Galleria Foto

Edificio di Via Bottego (2)

Foto rappresentetive dell'edificio di Via Bottego

Edificio Via San Mamete (2)

Foto rappresentetive dell'edificio di Via San Mamete

Natale 2018 (1)

Foto di Natale 2018

Installate le zanzariere in Via San Mamete (4)

Rappresentazione fotografica relativa all'installazione delle zanzariere in Via San Mamete

INAUGURAZIONE SCUOLA SECONDARIA I GRADO VIA ADRIANO 60 (1)

Utilizzo dei cookie

Questo sito utilizza cookie di tipo tecnico, per cui le informazioni raccolte non saranno utilizzate per finalità commerciali nè comunicate a terze parti.
Potrebbero essere presenti collegamenti esterni (esempio social, youtube, maps) per le cui policy si rimanda ai portali collegati, in quanto tali cookie non vengono trattati da questo sito.

Accetta Rifiuta

Maggiori informazioni

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 42,
            "timer": {
                "start": 1677688752,
                "last": 1677688778,
                "now": 1677688778
            },
            "token": "Y427qrlAq36DgOfe3120M2zaMcqQOOWo"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cDovL3ZlY2NoaW9zaXRvLmljcGVyYXNzby5lZHUuaXQvc2Vydml6aS1vbmxpbmUvYWNjZXNzby1jaXZpY28uaHRtbD8%3D"
            },
            "users": {
                "login": {
                    "form": {
                        "data": {
                            "return": "http://vecchiosito.icperasso.edu.it/area-riservata-docenti.html"
                        }
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "application": {
            "queue": []
        }
    },
    "__ricerca": {
        "cerca": null,
        "memo": null,
        "Itemid": 279,
        "indietro1": "http://vecchiosito.icperasso.edu.it/albo-e-trasparenza/archivio-fino-al-30-11-2021/atti-albo-archiviati.html"
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 2.16 ms / 2.16 ms Memoria: 0.406 MB / 0.75 MB Application: afterLoad

Tempo: 39.27 ms / 41.43 ms Memoria: 1.295 MB / 2.04 MB Application: afterInitialise

Tempo: 15.74 ms / 57.16 ms Memoria: 0.718 MB / 2.76 MB Application: afterRoute

Tempo: 1.01 ms / 58.18 ms Memoria: 0.058 MB / 2.82 MB Application: beforeRenderComponent com_phocagallery

Tempo: 41.62 ms / 99.80 ms Memoria: 0.608 MB / 3.43 MB Application: afterRenderComponent com_phocagallery

Tempo: 4.67 ms / 104.47 ms Memoria: 0.135 MB / 3.56 MB Application: Before Access::preloadComponents (all components)

Tempo: 1.31 ms / 105.78 ms Memoria: 0.067 MB / 3.63 MB Application: After Access::preloadComponents (all components)

Tempo: 0.04 ms / 105.81 ms Memoria: -0.004 MB / 3.62 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Tempo: 0.32 ms / 106.13 ms Memoria: 0.011 MB / 3.64 MB Application: After Access::getAssetRules (id:1 name:root.1)

Tempo: 1.10 ms / 107.23 ms Memoria: 0.011 MB / 3.65 MB Application: afterDispatch

Tempo: 6.66 ms / 113.89 ms Memoria: 0.179 MB / 3.82 MB Application: beforeRenderModule mod_accordeonck (Menu Generale)

Tempo: 20.25 ms / 134.14 ms Memoria: 0.567 MB / 4.39 MB Application: afterRenderModule mod_accordeonck (Menu Generale)

Tempo: 1.03 ms / 135.17 ms Memoria: -0.073 MB / 4.32 MB Application: beforeRenderModule mod_custom (Albo no logo)

Tempo: 0.48 ms / 135.65 ms Memoria: 0.006 MB / 4.32 MB Application: afterRenderModule mod_custom (Albo no logo)

Tempo: 0.17 ms / 135.82 ms Memoria: -0.002 MB / 4.32 MB Application: beforeRenderModule mod_custom (Personale no logo)

Tempo: 0.10 ms / 135.92 ms Memoria: 0.004 MB / 4.33 MB Application: afterRenderModule mod_custom (Personale no logo)

Tempo: 0.17 ms / 136.09 ms Memoria: -0.001 MB / 4.33 MB Application: beforeRenderModule mod_custom (Alunni no logo)

Tempo: 0.11 ms / 136.20 ms Memoria: 0.005 MB / 4.33 MB Application: afterRenderModule mod_custom (Alunni no logo)

Tempo: 0.13 ms / 136.33 ms Memoria: -0.001 MB / 4.33 MB Application: beforeRenderModule mod_custom (Didattica no logo)

Tempo: 0.09 ms / 136.43 ms Memoria: 0.003 MB / 4.33 MB Application: afterRenderModule mod_custom (Didattica no logo)

Tempo: 0.13 ms / 136.56 ms Memoria: -0.000 MB / 4.33 MB Application: beforeRenderModule mod_custom (Documenti no logo)

Tempo: 0.09 ms / 136.65 ms Memoria: 0.003 MB / 4.34 MB Application: afterRenderModule mod_custom (Documenti no logo)

Tempo: 0.13 ms / 136.78 ms Memoria: -0.000 MB / 4.34 MB Application: beforeRenderModule mod_custom (Contatti no logo)

Tempo: 0.09 ms / 136.87 ms Memoria: 0.004 MB / 4.34 MB Application: afterRenderModule mod_custom (Contatti no logo)

Tempo: 0.74 ms / 137.62 ms Memoria: 0.012 MB / 4.35 MB Application: beforeRenderModule mod_articles_latest (Articoli recenti)

Tempo: 0.85 ms / 138.47 ms Memoria: 0.105 MB / 4.46 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tempo: 0.11 ms / 138.58 ms Memoria: 0.010 MB / 4.47 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tempo: 17.79 ms / 156.37 ms Memoria: 0.194 MB / 4.66 MB Application: afterRenderModule mod_articles_latest (Articoli recenti)

Tempo: 0.24 ms / 156.60 ms Memoria: -0.137 MB / 4.52 MB Application: beforeRenderModule mod_articles_popular (Articoli più letti)

Tempo: 4.10 ms / 160.71 ms Memoria: 0.026 MB / 4.55 MB Application: afterRenderModule mod_articles_popular (Articoli più letti)

Tempo: 0.25 ms / 160.96 ms Memoria: 0.005 MB / 4.55 MB Application: beforeRenderModule mod_coalawebtraffic (Statistiche)

Tempo: 4.83 ms / 165.79 ms Memoria: 0.096 MB / 4.65 MB Application: afterRenderModule mod_coalawebtraffic (Statistiche)

Tempo: 0.23 ms / 166.02 ms Memoria: -0.007 MB / 4.64 MB Application: beforeRenderModule mod_jm_social_icons (Social)

Tempo: 0.54 ms / 166.56 ms Memoria: 0.042 MB / 4.68 MB Application: afterRenderModule mod_jm_social_icons (Social)

Tempo: 2.22 ms / 168.78 ms Memoria: 0.030 MB / 4.71 MB Application: beforeRenderModule mod_custom (Copyrights)

Tempo: 0.11 ms / 168.89 ms Memoria: 0.003 MB / 4.72 MB Application: afterRenderModule mod_custom (Copyrights)

Tempo: 0.06 ms / 168.95 ms Memoria: 0.000 MB / 4.72 MB Application: beforeRenderModule mod_breadcrumbs (Percorso)

Tempo: 0.79 ms / 169.74 ms Memoria: 0.011 MB / 4.73 MB Application: afterRenderModule mod_breadcrumbs (Percorso)

Tempo: 0.09 ms / 169.83 ms Memoria: 0.007 MB / 4.74 MB Application: beforeRenderModule mod_djmegamenu (Top MegaMenu)

Tempo: 3.50 ms / 173.33 ms Memoria: 0.130 MB / 4.87 MB Application: beforeRenderModule mod_custom (Logo Menu Personale)

Tempo: 0.12 ms / 173.46 ms Memoria: 0.003 MB / 4.87 MB Application: afterRenderModule mod_custom (Logo Menu Personale)

Tempo: 0.19 ms / 173.64 ms Memoria: 0.000 MB / 4.87 MB Application: beforeRenderModule mod_custom (Logo Menu Alunni)

Tempo: 0.10 ms / 173.74 ms Memoria: 0.003 MB / 4.87 MB Application: afterRenderModule mod_custom (Logo Menu Alunni)

Tempo: 0.12 ms / 173.86 ms Memoria: -0.000 MB / 4.87 MB Application: beforeRenderModule mod_custom (Logo Menu Didattica)

Tempo: 0.09 ms / 173.95 ms Memoria: 0.003 MB / 4.88 MB Application: afterRenderModule mod_custom (Logo Menu Didattica)

Tempo: 5.94 ms / 179.89 ms Memoria: 0.003 MB / 4.88 MB Application: afterRenderModule mod_djmegamenu (Top MegaMenu)

Tempo: 0.09 ms / 179.99 ms Memoria: -0.031 MB / 4.85 MB Application: beforeRenderModule mod_custom (Testata sito)

Tempo: 0.11 ms / 180.09 ms Memoria: 0.003 MB / 4.85 MB Application: afterRenderModule mod_custom (Testata sito)

Tempo: 0.06 ms / 180.15 ms Memoria: -0.001 MB / 4.85 MB Application: beforeRenderModule mod_syndicate (Feed Rss)

Tempo: 0.44 ms / 180.59 ms Memoria: 0.006 MB / 4.86 MB Application: afterRenderModule mod_syndicate (Feed Rss)

Tempo: 0.03 ms / 180.63 ms Memoria: -0.001 MB / 4.86 MB Application: beforeRenderModule mod_search (Cerca)

Tempo: 0.78 ms / 181.40 ms Memoria: 0.015 MB / 4.87 MB Application: afterRenderModule mod_search (Cerca)

Tempo: 0.09 ms / 181.50 ms Memoria: -0.005 MB / 4.87 MB Application: beforeRenderModule mod_custom (Menu a comparsa)

Tempo: 0.10 ms / 181.60 ms Memoria: 0.003 MB / 4.87 MB Application: afterRenderModule mod_custom (Menu a comparsa)

Tempo: 0.02 ms / 181.62 ms Memoria: -0.000 MB / 4.87 MB Application: beforeRenderModule mod_login (Login)

Tempo: 1.61 ms / 183.23 ms Memoria: 0.020 MB / 4.89 MB Application: afterRenderModule mod_login (Login)

Tempo: 0.08 ms / 183.31 ms Memoria: -0.002 MB / 4.89 MB Application: beforeRenderModule mod_custom (Bottoni Home)

Tempo: 0.11 ms / 183.42 ms Memoria: 0.003 MB / 4.89 MB Application: afterRenderModule mod_custom (Bottoni Home)

Tempo: 16.09 ms / 199.51 ms Memoria: 0.300 MB / 5.19 MB Application: afterRender

Query totali del database: 46.72 ms

Utilizzo memoria

Query Database

46 query eseguite 46.72 ms

Trovati 4 duplicati!

2 duplicati: #7 #8

2 duplicati: #18 #37

Tempo della query: 0.43 ms Memoria query: 0.023 MB memoria prima della query: 1.027 MB Righe restituite: 1

SELECT `data`

  FROM `gov3_session`

  WHERE `session_id` = X'666972686466736d36316371657035306a7572696a6567683064'

Explain

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

Profilo

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.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	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.02 ms
cleaning up	0.22 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.86 ms Dopo l'ultima query: 0.86 ms Memoria query: 0.042 MB memoria prima della query: 1.082 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

Explain

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

Profilo

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	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.09 ms
preparing	0.03 ms
executing	0.29 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.37 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.021 MB memoria prima della query: 1.124 MB Righe restituite: 9

SELECT id, rules

  FROM `gov3_viewlevels`

Explain

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

Profilo

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.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.04 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.03 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.41 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 1.138 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

Explain

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

Profilo

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.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 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.03 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.82 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.046 MB memoria prima della query: 1.159 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

Explain

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

Profilo

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.02 ms
executing	0.41 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.37 ms Dopo l'ultima query: 17.26 ms Memoria query: 0.004 MB memoria prima della query: 2.002 MB

DELETE 
  FROM `gov3_mi_iptable` 
  WHERE DATE_ADD(`lasthacktime`, INTERVAL 900 SECOND) < NOW() 
  AND `autodelete`=1;

Explain

EXPLAIN non possibile sulla query: DELETE FROM `gov3_mi_iptable` WHERE DATE_ADD(`lasthacktime`, INTERVAL 900 SECOND) < NOW() AND `autodelete`=1;

Profilo

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.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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.31 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.020 MB memoria prima della query: 2.006 MB Righe restituite: 1

Query duplicate: #8

SELECT COUNT(*) 
  from `gov3_mi_iptable` 
  WHERE ip = '127.0.0.1' 
  AND `hackcount` >= 3

Explain

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

Profilo

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.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.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.29 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.020 MB memoria prima della query: 2.011 MB Righe restituite: 1

Query duplicate: #7

SELECT COUNT(*) 
  from `gov3_mi_iptable` 
  WHERE ip = '127.0.0.1' 
  AND `hackcount` >= 3

Explain

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

Profilo

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.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 3.19 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.005 MB memoria prima della query: 2.023 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:39:38' 
  AND publish_down !='0000-00-00 00:00:00'

Explain

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:39:38' AND publish_down !='0000-00-00 00:00:00'

Profilo

Status	Duration
starting	0.07 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	2.75 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.50 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.005 MB memoria prima della query: 2.028 MB

UPDATE gov3_content

  SET state='0'

  WHERE state='2' 
  AND publish_down <='2023-03-01 16:39:38' 
  AND publish_down !='0000-00-00 00:00:00'

Explain

EXPLAIN non possibile sulla query: UPDATE gov3_content SET state='0' WHERE state='2' AND publish_down <='2023-03-01 16:39:38' AND publish_down !='0000-00-00 00:00:00'

Profilo

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.04 ms
init	0.01 ms
System lock	0.08 ms
Searching rows for update	0.09 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.27 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.020 MB memoria prima della query: 2.034 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwgears_schedule`

Explain

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

Profilo

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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.29 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.020 MB memoria prima della query: 2.039 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwgears_schedule`

  WHERE time + '86400'<'1677688778'

Explain

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

Profilo

Status	Duration
starting	0.07 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.01 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.24 ms Dopo l'ultima query: 0.76 ms Memoria query: 0.147 MB memoria prima della query: 2.072 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

Explain

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

Profilo

Status	Duration
starting	0.08 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.69 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.04 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.48 ms Dopo l'ultima query: 5.30 ms Memoria query: 0.024 MB memoria prima della query: 2.518 MB Righe restituite: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `gov3_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profilo

Status	Duration
starting	0.08 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.07 ms
preparing	0.02 ms
executing	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.02 ms
cleaning up	0.01 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.40 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.006 MB memoria prima della query: 2.511 MB

UPDATE `gov3_extensions`

  SET `params` = '{\"mediaversion\":\"4b38e67c0596ceaf24ac2ad9361e7ae4\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

EXPLAIN non possibile sulla query: UPDATE `gov3_extensions` SET `params` = '{\"mediaversion\":\"4b38e67c0596ceaf24ac2ad9361e7ae4\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profilo

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.06 ms
updating	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.01 ms
cleaning up	0.01 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.34 ms Dopo l'ultima query: 0.47 ms Memoria query: 0.021 MB memoria prima della query: 2.592 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_extensions`

  WHERE `element` = 'cwgears' 
  AND `extension_id` = ''

Explain

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

Profilo

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.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.47 ms Dopo l'ultima query: 0.55 ms Memoria query: 0.021 MB memoria prima della query: 2.599 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

Explain

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

Profilo

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.01 ms
Creating tmp table	0.03 ms
executing	0.09 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.29 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.021 MB memoria prima della query: 2.603 MB Righe restituite: 3

Query duplicate: #37

SELECT TCOUNT

  FROM `gov3_cwtraffic_total`

Explain

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

Profilo

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.01 ms
preparing	0.01 ms
executing	0.02 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.34 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.020 MB memoria prima della query: 2.609 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwtraffic`

  WHERE tm < '1677020400'

Explain

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

Profilo

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.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 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.03 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.32 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.020 MB memoria prima della query: 2.617 MB Righe restituite: 0

SELECT ip

  FROM `gov3_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

Explain

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

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 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.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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.27 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.020 MB memoria prima della query: 2.621 MB Righe restituite: 0

SELECT botname

  FROM `gov3_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

Explain

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

Profilo

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.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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.33 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.020 MB memoria prima della query: 2.626 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwtraffic`

  WHERE iphash = UNHEX(SHA1('127.0.0.1')) 
  AND tm + '86400'>'1677688778'

Explain

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

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 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.05 ms
preparing	0.02 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.51 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.021 MB memoria prima della query: 2.635 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

Explain

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

Profilo

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.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.46 ms Dopo l'ultima query: 2.61 ms Memoria query: 0.020 MB memoria prima della query: 2.806 MB Righe restituite: 2

SELECT *

  FROM gov3_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profilo

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.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.06 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 2.35 ms Dopo l'ultima query: 13.28 ms Memoria query: 0.022 MB memoria prima della query: 3.348 MB Righe restituite: 3

SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM gov3_phocagallery_styles AS a 
  WHERE a.published = 1 
  ORDER BY a.type, a.ordering ASC

Explain

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	3	33.33	Using where; Using filesort

Profilo

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.95 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.06 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.79 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:1461
11	PhocaGalleryRenderFront::renderAllCSS()	JROOT/components/com_phocagallery/views/categories/view.html.php:83
10	PhocaGalleryViewCategories->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:59
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:115
6	require_once JROOT/components/com_phocagallery/phocagallery.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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 3.35 ms Dopo l'ultima query: 6.90 ms Memoria query: 0.047 MB memoria prima della query: 3.385 MB Righe restituite: 6

SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, min(a.filename) as filename, min(a.extm) as extm, min(a.exts) as exts, min(a.exth) as exth, min(a.extw) as extw, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug 
  FROM gov3_phocagallery_categories AS cc 
  LEFT JOIN gov3_phocagallery AS a 
  ON a.catid = cc.id 
  and a.published = 1 
  LEFT JOIN gov3_phocagallery_user AS uc 
  ON uc.userid = cc.owner_id 
  LEFT JOIN gov3_users AS u 
  ON u.id = cc.owner_id 
  LEFT JOIN gov3_phocagallery_votes_statistics AS r 
  ON r.catid = cc.id 
  WHERE cc.published = 1 
  AND cc.approved = 1 
  GROUP BY cc.id, cc.parent_id, cc.owner_id, cc.image_id, cc.title, cc.name, cc.alias, cc.image, cc.section, cc.image_position, cc.description, cc.date, cc.published, cc.approved, cc.checked_out, cc.checked_out_time, cc.editor, cc.ordering, cc.access, cc.count, cc.hits, cc.accessuserid, cc.deleteuserid, cc.uploaduserid, cc.userfolder, cc.latitude, cc.longitude, cc.zoom, cc.geotitle, cc.extid, cc.exta, cc.extu, cc.extauth, cc.extfbuid, cc.extfbcatid, cc.params, cc.metakey, cc.metadesc, cc.metadata, cc.language, a.catid, u.username, r.count, r.average, uc.avatar, uc.approved, uc.published 
  ORDER BY cc.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	16.67	Using where; Using temporary; Using filesort
1	SIMPLE	a	NULL	ref	catid	catid	5	perasso2.cc.id,const	2	100.00	NULL
1	SIMPLE	uc	NULL	ALL	userid	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	perasso2.cc.owner_id	1	100.00	NULL
1	SIMPLE	r	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)

Profilo

Status	Duration
starting	0.17 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
Opening tables	2.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.05 ms
statistics	0.08 ms
preparing	0.05 ms
Creating tmp table	0.19 ms
executing	0.40 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.04 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocagallery/models/categories.php:97
12	PhocagalleryModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocagallery/views/categories/view.html.php:415
10	PhocaGalleryViewCategories->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:59
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:115
6	require_once JROOT/components/com_phocagallery/phocagallery.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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.95 ms Dopo l'ultima query: 20.90 ms Memoria query: 0.028 MB memoria prima della query: 3.567 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')

Explain

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

Profilo

Status	Duration
starting	0.11 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.12 ms
preparing	0.02 ms
executing	0.40 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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:47
10	RegularLabs\Plugin\System\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/src/Plugin.php:176
9	RegularLabs\Plugin\System\Sourcerer\Plugin->passChecks()	JROOT/plugins/system/sourcerer/src/Plugin.php:57
8	RegularLabs\Plugin\System\Sourcerer\Plugin->run()	JROOT/plugins/system/sourcerer/sourcerer.php:55
7	PlgSystemSourcerer->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.39 ms Dopo l'ultima query: 2.46 ms Memoria query: 0.021 MB memoria prima della query: 3.695 MB Righe restituite: 5

SELECT id 
  FROM gov3_template_styles 
  ORDER BY id

Explain

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

Profilo

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.01 ms
preparing	0.02 ms
executing	0.03 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.02 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.24 ms Dopo l'ultima query: 1.56 ms Memoria query: 0.045 MB memoria prima della query: 3.754 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:39:38') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-01 16:39:38') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 158 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profilo

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.00 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.67 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.77 ms Dopo l'ultima query: 3.51 ms Memoria query: 0.089 MB memoria prima della query: 3.898 MB Righe restituite: 46

SELECT *

			
  FROM gov3_modules

			
  WHERE published=1

			
  ORDER BY id

			;

Explain

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

Profilo

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.05 ms
preparing	0.02 ms
executing	0.33 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.52 ms Dopo l'ultima query: 14.50 ms Memoria query: 0.031 MB memoria prima della query: 4.439 MB Righe restituite: 5

SHOW FULL COLUMNS 
  FROM `gov3_hwdms_config`

Explain

EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `gov3_hwdms_config`

Profilo

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.41 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.20 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
executing	0.12 ms
checking permissions	0.06 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.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
31	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
30	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
29	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
28	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_hwdmediashare/tables/configuration.php:47
27	hwdMediaShareTableConfiguration->__construct()	JROOT/libraries/src/Table/Table.php:328
26	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_hwdmediashare/libraries/factory.php:243
25	hwdMediaShareFactory->getConfig()	JROOT/components/com_hwdmediashare/router.php:57
24	hwdMediaShareRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_accordeonck/helper.php:229
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.37 ms Dopo l'ultima query: 0.43 ms Memoria query: 0.029 MB memoria prima della query: 4.464 MB Righe restituite: 1

SELECT *

  FROM gov3_hwdms_config

  WHERE `id` = '1'

Explain

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

Profilo

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
preparing	0.01 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.02 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
27	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
26	Joomla\CMS\Table\Table->load()	JROOT/components/com_hwdmediashare/libraries/factory.php:249
25	hwdMediaShareFactory->getConfig()	JROOT/components/com_hwdmediashare/router.php:57
24	hwdMediaShareRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_accordeonck/helper.php:229
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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 13.89 ms Dopo l'ultima query: 6.30 ms Memoria query: 0.032 MB memoria prima della query: 4.474 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:39:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-01 16:39:38')

  ORDER BY a.publish_up DESC 
  LIMIT 5

Explain

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)

Profilo

Status	Duration
starting	0.22 ms
Executing hook on transaction	0.01 ms
starting	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.00 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.11 ms
executing	12.81 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.03 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.69 ms Dopo l'ultima query: 1.13 ms Memoria query: 0.031 MB memoria prima della query: 4.633 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

Explain

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

Profilo

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.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.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.03 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.62 ms Dopo l'ultima query: 0.92 ms Memoria query: 0.031 MB memoria prima della query: 4.665 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

Explain

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

Profilo

Status	Duration
starting	0.12 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.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 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.02 ms
cleaning up	0.01 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 3.09 ms Dopo l'ultima query: 1.50 ms Memoria query: 0.027 MB memoria prima della query: 4.555 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:39:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-01 16:39:38') 
  AND a.publish_up >= DATE_ADD('2023-03-01 16:39:38', INTERVAL -30 DAY)

  ORDER BY a.hits DESC 
  LIMIT 5

Explain

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)

Profilo

Status	Duration
starting	0.21 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.11 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.12 ms
executing	2.13 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.04 ms
cleaning up	0.01 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.33 ms Dopo l'ultima query: 2.34 ms Memoria query: 0.026 MB memoria prima della query: 4.600 MB Righe restituite: 3

Query duplicate: #18

SELECT TCOUNT

  FROM `gov3_cwtraffic_total`

Explain

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

Profilo

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.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 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.01 ms
cleaning up	0.01 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.25 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.026 MB memoria prima della query: 4.611 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwtraffic`

Explain

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

Profilo

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
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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.37 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.026 MB memoria prima della query: 4.622 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwtraffic`

  WHERE tm > '1677625200'

Explain

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

Profilo

Status	Duration
starting	0.03 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.01 ms
optimizing	0.01 ms
statistics	0.04 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.01 ms
cleaning up	0.01 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.33 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.026 MB memoria prima della query: 4.632 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwtraffic`

  WHERE tm > '1677538800' 
  AND tm < '1677625200'

Explain

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

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 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.04 ms
preparing	0.02 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.34 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.026 MB memoria prima della query: 4.642 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwtraffic`

  WHERE tm >= '1677452400'

Explain

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

Profilo

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.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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.35 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.026 MB memoria prima della query: 4.653 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwtraffic`

  WHERE tm >= '1677625200'

Explain

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

Profilo

Status	Duration
starting	0.03 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.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.55 ms Dopo l'ultima query: 9.19 ms Memoria query: 0.022 MB memoria prima della query: 4.861 MB Righe restituite: 1

SELECT manifest_cache 
  FROM gov3_extensions 
  WHERE element='mod_djmegamenu' 
  LIMIT 1

Explain

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

Profilo

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.11 ms
preparing	0.02 ms
executing	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.02 ms
cleaning up	0.03 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.36 ms Dopo l'ultima query: 9.12 ms Memoria query: 0.022 MB memoria prima della query: 4.905 MB Righe restituite: 0

SELECT uikit

  FROM `gov3_cwgears`

  WHERE url = 'http://vecchiosito.icperasso.edu.it/gallerie/galleria-foto.html'

Explain

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

Profilo

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.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

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.29 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 4.911 MB Righe restituite: 0

SELECT uikit_plus

  FROM `gov3_cwgears`

  WHERE url = 'http://vecchiosito.icperasso.edu.it/gallerie/galleria-foto.html'

Explain

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

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 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.03 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.77 ms Dopo l'ultima query: 12.18 ms Memoria query: 0.025 MB memoria prima della query: 5.251 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

Explain

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

Profilo

Status	Duration
starting	0.14 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.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.15 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.02 ms
cleaning up	0.03 ms

Call Stack

#	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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

35 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

6 × SELECT count(*) 
  FROM `gov3_cwtraffic`

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)

2 × SELECT COUNT(*) 
  from `gov3_mi_iptable`

2 × 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 TCOUNT 
  FROM `gov3_cwtraffic_total

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `gov3_extensions`

1 × SELECT `data` 
  FROM `gov3_session`

1 × SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, min(a.filename) as filename, min(a.extm) as extm, min(a.exts) as exts, min(a.exth) as exth, min(a.extw) as extw, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug 
  FROM gov3_phocagallery_categories AS cc 
  LEFT JOIN gov3_phocagallery AS a 
  ON a.catid = cc.id 
  and a.published = 1 
  LEFT JOIN gov3_phocagallery_user AS uc 
  ON uc.userid = cc.owner_id 
  LEFT JOIN gov3_users AS u 
  ON u.id = cc.owner_id 
  LEFT JOIN gov3_phocagallery_votes_statistics AS r 
  ON r.catid = cc.id

1 × SELECT uikit 
  FROM `gov3_cwgears`

1 × SELECT manifest_cache 
  FROM gov3_extensions

1 × SELECT count(*) 
  FROM `gov3_cwtraffic

1 × SELECT * 
  FROM gov3_hwdms_config

1 × SELECT *

    
  FROM gov3_modules

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 id 
  FROM gov3_template_styles

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `gov3_assets`

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 a.filename as filename, a.type as type, a.menulink as menulink 
  FROM gov3_phocagallery_styles AS a

```
1 × SELECT * 
  FROM gov3_languages
```

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`

ALTRE tabelle:

```
1 × DELETE 
  FROM `gov3_mi_iptable`
```

1 × UPDATE gov3_content 
  SET state=2  , publish_down =DATE_ADD(publish_down, INTERVAL 30 DAY)  , publish_down ='0000-00-00 00:00:00'

1 × UPDATE gov3_content 
  SET state='0'

1 × UPDATE `gov3_extensions` 
  SET `params` = '{\"mediaversion\":\"4b38e67c0596ceaf24ac2ad9361e7ae4\"}'

1 × SHOW FULL COLUMNS 
  FROM `gov3_hwdms_config