CONSULTING offer

CONSULTING Offer

Consulting for General Management to define :

The common and shared vision of the current situation and the identification of the problems that are stopping/slowing the accomplishment of the performance objectives for the company
the short, medium and long term targets, coherent with the Resource strategy of the company (Budget, Humans, Techniques)
the «Road Map» (level Methodology, Organization and Management) resulting
the Evaluation and Measure System, to ensure the good application of the actions and react if necessary in case of drifts.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1770060921,
                "last": 1770060921,
                "now": 1770060921
            },
            "token": "cyNdikwfc1SQyf9GcflguUzwnnNwLsE8"
        },
        "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"
        }
    }
}

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

EXPLAIN not possible on query: Update jnew_contentbuilder_articles As articles, jnew_content As content, jnew_contentbuilder_forms As forms, jnew_contentbuilder_registered_users As cbusers, jnew_users As users Set content.state = 0 Where articles.article_id = content.id And content.state = 1 And articles.form_id = forms.id And forms.act_as_registration = 1 And forms.id = cbusers.form_id And content.created_by = cbusers.user_id And ( ( users.id = cbusers.user_id And users.block = 1 ) )

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/plugins/system/falangdriver/falang_database.php:124
10	JFalangDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:417
9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
8	plgSystemContentbuilder_system->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.38 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 3.198 MB

Update 
                        jnew_contentbuilder_articles As articles,
                        jnew_content As content, 
                        jnew_contentbuilder_forms As forms,
                        jnew_contentbuilder_records As records,
                        jnew_contentbuilder_registered_users As cbusers,
                        jnew_users As users
                    
  Set 
                        content.state = forms.auto_publish
                    
  Where 
                        articles.article_id = content.id
                    
  And
                        content.state = 0
                    
  And
                        articles.form_id = forms.id
                    
  And
                        forms.act_as_registration = 1
                    
  And
                        forms.id = cbusers.form_id
                    
  And
                        content.created_by = cbusers.user_id
                    
  And
                        users.id = cbusers.user_id
                    
  And
                        records.record_id = cbusers.record_id
                    
  And
                        records.`type` = forms.`type`
                    
  And
                        users.block = 0

Explain

EXPLAIN not possible on query: Update jnew_contentbuilder_articles As articles, jnew_content As content, jnew_contentbuilder_forms As forms, jnew_contentbuilder_records As records, jnew_contentbuilder_registered_users As cbusers, jnew_users As users Set content.state = forms.auto_publish Where articles.article_id = content.id And content.state = 0 And articles.form_id = forms.id And forms.act_as_registration = 1 And forms.id = cbusers.form_id And content.created_by = cbusers.user_id And users.id = cbusers.user_id And records.record_id = cbusers.record_id And records.`type` = forms.`type` And users.block = 0

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
11	JFalangDatabase->execute()	JROOT/plugins/system/falangdriver/falang_database.php:124
10	JFalangDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:450
9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
8	plgSystemContentbuilder_system->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 0.14 ms Query memory: 0.022 MB Memory before query: 3.218 MB Rows returned: 0

Select 
                    form.id As form_id,
                    form.act_as_registration,
                    form.default_category,
                    form.registration_name_field, 
                    form.registration_username_field, 
                    form.registration_email_field, 
                    form.registration_email_repeat_field, 
                    form.`last_update`,
                    article.`article_id`,
                    form.`title_field`,
                    form.`create_articles`,
                    form.`name`,
                    form.`use_view_name_as_title`,
                    form.`protect_upload_directory`,
                    form.`reference_id`,
                    records.`record_id`,
                    form.`type`,
                    form.`published_only`,
                    form.`own_only`,
                    form.`own_only_fe`,
                    records.`last_update` As record_last_update,
                    article.`last_update` As article_last_update
                
  From
                    jnew_contentbuilder_records As records
                    
  Left Join jnew_contentbuilder_forms As form 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id )
                    
  Left Join jnew_contentbuilder_articles As article 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )
                    
  Left Join jnew_content As content 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.article_id = content.id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )
                
  Where 
                    form.`published` = 1
                
  And
                    form.create_articles = 1
                
  And
                    form.`type` = records.`type`
                
  And 
                    form.reference_id = records.reference_id
                
  And
                   (
                     (
                        article.form_id = form.id 
                      
  And 
                        article.record_id = records.record_id
                      
  And 
                        article.article_id = content.id 
                      
  And 
                        ( content.state = 1 Or content.state = 0 )
                      
  And
                      (
                        form.`last_update` > article.`last_update`   
                       Or
                        records.`last_update` > article.`last_update`
                      )
                     )
                     Or
                     (
                        form.id Is Not Null 
  And records.id Is Not Null 
  And content.id Is Null 
  And article.id Is Null
                     )
                   )
                
  Limit 50

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	form	system	PRIMARY,reference_id	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	records	ref	PRIMARY,record_id,reference_id,type,type_2	reference_id	4	const	2	Using where
1	SIMPLE	article	ref	record_id,record_id_2	record_id_2	8	al_consulting_com.records.record_id	1	Using where
1	SIMPLE	content	eq_ref	PRIMARY	PRIMARY	4	al_consulting_com.article.article_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
10	JFalangDatabase->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:516
9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
8	plgSystemContentbuilder_system->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.23 ms After last query: 0.68 ms Query memory: 0.074 MB Memory before query: 3.252 MB Rows returned: 42

Duplicate queries: #15

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

  LEFT JOIN jnew_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	151	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	al_consulting_com.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
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.24 ms After last query: 0.49 ms Query memory: 0.029 MB Memory before query: 3.344 MB Rows returned: 13

SELECT joomlatablename,tablepkID 
  FROM `jnew_falang_tableinfo`

Explain

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

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:1701
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
27	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144
26	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57
25	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
24	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
23	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.23 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 3.358 MB Rows returned: 2

SELECT * 
  FROM jnew_languages 
  ORDER BY ordering

Explain

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

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:1701
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
27	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319
26	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
25	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
24	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
23	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.79 ms After last query: 0.19 ms Query memory: 0.033 MB Memory before query: 3.378 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `jnew_languages`

Explain

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

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:1701
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
31	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
30	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
29	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
28	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:54
27	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325
26	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
25	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
24	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
23	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.80 ms After last query: 0.36 ms Query memory: 0.028 MB Memory before query: 3.420 MB Rows returned: 0

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

  FROM jnew_falang_content AS falang_content

  WHERE falang_content.language_id=3
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(82,1220,1221,250,251,239,1231,644,537,538,240,1230,782,1232,263,55,60,136,42,173,41,43,45,56,64,48,21,57,65,58,66,157,73,95,96,102,98,99,118,183,159,23)
   
  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	jfContent,jfContentPublished,reference_id,language_id,reference_table,falangContent,falangContentLanguage,idxFalang1	language_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
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
25	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
24	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
23	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.39 ms After last query: 0.59 ms Query memory: 0.023 MB Memory before query: 3.557 MB Rows returned: 1

SELECT `params`

  FROM `jnew_extensions`

  WHERE `type` = 'component' 
  AND `element` = 'com_rsseo'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_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
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
11	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
10	JFalangDatabase->loadResult()	JROOT/administrator/components/com_rsseo/helpers/rsseo.php:25
9	rsseoHelper::getConfig()	JROOT/plugins/system/rsseo/rsseo.php:170
8	plgSystemRsseo->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.24 ms After last query: 0.30 ms Query memory: 0.021 MB Memory before query: 3.584 MB Rows returned: 0

SELECT *

  FROM `jnew_rsseo_redirects`

  WHERE `published` = 1

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
12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
11	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
9	JFalangDatabase->loadObjectList()	JROOT/plugins/system/rsseo/rsseo.php:187
8	plgSystemRsseo->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 304.84 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 3.589 MB Rows returned: 0

SELECT `url`,`sef`

  FROM `jnew_rsseo_pages`

  WHERE `short` = 'en/consulting.html?print=1&amp;tmpl=component'

Explain

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

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:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
9	JFalangDatabase->loadObject()	JROOT/plugins/system/rsseo/rsseo.php:240
8	plgSystemRsseo->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.73 ms After last query: 4.70 ms Query memory: 0.024 MB Memory before query: 3.753 MB Rows returned: 0

SELECT `url`

  FROM `jnew_rsseo_pages`

  WHERE `sef` = 'en/consulting.html?print=1&tmpl=component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_pages	ref	sef	sef	1002	const	1	Using where

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:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
12	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
11	JFalangDatabase->loadResult()	JROOT/components/com_rsseo/sef.php:92
10	RsseoSef->parseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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.55 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 3.760 MB Rows returned: 0

SELECT `url`

  FROM `jnew_rsseo_pages`

  WHERE `sef` = 'en/consulting'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_pages	ref	sef	sef	1002	const	1	Using where

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:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
12	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
11	JFalangDatabase->loadResult()	JROOT/components/com_rsseo/sef.php:102
10	RsseoSef->parseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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.17 ms After last query: 5.51 ms Query memory: 0.073 MB Memory before query: 4.675 MB Rows returned: 42

Duplicate queries: #5

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

  LEFT JOIN jnew_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	151	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	al_consulting_com.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:1701
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:78
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:370
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:597
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:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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.95 ms After last query: 0.48 ms Query memory: 0.029 MB Memory before query: 4.766 MB Rows returned: 34

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

  FROM jnew_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(82,1220,1221,250,251,239,1231,644,537,538,240,1230,782,1232,263,55,60,136,42,173,41,43,45,56,64,48,21,57,65,58,66,157,73,95,96,102,98,99,118,183,159,23)
   
  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	jfContent,jfContentPublished,reference_id,language_id,reference_table,falangContent,falangContentLanguage,idxFalang1	reference_table	302	const	62	Using index condition; 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:1701
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:78
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:370
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:597
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:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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.79 ms After last query: 0.89 ms Query memory: 0.022 MB Memory before query: 4.690 MB Rows returned: 0

SELECT *

  FROM jnew_rsfirewall_hashes

  WHERE (`type`='3.10.11' OR `type`='protect') 
  AND `flag`!='C'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsfirewall_hashes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	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:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
9	JFalangDatabase->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1068
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.24 ms After last query: 0.30 ms Query memory: 0.021 MB Memory before query: 4.686 MB Rows returned: 0

SELECT *

  FROM jnew_rsfirewall_snapshots

  WHERE `type`='protect'

Explain

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

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:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1091
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.25 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 4.693 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM jnew_rsfirewall_lists

  WHERE (`ip`='216.73.216.56' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsfirewall_lists	ref	published,type,ip	published	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:174
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:153
9	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1127
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.24 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 4.699 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM jnew_rsfirewall_lists

  WHERE (`ip`='216.73.216.56' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsfirewall_lists	ref	published,type,ip	published	1	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:174
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:143
9	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1131
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.25 ms After last query: 0.44 ms Query memory: 0.021 MB Memory before query: 4.768 MB Rows returned: 0

SELECT *

  FROM jnew_rsfirewall_exceptions

  WHERE `published`='1'

Explain

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

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:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:719
9	plgSystemRsfirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1262
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.35 ms After last query: 0.46 ms Query memory: 0.025 MB Memory before query: 4.792 MB Rows returned: 1

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

  FROM `jnew_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

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:1701
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/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/arktypography/arktypography.php:115
8	plgSystemARKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.60 ms After last query: 0.23 ms Query memory: 0.006 MB Memory before query: 4.786 MB

UPDATE `jnew_extensions`

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

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

Explain

EXPLAIN not possible on query: UPDATE `jnew_extensions` SET `params` = '{\"mediaversion\":\"c42104e2fc619917ddfe9b77e4545dd2\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/arktypography/arktypography.php:115
8	plgSystemARKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.27 ms After last query: 1.95 ms Query memory: 0.021 MB Memory before query: 4.811 MB Rows returned: 1

Select `type`, `reference_id` 
  From jnew_contentbuilder_forms 
  Where published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_contentbuilder_forms	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1

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:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
9	JFalangDatabase->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:236
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.18 ms Query memory: 0.022 MB Memory before query: 4.818 MB Rows returned: 1

Select * 
  From jnew_contentbuilder_storages 
  Where id = 1 
  And published = 1 
  Order By `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_contentbuilder_storages	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

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:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:26
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.36 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 4.825 MB Rows returned: 9

Select * 
  From jnew_contentbuilder_storage_fields 
  Where storage_id = 1 
  And published = 1 
  Order By `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_contentbuilder_storage_fields	ALL	storage_id	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where; Using filesort

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:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
11	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:32
10	contentbuilder_com_contentbuilder->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.47 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 4.838 MB Rows returned: 0

Select r.id
                
                
  From 
                
                jnew_projets As r
                
                
  Where r.id Not In (
                    Select record_id 
  From jnew_contentbuilder_records As cr 
  Where cr.`type` = 'com_contentbuilder' 
  And cr.reference_id = '1' 
  And cr.record_id = r.id
                )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	r	index	NULL	PRIMARY	4	NULL	2	Using where; Using index
2	DEPENDENT SUBQUERY	cr	ref	record_id,reference_id,type,type_2	record_id	8	al_consulting_com.r.id	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
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:178
10	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/types/com_contentbuilder.php:56
9	contentbuilder_com_contentbuilder->synchRecords()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:243
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.23 ms After last query: 0.21 ms Query memory: 0.005 MB Memory before query: 4.845 MB

Update jnew_contentbuilder_records 
  Set published = 1 
  Where is_future = 1 
  And publish_up <> '0000-00-00 00:00:00' 
  And publish_up <= '2026-02-02 19:35:21'

Explain

EXPLAIN not possible on query: Update jnew_contentbuilder_records Set published = 1 Where is_future = 1 And publish_up <> '0000-00-00 00:00:00' And publish_up <= '2026-02-02 19:35:21'

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/plugins/system/falangdriver/falang_database.php:124
9	JFalangDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:256
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.15 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 4.851 MB

Update jnew_contentbuilder_records 
  Set published = 0 
  Where publish_down <> '0000-00-00 00:00:00' 
  And publish_down <= '2026-02-02 19:35:21'

Explain

EXPLAIN not possible on query: Update jnew_contentbuilder_records Set published = 0 Where publish_down <> '0000-00-00 00:00:00' And publish_down <= '2026-02-02 19:35:21'

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/plugins/system/falangdriver/falang_database.php:124
9	JFalangDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:259
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.55 ms After last query: 0.36 ms Query memory: 0.041 MB Memory before query: 4.860 MB Rows returned: 7

SELECT id, home, template, s.params

  FROM jnew_template_styles as s

  LEFT JOIN jnew_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,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	10	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	al_consulting_com.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
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/jat3/jat3/core/common.php:88
13	T3Common::get_active_template()	JROOT/plugins/system/jat3/jat3/core/define.php:16
12	include_once JROOT/plugins/system/jat3/jat3/core/define.php	JROOT/plugins/system/jat3/jat3/core/common.php:31
11	t3import()	JROOT/plugins/system/jat3/jat3/core/framework.php:16
10	include_once JROOT/plugins/system/jat3/jat3/core/framework.php	JROOT/plugins/system/jat3/jat3/core/common.php:31
9	t3import()	JROOT/plugins/system/jat3/jat3.php:156
8	plgSystemJAT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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:225
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.97 ms After last query: 4.67 ms Query memory: 0.030 MB Memory before query: 4.975 MB Rows returned: 55

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

  FROM `jnew_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_allvideoshare','com_arkeditor','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contentbuilder','com_contenthistory','com_cpanel','com_eventbooking','com_falang','com_fields','com_finder','com_gdpr','com_icagenda','com_installer','com_jantivirus','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_obphplist','com_ose_firewall','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_rsfirewall','com_rsform','com_rsseo','com_search','com_sendinblue','com_tags','com_templates','com_users','com_visforms','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_assets	range	idx_asset_name	idx_asset_name	402	NULL	56	Using index condition

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:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.76 ms After last query: 0.39 ms Query memory: 0.040 MB Memory before query: 5.039 MB Rows returned: 185

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

  FROM `jnew_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	437	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:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.87 ms Query memory: 0.034 MB Memory before query: 5.223 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `jnew_content`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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: 9.65 ms After last query: 0.85 ms Query memory: 0.006 MB Memory before query: 5.336 MB

UPDATE jnew_content

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

  WHERE `id` = '93'

Explain

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

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/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.79 ms After last query: 0.68 ms Query memory: 0.040 MB Memory before query: 5.359 MB Rows returned: 1

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

  FROM jnew_content AS a

  INNER JOIN jnew_categories AS c 
  on c.id = a.catid

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

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

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

  WHERE a.id = 93 
  AND c.published > 0 
  AND a.language in ('en-GB','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-02 19:35:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-02 19:35:21') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

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:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.92 ms After last query: 0.38 ms Query memory: 0.025 MB Memory before query: 5.403 MB Rows returned: 4

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

  FROM jnew_falang_content AS falang_content

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	falang_content	ref	jfContent,jfContentPublished,reference_id,language_id,reference_table,falangContent,falangContentLanguage,idxFalang1	jfContent	310	const,const,const	4	Using index condition; 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:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
17	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
16	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
15	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.78 ms After last query: 0.29 ms Query memory: 0.025 MB Memory before query: 5.405 MB Rows returned: 0

Duplicate queries: #39

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

  FROM jnew_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(99)
   
  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\|filter	jfContent,jfContentPublished,reference_id,language_id,reference_table,falangContent,falangContentLanguage,idxFalang1	reference_table\|reference_id	302\|4	NULL	1 (0%)	Using index condition; Using where; Using rowid filter

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:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
17	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
16	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
15	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.16 ms Query memory: 0.025 MB Memory before query: 5.415 MB Rows returned: 0

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

  FROM jnew_falang_content AS falang_content

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	falang_content	ref	jfContent,jfContentPublished,reference_id,language_id,reference_table,falangContent,falangContentLanguage,idxFalang1	jfContent	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
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
17	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
16	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
15	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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: 0.14 ms Query memory: 0.025 MB Memory before query: 5.424 MB Rows returned: 0

Duplicate queries: #37

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

  FROM jnew_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(99)
   
  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\|filter	jfContent,jfContentPublished,reference_id,language_id,reference_table,falangContent,falangContentLanguage,idxFalang1	reference_table\|reference_id	302\|4	NULL	1 (0%)	Using index condition; Using where; Using rowid filter

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:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
17	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
16	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
15	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.89 ms After last query: 1.12 ms Query memory: 0.027 MB Memory before query: 5.447 MB Rows returned: 1

SELECT fc.value

  FROM jnew_falang_content fc

  WHERE fc.reference_id = 93 
  AND fc.language_id = 2 
  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	jfContent,jfContentPublished,reference_id,language_id,reference_table,reference_field,falangContent,falangContentLanguage,idxFalang1	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
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
22	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
21	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
20	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:110
19	plgSystemFalangdriver->buildRule()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
17	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
15	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.40 ms After last query: 0.61 ms Query memory: 0.028 MB Memory before query: 5.453 MB Rows returned: 1

SELECT `sef`

  FROM `jnew_rsseo_pages`

  WHERE `hash` = '9aa512c5d3f7bd6cbdfd18f7e93e4048' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_pages	ref	hash,hash_2	hash	130	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
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
24	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
23	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
22	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
21	JFalangDatabase->loadResult()	JROOT/components/com_rsseo/sef.php:25
20	RsseoSef->getSEF()	JROOT/components/com_rsseo/sef.php:41
19	RsseoSef->buildRule()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
17	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
15	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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: 0.38 ms Query memory: 0.023 MB Memory before query: 5.474 MB Rows returned: 0

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

  FROM `jnew_contentitem_tag_map` AS m 

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	al_consulting_com.m.tag_id	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:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.74 ms After last query: 2.15 ms Query memory: 0.028 MB Memory before query: 5.627 MB Rows returned: 3

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

  FROM `jnew_categories` AS `s`

  INNER JOIN `jnew_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) 
  AND c.published = 1 
  AND s.id = 99

  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	37	Using where; Using filesort

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:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.07 ms After last query: 0.35 ms Query memory: 0.027 MB Memory before query: 5.660 MB Rows returned: 0

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

  FROM jnew_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,99,89)
   
  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	jfContent,jfContentPublished,reference_id,language_id,reference_table,falangContent,falangContentLanguage,idxFalang1	reference_table	302	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
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
23	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
22	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
21	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
20	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.32 ms After last query: 0.33 ms Query memory: 0.026 MB Memory before query: 5.679 MB Rows returned: 0

SELECT DISTINCT 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 jnew_fields AS a

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

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

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

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

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

  LEFT JOIN `jnew_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (99,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  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 temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	al_consulting_com.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	al_consulting_com.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	al_consulting_com.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	al_consulting_com.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	al_consulting_com.a.id	1	Using where; Using index; Distinct

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:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.33 ms After last query: 1.30 ms Query memory: 0.025 MB Memory before query: 5.698 MB Rows returned: 0

Duplicate queries: #47

Select form.`title_field`,form.`protect_upload_directory`,form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From jnew_contentbuilder_articles As article, jnew_contentbuilder_forms As form 
  Where form.`published` = 1 
  And form.id = article.`form_id` 
  And article.`article_id` = '93'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	form	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	article	ref	article_id	article_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
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
14	JFalangDatabase->loadAssoc()	JROOT/plugins/content/contentbuilder_download/contentbuilder_download.php:212
13	plgContentContentbuilder_download->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.29 ms After last query: 0.32 ms Query memory: 0.025 MB Memory before query: 5.708 MB Rows returned: 0

Duplicate queries: #46

Select form.`title_field`,form.`protect_upload_directory`,form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From jnew_contentbuilder_articles As article, jnew_contentbuilder_forms As form 
  Where form.`published` = 1 
  And form.id = article.`form_id` 
  And article.`article_id` = '93'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	form	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	article	ref	article_id	article_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
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
14	JFalangDatabase->loadAssoc()	JROOT/plugins/content/contentbuilder_image_scale/contentbuilder_image_scale.php:172
13	plgContentContentbuilder_image_scale->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.24 ms After last query: 0.25 ms Query memory: 0.025 MB Memory before query: 5.722 MB Rows returned: 0

Select form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From jnew_contentbuilder_articles As article, jnew_contentbuilder_forms As form 
  Where form.`published` = 1 
  And form.id = article.`form_id` 
  And article.`article_id` = '93'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	form	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	article	ref	article_id	article_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
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
14	JFalangDatabase->loadAssoc()	JROOT/plugins/content/contentbuilder_permission_observer/contentbuilder_permission_observer.php:67
13	plgContentContentbuilder_permission_observer->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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.27 ms After last query: 0.49 ms Query memory: 0.025 MB Memory before query: 5.733 MB Rows returned: 0

Select form.rating_slots,form.`title_field`,form.`protect_upload_directory`,form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From jnew_contentbuilder_articles As article, jnew_contentbuilder_forms As form 
  Where form.`published` = 1 
  And form.id = article.`form_id` 
  And article.`article_id` = '93'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	form	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	article	ref	article_id	article_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
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
14	JFalangDatabase->loadAssoc()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:130
13	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
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: 2.91 ms Query memory: 0.021 MB Memory before query: 5.803 MB Rows returned: 0

SELECT id,placeholder

  FROM `jnew_gdpr_checkbox`

Explain

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

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:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
8	JFalangDatabase->loadObjectList()	JROOT/plugins/system/gdpr/gdpr.php:1190
7	plgSystemGdpr->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:225
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.46 ms After last query: 0.31 ms Query memory: 0.021 MB Memory before query: 5.810 MB Rows returned: 1

SELECT language,id

  FROM `jnew_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	jnew_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	314	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:1701
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:225
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: 0.23 ms Query memory: 0.022 MB Memory before query: 5.820 MB Rows returned: 2

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

  FROM jnew_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(82)
   
  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	jfContent,jfContentPublished,reference_id,language_id,reference_table,falangContent,falangContentLanguage,idxFalang1	jfContent	310	const,const,const	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
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:225
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: 23.13 ms After last query: 0.51 ms Query memory: 0.026 MB Memory before query: 5.829 MB Rows returned: 0

SELECT `sef`

  FROM `jnew_rsseo_pages`

  WHERE `hash` = 'd1b2b8e181ee98f8e4080b5372b8b2f0' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_pages	ref	hash,hash_2	hash	130	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
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/components/com_rsseo/sef.php:25
17	RsseoSef->getSEF()	JROOT/components/com_rsseo/sef.php:41
16	RsseoSef->buildRule()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
14	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
13	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
12	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:763
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:225
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: 25.35 ms After last query: 0.38 ms Query memory: 0.026 MB Memory before query: 5.837 MB Rows returned: 0

SELECT `sef`

  FROM `jnew_rsseo_pages`

  WHERE `hash` = 'da161761718e92d88f2242e5a4383e92' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_pages	ref	hash,hash_2	hash	130	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
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/components/com_rsseo/sef.php:25
17	RsseoSef->getSEF()	JROOT/components/com_rsseo/sef.php:45
16	RsseoSef->buildRule()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
14	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
13	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
12	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:763
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:225
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: 1.00 ms Query memory: 0.021 MB Memory before query: 5.862 MB Rows returned: 0

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

  FROM `jnew_content` AS `c`

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

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

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

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

  WHERE c.id = 93 
  AND c2.access IN (1,1) 
  AND c2.language != 'en-GB' 
  AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2026-02-02 19:35:21') 
  AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2026-02-02 19:35:21') 
  AND c2.state = 1

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:1701
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/components/com_content/helpers/association.php:76
8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
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:225
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.33 ms After last query: 0.97 ms Query memory: 0.022 MB Memory before query: 5.872 MB Rows returned: 1

SELECT `extension_id`,`params`

  FROM `jnew_extensions`

  WHERE `type` = 'component' 
  AND `element` = 'com_rsseo'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_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
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
10	JFalangDatabase->loadObject()	JROOT/administrator/components/com_rsseo/helpers/rsseo.php:55
9	rsseoHelper::updateConfig()	JROOT/plugins/system/rsseo/rsseo.php:1479
8	plgSystemRsseo->sitemap()	JROOT/plugins/system/rsseo/rsseo.php:90
7	plgSystemRsseo->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:225
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.36 ms After last query: 0.26 ms Query memory: 0.005 MB Memory before query: 5.902 MB

UPDATE `jnew_extensions`

  SET `params` = '{\"global_register_code\":\"01X0E0FLG8QS5PFRQ927\",\"global_dateformat\":\"d M y H:i\",\"load_jquery\":\"1\",\"log_errors\":\"1\",\"custom_errors\":\"0\",\"obfuscate_visitor_ip\":\"0\",\"enable_sef\":\"1\",\"robots_permissions\":\"644\",\"title_length\":\"50\",\"keywords_length\":\"10\",\"description_length\":\"150\",\"customhead\":\"\",\"google_domain\":\"google.com\",\"enable_age\":\"1\",\"enable_bingp\":\"1\",\"enable_bingb\":\"1\",\"enable_alexa\":\"1\",\"enable_moz\":\"1\",\"moz_access_id\":\"\",\"moz_secret\":\"\",\"analytics_enable\":\"0\",\"analytics_client_id\":\"\",\"analytics_secret\":\"\",\"ga_tracking\":\"0\",\"ga_type\":\"0\",\"ga_code\":\"\",\"ga_options\":\"\",\"request_timeout\":\"0\",\"crawler_type\":\"loopback\",\"crawler_enable_auto\":\"1\",\"crawler_save\":\"1\",\"crawler_nofollow\":\"0\",\"crawler_level\":\"3\",\"site_name_in_title\":\"0\",\"site_name_separator\":\"|\",\"crawler_sef\":\"1\",\"crawler_title_duplicate\":\"1\",\"crawler_title_length\":\"1\",\"crawler_description_duplicate\":\"1\",\"crawler_description_length\":\"1\",\"crawler_keywords\":\"1\",\"crawler_headings\":\"1\",\"crawler_images\":\"1\",\"crawler_images_alt\":\"1\",\"crawler_images_hw\":\"1\",\"crawler_intext_links\":\"1\",\"crawler_ignore\":\"{*}tmpl=component{*}\\r\\n{*}format=pdf{*}\\r\\n{*}format=feed{*}\\r\\n{*}output=pdf{*}\\r\\n{*}?gclid={*}\",\"exclude_noindex\":\"0\",\"sitemap_permissions\":\"644\",\"enable_sitemap_cron\":\"1\",\"sitemap_cron_type\":\"0\",\"sitemap_cron_security\":\"707cb49519002c0b36d6ae726aa02589\",\"sitemap_autocrawled\":\"2\",\"sitemap_autocrawled_rule\":\"\",\"enable_keyword_replace\":\"1\",\"approved_chars\":\",;:.?!$%*&()[]{} ><\",\"keyword_density_enable\":\"1\",\"copykeywords\":\"0\",\"overwritekeywords\":\"0\",\"accountID\":\"\",\"g_date_format\":\"d M Y\",\"eanble_k_cron\":\"0\",\"k_cron_run\":\"weekly\",\"proxy_enable\":\"0\",\"proxy_server\":\"\",\"proxy_port\":\"\",\"proxy_username\":\"\",\"proxy_password\":\"\",\"img_auto_alt\":\"0\",\"img_auto_alt_rule\":\"{name} {title}\",\"img_auto_title\":\"0\",\"img_auto_title_rule\":\"{name} image\",\"track_visitors\":\"1\",\"autodeletevisitors\":\"\",\"visitors_ip\":\"\",\"sitemapauto\":\"1\",\"sitemapprotocol\":\"1\",\"sitemapport\":\"0\",\"ga_account\":\"\",\"ga_start\":\"\",\"ga_end\":\"\",\"ga_token\":\"\",\"sitemap_menus\":\"YToxOntpOjA7czo4OiJtYWlubWVudSI7fQ==\",\"sitemap_excludes\":\"YTowOnt9\",\"sitemap_timestamp\":1770060921,\"report\":\"{\\\"email_report\\\":\\\"1\\\",\\\"mode\\\":\\\"weekly\\\",\\\"mode_days\\\":\\\"2\\\",\\\"mode_day\\\":\\\"1\\\",\\\"email\\\":\\\"\\\",\\\"subject\\\":\\\"\\\",\\\"message\\\":\\\"\\\",\\\"font\\\":\\\"times\\\",\\\"orientation\\\":\\\"portrait\\\",\\\"paper\\\":\\\"a4\\\",\\\"statistics\\\":\\\"1\\\",\\\"last_crawled\\\":\\\"1\\\",\\\"most_visited\\\":\\\"1\\\",\\\"error_links\\\":\\\"1\\\",\\\"no_title\\\":\\\"1\\\",\\\"no_desc\\\":\\\"0\\\",\\\"
  limit\\\":\\\"10\\\",\\\"enable_competitors\\\":\\\"1\\\",\\\"enable_gkeywords\\\":\\\"1\\\"}\",\"lastrun\":\"2020-07-05 19:15:43\",\"lastrunvisitors\":\"\",\"enable_googler\":\"1\",\"exclude_autocrawled\":\"0\",\"sitemap_limit\":\"500\"}'

  WHERE `extension_id` = '10537'

Explain

EXPLAIN not possible on query: UPDATE `jnew_extensions` SET `params` = '{\"global_register_code\":\"01X0E0FLG8QS5PFRQ927\",\"global_dateformat\":\"d M y H:i\",\"load_jquery\":\"1\",\"log_errors\":\"1\",\"custom_errors\":\"0\",\"obfuscate_visitor_ip\":\"0\",\"enable_sef\":\"1\",\"robots_permissions\":\"644\",\"title_length\":\"50\",\"keywords_length\":\"10\",\"description_length\":\"150\",\"customhead\":\"\",\"google_domain\":\"google.com\",\"enable_age\":\"1\",\"enable_bingp\":\"1\",\"enable_bingb\":\"1\",\"enable_alexa\":\"1\",\"enable_moz\":\"1\",\"moz_access_id\":\"\",\"moz_secret\":\"\",\"analytics_enable\":\"0\",\"analytics_client_id\":\"\",\"analytics_secret\":\"\",\"ga_tracking\":\"0\",\"ga_type\":\"0\",\"ga_code\":\"\",\"ga_options\":\"\",\"request_timeout\":\"0\",\"crawler_type\":\"loopback\",\"crawler_enable_auto\":\"1\",\"crawler_save\":\"1\",\"crawler_nofollow\":\"0\",\"crawler_level\":\"3\",\"site_name_in_title\":\"0\",\"site_name_separator\":\"|\",\"crawler_sef\":\"1\",\"crawler_title_duplicate\":\"1\",\"crawler_title_length\":\"1\",\"crawler_description_duplicate\":\"1\",\"crawler_description_length\":\"1\",\"crawler_keywords\":\"1\",\"crawler_headings\":\"1\",\"crawler_images\":\"1\",\"crawler_images_alt\":\"1\",\"crawler_images_hw\":\"1\",\"crawler_intext_links\":\"1\",\"crawler_ignore\":\"{*}tmpl=component{*}\\r\\n{*}format=pdf{*}\\r\\n{*}format=feed{*}\\r\\n{*}output=pdf{*}\\r\\n{*}?gclid={*}\",\"exclude_noindex\":\"0\",\"sitemap_permissions\":\"644\",\"enable_sitemap_cron\":\"1\",\"sitemap_cron_type\":\"0\",\"sitemap_cron_security\":\"707cb49519002c0b36d6ae726aa02589\",\"sitemap_autocrawled\":\"2\",\"sitemap_autocrawled_rule\":\"\",\"enable_keyword_replace\":\"1\",\"approved_chars\":\",;:.?!$%*&()[]{} ><\",\"keyword_density_enable\":\"1\",\"copykeywords\":\"0\",\"overwritekeywords\":\"0\",\"accountID\":\"\",\"g_date_format\":\"d M Y\",\"eanble_k_cron\":\"0\",\"k_cron_run\":\"weekly\",\"proxy_enable\":\"0\",\"proxy_server\":\"\",\"proxy_port\":\"\",\"proxy_username\":\"\",\"proxy_password\":\"\",\"img_auto_alt\":\"0\",\"img_auto_alt_rule\":\"{name} {title}\",\"img_auto_title\":\"0\",\"img_auto_title_rule\":\"{name} image\",\"track_visitors\":\"1\",\"autodeletevisitors\":\"\",\"visitors_ip\":\"\",\"sitemapauto\":\"1\",\"sitemapprotocol\":\"1\",\"sitemapport\":\"0\",\"ga_account\":\"\",\"ga_start\":\"\",\"ga_end\":\"\",\"ga_token\":\"\",\"sitemap_menus\":\"YToxOntpOjA7czo4OiJtYWlubWVudSI7fQ==\",\"sitemap_excludes\":\"YTowOnt9\",\"sitemap_timestamp\":1770060921,\"report\":\"{\\\"email_report\\\":\\\"1\\\",\\\"mode\\\":\\\"weekly\\\",\\\"mode_days\\\":\\\"2\\\",\\\"mode_day\\\":\\\"1\\\",\\\"email\\\":\\\"\\\",\\\"subject\\\":\\\"\\\",\\\"message\\\":\\\"\\\",\\\"font\\\":\\\"times\\\",\\\"orientation\\\":\\\"portrait\\\",\\\"paper\\\":\\\"a4\\\",\\\"statistics\\\":\\\"1\\\",\\\"last_crawled\\\":\\\"1\\\",\\\"most_visited\\\":\\\"1\\\",\\\"error_links\\\":\\\"1\\\",\\\"no_title\\\":\\\"1\\\",\\\"no_desc\\\":\\\"0\\\",\\\"limit\\\":\\\"10\\\",\\\"enable_competitors\\\":\\\"1\\\",\\\"enable_gkeywords\\\":\\\"1\\\"}\",\"lastrun\":\"2020-07-05 19:15:43\",\"lastrunvisitors\":\"\",\"enable_googler\":\"1\",\"exclude_autocrawled\":\"0\",\"sitemap_limit\":\"500\"}' WHERE `extension_id` = '10537'

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/administrator/components/com_rsseo/helpers/rsseo.php:66
9	rsseoHelper::updateConfig()	JROOT/plugins/system/rsseo/rsseo.php:1479
8	plgSystemRsseo->sitemap()	JROOT/plugins/system/rsseo/rsseo.php:90
7	plgSystemRsseo->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:225
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: 284.39 ms After last query: 0.61 ms Query memory: 0.021 MB Memory before query: 5.891 MB Rows returned: 0

SELECT `id`,`url`,`sef`,`title`,`level`,`priority`,`frequency`

  FROM `jnew_rsseo_pages`

  WHERE `sitemap` = 0 
  AND `insitemap` = 1 
  AND `published` != -1 
  AND `canonical` = ''

  ORDER BY `level` 
  LIMIT 250

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_pages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	551216	Using where; Using filesort

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:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_rsseo/helpers/rsseo.php:640
9	rsseoHelper::cronSitemap()	JROOT/plugins/system/rsseo/rsseo.php:1480
8	plgSystemRsseo->sitemap()	JROOT/plugins/system/rsseo/rsseo.php:90
7	plgSystemRsseo->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:225
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: 308.78 ms After last query: 0.42 ms Query memory: 0.022 MB Memory before query: 5.897 MB Rows returned: 0

SELECT `sef`

  FROM `jnew_rsseo_pages`

  WHERE `url` = 'en/consulting.html?print=1&amp;tmpl=component' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_pages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	551216	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:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
10	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
9	JFalangDatabase->loadResult()	JROOT/plugins/system/rsseo/rsseo.php:1695
8	plgSystemRsseo->redirect()	JROOT/plugins/system/rsseo/rsseo.php:100
7	plgSystemRsseo->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:225
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: 359.99 ms After last query: 0.62 ms Query memory: 0.022 MB Memory before query: 5.905 MB Rows returned: 0

SELECT `id`

  FROM `jnew_rsseo_pages`

  WHERE (`url` = 'en/consulting.html?print=1&amp;tmpl=component' OR `sef` = 'consulting?print=1&amp;tmpl=component')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_pages	ALL	sef	NO INDEX KEY COULD BE USED	NULL	NULL	551216	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:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
10	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
9	JFalangDatabase->loadResult()	JROOT/plugins/system/rsseo/rsseo.php:906
8	plgSystemRsseo->auto()	JROOT/plugins/system/rsseo/rsseo.php:132
7	plgSystemRsseo->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:225
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: 305.53 ms After last query: 0.67 ms Query memory: 0.021 MB Memory before query: 5.911 MB Rows returned: 0

SELECT `id`,`title`,`description`,`keywords`,`level`,`crawled`,`modified`,`canonical`,`customhead`,`robots`,`custom`

  FROM `jnew_rsseo_pages`

  WHERE `published` = 1 
  AND (`url` = 'en/consulting.html?print=1&amp;tmpl=component' OR `sef` = 'consulting?print=1&amp;tmpl=component') 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_pages	ALL	sef	NO INDEX KEY COULD BE USED	NULL	NULL	551216	Using where

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:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
9	JFalangDatabase->loadObject()	JROOT/plugins/system/rsseo/rsseo.php:992
8	plgSystemRsseo->meta()	JROOT/plugins/system/rsseo/rsseo.php:135
7	plgSystemRsseo->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:225
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: 33.90 ms After last query: 0.44 ms Query memory: 0.021 MB Memory before query: 5.916 MB Rows returned: 0

SELECT `id`,`date`

  FROM `jnew_rsseo_visitors`

  WHERE `session_id` = '6bdsl4ac5cnl21l67kkqspk6bd'

  ORDER BY `date` DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_visitors	ref	session_id	session_id	202	const	1	Using index condition; Using where; Using filesort

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:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
9	JFalangDatabase->loadObject()	JROOT/plugins/system/rsseo/rsseo.php:1546
8	plgSystemRsseo->visit()	JROOT/plugins/system/rsseo/rsseo.php:138
7	plgSystemRsseo->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:225
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.32 ms After last query: 0.25 ms Query memory: 0.005 MB Memory before query: 5.922 MB

INSERT INTO `jnew_rsseo_visitors`

  SET `session_id` = '6bdsl4ac5cnl21l67kkqspk6bd'
	, `date` = '2026-02-02 19:35:21'
	, `ip` = '216.73.216.56'
	, `user_id` = '0'
	, `agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
	, `referer` = ''
	, `page` = 'en/consulting.html?print=1&amp;tmpl=component'

Explain

EXPLAIN not possible on query: INSERT INTO `jnew_rsseo_visitors` SET `session_id` = '6bdsl4ac5cnl21l67kkqspk6bd' , `date` = '2026-02-02 19:35:21' , `ip` = '216.73.216.56' , `user_id` = '0' , `agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `referer` = '' , `page` = 'en/consulting.html?print=1&tmpl=component'

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
9	JFalangDatabase->execute()	JROOT/plugins/system/rsseo/rsseo.php:1559
8	plgSystemRsseo->visit()	JROOT/plugins/system/rsseo/rsseo.php:138
7	plgSystemRsseo->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:225
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.20 ms After last query: 3.17 ms Query memory: 0.021 MB Memory before query: 5.945 MB Rows returned: 0

SELECT *

  FROM `jnew_rsseo_data`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_data	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found

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:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
8	JFalangDatabase->loadObjectList()	JROOT/plugins/system/rsseo/rsseo.php:292
7	plgSystemRsseo->onBeforeRender()	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:1102
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:231
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.25 ms After last query: 4.11 ms Query memory: 0.026 MB Memory before query: 5.995 MB Rows returned: 0

SELECT *

  FROM `jnew_rsseo_keywords`

  ORDER BY CHAR_LENGTH(keyword) DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_keywords	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found

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:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
8	JFalangDatabase->loadObjectList()	JROOT/plugins/system/rsseo/rsseo.php:337
7	plgSystemRsseo->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:1118
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:231
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: 292.41 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 6.008 MB Rows returned: 0

SELECT `id`,`css`,`scripts`

  FROM `jnew_rsseo_pages`

  WHERE `published` = 1 
  AND (`url` = 'en/consulting.html?print=1&amp;tmpl=component' OR `sef` = 'consulting?print=1&amp;tmpl=component') 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_rsseo_pages	ALL	sef	NO INDEX KEY COULD BE USED	NULL	NULL	551216	Using where

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:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
9	JFalangDatabase->loadObject()	JROOT/plugins/system/rsseo/rsseo.php:1768
8	plgSystemRsseo->removeCSSJs()	JROOT/plugins/system/rsseo/rsseo.php:639
7	plgSystemRsseo->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:1118
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:231
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.]

51 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

4 × SELECT `sef` 
  FROM `jnew_rsseo_pages`

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jnew_assets`

2 × 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 jnew_menu AS m 
  LEFT JOIN jnew_extensions AS e 
  ON m.component_id = e.extension_id

2 × Select form.`title_field`,form.`protect_upload_directory`,form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From jnew_contentbuilder_articles As article, jnew_contentbuilder_forms As form

2 × SELECT `url` 
  FROM `jnew_rsseo_pages`

2 × SELECT `ip`,`reason` 
  FROM jnew_rsfirewall_lists

1 × SELECT language,id 
  FROM `jnew_menu`

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 `jnew_categories` AS `s` 
  INNER JOIN `jnew_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 DISTINCT 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 jnew_fields AS a 
  LEFT JOIN `jnew_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jnew_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jnew_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jnew_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jnew_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `jnew_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × Select form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From jnew_contentbuilder_articles As article, jnew_contentbuilder_forms As form

1 × Select form.rating_slots,form.`title_field`,form.`protect_upload_directory`,form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From jnew_contentbuilder_articles As article, jnew_contentbuilder_forms As form

1 × SELECT id,placeholder 
  FROM `jnew_gdpr_checkbox

1 × SELECT `extension_id`,`params` 
  FROM `jnew_extensions`

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

1 × SELECT `id`,`url`,`sef`,`title`,`level`,`priority`,`frequency` 
  FROM `jnew_rsseo_pages`

1 × SELECT `id` 
  FROM `jnew_rsseo_pages`

1 × SELECT `id`,`title`,`description`,`keywords`,`level`,`crawled`,`modified`,`canonical`,`customhead`,`robots`,`custom` 
  FROM `jnew_rsseo_pages`

1 × SELECT `id`,`date` 
  FROM `jnew_rsseo_visitors`

```
1 × SELECT * 
  FROM `jnew_rsseo_data
```

1 × SELECT * 
  FROM `jnew_rsseo_keywords`

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

1 × SELECT * 
  FROM jnew_rsform_confi

1 × SELECT fc.value 
  FROM jnew_falang_content fc

1 × SELECT * 
  FROM jnew_rsfirewall_snapshots

1 × SELECT joomlatablename,tablepkID 
  FROM `jnew_falang_tableinfo

```
1 × SELECT * 
  FROM jnew_languages
```

1 × SELECT `params` 
  FROM `jnew_extensions`

1 × SELECT * 
  FROM `jnew_rsseo_redirects`

1 × SELECT `url`,`sef` 
  FROM `jnew_rsseo_pages`

1 × SELECT * 
  FROM jnew_rsfirewall_hashes

1 × SELECT * 
  FROM jnew_rsfirewall_exceptions

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

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

1 × Select `type`, `reference_id` 
  From jnew_contentbuilder_forms

1 × Select * 
  From jnew_contentbuilder_storages

1 × Select * 
  From jnew_contentbuilder_storage_fields

1 × Select r.id                                  
  From                                   jnew_projets As r

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

1 × Select                      form.id As form_id,                     form.act_as_registration,                     form.default_category,                     form.registration_name_field,                      form.registration_username_field,                      form.registration_email_field,                      form.registration_email_repeat_field,                      form.`last_update`,                     article.`article_id`,                     form.`title_field`,                     form.`create_articles`,                     form.`name`,                     form.`use_view_name_as_title`,                     form.`protect_upload_directory`,                     form.`reference_id`,                     records.`record_id`,                     form.`type`,                     form.`published_only`,                     form.`own_only`,                     form.`own_only_fe`,                     records.`last_update` As record_last_update,                     article.`last_update` As article_last_update                 
  From                     jnew_contentbuilder_records As records                     
  Left Join jnew_contentbuilder_forms As form 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id )                     
  Left Join jnew_contentbuilder_articles As article 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )                     
  Left Join jnew_content As content 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.article_id = content.id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )

1 × SELECT `id`,`css`,`scripts` 
  FROM `jnew_rsseo_pages`

OTHER Tables:

1 × Update                         jnew_contentbuilder_articles As articles,                         jnew_content As content,                          jnew_contentbuilder_forms As forms,                         jnew_contentbuilder_registered_users As cbusers,                         jnew_users As users                     
  Set                          content.state = 0

1 × Update                          jnew_contentbuilder_articles As articles,                         jnew_content As content,                          jnew_contentbuilder_forms As forms,                         jnew_contentbuilder_records As records,                         jnew_contentbuilder_registered_users As cbusers,                         jnew_users As users                     
  Set                          content.state = forms.auto_publish

1 × SHOW FULL COLUMNS 
  FROM `jnew_languages

1 × UPDATE `jnew_extensions` 
  SET `params` = '{\"mediaversion\":\"c42104e2fc619917ddfe9b77e4545dd2\"}'

1 × Update jnew_contentbuilder_records 
  Set published = 1

1 × Update jnew_contentbuilder_records 
  Set published = 0

1 × SHOW FULL COLUMNS 
  FROM `jnew_content

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

1 × UPDATE `jnew_extensions` 
  SET `params` = '{\"global_register_code\":\"01X0E0FLG8QS5PFRQ927\",\"global_dateformat\":\"d M y H:i\",\"load_jquery\":\"1\",\"log_errors\":\"1\",\"custom_errors\":\"0\",\"obfuscate_visitor_ip\":\"0\",\"enable_sef\":\"1\",\"robots_permissions\":\"644\",\"title_length\":\"50\",\"keywords_length\":\"10\",\"description_length\":\"150\",\"customhead\":\"\",\"google_domain\":\"google.com\",\"enable_age\":\"1\",\"enable_bingp\":\"1\",\"enable_bingb\":\"1\",\"enable_alexa\":\"1\",\"enable_moz\":\"1\",\"moz_access_id\":\"\",\"moz_secret\":\"\",\"analytics_enable\":\"0\",\"analytics_client_id\":\"\",\"analytics_secret\":\"\",\"ga_tracking\":\"0\",\"ga_type\":\"0\",\"ga_code\":\"\",\"ga_options\":\"\",\"request_timeout\":\"0\",\"crawler_type\":\"loopback\",\"crawler_enable_auto\":\"1\",\"crawler_save\":\"1\",\"crawler_nofollow\":\"0\",\"crawler_level\":\"3\",\"site_name_in_title\":\"0\",\"site_name_separator\":\"|\",\"crawler_sef\":\"1\",\"crawler_title_duplicate\":\"1\",\"crawler_title_length\":\"1\",\"crawler_description_duplicate\":\"1\",\"crawler_description_length\":\"1\",\"crawler_keywords\":\"1\",\"crawler_headings\":\"1\",\"crawler_images\":\"1\",\"crawler_images_alt\":\"1\",\"crawler_images_hw\":\"1\",\"crawler_intext_links\":\"1\",\"crawler_ignore\":\"{*}tmpl=component{*}\\r\\n{*}format=pdf{*}\\r\\n{*}format=feed{*}\\r\\n{*}output=pdf{*}\\r\\n{*}?gclid={*}\",\"exclude_noindex\":\"0\",\"sitemap_permissions\":\"644\",\"enable_sitemap_cron\":\"1\",\"sitemap_cron_type\":\"0\",\"sitemap_cron_security\":\"707cb49519002c0b36d6ae726aa02589\",\"sitemap_autocrawled\":\"2\",\"sitemap_autocrawled_rule\":\"\",\"enable_keyword_replace\":\"1\",\"approved_chars\":\",;:.?!$%*&()[]{} ><\",\"keyword_density_enable\":\"1\",\"copykeywords\":\"0\",\"overwritekeywords\":\"0\",\"accountID\":\"\",\"g_date_format\":\"d M Y\",\"eanble_k_cron\":\"0\",\"k_cron_run\":\"weekly\",\"proxy_enable\":\"0\",\"proxy_server\":\"\",\"proxy_port\":\"\",\"proxy_username\":\"\",\"proxy_password\":\"\",\"img_auto_alt\":\"0\",\"img_auto_alt_rule\":\"{name} {title}\",\"img_auto_title\":\"0\",\"img_auto_title_rule\":\"{name} image\",\"track_visitors\":\"1\",\"autodeletevisitors\":\"\",\"visitors_ip\":\"\",\"sitemapauto\":\"1\",\"sitemapprotocol\":\"1\",\"sitemapport\":\"0\",\"ga_account\":\"\",\"ga_start\":\"\",\"ga_end\":\"\",\"ga_token\":\"\",\"sitemap_menus\":\"YToxOntpOjA7czo4OiJtYWlubWVudSI7fQ==\",\"sitemap_excludes\":\"YTowOnt9\",\"sitemap_timestamp\":1770060921,\"report\":\"{\\\"email_report\\\":\\\"1\\\",\\\"mode\\\":\\\"weekly\\\",\\\"mode_days\\\":\\\"2\\\",\\\"mode_day\\\":\\\"1\\\",\\\"email\\\":\\\"\\\",\\\"subject\\\":\\\"\\\",\\\"message\\\":\\\"\\\",\\\"font\\\":\\\"times\\\",\\\"orientation\\\":\\\"portrait\\\",\\\"paper\\\":\\\"a4\\\",\\\"statistics\\\":\\\"1\\\",\\\"last_crawled\\\":\\\"1\\\",\\\"most_visited\\\":\\\"1\\\",\\\"error_links\\\":\\\"1\\\",\\\"no_title\\\":\\\"1\\\",\\\"no_desc\\\":\\\"0\\\",\\\"
  limit\\\":\\\"10\\\",\\\"enable_competitors\\\":\\\"1\\\",\\\"enable_gkeywords\\\":\\\"1\\\"}\",\"lastrun\":\"2020-07-05 19:15:43\",\"lastrunvisitors\":\"\",\"enable_googler\":\"1\",\"exclude_autocrawled\":\"0\",\"sitemap_limit\":\"500\"}'

1 × INSERT INTO `jnew_rsseo_visitors` 
  SET `session_id` = '6bdsl4ac5cnl21l67kkqspk6bd'  , `date` = '2026-02-02 19:35:21'  , `ip` = '216.73.216.56'  , `user_id` = '0'  , `agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'  , `referer` = ''  , `page` = 'en/consulting.html?print=1&amp;tmpl=component

CONSULTING offer

CONSULTING Offer

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

67 Queries Logged 2018.04 ms

6 duplicate found!

51 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: