Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgContentJoomPlu has a deprecated constructor in /var/www/html/app/plugins/content/joomplu/joomplu.php on line 26
jQuery(window).on('load', function() {
new JCaption('img.caption');
});
jQuery(function($){ initTooltips(); $("body").on("subform-row-add", initTooltips); function initTooltips (event, container) { container = container || document;$(container).find(".hasTooltip").tooltip({"html": true,"container": "body"});} });
jQuery(function($){ initPopovers(); $("body").on("subform-row-add", initPopovers); function initPopovers (event, container) { $(container || document).find(".hasPopover").popover({"html": true,"placement": "top","trigger": "hover focus","container": "body"});} });
jQuery.urlShortener.settings.apiKey='AIzaSyB9Z_0jbJ4-cZAis8KkEgZE2iGWFTQd8nE';
jQuery.urlShortener({
longUrl: "",
success: function (shortUrl) {
//shortUrl -> Shortened URL
jQuery("meta[property='og:url']").attr('content',shortUrl);
href=jQuery("#twitterhref").attr('href');
jQuery("#twitterhref").attr('href',href+'&url='+shortUrl);
},
error: function(err)
{
alert(JSON.stringify(err));
}
});
Console Debug Joomla!
{ "__default": { "session": { "counter": 1, "timer": { "start": 1758173138, "last": 1758173138, "now": 1758173138 } }, "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: 39.45 ms / 39.45 ms Memoria: 2.221 MB / 2.59 MB Application: afterLoad
Tempo: 152.82 ms / 192.27 ms Memoria: 6.113 MB / 8.71 MB Application: afterInitialise
Tempo: 38.02 ms / 230.29 ms Memoria: 1.732 MB / 10.44 MB Application: afterRoute
Tempo: 17.27 ms / 247.56 ms Memoria: 0.247 MB / 10.69 MB Application: beforeRenderComponent com_content
Tempo: 6.43 ms / 253.99 ms Memoria: 0.389 MB / 11.08 MB Application: Before Access::preloadComponents (all components)
Tempo: 2.12 ms / 256.10 ms Memoria: 0.063 MB / 11.14 MB Application: After Access::preloadComponents (all components)
Tempo: 0.03 ms / 256.13 ms Memoria: 0.000 MB / 11.13 MB Application: Before Access::preloadPermissions (com_content)
Tempo: 2.82 ms / 258.96 ms Memoria: 0.643 MB / 11.78 MB Application: After Access::preloadPermissions (com_content)
Tempo: 0.06 ms / 259.01 ms Memoria: 0.000 MB / 11.74 MB Application: Before Access::getAssetRules (id:4859 name:com_content.article.2136)
Tempo: 1.06 ms / 260.08 ms Memoria: 0.034 MB / 11.78 MB Application: After Access::getAssetRules (id:4859 name:com_content.article.2136)
Tempo: 105.31 ms / 365.39 ms Memoria: 2.397 MB / 14.17 MB Application: afterRenderComponent com_content
Tempo: 49.16 ms / 414.56 ms Memoria: 0.951 MB / 15.13 MB Application: afterDispatch
Tempo: 29.26 ms / 443.81 ms Memoria: 0.158 MB / 15.28 MB Application: beforeRenderModule mod_menu (Menu Footer)
Tempo: 6.40 ms / 450.21 ms Memoria: 0.096 MB / 15.38 MB Application: afterRenderModule mod_menu (Menu Footer)
Tempo: 0.08 ms / 450.29 ms Memoria: 0.000 MB / 15.38 MB Application: beforeRenderModule mod_fibfooter (FIB: FOOTER COMITATO)
Tempo: 7.76 ms / 458.05 ms Memoria: 0.049 MB / 15.42 MB Application: afterRenderModule mod_fibfooter (FIB: FOOTER COMITATO)
Tempo: 0.08 ms / 458.13 ms Memoria: 0.000 MB / 15.42 MB Application: beforeRenderModule mod_mixedmenu (Main Menu)
Tempo: 7.43 ms / 465.56 ms Memoria: 0.149 MB / 15.57 MB Application: afterRenderModule mod_mixedmenu (Main Menu)
Tempo: 0.09 ms / 465.65 ms Memoria: 0.000 MB / 15.56 MB Application: beforeRenderModule mod_custom (vai a FIB)
Tempo: 1.43 ms / 467.07 ms Memoria: 0.006 MB / 15.57 MB Application: afterRenderModule mod_custom (vai a FIB)
Tempo: 0.07 ms / 467.14 ms Memoria: 0.000 MB / 15.57 MB Application: beforeRenderModule mod_custom (panino in loadposition)
Tempo: 34.71 ms / 501.85 ms Memoria: 0.058 MB / 15.63 MB Application: beforeRenderModule mod_hamburger (Panino Main Menu)
Tempo: 2.25 ms / 504.10 ms Memoria: 0.005 MB / 15.63 MB Application: afterRenderModule mod_hamburger (Panino Main Menu)
Tempo: 0.50 ms / 504.60 ms Memoria: 0.000 MB / 15.59 MB Application: afterRenderModule mod_custom (panino in loadposition)
Tempo: 0.09 ms / 504.69 ms Memoria: 0.000 MB / 15.59 MB Application: beforeRenderModule mod_search (cerca testata)
Tempo: 2.36 ms / 507.05 ms Memoria: 0.088 MB / 15.68 MB Application: afterRenderModule mod_search (cerca testata)
Tempo: 0.06 ms / 507.11 ms Memoria: 0.000 MB / 15.67 MB Application: beforeRenderModule mod_fibtestata (FIB: TESTATA COMITATO)
Tempo: 3.53 ms / 510.65 ms Memoria: 0.018 MB / 15.69 MB Application: afterRenderModule mod_fibtestata (FIB: TESTATA COMITATO)
Tempo: 0.11 ms / 510.76 ms Memoria: 0.000 MB / 15.69 MB Application: beforeRenderModule mod_custom (Slide testata)
Tempo: 0.89 ms / 511.65 ms Memoria: 0.003 MB / 15.69 MB Application: afterRenderModule mod_custom (Slide testata)
Tempo: 0.08 ms / 511.72 ms Memoria: 0.000 MB / 15.69 MB Application: beforeRenderModule mod_custom (logo immagine)
Tempo: 1.16 ms / 512.88 ms Memoria: 0.003 MB / 15.69 MB Application: afterRenderModule mod_custom (logo immagine)
Tempo: 30.24 ms / 543.12 ms Memoria: 0.231 MB / 15.93 MB Application: afterRender
Query totali del database: 62.01 ms
16,36 MB (17.151.816 Bytes)
32 query eseguite 62.01 ms
- Tempo della query: 1.22 ms Memoria query: 0.025 MB memoria prima della query: 3.864 MB Righe restituite: 0
SELECT `data`
FROM `cp_alessandria_session`
WHERE `session_id` = X'3865663639316230666263633430353461663761613231613266386630393261'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.23 ms Executing hook on transaction 0.02 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms executing 0.03 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.05 ms # 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:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo della query: 0.76 ms Dopo l'ultima query: 2.56 ms Memoria query: 0.022 MB memoria prima della query: 4.028 MB Righe restituite: 0
SELECT `session_id`
FROM `cp_alessandria_session`
WHERE `session_id` = X'3865663639316230666263633430353461663761613231613266386630393261'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.02 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.03 ms # 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo della query: 6.26 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.004 MB memoria prima della query: 4.033 MB
INSERT INTO `cp_alessandria_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3865663639316230666263633430353461663761613231613266386630393261', 1, 1758173138, 0, '', 0)EXPLAIN non possibile sulla query: INSERT INTO `cp_alessandria_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3865663639316230666263633430353461663761613231613266386630393261', 1, 1758173138, 0, '', 0)Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms update 0.22 ms end 0.01 ms query end 0.01 ms waiting for handler commit 5.34 ms closing tables 0.08 ms freeing items 0.06 ms cleaning up 0.02 ms # 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo della query: 1.55 ms Dopo l'ultima query: 6.05 ms Memoria query: 0.043 MB memoria prima della query: 4.244 MB Righe restituite: 49
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `hvdqo_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 hvdqo_extensions NULL ref extension extension 82 const 51 1.00 Using where Status Duration starting 0.14 ms Executing hook on transaction 0.02 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.04 ms executing 0.27 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.05 ms # 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.05 ms Dopo l'ultima query: 3.89 ms Memoria query: 0.023 MB memoria prima della query: 4.460 MB Righe restituite: 5
SELECT id, rules
FROM `cp_alessandria_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_viewlevels NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 5 100.00 NULL Status Duration starting 0.12 ms Executing hook on transaction 0.05 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.03 ms executing 0.05 ms end 0.01 ms query end 0.12 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.47 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 4.472 MB Righe restituite: 2
SELECT b.id
FROM cp_alessandria_usergroups AS a
LEFT JOIN cp_alessandria_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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 2 100.00 Using where; Using index Status Duration starting 0.28 ms Executing hook on transaction 0.03 ms starting 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.05 ms executing 0.10 ms end 0.01 ms query end 0.03 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.05 ms # 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.72 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.034 MB memoria prima della query: 4.493 MB Righe restituite: 100
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `hvdqo_extensions`
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hvdqo_extensions NULL ref extension extension 82 const 166 0.60 Using where; Using filesort Status Duration starting 0.18 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.65 ms end 0.01 ms query end 0.03 ms waiting for handler commit 0.01 ms closing tables 0.06 ms freeing items 0.04 ms cleaning up 0.05 ms # 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:354 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:359 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.72 ms Dopo l'ultima query: 90.10 ms Memoria query: 0.005 MB memoria prima della query: 8.540 MB
DELETE
FROM `cp_alessandria_jhackguard_ip_filters`
WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY)
AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)EXPLAIN non possibile sulla query: DELETE FROM `cp_alessandria_jhackguard_ip_filters` WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)Status Duration starting 0.13 ms Executing hook on transaction 0.02 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.04 ms updating 0.04 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File e numero di linea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 9 JDatabase->query() JROOT/plugins/system/jhackguard/jhackguard.php:156 8 PlgSystemJhackguard->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.58 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.023 MB memoria prima della query: 8.548 MB Righe restituite: 0
SELECT `state`,`rule_type`
FROM `cp_alessandria_jhackguard_ip_filters`
WHERE `ip` ='35.191.81.219'
AND `state` = 1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_jhackguard_ip_filters NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/plugins/system/jhackguard/jhackguard.php:358 9 PlgSystemJhackguard->ip_is() JROOT/plugins/system/jhackguard/jhackguard.php:174 8 PlgSystemJhackguard->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.89 ms Dopo l'ultima query: 5.54 ms Memoria query: 0.039 MB memoria prima della query: 8.951 MB Righe restituite: 15
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM cp_alessandria_menu AS m
LEFT JOIN `hvdqo_extensions` AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 16 10.00 Using index condition; Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 web_federbocce_comitati.m.component_id 1 100.00 Using where Status Duration starting 0.23 ms Executing hook on transaction 0.03 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.02 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.05 ms executing 0.25 ms end 0.01 ms query end 0.09 ms waiting for handler commit 0.03 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.07 ms # Caller File e numero di linea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Chiamata uguale alla linea sottostante. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1073 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.06 ms Dopo l'ultima query: 33.82 ms Memoria query: 0.025 MB memoria prima della query: 10.472 MB Righe restituite: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `hvdqo_extensions`
WHERE `type` ='library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hvdqo_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.23 ms Executing hook on transaction 0.02 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.02 ms executing 0.06 ms end 0.01 ms query end 0.03 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.08 ms # Caller File e numero di linea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Chiamata uguale alla linea sottostante. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1130 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 7.87 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.005 MB memoria prima della query: 10.463 MB
UPDATE `hvdqo_extensions`
SET `params` ='{\"mediaversion\":\"882a655abd4feca6dab419ded2b02f21\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN non possibile sulla query: UPDATE `hvdqo_extensions` SET `params` ='{\"mediaversion\":\"882a655abd4feca6dab419ded2b02f21\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.26 ms Executing hook on transaction 0.01 ms starting 0.03 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.02 ms System lock 0.19 ms updating 0.27 ms end 0.01 ms query end 0.03 ms waiting for handler commit 6.27 ms closing tables 0.16 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File e numero di linea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1130 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.51 ms Dopo l'ultima query: 2.87 ms Memoria query: 0.025 MB memoria prima della query: 10.644 MB Righe restituite: 1
SELECT *
FROM cp_alessandria_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_languages NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.22 ms Executing hook on transaction 0.02 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.05 ms executing 0.15 ms end 0.01 ms query end 0.03 ms waiting for handler commit 0.04 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.03 ms # Caller File e numero di linea 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.71 ms Dopo l'ultima query: 0.34 ms Memoria query: 0.021 MB memoria prima della query: 10.663 MB Righe restituite: 3
SELECT id, home, template, s.params
FROM cp_alessandria_template_styles as s
LEFT JOIN `hvdqo_extensions` as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 5 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 web_federbocce_comitati.e.element 1 60.00 Using index condition; Using where Status Duration starting 0.37 ms Executing hook on transaction 0.02 ms starting 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.02 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.26 ms preparing 0.07 ms executing 0.19 ms end 0.01 ms query end 0.04 ms waiting for handler commit 0.03 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.03 ms # Caller File e numero di linea 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.82 ms Dopo l'ultima query: 7.57 ms Memoria query: 0.031 MB memoria prima della query: 11.079 MB Righe restituite: 46
SELECT `id`,`name`,`rules`,`parent_id`
FROM `cp_alessandria_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_ajaxresponse','com_akquickicons','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_docman','com_eventi','com_f_iteam','com_fields','com_finder','com_focontentuploader','com_import','com_installer','com_jce','com_jhackguard','com_jmap','com_joomgallery','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mightysites','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_social','com_tags','com_templates','com_tesseramento','com_users','com_watchfulli','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_assets NULL range idx_asset_name idx_asset_name 202 NULL 50 100.00 Using index condition Status Duration starting 0.25 ms Executing hook on transaction 0.03 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.25 ms preparing 0.04 ms executing 0.46 ms end 0.01 ms query end 0.06 ms waiting for handler commit 0.05 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.06 ms # Caller File e numero di linea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.65 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.125 MB memoria prima della query: 11.134 MB Righe restituite: 836
SELECT `id`,`name`,`rules`,`parent_id`
FROM `cp_alessandria_assets`
WHERE `name` LIKE'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_assets NULL ALL idx_asset_name,idx_parent_id NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1274 23.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.97 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.02 ms # Caller File e numero di linea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 2.95 ms Dopo l'ultima query: 3.72 ms Memoria query: 0.036 MB memoria prima della query: 11.820 MB Righe restituite: 31
SHOW FULL COLUMNS
FROM `cp_alessandria_content`EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `cp_alessandria_content`Status Duration starting 0.28 ms checking permissions 0.03 ms checking permissions 0.01 ms Opening tables 1.05 ms init 0.03 ms System lock 0.02 ms optimizing 0.06 ms statistics 0.11 ms preparing 0.03 ms Creating tmp table 0.06 ms executing 0.11 ms checking permissions 0.08 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.07 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.02 ms closing tables 0.07 ms freeing items 0.07 ms cleaning up 0.08 ms # Caller File e numero di linea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 5.22 ms Dopo l'ultima query: 6.28 ms Memoria query: 0.005 MB memoria prima della query: 12.064 MB
UPDATE cp_alessandria_content
SET `hits` = (`hits` + 1)
WHERE `id` ='2136'EXPLAIN non possibile sulla query: UPDATE cp_alessandria_content SET `hits` = (`hits` + 1) WHERE `id` ='2136'Status Duration starting 0.17 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.10 ms updating 0.23 ms end 0.01 ms query end 0.02 ms waiting for handler commit 4.06 ms closing tables 0.08 ms freeing items 0.05 ms cleaning up 0.06 ms # Caller File e numero di linea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.66 ms Dopo l'ultima query: 2.48 ms Memoria query: 0.037 MB memoria prima della query: 12.189 MB Righe restituite: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified ='0000-00-00 00:00:00'THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM cp_alessandria_content AS a
INNER JOIN cp_alessandria_categories AS c
on c.id = a.catid
LEFT JOIN cp_alessandria_users AS u
on u.id = a.created_by
LEFT JOIN cp_alessandria_categories as parent
ON parent.id = c.parent_id
LEFT JOIN cp_alessandria_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 2136
AND c.published > 0
AND (a.publish_up ='0000-00-00 00:00:00' OR a.publish_up <= '2025-09-18 05:25:38')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-09-18 05:25:38')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.40 ms Executing hook on transaction 0.03 ms starting 0.05 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.01 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.26 ms preparing 0.03 ms executing 0.05 ms end 0.01 ms query end 0.04 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.16 ms # Caller File e numero di linea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.67 ms Dopo l'ultima query: 4.98 ms Memoria query: 0.041 MB memoria prima della query: 12.414 MB Righe restituite: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `cp_alessandria_categories` AS `s`
INNER JOIN `cp_alessandria_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 18
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 11 59.50 Using where Status Duration starting 0.36 ms Executing hook on transaction 0.03 ms starting 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.02 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.25 ms preparing 0.08 ms executing 0.17 ms end 0.02 ms query end 0.02 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.11 ms # Caller File e numero di linea 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Chiamata uguale alla linea sottostante. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.00 ms Dopo l'ultima query: 1.38 ms Memoria query: 0.035 MB memoria prima della query: 12.468 MB Righe restituite: 0
SELECT `m`.`tag_id`,`t`.*
FROM `cp_alessandria_contentitem_tag_map` AS m
INNER JOIN `cp_alessandria_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` ='com_content.article'
AND `m`.`content_item_id` = 2136
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 web_federbocce_comitati.m.tag_id 1 100.00 Using where Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.05 ms # Caller File e numero di linea 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 2.18 ms Dopo l'ultima query: 29.57 ms Memoria query: 0.038 MB memoria prima della query: 13.162 MB Righe restituite: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM cp_alessandria_fields AS a
LEFT JOIN `cp_alessandria_languages` AS l
ON l.lang_code = a.language
LEFT JOIN cp_alessandria_users AS uc
ON uc.id=a.checked_out
LEFT JOIN cp_alessandria_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN cp_alessandria_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN cp_alessandria_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `cp_alessandria_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context ='com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (18,0,16))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 web_federbocce_comitati.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 web_federbocce_comitati.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 web_federbocce_comitati.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 web_federbocce_comitati.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 web_federbocce_comitati.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 web_federbocce_comitati.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.48 ms Executing hook on transaction 0.04 ms starting 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.28 ms init 0.03 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.28 ms preparing 0.04 ms Creating tmp table 0.10 ms executing 0.11 ms end 0.01 ms query end 0.03 ms waiting for handler commit 0.03 ms closing tables 0.04 ms freeing items 0.05 ms cleaning up 0.16 ms # Caller File e numero di linea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 2.33 ms Dopo l'ultima query: 36.73 ms Memoria query: 0.031 MB memoria prima della query: 14.270 MB Righe restituite: 10
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM cp_alessandria_modules AS m
LEFT JOIN cp_alessandria_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN `hvdqo_extensions` AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up ='0000-00-00 00:00:00' OR m.publish_up <= '2025-09-18 05:25:38')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-09-18 05:25:38')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 519 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL PRIMARY,published,newsfeeds NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 35 2.86 Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 web_federbocce_comitati.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 web_federbocce_comitati.m.id 1 40.00 Using where; Using index Status Duration starting 0.36 ms Executing hook on transaction 0.03 ms starting 0.05 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.18 ms init 0.02 ms System lock 0.06 ms optimizing 0.05 ms statistics 0.17 ms preparing 0.07 ms executing 0.49 ms end 0.02 ms query end 0.04 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.07 ms # Caller File e numero di linea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() Chiamata uguale alla linea sottostante. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 16 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 15 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 14 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/templates/hydra/html/com_content/article/default.php:134 13 include JROOT/templates/hydra/html/com_content/article/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_content/views/article/view.html.php:210 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.44 ms Dopo l'ultima query: 91.55 ms Memoria query: 0.023 MB memoria prima della query: 15.418 MB Righe restituite: 1Query duplicate: #26
SELECT id_comitato
FROM 00_comitati
WHERE sito_comitato="alessandria"
AND attivazione_comitato=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE 00_comitati NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 138 1.00 Using where Status Duration starting 0.26 ms Executing hook on transaction 0.04 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.04 ms preparing 0.04 ms executing 0.16 ms end 0.01 ms query end 0.03 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.10 ms cleaning up 0.03 ms # Caller File e numero di linea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/modules/mod_fibfooter/helper.php:27 10 modFooterFBI::getInfocomitato() JROOT/modules/mod_fibfooter/mod_fibfooter.php:17 9 include JROOT/modules/mod_fibfooter/mod_fibfooter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 8 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 7 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 2.13 ms Dopo l'ultima query: 15.19 ms Memoria query: 0.039 MB memoria prima della query: 15.597 MB Righe restituite: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM cp_alessandria_fields AS a
LEFT JOIN `cp_alessandria_languages` AS l
ON l.lang_code = a.language
LEFT JOIN cp_alessandria_users AS uc
ON uc.id=a.checked_out
LEFT JOIN cp_alessandria_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN cp_alessandria_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN cp_alessandria_fields_groups AS g
ON g.id = a.group_id
WHERE a.context ='mod_custom.content'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 web_federbocce_comitati.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 web_federbocce_comitati.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 web_federbocce_comitati.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 web_federbocce_comitati.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 web_federbocce_comitati.a.group_id 1 100.00 Using where Status Duration starting 0.40 ms Executing hook on transaction 0.04 ms starting 0.02 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.24 ms init 0.03 ms System lock 0.03 ms optimizing 0.04 ms statistics 0.27 ms preparing 0.04 ms Creating tmp table 0.11 ms executing 0.13 ms end 0.01 ms query end 0.04 ms waiting for handler commit 0.03 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.20 ms # Caller File e numero di linea 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 20 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 19 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 18 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 16 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 13 JHtmlContent::prepare() Chiamata uguale alla linea sottostante. 12 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 11 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 10 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 9 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 8 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 7 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.44 ms Dopo l'ultima query: 37.65 ms Memoria query: 0.023 MB memoria prima della query: 15.702 MB Righe restituite: 1Query duplicate: #24
SELECT id_comitato
FROM 00_comitati
WHERE sito_comitato="alessandria"
AND attivazione_comitato=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE 00_comitati NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 138 1.00 Using where Status Duration starting 0.27 ms Executing hook on transaction 0.04 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.04 ms preparing 0.04 ms executing 0.16 ms end 0.01 ms query end 0.04 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.12 ms # Caller File e numero di linea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/modules/mod_fibtestata/helper.php:27 10 modTestataFBI::getNomecomitato() JROOT/modules/mod_fibtestata/mod_fibtestata.php:17 9 include JROOT/modules/mod_fibtestata/mod_fibtestata.php JROOT/libraries/src/Helper/ModuleHelper.php:200 8 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 7 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.57 ms Dopo l'ultima query: 4.95 ms Memoria query: 0.026 MB memoria prima della query: 15.730 MB Righe restituite: 0
SELECT *
FROM cp_alessandria_jmap_metainfo
WHERE `linkurl` ='https://www.federbocce.it/alessandria/news-comunicati/18-bacheca/2136-promozioni-e-retrocessioni-2024.html'
AND `published` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_jmap_metainfo NULL ref linkurl,published linkurl 767 const 1 100.00 Using where Status Duration starting 0.30 ms Executing hook on transaction 0.03 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.19 ms init 0.03 ms System lock 0.03 ms optimizing 0.04 ms statistics 0.17 ms preparing 0.05 ms executing 0.05 ms end 0.01 ms query end 0.04 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.07 ms # Caller File e numero di linea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:707 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.33 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.006 MB memoria prima della query: 15.736 MB
SELECT *
FROM cp_alessandria_jmap_canonicals
WHERE `linkurl` ='https://www.federbocce.it/alessandria/news-comunicati/18-bacheca/2136-promozioni-e-retrocessioni-2024.html'Error Table 'web_federbocce_comitati.#__jmap_canonicals' doesn't exist Status Duration starting 0.13 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.68 ms end 0.04 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.06 ms # Caller File e numero di linea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:786 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.27 ms Dopo l'ultima query: 5.11 ms Memoria query: 0.022 MB memoria prima della query: 15.893 MB Righe restituite: 0
SELECT `name`,`regex`,`replacement`
FROM `cp_alessandria_jhackguard_output_filters`
WHERE `state` = 1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_jhackguard_output_filters NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.22 ms Executing hook on transaction 0.02 ms starting 0.02 ms checking permissions 0.02 ms Opening tables 0.14 ms init 0.02 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.05 ms executing 0.07 ms end 0.01 ms query end 0.04 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.15 ms # Caller File e numero di linea 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 8 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jhackguard/jhackguard.php:91 7 PlgSystemJhackguard->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.15 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 15.896 MB Righe restituite: 1
SELECT sleep_until <'2025-09-18 05:25:39'
FROM cp_alessandria_scheduler_metadata
WHERE type ='metadata'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_scheduler_metadata NULL const unique_type unique_type 98 const 1 100.00 NULL Status Duration starting 0.21 ms Executing hook on transaction 0.02 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.03 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.05 ms # Caller File e numero di linea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:128 8 PlgSystemJoomlatoolsscheduler->onAfterRender() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:167 6 PlgSystemJoomlatoolsscheduler->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.97 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.023 MB memoria prima della query: 15.900 MB Righe restituite: 0
SELECT *
FROM cp_alessandria_jmap_headings
WHERE `linkurl` ='https://www.federbocce.it/alessandria/news-comunicati/18-bacheca/2136-promozioni-e-retrocessioni-2024.html'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_jmap_headings NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using where Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.03 ms executing 0.05 ms end 0.01 ms query end 0.02 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.07 ms # Caller File e numero di linea 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 8 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:1102 7 plgSystemJMap->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.81 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.023 MB memoria prima della query: 15.905 MB Righe restituite: 0
SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex`
FROM `cp_alessandria_jmap_text_replacements`
WHERE `published` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cp_alessandria_jmap_text_replacements NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.05 ms # Caller File e numero di linea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jmap/jmap.php:357 8 plgSystemJMap->patternReplacements() JROOT/plugins/system/jmap/jmap.php:1179 7 plgSystemJMap->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
29 tipi di query eseguite, ordinate per Occurrences
Tabelle SELECT:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `hvdqo_extensions`2 × SELECT id_comitato
FROM 00_comitati2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `cp_alessandria_assets`1 × SELECT `data`
FROM `cp_alessandria_session`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM cp_alessandria_fields AS a
LEFT JOIN `cp_alessandria_languages` AS l
ON l.lang_code = a.language
LEFT JOIN cp_alessandria_users AS uc
ON uc.id=a.checked_out
LEFT JOIN cp_alessandria_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN cp_alessandria_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN cp_alessandria_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `cp_alessandria_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT *
FROM cp_alessandria_jmap_headings1 × SELECT sleep_until <'2025-09-18 05:25:39'
FROM cp_alessandria_scheduler_metadata1 × SELECT `name`,`regex`,`replacement`
FROM `cp_alessandria_jhackguard_output_filters`1 × SELECT *
FROM cp_alessandria_jmap_canonicals1 × SELECT *
FROM cp_alessandria_jmap_metainfo1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM cp_alessandria_fields AS a
LEFT JOIN `cp_alessandria_languages` AS l
ON l.lang_code = a.language
LEFT JOIN cp_alessandria_users AS uc
ON uc.id=a.checked_out
LEFT JOIN cp_alessandria_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN cp_alessandria_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN cp_alessandria_fields_groups AS g
ON g.id = a.group_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM cp_alessandria_modules AS m
LEFT JOIN cp_alessandria_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN `hvdqo_extensions` AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `cp_alessandria_categories` AS `s`
INNER JOIN `cp_alessandria_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT `m`.`tag_id`,`t`.*
FROM `cp_alessandria_contentitem_tag_map` AS m
INNER JOIN `cp_alessandria_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT `session_id`
FROM `cp_alessandria_session`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified ='0000-00-00 00:00:00'THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM cp_alessandria_content AS a
INNER JOIN cp_alessandria_categories AS c
on c.id = a.catid
LEFT JOIN cp_alessandria_users AS u
on u.id = a.created_by
LEFT JOIN cp_alessandria_categories as parent
ON parent.id = c.parent_id
LEFT JOIN cp_alessandria_content_rating AS v
ON a.id = v.content_id1 × SELECT id, home, template, s.params
FROM cp_alessandria_template_styles as s
LEFT JOIN `hvdqo_extensions` as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM cp_alessandria_languages1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM cp_alessandria_menu AS m
LEFT JOIN `hvdqo_extensions` AS e
ON m.component_id = e.extension_id1 × SELECT `state`,`rule_type`
FROM `cp_alessandria_jhackguard_ip_filters`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `hvdqo_extensions`1 × SELECT b.id
FROM cp_alessandria_usergroups AS a
LEFT JOIN cp_alessandria_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `cp_alessandria_viewlevels1 × SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex`
FROM `cp_alessandria_jmap_text_replacements`
ALTRE tabelle:
1 × INSERT INTO `cp_alessandria_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3865663639316230666263633430353461663761613231613266386630393261', 1, 1758173138, 0, '', 01 × DELETE
FROM `cp_alessandria_jhackguard_ip_filters`1 × UPDATE `hvdqo_extensions`
SET `params` ='{\"mediaversion\":\"882a655abd4feca6dab419ded2b02f21\"}'1 × SHOW FULL COLUMNS
FROM `cp_alessandria_content1 × UPDATE cp_alessandria_content
SET `hits` = (`hits` + 1)