Bed and Breakfast Borgata Lesna
Via Monginevro 252 Torino
Cel: +39 340 244 7013
Mail: Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.
Bed and Breakfast Borgata Lesna - Via Monginevro 252 Torino Cel: +39 340 244 7013
A Joomla51.com Design
Console Debug Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1714186132,
"last": 1714186132,
"now": 1714186132
},
"token": "HQl3RAOF1FFUXYLxTN5NCN5bTEw0kgD0"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Tempo
Memoria
Tempo: 72.39 ms / 72.39 ms Memoria: 0.473 MB / 0.86 MB Application: afterLoad
Tempo: 177.99 ms / 250.38 ms Memoria: 0.999 MB / 1.86 MB Application: afterInitialise
Tempo: 50.22 ms / 300.60 ms Memoria: 0.215 MB / 2.07 MB Application: afterRoute
Tempo: 16.51 ms / 317.11 ms Memoria: 0.094 MB / 2.17 MB Application: beforeRenderComponent com_content
Tempo: 13.73 ms / 330.83 ms Memoria: 0.111 MB / 2.28 MB Application: Before Access::preloadComponents (all components)
Tempo: 2.00 ms / 332.83 ms Memoria: 0.046 MB / 2.32 MB Application: After Access::preloadComponents (all components)
Tempo: 0.05 ms / 332.88 ms Memoria: 0.000 MB / 2.32 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Tempo: 1.57 ms / 334.46 ms Memoria: 0.009 MB / 2.33 MB Application: After Access::getAssetRules (id:8 name:com_content)
Tempo: 131.43 ms / 465.89 ms Memoria: 0.397 MB / 2.73 MB Application: afterRenderComponent com_content
Tempo: 12.27 ms / 478.17 ms Memoria: 0.072 MB / 2.80 MB Application: afterDispatch
Tempo: 8.01 ms / 486.18 ms Memoria: 0.072 MB / 2.87 MB Application: beforeRenderModule mod_menu ()
Tempo: 10.68 ms / 496.86 ms Memoria: 0.031 MB / 2.90 MB Application: afterRenderModule mod_menu ()
Tempo: 0.08 ms / 496.94 ms Memoria: 0.000 MB / 2.90 MB Application: beforeRenderModule mod_menu ()
Tempo: 0.45 ms / 497.38 ms Memoria: 0.004 MB / 2.91 MB Application: afterRenderModule mod_menu ()
Tempo: 0.06 ms / 497.44 ms Memoria: 0.000 MB / 2.91 MB Application: beforeRenderModule mod_menu ()
Tempo: 0.41 ms / 497.85 ms Memoria: 0.004 MB / 2.91 MB Application: afterRenderModule mod_menu ()
Tempo: 0.05 ms / 497.90 ms Memoria: 0.000 MB / 2.91 MB Application: beforeRenderModule mod_menu ()
Tempo: 0.41 ms / 498.31 ms Memoria: 0.005 MB / 2.91 MB Application: afterRenderModule mod_menu ()
Tempo: 12.64 ms / 510.95 ms Memoria: 0.016 MB / 2.93 MB Application: beforeRenderModule mod_custom (Loghi)
Tempo: 4.90 ms / 515.86 ms Memoria: 0.005 MB / 2.93 MB Application: afterRenderModule mod_custom (Loghi)
Tempo: 0.07 ms / 515.93 ms Memoria: 0.000 MB / 2.93 MB Application: beforeRenderModule mod_login (Login)
Tempo: 13.38 ms / 529.31 ms Memoria: 0.022 MB / 2.96 MB Application: afterRenderModule mod_login (Login)
Tempo: 0.08 ms / 529.38 ms Memoria: 0.000 MB / 2.96 MB Application: beforeRenderModule mod_menu (menu-sx)
Tempo: 0.86 ms / 530.24 ms Memoria: 0.028 MB / 2.98 MB Application: afterRenderModule mod_menu (menu-sx)
Tempo: 1.27 ms / 531.51 ms Memoria: 0.067 MB / 3.05 MB Application: afterRender
Query totali del database: 28.01 ms
3,33 MB (3.495.816 Bytes)
21 query eseguite 28.01 ms
- Tempo della query: 0.65 ms Memoria query: 0.025 MB memoria prima della query: 1.191 MB Righe restituite: 0
SELECT `data`
FROM `josjt_session`
WHERE `session_id` = 'cri0nqa7takun7bm43bev97i8m'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE josjt_session const PRIMARY PRIMARY 766 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.23 ms init 0.01 ms System lock 0.00 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.03 ms cleaning up 0.00 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:838 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 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:422 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.48 ms Dopo l'ultima query: 3.70 ms Memoria query: 0.021 MB memoria prima della query: 1.205 MB Righe restituite: 0
SELECT `session_id`
FROM `josjt_session`
WHERE `session_id` = 'cri0nqa7takun7bm43bev97i8m'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE josjt_session const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 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.03 ms cleaning up 0.00 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:179 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:840 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 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:422 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.45 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.003 MB memoria prima della query: 1.210 MB
INSERT INTO `josjt_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('cri0nqa7takun7bm43bev97i8m', 1, '1714186132', 0, '', 0)EXPLAIN non possibile sulla query: INSERT INTO `josjt_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('cri0nqa7takun7bm43bev97i8m', 1, '1714186132', 0, '', 0)Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms update 0.05 ms Waiting for query cache lock 0.00 ms update 0.00 ms end 0.00 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File e numero di linea 7 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Application/CMSApplication.php:219 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:840 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 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:422 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tempo della query: 6.45 ms Dopo l'ultima query: 6.87 ms Memoria query: 0.030 MB memoria prima della query: 1.308 MB Righe restituite: 34
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `josjt_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE josjt_extensions ref extension extension 82 const 34 100.00 Using index condition Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 5.62 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.13 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.00 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:422 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:430 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:496 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.74 ms Dopo l'ultima query: 7.06 ms Memoria query: 0.023 MB memoria prima della query: 1.339 MB Righe restituite: 5
SELECT id, rules
FROM `josjt_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE josjt_viewlevels ALL NULL NON E' POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 5 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.15 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.61 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.022 MB memoria prima della query: 1.351 MB Righe restituite: 2
SELECT b.id
FROM josjt_usergroups AS a
LEFT JOIN josjt_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 100.00 Using where; Using index Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.16 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.40 ms Dopo l'ultima query: 1.62 ms Memoria query: 0.038 MB memoria prima della query: 1.373 MB Righe restituite: 66
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM josjt_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE josjt_extensions ref extension extension 82 const 83 100.00 Using index condition; Using where; Using filesort Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.57 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.00 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.29 ms Dopo l'ultima query: 101.64 ms Memoria query: 0.035 MB memoria prima della query: 1.889 MB Righe restituite: 12
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 josjt_menu AS m
LEFT JOIN josjt_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 type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 15 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 Sql1155848_1.m.component_id 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.32 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.20 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.00 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:453 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:558 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:1153 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.54 ms Dopo l'ultima query: 43.51 ms Memoria query: 0.025 MB memoria prima della query: 2.093 MB Righe restituite: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `josjt_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE josjt_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration starting 0.02 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.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Chiamata uguale alla linea sottostante. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.49 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.005 MB memoria prima della query: 2.084 MB
UPDATE `josjt_extensions`
SET `params` = '{\"mediaversion\":\"b0e6d99a0b049a4410a43057ac6b3441\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE josjt_extensions range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.03 ms updating 0.04 ms end 0.00 ms Waiting for query cache lock 0.00 ms end 0.00 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File e numero di linea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.04 ms Dopo l'ultima query: 4.67 ms Memoria query: 0.025 MB memoria prima della query: 2.119 MB Righe restituite: 1
SELECT *
FROM josjt_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE josjt_languages ALL NULL NON E' POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.44 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 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 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.89 ms Dopo l'ultima query: 0.37 ms Memoria query: 0.021 MB memoria prima della query: 2.132 MB Righe restituite: 4
SELECT id, home, template, s.params
FROM josjt_template_styles as s
LEFT JOIN josjt_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 type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ALL idx_template NON E' POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 6 100.00 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 Sql1155848_1.s.template,const 1 100.00 Using index condition; Using where Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.22 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.65 ms Dopo l'ultima query: 20.59 ms Memoria query: 0.030 MB memoria prima della query: 2.281 MB Righe restituite: 32
SELECT `id`,`name`,`rules`,`parent_id`
FROM `josjt_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_spidercalendar','com_tags','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE josjt_assets ALL idx_asset_name NON E' POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 91 38.46 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.79 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms executing 0.00 ms Sending data 0.18 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.00 ms # Caller File e numero di linea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:248 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 3.38 ms Dopo l'ultima query: 3.64 ms Memoria query: 0.035 MB memoria prima della query: 2.334 MB Righe restituite: 30
SHOW FULL COLUMNS
FROM `josjt_content`EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `josjt_content`Status Duration starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.43 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Opening tables 1.77 ms checking permissions 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.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.00 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 checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.34 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File e numero di linea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:250 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.85 ms Dopo l'ultima query: 8.93 ms Memoria query: 0.035 MB memoria prima della query: 2.403 MB Righe restituite: 1
SELECT *
FROM josjt_content
WHERE `id` = '7'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE josjt_content const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 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.01 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.00 ms # Caller File e numero di linea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:730 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.41 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.005 MB memoria prima della query: 2.410 MB
UPDATE josjt_content
SET `hits` = (`hits` + 1)
WHERE `id` = '7'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE josjt_content range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms updating 0.03 ms end 0.00 ms Waiting for query cache lock 0.00 ms end 0.00 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File e numero di linea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1241 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:252 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 2.29 ms Dopo l'ultima query: 5.73 ms Memoria query: 0.037 MB memoria prima della query: 2.436 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 josjt_content AS a
INNER JOIN josjt_categories AS c
on c.id = a.catid
LEFT JOIN josjt_users AS u
on u.id = a.created_by
LEFT JOIN josjt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN josjt_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 7
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-27 02:48:53')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-27 02:48:53')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.16 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 Opening tables 1.29 ms init 0.04 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File e numero di linea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:148 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 0.95 ms Dopo l'ultima query: 8.09 ms Memoria query: 0.034 MB memoria prima della query: 2.551 MB Righe restituite: 0
SELECT `m`.`tag_id`,`t`.*
FROM `josjt_contentitem_tag_map` AS m
INNER JOIN `josjt_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 7
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type NON E' POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 Sql1155848_1.m.tag_id 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.28 ms init 0.04 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File e numero di linea 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:180 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.02 ms Dopo l'ultima query: 62.08 ms Memoria query: 0.038 MB memoria prima della query: 2.688 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 josjt_categories as c
LEFT JOIN josjt_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.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=2
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NON E' POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 8 50.00 Using where Status Duration starting 0.13 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.09 ms end 0.00 ms query end 0.00 ms closing tables 0.01 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:1691 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:197 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 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:190 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.24 ms Dopo l'ultima query: 0.73 ms Memoria query: 0.037 MB memoria prima della query: 2.709 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 josjt_fields AS a
LEFT JOIN `josjt_languages` AS l
ON l.lang_code = a.language
LEFT JOIN josjt_users AS uc
ON uc.id=a.checked_out
LEFT JOIN josjt_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN josjt_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN josjt_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `josjt_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 (2,0))
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 type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 Sql1155848_1.a.language 1 100.00 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 Sql1155848_1.a.checked_out 1 100.00 NULL 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 Sql1155848_1.a.access 1 100.00 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 Sql1155848_1.a.created_user_id 1 100.00 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 Sql1155848_1.a.group_id 1 100.00 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 Sql1155848_1.a.id 1 100.00 Using where; Using index Status Duration starting 0.06 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.00 ms Opening tables 0.43 ms init 0.04 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 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:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 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:190 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:42 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 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:274 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tempo della query: 1.20 ms Dopo l'ultima query: 48.47 ms Memoria query: 0.027 MB memoria prima della query: 2.844 MB Righe restituite: 4
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM josjt_modules AS m
LEFT JOIN josjt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN josjt_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 <= '2024-04-27 02:48:53')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-27 02:48:53')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 113 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 10 100.00 Using index condition; Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 Sql1155848_1.m.id 1 100.00 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 Sql1155848_1.m.module,const 1 100.00 Using index condition; Using where Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.24 ms init 0.03 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.14 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Caller File e numero di linea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() Chiamata uguale alla linea sottostante. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:442 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:372 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/j51_classic/php/config.php:6 8 require JROOT/templates/j51_classic/php/config.php JROOT/templates/j51_classic/index.php:12 7 require JROOT/templates/j51_classic/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1110 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:280 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
20 tipi di query eseguite, ordinate per Occurrences
Tabelle SELECT:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `josjt_extensions`1 × SELECT `data`
FROM `josjt_session`1 × SELECT `session_id`
FROM `josjt_session`1 × SELECT id, rules
FROM `josjt_viewlevels1 × SELECT b.id
FROM josjt_usergroups AS a
LEFT JOIN josjt_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 josjt_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM josjt_menu AS m
LEFT JOIN josjt_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM josjt_languages1 × SELECT id, home, template, s.params
FROM josjt_template_styles as s
LEFT JOIN josjt_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `josjt_assets`1 × SELECT *
FROM josjt_content1 × 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 josjt_content AS a
INNER JOIN josjt_categories AS c
on c.id = a.catid
LEFT JOIN josjt_users AS u
on u.id = a.created_by
LEFT JOIN josjt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN josjt_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `josjt_contentitem_tag_map` AS m
INNER JOIN `josjt_tags` AS t
ON `m`.`tag_id` = `t`.`id`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
FROM josjt_categories as c
LEFT JOIN josjt_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)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 josjt_fields AS a
LEFT JOIN `josjt_languages` AS l
ON l.lang_code = a.language
LEFT JOIN josjt_users AS uc
ON uc.id=a.checked_out
LEFT JOIN josjt_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN josjt_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN josjt_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `josjt_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM josjt_modules AS m
LEFT JOIN josjt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN josjt_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
ALTRE tabelle:
1 × INSERT INTO `josjt_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('cri0nqa7takun7bm43bev97i8m', 1, '1714186132', 0, '', 01 × UPDATE `josjt_extensions`
SET `params` = '{\"mediaversion\":\"b0e6d99a0b049a4410a43057ac6b3441\"}'1 × SHOW FULL COLUMNS
FROM `josjt_content1 × UPDATE josjt_content
SET `hits` = (`hits` + 1)