Secondi Piatti

headerMedula

Attenzione

JUser: :_load: non è stato possibile caricare l'utente con ID: 905

Merluzzo all'acqua pazza

Inizio Indietro123456789AvantiFine

footerMedula

Console Debug Joomla!

Sessione

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN non possibile sulla query: INSERT INTO `l1f3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'397363696a3267626937683331736d75386661386d3633346837', 1, 1768352342, 0, '', 0)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.02 ms Dopo l'ultima query: 1.09 ms Memoria query: 0.042 MB memoria prima della query: 1.090 MB Righe restituite: 50

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

  FROM `l1f3_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_extensions	NULL	ref	extension	extension	82	const	50	1.00	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.78 ms Dopo l'ultima query: 1.25 ms Memoria query: 0.021 MB memoria prima della query: 1.139 MB Righe restituite: 3

SELECT id, rules

  FROM `l1f3_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_viewlevels	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.53 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.021 MB memoria prima della query: 1.150 MB Righe restituite: 1

SELECT b.id

  FROM l1f3_usergroups AS a

  LEFT JOIN l1f3_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	100.00	Using where; Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.63 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.035 MB memoria prima della query: 1.171 MB Righe restituite: 132

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM l1f3_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_extensions	NULL	ref	extension	extension	82	const	187	0.40	Using where; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.07 ms Dopo l'ultima query: 11.95 ms Memoria query: 0.005 MB memoria prima della query: 1.702 MB

Update
                        l1f3_contentbuilder_articles As articles,
                        l1f3_content As content, 
                        l1f3_contentbuilder_forms As forms,
                        l1f3_contentbuilder_registered_users As cbusers,
                        l1f3_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
                        )
                      )

Explain

EXPLAIN non possibile sulla query: Update l1f3_contentbuilder_articles As articles, l1f3_content As content, l1f3_contentbuilder_forms As forms, l1f3_contentbuilder_registered_users As cbusers, l1f3_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 ) )

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.75 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.005 MB memoria prima della query: 1.709 MB

Update 
                        l1f3_contentbuilder_articles As articles,
                        l1f3_content As content, 
                        l1f3_contentbuilder_forms As forms,
                        l1f3_contentbuilder_records As records,
                        l1f3_contentbuilder_registered_users As cbusers,
                        l1f3_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 non possibile sulla query: Update l1f3_contentbuilder_articles As articles, l1f3_content As content, l1f3_contentbuilder_forms As forms, l1f3_contentbuilder_records As records, l1f3_contentbuilder_registered_users As cbusers, l1f3_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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.41 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.041 MB memoria prima della query: 1.721 MB Righe restituite: 50

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
                    l1f3_contentbuilder_records As records
                    
  Left Join l1f3_contentbuilder_forms As form 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id )
                    
  Left Join l1f3_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 l1f3_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	form	NULL	ALL	PRIMARY,reference_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where
1	SIMPLE	records	NULL	ref	record_id,reference_id,type,type_2	reference_id	4	database_life_349858y.form.reference_id	1363	100.00	Using where
1	SIMPLE	article	NULL	ALL	record_id,record_id_2	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	content	NULL	eq_ref	PRIMARY	PRIMARY	4	database_life_349858y.article.article_id	1	100.00	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.34 ms Dopo l'ultima query: 0.74 ms Memoria query: 0.006 MB memoria prima della query: 1.939 MB


  SET SESSION group_concat_max_len = 9999999

Explain

EXPLAIN non possibile sulla query: SET SESSION group_concat_max_len = 9999999

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:22
11	contentbuilder_com_breezingforms->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
10	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:530
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.04 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.156 MB memoria prima della query: 1.945 MB Righe restituite: 1

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:25
11	contentbuilder_com_breezingforms->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
10	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:530
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.08 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.053 MB memoria prima della query: 2.016 MB Righe restituite: 21

Select * 
  From l1f3_facileforms_elements 
  Where `type` <> 'Sofortueberweisung' 
  And `type` <> 'PayPal' 
  And `type` <> 'Static Text/HTML' 
  And `type` <> 'Rectangle' 
  And `type` <> 'Image' 
  And `type` <> 'Tooltip' 
  And `type` <> 'Query List' 
  And `type` <> 'Icon' 
  And `type` <> 'Graphic Button' 
  And `type` <> 'Regular Button' 
  And `type`<> 'Unknown' 
  And `type` <> 'Summarize' 
  And `type` <> 'ReCaptcha' 
  And form = 5 
  And published = 1 
  Order By `ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
12	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:29
11	contentbuilder_com_breezingforms->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
10	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:530
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.77 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.088 MB Righe restituite: 17

Query duplicate: #20 #26 #32 #38 #44 #50 #56 #62 #68 #74 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.60 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 2.102 MB Righe restituite: 17

Query duplicate: #21 #27 #33 #39 #45 #51 #57 #63 #69 #75 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 25.04 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.124 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4764' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.75 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.022 MB memoria prima della query: 2.128 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4764'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.49 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.135 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4764

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.57 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.144 MB Righe restituite: 1

Query duplicate: #25 #31 #37 #43 #49 #55 #61 #67 #73 #79 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.42 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.138 MB Righe restituite: 17

Query duplicate: #14 #26 #32 #38 #44 #50 #56 #62 #68 #74 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.68 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.023 MB memoria prima della query: 2.143 MB Righe restituite: 17

Query duplicate: #15 #27 #33 #39 #45 #51 #57 #63 #69 #75 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 20.65 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.022 MB memoria prima della query: 2.166 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4526' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.66 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 2.167 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4526'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.52 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.174 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4526

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.50 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.180 MB Righe restituite: 1

Query duplicate: #19 #31 #37 #43 #49 #55 #61 #67 #73 #79 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.67 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.174 MB Righe restituite: 17

Query duplicate: #14 #20 #32 #38 #44 #50 #56 #62 #68 #74 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.74 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 2.180 MB Righe restituite: 17

Query duplicate: #15 #21 #33 #39 #45 #51 #57 #63 #69 #75 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 20.31 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.202 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4103' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.62 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 2.204 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4103'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.51 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.210 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4103

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.52 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.217 MB Righe restituite: 1

Query duplicate: #19 #25 #37 #43 #49 #55 #61 #67 #73 #79 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.76 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.211 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #38 #44 #50 #56 #62 #68 #74 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.55 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.024 MB memoria prima della query: 2.223 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #39 #45 #51 #57 #63 #69 #75 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 24.39 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.246 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4098' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.70 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 2.248 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4098'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.56 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.254 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4098

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.51 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.261 MB Righe restituite: 1

Query duplicate: #19 #25 #31 #43 #49 #55 #61 #67 #73 #79 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.73 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.255 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #32 #44 #50 #56 #62 #68 #74 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.59 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.261 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #33 #45 #51 #57 #63 #69 #75 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 24.01 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.283 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4099' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.85 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 2.285 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4099'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.50 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.291 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4099

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.50 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.297 MB Righe restituite: 1

Query duplicate: #19 #25 #31 #37 #49 #55 #61 #67 #73 #79 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.76 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.292 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #32 #38 #50 #56 #62 #68 #74 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.60 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.297 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #33 #39 #51 #57 #63 #69 #75 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 23.06 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.319 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4100' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.74 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 2.321 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4100'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.49 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.327 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4100

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.55 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.334 MB Righe restituite: 1

Query duplicate: #19 #25 #31 #37 #43 #55 #61 #67 #73 #79 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.72 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.328 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #32 #38 #44 #56 #62 #68 #74 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.50 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 2.333 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #33 #39 #45 #57 #63 #69 #75 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 21.74 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.356 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4101' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.86 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 2.358 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4101'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.51 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.364 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4101

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.57 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.370 MB Righe restituite: 1

Query duplicate: #19 #25 #31 #37 #43 #49 #61 #67 #73 #79 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.75 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.365 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #32 #38 #44 #50 #62 #68 #74 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.64 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.370 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #33 #39 #45 #51 #63 #69 #75 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 23.63 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.392 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4092' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.80 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.021 MB memoria prima della query: 2.394 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4092'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.52 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.400 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4092

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.51 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.407 MB Righe restituite: 1

Query duplicate: #19 #25 #31 #37 #43 #49 #55 #67 #73 #79 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.75 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.401 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #32 #38 #44 #50 #56 #68 #74 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.60 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.023 MB memoria prima della query: 2.406 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #33 #39 #45 #51 #57 #69 #75 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 21.92 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.429 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4552' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.68 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.027 MB memoria prima della query: 2.440 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4552'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.47 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.451 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4552

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.53 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.458 MB Righe restituite: 1

Query duplicate: #19 #25 #31 #37 #43 #49 #55 #61 #73 #79 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.80 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.452 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #32 #38 #44 #50 #56 #62 #74 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.61 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 2.458 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #33 #39 #45 #51 #57 #63 #75 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 21.03 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.480 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4094' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.70 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 2.482 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4094'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.48 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.488 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4094

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.47 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.494 MB Righe restituite: 1

Query duplicate: #19 #25 #31 #37 #43 #49 #55 #61 #67 #79 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.86 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.489 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #32 #38 #44 #50 #56 #62 #68 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.53 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.023 MB memoria prima della query: 2.494 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #33 #39 #45 #51 #57 #63 #69 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 20.15 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.516 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4550' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.74 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.021 MB memoria prima della query: 2.518 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4550'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.50 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.524 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4550

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.47 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.531 MB Righe restituite: 1

Query duplicate: #19 #25 #31 #37 #43 #49 #55 #61 #67 #73 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.63 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.525 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #32 #38 #44 #50 #56 #62 #68 #74 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.63 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.530 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #33 #39 #45 #51 #57 #63 #69 #75 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 21.25 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.553 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4551' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.79 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 2.554 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4551'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2	record_id	8	const	1	29.56	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.52 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.561 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4551

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_records	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
10	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.57 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.567 MB Righe restituite: 1

Query duplicate: #19 #25 #31 #37 #43 #49 #55 #61 #67 #73 #79 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From l1f3_contentbuilder_forms 
  Where id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
11	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1898
10	contentbuilder::createArticle()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:555
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.66 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.562 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #32 #38 #44 #50 #56 #62 #68 #74 #80 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308

Select Distinct `label`, reference_id 
  From l1f3_contentbuilder_elements 
  Where form_id = 1 
  And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508') 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_contentbuilder_elements	NULL	ALL	reference_id,form_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	10.00	Using where; Using temporary; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:546
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.54 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.567 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #33 #39 #45 #51 #57 #63 #69 #75 #81 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309

Select id, `title`, `name`, `type` 
  From
                l1f3_facileforms_elements
                
  Where
                form = 5
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_facileforms_elements	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	52	1.92	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 21.91 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.589 MB Righe restituite: 1

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '199' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '200' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '201' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '202' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '207' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '208' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '209' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '242' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '255' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '269' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '274' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '295' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '296' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '332' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '345' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '431' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '508' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col508Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                l1f3_facileforms_subrecords As s,
                l1f3_facileforms_records As r
                 
  Left Join l1f3_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '4096' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 5
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2	record_id	8	const	1	26.90	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	38751	10.00	Using where; Using join buffer (hash join)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
10	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:553
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.79 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 2.591 MB Righe restituite: 1

Select metakey, metadesc, author, robots, rights, xreference 
  From l1f3_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '5' 
  And record_id = '4096'

Attenzione

Merluzzo all'acqua pazza

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

381 query eseguite 1421.36 ms

Trovati 178 duplicati!