//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

(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": 1732170234,
                "last": 1732170234,
                "now": 1732170234
            }
        },
        "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: 49.80 ms / 49.80 ms Memoria: 0.059 MB / 0.41 MB Application: afterLoad

Tempo: 104.80 ms / 154.60 ms Memoria: 0.800 MB / 1.21 MB Application: afterInitialise

Tempo: 21.77 ms / 176.37 ms Memoria: 0.357 MB / 1.57 MB Application: afterRoute

Tempo: 8.80 ms / 185.17 ms Memoria: 0.044 MB / 1.61 MB Application: beforeRenderComponent com_finder

Tempo: 71.12 ms / 256.29 ms Memoria: 0.191 MB / 1.81 MB Application: afterFinderQuery

Tempo: 0.03 ms / 256.32 ms Memoria: 0.001 MB / 1.81 MB Application: afterFinderResults

Tempo: 0.01 ms / 256.33 ms Memoria: 0.001 MB / 1.81 MB Application: afterFinderTotal

Tempo: 2.09 ms / 258.42 ms Memoria: 0.004 MB / 1.81 MB Application: afterFinderPagination

Tempo: 13.03 ms / 271.46 ms Memoria: 0.074 MB / 1.88 MB Application: beforeFinderLayout

Tempo: 57.41 ms / 328.86 ms Memoria: 0.047 MB / 1.93 MB Application: afterFinderLayout

Tempo: 4.12 ms / 332.99 ms Memoria: 0.000 MB / 1.91 MB Application: afterRenderComponent com_finder

Tempo: 2.12 ms / 335.11 ms Memoria: 0.007 MB / 1.91 MB Application: afterDispatch

Tempo: 17.88 ms / 352.99 ms Memoria: 0.163 MB / 2.08 MB Application: beforeRenderModule mod_menu (Menu Principale)

Tempo: 12.92 ms / 365.90 ms Memoria: 0.027 MB / 2.10 MB Application: afterRenderModule mod_menu (Menu Principale)

Tempo: 4.99 ms / 370.89 ms Memoria: 0.000 MB / 2.10 MB Application: beforeRenderModule mod_menu (Novità)

Tempo: 9.92 ms / 380.82 ms Memoria: 0.012 MB / 2.11 MB Application: afterRenderModule mod_menu (Novità)

Tempo: 4.59 ms / 385.40 ms Memoria: 0.000 MB / 2.11 MB Application: beforeRenderModule mod_menu (Parrocchia)

Tempo: 12.90 ms / 398.30 ms Memoria: 0.017 MB / 2.13 MB Application: afterRenderModule mod_menu (Parrocchia)

Tempo: 5.24 ms / 403.54 ms Memoria: 0.000 MB / 2.13 MB Application: beforeRenderModule mod_menu (attivita)

Tempo: 15.55 ms / 419.09 ms Memoria: 0.025 MB / 2.15 MB Application: afterRenderModule mod_menu (attivita)

Tempo: 4.35 ms / 423.44 ms Memoria: 0.000 MB / 2.15 MB Application: beforeRenderModule mod_menu (Gruppi)

Tempo: 13.38 ms / 436.82 ms Memoria: 0.023 MB / 2.17 MB Application: afterRenderModule mod_menu (Gruppi)

Tempo: 7.05 ms / 443.87 ms Memoria: 0.000 MB / 2.17 MB Application: afterRender

Query totali del database: 13.39 ms

Utilizzo memoria

Query Database

12 query eseguite 13.39 ms

Trovati 2 duplicati!

2 duplicati: #2 #12

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

SELECT `data`

  FROM `joom2_session`

  WHERE `session_id` = 'uv77a5nr1u23vljd7abotj5fk5'

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.01 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.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.05 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.01 ms
end	0.01 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.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.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.50 ms Dopo l'ultima query: 6.63 ms Memoria query: 0.023 MB memoria prima della query: 0.764 MB Righe restituite: 0

Query duplicate: #12

SELECT `session_id`

  FROM `joom2_session`

  WHERE `session_id` = 'uv77a5nr1u23vljd7abotj5fk5' 
  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.03 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.01 ms
end	0.01 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.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
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.59 ms Dopo l'ultima query: 0.13 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 
('uv77a5nr1u23vljd7abotj5fk5', 0, 1, '1732170234', 0, '')

Explain

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

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
update	0.14 ms
Waiting for query cache lock	0.01 ms
update	0.06 ms
end	0.01 ms
query end	0.05 ms
closing tables	0.02 ms
freeing items	0.05 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.88 ms Dopo l'ultima query: 12.60 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.01 ms
checking query cache for query	0.05 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.15 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.10 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.01 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
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.54 ms Dopo l'ultima query: 1.81 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.01 ms
checking query cache for query	0.02 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.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 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: 2.29 ms Dopo l'ultima query: 30.43 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.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.21 ms
Sending data	0.49 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.03 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/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.59 ms Dopo l'ultima query: 18.05 ms Memoria query: 0.007 MB memoria prima della query: 1.576 MB

UPDATE `joom2_extensions`

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

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

Explain

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

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.09 ms
Updating	0.06 ms
end	0.01 ms
query end	0.05 ms
closing tables	0.02 ms
freeing items	0.05 ms
logging slow query	0.01 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: 0.99 ms Dopo l'ultima query: 16.01 ms Memoria query: 0.025 MB memoria prima della query: 1.715 MB Righe restituite: 6

SELECT name

  FROM `joom2_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'finder' 
  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	68	Using where

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.04 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.07 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.31 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.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.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_finder/helpers/language.php:125
9	FinderHelperLanguage::loadPluginLanguage()	JROOT/components/com_finder/controller.php:38
8	FinderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_finder/finder.php:15
6	require_once JROOT/components/com_finder/finder.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.06 ms Dopo l'ultima query: 56.43 ms Memoria query: 0.030 MB memoria prima della query: 1.793 MB Righe restituite: 0

SELECT `title`

  FROM `joom2_finder_taxonomy`

  WHERE `parent_id` = 1 
  AND `state` = 1 
  AND `access` IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	joom2_finder_taxonomy	ref	parent_id,state,access,idx_parent_published	parent_id	4	const	1	Using where

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.04 ms
checking permissions	0.01 ms
Opening tables	0.51 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	1.78 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.02 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
18	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
17	FinderIndexerTaxonomy::getBranchTitles()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:749
16	FinderIndexerQuery->processString()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:235
15	FinderIndexerQuery->__construct()	JROOT/components/com_finder/models/search.php:1110
14	FinderModelSearch->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/components/com_finder/views/search/view.html.php:42
11	FinderViewSearch->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_finder/controller.php:55
8	FinderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_finder/finder.php:15
6	require_once JROOT/components/com_finder/finder.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.07 ms Dopo l'ultima query: 71.94 ms Memoria query: 0.033 MB memoria prima della query: 1.952 MB Righe restituite: 0

SELECT t.*, count(c.id) AS children

  FROM `joom2_finder_taxonomy` AS t

  INNER JOIN `joom2_finder_taxonomy` AS c 
  ON c.parent_id = t.id

  WHERE t.parent_id = 1 
  AND t.state = 1 
  AND t.access IN (1,1,5) 
  AND c.state = 1 
  AND c.access IN (1,1,5)

  GROUP BY `t`.`id`

  ORDER BY t.ordering, t.title

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,parent_id,state,access,idx_parent_published	parent_id	4	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	c	ref	parent_id,state,access,idx_parent_published	parent_id	4	Sql793024_2.t.id	1	Using where

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.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.05 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting for group	0.01 ms
executing	0.00 ms
Copying to tmp table	0.03 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.08 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.01 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_finder/helpers/html/filter.php:288
19	JHtmlFilter::select()	JROOT/libraries/cms/html/html.php:237
18	JHtml::call()	JROOT/libraries/cms/html/html.php:139
17	JHtml::_()	JROOT/components/com_finder/views/search/tmpl/default_form.php:98
16	include JROOT/components/com_finder/views/search/tmpl/default_form.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/components/com_finder/views/search/tmpl/default.php:31
14	include JROOT/components/com_finder/views/search/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_finder/views/search/view.html.php:110
11	FinderViewSearch->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_finder/controller.php:55
8	FinderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_finder/finder.php:15
6	require_once JROOT/components/com_finder/finder.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.61 ms Dopo l'ultima query: 11.26 ms Memoria query: 0.029 MB memoria prima della query: 1.956 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:23:54') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 06:23:54') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 111 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.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.02 ms
checking query cache for query	0.18 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.06 ms
init	0.09 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.06 ms
executing	0.00 ms
Sorting result	0.28 ms
Sending data	0.18 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.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.00 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.47 ms Dopo l'ultima query: 3.34 ms Memoria query: 0.026 MB memoria prima della query: 1.968 MB Righe restituite: 1

Query duplicate: #2

SELECT `session_id`

  FROM `joom2_session`

  WHERE `session_id` = 'uv77a5nr1u23vljd7abotj5fk5' 
  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.03 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.01 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.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.00 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]

11 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

2 × SELECT `session_id` 
  FROM `joom2_session`

1 × SELECT `data` 
  FROM `joom2_session`

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 id, rules 
  FROM `joom2_viewlevels

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 name 
  FROM `joom2_extensions`

1 × SELECT `title` 
  FROM `joom2_finder_taxonomy`

1 × SELECT t.*, count(c.id) AS children 
  FROM `joom2_finder_taxonomy` AS t 
  INNER JOIN `joom2_finder_taxonomy` AS c 
  ON c.parent_id = t.id

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  ('uv77a5nr1u23vljd7abotj5fk5', 0, 1, '1732170234', 0, ''

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