CAMERE

Camera ROSA

€ 60 / NOTTE

BOOK NOW

Carousel Item Title

Camera BLU

€ 60 / NOTTE

BOOK NOW

Carousel Item Title

Dog Friendly

Gli amici a quattro zampe sono i benvenuti

Carousel Item Title

Albergo recentemente ristrutturato, ambiente curato e confortevole situato vicino alle terme di Roma lontano da fonti di rumore e dal traffico locale, ma nello stesso tempo ben collegato con le linee del bus e ferroviarie per raggiungere in breve tempo la vicina cittadina di tivoli, villa d Este e villa Adriana e la capitale Roma dalle innumerevoli e incantevoli attrazioni e bellezze.

Non manca il forno a legna per poter realizzare pizze dai vari gusti e sapori, dal nostro mastro pizzaiolo che prepara pizze con varie farine di tipo biologico e dai vari cereali.

La maison delle terme si vanta di un' esperienza di tre generazioni nelle attività alberghiere , ricettive e di ristorazione , che con la sua unicità spera di potervi regalare soggiorni piacevoli.

Vi aspettiamo con vero piacere!

Restaurant - Breakfast area

All 'interno dell'hotel si può trovare un servizio di ristorazione molto curato e attento con l'occasione di poter mangiare e gustare piatti tipici romani e piatti più sofisticati per palati più raffinati a base di pesce e carne di qualità ... Non manca il forno a legna per poter realizzare pizze dai vari gusti e sapori, dal nostro mastro pizzaiolo che prepara pizze con varie farine di tipo biologico e dai vari cereali.

Area Restaurant - Breakfast

Agevolazioni concorsista

A pochi passi dall'aeroporto militare Guidonia. Ottima posizione per agevolare i concorsisti che partecipano ai vari concorsi indetti dall'aeroporto.
Inoltre abbiamo la possibilità di prenotare una navetta per accompagnare i nostri ospiti al centro di selezione dell'aeroporto di Guidonia.

Dove Siamo

Tivoli

Via Cecco Angiolieri, 34
Tivoli-Rome-Italy

Lunedì-Domenica

+39.0774.379336

+39.329.4505812

info@maisondelleterme.it

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1725850233,
                "last": 1725850233,
                "now": 1725850233
            }
        },
        "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: 32.03 ms / 32.03 ms Memoria: 0.047 MB / 0.38 MB Application: afterLoad

Tempo: 120.56 ms / 152.59 ms Memoria: 1.066 MB / 1.45 MB Application: afterInitialise

Tempo: 50.25 ms / 202.85 ms Memoria: 0.428 MB / 1.88 MB Application: afterRoute

Tempo: 2.87 ms / 205.72 ms Memoria: 0.055 MB / 1.93 MB Application: beforeRenderComponent com_sppagebuilder

Tempo: 14.09 ms / 219.81 ms Memoria: 0.118 MB / 2.05 MB Application: Before JAccess::preloadComponents (all components)

Tempo: 2.07 ms / 221.88 ms Memoria: 0.055 MB / 2.11 MB Application: After JAccess::preloadComponents (all components)

Tempo: 0.03 ms / 221.91 ms Memoria: 0.000 MB / 2.10 MB Application: Before JAccess::getAssetRules (id:180 name:com_sppagebuilder)

Tempo: 1.47 ms / 223.37 ms Memoria: 0.008 MB / 2.11 MB Application: After JAccess::getAssetRules (id:180 name:com_sppagebuilder)

Tempo: 50.88 ms / 274.25 ms Memoria: 0.177 MB / 2.29 MB Application: afterRenderComponent com_sppagebuilder

Tempo: 3.02 ms / 277.27 ms Memoria: 0.008 MB / 2.30 MB Application: afterDispatch

Tempo: 61.89 ms / 339.16 ms Memoria: 0.220 MB / 2.52 MB Application: beforeRenderModule mod_search (Search)

Tempo: 16.39 ms / 355.55 ms Memoria: 0.031 MB / 2.55 MB Application: afterRenderModule mod_search (Search)

Tempo: 0.09 ms / 355.64 ms Memoria: 0.000 MB / 2.54 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Tempo: 4.31 ms / 359.96 ms Memoria: 0.018 MB / 2.56 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Tempo: 0.12 ms / 360.07 ms Memoria: 0.000 MB / 2.56 MB Application: beforeRenderModule mod_custom (Bottom-logo)

Tempo: 36.98 ms / 397.06 ms Memoria: 0.110 MB / 2.67 MB Application: afterRenderModule mod_custom (Bottom-logo)

Tempo: 0.09 ms / 397.15 ms Memoria: 0.000 MB / 2.67 MB Application: beforeRenderModule mod_menu (Reservation menu)

Tempo: 0.53 ms / 397.68 ms Memoria: 0.009 MB / 2.68 MB Application: afterRenderModule mod_menu (Reservation menu)

Tempo: 44.69 ms / 442.36 ms Memoria: 0.474 MB / 3.15 MB Application: afterRender

Query totali del database: 39.39 ms

Utilizzo memoria

Query Database

25 query eseguite 39.39 ms

Tempo della query: 1.88 ms Memoria query: 0.003 MB memoria prima della query: 0.857 MB

DELETE 

  FROM `t6ml7_session`

  WHERE `time` < '1725849333'

Explain

EXPLAIN non possibile sulla query: DELETE FROM `t6ml7_session` WHERE `time` < '1725849333'

Profilo

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.81 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init for update	0.06 ms
Updating	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.40 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
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:413
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: 0.74 ms Memoria query: 0.023 MB memoria prima della query: 0.865 MB Righe restituite: 0

SELECT `data`

  FROM `t6ml7_session`

  WHERE `session_id` = '7c60416950b78f4a31e3a47b219263d3'

Explain

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

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
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:413
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: 2.34 ms Memoria query: 0.019 MB memoria prima della query: 0.880 MB Righe restituite: 0

SELECT `session_id`

  FROM `t6ml7_session`

  WHERE `session_id` = '7c60416950b78f4a31e3a47b219263d3' 
  LIMIT 1

Explain

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

Profilo

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
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:413
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.78 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.003 MB memoria prima della query: 0.885 MB

INSERT INTO `t6ml7_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('7c60416950b78f4a31e3a47b219263d3', 1, '1725850233', 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `t6ml7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('7c60416950b78f4a31e3a47b219263d3', 1, '1725850233', 0, '', 0)

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.40 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
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:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Tempo della query: 1.70 ms Dopo l'ultima query: 6.13 ms Memoria query: 0.023 MB memoria prima della query: 0.908 MB Righe restituite: 37

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

  FROM `t6ml7_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t6ml7_extensions	ref	extension	extension	82	const	37	Using index condition

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.82 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.04 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.27 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.51 ms Dopo l'ultima query: 6.67 ms Memoria query: 0.021 MB memoria prima della query: 0.999 MB Righe restituite: 5

SELECT id, rules

  FROM `t6ml7_viewlevels`

Explain

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

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.96 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
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:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.34 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.021 MB memoria prima della query: 1.011 MB Righe restituite: 1

SELECT b.id

  FROM t6ml7_usergroups AS a

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

  WHERE a.id = 1

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	1	Using where; Using index

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.74 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
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:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.01 ms Dopo l'ultima query: 1.77 ms Memoria query: 0.030 MB memoria prima della query: 1.032 MB Righe restituite: 88

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM t6ml7_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t6ml7_extensions	ALL	extension	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	212	Using where; Using filesort

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.52 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
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:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.47 ms Dopo l'ultima query: 48.07 ms Memoria query: 0.028 MB memoria prima della query: 1.539 MB Righe restituite: 12

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

  LEFT JOIN t6ml7_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	58	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.m.component_id	1	Using where

Profilo

Status	Duration
Starting	0.17 ms
checking permissions	0.01 ms
Opening tables	1.85 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.08 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.38 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.48 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
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:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.89 ms Dopo l'ultima query: 27.15 ms Memoria query: 0.024 MB memoria prima della query: 1.729 MB Righe restituite: 4

SELECT id, home, template, s.params

  FROM t6ml7_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	Using where; Using join buffer (flat, BNL join)

Profilo

Status	Duration
Starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.78 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.42 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
16	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:359
15	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:706
14	JHtml::script()	JROOT/libraries/cms/html/html.php:233
13	JHtml::call()	JROOT/libraries/cms/html/html.php:140
12	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	JROOT/libraries/cms/html/html.php:233
10	JHtml::call()	JROOT/libraries/cms/html/html.php:140
9	JHtml::_()	JROOT/plugins/system/solidres/solidres.php:32
8	plgSystemSolidres->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.57 ms Dopo l'ultima query: 2.70 ms Memoria query: 0.026 MB memoria prima della query: 1.779 MB Righe restituite: 1

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

  FROM `t6ml7_extensions`

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

Explain

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

Profilo

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
23	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
22	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
21	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
20	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
19	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
18	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
17	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
16	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
15	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:725
14	JHtml::script()	JROOT/libraries/cms/html/html.php:233
13	JHtml::call()	JROOT/libraries/cms/html/html.php:140
12	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	JROOT/libraries/cms/html/html.php:233
10	JHtml::call()	JROOT/libraries/cms/html/html.php:140
9	JHtml::_()	JROOT/plugins/system/solidres/solidres.php:32
8	plgSystemSolidres->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.87 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.009 MB memoria prima della query: 1.773 MB

UPDATE `t6ml7_extensions`

  SET `params` = '{\"mediaversion\":\"7d9c88ac0654df689aecd3f0a6bc254c\"}'

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

Explain

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

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.06 ms
Updating	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.41 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
19	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
18	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
17	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
16	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
15	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:725
14	JHtml::script()	JROOT/libraries/cms/html/html.php:233
13	JHtml::call()	JROOT/libraries/cms/html/html.php:140
12	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	JROOT/libraries/cms/html/html.php:233
10	JHtml::call()	JROOT/libraries/cms/html/html.php:140
9	JHtml::_()	JROOT/plugins/system/solidres/solidres.php:32
8	plgSystemSolidres->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
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.64 ms Dopo l'ultima query: 7.16 ms Memoria query: 0.019 MB memoria prima della query: 1.882 MB Righe restituite: 1

SELECT *

  FROM t6ml7_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t6ml7_languages	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using where; Using filesort

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	1.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.04 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.89 ms Dopo l'ultima query: 15.32 ms Memoria query: 0.028 MB memoria prima della query: 2.055 MB Righe restituite: 37

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `t6ml7_assets`

  WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_cmsmanager','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_solidres','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')

Explain

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

Profilo

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.97 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.04 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.10 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.24 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:434
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:74
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:265
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.63 ms Dopo l'ultima query: 2.24 ms Memoria query: 0.070 MB memoria prima della query: 2.113 MB Righe restituite: 1

SELECT a.*,l.title AS language_title,ua.name AS author_name

  FROM t6ml7_sppagebuilder as a

  LEFT JOIN `t6ml7_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN t6ml7_users AS ua 
  ON ua.id = a.created_user_id

  WHERE a.id = 1 
  AND a.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	8	const	1
1	SIMPLE	l	const	idx_langcode	idx_langcode	28	const	0	Unique row not found
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	1.84 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.11 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.94 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.18 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:82
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:74
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:265
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: 1.12 ms Memoria query: 0.028 MB memoria prima della query: 2.147 MB Righe restituite: 18

SHOW FULL COLUMNS 
  FROM `t6ml7_sppagebuilder`

Explain

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

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.11 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.14 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:19
13	SppagebuilderTablePage->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:126
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:74
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.69 ms Dopo l'ultima query: 2.20 ms Memoria query: 0.070 MB memoria prima della query: 2.180 MB Righe restituite: 1

SELECT *

  FROM t6ml7_sppagebuilder

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t6ml7_sppagebuilder	const	PRIMARY	PRIMARY	8	const	1

Profilo

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.15 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_sppagebuilder/models/page.php:127
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:74
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:265
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.84 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.006 MB memoria prima della query: 2.210 MB

UPDATE t6ml7_sppagebuilder

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

  WHERE `id` = '1'

Explain

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

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.04 ms
Updating	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.38 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
12	JTable->hit()	JROOT/components/com_sppagebuilder/models/page.php:128
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:35
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:74
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:265
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.39 ms Dopo l'ultima query: 88.42 ms Memoria query: 0.025 MB memoria prima della query: 2.474 MB Righe restituite: 5

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

  FROM t6ml7_modules AS m

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

  LEFT JOIN t6ml7_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-09-09 02:50:33') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-09 02:50:33') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 437 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	ALL	PRIMARY,published,newsfeeds	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	29	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	ffqcrsgd_sito.m.module,const	1	Using index condition; Using where

Profilo

Status	Duration
Starting	0.18 ms
checking permissions	0.01 ms
Opening tables	1.29 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.05 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.24 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:508
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:455
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:264
8	Helix3::generatelayout()	JROOT/templates/shaper_resort/index.php:157
7	require JROOT/templates/shaper_resort/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
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.61 ms Dopo l'ultima query: 67.30 ms Memoria query: 0.026 MB memoria prima della query: 2.676 MB Righe restituite: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM t6ml7_fields AS a

  LEFT JOIN `t6ml7_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN t6ml7_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN t6ml7_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN t6ml7_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN t6ml7_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ffqcrsgd_sito.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ffqcrsgd_sito.a.group_id	1	Using where

Profilo

Status	Duration
Starting	0.22 ms
checking permissions	0.01 ms
Opening tables	2.52 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.10 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	1.15 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
20	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
19	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
18	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:140
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
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.30 ms Dopo l'ultima query: 27.68 ms Memoria query: 0.026 MB memoria prima della query: 3.019 MB Righe restituite: 81

SELECT * 
  FROM t6ml7_acymailing_config

Explain

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

Profilo

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.68 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
10	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
9	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1369
8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:140
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
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: 4.50 ms Memoria query: 0.004 MB memoria prima della query: 3.121 MB

LOCK TABLES `t6ml7_extensions` WRITE

Explain

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

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:543
8	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:79
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
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.91 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.004 MB memoria prima della query: 3.125 MB

UPDATE `t6ml7_extensions`

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

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

Explain

EXPLAIN non possibile sulla query: UPDATE `t6ml7_extensions` SET `params` = '{\"lastrun\":1725850233}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
init for update	0.09 ms
Updating	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.43 ms
Query end	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/updatenotification/updatenotification.php:90
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
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.30 ms Dopo l'ultima query: 3.33 ms Memoria query: 0.004 MB memoria prima della query: 3.139 MB

UNLOCK TABLES

Explain

EXPLAIN non possibile sulla query: UNLOCK TABLES

Profilo

Status	Duration
Starting	0.10 ms
Commit implicit	0.01 ms
starting	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
starting	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:918
8	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:104
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
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.04 ms Dopo l'ultima query: 2.54 ms Memoria query: 0.021 MB memoria prima della query: 3.150 MB Righe restituite: 0

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

  FROM `t6ml7_update_sites` AS `a`

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	16	Using where; Using temporary
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	8	ffqcrsgd_sito.a.update_site_id,const	1	Using index; Distinct

Profilo

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	1.66 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Creating tmp table	0.06 ms
Executing	0.02 ms
Sending data	0.64 ms
Removing tmp table	0.09 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
10	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/updater/updater.php:232
9	JUpdater->getUpdateSites()	JROOT/libraries/joomla/updater/updater.php:119
8	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
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]

24 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

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

1 × SELECT `data` 
  FROM `t6ml7_session`

1 × SELECT `session_id` 
  FROM `t6ml7_session`

1 × SELECT id, rules 
  FROM `t6ml7_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM t6ml7_extensions

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

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

```
1 × SELECT * 
  FROM t6ml7_languages
```

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `t6ml7_assets`

1 × SELECT a.*,l.title AS language_title,ua.name AS author_name 
  FROM t6ml7_sppagebuilder as a 
  LEFT JOIN `t6ml7_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN t6ml7_users AS ua 
  ON ua.id = a.created_user_id

1 × SELECT * 
  FROM t6ml7_sppagebuilder

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

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM t6ml7_fields AS a 
  LEFT JOIN `t6ml7_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN t6ml7_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN t6ml7_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN t6ml7_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN t6ml7_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT * 
  FROM t6ml7_acymailing_confi

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

ALTRE tabelle:

```
1 × DELETE  
  FROM `t6ml7_session`
```

1 × INSERT INTO `t6ml7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('7c60416950b78f4a31e3a47b219263d3', 1, '1725850233', 0, '', 0

1 × UPDATE `t6ml7_extensions` 
  SET `params` = '{\"mediaversion\":\"7d9c88ac0654df689aecd3f0a6bc254c\"}'

1 × SHOW FULL COLUMNS 
  FROM `t6ml7_sppagebuilder

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

1 × LOCK TABLES `t6ml7_extensions` WRIT

1 × UPDATE `t6ml7_extensions` 
  SET `params` = '{\"lastrun\":1725850233}'

```
1 × UNLOCK TABLE
```