Interviste di Adriano Panzironi - ROSARIA ESPOSITO con il LIFE 120 ha risolto GASTRITE CON REFLUSSO, STITICHEZZA, ARTROSI

headerMedula

RICERCA INTERVISTA

ROSARIA ESPOSITO con il LIFE 120 ha risolto GASTRITE CON REFLUSSO, STITICHEZZA, ARTROSI

footerMedula

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1779273595,
                "last": 1779273595,
                "now": 1779273595
            }
        },
        "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
        },
        "avs_arr": [
            "rosaria-esposito-con-il-life-120-ha-risolto-gastrite-con-reflusso-stitichezza-artrosi"
        ]
    }
}

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'3533763136716f7335343933646164696370376e6c347536686d', 1, 1779273595, 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.10 ms Dopo l'ultima query: 1.63 ms Memoria query: 0.042 MB memoria prima della query: 1.089 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.53 ms Dopo l'ultima query: 1.79 ms Memoria query: 0.021 MB memoria prima della query: 1.138 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.16 ms Memoria query: 0.021 MB memoria prima della query: 1.149 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.79 ms Dopo l'ultima query: 0.13 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.11 ms Dopo l'ultima query: 19.35 ms Memoria query: 0.005 MB memoria prima della query: 1.701 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: 1.11 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.005 MB memoria prima della query: 1.708 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.62 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.041 MB memoria prima della query: 1.720 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.38 ms Dopo l'ultima query: 1.03 ms Memoria query: 0.006 MB memoria prima della query: 1.938 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.11 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.160 MB memoria prima della query: 1.944 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.17 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.054 MB memoria prima della query: 2.020 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.81 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.022 MB memoria prima della query: 2.093 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.63 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.023 MB memoria prima della query: 2.106 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: 35.77 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.129 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.77 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.132 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.54 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.139 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: 0.53 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.022 MB memoria prima della query: 2.148 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: 0.79 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.022 MB memoria prima della query: 2.142 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.59 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.023 MB memoria prima della query: 2.148 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: 34.42 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.170 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.95 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 2.172 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.70 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.178 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.94 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.184 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.90 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.022 MB memoria prima della query: 2.179 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: 1.06 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.023 MB memoria prima della query: 2.184 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: 34.16 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.206 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.84 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 2.208 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.57 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.214 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.58 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 2.221 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.84 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.022 MB memoria prima della query: 2.215 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.60 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.024 MB memoria prima della query: 2.227 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: 46.34 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.251 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: 1.75 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 2.252 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.58 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.258 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.57 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.265 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.90 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.260 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.62 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.023 MB memoria prima della query: 2.265 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: 73.70 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.022 MB memoria prima della query: 2.287 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: 1.58 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.021 MB memoria prima della query: 2.289 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.54 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.295 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.55 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.302 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: 1.13 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.022 MB memoria prima della query: 2.296 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: 1.08 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 2.301 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: 58.18 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.324 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.70 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.021 MB memoria prima della query: 2.325 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.55 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.331 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.54 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.338 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: 1.98 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.333 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.62 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 2.338 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: 72.43 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.360 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.71 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.021 MB memoria prima della query: 2.362 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.54 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.368 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.53 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.375 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: 3.22 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.022 MB memoria prima della query: 2.369 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.59 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.023 MB memoria prima della query: 2.374 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: 72.30 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 2.397 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.68 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.021 MB memoria prima della query: 2.398 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.56 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.404 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.16 ms Memoria query: 0.022 MB memoria prima della query: 2.411 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.83 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.022 MB memoria prima della query: 2.405 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: 1.82 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.023 MB memoria prima della query: 2.411 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: 62.62 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 2.433 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.75 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.027 MB memoria prima della query: 2.444 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.52 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.456 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.54 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.462 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.85 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.022 MB memoria prima della query: 2.457 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.69 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.023 MB memoria prima della query: 2.462 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: 68.22 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 2.484 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: 1.11 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 2.486 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.63 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.492 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.60 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.499 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.87 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.022 MB memoria prima della query: 2.493 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.65 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.023 MB memoria prima della query: 2.498 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: 44.52 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.521 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: 1.09 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.021 MB memoria prima della query: 2.523 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.68 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.529 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.63 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.535 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.90 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.022 MB memoria prima della query: 2.530 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.68 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.023 MB memoria prima della query: 2.535 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: 36.99 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.557 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: 1.03 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.021 MB memoria prima della query: 2.559 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.68 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.565 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.64 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.571 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.89 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.022 MB memoria prima della query: 2.566 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.76 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.023 MB memoria prima della query: 2.571 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: 37.06 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.594 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: 1.00 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 2.595 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'

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.70 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.601 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4096

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.82 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.608 MB Righe restituite: 1

Query duplicate: #19 #25 #31 #37 #43 #49 #55 #61 #67 #73 #79 #85 #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.95 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.022 MB memoria prima della query: 2.602 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #32 #38 #44 #50 #56 #62 #68 #74 #80 #86 #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.67 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.023 MB memoria prima della query: 2.608 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #33 #39 #45 #51 #57 #63 #69 #75 #81 #87 #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: 36.65 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.630 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 = '4105' 
  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: 1.15 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 2.632 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 = '4105'

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.79 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.638 MB Righe restituite: 1

Select * 
  From l1f3_facileforms_records 
  Where id = 4105

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.64 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.644 MB Righe restituite: 1

Query duplicate: #19 #25 #31 #37 #43 #49 #55 #61 #67 #73 #79 #85 #91 #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.92 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.022 MB memoria prima della query: 2.639 MB Righe restituite: 17

Query duplicate: #14 #20 #26 #32 #38 #44 #50 #56 #62 #68 #74 #80 #86 #92 #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.69 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.023 MB memoria prima della query: 2.644 MB Righe restituite: 17

Query duplicate: #15 #21 #27 #33 #39 #45 #51 #57 #63 #69 #75 #81 #87 #93 #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: 37.83 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.667 MB Righe restituite: 1

RICERCA INTERVISTA

ROSARIA ESPOSITO con il LIFE 120 ha risolto GASTRITE CON REFLUSSO, STITICHEZZA, ARTROSI

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

334 query eseguite 3150.88 ms

Trovati 150 duplicati!