Console Debug Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1749855894,
"last": 1749855894,
"now": 1749855894
}
},
"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
}
}
}
Tempo
Memoria
Tempo: 18.57 ms / 18.57 ms Memoria: 0.409 MB / 0.76 MB Application: afterLoad
Tempo: 2545.42 ms / 2563.98 ms Memoria: 3.740 MB / 4.50 MB Application: afterInitialise
Tempo: 23.86 ms / 2587.84 ms Memoria: 0.506 MB / 5.00 MB Application: afterRoute
Tempo: 0.81 ms / 2588.65 ms Memoria: 0.083 MB / 5.08 MB Application: beforeRenderComponent com_k2
Tempo: 0.22 ms / 2588.87 ms Memoria: 0.018 MB / 5.10 MB Application: Before Access::preloadComponents (all components)
Tempo: 1.01 ms / 2589.89 ms Memoria: 0.066 MB / 5.17 MB Application: After Access::preloadComponents (all components)
Tempo: 0.02 ms / 2589.91 ms Memoria: -0.002 MB / 5.17 MB Application: Before Access::getAssetRules (id:160 name:com_k2)
Tempo: 0.58 ms / 2590.49 ms Memoria: 0.009 MB / 5.18 MB Application: After Access::getAssetRules (id:160 name:com_k2)
Tempo: 280.25 ms / 2870.74 ms Memoria: 2.277 MB / 7.45 MB Application: afterRenderComponent com_k2
Tempo: 2.41 ms / 2873.15 ms Memoria: 0.014 MB / 7.47 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Tempo: 0.04 ms / 2873.19 ms Memoria: 0.008 MB / 7.47 MB Application: After Access::getAssetRules (id:1 name:root.1)
Tempo: 6.73 ms / 2879.92 ms Memoria: 0.046 MB / 7.52 MB Application: afterDispatch
Tempo: 16.60 ms / 2896.52 ms Memoria: 0.169 MB / 7.69 MB Application: beforeRenderModule mod_k2_tools (Categorie)
Tempo: 7.59 ms / 2904.11 ms Memoria: 0.069 MB / 7.76 MB Application: afterRenderModule mod_k2_tools (Categorie)
Tempo: 0.07 ms / 2904.18 ms Memoria: -0.010 MB / 7.75 MB Application: beforeRenderModule mod_search (Search)
Tempo: 3.40 ms / 2907.57 ms Memoria: 0.015 MB / 7.76 MB Application: afterRenderModule mod_search (Search)
Tempo: 9.30 ms / 2916.87 ms Memoria: 0.177 MB / 7.94 MB Application: afterRender
Query totali del database: 2559.74 ms
9,77 MB (10.241.632 Bytes)
446 query eseguite 2559.74 ms
Trovati 194 duplicati!
50 duplicati: #17 #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
50 duplicati: #18 #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
- Tempo della query: 0.47 ms Memoria query: 0.023 MB memoria prima della query: 1.039 MB Righe restituite: 0
SELECT `data`
FROM `l1f3_session`
WHERE `session_id` = X'7137686568313764736c686271663130756b316c673630746871'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.43 ms Dopo l'ultima query: 0.94 ms Memoria query: 0.020 MB memoria prima della query: 1.053 MB Righe restituite: 0
SELECT `session_id`
FROM `l1f3_session`
WHERE `session_id` = X'7137686568313764736c686271663130756b316c673630746871'
LIMIT 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.63 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.004 MB memoria prima della query: 1.058 MB
INSERT INTO `l1f3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'7137686568313764736c686271663130756b316c673630746871', 1, 1749855894, 0, '', 0)EXPLAIN non possibile sulla query: INSERT INTO `l1f3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7137686568313764736c686271663130756b316c673630746871', 1, 1749855894, 0, '', 0)Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.87 ms Dopo l'ultima query: 2.99 ms Memoria query: 0.042 MB memoria prima della query: 1.395 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` = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 1.16 ms Dopo l'ultima query: 1.78 ms Memoria query: 0.021 MB memoria prima della query: 1.440 MB Righe restituite: 3
SELECT id, rules
FROM `l1f3_viewlevels`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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.51 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.021 MB memoria prima della query: 1.451 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 = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 1.44 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.035 MB memoria prima della query: 1.472 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 orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.60 ms Dopo l'ultima query: 10.76 ms Memoria query: 0.022 MB memoria prima della query: 1.916 MB Righe restituite: 1
SELECT `value`
FROM `l1f3_admintools_storage`
WHERE `key` = 'cparams'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.55 ms Dopo l'ultima query: 0.34 ms Memoria query: 0.021 MB memoria prima della query: 1.924 MB Righe restituite: 0
SELECT *
FROM `l1f3_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.53 ms Dopo l'ultima query: 11.22 ms Memoria query: 0.021 MB memoria prima della query: 2.164 MB Righe restituite: 0
SELECT `source`,`keepurlparams`
FROM `l1f3_admintools_redirects`
WHERE ((`dest` = 'ricette.html') OR (`dest` = 'ricette.html?start=304') OR ('ricette.html?start=304' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.76 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.005 MB memoria prima della query: 2.168 MB
Update l1f3_contentbuilder_articles As articles, l1f3_content As content, l1f3_contentbuilder_forms As forms, l1f3_contentbuilder_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 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 ) )Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.74 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.005 MB memoria prima della query: 2.174 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 = 0EXPLAIN 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 = 0Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 1.26 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.041 MB memoria prima della query: 2.185 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 50id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.31 ms Dopo l'ultima query: 0.98 ms Memoria query: 0.006 MB memoria prima della query: 2.404 MB
SET SESSION group_concat_max_len = 9999999EXPLAIN non possibile sulla query: SET SESSION group_concat_max_len = 9999999Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.85 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.160 MB memoria prima della query: 2.410 MB Righe restituite: 1
Select *
From l1f3_facileforms_forms
Where id = 5
And published = 1
Order By `ordering`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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.93 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.054 MB memoria prima della query: 2.485 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`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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.71 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 2.560 MB Righe restituite: 17Query 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 orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.52 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.574 MB Righe restituite: 17Query 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 38.02 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.596 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.recordid 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) Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.63 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.021 MB memoria prima della query: 2.598 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.50 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.604 MB Righe restituite: 1
Select *
From l1f3_facileforms_records
Where id = 4764id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.51 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.022 MB memoria prima della query: 2.613 MB Righe restituite: 1Query 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 = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.74 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.608 MB Righe restituite: 17Query 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 orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.54 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.023 MB memoria prima della query: 2.613 MB Righe restituite: 17Query 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 36.94 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.635 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.recordid 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) Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.69 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 2.637 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.48 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.643 MB Righe restituite: 1
Select *
From l1f3_facileforms_records
Where id = 4526id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.49 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.650 MB Righe restituite: 1Query 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 = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.81 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.022 MB memoria prima della query: 2.644 MB Righe restituite: 17Query 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 orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.53 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.023 MB memoria prima della query: 2.650 MB Righe restituite: 17Query 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 37.82 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.672 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.recordid 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) Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.65 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 2.674 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.49 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.023 MB memoria prima della query: 2.686 MB Righe restituite: 1
Select *
From l1f3_facileforms_records
Where id = 4103id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.45 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.694 MB Righe restituite: 1Query 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 = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 2.28 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.688 MB Righe restituite: 17Query 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 orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.56 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.023 MB memoria prima della query: 2.694 MB Righe restituite: 17Query 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 41.75 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.716 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.recordid 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) Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.56 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.021 MB memoria prima della query: 2.718 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.60 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.724 MB Righe restituite: 1
Select *
From l1f3_facileforms_records
Where id = 4098id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.70 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.730 MB Righe restituite: 1Query 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 = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.68 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.725 MB Righe restituite: 17Query 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 orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.61 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 2.730 MB Righe restituite: 17Query 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 36.32 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.753 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.recordid 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) Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.58 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 2.754 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.45 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.761 MB Righe restituite: 1
Select *
From l1f3_facileforms_records
Where id = 4099id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.48 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.767 MB Righe restituite: 1Query 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 = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.70 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.761 MB Righe restituite: 17Query 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 orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.53 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 2.767 MB Righe restituite: 17Query 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 35.37 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.789 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.recordid 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) Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.65 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 2.791 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.41 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.797 MB Righe restituite: 1
Select *
From l1f3_facileforms_records
Where id = 4100id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.51 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.803 MB Righe restituite: 1Query 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 = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.84 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.798 MB Righe restituite: 17Query 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 orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.49 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.023 MB memoria prima della query: 2.803 MB Righe restituite: 17Query 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 37.58 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.825 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.recordid 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) Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.60 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.021 MB memoria prima della query: 2.827 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.46 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.833 MB Righe restituite: 1
Select *
From l1f3_facileforms_records
Where id = 4101id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.48 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.840 MB Righe restituite: 1Query 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 = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.68 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.834 MB Righe restituite: 17Query 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 orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.51 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.023 MB memoria prima della query: 2.840 MB Righe restituite: 17Query 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 36.30 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.862 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.recordid 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) Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.57 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 2.864 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.47 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.870 MB Righe restituite: 1
Select *
From l1f3_facileforms_records
Where id = 4092id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.44 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 2.876 MB Righe restituite: 1Query 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 = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.78 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.027 MB memoria prima della query: 2.880 MB Righe restituite: 17Query 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 orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.69 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.023 MB memoria prima della query: 2.891 MB Righe restituite: 17Query 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 36.67 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 2.913 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.recordid 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) Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.61 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 2.915 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.42 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.022 MB memoria prima della query: 2.921 MB Righe restituite: 1
Select *
From l1f3_facileforms_records
Where id = 4552id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.49 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.927 MB Righe restituite: 1Query 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 = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.67 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.922 MB Righe restituite: 17Query 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 orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.47 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.927 MB Righe restituite: 17Query 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 36.26 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.949 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.recordid 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) Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.61 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 2.951 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'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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.42 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.957 MB Righe restituite: 1
Select *
From l1f3_facileforms_records
Where id = 4094id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.42 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.964 MB Righe restituite: 1Query duplicate: #22 #28 #34 #40 #46 #52 #58 #64 #70 #82 #88 #94 #100 #106 #112 #118 #124 #130 #136 #142 #148 #154 #160 #166 #172 #178 #184 #190 #196 #202 #208 #214 #220 #226 #232 #238 #244 #250 #256 #262 #268 #274 #280 #286 #292 #298 #304 #310 #316
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From l1f3_contentbuilder_forms
Where id = 1id 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.74 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 2.958 MB Righe restituite: 17Query duplicate: #17 #23 #29 #35 #41 #47 #53 #59 #65 #71 #83 #89 #95 #101 #107 #113 #119 #125 #131 #137 #143 #149 #155 #161 #167 #173 #179 #185 #191 #197 #203 #209 #215 #221 #227 #233 #239 #245 #251 #257 #263 #269 #275 #281 #287 #293 #299 #305 #311
Select Distinct `label`, reference_id
From l1f3_contentbuilder_elements
Where form_id = 1
And reference_id In ('199','200','208','201','242','202','207','332','209','255','269','295','296','345','431','274','508')
And published = 1
Order By orderingid 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 Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)# 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 - Tempo della query: 0.50 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 2.964 MB Righe restituite: 17