Condividi il video

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 2600,
            "timer": {
                "start": 1677688752,
                "last": 1677691417,
                "now": 1677691417
            },
            "token": "Y427qrlAq36DgOfe3120M2zaMcqQOOWo"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cDovL3ZlY2NoaW9zaXRvLmljcGVyYXNzby5lZHUuaXQvc2Vydml6aS1vbmxpbmUvYWNjZXNzby1jaXZpY28vNjEtbW9kYWxpdGEtZGktYWNjZXNzby1jaXZpY28tZS1tb2R1bG8tZGktYWNjZXNzby5odG1sP3RtcGw9Y29tcG9uZW50JnByaW50PTE%3D"
            },
            "users": {
                "login": {
                    "form": {
                        "data": {
                            "return": "http://vecchiosito.icperasso.edu.it/area-riservata-docenti.html?jsmallfib=1&dir=JSROOT/Area_Riservata/ORGANI%20COLLEGIALI/Anno%20scolastico%202022-23/Collegio%20docenti%20unitario%2001-09-22"
                        }
                    }
                }
            },
            "com_hwdmediashare": {
                "media": {
                    "list": {
                        "fullordering": "a.created DESC",
                        "limit": "9"
                    },
                    "limitstart": 0
                }
            },
            "media": {
                "quality": "480",
                "display": "list"
            },
            "com_content": {
                "category": {
                    "list": {
                        "98:209": {
                            "limit": 20
                        },
                        "29:281": {
                            "limit": 20
                        },
                        "30:281": {
                            "limit": 20
                        },
                        "31:281": {
                            "limit": 20
                        },
                        "32:281": {
                            "limit": 20
                        },
                        "33:281": {
                            "limit": 20
                        },
                        "34:281": {
                            "limit": 20
                        },
                        "106:281": {
                            "limit": 20
                        },
                        "114:281": {
                            "limit": 20
                        },
                        "14:281": {
                            "limit": 20
                        },
                        "35:281": {
                            "limit": 20
                        },
                        "36:281": {
                            "limit": 20
                        },
                        "37:281": {
                            "limit": 20
                        },
                        "18:281": {
                            "limit": 20
                        },
                        "15:281": {
                            "limit": 20
                        },
                        "115:281": {
                            "limit": 20
                        },
                        "38:281": {
                            "limit": 20
                        },
                        "39:281": {
                            "limit": 20
                        },
                        "40:281": {
                            "limit": 20
                        },
                        "116:281": {
                            "limit": 20
                        },
                        "133:281": {
                            "limit": 20
                        },
                        "134:281": {
                            "limit": 20
                        },
                        "16:281": {
                            "limit": 20
                        },
                        "17:281": {
                            "limit": 20
                        },
                        "41:281": {
                            "limit": 20
                        },
                        "42:281": {
                            "limit": 20
                        },
                        "43:281": {
                            "limit": 20
                        },
                        "44:281": {
                            "limit": 20
                        },
                        "45:281": {
                            "limit": 20
                        },
                        "46:281": {
                            "limit": 20
                        },
                        "47:281": {
                            "limit": 20
                        },
                        "48:281": {
                            "limit": 20
                        },
                        "49:281": {
                            "limit": 20
                        },
                        "117:281": {
                            "limit": 20
                        },
                        "118:281": {
                            "limit": 20
                        },
                        "119:281": {
                            "limit": 20
                        },
                        "120:281": {
                            "limit": 20
                        },
                        "135:281": {
                            "limit": 20
                        },
                        "50:281": {
                            "limit": 20
                        },
                        "51:281": {
                            "limit": 20
                        },
                        "52:281": {
                            "limit": 20
                        },
                        "53:281": {
                            "limit": 20
                        },
                        "54:281": {
                            "limit": 20
                        },
                        "55:281": {
                            "limit": 20
                        },
                        "56:281": {
                            "limit": 20
                        },
                        "107:281": {
                            "limit": 20
                        },
                        "108:281": {
                            "limit": 20
                        },
                        "57:281": {
                            "limit": 20
                        },
                        "58:281": {
                            "limit": 20
                        },
                        "59:281": {
                            "limit": 20
                        },
                        "60:281": {
                            "limit": 20
                        },
                        "61:281": {
                            "limit": 20
                        },
                        "62:281": {
                            "limit": 20
                        },
                        "63:281": {
                            "limit": 20
                        },
                        "64:281": {
                            "limit": 20
                        },
                        "65:281": {
                            "limit": 20
                        },
                        "66:281": {
                            "limit": 20
                        },
                        "67:281": {
                            "limit": 20
                        },
                        "68:281": {
                            "limit": 20
                        },
                        "69:281": {
                            "limit": 20
                        },
                        "70:281": {
                            "limit": 20
                        },
                        "71:281": {
                            "limit": 20
                        },
                        "121:281": {
                            "limit": 20
                        },
                        "122:281": {
                            "limit": 20
                        },
                        "72:281": {
                            "limit": 20
                        },
                        "73:281": {
                            "limit": 20
                        },
                        "74:281": {
                            "limit": 20
                        },
                        "75:281": {
                            "limit": 20
                        },
                        "76:281": {
                            "limit": 20
                        },
                        "77:281": {
                            "limit": 20
                        },
                        "78:281": {
                            "limit": 20
                        },
                        "79:281": {
                            "limit": 20
                        },
                        "80:281": {
                            "limit": 20
                        },
                        "81:281": {
                            "limit": 20
                        },
                        "123:281": {
                            "limit": 20
                        },
                        "124:281": {
                            "limit": 20
                        },
                        "125:281": {
                            "limit": 20
                        },
                        "82:281": {
                            "limit": 20
                        },
                        "83:281": {
                            "limit": 20
                        },
                        "84:281": {
                            "limit": 20
                        },
                        "85:281": {
                            "limit": 20
                        },
                        "86:281": {
                            "limit": 20
                        },
                        "109:281": {
                            "limit": 20
                        },
                        "126:281": {
                            "limit": 20
                        },
                        "87:281": {
                            "limit": 20
                        },
                        "88:281": {
                            "limit": 20
                        },
                        "89:281": {
                            "limit": 20
                        },
                        "127:281": {
                            "limit": 20
                        },
                        "132:281": {
                            "limit": 20
                        },
                        "90:281": {
                            "limit": 20
                        },
                        "128:281": {
                            "limit": 20
                        },
                        "129:281": {
                            "limit": 20
                        },
                        "130:281": {
                            "limit": 20
                        },
                        "91:281": {
                            "limit": 20
                        },
                        "92:281": {
                            "limit": 20
                        },
                        "93:281": {
                            "limit": 20
                        },
                        "94:281": {
                            "limit": 20
                        },
                        "95:281": {
                            "limit": 20
                        },
                        "131:281": {
                            "limit": 20
                        },
                        "110:281": {
                            "limit": 20
                        },
                        "96:281": {
                            "limit": 20
                        },
                        "97:281": {
                            "limit": 20
                        },
                        "111:281": {
                            "limit": 20
                        }
                    }
                }
            }
        },
        "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": "",
        "indietro1": "http://vecchiosito.icperasso.edu.it/component/chronoconnectivity5/?cont=lists&act=index&ccname=albo_atti_sezioni_categorie&sez=5",
        "allegato1": "20181127132536_PROCLAMAZIONE_DEGLI_ELETTI.pdf",
        "allegato2": "20210714151545_Elenco_esclusi_III_Fascia_provvisoria_GA.pdf",
        "allegato3": "20200312121605_allegato-2-offerta-tecnico-economica-2__1_.pdf",
        "allegato4": "20200312121634_allegato-3-dichiarazione-sostitutiva-e-traccaibilit-flussi.pdf",
        "allegato5": "20200312121715_allegato-4-informativa-privacy.pdf",
        "allegato6": "20200312121758_determina-RSPP.pdf",
        "allegato7": "20200504121542_DETERMINA_MEDICO_COMPETENTE.pdf",
        "allegato8": "20201030155700_Nomina_Commissione_per_apertura_buste.pdf",
        "categoria": 0,
        "sezione": 5,
        "ent": 0,
        "anno": "",
        "flag": 1
    }
}

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

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

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

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

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

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

#	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

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

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

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

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

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

EXPLAIN non possibile sulla query: UPDATE gov3_content SET state=2 , publish_down =DATE_ADD(publish_down, INTERVAL 30 DAY) , publish_down ='0000-00-00 00:00:00' WHERE state='1' AND publish_down <='2023-03-01 17:23:37' AND publish_down !='0000-00-00 00:00:00'

Profilo

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.11 ms
updating	2.19 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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.47 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.005 MB memoria prima della query: 2.110 MB

UPDATE gov3_content

  SET state='0'

  WHERE state='2' 
  AND publish_down <='2023-03-01 17:23:37' 
  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 17:23:37' AND publish_down !='0000-00-00 00:00:00'

Profilo

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.06 ms
Searching rows for update	0.09 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.35 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.020 MB memoria prima della query: 2.116 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.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.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.35 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.020 MB memoria prima della query: 2.121 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwgears_schedule`

  WHERE time + '86400'<'1677691417'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.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.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.08 ms Dopo l'ultima query: 0.78 ms Memoria query: 0.147 MB memoria prima della query: 2.156 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.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.62 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 0.55 ms Dopo l'ultima query: 5.18 ms Memoria query: 0.024 MB memoria prima della query: 2.601 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.03 ms

Call Stack

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

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

Tempo della query: 0.43 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.006 MB memoria prima della query: 2.594 MB

UPDATE `gov3_extensions`

  SET `params` = '{\"mediaversion\":\"8d6a68b8b04588a2000c86e4fbda1f32\"}'

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

Explain

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

Profilo

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.06 ms
updating	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:195
8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 0.35 ms Dopo l'ultima query: 0.49 ms Memoria query: 0.021 MB memoria prima della query: 2.675 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_extensions`

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

Explain

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

Profilo

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

Call Stack

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

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

Tempo della query: 0.46 ms Dopo l'ultima query: 0.48 ms Memoria query: 0.021 MB memoria prima della query: 2.682 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.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
executing	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

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

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

Tempo della query: 0.30 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.021 MB memoria prima della query: 2.686 MB Righe restituite: 3

SELECT TCOUNT

  FROM `gov3_cwtraffic_total`

Explain

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

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 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
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.35 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.020 MB memoria prima della query: 2.692 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.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.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
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.31 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.020 MB memoria prima della query: 2.700 MB Righe restituite: 0

SELECT ip

  FROM `gov3_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

Explain

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

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:163
8	plgSystemCwtrafficCount->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 0.27 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.020 MB memoria prima della query: 2.704 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.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
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.39 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.020 MB memoria prima della query: 2.709 MB Righe restituite: 1

SELECT count(*)

  FROM `gov3_cwtraffic`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gov3_cwtraffic	NULL	ref	unique_tm_iphash,idx_iphash,idx_iphashtm	idx_iphashtm	20	const	3	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.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.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

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

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

Tempo della query: 0.50 ms Dopo l'ultima query: 0.30 ms Memoria query: 0.021 MB memoria prima della query: 2.718 MB Righe restituite: 3

SELECT id, home, template, s.params

  FROM gov3_template_styles as s

  LEFT JOIN gov3_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	perasso2.e.element	1	60.00	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:2035
9	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:417
8	plgSystemEF4_JMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 0.53 ms Dopo l'ultima query: 2.45 ms Memoria query: 0.020 MB memoria prima della query: 2.847 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.08 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.02 ms
preparing	0.02 ms
executing	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.03 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: 1.28 ms Dopo l'ultima query: 2.80 ms Memoria query: 0.023 MB memoria prima della query: 3.009 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.07 ms
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.38 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
executing	0.08 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_hwdmediashare/tables/configuration.php:47
10	hwdMediaShareTableConfiguration->__construct()	JROOT/libraries/src/Table/Table.php:328
9	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_hwdmediashare/libraries/factory.php:243
8	hwdMediaShareFactory->getConfig()	JROOT/components/com_hwdmediashare/helpers/route.php:99
7	hwdMediaShareHelperRoute::entry()	JROOT/components/com_hwdmediashare/hwdmediashare.php:43
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.38 ms Memoria query: 0.021 MB memoria prima della query: 3.025 MB Righe restituite: 1

SELECT *

  FROM gov3_hwdms_config

  WHERE `id` = '1'

Explain

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

Profilo

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_hwdmediashare/libraries/factory.php:249
8	hwdMediaShareFactory->getConfig()	JROOT/components/com_hwdmediashare/helpers/route.php:99
7	hwdMediaShareHelperRoute::entry()	JROOT/components/com_hwdmediashare/hwdmediashare.php:43
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.90 ms Dopo l'ultima query: 1.83 ms Memoria query: 0.030 MB memoria prima della query: 3.168 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.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.36 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_hwdmediashare/models/mediaitem.php:713
13	hwdMediaShareModelMediaItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_hwdmediashare/models/mediaitem.php:171
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.93 ms Dopo l'ultima query: 0.75 ms Memoria query: 0.033 MB memoria prima della query: 3.256 MB Righe restituite: 40

SHOW FULL COLUMNS 
  FROM `gov3_hwdms_media`

Explain

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

Profilo

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.38 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
executing	0.07 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
checking permissions	0.09 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.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_hwdmediashare/tables/media.php:47
14	hwdMediaShareTableMedia->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_hwdmediashare/models/mediaitem.php:131
12	hwdMediaShareModelMediaItem->getTable()	JROOT/components/com_hwdmediashare/models/mediaitem.php:185
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.38 ms Memoria query: 0.023 MB memoria prima della query: 3.311 MB Righe restituite: 1

SELECT *

  FROM gov3_hwdms_media

  WHERE `id` = '34'

Explain

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

Profilo

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_hwdmediashare/models/mediaitem.php:191
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.44 ms Dopo l'ultima query: 0.57 ms Memoria query: 0.022 MB memoria prima della query: 3.328 MB Righe restituite: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `gov3_contentitem_tag_map` AS m 

  INNER JOIN `gov3_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_hwdmediashare.media' 
  AND `m`.`content_item_id` = 34 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	perasso2.m.tag_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_hwdmediashare/models/mediaitem.php:501
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.25 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.022 MB memoria prima della query: 3.337 MB Righe restituite: 0

SELECT field.*,value.`value` , value.`access`

  FROM gov3_hwdms_fields AS field

  LEFT JOIN gov3_hwdms_fields_values AS value 
  ON field.`id`=value.`field_id` 
  AND value.`element_id`='34'

  WHERE `field`.`published`='1' 
  AND `field`.`element_type`='1'

  ORDER BY `field`.`ordering`

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.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_hwdmediashare/libraries/customfields.php:365
12	hwdMediaShareCustomFields->load()	JROOT/components/com_hwdmediashare/models/mediaitem.php:513
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 0.33 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.022 MB memoria prima della query: 3.346 MB Righe restituite: 2

SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key

  FROM gov3_hwdms_files AS a

  LEFT JOIN gov3_hwdms_media AS m 
  ON m.id = a.element_id

  WHERE `a`.`element_type` = '1' 
  AND `a`.`element_id` = '34'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	8.33	Using where
1	SIMPLE	m	NULL	eq_ref	PRIMARY	PRIMARY	4	perasso2.a.element_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.10 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_hwdmediashare/libraries/files.php:1021
12	hwdMediaShareFiles->getMediaFiles()	JROOT/components/com_hwdmediashare/models/mediaitem.php:523
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.25 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.023 MB memoria prima della query: 3.364 MB Righe restituite: 0

SELECT c.id, c.title

  FROM gov3_hwdms_category_map AS cmap

  LEFT JOIN gov3_categories AS c 
  ON c.id = cmap.category_id

  WHERE `cmap`.`element_id` = '34' 
  AND `cmap`.`element_type` = '1' 
  AND `c`.`id` > 0 
  AND c.access IN (1,1,5) 
  AND c.published IN (1)

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.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
executing	0.01 ms
end	0.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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_hwdmediashare/libraries/category.php:511
12	hwdMediaShareCategory->load()	JROOT/components/com_hwdmediashare/models/mediaitem.php:533
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.19 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.022 MB memoria prima della query: 3.372 MB Righe restituite: 1

Query duplicate: #35

SELECT media_type

  FROM gov3_hwdms_ext

  WHERE `id` = 41

Explain

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

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.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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_hwdmediashare/libraries/media.php:501
12	hwdMediaShareMedia::loadMediaType()	JROOT/components/com_hwdmediashare/models/mediaitem.php:541
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.22 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 3.379 MB Righe restituite: 1

Query duplicate: #34

SELECT media_type

  FROM gov3_hwdms_ext

  WHERE `id` = 41

Explain

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

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
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.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_hwdmediashare/libraries/media.php:523
12	hwdMediaShareMedia::loadMediaType()	JROOT/components/com_hwdmediashare/models/mediaitem.php:541
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.25 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.029 MB memoria prima della query: 3.452 MB Righe restituite: 17

SHOW FULL COLUMNS 
  FROM `gov3_users`

Explain

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

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.36 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
executing	0.08 ms
checking permissions	0.05 ms
checking permissions	0.02 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.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.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/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
16	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/components/com_hwdmediashare/models/mediaitem.php:551
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.35 ms Memoria query: 0.025 MB memoria prima della query: 3.482 MB Righe restituite: 1

SELECT *

  FROM `gov3_users`

  WHERE `id` = 99

Explain

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

Profilo

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.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.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.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/components/com_hwdmediashare/models/mediaitem.php:551
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.29 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.024 MB memoria prima della query: 3.494 MB Righe restituite: 1

SELECT `g`.`id`,`g`.`title`

  FROM `gov3_usergroups` AS g

  INNER JOIN `gov3_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 99

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	perasso2.m.group_id	1	100.00	NULL

Profilo

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/components/com_hwdmediashare/models/mediaitem.php:551
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.22 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.022 MB memoria prima della query: 3.502 MB Righe restituite: 1

SELECT COUNT(*)

  FROM gov3_hwdms_subscriptions

  WHERE element_type = '5' 
  AND element_id = '99' 
  AND user_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.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_hwdmediashare/libraries/subscriptions.php:439
12	hwdMediaShareSubscriptions->isSubscribed()	JROOT/components/com_hwdmediashare/models/mediaitem.php:575
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.23 ms Memoria query: 0.022 MB memoria prima della query: 3.511 MB Righe restituite: 0

SELECT id

  FROM gov3_hwdms_favourites

  WHERE element_type = '1' 
  AND element_id = '34' 
  AND user_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.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_hwdmediashare/libraries/favourites.php:415
12	hwdMediaShareFavourites->isFavourite()	JROOT/components/com_hwdmediashare/models/mediaitem.php:587
11	hwdMediaShareModelMediaItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:379
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.29 ms Dopo l'ultima query: 4.91 ms Memoria query: 0.026 MB memoria prima della query: 3.569 MB Righe restituite: 1

SELECT `alias`

  FROM `gov3_hwdms_media`

  WHERE `id` = 34

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	gov3_hwdms_media	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.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_hwdmediashare/libraries/routers/standard.php:281
21	hwdMediaShareRouterStandard->build()	JROOT/components/com_hwdmediashare/router.php:71
20	hwdMediaShareRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_hwdmediashare/libraries/media.php:709
13	hwdMediaShareMedia::getPermalink()	JROOT/components/com_hwdmediashare/views/mediaform/tmpl/default_share.php:35
12	include JROOT/components/com_hwdmediashare/views/mediaform/tmpl/default_share.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:439
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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.25 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.025 MB memoria prima della query: 3.581 MB Righe restituite: 1

SELECT ext

  FROM gov3_hwdms_ext

  WHERE id = '32'

Explain

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

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_hwdmediashare/libraries/files.php:787
16	hwdMediaShareFiles::getExtension()	JROOT/components/com_hwdmediashare/libraries/thumbnails.php:1233
15	hwdMediaShareThumbnails::getElementThumbnail()	JROOT/components/com_hwdmediashare/libraries/thumbnails.php:505
14	hwdMediaShareThumbnails::getMediaThumbnail()	JROOT/components/com_hwdmediashare/libraries/thumbnails.php:151
13	hwdMediaShareThumbnails::thumbnail()	JROOT/components/com_hwdmediashare/views/mediaform/tmpl/default_share.php:41
12	include JROOT/components/com_hwdmediashare/views/mediaform/tmpl/default_share.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_hwdmediashare/views/mediaform/view.html.php:439
9	hwdMediaShareViewMediaForm->share()	JROOT/components/com_hwdmediashare/controllers/mediaform.php:601
8	hwdMediaShareControllerMediaForm->share()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hwdmediashare/hwdmediashare.php:55
6	require_once JROOT/components/com_hwdmediashare/hwdmediashare.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: 8.37 ms Memoria query: 0.022 MB memoria prima della query: 4.016 MB Righe restituite: 0

SELECT uikit

  FROM `gov3_cwgears`

  WHERE url = 'http://vecchiosito.icperasso.edu.it/gallerie/galleria-video.html?task=mediaform.share&id=34&return=aHR0cDovL3ZlY2NoaW9zaXRvLmljcGVyYXNzby5lZHUuaXQvZ2FsbGVyaWUvZ2FsbGVyaWEtdmlkZW8vMzQtcGF0dG8tZWR1Y2F0aXZvLXRlcnJpdG9yaWFsZS5odG1s&tmpl=component'

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.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.02 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
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.31 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 4.023 MB Righe restituite: 0

SELECT uikit_plus

  FROM `gov3_cwgears`

  WHERE url = 'http://vecchiosito.icperasso.edu.it/gallerie/galleria-video.html?task=mediaform.share&id=34&return=aHR0cDovL3ZlY2NoaW9zaXRvLmljcGVyYXNzby5lZHUuaXQvZ2FsbGVyaWUvZ2FsbGVyaWEtdmlkZW8vMzQtcGF0dG8tZWR1Y2F0aXZvLXRlcnJpdG9yaWFsZS5odG1s&tmpl=component'

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.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:427
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

Tempo della query: 1.24 ms Dopo l'ultima query: 1.50 ms Memoria query: 0.042 MB memoria prima della query: 4.085 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 17:23:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-01 17:23:37') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 177 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.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.06 ms
executing	0.64 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
10	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
9	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:37
8	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/plugins/system/cwgears/cwgears.php:732
7	plgSystemCwgears->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]

41 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

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

2 × SELECT COUNT(*) 
  from `gov3_mi_iptable`

2 × SELECT count(*) 
  FROM `gov3_cwtraffic`

2 × SELECT media_type 
  FROM gov3_hwdms_ext

```
1 × SELECT * 
  FROM `gov3_users`
```

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `gov3_contentitem_tag_map` AS m  
  INNER JOIN `gov3_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT field.*,value.`value` , value.`access` 
  FROM gov3_hwdms_fields AS field 
  LEFT JOIN gov3_hwdms_fields_values AS value 
  ON field.`id`=value.`field_id` 
  AND value.`element_id`='34'

1 × SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key 
  FROM gov3_hwdms_files AS a 
  LEFT JOIN gov3_hwdms_media AS m 
  ON m.id = a.element_id

1 × SELECT c.id, c.title 
  FROM gov3_hwdms_category_map AS cmap 
  LEFT JOIN gov3_categories AS c 
  ON c.id = cmap.category_id

1 × SELECT `data` 
  FROM `gov3_session`

```
1 × SELECT * 
  FROM gov3_hwdms_media
```

1 × SELECT COUNT(*) 
  FROM gov3_hwdms_subscriptions

1 × SELECT id 
  FROM gov3_hwdms_favourites

1 × SELECT `alias` 
  FROM `gov3_hwdms_media`

```
1 × SELECT ext 
  FROM gov3_hwdms_ext
```

1 × SELECT uikit 
  FROM `gov3_cwgears`

1 × SELECT uikit_plus 
  FROM `gov3_cwgears`

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `gov3_usergroups` AS g 
  INNER JOIN `gov3_user_usergroup_map` AS m 
  ON m.group_id = g.id

1 × SELECT * 
  FROM gov3_hwdms_config

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

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

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

1 × SELECT botname 
  FROM `gov3_cwtraffic_knownips`

1 × SELECT ip 
  FROM `gov3_cwtraffic_knownips`

1 × SELECT TCOUNT 
  FROM `gov3_cwtraffic_total

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

1 × SELECT count(*) 
  FROM `gov3_extensions`

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

1 × SELECT count(*) 
  FROM `gov3_cwgears_schedule`

1 × SELECT count(*) 
  FROM `gov3_cwgears_schedule

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

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

1 × SELECT id, rules 
  FROM `gov3_viewlevels

1 × SELECT 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

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\":\"8d6a68b8b04588a2000c86e4fbda1f32\"}'

1 × SHOW FULL COLUMNS 
  FROM `gov3_hwdms_config

1 × SHOW FULL COLUMNS 
  FROM `gov3_hwdms_media

1 × SHOW FULL COLUMNS 
  FROM `gov3_users