Joomla! Debug Console

Session

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

Time: 159.28 ms / 196.42 ms Memory: 4.825 MB / 5.75 MB Application: afterInitialise

Time: 71.72 ms / 268.15 ms Memory: 1.481 MB / 7.23 MB Application: afterRoute

Time: 0.99 ms / 269.14 ms Memory: 0.022 MB / 7.25 MB Application: beforeRenderComponent com_content

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

Time: 2.11 ms / 288.68 ms Memory: 0.033 MB / 7.98 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.04 ms / 288.71 ms Memory: 0.000 MB / 7.98 MB Application: Start JAccess::preload(components)

Time: 1.85 ms / 290.57 ms Memory: 0.209 MB / 8.19 MB Application: Finish JAccess::preload(components)

Time: 134.90 ms / 425.47 ms Memory: 1.687 MB / 9.87 MB Application: beforeRenderModule mod_bt_contentshowcase (Emergency doctor)

Time: 30.82 ms / 456.29 ms Memory: 0.648 MB / 10.52 MB Application: afterRenderModule mod_bt_contentshowcase (Emergency doctor)

Time: 3.08 ms / 459.36 ms Memory: 0.020 MB / 10.54 MB Application: afterRenderComponent com_content

Time: 7.52 ms / 466.88 ms Memory: 0.146 MB / 10.69 MB Application: afterDispatch

Time: 54.15 ms / 521.03 ms Memory: 1.630 MB / 12.32 MB Application: beforeRenderModule mod_footer (Footer)

Time: 2.13 ms / 523.16 ms Memory: 0.007 MB / 12.32 MB Application: afterRenderModule mod_footer (Footer)

Time: 0.07 ms / 523.23 ms Memory: 0.002 MB / 12.33 MB Application: beforeRenderModule mod_acymailing (Email Newsletter)

Time: 14.40 ms / 537.63 ms Memory: 0.649 MB / 12.98 MB Application: afterRenderModule mod_acymailing (Email Newsletter)

Time: 0.04 ms / 537.67 ms Memory: 0.000 MB / 12.96 MB Application: beforeRenderModule mod_custom (Social footer)

Time: 2.07 ms / 539.74 ms Memory: 0.007 MB / 12.97 MB Application: afterRenderModule mod_custom (Social footer)

Time: 0.05 ms / 539.80 ms Memory: 0.002 MB / 12.97 MB Application: beforeRenderModule mod_custom (OUR OFFERS)

Time: 0.38 ms / 540.18 ms Memory: 0.003 MB / 12.97 MB Application: afterRenderModule mod_custom (OUR OFFERS)

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

Time: 0.35 ms / 540.55 ms Memory: 0.003 MB / 12.97 MB Application: afterRenderModule mod_custom (OUR OFFERS F)

Time: 0.05 ms / 540.60 ms Memory: 0.000 MB / 12.97 MB Application: beforeRenderModule mod_custom (MEDICAL DEPARTMENTS)

Time: 0.33 ms / 540.92 ms Memory: 0.003 MB / 12.98 MB Application: afterRenderModule mod_custom (MEDICAL DEPARTMENTS)

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

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

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

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

Time: 0.05 ms / 541.69 ms Memory: 0.003 MB / 12.99 MB Application: beforeRenderModule mod_bt_sociallogin (BT Social Login)

Time: 37.80 ms / 579.49 ms Memory: 0.935 MB / 13.92 MB Application: afterRenderModule mod_bt_sociallogin (BT Social Login)

Time: 0.06 ms / 579.55 ms Memory: 0.000 MB / 13.90 MB Application: beforeRenderModule mod_search (Search)

Time: 2.37 ms / 581.92 ms Memory: 0.012 MB / 13.92 MB Application: afterRenderModule mod_search (Search)

Time: 0.08 ms / 582.00 ms Memory: 0.000 MB / 13.91 MB Application: beforeRenderModule mod_menu (Main menu reponsive)

Time: 13.31 ms / 595.30 ms Memory: 0.121 MB / 14.03 MB Application: afterRenderModule mod_menu (Main menu reponsive)

Time: 0.05 ms / 595.35 ms Memory: 0.000 MB / 14.03 MB Application: beforeRenderModule mod_languages (Language Switcher)

Time: 9.13 ms / 604.49 ms Memory: 0.336 MB / 14.37 MB Application: afterRenderModule mod_languages (Language Switcher)

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

Time: 0.35 ms / 604.86 ms Memory: 0.003 MB / 14.37 MB Application: afterRenderModule mod_custom (Top head right)

Time: 0.05 ms / 604.91 ms Memory: 0.001 MB / 14.37 MB Application: beforeRenderModule mod_custom (Top head)

Time: 0.32 ms / 605.23 ms Memory: 0.003 MB / 14.37 MB Application: afterRenderModule mod_custom (Top head)

Time: 11.72 ms / 616.95 ms Memory: 0.283 MB / 14.65 MB Application: afterRender

Database queries total: 116.56 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.16 ms After last query: 4.07 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.15 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 6.280 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: 8.80 ms After last query: 4.74 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: 3.13 ms After last query: 2.64 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.36 ms After last query: 3.66 ms Query memory: 0.022 MB Memory before query: 6.478 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.24 ms After last query: 12.18 ms Query memory: 0.025 MB Memory before query: 6.705 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.35 ms After last query: 0.22 ms Query memory: 0.006 MB Memory before query: 6.699 MB

UPDATE `h_extensions`

  SET `params` = '{\"mediaversion\":\"2ec104b9ea8f90beae30b262420736cb\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `h_extensions` SET `params` = '{\"mediaversion\":\"2ec104b9ea8f90beae30b262420736cb\"}' 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: 8.28 ms After last query: 22.16 ms Query memory: 0.028 MB Memory before query: 7.919 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.19 ms Query memory: 0.026 MB Memory before query: 7.942 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.28 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 7.951 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.29 ms After last query: 1.88 ms Query memory: 0.026 MB Memory before query: 7.978 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.46 ms After last query: 0.20 ms Query memory: 0.027 MB Memory before query: 7.993 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: 8.57 ms After last query: 1.97 ms Query memory: 0.033 MB Memory before query: 8.215 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.25 ms After last query: 6.90 ms Query memory: 0.025 MB Memory before query: 8.477 MB Rows returned: 1

SELECT *

  FROM h_content

  WHERE `id` = '75'

Explain

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

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.29 ms After last query: 0.23 ms Query memory: 0.025 MB Memory before query: 8.510 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(75)
   
  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.45 ms After last query: 0.14 ms Query memory: 0.006 MB Memory before query: 8.517 MB

UPDATE h_content

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

  WHERE `id` = '75'

Explain

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

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: 43.69 ms After last query: 2.78 ms Query memory: 0.025 MB Memory before query: 8.621 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 = 75 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 19:41:36') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 19:41:36') 
  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 = 75 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 19:41:36') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 19:41:36') 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.37 ms After last query: 0.38 ms Query memory: 0.025 MB Memory before query: 8.642 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(75)
   
  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.28 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 8.652 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(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
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.26 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 8.661 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(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
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: 10.31 ms After last query: 8.37 ms Query memory: 0.025 MB Memory before query: 8.813 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
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.38 ms After last query: 0.36 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,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
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: 8.67 ms After last query: 0.58 ms Query memory: 0.023 MB Memory before query: 8.843 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` = 75 
  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` = 75 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: 1.76 ms After last query: 34.80 ms Query memory: 0.190 MB Memory before query: 9.633 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:41:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-25 19:41:36') 
  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:41:36') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-25 19:41:36') 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
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\t3\includes\joomla30\modulehelper.php:423
16	JModuleHelper::_load()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:52
15	JModuleHelper::getModule()	JROOT\plugins\content\loadmodule\loadmodule.php:168
14	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:69
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:161
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: 2.96 ms After last query: 0.49 ms Query memory: 0.026 MB Memory before query: 9.906 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
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:276
20	JFalangDatabase->loadObjectList()	JROOT\components\com_falang\helpers\falang.class.php:252
19	Falang::translateListWithIDs()	JROOT\components\com_falang\helpers\falang.class.php:125
18	Falang::translateList()	JROOT\plugins\system\falangdriver\falang_database.php:332
17	JFalangDatabase->loadObjectList()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:423
16	JModuleHelper::_load()	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:52
15	JModuleHelper::getModule()	JROOT\plugins\content\loadmodule\loadmodule.php:168
14	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:69
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:161
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: 1.08 ms After last query: 11.90 ms Query memory: 0.062 MB Memory before query: 10.273 MB Rows returned: 3

SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,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 IN (27) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 19:41:36') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 19:41:36') 
  AND a.language in ('en-GB','*')

  ORDER BY a.created asc 
  LIMIT 100

Explain

EXPLAIN not possible on query: SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,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 IN (27) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-25 19:41:36') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-25 19:41:36') AND a.language in ('en-GB','*') ORDER BY a.created asc LIMIT 100

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\model\legacy.php:310
22	JModelLegacy->_getList()	JROOT\libraries\legacy\model\list.php:183
21	JModelList->getItems()	JROOT\components\com_content\models\articles.php:565
20	ContentModelArticles->getItems()	JROOT\modules\mod_bt_contentshowcase\classes\content.php:159
19	BtContentDataSource->getList()	JROOT\modules\mod_bt_contentshowcase\helpers\helper.php:71
18	modBtContentShowcaseHelper::getList()	JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php:21
17	include JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:191
16	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
15	JDocumentRendererHtmlModule->render()	JROOT\plugins\content\loadmodule\loadmodule.php:183
14	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:69
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:161
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.45 ms After last query: 0.43 ms Query memory: 0.029 MB Memory before query: 10.330 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(67,68,70)
   
  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
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\model\legacy.php:310
22	JModelLegacy->_getList()	JROOT\libraries\legacy\model\list.php:183
21	JModelList->getItems()	JROOT\components\com_content\models\articles.php:565
20	ContentModelArticles->getItems()	JROOT\modules\mod_bt_contentshowcase\classes\content.php:159
19	BtContentDataSource->getList()	JROOT\modules\mod_bt_contentshowcase\helpers\helper.php:71
18	modBtContentShowcaseHelper::getList()	JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php:21
17	include JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:191
16	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
15	JDocumentRendererHtmlModule->render()	JROOT\plugins\content\loadmodule\loadmodule.php:183
14	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:69
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:161
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.10 ms Query memory: 0.029 MB Memory before query: 10.343 MB Rows returned: 0

Duplicate queries: #30

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(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\model\legacy.php:310
22	JModelLegacy->_getList()	JROOT\libraries\legacy\model\list.php:183
21	JModelList->getItems()	JROOT\components\com_content\models\articles.php:565
20	ContentModelArticles->getItems()	JROOT\modules\mod_bt_contentshowcase\classes\content.php:159
19	BtContentDataSource->getList()	JROOT\modules\mod_bt_contentshowcase\helpers\helper.php:71
18	modBtContentShowcaseHelper::getList()	JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php:21
17	include JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:191
16	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
15	JDocumentRendererHtmlModule->render()	JROOT\plugins\content\loadmodule\loadmodule.php:183
14	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:69
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:161
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.26 ms After last query: 0.09 ms Query memory: 0.029 MB Memory before query: 10.357 MB Rows returned: 0

Duplicate queries: #29

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(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\model\legacy.php:310
22	JModelLegacy->_getList()	JROOT\libraries\legacy\model\list.php:183
21	JModelList->getItems()	JROOT\components\com_content\models\articles.php:565
20	ContentModelArticles->getItems()	JROOT\modules\mod_bt_contentshowcase\classes\content.php:159
19	BtContentDataSource->getList()	JROOT\modules\mod_bt_contentshowcase\helpers\helper.php:71
18	modBtContentShowcaseHelper::getList()	JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php:21
17	include JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:191
16	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
15	JDocumentRendererHtmlModule->render()	JROOT\plugins\content\loadmodule\loadmodule.php:183
14	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:69
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:161
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.26 ms Query memory: 0.027 MB Memory before query: 10.397 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` = 67 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

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\libraries\cms\helper\tags.php:435
21	JHelperTags->getItemTags()	JROOT\components\com_content\models\articles.php:693
20	ContentModelArticles->getItems()	JROOT\modules\mod_bt_contentshowcase\classes\content.php:159
19	BtContentDataSource->getList()	JROOT\modules\mod_bt_contentshowcase\helpers\helper.php:71
18	modBtContentShowcaseHelper::getList()	JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php:21
17	include JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:191
16	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
15	JDocumentRendererHtmlModule->render()	JROOT\plugins\content\loadmodule\loadmodule.php:183
14	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:69
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:161
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.27 ms Query memory: 0.027 MB Memory before query: 10.389 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` = 68 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

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\libraries\cms\helper\tags.php:435
21	JHelperTags->getItemTags()	JROOT\components\com_content\models\articles.php:693
20	ContentModelArticles->getItems()	JROOT\modules\mod_bt_contentshowcase\classes\content.php:159
19	BtContentDataSource->getList()	JROOT\modules\mod_bt_contentshowcase\helpers\helper.php:71
18	modBtContentShowcaseHelper::getList()	JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php:21
17	include JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:191
16	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
15	JDocumentRendererHtmlModule->render()	JROOT\plugins\content\loadmodule\loadmodule.php:183
14	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:69
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:161
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.24 ms After last query: 0.25 ms Query memory: 0.028 MB Memory before query: 10.416 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` = 70 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

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\libraries\cms\helper\tags.php:435
21	JHelperTags->getItemTags()	JROOT\components\com_content\models\articles.php:693
20	ContentModelArticles->getItems()	JROOT\modules\mod_bt_contentshowcase\classes\content.php:159
19	BtContentDataSource->getList()	JROOT\modules\mod_bt_contentshowcase\helpers\helper.php:71
18	modBtContentShowcaseHelper::getList()	JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php:21
17	include JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:191
16	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
15	JDocumentRendererHtmlModule->render()	JROOT\plugins\content\loadmodule\loadmodule.php:183
14	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:69
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:161
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: 9.58 ms After last query: 0.20 ms Query memory: 0.029 MB Memory before query: 10.431 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:44
20	ContentHelperRoute::getArticleRoute()	JROOT\modules\mod_bt_contentshowcase\classes\content.php:186
19	BtContentDataSource->getList()	JROOT\modules\mod_bt_contentshowcase\helpers\helper.php:71
18	modBtContentShowcaseHelper::getList()	JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php:21
17	include JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:191
16	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
15	JDocumentRendererHtmlModule->render()	JROOT\plugins\content\loadmodule\loadmodule.php:183
14	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:69
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:161
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.43 ms After last query: 0.33 ms Query memory: 0.029 MB Memory before query: 10.466 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:44
20	ContentHelperRoute::getArticleRoute()	JROOT\modules\mod_bt_contentshowcase\classes\content.php:186
19	BtContentDataSource->getList()	JROOT\modules\mod_bt_contentshowcase\helpers\helper.php:71
18	modBtContentShowcaseHelper::getList()	JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php:21
17	include JROOT\modules\mod_bt_contentshowcase\mod_bt_contentshowcase.php	JROOT\plugins\system\t3\includes\joomla30\modulehelper.php:191
16	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
15	JDocumentRendererHtmlModule->render()	JROOT\plugins\content\loadmodule\loadmodule.php:183
14	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:69
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:161
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: 7.69 ms Query memory: 0.021 MB Memory before query: 10.546 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.39 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 10.542 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.12 ms After last query: 0.26 ms Query memory: 0.025 MB Memory before query: 10.549 MB Rows returned: 1

Duplicate queries: #42

SELECT alias

  FROM h_content

  WHERE id=75

Explain

EXPLAIN not possible on query: SELECT alias FROM h_content WHERE id=75

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\plugins\system\falangdriver\falang_database.php:349
15	JFalangDatabase->_loadObject()	JROOT\plugins\system\falangdriver\falang_database.php:140
14	JFalangDatabase->loadResult()	JROOT\components\com_content\router.php:118
13	ContentRouter->build()	JROOT\libraries\cms\router\site.php:496
12	JRouterSite->buildSefRoute()	JROOT\libraries\cms\router\site.php:465
11	JRouterSite->_buildSefRoute()	JROOT\libraries\cms\router\router.php:281
10	JRouter->build()	JROOT\libraries\cms\router\site.php:147
9	JRouterSite->build()	JROOT\libraries\joomla\application\route.php:62
8	JRoute::_()	JROOT\plugins\system\languagefilter\languagefilter.php:709
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.28 ms After last query: 2.76 ms Query memory: 0.021 MB Memory before query: 10.589 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 = 75

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

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: 0.31 ms After last query: 67.00 ms Query memory: 0.028 MB Memory before query: 12.708 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.20 ms After last query: 4.68 ms Query memory: 0.023 MB Memory before query: 13.012 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.]

Query Time: 0.25 ms After last query: 10.86 ms Query memory: 0.026 MB Memory before query: 13.248 MB Rows returned: 1

Duplicate queries: #38

SELECT alias

  FROM h_content

  WHERE id=75

Explain

EXPLAIN not possible on query: SELECT alias FROM h_content WHERE id=75

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\components\com_content\router.php:118
16	ContentRouter->build()	JROOT\libraries\cms\router\site.php:496
15	JRouterSite->buildSefRoute()	JROOT\libraries\cms\router\site.php:465
14	JRouterSite->_buildSefRoute()	JROOT\libraries\cms\router\router.php:281
13	JRouter->build()	JROOT\libraries\cms\router\site.php:147
12	JRouterSite->build()	JROOT\libraries\joomla\application\route.php:62
11	JRoute::_()	JROOT\modules\mod_bt_sociallogin\mod_bt_sociallogin.php:67
10	include JROOT\modules\mod_bt_sociallogin\mod_bt_sociallogin.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.31 ms After last query: 51.76 ms Query memory: 0.024 MB Memory before query: 14.250 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
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\language\associations.php:101
13	JLanguageAssociations::getAssociations()	JROOT\administrator\components\com_menus\helpers\menus.php:284
12	MenusHelper::getAssociations()	JROOT\modules\mod_languages\helper.php:62
11	ModLanguagesHelper::getList()	JROOT\modules\mod_languages\mod_languages.php:17
10	include JROOT\modules\mod_languages\mod_languages.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.]

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

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

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

```
2 × SELECT alias
 
  FROM h_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 * 
  FROM h_acymailing_list

1 × SELECT * 
  FROM h_acymailing_confi

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 language,id
 
  FROM `h_menu`

1 × SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,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

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 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 joomlatablename,tablepkID 
  FROM `h_falang_tableinfo

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

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

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `h_languages

1 × UPDATE `h_extensions`
 
  SET `params` = '{\"mediaversion\":\"2ec104b9ea8f90beae30b262420736cb\"}'

1 × SHOW FULL COLUMNS 
  FROM `h_assets

1 × SHOW FULL COLUMNS 
  FROM `h_content

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

Main Menu

Dr. Heba Barakat

Qualifications

Specialist’s

Principles of the hospital

MEDICAL DEPARTMENTS

OUR OFFERS

Email Newsletter

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

44 Queries Logged 116.56 ms

8 duplicate found!

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Main Menu

Login to your account

Create an account

Dr. Heba Barakat

Qualifications

Specialist’s

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

44 Queries Logged 116.56 ms

8 duplicate found!

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: