Informativa

Questo sito o gli strumenti terzi da questo utilizzati si avvalgono di cookie necessari al funzionamento ed utili alle finalità illustrate nella cookie policy. Se vuoi saperne di più o negare il consenso a tutti o ad alcuni cookie, consulta la cookie policy.
Chiudendo questo banner, scorrendo questa pagina, cliccando su un link o proseguendo la navigazione in altra maniera, acconsenti all’uso dei cookie.

News da Villario

Dettagli: Categoria: Blog; Creato: 09 Novembre 2015

Aggiornata la carta dei servizi. Consultabile nella relativa sezione, troverete tutto ciò che include la Carta dei Servizi.

Dettagli: Categoria: Blog; Creato: 10 Novembre 2015

Siamo lieti di invitarvi il 19 Dicembre PV al concerto lirico che si terrà presso la Nuova Villa Rio, dove saremo omaggiati dalla dolce voce di Marie e dalle luminose note del "nostro" amatissimo Don Bruno

Dettagli: Categoria: Blog; Creato: 02 Novembre 2015

Finalmente online il nuovo sito di Villario. Rivisitato sotto ogni aspetto, oltre che ad essere informativo per l'utente circa la nostra Struttura, sarà uno strumento fondamentale per la comunicazione delle attività e di tutto ciò che avviene a Villa Rio. Restate in contatto

SCROLL TO TOP

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1725940492,
                "last": 1725940492,
                "now": 1725940492
            }
        },
        "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: 20.00 ms / 20.00 ms Memoria: 0.711 MB / 0.95 MB Application: afterLoad

Tempo: 65.11 ms / 85.11 ms Memoria: 5.275 MB / 6.22 MB Application: afterInitialise

Tempo: 7.86 ms / 92.97 ms Memoria: 0.579 MB / 6.80 MB Application: afterRoute

Tempo: 2.78 ms / 95.75 ms Memoria: 0.083 MB / 6.88 MB Application: beforeRenderComponent com_content

Tempo: 19.22 ms / 114.96 ms Memoria: 1.323 MB / 8.21 MB Application: Start JAccess::getAssetRules Old (1)

Tempo: 1.98 ms / 116.94 ms Memoria: 0.065 MB / 8.27 MB Application: Finish JAccess::getAssetRules Old (1)

Tempo: 0.06 ms / 117.00 ms Memoria: 0.000 MB / 8.27 MB Application: New JAccess Preloading Process(com_content.category)

Tempo: 1.59 ms / 118.59 ms Memoria: 0.086 MB / 8.35 MB Application: After preloadPermissionsParentIdMapping (com_content.category)

Tempo: 4.64 ms / 123.23 ms Memoria: 0.143 MB / 8.49 MB Application: After preloadPermissions (com_content.category)

Tempo: 0.02 ms / 123.25 ms Memoria: 0.002 MB / 8.50 MB Application: End New JAccess Preloading Process(com_content.category)

Tempo: 0.02 ms / 123.27 ms Memoria: 0.002 MB / 8.50 MB Application: Start JAccess::getAssetRules New (com_content.category.9)

Tempo: 0.11 ms / 123.38 ms Memoria: 0.011 MB / 8.51 MB Application: Finish JAccess::getAssetRules New (com_content.category.9)

Tempo: 11.91 ms / 135.29 ms Memoria: 0.380 MB / 8.89 MB Application: Start JAccess::preload(components)

Tempo: 6.84 ms / 142.13 ms Memoria: 0.339 MB / 9.23 MB Application: Finish JAccess::preload(components)

Tempo: 49.92 ms / 192.04 ms Memoria: 1.418 MB / 10.65 MB Application: afterRenderComponent com_content

Tempo: 2.24 ms / 194.28 ms Memoria: 0.060 MB / 10.71 MB Application: afterDispatch

Tempo: 11.91 ms / 206.19 ms Memoria: 0.443 MB / 11.15 MB Application: beforeRenderModule mod_tags_popular (TAG POPOLARI)

Tempo: 12.06 ms / 218.25 ms Memoria: 0.189 MB / 11.34 MB Application: afterRenderModule mod_tags_popular (TAG POPOLARI)

Tempo: 0.06 ms / 218.31 ms Memoria: 0.000 MB / 11.33 MB Application: beforeRenderModule mod_articles_archive (ARCHIVIO)

Tempo: 5.25 ms / 223.56 ms Memoria: 0.046 MB / 11.37 MB Application: afterRenderModule mod_articles_archive (ARCHIVIO)

Tempo: 4.02 ms / 227.58 ms Memoria: 0.127 MB / 11.50 MB Application: afterRender

Query totali del database: 44.65 ms

Utilizzo memoria

Query Database

27 query eseguite 44.65 ms

Tempo della query: 0.83 ms Memoria query: 0.018 MB memoria prima della query: 2.968 MB Righe restituite: 0

SELECT `data`

  FROM `vil1_session`

  WHERE `session_id` = '3jm59r4ksf2ap28hfv2sg2ouk5'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vil1_session	const	PRIMARY	PRIMARY	602	const	1

Profilo

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Tempo della query: 0.67 ms Dopo l'ultima query: 2.90 ms Memoria query: 0.012 MB memoria prima della query: 3.176 MB Righe restituite: 0

SELECT `session_id`

  FROM `vil1_session`

  WHERE `session_id` = '3jm59r4ksf2ap28hfv2sg2ouk5' 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Tempo della query: 0.82 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.009 MB memoria prima della query: 3.192 MB

INSERT INTO `vil1_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('3jm59r4ksf2ap28hfv2sg2ouk5', 0, 1, '1725940492', 0, '')

Explain

EXPLAIN non possibile sulla query: INSERT INTO `vil1_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('3jm59r4ksf2ap28hfv2sg2ouk5', 0, 1, '1725940492', 0, '')

Profilo

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Tempo della query: 1.06 ms Dopo l'ultima query: 2.89 ms Memoria query: 0.017 MB memoria prima della query: 3.449 MB Righe restituite: 34

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

  FROM `vil1_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vil1_extensions	ref	extension	extension	62	const	34	Using index condition

Profilo

Status	Duration
Starting	0.15 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.02 ms
Optimizing	0.01 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.08 ms
Starting cleanup	0.01 ms
Freeing items	0.08 ms
Updating status	0.09 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.87 ms Dopo l'ultima query: 1.72 ms Memoria query: 0.015 MB memoria prima della query: 3.652 MB Righe restituite: 2

SELECT b.id

  FROM vil1_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.60 ms Dopo l'ultima query: 0.69 ms Memoria query: 0.015 MB memoria prima della query: 3.729 MB Righe restituite: 5

SELECT id, rules

  FROM `vil1_viewlevels`

Explain

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

Profilo

Status	Duration
Starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.03 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.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.18 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.013 MB memoria prima della query: 3.747 MB Righe restituite: 41

SELECT folder AS type, element AS name, params

  FROM vil1_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vil1_extensions	ALL	extension	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	180	Using where; Using filesort

Profilo

Status	Duration
Starting	0.12 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.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.03 ms
Sending data	0.01 ms
Creating sort index	0.40 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.05 ms
Starting cleanup	0.01 ms
Freeing items	0.08 ms
Updating status	0.08 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.99 ms Dopo l'ultima query: 8.84 ms Memoria query: 0.035 MB memoria prima della query: 4.601 MB Righe restituite: 30

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM vil1_menu AS m

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

Profilo

Status	Duration
Starting	0.20 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.03 ms
table lock	0.01 ms
init	0.06 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.04 ms
Creating sort index	0.92 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.08 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.09 ms
Reset for next command	0.07 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
12	JApplicationSite->getTemplate()	JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php:861
11	require_once JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php	JROOT/libraries/zauan/shortcodes/shortcodes.php:290
10	include_once JROOT/libraries/zauan/shortcodes/shortcodes.php	JROOT/libraries/loader.php:219
9	JLoader::import()	JROOT/libraries/loader.php:682
8	jimport()	JROOT/plugins/system/hg_assets/hg_assets.php:16
7	require_once JROOT/plugins/system/hg_assets/hg_assets.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.15 ms Dopo l'ultima query: 1.06 ms Memoria query: 0.025 MB memoria prima della query: 4.983 MB Righe restituite: 4

SELECT id, home, template, s.params

  FROM vil1_template_styles as s

  LEFT JOIN vil1_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	62	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	Using where; Using join buffer (flat, BNL join)

Profilo

Status	Duration
Starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.12 ms
Preparing	0.06 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
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.09 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.09 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
12	JApplicationSite->getTemplate()	JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php:861
11	require_once JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php	JROOT/libraries/zauan/shortcodes/shortcodes.php:290
10	include_once JROOT/libraries/zauan/shortcodes/shortcodes.php	JROOT/libraries/loader.php:219
9	JLoader::import()	JROOT/libraries/loader.php:682
8	jimport()	JROOT/plugins/system/hg_assets/hg_assets.php:16
7	require_once JROOT/plugins/system/hg_assets/hg_assets.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.00 ms Dopo l'ultima query: 7.33 ms Memoria query: 0.024 MB memoria prima della query: 5.650 MB Righe restituite: 1

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

  FROM `vil1_extensions`

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

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
18	JDatabaseDriver->loadObject()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/fmalertcookies/fmalertcookies.php:35
9	plgSystemFmAlertCookies->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.92 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.018 MB memoria prima della query: 5.657 MB

UPDATE `vil1_extensions`

  SET `params` = '{\"mediaversion\":\"0d22dbfd2f974cdc2595898be7ac4eda\"}'

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

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/fmalertcookies/fmalertcookies.php:35
9	plgSystemFmAlertCookies->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.17 ms Dopo l'ultima query: 13.45 ms Memoria query: 0.014 MB memoria prima della query: 6.857 MB Righe restituite: 2

SELECT *

  FROM vil1_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vil1_languages	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 2.86 ms Dopo l'ultima query: 14.82 ms Memoria query: 0.033 MB memoria prima della query: 8.111 MB Righe restituite: 8

SHOW FULL COLUMNS 
  FROM `vil1_assets`

Explain

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

Profilo

Status	Duration
Starting	0.34 ms
checking permissions	0.02 ms
closing tables	0.01 ms
Opening tables	0.81 ms
After opening tables	0.05 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.04 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
checking permissions	0.16 ms
closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.03 ms
Removing tmp table	0.40 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.06 ms
Freeing items	0.13 ms
Updating status	0.16 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.14 ms Dopo l'ultima query: 1.20 ms Memoria query: 0.028 MB memoria prima della query: 8.185 MB Righe restituite: 1

SELECT *

  FROM vil1_assets

  WHERE `id` = '1'

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.10 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.024 MB memoria prima della query: 8.207 MB Righe restituite: 1

SELECT a.rules

  FROM vil1_assets AS a

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,152	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profilo

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.30 ms Dopo l'ultima query: 0.94 ms Memoria query: 0.028 MB memoria prima della query: 8.268 MB Righe restituite: 84

SELECT a.id, a.parent_id

  FROM vil1_assets AS a

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

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
18	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.43 ms Dopo l'ultima query: 3.07 ms Memoria query: 0.029 MB memoria prima della query: 8.379 MB Righe restituite: 84

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

  FROM vil1_assets AS a

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

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
19	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 4.45 ms Dopo l'ultima query: 2.50 ms Memoria query: 0.030 MB memoria prima della query: 8.638 MB Righe restituite: 5

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,COUNT(i.`id`) AS numitems

  FROM vil1_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM vil1_categories AS cat JOIN vil1_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

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

  LEFT JOIN `vil1_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

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

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	20	Using where
1	PRIMARY	i	ref\|filter	idx_state,idx_catid	idx_catid\|idx_state	4\|1	ugs4ll8x_villa.c.id	2 (35%)	Using where; Using rowid filter
1	PRIMARY	<derived2>	ref	key0	key0	5	ugs4ll8x_villa.c.id	4	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152	const	7	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	20	Using where; Using index; Using join buffer (flat, BNL join)

Profilo

Status	Duration
Starting	0.34 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.20 ms
Optimizing	0.12 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Statistics	0.31 ms
Preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.04 ms
Preparing	0.07 ms
Creating tmp table	0.27 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	0.17 ms
Executing	0.01 ms
Sending data	0.21 ms
Creating sort index	0.04 ms
Removing tmp table	0.02 ms
Creating sort index	1.07 ms
Creating sort index	0.12 ms
Removing tmp table	0.37 ms
Creating sort index	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.07 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.09 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/models/category.php:354
13	ContentModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.19 ms Dopo l'ultima query: 5.69 ms Memoria query: 0.030 MB memoria prima della query: 8.886 MB Righe restituite: 34

SELECT element

  FROM vil1_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vil1_extensions	ref	extension	extension	62	const	34	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
22	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.49 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.031 MB memoria prima della query: 8.922 MB Righe restituite: 34

SELECT a.name, a.rules

  FROM vil1_assets AS a

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_asset_name	idx_asset_name	152	NULL	35	Using index condition

Profilo

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
22	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 2.90 ms Dopo l'ultima query: 3.78 ms Memoria query: 0.034 MB memoria prima della query: 9.222 MB Righe restituite: 3

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM vil1_content AS a

  LEFT JOIN vil1_categories AS c 
  ON c.id = a.catid

  LEFT JOIN vil1_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN vil1_users AS uam 
  ON uam.id = a.modified_by

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM vil1_categories AS cat JOIN vil1_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 9 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-10 03:54:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-10 03:54:52')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	14	Using where; Using filesort
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	ugs4ll8x_villa.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	ugs4ll8x_villa.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	ugs4ll8x_villa.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	Using where
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152	const	7	Using index condition; Using where

Profilo

Status	Duration
Starting	0.41 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.16 ms
Optimizing	0.07 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Statistics	0.18 ms
Preparing	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.21 ms
Executing	0.01 ms
Sending data	0.12 ms
Executing	0.01 ms
Sending data	0.07 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.02 ms
Sending data	0.07 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.04 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
closing tables	0.01 ms
Removing tmp table	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.09 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.76 ms Dopo l'ultima query: 2.91 ms Memoria query: 0.024 MB memoria prima della query: 9.473 MB Righe restituite: 1

SELECT COUNT(*)

  FROM vil1_content AS a

  LEFT JOIN vil1_categories AS c 
  ON c.id = a.catid

  LEFT JOIN vil1_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN vil1_users AS uam 
  ON uam.id = a.modified_by

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM vil1_categories AS cat JOIN vil1_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 9 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-10 03:54:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-10 03:54:52')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	14	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	Using where
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152	const	7	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.01 ms Dopo l'ultima query: 2.78 ms Memoria query: 0.026 MB memoria prima della query: 9.661 MB Righe restituite: 0

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

  FROM `vil1_contentitem_tag_map` AS m 

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

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

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:217
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 3.63 ms Dopo l'ultima query: 17.74 ms Memoria query: 0.039 MB memoria prima della query: 10.583 MB Righe restituite: 5

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 vil1_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM vil1_categories AS cat JOIN vil1_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

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

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

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	20	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	ugs4ll8x_villa.c.id	4	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152	const	7	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	20	Using where; Using index; Using join buffer (flat, BNL join)

Profilo

Status	Duration
Starting	0.38 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.19 ms
Optimizing	0.06 ms
Optimizing	0.02 ms
Statistics	0.13 ms
Statistics	0.17 ms
Preparing	0.04 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.07 ms
Creating tmp table	0.14 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
Executing	0.01 ms
Sending data	0.21 ms
Creating sort index	0.04 ms
Removing tmp table	0.02 ms
Creating sort index	0.76 ms
Creating sort index	0.15 ms
Removing tmp table	0.36 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.13 ms
Updating status	0.11 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
21	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
20	ContentHelperRoute::getArticleRoute()	JROOT/templates/ammon_v2/html/layouts/joomla/content/blog_style_default_item_title.php:25
19	include JROOT/templates/ammon_v2/html/layouts/joomla/content/blog_style_default_item_title.php	JROOT/libraries/cms/layout/file.php:121
18	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
17	JLayoutHelper::render()	JROOT/templates/ammon_v2/html/com_content/category/blog_item.php:23
16	include JROOT/templates/ammon_v2/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/ammon_v2/html/com_content/category/blog.php:61
14	include JROOT/templates/ammon_v2/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 3.15 ms Dopo l'ultima query: 22.09 ms Memoria query: 0.023 MB memoria prima della query: 11.087 MB Righe restituite: 22

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

  FROM vil1_modules AS m

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

  LEFT JOIN vil1_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-10 03:54:52') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-10 03:54:52') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 106 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:514
8	JDocumentHtml->countModules()	JROOT/templates/ammon_v2/index.php:49
7	require JROOT/templates/ammon_v2/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 3.89 ms Dopo l'ultima query: 10.04 ms Memoria query: 0.022 MB memoria prima della query: 11.252 MB Righe restituite: 2

SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params

  FROM `vil1_contentitem_tag_map` AS `m`

  INNER JOIN `vil1_tags` AS `t` 
  ON `tag_id` = t.id

  INNER JOIN `vil1_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

  WHERE `t`.`access` IN (1,1,5) 
  AND `t`.`published` = 1  
  AND `m`.`type_alias` = `c`.`core_type_alias` 
  AND `c`.`core_state` = 1 
  AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2024-09-10 03:54:52') 
  AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2024-09-10 03:54:52')

  GROUP BY `tag_id`,`title`,`access`,`alias`

  ORDER BY `count` DESC 
  LIMIT 7

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type,idx_tag,idx_core_content_id	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	Using temporary; Using filesort
1	SIMPLE	c	eq_ref\|filter	PRIMARY,tag_idx,idx_content_type	idx_content_type\|tag_idx	771\|1	ugs4ll8x_villa.m.type_alias,ugs4ll8x_villa.m.core_content_id	1 (23%)	Using where; Using rowid filter
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	Using where; Using join buffer (flat, BNL join)

Profilo

Status	Duration
Starting	0.29 ms
checking permissions	0.02 ms
Opening tables	0.15 ms
After opening tables	0.03 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.12 ms
Optimizing	0.07 ms
Statistics	0.34 ms
Preparing	0.12 ms
Creating tmp table	0.11 ms
Sorting result	0.05 ms
Executing	0.01 ms
Sending data	1.35 ms
Creating sort index	0.17 ms
Removing tmp table	0.42 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.10 ms
Starting cleanup	0.02 ms
Freeing items	0.14 ms
Updating status	0.12 ms
Reset for next command	0.06 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:127
14	ModTagsPopularHelper::getList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:582
11	JModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
10	include JROOT/modules/mod_tags_popular/mod_tags_popular.php	JROOT/libraries/cms/module/helper.php:199
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:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.08 ms Dopo l'ultima query: 7.23 ms Memoria query: 0.019 MB memoria prima della query: 11.374 MB Righe restituite: 0

SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year

  FROM vil1_content

  WHERE state = 2

  GROUP BY YEAR(`created`), MONTH(`created`)

  ORDER BY YEAR(`created`) DESC, MONTH(`created`) DESC 
  LIMIT 4

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vil1_content	ref	idx_state	idx_state	1	const	1	Using where; Using temporary; Using filesort

Profilo

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_articles_archive/helper.php:53
11	ModArchiveHelper::getList()	JROOT/modules/mod_articles_archive/mod_articles_archive.php:17
10	include JROOT/modules/mod_articles_archive/mod_articles_archive.php	JROOT/libraries/cms/module/helper.php:199
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:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

26 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM vil1_content AS a 
  LEFT JOIN vil1_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN vil1_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN vil1_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN vil1_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN vil1_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM vil1_categories AS cat JOIN vil1_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

1 × SELECT element 
  FROM vil1_extensions

1 × SELECT COUNT(*) 
  FROM vil1_content AS a 
  LEFT JOIN vil1_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN vil1_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN vil1_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN vil1_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN vil1_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM vil1_categories AS cat JOIN vil1_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  FROM vil1_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM vil1_categories AS cat JOIN vil1_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

1 × SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year 
  FROM vil1_content

1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params 
  FROM `vil1_contentitem_tag_map` AS `m` 
  INNER JOIN `vil1_tags` AS `t` 
  ON `tag_id` = t.id 
  INNER JOIN `vil1_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

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

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

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

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

1 × SELECT folder AS type, element AS name, params 
  FROM vil1_extensions

1 × SELECT id, rules 
  FROM `vil1_viewlevels

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

1 × SELECT `session_id` 
  FROM `vil1_session`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM vil1_menu AS m 
  LEFT JOIN vil1_extensions AS e 
  ON m.component_id = e.extension_id

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

1 × SELECT a.rules 
  FROM vil1_assets AS a

```
1 × SELECT * 
  FROM vil1_assets
```
```
1 × SELECT * 
  FROM vil1_languages
```

1 × SELECT `data` 
  FROM `vil1_session`

ALTRE tabelle:

1 × SHOW FULL COLUMNS 
  FROM `vil1_assets

1 × UPDATE `vil1_extensions` 
  SET `params` = '{\"mediaversion\":\"0d22dbfd2f974cdc2595898be7ac4eda\"}'

1 × INSERT INTO `vil1_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('3jm59r4ksf2ap28hfv2sg2ouk5', 0, 1, '1725940492', 0, ''

News da Villario

Aggiornata la Carta dei Servizi

Concerto lirico di Natale

Nasce il nuovo sito nuovavillario.it

TAG POPOLARI

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

27 query eseguite 44.65 ms

26 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: