//modificato
Deprecated: Non-static method JApplicationSite::getMenu() should not be called statically in /web/htdocs/www.santicirilloemetodio.it/home/templates/apicloudnature/index.php on line 135

Deprecated: Non-static method JApplicationCms::getMenu() should not be called statically in /web/htdocs/www.santicirilloemetodio.it/home/libraries/cms/application/site.php on line 272

Notice: Undefined variable: this in /web/htdocs/www.santicirilloemetodio.it/home/libraries/cms/application/cms.php on line 434

I Santi Patroni

Stampa

Dettagli: Ultima modifica: Venerdì, 09 Maggio 2014 11:18; Scritto da dG

I SANTI PATRONI

I santi Cirillo e Metodio hanno portato a compimento nel IX secolo l’opera di evangelizzazione tra i popoli slavi. Originari di Tessalonica ed intrepidi testimoni del Vangelo sono stati i capostipiti del folto gruppo di apostoli che hanno lavorato attivamente al servizio di Cristo fra i popoli slavi.
Pur avendo la possibilità di intraprendere brillanti carriere politiche, questi due Fratelli si dedicarono totalmente al Signore. Su richiesta del Principe Rastislav della Grande Moravia all'Imperatore Michele III, furono inviati ad annunciare ai popoli dell'Europa centrale la fede cristiana nella loro propria lingua. Essi dedicarono così la loro vita a questo compito, affrontando non poche difficoltà e sofferenze, persecuzioni e prigionia, e divenendo entrambi esempi luminosi di dedizione alla causa di Cristo e di amore ai fratelli assetati della Verità evangelica.

A loro ben si applicano le parole di san Paolo: "Guai a me se non predicassi il Vangelo!" (1 Cor 9, 16). Aprendo il proprio animo ai cristiani di Corinto, l'Apostolo esprime la consapevolezza della necessità e dell'urgenza dell'annuncio evangelico. Egli lo sente come un grande dono ma anche come un irrinunciabile impegno: un vero e proprio "dovere" (cfr ibid.), del quale porta la responsabilità in comunione con gli altri Apostoli. Con il suo farsi "tutto a tutti, per salvare ad ogni costo qualcuno" (ibid., 22), egli ci mostra come ogni evangelizzatore debba imparare ad adattarsi al linguaggio dei suoi ascoltatori, per entrare in sintonia profonda con loro.
Questo brano, scelto per la liturgia dei due Santi fratelli, esprime quanto hanno compiuto in modo mirabile: tutta la loro missione è stata tesa ad "incarnare" la Parola di Dio nella lingua e nella cultura slava. A loro si deve la trascrizione dei testi sacri e liturgici in lingua paleoslava mediante un nuovo alfabeto. Per mantenere salda la comunione ecclesiale, essi vennero a Roma ed ottennero l'approvazione del Papa Adriano II. Fu proprio a Roma che, il 14 febbraio 869, morì Cirillo, mentre Metodio, consacrato Vescovo per il territorio dell'antica diocesi di Pannonia e nominato Legato Pontificio per le genti slave, proseguì il compito missionario che aveva intrapreso insieme col fratello.
Entambi sono stati araldi sapienti del Vangelo nell’Europa orientale e continuano anche oggi ad insegnare agli evangelizzatori del nostro tempo il coraggio dell'annuncio e l'atteggiamento necessario per inculturare la fede.
(Stralcio dell’omelia di Giovanni Paolo II nella sua visita alla nostra parrocchia il 15 febbraio 1998)

Giovanni Paolo II li ha proclamati Compatroni d'Europa, rendendo "il loro ricordo particolarmente vivo ed attuale ai nostri giorni" (Enc. Slavorum apostoli, n. 1)

NOSTRI SANTI PATRONI

Bibliografia più accessibile:

Enciclica Slavorum apostoli, di Giovanni Paolo II.
AA.VV. Cirillo e Metodio, i Santi Apostoli degli Slavi. Ed. Pontificio Istituto Orientale, Roma 1964.
M. Lacko, Cirillo e Metodio, apostoli degli Slavi, La Casa di Matriona, Milano, 1982
V. Peri, Cirillo e Metodio, le biografie paleoslave, ed. E.O. Milano, 1981
A.E. Tachiaos, Cirillo e Metodio. Le radici cristiane della cultura slava, Jaca Book, Milano 2005

(c) Parrocchia Santi Cirillo e Metodio in Roma - C.F. 97084540588 - Via dell'Osteria di Dragoncello, 12 - 00126 Roma - Tel. ( +39) 06 83 99 37 29
E-mail: parrocchia@santicirilloemetodio.it - PEC: parrocchia@pec.santicirilloemetodio.it globbers joomla templates

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732172256,
                "last": 1732172256,
                "now": 1732172256
            }
        },
        "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: 42.81 ms / 42.81 ms Memoria: 0.059 MB / 0.41 MB Application: afterLoad

Tempo: 61.34 ms / 104.15 ms Memoria: 0.800 MB / 1.21 MB Application: afterInitialise

Tempo: 12.80 ms / 116.95 ms Memoria: 0.357 MB / 1.57 MB Application: afterRoute

Tempo: 6.93 ms / 123.88 ms Memoria: 0.064 MB / 1.63 MB Application: beforeRenderComponent com_content

Tempo: 10.41 ms / 134.28 ms Memoria: 0.178 MB / 1.81 MB Application: Start JAccess::getAssetRules Old (1)

Tempo: 1.30 ms / 135.59 ms Memoria: 0.018 MB / 1.83 MB Application: Finish JAccess::getAssetRules Old (1)

Tempo: 0.04 ms / 135.62 ms Memoria: 0.000 MB / 1.82 MB Application: Start JAccess::preload(components)

Tempo: 2.81 ms / 138.43 ms Memoria: 0.219 MB / 2.04 MB Application: Finish JAccess::preload(components)

Tempo: 26.20 ms / 164.63 ms Memoria: 0.340 MB / 2.38 MB Application: New JAccess Preloading Process(com_content.article)

Tempo: 0.51 ms / 165.14 ms Memoria: 0.034 MB / 2.42 MB Application: After preloadPermissionsParentIdMapping (com_content.article)

Tempo: 2.82 ms / 167.96 ms Memoria: 0.045 MB / 2.46 MB Application: After preloadPermissions (com_content.article)

Tempo: 0.02 ms / 167.97 ms Memoria: 0.001 MB / 2.46 MB Application: End New JAccess Preloading Process(com_content.article)

Tempo: 0.02 ms / 167.99 ms Memoria: 0.001 MB / 2.46 MB Application: Start JAccess::getAssetRules New (com_content.article.2)

Tempo: 0.12 ms / 168.12 ms Memoria: 0.007 MB / 2.47 MB Application: Finish JAccess::getAssetRules New (com_content.article.2)

Tempo: 9.64 ms / 177.75 ms Memoria: 0.060 MB / 2.53 MB Application: afterRenderComponent com_content

Tempo: 3.63 ms / 181.39 ms Memoria: 0.016 MB / 2.55 MB Application: afterDispatch

Tempo: 20.08 ms / 201.46 ms Memoria: 0.310 MB / 2.86 MB Application: beforeRenderModule mod_menu (Menu Principale)

Tempo: 11.22 ms / 212.68 ms Memoria: 0.016 MB / 2.87 MB Application: afterRenderModule mod_menu (Menu Principale)

Tempo: 4.59 ms / 217.27 ms Memoria: 0.000 MB / 2.87 MB Application: beforeRenderModule mod_menu (Novità)

Tempo: 7.99 ms / 225.25 ms Memoria: 0.012 MB / 2.88 MB Application: afterRenderModule mod_menu (Novità)

Tempo: 3.39 ms / 228.64 ms Memoria: 0.000 MB / 2.88 MB Application: beforeRenderModule mod_menu (Parrocchia)

Tempo: 10.62 ms / 239.26 ms Memoria: 0.016 MB / 2.90 MB Application: afterRenderModule mod_menu (Parrocchia)

Tempo: 4.55 ms / 243.81 ms Memoria: 0.000 MB / 2.90 MB Application: beforeRenderModule mod_menu (attivita)

Tempo: 17.56 ms / 261.37 ms Memoria: 0.025 MB / 2.92 MB Application: afterRenderModule mod_menu (attivita)

Tempo: 4.63 ms / 266.00 ms Memoria: 0.000 MB / 2.92 MB Application: beforeRenderModule mod_menu (Gruppi)

Tempo: 12.32 ms / 278.32 ms Memoria: 0.023 MB / 2.94 MB Application: afterRenderModule mod_menu (Gruppi)

Tempo: 10.98 ms / 289.30 ms Memoria: 0.000 MB / 2.73 MB Application: afterRender

Query totali del database: 23.08 ms

Utilizzo memoria

Query Database

23 query eseguite 23.08 ms

Trovati 2 duplicati!

2 duplicati: #2 #23

Tempo della query: 0.57 ms Memoria query: 0.026 MB memoria prima della query: 0.743 MB Righe restituite: 0

SELECT `data`

  FROM `joom2_session`

  WHERE `session_id` = 'ltk1hrel5joihpl6gr70b3ifv3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	joom2_session	const	PRIMARY	PRIMARY	766	const	1

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	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.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
logging slow query	0.00 ms
cleaning up	0.00 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.39 ms Dopo l'ultima query: 4.42 ms Memoria query: 0.023 MB memoria prima della query: 0.764 MB Righe restituite: 0

Query duplicate: #23

SELECT `session_id`

  FROM `joom2_session`

  WHERE `session_id` = 'ltk1hrel5joihpl6gr70b3ifv3' 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	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.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
logging slow query	0.00 ms
cleaning up	0.00 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.41 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.005 MB memoria prima della query: 0.770 MB

INSERT INTO `joom2_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('ltk1hrel5joihpl6gr70b3ifv3', 0, 1, '1732172256', 0, '')

Explain

EXPLAIN non possibile sulla query: INSERT INTO `joom2_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('ltk1hrel5joihpl6gr70b3ifv3', 0, 1, '1732172256', 0, '')

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.01 ms
update	0.04 ms
Waiting for query cache lock	0.00 ms
update	0.01 ms
end	0.00 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 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: 0.44 ms Dopo l'ultima query: 6.24 ms Memoria query: 0.025 MB memoria prima della query: 0.893 MB Righe restituite: 2

SELECT b.id

  FROM joom2_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 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.29 ms Dopo l'ultima query: 0.83 ms Memoria query: 0.025 MB memoria prima della query: 0.901 MB Righe restituite: 5

SELECT id, rules

  FROM `joom2_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	joom2_viewlevels	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 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: 1.43 ms Dopo l'ultima query: 19.32 ms Memoria query: 0.056 MB memoria prima della query: 1.293 MB Righe restituite: 30

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	34	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql793024_2.m.component_id	1

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.19 ms
Sending data	0.21 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.03 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.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.08 ms
logging slow query	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.54 ms Dopo l'ultima query: 10.97 ms Memoria query: 0.007 MB memoria prima della query: 1.576 MB

UPDATE `joom2_extensions`

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

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

Explain

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

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.06 ms
Updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.15 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 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.67 ms Dopo l'ultima query: 11.01 ms Memoria query: 0.035 MB memoria prima della query: 1.768 MB Righe restituite: 8

SHOW FULL COLUMNS 
  FROM `joom2_assets`

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
System lock	0.01 ms
init	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 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.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.62 ms
closing tables	0.01 ms
freeing items	0.08 ms
logging slow query	0.01 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.51 ms Dopo l'ultima query: 1.63 ms Memoria query: 0.031 MB memoria prima della query: 1.802 MB Righe restituite: 1

SELECT *

  FROM joom2_assets

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	joom2_assets	const	PRIMARY	PRIMARY	4	const	1

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
logging slow query	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: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.27 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.027 MB memoria prima della query: 1.812 MB Righe restituite: 1

SELECT a.rules

  FROM joom2_assets AS a

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	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.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
logging slow query	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.75 ms Dopo l'ultima query: 1.04 ms Memoria query: 0.031 MB memoria prima della query: 1.825 MB Righe restituite: 36

SELECT element

  FROM joom2_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	joom2_extensions	ref	extension	extension	82	const	36	Using where

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.01 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.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.01 ms
logging slow query	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: 0.32 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.032 MB memoria prima della query: 1.842 MB Righe restituite: 36

SELECT a.name, a.rules

  FROM joom2_assets AS a

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

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
logging slow query	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: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.57 ms Dopo l'ultima query: 2.44 ms Memoria query: 0.039 MB memoria prima della query: 2.044 MB Righe restituite: 30

SHOW FULL COLUMNS 
  FROM `joom2_content`

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.28 ms
System lock	0.01 ms
init	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.02 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.01 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	1.25 ms
closing tables	0.00 ms
freeing items	0.03 ms
logging slow query	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/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: 0.60 ms Dopo l'ultima query: 3.42 ms Memoria query: 0.043 MB memoria prima della query: 2.122 MB Righe restituite: 1

SELECT *

  FROM joom2_content

  WHERE `id` = '2'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	joom2_content	const	PRIMARY	PRIMARY	4	const	1

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
init	0.02 ms
optimizing	0.00 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 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.00 ms
freeing items	0.00 ms
storing result in query cache	0.20 ms
logging slow query	0.00 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.93 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.007 MB memoria prima della query: 2.144 MB

UPDATE joom2_content

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

  WHERE `id` = '2'

Explain

EXPLAIN non possibile sulla query: UPDATE joom2_content SET `hits` = (`hits` + 1) WHERE `id` = '2'

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.03 ms
Updating	0.12 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.26 ms
query end	0.06 ms
closing tables	0.02 ms
freeing items	0.06 ms
logging slow query	0.00 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: 4.31 ms Dopo l'ultima query: 4.29 ms Memoria query: 0.039 MB memoria prima della query: 2.252 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 joom2_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM joom2_categories AS cat JOIN joom2_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 = 2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	0	const row not found
1	PRIMARY	a	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	Using where; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	7	Using where; Using index; Using join buffer

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
checking query cache for query	0.24 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.06 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	2.77 ms
Creating tmp table	0.03 ms
executing	0.00 ms
Copying to tmp table	0.05 ms
Sorting result	0.02 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.09 ms
init	0.09 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.04 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.01 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
13	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
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.41 ms Dopo l'ultima query: 3.65 ms Memoria query: 0.040 MB memoria prima della query: 2.312 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 joom2_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM joom2_categories AS cat JOIN joom2_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 joom2_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	0	const row not found
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	7	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using where; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	7	Using where; Using index; Using join buffer

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.04 ms
logging slow query	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/legacy/categories/categories.php:309
14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
12	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
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.81 ms Dopo l'ultima query: 0.71 ms Memoria query: 0.037 MB memoria prima della query: 2.356 MB Righe restituite: 0

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

  FROM `joom2_contentitem_tag_map` AS m 

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

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

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
Waiting on query cache mutex	0.05 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 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.00 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.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
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.31 ms Dopo l'ultima query: 3.47 ms Memoria query: 0.034 MB memoria prima della query: 2.384 MB Righe restituite: 39

SELECT a.id, a.parent_id

  FROM joom2_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	100	Using where

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
logging slow query	0.00 ms
cleaning up	0.00 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/access/access.php:332
18	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
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.21 ms Dopo l'ultima query: 1.52 ms Memoria query: 0.035 MB memoria prima della query: 2.421 MB Righe restituite: 39

SELECT a.id, a.name, a.rules

  FROM joom2_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	100	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
19	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 2.24 ms Dopo l'ultima query: 0.55 ms Memoria query: 0.033 MB memoria prima della query: 2.483 MB Righe restituite: 32

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM joom2_content AS a

  LEFT JOIN joom2_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 2 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-21 06:57:36') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-21 06:57:36')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_state,idx_catid	1,4	NULL	5	Using intersect(idx_state,idx_catid); Using where; Using filesort
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.08 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.91 ms
Sending data	0.42 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.00 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.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 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/plugins/content/pagenavigation/pagenavigation.php:152
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
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.59 ms Dopo l'ultima query: 16.27 ms Memoria query: 0.029 MB memoria prima della query: 2.593 MB Righe restituite: 6

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

  FROM joom2_modules AS m

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

  LEFT JOIN joom2_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-11-21 06:57:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 06:57:36') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 103 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.06 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.06 ms
executing	0.00 ms
Sorting result	0.19 ms
Sending data	0.19 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.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.01 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

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

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

Tempo della query: 0.51 ms Dopo l'ultima query: 2.72 ms Memoria query: 0.026 MB memoria prima della query: 2.605 MB Righe restituite: 1

Query duplicate: #2

SELECT `session_id`

  FROM `joom2_session`

  WHERE `session_id` = 'ltk1hrel5joihpl6gr70b3ifv3' 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.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.01 ms
logging slow query	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:1728
12	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
11	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
10	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
9	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
8	JApplicationSite->__construct()	JROOT/templates/apicloudnature/index.php:134
7	require JROOT/templates/apicloudnature/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

22 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

2 × SELECT `session_id` 
  FROM `joom2_session`

1 × SELECT `data` 
  FROM `joom2_session`

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM joom2_content AS a 
  LEFT JOIN joom2_categories AS cc 
  ON cc.id = a.catid

1 × SELECT a.id, a.name, a.rules 
  FROM joom2_assets AS a

1 × SELECT a.id, a.parent_id 
  FROM joom2_assets AS a

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `joom2_contentitem_tag_map` AS m  
  INNER JOIN `joom2_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 joom2_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM joom2_categories AS cat JOIN joom2_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 joom2_content AS a 
  LEFT JOIN joom2_categories AS c 
  on c.id = a.catid 
  LEFT JOIN joom2_users AS u 
  on u.id = a.created_by 
  LEFT JOIN joom2_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN joom2_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM joom2_categories AS cat JOIN joom2_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

```
1 × SELECT * 
  FROM joom2_content
```

1 × SELECT element 
  FROM joom2_extensions

1 × SELECT a.rules 
  FROM joom2_assets AS a

```
1 × SELECT * 
  FROM joom2_assets
```

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

1 × SELECT id, rules 
  FROM `joom2_viewlevels

1 × SELECT b.id 
  FROM joom2_usergroups AS a 
  LEFT JOIN joom2_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 joom2_modules AS m 
  LEFT JOIN joom2_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN joom2_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

ALTRE tabelle:

1 × INSERT INTO `joom2_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('ltk1hrel5joihpl6gr70b3ifv3', 0, 1, '1732172256', 0, ''

1 × UPDATE `joom2_extensions` 
  SET `params` = '{\"mediaversion\":\"f4c98cf983c9fb7ce3e3b4c168187581\"}'

1 × SHOW FULL COLUMNS 
  FROM `joom2_assets

1 × SHOW FULL COLUMNS 
  FROM `joom2_content

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