Formazione per Tecnico Esperto Gestione dell’Energia

OBIETTIVI CORSO E ARGOMENTI

Il percorso formativo si rivolge a coloro che intendono acquisire conoscenze ed esperienze come tecnico esperto delle gestione dell’energia. Durante il corso verranno affrontati:: il tema dell’energia, distinguendo tra rinnovabile e non, i sistemi e i vettori energetici. Ad ogni tipo di fonte rinnovabile – solare, eolica, di terra o di mare, biomasse – sarà dedicata un’unità didattica specifica in modo da approfondirne l’uso all’interno di una progettazione che tenga conto della sostenibilità, di un consumo energetico ragionato e del risparmio energetico.

Saranno approfondite le leggi in vigore – italiane ed europee – che ogni esperto in gestione dell’energia deve conoscere per sapere a quali strumenti economici e finanziari fare riferimento nella valutazione di progetti energetici. Nell’ultima parte del corso saranno previste una serie di esercitazioni, attraverso il quale ogni corsista imparerà a dimensionare e progettare impianti per la produzione di energia da fonti rinnovabili e a sviluppare una diagnosi energetica.

SCHEDA TECNICA

• Durata corso: 40 ore, Il percorso formativo si articola in 3 moduli, MODULO BASE (16 ore), MODULO CIVILE (12 ore) MODULO INDUSTRIALE (12 ore) per un totale di 40 ore (10 lezioni da 4 ore di formazione

• Periodicità di aggiornamento: 5 anni

• Formazione in aula/in e-learning

• Attestato: al termine del corso e con il superamento del test finale viene rilasciato un attestato di frequenza

Contattaci

Su di noi

Antares Project srl nasce nel 2019 da un’idea imprenditoriale dei suoi soci con l’obiettivo primario di creare una società multi servizi assolutamente unica nel panorama locale e nazionale.

Sfruttando l’elevata esperienza e competenza dei soci fondatori nei vari settori industriali, Antares Project srl è così in grado di rispondere alle più varie e singolari esigenze dei suo clienti, offrendo servizi come corsi di formazione, assistenza alle imprese, progettazione ed altro.

Indirizzo

Antares Project srl

Via E. Azimonti 54

Marsicovetere (PZ)

85050

info@pec.antares-project.it

info@antares-project.it

+39 351 674 6696

Console Debug Joomla!

Sessione

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

Tempo

Memoria

Tempo: 67.59 ms / 67.59 ms Memoria: 0.049 MB / 0.40 MB Application: afterLoad

Tempo: 561.66 ms / 629.25 ms Memoria: 1.223 MB / 1.62 MB Application: afterInitialise

Tempo: 37.43 ms / 666.69 ms Memoria: 0.264 MB / 1.89 MB Application: afterRoute

Tempo: 11.49 ms / 678.18 ms Memoria: 0.057 MB / 1.94 MB Application: beforeRenderComponent com_content

Tempo: 15.01 ms / 693.19 ms Memoria: 0.157 MB / 2.10 MB Application: Start JAccess::getAssetRules Old (1)

Tempo: 2.89 ms / 696.07 ms Memoria: 0.019 MB / 2.12 MB Application: Finish JAccess::getAssetRules Old (1)

Tempo: 0.16 ms / 696.23 ms Memoria: 0.000 MB / 2.11 MB Application: Start JAccess::preload(components)

Tempo: 7.79 ms / 704.02 ms Memoria: 0.176 MB / 2.29 MB Application: Finish JAccess::preload(components)

Tempo: 50.91 ms / 754.93 ms Memoria: 0.297 MB / 2.59 MB Application: beforeRenderModule mod_easyquickcontact (Easy Quick Contact)

Tempo: 10.76 ms / 765.69 ms Memoria: 0.021 MB / 2.61 MB Application: afterRenderModule mod_easyquickcontact (Easy Quick Contact)

Tempo: 37.09 ms / 802.78 ms Memoria: 0.247 MB / 2.86 MB Application: afterRenderComponent com_content

Tempo: 11.23 ms / 814.01 ms Memoria: 0.018 MB / 2.87 MB Application: afterDispatch

Tempo: 2.49 ms / 816.49 ms Memoria: 0.049 MB / 2.92 MB Application: beforeRenderModule mod_custom (Su di noi)

Tempo: 5.05 ms / 821.55 ms Memoria: 0.006 MB / 2.93 MB Application: afterRenderModule mod_custom (Su di noi)

Tempo: 0.05 ms / 821.59 ms Memoria: 0.000 MB / 2.93 MB Application: beforeRenderModule mod_custom (Indirizzo)

Tempo: 0.21 ms / 821.80 ms Memoria: 0.004 MB / 2.93 MB Application: afterRenderModule mod_custom (Indirizzo)

Tempo: 0.05 ms / 821.85 ms Memoria: 0.000 MB / 2.93 MB Application: beforeRenderModule mod_custom (Logo footer)

Tempo: 0.16 ms / 822.01 ms Memoria: 0.005 MB / 2.94 MB Application: afterRenderModule mod_custom (Logo footer)

Tempo: 17.22 ms / 839.23 ms Memoria: 0.095 MB / 3.03 MB Application: beforeRenderModule mod_custom (Logo Left)

Tempo: 1.45 ms / 840.68 ms Memoria: 0.005 MB / 3.04 MB Application: afterRenderModule mod_custom (Logo Left)

Tempo: 1.08 ms / 841.76 ms Memoria: 0.003 MB / 3.04 MB Application: beforeRenderModule mod_menu (Main Menu)

Tempo: 7.56 ms / 849.33 ms Memoria: 0.022 MB / 3.06 MB Application: afterRenderModule mod_menu (Main Menu)

Tempo: 8.75 ms / 858.07 ms Memoria: 0.015 MB / 3.08 MB Application: beforeRenderModule mod_custom (Logo Mobile)

Tempo: 0.19 ms / 858.26 ms Memoria: 0.004 MB / 3.08 MB Application: afterRenderModule mod_custom (Logo Mobile)

Tempo: 2.78 ms / 861.05 ms Memoria: 0.002 MB / 3.08 MB Application: beforeRenderModule mod_custom (Copyright)

Tempo: 0.17 ms / 861.22 ms Memoria: 0.004 MB / 3.09 MB Application: afterRenderModule mod_custom (Copyright)

Tempo: 0.05 ms / 861.27 ms Memoria: 0.000 MB / 3.09 MB Application: beforeRenderModule mod_custom (Social Icons)

Tempo: 0.16 ms / 861.43 ms Memoria: 0.004 MB / 3.09 MB Application: afterRenderModule mod_custom (Social Icons)

Tempo: 0.71 ms / 862.14 ms Memoria: 0.003 MB / 3.09 MB Application: beforeRenderModule mod_menu (Main Menu Offcanvas)

Tempo: 0.78 ms / 862.92 ms Memoria: 0.006 MB / 3.10 MB Application: afterRenderModule mod_menu (Main Menu Offcanvas)

Tempo: 141.80 ms / 1004.72 ms Memoria: 0.173 MB / 3.27 MB Application: afterRender

Query totali del database: 83.79 ms

Utilizzo memoria

Query Database

46 query eseguite 83.79 ms

Trovati 4 duplicati!

2 duplicati: #9 #10

2 duplicati: #14 #16

Tempo della query: 1.06 ms Memoria query: 0.022 MB memoria prima della query: 0.674 MB Righe restituite: 0

SELECT `data`

  FROM `w2bao_session`

  WHERE `session_id` = '8qnvctvalcoivc0p132hpeep7c'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->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.77 ms Dopo l'ultima query: 5.38 ms Memoria query: 0.003 MB memoria prima della query: 0.691 MB

DELETE 

  FROM `w2bao_session`

  WHERE `time` < '1734944315'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	w2bao_session	NULL	range	time	time	59	const	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
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: 0.68 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.019 MB memoria prima della query: 0.696 MB Righe restituite: 0

SELECT `session_id`

  FROM `w2bao_session`

  WHERE `session_id` = '8qnvctvalcoivc0p132hpeep7c' 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->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: 0.69 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.003 MB memoria prima della query: 0.701 MB

INSERT INTO `w2bao_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('8qnvctvalcoivc0p132hpeep7c', 0, 1, '1734945215', 0, '')

Explain

EXPLAIN non possibile sulla query: INSERT INTO `w2bao_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('8qnvctvalcoivc0p132hpeep7c', 0, 1, '1734945215', 0, '')

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->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: 2.13 ms Dopo l'ultima query: 5.64 ms Memoria query: 0.022 MB memoria prima della query: 0.723 MB Righe restituite: 32

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

  FROM `w2bao_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_extensions	NULL	ref	extension	extension	82	const	32	100.00	NULL

Profilo

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

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	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: 1.31 ms Dopo l'ultima query: 3.77 ms Memoria query: 0.021 MB memoria prima della query: 0.738 MB Righe restituite: 1

SELECT b.id

  FROM w2bao_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->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.12 ms Dopo l'ultima query: 2.05 ms Memoria query: 0.021 MB memoria prima della query: 0.742 MB Righe restituite: 3

SELECT id, rules

  FROM `w2bao_viewlevels`

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->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: 3.25 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.023 MB memoria prima della query: 0.750 MB Righe restituite: 49

SELECT folder AS type, element AS name, params

  FROM w2bao_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_extensions	NULL	ref	extension	extension	82	const	63	0.62	Using index condition; Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->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: 1.19 ms Dopo l'ultima query: 47.87 ms Memoria query: 0.023 MB memoria prima della query: 1.154 MB Righe restituite: 1

Query duplicate: #10

SELECT template

  FROM w2bao_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	33.33	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
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: 0.32 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.023 MB memoria prima della query: 1.161 MB Righe restituite: 1

Query duplicate: #9

SELECT template

  FROM w2bao_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	33.33	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
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.00 ms Dopo l'ultima query: 10.17 ms Memoria query: 0.021 MB memoria prima della query: 1.289 MB Righe restituite: 2

SELECT extension, file, type

  FROM w2bao_rokcommon_configs

  ORDER BY priority

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
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: 11.45 ms Dopo l'ultima query: 23.15 ms Memoria query: 0.025 MB memoria prima della query: 1.432 MB Righe restituite: 17

SHOW FULL COLUMNS 
  FROM `w2bao_extensions`

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	9.79 ms
checking permissions	0.01 ms
Opening tables	0.32 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.02 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
12	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
11	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
10	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:308
9	JTable::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
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.34 ms Dopo l'ultima query: 2.02 ms Memoria query: 0.021 MB memoria prima della query: 1.459 MB Righe restituite: 1

SELECT `extension_id`

  FROM `w2bao_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
9	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
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: 0.86 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 1.466 MB Righe restituite: 1

Query duplicate: #16

SELECT *

  FROM w2bao_extensions

  WHERE `extension_id` = '10057'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
9	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
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.28 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 1.470 MB Righe restituite: 1

SELECT `extension_id`

  FROM `w2bao_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
9	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
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: 0.48 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.021 MB memoria prima della query: 1.476 MB Righe restituite: 1

Query duplicate: #14

SELECT *

  FROM w2bao_extensions

  WHERE `extension_id` = '10057'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
9	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
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: 5.40 ms Dopo l'ultima query: 380.04 ms Memoria query: 0.067 MB memoria prima della query: 1.634 MB Righe restituite: 38

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

  LEFT JOIN w2bao_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	1	5.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1535287_1.m.component_id	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->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.53 ms Dopo l'ultima query: 29.56 ms Memoria query: 0.022 MB memoria prima della query: 1.905 MB Righe restituite: 1

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

  FROM `w2bao_extensions`

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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	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.37 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.005 MB memoria prima della query: 1.895 MB

UPDATE `w2bao_extensions`

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	w2bao_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->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: 1.32 ms Dopo l'ultima query: 3.13 ms Memoria query: 0.019 MB memoria prima della query: 1.931 MB Righe restituite: 1

SELECT *

  FROM w2bao_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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: 1.65 ms Dopo l'ultima query: 0.62 ms Memoria query: 0.019 MB memoria prima della query: 1.939 MB Righe restituite: 2

SELECT id, home, template, s.params

  FROM w2bao_template_styles as s

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	3	1.67	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template	idx_template	202	Sql1535287_1.e.element	2	33.33	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysqli->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: 1.82 ms Dopo l'ultima query: 12.40 ms Memoria query: 0.027 MB memoria prima della query: 2.073 MB Righe restituite: 8

SHOW FULL COLUMNS 
  FROM `w2bao_assets`

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.43 ms
checking permissions	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->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: 0.87 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.024 MB memoria prima della query: 2.095 MB Righe restituite: 1

SELECT *

  FROM w2bao_assets

  WHERE `id` = '1'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->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.16 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.023 MB memoria prima della query: 2.101 MB Righe restituite: 1

SELECT a.rules

  FROM w2bao_assets AS a

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	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.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.42 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.14 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->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: 1.57 ms Dopo l'ultima query: 1.90 ms Memoria query: 0.025 MB memoria prima della query: 2.115 MB Righe restituite: 32

SELECT element

  FROM w2bao_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_extensions	NULL	ref	extension	extension	82	const	32	10.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->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: 2.09 ms Dopo l'ultima query: 0.44 ms Memoria query: 0.025 MB memoria prima della query: 2.128 MB Righe restituite: 32

SELECT a.name, a.rules

  FROM w2bao_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_roksprocket','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	163	20.25	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->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: 2.36 ms Dopo l'ultima query: 5.67 ms Memoria query: 0.031 MB memoria prima della query: 2.294 MB Righe restituite: 30

SHOW FULL COLUMNS 
  FROM `w2bao_content`

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.43 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->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: 1.53 ms Dopo l'ultima query: 6.65 ms Memoria query: 0.022 MB memoria prima della query: 2.343 MB Righe restituite: 1

SELECT *

  FROM w2bao_content

  WHERE `id` = '62'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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: 0.74 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.005 MB memoria prima della query: 2.351 MB

UPDATE w2bao_content

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

  WHERE `id` = '62'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	w2bao_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->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.26 ms Dopo l'ultima query: 3.87 ms Memoria query: 0.023 MB memoria prima della query: 2.375 MB Righe restituite: 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 w2bao_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM w2bao_categories AS cat JOIN w2bao_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 = 62 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-23 09:13:36') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-23 09:13:36') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	v	NULL	system	PRIMARY	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	0	0.00	const row not found
1	PRIMARY	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	ALL	PRIMARY,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	11.11	Range checked for each record (index map: 0x11)

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.03 ms
checking query cache for query	0.54 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.63 ms
init	0.28 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
System lock	0.11 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.05 ms
Creating tmp table	0.03 ms
Sorting result	0.04 ms
statistics	0.36 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.09 ms
executing	0.01 ms
Sending data	0.16 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.02 ms
removing tmp table	0.23 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.07 ms
closing tables	0.10 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.07 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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: 3.68 ms Dopo l'ultima query: 5.27 ms Memoria query: 0.023 MB memoria prima della query: 2.418 MB Righe restituite: 2

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

  FROM w2bao_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM w2bao_categories AS cat JOIN w2bao_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 w2bao_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) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=12

  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	4	55.55	Using index condition; Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	Sql1535287_1.c.id	2	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	ALL	PRIMARY,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	11.11	Range checked for each record (index map: 0x11)

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.02 ms
checking query cache for query	0.33 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.21 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
System lock	0.05 ms
optimizing	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
statistics	0.28 ms
preparing	0.10 ms
Creating tmp table	0.18 ms
Sorting result	0.01 ms
executing	0.02 ms
Sending data	0.14 ms
executing	0.01 ms
Sending data	0.12 ms
Creating sort index	0.51 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.06 ms
query end	0.01 ms
removing tmp table	0.18 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.04 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.06 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->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: 1.89 ms Dopo l'ultima query: 1.46 ms Memoria query: 0.022 MB memoria prima della query: 2.446 MB Righe restituite: 0

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

  FROM `w2bao_contentitem_tag_map` AS m 

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

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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->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: 5.82 ms Dopo l'ultima query: 9.75 ms Memoria query: 0.028 MB memoria prima della query: 2.560 MB Righe restituite: 10

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

  FROM w2bao_modules AS m

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

  LEFT JOIN w2bao_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 <= '2024-12-23 09:13:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-23 09:13:36') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 247 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	9	1.15	Using index condition; Using where; Using filesort
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	Sql1535287_1.m.id	1	40.00	Using where; Using index
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_folder_clientid	402	Sql1535287_1.m.module	11	1.00	Using index condition; Using where

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.02 ms
checking query cache for query	0.20 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
Opening tables	0.45 ms
init	0.11 ms
System lock	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
System lock	0.05 ms
optimizing	0.05 ms
statistics	0.21 ms
preparing	0.08 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	3.61 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.02 ms
freeing items	0.07 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
18	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:434
17	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:370
16	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:34
15	JModuleHelper::getModule()	JROOT/plugins/content/loadmodule/loadmodule.php:168
14	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:113
13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
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: 0.71 ms Dopo l'ultima query: 114.75 ms Memoria query: 0.004 MB memoria prima della query: 3.081 MB

LOCK TABLES `w2bao_extensions` WRITE

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.18 ms
System lock	0.02 ms
invalidating query cache entri	0.01 ms
Waiting for query cache lock	0.01 ms
invalidating query cache entri	0.10 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:543
8	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:79
7	PlgSystemUpdatenotification->onAfterRender()	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.43 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.004 MB memoria prima della query: 3.085 MB

UPDATE `w2bao_extensions`

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	w2bao_extensions	NULL	range	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.82 ms
updating	0.15 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/updatenotification/updatenotification.php:90
7	PlgSystemUpdatenotification->onAfterRender()	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.38 ms Dopo l'ultima query: 4.26 ms Memoria query: 0.004 MB memoria prima della query: 3.095 MB

UNLOCK TABLES

Explain

EXPLAIN non possibile sulla query: UNLOCK TABLES

Profilo

Status	Duration
starting	0.10 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:918
8	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:104
7	PlgSystemUpdatenotification->onAfterRender()	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: 2.09 ms Dopo l'ultima query: 2.64 ms Memoria query: 0.021 MB memoria prima della query: 3.106 MB Righe restituite: 1

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

  FROM `w2bao_update_sites` AS `a`

  INNER JOIN w2bao_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	8	12.50	Using where; Using temporary
1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	8	Sql1535287_1.a.update_site_id,const	1	100.00	Using index; Distinct

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.61 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
System lock	0.04 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.06 ms
executing	0.01 ms
Sending data	0.43 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.07 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.07 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.12 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
10	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/updater/updater.php:229
9	JUpdater->getUpdateSites()	JROOT/libraries/joomla/updater/updater.php:119
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	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.17 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 3.114 MB Righe restituite: 1

SELECT DISTINCT update_site_id

  FROM w2bao_updates

  WHERE `update_site_id` IN (
SELECT update_site_id

  FROM w2bao_update_sites

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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/updater/updater.php:400
9	JUpdater->getSitesWithUpdates()	JROOT/libraries/joomla/updater/updater.php:132
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	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.78 ms Dopo l'ultima query: 3.66 ms Memoria query: 0.022 MB memoria prima della query: 3.186 MB Righe restituite: 1

SELECT `name`

  FROM `w2bao_update_sites`

  WHERE `update_site_id` = '1'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/updater/updateadapter.php:188
12	JUpdateAdapter->getUpdateSiteName()	JROOT/libraries/joomla/updater/updateadapter.php:215
11	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
10	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	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.68 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.006 MB memoria prima della query: 3.192 MB

UPDATE `w2bao_update_sites`

  SET `enabled` = '0'

  WHERE `update_site_id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	w2bao_update_sites	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.05 ms
updating	0.12 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.08 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updateadapter.php:153
12	JUpdateAdapter->toggleUpdateSite()	JROOT/libraries/joomla/updater/updateadapter.php:238
11	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
10	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	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.19 ms Dopo l'ultima query: 106.48 ms Memoria query: 0.006 MB memoria prima della query: 3.211 MB

UPDATE `w2bao_update_sites`

  SET `enabled` = '1'

  WHERE `update_site_id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	w2bao_update_sites	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updateadapter.php:153
12	JUpdateAdapter->toggleUpdateSite()	JROOT/libraries/joomla/updater/updateadapter.php:254
11	JUpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/joomla/updater/adapters/collection.php:223
10	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	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.51 ms Dopo l'ultima query: 0.74 ms Memoria query: 0.026 MB memoria prima della query: 3.221 MB Righe restituite: 14

SHOW FULL COLUMNS 
  FROM `w2bao_updates`

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.33 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.03 ms
Opening tables	0.02 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
freeing items	0.09 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/libraries/joomla/table/update.php:31
14	JTableUpdate->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/libraries/joomla/updater/adapters/collection.php:117
12	JUpdaterCollection->_startElement()	Chiamata uguale alla linea sottostante.
11	xml_parse()	JROOT/libraries/joomla/updater/adapters/collection.php:234
10	JUpdaterCollection->findUpdate()	JROOT/libraries/joomla/updater/updater.php:267
9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	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.89 ms Dopo l'ultima query: 2.33 ms Memoria query: 0.021 MB memoria prima della query: 3.241 MB Righe restituite: 1

SELECT `update_id`

  FROM `w2bao_updates`

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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/update.php:110
10	JTableUpdate->find()	JROOT/libraries/joomla/updater/updater.php:319
9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	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.17 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.021 MB memoria prima della query: 3.246 MB Righe restituite: 1

SELECT `extension_id`

  FROM `w2bao_extensions`

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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
10	JTableExtension->find()	JROOT/libraries/joomla/updater/updater.php:329
9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	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.14 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.021 MB memoria prima della query: 3.252 MB Righe restituite: 1

SELECT *

  FROM w2bao_updates

  WHERE `update_id` = '1'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/libraries/joomla/updater/updater.php:356
9	JUpdater->getUpdateObjectsForSite()	JROOT/libraries/joomla/updater/updater.php:151
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	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.64 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.005 MB memoria prima della query: 3.252 MB

UPDATE `w2bao_update_sites`

  SET `last_check_timestamp` = '1734945216'

  WHERE `update_site_id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	w2bao_update_sites	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/updater/updater.php:429
9	JUpdater->updateLastCheckTimestamp()	JROOT/libraries/joomla/updater/updater.php:165
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	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]

41 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

3 × SELECT `extension_id` 
  FROM `w2bao_extensions`

2 × SELECT template 
  FROM w2bao_template_styles as s

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

```
2 × SELECT * 
  FROM w2bao_extensions
```

1 × SELECT `data` 
  FROM `w2bao_session`

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

1 × SELECT `update_id` 
  FROM `w2bao_updates`

1 × SELECT `name` 
  FROM `w2bao_update_sites`

1 × SELECT DISTINCT update_site_id 
  FROM w2bao_updates

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

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

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

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 w2bao_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM w2bao_categories AS cat JOIN w2bao_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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 w2bao_content AS a 
  LEFT JOIN w2bao_categories AS c 
  on c.id = a.catid 
  LEFT JOIN w2bao_users AS u 
  on u.id = a.created_by 
  LEFT JOIN w2bao_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN w2bao_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM w2bao_categories AS cat JOIN w2bao_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT * 
  FROM w2bao_content
```
```
1 × SELECT * 
  FROM w2bao_assets
```

1 × SELECT element 
  FROM w2bao_extensions

1 × SELECT a.rules 
  FROM w2bao_assets AS a

1 × SELECT `session_id` 
  FROM `w2bao_session`

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

```
1 × SELECT * 
  FROM w2bao_languages
```

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

1 × SELECT extension, file, type 
  FROM w2bao_rokcommon_configs

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

1 × SELECT id, rules 
  FROM `w2bao_viewlevels

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

```
1 × SELECT * 
  FROM w2bao_updates
```

ALTRE tabelle:

```
1 × DELETE  
  FROM `w2bao_session`
```

1 × INSERT INTO `w2bao_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('8qnvctvalcoivc0p132hpeep7c', 0, 1, '1734945215', 0, ''

1 × SHOW FULL COLUMNS 
  FROM `w2bao_extensions

1 × UPDATE `w2bao_extensions` 
  SET `params` = '{\"mediaversion\":\"8c24c256ff69d596b272b59375c72cb9\"}'

1 × SHOW FULL COLUMNS 
  FROM `w2bao_assets

1 × SHOW FULL COLUMNS 
  FROM `w2bao_content

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

1 × LOCK TABLES `w2bao_extensions` WRIT

1 × UPDATE `w2bao_extensions` 
  SET `params` = '{\"lastrun\":1734945216}'

```
1 × UNLOCK TABLE
```

1 × UPDATE `w2bao_update_sites` 
  SET `enabled` = '0'

1 × UPDATE `w2bao_update_sites` 
  SET `enabled` = '1'

1 × SHOW FULL COLUMNS 
  FROM `w2bao_updates

1 × UPDATE `w2bao_update_sites` 
  SET `last_check_timestamp` = '1734945216'