commemorazioni
Anniversario uccisione Mauro Venegoni
ore 10.00 pullman a disposizione in Largo Tosi a Legnano per chi desidera partecipare alla commemorazione. Rientro in Largo Tosi a fine commemorazione.
http://www.legnanonews.com/news/1/63814/
mauro_venegoni_martire_della_resistenza
http://www.legnanonews.com/news/1/63894/
commemorazione_mauro_venegoni_
l'intervento_di_luigi_botta
http://www.legnanonews.com/news/1/63814/
mauro_venegoni_martire_della_resistenza
http://www.legnanonews.com/news/1/63894/
commemorazione_mauro_venegoni_
l'intervento_di_luigi_botta
Console Debug Joomla!{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1779815330,
"last": 1779815330,
"now": 1779815330
},
"token": "dsydQQRotM1SsxZ9beYb9lLOqwFQ7eMK"
},
"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
}
}
}
TempoMemoriaTempo: 16.17 ms / 16.17 ms Memoria: 0.750 MB / 0.97 MB Application: afterLoad Tempo: 101.26 ms / 117.43 ms Memoria: 1.898 MB / 2.87 MB Application: afterInitialise Tempo: 33.19 ms / 150.62 ms Memoria: 0.608 MB / 3.48 MB Application: afterRoute Tempo: 3.76 ms / 154.38 ms Memoria: 0.062 MB / 3.54 MB Application: beforeRenderComponent com_content Tempo: 5.58 ms / 159.96 ms Memoria: 0.257 MB / 3.80 MB Application: Before Access::preloadComponents (all components) Tempo: 2.46 ms / 162.42 ms Memoria: 0.098 MB / 3.89 MB Application: After Access::preloadComponents (all components) Tempo: 0.08 ms / 162.50 ms Memoria: 0.000 MB / 3.89 MB Application: Before Access::preloadPermissions (com_content) Tempo: 6.81 ms / 169.30 ms Memoria: 1.011 MB / 4.90 MB Application: After Access::preloadPermissions (com_content) Tempo: 0.21 ms / 169.51 ms Memoria: 0.000 MB / 4.84 MB Application: Before Access::getAssetRules (id:182 name:com_content.category.82) Tempo: 1.21 ms / 170.72 ms Memoria: 0.022 MB / 4.86 MB Application: After Access::getAssetRules (id:182 name:com_content.category.82) Tempo: 6.84 ms / 177.56 ms Memoria: 0.127 MB / 4.99 MB Application: Before Access::getAssetRules (id:8 name:com_content) Tempo: 0.25 ms / 177.81 ms Memoria: 0.009 MB / 5.00 MB Application: After Access::getAssetRules (id:8 name:com_content) Tempo: 90.19 ms / 267.99 ms Memoria: 1.309 MB / 6.31 MB Application: afterRenderComponent com_content Tempo: 4.74 ms / 272.74 ms Memoria: 0.019 MB / 6.33 MB Application: afterDispatch Tempo: 4.63 ms / 277.36 ms Memoria: 0.110 MB / 6.44 MB Application: beforeRenderModule mod_footer (Footer) Tempo: 1.44 ms / 278.81 ms Memoria: 0.012 MB / 6.45 MB Application: afterRenderModule mod_footer (Footer) Tempo: 0.35 ms / 279.16 ms Memoria: 0.009 MB / 6.46 MB Application: beforeRenderModule mod_dpcalendar_mini (DPCalendar Mini) Tempo: 3.87 ms / 283.03 ms Memoria: 0.151 MB / 6.61 MB Application: Before Access::preloadPermissions (com_dpcalendar) Tempo: 1.82 ms / 284.85 ms Memoria: 0.029 MB / 6.64 MB Application: After Access::preloadPermissions (com_dpcalendar) Tempo: 0.21 ms / 285.06 ms Memoria: 0.001 MB / 6.64 MB Application: Before Access::getAssetRules (id:577 name:com_dpcalendar.category.87) Tempo: 0.19 ms / 285.25 ms Memoria: 0.009 MB / 6.65 MB Application: After Access::getAssetRules (id:577 name:com_dpcalendar.category.87) Tempo: 22.27 ms / 307.52 ms Memoria: 0.369 MB / 7.02 MB Application: Before Access::getAssetRules (id:576 name:com_dpcalendar) Tempo: 0.08 ms / 307.60 ms Memoria: 0.003 MB / 7.02 MB Application: After Access::getAssetRules (id:576 name:com_dpcalendar) Tempo: 6.35 ms / 313.95 ms Memoria: 0.065 MB / 7.08 MB Application: afterRenderModule mod_dpcalendar_mini (DPCalendar Mini) Tempo: 0.33 ms / 314.27 ms Memoria: 0.000 MB / 7.06 MB Application: beforeRenderModule mod_acymailing (Newsletter) Tempo: 11.47 ms / 325.74 ms Memoria: 0.629 MB / 7.69 MB Application: afterRenderModule mod_acymailing (Newsletter) Tempo: 0.68 ms / 326.42 ms Memoria: 0.000 MB / 7.66 MB Application: beforeRenderModule mod_bm_cool_menu (BM Cool Menu) Tempo: 7.82 ms / 334.24 ms Memoria: 0.131 MB / 7.79 MB Application: afterRenderModule mod_bm_cool_menu (BM Cool Menu) Tempo: 0.49 ms / 334.73 ms Memoria: 0.000 MB / 7.78 MB Application: beforeRenderModule mod_search (Search) Tempo: 2.44 ms / 337.18 ms Memoria: 0.026 MB / 7.81 MB Application: afterRenderModule mod_search (Search) Tempo: 31.86 ms / 369.04 ms Memoria: 0.177 MB / 7.98 MB Application: afterRender Query totali del database: 64.80 ms 8,73 MB (9.156.264 Bytes) 40 query eseguite 64.80 msTempo della query: 9.48 ms Memoria query: 0.021 MB memoria prima della query: 1.498 MB Righe restituite: 0 SELECT `data`
FROM `anpi_session`
WHERE `session_id` = 'eiuvog7896n86fnqggja6j6v47' | 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.07 ms | | init | 0.04 ms | | System lock | 0.03 ms | | optimizing | 0.02 ms | | statistics | 9.00 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.04 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.49 ms Dopo l'ultima query: 1.39 ms Memoria query: 0.012 MB memoria prima della query: 1.552 MB Righe restituite: 0 SELECT `session_id`
FROM `anpi_session`
WHERE `session_id` = 'eiuvog7896n86fnqggja6j6v47'
LIMIT 1 | 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 | Using index |
| Status | Duration |
|---|
| starting | 0.06 ms | | checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | init | 0.03 ms | | System lock | 0.02 ms | | optimizing | 0.01 ms | | statistics | 0.05 ms | | executing | 0.02 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 |
|---|
| 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: 1.43 ms Dopo l'ultima query: 0.39 ms Memoria query: 0.009 MB memoria prima della query: 1.567 MB INSERT INTO `anpi_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('eiuvog7896n86fnqggja6j6v47', 1, '1779815330', 0, '', 0) EXPLAIN non possibile sulla query: INSERT INTO `anpi_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('eiuvog7896n86fnqggja6j6v47', 1, '1779815330', 0, '', 0) | Status | Duration |
|---|
| starting | 0.06 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.03 ms | | System lock | 0.02 ms | | update | 0.26 ms | | end | 0.01 ms | | query end | 0.86 ms | | closing tables | 0.02 ms | | freeing items | 0.05 ms | | cleaning up | 0.03 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: 1.02 ms Dopo l'ultima query: 2.20 ms Memoria query: 0.020 MB memoria prima della query: 1.642 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.06 ms | | checking permissions | 0.02 ms | | Opening tables | 0.04 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.13 ms | | preparing | 0.03 ms | | executing | 0.01 ms | | Sending data | 0.42 ms | | end | 0.02 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.05 ms | | cleaning up | 0.04 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.44 ms Dopo l'ultima query: 2.33 ms Memoria query: 0.014 MB memoria prima della query: 1.732 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.03 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.10 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 |
|---|
| 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.52 ms Dopo l'ultima query: 0.44 ms Memoria query: 0.015 MB memoria prima della query: 1.757 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 = 1 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL | | 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.06 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.10 ms | | preparing | 0.03 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.04 ms | | cleaning up | 0.02 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.89 ms Dopo l'ultima query: 0.88 ms Memoria query: 0.047 MB memoria prima della query: 1.794 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 ordering | 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 | 111 | 0.42 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.02 ms | | Opening tables | 0.02 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.06 ms | | preparing | 0.04 ms | | Sorting result | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 1.40 ms | | end | 0.02 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 |
|---|
| 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.43 ms Dopo l'ultima query: 66.94 ms Memoria query: 0.029 MB memoria prima della query: 2.952 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.lft | id | 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.15 ms | | checking permissions | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.04 ms | | init | 0.06 ms | | System lock | 0.02 ms | | optimizing | 0.03 ms | | statistics | 0.10 ms | | preparing | 0.04 ms | | Sorting result | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.03 ms | | Creating sort index | 0.29 ms | | end | 0.02 ms | | query end | 0.02 ms | | closing tables | 0.02 ms | | freeing items | 0.06 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.66 ms Dopo l'ultima query: 16.44 ms Memoria query: 0.025 MB memoria prima della query: 3.260 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.11 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.11 ms | | preparing | 0.02 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 |
|---|
| 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.14 ms Dopo l'ultima query: 0.68 ms Memoria query: 0.018 MB memoria prima della query: 3.267 MB UPDATE `anpi_extensions`
SET `params` = '{\"mediaversion\":\"d304eba10c19b2a45aa1706d61495ce0\"}'
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.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.03 ms | | System lock | 0.06 ms | | updating | 0.10 ms | | end | 0.02 ms | | query end | 0.71 ms | | closing tables | 0.02 ms | | freeing items | 0.04 ms | | cleaning up | 0.02 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.62 ms Dopo l'ultima query: 1.21 ms Memoria query: 0.015 MB memoria prima della query: 3.348 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.05 ms | | checking permissions | 0.01 ms | | Opening tables | 0.01 ms | | init | 0.03 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.10 ms | | preparing | 0.03 ms | | executing | 0.01 ms | | Sending data | 0.14 ms | | end | 0.02 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.05 ms | | cleaning up | 0.03 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.62 ms Dopo l'ultima query: 8.32 ms Memoria query: 0.014 MB memoria prima della query: 3.498 MB Righe restituite: 1 SELECT *
FROM anpi_languages
WHERE published=1
ORDER BY ordering ASC | id | 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.07 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.02 ms | | preparing | 0.02 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.02 ms | | Creating sort index | 0.10 ms | | end | 0.01 ms | | query end | 0.03 ms | | closing tables | 0.01 ms | | freeing items | 0.05 ms | | cleaning up | 0.03 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.59 ms Dopo l'ultima query: 1.09 ms Memoria query: 0.010 MB memoria prima della query: 3.528 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 = 1 | id | 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.07 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.08 ms | | preparing | 0.03 ms | | executing | 0.01 ms | | Sending data | 0.15 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.33 ms Dopo l'ultima query: 7.03 ms Memoria query: 0.028 MB memoria prima della query: 3.803 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.10 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.06 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.20 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.68 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 |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 | | 18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 | | 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 | | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 | | 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 | | 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.47 ms Dopo l'ultima query: 0.88 ms Memoria query: 0.051 MB memoria prima della query: 3.891 MB Righe restituite: 635 SELECT `id`,`name`,`rules`,`parent_id`
FROM `anpi_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0 | id | 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.05 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 | 1.08 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.02 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/Access/Access.php:359 | | 18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 | | 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 | | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 | | 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 | | 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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: 2.06 ms Dopo l'ultima query: 8.50 ms Memoria query: 0.029 MB memoria prima della query: 4.882 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,(
SELECT COUNT(i.`id`)
FROM `anpi_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
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.published = 1
AND s.id = 82
ORDER BY c.lft | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort | | 1 | PRIMARY | c | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 11 | 93.59 | Using index condition; Using where | | 2 | DEPENDENT SUBQUERY | i | NULL | ref | idx_state,idx_catid | idx_catid | 4 | joomla.c.id | 15 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.18 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.02 ms | | statistics | 0.17 ms | | preparing | 0.03 ms | | Sorting result | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 ms | | preparing | 0.03 ms | | executing | 0.01 ms | | Sending data | 0.02 ms | | Creating sort index | 0.19 ms | | executing | 0.01 ms | | Sending data | 0.05 ms | | executing | 0.01 ms | | Sending data | 0.83 ms | | end | 0.01 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 |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 | | 15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 | | 14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 | | 13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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: 22.55 ms Dopo l'ultima query: 3.28 ms Memoria query: 0.037 MB memoria prima della query: 4.998 MB Righe restituite: 9 SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM anpi_content AS a
LEFT JOIN anpi_categories AS c
ON c.id = a.catid
LEFT JOIN anpi_users AS ua
ON ua.id = a.created_by
LEFT JOIN anpi_users AS uam
ON uam.id = a.modified_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.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid = 82
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-26 17:08:50')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-26 17:08:50')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 65, 9 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort | | 1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 151 | 16.00 | Using where | | 1 | SIMPLE | ua | NULL | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 3 | 100.00 | Using where; Using join buffer (Block Nested Loop) | | 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla.a.modified_by | 1 | 100.00 | Using where | | 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where | | 1 | SIMPLE | v | NULL | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.24 ms | | checking permissions | 0.01 ms | | checking permissions | 0.00 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.10 ms | | System lock | 0.01 ms | | optimizing | 0.03 ms | | statistics | 0.23 ms | | preparing | 0.06 ms | | Creating tmp table | 0.10 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 20.16 ms | | Creating sort index | 1.06 ms | | end | 0.01 ms | | query end | 0.01 ms | | removing tmp table | 0.19 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.05 ms | | cleaning up | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 | | 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 | | 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:558 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.72 ms Dopo l'ultima query: 2.23 ms Memoria query: 0.029 MB memoria prima della query: 5.179 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` = 341
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.09 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.13 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.11 ms | | preparing | 0.05 ms | | executing | 0.01 ms | | Sending data | 0.05 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/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:688 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.40 ms Dopo l'ultima query: 1.03 ms Memoria query: 0.029 MB memoria prima della query: 5.217 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` = 339
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.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 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.02 ms |
| # | Caller | File e numero di linea |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:688 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.39 ms Dopo l'ultima query: 0.91 ms Memoria query: 0.029 MB memoria prima della query: 5.255 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` = 337
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.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 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.04 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/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:688 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.52 ms Dopo l'ultima query: 0.93 ms Memoria query: 0.029 MB memoria prima della query: 5.293 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` = 335
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.02 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.09 ms | | preparing | 0.04 ms | | executing | 0.01 ms | | Sending data | 0.04 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.04 ms | | cleaning up | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:688 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.41 ms Dopo l'ultima query: 0.95 ms Memoria query: 0.029 MB memoria prima della query: 5.331 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` = 332
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.07 ms | | checking permissions | 0.01 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.06 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.04 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/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:688 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.39 ms Dopo l'ultima query: 0.92 ms Memoria query: 0.029 MB memoria prima della query: 5.369 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` = 328
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.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 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.05 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/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:688 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.52 ms Dopo l'ultima query: 0.88 ms Memoria query: 0.029 MB memoria prima della query: 5.407 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` = 326
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.07 ms | | checking permissions | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.05 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.03 ms | | freeing items | 0.04 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/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:688 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.41 ms Dopo l'ultima query: 0.95 ms Memoria query: 0.029 MB memoria prima della query: 5.445 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` = 324
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.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.08 ms | | preparing | 0.03 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.04 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/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:688 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.45 ms Dopo l'ultima query: 0.86 ms Memoria query: 0.029 MB memoria prima della query: 5.483 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` = 321
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.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 ms | | preparing | 0.03 ms | | executing | 0.01 ms | | Sending data | 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.02 ms |
| # | Caller | File e numero di linea |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:688 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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: 2.70 ms Dopo l'ultima query: 1.25 ms Memoria query: 0.024 MB memoria prima della query: 5.524 MB Righe restituite: 1 SELECT COUNT(*)
FROM anpi_content AS a
LEFT JOIN anpi_categories AS c
ON c.id = a.catid
LEFT JOIN anpi_users AS ua
ON ua.id = a.created_by
LEFT JOIN anpi_users AS uam
ON uam.id = a.modified_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.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid = 82
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-26 17:08:50')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-26 17:08:50') | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | NULL | | 1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 151 | 16.00 | Using where | | 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla.a.created_by | 1 | 100.00 | Using where; Using index | | 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla.a.modified_by | 1 | 100.00 | Using where; Using index | | 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where; Using index | | 1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla.a.id | 1 | 100.00 | Using where; Using index |
| 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.00 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.14 ms | | preparing | 0.05 ms | | executing | 0.02 ms | | Sending data | 2.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 |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335 | | 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 | | 15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 | | 14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.41 ms Dopo l'ultima query: 0.80 ms Memoria query: 0.025 MB memoria prima della query: 5.534 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.category'
AND `m`.`content_item_id` = 82
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.01 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.06 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.02 ms |
| # | Caller | File e numero di linea |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:226 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 | | 10 | ContentViewCategory->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.90 ms Dopo l'ultima query: 10.85 ms Memoria query: 0.034 MB memoria prima della query: 5.902 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.lft | id | 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.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.16 ms | | preparing | 0.04 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.02 ms | | Creating sort index | 0.17 ms | | end | 0.01 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 |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 | | 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 | | 20 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 | | 19 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 | | 18 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 | | 17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | 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/category/view.html.php:108 | | 10 | ContentViewCategory->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.81 ms Dopo l'ultima query: 0.77 ms Memoria query: 0.032 MB memoria prima della query: 5.941 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 ASC | id | 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.12 ms | | checking permissions | 0.01 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.00 ms | | checking permissions | 0.01 ms | | Opening tables | 0.17 ms | | init | 0.06 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.09 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.02 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/category/view.html.php:108 | | 10 | ContentViewCategory->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: 42.52 ms Memoria query: 0.021 MB memoria prima della query: 6.404 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-05-26 17:08:50')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-26 17:08:50')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 473 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering | id | 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.19 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.13 ms | | init | 0.06 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.11 ms | | preparing | 0.04 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 0.41 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 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.82 ms Dopo l'ultima query: 4.84 ms Memoria query: 0.028 MB memoria prima della query: 6.572 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.lft | id | 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.15 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.07 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.14 ms | | preparing | 0.03 ms | | Sorting result | 0.01 ms | | executing | 0.00 ms | | Sending data | 0.02 ms | | Creating sort index | 0.10 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.32 ms Dopo l'ultima query: 0.81 ms Memoria query: 0.026 MB memoria prima della query: 6.610 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` = 0 | id | 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.05 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.84 ms | | end | 0.02 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.05 ms | | cleaning up | 0.03 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.97 ms Dopo l'ultima query: 2.11 ms Memoria query: 0.031 MB memoria prima della query: 6.693 MB Righe restituite: 1 SELECT COUNT(*)
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) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | index | NULL | calendarid | 107 | NULL | 1 | 100.00 | Using index | | 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.14 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 | | Opening tables | 0.34 ms | | init | 0.06 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.06 ms | | preparing | 0.04 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.03 ms |
| # | Caller | File e numero di linea |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 23 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335 | | 22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 | | 21 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:316 | | 20 | Joomla\CMS\MVC\Model\ListModel->getStart() | 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.84 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.032 MB memoria prima della query: 6.715 MB Righe restituite: 0 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 20 | id | 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.12 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 | | Opening tables | 0.02 ms | | init | 0.06 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.04 ms | | preparing | 0.03 ms | | Creating tmp table | 0.05 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.16 ms | | Creating sort index | 0.05 ms | | end | 0.01 ms | | query end | 0.01 ms | | removing tmp table | 0.04 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 |
|---|
| 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.65 ms Dopo l'ultima query: 18.99 ms Memoria query: 0.026 MB memoria prima della query: 7.019 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.id | id | 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.12 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.05 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.10 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.06 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.48 ms Dopo l'ultima query: 1.23 ms Memoria query: 0.037 MB memoria prima della query: 7.061 MB Righe restituite: 1 SELECT COUNT(*)
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) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | index | NULL | calendarid | 107 | NULL | 1 | 100.00 | Using index | | 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.04 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.04 ms | | preparing | 0.05 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.04 ms | | cleaning up | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 | | 28 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335 | | 27 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 | | 26 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:316 | | 25 | Joomla\CMS\MVC\Model\ListModel->getStart() | 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.66 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.038 MB memoria prima della query: 7.088 MB Righe restituite: 0 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 20 | id | 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.08 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.04 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.03 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.04 ms | | end | 0.01 ms | | query end | 0.01 ms | | removing tmp table | 0.05 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 |
|---|
| 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.50 ms Dopo l'ultima query: 4.99 ms Memoria query: 0.026 MB memoria prima della query: 7.161 MB Righe restituite: 124 SELECT *
FROM anpi_acymailing_config | id | 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.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.11 ms | | init | 0.02 ms | | System lock | 0.02 ms | | optimizing | 0.01 ms | | statistics | 0.01 ms | | preparing | 0.01 ms | | executing | 0.01 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 |
|---|
| 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.52 ms Dopo l'ultima query: 7.60 ms Memoria query: 0.024 MB memoria prima della query: 7.680 MB Righe restituite: 1 SELECT *
FROM anpi_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASC | id | 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.06 ms | | checking permissions | 0.01 ms | | Opening tables | 0.14 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.03 ms | | preparing | 0.01 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.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/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 |
25 tipi di query eseguite, ordinate per OccurrencesTabelle SELECT:10 × SELECT `m`.`tag_id`,`t`.*
FROM `anpi_contentitem_tag_map` AS m
INNER JOIN `anpi_tags` AS t
ON `m`.`tag_id` = `t`.`id` 3 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `anpi_assets` 2 × SELECT COUNT(*)
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 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 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 *
FROM anpi_acymailing_list 1 × SELECT COUNT(*)
FROM anpi_content AS a
LEFT JOIN anpi_categories AS c
ON c.id = a.catid
LEFT JOIN anpi_users AS ua
ON ua.id = a.created_by
LEFT JOIN anpi_users AS uam
ON uam.id = a.modified_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 1 × 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 1 × SELECT *
FROM anpi_acymailing_confi 1 × 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 1 × SELECT c.id AS id, a.name AS asset_name
FROM ( SELECT id,asset_id
FROM anpi_categories 1 × 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,( SELECT COUNT(i.`id`)
FROM `anpi_content` AS `i` 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM anpi_extensions 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 1 × SELECT id, rules
FROM `anpi_viewlevels 1 × SELECT `session_id`
FROM `anpi_session` 1 × 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 1 × SELECT params
FROM anpi_extensions 1 × SELECT `data`
FROM `anpi_session` 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 1 × SELECT *
FROM anpi_languages 1 × SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM anpi_content AS a
LEFT JOIN anpi_categories AS c
ON c.id = a.catid
LEFT JOIN anpi_users AS ua
ON ua.id = a.created_by
LEFT JOIN anpi_users AS uam
ON uam.id = a.modified_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
ALTRE tabelle:1 × UPDATE `anpi_extensions`
SET `params` = '{\"mediaversion\":\"d304eba10c19b2a45aa1706d61495ce0\"}' 1 × INSERT INTO `anpi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('eiuvog7896n86fnqggja6j6v47', 1, '1779815330', 0, '', 0
eventi
Conferenza: Viaggio in un mondo fuori dal mondo
pellegrinaggio associati ANPI Legnano
Pellegrinaggio Associati ANPI Legnano
al Museo della Resistenza di Lecco
25 settembre 2016
Gli associati sella Sezione ANPI di Legnano si sono recati domenica 25 settembre in visita al Museo della Resistenza di Lecco, realizzato presso il Municipio della città. Vi sono esposte in due sale alcune bacheche con documenti originali, lettere di esponenti dell'antifascismo lecchese, fotografie, manifesti a stampa, giornali, reperti militari, dall'affermazione del Fascismo alla fine della Seconda guerra mondiale, con particolare riguardo al periodo dal settembre 1943 all'aprile 1945. E vi è anche esposta una statua della Madonna, trafitta da colpi d'arma da fuoco durante il primo rastrellamento contro i partigiani che i fascisti hanno organizzato proprio sui monti del lecchese, sparando anche nella locale chiesa.
http://www.museilecco.org/salaresistenza.htm
  
 La giornata è proseguita con il pranzo presso un ristorante a Santa Maria Hoè, paese nel quale era nato Don Carlo Riva, coadiutore della Parrocchia di San Domenico e fulcro della Resistenza di impronta cattolica del legnanese, legata alla Brigata Carroccio della formazione cattolica Alfredo Di Dio.
  
E ringraziamo il nostro associato poeta Gino Civinini che puntualmente ci allieta con le sue riflessioni in rima:
 Alla gita a Lecco con l'ANPI di Legnano
ne abbiam viste di tutti i colori
non potendo trovar pur cercando piano
abbiam visto tutta Lecco ed anche fuori...
Ma alla fine ci siam consolati
mangiando nel ristorante miglior che c'è
e qui ci siamo molto abbuffati
in questa località: S. Maria Hoè.
Gino Civinini
eventi
"Naufragi di ieri e di oggi": conferenza a Palazzo da Perego
L'ANPI Legnano, in collaborazione con il Comune di Legnano, in occasione della Giornata della memoria e dell'accoglienza in ricordo della tragedia di Lampedusa del 3 ottobre 2013 organizza per venerdì 7 ottobre, alle 20.50, a Palazzo Leone da Perego, via Gilardelli 10, Legnano, la conferenza dal titolo "Naufragi di ieri e di oggi - Dalle tragedie dei nostri emigranti ai drammi quotidiani nel Mediterraneo".
Libri e DVD di storia locale
Nuova pubblicazione ANPI
Circa venti collaboratori prendono qui in esame il ruolo svolto dagli intellettuali durante la Grande Guerra: una guerra con “nomi e cognomi”, più o meno noti al grande pubblico. I singoli contributi pongono in risalto le diverse opinioni che si vennero a determinare prima dell’adesione dell’Italia al conflitto, analizzando il vivace dibattito che si accese tra interventisti e neutralisti, con le numerose e sfumate scelte e prese di posizione di poeti, artisti, giornalisti e intellettuali di varia matrice ideologica ed estrazione sociale.
LIBRO IN FORMATO E-BOOK LIBERAMENTE SCARICABILE cliccando QUI
Il libro cartaceo in DUE VOLUMI sarà disponibile presso la sede ANPI di Legnano a partire da fine settembre 2016.
|
|
