Contract Solutions - Metallaser

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1722067089,
                "last": 1722067089,
                "now": 1722067089
            },
            "token": "Arke5ROph7I2p7I0yKedwT5UQdjQ763w"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Profile Information

Time

Memory

Time: 34.52 ms / 34.52 ms Memory: 0.571 MB / 0.92 MB Application: afterLoad

Time: 342.76 ms / 377.28 ms Memory: 1.617 MB / 2.53 MB Application: afterInitialise

Time: 56.55 ms / 433.83 ms Memory: 0.553 MB / 3.09 MB Application: afterRoute

Time: 7.53 ms / 441.36 ms Memory: 0.076 MB / 3.16 MB Application: beforeRenderComponent com_content

Time: 6.80 ms / 448.16 ms Memory: 0.152 MB / 3.31 MB Application: Before Access::preloadComponents (all components)

Time: 2.80 ms / 450.96 ms Memory: 0.064 MB / 3.38 MB Application: After Access::preloadComponents (all components)

Time: 0.06 ms / 451.02 ms Memory: 0.000 MB / 3.38 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.87 ms / 451.89 ms Memory: 0.009 MB / 3.38 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 29.86 ms / 481.75 ms Memory: 0.160 MB / 3.54 MB Application: afterRenderComponent com_content

Time: 28.51 ms / 510.25 ms Memory: 0.062 MB / 3.61 MB Application: afterDispatch

Time: 21.65 ms / 531.90 ms Memory: 0.142 MB / 3.75 MB Application: beforeRenderModule mod_custom (Footer)

Time: 1.02 ms / 532.91 ms Memory: 0.007 MB / 3.75 MB Application: afterRenderModule mod_custom (Footer)

Time: 13.50 ms / 546.41 ms Memory: 0.000 MB / 3.75 MB Application: beforeRenderModule mod_custom (Contacts)

Time: 0.67 ms / 547.08 ms Memory: 0.003 MB / 3.76 MB Application: afterRenderModule mod_custom (Contacts)

Time: 1.78 ms / 548.86 ms Memory: 0.000 MB / 3.76 MB Application: beforeRenderModule mod_custom (Social - Bottom)

Time: 0.54 ms / 549.40 ms Memory: 0.004 MB / 3.76 MB Application: afterRenderModule mod_custom (Social - Bottom)

Time: 1.17 ms / 550.57 ms Memory: 0.046 MB / 3.81 MB Application: beforeRenderModule mod_news_pro_gk5 (Materials and emotions)

Time: 78.84 ms / 629.41 ms Memory: 0.680 MB / 4.49 MB Application: afterRenderModule mod_news_pro_gk5 (Materials and emotions)

Time: 1.47 ms / 630.89 ms Memory: 0.000 MB / 4.38 MB Application: beforeRenderModule mod_eventgallery_event (Achievements)

Time: 49.22 ms / 680.11 ms Memory: 0.179 MB / 4.55 MB Application: afterRenderModule mod_eventgallery_event (Achievements)

Time: 1.83 ms / 681.94 ms Memory: 0.015 MB / 4.57 MB Application: beforeRenderModule mod_custom (Referenze)

Time: 4.45 ms / 686.39 ms Memory: 0.034 MB / 4.60 MB Application: afterRenderModule mod_custom (Referenze)

Time: 1.26 ms / 687.65 ms Memory: 0.000 MB / 4.60 MB Application: beforeRenderModule mod_custom (Slogan BOTTOM)

Time: 0.53 ms / 688.18 ms Memory: 0.004 MB / 4.61 MB Application: afterRenderModule mod_custom (Slogan BOTTOM)

Time: 0.93 ms / 689.11 ms Memory: 0.000 MB / 4.61 MB Application: beforeRenderModule mod_custom (Servizi - CONTRACT Solutions)

Time: 0.58 ms / 689.69 ms Memory: 0.003 MB / 4.61 MB Application: afterRenderModule mod_custom (Servizi - CONTRACT Solutions)

Time: 0.91 ms / 690.60 ms Memory: 0.001 MB / 4.61 MB Application: beforeRenderModule mod_custom (Slogan TOP)

Time: 0.59 ms / 691.19 ms Memory: 0.004 MB / 4.61 MB Application: afterRenderModule mod_custom (Slogan TOP)

Time: 0.95 ms / 692.14 ms Memory: 0.000 MB / 4.61 MB Application: beforeRenderModule mod_custom (Company)

Time: 0.82 ms / 692.97 ms Memory: 0.004 MB / 4.62 MB Application: afterRenderModule mod_custom (Company)

Time: 0.92 ms / 693.89 ms Memory: 0.002 MB / 4.62 MB Application: beforeRenderModule mod_custom (Video Contract Solutions)

Time: 0.59 ms / 694.48 ms Memory: 0.004 MB / 4.62 MB Application: afterRenderModule mod_custom (Video Contract Solutions)

Time: 1.06 ms / 695.54 ms Memory: 0.005 MB / 4.63 MB Application: beforeRenderModule mod_falang (Lingua)

Time: 15.62 ms / 711.16 ms Memory: 0.234 MB / 4.86 MB Application: afterRenderModule mod_falang (Lingua)

Time: 1.21 ms / 712.37 ms Memory: 0.000 MB / 4.86 MB Application: beforeRenderModule mod_custom (Logo - HOME PAGE CONTRACT)

Time: 0.78 ms / 713.15 ms Memory: 0.004 MB / 4.86 MB Application: afterRenderModule mod_custom (Logo - HOME PAGE CONTRACT)

Time: 1.07 ms / 714.22 ms Memory: 0.003 MB / 4.86 MB Application: beforeRenderModule mod_menu (Menu Principale)

Time: 5.75 ms / 719.97 ms Memory: 0.090 MB / 4.95 MB Application: afterRenderModule mod_menu (Menu Principale)

Time: 12.51 ms / 732.48 ms Memory: 0.474 MB / 5.43 MB Application: afterRender

Database queries total: 113.89 ms

Memory Usage

Database Queries

46 Queries Logged 113.89 ms

12 duplicate found!

2 duplicates: #20 #22

6 duplicates: #26 #28 #30 #32 #34 #36

2 duplicates: #40 #43

2 duplicates: #41 #44

Query Time: 0.94 ms Query memory: 0.050 MB Memory before query: 2.921 MB Rows returned: 16

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 l3yfr_menu AS m

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	17	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.m.component_id	1	Using where

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:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 2.89 ms Query memory: 0.034 MB Memory before query: 2.993 MB Rows returned: 10

SELECT joomlatablename,tablepkID 
  FROM `l3yfr_falang_tableinfo`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l3yfr_falang_tableinfo	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	10

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144
22	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57
21	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
20	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
19	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.19 ms Query memory: 0.038 MB Memory before query: 3.010 MB Rows returned: 3

SELECT * 
  FROM l3yfr_languages 
  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l3yfr_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using filesort

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319
22	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
21	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
20	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
19	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.11 ms After last query: 8.18 ms Query memory: 0.040 MB Memory before query: 3.042 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `l3yfr_languages`

Explain

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

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:105
29	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
27	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
24	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:54
23	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325
22	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
21	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
20	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
19	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.30 ms After last query: 1.65 ms Query memory: 0.036 MB Memory before query: 3.096 MB Rows returned: 24

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

  FROM l3yfr_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(101,102,103,104,105,106,107,108,109,110,111,112,113,114,123,124)
   
  AND falang_content.reference_table='menu'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	falang_content	index_merge	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id,reference_table	4,302	NULL	23	Using intersect(language_id,reference_table); Using where

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
21	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
20	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
19	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.68 ms After last query: 2.51 ms Query memory: 0.007 MB Memory before query: 3.091 MB

UPDATE `l3yfr_extensions`

  SET `params` = '{\"mediaversion\":\"76314b2d13967d7ebe095ed73dab0749\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `l3yfr_extensions` SET `params` = '{\"mediaversion\":\"76314b2d13967d7ebe095ed73dab0749\"}' 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:105
10	JFalangDatabase->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 2.58 ms Query memory: 0.023 MB Memory before query: 3.139 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM l3yfr_template_styles as s

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	dbmetallaser.s.template,const	1	Using index condition; Using where

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:105
7	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
5	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.27 ms After last query: 8.48 ms Query memory: 0.038 MB Memory before query: 3.317 MB Rows returned: 39

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `l3yfr_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventgallery','com_falang','com_fields','com_finder','com_installer','com_jch_optimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l3yfr_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	166	Using where

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
14	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.11 ms After last query: 2.55 ms Query memory: 0.043 MB Memory before query: 3.428 MB Rows returned: 0

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

  FROM l3yfr_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-07-27 07:58:10') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-07-27 07:58:10') 
  AND a.language IN ('en-GB','*')

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid,idx_language	idx_featured_catid	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.modified_by	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	dbmetallaser.a.catid	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.id	1	Using where

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:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
13	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 2.71 ms Query memory: 0.031 MB Memory before query: 3.464 MB Rows returned: 1

SELECT COUNT(*)

  FROM l3yfr_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-07-27 07:58:10') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-07-27 07:58:10') 
  AND a.language IN ('en-GB','*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid,idx_language	idx_featured_catid	1	const	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	dbmetallaser.a.catid	1	Using where

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:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
16	JFalangDatabase->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 23.70 ms Query memory: 0.031 MB Memory before query: 3.550 MB Rows returned: 0

SELECT folder.*

  FROM `l3yfr_eventgallery_folder` AS folder

  LEFT JOIN `l3yfr_eventgallery_file` AS file 
  ON folder.folder = file.folder 
  and file.published=1 
  and file.ismainimage=0

  WHERE file.file IS NULL 
  AND folder.foldertypeid=1 OR folder.foldertypeid=2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	folder	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where
1	SIMPLE	file	ref	file,index_folder	index_folder	377	dbmetallaser.folder.folder	12	Using where

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:105
10	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
8	JFalangDatabase->loadObjectList()	JROOT/plugins/system/picasaupdater/picasaupdater.php:66
7	plgSystemPicasaupdater->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.87 ms After last query: 2.85 ms Query memory: 0.025 MB Memory before query: 3.561 MB Rows returned: 1

SELECT language,id

  FROM `l3yfr_menu`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l3yfr_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	54	Using where

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:105
11	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.19 ms After last query: 0.34 ms Query memory: 0.028 MB Memory before query: 3.574 MB Rows returned: 0

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

  FROM l3yfr_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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	reference_id	4	const	1	Using where

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:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
12	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
11	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.49 ms After last query: 1.53 ms Query memory: 0.026 MB Memory before query: 3.588 MB Rows returned: 0

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

  FROM `l3yfr_menu` AS `c`

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

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

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

  WHERE c.id = 112

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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:105
12	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 7.93 ms After last query: 9.02 ms Query memory: 0.058 MB Memory before query: 3.652 MB Rows returned: 14

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

  FROM l3yfr_modules AS m

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

  LEFT JOIN l3yfr_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 <= '2024-07-27 07:58:10') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 07:58:10') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 112 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	61	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	dbmetallaser.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	dbmetallaser.m.module,const	1	Using index condition; Using where

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:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/metallaser/layout.php:32
8	include JROOT/templates/metallaser/layout.php	JROOT/templates/metallaser/index.php:91
7	require JROOT/templates/metallaser/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.54 ms After last query: 0.54 ms Query memory: 0.046 MB Memory before query: 3.721 MB Rows returned: 22

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

  FROM l3yfr_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(94,152,114,137,138,139,140,142,149,151,92,93,1,146)
   
  AND falang_content.reference_table='modules'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	falang_content	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	20	Using index condition; Using where

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:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
18	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
17	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
16	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
15	JFalangDatabase->loadObjectList()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/metallaser/layout.php:32
8	include JROOT/templates/metallaser/layout.php	JROOT/templates/metallaser/index.php:91
7	require JROOT/templates/metallaser/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.87 ms After last query: 28.99 ms Query memory: 0.031 MB Memory before query: 3.998 MB Rows returned: 6

SELECT 
					c.id AS CID
				
  FROM 
					l3yfr_categories AS c
				
  LEFT JOIN 
					l3yfr_content AS content 
					
  ON 
					c.id = content.catid 
						
				
  WHERE 
					1=1 
					 
  AND ( c.id = 13) 
					
  AND 
					c.extension = 'com_content' 
  AND 
					c.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
1	SIMPLE	content	ref	idx_catid	idx_catid	4	const	6	Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:85
15	NSP_GK5_com_content_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:100
14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 0.44 ms Query memory: 0.032 MB Memory before query: 4.013 MB Rows returned: 0

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

  FROM l3yfr_falang_content AS falang_content

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	const,const,const	1	Using index condition; Using where

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:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
19	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
18	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
17	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
16	JFalangDatabase->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:85
15	NSP_GK5_com_content_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:100
14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 0.31 ms Query memory: 0.031 MB Memory before query: 4.025 MB Rows returned: 6

SELECT
			content.id AS iid				
		
  FROM 
			l3yfr_content AS content
			 
			 
			
		
  WHERE 
			content.state = 1
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2024-07-27 07:58:10' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-07-27 07:58:10' )
			 
  AND (  content.catid = 13 ) 
			 
  AND content.language in ('en-GB','*') 
			 
			
			
			
		
		
		
  ORDER BY 
			 content.created ASC 
		
  LIMIT
			0,36;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	6	Using where; Using filesort

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:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
16	JFalangDatabase->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:268
15	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.84 ms After last query: 0.27 ms Query memory: 0.038 MB Memory before query: 4.043 MB Rows returned: 42

Duplicate queries: #22

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

  FROM l3yfr_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(22,23,24,25,26,29)
   
  AND falang_content.reference_table='content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	falang_content	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	30	Using index condition; Using where

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:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
20	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
19	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
18	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
16	JFalangDatabase->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:268
15	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.21 ms After last query: 0.30 ms Query memory: 0.037 MB Memory before query: 4.060 MB Rows returned: 6

SELECT
			content.id AS iid,
			content.title AS title, 
			content.introtext AS text,
			content.created AS date,  
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.images AS images,
			content.featured AS frontpage,
			content.access AS access,
			content.language AS lang,
			categories.title AS catname, 
			users.email AS author_email,
			content.created_by_alias AS author_alias,
			users.name AS author_username,
			content_rating.rating_sum AS rating_sum,
			content_rating.rating_count AS rating_count,
			
  CASE WHEN CHAR_LENGTH(content.alias) 
				THEN CONCAT_WS(":", content.id, content.alias) 
					ELSE content.id END as id, 
			
  CASE WHEN CHAR_LENGTH(categories.alias) 
				THEN CONCAT_WS(":", categories.id, categories.alias) 
					ELSE categories.id END as cid			
		
  FROM 
			l3yfr_content AS content 
			
  LEFT JOIN 
				l3yfr_categories AS categories 
				
  ON categories.id = content.catid 
			
  LEFT JOIN 
				l3yfr_users AS users 
				
  ON users.id = content.created_by 			
			
  LEFT JOIN 
				l3yfr_content_rating AS content_rating 
				
  ON content_rating.content_id = content.id
			
  LEFT JOIN 
				l3yfr_content_frontpage AS content_frontpage 
				
  ON content_frontpage.content_id = content.id
		
  WHERE 
			1=1
			 
  AND ( content.id = 22 OR  content.id = 23 OR  content.id = 24 OR  content.id = 25 OR  content.id = 26 OR  content.id = 29)
		
  ORDER BY 
			 content.created ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	range	PRIMARY	PRIMARY	4	NULL	6	Using where; Using filesort
1	SIMPLE	categories	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.content.catid	1	Using where
1	SIMPLE	users	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.content.created_by	1	Using where
1	SIMPLE	content_rating	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.content.id	1	Using where

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:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
16	JFalangDatabase->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:332
15	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.49 ms After last query: 0.36 ms Query memory: 0.038 MB Memory before query: 4.101 MB Rows returned: 42

Duplicate queries: #20

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

  FROM l3yfr_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(22,23,24,25,26,29)
   
  AND falang_content.reference_table='content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	falang_content	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	30	Using index condition; Using where

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:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
20	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
19	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
18	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
16	JFalangDatabase->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:332
15	NSP_GK5_com_content_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:114
14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.39 ms After last query: 2.80 ms Query memory: 0.050 MB Memory before query: 4.115 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 `l3yfr_categories` AS `s`

  INNER JOIN `l3yfr_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('en-GB','*')) OR (c.lft <= s.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 s.id = 13

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	12	Using where; Using filesort

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
30	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
29	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
28	ContentRouter->getCategorySegment()	Same as call in the line below.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.72 ms After last query: 0.62 ms Query memory: 0.041 MB Memory before query: 4.155 MB Rows returned: 0

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

  FROM l3yfr_falang_content AS falang_content

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	falang_content	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	2	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
36	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
35	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
34	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
33	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
32	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
31	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
30	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
29	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
28	ContentRouter->getCategorySegment()	Same as call in the line below.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.68 ms After last query: 0.74 ms Query memory: 0.039 MB Memory before query: 4.242 MB Rows returned: 1

SELECT fc.value

  FROM l3yfr_falang_content fc

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	idxFalang1	608	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:107
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.04 ms After last query: 0.28 ms Query memory: 0.039 MB Memory before query: 4.248 MB Rows returned: 0

Duplicate queries: #28 #30 #32 #34 #36

SELECT fc.value

  FROM l3yfr_falang_content fc

  WHERE fc.reference_id = 13 
  AND fc.language_id = 1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'categories'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:128
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.89 ms Query memory: 0.039 MB Memory before query: 4.272 MB Rows returned: 1

SELECT fc.value

  FROM l3yfr_falang_content fc

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	idxFalang1	608	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:107
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.90 ms After last query: 0.77 ms Query memory: 0.039 MB Memory before query: 4.294 MB Rows returned: 0

Duplicate queries: #26 #30 #32 #34 #36

SELECT fc.value

  FROM l3yfr_falang_content fc

  WHERE fc.reference_id = 13 
  AND fc.language_id = 1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'categories'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:128
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.32 ms After last query: 0.67 ms Query memory: 0.039 MB Memory before query: 4.317 MB Rows returned: 1

SELECT fc.value

  FROM l3yfr_falang_content fc

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	idxFalang1	608	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:107
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 13.60 ms After last query: 0.28 ms Query memory: 0.039 MB Memory before query: 4.339 MB Rows returned: 0

Duplicate queries: #26 #28 #32 #34 #36

SELECT fc.value

  FROM l3yfr_falang_content fc

  WHERE fc.reference_id = 13 
  AND fc.language_id = 1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'categories'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:128
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.14 ms After last query: 0.97 ms Query memory: 0.039 MB Memory before query: 4.362 MB Rows returned: 1

SELECT fc.value

  FROM l3yfr_falang_content fc

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	idxFalang1	608	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:107
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.27 ms Query memory: 0.039 MB Memory before query: 4.384 MB Rows returned: 0

Duplicate queries: #26 #28 #30 #34 #36

SELECT fc.value

  FROM l3yfr_falang_content fc

  WHERE fc.reference_id = 13 
  AND fc.language_id = 1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'categories'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:128
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.80 ms Query memory: 0.040 MB Memory before query: 4.413 MB Rows returned: 1

SELECT fc.value

  FROM l3yfr_falang_content fc

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	idxFalang1	608	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:107
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 27.19 ms After last query: 0.26 ms Query memory: 0.039 MB Memory before query: 4.437 MB Rows returned: 0

Duplicate queries: #26 #28 #30 #32 #36

SELECT fc.value

  FROM l3yfr_falang_content fc

  WHERE fc.reference_id = 13 
  AND fc.language_id = 1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'categories'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:128
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 1.10 ms Query memory: 0.039 MB Memory before query: 4.460 MB Rows returned: 1

SELECT fc.value

  FROM l3yfr_falang_content fc

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	idxFalang1	608	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:107
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.03 ms After last query: 0.25 ms Query memory: 0.039 MB Memory before query: 4.482 MB Rows returned: 0

Duplicate queries: #26 #28 #30 #32 #34

SELECT fc.value

  FROM l3yfr_falang_content fc

  WHERE fc.reference_id = 13 
  AND fc.language_id = 1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'categories'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	Using index condition; Using where

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:105
33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
30	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
29	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
28	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:128
27	plgSystemFalangdriver->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
18	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
17	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
16	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:36
15	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
14	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 5.02 ms Query memory: 0.032 MB Memory before query: 4.518 MB Rows returned: 1

SELECT `name`

  FROM `l3yfr_extensions`

  WHERE `type` = 'package' 
  AND `element` = 'pkg_eventgallery_full'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l3yfr_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

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:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
19	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
18	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
17	JFalangDatabase->loadResult()	JROOT/administrator/components/com_eventgallery/version.php:24
16	include_once JROOT/administrator/components/com_eventgallery/version.php	JROOT/components/com_eventgallery/helpers/medialoader.php:29
15	EventgalleryHelpersMedialoader::load()	JROOT/modules/mod_eventgallery_event/mod_eventgallery_event.php:25
14	EventgalleryModuleEvent->renderModule()	JROOT/modules/mod_eventgallery_event/mod_eventgallery_event.php:66
13	include JROOT/modules/mod_eventgallery_event/mod_eventgallery_event.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.65 ms After last query: 49.80 ms Query memory: 0.045 MB Memory before query: 4.604 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM l3yfr_fields AS a

  LEFT JOIN `l3yfr_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN l3yfr_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN l3yfr_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN l3yfr_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN l3yfr_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	dbmetallaser.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	dbmetallaser.a.group_id	1	Using where

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:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
25	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
17	JHtmlContent::prepare()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
13	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:598
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->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: 13.08 ms Query memory: 0.031 MB Memory before query: 4.665 MB Rows returned: 0

SELECT fc.value

  FROM l3yfr_falang_content fc

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref\|filter	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	reference_id\|language_id	4\|4	const	1 (0%)	Using where; Using rowid filter

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:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
15	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:342
14	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
13	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.23 ms Query memory: 0.031 MB Memory before query: 4.678 MB Rows returned: 1

Duplicate queries: #43

SELECT m.path

  FROM l3yfr_menu m

  WHERE m.id = 112

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
15	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:351
14	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
13	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 4.694 MB Rows returned: 0

Duplicate queries: #44

SELECT fc.value

  FROM l3yfr_falang_content fc

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref\|filter	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	reference_id\|reference_field	4\|302	const	1 (2%)	Using where; Using rowid filter

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:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
15	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:367
14	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
13	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.00 ms After last query: 0.81 ms Query memory: 0.031 MB Memory before query: 4.709 MB Rows returned: 0

SELECT fc.value

  FROM l3yfr_falang_content fc

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref\|filter	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	reference_id\|reference_field	4\|302	const	1 (2%)	Using where; Using rowid filter

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:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
15	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:342
14	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
13	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 4.722 MB Rows returned: 1

Duplicate queries: #40

SELECT m.path

  FROM l3yfr_menu m

  WHERE m.id = 112

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
15	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:351
14	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
13	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 4.738 MB Rows returned: 0

Duplicate queries: #41

SELECT fc.value

  FROM l3yfr_falang_content fc

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fc	ref\|filter	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	reference_id\|reference_field	4\|302	const	1 (2%)	Using where; Using rowid filter

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:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
15	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:367
14	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
13	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:620
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 22.71 ms Query memory: 0.045 MB Memory before query: 5.074 MB Rows returned: 140

SELECT * 
  FROM l3yfr_acymailing_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l3yfr_acymailing_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	140

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:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:464
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:803
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

23 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

16 × SELECT fc.value 
  FROM l3yfr_falang_content fc

7 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value  
  FROM l3yfr_falang_content AS falang_content

2 × SELECT m.path 
  FROM l3yfr_menu m

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

1 × SELECT       c.id AS CID     
  FROM       l3yfr_categories AS c     
  LEFT JOIN       l3yfr_content AS content       
  ON       c.id = content.catid

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM l3yfr_fields AS a 
  LEFT JOIN `l3yfr_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN l3yfr_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN l3yfr_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN l3yfr_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN l3yfr_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT `name` 
  FROM `l3yfr_extensions`

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 `l3yfr_categories` AS `s` 
  INNER JOIN `l3yfr_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

1 × SELECT    content.id AS iid,    content.title AS title,     content.introtext AS text,    content.created AS date,      content.publish_up AS date_publish,    content.hits AS hits,    content.images AS images,    content.featured AS frontpage,    content.access AS access,    content.language AS lang,    categories.title AS catname,     users.email AS author_email,    content.created_by_alias AS author_alias,    users.name AS author_username,    content_rating.rating_sum AS rating_sum,    content_rating.rating_count AS rating_count,    
  CASE WHEN CHAR_LENGTH(content.alias)      THEN CONCAT_WS(":", content.id, content.alias)       ELSE content.id END as id,     
  CASE WHEN CHAR_LENGTH(categories.alias)      THEN CONCAT_WS(":", categories.id, categories.alias)       ELSE categories.id END as cid      
  FROM     l3yfr_content AS content     
  LEFT JOIN      l3yfr_categories AS categories      
  ON categories.id = content.catid     
  LEFT JOIN      l3yfr_users AS users      
  ON users.id = content.created_by        
  LEFT JOIN      l3yfr_content_rating AS content_rating      
  ON content_rating.content_id = content.id    
  LEFT JOIN      l3yfr_content_frontpage AS content_frontpage      
  ON content_frontpage.content_id = content.id

1 × SELECT    content.id AS iid       
  FROM     l3yfr_content AS content

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

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM l3yfr_modules AS m 
  LEFT JOIN l3yfr_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN l3yfr_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT joomlatablename,tablepkID 
  FROM `l3yfr_falang_tableinfo

1 × SELECT language,id 
  FROM `l3yfr_menu`

1 × SELECT folder.* 
  FROM `l3yfr_eventgallery_folder` AS folder 
  LEFT JOIN `l3yfr_eventgallery_file` AS file 
  ON folder.folder = file.folder 
  and file.published=1 
  and file.ismainimage=0

1 × SELECT COUNT(*) 
  FROM l3yfr_content AS a 
  LEFT JOIN l3yfr_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN l3yfr_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN l3yfr_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN l3yfr_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN l3yfr_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM l3yfr_content AS a 
  LEFT JOIN l3yfr_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN l3yfr_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN l3yfr_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN l3yfr_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN l3yfr_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `l3yfr_assets`

1 × SELECT id, home, template, s.params 
  FROM l3yfr_template_styles as s 
  LEFT JOIN l3yfr_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM l3yfr_languages
```

1 × SELECT * 
  FROM l3yfr_acymailing_confi

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `l3yfr_languages

1 × UPDATE `l3yfr_extensions` 
  SET `params` = '{\"mediaversion\":\"76314b2d13967d7ebe095ed73dab0749\"}'

Emozione

Ricerca dei Materiali

Funzionalità

Unico referente

Design

Tecnologia Avanguardia

Company

We anticipate your imagination to exceed your expectations.

DESIGNING

RESEARCH AND DEVELOPMENT

INNOVATION

Above all, emotion and functionality.

Materials and emotions

Steel flexibility

Refinement of marble

Elegance of Shapes

Cement Solidity

Wealth of treatments

The warmth of wood

Achievements

Contacts

Metallaser

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

46 Queries Logged 113.89 ms

12 duplicate found!

23 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Emozione

Ricerca dei Materiali

Funzionalità

Unico referente

Design

Tecnologia Avanguardia

Company

We anticipate your imagination to exceed your expectations.

DESIGNING

RESEARCH AND DEVELOPMENT

INNOVATION

Above all, emotion and functionality.

Materials and emotions

Steel flexibility

Refinement of marble

Elegance of Shapes

Cement Solidity

Wealth of treatments

The warmth of wood

Achievements

Follow us on social

Contacts

Metallaser

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

46 Queries Logged 113.89 ms

12 duplicate found!

23 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: