Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1686236402,
                "last": 1686236402,
                "now": 1686236402
            }
        },
        "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": {
                "c299d705f9d5274350e8b9ceae211e784a8855e0": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/orai-e-biglietti-per-il-palazzo-farnese.html",
                    "expiry": 1686236403
                },
                "b454ccd4284c5d57872e306bf656306fddf891bb": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/i-giardini-e-il-parco.html",
                    "expiry": 1686236403
                },
                "0047c41712eb2de01816024a835e32b855145f8f": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/casina-del-piacere.html",
                    "expiry": 1686236403
                },
                "4bd489da909a5b7895f47dd4cf3f6ff2841ac6b2": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/come-arrivare-a-palazzo.html",
                    "expiry": 1686236403
                },
                "a2479db21f39d64eea87c19209fd87fbde6b26e1": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/il-cortile-circolare.html",
                    "expiry": 1686236403
                },
                "17dda26cc164c87c2a674b4120742c01be415d17": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/682-orari-e-disposizioni-visite-palazzo-farnese-post-covid.html",
                    "expiry": 1686236403
                },
                "70d5a23aed370b9a67fc7f72591035a6b373a35c": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/dove-parcheggiare.html",
                    "expiry": 1686236403
                },
                "6a6f85354db5e6e3405e3f71f6f3373deff28973": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/666-video-sul-palazzo-farnese.html",
                    "expiry": 1686236403
                },
                "420a9467376bf45dd8ccc94e124e499e654894f3": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/le-stanze-e-gli-affreschi\/640-stanza-degli-angeli.html",
                    "expiry": 1686236403
                },
                "611ccfaedd948979480e3bb99b774f7414ac7dac": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/la-cappella.html",
                    "expiry": 1686236403
                },
                "72b1fa3bba0a69e6ce2d28828953e0877bc9870b": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/le-stanze-e-gli-affreschi\/639-stanza-dei-sogni.html",
                    "expiry": 1686236403
                }
            }
        }
    }
}

Informazioni profilo

Tempo

Memoria

**Tempo**: 91.42 ms / 91.42 ms **Memoria**: 0.043 MB / 0.39 MB Application: afterLoad

**Tempo**: 127.72 ms / 219.14 ms **Memoria**: 0.662 MB / 1.06 MB Application: Before JAccess::preloadComponents (all components)

**Tempo**: 0.79 ms / 219.93 ms **Memoria**: 0.054 MB / 1.11 MB Application: After JAccess::preloadComponents (all components)

**Tempo**: 0.04 ms / 219.96 ms **Memoria**: 0.000 MB / 1.11 MB Application: Before JAccess::getAssetRules (id:23 name:com_templates)

**Tempo**: 2.48 ms / 222.44 ms **Memoria**: 0.013 MB / 1.12 MB Application: After JAccess::getAssetRules (id:23 name:com_templates)

**Tempo**: 41.46 ms / 263.90 ms **Memoria**: 0.249 MB / 1.37 MB Application: afterInitialise

**Tempo**: 147.04 ms / 410.94 ms **Memoria**: 0.645 MB / 2.02 MB Application: afterRoute

**Tempo**: 7.58 ms / 418.52 ms **Memoria**: 0.049 MB / 2.06 MB Application: beforeRenderComponent com_content

**Tempo**: 29.25 ms / 447.77 ms **Memoria**: 0.169 MB / 2.23 MB Application: Before JAccess::preloadPermissions (com_content)

**Tempo**: 1.87 ms / 449.64 ms **Memoria**: 0.609 MB / 2.84 MB Application: After JAccess::preloadPermissions (com_content)

**Tempo**: 0.04 ms / 449.68 ms **Memoria**: 0.000 MB / 2.81 MB Application: Before JAccess::getAssetRules (id:1154 name:com_content.category.98)

**Tempo**: 0.06 ms / 449.74 ms **Memoria**: 0.007 MB / 2.82 MB Application: After JAccess::getAssetRules (id:1154 name:com_content.category.98)

**Tempo**: 13.22 ms / 462.96 ms **Memoria**: 0.040 MB / 2.85 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

**Tempo**: 0.02 ms / 462.98 ms **Memoria**: 0.002 MB / 2.86 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

**Tempo**: 345.25 ms / 808.23 ms **Memoria**: 1.258 MB / 4.11 MB Application: afterRenderComponent com_content

**Tempo**: 3.08 ms / 811.31 ms **Memoria**: 0.005 MB / 4.12 MB Application: afterDispatch

**Tempo**: 20.91 ms / 832.22 ms **Memoria**: 0.167 MB / 4.29 MB Application: beforeRenderModule mod_menu ()

**Tempo**: 125.89 ms / 958.11 ms **Memoria**: 0.928 MB / 5.22 MB Application: afterRenderModule mod_menu ()

**Tempo**: 56.70 ms / 1014.82 ms **Memoria**: 0.065 MB / 5.28 MB Application: beforeRenderModule mod_menu ()

**Tempo**: 42.19 ms / 1057.01 ms **Memoria**: 0.016 MB / 5.30 MB Application: afterRenderModule mod_menu ()

**Tempo**: 5.67 ms / 1062.68 ms **Memoria**: 0.000 MB / 5.24 MB Application: beforeRenderModule mod_custom (Informazioni sul sito)

**Tempo**: 7.54 ms / 1070.22 ms **Memoria**: 0.006 MB / 5.24 MB Application: afterRenderModule mod_custom (Informazioni sul sito)

**Tempo**: 0.08 ms / 1070.30 ms **Memoria**: 0.000 MB / 5.24 MB Application: beforeRenderModule mod_custom (Social)

**Tempo**: 2.96 ms / 1073.26 ms **Memoria**: 0.004 MB / 5.25 MB Application: afterRenderModule mod_custom (Social)

**Tempo**: 0.07 ms / 1073.33 ms **Memoria**: 0.000 MB / 5.24 MB Application: beforeRenderModule mod_menu (Risorse esterne)

**Tempo**: 13.67 ms / 1087.00 ms **Memoria**: 0.022 MB / 5.27 MB Application: afterRenderModule mod_menu (Risorse esterne)

**Tempo**: 0.08 ms / 1087.08 ms **Memoria**: 0.000 MB / 5.26 MB Application: beforeRenderModule mod_menu (Altri siti su Caprarola)

**Tempo**: 9.42 ms / 1096.50 ms **Memoria**: 0.023 MB / 5.29 MB Application: afterRenderModule mod_menu (Altri siti su Caprarola)

**Tempo**: 0.09 ms / 1096.59 ms **Memoria**: 0.000 MB / 5.28 MB Application: beforeRenderModule mod_search (Cerca)

**Tempo**: 8.60 ms / 1105.19 ms **Memoria**: 0.019 MB / 5.30 MB Application: afterRenderModule mod_search (Cerca)

**Tempo**: 0.06 ms / 1105.25 ms **Memoria**: 0.000 MB / 5.30 MB Application: beforeRenderModule mod_menu (Menù Generale)

**Tempo**: 17.92 ms / 1123.17 ms **Memoria**: 0.142 MB / 5.44 MB Application: afterRenderModule mod_menu (Menù Generale)

**Tempo**: 0.06 ms / 1123.23 ms **Memoria**: 0.000 MB / 5.44 MB Application: beforeRenderModule mod_custom (amazon)

**Tempo**: 3.09 ms / 1126.32 ms **Memoria**: 0.006 MB / 5.44 MB Application: afterRenderModule mod_custom (amazon)

**Tempo**: 0.12 ms / 1126.43 ms **Memoria**: 0.000 MB / 5.44 MB Application: beforeRenderModule mod_syndicate (Syndication)

**Tempo**: 12.68 ms / 1139.11 ms **Memoria**: 0.007 MB / 5.45 MB Application: afterRenderModule mod_syndicate (Syndication)

**Tempo**: 0.04 ms / 1139.15 ms **Memoria**: 0.000 MB / 5.45 MB Application: beforeRenderModule mod_banners (Scopri il Palazzo Farnese)

**Tempo**: 19.76 ms / 1158.91 ms **Memoria**: 0.041 MB / 5.49 MB Application: afterRenderModule mod_banners (Scopri il Palazzo Farnese)

**Tempo**: 0.04 ms / 1158.94 ms **Memoria**: 0.000 MB / 5.48 MB Application: beforeRenderModule mod_banners (ufficio turistico)

**Tempo**: 5.42 ms / 1164.37 ms **Memoria**: 0.028 MB / 5.51 MB Application: afterRenderModule mod_banners (ufficio turistico)

**Tempo**: 0.04 ms / 1164.40 ms **Memoria**: 0.000 MB / 5.51 MB Application: beforeRenderModule mod_custom (banner-120-dx)

**Tempo**: 2.60 ms / 1167.01 ms **Memoria**: 0.004 MB / 5.51 MB Application: afterRenderModule mod_custom (banner-120-dx)

**Tempo**: 0.06 ms / 1167.07 ms **Memoria**: 0.000 MB / 5.51 MB Application: beforeRenderModule mod_custom (Video cesti)

**Tempo**: 2.79 ms / 1169.86 ms **Memoria**: 0.004 MB / 5.51 MB Application: afterRenderModule mod_custom (Video cesti)

**Tempo**: 0.06 ms / 1169.93 ms **Memoria**: 0.000 MB / 5.51 MB Application: beforeRenderModule mod_banners (DOVE MANGIARE A CAPRAROLA)

**Tempo**: 5.45 ms / 1175.37 ms **Memoria**: 0.029 MB / 5.54 MB Application: afterRenderModule mod_banners (DOVE MANGIARE A CAPRAROLA)

**Tempo**: 0.06 ms / 1175.43 ms **Memoria**: 0.000 MB / 5.54 MB Application: beforeRenderModule mod_menu (Menu top)

**Tempo**: 1.87 ms / 1177.30 ms **Memoria**: 0.003 MB / 5.54 MB Application: afterRenderModule mod_menu (Menu top)

**Tempo**: 0.03 ms / 1177.34 ms **Memoria**: 0.000 MB / 5.54 MB Application: beforeRenderModule mod_banners (Trattoria Tipica a Caprarola)

**Tempo**: 4.74 ms / 1182.08 ms **Memoria**: 0.028 MB / 5.57 MB Application: afterRenderModule mod_banners (Trattoria Tipica a Caprarola)

**Tempo**: 0.06 ms / 1182.14 ms **Memoria**: 0.000 MB / 5.56 MB Application: beforeRenderModule mod_banners (Delizie 300)

**Tempo**: 6.32 ms / 1188.46 ms **Memoria**: 0.041 MB / 5.60 MB Application: afterRenderModule mod_banners (Delizie 300)

**Tempo**: 0.06 ms / 1188.52 ms **Memoria**: 0.000 MB / 5.60 MB Application: beforeRenderModule mod_banners (Visite Guidate)

**Tempo**: 5.33 ms / 1193.85 ms **Memoria**: 0.028 MB / 5.63 MB Application: afterRenderModule mod_banners (Visite Guidate)

**Tempo**: 0.06 ms / 1193.91 ms **Memoria**: 0.000 MB / 5.62 MB Application: beforeRenderModule mod_custom (Top-testo)

**Tempo**: 3.23 ms / 1197.13 ms **Memoria**: 0.004 MB / 5.63 MB Application: afterRenderModule mod_custom (Top-testo)

**Tempo**: 0.07 ms / 1197.20 ms **Memoria**: 0.000 MB / 5.62 MB Application: beforeRenderModule mod_custom (logo-template)

**Tempo**: 2.78 ms / 1199.98 ms **Memoria**: 0.004 MB / 5.63 MB Application: afterRenderModule mod_custom (logo-template)

**Tempo**: 7.08 ms / 1207.06 ms **Memoria**: 0.137 MB / 5.77 MB Application: afterRender

**Query totali del database: 76.37 ms**

Utilizzo memoria

Query Database

117 query eseguite 76.37 ms

Trovati 63 duplicati!

**4 duplicati**: #8 #10 #13 #14

**9 duplicati**: #45 #46 #63 #68 #69 #70 #78 #87 #92

**16 duplicati**: #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #61 #62

**4 duplicati**: #64 #65 #66 #67

**7 duplicati**: #71 #72 #73 #74 #75 #76 #77

**8 duplicati**: #79 #80 #81 #82 #83 #84 #85 #86

**4 duplicati**: #88 #89 #90 #91

**5 duplicati**: #93 #94 #95 #96 #97

**6 duplicati**: #98 #101 #104 #107 #110 #115

**Tempo della query: 0.46 ms** **Memoria query: 0.023 MB memoria prima della query: 0.676 MB** **Righe restituite: 0**

SELECT `data`

  FROM `j25_session`

  WHERE `session_id` = 'tedi05d2jf35ghhep34v46d5tk'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_session	const	PRIMARY	PRIMARY	575	const	1

**Profilo**

Error
The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

**Call Stack**

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

SELECT `session_id`

  FROM `j25_session`

  WHERE `session_id` = 'tedi05d2jf35ghhep34v46d5tk' 
  LIMIT 1

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php: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: 0.33 ms** **Dopo l'ultima query: 0.15 ms** **Memoria query: 0.003 MB memoria prima della query: 0.695 MB**

INSERT INTO `j25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('tedi05d2jf35ghhep34v46d5tk', 1, '1686236402', 0, '', 0)

**Explain**

**EXPLAIN non possibile sulla query: INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('tedi05d2jf35ghhep34v46d5tk', 1, '1686236402', 0, '', 0)**

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
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.47 ms** **Dopo l'ultima query: 9.49 ms** **Memoria query: 0.023 MB memoria prima della query: 0.719 MB** **Righe restituite: 39**

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

  FROM `j25_extensions`

  WHERE `type` = 'component'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_extensions	ref	extension	extension	62	const	33	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php: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.32 ms** **Dopo l'ultima query: 11.05 ms** **Memoria query: 0.021 MB memoria prima della query: 0.744 MB** **Righe restituite: 1**

SELECT b.id

  FROM j25_usergroups AS a

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

  WHERE a.id = 1

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php: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.33 ms** **Dopo l'ultima query: 2.44 ms** **Memoria query: 0.021 MB memoria prima della query: 0.748 MB** **Righe restituite: 3**

SELECT id, rules

  FROM `j25_viewlevels`

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php: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: 0.59 ms** **Dopo l'ultima query: 0.12 ms** **Memoria query: 0.041 MB memoria prima della query: 0.775 MB** **Righe restituite: 74**

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

  FROM j25_extensions

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

  ORDER BY ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_extensions	ref	extension	extension	62	const	128	Using where; Using filesort

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
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.46 ms** **Dopo l'ultima query: 31.50 ms** **Memoria query: 0.020 MB memoria prima della query: 1.049 MB** **Righe restituite: 1**

**Query duplicate**: #10 #13 #14

SELECT a.template

  FROM `j25_template_styles` AS a

  WHERE client_id = 0 
  AND a.home = 1

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:504
8	Yjsg::getDefaultTemplate()	JROOT/plugins/system/yjsg/yjsg.php:122
7	plgSystemYjsg->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:689
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
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.54 ms** **Dopo l'ultima query: 1.36 ms** **Memoria query: 0.025 MB memoria prima della query: 1.062 MB** **Righe restituite: 38**

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

  FROM `j25_assets`

  WHERE `name` IN ('com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper') OR `parent_id` = 0

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
12	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
11	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
10	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
9	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
8	JUser->authorise()	JROOT/plugins/system/yjsg/yjsg.php:132
7	plgSystemYjsg->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:689
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
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.37 ms** **Dopo l'ultima query: 2.67 ms** **Memoria query: 0.020 MB memoria prima della query: 1.121 MB** **Righe restituite: 1**

**Query duplicate**: #8 #13 #14

SELECT a.template

  FROM `j25_template_styles` AS a

  WHERE client_id = 0 
  AND a.home = 1

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:504
8	Yjsg::getDefaultTemplate()	JROOT/plugins/system/yjsg/yjsg.php:133
7	plgSystemYjsg->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:689
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
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.87 ms** **Dopo l'ultima query: 47.53 ms** **Memoria query: 0.166 MB memoria prima della query: 1.398 MB** **Righe restituite: 106**

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

  LEFT JOIN j25_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	101	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.m.component_id	1

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:450
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:555
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1148
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: 0.40 ms** **Dopo l'ultima query: 70.34 ms** **Memoria query: 0.021 MB memoria prima della query: 1.886 MB** **Righe restituite: 6**

SELECT id, home, template, s.params

  FROM j25_template_styles as s

  LEFT JOIN j25_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	s	ALL	idx_template	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	Sql274670_3.s.template,const	1	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
9	JApplicationSite->getTemplate()	JROOT/plugins/system/yjsg/yjsg.php:231
8	plgSystemYjsg->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: 0.39 ms** **Dopo l'ultima query: 5.89 ms** **Memoria query: 0.021 MB memoria prima della query: 1.915 MB** **Righe restituite: 1**

**Query duplicate**: #8 #10 #14

SELECT a.template

  FROM `j25_template_styles` AS a

  WHERE client_id = 0 
  AND a.home = 1

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:504
10	Yjsg::getDefaultTemplate()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:565
9	Yjsg->cleanup()	JROOT/plugins/system/yjsg/yjsg.php:240
8	plgSystemYjsg->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: 0.30 ms** **Dopo l'ultima query: 1.90 ms** **Memoria query: 0.021 MB memoria prima della query: 1.921 MB** **Righe restituite: 1**

**Query duplicate**: #8 #10 #13

SELECT a.template

  FROM `j25_template_styles` AS a

  WHERE client_id = 0 
  AND a.home = 1

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:504
10	Yjsg::getDefaultTemplate()	JROOT/plugins/system/yjsg/yjsg.php:534
9	plgSystemYjsg->yjsgConstants()	JROOT/plugins/system/yjsg/yjsg.php:251
8	plgSystemYjsg->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: 0.35 ms** **Dopo l'ultima query: 59.18 ms** **Memoria query: 0.022 MB memoria prima della query: 2.035 MB** **Righe restituite: 1**

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

  FROM `j25_extensions`

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

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
12	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php: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.17 ms** **Memoria query: 0.005 MB memoria prima della query: 2.026 MB**

UPDATE `j25_extensions`

  SET `params` = '{\"mediaversion\":\"3ad3dd7bb5b4a8c7814ac7df5cd3d0b4\"}'

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

**Explain**

**EXPLAIN non possibile sulla query: UPDATE `j25_extensions` SET `params` = '{\"mediaversion\":\"3ad3dd7bb5b4a8c7814ac7df5cd3d0b4\"}' WHERE `type` = 'library' AND `element` = 'joomla'**

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php: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.39 ms** **Dopo l'ultima query: 3.30 ms** **Memoria query: 0.020 MB memoria prima della query: 2.057 MB** **Righe restituite: 2**

SELECT *

  FROM j25_languages

  WHERE published=1

  ORDER BY ordering ASC

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php: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.80 ms** **Dopo l'ultima query: 30.29 ms** **Memoria query: 0.130 MB memoria prima della query: 2.236 MB** **Righe restituite: 731**

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

  FROM `j25_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/components/com_content/models/category.php:142
13	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
12	JModelLegacy->getState()	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:671
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: 4.30 ms** **Dopo l'ultima query: 6.29 ms** **Memoria query: 0.025 MB memoria prima della query: 2.816 MB** **Righe restituite: 3**

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

  LEFT JOIN j25_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 `j25_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.published = 1 
  AND s.id=98

  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	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	55	Using where
1	SIMPLE	i	ref	idx_state,idx_catid	idx_catid	4	Sql274670_3.c.id	19

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
14	JCategories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:121
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 11.66 ms** **Dopo l'ultima query: 3.74 ms** **Memoria query: 0.130 MB memoria prima della query: 2.852 MB** **Righe restituite: 15**

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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM j25_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 98 OR a.catid IN (
SELECT sub.id

  FROM j25_categories as sub

  INNER JOIN j25_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 98)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-08 15:00:03') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-08 15:00:03')

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	range	PRIMARY,idx_access	idx_access	4	NULL	54	Using where; Using temporary; Using filesort
1	PRIMARY	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	Sql274670_3.c.id	19	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.created_by	1
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.modified_by	1
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.c.parent_id	1
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.id	1
2	DEPENDENT SUBQUERY	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	DEPENDENT SUBQUERY	sub	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	func	1	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.42 ms** **Dopo l'ultima query: 3.48 ms** **Memoria query: 0.026 MB memoria prima della query: 3.027 MB** **Righe restituite: 4**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.32 ms** **Dopo l'ultima query: 0.27 ms** **Memoria query: 0.024 MB memoria prima della query: 3.053 MB** **Righe restituite: 1**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.33 ms** **Dopo l'ultima query: 0.16 ms** **Memoria query: 0.026 MB memoria prima della query: 3.073 MB** **Righe restituite: 4**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.28 ms** **Dopo l'ultima query: 0.18 ms** **Memoria query: 0.024 MB memoria prima della query: 3.099 MB** **Righe restituite: 0**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.28 ms** **Dopo l'ultima query: 0.17 ms** **Memoria query: 0.024 MB memoria prima della query: 3.118 MB** **Righe restituite: 1**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.29 ms** **Dopo l'ultima query: 0.17 ms** **Memoria query: 0.025 MB memoria prima della query: 3.138 MB** **Righe restituite: 3**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.34 ms** **Dopo l'ultima query: 0.20 ms** **Memoria query: 0.025 MB memoria prima della query: 3.163 MB** **Righe restituite: 3**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.29 ms** **Dopo l'ultima query: 0.19 ms** **Memoria query: 0.025 MB memoria prima della query: 3.187 MB** **Righe restituite: 2**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.28 ms** **Dopo l'ultima query: 0.19 ms** **Memoria query: 0.024 MB memoria prima della query: 3.210 MB** **Righe restituite: 0**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.28 ms** **Dopo l'ultima query: 0.15 ms** **Memoria query: 0.025 MB memoria prima della query: 3.228 MB** **Righe restituite: 3**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.28 ms** **Dopo l'ultima query: 0.14 ms** **Memoria query: 0.025 MB memoria prima della query: 3.252 MB** **Righe restituite: 2**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.29 ms** **Dopo l'ultima query: 0.20 ms** **Memoria query: 0.025 MB memoria prima della query: 3.275 MB** **Righe restituite: 3**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.30 ms** **Dopo l'ultima query: 0.14 ms** **Memoria query: 0.028 MB memoria prima della query: 3.306 MB** **Righe restituite: 5**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.30 ms** **Dopo l'ultima query: 0.22 ms** **Memoria query: 0.026 MB memoria prima della query: 3.335 MB** **Righe restituite: 5**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.30 ms** **Dopo l'ultima query: 0.14 ms** **Memoria query: 0.026 MB memoria prima della query: 3.363 MB** **Righe restituite: 5**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 8.04 ms** **Dopo l'ultima query: 22.03 ms** **Memoria query: 0.024 MB memoria prima della query: 3.381 MB** **Righe restituite: 1**

SELECT COUNT(*)

  FROM j25_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 98 OR a.catid IN (
SELECT sub.id

  FROM j25_categories as sub

  INNER JOIN j25_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 98)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-08 15:00:03') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-08 15:00:03')

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	PRIMARY,idx_access	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	55	Using where
1	PRIMARY	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	Sql274670_3.c.id	19	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.created_by	1	Using index
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.modified_by	1	Using index
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.c.parent_id	1	Using index
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.id	1	Using index
2	DEPENDENT SUBQUERY	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	DEPENDENT SUBQUERY	sub	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	func	1	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.33 ms** **Dopo l'ultima query: 0.20 ms** **Memoria query: 0.024 MB memoria prima della query: 3.383 MB** **Righe restituite: 4**

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

  FROM `j25_contentitem_tag_map` AS m 

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

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	22	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Sql274670_3.t.id	28	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:225
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.51 ms** **Dopo l'ultima query: 29.33 ms** **Memoria query: 0.027 MB memoria prima della query: 3.538 MB** **Righe restituite: 3**

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

  LEFT JOIN j25_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) 
  AND c.published = 1 
  AND s.id=98

  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	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	55	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
18	JCategories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
17	FieldsModelFields->getListQuery()	JROOT/libraries/legacy/model/list.php:132
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
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: 0.35 ms** **Dopo l'ultima query: 0.20 ms** **Memoria query: 0.025 MB memoria prima della query: 3.561 MB** **Righe restituite: 0**

Palazzo Farnese a Caprarola - gioiello unico

Orari Palazzo Farnese Caprarola e biglietti

I Giardini di Palazzo Farnese

La Casina del Piacere e i Giardini alti

Come arrivare a Palazzo

Il Cortile Circolare

Orari e disposizioni visite Palazzo Farnese post COVID

Dove parcheggiare

Video sul Palazzo Farnese

Stanza degli Angeli, o stanza dell'eco

La Cappella

La Stanza dei Sogni e degli angeli messaggeri

Altri articoli...

Sottocategorie

DOVE MANGIARE A CAPRAROLA

Scopri il Palazzo Farnese

Cerca

Menù Generale

Altri siti su Caprarola

Risorse esterne

Social

Informazioni sul sito

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

117 query eseguite 76.37 ms

Trovati 63 duplicati!

Palazzo Farnese a Caprarola - gioiello unico

**Altri articoli...**

**Sottocategorie**

DOVE MANGIARE A CAPRAROLA

Scopri il Palazzo Farnese

Cerca

Menù Generale

Altri siti su Caprarola

Risorse esterne

Social

Informazioni sul sito

**Console Debug Joomla!**

**Sessione**

**Informazioni profilo**

**Tempo**

**Memoria**

**Utilizzo memoria**

**Query Database**

**117 query eseguite** 76.37 ms

**Trovati 63 duplicati!**

Altri articoli...

Sottocategorie

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

117 query eseguite 76.37 ms

Trovati 63 duplicati!