Tempo della query: 0.33 ms Memoria query: 0.023 MB memoria prima della query: 1.028 MB Righe restituite: 1
SELECT `data`
FROM `gov3_session`
WHERE `session_id` = X'666972686466736d36316371657035306a7572696a6567683064'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Chiamata uguale alla linea sottostante. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:45 |
Tempo della query: 0.51 ms Dopo l'ultima query: 1.31 ms Memoria query: 0.042 MB memoria prima della query: 1.091 MB Righe restituite: 49
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `gov3_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_extensions | NULL | ref | extension | extension | 82 | const | 50 | 1.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.20 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Chiamata uguale alla linea sottostante. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.23 ms Dopo l'ultima query: 0.58 ms Memoria query: 0.021 MB memoria prima della query: 1.133 MB Righe restituite: 9
SELECT id, rules
FROM `gov3_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_viewlevels | NULL | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 9 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.04 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.33 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 1.147 MB Righe restituite: 2
SELECT b.id
FROM gov3_usergroups AS a
LEFT JOIN gov3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.69 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.046 MB memoria prima della query: 1.168 MB Righe restituite: 108
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM gov3_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_extensions | NULL | ref | extension | extension | 82 | const | 147 | 0.60 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
executing | 0.40 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Chiamata uguale alla linea sottostante. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.29 ms Dopo l'ultima query: 15.13 ms Memoria query: 0.004 MB memoria prima della query: 2.011 MB
DELETE
FROM `gov3_mi_iptable`
WHERE DATE_ADD(`lasthacktime`, INTERVAL 900 SECOND) < NOW()
AND `autodelete`=1;
EXPLAIN non possibile sulla query: DELETE FROM `gov3_mi_iptable` WHERE DATE_ADD(`lasthacktime`, INTERVAL 900 SECOND) < NOW() AND `autodelete`=1;
Status | Duration |
---|
starting | 0.08 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.03 ms |
updating | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:53 |
8 | plgSystemMarcosinterceptor->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.20 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.020 MB memoria prima della query: 2.015 MB Righe restituite: 1
SELECT COUNT(*)
from `gov3_mi_iptable`
WHERE ip = '127.0.0.1'
AND `hackcount` >= 3
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.04 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:61 |
8 | plgSystemMarcosinterceptor->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.18 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.020 MB memoria prima della query: 2.019 MB Righe restituite: 1
SELECT COUNT(*)
from `gov3_mi_iptable`
WHERE ip = '127.0.0.1'
AND `hackcount` >= 3
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.03 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:65 |
8 | plgSystemMarcosinterceptor->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 3.88 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.005 MB memoria prima della query: 2.032 MB
UPDATE gov3_content
SET state=2
, publish_down =DATE_ADD(publish_down, INTERVAL 30 DAY)
, publish_down ='0000-00-00 00:00:00'
WHERE state='1'
AND publish_down <='2023-03-01 16:49:02'
AND publish_down !='0000-00-00 00:00:00'
EXPLAIN non possibile sulla query: UPDATE gov3_content
SET state=2
, publish_down =DATE_ADD(publish_down, INTERVAL 30 DAY)
, publish_down ='0000-00-00 00:00:00'
WHERE state='1' AND publish_down <='2023-03-01 16:49:02' AND publish_down !='0000-00-00 00:00:00'
Status | Duration |
---|
starting | 0.06 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.04 ms |
init | 0.01 ms |
System lock | 0.08 ms |
updating | 3.55 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
9 | JDatabase->query() | JROOT/plugins/system/chanse/chanse.php:155 |
8 | plgSystemChanse->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.37 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.005 MB memoria prima della query: 2.037 MB
UPDATE gov3_content
SET state='0'
WHERE state='2'
AND publish_down <='2023-03-01 16:49:02'
AND publish_down !='0000-00-00 00:00:00'
EXPLAIN non possibile sulla query: UPDATE gov3_content
SET state='0'
WHERE state='2' AND publish_down <='2023-03-01 16:49:02' AND publish_down !='0000-00-00 00:00:00'
Status | Duration |
---|
starting | 0.06 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.07 ms |
Searching rows for update | 0.08 ms |
updating | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
9 | JDatabase->query() | JROOT/plugins/system/chanse/chanse.php:179 |
8 | plgSystemChanse->OnAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.17 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.020 MB memoria prima della query: 2.043 MB Righe restituite: 1
SELECT count(*)
FROM `gov3_cwgears_schedule`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | NULL | Select tables optimized away |
Status | Duration |
---|
starting | 0.04 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.00 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/cwgears.php:96 |
8 | plgSystemCwgears->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.22 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.020 MB memoria prima della query: 2.048 MB Righe restituite: 1
SELECT count(*)
FROM `gov3_cwgears_schedule`
WHERE time + '86400'<'1677689342'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
starting | 0.03 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.00 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.03 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/cwgears.php:139 |
8 | plgSystemCwgears->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 1.28 ms Dopo l'ultima query: 0.78 ms Memoria query: 0.147 MB memoria prima della query: 2.081 MB Righe restituite: 84
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 gov3_menu AS m
LEFT JOIN gov3_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_client_id_parent_id_alias_language | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 183 | 5.36 | Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
executing | 0.79 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Chiamata uguale alla linea sottostante. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.99 ms Dopo l'ultima query: 6.26 ms Memoria query: 0.023 MB memoria prima della query: 2.578 MB Righe restituite: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `gov3_categories` AS `s`
INNER JOIN `gov3_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 92
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 142 | 73.11 | Using where |
Status | Duration |
---|
starting | 0.13 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.06 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.14 ms |
preparing | 0.03 ms |
executing | 0.35 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.03 ms |
# | Caller | File e numero di linea |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
12 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
11 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:350 |
10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.48 ms Dopo l'ultima query: 0.57 ms Memoria query: 0.024 MB memoria prima della query: 2.626 MB Righe restituite: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `gov3_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
executing | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Chiamata uguale alla linea sottostante. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/cwgears/cwgears.php:195 |
8 | plgSystemCwgears->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.29 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.006 MB memoria prima della query: 2.619 MB
UPDATE `gov3_extensions`
SET `params` = '{\"mediaversion\":\"f980461ae85343b3efc2d7be12b9f7b3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN non possibile sulla query: UPDATE `gov3_extensions`
SET `params` = '{\"mediaversion\":\"f980461ae85343b3efc2d7be12b9f7b3\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.06 ms |
updating | 0.04 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/cwgears/cwgears.php:195 |
8 | plgSystemCwgears->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.25 ms Dopo l'ultima query: 0.55 ms Memoria query: 0.021 MB memoria prima della query: 2.639 MB Righe restituite: 1
SELECT count(*)
FROM `gov3_extensions`
WHERE `element` = 'cwgears'
AND `extension_id` = ''
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/cwgears.php:1003 |
9 | plgSystemCwgears->updateDownloadKeySub() | JROOT/plugins/system/cwgears/cwgears.php:202 |
8 | plgSystemCwgears->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.37 ms Dopo l'ultima query: 0.46 ms Memoria query: 0.020 MB memoria prima della query: 2.645 MB Righe restituite: 0
SELECT id,
LEFT( tm, 9 ) , ip, count(*)
FROM `gov3_cwtraffic`
GROUP BY
LEFT( tm, 9 ) , ip
HAVING count(*) > 1
LIMIT 50
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_cwtraffic | NULL | ALL | unique_tm_ip,idx_iptm | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 7 | 100.00 | Using temporary |
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
Creating tmp table | 0.03 ms |
executing | 0.11 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:129 |
8 | plgSystemCwtrafficClean->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.17 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.021 MB memoria prima della query: 2.649 MB Righe restituite: 3
SELECT TCOUNT
FROM `gov3_cwtraffic_total`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_cwtraffic_total | NULL | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 3 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.00 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:217 |
8 | plgSystemCwtrafficClean->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.23 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.020 MB memoria prima della query: 2.655 MB Righe restituite: 1
SELECT count(*)
FROM `gov3_cwtraffic`
WHERE tm < '1677020400'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_cwtraffic | NULL | range | unique_tm_ip,unique_tm_iphash,idx_tm,idx_iptm,idx_iphashtm | unique_tm_ip | 4 | NULL | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.03 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.00 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.02 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:286 |
8 | plgSystemCwtrafficClean->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.22 ms Dopo l'ultima query: 0.64 ms Memoria query: 0.020 MB memoria prima della query: 2.662 MB Righe restituite: 0
SELECT ip
FROM `gov3_cwtraffic_knownips`
WHERE state = 1
AND count = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.00 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
9 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:163 |
8 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.17 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.020 MB memoria prima della query: 2.667 MB Righe restituite: 0
SELECT botname
FROM `gov3_cwtraffic_knownips`
WHERE state = 1
AND count = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.03 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
9 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:191 |
8 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.30 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.020 MB memoria prima della query: 2.672 MB Righe restituite: 1
SELECT count(*)
FROM `gov3_cwtraffic`
WHERE iphash = UNHEX(SHA1('127.0.0.1'))
AND tm + '86400'>'1677689342'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_cwtraffic | NULL | ref | unique_tm_iphash,idx_iphash,idx_iphashtm | idx_iphashtm | 20 | const | 3 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.04 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.00 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:247 |
8 | plgSystemCwtrafficCount->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.45 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.021 MB memoria prima della query: 2.680 MB Righe restituite: 3
SELECT id, home, template, s.params
FROM gov3_template_styles as s
LEFT JOIN gov3_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | 1.00 | Using index condition; Using where |
1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | perasso2.e.element | 1 | 60.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.06 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.04 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
executing | 0.09 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:2035 |
9 | plgSystemEF4_JMFramework->getTemplateName() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:417 |
8 | plgSystemEF4_JMFramework->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.38 ms Dopo l'ultima query: 2.65 ms Memoria query: 0.020 MB memoria prima della query: 2.819 MB Righe restituite: 2
SELECT *
FROM gov3_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_languages | NULL | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | 50.00 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.07 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 1.03 ms Dopo l'ultima query: 2.35 ms Memoria query: 0.030 MB memoria prima della query: 3.009 MB Righe restituite: 49
SELECT `id`,`name`,`rules`,`parent_id`
FROM `gov3_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_albopretorio_online','com_associations','com_attachments','com_banners','com_buttons','com_cache','com_categories','com_checkin','com_chronoconnectivity5','com_chronoforms5','com_coalawebtraffic','com_config','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_dmfrontendusermanager','com_dmhelper','com_fields','com_finder','com_hwdmediashare','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_minitekwall','com_modules','com_moduliscuola_online','com_newsfeeds','com_nspro','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_tags','com_templates','com_users','com_wrapper')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 50 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.13 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.18 ms |
preparing | 0.04 ms |
executing | 0.42 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 1.36 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.166 MB memoria prima della query: 3.069 MB Righe restituite: 1213
SELECT `id`,`name`,`rules`,`parent_id`
FROM `gov3_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_assets | NULL | ALL | idx_asset_name,idx_parent_id | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1399 | 21.29 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 1.08 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 1.22 ms Dopo l'ultima query: 2.65 ms Memoria query: 0.025 MB memoria prima della query: 4.056 MB Righe restituite: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)
FROM `gov3_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `gov3_categories` AS `s`
INNER JOIN `gov3_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 92
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | PRIMARY | c | NULL | ALL | cat_idx,idx_left_right | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 142 | 71.95 | Using where |
2 | DEPENDENT SUBQUERY | i | NULL | ref | idx_state,idx_catid | idx_catid | 4 | perasso2.c.id | 31 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.14 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.07 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.03 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.03 ms |
executing | 0.52 ms |
executing | 0.03 ms |
executing | 0.02 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.03 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 |
13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 1.07 ms Dopo l'ultima query: 0.89 ms Memoria query: 0.024 MB memoria prima della query: 4.105 MB Righe restituite: 0
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,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 gov3_content AS a
LEFT JOIN gov3_categories AS c
ON c.id = a.catid
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_by
LEFT JOIN gov3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gov3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gov3_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.catid = 92
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-01 16:49:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-01 16:49:02')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 20
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 1 | 16.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.modified_by | 1 | 100.00 | Using where |
1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.28 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.16 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.09 ms |
statistics | 0.18 ms |
preparing | 0.07 ms |
executing | 0.07 ms |
end | 0.00 ms |
query end | 0.00 ms |
waiting for handler commit | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.55 ms Dopo l'ultima query: 0.50 ms Memoria query: 0.024 MB memoria prima della query: 4.127 MB Righe restituite: 1
SELECT COUNT(*)
FROM gov3_content AS a
LEFT JOIN gov3_categories AS c
ON c.id = a.catid
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_by
LEFT JOIN gov3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gov3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gov3_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.catid = 92
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-01 16:49:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-01 16:49:02')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 1 | 16.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.created_by | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.modified_by | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.id | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.13 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.07 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.12 ms |
preparing | 0.04 ms |
executing | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:289 |
15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:239 |
14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.40 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.022 MB memoria prima della query: 4.136 MB Righe restituite: 0
SELECT `m`.`tag_id`,`t`.*
FROM `gov3_contentitem_tag_map` AS m
INNER JOIN `gov3_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 92
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | 100.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | perasso2.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.04 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:229 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 1.23 ms Dopo l'ultima query: 3.28 ms Memoria query: 0.026 MB memoria prima della query: 4.401 MB Righe restituite: 5
SHOW FULL COLUMNS
FROM `gov3_hwdms_config`
EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `gov3_hwdms_config`
Status | Duration |
---|
starting | 0.07 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.45 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
executing | 0.09 ms |
checking permissions | 0.05 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.04 ms |
end | 0.00 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
18 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
17 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_hwdmediashare/tables/configuration.php:47 |
16 | hwdMediaShareTableConfiguration->__construct() | JROOT/libraries/src/Table/Table.php:328 |
15 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_hwdmediashare/libraries/factory.php:243 |
14 | hwdMediaShareFactory->getConfig() | JROOT/plugins/content/media/media.php:123 |
13 | plgContentMedia->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_content/views/category/view.html.php:88 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.26 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.025 MB memoria prima della query: 4.427 MB Righe restituite: 1
SELECT *
FROM gov3_hwdms_config
WHERE `id` = '1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_hwdms_config | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
16 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
15 | Joomla\CMS\Table\Table->load() | JROOT/components/com_hwdmediashare/libraries/factory.php:249 |
14 | hwdMediaShareFactory->getConfig() | JROOT/plugins/content/media/media.php:123 |
13 | plgContentMedia->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_content/views/category/view.html.php:88 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.71 ms Dopo l'ultima query: 6.44 ms Memoria query: 0.028 MB memoria prima della query: 4.985 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 gov3_fields AS a
LEFT JOIN `gov3_languages` AS l
ON l.lang_code = a.language
LEFT JOIN gov3_users AS uc
ON uc.id=a.checked_out
LEFT JOIN gov3_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN gov3_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | perasso2.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.group_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.13 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.08 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.16 ms |
preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
executing | 0.05 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
24 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
23 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
22 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
21 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
20 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/layouts/joomla/content/category_default.php:25 |
17 | include JROOT/layouts/joomla/content/category_default.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
16 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
15 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_content/views/category/tmpl/default.php:20 |
14 | include JROOT/components/com_content/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.76 ms Dopo l'ultima query: 10.24 ms Memoria query: 0.028 MB memoria prima della query: 5.237 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 gov3_fields AS a
LEFT JOIN `gov3_languages` AS l
ON l.lang_code = a.language
LEFT JOIN gov3_users AS uc
ON uc.id=a.checked_out
LEFT JOIN gov3_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN gov3_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `gov3_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (92,0,13))
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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | perasso2.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | perasso2.a.id | 1 | 100.00 | Using where; Using index; Distinct |
Status | Duration |
---|
starting | 0.15 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.09 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.13 ms |
preparing | 0.03 ms |
Creating tmp table | 0.06 ms |
executing | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
25 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
24 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
23 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
22 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:404 |
21 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:324 |
20 | PlgSystemFields->onContentAfterTitle() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/layouts/joomla/content/category_default.php:28 |
17 | include JROOT/layouts/joomla/content/category_default.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
16 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
15 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_content/views/category/tmpl/default.php:20 |
14 | include JROOT/components/com_content/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.33 ms Dopo l'ultima query: 2.75 ms Memoria query: 0.027 MB memoria prima della query: 5.369 MB Righe restituite: 1
SELECT created_by, catid
FROM gov3_content
WHERE id = 92
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.07 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 |
21 | AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() | JROOT/plugins/content/attachments/attachments.php:319 |
20 | plgContentAttachments->onContentBeforeDisplay() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/layouts/joomla/content/category_default.php:31 |
17 | include JROOT/layouts/joomla/content/category_default.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
16 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
15 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_content/views/category/tmpl/default.php:20 |
14 | include JROOT/components/com_content/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 1.91 ms Dopo l'ultima query: 0.88 ms Memoria query: 0.028 MB memoria prima della query: 5.426 MB Righe restituite: 0
SELECT a.*, u.name as creator_name
FROM gov3_attachments AS a
LEFT JOIN gov3_users AS u
ON u.id = a.created_by
WHERE a.parent_id=92
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1,5)
ORDER BY filename
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1076 | 0.09 | Using where; Using filesort |
1 | SIMPLE | u | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.created_by | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.09 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.05 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
preparing | 0.03 ms |
executing | 1.50 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | Caller | File e numero di linea |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/components/com_attachments/models/attachments.php:436 |
24 | AttachmentsModelAttachments->getAttachmentsList() | JROOT/components/com_attachments/models/attachments.php:514 |
23 | AttachmentsModelAttachments->someVisible() | JROOT/components/com_attachments/controllers/attachments.php:98 |
22 | AttachmentsControllerAttachments->displayString() | JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 |
21 | AttachmentsPlugin->insertAttachmentsList() | JROOT/plugins/content/attachments/attachments.php:325 |
20 | plgContentAttachments->onContentBeforeDisplay() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/layouts/joomla/content/category_default.php:31 |
17 | include JROOT/layouts/joomla/content/category_default.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
16 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
15 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_content/views/category/tmpl/default.php:20 |
14 | include JROOT/components/com_content/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.72 ms Dopo l'ultima query: 0.76 ms Memoria query: 0.029 MB memoria prima della query: 5.442 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 gov3_fields AS a
LEFT JOIN `gov3_languages` AS l
ON l.lang_code = a.language
LEFT JOIN gov3_users AS uc
ON uc.id=a.checked_out
LEFT JOIN gov3_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN gov3_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.category.title'
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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | perasso2.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.group_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.16 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.08 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
executing | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
28 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
27 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
26 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
25 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
24 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
23 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
22 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
21 | JHtmlContent::prepare() | Chiamata uguale alla linea sottostante. |
20 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
19 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
18 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/layouts/joomla/content/category_default.php:57 |
17 | include JROOT/layouts/joomla/content/category_default.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
16 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
15 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_content/views/category/tmpl/default.php:20 |
14 | include JROOT/components/com_content/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.68 ms Dopo l'ultima query: 1.00 ms Memoria query: 0.029 MB memoria prima della query: 5.458 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 gov3_fields AS a
LEFT JOIN `gov3_languages` AS l
ON l.lang_code = a.language
LEFT JOIN gov3_users AS uc
ON uc.id=a.checked_out
LEFT JOIN gov3_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN gov3_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.category.description'
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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using where; Using temporary; Using filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | perasso2.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.group_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.13 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.07 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
executing | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
28 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
27 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
26 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
25 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
24 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
23 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
22 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
21 | JHtmlContent::prepare() | Chiamata uguale alla linea sottostante. |
20 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
19 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 |
18 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/layouts/joomla/content/category_default.php:73 |
17 | include JROOT/layouts/joomla/content/category_default.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
16 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
15 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_content/views/category/tmpl/default.php:20 |
14 | include JROOT/components/com_content/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.50 ms Dopo l'ultima query: 0.76 ms Memoria query: 0.028 MB memoria prima della query: 5.489 MB Righe restituite: 0
SELECT id
FROM gov3_categories
WHERE description='\n\n<!-- START: Sliders -->\n<div class=\"rl_sliders nn_sliders accordion panel-
group\" id=\"
set-rl_sliders-2\" role=\"presentation\"><a id=\"rl_sliders-scrollto_2\" class=\"anchor rl_sliders-scroll nn_sliders-scroll\"></a>\n<div class=\"accordion-
group panel rl_sliders-
group nn_sliders-
group\">\n<a id=\"rl_sliders-scrollto_riferimenti-normativi-2\" class=\"anchor rl_sliders-scroll nn_sliders-scroll\"></a>\n<div class=\"accordion-heading panel-heading\" aria-controls=\"riferimenti-normativi-2\">\n<a href=\"http://vecchiosito.icperasso.edu.it/albo-e-trasparenza/archivio-fino-al-30-11-2021/amministrazione-trasparente/92-informazioni-ambientali.html#riferimenti-normativi-2\" title=\"Riferimenti normativi\" class=\"accordion-toggle rl_sliders-toggle nn_sliders-toggle collapsed\" data-toggle=\"collapse\" id=\"slider-riferimenti-normativi-2\" data-id=\"riferimenti-normativi-2\" data-parent=\"#
set-rl_sliders-2\" aria-expanded=\"false\"><span class=\"rl_sliders-toggle-
inner nn_sliders-toggle-
inner\"> Riferimenti normativi</span></a>\n</div>\n<div class=\"accordion-body rl_sliders-body nn_sliders-body collapse\" role=\"region\" aria-labelledby=\"slider-riferimenti-normativi-2\" aria-hidden=\"true\" id=\"riferimenti-normativi-2\">\n<div class=\"accordion-
inner panel-body\">\n<h2 class=\"rl_sliders-title nn_sliders-title\">Riferimenti normativi</h2>\n<p><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\">INFORMAZIONI:</span></strong></p>\n<p><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\">Qualsiasi informazione disponibile in forma scritta, visiva, sonora, elettronica od in qualunque altra forma materiale concernente:</span></p>\n<ul>\n<li><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\">lo stato degli elementi dell\'ambiente, quali l\'aria, l\'atmosfera, l\'acqua, il suolo, il territorio, i siti naturali, compresi gli igrotopi, le zone costiere e marine, la diversità biologica ed i suoi elementi costitutivi, compresi gli organismi geneticamente modificati, e, inoltre, le interazioni tra questi elementi;</span></li>\n<li><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\">fattori quali le sostanze, l\'energia, il rumore, le radiazioni od i rifiuti, anche quelli radioattivi, le missioni, gli scarichi ed altri rilasci nell\'ambiente, che incidono o possono incidere sugli elementi dell\'ambiente, individuati al numero 1);</span></li>\n<li><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\">le misure, anche amministrative, quali le politiche, le disposizioni legislative, i piani, i programmi, gli accordi ambientali e ogni altro atto, anche di natura amministrativa, nonché le attività che incidono o possono incidere sugli elementi e sui fattori dell\'ambiente di cui ai numeri 1) e 2), e le misure o le attività finalizzate a proteggere i suddetti elementi;</span></li>\n<li><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\">le relazioni sull\'attuazione della legislazione ambientale;</span></li>\n<li><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\">le analisi costi-benefici ed altre analisi ed ipotesi economiche, usate nell\'ambito delle misure e delle attività di cui al numero 3);</span></li>\n<li><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\">lo stato della salute e della sicurezza umana, compresa la contaminazione della catena alimentare, le condizioni della vita umana, il paesaggio, i siti e gli edifici d\'interesse culturale, per quanto influenzabili dallo stato degli elementi dell\'ambiente di cui al punto 1) o, attraverso tali elementi, da qualsiasi fattore di cui ai punti 2) e 3);</span></li>\n</ul>\n<p> </p>\n<p><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\">RIFERIMENTI:</span></strong></p>\n<p><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\">Art. 40 - Pubblicazione e accesso alle informazioni ambientali</span><br /><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\"> 1. In materia di informazioni ambientali restano ferme le disposizioni di maggior tutela già previste dall\'articolo 3-sexies del decreto legislativo 3 aprile 2006 n. 152, dalla legge 16 marzo 2001, n. 108, nonché dal decreto legislativo 19 agosto 2005 n. 195.</span><br /><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\"> 2. Le amministrazioni di cui all\'articolo 2, comma 1, lettera b), del decreto legislativo n. 195 del 2005, pubblicano, sui propri siti istituzionali e in conformità a quanto previsto dal presente decreto, le informazioni ambientali di cui all\'articolo 2, comma 1, lettera a), del decreto legislativo 19 agosto 2005, n.195, che detengono ai fini delle proprie attività istituzionali, nonché le relazioni di cui all\'articolo 10 del medesimo decreto legislativo. Di tali informazioni deve essere dato specifico rilievo all\'interno di un\'apposita sezione detta «Informazioni ambientali».</span><br /><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\"> 3. Sono fatti salvi i casi di esclusione del diritto di accesso alle informazioni ambientali di cui all\'articolo 5 del decreto legislativo 19 agosto 2005, n. 195.</span><br /><span style=\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\"> 4. L\'attuazione degli obblighi di cui al presente articolo non è in alcun caso subordinata alla stipulazione degli accordi di cui all\'articolo 11 del decreto legislativo 19 agosto 2005, n. 195. Sono fatti salvi gli effetti degli accordi eventualmente già stipulati, qualora assicurino livelli di informazione ambientale superiori a quelli garantiti dalle disposizioni del presente decreto. Resta fermo il potere di stipulare ulteriori accordi ai sensi del medesimo articolo 11, nel rispetto dei livelli di informazione ambientale garantiti dalle disposizioni del presente decreto</span></p>\n</div></div></div></div><!-- END: Sliders -->'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_categories | NULL | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 142 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.13 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.17 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
25 | JDatabaseDriver->loadResult() | JROOT/plugins/content/attachments/attachments.php:168 |
24 | plgContentAttachments->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
23 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
22 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
21 | JHtmlContent::prepare() | Chiamata uguale alla linea sottostante. |
20 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
19 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 |
18 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/layouts/joomla/content/category_default.php:73 |
17 | include JROOT/layouts/joomla/content/category_default.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
16 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
15 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_content/views/category/tmpl/default.php:20 |
14 | include JROOT/components/com_content/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.29 ms Dopo l'ultima query: 0.72 ms Memoria query: 0.028 MB memoria prima della query: 5.503 MB Righe restituite: 1
SELECT id
FROM gov3_categories
WHERE id = 92
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.06 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
26 | JDatabaseDriver->loadResult() | JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790 |
25 | AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() | JROOT/plugins/content/attachments/attachments.php:202 |
24 | plgContentAttachments->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
23 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
22 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
21 | JHtmlContent::prepare() | Chiamata uguale alla linea sottostante. |
20 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
19 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 |
18 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/layouts/joomla/content/category_default.php:73 |
17 | include JROOT/layouts/joomla/content/category_default.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
16 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
15 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_content/views/category/tmpl/default.php:20 |
14 | include JROOT/components/com_content/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 1.86 ms Dopo l'ultima query: 0.49 ms Memoria query: 0.029 MB memoria prima della query: 5.522 MB Righe restituite: 0
SELECT a.*, u.name as creator_name
FROM gov3_attachments AS a
LEFT JOIN gov3_users AS u
ON u.id = a.created_by
WHERE a.parent_id=92
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='category'
AND a.access IN (1,5)
ORDER BY filename
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1076 | 0.09 | Using where; Using filesort |
1 | SIMPLE | u | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.created_by | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.07 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.05 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
preparing | 0.03 ms |
executing | 1.50 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
29 | JDatabaseDriver->loadObjectList() | JROOT/components/com_attachments/models/attachments.php:436 |
28 | AttachmentsModelAttachments->getAttachmentsList() | JROOT/components/com_attachments/models/attachments.php:514 |
27 | AttachmentsModelAttachments->someVisible() | JROOT/components/com_attachments/controllers/attachments.php:98 |
26 | AttachmentsControllerAttachments->displayString() | JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 |
25 | AttachmentsPlugin->insertAttachmentsList() | JROOT/plugins/content/attachments/attachments.php:218 |
24 | plgContentAttachments->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
23 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
22 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
21 | JHtmlContent::prepare() | Chiamata uguale alla linea sottostante. |
20 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
19 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 |
18 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/layouts/joomla/content/category_default.php:73 |
17 | include JROOT/layouts/joomla/content/category_default.php | JROOT/libraries/src/Layout/FileLayout.php:125 |
16 | Joomla\CMS\Layout\FileLayout->render() | JROOT/libraries/src/Layout/LayoutHelper.php:73 |
15 | Joomla\CMS\Layout\LayoutHelper::render() | JROOT/components/com_content/views/category/tmpl/default.php:20 |
14 | include JROOT/components/com_content/views/category/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 |
11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.31 ms Dopo l'ultima query: 3.91 ms Memoria query: 0.021 MB memoria prima della query: 5.566 MB Righe restituite: 5
SELECT id
FROM gov3_template_styles
ORDER BY id
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_template_styles | NULL | index | NULL | PRIMARY | 4 | NULL | 5 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.06 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.02 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:657 |
9 | JMFTemplate->setup() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:251 |
8 | JMFTemplate->__construct() | JROOT/templates/id-gov/index.php:37 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 1.09 ms Dopo l'ultima query: 1.65 ms Memoria query: 0.045 MB memoria prima della query: 5.625 MB Righe restituite: 30
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gov3_modules AS m
LEFT JOIN gov3_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gov3_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-01 16:49:02')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-01 16:49:02')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 281 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | PRIMARY,published,newsfeeds | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 88 | 1.14 | Using where; Using filesort |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | perasso2.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | perasso2.m.id | 1 | 40.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.11 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.06 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.08 ms |
preparing | 0.04 ms |
executing | 0.60 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | Chiamata uguale alla linea sottostante. |
17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
15 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
13 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
12 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:951 |
11 | JMFTemplate->countModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:937 |
10 | JMFTemplate->checkModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:3421 |
9 | JMFTemplate->getAllColumnsClasses() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:381 |
8 | JMFTemplate->__construct() | JROOT/templates/id-gov/index.php:37 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.76 ms Dopo l'ultima query: 3.61 ms Memoria query: 0.089 MB memoria prima della query: 5.769 MB Righe restituite: 46
SELECT *
FROM gov3_modules
WHERE published=1
ORDER BY id
;
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_modules | NULL | ref | published | published | 1 | const | 46 | 100.00 | Using filesort |
Status | Duration |
---|
starting | 0.09 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
executing | 0.35 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_accordeonck/helper.php:525 |
18 | modAccordeonckHelper::CreateModulesList() | JROOT/modules/mod_accordeonck/helper.php:89 |
17 | modAccordeonckHelper::GetItems() | JROOT/modules/mod_accordeonck/mod_accordeonck.php:65 |
16 | include JROOT/modules/mod_accordeonck/mod_accordeonck.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559 |
13 | JMFTemplate->renderModules() | JROOT/templates/id-gov/tpl/blocks/main.php:103 |
12 | include JROOT/templates/id-gov/tpl/blocks/main.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
11 | JMFTemplate->renderBlock() | JROOT/templates/id-gov/tpl/default.php:74 |
10 | include JROOT/templates/id-gov/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427 |
8 | JMFTemplate->renderScheme() | JROOT/templates/id-gov/index.php:39 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 17.98 ms Dopo l'ultima query: 25.36 ms Memoria query: 0.031 MB memoria prima della query: 6.200 MB Righe restituite: 5
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,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 gov3_content AS a
LEFT JOIN gov3_categories AS c
ON c.id = a.catid
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_by
LEFT JOIN gov3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gov3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gov3_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-01 16:49:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-01 16:49:02')
ORDER BY a.publish_up DESC
LIMIT 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ALL | idx_access,idx_state,idx_catid | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 986 | 16.00 | Using where; Using temporary; Using filesort |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | perasso2.a.catid | 1 | 9.65 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.modified_by | 1 | 100.00 | Using where |
1 | SIMPLE | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.c.parent_id | 1 | 100.00 | Using where |
1 | SIMPLE | v | NULL | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (hash join) |
Status | Duration |
---|
starting | 0.26 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.14 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.14 ms |
preparing | 0.03 ms |
Creating tmp table | 0.11 ms |
executing | 16.89 ms |
end | 0.02 ms |
query end | 0.01 ms |
waiting for handler commit | 0.11 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
19 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_latest/helper.php:123 |
18 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
17 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31 |
12 | include JROOT/templates/id-gov/tpl/blocks/footer-mod.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
11 | JMFTemplate->renderBlock() | JROOT/templates/id-gov/tpl/default.php:74 |
10 | include JROOT/templates/id-gov/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427 |
8 | JMFTemplate->renderScheme() | JROOT/templates/id-gov/index.php:39 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.71 ms Dopo l'ultima query: 1.55 ms Memoria query: 0.031 MB memoria prima della query: 6.291 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 `gov3_categories` AS `s`
INNER JOIN `gov3_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 20
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 5 | 88.73 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.14 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.06 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.14 ms |
preparing | 0.03 ms |
executing | 0.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
32 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
31 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
30 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
29 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
28 | ContentRouter->getCategorySegment() | Chiamata uguale alla linea sottostante. |
27 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
26 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
25 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
24 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
23 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
22 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
21 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
20 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
19 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_latest/helper.php:135 |
18 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
17 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31 |
12 | include JROOT/templates/id-gov/tpl/blocks/footer-mod.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
11 | JMFTemplate->renderBlock() | JROOT/templates/id-gov/tpl/default.php:74 |
10 | include JROOT/templates/id-gov/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427 |
8 | JMFTemplate->renderScheme() | JROOT/templates/id-gov/index.php:39 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.81 ms Dopo l'ultima query: 1.66 ms Memoria query: 0.031 MB memoria prima della query: 6.314 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 `gov3_categories` AS `s`
INNER JOIN `gov3_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 19
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 4 | 88.73 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.15 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.05 ms |
statistics | 0.17 ms |
preparing | 0.05 ms |
executing | 0.10 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
32 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
31 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
30 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
29 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
28 | ContentRouter->getCategorySegment() | Chiamata uguale alla linea sottostante. |
27 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
26 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
25 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
24 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
23 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
22 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
21 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
20 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
19 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_latest/helper.php:135 |
18 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
17 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31 |
12 | include JROOT/templates/id-gov/tpl/blocks/footer-mod.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
11 | JMFTemplate->renderBlock() | JROOT/templates/id-gov/tpl/default.php:74 |
10 | include JROOT/templates/id-gov/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427 |
8 | JMFTemplate->renderScheme() | JROOT/templates/id-gov/index.php:39 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 3.20 ms Dopo l'ultima query: 2.50 ms Memoria query: 0.027 MB memoria prima della query: 6.267 MB Righe restituite: 0
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,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 gov3_content AS a
LEFT JOIN gov3_categories AS c
ON c.id = a.catid
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_by
LEFT JOIN gov3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gov3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gov3_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-01 16:49:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-01 16:49:02')
AND a.publish_up >= DATE_ADD('2023-03-01 16:49:02', INTERVAL -30 DAY)
ORDER BY a.hits DESC
LIMIT 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ALL | idx_access,idx_state,idx_catid | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 986 | 5.33 | Using where; Using temporary; Using filesort |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | perasso2.a.catid | 1 | 9.65 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.a.modified_by | 1 | 100.00 | Using where |
1 | SIMPLE | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | perasso2.c.parent_id | 1 | 100.00 | Using where |
1 | SIMPLE | v | NULL | ALL | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (hash join) |
Status | Duration |
---|
starting | 0.26 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.04 ms |
statistics | 0.18 ms |
preparing | 0.04 ms |
Creating tmp table | 0.12 ms |
executing | 2.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
19 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_popular/helper.php:77 |
18 | ModArticlesPopularHelper::getList() | JROOT/modules/mod_articles_popular/mod_articles_popular.php:15 |
17 | include JROOT/modules/mod_articles_popular/mod_articles_popular.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31 |
12 | include JROOT/templates/id-gov/tpl/blocks/footer-mod.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
11 | JMFTemplate->renderBlock() | JROOT/templates/id-gov/tpl/default.php:74 |
10 | include JROOT/templates/id-gov/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427 |
8 | JMFTemplate->renderScheme() | JROOT/templates/id-gov/index.php:39 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.43 ms Dopo l'ultima query: 2.97 ms Memoria query: 0.026 MB memoria prima della query: 6.315 MB Righe restituite: 3
SELECT TCOUNT
FROM `gov3_cwtraffic_total`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_cwtraffic_total | NULL | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 3 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.09 ms |
Executing hook on transaction | 0.02 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.02 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:87 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:93 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31 |
12 | include JROOT/templates/id-gov/tpl/blocks/footer-mod.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
11 | JMFTemplate->renderBlock() | JROOT/templates/id-gov/tpl/default.php:74 |
10 | include JROOT/templates/id-gov/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427 |
8 | JMFTemplate->renderScheme() | JROOT/templates/id-gov/index.php:39 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.25 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.026 MB memoria prima della query: 6.325 MB Righe restituite: 1
SELECT count(*)
FROM `gov3_cwtraffic`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | NULL | Select tables optimized away |
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.02 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:104 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:93 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31 |
12 | include JROOT/templates/id-gov/tpl/blocks/footer-mod.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
11 | JMFTemplate->renderBlock() | JROOT/templates/id-gov/tpl/default.php:74 |
10 | include JROOT/templates/id-gov/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427 |
8 | JMFTemplate->renderScheme() | JROOT/templates/id-gov/index.php:39 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.43 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.026 MB memoria prima della query: 6.336 MB Righe restituite: 1
SELECT count(*)
FROM `gov3_cwtraffic`
WHERE tm > '1677625200'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_cwtraffic | NULL | range | unique_tm_ip,unique_tm_iphash,idx_tm,idx_iptm,idx_iphashtm | idx_tm | 4 | NULL | 3 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:125 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:93 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31 |
12 | include JROOT/templates/id-gov/tpl/blocks/footer-mod.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
11 | JMFTemplate->renderBlock() | JROOT/templates/id-gov/tpl/default.php:74 |
10 | include JROOT/templates/id-gov/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427 |
8 | JMFTemplate->renderScheme() | JROOT/templates/id-gov/index.php:39 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.47 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.026 MB memoria prima della query: 6.346 MB Righe restituite: 1
SELECT count(*)
FROM `gov3_cwtraffic`
WHERE tm > '1677538800'
AND tm < '1677625200'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_cwtraffic | NULL | range | unique_tm_ip,unique_tm_iphash,idx_tm,idx_iptm,idx_iphashtm | unique_tm_ip | 4 | NULL | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.09 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:144 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:93 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31 |
12 | include JROOT/templates/id-gov/tpl/blocks/footer-mod.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
11 | JMFTemplate->renderBlock() | JROOT/templates/id-gov/tpl/default.php:74 |
10 | include JROOT/templates/id-gov/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427 |
8 | JMFTemplate->renderScheme() | JROOT/templates/id-gov/index.php:39 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.37 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.026 MB memoria prima della query: 6.356 MB Righe restituite: 1
SELECT count(*)
FROM `gov3_cwtraffic`
WHERE tm >= '1677452400'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_cwtraffic | NULL | range | unique_tm_ip,unique_tm_iphash,idx_tm,idx_iptm,idx_iphashtm | idx_tm | 4 | NULL | 5 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.09 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:162 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:93 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31 |
12 | include JROOT/templates/id-gov/tpl/blocks/footer-mod.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
11 | JMFTemplate->renderBlock() | JROOT/templates/id-gov/tpl/default.php:74 |
10 | include JROOT/templates/id-gov/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427 |
8 | JMFTemplate->renderScheme() | JROOT/templates/id-gov/index.php:39 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.38 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.026 MB memoria prima della query: 6.367 MB Righe restituite: 1
SELECT count(*)
FROM `gov3_cwtraffic`
WHERE tm >= '1677625200'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_cwtraffic | NULL | range | unique_tm_ip,unique_tm_iphash,idx_tm,idx_iptm,idx_iphashtm | idx_tm | 4 | NULL | 3 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.07 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.03 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
19 | JDatabaseDriver->loadResult() | JROOT/modules/mod_coalawebtraffic/helper.php:180 |
18 | mod_coalawebtrafficHelper->read() | JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:93 |
17 | include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559 |
14 | JMFTemplate->renderModules() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869 |
13 | JMFTemplate->renderFlexiblock() | JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31 |
12 | include JROOT/templates/id-gov/tpl/blocks/footer-mod.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
11 | JMFTemplate->renderBlock() | JROOT/templates/id-gov/tpl/default.php:74 |
10 | include JROOT/templates/id-gov/tpl/default.php | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397 |
9 | JMFTemplate->renderBlock() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427 |
8 | JMFTemplate->renderScheme() | JROOT/templates/id-gov/index.php:39 |
7 | require JROOT/templates/id-gov/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.44 ms Dopo l'ultima query: 12.34 ms Memoria query: 0.022 MB memoria prima della query: 6.575 MB Righe restituite: 1
SELECT manifest_cache
FROM gov3_extensions
WHERE element='mod_djmegamenu'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | gov3_extensions | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.09 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/modules/mod_djmegamenu/helper.php:519 |
11 | modDJMMHelper::getVersion() | JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:133 |
10 | include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.48 ms Dopo l'ultima query: 10.13 ms Memoria query: 0.022 MB memoria prima della query: 6.620 MB Righe restituite: 0
SELECT uikit
FROM `gov3_cwgears`
WHERE url = 'http://vecchiosito.icperasso.edu.it/albo-e-trasparenza/archivio-fino-al-30-11-2021/amministrazione-trasparente/92-informazioni-ambientali.html'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.11 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.03 ms |
# | Caller | File e numero di linea |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/helpers/loadcount.php:67 |
13 | CwGearsHelperLoadcount::getCounts() | JROOT/plugins/system/cwgears/cwgears.php:418 |
12 | plgSystemCwgears->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.22 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.022 MB memoria prima della query: 6.626 MB Righe restituite: 0
SELECT uikit_plus
FROM `gov3_cwgears`
WHERE url = 'http://vecchiosito.icperasso.edu.it/albo-e-trasparenza/archivio-fino-al-30-11-2021/amministrazione-trasparente/92-informazioni-ambientali.html'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.05 ms |
Executing hook on transaction | 0.00 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/plugins/system/cwgears/helpers/loadcount.php:67 |
13 | CwGearsHelperLoadcount::getCounts() | JROOT/plugins/system/cwgears/cwgears.php:427 |
12 | plgSystemCwgears->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
Tempo della query: 0.67 ms Dopo l'ultima query: 14.57 ms Memoria query: 0.025 MB memoria prima della query: 6.897 MB Righe restituite: 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 `gov3_categories` AS `s`
INNER JOIN `gov3_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 23
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 15 | 88.73 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.14 ms |
Executing hook on transaction | 0.01 ms |
starting | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.14 ms |
preparing | 0.03 ms |
executing | 0.07 ms |
end | 0.01 ms |
query end | 0.00 ms |
waiting for handler commit | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
17 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
16 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:173 |
15 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
14 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
13 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
12 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
11 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
10 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
9 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/sef/sef.php:110 |
7 | PlgSystemSef->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:48 |
6 × SELECT count(*)
FROM `gov3_cwtraffic`
4 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `gov3_categories` AS `s`
INNER JOIN `gov3_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
3 × 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 gov3_fields AS a
LEFT JOIN `gov3_languages` AS l
ON l.lang_code = a.language
LEFT JOIN gov3_users AS uc
ON uc.id=a.checked_out
LEFT JOIN gov3_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN gov3_fields_groups AS g
ON g.id = a.group_id
3 × 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,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 gov3_content AS a
LEFT JOIN gov3_categories AS c
ON c.id = a.catid
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_by
LEFT JOIN gov3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gov3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gov3_content_rating AS v
ON a.id = v.content_id
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `gov3_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `gov3_extensions`
2 × SELECT TCOUNT
FROM `gov3_cwtraffic_total
2 × SELECT a.*, u.name as creator_name
FROM gov3_attachments AS a
LEFT JOIN gov3_users AS u
ON u.id = a.created_by
2 × SELECT id
FROM gov3_categories
2 × SELECT COUNT(*)
from `gov3_mi_iptable`
1 × SELECT id
FROM gov3_template_styles
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gov3_modules AS m
LEFT JOIN gov3_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gov3_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM gov3_modules
1 × SELECT count(*)
FROM `gov3_cwtraffic
1 × SELECT created_by, catid
FROM gov3_content
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM gov3_fields AS a
LEFT JOIN `gov3_languages` AS l
ON l.lang_code = a.language
LEFT JOIN gov3_users AS uc
ON uc.id=a.checked_out
LEFT JOIN gov3_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN gov3_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `gov3_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT manifest_cache
FROM gov3_extensions
1 × SELECT *
FROM gov3_hwdms_config
1 × SELECT uikit
FROM `gov3_cwgears`
1 × SELECT `m`.`tag_id`,`t`.*
FROM `gov3_contentitem_tag_map` AS m
INNER JOIN `gov3_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT `data`
FROM `gov3_session`
1 × SELECT COUNT(*)
FROM gov3_content AS a
LEFT JOIN gov3_categories AS c
ON c.id = a.catid
LEFT JOIN gov3_users AS ua
ON ua.id = a.created_by
LEFT JOIN gov3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN gov3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN gov3_content_rating AS v
ON a.id = v.content_id
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `gov3_content` AS `i`
1 × SELECT *
FROM gov3_languages
1 × SELECT id, home, template, s.params
FROM gov3_template_styles as s
LEFT JOIN gov3_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT botname
FROM `gov3_cwtraffic_knownips`
1 × SELECT ip
FROM `gov3_cwtraffic_knownips`
1 × SELECT id,
LEFT( tm, 9 ) , ip, count(*)
FROM `gov3_cwtraffic`
GROUP BY
LEFT( tm, 9 ) , ip
HAVING count(*) > 1
LIMIT 5
1 × SELECT count(*)
FROM `gov3_extensions`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM gov3_menu AS m
LEFT JOIN gov3_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT count(*)
FROM `gov3_cwgears_schedule`
1 × SELECT count(*)
FROM `gov3_cwgears_schedule
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM gov3_extensions
1 × SELECT b.id
FROM gov3_usergroups AS a
LEFT JOIN gov3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `gov3_viewlevels
1 × SELECT uikit_plus
FROM `gov3_cwgears`