Console Debug Joomla!
{ "__default": { "session": { "counter": 1, "timer": { "start": 1743025778, "last": 1743025778, "now": 1743025778 } }, "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: 15.10 ms / 15.10 ms Memoria: 0.409 MB / 0.75 MB Application: afterLoad
Tempo: 2208.80 ms / 2223.90 ms Memoria: 3.736 MB / 4.49 MB Application: afterInitialise
Tempo: 19.50 ms / 2243.40 ms Memoria: 0.506 MB / 5.00 MB Application: afterRoute
Tempo: 0.62 ms / 2244.02 ms Memoria: 0.083 MB / 5.08 MB Application: beforeRenderComponent com_k2
Tempo: 0.13 ms / 2244.15 ms Memoria: 0.018 MB / 5.10 MB Application: Before Access::preloadComponents (all components)
Tempo: 1.25 ms / 2245.41 ms Memoria: 0.066 MB / 5.16 MB Application: After Access::preloadComponents (all components)
Tempo: 0.03 ms / 2245.43 ms Memoria: -0.002 MB / 5.16 MB Application: Before Access::getAssetRules (id:160 name:com_k2)
Tempo: 0.44 ms / 2245.88 ms Memoria: 0.009 MB / 5.17 MB Application: After Access::getAssetRules (id:160 name:com_k2)
Tempo: 158.23 ms / 2404.11 ms Memoria: 1.999 MB / 7.17 MB Application: afterRenderComponent com_k2
Tempo: 2.17 ms / 2406.27 ms Memoria: 0.013 MB / 7.18 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Tempo: 0.04 ms / 2406.31 ms Memoria: 0.008 MB / 7.19 MB Application: After Access::getAssetRules (id:1 name:root.1)
Tempo: 6.73 ms / 2413.04 ms Memoria: 0.046 MB / 7.24 MB Application: afterDispatch
Tempo: 13.78 ms / 2426.83 ms Memoria: 0.152 MB / 7.39 MB Application: beforeRenderModule mod_search (Search)
Tempo: 3.83 ms / 2430.66 ms Memoria: 0.016 MB / 7.40 MB Application: afterRenderModule mod_search (Search)
Tempo: 24.82 ms / 2455.48 ms Memoria: 0.523 MB / 7.93 MB Application: afterRender
Query totali del database: 2161.60 ms
9,60 MB (10.068.328 Bytes)
380 query eseguite 2161.60 ms
Trovati 170 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: 1.30 ms Memoria query: 0.023 MB memoria prima della query: 1.036 MB Righe restituite: 0
SELECT `data`
FROM `l1f3_session`
WHERE `session_id` = X'6c3263767638697031726e6c7669713169366a7431686a617137'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.54 ms Dopo l'ultima query: 1.57 ms Memoria query: 0.020 MB memoria prima della query: 1.051 MB Righe restituite: 0
SELECT `session_id`
FROM `l1f3_session`
WHERE `session_id` = X'6c3263767638697031726e6c7669713169366a7431686a617137'
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: 1.78 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.004 MB memoria prima della query: 1.056 MB
INSERT INTO `l1f3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6c3263767638697031726e6c7669713169366a7431686a617137', 1, 1743025778, 0, '', 0)EXPLAIN non possibile sulla query: INSERT INTO `l1f3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6c3263767638697031726e6c7669713169366a7431686a617137', 1, 1743025778, 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: 1.13 ms Dopo l'ultima query: 5.85 ms Memoria query: 0.042 MB memoria prima della query: 1.389 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: 0.54 ms Dopo l'ultima query: 1.57 ms Memoria query: 0.021 MB memoria prima della query: 1.434 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: 1.33 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.021 MB memoria prima della query: 1.445 MB Righe restituite: 1
SELECT b.id
FROM l1f3_usergroups AS a
LEFT JOIN l1f3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 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: 2.70 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.035 MB memoria prima della query: 1.466 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: 1.69 ms Dopo l'ultima query: 22.32 ms Memoria query: 0.022 MB memoria prima della query: 1.909 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.49 ms Dopo l'ultima query: 0.49 ms Memoria query: 0.021 MB memoria prima della query: 1.918 MB Righe restituite: 0
SELECT *
FROM `l1f3_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')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.55 ms Dopo l'ultima query: 18.15 ms Memoria query: 0.021 MB memoria prima della query: 2.158 MB Righe restituite: 0
SELECT `source`,`keepurlparams`
FROM `l1f3_admintools_redirects`
WHERE ((`dest` = 'informazione-salute/tag/malattie.html') OR (`dest` = 'informazione-salute/tag/malattie.html') OR ('informazione-salute/tag/malattie.html' 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: 1.46 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.005 MB memoria prima della query: 2.161 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.91 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.005 MB memoria prima della query: 2.167 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: 2.56 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.041 MB memoria prima della query: 2.179 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.50 ms Dopo l'ultima query: 2.43 ms Memoria query: 0.006 MB memoria prima della query: 2.397 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: 1.70 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.160 MB memoria prima della query: 2.403 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: 1.23 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.054 MB memoria prima della query: 2.478 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: 2.02 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.553 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.68 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.023 MB memoria prima della query: 2.568 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: 58.22 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 2.590 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.83 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 2.592 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.47 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.598 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.47 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.022 MB memoria prima della query: 2.607 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.77 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.601 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.07 ms Memoria query: 0.023 MB memoria prima della query: 2.607 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: 37.54 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.629 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.63 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 2.631 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.52 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.637 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.52 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.643 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.16 ms Memoria query: 0.022 MB memoria prima della query: 2.638 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.62 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.023 MB memoria prima della query: 2.643 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: 38.61 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.665 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.74 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 2.667 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.53 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.023 MB memoria prima della query: 2.680 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.58 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.688 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: 0.78 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.022 MB memoria prima della query: 2.682 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.61 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.023 MB memoria prima della query: 2.687 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.07 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.710 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.60 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.021 MB memoria prima della query: 2.711 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.45 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.022 MB memoria prima della query: 2.717 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.45 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.724 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.75 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.718 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.51 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.724 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: 37.67 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.746 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.55 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.021 MB memoria prima della query: 2.748 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.43 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.754 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.46 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.761 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.77 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.755 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.51 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.760 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: 43.41 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.783 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: 1.35 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.021 MB memoria prima della query: 2.784 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.88 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.790 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.45 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.797 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.71 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.791 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.53 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.797 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: 36.28 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.819 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.62 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 2.821 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.53 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 2.827 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.09 ms Memoria query: 0.022 MB memoria prima della query: 2.834 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.80 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.022 MB memoria prima della query: 2.828 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.59 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.023 MB memoria prima della query: 2.833 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: 40.73 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.855 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.65 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 2.857 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.84 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.022 MB memoria prima della query: 2.863 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.55 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.870 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.75 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.027 MB memoria prima della query: 2.874 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: 1.36 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.023 MB memoria prima della query: 2.884 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: 42.16 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.022 MB memoria prima della query: 2.907 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.82 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 2.908 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.51 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 2.914 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.52 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.921 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.84 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.022 MB memoria prima della query: 2.915 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: 1.35 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.023 MB memoria prima della query: 2.921 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: 37.20 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 2.943 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.99 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.021 MB memoria prima della query: 2.945 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.55 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 2.951 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.45 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.957 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.76 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 2.952 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.56 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 2.957 MB Righe restituite: 17Query duplicate: #18 #24 #30 #36 #42 #48 #54 #60 #66 #72 #84 #90 #96 #102 #108 #114 #120 #126 #132 #138 #144 #150 #156 #162 #168 #174 #180 #186 #192 #198 #204 #210 #216 #222 #228 #234 #240 #246 #252 #258 #264 #270 #276 #282 #288 #294 #300 #306 #312
Select id, `title`, `name`, `type`
From l1f3_facileforms_elements
Where form = 5
And published = 1
And `name` <> 'bfFakeName'
And `name` <> 'bfFakeName2'
And `name` <> 'bfFakeName3'
And `name` <> 'bfFakeName4'
And `name` <> 'bfFakeName5'
And `name` <> 'bfFakeName6'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.05 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 2.980 MB Righe restituite: 1
Select GROUP_CONCAT( (
Case When s.`element` = '199' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( (
Case When s.`element` = '200' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( (
Case When s.`element` = '201' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( (
Case When s.`element` = '202' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( (
Case When s.`element` = '207' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( (
Case When s.`element` = '208' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( (
Case When s.`element` = '209' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( (
Case When s.`element` = '242' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( (
Case When s.`element` = '255' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( (
Case When s.`element` = '269' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( (
Case When s.`element` = '274' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( (
Case When s.`element` = '295' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( (
Case When s.`element` = '296' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( (
Case When s.`element` = '332' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( (
Case When s.`element` = '345' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( (
Case When s.`element` = '431' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( (
Case When s.`element` = '508' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col508Value`, joined_records.rating_sum / joined_records.rating_count As colRating, joined_records.rating_count As colRatingCount, joined_records.rating_sum As colRatingSum
From l1f3_facileforms_subrecords As s, l1f3_facileforms_records As r
Left Join l1f3_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_breezingforms'
And joined_records.record_id = r.id
And joined_records.reference_id = r.form )
Where r.id = '4550'
And joined_records.`type` = 'com_breezingforms'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And r.form = 5
And s.record = r.id
And r.archived = 0
Group By s.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.73 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 2.981 MB Righe restituite: 1
Select metakey, metadesc, author, robots, rights, xreference
From l1f3_contentbuilder_records
Where `type` = 'com_breezingforms'
And reference_id = '5'
And record_id = '4550'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.07 ms Memoria query: 0.022 MB memoria prima della query: 2.987 MB Righe restituite: 1
Select *
From l1f3_facileforms_records
Where id = 4550id 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.12 ms Memoria query: 0.022 MB memoria prima della query: 2.994 MB Righe restituite: 1Query duplicate: #22 #28 #34 #40 #46 #52 #58 #64 #70 #76 #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.76 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.022 MB memoria prima della query: 2.988 MB Righe restituite: 17Query duplicate: #17 #23 #29 #35 #41 #47 #53 #59 #65 #71 #77 #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.57 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.023 MB memoria prima della query: 2.994 MB Righe restituite: 17Query duplicate: #18 #24 #30 #36 #42 #48 #54 #60 #66 #72 #78 #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: 31.30 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 3.016 MB Righe restituite: 1
Select GROUP_CONCAT( (
Case When s.`element` = '199' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col199Value`,GROUP_CONCAT( (
Case When s.`element` = '200' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col200Value`,GROUP_CONCAT( (
Case When s.`element` = '201' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col201Value`,GROUP_CONCAT( (
Case When s.`element` = '202' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col202Value`,GROUP_CONCAT( (
Case When s.`element` = '207' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col207Value`,GROUP_CONCAT( (
Case When s.`element` = '208' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col208Value`,GROUP_CONCAT( (
Case When s.`element` = '209' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col209Value`,GROUP_CONCAT( (
Case When s.`element` = '242' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col242Value`,GROUP_CONCAT( (
Case When s.`element` = '255' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col255Value`,GROUP_CONCAT( (
Case When s.`element` = '269' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col269Value`,GROUP_CONCAT( (
Case When s.`element` = '274' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col274Value`,GROUP_CONCAT( (
Case When s.`element` = '295' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col295Value`,GROUP_CONCAT( (
Case When s.`element` = '296' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col296Value`,GROUP_CONCAT( (
Case When s.`element` = '332' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col332Value`,GROUP_CONCAT( (
Case When s.`element` = '345' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col345Value`,GROUP_CONCAT( (
Case When s.`element` = '431' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col431Value`,GROUP_CONCAT( (
Case When s.`element` = '508' Then s.`value` End )
Order By s.`id` SEPARATOR ', ' ) As `col508Value`, joined_records.rating_sum / joined_records.rating_count As colRating, joined_records.rating_count As colRatingCount, joined_records.rating_sum As colRatingSum
From l1f3_facileforms_subrecords As s, l1f3_facileforms_records As r
Left Join l1f3_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_breezingforms'
And joined_records.record_id = r.id
And joined_records.reference_id = r.form )
Where r.id = '4551'
And joined_records.`type` = 'com_breezingforms'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And r.form = 5
And s.record = r.id
And r.archived = 0
Group By s.recordid