Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695669608,
                "last": 1695669608,
                "now": 1695669608
            },
            "token": "IWZMIdOetD5alth7P2mrKWL9y7dqpBAW"
        },
        "registry": {
            "current_theme": "green",
            "current_direction": "ltr",
            "current_key_sufix": "_green_ltr"
        },
        "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
        },
        "application": {
            "queue": null
        },
        "btl-s": {
            "facebook": "fb",
            "google": "gg",
            "twitter": "tt"
        }
    }
}

Profile Information

Time

Memory

Time: 38.89 ms / 38.89 ms Memory: 0.549 MB / 0.93 MB Application: afterLoad

Time: 144.93 ms / 183.82 ms Memory: 4.824 MB / 5.75 MB Application: afterInitialise

Time: 72.48 ms / 256.30 ms Memory: 1.470 MB / 7.22 MB Application: afterRoute

Time: 0.95 ms / 257.25 ms Memory: 0.034 MB / 7.25 MB Application: beforeRenderComponent com_content

Time: 58.10 ms / 315.35 ms Memory: 0.966 MB / 8.22 MB Application: Start JAccess::getAssetRules Old (1)

Time: 2.52 ms / 317.87 ms Memory: 0.034 MB / 8.25 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.04 ms / 317.91 ms Memory: 0.000 MB / 8.25 MB Application: New JAccess Preloading Process(com_content.category)

Time: 0.73 ms / 318.64 ms Memory: 0.065 MB / 8.31 MB Application: After preloadPermissionsParentIdMapping (com_content.category)

Time: 2.63 ms / 321.27 ms Memory: 0.100 MB / 8.41 MB Application: After preloadPermissions (com_content.category)

Time: 0.01 ms / 321.29 ms Memory: 0.001 MB / 8.41 MB Application: End New JAccess Preloading Process(com_content.category)

Time: 0.02 ms / 321.30 ms Memory: 0.001 MB / 8.42 MB Application: Start JAccess::getAssetRules New (com_content.category.9)

Time: 0.07 ms / 321.37 ms Memory: 0.007 MB / 8.42 MB Application: Finish JAccess::getAssetRules New (com_content.category.9)

Time: 25.54 ms / 346.91 ms Memory: 0.273 MB / 8.70 MB Application: Start JAccess::preload(components)

Time: 2.31 ms / 349.22 ms Memory: 0.209 MB / 8.91 MB Application: Finish JAccess::preload(components)

Time: 206.90 ms / 556.12 ms Memory: 0.997 MB / 9.90 MB Application: afterRenderComponent com_content

Time: 16.29 ms / 572.42 ms Memory: 0.086 MB / 9.99 MB Application: afterDispatch

Time: 79.28 ms / 651.70 ms Memory: 2.456 MB / 12.44 MB Application: beforeRenderModule mod_footer (Footer)

Time: 4.34 ms / 656.04 ms Memory: 0.050 MB / 12.49 MB Application: afterRenderModule mod_footer (Footer)

Time: 0.07 ms / 656.11 ms Memory: 0.003 MB / 12.50 MB Application: beforeRenderModule mod_acymailing (Email Newsletter)

Time: 13.83 ms / 669.94 ms Memory: 0.587 MB / 13.08 MB Application: afterRenderModule mod_acymailing (Email Newsletter)

Time: 0.03 ms / 669.97 ms Memory: 0.000 MB / 13.07 MB Application: beforeRenderModule mod_custom (Social footer)

Time: 2.07 ms / 672.05 ms Memory: 0.005 MB / 13.07 MB Application: afterRenderModule mod_custom (Social footer)

Time: 0.05 ms / 672.10 ms Memory: 0.002 MB / 13.08 MB Application: beforeRenderModule mod_custom (OUR OFFERS)

Time: 0.36 ms / 672.46 ms Memory: 0.003 MB / 13.08 MB Application: afterRenderModule mod_custom (OUR OFFERS)

Time: 0.03 ms / 672.49 ms Memory: 0.000 MB / 13.08 MB Application: beforeRenderModule mod_custom (OUR OFFERS F)

Time: 0.34 ms / 672.82 ms Memory: 0.003 MB / 13.08 MB Application: afterRenderModule mod_custom (OUR OFFERS F)

Time: 0.05 ms / 672.87 ms Memory: 0.000 MB / 13.08 MB Application: beforeRenderModule mod_custom (MEDICAL DEPARTMENTS)

Time: 0.34 ms / 673.22 ms Memory: 0.003 MB / 13.08 MB Application: afterRenderModule mod_custom (MEDICAL DEPARTMENTS)

Time: 0.02 ms / 673.24 ms Memory: 0.000 MB / 13.08 MB Application: beforeRenderModule mod_custom (MEDICAL DEPARTMENTS F2)

Time: 0.32 ms / 673.56 ms Memory: 0.003 MB / 13.09 MB Application: afterRenderModule mod_custom (MEDICAL DEPARTMENTS F2)

Time: 0.04 ms / 673.60 ms Memory: 0.000 MB / 13.09 MB Application: beforeRenderModule mod_custom (Principles of the hospital)

Time: 0.32 ms / 673.92 ms Memory: 0.003 MB / 13.09 MB Application: afterRenderModule mod_custom (Principles of the hospital)

Time: 0.06 ms / 673.98 ms Memory: 0.003 MB / 13.09 MB Application: beforeRenderModule mod_bt_sociallogin (BT Social Login)

Time: 45.19 ms / 719.17 ms Memory: 1.202 MB / 14.30 MB Application: afterRenderModule mod_bt_sociallogin (BT Social Login)

Time: 0.06 ms / 719.23 ms Memory: 0.000 MB / 14.28 MB Application: beforeRenderModule mod_search (Search)

Time: 2.71 ms / 721.94 ms Memory: 0.012 MB / 14.29 MB Application: afterRenderModule mod_search (Search)

Time: 0.06 ms / 722.00 ms Memory: 0.000 MB / 14.29 MB Application: beforeRenderModule mod_menu (Main menu reponsive)

Time: 13.59 ms / 735.59 ms Memory: 0.117 MB / 14.40 MB Application: afterRenderModule mod_menu (Main menu reponsive)

Time: 0.05 ms / 735.64 ms Memory: 0.000 MB / 14.40 MB Application: beforeRenderModule mod_languages (Language Switcher)

Time: 8.42 ms / 744.06 ms Memory: 0.149 MB / 14.55 MB Application: afterRenderModule mod_languages (Language Switcher)

Time: 0.03 ms / 744.09 ms Memory: 0.000 MB / 14.55 MB Application: beforeRenderModule mod_custom (Top head right)

Time: 0.40 ms / 744.48 ms Memory: 0.003 MB / 14.55 MB Application: afterRenderModule mod_custom (Top head right)

Time: 0.06 ms / 744.54 ms Memory: 0.001 MB / 14.55 MB Application: beforeRenderModule mod_custom (Top head)

Time: 0.37 ms / 744.91 ms Memory: 0.003 MB / 14.55 MB Application: afterRenderModule mod_custom (Top head)

Time: 10.18 ms / 755.09 ms Memory: 0.263 MB / 14.82 MB Application: afterRender

Database queries total: 180.16 ms

EXPLAIN not possible on query: 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 h_menu AS m LEFT JOIN h_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

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:100
16	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
14	JFalangDatabase->loadObjectList()	JROOT\libraries\cms\menu\site.php:86
13	JMenuSite->load()	JROOT\libraries\cms\menu\menu.php:74
12	JMenu->__construct()	JROOT\libraries\cms\menu\site.php:57
11	JMenuSite->__construct()	JROOT\plugins\system\falangdriver\falangdriver.php:264
10	plgSystemFalangdriver->parseRule()	JROOT\libraries\cms\router\router.php:596
9	JRouter->processParseRules()	JROOT\libraries\cms\router\site.php:561
8	JRouterSite->processParseRules()	JROOT\libraries\cms\router\router.php:570
7	JRouter->_processParseRules()	JROOT\libraries\cms\router\router.php:224
6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.14 ms After last query: 3.54 ms Query memory: 0.026 MB Memory before query: 6.269 MB Rows returned: 7

SELECT joomlatablename,tablepkID 
  FROM `h_falang_tableinfo`

Explain

EXPLAIN not possible on query: SELECT joomlatablename,tablepkID FROM `h_falang_tableinfo`

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
21	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
19	JFalangDatabase->loadObjectList()	JROOT\administrator\components\com_falang\classes\FalangManager.class.php:147
18	FalangManager->_loadPrimaryKeyData()	JROOT\administrator\components\com_falang\classes\FalangManager.class.php:60
17	FalangManager->__construct()	JROOT\administrator\components\com_falang\classes\FalangManager.class.php:88
16	FalangManager::getInstance()	JROOT\components\com_falang\helpers\falang.class.php:52
15	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
14	JFalangDatabase->loadObjectList()	JROOT\libraries\cms\menu\site.php:86
13	JMenuSite->load()	JROOT\libraries\cms\menu\menu.php:74
12	JMenu->__construct()	JROOT\libraries\cms\menu\site.php:57
11	JMenuSite->__construct()	JROOT\plugins\system\falangdriver\falangdriver.php:264
10	plgSystemFalangdriver->parseRule()	JROOT\libraries\cms\router\router.php:596
9	JRouter->processParseRules()	JROOT\libraries\cms\router\site.php:561
8	JRouterSite->processParseRules()	JROOT\libraries\cms\router\router.php:570
7	JRouter->_processParseRules()	JROOT\libraries\cms\router\router.php:224
6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.14 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 6.279 MB Rows returned: 2

SELECT * 
  FROM h_languages 
  ORDER BY ordering

Explain

EXPLAIN not possible on query: SELECT * FROM h_languages ORDER BY ordering

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
21	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
19	JFalangDatabase->loadObjectList()	JROOT\administrator\components\com_falang\classes\FalangManager.class.php:322
18	FalangManager->getLanguages()	JROOT\administrator\components\com_falang\classes\FalangManager.class.php:66
17	FalangManager->__construct()	JROOT\administrator\components\com_falang\classes\FalangManager.class.php:88
16	FalangManager::getInstance()	JROOT\components\com_falang\helpers\falang.class.php:52
15	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
14	JFalangDatabase->loadObjectList()	JROOT\libraries\cms\menu\site.php:86
13	JMenuSite->load()	JROOT\libraries\cms\menu\menu.php:74
12	JMenu->__construct()	JROOT\libraries\cms\menu\site.php:57
11	JMenuSite->__construct()	JROOT\plugins\system\falangdriver\falangdriver.php:264
10	plgSystemFalangdriver->parseRule()	JROOT\libraries\cms\router\router.php:596
9	JRouter->processParseRules()	JROOT\libraries\cms\router\site.php:561
8	JRouterSite->processParseRules()	JROOT\libraries\cms\router\router.php:570
7	JRouter->_processParseRules()	JROOT\libraries\cms\router\router.php:224
6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 10.72 ms After last query: 4.03 ms Query memory: 0.029 MB Memory before query: 6.501 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `h_languages`

Explain

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

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
21	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
20	JTable->__construct()	JROOT\administrator\components\com_falang\tables\JFLanguage.php:77
19	TableJFLanguage->__construct()	JROOT\administrator\components\com_falang\classes\FalangManager.class.php:328
18	FalangManager->getLanguages()	JROOT\administrator\components\com_falang\classes\FalangManager.class.php:66
17	FalangManager->__construct()	JROOT\administrator\components\com_falang\classes\FalangManager.class.php:88
16	FalangManager::getInstance()	JROOT\components\com_falang\helpers\falang.class.php:52
15	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
14	JFalangDatabase->loadObjectList()	JROOT\libraries\cms\menu\site.php:86
13	JMenuSite->load()	JROOT\libraries\cms\menu\menu.php:74
12	JMenu->__construct()	JROOT\libraries\cms\menu\site.php:57
11	JMenuSite->__construct()	JROOT\plugins\system\falangdriver\falangdriver.php:264
10	plgSystemFalangdriver->parseRule()	JROOT\libraries\cms\router\router.php:596
9	JRouter->processParseRules()	JROOT\libraries\cms\router\site.php:561
8	JRouterSite->processParseRules()	JROOT\libraries\cms\router\router.php:570
7	JRouter->_processParseRules()	JROOT\libraries\cms\router\router.php:224
6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 4.25 ms After last query: 2.84 ms Query memory: 0.025 MB Memory before query: 6.556 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(198,171,168,199,169,170,172,173,210,205,203,204,208,209,102,104,105,103,106,107,101,128,129,227,196,197,200,132,134,201,221,225,224,202,130,207,161,162,163,135,193,143,144,145,140,152,153,150,164,165,166,175,176,177,178,179,180,181,182,183,184,185,186,131)
   
  AND falang_content.reference_table='menu'

Explain

EXPLAIN not possible on query: SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM h_falang_content AS falang_content WHERE falang_content.language_id=1 AND falang_content.published=1 AND falang_content.reference_id IN(198,171,168,199,169,170,172,173,210,205,203,204,208,209,102,104,105,103,106,107,101,128,129,227,196,197,200,132,134,201,221,225,224,202,130,207,161,162,163,135,193,143,144,145,140,152,153,150,164,165,166,175,176,177,178,179,180,181,182,183,184,185,186,131) AND falang_content.reference_table='menu'

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:100
19	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
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:332
14	JFalangDatabase->loadObjectList()	JROOT\libraries\cms\menu\site.php:86
13	JMenuSite->load()	JROOT\libraries\cms\menu\menu.php:74
12	JMenu->__construct()	JROOT\libraries\cms\menu\site.php:57
11	JMenuSite->__construct()	JROOT\plugins\system\falangdriver\falangdriver.php:264
10	plgSystemFalangdriver->parseRule()	JROOT\libraries\cms\router\router.php:596
9	JRouter->processParseRules()	JROOT\libraries\cms\router\site.php:561
8	JRouterSite->processParseRules()	JROOT\libraries\cms\router\router.php:570
7	JRouter->_processParseRules()	JROOT\libraries\cms\router\router.php:224
6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.37 ms After last query: 3.75 ms Query memory: 0.022 MB Memory before query: 6.466 MB Rows returned: 7

SELECT id, home, template, s.params

  FROM h_template_styles as s

  LEFT JOIN h_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

EXPLAIN not possible on query: SELECT id, home, template, s.params FROM h_template_styles as s LEFT JOIN h_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

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:100
13	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
11	JFalangDatabase->loadObjectList()	JROOT\libraries\cms\application\site.php:484
10	JApplicationSite->getTemplate()	JROOT\plugins\system\t3\includes\core\t3.php:307
9	T3::detect()	JROOT\plugins\system\t3\t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT\libraries\joomla\event\event.php:69
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1125
4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.28 ms After last query: 13.64 ms Query memory: 0.025 MB Memory before query: 6.694 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `h_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `h_extensions` WHERE `type` = 'library' AND `element` = 'joomla'

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
19	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
17	JFalangDatabase->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:414
16	JFalangDatabase->loadObject()	JROOT\libraries\joomla\cache\controller\callback.php:152
15	JCacheControllerCallback->get()	JROOT\libraries\cms\library\helper.php:156
14	JLibraryHelper::_load()	JROOT\libraries\cms\library\helper.php:47
13	JLibraryHelper::getLibrary()	JROOT\libraries\cms\library\helper.php:90
12	JLibraryHelper::getParams()	JROOT\libraries\cms\version\version.php:274
11	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:755
10	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
9	JFactory::getDocument()	JROOT\plugins\system\k2\k2.php:52
8	plgSystemK2->onAfterRoute()	JROOT\libraries\joomla\event\event.php:69
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1125
4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.48 ms After last query: 0.24 ms Query memory: 0.006 MB Memory before query: 6.687 MB

UPDATE `h_extensions`

  SET `params` = '{\"mediaversion\":\"b9d1b75ccb1b461570a70c3db7c1359a\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
14	JFalangDatabase->execute()	JROOT\libraries\cms\library\helper.php:119
13	JLibraryHelper::saveParams()	JROOT\libraries\cms\version\version.php:325
12	JVersion->setMediaVersion()	JROOT\libraries\cms\version\version.php:284
11	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:755
10	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
9	JFactory::getDocument()	JROOT\plugins\system\k2\k2.php:52
8	plgSystemK2->onAfterRoute()	JROOT\libraries\joomla\event\event.php:69
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1125
4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 10.99 ms After last query: 58.27 ms Query memory: 0.029 MB Memory before query: 8.187 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `h_assets`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
21	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
20	JTable->__construct()	JROOT\libraries\joomla\table\asset.php:60
19	JTableAsset->__construct()	JROOT\libraries\joomla\table\table.php:308
18	JTable::getInstance()	JROOT\libraries\joomla\access\access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:555
16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
15	JUser->authorise()	JROOT\components\com_content\models\category.php:142
14	ContentModelCategory->populateState()	JROOT\libraries\legacy\model\legacy.php:435
13	JModelLegacy->getState()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.22 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 8.211 MB Rows returned: 1

SELECT *

  FROM h_assets

  WHERE `id` = '1'

Explain

EXPLAIN not possible on query: SELECT * FROM h_assets WHERE `id` = '1'

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
24	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
22	JFalangDatabase->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:414
21	JFalangDatabase->loadObject()	JROOT\plugins\system\falangdriver\falang_database.php:349
20	JFalangDatabase->_loadObject()	JROOT\plugins\system\falangdriver\falang_database.php:432
19	JFalangDatabase->loadAssoc()	JROOT\libraries\joomla\table\table.php:719
18	JTable->load()	JROOT\libraries\joomla\access\access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:555
16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
15	JUser->authorise()	JROOT\components\com_content\models\category.php:142
14	ContentModelCategory->populateState()	JROOT\libraries\legacy\model\legacy.php:435
13	JModelLegacy->getState()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.35 ms After last query: 0.24 ms Query memory: 0.025 MB Memory before query: 8.221 MB Rows returned: 1

SELECT a.rules

  FROM h_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

EXPLAIN not possible on query: SELECT a.rules FROM h_assets AS a WHERE (a.id = 1 OR a.name = 'root.1')

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
20	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
18	JFalangDatabase->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:176
17	JFalangDatabase->loadColumn()	JROOT\libraries\joomla\access\access.php:652
16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
15	JUser->authorise()	JROOT\components\com_content\models\category.php:142
14	ContentModelCategory->populateState()	JROOT\libraries\legacy\model\legacy.php:435
13	JModelLegacy->getState()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.49 ms After last query: 2.21 ms Query memory: 0.031 MB Memory before query: 8.250 MB Rows returned: 101

SELECT a.id, a.parent_id

  FROM h_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

Explain

EXPLAIN not possible on query: SELECT a.id, a.parent_id FROM h_assets AS a WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
21	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
19	JFalangDatabase->loadObjectList()	JROOT\libraries\joomla\access\access.php:332
18	JAccess::preloadPermissionsParentIdMapping()	JROOT\libraries\joomla\access\access.php:240
17	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
16	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
15	JUser->authorise()	JROOT\components\com_content\models\category.php:142
14	ContentModelCategory->populateState()	JROOT\libraries\legacy\model\legacy.php:435
13	JModelLegacy->getState()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.46 ms After last query: 2.09 ms Query memory: 0.035 MB Memory before query: 8.326 MB Rows returned: 101

SELECT a.id, a.name, a.rules

  FROM h_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

Explain

EXPLAIN not possible on query: SELECT a.id, a.name, a.rules FROM h_assets AS a WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
20	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1255
19	JDatabaseDriver->getIterator()	JROOT\libraries\joomla\access\access.php:373
18	JAccess::preloadPermissions()	JROOT\libraries\joomla\access\access.php:243
17	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
16	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
15	JUser->authorise()	JROOT\components\com_content\models\category.php:142
14	ContentModelCategory->populateState()	JROOT\libraries\legacy\model\legacy.php:435
13	JModelLegacy->getState()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 17.32 ms After last query: 3.18 ms Query memory: 0.033 MB Memory before query: 8.484 MB Rows returned: 17

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

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  LEFT JOIN `h_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1 
  AND (i.language = '*' OR i.language = 'en-GB')

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=9

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
18	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
16	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
15	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
14	JCategories->get()	JROOT\components\com_content\models\category.php:354
13	ContentModelCategory->getCategory()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 1.37 ms After last query: 0.46 ms Query memory: 0.026 MB Memory before query: 8.548 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,13,14,15,16,18,19,20,21,22,23,24,25,26,27,28)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
21	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
19	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
18	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
17	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
16	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
15	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
14	JCategories->get()	JROOT\components\com_content\models\category.php:354
13	ContentModelCategory->getCategory()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.42 ms After last query: 3.62 ms Query memory: 0.028 MB Memory before query: 8.698 MB Rows returned: 35

SELECT element

  FROM h_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

EXPLAIN not possible on query: SELECT element FROM h_extensions WHERE type = 'component' AND enabled = '1'

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:176
22	JFalangDatabase->loadColumn()	JROOT\libraries\joomla\access\access.php:413
21	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
20	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
19	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
18	JUser->authorise()	JROOT\components\com_content\models\articles.php:466
17	ContentModelArticles->getListQuery()	JROOT\libraries\legacy\model\list.php:129
16	JModelList->_getListQuery()	JROOT\libraries\legacy\model\list.php:183
15	JModelList->getItems()	JROOT\components\com_content\models\articles.php:565
14	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
13	ContentModelCategory->getItems()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.65 ms After last query: 0.23 ms Query memory: 0.030 MB Memory before query: 8.702 MB Rows returned: 35

SELECT a.name, a.rules

  FROM h_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_falang','com_finder','com_installer','com_joomlaupdate','com_jssupportticket','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

Explain

EXPLAIN not possible on query: SELECT a.name, a.rules FROM h_assets AS a WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_falang','com_finder','com_installer','com_joomlaupdate','com_jssupportticket','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:457
22	JFalangDatabase->loadAssocList()	JROOT\libraries\joomla\access\access.php:441
21	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
20	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
19	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
18	JUser->authorise()	JROOT\components\com_content\models\articles.php:466
17	ContentModelArticles->getListQuery()	JROOT\libraries\legacy\model\list.php:129
16	JModelList->_getListQuery()	JROOT\libraries\legacy\model\list.php:183
15	JModelList->getItems()	JROOT\components\com_content\models\articles.php:565
14	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
13	ContentModelCategory->getItems()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.90 ms After last query: 1.04 ms Query memory: 0.026 MB Memory before query: 8.904 MB Rows returned: 0

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM h_content AS a

  LEFT JOIN h_categories AS c 
  ON c.id = a.catid

  LEFT JOIN h_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN h_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN h_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN h_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 9 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 19:20:08') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 19:20:08') 
  AND a.language in ('en-GB','*')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END ,  a.created   
  LIMIT 10

Explain

EXPLAIN not possible on query: SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM h_content AS a LEFT JOIN h_categories AS c ON c.id = a.catid LEFT JOIN h_users AS ua ON ua.id = a.created_by LEFT JOIN h_users AS uam ON uam.id = a.modified_by LEFT JOIN h_categories as parent ON parent.id = c.parent_id LEFT JOIN h_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid = 9 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 19:20:08') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 19:20:08') AND a.language in ('en-GB','*') ORDER BY c.lft, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END , a.created LIMIT 10

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:100
19	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
17	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\model\legacy.php:310
16	JModelLegacy->_getList()	JROOT\libraries\legacy\model\list.php:183
15	JModelList->getItems()	JROOT\components\com_content\models\articles.php:565
14	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
13	ContentModelCategory->getItems()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.61 ms After last query: 2.38 ms Query memory: 0.026 MB Memory before query: 9.028 MB Rows returned: 1

SELECT COUNT(*)

  FROM h_content AS a

  LEFT JOIN h_categories AS c 
  ON c.id = a.catid

  LEFT JOIN h_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN h_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN h_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN h_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 9 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 19:20:08') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 19:20:08') 
  AND a.language in ('en-GB','*')

Explain

EXPLAIN not possible on query: SELECT COUNT(*) FROM h_content AS a LEFT JOIN h_categories AS c ON c.id = a.catid LEFT JOIN h_users AS ua ON ua.id = a.created_by LEFT JOIN h_users AS uam ON uam.id = a.modified_by LEFT JOIN h_categories as parent ON parent.id = c.parent_id LEFT JOIN h_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid = 9 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 19:20:08') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 19:20:08') AND a.language in ('en-GB','*')

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:100
22	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
20	JFalangDatabase->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:414
19	JFalangDatabase->loadObject()	JROOT\plugins\system\falangdriver\falang_database.php:349
18	JFalangDatabase->_loadObject()	JROOT\plugins\system\falangdriver\falang_database.php:140
17	JFalangDatabase->loadResult()	JROOT\libraries\legacy\model\legacy.php:337
16	JModelLegacy->_getListCount()	JROOT\libraries\legacy\model\list.php:278
15	JModelList->getTotal()	JROOT\libraries\legacy\model\list.php:228
14	JModelList->getPagination()	JROOT\components\com_content\models\category.php:265
13	ContentModelCategory->getItems()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.34 ms After last query: 3.51 ms Query memory: 0.023 MB Memory before query: 9.124 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `h_contentitem_tag_map` AS m 

  INNER JOIN `h_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 9 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

EXPLAIN not possible on query: SELECT `m`.`tag_id`,`t`.* FROM `h_contentitem_tag_map` AS m INNER JOIN `h_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.category' AND `m`.`content_item_id` = 9 AND `t`.`published` = 1 AND t.access IN (1,1,5)

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
15	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
13	JFalangDatabase->loadObjectList()	JROOT\libraries\cms\helper\tags.php:435
12	JHelperTags->getItemTags()	JROOT\libraries\legacy\view\category.php:217
11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 9.93 ms After last query: 66.66 ms Query memory: 0.030 MB Memory before query: 9.509 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=13

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=13 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.47 ms After last query: 0.34 ms Query memory: 0.029 MB Memory before query: 9.546 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,13)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 8.81 ms After last query: 0.41 ms Query memory: 0.030 MB Memory before query: 9.568 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=14

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=14 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.46 ms After last query: 0.37 ms Query memory: 0.029 MB Memory before query: 9.589 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,14)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 8.16 ms After last query: 0.31 ms Query memory: 0.030 MB Memory before query: 9.601 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=15

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=15 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.47 ms After last query: 0.38 ms Query memory: 0.029 MB Memory before query: 9.622 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,15)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 8.19 ms After last query: 0.37 ms Query memory: 0.030 MB Memory before query: 9.633 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=16

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=16 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.46 ms After last query: 0.33 ms Query memory: 0.029 MB Memory before query: 9.655 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,16)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 8.76 ms After last query: 0.36 ms Query memory: 0.030 MB Memory before query: 9.666 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=18

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=18 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.47 ms After last query: 0.37 ms Query memory: 0.029 MB Memory before query: 9.688 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,18)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 8.39 ms After last query: 0.30 ms Query memory: 0.030 MB Memory before query: 9.699 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=19

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=19 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.47 ms After last query: 0.36 ms Query memory: 0.029 MB Memory before query: 9.720 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,19)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 8.12 ms After last query: 0.30 ms Query memory: 0.031 MB Memory before query: 9.738 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=20

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=20 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.45 ms After last query: 0.29 ms Query memory: 0.029 MB Memory before query: 9.761 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,20)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 8.19 ms After last query: 0.34 ms Query memory: 0.030 MB Memory before query: 9.773 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=21

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=21 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.45 ms After last query: 0.36 ms Query memory: 0.029 MB Memory before query: 9.794 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,21)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 8.21 ms After last query: 0.34 ms Query memory: 0.030 MB Memory before query: 9.806 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=22

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=22 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.42 ms After last query: 0.36 ms Query memory: 0.029 MB Memory before query: 9.827 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,22)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 7.89 ms After last query: 0.30 ms Query memory: 0.030 MB Memory before query: 9.839 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=24

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=24 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.42 ms After last query: 0.35 ms Query memory: 0.029 MB Memory before query: 9.860 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,24)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 8.24 ms After last query: 0.33 ms Query memory: 0.030 MB Memory before query: 9.872 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=25

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=25 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.39 ms After last query: 0.36 ms Query memory: 0.029 MB Memory before query: 9.893 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,25)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 7.82 ms After last query: 0.29 ms Query memory: 0.030 MB Memory before query: 9.904 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=26

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=26 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.37 ms After last query: 0.35 ms Query memory: 0.029 MB Memory before query: 9.926 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,26)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 8.51 ms After last query: 0.29 ms Query memory: 0.030 MB Memory before query: 9.937 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=27

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=27 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.43 ms After last query: 0.28 ms Query memory: 0.029 MB Memory before query: 9.959 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,27)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 7.72 ms After last query: 0.33 ms Query memory: 0.030 MB Memory before query: 9.970 MB Rows returned: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM h_categories AS cat JOIN h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=28

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

EXPLAIN not possible on query: 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 h_categories as c LEFT JOIN (SELECT cat.id as id FROM h_categories AS cat JOIN h_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN h_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id=28 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

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:100
25	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.43 ms After last query: 0.28 ms Query memory: 0.029 MB Memory before query: 9.991 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,9,28)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
28	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
26	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
25	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
24	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
23	JFalangDatabase->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\helpers\route.php:88
20	ContentHelperRoute::getCategoryRoute()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php:44
19	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default_children.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
18	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php:62
17	include JROOT\plugins\system\t3\base-bs3\html\layouts\joomla\content\category_default.php	JROOT\plugins\system\t3\includes\joomla25\layout\file.php:97
16	JLayoutFile->render()	JROOT\libraries\cms\layout\helper.php:72
15	JLayoutHelper::render()	JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php:20
14	include JROOT\plugins\system\t3\base-bs3\html\com_content\category\default.php	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:207
12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.26 ms After last query: 0.40 ms Query memory: 0.021 MB Memory before query: 9.907 MB Rows returned: 3

SELECT language,id

  FROM `h_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

EXPLAIN not possible on query: SELECT language,id FROM `h_menu` WHERE home = 1 AND published = 1 AND client_id = 0

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:100
11	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
9	JFalangDatabase->loadObjectList()	JROOT\libraries\cms\language\multilang.php:121
8	JLanguageMultilang::getSiteHomePages()	JROOT\plugins\system\languagefilter\languagefilter.php:697
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.44 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 9.903 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(101,165,166)
   
  AND falang_content.reference_table='menu'

Explain

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:100
14	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
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:332
9	JFalangDatabase->loadObjectList()	JROOT\libraries\cms\language\multilang.php:121
8	JLanguageMultilang::getSiteHomePages()	JROOT\plugins\system\languagefilter\languagefilter.php:697
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.23 ms After last query: 2.51 ms Query memory: 0.021 MB Memory before query: 9.950 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `h_menu` AS `c`

  INNER JOIN `h_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `h_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `h_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 131

Explain

EXPLAIN not possible on query: SELECT `c2`.`language`,`c2`.`id` FROM `h_menu` AS `c` INNER JOIN `h_associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item' INNER JOIN `h_associations` AS `a2` ON a.key = a2.key INNER JOIN `h_menu` AS `c2` ON a2.id = c2.`id` WHERE c.id = 131

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
12	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
10	JFalangDatabase->loadObjectList()	JROOT\libraries\cms\language\associations.php:101
9	JLanguageAssociations::getAssociations()	JROOT\administrator\components\com_menus\helpers\menus.php:284
8	MenusHelper::getAssociations()	JROOT\plugins\system\languagefilter\languagefilter.php:714
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.33 ms After last query: 9.85 ms Query memory: 0.022 MB Memory before query: 9.977 MB Rows returned: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`

  FROM `h_categories` AS `c`

  INNER JOIN `h_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_categories.item'

  INNER JOIN `h_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `h_categories` AS `c2` 
  ON a2.id = c2.`id` 
  AND c2.extension = 'com_content'

  WHERE c.id = 9 
  AND c.extension = 'com_content'

Explain

EXPLAIN not possible on query: SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` FROM `h_categories` AS `c` INNER JOIN `h_associations` AS `a` ON a.id = c.`id` AND a.context='com_categories.item' INNER JOIN `h_associations` AS `a2` ON a.key = a2.key INNER JOIN `h_categories` AS `c2` ON a2.id = c2.`id` AND c2.extension = 'com_content' WHERE c.id = 9 AND c.extension = 'com_content'

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

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

Query Time: 1.59 ms After last query: 54.30 ms Query memory: 0.190 MB Memory before query: 11.635 MB Rows returned: 53

SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM h_modules AS m

  LEFT JOIN h_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN h_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 <= '2023-09-25 19:20:08') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-25 19:20:08') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 131 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

EXPLAIN not possible on query: SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM h_modules AS m LEFT JOIN h_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN h_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 <= '2023-09-25 19:20:08') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-25 19:20:08') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 131 OR mm.menuid <= 0) AND m.language IN ('en-GB','*') ORDER BY m.position, m.ordering

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
18	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
16	JFalangDatabase->loadObjectList()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:423
15	JModuleHelper::_load()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:102
14	JModuleHelper::getModules()	JROOT\libraries\joomla\document\html.php:514
13	JDocumentHtml->countModules()	JROOT\plugins\system\t3\includes\core\template.php:608
12	T3Template->countModules()	JROOT\templates\bt_medical\tpls\blocks\header.php:36
11	include JROOT\templates\bt_medical\tpls\blocks\header.php	JROOT\plugins\system\t3\includes\core\template.php:176
10	T3Template->loadBlock()	JROOT\templates\bt_medical\tpls\default.php:42
9	include JROOT\templates\bt_medical\tpls\default.php	JROOT\plugins\system\t3\includes\core\template.php:200
8	T3Template->loadLayout()	JROOT\templates\bt_medical\index.php:34
7	require JROOT\templates\bt_medical\index.php	JROOT\libraries\joomla\document\html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT\libraries\joomla\document\html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT\libraries\joomla\document\html.php:455
4	JDocumentHtml->parse()	JROOT\libraries\cms\application\cms.php:1072
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 2.62 ms After last query: 0.35 ms Query memory: 0.026 MB Memory before query: 11.898 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(119,145,146,147,148,149,150,151,162,165,168,172,173,174,130,111,112,170,113,171,107,114,99,93,123,128,116,129,134,135,136,137,138,139,140,141,142,143,144,163,164,167,127,117,131,118)
   
  AND falang_content.reference_table='modules'

Explain

EXPLAIN not possible on query: SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value FROM h_falang_content AS falang_content WHERE falang_content.language_id=1 AND falang_content.published=1 AND falang_content.reference_id IN(119,145,146,147,148,149,150,151,162,165,168,172,173,174,130,111,112,170,113,171,107,114,99,93,123,128,116,129,134,135,136,137,138,139,140,141,142,143,144,163,164,167,127,117,131,118) AND falang_content.reference_table='modules'

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
21	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:276
19	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
18	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
17	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
16	JFalangDatabase->loadObjectList()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:423
15	JModuleHelper::_load()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:102
14	JModuleHelper::getModules()	JROOT\libraries\joomla\document\html.php:514
13	JDocumentHtml->countModules()	JROOT\plugins\system\t3\includes\core\template.php:608
12	T3Template->countModules()	JROOT\templates\bt_medical\tpls\blocks\header.php:36
11	include JROOT\templates\bt_medical\tpls\blocks\header.php	JROOT\plugins\system\t3\includes\core\template.php:176
10	T3Template->loadBlock()	JROOT\templates\bt_medical\tpls\default.php:42
9	include JROOT\templates\bt_medical\tpls\default.php	JROOT\plugins\system\t3\includes\core\template.php:200
8	T3Template->loadLayout()	JROOT\templates\bt_medical\index.php:34
7	require JROOT\templates\bt_medical\index.php	JROOT\libraries\joomla\document\html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT\libraries\joomla\document\html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT\libraries\joomla\document\html.php:455
4	JDocumentHtml->parse()	JROOT\libraries\cms\application\cms.php:1072
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.25 ms After last query: 34.18 ms Query memory: 0.028 MB Memory before query: 12.882 MB Rows returned: 79

SELECT * 
  FROM h_acymailing_config

Explain

EXPLAIN not possible on query: SELECT * FROM h_acymailing_config

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:100
16	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
14	JFalangDatabase->loadObjectList()	JROOT\administrator\components\com_acymailing\classes\cpanel.php:17
13	cpanelClass->load()	JROOT\administrator\components\com_acymailing\helpers\helper.php:402
12	acymailing_config()	JROOT\administrator\components\com_acymailing\helpers\helper.php:862
11	include_once JROOT\administrator\components\com_acymailing\helpers\helper.php	JROOT\modules\mod_acymailing\mod_acymailing.php:12
10	include JROOT\modules\mod_acymailing\mod_acymailing.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:411
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:477
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1086
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:50

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

Query Time: 0.21 ms After last query: 4.75 ms Query memory: 0.023 MB Memory before query: 13.121 MB Rows returned: 1

SELECT * 
  FROM h_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Explain

EXPLAIN not possible on query: SELECT * FROM h_acymailing_list WHERE type = 'list' ORDER BY ordering ASC

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:100
14	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
12	JFalangDatabase->loadObjectList()	JROOT\administrator\components\com_acymailing\classes\list.php:29
11	listClass->getLists()	JROOT\modules\mod_acymailing\mod_acymailing.php:121
10	include JROOT\modules\mod_acymailing\mod_acymailing.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:411
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:477
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1086
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:50

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

26 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

18 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value  
  FROM h_falang_content AS falang_content

14 × 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

Main Menu

Principles of the hospital

MEDICAL DEPARTMENTS

OUR OFFERS

Email Newsletter

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

57 Queries Logged 180.16 ms

26 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

Main Menu

Login to your account

Create an account

Subcategories

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

57 Queries Logged 180.16 ms

26 Query Types Logged, Sorted by Occurrences.

SELECT Tables: