Secondi Piatti

Attenzione

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

Spiedini di pollo, melanzane e peperoni

Rotolo di frittata, prosciutto cotto e spinaci

Bocconcini di pollo alle verdure

Involtini di sogliola profumati

Scaloppine con prosciutto crudo e ricotta

Arrosto di tacchino con salsa di ricotta

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1752122625,
                "last": 1752122625,
                "now": 1752122625
            }
        },
        "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'6f7031713230656162376874667668616f756a307376686f6867', 1, 1752122625, 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.79 ms Dopo l'ultima query: 2.36 ms Memoria query: 0.042 MB memoria prima della query: 1.394 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: 0.44 ms Dopo l'ultima query: 1.39 ms Memoria query: 0.021 MB memoria prima della query: 1.438 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.46 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.021 MB memoria prima della query: 1.450 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.16 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.035 MB memoria prima della query: 1.471 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: 0.43 ms Dopo l'ultima query: 11.03 ms Memoria query: 0.022 MB memoria prima della query: 1.914 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.45 ms Dopo l'ultima query: 0.34 ms Memoria query: 0.021 MB memoria prima della query: 1.923 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.48 ms Dopo l'ultima query: 9.54 ms Memoria query: 0.021 MB memoria prima della query: 2.162 MB Righe restituite: 0

SELECT `source`,`keepurlparams`

  FROM `l1f3_admintools_redirects`

  WHERE ((`dest` = 'ricette/content/12-secondi-piatti.html') OR (`dest` = 'ricette/content/12-secondi-piatti.html') OR ('ricette/content/12-secondi-piatti.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.64 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.005 MB memoria prima della query: 2.166 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: 0.58 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.005 MB memoria prima della query: 2.172 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.03 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.041 MB memoria prima della query: 2.184 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.32 ms Dopo l'ultima query: 1.07 ms Memoria query: 0.006 MB memoria prima della query: 2.402 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.83 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.160 MB memoria prima della query: 2.408 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.68 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.054 MB memoria prima della query: 2.483 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.59 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.022 MB memoria prima della query: 2.558 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.41 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.023 MB memoria prima della query: 2.572 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: 17.74 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.595 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.58 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.021 MB memoria prima della query: 2.597 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.41 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.603 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.38 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.612 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.52 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.606 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.40 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.023 MB memoria prima della query: 2.611 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: 18.33 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.634 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.62 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 2.635 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.44 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.642 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.38 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.648 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.57 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.642 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.42 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.023 MB memoria prima della query: 2.648 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: 23.37 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.670 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.51 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 2.672 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.40 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.685 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.45 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.692 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.59 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.687 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.44 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.692 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: 17.79 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.714 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.82 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.021 MB memoria prima della query: 2.716 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.39 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.722 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: 0.40 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.729 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.53 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.723 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.47 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.729 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: 18.14 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.751 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.76 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 2.753 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.39 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.759 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.45 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.765 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.56 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.760 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.44 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.765 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: 18.06 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.787 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.52 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 2.789 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.39 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.795 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.42 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.802 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.51 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.796 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.38 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 2.801 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: 17.64 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.824 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.49 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.021 MB memoria prima della query: 2.826 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.38 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.022 MB memoria prima della query: 2.832 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.40 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.838 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.56 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.833 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.40 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.838 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: 17.48 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.860 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.48 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.021 MB memoria prima della query: 2.862 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.42 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.868 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.41 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.874 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.57 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.027 MB memoria prima della query: 2.878 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.40 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.889 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: 17.19 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.911 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.51 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.021 MB memoria prima della query: 2.913 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.43 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.919 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.43 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.926 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.54 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.920 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.45 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.926 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: 17.37 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.948 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.48 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.021 MB memoria prima della query: 2.950 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.39 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.022 MB memoria prima della query: 2.956 MB Righe restituite: 1

Attenzione

Spiedini di pollo, melanzane e peperoni

Fegato d'oca alla borghese

Calamari ripieni al forno

Manzo al Porto

Pollo, prosciutto e funghi

Rotolo di frittata, prosciutto cotto e spinaci

Scaloppine alla menta

Cernia limone e aneto

Tacchino speziato al forno

Bocconcini di pollo alle verdure

Salmone al vapore marinato

Involtini di sogliola profumati

Cosce di pollo piccanti

Scaloppine con prosciutto crudo e ricotta

Arrosto di tacchino con salsa di ricotta

Pesce spada mediterraneo

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

458 query eseguite 1096.97 ms

Trovati 222 duplicati!