Istituto Comprensivo Perasso

Vista atti ed allegati

Sezione: Bandi e Gare Categoria: Bandi

Macrofamiglia: Tipologia:

Numero in albo: 14 - Anno: 2021

Numero atto: 2947 Data atto: 12-10-2021

Nome atto: Bando di gara finalizzato all’individuazione di un esperto esterno qualificato per l’affidamento dell’organizzazione del servizio psicologico a favore del pesonale docente, degli alunni e dei genitori dell’i.c. perasso - a.s. 2021/2022

Pubblicazione dal: 12-10-2021 al: 30-11-2021

Info atto:

Pubblicato: Si

Diritto all'oblio. Visibile dopo pubblicazione: Si

Allegati all'atto n: 14 Titolo: Bando di gara finalizzato all’individuazione di un esperto esterno qualificato per l’affidamento dell’organizzazione del servizio psicologico a favore del pesonale docente, degli alunni e dei genitori dell’i.c. perasso - a.s. 2021/2022

Titolo Allegato

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 267,
            "timer": {
                "start": 1677688752,
                "last": 1677688861,
                "now": 1677688862
            },
            "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": 279,
        "indietro1": "http://vecchiosito.icperasso.edu.it/albo-e-trasparenza/archivio-fino-al-30-11-2021/atti-albo-archiviati.html?act=index&orderfld=categorie.cat_nome&orderdrc=asc",
        "allegato1": "20211012145111_2_Avviso_bando_sportello_psicologico_a.s.2021-2022.pdf",
        "allegato2": "20211012145154_3_Allegato1.pdf",
        "allegato3": "20211029144555_03_Allegato_1_-_Condizioni_minime_a_pena_esclusione.pdf",
        "allegato4": "20211029144627_04_Allegato_2_-_Criteri_di_valutazione.pdf",
        "allegato5": "20211029144649_05_Modello_A_-_Documentazione_amministrativa.pdf",
        "allegato6": "20211029144712_06_Modello_B_-_Offerta_tecnica.pdf",
        "allegato7": "20211029144736_07_Modello_C_-_Offerta_economica.pdf"
    }
}

Informazioni profilo

Tempo

Memoria

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

Tempo: 34.97 ms / 37.09 ms Memoria: 1.301 MB / 2.05 MB Application: afterInitialise

Tempo: 33.50 ms / 70.59 ms Memoria: 0.718 MB / 2.77 MB Application: afterRoute

Tempo: 1.31 ms / 71.90 ms Memoria: 0.012 MB / 2.78 MB Application: beforeRenderComponent com_chronoforms5

Tempo: 24.71 ms / 96.61 ms Memoria: 0.537 MB / 3.32 MB Application: afterRenderComponent com_chronoforms5

Tempo: 3.89 ms / 100.50 ms Memoria: 0.060 MB / 3.38 MB Application: Before Access::preloadComponents (all components)

Tempo: 1.27 ms / 101.77 ms Memoria: 0.068 MB / 3.45 MB Application: After Access::preloadComponents (all components)

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

Tempo: 0.41 ms / 102.22 ms Memoria: 0.018 MB / 3.46 MB Application: After Access::getAssetRules (id:1 name:root.1)

Tempo: 1.03 ms / 103.24 ms Memoria: 0.018 MB / 3.48 MB Application: afterDispatch

Tempo: 6.91 ms / 110.15 ms Memoria: 0.178 MB / 3.66 MB Application: beforeRenderModule mod_accordeonck (Menu Generale)

Tempo: 20.44 ms / 130.59 ms Memoria: 0.628 MB / 4.29 MB Application: afterRenderModule mod_accordeonck (Menu Generale)

Tempo: 1.05 ms / 131.64 ms Memoria: -0.073 MB / 4.21 MB Application: beforeRenderModule mod_custom (Albo no logo)

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

Tempo: 0.16 ms / 132.14 ms Memoria: -0.002 MB / 4.22 MB Application: beforeRenderModule mod_custom (Personale no logo)

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

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

Tempo: 0.09 ms / 132.47 ms Memoria: 0.005 MB / 4.23 MB Application: afterRenderModule mod_custom (Alunni no logo)

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

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

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

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

Tempo: 0.14 ms / 133.07 ms Memoria: -0.000 MB / 4.23 MB Application: beforeRenderModule mod_custom (Contatti no logo)

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

Tempo: 0.76 ms / 133.92 ms Memoria: 0.012 MB / 4.25 MB Application: beforeRenderModule mod_articles_latest (Articoli recenti)

Tempo: 0.91 ms / 134.83 ms Memoria: 0.042 MB / 4.29 MB Application: Before Access::getAssetRules (id:8 name:com_content)

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

Tempo: 17.50 ms / 152.44 ms Memoria: 0.074 MB / 4.37 MB Application: afterRenderModule mod_articles_latest (Articoli recenti)

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

Tempo: 3.96 ms / 156.61 ms Memoria: 0.026 MB / 4.37 MB Application: afterRenderModule mod_articles_popular (Articoli più letti)

Tempo: 0.24 ms / 156.85 ms Memoria: 0.005 MB / 4.38 MB Application: beforeRenderModule mod_coalawebtraffic (Statistiche)

Tempo: 4.67 ms / 161.52 ms Memoria: 0.095 MB / 4.47 MB Application: afterRenderModule mod_coalawebtraffic (Statistiche)

Tempo: 0.22 ms / 161.74 ms Memoria: -0.007 MB / 4.47 MB Application: beforeRenderModule mod_jm_social_icons (Social)

Tempo: 0.48 ms / 162.22 ms Memoria: 0.043 MB / 4.51 MB Application: afterRenderModule mod_jm_social_icons (Social)

Tempo: 2.26 ms / 164.48 ms Memoria: 0.030 MB / 4.54 MB Application: beforeRenderModule mod_custom (Copyrights)

Tempo: 0.10 ms / 164.58 ms Memoria: 0.003 MB / 4.54 MB Application: afterRenderModule mod_custom (Copyrights)

Tempo: 0.06 ms / 164.64 ms Memoria: 0.000 MB / 4.54 MB Application: beforeRenderModule mod_breadcrumbs (Percorso)

Tempo: 0.80 ms / 165.44 ms Memoria: 0.011 MB / 4.55 MB Application: afterRenderModule mod_breadcrumbs (Percorso)

Tempo: 0.09 ms / 165.53 ms Memoria: 0.008 MB / 4.56 MB Application: beforeRenderModule mod_djmegamenu (Top MegaMenu)

Tempo: 3.63 ms / 169.16 ms Memoria: 0.130 MB / 4.69 MB Application: beforeRenderModule mod_custom (Logo Menu Personale)

Tempo: 0.13 ms / 169.29 ms Memoria: 0.003 MB / 4.70 MB Application: afterRenderModule mod_custom (Logo Menu Personale)

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

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

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

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

Tempo: 5.86 ms / 175.62 ms Memoria: 0.003 MB / 4.70 MB Application: afterRenderModule mod_djmegamenu (Top MegaMenu)

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

Tempo: 0.11 ms / 175.82 ms Memoria: 0.003 MB / 4.68 MB Application: afterRenderModule mod_custom (Testata sito)

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

Tempo: 0.34 ms / 176.22 ms Memoria: 0.006 MB / 4.68 MB Application: afterRenderModule mod_syndicate (Feed Rss)

Tempo: 0.03 ms / 176.25 ms Memoria: -0.001 MB / 4.68 MB Application: beforeRenderModule mod_search (Cerca)

Tempo: 0.71 ms / 176.96 ms Memoria: 0.015 MB / 4.70 MB Application: afterRenderModule mod_search (Cerca)

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

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

Tempo: 0.02 ms / 177.15 ms Memoria: -0.000 MB / 4.69 MB Application: beforeRenderModule mod_login (Login)

Tempo: 1.42 ms / 178.57 ms Memoria: 0.021 MB / 4.72 MB Application: afterRenderModule mod_login (Login)

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

Tempo: 0.11 ms / 178.75 ms Memoria: 0.003 MB / 4.72 MB Application: afterRenderModule mod_custom (Bottoni Home)

Tempo: 14.52 ms / 193.26 ms Memoria: 0.296 MB / 5.01 MB Application: afterRender

Query totali del database: 57.23 ms

Utilizzo memoria

Query Database

57 query eseguite 57.23 ms

Trovati 4 duplicati!

2 duplicati: #7 #8

2 duplicati: #18 #48

Tempo della query: 0.31 ms Memoria query: 0.023 MB memoria prima della query: 1.031 MB Righe restituite: 1

SELECT `data`

  FROM `gov3_session`

  WHERE `session_id` = X'666972686466736d36316371657035306a7572696a6567683064'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gov3_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.06 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.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:45

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

Tempo della query: 0.53 ms Dopo l'ultima query: 0.79 ms Memoria query: 0.042 MB memoria prima della query: 1.092 MB Righe restituite: 49

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

  FROM `gov3_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gov3_extensions	NULL	ref	extension	extension	82	const	50	1.00	Using where

Profilo

Status	Duration
starting	0.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.06 ms
preparing	0.02 ms
executing	0.21 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 0.78 ms Dopo l'ultima query: 1.02 ms Memoria query: 0.021 MB memoria prima della query: 1.134 MB Righe restituite: 9

SELECT id, rules

  FROM `gov3_viewlevels`

Explain

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

Profilo

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.11 ms
end	0.01 ms
query end	0.02 ms
waiting for handler commit	0.03 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 0.54 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.021 MB memoria prima della query: 1.148 MB Righe restituite: 2

SELECT b.id

  FROM gov3_usergroups AS a

  LEFT JOIN gov3_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	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.02 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 1.13 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.046 MB memoria prima della query: 1.169 MB Righe restituite: 108

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM gov3_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gov3_extensions	NULL	ref	extension	extension	82	const	147	0.60	Using where; Using filesort

Profilo

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.67 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 0.43 ms Dopo l'ultima query: 16.88 ms Memoria query: 0.004 MB memoria prima della query: 2.012 MB

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

Explain

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

Profilo

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.03 ms
updating	0.01 ms
end	0.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
9	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:53
8	plgSystemMarcosinterceptor->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

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

Query duplicate: #8

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

Profilo

Status	Duration
starting	0.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
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
9	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:61
8	plgSystemMarcosinterceptor->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

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

Query duplicate: #7

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.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/marcosinterceptor/marcosinterceptor.php:65
8	plgSystemMarcosinterceptor->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 2.64 ms Dopo l'ultima query: 0.30 ms Memoria query: 0.005 MB memoria prima della query: 2.032 MB

UPDATE gov3_content

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

  WHERE state='1' 
  AND publish_down <='2023-03-01 16:41:02' 
  AND publish_down !='0000-00-00 00:00:00'

Explain

EXPLAIN non possibile sulla query: UPDATE gov3_content SET state=2 , publish_down =DATE_ADD(publish_down, INTERVAL 30 DAY) , publish_down ='0000-00-00 00:00:00' WHERE state='1' AND publish_down <='2023-03-01 16:41:02' 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.07 ms
updating	2.27 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.04 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.42 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.005 MB memoria prima della query: 2.038 MB

UPDATE gov3_content

  SET state='0'

  WHERE state='2' 
  AND publish_down <='2023-03-01 16:41:02' 
  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:02' 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.30 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.020 MB memoria prima della query: 2.044 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwgears_schedule`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Select tables optimized away

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:96
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

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

SELECT count(*)

  FROM `gov3_cwgears_schedule`

  WHERE time + '86400'<'1677688862'

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.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.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.06 ms Dopo l'ultima query: 0.77 ms Memoria query: 0.147 MB memoria prima della query: 2.083 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.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.63 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()	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.49 ms Dopo l'ultima query: 5.72 ms Memoria query: 0.024 MB memoria prima della query: 2.528 MB Righe restituite: 1

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

  FROM `gov3_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gov3_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profilo

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:195
8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 5.61 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.006 MB memoria prima della query: 2.521 MB

UPDATE `gov3_extensions`

  SET `params` = '{\"mediaversion\":\"6c562ea9dd4c6e3c4b6cf7d814b1489e\"}'

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

Explain

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

Profilo

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.07 ms
updating	0.10 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	4.95 ms
closing tables	0.06 ms
freeing items	0.09 ms
cleaning up	0.05 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: 1.25 ms Dopo l'ultima query: 3.57 ms Memoria query: 0.021 MB memoria prima della query: 2.602 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.21 ms
Executing hook on transaction	0.02 ms
starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.11 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.07 ms
statistics	0.17 ms
executing	0.05 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.04 ms
closing tables	0.08 ms
freeing items	0.07 ms
cleaning up	0.05 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: 1.62 ms Dopo l'ultima query: 2.40 ms Memoria query: 0.021 MB memoria prima della query: 2.609 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.23 ms
Executing hook on transaction	0.02 ms
starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.05 ms
Creating tmp table	0.14 ms
executing	0.52 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.03 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.50 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.021 MB memoria prima della query: 2.614 MB Righe restituite: 3

Query duplicate: #48

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.08 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 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.66 ms Dopo l'ultima query: 0.40 ms Memoria query: 0.020 MB memoria prima della query: 2.619 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.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.04 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:286
8	plgSystemCwtrafficClean->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 0.61 ms Dopo l'ultima query: 1.32 ms Memoria query: 0.020 MB memoria prima della query: 2.627 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.11 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
executing	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.03 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.47 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.020 MB memoria prima della query: 2.632 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.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.03 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.52 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.020 MB memoria prima della query: 2.636 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwtraffic`

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

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.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.05 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 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.80 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.021 MB memoria prima della query: 2.645 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.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.05 ms
executing	0.14 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 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.60 ms Dopo l'ultima query: 4.51 ms Memoria query: 0.020 MB memoria prima della query: 2.774 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.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.10 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 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: 3.97 ms Memoria query: 0.023 MB memoria prima della query: 2.966 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.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.17 ms Dopo l'ultima query: 2.02 ms Memoria query: 0.072 MB memoria prima della query: 3.031 MB Righe restituite: 1

SELECT `Form`.`id` AS `Form.id`, `Form`.`title` AS `Form.title`, `Form`.`params` AS `Form.params`, `Form`.`extras` AS `Form.extras`, `Form`.`published` AS `Form.published`, `Form`.`app` AS `Form.app`, `Form`.`form_type` AS `Form.form_type`, `Form`.`content` AS `Form.content` 
  FROM `gov3_chronoengine_chronoforms` AS `Form` 
  WHERE `Form`.`title` = 'atti_vista' 
  AND `Form`.`published` = '1'

Explain

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

Profilo

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.65 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
16	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
15	GCore\Libs\Model->find()	JROOT/libraries/cegcore/libs/gmodel.php:27
14	GCore\Libs\GModel->find()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:51
13	GCore\Extensions\Chronoforms\Libs\Form->getForm()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:29
12	GCore\Extensions\Chronoforms\Libs\Form->__construct()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:41
11	GCore\Extensions\Chronoforms\Libs\Form::getInstance()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:85
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.41 ms Dopo l'ultima query: 1.31 ms Memoria query: 0.025 MB memoria prima della query: 3.119 MB Righe restituite: 1

SELECT `atto`.`id` AS `atto.id`, `atto`.`uniq_id` AS `atto.uniq_id`, `atto`.`created` AS `atto.created`, `atto`.`modified` AS `atto.modified`, `atto`.`ipaddress` AS `atto.ipaddress`, `atto`.`user_id` AS `atto.user_id`, `atto`.`numero_albo` AS `atto.numero_albo`, `atto`.`anno` AS `atto.anno`, `atto`.`numero_atto` AS `atto.numero_atto`, `atto`.`data_atto` AS `atto.data_atto`, `atto`.`protocollo` AS `atto.protocollo`, `atto`.`nome_atto` AS `atto.nome_atto`, `atto`.`datainizio_atto` AS `atto.datainizio_atto`, `atto`.`datafine_atto` AS `atto.datafine_atto`, `atto`.`radio0` AS `atto.radio0`, `atto`.`radio1` AS `atto.radio1`, `atto`.`info_atto` AS `atto.info_atto`, `atto`.`cod_sezione` AS `atto.cod_sezione`, `atto`.`cod_categoria` AS `atto.cod_categoria`, `atto`.`atto_status` AS `atto.atto_status`, `atto`.`cod_ente` AS `atto.cod_ente`, `atto`.`cod_macro` AS `atto.cod_macro`, `atto`.`cod_tipo` AS `atto.cod_tipo` 
  FROM `gov3_chronoforms_atto_30` AS `atto` 
  WHERE atto.id = 211

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	atto	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.10 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.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
15	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
14	GCore\Libs\Model->find()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/db_read/db_read.php:100
13	GCore\Admin\Extensions\Chronoforms\Actions\DbRead\DbRead->execute()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:106
12	GCore\Extensions\Chronoforms\Libs\Form->runAction()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:84
11	GCore\Extensions\Chronoforms\Libs\Form->process()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:87
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.30 ms Dopo l'ultima query: 0.82 ms Memoria query: 0.024 MB memoria prima della query: 3.140 MB Righe restituite: 1

SELECT `sezioni`.`sez_nome` AS `sezioni.sez_nome` 
  FROM `gov3_chronoforms_sezione_30` AS `sezioni` 
  WHERE `sezioni`.`cf_id` = '4'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sezioni	NULL	const	PRIMARY	PRIMARY	4	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.03 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
15	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
14	GCore\Libs\Model->find()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/db_read/db_read.php:100
13	GCore\Admin\Extensions\Chronoforms\Actions\DbRead\DbRead->execute()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:106
12	GCore\Extensions\Chronoforms\Libs\Form->runAction()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:84
11	GCore\Extensions\Chronoforms\Libs\Form->process()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:87
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.28 ms Dopo l'ultima query: 0.58 ms Memoria query: 0.024 MB memoria prima della query: 3.160 MB Righe restituite: 1

SELECT `categorie`.`cat_nome` AS `categorie.cat_nome` 
  FROM `gov3_chronoforms_categoria_30` AS `categorie` 
  WHERE `categorie`.`cf_id` = '9'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	categorie	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.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.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
15	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
14	GCore\Libs\Model->find()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/db_read/db_read.php:100
13	GCore\Admin\Extensions\Chronoforms\Actions\DbRead\DbRead->execute()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:106
12	GCore\Extensions\Chronoforms\Libs\Form->runAction()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:84
11	GCore\Extensions\Chronoforms\Libs\Form->process()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:87
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.28 ms Dopo l'ultima query: 0.58 ms Memoria query: 0.024 MB memoria prima della query: 3.179 MB Righe restituite: 0

SELECT `enti`.`cf_id` AS `enti.cf_id`, `enti`.`nome_ente` AS `enti.nome_ente` 
  FROM `gov3_chronoforms_e_30` AS `enti` 
  WHERE `enti`.`cf_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	Impossible WHERE noticed after reading const tables

Profilo

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
15	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
14	GCore\Libs\Model->find()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/db_read/db_read.php:100
13	GCore\Admin\Extensions\Chronoforms\Actions\DbRead\DbRead->execute()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:106
12	GCore\Extensions\Chronoforms\Libs\Form->runAction()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:84
11	GCore\Extensions\Chronoforms\Libs\Form->process()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:87
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.38 ms Dopo l'ultima query: 0.57 ms Memoria query: 0.024 MB memoria prima della query: 3.198 MB Righe restituite: 0

SELECT `macrofamiglia`.`macrofamiglia` AS `macrofamiglia.macrofamiglia` 
  FROM `gov3_chronoforms_macrofamiglie_at_30` AS `macrofamiglia` 
  WHERE `macrofamiglia`.`id` = '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.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
15	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
14	GCore\Libs\Model->find()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/db_read/db_read.php:100
13	GCore\Admin\Extensions\Chronoforms\Actions\DbRead\DbRead->execute()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:106
12	GCore\Extensions\Chronoforms\Libs\Form->runAction()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:84
11	GCore\Extensions\Chronoforms\Libs\Form->process()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:87
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.65 ms Dopo l'ultima query: 0.52 ms Memoria query: 0.026 MB memoria prima della query: 3.217 MB Righe restituite: 66

SELECT `tipologia`.`tipologia` AS `tipologia.tipologia` 
  FROM `gov3_chronoforms_tipologie_at_30` AS `tipologia`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tipologia	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	66	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.12 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.32 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
15	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
14	GCore\Libs\Model->find()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/db_read/db_read.php:100
13	GCore\Admin\Extensions\Chronoforms\Actions\DbRead\DbRead->execute()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:106
12	GCore\Extensions\Chronoforms\Libs\Form->runAction()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:84
11	GCore\Extensions\Chronoforms\Libs\Form->process()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:87
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.32 ms Dopo l'ultima query: 3.28 ms Memoria query: 0.025 MB memoria prima della query: 3.311 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.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.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/html/html.php(263) : eval()'d code:18
14	eval()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/html/html.php:263
13	GCore\Admin\Extensions\Chronoforms\Actions\Html\Html->execute()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:106
12	GCore\Extensions\Chronoforms\Libs\Form->runAction()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:84
11	GCore\Extensions\Chronoforms\Libs\Form->process()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:87
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.63 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.023 MB memoria prima della query: 3.323 MB Righe restituite: 0

SELECT funzioni

  FROM `gov3_chronoforms_ute_30`

  WHERE `utente` = '0'

Explain

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

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.40 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
15	JDatabaseDriver->loadRow()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/html/html.php(263) : eval()'d code:38
14	eval()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/html/html.php:263
13	GCore\Admin\Extensions\Chronoforms\Actions\Html\Html->execute()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:106
12	GCore\Extensions\Chronoforms\Libs\Form->runAction()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:84
11	GCore\Extensions\Chronoforms\Libs\Form->process()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:87
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.34 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.024 MB memoria prima della query: 3.330 MB Righe restituite: 1

SELECT *

  FROM `gov3_chronoforms_configurazi_30`

Explain

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

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/html/html.php(263) : eval()'d code:92
14	eval()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/html/html.php:263
13	GCore\Admin\Extensions\Chronoforms\Actions\Html\Html->execute()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:106
12	GCore\Extensions\Chronoforms\Libs\Form->runAction()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:84
11	GCore\Extensions\Chronoforms\Libs\Form->process()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:87
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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: 2.34 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.023 MB memoria prima della query: 3.338 MB Righe restituite: 2

SELECT `titolo_all`,`allegato`

  FROM `gov3_chronoforms_allegati_30`

  WHERE `cod_atto` = '211'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gov3_chronoforms_allegati_30	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	256	10.00	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.21 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	1.81 ms
end	0.04 ms
query end	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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/html/html.php(263) : eval()'d code:107
14	eval()	JROOT/administrator/components/com_chronoforms5/chronoforms/actions/html/html.php:263
13	GCore\Admin\Extensions\Chronoforms\Actions\Html\Html->execute()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:106
12	GCore\Extensions\Chronoforms\Libs\Form->runAction()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:84
11	GCore\Extensions\Chronoforms\Libs\Form->process()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:87
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.34 ms Dopo l'ultima query: 1.52 ms Memoria query: 0.023 MB memoria prima della query: 3.282 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` = 'chronoforms'

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.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 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.02 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/components/com_chronoforms5/chronoforms/libs/form.php:210
11	GCore\Extensions\Chronoforms\Libs\Form::_settings()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:89
10	GCore\Extensions\Chronoforms\Chronoforms->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_chronoforms5/chronoforms5.php:36
6	require_once JROOT/components/com_chronoforms5/chronoforms5.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.92 ms Dopo l'ultima query: 5.62 ms Memoria query: 0.028 MB memoria prima della query: 3.387 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.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.36 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.39 ms Dopo l'ultima query: 2.58 ms Memoria query: 0.021 MB memoria prima della query: 3.531 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.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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.21 ms Dopo l'ultima query: 1.61 ms Memoria query: 0.045 MB memoria prima della query: 3.590 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:02') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-01 16:41:02') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 278 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.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.05 ms
executing	0.62 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.74 ms Dopo l'ultima query: 3.76 ms Memoria query: 0.089 MB memoria prima della query: 3.733 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.04 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.29 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
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.41 ms Dopo l'ultima query: 14.79 ms Memoria query: 0.031 MB memoria prima della query: 4.274 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.51 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.07 ms
executing	0.07 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
end	0.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.43 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.029 MB memoria prima della query: 4.361 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.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.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
27	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
26	Joomla\CMS\Table\Table->load()	JROOT/components/com_hwdmediashare/libraries/factory.php:249
25	hwdMediaShareFactory->getConfig()	JROOT/components/com_hwdmediashare/router.php:57
24	hwdMediaShareRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_accordeonck/helper.php:229
17	modAccordeonckHelper::GetItems()	JROOT/modules/mod_accordeonck/mod_accordeonck.php:65
16	include JROOT/modules/mod_accordeonck/mod_accordeonck.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559
13	JMFTemplate->renderModules()	JROOT/templates/id-gov/tpl/blocks/main.php:103
12	include JROOT/templates/id-gov/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397
11	JMFTemplate->renderBlock()	JROOT/templates/id-gov/tpl/default.php:74
10	include JROOT/templates/id-gov/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427
8	JMFTemplate->renderScheme()	JROOT/templates/id-gov/index.php:39
7	require JROOT/templates/id-gov/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 13.78 ms Dopo l'ultima query: 6.10 ms Memoria query: 0.031 MB memoria prima della query: 4.301 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:02') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-01 16:41:02')

  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.17 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.11 ms
executing	12.67 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.11 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

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.70 ms Dopo l'ultima query: 0.92 ms Memoria query: 0.031 MB memoria prima della query: 4.347 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.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
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.65 ms Dopo l'ultima query: 0.87 ms Memoria query: 0.031 MB memoria prima della query: 4.379 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.16 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.06 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.03 ms

Call Stack

#	Caller	File e numero di linea
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
30	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
29	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
28	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:135
18	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
17	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559
14	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869
13	JMFTemplate->renderFlexiblock()	JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31
12	include JROOT/templates/id-gov/tpl/blocks/footer-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397
11	JMFTemplate->renderBlock()	JROOT/templates/id-gov/tpl/default.php:74
10	include JROOT/templates/id-gov/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427
8	JMFTemplate->renderScheme()	JROOT/templates/id-gov/index.php:39
7	require JROOT/templates/id-gov/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 3.06 ms Dopo l'ultima query: 1.39 ms Memoria query: 0.027 MB memoria prima della query: 4.381 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:02') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-01 16:41:02') 
  AND a.publish_up >= DATE_ADD('2023-03-01 16:41:02', 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.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.11 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.05 ms
statistics	0.15 ms
preparing	0.03 ms
Creating tmp table	0.12 ms
executing	2.10 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
19	ContentModelArticles->getItems()	JROOT/modules/mod_articles_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.41 ms Dopo l'ultima query: 2.17 ms Memoria query: 0.026 MB memoria prima della query: 4.426 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.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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.24 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.026 MB memoria prima della query: 4.436 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.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_coalawebtraffic/helper.php:104
18	mod_coalawebtrafficHelper->read()	JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:93
17	include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1559
14	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1869
13	JMFTemplate->renderFlexiblock()	JROOT/templates/id-gov/tpl/blocks/footer-mod.php:31
12	include JROOT/templates/id-gov/tpl/blocks/footer-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397
11	JMFTemplate->renderBlock()	JROOT/templates/id-gov/tpl/default.php:74
10	include JROOT/templates/id-gov/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1397
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1427
8	JMFTemplate->renderScheme()	JROOT/templates/id-gov/index.php:39
7	require JROOT/templates/id-gov/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 0.32 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.026 MB memoria prima della query: 4.447 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.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.02 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.34 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.026 MB memoria prima della query: 4.457 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.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.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.32 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.026 MB memoria prima della query: 4.468 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwtraffic`

  WHERE tm >= '1677452400'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gov3_cwtraffic	NULL	range	unique_tm_ip,unique_tm_iphash,idx_tm,idx_iptm,idx_iphashtm	idx_tm	4	NULL	5	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.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.32 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.026 MB memoria prima della query: 4.478 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.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
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.49 ms Dopo l'ultima query: 9.22 ms Memoria query: 0.022 MB memoria prima della query: 4.686 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.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	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.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.38 ms Dopo l'ultima query: 8.30 ms Memoria query: 0.022 MB memoria prima della query: 4.722 MB Righe restituite: 0

SELECT uikit

  FROM `gov3_cwgears`

  WHERE url = 'http://vecchiosito.icperasso.edu.it/component/chronoforms5/?chronoform=atti_vista&gcb=211&Itemid=278'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

Profilo

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 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.25 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.022 MB memoria prima della query: 4.729 MB Righe restituite: 0

SELECT uikit_plus

  FROM `gov3_cwgears`

  WHERE url = 'http://vecchiosito.icperasso.edu.it/component/chronoforms5/?chronoform=atti_vista&gcb=211&Itemid=278'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.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
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.85 ms Dopo l'ultima query: 11.03 ms Memoria query: 0.025 MB memoria prima della query: 5.076 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.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.19 ms
preparing	0.03 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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]

46 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 * 
  FROM `gov3_chronoforms_configurazi_30`

1 × SELECT funzioni 
  FROM `gov3_chronoforms_ute_30`

1 × SELECT * 
  FROM `gov3_chronoforms_configurazi_30

1 × SELECT `titolo_all`,`allegato` 
  FROM `gov3_chronoforms_allegati_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 `data` 
  FROM `gov3_session`

1 × SELECT id 
  FROM gov3_template_styles

1 × SELECT `macrofamiglia`.`macrofamiglia` AS `macrofamiglia.macrofamiglia` 
  FROM `gov3_chronoforms_macrofamiglie_at_30` AS `macrofamiglia`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM gov3_modules AS m 
  LEFT JOIN gov3_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN gov3_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT *

    
  FROM gov3_modules

1 × SELECT * 
  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 `tipologia`.`tipologia` AS `tipologia.tipologia` 
  FROM `gov3_chronoforms_tipologie_at_30` AS `tipologia

1 × SELECT `sezioni`.`sez_nome` AS `sezioni.sez_nome` 
  FROM `gov3_chronoforms_sezione_30` AS `sezioni`

1 × SELECT `enti`.`cf_id` AS `enti.cf_id`, `enti`.`nome_ente` AS `enti.nome_ente` 
  FROM `gov3_chronoforms_e_30` AS `enti`

1 × SELECT count(*) 
  FROM `gov3_extensions`

1 × SELECT id, rules 
  FROM `gov3_viewlevels

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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM gov3_extensions

1 × SELECT count(*) 
  FROM `gov3_cwgears_schedule

1 × SELECT count(*) 
  FROM `gov3_cwgears_schedule`

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 id, 
  LEFT( tm, 9 ) , ip, count(*) 
  FROM `gov3_cwtraffic` 
  GROUP BY 
  LEFT( tm, 9 ) , ip 
  HAVING count(*) > 1 
  LIMIT 5

1 × SELECT `categorie`.`cat_nome` AS `categorie.cat_nome` 
  FROM `gov3_chronoforms_categoria_30` AS `categorie`

1 × SELECT ip 
  FROM `gov3_cwtraffic_knownips`

1 × SELECT botname 
  FROM `gov3_cwtraffic_knownips`

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 * 
  FROM gov3_languages
```

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

1 × SELECT `Form`.`id` AS `Form.id`, `Form`.`title` AS `Form.title`, `Form`.`params` AS `Form.params`, `Form`.`extras` AS `Form.extras`, `Form`.`published` AS `Form.published`, `Form`.`app` AS `Form.app`, `Form`.`form_type` AS `Form.form_type`, `Form`.`content` AS `Form.content` 
  FROM `gov3_chronoengine_chronoforms` AS `Form`

1 × SELECT `atto`.`id` AS `atto.id`, `atto`.`uniq_id` AS `atto.uniq_id`, `atto`.`created` AS `atto.created`, `atto`.`modified` AS `atto.modified`, `atto`.`ipaddress` AS `atto.ipaddress`, `atto`.`user_id` AS `atto.user_id`, `atto`.`numero_albo` AS `atto.numero_albo`, `atto`.`anno` AS `atto.anno`, `atto`.`numero_atto` AS `atto.numero_atto`, `atto`.`data_atto` AS `atto.data_atto`, `atto`.`protocollo` AS `atto.protocollo`, `atto`.`nome_atto` AS `atto.nome_atto`, `atto`.`datainizio_atto` AS `atto.datainizio_atto`, `atto`.`datafine_atto` AS `atto.datafine_atto`, `atto`.`radio0` AS `atto.radio0`, `atto`.`radio1` AS `atto.radio1`, `atto`.`info_atto` AS `atto.info_atto`, `atto`.`cod_sezione` AS `atto.cod_sezione`, `atto`.`cod_categoria` AS `atto.cod_categoria`, `atto`.`atto_status` AS `atto.atto_status`, `atto`.`cod_ente` AS `atto.cod_ente`, `atto`.`cod_macro` AS `atto.cod_macro`, `atto`.`cod_tipo` AS `atto.cod_tipo` 
  FROM `gov3_chronoforms_atto_30` AS `atto`

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\":\"6c562ea9dd4c6e3c4b6cf7d814b1489e\"}'

1 × SHOW FULL COLUMNS 
  FROM `gov3_hwdms_config