Manifestazione per l'anniversario della uccisione di Mauro Venegoni
29 ottobre 2017
Siete tutti invitati alla manifestazione per l’anniversario della uccisione di Mauro Venegoni, avvenuta a Cassano Magnago
In Largo Tosi a Legnano alle ore 10.00 partirà il pullman gratuito per recarci al luogo della manifestazione.
FOTO e resoconto della giornata:
http://www.legnanonews.com/news/cronaca/909540/
mauro_venegoni_ricordato_il_martire_della_resistenza

Cosa ricordiamo? Cos'è accaduto a Mauro???
Non si può parlare di Resistenza a Legnano e in tutta la Valle Olona senza parlare dei fratelli Venegoni: Carlo, Mauro, Pierino e Guido Venegoni.
Carlo Venegoni dopo la fuga dal lager di Bolzano-Gries riesce ad incontrarsi il 29 ottobre 1944 col fratello Mauro, in un recapito a Milano in Corso Buenos Aires 1 e in quest’occasione Mauro, che nel frattempo è diventato comandante di una Brigata Garibaldi nel Vimercatese, si lamenta col fratello.
“Mauro era esasperato,” racconterà poi Carlo, “l’ho visto in uno stato di esasperazione tale da non saper più connettere: aveva acceso il gas, ché stavamo cuocendo un po’ di riso, poi si è spento il gas e lui è tornato ad aprirlo senza accendere il fuoco e a un certo momento io sentivo la puzza del gas… tanto era esasperato nel raccontarmi la sua vicenda.”
Da due settimane Mauro è completamente isolato, senza collegamenti.
Mentre i due fratelli sono insieme arriva la notizia che è stato arrestato un compagno che conosce il recapito di corso Buenos Aires. Mauro deve fuggire ma vuole agire, far ancora parte della Resistenza, decide di tornare verso Legnano e Busto.
Ai fratelli che gli consigliavano prudenza Mauro tempo addietro aveva risposto “Noi dobbiamo rimanere sulla breccia. E se è nostro destino sacrificarci, dobbiamo cadere là, al nostro posto di combattimento! Non un passo indietro!” e aveva intensificato la sua attività.
Casualmente, il giorno successivo, il 30 ottobre, viene arrestato e condotto alla caserma della Brigata Nera di Busto Arsizio, ma ha con sé documenti falsi a nome Mario Raimondi. Viene interrogato e anche torturato ma a un certo punto uno lo riconosce per quello che è, il Mauro Venegoni che da tempo vorrebbero avere fra le mani: per lui è finita, le botte e le torture si intensificano, in un’orgia di sangue, corrono brigatisti neri anche da fuori Busto. Vogliono sapere dov’è suo fratello Carlo e vogliono informazioni sulle Brigate. Lungamente e orribilmente torturato, Mauro non dice una parola. “Vermi,” urla loro, “voi avete rovinato l’Italia!” La notte del 31 ottobre lo caricheranno su una lunga automobile nera e, ubriachi di liquore e di sangue, lo scaraventeranno lungo la strada per Cassano Magnago e lo finiranno con due colpi alla nuca, abbandonando il corpo segnato da ferite e lesioni di ogni genere, mutilato e il viso orrendamente sfigurato: gli hanno rotto la mascella, cavato gli occhi...
I fascisti lo seppelliranno in tutta fretta col nome falso scritto sul suo documento dando come unica causa di morte i colpi d’arma da fuoco, tacendo tutto il resto e imputando la colpa dell’accaduto a ignoti ma la moglie di Mauro richiederà la riesumazione del cadavere, riconoscendo in esso il marito.
A Mauro verrà conferita una medaglia d’oro alla memoria.
FOTO e resoconto della giornata:
http://www.legnanonews.com/news/cronaca/909540/
mauro_venegoni_ricordato_il_martire_della_resistenza

Console Debug Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1782328707,
"last": 1782328707,
"now": 1782328707
},
"token": "jqL3W1vGMSS7r5PR2sYntZomrYfh7MJj"
},
"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
31 query eseguite 36.16 ms
- Tempo della query: 14.05 ms Memoria query: 0.021 MB memoria prima della query: 1.497 MB Righe restituite: 0
SELECT `data`
FROM `anpi_session`
WHERE `session_id` = 'pg2l3pjng8m2tp9adv1thfruv6'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_session NULL const PRIMARY PRIMARY 766 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 13.48 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.03 ms # Caller File e numero di linea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 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:854 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 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:451 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.34 ms Dopo l'ultima query: 1.45 ms Memoria query: 0.012 MB memoria prima della query: 1.551 MB Righe restituite: 0
SELECT `session_id`
FROM `anpi_session`
WHERE `session_id` = 'pg2l3pjng8m2tp9adv1thfruv6'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_session NULL const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 7 JDatabaseDriver->loadResult() JROOT/libraries/src/Application/CMSApplication.php:214 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:133 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:451 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.95 ms Dopo l'ultima query: 0.37 ms Memoria query: 0.009 MB memoria prima della query: 1.566 MB
INSERT INTO `anpi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('pg2l3pjng8m2tp9adv1thfruv6', 1, '1782328707', 0, '', 0)EXPLAIN non possibile sulla query: INSERT INTO `anpi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('pg2l3pjng8m2tp9adv1thfruv6', 1, '1782328707', 0, '', 0)Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms update 0.10 ms end 0.01 ms query end 0.64 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 7 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Application/CMSApplication.php:254 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:133 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:451 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.58 ms Dopo l'ultima query: 1.59 ms Memoria query: 0.020 MB memoria prima della query: 1.641 MB Righe restituite: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `anpi_extensions`
WHERE `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_extensions NULL ref extension extension 82 const 40 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.23 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:423 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:431 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:497 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:596 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.35 ms Dopo l'ultima query: 1.71 ms Memoria query: 0.014 MB memoria prima della query: 1.731 MB Righe restituite: 4
SELECT id, rules
FROM `anpi_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_viewlevels NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 4 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.03 ms # Caller File e numero di linea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 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:310 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:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.48 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.015 MB memoria prima della query: 1.756 MB Righe restituite: 1
SELECT b.id
FROM anpi_usergroups AS a
LEFT JOIN anpi_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 Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File e numero di linea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 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:310 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:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.17 ms Dopo l'ultima query: 0.65 ms Memoria query: 0.047 MB memoria prima della query: 1.793 MB Righe restituite: 107
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM anpi_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 anpi_extensions NULL ref extension extension 82 const 111 0.42 Using index condition; Using where; Using filesort Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.81 ms end 0.01 ms query end 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:1691 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:343 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:348 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:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.09 ms Dopo l'ultima query: 37.48 ms Memoria query: 0.029 MB memoria prima della query: 2.950 MB Righe restituite: 7
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 anpi_menu AS m
LEFT JOIN anpi_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 ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 40 3.33 Using index condition; Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 joomla.m.component_id 1 100.00 Using where Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.04 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.33 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File e numero di linea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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:482 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:587 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1169 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.61 ms Dopo l'ultima query: 12.82 ms Memoria query: 0.025 MB memoria prima della query: 3.257 MB Righe restituite: 0
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 `anpi_categories` AS `s`
INNER JOIN `anpi_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)
AND c.published = 1
AND s.id = 410
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL NULL NULL no matching row in const table Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.03 ms # Caller File e numero di linea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:314 12 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 11 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:350 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1170 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.32 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.017 MB memoria prima della query: 3.273 MB Righe restituite: 1
SELECT `alias`,`catid`
FROM `anpi_content`
WHERE `id` = 410id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 11 JDatabaseDriver->loadObject() JROOT/components/com_content/helpers/legacyrouter.php:366 10 ContentRouterRulesLegacy->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1170 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.38 ms Dopo l'ultima query: 0.87 ms Memoria query: 0.025 MB memoria prima della query: 3.315 MB Righe restituite: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `anpi_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File e numero di linea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 19 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 18 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Chiamata uguale alla linea sottostante. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 15 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 14 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 13 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jcktypography/jcktypography.php:48 9 plgSystemJCKtypography->onAfterRoute() Chiamata uguale alla linea sottostante. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1179 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.03 ms Dopo l'ultima query: 0.51 ms Memoria query: 0.018 MB memoria prima della query: 3.322 MB
UPDATE `anpi_extensions`
SET `params` = '{\"mediaversion\":\"a8e451d396dab6700eaf9baf4b9f8da2\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE anpi_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.06 ms updating 0.08 ms end 0.01 ms query end 0.67 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File e numero di linea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 14 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 13 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jcktypography/jcktypography.php:48 9 plgSystemJCKtypography->onAfterRoute() Chiamata uguale alla linea sottostante. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1179 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.39 ms Dopo l'ultima query: 1.02 ms Memoria query: 0.015 MB memoria prima della query: 3.403 MB Righe restituite: 1
SELECT params
FROM anpi_extensions
WHERE folder ='editors'
AND element ='jckeditor'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_extensions NULL ref element_clientid,element_folder_clientid element_clientid 402 const 1 10.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.09 ms end 0.01 ms query end 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:1730 10 JDatabaseDriver->loadResult() JROOT/plugins/system/jcktypography/jcktypography.php:61 9 plgSystemJCKtypography->onAfterRoute() Chiamata uguale alla linea sottostante. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1179 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.45 ms Dopo l'ultima query: 6.74 ms Memoria query: 0.014 MB memoria prima della query: 3.553 MB Righe restituite: 1
SELECT *
FROM anpi_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_languages NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.62 ms Dopo l'ultima query: 0.98 ms Memoria query: 0.010 MB memoria prima della query: 3.583 MB Righe restituite: 7
SELECT id, home, template, s.params
FROM anpi_template_styles as s
LEFT JOIN anpi_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 s NULL ALL idx_template NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 10 10.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 joomla.s.template,const 1 4.56 Using index condition; Using where Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.21 ms Dopo l'ultima query: 4.48 ms Memoria query: 0.026 MB memoria prima della query: 3.740 MB Righe restituite: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `anpi_assets`
WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforms6','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jckman','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_multicalendar','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_spdownload','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_assets NULL range idx_asset_name idx_asset_name 202 NULL 41 100.00 Using index condition Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.20 ms preparing 0.02 ms executing 0.01 ms Sending data 0.60 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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:55 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:248 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.98 ms Dopo l'ultima query: 2.13 ms Memoria query: 0.026 MB memoria prima della query: 3.868 MB Righe restituite: 30
SHOW FULL COLUMNS
FROM `anpi_content`EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `anpi_content`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.19 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.04 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.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.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.01 ms checking permissions 0.02 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 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:250 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.48 ms Dopo l'ultima query: 7.16 ms Memoria query: 0.023 MB memoria prima della query: 4.021 MB Righe restituite: 1
SELECT *
FROM anpi_content
WHERE `id` = '410'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File e numero di linea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.05 ms Dopo l'ultima query: 0.48 ms Memoria query: 0.014 MB memoria prima della query: 4.041 MB
UPDATE anpi_content
SET `hits` = (`hits` + 1)
WHERE `id` = '410'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE anpi_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.04 ms updating 0.10 ms end 0.01 ms query end 0.70 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1242 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:252 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.77 ms Dopo l'ultima query: 1.91 ms Memoria query: 0.028 MB memoria prima della query: 4.110 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 anpi_content AS a
INNER JOIN anpi_categories AS c
on c.id = a.catid
LEFT JOIN anpi_users AS u
on u.id = a.created_by
LEFT JOIN anpi_categories as parent
ON parent.id = c.parent_id
LEFT JOIN anpi_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 410
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-24 19:18:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-24 19:18:27')
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.18 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.09 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File e numero di linea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:148 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 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: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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.05 ms Dopo l'ultima query: 2.57 ms Memoria query: 0.035 MB memoria prima della query: 4.202 MB Righe restituite: 2
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 `anpi_categories` AS `s`
INNER JOIN `anpi_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)
AND c.published = 1
AND s.id = 82
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 range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 11 93.59 Using index condition; Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.46 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File e numero di linea 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:314 21 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 20 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 19 ContentRouter->getCategorySegment() Chiamata uguale alla linea sottostante. 18 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 17 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 16 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 15 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:670 14 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 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: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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.49 ms Dopo l'ultima query: 1.79 ms Memoria query: 0.024 MB memoria prima della query: 4.272 MB Righe restituite: 0
SELECT `m`.`tag_id`,`t`.*
FROM `anpi_contentitem_tag_map` AS m
INNER JOIN `anpi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 410
AND `t`.`published` = 1
AND t.access IN (1,1)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 joomla.m.tag_id 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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: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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.01 ms Dopo l'ultima query: 10.10 ms Memoria query: 0.032 MB memoria prima della query: 4.655 MB Righe restituite: 0
SELECT 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
FROM anpi_fields AS a
LEFT JOIN `anpi_languages` AS l
ON l.lang_code = a.language
LEFT JOIN anpi_users AS uc
ON uc.id=a.checked_out
LEFT JOIN anpi_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN anpi_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN anpi_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `anpi_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 (82,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 index condition; Using where; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 joomla.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 joomla.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 joomla.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 joomla.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 joomla.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 joomla.a.id 1 100.00 Using where; Using index Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.00 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.20 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.03 ms # Caller File e numero di linea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:427 14 PlgSystemFields->onContentPrepare() Chiamata uguale alla linea sottostante. 13 call_user_func_array() 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: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:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:303 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.27 ms Dopo l'ultima query: 17.43 ms Memoria query: 0.021 MB memoria prima della query: 4.996 MB Righe restituite: 12
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM anpi_modules AS m
LEFT JOIN anpi_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN anpi_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 <= '2026-06-24 19:18:27')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-24 19:18:27')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 473 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 ref PRIMARY,published,newsfeeds published 1 const 28 1.19 Using index condition; Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 joomla.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 joomla.m.id 2 40.00 Using where; Using index Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.06 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.43 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.03 ms # Caller File e numero di linea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() 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/ModuleHelper.php:433 10 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:363 9 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 8 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.73 ms Dopo l'ultima query: 5.05 ms Memoria query: 0.028 MB memoria prima della query: 5.164 MB Righe restituite: 2
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 `anpi_categories` AS `s`
INNER JOIN `anpi_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_dpcalendar' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 87
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 range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 2 100.00 Using index condition; Using where Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File e numero di linea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:314 14 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 13 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:39 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:67 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:21 10 include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.03 ms Dopo l'ultima query: 0.77 ms Memoria query: 0.026 MB memoria prima della query: 5.202 MB Righe restituite: 3
SELECT `id`,`name`,`rules`,`parent_id`
FROM `anpi_assets`
WHERE `name` LIKE 'com_dpcalendar.%' OR `name` = 'com_dpcalendar' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_assets NULL ALL idx_asset_name,idx_parent_id NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 735 21.78 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms executing 0.01 ms Sending data 0.67 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 17 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 16 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 15 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 13 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:51 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:67 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:21 10 include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.84 ms Dopo l'ultima query: 1.74 ms Memoria query: 0.032 MB memoria prima della query: 5.274 MB Righe restituite: 0Query duplicate: #29
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `anpi_dpcalendar_caldav_calendarinstances` c
LEFT
OUTER JOIN anpi_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from anpi_dpcalendar_caldav_principals memberp
inner join anpi_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join anpi_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
ORDER BY c.displayname ASC
LIMIT 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using temporary; Using filesort 1 SIMPLE mainp NULL eq_ref uri uri 202 joomla.c.principaluri 1 100.00 Using where 1 SIMPLE m NULL index principal_id principal_id 8 NULL 1 100.00 Using index 1 SIMPLE memberp NULL eq_ref PRIMARY PRIMARY 4 joomla.m.member_id 1 100.00 Using where 1 SIMPLE linkp NULL eq_ref PRIMARY PRIMARY 4 joomla.m.principal_id 1 100.00 Using where Status Duration starting 0.09 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.18 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.12 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File e numero di linea 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 20 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/profile.php:36 18 DPCalendarModelProfile->getItems() JROOT/plugins/system/dpcalendar/dpcalendar.php:337 17 PlgSystemDpcalendar->fetchCalendars() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:435 16 DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch() Chiamata uguale alla linea sottostante. 15 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 12 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/components/com_dpcalendar/models/calendar.php:93 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:21 10 include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.64 ms Dopo l'ultima query: 17.74 ms Memoria query: 0.026 MB memoria prima della query: 5.581 MB Righe restituite: 1
SELECT c.id AS id, a.name AS asset_name
FROM ( SELECT id,asset_id
FROM anpi_categories
WHERE extension = 'com_dpcalendar'
AND published = 1) AS c
INNER JOIN anpi_assets AS a
ON c.asset_id = a.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_categories NULL ref cat_idx cat_idx 203 const,const 1 100.00 NULL 1 SIMPLE a NULL eq_ref PRIMARY PRIMARY 4 joomla.anpi_categories.asset_id 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File e numero di linea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/User/User.php:428 17 Joomla\CMS\User\User->getAuthorisedCategories() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:887 16 DPCalendar\Helper\DPCalendarHelper::canCreateEvent() JROOT/components/com_dpcalendar/layouts/calendar/calendar.php:68 15 include JROOT/components/com_dpcalendar/layouts/calendar/calendar.php JROOT/libraries/src/Layout/FileLayout.php:125 14 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 13 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:533 12 DPCalendar\Helper\DPCalendarHelper::renderLayout() JROOT/modules/mod_dpcalendar_mini/tmpl/default.php:71 11 require JROOT/modules/mod_dpcalendar_mini/tmpl/default.php JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:25 10 include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.70 ms Dopo l'ultima query: 0.94 ms Memoria query: 0.038 MB memoria prima della query: 5.610 MB Righe restituite: 0Query duplicate: #27
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `anpi_dpcalendar_caldav_calendarinstances` c
LEFT
OUTER JOIN anpi_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from anpi_dpcalendar_caldav_principals memberp
inner join anpi_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join anpi_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
ORDER BY c.displayname ASC
LIMIT 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using temporary; Using filesort 1 SIMPLE mainp NULL eq_ref uri uri 202 joomla.c.principaluri 1 100.00 Using where 1 SIMPLE m NULL index principal_id principal_id 8 NULL 1 100.00 Using index 1 SIMPLE memberp NULL eq_ref PRIMARY PRIMARY 4 joomla.m.member_id 1 100.00 Using where 1 SIMPLE linkp NULL eq_ref PRIMARY PRIMARY 4 joomla.m.principal_id 1 100.00 Using where Status Duration starting 0.09 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.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.13 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Caller File e numero di linea 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 24 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/profile.php:36 23 DPCalendarModelProfile->getItems() JROOT/plugins/system/dpcalendar/dpcalendar.php:337 22 PlgSystemDpcalendar->fetchCalendars() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:435 21 DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch() Chiamata uguale alla linea sottostante. 20 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 19 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 18 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 17 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:891 16 DPCalendar\Helper\DPCalendarHelper::canCreateEvent() JROOT/components/com_dpcalendar/layouts/calendar/calendar.php:68 15 include JROOT/components/com_dpcalendar/layouts/calendar/calendar.php JROOT/libraries/src/Layout/FileLayout.php:125 14 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 13 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:533 12 DPCalendar\Helper\DPCalendarHelper::renderLayout() JROOT/modules/mod_dpcalendar_mini/tmpl/default.php:71 11 require JROOT/modules/mod_dpcalendar_mini/tmpl/default.php JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php:25 10 include JROOT/modules/mod_dpcalendar_mini/mod_dpcalendar_mini.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.55 ms Dopo l'ultima query: 4.81 ms Memoria query: 0.026 MB memoria prima della query: 5.686 MB Righe restituite: 124
SELECT *
FROM anpi_acymailing_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_acymailing_config NULL ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 124 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:464 15 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 14 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:434 13 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:803 12 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:21 11 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/modules/mod_acymailing/mod_acymailing.php:13 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.56 ms Dopo l'ultima query: 7.91 ms Memoria query: 0.024 MB memoria prima della query: 6.204 MB Righe restituite: 1
SELECT *
FROM anpi_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE anpi_acymailing_list NULL system typeorderingindex,typeuseridindex NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.04 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File e numero di linea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:464 12 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/list.php:30 11 listClass->getLists() JROOT/modules/mod_acymailing/mod_acymailing.php:105 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:309 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
26 tipi di query eseguite, ordinate per Occurrences
Tabelle SELECT:
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 `anpi_categories` AS `s`
INNER JOIN `anpi_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `anpi_assets`2 × SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
FROM `anpi_dpcalendar_caldav_calendarinstances` c
LEFT
OUTER JOIN anpi_dpcalendar_caldav_principals mainp
on mainp.uri = c.principaluri
LEFT
OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
from anpi_dpcalendar_caldav_principals memberp
inner join anpi_dpcalendar_caldav_groupmembers m
on memberp.id = m.member_id
inner join anpi_dpcalendar_caldav_principals linkp
on m.principal_id = linkp.id) as mp
on mp.linkuri LIKE CONCAT(c.principaluri, '/%')2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `anpi_extensions`1 × SELECT `m`.`tag_id`,`t`.*
FROM `anpi_contentitem_tag_map` AS m
INNER JOIN `anpi_tags` AS t
ON `m`.`tag_id` = `t`.`id`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 anpi_content AS a
INNER JOIN anpi_categories AS c
on c.id = a.catid
LEFT JOIN anpi_users AS u
on u.id = a.created_by
LEFT JOIN anpi_categories as parent
ON parent.id = c.parent_id
LEFT JOIN anpi_content_rating AS v
ON a.id = v.content_id1 × SELECT 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
FROM anpi_fields AS a
LEFT JOIN `anpi_languages` AS l
ON l.lang_code = a.language
LEFT JOIN anpi_users AS uc
ON uc.id=a.checked_out
LEFT JOIN anpi_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN anpi_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN anpi_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `anpi_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT *
FROM anpi_content1 × SELECT *
FROM anpi_acymailing_list1 × SELECT c.id AS id, a.name AS asset_name
FROM ( SELECT id,asset_id
FROM anpi_categories1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM anpi_modules AS m
LEFT JOIN anpi_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN anpi_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM anpi_acymailing_confi1 × SELECT *
FROM anpi_languages1 × SELECT b.id
FROM anpi_usergroups AS a
LEFT JOIN anpi_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `anpi_viewlevels1 × SELECT `session_id`
FROM `anpi_session`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM anpi_extensions1 × 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 anpi_menu AS m
LEFT JOIN anpi_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `data`
FROM `anpi_session`1 × SELECT params
FROM anpi_extensions1 × SELECT `alias`,`catid`
FROM `anpi_content`1 × SELECT id, home, template, s.params
FROM anpi_template_styles as s
LEFT JOIN anpi_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
ALTRE tabelle:
1 × UPDATE anpi_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `anpi_content1 × UPDATE `anpi_extensions`
SET `params` = '{\"mediaversion\":\"a8e451d396dab6700eaf9baf4b9f8da2\"}'1 × INSERT INTO `anpi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('pg2l3pjng8m2tp9adv1thfruv6', 1, '1782328707', 0, '', 0

