NewCo Investment

Obiettivi dell'offerta formativa:

La NewCoInvestmentSrl Agenzia formativa accreditata presso la Regione Calabria sta per partire con il primo corso di Ispettore dei centri di controlli privati per la revisione periodica dei veicoli di competenza in rispetto del decreto del Ministero delle Infrastrutture e dei trasporti del 19 Maggio 2017 n. 214 e l’Accordo tra Governo, Regioni e Province autonome di Trento e Bolzano del 17 Aprile 2019 n° 65/CSR.

La figura dell’Ispettore dei centri di controlli privati per la revisione periodica dei veicoli di competenza svolge direttamente il compito di verifica dell'idoneità tecnica del veicolo e pertanto costituisce una figura professionale indispensabile in tutti i centri esercenti il servizio di revisione.

Normativa di riferimento:

Decreto del Ministero delle Infrastrutture e dei trasporti del 19 Maggio 2017 n. 214
Accordo Stato Regione del 17 Aprile 2019 n° 65/CSR

Il corso è articolato in due Moduli.

Modulo A teorico della durata di 120 ore in aula così articolato:

- Modulo A1: Tecnologia dei veicoli circolanti (54 ore)
- Modulo A2: Materiali e propulsione dei veicoli (26 ore)
- Modulo A3: Caratteristiche accessorie dei veicoli (40 ore)
- Esame finale con rilascio di Attestato di frequenza con profitto propedeutico all'accesso al modulo B.

I candidati in possesso di Laurea in Ingegneria sono esonerati dalla frequenza del Modulo A.

Partenza MODULO A:

Termine iscrizioni	Data partenza Corso	Giornate aula
08 Maggio 2020	25 Maggio 2020	Dal Lunedì al Venerdì

Modulo B teorico-pratico della durata di 176 ore in aula ed in officina così articolato:

- Modulo B1: Tecnologia automobilistica (74 ore)
- Modulo B2: Metodi di Prova (70 ore)
- Modulo B3: Procedure amministrative (32 ore)
- Esame finale con rilascio di Attestato di frequenza con profitto propedeutico all'accesso al modulo C.

Prossime date MODULO B:

Termine iscrizioni	Data partenza Corso	Giornate aula
25 Maggio 2020	Dopo l’esame del modulo A	Dal Lunedì al Venerdì

La percentuale massima di assenze tollerata è pari al 20%.

Requisiti per l'iscrizione:

- essere in possesso di uno dei seguenti titoli di studio:

a) Diploma di liceo scientifico
b) Diplomi quinquennali rilasciati da istituti tecnici, settore tecnologico (incluso Geometra).
c) Laurea Triennale in ingegneria meccanica
d) Laurea in ingegneria del vecchio ordinamento o laurea magistrale in ingegneria
e) Diplomi quinquennali di maturità rilasciati dagli Istituti Professionali di Stato del settore Industria/artigianato indirizzo Manutenzione assistenza tecnica
f) Diplomi quadriennali di Istruzione e formazione professionale di cui all'Accordo in Conferenza-Stato-Regioni del 27 Luglio 2011 di Tecnico riparatore di veicoli a motore
g) Altri titoli dichiarati equipollenti nei modi di Legge.

- Esperienza professionale di Tirocinio o lavoro o ricerca, anche in combinazione tra loro, svolti presso:

a) Officine di autoriparazione di cui alla Legge 5 Febbraio 1992, n° 122
b) Centri di controllo
c) Aziende costruttrici di veicoli o loro impianti;
d) Università o Istituti Scolastici Superiori.

Tale durata è di 6 mesi per le lauree e 3 anni per i diplomi.

Il corso prevede il rilascio da parte della Regione Calabria gli Attestati di Frequenza con profitto validi su tutto il territorio nazionale per l'ammissione al successivo esame conclusivo presso il competente Organismo di Supervisione.

Prezzo del corso:

Il prezzo del corso per Ispettore dei centri di controlli privati per la revisione periodica dei veicoli di competenza è il seguente: Modulo A € 1500,00 più Iva , Modulo B € 2.000,00 più

Per le iscrizioni inviare e-mail al seguente indirizzo: Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. oppure telefonare al 333.3336124

NewCo Investment s.r.l. è una agenzia formativa accreditata dalla Regione Calabria per la formazione continua e superiore.

La Sede Legale è sita in Via Pedro Alvares Cabrai S.n.c. - 87036-Rende (Cs).

Contatti:

0984-402117

333-3336124

334-2397716

Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1606499026,
                "last": 1606499026,
                "now": 1606499026
            }
        },
        "registry": {
            "com_installer": {
                "message": "",
                "extension_message": ""
            }
        },
        "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
        }
    }
}

Informazioni profilo

Utilizzo memoria

Query Database

49 query eseguite 97.60 ms

Trovati 8 duplicati!

2 duplicati: #15 #49

2 duplicati: #35 #38

2 duplicati: #36 #39

2 duplicati: #37 #40

Tempo della query: 3.59 ms

SELECT `data`

  FROM `hayuz_session`

  WHERE `session_id` = 'qobfdf203rous1iga3c5r060d1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\session\storage\database.php:44
12	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
11	session_start()	JROOT\libraries\joomla\session\handler\native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT\libraries\joomla\session\handler\native.php:49
9	JSessionHandlerNative->start()	JROOT\libraries\joomla\session\handler\joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT\libraries\joomla\session\session.php:636
7	JSession->_start()	JROOT\libraries\joomla\session\session.php:596
6	JSession->start()	JROOT\libraries\cms\application\cms.php:773
5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:408
2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
1	JFactory::getApplication()	JROOT\index.php:46

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

Tempo della query: 1.60 ms Dopo l'ultima query: 6.97 ms

SELECT `session_id`

  FROM `hayuz_session`

  WHERE `session_id` = 'qobfdf203rous1iga3c5r060d1' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_session	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT\libraries\cms\application\cms.php:176
6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:799
5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:408
2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
1	JFactory::getApplication()	JROOT\index.php:46

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

Tempo della query: 1.86 ms Dopo l'ultima query: 0.26 ms

INSERT INTO `hayuz_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('qobfdf203rous1iga3c5r060d1', 0, 1, '1606499026', 0, '')

Explain

EXPLAIN non possibile sulla query: INSERT INTO `hayuz_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('qobfdf203rous1iga3c5r060d1', 0, 1, '1606499026', 0, '')

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysql->execute()	JROOT\libraries\cms\application\cms.php:212
6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:799
5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:408
2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
1	JFactory::getApplication()	JROOT\index.php:46

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

Tempo della query: 4.32 ms Dopo l'ultima query: 6.09 ms

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

  FROM `hayuz_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_extensions	ref	extension	extension	82	const	30	100.00	Using index condition

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
9	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:152
7	JCacheControllerCallback->get()	JROOT\libraries\cms\component\helper.php:448
6	JComponentHelper::load()	JROOT\libraries\cms\component\helper.php:43
5	JComponentHelper::getComponent()	JROOT\libraries\cms\component\helper.php:120
4	JComponentHelper::getParams()	JROOT\libraries\cms\application\site.php:589
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 2.20 ms Dopo l'ultima query: 3.24 ms

SELECT b.id

  FROM hayuz_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:835
9	JAccess::getGroupsByUser()	JROOT\libraries\joomla\access\access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT\libraries\joomla\user\user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT\libraries\cms\plugin\helper.php:296
6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:599
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.87 ms Dopo l'ultima query: 1.39 ms

SELECT id, rules

  FROM `hayuz_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_viewlevels	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	100.00	NULL

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT\libraries\joomla\access\access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT\libraries\joomla\user\user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT\libraries\cms\plugin\helper.php:296
6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:599
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.19 ms Dopo l'ultima query: 0.25 ms

SELECT folder AS type, element AS name, params

  FROM hayuz_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_extensions	ref	extension	extension	82	const	56	100.00	Using index condition; Using where; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\plugin\helper.php:310
6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:599
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 9.77 ms Dopo l'ultima query: 42.51 ms

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 hayuz_menu AS m

  LEFT JOIN hayuz_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	16	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql1063178_2.m.component_id	1	100.00	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\menu\site.php:86
14	JMenuSite->load()	JROOT\libraries\cms\menu\menu.php:74
13	JMenu->__construct()	JROOT\libraries\cms\menu\site.php:57
12	JMenuSite->__construct()	JROOT\libraries\cms\menu\menu.php:145
11	JMenu::getInstance()	JROOT\libraries\cms\application\cms.php:439
10	JApplicationCms->getMenu()	JROOT\libraries\cms\application\site.php:272
9	JApplicationSite->getMenu()	JROOT\libraries\cms\router\site.php:57
8	JRouterSite->__construct()	JROOT\libraries\cms\router\router.php:197
7	JRouter::getInstance()	JROOT\libraries\cms\application\cms.php:535
6	JApplicationCms::getRouter()	JROOT\libraries\cms\application\site.php:407
5	JApplicationSite::getRouter()	JROOT\libraries\cms\application\cms.php:1115
4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.15 ms Dopo l'ultima query: 20.35 ms

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

  FROM `hayuz_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1650
13	JDatabaseDriver->loadObject()	Chiamata uguale alla linea sottostante.
12	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:152
11	JCacheControllerCallback->get()	JROOT\libraries\cms\library\helper.php:156
10	JLibraryHelper::_load()	JROOT\libraries\cms\library\helper.php:47
9	JLibraryHelper::getLibrary()	JROOT\libraries\cms\library\helper.php:90
8	JLibraryHelper::getParams()	JROOT\libraries\cms\version\version.php:274
7	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:755
6	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
5	JFactory::getDocument()	JROOT\libraries\joomla\application\web.php:977
4	JApplicationWeb->loadDocument()	JROOT\libraries\cms\application\site.php:130
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.16 ms Dopo l'ultima query: 0.51 ms

UPDATE `hayuz_extensions`

  SET `params` = '{\"mediaversion\":\"ad69c6c8c2d4c43936df689bcaea1dfb\"}'

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysql->execute()	JROOT\libraries\cms\library\helper.php:119
9	JLibraryHelper::saveParams()	JROOT\libraries\cms\version\version.php:325
8	JVersion->setMediaVersion()	JROOT\libraries\cms\version\version.php:284
7	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:755
6	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
5	JFactory::getDocument()	JROOT\libraries\joomla\application\web.php:977
4	JApplicationWeb->loadDocument()	JROOT\libraries\cms\application\site.php:130
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 2.67 ms Dopo l'ultima query: 4.88 ms

SELECT *

  FROM hayuz_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_languages	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using where; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\language\helper.php:164
5	JLanguageHelper::getLanguages()	JROOT\libraries\cms\application\site.php:329
4	JApplicationSite->getParams()	JROOT\libraries\cms\application\site.php:135
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 2.16 ms Dopo l'ultima query: 0.60 ms

SELECT id, home, template, s.params

  FROM hayuz_template_styles as s

  LEFT JOIN hayuz_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	Sql1063178_2.s.template,const	1	100.00	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\application\site.php:484
4	JApplicationSite->getTemplate()	JROOT\libraries\cms\application\site.php:165
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 2.40 ms Dopo l'ultima query: 25.34 ms

SHOW FULL COLUMNS 
  FROM `hayuz_assets`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
18	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
17	JTable->__construct()	JROOT\libraries\joomla\table\asset.php:60
16	JTableAsset->__construct()	JROOT\libraries\joomla\table\table.php:308
15	JTable::getInstance()	JROOT\libraries\joomla\access\access.php:696
14	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:555
13	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:435
10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.12 ms Dopo l'ultima query: 3.17 ms

SELECT *

  FROM hayuz_assets

  WHERE `id` = '1'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:719
15	JTable->load()	JROOT\libraries\joomla\access\access.php:697
14	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:555
13	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:435
10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.32 ms Dopo l'ultima query: 0.28 ms

Query duplicate: #49

SELECT a.rules

  FROM hayuz_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:652
13	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:435
10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.94 ms Dopo l'ultima query: 2.46 ms

SELECT element

  FROM hayuz_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_extensions	ref	extension	extension	82	const	30	100.00	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:413
15	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
14	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
13	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:435
10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.32 ms Dopo l'ultima query: 0.35 ms

SELECT a.name, a.rules

  FROM hayuz_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	idx_asset_name	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	97	31.96	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT\libraries\joomla\access\access.php:441
15	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
14	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
13	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:435
10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:262
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 5.53 ms Dopo l'ultima query: 4.34 ms

SHOW FULL COLUMNS 
  FROM `hayuz_content`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
13	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
12	JTable->__construct()	JROOT\libraries\legacy\table\content.php:31
11	JTableContent->__construct()	JROOT\libraries\joomla\table\table.php:308
10	JTable::getInstance()	JROOT\components\com_content\models\article.php:264
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 2.70 ms Dopo l'ultima query: 8.98 ms

SELECT *

  FROM hayuz_content

  WHERE `id` = '1'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:719
10	JTable->load()	JROOT\components\com_content\models\article.php:265
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 2.17 ms Dopo l'ultima query: 0.33 ms

UPDATE hayuz_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_content	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\table\table.php:1228
10	JTable->hit()	JROOT\components\com_content\models\article.php:266
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 5.92 ms Dopo l'ultima query: 5.76 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM hayuz_content AS a

  LEFT JOIN hayuz_categories AS c 
  on c.id = a.catid

  LEFT JOIN hayuz_users AS u 
  on u.id = a.created_by

  LEFT JOIN hayuz_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN hayuz_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM hayuz_categories AS cat JOIN hayuz_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-27 17:43:47') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-27 17:43:47') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	const	5	100.00	Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	3	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	18	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT\components\com_content\models\article.php:159
12	ContentModelArticle->getItem()	JROOT\libraries\legacy\view\legacy.php:408
11	JViewLegacy->get()	JROOT\components\com_content\views\article\view.html.php:42
10	ContentViewArticle->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 2.65 ms Dopo l'ultima query: 10.41 ms

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM hayuz_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM hayuz_categories AS cat JOIN hayuz_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN hayuz_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=2

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	18	72.22	Using where
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	Sql1063178_2.c.id	5	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	3	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	18	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
13	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
12	JCategories->get()	JROOT\components\com_content\helpers\route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT\components\com_content\views\article\view.html.php:71
10	ContentViewArticle->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 2.95 ms Dopo l'ultima query: 1.31 ms

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

  FROM `hayuz_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\helper\tags.php:435
11	JHelperTags->getItemTags()	JROOT\components\com_content\views\article\view.html.php:156
10	ContentViewArticle->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 7.78 ms Dopo l'ultima query: 71.60 ms

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM hayuz_modules AS m

  LEFT JOIN hayuz_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN hayuz_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 <= '2020-11-27 17:43:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-27 17:43:47') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	12	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql1063178_2.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	Sql1063178_2.m.module,const	1	100.00	Using index condition; Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
13	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
12	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:152
11	JCacheControllerCallback->get()	JROOT\libraries\cms\module\helper.php:425
10	JModuleHelper::getModuleList()	JROOT\libraries\cms\module\helper.php:361
9	JModuleHelper::load()	JROOT\libraries\cms\module\helper.php:34
8	JModuleHelper::getModule()	JROOT\templates\pt_honbect_free\index.php:43
7	require JROOT\templates\pt_honbect_free\index.php	JROOT\libraries\joomla\document\html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT\libraries\joomla\document\html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT\libraries\joomla\document\html.php:455
4	JDocumentHtml->parse()	JROOT\libraries\cms\application\cms.php:1072
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.26 ms Dopo l'ultima query: 51.13 ms

LOCK TABLES `hayuz_extensions` WRITE

Explain

EXPLAIN non possibile sulla query: LOCK TABLES `hayuz_extensions` WRITE

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver\mysqli.php:543
9	JDatabaseDriverMysqli->lockTable()	JROOT\plugins\system\updatenotification\updatenotification.php:79
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.67 ms Dopo l'ultima query: 0.17 ms

UPDATE `hayuz_extensions`

  SET `params` = '{\"lastrun\":1606499027}'

  WHERE `type` = 'plugin' 
  AND `folder` = 'system' 
  AND `element` = 'updatenotification'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_extensions	range	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysql->execute()	JROOT\plugins\system\updatenotification\updatenotification.php:90
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

[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: 4.52 ms

UNLOCK TABLES

Explain

EXPLAIN non possibile sulla query: UNLOCK TABLES

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver\mysqli.php:918
9	JDatabaseDriverMysqli->unlockTables()	JROOT\plugins\system\updatenotification\updatenotification.php:104
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 3.31 ms Dopo l'ultima query: 3.11 ms

SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query

  FROM `hayuz_update_sites` AS `a`

  INNER JOIN hayuz_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

  WHERE a.enabled = 1 
  AND b.extension_id IN (700)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	100.00	Using where; Using temporary
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	8	Sql1063178_2.a.update_site_id,const	1	100.00	Using index; Distinct

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1494
11	JDatabaseDriver->loadAssocList()	JROOT\libraries\joomla\updater\updater.php:229
10	JUpdater->getUpdateSites()	JROOT\libraries\joomla\updater\updater.php:119
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 6.01 ms Dopo l'ultima query: 0.41 ms

SELECT DISTINCT update_site_id

  FROM hayuz_updates

  WHERE `update_site_id` IN (
SELECT update_site_id

  FROM hayuz_update_sites

  WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= '1606477427')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_updates	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	156	100.00	Using temporary
1	SIMPLE	hayuz_update_sites	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	83.33	Using where; Distinct; Using join buffer (Block Nested Loop)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\updater\updater.php:400
10	JUpdater->getSitesWithUpdates()	JROOT\libraries\joomla\updater\updater.php:132
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.60 ms Dopo l'ultima query: 5.13 ms

SELECT `name`

  FROM `hayuz_update_sites`

  WHERE `update_site_id` = '1'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\updater\updateadapter.php:188
13	JUpdateAdapter->getUpdateSiteName()	JROOT\libraries\joomla\updater\updateadapter.php:215
12	JUpdateAdapter->getUpdateSiteResponse()	JROOT\libraries\joomla\updater\adapters\collection.php:223
11	JUpdaterCollection->findUpdate()	JROOT\libraries\joomla\updater\updater.php:267
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.57 ms Dopo l'ultima query: 0.23 ms

UPDATE `hayuz_update_sites`

  SET `enabled` = '0'

  WHERE `update_site_id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_update_sites	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\updater\updateadapter.php:153
13	JUpdateAdapter->toggleUpdateSite()	JROOT\libraries\joomla\updater\updateadapter.php:238
12	JUpdateAdapter->getUpdateSiteResponse()	JROOT\libraries\joomla\updater\adapters\collection.php:223
11	JUpdaterCollection->findUpdate()	JROOT\libraries\joomla\updater\updater.php:267
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.80 ms Dopo l'ultima query: 1860.99 ms

UPDATE `hayuz_update_sites`

  SET `enabled` = '1'

  WHERE `update_site_id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_update_sites	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\updater\updateadapter.php:153
13	JUpdateAdapter->toggleUpdateSite()	JROOT\libraries\joomla\updater\updateadapter.php:254
12	JUpdateAdapter->getUpdateSiteResponse()	JROOT\libraries\joomla\updater\adapters\collection.php:223
11	JUpdaterCollection->findUpdate()	JROOT\libraries\joomla\updater\updater.php:267
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.32 ms Dopo l'ultima query: 1.99 ms

SHOW FULL COLUMNS 
  FROM `hayuz_updates`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
18	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
17	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
16	JTable->__construct()	JROOT\libraries\joomla\table\update.php:31
15	JTableUpdate->__construct()	JROOT\libraries\joomla\table\table.php:308
14	JTable::getInstance()	JROOT\libraries\joomla\updater\adapters\collection.php:117
13	JUpdaterCollection->_startElement()	Chiamata uguale alla linea sottostante.
12	xml_parse()	JROOT\libraries\joomla\updater\adapters\collection.php:234
11	JUpdaterCollection->findUpdate()	JROOT\libraries\joomla\updater\updater.php:267
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.11 ms Dopo l'ultima query: 4.72 ms

SHOW FULL COLUMNS 
  FROM `hayuz_extensions`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
15	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
14	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
13	JTable->__construct()	JROOT\libraries\joomla\table\extension.php:31
12	JTableExtension->__construct()	JROOT\libraries\joomla\table\table.php:308
11	JTable::getInstance()	JROOT\libraries\joomla\updater\updater.php:311
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.44 ms Dopo l'ultima query: 0.37 ms

Query duplicate: #38

SELECT `update_id`

  FROM `hayuz_updates`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_updates	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	156	100.00	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\table\update.php:110
11	JTableUpdate->find()	JROOT\libraries\joomla\updater\updater.php:321
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.92 ms Dopo l'ultima query: 0.26 ms

Query duplicate: #39

SELECT `extension_id`

  FROM `hayuz_extensions`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_extensions	ref	element_clientid,element_folder_clientid,extension	extension	887	const,const,const,const	1	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.11 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\table\extension.php:109
11	JTableExtension->find()	JROOT\libraries\joomla\updater\updater.php:331
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.69 ms Dopo l'ultima query: 0.32 ms

Query duplicate: #40

SELECT *

  FROM hayuz_updates

  WHERE `update_id` = '1'

Explain

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

Profilo

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.07 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
12	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:719
11	JTable->load()	JROOT\libraries\joomla\updater\updater.php:356
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.82 ms Dopo l'ultima query: 0.34 ms

Query duplicate: #35

SELECT `update_id`

  FROM `hayuz_updates`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_updates	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	156	100.00	Using where

Profilo

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\table\update.php:110
11	JTableUpdate->find()	JROOT\libraries\joomla\updater\updater.php:321
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.57 ms Dopo l'ultima query: 0.25 ms

Query duplicate: #36

SELECT `extension_id`

  FROM `hayuz_extensions`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_extensions	ref	element_clientid,element_folder_clientid,extension	extension	887	const,const,const,const	1	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\table\extension.php:109
11	JTableExtension->find()	JROOT\libraries\joomla\updater\updater.php:331
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.54 ms Dopo l'ultima query: 0.29 ms

Query duplicate: #37

SELECT *

  FROM hayuz_updates

  WHERE `update_id` = '1'

Explain

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

Profilo

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
12	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:719
11	JTable->load()	JROOT\libraries\joomla\updater\updater.php:356
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.62 ms Dopo l'ultima query: 0.38 ms

INSERT INTO `hayuz_updates`
(`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`detailsurl`,`infourl`,`extra_query`) 
  VALUES 
('1','Joomla','','joomla','file','','0','3.9.23','https://update.joomla.org/core/sts/extension_sts.xml','','')

Explain

EXPLAIN non possibile sulla query: INSERT INTO `hayuz_updates` (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`detailsurl`,`infourl`,`extra_query`) VALUES ('1','Joomla','','joomla','file','','0','3.9.23','https://update.joomla.org/core/sts/extension_sts.xml','','')

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.03 ms
Waiting for query cache lock	0.00 ms
update	0.02 ms
end	0.00 ms
query end	0.04 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1409
11	JDatabaseDriver->insertObject()	JROOT\libraries\joomla\table\table.php:793
10	JTable->store()	JROOT\libraries\joomla\updater\updater.php:160
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.60 ms Dopo l'ultima query: 0.25 ms

UPDATE `hayuz_update_sites`

  SET `last_check_timestamp` = '1606499029'

  WHERE `update_site_id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_update_sites	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
updating	0.02 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.00 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\updater\updater.php:429
10	JUpdater->updateLastCheckTimestamp()	JROOT\libraries\joomla\updater\updater.php:165
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.59 ms Dopo l'ultima query: 0.98 ms

SELECT `name`

  FROM `hayuz_update_sites`

  WHERE `update_site_id` = '2'

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\updater\updateadapter.php:188
13	JUpdateAdapter->getUpdateSiteName()	JROOT\libraries\joomla\updater\updateadapter.php:215
12	JUpdateAdapter->getUpdateSiteResponse()	JROOT\libraries\joomla\updater\adapters\collection.php:223
11	JUpdaterCollection->findUpdate()	JROOT\libraries\joomla\updater\updater.php:267
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.63 ms Dopo l'ultima query: 0.22 ms

UPDATE `hayuz_update_sites`

  SET `enabled` = '0'

  WHERE `update_site_id` = '2'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_update_sites	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.03 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\updater\updateadapter.php:153
13	JUpdateAdapter->toggleUpdateSite()	JROOT\libraries\joomla\updater\updateadapter.php:238
12	JUpdateAdapter->getUpdateSiteResponse()	JROOT\libraries\joomla\updater\adapters\collection.php:223
11	JUpdaterCollection->findUpdate()	JROOT\libraries\joomla\updater\updater.php:267
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.72 ms Dopo l'ultima query: 162.35 ms

UPDATE `hayuz_update_sites`

  SET `enabled` = '1'

  WHERE `update_site_id` = '2'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_update_sites	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.02 ms
updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.00 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\updater\updateadapter.php:153
13	JUpdateAdapter->toggleUpdateSite()	JROOT\libraries\joomla\updater\updateadapter.php:254
12	JUpdateAdapter->getUpdateSiteResponse()	JROOT\libraries\joomla\updater\adapters\collection.php:223
11	JUpdaterCollection->findUpdate()	JROOT\libraries\joomla\updater\updater.php:267
10	JUpdater->getUpdateObjectsForSite()	JROOT\libraries\joomla\updater\updater.php:151
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.61 ms Dopo l'ultima query: 0.37 ms

UPDATE `hayuz_update_sites`

  SET `last_check_timestamp` = '1606499029'

  WHERE `update_site_id` = '2'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_update_sites	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.03 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.00 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\updater\updater.php:429
10	JUpdater->updateLastCheckTimestamp()	JROOT\libraries\joomla\updater\updater.php:165
9	JUpdater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:123
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 1.16 ms Dopo l'ultima query: 5.76 ms

SELECT u.*,`e`.`manifest_cache`

  FROM `hayuz_updates` AS `u`

  LEFT JOIN `hayuz_extensions` AS `e` 
  ON `e`.`extension_id` = `u`.`extension_id`

  WHERE `u`.`extension_id` != '0' 
  AND `u`.`extension_id` = '700'

  ORDER BY `u`.`name` asc 
  LIMIT 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	156	100.00	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql1063178_2.u.extension_id	1	100.00	NULL

Profilo

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.30 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT\libraries\legacy\model\legacy.php:310
11	JModelLegacy->_getList()	JROOT\administrator\components\com_installer\models\update.php:216
10	InstallerModelUpdate->_getList()	JROOT\libraries\legacy\model\list.php:183
9	JModelList->getItems()	JROOT\plugins\system\updatenotification\updatenotification.php:137
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

Tempo della query: 0.74 ms Dopo l'ultima query: 0.39 ms

SELECT id

  FROM hayuz_assets

  WHERE parent_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hayuz_assets	ref	idx_parent_id	idx_parent_id	4	const	1	100.00	Using index

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.07 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\table\nested.php:1210
10	JTableNested->getRootId()	JROOT\plugins\system\updatenotification\updatenotification.php:296
9	PlgSystemUpdatenotification->getSuperUsers()	JROOT\plugins\system\updatenotification\updatenotification.php:187
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

[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.23 ms

Query duplicate: #15

SELECT a.rules

  FROM hayuz_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profilo

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:652
10	JAccess::getAssetRules()	JROOT\plugins\system\updatenotification\updatenotification.php:297
9	PlgSystemUpdatenotification->getSuperUsers()	JROOT\plugins\system\updatenotification\updatenotification.php:187
8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:69
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1092
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
1	JApplicationCms->execute()	JROOT\index.php:49

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

40 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

2 × SELECT `extension_id`
 
  FROM `hayuz_extensions`

2 × SELECT `name`
 
  FROM `hayuz_update_sites`

2 × SELECT a.rules
 
  FROM hayuz_assets AS a

```
2 × SELECT *
 
  FROM hayuz_updates
```

2 × SELECT `update_id`
 
  FROM `hayuz_updates`

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

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

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

```
1 × SELECT id
 
  FROM hayuz_assets
```

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
 
  FROM hayuz_categories as c
 
  LEFT JOIN  (SELECT cat.id as id 
  FROM hayuz_categories AS cat JOIN hayuz_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
 
  FROM `hayuz_update_sites` AS `a`
 
  INNER JOIN hayuz_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
 
  FROM hayuz_content AS a
 
  LEFT JOIN hayuz_categories AS c 
  on c.id = a.catid
 
  LEFT JOIN hayuz_users AS u 
  on u.id = a.created_by
 
  LEFT JOIN hayuz_categories as parent 
  ON parent.id = c.parent_id
 
  LEFT JOIN hayuz_content_rating AS v 
  ON a.id = v.content_id
 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM hayuz_categories AS cat JOIN hayuz_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT DISTINCT update_site_id
 
  FROM hayuz_updates

1 × SELECT u.*,`e`.`manifest_cache`
 
  FROM `hayuz_updates` AS `u`
 
  LEFT JOIN `hayuz_extensions` AS `e` 
  ON `e`.`extension_id` = `u`.`extension_id`

1 × SELECT a.name, a.rules
 
  FROM hayuz_assets AS a

1 × SELECT folder AS type, element AS name, params
 
  FROM hayuz_extensions

1 × SELECT id, rules
 
  FROM `hayuz_viewlevels

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

1 × SELECT `session_id`
 
  FROM `hayuz_session`

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 hayuz_menu AS m
 
  LEFT JOIN hayuz_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT *
 
  FROM hayuz_languages
```

1 × SELECT `data`
 
  FROM `hayuz_session`

1 × SELECT element
 
  FROM hayuz_extensions

```
1 × SELECT *
 
  FROM hayuz_assets
```

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

```
1 × SELECT *
 
  FROM hayuz_content
```

ALTRE tabelle:

2 × UPDATE `hayuz_update_sites`
 
  SET `enabled` = '1'

2 × UPDATE `hayuz_update_sites`
 
  SET `enabled` = '0'

2 × UPDATE `hayuz_update_sites`
 
  SET `last_check_timestamp` = '1606499029'

1 × SHOW FULL COLUMNS 
  FROM `hayuz_updates

1 × SHOW FULL COLUMNS 
  FROM `hayuz_extensions

1 × INSERT INTO `hayuz_updates`
 (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`detailsurl`,`infourl`,`extra_query`) 
  VALUES 
 ('1','Joomla','','joomla','file','','0','3.9.23','https://update.joomla.org/core/sts/extension_sts.xml','',''

```
1 × UNLOCK TABLE
```

1 × UPDATE `hayuz_extensions`
 
  SET `params` = '{\"lastrun\":1606499027}'

1 × SHOW FULL COLUMNS 
  FROM `hayuz_assets

1 × UPDATE `hayuz_extensions`
 
  SET `params` = '{\"mediaversion\":\"ad69c6c8c2d4c43936df689bcaea1dfb\"}'

1 × SHOW FULL COLUMNS 
  FROM `hayuz_content

1 × UPDATE hayuz_content
 
  SET `hits` = (`hits` + 1)

1 × LOCK TABLES `hayuz_extensions` WRIT

1 × INSERT INTO `hayuz_session`
 (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
 ('qobfdf203rous1iga3c5r060d1', 0, 1, '1606499026', 0, ''

NewCo Investment

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

49 query eseguite 97.60 ms

Trovati 8 duplicati!

40 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: