Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; AzrulJXTemplate has a deprecated constructor in /web/htdocs/www.sandrinimpianti.it/home/plugins/system/azrul.system/pc_includes/template.php on line 15

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; AzrulJXCachedTemplate has a deprecated constructor in /web/htdocs/www.sandrinimpianti.it/home/plugins/system/azrul.system/pc_includes/template.php on line 64

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; JAXResponse has a deprecated constructor in /web/htdocs/www.sandrinimpianti.it/home/plugins/system/azrul.system/pc_includes/ajax.php on line 50

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; JAX has a deprecated constructor in /web/htdocs/www.sandrinimpianti.it/home/plugins/system/azrul.system/pc_includes/ajax.php on line 208

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Services_JSON has a deprecated constructor in /web/htdocs/www.sandrinimpianti.it/home/plugins/system/azrul.system/pc_includes/JSON.php on line 117

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Services_JSON_Error has a deprecated constructor in /web/htdocs/www.sandrinimpianti.it/home/plugins/system/azrul.system/pc_includes/JSON.php on line 783

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Services_JSON_Error has a deprecated constructor in /web/htdocs/www.sandrinimpianti.it/home/plugins/system/azrul.system/pc_includes/JSON.php on line 797

Warning: count(): Parameter must be an array or an object that implements Countable in /web/htdocs/www.sandrinimpianti.it/home/libraries/cms/application/cms.php on line 477
Privacy

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgContentJComments has a deprecated constructor in /web/htdocs/www.sandrinimpianti.it/home/plugins/content/jcomments/jcomments.php on line 25

Informazioni sul trattamento dei dati personali

Perché la Sandrini Impianti tratta i tuoi dati personali?

Il trattamento dei dati personali avviene per dar corso alle attività preliminari e conseguenti alla gestione del rapporto contrattuale instaurato, per la gestione dei pagamenti nonché per l’adempimento di ogni altro obbligo discendente dal contratto, quali la registrazione e l’archiviazione dei dati personali.

I dati saranno trattati anche per tutte le attività connesse o strumentali, funzionalmente legate all’operatività della Società o alla tutela dei suoi diritti tra cui ad esempio: le finalità assicurative; la gestione delle commesse e la verifica della qualità interna; l’adempimento degli obblighi legali, contabili, fiscali, amministrativi; la gestione del potenziale contenzioso con il Cliente, sia in fase giudiziale che stragiudiziale.

I dati personali potranno essere altresì utilizzati per inoltrare specifiche comunicazioni e informazioni inerenti agli obblighi o alle scadenze contrattuali, alle modalità di erogazione del servizio o eventuali esigenze operative aziendali.

Nel caso in cui sia necessario per fornire assistenza e/o garantire e verificare il corretto funzionamento degli impianti, la Sandrini Impianti potrebbe accedere ai sistemi da remoto e/o collegandosi ai portali messi a disposizione del cliente dai diversi produttori. Tali accessi verranno effettuati solo nel caso in cui siano necessari per fornire i servizi richiesti dal cliente.

Che cosa succede se non fornisci i dati?

Se non fornisci i dati personali la Sandrini Impianti non potrà dar seguito ai trattamenti legati alla gestione del contratto e dei servizi ad esso collegati né agli adempimenti che da essi dipendono.

Categorie di destinatari dei dati personali

Potranno accedere ai dati personali solamente persone autorizzate al trattamento e soggetti che, trattando dati per conto della Società, sono stati individuati quali Responsabili. Tali soggetti sono tenuti al segreto e alla riservatezza anche sulla base di apposito regolamento interno.

I dati raccolti per le finalità sopra in elenco potrebbero essere comunicati a istituti bancari, assicurazioni (per la gestione di eventuali rischi assicurati), amministrazioni finanziarie, studi legali, arbitri, società di recupero crediti (per la tutela giudiziale o stragiudiziale), spedizionieri e vettori e, qualora sia necessario per adempiere al contratto concluso, a altre società e/o imprese (anche partner della Sandrini Impianti), consulenti, fornitori tecnici, ecc.

Tali comunicazioni di dati personali sono necessarie perché effettuate sulla base di un obbligo legale o contrattuale oppure requisito necessario per la conclusione di un contratto o, infine, per il perseguimento di un legittimo interesse.

Come e per quanto tempo vengono conservati i dati?

Come

Il trattamento dei dati è eseguito attraverso supporti cartacei o procedure informatiche da parte di soggetti appositamente autorizzati e formati. A questi è consentito l’accesso ai tuoi dati personali nella misura e nei limiti in cui ciò è necessario per lo svolgimento delle attività di trattamento che ti riguardano.

Dove

I dati sono conservati in archivi cartacei, informatici e telematici situati all’interno dello spazio economico europeo. I dati personali non sono trasferiti in Paesi extra UE.

Quanto tempo

I dati personali sono trattati per il tempo necessario al conseguimento delle finalità per le quali sono stati raccolti o per qualsiasi altra legittima finalità collegata. Pertanto, se i dati personali sono trattati per differenti finalità, tali dati verranno conservati fino a che non scadrà la finalità con il termine più lungo; tuttavia essi non saranno più trattati per le finalità il cui periodo di conservazione sia venuto meno.

I dati personali non più necessari, o per i quali non vi sia più un presupposto giuridico per la relativa conservazione, verranno anonimizzati irreversibilmente (o cancellati definitivamente).

In particolare, i dati personali forniti per le finalità primarie saranno conservati per un periodo individuato secondo criteri di stretta necessità in ragione delle diverse finalità perseguite e, comunque, nel rispetto della vigente normativa in materia di protezione dei dati personali, di conservazione delle scritture contabili e della documentazione commerciale (conformemente a quanto disposto dall'art. 2220 c.c.) e secondo logiche di tutela dei diritti della Società (a titolo esemplificativo: termini di prescrizione di cui al Codice Civile).

Nel caso in cui alcuni trattamenti siano oggetto di contestazione e/o alcuni dati siano necessari per l’esercizio di un diritto in sede giudiziaria, la conservazione potrà superare i limiti sopra riportati, estendendosi fino alla definizione del contenzioso.

Quali sono i miei diritti?

Per chiedere qualsiasi chiarimento relativo al trattamento dei dati personali, è possibile contattare la Sandrini Impianti ai seguenti recapiti: e-mail Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. - telefono +39 0481888666

Per quanto attiene all'esercizio dei diritti riconosciuti dal Regolamento (UE) 2016/679 la Sandrini Impianti ti ricorda che hai diritto di chiedere:

- l'accesso ai dati personali e alle informazioni (art. 15 del GDPR);

- la rettifica o la cancellazione degli stessi (artt. 16 e 17 del GDPR);

- la limitazione del trattamento dei dati personali (art. 18 del GDPR).

Infine, potrai:

- opporti al trattamento dei dati personali alle condizioni e nei limiti di cui all’art. 21 del GDPR;

- esercitare il diritto alla portabilità dei dati (art. 20 GDPR).

Per quanto attiene alle operazioni di trattamento basate sul consenso -ai sensi dell’articolo 6, paragrafo 1, lett. a), e dell’articolo 9, paragrafo 2, lett. a) del GDPR-, si ricorda che hai diritto di revocare tale consenso in qualsiasi momento (senza pregiudicare la liceità del trattamento basata sul consenso prestato prima della revoca).

Infine, qualora tu ritenga che il trattamento che ti riguarda violi il Regolamento, hai diritto di proporre reclamo a un’autorità di controllo (Garante per la protezione dei dati personali o altra autorità eventualmente competente) ai sensi dell’art. 77 e ss. GDPR.

Domotica, Impianti elettrici, anti intrusione, controllo e sicurezza, energie rinnovabili, costruzione piscine e impianti.

Sandrini Impianti, via del Filatoio 11
34072 Farra d'Isonzo (Gorizia)
tel. 0481 888666

Seguici su Facebook

Cosa fa Sandrini?

Warning: count(): Parameter must be an array or an object that implements Countable in /web/htdocs/www.sandrinimpianti.it/home/libraries/tzm/sources/modules/modules.php on line 22

Resta aggiornato

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1726670273,
                "last": 1726670273,
                "now": 1726670273
            },
            "token": "ROyf8twXhOdmTrWQQfusbA4LYytyInYO"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "132c89a6b16374a5f37239fbe5a94e57b5e3115a": {
                    "link": "https:\/\/www.sandrinimpianti.it\/privacy.html",
                    "expiry": 1726670274
                }
            }
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 111.89 ms / 111.89 ms Memoria: 0.202 MB / 0.58 MB Application: afterLoad

Tempo: 322.90 ms / 434.79 ms Memoria: 1.211 MB / 1.79 MB Application: afterInitialise

Tempo: 223.64 ms / 658.43 ms Memoria: 1.668 MB / 3.46 MB Application: afterRoute

Tempo: 2.76 ms / 661.19 ms Memoria: 0.035 MB / 3.49 MB Application: beforeRenderComponent com_content

Tempo: 21.88 ms / 683.07 ms Memoria: 0.427 MB / 3.92 MB Application: Before JAccess::preloadComponents (all components)

Tempo: 4.91 ms / 687.98 ms Memoria: 0.057 MB / 3.98 MB Application: After JAccess::preloadComponents (all components)

Tempo: 0.05 ms / 688.03 ms Memoria: 0.000 MB / 3.97 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Tempo: 2.78 ms / 690.82 ms Memoria: 0.027 MB / 4.00 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Tempo: 139.31 ms / 830.12 ms Memoria: 1.938 MB / 5.94 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Tempo: 0.09 ms / 830.21 ms Memoria: 0.007 MB / 5.95 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Tempo: 75.54 ms / 905.76 ms Memoria: 1.852 MB / 7.80 MB Application: afterRenderComponent com_content

Tempo: 6.48 ms / 912.24 ms Memoria: 0.020 MB / 7.82 MB Application: afterDispatch

Tempo: 147.79 ms / 1060.03 ms Memoria: 11.084 MB / 18.90 MB Application: beforeRenderModule mod_menu (Footer Menu)

Tempo: 22.36 ms / 1082.39 ms Memoria: 0.115 MB / 19.02 MB Application: afterRenderModule mod_menu (Footer Menu)

Tempo: 3.58 ms / 1085.97 ms Memoria: 0.000 MB / 19.00 MB Application: beforeRenderModule mod_mylivechat (MyLiveChat)

Tempo: 3.94 ms / 1089.91 ms Memoria: 0.020 MB / 19.02 MB Application: afterRenderModule mod_mylivechat (MyLiveChat)

Tempo: 257.96 ms / 1347.88 ms Memoria: 0.131 MB / 19.15 MB Application: beforeRenderModule mod_tz_news_pro (Cosa fa Sandrini?)

Tempo: 38.12 ms / 1386.00 ms Memoria: 0.564 MB / 19.71 MB Application: afterRenderModule mod_tz_news_pro (Cosa fa Sandrini?)

Tempo: 305.31 ms / 1691.31 ms Memoria: 0.000 MB / 9.59 MB Application: afterRender

Query totali del database: 74.49 ms

Utilizzo memoria

Query Database

17 query eseguite 74.49 ms

Tempo della query: 1.96 ms Memoria query: 0.003 MB memoria prima della query: 0.966 MB

DELETE 

  FROM `ecw3r_session`

  WHERE `time` < '1726580273'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_session	range	time	time	45	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.06 ms
updating	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
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: 1.49 ms Memoria query: 0.024 MB memoria prima della query: 0.975 MB Righe restituite: 0

SELECT `data`

  FROM `ecw3r_session`

  WHERE `session_id` = 'osn1a2vsh8o243hjo0vkjjpd7a'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_session	const	PRIMARY	PRIMARY	575	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 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
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
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:832
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
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.77 ms Dopo l'ultima query: 5.97 ms Memoria query: 0.021 MB memoria prima della query: 0.989 MB Righe restituite: 0

SELECT `session_id`

  FROM `ecw3r_session`

  WHERE `session_id` = 'osn1a2vsh8o243hjo0vkjjpd7a' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_session	const	PRIMARY	PRIMARY	575	const	1	100.00	Using index

Profilo

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:834
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
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.11 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.003 MB memoria prima della query: 0.994 MB

INSERT INTO `ecw3r_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('osn1a2vsh8o243hjo0vkjjpd7a', 1, '1726670273', 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `ecw3r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('osn1a2vsh8o243hjo0vkjjpd7a', 1, '1726670273', 0, '', 0)

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.17 ms
Waiting for query cache lock	0.01 ms
update	0.14 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.11 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:217
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:834
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
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.83 ms Dopo l'ultima query: 47.59 ms Memoria query: 0.022 MB memoria prima della query: 1.208 MB Righe restituite: 2

SELECT b.id

  FROM ecw3r_usergroups AS a

  LEFT JOIN ecw3r_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	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.06 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
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
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:272
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.90 ms Dopo l'ultima query: 4.16 ms Memoria query: 0.023 MB memoria prima della query: 1.214 MB Righe restituite: 5

SELECT id, rules

  FROM `ecw3r_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_viewlevels	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
System lock	0.12 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.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 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.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
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:272
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.12 ms Dopo l'ultima query: 295.53 ms Memoria query: 0.006 MB memoria prima della query: 2.683 MB

UPDATE `ecw3r_extensions`

  SET `params` = '{\"mediaversion\":\"879476e92467ff2fdf20464765addd84\"}'

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
8	plgSystemJComments->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:1158
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:272
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.32 ms Dopo l'ultima query: 94.14 ms Memoria query: 0.030 MB memoria prima della query: 3.923 MB Righe restituite: 39

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

  FROM `ecw3r_assets`

  WHERE `name` IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_foxcontact','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_tz_multipurpose','com_tz_portfolio','com_uniterevolution2','com_users','com_weblinks','com_wrapper','com_xmap') OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_assets	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	152,4	NULL	40	100.00	Using sort_union(idx_asset_name,idx_parent_id); Using where

Profilo

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:434
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:272
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: 7.08 ms Dopo l'ultima query: 7.40 ms Memoria query: 0.036 MB memoria prima della query: 4.051 MB Righe restituite: 30

SHOW FULL COLUMNS 
  FROM `ecw3r_content`

Explain

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

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.38 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	5.20 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.28 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.16 ms Dopo l'ultima query: 17.63 ms Memoria query: 0.046 MB memoria prima della query: 4.325 MB Righe restituite: 1

SELECT *

  FROM ecw3r_content

  WHERE `id` = '92'

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:272
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.76 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.005 MB memoria prima della query: 4.353 MB

UPDATE ecw3r_content

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

  WHERE `id` = '92'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_content	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
10	JTable->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:272
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.97 ms Dopo l'ultima query: 8.97 ms Memoria query: 0.037 MB memoria prima della query: 4.462 MB Righe restituite: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM ecw3r_content AS a

  INNER JOIN ecw3r_categories AS c 
  on c.id = a.catid

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

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

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

  WHERE a.id = 92 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-18 14:37:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-18 14:37:54') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.02 ms
checking query cache for query	0.23 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	3.34 ms
init	0.11 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.08 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.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.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
13	ContentModelArticle->getItem()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:272
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: 11.33 ms Memoria query: 0.039 MB memoria prima della query: 4.724 MB Righe restituite: 2

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

  FROM ecw3r_categories as c

  LEFT JOIN ecw3r_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	70.59	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.05 ms
checking query cache for query	0.24 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.13 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.07 ms
optimizing	0.03 ms
statistics	0.23 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
Creating sort index	0.21 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.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
21	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
20	JCategories->get()	JROOT/components/com_content/router.php:70
19	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
18	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
17	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
16	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
15	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:272
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: 16.35 ms Dopo l'ultima query: 0.75 ms Memoria query: 0.035 MB memoria prima della query: 4.764 MB Righe restituite: 0

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

  FROM `ecw3r_contentitem_tag_map` AS m 

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

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

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	15.40 ms
init	0.06 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.07 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.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
12	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:180
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:272
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: 19.60 ms Dopo l'ultima query: 189.39 ms Memoria query: 0.031 MB memoria prima della query: 8.415 MB Righe restituite: 14

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

  FROM ecw3r_modules AS m

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

  LEFT JOIN ecw3r_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-18 14:37:54') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-18 14:37:54') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 517 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	191	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	Sql1009297_1.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql1009297_1.m.id	3	100.00	Using where; Using index

Profilo

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:424
17	JModuleHelper::_load()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:102
16	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
15	JDocumentHtml->countModules()	JROOT/plugins/system/plazart/includes/core/template.php:1471
14	PlazartTemplate::countModules()	JROOT/plugins/system/plazart/includes/core/template.php:998
13	PlazartTemplate::showRow()	JROOT/plugins/system/plazart/includes/core/template.php:1118
12	PlazartTemplate->generatelayout()	JROOT/plugins/system/plazart/includes/core/template.php:1445
11	PlazartTemplate::layout()	JROOT/templates/tz_jollyany_joomla/layouts/default.php:38
10	include JROOT/templates/tz_jollyany_joomla/layouts/default.php	JROOT/plugins/system/plazart/includes/core/template.php:138
9	PlazartTemplate->loadLayout()	JROOT/templates/tz_jollyany_joomla/libraries/plazart.render.php:67
8	PlazartRender->__construct()	JROOT/templates/tz_jollyany_joomla/index.php:26
7	require JROOT/templates/tz_jollyany_joomla/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:1105
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
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: 7.49 ms Dopo l'ultima query: 385.26 ms Memoria query: 0.058 MB memoria prima della query: 19.311 MB Righe restituite: 6

SELECT ct.*,cat.title as category_title,cat.id as catid, cat.alias as category_alias,us.id,us.name as author,tz_xc.type as type_media,tz_xc.*

  FROM ecw3r_content as ct

  LEFT JOIN ecw3r_categories as cat 
  on cat.id = ct.catid

  LEFT JOIN ecw3r_users as us 
  on us.id = ct.created_by

  LEFT JOIN ecw3r_tz_portfolio_xref_content as tz_xc 
  on tz_xc.contentid = ct.id

  WHERE (tz_xc.type not in('audio','quote','link') or tz_xc.type is null) 
  AND  ct.catid IN(8) 
  and ct.state = 1  
  ORDER BY ct.created DESC 
  LIMIT 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ct	index_merge	idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	5	80.00	Using intersect(idx_catid,idx_state); Using where; Using temporary; Using filesort
1	SIMPLE	cat	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	us	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	tz_xc	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where; Using join buffer (Block Nested Loop)

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	1.60 ms
init	0.11 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.07 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.07 ms
Creating tmp table	0.23 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	3.11 ms
Creating sort index	0.22 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.20 ms
end	0.13 ms
removing tmp table	0.56 ms
end	0.01 ms
query end	0.00 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.08 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tz_news_pro/helper.php:105
11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:45
10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
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:474
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:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
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.85 ms Dopo l'ultima query: 11.23 ms Memoria query: 0.037 MB memoria prima della query: 19.710 MB Righe restituite: 2

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

  FROM ecw3r_categories as c

  LEFT JOIN ecw3r_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	70.59	Using where

Profilo

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
13	JCategories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:45
12	TZ_PortfolioHelperRoute::getArticleRoute()	JROOT/modules/mod_tz_news_pro/helper.php:148
11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:45
10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
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:474
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:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
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]

16 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM ecw3r_categories as c 
  LEFT JOIN ecw3r_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

1 × SELECT `data` 
  FROM `ecw3r_session`

1 × SELECT `session_id` 
  FROM `ecw3r_session`

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

1 × SELECT id, rules 
  FROM `ecw3r_viewlevels

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

```
1 × SELECT * 
  FROM ecw3r_content
```

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM ecw3r_content AS a 
  INNER JOIN ecw3r_categories AS c 
  on c.id = a.catid 
  LEFT JOIN ecw3r_users AS u 
  on u.id = a.created_by 
  LEFT JOIN ecw3r_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ecw3r_content_rating AS v 
  ON a.id = v.content_id

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

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ecw3r_modules AS m 
  LEFT JOIN ecw3r_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ecw3r_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT ct.*,cat.title as category_title,cat.id as catid, cat.alias as category_alias,us.id,us.name as author,tz_xc.type as type_media,tz_xc.* 
  FROM ecw3r_content as ct 
  LEFT JOIN ecw3r_categories as cat 
  on cat.id = ct.catid 
  LEFT JOIN ecw3r_users as us 
  on us.id = ct.created_by 
  LEFT JOIN ecw3r_tz_portfolio_xref_content as tz_xc 
  on tz_xc.contentid = ct.id

ALTRE tabelle:

```
1 × DELETE  
  FROM `ecw3r_session`
```

1 × INSERT INTO `ecw3r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('osn1a2vsh8o243hjo0vkjjpd7a', 1, '1726670273', 0, '', 0

1 × UPDATE `ecw3r_extensions` 
  SET `params` = '{\"mediaversion\":\"879476e92467ff2fdf20464765addd84\"}'

1 × SHOW FULL COLUMNS 
  FROM `ecw3r_content

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