July 30 2019 г.

How to solve the problems of deceived stakeholders

March 28 2019 г.

Over 10 thousand equity holders of the capital do not have apartments over the years

March 12 2019 г.

Who can not access the program 7-20-25?

January 172019 г.

MG RK: In Kazakhstan, the construction of primary housing will grow

January 10 2019 г.

"The Law on Equity Construction Obstructs Two Parties" - experts explained that the apartments were sold without the permission of akimat

14 January 2019.

Housing construction development. Program Economy Khabar 24

December 28, 2018

Briefing of the Chairman of the Board of JSC "FGJS" in the Service of Central communications

November 29, 2018

How much are apartments in the cities of Kazakhstan

July 20, 2018

Picture of the day "Housing without collateral for shareholders»

April 3, 2018

Administration of oral, JSC "ZHILSTROYSBERBANK", JSC "FGIS" and LLP "Caravan route" signed a Memorandum on cooperation in the framework of the program "Own house".

South Korea shares experience of housing construction guarantee with Kazakhstan

FaLang translation system by Faboba

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1582847638,
                "last": 1582847638,
                "now": 1582847638
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "js_id_currency_orig": "1",
        "js_id_currency": "1"
    }
}

Profile Information

Time

Memory

Time: 11.04 ms / 11.04 ms Memory: 0.191 MB / 0.42 MB Application: afterLoad

Time: 62.46 ms / 73.50 ms Memory: 3.164 MB / 3.58 MB Application: afterInitialise

Time: 43.71 ms / 117.21 ms Memory: 0.706 MB / 4.29 MB Application: afterRoute

Time: 7.82 ms / 125.03 ms Memory: 0.156 MB / 4.45 MB Application: beforeRenderComponent com_content

Time: 4.70 ms / 129.73 ms Memory: 0.233 MB / 4.68 MB Application: Start JAccess::getAssetRules Old (1)

Time: 1.20 ms / 130.93 ms Memory: 0.041 MB / 4.72 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.06 ms / 130.99 ms Memory: 0.000 MB / 4.71 MB Application: Start JAccess::preload(components)

Time: 3.59 ms / 134.58 ms Memory: 0.284 MB / 5.00 MB Application: Finish JAccess::preload(components)

Time: 37.86 ms / 172.44 ms Memory: 0.759 MB / 5.76 MB Application: afterRenderComponent com_content

Time: 7.70 ms / 180.14 ms Memory: 0.117 MB / 5.88 MB Application: afterDispatch

Time: 9.11 ms / 189.25 ms Memory: 0.122 MB / 6.00 MB Application: beforeRenderModule mod_custom (footer)

Time: 1.07 ms / 190.32 ms Memory: 0.012 MB / 6.01 MB Application: afterRenderModule mod_custom (footer)

Time: 0.06 ms / 190.37 ms Memory: 0.000 MB / 6.01 MB Application: beforeRenderModule mod_custom (copyright)

Time: 0.51 ms / 190.88 ms Memory: 0.007 MB / 6.01 MB Application: afterRenderModule mod_custom (copyright)

Time: 0.19 ms / 191.07 ms Memory: 0.002 MB / 6.01 MB Application: beforeRenderModule mod_menu (Mobi menu)

Time: 46.13 ms / 237.19 ms Memory: 0.855 MB / 6.87 MB Application: afterRenderModule mod_menu (Mobi menu)

Time: 0.16 ms / 237.35 ms Memory: 0.000 MB / 6.86 MB Application: beforeRenderModule mod_menu (menu)

Time: 25.05 ms / 262.40 ms Memory: 0.025 MB / 6.88 MB Application: afterRenderModule mod_menu (menu)

Time: 0.17 ms / 262.56 ms Memory: 0.000 MB / 6.87 MB Application: beforeRenderModule mod_search (searh)

Time: 2.83 ms / 265.39 ms Memory: 0.030 MB / 6.90 MB Application: afterRenderModule mod_search (searh)

Time: 0.11 ms / 265.50 ms Memory: 0.000 MB / 6.90 MB Application: beforeRenderModule mod_falang (FaLang Language Switcher)

Time: 15.79 ms / 281.29 ms Memory: 0.480 MB / 7.38 MB Application: afterRenderModule mod_falang (FaLang Language Switcher)

Time: 0.12 ms / 281.41 ms Memory: 0.000 MB / 7.37 MB Application: beforeRenderModule mod_custom (Site header)

Time: 0.58 ms / 281.99 ms Memory: 0.007 MB / 7.37 MB Application: afterRenderModule mod_custom (Site header)

Time: 0.06 ms / 282.05 ms Memory: 0.000 MB / 7.37 MB Application: beforeRenderModule mod_custom (logo)

Time: 0.51 ms / 282.55 ms Memory: 0.007 MB / 7.38 MB Application: afterRenderModule mod_custom (logo)

Time: 4.08 ms / 286.63 ms Memory: 0.068 MB / 7.45 MB Application: afterRender

Database queries total: 41.12 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 hf05s_menu AS m LEFT JOIN hf05s_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
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/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:264
11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
10	call_user_func_array()	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:49

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

Query Time: 0.13 ms After last query: 2.44 ms Query memory: 0.027 MB Memory before query: 4.564 MB Rows returned: 7

SELECT joomlatablename,tablepkID 
  FROM `hf05s_falang_tableinfo`

Explain

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

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/administrator/components/com_falang/classes/FalangManager.class.php:147
19	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:60
18	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
17	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
16	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:332
15	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:264
11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
10	call_user_func_array()	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:49

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

Query Time: 0.14 ms After last query: 0.30 ms Query memory: 0.027 MB Memory before query: 4.596 MB Rows returned: 3

SELECT * 
  FROM hf05s_languages 
  ORDER BY ordering

Explain

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

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/administrator/components/com_falang/classes/FalangManager.class.php:322
19	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:66
18	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
17	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
16	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:332
15	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:264
11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
10	call_user_func_array()	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:49

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

Query Time: 0.74 ms After last query: 0.48 ms Query memory: 0.032 MB Memory before query: 4.662 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `hf05s_languages`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:281
24	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
21	JTable->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:77
20	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:328
19	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:66
18	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
17	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
16	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:332
15	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:264
11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
10	call_user_func_array()	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:49

[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.24 ms Query memory: 0.025 MB Memory before query: 4.780 MB Rows returned: 485

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

  FROM hf05s_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(101,102,154,155,156,157,158,103,177,178,179,180,181,182,105,112,122,149,150,151,153,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,183,184,191,104,113,114,115,116,117,121,106,118,119,120,123,124,138,185,193,197,198,199,200,202,203,204,107,135,136,137,186,187,188,189,190,148,159,160,192,125,126,127,128,129,130,131,132,133,134,194,195,196,201,205,206,108,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,228,229,230)
   
  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 hf05s_falang_content AS falang_content WHERE falang_content.language_id=1 AND falang_content.published=1 AND falang_content.reference_id IN(101,102,154,155,156,157,158,103,177,178,179,180,181,182,105,112,122,149,150,151,153,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,183,184,191,104,113,114,115,116,117,121,106,118,119,120,123,124,138,185,193,197,198,199,200,202,203,204,107,135,136,137,186,187,188,189,190,148,159,160,192,125,126,127,128,129,130,131,132,133,134,194,195,196,201,205,206,108,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,228,229,230) 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
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:276
18	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
17	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
16	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:332
15	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:264
11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
10	call_user_func_array()	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:49

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

Query Time: 1.46 ms After last query: 29.20 ms Query memory: 0.020 MB Memory before query: 4.318 MB Rows returned: 1

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

  FROM `hf05s_extensions`

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

Explain

EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `hf05s_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
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()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
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:49

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

Query Time: 1.78 ms After last query: 0.58 ms Query memory: 0.013 MB Memory before query: 4.323 MB

UPDATE `hf05s_extensions`

  SET `params` = '{\"mediaversion\":\"27b24b0c3d8e114966abbce922a03320\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `hf05s_extensions` SET `params` = '{\"mediaversion\":\"27b24b0c3d8e114966abbce922a03320\"}' 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
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
10	JFalangDatabase->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
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:49

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

Query Time: 1.58 ms After last query: 1.44 ms Query memory: 0.010 MB Memory before query: 4.432 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM hf05s_template_styles as s

  LEFT JOIN hf05s_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 hf05s_template_styles as s LEFT JOIN hf05s_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
8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
7	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:281
5	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
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:49

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

Query Time: 0.74 ms After last query: 3.22 ms Query memory: 0.028 MB Memory before query: 4.604 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `hf05s_assets`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hf05s_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:49

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

Query Time: 0.19 ms After last query: 0.53 ms Query memory: 0.027 MB Memory before query: 4.656 MB Rows returned: 1

SELECT *

  FROM hf05s_assets

  WHERE `id` = '1'

Explain

EXPLAIN not possible on query: SELECT * FROM hf05s_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:49

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

Query Time: 0.14 ms After last query: 0.66 ms Query memory: 0.022 MB Memory before query: 4.681 MB Rows returned: 1

SELECT a.rules

  FROM hf05s_assets AS a

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

Explain

EXPLAIN not possible on query: SELECT a.rules FROM hf05s_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:49

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

Query Time: 0.53 ms After last query: 1.09 ms Query memory: 0.024 MB Memory before query: 4.718 MB Rows returned: 33

SELECT element

  FROM hf05s_extensions

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

Explain

EXPLAIN not possible on query: SELECT element FROM hf05s_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:49

[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.50 ms Query memory: 0.024 MB Memory before query: 4.750 MB Rows returned: 33

SELECT a.name, a.rules

  FROM hf05s_assets AS a

  WHERE (a.name IN ('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_jshopping','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_sigpro','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')

Explain

EXPLAIN not possible on query: SELECT a.name, a.rules FROM hf05s_assets AS a WHERE (a.name IN ('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_jshopping','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_sigpro','com_tags','com_templates','com_users','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:49

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

Query Time: 0.67 ms After last query: 2.78 ms Query memory: 0.022 MB Memory before query: 5.015 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `hf05s_content`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hf05s_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:49

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

Query Time: 1.82 ms After last query: 2.87 ms Query memory: 0.021 MB Memory before query: 5.150 MB Rows returned: 1

SELECT *

  FROM hf05s_content

  WHERE `id` = '45'

Explain

EXPLAIN not possible on query: SELECT * FROM hf05s_content WHERE `id` = '45'

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:49

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

Query Time: 0.95 ms After last query: 0.57 ms Query memory: 0.024 MB Memory before query: 5.217 MB Rows returned: 7

Duplicate queries: #19

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

  FROM hf05s_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(45)
   
  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:49

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

Query Time: 1.31 ms After last query: 0.36 ms Query memory: 0.015 MB Memory before query: 5.229 MB

UPDATE hf05s_content

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

  WHERE `id` = '45'

Explain

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

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:49

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

Query Time: 6.19 ms After last query: 1.33 ms Query memory: 0.021 MB Memory before query: 5.298 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 hf05s_content AS a

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

  LEFT JOIN hf05s_users AS u 
  on u.id = a.created_by

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM hf05s_categories AS cat JOIN hf05s_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 = 45 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-02-27 23:53:59') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-02-27 23:53:59') 
  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 hf05s_content AS a LEFT JOIN hf05s_categories AS c on c.id = a.catid LEFT JOIN hf05s_users AS u on u.id = a.created_by LEFT JOIN hf05s_categories as parent ON parent.id = c.parent_id LEFT JOIN hf05s_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM hf05s_categories AS cat JOIN hf05s_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 = 45 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-02-27 23:53:59') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-02-27 23:53:59') 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/libraries/legacy/view/legacy.php:408
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:49

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

Query Time: 0.16 ms After last query: 0.62 ms Query memory: 0.024 MB Memory before query: 5.346 MB Rows returned: 7

Duplicate queries: #16

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

  FROM hf05s_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(45)
   
  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/libraries/legacy/view/legacy.php:408
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:49

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

Query Time: 0.57 ms After last query: 0.26 ms Query memory: 0.024 MB Memory before query: 5.370 MB Rows returned: 0

Duplicate queries: #21

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

  FROM hf05s_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(2)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:276
17	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
16	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
15	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:332
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:414
13	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
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:49

[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.22 ms Query memory: 0.024 MB Memory before query: 5.395 MB Rows returned: 0

Duplicate queries: #20

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

  FROM hf05s_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(2)
   
  AND falang_content.reference_table='categories'

Explain

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:276
17	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
16	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
15	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:332
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:414
13	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
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:49

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

Query Time: 3.16 ms After last query: 2.61 ms Query memory: 0.021 MB Memory before query: 5.503 MB Rows returned: 2

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

  FROM hf05s_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM hf05s_categories AS cat JOIN hf05s_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 hf05s_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

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

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

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:281
14	JFalangDatabase->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.56 ms Query memory: 0.024 MB Memory before query: 5.533 MB Rows returned: 0

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

  FROM hf05s_falang_content AS falang_content

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

Explain

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:276
17	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
16	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
15	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:332
14	JFalangDatabase->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 1.15 ms Query memory: 0.030 MB Memory before query: 5.571 MB Rows returned: 1

SELECT fc.value

  FROM hf05s_falang_content fc

  WHERE fc.reference_id = 45 
  AND fc.language_id = 1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'content'

Explain

EXPLAIN not possible on query: SELECT fc.value FROM hf05s_falang_content fc WHERE fc.reference_id = 45 AND fc.language_id = 1 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:281
22	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:414
21	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:349
20	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:140
19	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:81
18	plgSystemFalangdriver->buildRule()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/cms/router/router.php:638
16	JRouter->processBuildRules()	JROOT/libraries/cms/router/site.php:622
15	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:614
14	JRouter->_processBuildRules()	JROOT/libraries/cms/router/router.php:270
13	JRouter->build()	JROOT/libraries/cms/router/site.php:147
12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
11	JRoute::_()	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:49

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

Query Time: 2.29 ms After last query: 0.94 ms Query memory: 0.019 MB Memory before query: 5.597 MB Rows returned: 0

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

  FROM `hf05s_contentitem_tag_map` AS m 

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

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

Explain

EXPLAIN not possible on query: SELECT `m`.`tag_id`,`t`.* FROM `hf05s_contentitem_tag_map` AS m INNER JOIN `hf05s_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 45 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:49

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

Query Time: 0.17 ms After last query: 7.44 ms Query memory: 0.015 MB Memory before query: 5.762 MB Rows returned: 1

SELECT language,id

  FROM `hf05s_menu`

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

Explain

EXPLAIN not possible on query: SELECT language,id FROM `hf05s_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
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/multilang.php:121
9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	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:49

[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.32 ms Query memory: 0.019 MB Memory before query: 5.785 MB Rows returned: 5

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

  FROM hf05s_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(101)
   
  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
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:276
13	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
12	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
11	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:332
10	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	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:49

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

Query Time: 1.25 ms After last query: 1.07 ms Query memory: 0.016 MB Memory before query: 5.815 MB Rows returned: 0

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

  FROM `hf05s_menu` AS `c`

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

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

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

  WHERE c.id = 136

Explain

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

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/language/associations.php:101
10	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:714
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	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:49

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

Query Time: 0.96 ms After last query: 1.08 ms Query memory: 0.017 MB Memory before query: 5.840 MB Rows returned: 0

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

  FROM `hf05s_content` AS `c`

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

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

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

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

  WHERE c.id = 45

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 `hf05s_content` AS `c` INNER JOIN `hf05s_associations` AS `a` ON a.id = c.`id` AND a.context='com_content.item' INNER JOIN `hf05s_associations` AS `a2` ON a.key = a2.key INNER JOIN `hf05s_content` AS `c2` ON a2.id = c2.`id` INNER JOIN `hf05s_categories` AS `ca` ON `c2`.`catid` = ca.id AND ca.extension = 'com_content' WHERE c.id = 45

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:281
12	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
11	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:43
10	ContentHelperAssociation::getAssociations()	Same as call in the line below.
9	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:729
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	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:49

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

Query Time: 5.58 ms After last query: 3.50 ms Query memory: 0.020 MB Memory before query: 5.924 MB Rows returned: 8

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

  FROM hf05s_modules AS m

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

  LEFT JOIN hf05s_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 <= '2020-02-27 23:53:59') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-02-27 23:53:59') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 136 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM hf05s_modules AS m LEFT JOIN hf05s_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN hf05s_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 <= '2020-02-27 23:53:59') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-02-27 23:53:59') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 136 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
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()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:514
8	JDocumentHtml->countModules()	JROOT/templates/mytemplate/index.php:2
7	require JROOT/templates/mytemplate/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:49

[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.52 ms Query memory: 0.024 MB Memory before query: 5.979 MB Rows returned: 13

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

  FROM hf05s_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(95,96,100,87,88,99,89,102)
   
  AND falang_content.reference_table='modules'

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()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:514
8	JDocumentHtml->countModules()	JROOT/templates/mytemplate/index.php:2
7	require JROOT/templates/mytemplate/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:49

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

Query Time: 1.40 ms After last query: 20.82 ms Query memory: 0.035 MB Memory before query: 6.223 MB Rows returned: 140

SHOW FULL COLUMNS 
  FROM `hf05s_jshopping_config`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
29	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:281
27	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
25	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
24	JTable->__construct()	JROOT/components/com_jshopping/tables/config.php:14
23	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
22	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
21	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
20	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1560
19	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
18	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_menu/helper.php:118
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:199
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:49

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

Query Time: 0.24 ms After last query: 2.35 ms Query memory: 0.036 MB Memory before query: 6.684 MB Rows returned: 1

SELECT *

  FROM hf05s_jshopping_config

  WHERE `id` = '1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
29	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:281
27	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:414
26	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:349
25	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:432
24	JFalangDatabase->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
23	JTable->load()	JROOT/components/com_jshopping/lib/factory.php:30
22	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
21	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
20	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1560
19	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
18	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_menu/helper.php:118
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:199
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:49

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

Query Time: 0.62 ms After last query: 1.89 ms Query memory: 0.040 MB Memory before query: 6.704 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `hf05s_jshopping_currencies`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
34	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:281
31	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
30	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
29	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
28	JTable->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
27	jshopCurrency->__construct()	JROOT/libraries/joomla/table/table.php:308
26	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
25	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:548
24	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
23	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
22	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
21	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
20	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1560
19	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
18	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_menu/helper.php:118
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:199
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:49

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

Query Time: 0.13 ms After last query: 0.30 ms Query memory: 0.034 MB Memory before query: 6.761 MB Rows returned: 1

SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `hf05s_jshopping_currencies` 
  WHERE currency_publish = '1' 
  ORDER BY currency_ordering

Explain

EXPLAIN not possible on query: SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `hf05s_jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering

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:281
26	JFalangDatabase->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
25	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:549
24	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
23	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
22	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
21	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
20	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1560
19	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
18	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_menu/helper.php:118
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:199
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:49

[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.40 ms Query memory: 0.030 MB Memory before query: 6.761 MB Rows returned: 1

select id,link 
  from hf05s_menu 
			          
  where `type`='component' 
  and published=1 
  and link like '%option=com_jshopping%' 
  and client_id=0 
					  
  and (language='*' or language='en-GB') 
  and access IN (1,1,5)

Explain

EXPLAIN not possible on query: select id,link from hf05s_menu where `type`='component' and published=1 and link like '%option=com_jshopping%' and client_id=0 and (language='*' or language='en-GB') and access IN (1,1,5)

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/components/com_jshopping/lib/shop_item_menu.php:136
21	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:46
20	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:39
19	shopItemMenu::getInstance()	JROOT/components/com_jshopping/router.php:15
18	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_menu/helper.php:118
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:199
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:49

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

Query Time: 0.16 ms After last query: 0.38 ms Query memory: 0.033 MB Memory before query: 6.799 MB Rows returned: 5

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

  FROM hf05s_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(148)
   
  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
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:100
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:276
25	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
24	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
23	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:332
22	JFalangDatabase->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:136
21	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:46
20	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:39
19	shopItemMenu::getInstance()	JROOT/components/com_jshopping/router.php:15
18	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_menu/helper.php:118
11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:199
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:49

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

Query Time: 1.19 ms After last query: 52.12 ms Query memory: 0.022 MB Memory before query: 6.989 MB Rows returned: 0

SELECT fc.value

  FROM hf05s_falang_content fc

  WHERE fc.reference_id = 136 
  AND fc.language_id = 2 
  AND fc.reference_field = 'path' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

EXPLAIN not possible on query: SELECT fc.value FROM hf05s_falang_content fc WHERE fc.reference_id = 136 AND fc.language_id = 2 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'

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:414
14	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:349
13	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:140
12	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:303
11	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
10	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/cms/module/helper.php:199
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:49

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

Query Time: 0.36 ms After last query: 0.38 ms Query memory: 0.022 MB Memory before query: 7.010 MB Rows returned: 1

Duplicate queries: #42

SELECT m.path

  FROM hf05s_menu m

  WHERE m.id = 136

Explain

EXPLAIN not possible on query: SELECT m.path FROM hf05s_menu m WHERE m.id = 136

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:414
14	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:349
13	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:140
12	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:312
11	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
10	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/cms/module/helper.php:199
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:49

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

Query Time: 0.69 ms After last query: 0.37 ms Query memory: 0.022 MB Memory before query: 7.035 MB Rows returned: 1

Duplicate queries: #43

SELECT fc.value

  FROM hf05s_falang_content fc

  WHERE fc.reference_id = 136 
  AND fc.language_id = 1 
  AND fc.reference_field = 'path' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

EXPLAIN not possible on query: SELECT fc.value FROM hf05s_falang_content fc WHERE fc.reference_id = 136 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'

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:414
14	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:349
13	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:140
12	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:328
11	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
10	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/cms/module/helper.php:199
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:49

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

Query Time: 0.69 ms After last query: 1.17 ms Query memory: 0.022 MB Memory before query: 7.058 MB Rows returned: 1

SELECT fc.value

  FROM hf05s_falang_content fc

  WHERE fc.reference_id = 136 
  AND fc.language_id = 4 
  AND fc.reference_field = 'path' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

EXPLAIN not possible on query: SELECT fc.value FROM hf05s_falang_content fc WHERE fc.reference_id = 136 AND fc.language_id = 4 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'

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:414
14	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:349
13	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:140
12	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:303
11	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
10	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/cms/module/helper.php:199
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:49

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

Query Time: 0.16 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 7.080 MB Rows returned: 1

Duplicate queries: #39

SELECT m.path

  FROM hf05s_menu m

  WHERE m.id = 136

Explain

EXPLAIN not possible on query: SELECT m.path FROM hf05s_menu m WHERE m.id = 136

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:414
14	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:349
13	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:140
12	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:312
11	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
10	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/cms/module/helper.php:199
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:49

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

Query Time: 0.11 ms After last query: 0.36 ms Query memory: 0.022 MB Memory before query: 7.105 MB Rows returned: 1

Duplicate queries: #40

SELECT fc.value

  FROM hf05s_falang_content fc

  WHERE fc.reference_id = 136 
  AND fc.language_id = 1 
  AND fc.reference_field = 'path' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

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:414
14	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:349
13	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:140
12	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:328
11	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
10	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/cms/module/helper.php:199
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:49

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

30 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

9 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value  
  FROM hf05s_falang_content AS falang_content

5 × SELECT fc.value 
  FROM hf05s_falang_content fc

2 × SELECT m.path 
  FROM hf05s_menu m

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `hf05s_menu` AS `c` 
  INNER JOIN `hf05s_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `hf05s_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `hf05s_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT language,id 
  FROM `hf05s_menu`

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

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

1 × SELECT * 
  FROM hf05s_jshopping_config

```
1 × select id,link 
  from hf05s_menu
```

1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `hf05s_jshopping_currencies`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM hf05s_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM hf05s_categories AS cat JOIN hf05s_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM hf05s_modules AS m 
  LEFT JOIN hf05s_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN hf05s_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 hf05s_content AS a 
  LEFT JOIN hf05s_categories AS c 
  on c.id = a.catid 
  LEFT JOIN hf05s_users AS u 
  on u.id = a.created_by 
  LEFT JOIN hf05s_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN hf05s_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM hf05s_categories AS cat JOIN hf05s_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT id, home, template, s.params 
  FROM hf05s_template_styles as s 
  LEFT JOIN hf05s_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 `hf05s_extensions`

```
1 × SELECT * 
  FROM hf05s_languages
```

1 × SELECT joomlatablename,tablepkID 
  FROM `hf05s_falang_tableinfo

```
1 × SELECT * 
  FROM hf05s_assets
```

1 × SELECT a.rules 
  FROM hf05s_assets AS a

```
1 × SELECT * 
  FROM hf05s_content
```

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

1 × SELECT element 
  FROM hf05s_extensions

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 hf05s_menu AS m 
  LEFT JOIN hf05s_extensions AS e 
  ON m.component_id = e.extension_id

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `hf05s_jshopping_config

1 × SHOW FULL COLUMNS 
  FROM `hf05s_jshopping_currencies

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

1 × SHOW FULL COLUMNS 
  FROM `hf05s_content

1 × UPDATE `hf05s_extensions` 
  SET `params` = '{\"mediaversion\":\"27b24b0c3d8e114966abbce922a03320\"}'

1 × SHOW FULL COLUMNS 
  FROM `hf05s_assets

1 × SHOW FULL COLUMNS 
  FROM `hf05s_languages

video material

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

44 Queries Logged 41.12 ms

8 duplicate found!

30 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: