Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695674992,
                "last": 1695674992,
                "now": 1695674992
            },
            "token": "YyDtStZEce5arBlsj06GINUc1aL3qF7h"
        },
        "registry": {
            "users": {
                "login": {
                    "form": {
                        "data": {
                            "return": "index.php?option=com_jssupportticket&c=ticket&layout=formticket&Itemid=225"
                        }
                    }
                }
            },
            "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
        },
        "btl-s": {
            "facebook": "fb",
            "google": "gg",
            "twitter": "tt"
        },
        "application": {
            "queue": null
        }
    }
}

Profile Information

Time

Memory

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

Time: 64.80 ms / 74.03 ms Memory: 4.826 MB / 5.75 MB Application: afterInitialise

Time: 39.37 ms / 113.40 ms Memory: 1.401 MB / 7.16 MB Application: afterRoute

Time: 0.32 ms / 113.72 ms Memory: 0.013 MB / 7.17 MB Application: beforeRenderComponent com_users

Time: 24.21 ms / 137.93 ms Memory: 1.534 MB / 8.70 MB Application: afterRenderComponent com_users

Time: 2.93 ms / 140.85 ms Memory: 0.113 MB / 8.81 MB Application: afterDispatch

Time: 64.07 ms / 204.92 ms Memory: 2.414 MB / 11.23 MB Application: beforeRenderModule mod_footer (Footer)

Time: 1.56 ms / 206.48 ms Memory: 0.111 MB / 11.34 MB Application: afterRenderModule mod_footer (Footer)

Time: 0.08 ms / 206.56 ms Memory: 0.003 MB / 11.34 MB Application: beforeRenderModule mod_acymailing (Email Newsletter)

Time: 7.21 ms / 213.77 ms Memory: 0.515 MB / 11.86 MB Application: afterRenderModule mod_acymailing (Email Newsletter)

Time: 0.03 ms / 213.80 ms Memory: 0.000 MB / 11.84 MB Application: beforeRenderModule mod_custom (Social footer)

Time: 0.67 ms / 214.47 ms Memory: 0.005 MB / 11.85 MB Application: afterRenderModule mod_custom (Social footer)

Time: 0.05 ms / 214.52 ms Memory: 0.002 MB / 11.85 MB Application: beforeRenderModule mod_custom (OUR OFFERS)

Time: 0.35 ms / 214.87 ms Memory: 0.003 MB / 11.85 MB Application: afterRenderModule mod_custom (OUR OFFERS)

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

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

Time: 0.05 ms / 215.27 ms Memory: 0.000 MB / 11.85 MB Application: beforeRenderModule mod_custom (MEDICAL DEPARTMENTS)

Time: 0.33 ms / 215.60 ms Memory: 0.005 MB / 11.86 MB Application: afterRenderModule mod_custom (MEDICAL DEPARTMENTS)

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

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

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

Time: 0.33 ms / 216.32 ms Memory: 0.003 MB / 11.86 MB Application: afterRenderModule mod_custom (Principles of the hospital)

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

Time: 16.23 ms / 232.61 ms Memory: 0.396 MB / 12.26 MB Application: afterRenderModule mod_bt_sociallogin (BT Social Login)

Time: 0.06 ms / 232.67 ms Memory: 0.000 MB / 12.25 MB Application: beforeRenderModule mod_search (Search)

Time: 0.75 ms / 233.42 ms Memory: 0.012 MB / 12.26 MB Application: afterRenderModule mod_search (Search)

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

Time: 8.89 ms / 242.36 ms Memory: 0.191 MB / 12.45 MB Application: afterRenderModule mod_menu (Main menu reponsive)

Time: 0.05 ms / 242.42 ms Memory: 0.000 MB / 12.44 MB Application: beforeRenderModule mod_languages (Language Switcher)

Time: 3.83 ms / 246.25 ms Memory: 0.168 MB / 12.61 MB Application: afterRenderModule mod_languages (Language Switcher)

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

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

Time: 0.05 ms / 246.67 ms Memory: 0.001 MB / 12.61 MB Application: beforeRenderModule mod_custom (Top head)

Time: 0.32 ms / 246.99 ms Memory: 0.006 MB / 12.62 MB Application: afterRenderModule mod_custom (Top head)

Time: 11.23 ms / 258.22 ms Memory: 0.276 MB / 12.89 MB Application: afterRender

Database queries total: 44.63 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.21 ms After last query: 1.57 ms Query memory: 0.026 MB Memory before query: 6.272 MB Rows returned: 7

SELECT joomlatablename,tablepkID 
  FROM `h_falang_tableinfo`

Explain

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

Profile

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

Call Stack

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

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

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

SELECT * 
  FROM h_languages 
  ORDER BY ordering

Explain

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

Profile

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

Call Stack

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

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

Query Time: 11.22 ms After last query: 1.96 ms Query memory: 0.029 MB Memory before query: 6.504 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `h_languages`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 4.22 ms After last query: 1.03 ms Query memory: 0.025 MB Memory before query: 6.559 MB Rows returned: 0

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

  FROM h_falang_content AS falang_content

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.39 ms After last query: 1.23 ms Query memory: 0.022 MB Memory before query: 6.402 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.29 ms After last query: 4.86 ms Query memory: 0.025 MB Memory before query: 6.630 MB Rows returned: 1

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

  FROM `h_extensions`

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.40 ms After last query: 0.16 ms Query memory: 0.006 MB Memory before query: 6.624 MB

UPDATE `h_extensions`

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

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

Explain

EXPLAIN not possible on query: UPDATE `h_extensions` SET `params` = '{\"mediaversion\":\"a627563dd8683b4b761fdfa8d67a4948\"}' 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: 0.35 ms After last query: 30.35 ms Query memory: 0.022 MB Memory before query: 8.705 MB Rows returned: 3

SELECT language,id

  FROM `h_menu`

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.46 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 8.717 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: 22.67 ms After last query: 29.51 ms Query memory: 0.190 MB Memory before query: 10.465 MB Rows returned: 53

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

  FROM h_modules AS m

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

  LEFT JOIN h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-09-25 20:49:52') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-25 20:49:52') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

EXPLAIN not possible on query: SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM h_modules AS m LEFT JOIN h_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN h_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-09-25 20:49:52') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-25 20:49:52') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 0 OR mm.menuid <= 0) AND m.language IN ('en-GB','*') ORDER BY m.position, m.ordering

Profile

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

Call Stack

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

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

Query Time: 2.89 ms After last query: 0.43 ms Query memory: 0.026 MB Memory before query: 10.728 MB Rows returned: 0

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

  FROM h_falang_content AS falang_content

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.30 ms After last query: 15.88 ms Query memory: 0.028 MB Memory before query: 11.728 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.26 ms After last query: 1.71 ms Query memory: 0.023 MB Memory before query: 11.894 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.]

12 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

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

1 × SELECT joomlatablename,tablepkID 
  FROM `h_falang_tableinfo

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

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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
 
  FROM `h_extensions`

1 × SELECT language,id
 
  FROM `h_menu`

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 * 
  FROM h_acymailing_confi

1 × SELECT * 
  FROM h_acymailing_list

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `h_languages

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

Main Menu

Login to your account

Create an account

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

15 Queries Logged 44.63 ms

12 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: