Non sono attivi servizi Pre-Post scuola
Console Debug Joomla!
{ "__default": { "session": { "counter": 1, "timer": { "start": 1702231116, "last": 1702231116, "now": 1702231116 }, "token": "oFF9aa34JRU1H7WDZtREmVMfl1P5nu0O" }, "registry": { "com_attachments": { "current_url": "&return=aHR0cHM6Ly93d3cuaXN0aXR1dG9jb21wcmVuc2l2b3RhdXJpc2Fuby5lZHUuaXQvaW5kZXgucGhwL3NlcnZpemkvc2Vydml6aS1wZXItbGUtZmFtaWdsaWUvc2Vydml6aS1wcmUtZS1wb3N0LXNjdW9sYT8%3D" } }, "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 }, "com_mailto": { "links": { "23280613b7c00339e19146a5b0c7f259d32eebed": { "link": "https://www.istitutocomprensivotaurisano.edu.it/index.php/servizi/servizi-per-le-famiglie/servizi-pre-e-post-scuola", "expiry": 1702231116 } } }, "theme": "italia" } }
Tempo
Memoria
Tempo: 37.27 ms / 37.27 ms Memoria: 0.424 MB / 0.76 MB Application: afterLoad
Tempo: 247.18 ms / 284.45 ms Memoria: 2.150 MB / 2.91 MB Application: afterInitialise
Tempo: 86.10 ms / 370.56 ms Memoria: 0.303 MB / 3.21 MB Application: afterRoute
Tempo: 7.46 ms / 378.01 ms Memoria: 0.030 MB / 3.24 MB Application: beforeRenderComponent com_content
Tempo: 20.51 ms / 398.52 ms Memoria: 0.061 MB / 3.30 MB Application: Before Access::preloadComponents (all components)
Tempo: 2.59 ms / 401.11 ms Memoria: 0.063 MB / 3.36 MB Application: After Access::preloadComponents (all components)
Tempo: 0.04 ms / 401.15 ms Memoria: -0.004 MB / 3.36 MB Application: Before Access::preloadPermissions (com_content)
Tempo: 5.97 ms / 407.12 ms Memoria: 1.064 MB / 4.42 MB Application: After Access::preloadPermissions (com_content)
Tempo: 0.10 ms / 407.23 ms Memoria: -0.065 MB / 4.36 MB Application: Before Access::getAssetRules (id:239 name:com_content.article.74)
Tempo: 0.99 ms / 408.22 ms Memoria: 0.012 MB / 4.37 MB Application: After Access::getAssetRules (id:239 name:com_content.article.74)
Tempo: 177.35 ms / 585.57 ms Memoria: 0.709 MB / 5.08 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Tempo: 0.02 ms / 585.60 ms Memoria: 0.002 MB / 5.08 MB Application: After Access::getAssetRules (id:8 name:com_content)
Tempo: 2.97 ms / 588.57 ms Memoria: 0.019 MB / 5.10 MB Application: Before Access::getAssetRules (id:909 name:com_attachments)
Tempo: 0.05 ms / 588.62 ms Memoria: 0.009 MB / 5.11 MB Application: After Access::getAssetRules (id:909 name:com_attachments)
Tempo: 0.03 ms / 588.64 ms Memoria: 0.001 MB / 5.11 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Tempo: 0.01 ms / 588.65 ms Memoria: 0.002 MB / 5.11 MB Application: After Access::getAssetRules (id:1 name:root.1)
Tempo: 35.25 ms / 623.90 ms Memoria: 0.127 MB / 5.24 MB Application: afterRenderComponent com_content
Tempo: 7.74 ms / 631.65 ms Memoria: 0.008 MB / 5.25 MB Application: afterDispatch
Tempo: 168.35 ms / 799.99 ms Memoria: 0.129 MB / 5.37 MB Application: beforeRenderModule mod_menu (Info portale)
Tempo: 7.31 ms / 807.30 ms Memoria: 0.098 MB / 5.47 MB Application: afterRenderModule mod_menu (Info portale)
Tempo: 0.04 ms / 807.35 ms Memoria: -0.005 MB / 5.47 MB Application: beforeRenderModule mod_menu (Sitemap)
Tempo: 0.34 ms / 807.68 ms Memoria: 0.008 MB / 5.48 MB Application: afterRenderModule mod_menu (Sitemap)
Tempo: 0.06 ms / 807.75 ms Memoria: 0.000 MB / 5.48 MB Application: beforeRenderModule mod_schemaorg (Sede Amministrativa)
Tempo: 4.04 ms / 811.79 ms Memoria: 0.017 MB / 5.49 MB Application: afterRenderModule mod_schemaorg (Sede Amministrativa)
Tempo: 0.03 ms / 811.82 ms Memoria: -0.007 MB / 5.49 MB Application: beforeRenderModule mod_schemaorg (Recapiti Telefonici)
Tempo: 1.00 ms / 812.82 ms Memoria: 0.006 MB / 5.49 MB Application: afterRenderModule mod_schemaorg (Recapiti Telefonici)
Tempo: 0.03 ms / 812.85 ms Memoria: -0.002 MB / 5.49 MB Application: beforeRenderModule mod_schemaorg (Contatti)
Tempo: 4.83 ms / 817.69 ms Memoria: 0.010 MB / 5.50 MB Application: afterRenderModule mod_schemaorg (Contatti)
Tempo: 0.03 ms / 817.72 ms Memoria: -0.003 MB / 5.50 MB Application: beforeRenderModule mod_custom (Codici Istituzionali)
Tempo: 2.89 ms / 820.61 ms Memoria: 0.007 MB / 5.50 MB Application: afterRenderModule mod_custom (Codici Istituzionali)
Tempo: 0.06 ms / 820.68 ms Memoria: -0.003 MB / 5.50 MB Application: beforeRenderModule mod_menu (ORARIO LEZIONI SINCRONE)
Tempo: 0.15 ms / 820.83 ms Memoria: 0.004 MB / 5.51 MB Application: afterRenderModule mod_menu (ORARIO LEZIONI SINCRONE)
Tempo: 0.04 ms / 820.87 ms Memoria: -0.003 MB / 5.50 MB Application: beforeRenderModule mod_articles_categories (Servizi per le famiglie)
Tempo: 9.68 ms / 830.55 ms Memoria: 0.090 MB / 5.59 MB Application: afterRenderModule mod_articles_categories (Servizi per le famiglie)
Tempo: 0.06 ms / 830.61 ms Memoria: -0.004 MB / 5.59 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Tempo: 4.11 ms / 834.72 ms Memoria: 0.014 MB / 5.60 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Tempo: 0.06 ms / 834.78 ms Memoria: -0.005 MB / 5.60 MB Application: beforeRenderModule mod_menu (Burger Menu)
Tempo: 8.77 ms / 843.56 ms Memoria: 0.499 MB / 6.10 MB Application: afterRenderModule mod_menu (Burger Menu)
Tempo: 0.06 ms / 843.62 ms Memoria: -0.012 MB / 6.08 MB Application: beforeRenderModule mod_menu (Mega Menu)
Tempo: 5.08 ms / 848.70 ms Memoria: 0.161 MB / 6.25 MB Application: afterRenderModule mod_menu (Mega Menu)
Tempo: 0.06 ms / 848.76 ms Memoria: -0.020 MB / 6.23 MB Application: beforeRenderModule mod_search (Cerca)
Tempo: 3.09 ms / 851.85 ms Memoria: 0.017 MB / 6.24 MB Application: afterRenderModule mod_search (Cerca)
Tempo: 0.06 ms / 851.91 ms Memoria: -0.005 MB / 6.24 MB Application: beforeRenderModule mod_menu (Joomla per la scuola)
Tempo: 0.59 ms / 852.50 ms Memoria: 0.011 MB / 6.25 MB Application: afterRenderModule mod_menu (Joomla per la scuola)
Tempo: 450.46 ms / 1302.96 ms Memoria: 0.391 MB / 6.64 MB Application: afterRender
Query totali del database: 159.79 ms
7,00 MB (7.342.296 Bytes)
31 query eseguite 159.79 ms
- Tempo della query: 0.54 ms Memoria query: 0.023 MB memoria prima della query: 1.042 MB Righe restituite: 0
SELECT `data`
FROM `bj2r0_session`
WHERE `session_id` = X'68706d693632716176347070613366386c71706e32396b343639'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File e numero di linea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Chiamata uguale alla linea sottostante. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo della query: 54.92 ms Dopo l'ultima query: 1.48 ms Memoria query: 0.020 MB memoria prima della query: 1.057 MB Righe restituite: 0
SELECT `session_id`
FROM `bj2r0_session`
WHERE `session_id` = X'68706d693632716176347070613366386c71706e32396b343639'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 54.41 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File e numero di linea 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 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: 0.31 ms Memoria query: 0.004 MB memoria prima della query: 1.062 MB
INSERT INTO `bj2r0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'68706d693632716176347070613366386c71706e32396b343639', 1, 1702231116, 0, '', 0)EXPLAIN non possibile sulla query: INSERT INTO `bj2r0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'68706d693632716176347070613366386c71706e32396b343639', 1, 1702231116, 0, '', 0)Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.12 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.00 ms query end 0.05 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 3.16 ms # Caller File e numero di linea 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo della query: 3.04 ms Dopo l'ultima query: 3.93 ms Memoria query: 0.079 MB memoria prima della query: 1.093 MB Righe restituite: 46
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `bj2r0_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_extensions NULL ref extension extension 82 const 47 1.00 Using where Status Duration starting 0.08 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.09 ms preparing 0.02 ms executing 0.00 ms Sending data 1.13 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File e numero di linea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Chiamata uguale alla linea sottostante. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.17 ms Dopo l'ultima query: 4.55 ms Memoria query: 0.021 MB memoria prima della query: 1.167 MB Righe restituite: 11
SELECT id, rules
FROM `bj2r0_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_viewlevels NULL ALL NULL NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 11 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.22 ms statistics 0.02 ms preparing 0.02 ms executing 0.00 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File e numero di linea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 6.44 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.021 MB memoria prima della query: 1.244 MB Righe restituite: 2
SELECT b.id
FROM bj2r0_usergroups AS a
LEFT JOIN bj2r0_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.08 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 5.33 ms preparing 0.03 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File e numero di linea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 2.35 ms Dopo l'ultima query: 0.56 ms Memoria query: 0.035 MB memoria prima della query: 1.265 MB Righe restituite: 129
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM bj2r0_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_extensions NULL ref extension extension 82 const 152 0.60 Using index condition; Using where; Using filesort Status Duration starting 0.10 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.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 1.38 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File e numero di linea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Chiamata uguale alla linea sottostante. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.68 ms Dopo l'ultima query: 61.01 ms Memoria query: 0.021 MB memoria prima della query: 1.815 MB Righe restituite: 1
SELECT `extension`
FROM `bj2r0_action_logs_extensions`
WHERE `extension` = 'com_icagenda'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_action_logs_extensions NULL ALL NULL NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 19 10.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File e numero di linea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/actionlog/icagenda/icagenda.php:111 10 PlgActionlogIcagenda->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 9 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 8 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/plugins/system/actionlogs/actionlogs.php:64 7 PlgSystemActionLogs->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 10.11 ms Dopo l'ultima query: 47.81 ms Memoria query: 0.268 MB memoria prima della query: 2.107 MB Righe restituite: 220
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 bj2r0_menu AS m
LEFT JOIN bj2r0_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 364 9.15 Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 Sql1466330_1.m.component_id 1 100.00 Using where Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Sorting result 0.12 ms executing 0.00 ms Sending data 0.03 ms Creating sort index 6.66 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File e numero di linea 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Chiamata uguale alla linea sottostante. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/dropfiles/dropfiles.php:37 8 PlgSystemDropfiles->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.45 ms Dopo l'ultima query: 5.49 ms Memoria query: 0.020 MB memoria prima della query: 2.896 MB Righe restituite: 0
SELECT `v`.`item_id`
FROM `bj2r0_fields` f
INNER JOIN `bj2r0_fields_values` v
ON f.id = v.field_id
INNER JOIN `bj2r0_content` a
ON v.item_id = a.id
WHERE `f`.`context` = 'com_content.article'
AND `f`.`name` = 'plg-system-autoarchive-date'
AND `v`.`value`
AND `v`.`value` <= '2023-12-10 17:58:36'
AND `a`.`state` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE f NULL ALL PRIMARY,idx_context NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 7 14.29 Using where 1 SIMPLE v NULL ALL idx_field_id,idx_item_id NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 69 30.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE a NULL eq_ref PRIMARY,idx_state PRIMARY 4 Sql1466330_1.v.item_id 1 79.37 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.05 ms executing 0.00 ms Sending data 0.23 ms end 0.00 ms query end 0.09 ms closing tables 0.08 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File e numero di linea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 9 JDatabaseDriver->loadColumn() JROOT/plugins/system/autoarchive/autoarchive.php:77 8 plgSystemAutoarchive->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.74 ms Dopo l'ultima query: 26.35 ms Memoria query: 0.024 MB memoria prima della query: 3.097 MB Righe restituite: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `bj2r0_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms executing 0.02 ms Sending data 0.07 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File e numero di linea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/gdpr/gdpr.php:1381 8 plgSystemGdpr->onAfterRoute() 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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.80 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.006 MB memoria prima della query: 3.089 MB
UPDATE `bj2r0_extensions`
SET `params` = '{\"mediaversion\":\"f511f58c458ecfb5cfabacfef9443586\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE bj2r0_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.12 ms updating 0.12 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.09 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File e numero di linea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/gdpr/gdpr.php:1381 8 plgSystemGdpr->onAfterRoute() 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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 42.42 ms Dopo l'ultima query: 6.13 ms Memoria query: 0.021 MB memoria prima della query: 3.184 MB Righe restituite: 6
SELECT id, home, template, s.params
FROM bj2r0_template_styles as s
LEFT JOIN bj2r0_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 7 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 Sql1466330_1.e.element 1 100.00 Using index condition; Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 41.38 ms Opening tables 0.04 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.04 ms executing 0.00 ms Sending data 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File e numero di linea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 9 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/italiapa/italiapa.php:165 8 PlgSystemItaliaPA->onAfterRoute() 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:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.81 ms Dopo l'ultima query: 10.81 ms Memoria query: 0.019 MB memoria prima della query: 3.221 MB Righe restituite: 2
SELECT *
FROM bj2r0_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_languages NULL ALL NULL NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 2 50.00 Using where; Using filesort Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 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.03 ms Creating sort index 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File e numero di linea 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 2.31 ms Dopo l'ultima query: 26.89 ms Memoria query: 0.028 MB memoria prima della query: 3.305 MB Righe restituite: 46
SELECT `id`,`name`,`rules`,`parent_id`
FROM `bj2r0_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_albopretorio_online','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_chronoconnectivity5','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dropfiles','com_fields','com_finder','com_icagenda','com_installer','com_j2xml','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_oziogallery3','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_rebuilder','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_assets NULL range idx_asset_name idx_asset_name 202 NULL 47 100.00 Using index condition Status Duration starting 0.14 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.11 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.43 ms preparing 0.02 ms executing 0.00 ms Sending data 1.04 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File e numero di linea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 3.89 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.169 MB memoria prima della query: 3.360 MB Righe restituite: 1252
SELECT `id`,`name`,`rules`,`parent_id`
FROM `bj2r0_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_assets NULL ALL idx_asset_name,idx_parent_id NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1439 20.86 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 3.10 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File e numero di linea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.69 ms Dopo l'ultima query: 4.16 ms Memoria query: 0.032 MB memoria prima della query: 4.378 MB Righe restituite: 31
SHOW FULL COLUMNS
FROM `bj2r0_content`EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `bj2r0_content`Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.03 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms Sending data 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File e numero di linea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.81 ms Dopo l'ultima query: 4.54 ms Memoria query: 0.005 MB memoria prima della query: 4.518 MB
UPDATE bj2r0_content
SET `hits` = (`hits` + 1)
WHERE `id` = '74'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE bj2r0_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.07 ms updating 0.10 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.06 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File e numero di linea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.80 ms Dopo l'ultima query: 2.32 ms Memoria query: 0.023 MB memoria prima della query: 4.541 MB Righe restituite: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM bj2r0_content AS a
INNER JOIN bj2r0_categories AS c
on c.id = a.catid
LEFT JOIN bj2r0_users AS u
on u.id = a.created_by
LEFT JOIN bj2r0_categories as parent
ON parent.id = c.parent_id
LEFT JOIN bj2r0_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 74
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-10 17:58:36')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-10 17:58:36')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.38 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.20 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.27 ms preparing 0.03 ms executing 0.01 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.06 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File e numero di linea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.13 ms Dopo l'ultima query: 2.42 ms Memoria query: 0.022 MB memoria prima della query: 4.578 MB Righe restituite: 0
SELECT `m`.`tag_id`,`t`.*
FROM `bj2r0_contentitem_tag_map` AS m
INNER JOIN `bj2r0_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 74
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 Sql1466330_1.m.tag_id 1 100.00 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.10 ms System lock 0.01 ms optimizing 0.10 ms statistics 0.11 ms preparing 0.02 ms executing 0.00 ms Sending data 0.08 ms end 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File e numero di linea 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.33 ms Dopo l'ultima query: 23.60 ms Memoria query: 0.027 MB memoria prima della query: 4.725 MB Righe restituite: 4
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 `bj2r0_categories` AS `s`
INNER JOIN `bj2r0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 141
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 31 86.86 Using index condition; Using where Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.10 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File e numero di linea 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 2.31 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.028 MB memoria prima della query: 4.755 MB Righe restituite: 6
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM bj2r0_fields AS a
LEFT JOIN `bj2r0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN bj2r0_users AS uc
ON uc.id=a.checked_out
LEFT JOIN bj2r0_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN bj2r0_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN bj2r0_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `bj2r0_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 (141,0,45,38))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL idx_state,idx_access,idx_context NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 7 85.71 Using where; Using temporary; Using filesort 1 SIMPLE l NULL ALL idx_langcode NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 2 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 Sql1466330_1.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 Sql1466330_1.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 Sql1466330_1.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL ALL PRIMARY NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 Sql1466330_1.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.09 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.00 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.06 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.46 ms Creating sort index 0.10 ms end 0.00 ms query end 0.10 ms removing tmp table 0.04 ms query end 0.00 ms closing tables 0.09 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File e numero di linea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.36 ms Dopo l'ultima query: 1.31 ms Memoria query: 0.024 MB memoria prima della query: 4.812 MB Righe restituite: 0
SELECT `field_id`,`value`
FROM `bj2r0_fields_values`
WHERE `field_id` IN (1,2,3,5,6,7)
AND `item_id` = '74'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_fields_values NULL ref idx_field_id,idx_item_id idx_item_id 766 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File e numero di linea 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:680 15 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/helpers/fields.php:158 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.20 ms Dopo l'ultima query: 130.30 ms Memoria query: 0.023 MB memoria prima della query: 5.071 MB Righe restituite: 1
SELECT created_by, catid
FROM bj2r0_content
WHERE id = 74id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 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.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File e numero di linea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 14 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:319 13 plgContentAttachments->onContentBeforeDisplay() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:199 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 3.74 ms Dopo l'ultima query: 3.86 ms Memoria query: 0.025 MB memoria prima della query: 5.110 MB Righe restituite: 0
SELECT a.*, u.name as creator_name
FROM bj2r0_attachments AS a
LEFT JOIN bj2r0_users AS u
ON u.id = a.created_by
WHERE a.parent_id=74
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filenameid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL NULL NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 761 0.13 Using where; Using filesort 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 Sql1466330_1.a.created_by 1 100.00 NULL Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.08 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.05 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.04 ms Creating sort index 2.33 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File e numero di linea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/components/com_attachments/models/attachments.php:436 17 AttachmentsModelAttachments->getAttachmentsList() JROOT/components/com_attachments/models/attachments.php:514 16 AttachmentsModelAttachments->someVisible() JROOT/components/com_attachments/controllers/attachments.php:98 15 AttachmentsControllerAttachments->displayString() JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 14 AttachmentsPlugin->insertAttachmentsList() JROOT/plugins/content/attachments/attachments.php:325 13 plgContentAttachments->onContentBeforeDisplay() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:199 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 3.13 ms Dopo l'ultima query: 13.99 ms Memoria query: 0.028 MB memoria prima della query: 5.160 MB Righe restituite: 15
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM bj2r0_modules AS m
LEFT JOIN bj2r0_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN bj2r0_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 <= '2023-12-10 17:58:36')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-10 17:58:36')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 278 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL PRIMARY,published,newsfeeds NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 69 1.45 Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 Sql1466330_1.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 Sql1466330_1.m.id 4 40.00 Using where; Using index Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.03 ms Opening tables 0.05 ms init 0.11 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.15 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 1.57 ms end 0.01 ms query end 0.01 ms closing tables 0.06 ms freeing items 0.06 ms cleaning up 0.02 ms # Caller File e numero di linea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() Chiamata uguale alla linea sottostante. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 16 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 15 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 14 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/templates/italiapa/html/com_content/article/default.php:49 13 include JROOT/templates/italiapa/html/com_content/article/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_content/views/article/view.html.php:210 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.29 ms Dopo l'ultima query: 16.78 ms Memoria query: 0.020 MB memoria prima della query: 5.248 MB Righe restituite: 0
SELECT id,placeholder
FROM `bj2r0_gdpr_checkbox`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_gdpr_checkbox NULL ALL NULL NON ร POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File e numero di linea 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 8 JDatabaseDriver->loadObjectList() JROOT/plugins/system/gdpr/gdpr.php:1646 7 plgSystemGdpr->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.91 ms Dopo l'ultima query: 196.40 ms Memoria query: 0.027 MB memoria prima della query: 5.556 MB Righe restituite: 6
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 `bj2r0_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `bj2r0_categories` AS `s`
INNER JOIN `bj2r0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 45
ORDER BY c.lftid 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 NULL 1 PRIMARY c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 31 86.86 Using index condition; Using where 2 DEPENDENT SUBQUERY i NULL ref idx_state,idx_catid idx_catid 4 Sql1466330_1.c.id 17 79.37 Using index condition; Using where Status Duration starting 0.23 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.11 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.27 ms preparing 0.04 ms Sorting result 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.11 ms executing 0.00 ms Sending data 0.08 ms executing 0.00 ms Sending data 0.07 ms executing 0.00 ms Sending data 0.05 ms executing 0.01 ms Sending data 0.12 ms executing 0.00 ms Sending data 0.04 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File e numero di linea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 16 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 15 Joomla\CMS\Categories\Categories->get() JROOT/modules/mod_articles_categories/helper.php:34 14 ModArticlesCategoriesHelper::getList() Chiamata uguale alla linea sottostante. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_categories/mod_articles_categories.php:28 10 include JROOT/modules/mod_articles_categories/mod_articles_categories.php JROOT/libraries/src/Helper/ModuleHelper.php:200 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.52 ms Dopo l'ultima query: 1.12 ms Memoria query: 0.030 MB memoria prima della query: 5.575 MB Righe restituite: 4
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 `bj2r0_categories` AS `s`
INNER JOIN `bj2r0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 44
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 29 86.86 Using index condition; Using where Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.09 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.23 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.19 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File e numero di linea 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 22 ContentRouter->getCategorySegment() Chiamata uguale alla linea sottostante. 21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/templates/italiapa/html/mod_articles_categories/treeview_items.php:21 12 require JROOT/templates/italiapa/html/mod_articles_categories/treeview_items.php JROOT/templates/italiapa/html/mod_articles_categories/treeview.php:21 11 require JROOT/templates/italiapa/html/mod_articles_categories/treeview.php JROOT/modules/mod_articles_categories/mod_articles_categories.php:35 10 include JROOT/modules/mod_articles_categories/mod_articles_categories.php JROOT/libraries/src/Helper/ModuleHelper.php:200 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.40 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.030 MB memoria prima della query: 5.594 MB Righe restituite: 4
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 `bj2r0_categories` AS `s`
INNER JOIN `bj2r0_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 140
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 30 86.86 Using index condition; Using where Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.09 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.21 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.17 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File e numero di linea 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 22 ContentRouter->getCategorySegment() Chiamata uguale alla linea sottostante. 21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/templates/italiapa/html/mod_articles_categories/treeview_items.php:21 12 require JROOT/templates/italiapa/html/mod_articles_categories/treeview_items.php JROOT/templates/italiapa/html/mod_articles_categories/treeview.php:21 11 require JROOT/templates/italiapa/html/mod_articles_categories/treeview.php JROOT/modules/mod_articles_categories/mod_articles_categories.php:35 10 include JROOT/modules/mod_articles_categories/mod_articles_categories.php JROOT/libraries/src/Helper/ModuleHelper.php:200 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.49 ms Dopo l'ultima query: 34.30 ms Memoria query: 0.024 MB memoria prima della query: 6.401 MB Righe restituite: 46
SELECT name, element AS `option`
FROM bj2r0_extensions
WHERE type = 'component'
AND enabled = 1
ORDER BY name ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bj2r0_extensions NULL ref extension extension 82 const 47 10.00 Using index condition; Using where; Using filesort Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.73 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File e numero di linea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_menus/models/menutypes.php:90 12 MenusModelMenutypes->getTypeOptions() JROOT/plugins/system/betterpreview/src/Component/Link.php:35 11 RegularLabs\Plugin\System\BetterPreview\Component\Link->__construct() JROOT/plugins/system/betterpreview/src/Component.php:28 10 RegularLabs\Plugin\System\BetterPreview\Component::getClass() JROOT/plugins/system/betterpreview/betterpreview.php:188 9 PlgSystemBetterPreview->getClass() JROOT/plugins/system/betterpreview/betterpreview.php:162 8 PlgSystemBetterPreview->handleOnAfterRender() JROOT/libraries/regularlabs/src/SystemPlugin.php:138 7 RegularLabs\Library\SystemPlugin->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
27 tipi di query eseguite, ordinate per Occurrences
Tabelle SELECT:
3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `bj2r0_categories` AS `s`
INNER JOIN `bj2r0_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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `bj2r0_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `bj2r0_assets`1 × SELECT `data`
FROM `bj2r0_session`1 × SELECT `session_id`
FROM `bj2r0_session`1 × SELECT id, rules
FROM `bj2r0_viewlevels1 × SELECT b.id
FROM bj2r0_usergroups AS a
LEFT JOIN bj2r0_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM bj2r0_extensions1 × SELECT `extension`
FROM `bj2r0_action_logs_extensions`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 bj2r0_menu AS m
LEFT JOIN bj2r0_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `v`.`item_id`
FROM `bj2r0_fields` f
INNER JOIN `bj2r0_fields_values` v
ON f.id = v.field_id
INNER JOIN `bj2r0_content` a
ON v.item_id = a.id1 × SELECT id, home, template, s.params
FROM bj2r0_template_styles as s
LEFT JOIN bj2r0_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM bj2r0_languages1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM bj2r0_content AS a
INNER JOIN bj2r0_categories AS c
on c.id = a.catid
LEFT JOIN bj2r0_users AS u
on u.id = a.created_by
LEFT JOIN bj2r0_categories as parent
ON parent.id = c.parent_id
LEFT JOIN bj2r0_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `bj2r0_contentitem_tag_map` AS m
INNER JOIN `bj2r0_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM bj2r0_fields AS a
LEFT JOIN `bj2r0_languages` AS l
ON l.lang_code = a.language
LEFT JOIN bj2r0_users AS uc
ON uc.id=a.checked_out
LEFT JOIN bj2r0_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN bj2r0_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN bj2r0_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `bj2r0_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `field_id`,`value`
FROM `bj2r0_fields_values`1 × SELECT created_by, catid
FROM bj2r0_content1 × SELECT a.*, u.name as creator_name
FROM bj2r0_attachments AS a
LEFT JOIN bj2r0_users AS u
ON u.id = a.created_by1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM bj2r0_modules AS m
LEFT JOIN bj2r0_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN bj2r0_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT id,placeholder
FROM `bj2r0_gdpr_checkbox1 × 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 `bj2r0_content` AS `i`1 × SELECT name, element AS `option`
FROM bj2r0_extensions
ALTRE tabelle:
1 × INSERT INTO `bj2r0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'68706d693632716176347070613366386c71706e32396b343639', 1, 1702231116, 0, '', 01 × UPDATE `bj2r0_extensions`
SET `params` = '{\"mediaversion\":\"f511f58c458ecfb5cfabacfef9443586\"}'1 × SHOW FULL COLUMNS
FROM `bj2r0_content1 × UPDATE bj2r0_content
SET `hits` = (`hits` + 1)