BLOG SALUTE

Conservazione e colorazione tra nitriti e nitrati. Il lato cancerogeno dei salumi

Cibo e (buon) umore: una strada a doppio senso sulla via del benessere

Vitamina D e il nuovo studio: protegge l’intestino e riduce il rischio di cancro al colon

Dolore alla bocca? Tutta colpa della carenza di vitamina D

Semi di lino: tesoro per lo sport e arma contro ipertensione e ipercolesterolemia

Dermatite seborroica, tanti rimedi naturali contro l'infiammazione cutanea

Lo stress dopo il riposo. Come combattere la stanchezza post vacanza

Vitamina C: le dosi raccomandate sono davvero sufficienti?

Dall’abbronzatura al sistema immunitario, ci pensano gli essenziali per l’estate

Le micosi della pelle: un nemico difficile da debellare

Stress, insonnia, stanchezza e crampi: i segreti per un’estate a pieno ritmo

Eritema solare: al mare o in montagna per una vacanza senza scottature

Pesce grasso e omega 3: l’accoppiata vincente contro l’emicrania

Vitamine e minerali, i nutrienti amici della pelle e della vista

Birra, sotto l’ombrellone un concentrato di buonumore e sali minerali

Promemoria per l’estate: i segreti per una pelle sana e abbronzata

Russamento e apnee notturne: il 70% tra bambini e adolescenti vittime dell’insonnia

InizioIndietro12345678910Avanti Fine

Console Debug Joomla!

Sessione

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

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

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

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:856
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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:51

EXPLAIN non possibile sulla query: INSERT INTO `l1f3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'383535336874616f72706968736931716162626a716475753636', 1, 1746016861, 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:856
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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:51

[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: 2.82 ms Memoria query: 0.042 MB memoria prima della query: 1.390 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:74

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

Tempo della query: 7.82 ms Dopo l'ultima query: 2.76 ms Memoria query: 0.021 MB memoria prima della query: 1.434 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:74

[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.11 ms Memoria query: 0.021 MB memoria prima della query: 1.445 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:74

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

Tempo della query: 1.49 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.035 MB memoria prima della query: 1.467 MB Righe restituite: 131

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	186	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:74

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

Tempo della query: 2.98 ms Dopo l'ultima query: 20.41 ms Memoria query: 0.022 MB memoria prima della query: 1.910 MB Righe restituite: 1

SELECT `value`

  FROM `l1f3_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_admintools_storage	NULL	const	PRIMARY	PRIMARY	402	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
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:74

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

Tempo della query: 0.46 ms Dopo l'ultima query: 0.47 ms Memoria query: 0.021 MB memoria prima della query: 1.918 MB Righe restituite: 0

SELECT *

  FROM `l1f3_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l1f3_admintools_wafexceptions	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
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:74

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

Tempo della query: 0.49 ms Dopo l'ultima query: 15.01 ms Memoria query: 0.021 MB memoria prima della query: 2.158 MB Righe restituite: 0

SELECT `source`,`keepurlparams`

  FROM `l1f3_admintools_redirects`

  WHERE ((`dest` = 'informazione-salute.html') OR (`dest` = 'informazione-salute.html') OR ('informazione-salute.html' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

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

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:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->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:696
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:74

[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.33 ms Memoria query: 0.005 MB memoria prima della query: 2.162 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:696
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:74

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

Tempo della query: 8.35 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.005 MB memoria prima della query: 2.168 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:696
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:74

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

Tempo della query: 1.24 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.041 MB memoria prima della query: 2.180 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:696
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:74

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

Tempo della query: 0.33 ms Dopo l'ultima query: 1.46 ms Memoria query: 0.006 MB memoria prima della query: 2.398 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:696
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:74

[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.05 ms Memoria query: 0.156 MB memoria prima della query: 2.404 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:696
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:74

[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.10 ms Memoria query: 0.053 MB memoria prima della query: 2.475 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:696
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:74

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

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

Query duplicate: #23 #29 #35 #41 #47 #53 #59 #65 #71 #77 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311

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:696
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:74

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

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

Query duplicate: #24 #30 #36 #42 #48 #54 #60 #66 #72 #78 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312

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:696
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:74

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

Tempo della query: 34.61 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 2.586 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:696
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:74

[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.12 ms Memoria query: 0.021 MB memoria prima della query: 2.588 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:696
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:74

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

Tempo della query: 0.44 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.594 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:696
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:74

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

Tempo della query: 0.42 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.603 MB Righe restituite: 1

Query duplicate: #28 #34 #40 #46 #52 #58 #64 #70 #76 #82 #88 #94 #100 #106 #112 #118 #124 #130 #136 #142 #148 #154 #160 #166 #172 #178 #184 #190 #196 #202 #208 #214 #220 #226 #232 #238 #244 #250 #256 #262 #268 #274 #280 #286 #292 #298 #304 #310 #316

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:696
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:74

[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.15 ms Memoria query: 0.022 MB memoria prima della query: 2.597 MB Righe restituite: 17

Query duplicate: #17 #29 #35 #41 #47 #53 #59 #65 #71 #77 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311

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:696
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:74

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

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

Query duplicate: #18 #30 #36 #42 #48 #54 #60 #66 #72 #78 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312

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:696
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:74

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

Tempo della query: 35.67 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.624 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:696
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:74

[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.10 ms Memoria query: 0.021 MB memoria prima della query: 2.626 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:696
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:74

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

Tempo della query: 0.42 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.632 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:696
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:74

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

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

Query duplicate: #22 #34 #40 #46 #52 #58 #64 #70 #76 #82 #88 #94 #100 #106 #112 #118 #124 #130 #136 #142 #148 #154 #160 #166 #172 #178 #184 #190 #196 #202 #208 #214 #220 #226 #232 #238 #244 #250 #256 #262 #268 #274 #280 #286 #292 #298 #304 #310 #316

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:696
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:74

[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.15 ms Memoria query: 0.022 MB memoria prima della query: 2.633 MB Righe restituite: 17

Query duplicate: #17 #23 #35 #41 #47 #53 #59 #65 #71 #77 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311

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:696
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:74

[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.023 MB memoria prima della query: 2.639 MB Righe restituite: 17

Query duplicate: #18 #24 #36 #42 #48 #54 #60 #66 #72 #78 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312

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:696
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:74

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

Tempo della query: 41.03 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.661 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:696
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:74

[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.16 ms Memoria query: 0.021 MB memoria prima della query: 2.663 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:696
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:74

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

Tempo della query: 0.46 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.023 MB memoria prima della query: 2.676 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:696
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:74

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

Tempo della query: 0.46 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.683 MB Righe restituite: 1

Query duplicate: #22 #28 #40 #46 #52 #58 #64 #70 #76 #82 #88 #94 #100 #106 #112 #118 #124 #130 #136 #142 #148 #154 #160 #166 #172 #178 #184 #190 #196 #202 #208 #214 #220 #226 #232 #238 #244 #250 #256 #262 #268 #274 #280 #286 #292 #298 #304 #310 #316

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:696
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:74

[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.22 ms Memoria query: 0.022 MB memoria prima della query: 2.678 MB Righe restituite: 17

Query duplicate: #17 #23 #29 #41 #47 #53 #59 #65 #71 #77 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311

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:696
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:74

[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.08 ms Memoria query: 0.023 MB memoria prima della query: 2.683 MB Righe restituite: 17

Query duplicate: #18 #24 #30 #42 #48 #54 #60 #66 #72 #78 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312

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:696
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:74

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

Tempo della query: 35.43 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.705 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:696
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:74

[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.18 ms Memoria query: 0.021 MB memoria prima della query: 2.707 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:696
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:74

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

Tempo della query: 0.48 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.713 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:696
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:74

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

Tempo della query: 2.26 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.720 MB Righe restituite: 1

Query duplicate: #22 #28 #34 #46 #52 #58 #64 #70 #76 #82 #88 #94 #100 #106 #112 #118 #124 #130 #136 #142 #148 #154 #160 #166 #172 #178 #184 #190 #196 #202 #208 #214 #220 #226 #232 #238 #244 #250 #256 #262 #268 #274 #280 #286 #292 #298 #304 #310 #316

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:696
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:74

[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.714 MB Righe restituite: 17

Query duplicate: #17 #23 #29 #35 #47 #53 #59 #65 #71 #77 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311

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:696
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:74

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

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

Query duplicate: #18 #24 #30 #36 #48 #54 #60 #66 #72 #78 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312

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:696
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:74

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

Tempo della query: 38.41 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.022 MB memoria prima della query: 2.742 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:696
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:74

[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.13 ms Memoria query: 0.021 MB memoria prima della query: 2.744 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:696
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:74

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

Tempo della query: 0.45 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.750 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:696
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:74

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

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

Query duplicate: #22 #28 #34 #40 #52 #58 #64 #70 #76 #82 #88 #94 #100 #106 #112 #118 #124 #130 #136 #142 #148 #154 #160 #166 #172 #178 #184 #190 #196 #202 #208 #214 #220 #226 #232 #238 #244 #250 #256 #262 #268 #274 #280 #286 #292 #298 #304 #310 #316

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:696
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:74

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

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

Query duplicate: #17 #23 #29 #35 #41 #53 #59 #65 #71 #77 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311

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:696
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:74

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

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

Query duplicate: #18 #24 #30 #36 #42 #54 #60 #66 #72 #78 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312

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:696
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:74

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

Tempo della query: 35.46 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.778 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:696
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:74

[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.021 MB memoria prima della query: 2.780 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:696
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:74

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

Tempo della query: 0.43 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.022 MB memoria prima della query: 2.786 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:696
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:74

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

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

Query duplicate: #22 #28 #34 #40 #46 #58 #64 #70 #76 #82 #88 #94 #100 #106 #112 #118 #124 #130 #136 #142 #148 #154 #160 #166 #172 #178 #184 #190 #196 #202 #208 #214 #220 #226 #232 #238 #244 #250 #256 #262 #268 #274 #280 #286 #292 #298 #304 #310 #316

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:696
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:74

[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.15 ms Memoria query: 0.022 MB memoria prima della query: 2.787 MB Righe restituite: 17

Query duplicate: #17 #23 #29 #35 #41 #47 #59 #65 #71 #77 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311

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:696
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:74

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

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

Query duplicate: #18 #24 #30 #36 #42 #48 #60 #66 #72 #78 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312

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:696
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:74

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

Tempo della query: 35.31 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.815 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:696
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:74

[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.13 ms Memoria query: 0.021 MB memoria prima della query: 2.817 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:696
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:74

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

Tempo della query: 0.46 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.823 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:696
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:74

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

Tempo della query: 0.43 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 2.829 MB Righe restituite: 1

Query duplicate: #22 #28 #34 #40 #46 #52 #64 #70 #76 #82 #88 #94 #100 #106 #112 #118 #124 #130 #136 #142 #148 #154 #160 #166 #172 #178 #184 #190 #196 #202 #208 #214 #220 #226 #232 #238 #244 #250 #256 #262 #268 #274 #280 #286 #292 #298 #304 #310 #316

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:696
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:74

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

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

Query duplicate: #17 #23 #29 #35 #41 #47 #53 #65 #71 #77 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311

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:696
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:74

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

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

Query duplicate: #18 #24 #30 #36 #42 #48 #54 #66 #72 #78 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312

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:696
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:74

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

Tempo della query: 35.43 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.851 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:696
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:74

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

Tempo della query: 0.61 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 2.853 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:696
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:74

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

Tempo della query: 0.44 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.859 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:696
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:74

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

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

Query duplicate: #22 #28 #34 #40 #46 #52 #58 #70 #76 #82 #88 #94 #100 #106 #112 #118 #124 #130 #136 #142 #148 #154 #160 #166 #172 #178 #184 #190 #196 #202 #208 #214 #220 #226 #232 #238 #244 #250 #256 #262 #268 #274 #280 #286 #292 #298 #304 #310 #316

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:696
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:74

[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.16 ms Memoria query: 0.027 MB memoria prima della query: 2.869 MB Righe restituite: 17

Query duplicate: #17 #23 #29 #35 #41 #47 #53 #59 #71 #77 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311

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:696
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:74

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

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

Query duplicate: #18 #24 #30 #36 #42 #48 #54 #60 #72 #78 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312

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:696
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:74

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

Tempo della query: 35.10 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.902 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:696
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:74

[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.12 ms Memoria query: 0.021 MB memoria prima della query: 2.904 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:696
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:74

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

Tempo della query: 0.41 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.910 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:696
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:74

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

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

Query duplicate: #22 #28 #34 #40 #46 #52 #58 #64 #76 #82 #88 #94 #100 #106 #112 #118 #124 #130 #136 #142 #148 #154 #160 #166 #172 #178 #184 #190 #196 #202 #208 #214 #220 #226 #232 #238 #244 #250 #256 #262 #268 #274 #280 #286 #292 #298 #304 #310 #316

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:696
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:74

[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.15 ms Memoria query: 0.022 MB memoria prima della query: 2.911 MB Righe restituite: 17

Query duplicate: #17 #23 #29 #35 #41 #47 #53 #59 #65 #77 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311

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:696
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:74

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

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

Query duplicate: #18 #24 #30 #36 #42 #48 #54 #60 #66 #78 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312

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:696
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:74

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

Tempo della query: 34.73 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.939 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:696
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:74

[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.12 ms Memoria query: 0.021 MB memoria prima della query: 2.940 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:696
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:74

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

Tempo della query: 0.41 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.946 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:696
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:74

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

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

Query duplicate: #22 #28 #34 #40 #46 #52 #58 #64 #70 #82 #88 #94 #100 #106 #112 #118 #124 #130 #136 #142 #148 #154 #160 #166 #172 #178 #184 #190 #196 #202 #208 #214 #220 #226 #232 #238 #244 #250 #256 #262 #268 #274 #280 #286 #292 #298 #304 #310 #316

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:696
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:74

[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.948 MB Righe restituite: 17

Query duplicate: #17 #23 #29 #35 #41 #47 #53 #59 #65 #71 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311

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:696
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:74

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

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

Query duplicate: #18 #24 #30 #36 #42 #48 #54 #60 #66 #72 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312

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:696
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:74

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

Tempo della query: 34.78 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.975 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:696
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:74

[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.11 ms Memoria query: 0.021 MB memoria prima della query: 2.977 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:696
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:74

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

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

Conservazione e colorazione tra nitriti e nitrati. Il lato cancerogeno dei salumi

CURCUMA: SOLO CURCUMINA?

Cibo e (buon) umore: una strada a doppio senso sulla via del benessere

Vitamina D e il nuovo studio: protegge l’intestino e riduce il rischio di cancro al colon

Dolore alla bocca? Tutta colpa della carenza di vitamina D

Semi di lino: tesoro per lo sport e arma contro ipertensione e ipercolesterolemia

Dermatite seborroica, tanti rimedi naturali contro l'infiammazione cutanea

Lo stress dopo il riposo. Come combattere la stanchezza post vacanza

Vitamina C: le dosi raccomandate sono davvero sufficienti?

Dall’abbronzatura al sistema immunitario, ci pensano gli essenziali per l’estate

Le micosi della pelle: un nemico difficile da debellare

Stress, insonnia, stanchezza e crampi: i segreti per un’estate a pieno ritmo

Eritema solare: al mare o in montagna per una vacanza senza scottature

Pesce grasso e omega 3: l’accoppiata vincente contro l’emicrania

Vitamine e minerali, i nutrienti amici della pelle e della vista

Birra, sotto l’ombrellone un concentrato di buonumore e sali minerali

Promemoria per l’estate: i segreti per una pelle sana e abbronzata

Russamento e apnee notturne: il 70% tra bambini e adolescenti vittime dell’insonnia

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

417 query eseguite 1474.72 ms

Trovati 188 duplicati!