Spazi confinati

OBIETTIVI CORSO E ARGOMENTI

Il corso si rivolge a chiunque svolga lavori in ambienti confinati o sospetti d’inquinamento, incluso il datore di lavoro, se coinvolto nelle lavorazioni. Fornisce una solida preparazione teorica e pratica, con analisi del DPR 177, procedure di individuazione e gestione di rischi e pericoli, addestramento nell’uso dei Dispositivi di Protezione Individuale.

SCHEDA TECNICA

• Durata corso: 8 ore

• Periodicità di aggiornamento: non regolamentata

• Formazione in aula/in e-learning:

• Requisiti: avvenuta formazione specifica con classe di rischio alto dei lavoratori coinvolti

• Attestato: al termine del corso viene rilasciato un attestato di frequenza con verifica dell’apprendimento se saranno rispettati i criteri di:

o presenza ai corsi di formazione almeno nella misura del 90% rispetto alle ore previste

o svolgimento e superamento della verifica di apprendimento mediante questionario a risposta multipla con almeno il 70% delle risposte esatte

o svolgimento e superamento dell’addestramento a insindacabile giudizio dell’istruttore

• Riferimenti legislativi: DPR n. 177 del 14.09.2011

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": 1734946190,
                "last": 1734946190,
                "now": 1734946190
            }
        },
        "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: 50.46 ms / 50.46 ms Memoria: 0.049 MB / 0.40 MB Application: afterLoad

Tempo: 555.77 ms / 606.23 ms Memoria: 1.220 MB / 1.62 MB Application: afterInitialise

Tempo: 32.20 ms / 638.44 ms Memoria: 0.261 MB / 1.88 MB Application: afterRoute

Tempo: 6.40 ms / 644.83 ms Memoria: 0.059 MB / 1.94 MB Application: beforeRenderComponent com_content

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

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

Tempo: 0.06 ms / 657.22 ms Memoria: 0.000 MB / 2.11 MB Application: Start JAccess::preload(components)

Tempo: 3.64 ms / 660.86 ms Memoria: 0.176 MB / 2.29 MB Application: Finish JAccess::preload(components)

Tempo: 45.70 ms / 706.56 ms Memoria: 0.288 MB / 2.57 MB Application: beforeRenderModule mod_easyquickcontact (Easy Quick Contact)

Tempo: 4.56 ms / 711.12 ms Memoria: 0.021 MB / 2.60 MB Application: afterRenderModule mod_easyquickcontact (Easy Quick Contact)

Tempo: 27.85 ms / 738.96 ms Memoria: 0.248 MB / 2.84 MB Application: afterRenderComponent com_content

Tempo: 4.61 ms / 743.57 ms Memoria: 0.018 MB / 2.86 MB Application: afterDispatch

Tempo: 1.92 ms / 745.50 ms Memoria: 0.049 MB / 2.91 MB Application: beforeRenderModule mod_custom (Su di noi)

Tempo: 3.90 ms / 749.39 ms Memoria: 0.006 MB / 2.92 MB Application: afterRenderModule mod_custom (Su di noi)

Tempo: 0.05 ms / 749.44 ms Memoria: 0.000 MB / 2.92 MB Application: beforeRenderModule mod_custom (Indirizzo)

Tempo: 0.15 ms / 749.59 ms Memoria: 0.004 MB / 2.92 MB Application: afterRenderModule mod_custom (Indirizzo)

Tempo: 0.04 ms / 749.63 ms Memoria: 0.000 MB / 2.92 MB Application: beforeRenderModule mod_custom (Logo footer)

Tempo: 0.14 ms / 749.77 ms Memoria: 0.005 MB / 2.92 MB Application: afterRenderModule mod_custom (Logo footer)

Tempo: 11.48 ms / 761.24 ms Memoria: 0.095 MB / 3.02 MB Application: beforeRenderModule mod_custom (Logo Left)

Tempo: 0.76 ms / 762.01 ms Memoria: 0.005 MB / 3.02 MB Application: afterRenderModule mod_custom (Logo Left)

Tempo: 0.54 ms / 762.55 ms Memoria: 0.003 MB / 3.03 MB Application: beforeRenderModule mod_menu (Main Menu)

Tempo: 5.60 ms / 768.14 ms Memoria: 0.022 MB / 3.05 MB Application: afterRenderModule mod_menu (Main Menu)

Tempo: 6.80 ms / 774.95 ms Memoria: 0.015 MB / 3.06 MB Application: beforeRenderModule mod_custom (Logo Mobile)

Tempo: 0.23 ms / 775.18 ms Memoria: 0.004 MB / 3.07 MB Application: afterRenderModule mod_custom (Logo Mobile)

Tempo: 2.23 ms / 777.42 ms Memoria: 0.002 MB / 3.07 MB Application: beforeRenderModule mod_custom (Copyright)

Tempo: 0.16 ms / 777.58 ms Memoria: 0.004 MB / 3.07 MB Application: afterRenderModule mod_custom (Copyright)

Tempo: 0.04 ms / 777.62 ms Memoria: 0.000 MB / 3.07 MB Application: beforeRenderModule mod_custom (Social Icons)

Tempo: 0.15 ms / 777.77 ms Memoria: 0.004 MB / 3.08 MB Application: afterRenderModule mod_custom (Social Icons)

Tempo: 0.67 ms / 778.44 ms Memoria: 0.003 MB / 3.08 MB Application: beforeRenderModule mod_menu (Main Menu Offcanvas)

Tempo: 0.90 ms / 779.34 ms Memoria: 0.006 MB / 3.09 MB Application: afterRenderModule mod_menu (Main Menu Offcanvas)

Tempo: 5.68 ms / 785.02 ms Memoria: 0.000 MB / 3.08 MB Application: afterRender

Query totali del database: 58.05 ms

Utilizzo memoria

Query Database

32 query eseguite 58.05 ms

Trovati 4 duplicati!

2 duplicati: #8 #9

2 duplicati: #13 #15

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

SELECT `data`

  FROM `w2bao_session`

  WHERE `session_id` = 'h21um3g1i999o7l5tnl7iqsvtr'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_session	NULL	const	PRIMARY	PRIMARY	766	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.05 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.06 ms
executing	0.01 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.00 ms
freeing items	9.29 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.15 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: 0.94 ms Dopo l'ultima query: 8.00 ms Memoria query: 0.019 MB memoria prima della query: 0.691 MB Righe restituite: 0

SELECT `session_id`

  FROM `w2bao_session`

  WHERE `session_id` = 'h21um3g1i999o7l5tnl7iqsvtr' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	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.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.27 ms
optimizing	0.02 ms
statistics	0.04 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.15 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.86 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.003 MB memoria prima della query: 0.695 MB

INSERT INTO `w2bao_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('h21um3g1i999o7l5tnl7iqsvtr', 0, 1, '1734946190', 0, '')

Explain

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

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.15 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.10 ms
freeing items	0.07 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.39 ms Dopo l'ultima query: 6.27 ms Memoria query: 0.022 MB memoria prima della query: 0.719 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.02 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.03 ms
Opening tables	0.05 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.06 ms
optimizing	0.02 ms
statistics	0.36 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.66 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.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.01 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: 0.96 ms Dopo l'ultima query: 3.27 ms Memoria query: 0.021 MB memoria prima della query: 0.734 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.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.08 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.02 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.10 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.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.16 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: 0.71 ms Dopo l'ultima query: 1.37 ms Memoria query: 0.021 MB memoria prima della query: 0.739 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.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.04 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
executing	0.01 ms
Sending data	0.12 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.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
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.21 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.023 MB memoria prima della query: 0.746 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.02 ms
checking query cache for query	0.11 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.03 ms
statistics	0.36 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.96 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.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.11 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: 0.88 ms Dopo l'ultima query: 51.55 ms Memoria query: 0.022 MB memoria prima della query: 1.150 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.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.06 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.04 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.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.02 ms
freeing items	0.01 ms
storing result in query cache	0.26 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.52 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.023 MB memoria prima della query: 1.158 MB Righe restituite: 1

Query duplicate: #8

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.04 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
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: 0.96 ms Dopo l'ultima query: 14.54 ms Memoria query: 0.021 MB memoria prima della query: 1.286 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.02 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.04 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.01 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.02 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.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.02 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: 3.21 ms Dopo l'ultima query: 30.73 ms Memoria query: 0.025 MB memoria prima della query: 1.429 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.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.01 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.02 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	1.48 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.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.08 ms
closing tables	0.01 ms
freeing items	0.09 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.40 ms Dopo l'ultima query: 2.58 ms Memoria query: 0.021 MB memoria prima della query: 1.456 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.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.03 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.51 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.20 ms
Waiting for query cache lock	0.02 ms
Waiting on query cache mutex	0.01 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
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.78 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 1.462 MB Righe restituite: 1

Query duplicate: #15

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.05 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.11 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.43 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.021 MB memoria prima della query: 1.467 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.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.02 ms
optimizing	0.02 ms
statistics	0.65 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.05 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.19 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.01 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.37 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.021 MB memoria prima della query: 1.473 MB Righe restituite: 1

Query duplicate: #13

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.11 ms Dopo l'ultima query: 362.28 ms Memoria query: 0.066 MB memoria prima della query: 1.629 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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	2.35 ms
starting	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.29 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.60 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.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
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: 0.72 ms Dopo l'ultima query: 24.96 ms Memoria query: 0.022 MB memoria prima della query: 1.900 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.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.26 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
13	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: 0.82 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.005 MB memoria prima della query: 1.891 MB

UPDATE `w2bao_extensions`

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

  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.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.24 ms
updating	0.07 ms
end	0.00 ms
Waiting for query cache lock	0.11 ms
end	0.11 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.04 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: 0.50 ms Dopo l'ultima query: 2.20 ms Memoria query: 0.019 MB memoria prima della query: 1.927 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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.03 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.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
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: 0.71 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.019 MB memoria prima della query: 1.935 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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.17 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
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: 0.75 ms Dopo l'ultima query: 9.52 ms Memoria query: 0.027 MB memoria prima della query: 2.070 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.03 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Opening tables	0.16 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.04 ms
checking permissions	0.03 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.02 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.04 ms
cleaning up	0.00 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.40 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.024 MB memoria prima della query: 2.091 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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.00 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: 0.63 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.023 MB memoria prima della query: 2.098 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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.22 ms
end	0.00 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
storing result in query cache	0.00 ms
cleaning up	0.00 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: 0.83 ms Dopo l'ultima query: 1.02 ms Memoria query: 0.025 MB memoria prima della query: 2.112 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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.27 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
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: 1.37 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.025 MB memoria prima della query: 2.124 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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.18 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.56 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
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: 1.22 ms Dopo l'ultima query: 2.31 ms Memoria query: 0.031 MB memoria prima della query: 2.291 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.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.04 ms
checking permissions	0.03 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
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
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
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
checking permissions	0.02 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.00 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: 5.08 ms Dopo l'ultima query: 3.54 ms Memoria query: 0.022 MB memoria prima della query: 2.339 MB Righe restituite: 1

SELECT *

  FROM w2bao_content

  WHERE `id` = '59'

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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	4.26 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.34 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.09 ms
cleaning up	0.00 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.39 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.005 MB memoria prima della query: 2.347 MB

UPDATE w2bao_content

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

  WHERE `id` = '59'

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.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.07 ms
end	0.00 ms
Waiting for query cache lock	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.00 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: 2.13 ms Dopo l'ultima query: 2.63 ms Memoria query: 0.023 MB memoria prima della query: 2.371 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 = 59 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-23 09:29:50') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-23 09:29:50') 
  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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.24 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.17 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.05 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.03 ms
statistics	0.22 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
executing	0.00 ms
Sending data	0.15 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.16 ms
query end	0.00 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.06 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 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.29 ms Dopo l'ultima query: 11.19 ms Memoria query: 0.023 MB memoria prima della query: 2.414 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.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.02 ms
checking query cache for query	0.36 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.29 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.06 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.04 ms
statistics	0.31 ms
preparing	0.15 ms
Creating tmp table	0.15 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.15 ms
executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.34 ms
Creating sort index	0.07 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.12 ms
query end	0.00 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.03 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.19 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.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: 0.75 ms Dopo l'ultima query: 0.69 ms Memoria query: 0.022 MB memoria prima della query: 2.441 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` = 59 
  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.01 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.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 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.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.05 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
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: 4.75 ms Dopo l'ultima query: 8.69 ms Memoria query: 0.026 MB memoria prima della query: 2.549 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:29:50') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-23 09:29:50') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 244 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.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.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.12 ms
System lock	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.05 ms
optimizing	0.05 ms
statistics	0.19 ms
preparing	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
Creating sort index	3.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.07 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.20 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.02 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]

28 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

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 `extension_id` 
  FROM `w2bao_extensions`

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

1 × SELECT `data` 
  FROM `w2bao_session`

1 × SELECT a.rules 
  FROM w2bao_assets AS a

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 a.name, a.rules 
  FROM w2bao_assets AS a

1 × SELECT element 
  FROM w2bao_extensions

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

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 `session_id` 
  FROM `w2bao_session`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM 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 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

ALTRE tabelle:

1 × INSERT INTO `w2bao_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('h21um3g1i999o7l5tnl7iqsvtr', 0, 1, '1734946190', 0, ''

1 × SHOW FULL COLUMNS 
  FROM `w2bao_extensions

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

1 × SHOW FULL COLUMNS 
  FROM `w2bao_assets

1 × SHOW FULL COLUMNS 
  FROM `w2bao_content

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