Tempo della query: 0.87 ms Memoria query: 0.025 MB memoria prima della query: 3.777 MB Righe restituite: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = '98e647858d58ab2fe240836279bbee09'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.18 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.07 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Chiamata uguale alla linea sottostante. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:758 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Tempo della query: 0.67 ms Dopo l'ultima query: 2.72 ms Memoria query: 0.022 MB memoria prima della query: 3.880 MB Righe restituite: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = '98e647858d58ab2fe240836279bbee09'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Tempo della query: 0.97 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.004 MB memoria prima della query: 3.885 MB
INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('98e647858d58ab2fe240836279bbee09', 1, 1679692567, 0, '', 0)
EXPLAIN non possibile sulla query: INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('98e647858d58ab2fe240836279bbee09', 1, 1679692567, 0, '', 0)
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init for update | 0.03 ms |
| Update | 0.09 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.06 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Tempo della query: 1.38 ms Dopo l'ultima query: 5.70 ms Memoria query: 0.038 MB memoria prima della query: 4.159 MB Righe restituite: 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 43 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.22 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.09 ms |
| Preparing | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.31 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Chiamata uguale alla linea sottostante. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.05 ms Dopo l'ultima query: 11.15 ms Memoria query: 0.023 MB memoria prima della query: 4.374 MB Righe restituite: 6
SELECT id, rules
FROM `jos_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_viewlevels | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 6 | |
| Status | Duration |
|---|
| Starting | 0.25 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.94 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.022 MB memoria prima della query: 4.386 MB Righe restituite: 2
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 13
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.11 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.78 ms Dopo l'ultima query: 2.11 ms Memoria query: 0.040 MB memoria prima della query: 4.453 MB Righe restituite: 155
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ALL | extension | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 309 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.08 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.72 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Chiamata uguale alla linea sottostante. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:359 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.87 ms Dopo l'ultima query: 2.30 ms Memoria query: 0.025 MB memoria prima della query: 4.602 MB Righe restituite: 2
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_languages | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 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/Language/LanguageHelper.php:67 |
| 4 | Joomla\CMS\Language\LanguageHelper::detectLanguage() | JROOT/libraries/src/Application/SiteApplication.php:653 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.14 ms Dopo l'ultima query: 63.78 ms Memoria query: 0.027 MB memoria prima della query: 8.764 MB Righe restituite: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.27 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.12 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 17 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 16 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Chiamata uguale alla linea sottostante. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 13 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 12 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 11 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/tcshortcodes/tcshortcodes.php:14 |
| 7 | require_once JROOT/plugins/system/tcshortcodes/tcshortcodes.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 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:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.64 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.006 MB memoria prima della query: 8.756 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"0177c3abf33cbb5217a8891e7b471fd7\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN non possibile sulla query: UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"0177c3abf33cbb5217a8891e7b471fd7\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init for update | 0.08 ms |
| Updating | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 12 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 11 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/tcshortcodes/tcshortcodes.php:14 |
| 7 | require_once JROOT/plugins/system/tcshortcodes/tcshortcodes.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 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:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.06 ms Dopo l'ultima query: 4.38 ms Memoria query: 0.023 MB memoria prima della query: 9.008 MB Righe restituite: 4
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `jos_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 4 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.23 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.09 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:209 |
| 8 | Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:110 |
| 7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 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:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.79 ms Dopo l'ultima query: 21.41 ms Memoria query: 0.056 MB memoria prima della query: 10.310 MB Righe restituite: 35
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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_client_id_parent_id_alias_language | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 280 | Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.30 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.07 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.10 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.58 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 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:76 |
| 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:131 |
| 15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
| 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:64 |
| 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:491 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
| 8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.27 ms Dopo l'ultima query: 33.20 ms Memoria query: 0.028 MB memoria prima della query: 11.751 MB Righe restituite: 4
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 6 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | cronorun_newcron.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.27 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.07 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.14 ms |
| Preparing | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.11 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 19 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
| 18 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
| 17 | Joomla\CMS\HTML\HTMLHelper::script() | Chiamata uguale alla linea sottostante. |
| 16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/jquery.php:52 |
| 13 | JHtmlJquery::framework() | Chiamata uguale alla linea sottostante. |
| 12 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 11 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 10 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/administrator/components/com_k2/helpers/html.php:259 |
| 9 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:438 |
| 8 | plgSystemK2->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:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 2.46 ms Dopo l'ultima query: 22.73 ms Memoria query: 0.032 MB memoria prima della query: 13.046 MB Righe restituite: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoconnectivity6','com_chronoforms6','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fabrik','com_fields','com_finder','com_icagenda','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_simplefilemanager','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 44 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.25 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.61 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.09 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| init | 0.09 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.20 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.45 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 19 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 18 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 17 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 16 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 15 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/articles.php:115 |
| 14 | ContentModelArticles->populateState() | JROOT/components/com_content/models/featured.php:44 |
| 13 | ContentModelFeatured->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 8.63 ms Dopo l'ultima query: 2.94 ms Memoria query: 0.039 MB memoria prima della query: 13.184 MB Righe restituite: 1
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-24 21:16:07')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-24 21:16:07')
AND a.language IN ('it-IT','*')
ORDER BY c.lft, a.featured DESC, fp.ordering,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 4
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fp | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 3 | Using temporary; Using filesort |
| 1 | SIMPLE | a | eq_ref | PRIMARY,idx_access,idx_state,idx_catid,idx_language | PRIMARY | 4 | cronorun_newcron.fp.content_id | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.created_by | 1 | Using where |
| 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.modified_by | 1 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | cronorun_newcron.a.catid | 1 | Using where |
| 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.c.parent_id | 1 | Using where |
| 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.59 ms |
| checking permissions | 0.05 ms |
| Opening tables | 3.06 ms |
| After opening tables | 0.06 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.43 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.05 ms |
| init | 0.25 ms |
| Optimizing | 0.18 ms |
| Statistics | 0.29 ms |
| Preparing | 0.12 ms |
| Creating tmp table | 0.34 ms |
| Sorting result | 0.06 ms |
| Executing | 0.03 ms |
| Sending data | 1.40 ms |
| Creating sort index | 0.15 ms |
| Removing tmp table | 0.44 ms |
| Creating sort index | 0.05 ms |
| End of update loop | 0.07 ms |
| Query end | 0.03 ms |
| Commit | 0.04 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.06 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.19 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.05 ms |
| # | Caller | File e numero di linea |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 15 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 14 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:125 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 2.00 ms Dopo l'ultima query: 2.61 ms Memoria query: 0.035 MB memoria prima della query: 13.416 MB Righe restituite: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 109
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | cronorun_newcron.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.83 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.15 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.09 ms |
| Preparing | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 14 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:125 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.20 ms Dopo l'ultima query: 1.76 ms Memoria query: 0.025 MB memoria prima della query: 13.492 MB Righe restituite: 1
SELECT COUNT(*)
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-24 21:16:07')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-24 21:16:07')
AND a.language IN ('it-IT','*')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | fp | index | PRIMARY | PRIMARY | 4 | NULL | 3 | Using index |
| 1 | SIMPLE | a | eq_ref | PRIMARY,idx_access,idx_state,idx_catid,idx_language | PRIMARY | 4 | cronorun_newcron.fp.content_id | 1 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | cronorun_newcron.a.catid | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.21 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.07 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.15 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
| 12 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:57 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.03 ms Dopo l'ultima query: 7.06 ms Memoria query: 0.028 MB memoria prima della query: 13.611 MB Righe restituite: 1
SELECT `extension_id`,`name`,`enabled`,`params`
FROM jos_extensions
WHERE `type` = 'plugin'
AND `element` = 'osembed'
AND `folder` = 'content'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.21 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 21 | JDatabaseDriver->loadObject() | JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170 |
| 20 | Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase() | JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:140 |
| 19 | Alledia\Framework\Joomla\Extension\Generic->__construct() | JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:62 |
| 18 | Alledia\Framework\Joomla\Extension\Licensed->__construct() | JROOT/libraries/allediaframework/Framework/Factory.php:61 |
| 17 | Alledia\Framework\Factory::getExtension() | JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:85 |
| 16 | Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension() | JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:56 |
| 15 | Alledia\Framework\Joomla\Extension\AbstractPlugin->init() | JROOT/plugins/content/osembed/osembed.php:93 |
| 14 | Plgcontentosembed->init() | JROOT/plugins/content/osembed/osembed.php:85 |
| 13 | Plgcontentosembed->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_content/views/featured/view.html.php:78 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.76 ms Dopo l'ultima query: 14.61 ms Memoria query: 0.038 MB memoria prima della query: 14.120 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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('it-IT','*')) 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 = 110
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right,idx_language | cat_idx | 207 | NULL | 6 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.34 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.10 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.22 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.08 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.22 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 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: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:135 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:488 |
| 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/featured/view.html.php:102 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 3.92 ms Dopo l'ultima query: 1.11 ms Memoria query: 0.037 MB memoria prima della query: 14.164 MB Righe restituite: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_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 (110,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 ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | cronorun_newcron.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.29 ms |
| checking permissions | 0.03 ms |
| Opening tables | 1.24 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.13 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| init | 0.12 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.21 ms |
| Preparing | 0.09 ms |
| Creating tmp table | 0.14 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.55 ms |
| Creating sort index | 0.11 ms |
| Removing tmp table | 0.20 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:488 |
| 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/featured/view.html.php:102 |
| 10 | ContentViewFeatured->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.22 ms Dopo l'ultima query: 35.45 ms Memoria query: 0.022 MB memoria prima della query: 15.052 MB Righe restituite: 1
SELECT language,id
FROM `jos_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_menu | ALL | idx_client_id_parent_id_alias_language | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 280 | Using where |
| Status | Duration |
|---|
| Starting | 0.22 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.07 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.29 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.04 ms |
| # | Caller | File e numero di linea |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
| 8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
| 7 | PlgSystemLanguageFilter->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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.54 ms Dopo l'ultima query: 1.86 ms Memoria query: 0.023 MB memoria prima della query: 15.129 MB Righe restituite: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `jos_menu` AS `c`
INNER JOIN `jos_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `jos_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jos_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 435
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.51 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.04 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.04 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.10 ms |
| Preparing | 0.03 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
| 9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
| 8 | MenusHelper::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:768 |
| 7 | PlgSystemLanguageFilter->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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 3.01 ms Dopo l'ultima query: 24.22 ms Memoria query: 0.031 MB memoria prima della query: 15.527 MB Righe restituite: 12
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_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-03-24 21:16:07')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-24 21:16:07')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 435 OR mm.menuid <= 0)
AND m.language IN ('it-IT','*')
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds,idx_language | published | 1 | const | 48 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | cronorun_newcron.m.module,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.25 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.83 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.08 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| init | 0.08 ms |
| Optimizing | 0.10 ms |
| Statistics | 0.14 ms |
| Preparing | 0.08 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.72 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.11 ms |
| Updating status | 0.04 ms |
| Reset for next command | 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:432 |
| 16 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
| 15 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 14 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
| 13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:397 |
| 12 | sboostHelper->hasModule() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:416 |
| 11 | sboostHelper->getModules() | JROOT/templates/mx_joomla132/lib/framework/features/cpanel.php:13 |
| 10 | require_once JROOT/templates/mx_joomla132/lib/framework/features/cpanel.php | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:54 |
| 9 | sboostHelper->import() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:155 |
| 8 | sboostHelper->addFeatures() | JROOT/templates/mx_joomla132/index.php:50 |
| 7 | require JROOT/templates/mx_joomla132/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.88 ms Dopo l'ultima query: 4.62 ms Memoria query: 0.024 MB memoria prima della query: 15.675 MB Righe restituite: 1
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = '98e647858d58ab2fe240836279bbee09'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.18 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.07 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 14 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 13 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 12 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 11 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 10 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 9 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:282 |
| 8 | sboostHelper->showSlideItem() | JROOT/templates/mx_joomla132/index.php:78 |
| 7 | require JROOT/templates/mx_joomla132/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.82 ms Dopo l'ultima query: 2.54 ms Memoria query: 0.026 MB memoria prima della query: 15.709 MB Righe restituite: 1
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = '98e647858d58ab2fe240836279bbee09'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 16 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 15 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 14 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 13 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 12 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:268 |
| 11 | sboostHelper->hideItem() | JROOT/templates/mx_joomla132/lib/framework/layout/content.php:28 |
| 10 | require_once JROOT/templates/mx_joomla132/lib/framework/layout/content.php | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:54 |
| 9 | sboostHelper->import() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:95 |
| 8 | sboostHelper->loadLayout() | JROOT/templates/mx_joomla132/index.php:100 |
| 7 | require JROOT/templates/mx_joomla132/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:1030 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 2.71 ms Dopo l'ultima query: 25.37 ms Memoria query: 0.058 MB memoria prima della query: 16.180 MB Righe restituite: 182
SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate,
weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
FROM `jos_icagenda_events` AS e
WHERE e.state = 1 OR e.state = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 199 | Using where |
| Status | Duration |
|---|
| Starting | 0.27 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.69 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.13 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| init | 0.09 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.04 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.75 ms |
| End of update loop | 0.06 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/data.php:848 |
| 11 | icagendaEventsData::getNext() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:131 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.57 ms Dopo l'ultima query: 29.58 ms Memoria query: 0.025 MB memoria prima della query: 16.233 MB Righe restituite: 3
SELECT m.title, m.published, m.id, m.params, m.language
FROM `jos_menu` AS m
WHERE (m.link = 'index.php?option=com_icagenda&view=list')
AND (m.published = 1)
AND m.language in ('it-IT','*')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_language | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 280 | Using where |
| Status | Duration |
|---|
| Starting | 0.26 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.09 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.10 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.41 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.05 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.12 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.04 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/menus/menus.php:56 |
| 11 | icagendaMenus::iClistMenuItemsInfo() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:202 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 3.38 ms Dopo l'ultima query: 2.23 ms Memoria query: 0.106 MB memoria prima della query: 16.314 MB Righe restituite: 25
SELECT e.*
FROM jos_icagenda_events AS e
LEFT JOIN `jos_icagenda_category` AS c
ON c.id = e.catid
WHERE c.state = 1
AND e.state = 1
AND e.catid IN (1,3)
AND TRUE
AND e.language IN ('it-IT','*')
AND e.access IN (1, 1, 5)
AND e.approval <> 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | range | fb_groupbyorder_catid_INDEX | fb_groupbyorder_catid_INDEX | 4 | NULL | 41 | Using index condition; Using where |
| 1 | SIMPLE | c | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 3 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.19 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.59 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.05 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| init | 0.10 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.16 ms |
| Preparing | 0.08 ms |
| Executing | 0.02 ms |
| Sending data | 1.54 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.06 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/data.php:174 |
| 16 | icagendaEventsData::getAllDates() | JROOT/components/com_icagenda/models/events.php:255 |
| 15 | iCagendaModelEvents->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 14 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_icagenda/models/events.php:295 |
| 12 | iCagendaModelEvents->getItems() | JROOT/modules/mod_ic_event_list/helper.php:112 |
| 11 | modiCEventListHelper::getList() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:216 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 8.69 ms Dopo l'ultima query: 3.47 ms Memoria query: 0.097 MB memoria prima della query: 16.349 MB Righe restituite: 25
SELECT e.*,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,
c.title AS category, c.color AS catcolor,feat.count AS features,r.count AS registered
FROM `jos_icagenda_events` AS e
LEFT JOIN jos_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN (
SELECT r.state, r.date, r.eventid, sum(r.people) AS count
FROM `jos_icagenda_registration` AS r
WHERE r.state > 0
GROUP BY r.date, r.eventid) AS r
ON ((e.next = r.date OR r.date = "")
AND e.id = r.eventid)
WHERE c.state = 1
AND e.state = 1
AND e.approval <> 1
AND e.access IN (1,1,5)
AND e.language in ('it-IT','*')
AND e.id IN (200, 189, 184, 193, 185, 190, 199, 198, 204, 205, 188, 207, 195, 196, 202, 208, 182, 183, 197, 175, 209, 206, 201, 191, 172)
ORDER BY e.next ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 3 | Using where; Using temporary; Using filesort |
| 1 | PRIMARY | e | ref | PRIMARY,fb_groupbyorder_catid_INDEX | fb_groupbyorder_catid_INDEX | 4 | cronorun_newcron.c.id | 62 | Using index condition; Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | cronorun_newcron.e.id | 7 | |
| 1 | PRIMARY | <derived3> | ref | key0 | key0 | 5 | cronorun_newcron.e.id | 3 | Using where |
| 3 | DERIVED | r | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 31 | Using where; Using temporary; Using filesort |
| 2 | DERIVED | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 2 | DERIVED | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.34 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.94 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.11 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| init | 0.20 ms |
| Optimizing | 0.08 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.08 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.02 ms |
| Statistics | 0.11 ms |
| Preparing | 0.06 ms |
| Creating tmp table | 0.15 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.22 ms |
| Executing | 0.02 ms |
| Sending data | 0.16 ms |
| Creating sort index | 0.08 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.27 ms |
| Executing | 0.06 ms |
| Sending data | 0.44 ms |
| Creating sort index | 0.26 ms |
| Removing tmp table | 0.19 ms |
| Creating sort index | 2.77 ms |
| Creating sort index | 0.67 ms |
| Removing tmp table | 0.30 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.17 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.11 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_icagenda/models/events.php:295 |
| 12 | iCagendaModelEvents->getItems() | JROOT/modules/mod_ic_event_list/helper.php:112 |
| 11 | modiCEventListHelper::getList() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:216 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 2.19 ms Dopo l'ultima query: 0.52 ms Memoria query: 0.085 MB memoria prima della query: 16.615 MB Righe restituite: 25
SELECT e.*
FROM jos_icagenda_events AS e
LEFT JOIN `jos_icagenda_category` AS c
ON c.id = e.catid
WHERE c.state = 1
AND e.state = 1
AND e.catid IN (1,3)
AND TRUE
AND e.language IN ('it-IT','*')
AND e.access IN (1, 1, 5)
AND e.approval <> 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | range | fb_groupbyorder_catid_INDEX | fb_groupbyorder_catid_INDEX | 4 | NULL | 41 | Using index condition; Using where |
| 1 | SIMPLE | c | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 3 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.08 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.06 ms |
| Preparing | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 1.33 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/data.php:174 |
| 11 | icagendaEventsData::getAllDates() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:301 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.57 ms Dopo l'ultima query: 5.51 ms Memoria query: 0.024 MB memoria prima della query: 16.775 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=172
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.25 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.07 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.06 ms |
| Preparing | 0.07 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.15 ms |
| Creating sort index | 0.04 ms |
| Removing tmp table | 0.04 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.13 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.04 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.34 ms Dopo l'ultima query: 1.72 ms Memoria query: 0.024 MB memoria prima della query: 16.788 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=191
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.22 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.07 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.06 ms |
| Preparing | 0.08 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.10 ms |
| Creating sort index | 0.05 ms |
| Removing tmp table | 0.03 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 4.37 ms Dopo l'ultima query: 1.67 ms Memoria query: 0.025 MB memoria prima della query: 16.802 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=201
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.19 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.05 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.08 ms |
| Creating sort index | 0.04 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.07 ms Dopo l'ultima query: 1.94 ms Memoria query: 0.024 MB memoria prima della query: 16.810 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=206
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.18 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.08 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.04 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.89 ms Dopo l'ultima query: 1.60 ms Memoria query: 0.024 MB memoria prima della query: 16.817 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=209
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.95 ms Dopo l'ultima query: 1.33 ms Memoria query: 0.024 MB memoria prima della query: 16.824 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=175
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.15 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.04 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.90 ms Dopo l'ultima query: 1.31 ms Memoria query: 0.024 MB memoria prima della query: 16.832 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=197
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.15 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.81 ms Dopo l'ultima query: 1.23 ms Memoria query: 0.024 MB memoria prima della query: 16.839 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=183
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.82 ms Dopo l'ultima query: 1.16 ms Memoria query: 0.024 MB memoria prima della query: 16.846 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=182
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.04 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.82 ms Dopo l'ultima query: 0.99 ms Memoria query: 0.024 MB memoria prima della query: 16.853 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=208
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.82 ms Dopo l'ultima query: 1.03 ms Memoria query: 0.024 MB memoria prima della query: 16.860 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=202
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.84 ms Dopo l'ultima query: 0.96 ms Memoria query: 0.024 MB memoria prima della query: 16.867 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=196
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.04 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.79 ms Dopo l'ultima query: 1.00 ms Memoria query: 0.024 MB memoria prima della query: 16.875 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=195
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.83 ms Dopo l'ultima query: 0.96 ms Memoria query: 0.024 MB memoria prima della query: 16.897 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=207
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.80 ms Dopo l'ultima query: 0.98 ms Memoria query: 0.024 MB memoria prima della query: 16.905 MB Righe restituite: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=188
ORDER BY f.ordering DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
| 11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
| 10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.74 ms Dopo l'ultima query: 2.51 ms Memoria query: 0.039 MB memoria prima della query: 16.621 MB Righe restituite: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'mod_custom.content'
AND (fc.category_id IS NULL OR fc.category_id IN (110,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 ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | cronorun_newcron.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.20 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.14 ms |
| Preparing | 0.05 ms |
| Creating tmp table | 0.08 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.45 ms |
| Creating sort index | 0.06 ms |
| Removing tmp table | 0.13 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:488 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 14 | JHtmlContent::prepare() | Chiamata uguale alla linea sottostante. |
| 13 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.55 ms Dopo l'ultima query: 12.20 ms Memoria query: 0.025 MB memoria prima della query: 16.942 MB Righe restituite: 3
SELECT m.title, m.published, m.id, m.params, m.language
FROM `jos_menu` AS m
WHERE (m.link = 'index.php?option=com_icagenda&view=list')
AND (m.published = 1)
AND m.language in ('it-IT','*')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_language | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 280 | Using where |
| Status | Duration |
|---|
| Starting | 0.26 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.10 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.45 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/menus/menus.php:56 |
| 12 | icagendaMenus::iClistMenuItemsInfo() | JROOT/modules/mod_iccalendar/helper.php:117 |
| 11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:169 |
| 10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 6.08 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.116 MB memoria prima della query: 16.959 MB Righe restituite: 27
SELECT e.*,
e.place as place_name,
c.title as cat_title,
c.alias as cat_alias,
c.color as cat_color,
c.ordering as cat_order
,feat.count AS features,r.count AS registered, r.date AS reg_date
FROM `jos_icagenda_events` AS e
LEFT JOIN `jos_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN (
SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `jos_icagenda_registration` AS r
WHERE r.state > 0
GROUP BY r.eventid) AS r
ON e.id=r.eventid
WHERE c.state = 1
AND e.state = 1
AND e.approval = 0
AND e.next >= '2023-03-01'
AND e.access IN (1, 1, 5)
AND e.language IN ('it-IT','*')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 3 | Using where |
| 1 | PRIMARY | e | ref | fb_groupbyorder_catid_INDEX | fb_groupbyorder_catid_INDEX | 4 | cronorun_newcron.c.id | 62 | Using index condition; Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | cronorun_newcron.e.id | 7 | |
| 1 | PRIMARY | <derived3> | ref | key0 | key0 | 5 | cronorun_newcron.e.id | 3 | |
| 3 | DERIVED | r | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 31 | Using where; Using temporary; Using filesort |
| 2 | DERIVED | f | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
| 2 | DERIVED | fx | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.27 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.18 ms |
| Optimizing | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.25 ms |
| Executing | 0.02 ms |
| Sending data | 0.11 ms |
| Creating sort index | 0.07 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.30 ms |
| Executing | 0.02 ms |
| Sending data | 0.40 ms |
| Creating sort index | 0.14 ms |
| Removing tmp table | 0.16 ms |
| Creating sort index | 2.90 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.19 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_iccalendar/helper.php:236 |
| 11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:169 |
| 10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.75 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.027 MB memoria prima della query: 17.255 MB Righe restituite: 31
SELECT r.date AS date, r.eventid AS eventid, r.people AS people
FROM `jos_icagenda_registration` AS r
WHERE r.state = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | r | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 31 | Using where |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/data.php:1239 |
| 12 | icagendaEventsData::registeredList() | JROOT/modules/mod_iccalendar/helper.php:238 |
| 11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:169 |
| 10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.08 ms Dopo l'ultima query: 25.46 ms Memoria query: 0.032 MB memoria prima della query: 17.384 MB Righe restituite: 163
SELECT id AS nbevt
FROM `jos_icagenda_events` AS e
WHERE e.state > 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 199 | Using where |
| Status | Duration |
|---|
| Starting | 0.15 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.34 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 12 | JDatabaseDriver->loadResult() | JROOT/modules/mod_iccalendar/helper.php:607 |
| 11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:169 |
| 10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.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:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.66 ms Dopo l'ultima query: 29.31 ms Memoria query: 0.036 MB memoria prima della query: 18.538 MB Righe restituite: 164
SHOW TABLES
EXPLAIN non possibile sulla query: SHOW TABLES
| Status | Duration |
|---|
| Starting | 0.18 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.02 ms |
| checking permissions | 0.68 ms |
| Executing | 0.02 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 20 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:502 |
| 19 | JDatabaseDriverMysqli->getTableList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:550 |
| 18 | acymailing_getTableList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:16 |
| 17 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:455 |
| 16 | acymailing_config() | JROOT/administrator/components/com_acymailing/compat/joomla.php:817 |
| 15 | include_once JROOT/administrator/components/com_acymailing/compat/joomla.php | JROOT/administrator/components/com_acymailing/helpers/helper.php:23 |
| 14 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/components/com_acymailing/inc/joomlanotification/mail.php:47 |
| 13 | JMail->initMailCorrespondance() | JROOT/components/com_acymailing/inc/joomlanotification/mail.php:41 |
| 12 | JMail->__construct() | JROOT/components/com_acymailing/inc/joomlanotification/jMail_J25.php:62 |
| 11 | jMail_acy::getInstance() | JROOT/libraries/src/Factory.php:695 |
| 10 | Joomla\CMS\Factory::createMailer() | JROOT/libraries/src/Factory.php:367 |
| 9 | Joomla\CMS\Factory::getMailer() | JROOT/plugins/system/fabrikcron/fabrikcron.php:147 |
| 8 | PlgSystemFabrikcron->doCron() | JROOT/plugins/system/fabrikcron/fabrikcron.php:304 |
| 7 | PlgSystemFabrikcron->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.30 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.040 MB memoria prima della query: 18.568 MB Righe restituite: 168
SELECT *
FROM jos_acymailing_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jos_acymailing_config | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 168 | |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.38 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.18 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File e numero di linea |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:476 |
| 18 | acymailing_loadObjectList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:21 |
| 17 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:455 |
| 16 | acymailing_config() | JROOT/administrator/components/com_acymailing/compat/joomla.php:817 |
| 15 | include_once JROOT/administrator/components/com_acymailing/compat/joomla.php | JROOT/administrator/components/com_acymailing/helpers/helper.php:23 |
| 14 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/components/com_acymailing/inc/joomlanotification/mail.php:47 |
| 13 | JMail->initMailCorrespondance() | JROOT/components/com_acymailing/inc/joomlanotification/mail.php:41 |
| 12 | JMail->__construct() | JROOT/components/com_acymailing/inc/joomlanotification/jMail_J25.php:62 |
| 11 | jMail_acy::getInstance() | JROOT/libraries/src/Factory.php:695 |
| 10 | Joomla\CMS\Factory::createMailer() | JROOT/libraries/src/Factory.php:367 |
| 9 | Joomla\CMS\Factory::getMailer() | JROOT/plugins/system/fabrikcron/fabrikcron.php:147 |
| 8 | PlgSystemFabrikcron->doCron() | JROOT/plugins/system/fabrikcron/fabrikcron.php:304 |
| 7 | PlgSystemFabrikcron->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
15 × SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
3 × SELECT `session_id`
FROM `jos_session`
2 × 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc
ON fc.field_id = a.id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
2 × SELECT e.*
FROM jos_icagenda_events AS e
LEFT JOIN `jos_icagenda_category` AS c
ON c.id = e.catid
2 × SELECT m.title, m.published, m.id, m.params, m.language
FROM `jos_menu` AS m
1 × SELECT `data`
FROM `jos_session`
1 × SELECT id AS nbevt
FROM `jos_icagenda_events` AS e
1 × SELECT r.date AS date, r.eventid AS eventid, r.people AS people
FROM `jos_icagenda_registration` AS r
1 × SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as cat_alias, c.color as cat_color, c.ordering as cat_order ,feat.count AS features,r.count AS registered, r.date AS reg_date
FROM `jos_icagenda_events` AS e
LEFT JOIN `jos_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN ( SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `jos_icagenda_registration` AS r
1 × SELECT e.*,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc, c.title AS category, c.color AS catcolor,feat.count AS features,r.count AS registered
FROM `jos_icagenda_events` AS e
LEFT JOIN jos_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN ( SELECT r.state, r.date, r.eventid, sum(r.people) AS count
FROM `jos_icagenda_registration` AS r
1 × SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate, weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
FROM `jos_icagenda_events` AS e
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `c2`.`language`,`c2`.`id`
FROM `jos_menu` AS `c`
INNER JOIN `jos_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `jos_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jos_menu` AS `c2`
ON a2.id = c2.`id`
1 × SELECT language,id
FROM `jos_menu`
1 × SELECT `extension_id`,`name`,`enabled`,`params`
FROM jos_extensions
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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('it-IT','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
1 × SELECT COUNT(*)
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
1 × SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `jos_extensions`
1 × SELECT *
FROM jos_languages
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_extensions
1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `jos_viewlevels
1 × SELECT *
FROM jos_acymailing_confi
