Istituto Comprensivo Perasso

Archivio storico atti per Sezione/Categoria

Mostrati da 1 a 2 di 2 Elementi

N. in albo	Anno	N. atto	Data	Oggetto	Data inizio	Data fine	Sezione	Categoria
102	2019	3404/B13	23-10-2019	Proclamazione eletti rappresentanti dei genitori della Scuola Secondaria di primo grado a.s. 2019/20	31-10-2019	15-11-2019	Organi collegiali	Organi collegiali
6	2018	1361/A19	28-11-2018	Variazioni organi collegiali per esigenze istituzionali	28-11-2018	13-12-2018	Organi collegiali	Organi collegiali

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 336,
            "timer": {
                "start": 1677688752,
                "last": 1677688887,
                "now": 1677688887
            },
            "token": "Y427qrlAq36DgOfe3120M2zaMcqQOOWo"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cDovL3ZlY2NoaW9zaXRvLmljcGVyYXNzby5lZHUuaXQvYXJlYS1wZXJzb25hbGUtYWx1bm5pLWRpZGF0dGljYS9wcm9nZXR0aS5odG1sPw%3D%3D"
            },
            "users": {
                "login": {
                    "form": {
                        "data": {
                            "return": "http://vecchiosito.icperasso.edu.it/area-riservata-docenti.html"
                        }
                    }
                }
            },
            "com_hwdmediashare": {
                "media": {
                    "list": {
                        "fullordering": "a.created DESC",
                        "limit": "9"
                    },
                    "limitstart": 0
                }
            },
            "media": {
                "quality": "480"
            }
        },
        "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": 0,
        "indietro1": "http://vecchiosito.icperasso.edu.it/index.php?option=com_chronoconnectivity5&cont=lists&act=index&ccname=albo_atti_sezioni_categorie&cat=21&Itemid=",
        "allegato1": "20200608125454_Determina_n._25_1.pdf",
        "allegato2": "20201030154621_02_Invito_alla_presentazione_delle_offerte.pdf",
        "allegato3": "20201030154649_03_Allegato_1_-_Condizioni_minime_a_pena_esclusione.pdf",
        "allegato4": "20201030154711_04_Allegato_2_-_Criteri_di_valutazione.pdf",
        "allegato5": "20201030154814_05_Modello_A_-_Documentazione_amministrativa.pdf",
        "allegato6": "20201030154832_06_Modello_B_-_Offerta_tecnica.pdf",
        "allegato7": "20201030154851_07_Modello_C_-_Offerta_economica.pdf",
        "allegato8": "20201030155700_Nomina_Commissione_per_apertura_buste.pdf",
        "categoria": 21,
        "sezione": 0,
        "ent": 0,
        "anno": null,
        "flag": null
    }
}

Informazioni profilo

Tempo

Memoria

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

Tempo: 36.40 ms / 39.12 ms Memoria: 1.302 MB / 2.05 MB Application: afterInitialise

Tempo: 15.91 ms / 55.03 ms Memoria: 0.719 MB / 2.77 MB Application: afterRoute

Tempo: 0.80 ms / 55.83 ms Memoria: 0.012 MB / 2.78 MB Application: beforeRenderComponent com_chronoconnectivity5

Tempo: 19.00 ms / 74.83 ms Memoria: 0.533 MB / 3.31 MB Application: afterRenderComponent com_chronoconnectivity5

Tempo: 4.88 ms / 79.71 ms Memoria: 0.074 MB / 3.39 MB Application: Before Access::preloadComponents (all components)

Tempo: 1.32 ms / 81.03 ms Memoria: 0.068 MB / 3.46 MB Application: After Access::preloadComponents (all components)

Tempo: 0.03 ms / 81.06 ms Memoria: -0.004 MB / 3.45 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Tempo: 0.33 ms / 81.39 ms Memoria: 0.011 MB / 3.46 MB Application: After Access::getAssetRules (id:1 name:root.1)

Tempo: 0.92 ms / 82.31 ms Memoria: 0.018 MB / 3.48 MB Application: afterDispatch

Tempo: 6.33 ms / 88.64 ms Memoria: 0.185 MB / 3.67 MB Application: beforeRenderModule mod_accordeonck (Menu Generale)

Tempo: 19.60 ms / 108.24 ms Memoria: 0.628 MB / 4.30 MB Application: afterRenderModule mod_accordeonck (Menu Generale)

Tempo: 0.98 ms / 109.22 ms Memoria: -0.073 MB / 4.22 MB Application: beforeRenderModule mod_custom (Albo no logo)

Tempo: 0.34 ms / 109.56 ms Memoria: 0.006 MB / 4.23 MB Application: afterRenderModule mod_custom (Albo no logo)

Tempo: 0.24 ms / 109.80 ms Memoria: -0.002 MB / 4.23 MB Application: beforeRenderModule mod_custom (Personale no logo)

Tempo: 0.11 ms / 109.91 ms Memoria: 0.004 MB / 4.23 MB Application: afterRenderModule mod_custom (Personale no logo)

Tempo: 0.14 ms / 110.04 ms Memoria: -0.001 MB / 4.23 MB Application: beforeRenderModule mod_custom (Alunni no logo)

Tempo: 0.10 ms / 110.14 ms Memoria: 0.005 MB / 4.24 MB Application: afterRenderModule mod_custom (Alunni no logo)

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

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

Tempo: 0.24 ms / 110.61 ms Memoria: -0.000 MB / 4.24 MB Application: beforeRenderModule mod_custom (Documenti no logo)

Tempo: 0.15 ms / 110.76 ms Memoria: 0.003 MB / 4.24 MB Application: afterRenderModule mod_custom (Documenti no logo)

Tempo: 0.15 ms / 110.91 ms Memoria: -0.000 MB / 4.24 MB Application: beforeRenderModule mod_custom (Contatti no logo)

Tempo: 0.10 ms / 111.01 ms Memoria: 0.004 MB / 4.24 MB Application: afterRenderModule mod_custom (Contatti no logo)

Tempo: 0.84 ms / 111.85 ms Memoria: 0.012 MB / 4.26 MB Application: beforeRenderModule mod_articles_latest (Articoli recenti)

Tempo: 1.03 ms / 112.88 ms Memoria: 0.042 MB / 4.30 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tempo: 0.14 ms / 113.02 ms Memoria: 0.010 MB / 4.31 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tempo: 17.89 ms / 130.91 ms Memoria: 0.074 MB / 4.38 MB Application: afterRenderModule mod_articles_latest (Articoli recenti)

Tempo: 0.21 ms / 131.12 ms Memoria: -0.025 MB / 4.36 MB Application: beforeRenderModule mod_articles_popular (Articoli più letti)

Tempo: 3.91 ms / 135.03 ms Memoria: 0.026 MB / 4.38 MB Application: afterRenderModule mod_articles_popular (Articoli più letti)

Tempo: 0.33 ms / 135.35 ms Memoria: 0.005 MB / 4.39 MB Application: beforeRenderModule mod_coalawebtraffic (Statistiche)

Tempo: 4.25 ms / 139.61 ms Memoria: 0.095 MB / 4.48 MB Application: afterRenderModule mod_coalawebtraffic (Statistiche)

Tempo: 0.37 ms / 139.98 ms Memoria: -0.007 MB / 4.48 MB Application: beforeRenderModule mod_jm_social_icons (Social)

Tempo: 0.79 ms / 140.77 ms Memoria: 0.042 MB / 4.52 MB Application: afterRenderModule mod_jm_social_icons (Social)

Tempo: 2.98 ms / 143.75 ms Memoria: 0.030 MB / 4.55 MB Application: beforeRenderModule mod_custom (Copyrights)

Tempo: 0.10 ms / 143.86 ms Memoria: 0.003 MB / 4.55 MB Application: afterRenderModule mod_custom (Copyrights)

Tempo: 0.06 ms / 143.92 ms Memoria: 0.000 MB / 4.55 MB Application: beforeRenderModule mod_breadcrumbs (Percorso)

Tempo: 0.79 ms / 144.70 ms Memoria: 0.011 MB / 4.56 MB Application: afterRenderModule mod_breadcrumbs (Percorso)

Tempo: 0.08 ms / 144.79 ms Memoria: 0.008 MB / 4.57 MB Application: beforeRenderModule mod_djmegamenu (Top MegaMenu)

Tempo: 3.49 ms / 148.28 ms Memoria: 0.193 MB / 4.76 MB Application: beforeRenderModule mod_custom (Logo Menu Personale)

Tempo: 0.19 ms / 148.47 ms Memoria: 0.003 MB / 4.77 MB Application: afterRenderModule mod_custom (Logo Menu Personale)

Tempo: 0.18 ms / 148.65 ms Memoria: 0.000 MB / 4.77 MB Application: beforeRenderModule mod_custom (Logo Menu Alunni)

Tempo: 0.09 ms / 148.74 ms Memoria: 0.003 MB / 4.77 MB Application: afterRenderModule mod_custom (Logo Menu Alunni)

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

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

Tempo: 5.77 ms / 154.72 ms Memoria: 0.003 MB / 4.78 MB Application: afterRenderModule mod_djmegamenu (Top MegaMenu)

Tempo: 0.13 ms / 154.85 ms Memoria: -0.031 MB / 4.75 MB Application: beforeRenderModule mod_custom (Testata sito)

Tempo: 0.12 ms / 154.97 ms Memoria: 0.003 MB / 4.75 MB Application: afterRenderModule mod_custom (Testata sito)

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

Tempo: 0.35 ms / 155.38 ms Memoria: 0.006 MB / 4.75 MB Application: afterRenderModule mod_syndicate (Feed Rss)

Tempo: 0.03 ms / 155.41 ms Memoria: -0.001 MB / 4.75 MB Application: beforeRenderModule mod_search (Cerca)

Tempo: 0.71 ms / 156.12 ms Memoria: 0.016 MB / 4.77 MB Application: afterRenderModule mod_search (Cerca)

Tempo: 0.07 ms / 156.19 ms Memoria: -0.005 MB / 4.76 MB Application: beforeRenderModule mod_custom (Menu a comparsa)

Tempo: 0.09 ms / 156.28 ms Memoria: 0.003 MB / 4.77 MB Application: afterRenderModule mod_custom (Menu a comparsa)

Tempo: 0.02 ms / 156.31 ms Memoria: -0.000 MB / 4.77 MB Application: beforeRenderModule mod_login (Login)

Tempo: 1.55 ms / 157.85 ms Memoria: 0.021 MB / 4.79 MB Application: afterRenderModule mod_login (Login)

Tempo: 0.07 ms / 157.92 ms Memoria: -0.002 MB / 4.78 MB Application: beforeRenderModule mod_custom (Bottoni Home)

Tempo: 0.11 ms / 158.03 ms Memoria: 0.003 MB / 4.79 MB Application: afterRenderModule mod_custom (Bottoni Home)

Tempo: 14.34 ms / 172.37 ms Memoria: 0.243 MB / 5.03 MB Application: afterRender

Query totali del database: 44.52 ms

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

#	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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gov3_viewlevels	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	100.00	NULL

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.02 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.02 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

#	Caller	File e numero di linea
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

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

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

#	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

#	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

#	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

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:41:27' 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.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.07 ms
updating	2.27 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.02 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.46 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.005 MB memoria prima della query: 2.037 MB

UPDATE gov3_content

  SET state='0'

  WHERE state='2' 
  AND publish_down <='2023-03-01 16:41:27' 
  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:41:27' AND publish_down !='0000-00-00 00:00:00'

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
Searching rows for update	0.08 ms
updating	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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.28 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.020 MB memoria prima della query: 2.043 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.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.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/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.28 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.020 MB memoria prima della query: 2.048 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwgears_schedule`

  WHERE time + '86400'<'1677688887'

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.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
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.07 ms Dopo l'ultima query: 0.78 ms Memoria query: 0.147 MB memoria prima della query: 2.082 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.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.72 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()	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.40 ms Dopo l'ultima query: 5.83 ms Memoria query: 0.024 MB memoria prima della query: 2.527 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.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	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.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.26 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.006 MB memoria prima della query: 2.520 MB

UPDATE `gov3_extensions`

  SET `params` = '{\"mediaversion\":\"72dfa6781cd589fe03eca32a8409a07c\"}'

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

Explain

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

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.01 ms
System lock	0.06 ms
updating	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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.29 ms Dopo l'ultima query: 0.67 ms Memoria query: 0.021 MB memoria prima della query: 2.601 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.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.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.38 ms Dopo l'ultima query: 0.47 ms Memoria query: 0.021 MB memoria prima della query: 2.608 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.11 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.17 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.021 MB memoria prima della query: 2.613 MB Righe restituite: 3

Query duplicate: #42

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.00 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.21 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.020 MB memoria prima della query: 2.618 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.03 ms
preparing	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: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.19 ms Dopo l'ultima query: 0.67 ms Memoria query: 0.020 MB memoria prima della query: 2.626 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.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: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.16 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.020 MB memoria prima della query: 2.630 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.00 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
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.26 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.020 MB memoria prima della query: 2.635 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwtraffic`

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

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.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.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.39 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.021 MB memoria prima della query: 2.644 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.05 ms
Executing hook on transaction	0.00 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.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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.38 ms Dopo l'ultima query: 3.08 ms Memoria query: 0.020 MB memoria prima della query: 2.773 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.01 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.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: 0.37 ms Dopo l'ultima query: 2.76 ms Memoria query: 0.023 MB memoria prima della query: 2.965 MB Righe restituite: 0

SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` 
  FROM `gov3_chronoengine_extensions` AS `Extension` 
  WHERE `Extension`.`enabled` = '1' 
  ORDER BY `Extension`.`ordering` ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Extension	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where; Using filesort

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.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
14	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
13	GCore\Libs\Model->find()	JROOT/libraries/cegcore/libs/gmodel.php:27
12	GCore\Libs\GModel->find()	JROOT/libraries/cegcore/libs/event.php:18
11	GCore\Libs\Event::get_extensions()	JROOT/libraries/cegcore/libs/event.php:35
10	GCore\Libs\Event::trigger()	JROOT/libraries/cegcore/libs/app_j.php:112
9	GCore\Libs\AppJ->dispatch()	JROOT/libraries/cegcore/libs/app_j.php:444
8	GCore\Libs\AppJ::call()	JROOT/libraries/cegcore/joomla_gcloader.php:104
7	JoomlaGCLoader->__construct()	JROOT/components/com_chronoconnectivity5/chronoconnectivity5.php:53
6	require_once JROOT/components/com_chronoconnectivity5/chronoconnectivity5.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.43 ms Dopo l'ultima query: 1.52 ms Memoria query: 0.062 MB memoria prima della query: 3.080 MB Righe restituite: 1

SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` 
  FROM `gov3_chronoengine_connections` AS `Connection` 
  WHERE `Connection`.`title` = 'albo_atti_sezioni_categorie' 
  AND `Connection`.`published` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Connection	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	27	3.70	Using where

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.02 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.18 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
13	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
12	GCore\Libs\Model->find()	JROOT/libraries/cegcore/libs/gmodel.php:27
11	GCore\Libs\GModel->find()	JROOT/administrator/components/com_chronoconnectivity5/chronoconnectivity/controllers/lists.php:65
10	GCore\Admin\Extensions\Chronoconnectivity\Controllers\Lists->_initialize()	JROOT/libraries/cegcore/libs/app_j.php:219
9	GCore\Libs\AppJ->dispatch()	JROOT/libraries/cegcore/libs/app_j.php:444
8	GCore\Libs\AppJ::call()	JROOT/libraries/cegcore/joomla_gcloader.php:104
7	JoomlaGCLoader->__construct()	JROOT/components/com_chronoconnectivity5/chronoconnectivity5.php:53
6	require_once JROOT/components/com_chronoconnectivity5/chronoconnectivity5.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.37 ms Dopo l'ultima query: 1.57 ms Memoria query: 0.023 MB memoria prima della query: 3.207 MB Righe restituite: 1

SELECT *

  FROM `gov3_chronoforms_configurazi_30`

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gov3_chronoforms_configurazi_30	NULL	system	PRIMARY	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

Profilo

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.04 ms
executing	0.02 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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_chronoconnectivity5/chronoconnectivity/controllers/lists.php(531) : eval()'d code:19
11	eval()	JROOT/administrator/components/com_chronoconnectivity5/chronoconnectivity/controllers/lists.php:531
10	GCore\Admin\Extensions\Chronoconnectivity\Controllers\Lists->index()	JROOT/libraries/cegcore/libs/app_j.php:249
9	GCore\Libs\AppJ->dispatch()	JROOT/libraries/cegcore/libs/app_j.php:444
8	GCore\Libs\AppJ::call()	JROOT/libraries/cegcore/joomla_gcloader.php:104
7	JoomlaGCLoader->__construct()	JROOT/components/com_chronoconnectivity5/chronoconnectivity5.php:53
6	require_once JROOT/components/com_chronoconnectivity5/chronoconnectivity5.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: 1.50 ms Dopo l'ultima query: 0.90 ms Memoria query: 0.023 MB memoria prima della query: 3.205 MB Righe restituite: 1

SELECT COUNT(`atti19`.`id`) AS `atti19.count` 
  FROM `gov3_chronoforms_atto_30` AS `atti19` 
  LEFT JOIN `gov3_chronoforms_sezione_30` AS `sezioni` 
  ON `atti19`.`cod_sezione` = `sezioni`.`cf_id` 
  LEFT JOIN `gov3_chronoforms_categoria_30` AS `categorie` 
  ON `atti19`.`cod_categoria` = `categorie`.`cf_id` 
  LEFT JOIN `gov3_chronoforms_e_30` AS `ente` 
  ON `atti19`.`cod_ente` = `ente`.`cf_id` 
  WHERE atti19.radio0 = 'Si' 
  AND atti19.radio1 = 'Si' 
  AND atti19.datafine_atto < CURDATE() 
  AND atti19.cod_categoria = '21' 
  ORDER BY CONCAT(`atti19`.`anno`,LPAD(`atti19`.`numero_albo`,5,'0')) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	atti19	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	203	0.49	Using where
1	SIMPLE	sezioni	NULL	eq_ref	PRIMARY	PRIMARY	4	perasso2.atti19.cod_sezione	1	100.00	Using where; Using index
1	SIMPLE	categorie	NULL	eq_ref	PRIMARY	PRIMARY	4	perasso2.atti19.cod_categoria	1	100.00	Using where; Using index
1	SIMPLE	ente	NULL	eq_ref	PRIMARY	PRIMARY	4	perasso2.atti19.cod_ente	1	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.09 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
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	1.14 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
14	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
13	GCore\Libs\Model->find()	JROOT/libraries/cegcore/libs/gmodel.php:27
12	GCore\Libs\GModel->find()	JROOT/libraries/cegcore/libs/gcontroller.php:330
11	GCore\Libs\GController->_paginate()	JROOT/administrator/components/com_chronoconnectivity5/chronoconnectivity/controllers/lists.php:617
10	GCore\Admin\Extensions\Chronoconnectivity\Controllers\Lists->index()	JROOT/libraries/cegcore/libs/app_j.php:249
9	GCore\Libs\AppJ->dispatch()	JROOT/libraries/cegcore/libs/app_j.php:444
8	GCore\Libs\AppJ::call()	JROOT/libraries/cegcore/joomla_gcloader.php:104
7	JoomlaGCLoader->__construct()	JROOT/components/com_chronoconnectivity5/chronoconnectivity5.php:53
6	require_once JROOT/components/com_chronoconnectivity5/chronoconnectivity5.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: 1.59 ms Dopo l'ultima query: 1.14 ms Memoria query: 0.026 MB memoria prima della query: 3.222 MB Righe restituite: 2

SELECT `atti19`.`id` AS `atti19.id`, `atti19`.`uniq_id` AS `atti19.uniq_id`, `atti19`.`created` AS `atti19.created`, `atti19`.`modified` AS `atti19.modified`, `atti19`.`ipaddress` AS `atti19.ipaddress`, `atti19`.`user_id` AS `atti19.user_id`, `atti19`.`numero_albo` AS `atti19.numero_albo`, `atti19`.`anno` AS `atti19.anno`, `atti19`.`numero_atto` AS `atti19.numero_atto`, `atti19`.`data_atto` AS `atti19.data_atto`, `atti19`.`protocollo` AS `atti19.protocollo`, `atti19`.`nome_atto` AS `atti19.nome_atto`, `atti19`.`datainizio_atto` AS `atti19.datainizio_atto`, `atti19`.`datafine_atto` AS `atti19.datafine_atto`, `atti19`.`radio0` AS `atti19.radio0`, `atti19`.`radio1` AS `atti19.radio1`, `atti19`.`info_atto` AS `atti19.info_atto`, `atti19`.`cod_sezione` AS `atti19.cod_sezione`, `atti19`.`cod_categoria` AS `atti19.cod_categoria`, `atti19`.`atto_status` AS `atti19.atto_status`, `atti19`.`cod_ente` AS `atti19.cod_ente`, `atti19`.`cod_macro` AS `atti19.cod_macro`, `atti19`.`cod_tipo` AS `atti19.cod_tipo`, `sezioni`.`cf_id` AS `sezioni.cf_id`, `sezioni`.`created` AS `sezioni.created`, `sezioni`.`modified` AS `sezioni.modified`, `sezioni`.`user_id` AS `sezioni.user_id`, `sezioni`.`sez_nome` AS `sezioni.sez_nome`, `sezioni`.`des_sezione` AS `sezioni.des_sezione`, `categorie`.`cf_id` AS `categorie.cf_id`, `categorie`.`created` AS `categorie.created`, `categorie`.`modified` AS `categorie.modified`, `categorie`.`user_id` AS `categorie.user_id`, `categorie`.`cat_nome` AS `categorie.cat_nome`, `categorie`.`des_categoria` AS `categorie.des_categoria`, `categorie`.`cod_sezione` AS `categorie.cod_sezione`, `categorie`.`check_cat` AS `categorie.check_cat`, `categorie`.`cat_giorni` AS `categorie.cat_giorni`, `ente`.`cf_id` AS `ente.cf_id`, `ente`.`created` AS `ente.created`, `ente`.`modified` AS `ente.modified`, `ente`.`user_id` AS `ente.user_id`, `ente`.`nome_ente` AS `ente.nome_ente` 
  FROM `gov3_chronoforms_atto_30` AS `atti19` 
  LEFT JOIN `gov3_chronoforms_sezione_30` AS `sezioni` 
  ON `atti19`.`cod_sezione` = `sezioni`.`cf_id` 
  LEFT JOIN `gov3_chronoforms_categoria_30` AS `categorie` 
  ON `atti19`.`cod_categoria` = `categorie`.`cf_id` 
  LEFT JOIN `gov3_chronoforms_e_30` AS `ente` 
  ON `atti19`.`cod_ente` = `ente`.`cf_id` 
  WHERE atti19.radio0 = 'Si' 
  AND atti19.radio1 = 'Si' 
  AND atti19.datafine_atto < CURDATE() 
  AND atti19.cod_categoria = '21' 
  ORDER BY CONCAT(`atti19`.`anno`,LPAD(`atti19`.`numero_albo`,5,'0')) DESC 
  LIMIT 30

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	atti19	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	203	0.49	Using where; Using filesort
1	SIMPLE	sezioni	NULL	eq_ref	PRIMARY	PRIMARY	4	perasso2.atti19.cod_sezione	1	100.00	Using where
1	SIMPLE	categorie	NULL	eq_ref	PRIMARY	PRIMARY	4	perasso2.atti19.cod_categoria	1	100.00	Using where
1	SIMPLE	ente	NULL	eq_ref	PRIMARY	PRIMARY	4	perasso2.atti19.cod_ente	1	100.00	Using where

Profilo

Status	Duration
starting	0.20 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	1.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
13	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
12	GCore\Libs\Model->find()	JROOT/libraries/cegcore/libs/gmodel.php:27
11	GCore\Libs\GModel->find()	JROOT/administrator/components/com_chronoconnectivity5/chronoconnectivity/controllers/lists.php:621
10	GCore\Admin\Extensions\Chronoconnectivity\Controllers\Lists->index()	JROOT/libraries/cegcore/libs/app_j.php:249
9	GCore\Libs\AppJ->dispatch()	JROOT/libraries/cegcore/libs/app_j.php:444
8	GCore\Libs\AppJ::call()	JROOT/libraries/cegcore/joomla_gcloader.php:104
7	JoomlaGCLoader->__construct()	JROOT/components/com_chronoconnectivity5/chronoconnectivity5.php:53
6	require_once JROOT/components/com_chronoconnectivity5/chronoconnectivity5.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: 1.39 ms Dopo l'ultima query: 3.27 ms Memoria query: 0.023 MB memoria prima della query: 3.379 MB Righe restituite: 5

SELECT distinct `anno`

  FROM `gov3_chronoforms_atto_30`

  WHERE `anno` <> '0'

  ORDER BY `anno`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gov3_chronoforms_atto_30	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	203	90.00	Using where; Using temporary; 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.01 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
executing	1.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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_chronoconnectivity5/chronoconnectivity/blocks/table.php(65) : eval()'d code:25
13	eval()	JROOT/administrator/components/com_chronoconnectivity5/chronoconnectivity/blocks/table.php:65
12	GCore\Admin\Extensions\Chronoconnectivity\Blocks\Table->display()	JROOT/administrator/components/com_chronoconnectivity5/chronoconnectivity/views/lists/index.php:23
11	include JROOT/administrator/components/com_chronoconnectivity5/chronoconnectivity/views/lists/index.php	JROOT/libraries/cegcore/libs/view.php:76
10	GCore\Libs\View->renderView()	JROOT/libraries/cegcore/libs/app_j.php:257
9	GCore\Libs\AppJ->dispatch()	JROOT/libraries/cegcore/libs/app_j.php:444
8	GCore\Libs\AppJ::call()	JROOT/libraries/cegcore/joomla_gcloader.php:104
7	JoomlaGCLoader->__construct()	JROOT/components/com_chronoconnectivity5/chronoconnectivity5.php:53
6	require_once JROOT/components/com_chronoconnectivity5/chronoconnectivity5.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.33 ms Dopo l'ultima query: 1.10 ms Memoria query: 0.023 MB memoria prima della query: 3.341 MB Righe restituite: 0

SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`addon_id` AS `Extension.addon_id`, `Extension`.`name` AS `Extension.name`, `Extension`.`title` AS `Extension.title`, `Extension`.`enabled` AS `Extension.enabled`, `Extension`.`ordering` AS `Extension.ordering`, `Extension`.`settings` AS `Extension.settings` 
  FROM `gov3_chronoengine_extensions` AS `Extension` 
  WHERE `Extension`.`name` = 'chronoconnectivity'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Extension	NULL	ref	name	name	767	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.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
14	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
13	GCore\Libs\Model->find()	JROOT/libraries/cegcore/libs/gmodel.php:27
12	GCore\Libs\GModel->find()	JROOT/libraries/cegcore/libs/gcontroller.php:16
11	GCore\Libs\GController->_settings()	JROOT/administrator/components/com_chronoconnectivity5/chronoconnectivity/controllers/lists.php:453
10	GCore\Admin\Extensions\Chronoconnectivity\Controllers\Lists->_finalize()	JROOT/libraries/cegcore/libs/app_j.php:269
9	GCore\Libs\AppJ->dispatch()	JROOT/libraries/cegcore/libs/app_j.php:444
8	GCore\Libs\AppJ::call()	JROOT/libraries/cegcore/joomla_gcloader.php:104
7	JoomlaGCLoader->__construct()	JROOT/components/com_chronoconnectivity5/chronoconnectivity5.php:53
6	require_once JROOT/components/com_chronoconnectivity5/chronoconnectivity5.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.96 ms Dopo l'ultima query: 6.10 ms Memoria query: 0.028 MB memoria prima della query: 3.396 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.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.01 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.46 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
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.30 ms Dopo l'ultima query: 2.34 ms Memoria query: 0.022 MB memoria prima della query: 3.539 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.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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.01 ms Dopo l'ultima query: 1.50 ms Memoria query: 0.045 MB memoria prima della query: 3.599 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:41:27') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-01 16:41:27') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 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.01 ms
starting	0.01 ms
checking permissions	0.00 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.56 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: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.63 ms Dopo l'ultima query: 3.50 ms Memoria query: 0.089 MB memoria prima della query: 3.742 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.30 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.23 ms Dopo l'ultima query: 14.40 ms Memoria query: 0.031 MB memoria prima della query: 4.344 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.08 ms
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.40 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.08 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.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.04 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/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.32 ms Dopo l'ultima query: 0.41 ms Memoria query: 0.029 MB memoria prima della query: 4.369 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.02 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 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: 14.27 ms Dopo l'ultima query: 6.59 ms Memoria query: 0.031 MB memoria prima della query: 4.309 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:41:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-01 16:41:27')

  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.18 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.16 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	13.28 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.02 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.64 ms Dopo l'ultima query: 0.93 ms Memoria query: 0.031 MB memoria prima della query: 4.355 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.17 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 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: 0.60 ms Dopo l'ultima query: 0.86 ms Memoria query: 0.031 MB memoria prima della query: 4.387 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.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.10 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.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.00 ms Dopo l'ultima query: 1.40 ms Memoria query: 0.027 MB memoria prima della query: 4.389 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:41:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-01 16:41:27') 
  AND a.publish_up >= DATE_ADD('2023-03-01 16:41:27', 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.20 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.12 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	2.15 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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.27 ms Dopo l'ultima query: 2.33 ms Memoria query: 0.026 MB memoria prima della query: 4.434 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.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
preparing	0.01 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.16 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.026 MB memoria prima della query: 4.445 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.00 ms
Opening tables	0.01 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.22 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.026 MB memoria prima della query: 4.455 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.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 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
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.23 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.026 MB memoria prima della query: 4.466 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.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.02 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.21 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.026 MB memoria prima della query: 4.476 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.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 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.19 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.026 MB memoria prima della query: 4.486 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.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 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
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.37 ms Dopo l'ultima query: 10.52 ms Memoria query: 0.022 MB memoria prima della query: 4.757 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.07 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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.33 ms Dopo l'ultima query: 8.46 ms Memoria query: 0.022 MB memoria prima della query: 4.793 MB Righe restituite: 0

SELECT uikit

  FROM `gov3_cwgears`

  WHERE url = 'http://vecchiosito.icperasso.edu.it/index.php?option=com_chronoconnectivity5&cont=lists&act=index&ccname=albo_atti_sezioni_categorie&cat=21&Itemid='

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.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.02 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.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
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.16 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 4.800 MB Righe restituite: 0

SELECT uikit_plus

  FROM `gov3_cwgears`

  WHERE url = 'http://vecchiosito.icperasso.edu.it/index.php?option=com_chronoconnectivity5&cont=lists&act=index&ccname=albo_atti_sezioni_categorie&cat=21&Itemid='

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.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 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: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.80 ms Dopo l'ultima query: 11.12 ms Memoria query: 0.025 MB memoria prima della query: 5.089 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.17 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.12 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 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]

Tempo della query: 0.31 ms Dopo l'ultima query: 1.67 ms Memoria query: 0.004 MB memoria prima della query: 5.018 MB

DELETE 

  FROM `gov3_session`

  WHERE `time` < 1677687987

Explain

EXPLAIN non possibile sulla query: DELETE FROM `gov3_session` WHERE `time` < 1677687987

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.03 ms
init	0.01 ms
System lock	0.04 ms
updating	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/session/storage/database.php:156
7	JSessionStorageDatabase->gc()	JROOT/libraries/src/Session/Session.php:837
6	Joomla\CMS\Session\Session->gc()	JROOT/plugins/system/sessiongc/sessiongc.php:60
5	PlgSystemSessionGc->onAfterRespond()	JROOT/libraries/joomla/event/event.php:70
4	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
3	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
2	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:247
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]

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

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

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

1 × SELECT `data` 
  FROM `gov3_session`

1 × SELECT distinct `anno` 
  FROM `gov3_chronoforms_atto_30`

1 × SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`addon_id` AS `Extension.addon_id`, `Extension`.`name` AS `Extension.name`, `Extension`.`title` AS `Extension.title`, `Extension`.`enabled` AS `Extension.enabled`, `Extension`.`ordering` AS `Extension.ordering`, `Extension`.`settings` AS `Extension.settings` 
  FROM `gov3_chronoengine_extensions` AS `Extension`

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

1 × SELECT id 
  FROM gov3_template_styles

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 COUNT(`atti19`.`id`) AS `atti19.count` 
  FROM `gov3_chronoforms_atto_30` AS `atti19` 
  LEFT JOIN `gov3_chronoforms_sezione_30` AS `sezioni` 
  ON `atti19`.`cod_sezione` = `sezioni`.`cf_id` 
  LEFT JOIN `gov3_chronoforms_categoria_30` AS `categorie` 
  ON `atti19`.`cod_categoria` = `categorie`.`cf_id` 
  LEFT JOIN `gov3_chronoforms_e_30` AS `ente` 
  ON `atti19`.`cod_ente` = `ente`.`cf_id`

1 × SELECT * 
  FROM gov3_hwdms_config

1 × SELECT count(*) 
  FROM `gov3_cwtraffic

1 × SELECT manifest_cache 
  FROM gov3_extensions

1 × SELECT uikit 
  FROM `gov3_cwgears`

1 × SELECT `atti19`.`id` AS `atti19.id`, `atti19`.`uniq_id` AS `atti19.uniq_id`, `atti19`.`created` AS `atti19.created`, `atti19`.`modified` AS `atti19.modified`, `atti19`.`ipaddress` AS `atti19.ipaddress`, `atti19`.`user_id` AS `atti19.user_id`, `atti19`.`numero_albo` AS `atti19.numero_albo`, `atti19`.`anno` AS `atti19.anno`, `atti19`.`numero_atto` AS `atti19.numero_atto`, `atti19`.`data_atto` AS `atti19.data_atto`, `atti19`.`protocollo` AS `atti19.protocollo`, `atti19`.`nome_atto` AS `atti19.nome_atto`, `atti19`.`datainizio_atto` AS `atti19.datainizio_atto`, `atti19`.`datafine_atto` AS `atti19.datafine_atto`, `atti19`.`radio0` AS `atti19.radio0`, `atti19`.`radio1` AS `atti19.radio1`, `atti19`.`info_atto` AS `atti19.info_atto`, `atti19`.`cod_sezione` AS `atti19.cod_sezione`, `atti19`.`cod_categoria` AS `atti19.cod_categoria`, `atti19`.`atto_status` AS `atti19.atto_status`, `atti19`.`cod_ente` AS `atti19.cod_ente`, `atti19`.`cod_macro` AS `atti19.cod_macro`, `atti19`.`cod_tipo` AS `atti19.cod_tipo`, `sezioni`.`cf_id` AS `sezioni.cf_id`, `sezioni`.`created` AS `sezioni.created`, `sezioni`.`modified` AS `sezioni.modified`, `sezioni`.`user_id` AS `sezioni.user_id`, `sezioni`.`sez_nome` AS `sezioni.sez_nome`, `sezioni`.`des_sezione` AS `sezioni.des_sezione`, `categorie`.`cf_id` AS `categorie.cf_id`, `categorie`.`created` AS `categorie.created`, `categorie`.`modified` AS `categorie.modified`, `categorie`.`user_id` AS `categorie.user_id`, `categorie`.`cat_nome` AS `categorie.cat_nome`, `categorie`.`des_categoria` AS `categorie.des_categoria`, `categorie`.`cod_sezione` AS `categorie.cod_sezione`, `categorie`.`check_cat` AS `categorie.check_cat`, `categorie`.`cat_giorni` AS `categorie.cat_giorni`, `ente`.`cf_id` AS `ente.cf_id`, `ente`.`created` AS `ente.created`, `ente`.`modified` AS `ente.modified`, `ente`.`user_id` AS `ente.user_id`, `ente`.`nome_ente` AS `ente.nome_ente` 
  FROM `gov3_chronoforms_atto_30` AS `atti19` 
  LEFT JOIN `gov3_chronoforms_sezione_30` AS `sezioni` 
  ON `atti19`.`cod_sezione` = `sezioni`.`cf_id` 
  LEFT JOIN `gov3_chronoforms_categoria_30` AS `categorie` 
  ON `atti19`.`cod_categoria` = `categorie`.`cf_id` 
  LEFT JOIN `gov3_chronoforms_e_30` AS `ente` 
  ON `atti19`.`cod_ente` = `ente`.`cf_id`

1 × SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` 
  FROM `gov3_chronoengine_extensions` AS `Extension`

1 × SELECT * 
  FROM `gov3_chronoforms_configurazi_30`

1 × SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` 
  FROM `gov3_chronoengine_connections` AS `Connection`

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

1 × SELECT id, home, template, s.params 
  FROM gov3_template_styles as s 
  LEFT JOIN gov3_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT botname 
  FROM `gov3_cwtraffic_knownips`

1 × SELECT ip 
  FROM `gov3_cwtraffic_knownips`

1 × SELECT id, 
  LEFT( tm, 9 ) , ip, count(*) 
  FROM `gov3_cwtraffic` 
  GROUP BY 
  LEFT( tm, 9 ) , ip 
  HAVING count(*) > 1 
  LIMIT 5

1 × SELECT count(*) 
  FROM `gov3_extensions`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM gov3_menu AS m 
  LEFT JOIN gov3_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT count(*) 
  FROM `gov3_cwgears_schedule`

1 × SELECT count(*) 
  FROM `gov3_cwgears_schedule

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM gov3_extensions

1 × SELECT b.id 
  FROM gov3_usergroups AS a 
  LEFT JOIN gov3_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `gov3_viewlevels

1 × SELECT uikit_plus 
  FROM `gov3_cwgears`

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\":\"72dfa6781cd589fe03eca32a8409a07c\"}'

1 × SHOW FULL COLUMNS 
  FROM `gov3_hwdms_config

```
1 × DELETE  
  FROM `gov3_session`
```

Archivio storico atti per Sezione/Categoria

Articoli recenti

Articoli più letti

Statistiche

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

52 query eseguite 44.52 ms

Trovati 4 duplicati!

41 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: