Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695673377,
                "last": 1695673377,
                "now": 1695673377
            },
            "token": "uG71MCoRE134RMIJ4yBIbgtnVnIQHw6F"
        },
        "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: 13.85 ms / 13.85 ms Memory: 0.549 MB / 0.93 MB Application: afterLoad

Time: 81.68 ms / 95.53 ms Memory: 4.827 MB / 5.75 MB Application: afterInitialise

Time: 43.10 ms / 138.63 ms Memory: 1.470 MB / 7.22 MB Application: afterRoute

Time: 0.43 ms / 139.06 ms Memory: 0.034 MB / 7.26 MB Application: beforeRenderComponent com_content

Time: 13.88 ms / 152.95 ms Memory: 0.696 MB / 7.95 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.99 ms / 153.93 ms Memory: 0.033 MB / 7.99 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.03 ms / 153.96 ms Memory: 0.000 MB / 7.98 MB Application: Start JAccess::preload(components)

Time: 1.78 ms / 155.74 ms Memory: 0.209 MB / 8.19 MB Application: Finish JAccess::preload(components)

Time: 52.03 ms / 207.77 ms Memory: 1.377 MB / 9.57 MB Application: afterRenderComponent com_content

Time: 5.48 ms / 213.25 ms Memory: 0.175 MB / 9.74 MB Application: afterDispatch

Time: 38.35 ms / 251.60 ms Memory: 2.045 MB / 11.79 MB Application: beforeRenderModule mod_footer (Footer)

Time: 1.43 ms / 253.03 ms Memory: 0.048 MB / 11.83 MB Application: afterRenderModule mod_footer (Footer)

Time: 0.06 ms / 253.09 ms Memory: 0.003 MB / 11.84 MB Application: beforeRenderModule mod_acymailing (Email Newsletter)

Time: 8.00 ms / 261.09 ms Memory: 0.587 MB / 12.42 MB Application: afterRenderModule mod_acymailing (Email Newsletter)

Time: 0.03 ms / 261.12 ms Memory: 0.000 MB / 12.41 MB Application: beforeRenderModule mod_custom (Social footer)

Time: 0.69 ms / 261.82 ms Memory: 0.005 MB / 12.42 MB Application: afterRenderModule mod_custom (Social footer)

Time: 0.05 ms / 261.87 ms Memory: 0.002 MB / 12.42 MB Application: beforeRenderModule mod_custom (OUR OFFERS)

Time: 0.34 ms / 262.21 ms Memory: 0.005 MB / 12.42 MB Application: afterRenderModule mod_custom (OUR OFFERS)

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

Time: 0.32 ms / 262.55 ms Memory: 0.003 MB / 12.42 MB Application: afterRenderModule mod_custom (OUR OFFERS F)

Time: 0.05 ms / 262.60 ms Memory: 0.000 MB / 12.42 MB Application: beforeRenderModule mod_custom (MEDICAL DEPARTMENTS)

Time: 0.32 ms / 262.92 ms Memory: 0.003 MB / 12.43 MB Application: afterRenderModule mod_custom (MEDICAL DEPARTMENTS)

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

Time: 0.31 ms / 263.26 ms Memory: 0.003 MB / 12.43 MB Application: afterRenderModule mod_custom (MEDICAL DEPARTMENTS F2)

Time: 0.05 ms / 263.31 ms Memory: 0.000 MB / 12.43 MB Application: beforeRenderModule mod_custom (Principles of the hospital)

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

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

Time: 24.00 ms / 287.68 ms Memory: 0.937 MB / 13.37 MB Application: afterRenderModule mod_bt_sociallogin (BT Social Login)

Time: 0.06 ms / 287.74 ms Memory: 0.000 MB / 13.36 MB Application: beforeRenderModule mod_search (Search)

Time: 0.94 ms / 288.68 ms Memory: 0.012 MB / 13.37 MB Application: afterRenderModule mod_search (Search)

Time: 0.05 ms / 288.74 ms Memory: 0.000 MB / 13.37 MB Application: beforeRenderModule mod_menu (Main menu reponsive)

Time: 9.36 ms / 298.10 ms Memory: 0.179 MB / 13.54 MB Application: afterRenderModule mod_menu (Main menu reponsive)

Time: 0.05 ms / 298.15 ms Memory: 0.000 MB / 13.54 MB Application: beforeRenderModule mod_languages (Language Switcher)

Time: 3.84 ms / 301.99 ms Memory: 0.153 MB / 13.69 MB Application: afterRenderModule mod_languages (Language Switcher)

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

Time: 0.34 ms / 302.36 ms Memory: 0.003 MB / 13.69 MB Application: afterRenderModule mod_custom (Top head right)

Time: 0.05 ms / 302.41 ms Memory: 0.001 MB / 13.69 MB Application: beforeRenderModule mod_custom (Top head)

Time: 0.32 ms / 302.73 ms Memory: 0.003 MB / 13.70 MB Application: afterRenderModule mod_custom (Top head)

Time: 7.94 ms / 310.67 ms Memory: 0.256 MB / 13.95 MB Application: afterRender

Database queries total: 54.52 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.20 ms After last query: 1.72 ms Query memory: 0.026 MB Memory before query: 6.272 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.16 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 6.283 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: 9.70 ms After last query: 2.21 ms Query memory: 0.029 MB Memory before query: 6.504 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.17 ms After last query: 1.00 ms Query memory: 0.025 MB Memory before query: 6.559 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.36 ms After last query: 1.98 ms Query memory: 0.022 MB Memory before query: 6.469 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: 4.92 ms Query memory: 0.025 MB Memory before query: 6.697 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.40 ms After last query: 0.18 ms Query memory: 0.006 MB Memory before query: 6.690 MB

UPDATE `h_extensions`

  SET `params` = '{\"mediaversion\":\"54605b7f84dee70e9f7606e586b8fe5a\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `h_extensions` SET `params` = '{\"mediaversion\":\"54605b7f84dee70e9f7606e586b8fe5a\"}' 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: 9.08 ms After last query: 11.02 ms Query memory: 0.028 MB Memory before query: 7.922 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
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\libraries\joomla\database\driver\mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
18	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
17	JTable->__construct()	JROOT\libraries\joomla\table\asset.php:60
16	JTableAsset->__construct()	JROOT\libraries\joomla\table\table.php:308
15	JTable::getInstance()	JROOT\libraries\joomla\access\access.php:696
14	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:555
13	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:435
10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
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.18 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 7.945 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
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\plugins\system\falangdriver\falang_database.php:414
18	JFalangDatabase->loadObject()	JROOT\plugins\system\falangdriver\falang_database.php:349
17	JFalangDatabase->_loadObject()	JROOT\plugins\system\falangdriver\falang_database.php:432
16	JFalangDatabase->loadAssoc()	JROOT\libraries\joomla\table\table.php:719
15	JTable->load()	JROOT\libraries\joomla\access\access.php:697
14	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:555
13	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:435
10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
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.31 ms After last query: 0.13 ms Query memory: 0.024 MB Memory before query: 7.954 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
18	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
17	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
15	JFalangDatabase->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:176
14	JFalangDatabase->loadColumn()	JROOT\libraries\joomla\access\access.php:652
13	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:435
10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
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.30 ms After last query: 0.71 ms Query memory: 0.026 MB Memory before query: 7.981 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
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:176
16	JFalangDatabase->loadColumn()	JROOT\libraries\joomla\access\access.php:413
15	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
14	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
13	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:435
10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
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.56 ms After last query: 0.15 ms Query memory: 0.027 MB Memory before query: 7.996 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
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:457
16	JFalangDatabase->loadAssocList()	JROOT\libraries\joomla\access\access.php:441
15	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
14	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
13	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:435
10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
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.09 ms After last query: 1.38 ms Query memory: 0.033 MB Memory before query: 8.218 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `h_content`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\falangdriver\falang_database.php:100
17	JFalangDatabase->execute()	JROOT\libraries\joomla\database\driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\falangdriver\falang_database.php:281
15	JFalangDatabase->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
13	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
12	JTable->__construct()	JROOT\libraries\legacy\table\content.php:31
11	JTableContent->__construct()	JROOT\libraries\joomla\table\table.php:308
10	JTable::getInstance()	JROOT\components\com_content\models\article.php:264
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
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.51 ms After last query: 2.65 ms Query memory: 0.025 MB Memory before query: 8.480 MB Rows returned: 1

SELECT *

  FROM h_content

  WHERE `id` = '60'

Explain

EXPLAIN not possible on query: SELECT * FROM h_content WHERE `id` = '60'

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\plugins\system\falangdriver\falang_database.php:414
13	JFalangDatabase->loadObject()	JROOT\plugins\system\falangdriver\falang_database.php:349
12	JFalangDatabase->_loadObject()	JROOT\plugins\system\falangdriver\falang_database.php:432
11	JFalangDatabase->loadAssoc()	JROOT\libraries\joomla\table\table.php:719
10	JTable->load()	JROOT\components\com_content\models\article.php:265
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
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.36 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 8.512 MB Rows returned: 0

Duplicate queries: #19

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(60)
   
  AND falang_content.reference_table='content'

Explain

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\plugins\system\falangdriver\falang_database.php:414
13	JFalangDatabase->loadObject()	JROOT\plugins\system\falangdriver\falang_database.php:349
12	JFalangDatabase->_loadObject()	JROOT\plugins\system\falangdriver\falang_database.php:432
11	JFalangDatabase->loadAssoc()	JROOT\libraries\joomla\table\table.php:719
10	JTable->load()	JROOT\components\com_content\models\article.php:265
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
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.48 ms After last query: 0.11 ms Query memory: 0.006 MB Memory before query: 8.519 MB

UPDATE h_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '60'

Explain

EXPLAIN not possible on query: UPDATE h_content SET `hits` = (`hits` + 1) WHERE `id` = '60'

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\table\table.php:1228
10	JTable->hit()	JROOT\components\com_content\models\article.php:266
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
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.82 ms After last query: 1.61 ms Query memory: 0.025 MB Memory before query: 8.623 MB Rows returned: 1

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

  FROM h_content AS a

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

  LEFT JOIN h_users AS u 
  on u.id = a.created_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 <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.language in ('en-GB','*') 
  AND a.id = 60 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 20:22:57') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 20:22:57') 
  AND (a.state = 1 OR a.state =2)

Explain

EXPLAIN not possible on query: SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM h_content AS a LEFT JOIN h_categories AS c on c.id = a.catid LEFT JOIN h_users AS u on u.id = a.created_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 <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.language in ('en-GB','*') AND a.id = 60 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 20:22:57') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 20:22:57') AND (a.state = 1 OR a.state =2)

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\plugins\system\falangdriver\falang_database.php:414
13	JFalangDatabase->loadObject()	JROOT\components\com_content\models\article.php:159
12	ContentModelArticle->getItem()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
11	JViewLegacy->get()	JROOT\components\com_content\views\article\view.html.php:42
10	ContentViewArticle->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.29 ms Query memory: 0.025 MB Memory before query: 8.644 MB Rows returned: 0

Duplicate queries: #16

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(60)
   
  AND falang_content.reference_table='content'

Explain

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\plugins\system\falangdriver\falang_database.php:414
13	JFalangDatabase->loadObject()	JROOT\components\com_content\models\article.php:159
12	ContentModelArticle->getItem()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
11	JViewLegacy->get()	JROOT\components\com_content\views\article\view.html.php:42
10	ContentViewArticle->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.27 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 8.653 MB Rows returned: 0

Duplicate queries: #21

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(2)
   
  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
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\plugins\system\falangdriver\falang_database.php:414
13	JFalangDatabase->loadObject()	JROOT\components\com_content\models\article.php:159
12	ContentModelArticle->getItem()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
11	JViewLegacy->get()	JROOT\components\com_content\views\article\view.html.php:42
10	ContentViewArticle->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.25 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 8.663 MB Rows returned: 0

Duplicate queries: #20

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(2)
   
  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
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\plugins\system\falangdriver\falang_database.php:414
13	JFalangDatabase->loadObject()	JROOT\components\com_content\models\article.php:159
12	ContentModelArticle->getItem()	JROOT\plugins\system\t3\includes\joomla30\viewlegacy.php:394
11	JViewLegacy->get()	JROOT\components\com_content\views\article\view.html.php:42
10	ContentViewArticle->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: 2.64 ms Query memory: 0.025 MB Memory before query: 8.814 MB Rows returned: 2

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

  FROM 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=2

  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=2 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
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\legacy\categories\categories.php:309
13	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
12	JCategories->get()	JROOT\components\com_content\helpers\route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT\components\com_content\views\article\view.html.php:71
10	ContentViewArticle->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.36 ms After last query: 0.30 ms Query memory: 0.025 MB Memory before query: 8.825 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,2)
   
  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
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\legacy\categories\categories.php:309
13	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
12	JCategories->get()	JROOT\components\com_content\helpers\route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT\components\com_content\views\article\view.html.php:71
10	ContentViewArticle->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.28 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 8.847 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.article' 
  AND `m`.`content_item_id` = 60 
  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.article' AND `m`.`content_item_id` = 60 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
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\helper\tags.php:435
11	JHelperTags->getItemTags()	JROOT\components\com_content\views\article\view.html.php:156
10	ContentViewArticle->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: 21.38 ms Query memory: 0.021 MB Memory before query: 9.569 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.46 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 9.581 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.22 ms After last query: 0.98 ms Query memory: 0.021 MB Memory before query: 9.627 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 = 201

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 = 201

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.25 ms After last query: 0.91 ms Query memory: 0.021 MB Memory before query: 9.644 MB Rows returned: 0

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

  FROM `h_content` AS `c`

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

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

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

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

  WHERE c.id = 60

Explain

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

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\components\com_content\helpers\association.php:43
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.76 ms After last query: 30.98 ms Query memory: 0.190 MB Memory before query: 11.447 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 20:22:57') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-25 20:22:57') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 201 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 20:22:57') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-25 20:22:57') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 201 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.89 ms After last query: 0.37 ms Query memory: 0.026 MB Memory before query: 11.710 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.28 ms After last query: 9.70 ms Query memory: 0.028 MB Memory before query: 12.223 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.24 ms After last query: 2.61 ms Query memory: 0.023 MB Memory before query: 12.462 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.]

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
 
  FROM h_menu AS m
 
  LEFT JOIN h_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
 
  FROM h_content AS a
 
  LEFT JOIN h_categories AS c 
  on c.id = a.catid
 
  LEFT JOIN h_users AS u 
  on u.id = a.created_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

1 × SELECT * 
  FROM h_acymailing_confi

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

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
 
  FROM `h_content` AS `c`
 
  INNER JOIN `h_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'
 
  INNER JOIN `h_associations` AS `a2` 
  ON a.key = a2.key
 
  INNER JOIN `h_content` AS `c2` 
  ON a2.id = c2.`id`
 
  INNER JOIN `h_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × 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`

1 × SELECT language,id
 
  FROM `h_menu`

1 × SELECT `m`.`tag_id`,`t`.*
 
  FROM `h_contentitem_tag_map` AS m 
 
  INNER JOIN `h_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

```
1 × SELECT *
 
  FROM h_content
```

1 × SELECT joomlatablename,tablepkID 
  FROM `h_falang_tableinfo

1 × SELECT a.name, a.rules
 
  FROM h_assets AS a

1 × SELECT element
 
  FROM h_extensions

1 × SELECT a.rules
 
  FROM h_assets AS a

```
1 × SELECT *
 
  FROM h_assets
```

1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
 
  FROM `h_extensions`

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

```
1 × SELECT * 
  FROM h_languages
```

1 × SELECT * 
  FROM h_acymailing_list

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `h_languages

1 × UPDATE `h_extensions`
 
  SET `params` = '{\"mediaversion\":\"54605b7f84dee70e9f7606e586b8fe5a\"}'

1 × SHOW FULL COLUMNS 
  FROM `h_assets

1 × SHOW FULL COLUMNS 
  FROM `h_content

1 × UPDATE h_content
 
  SET `hits` = (`hits` + 1)

Main Menu

CLINIC APPOINTMENTS

Principles of the hospital

MEDICAL DEPARTMENTS

OUR OFFERS

Email Newsletter

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

33 Queries Logged 54.52 ms

4 duplicate found!

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Main Menu

Login to your account

Create an account

CLINIC APPOINTMENTS

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

33 Queries Logged 54.52 ms

4 duplicate found!

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: