Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1675404761,
                "last": 1675404761,
                "now": 1675404761
            }
        },
        "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": {
                "8fb7d106c3f6f7347b6ecc426e247de7cd76c62a": {
                    "link": "http:\/\/www.caprarola.com\/eventi\/676-cioccofest-caprarola-ad-ottobre.html",
                    "expiry": 1675404762
                },
                "24d4f58edf315a9d380a71b907323e62556e0283": {
                    "link": "http:\/\/www.caprarola.com\/eventi\/675-caprarola-10-agosto-locus-amoenus-locus-terribilis-scientia-mundi.html",
                    "expiry": 1675404762
                },
                "1aec7cc2d64a01f619a7bb3c3fbfb0cdf0e513b7": {
                    "link": "http:\/\/www.caprarola.com\/cosa-vedere\/panorami\/669-caprarola-panorami-intensi.html",
                    "expiry": 1675404762
                },
                "4922fc2f8c74d542ba87fd4fdfbc4cc30869c4d4": {
                    "link": "http:\/\/www.caprarola.com\/turismo\/668-visitiamo-il-palazzo-farnese-domenica-24-marzo.html",
                    "expiry": 1675404762
                },
                "0c3cd5cfe48c11037731d5a45be0253de04547b5": {
                    "link": "http:\/\/www.caprarola.com\/cosa-vedere\/la-via-francigena-a-caprarola.html",
                    "expiry": 1675404762
                },
                "bf282685c3ca20e6d7fc8b3f41e582cc355260d5": {
                    "link": "http:\/\/www.caprarola.com\/lago-di-vico\/monte-venere.html",
                    "expiry": 1675404762
                },
                "611ccfaedd948979480e3bb99b774f7414ac7dac": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/la-cappella.html",
                    "expiry": 1675404762
                },
                "0047c41712eb2de01816024a835e32b855145f8f": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/casina-del-piacere.html",
                    "expiry": 1675404762
                },
                "a2479db21f39d64eea87c19209fd87fbde6b26e1": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/il-cortile-circolare.html",
                    "expiry": 1675404762
                },
                "70d5a23aed370b9a67fc7f72591035a6b373a35c": {
                    "link": "http:\/\/www.caprarola.com\/palazzo-farnese\/dove-parcheggiare.html",
                    "expiry": 1675404762
                },
                "36e919e28f5649a83b22afcae235dbd8661fda49": {
                    "link": "http:\/\/www.caprarola.com\/eventi\/644-date-e-orari-del-presepe-vivente-di-caprarola.html",
                    "expiry": 1675404762
                }
            }
        }
    }
}

Informazioni profilo

Tempo

Memoria

**Tempo**: 53.81 ms / 53.81 ms **Memoria**: 0.043 MB / 0.40 MB Application: afterLoad

**Tempo**: 82.29 ms / 136.10 ms **Memoria**: 0.667 MB / 1.06 MB Application: Before JAccess::preloadComponents (all components)

**Tempo**: 0.52 ms / 136.62 ms **Memoria**: 0.053 MB / 1.11 MB Application: After JAccess::preloadComponents (all components)

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

**Tempo**: 1.75 ms / 138.41 ms **Memoria**: 0.013 MB / 1.13 MB Application: After JAccess::getAssetRules (id:23 name:com_templates)

**Tempo**: 20.49 ms / 158.90 ms **Memoria**: 0.249 MB / 1.37 MB Application: afterInitialise

**Tempo**: 79.98 ms / 238.88 ms **Memoria**: 0.640 MB / 2.02 MB Application: afterRoute

**Tempo**: 6.19 ms / 245.07 ms **Memoria**: 0.049 MB / 2.06 MB Application: beforeRenderComponent com_content

**Tempo**: 18.36 ms / 263.42 ms **Memoria**: 0.069 MB / 2.13 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

**Tempo**: 0.10 ms / 263.53 ms **Memoria**: 0.007 MB / 2.14 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

**Tempo**: 315.65 ms / 579.17 ms **Memoria**: 1.478 MB / 3.62 MB Application: afterRenderComponent com_content

**Tempo**: 7.48 ms / 586.66 ms **Memoria**: 0.005 MB / 3.62 MB Application: afterDispatch

**Tempo**: 15.49 ms / 602.15 ms **Memoria**: 0.106 MB / 3.73 MB Application: beforeRenderModule mod_menu ()

**Tempo**: 99.22 ms / 701.36 ms **Memoria**: 0.930 MB / 4.66 MB Application: afterRenderModule mod_menu ()

**Tempo**: 47.66 ms / 749.02 ms **Memoria**: 0.065 MB / 4.73 MB Application: beforeRenderModule mod_menu ()

**Tempo**: 38.09 ms / 787.10 ms **Memoria**: 0.016 MB / 4.74 MB Application: afterRenderModule mod_menu ()

**Tempo**: 5.10 ms / 792.21 ms **Memoria**: 0.000 MB / 4.68 MB Application: beforeRenderModule mod_custom (Informazioni sul sito)

**Tempo**: 5.45 ms / 797.66 ms **Memoria**: 0.007 MB / 4.69 MB Application: afterRenderModule mod_custom (Informazioni sul sito)

**Tempo**: 0.09 ms / 797.75 ms **Memoria**: 0.000 MB / 4.69 MB Application: beforeRenderModule mod_custom (Social)

**Tempo**: 4.06 ms / 801.80 ms **Memoria**: 0.004 MB / 4.69 MB Application: afterRenderModule mod_custom (Social)

**Tempo**: 0.10 ms / 801.90 ms **Memoria**: 0.000 MB / 4.69 MB Application: beforeRenderModule mod_menu (Risorse esterne)

**Tempo**: 11.95 ms / 813.85 ms **Memoria**: 0.022 MB / 4.71 MB Application: afterRenderModule mod_menu (Risorse esterne)

**Tempo**: 0.09 ms / 813.94 ms **Memoria**: 0.000 MB / 4.71 MB Application: beforeRenderModule mod_menu (Altri siti su Caprarola)

**Tempo**: 9.32 ms / 823.26 ms **Memoria**: 0.023 MB / 4.73 MB Application: afterRenderModule mod_menu (Altri siti su Caprarola)

**Tempo**: 0.09 ms / 823.35 ms **Memoria**: 0.000 MB / 4.73 MB Application: beforeRenderModule mod_search (Cerca)

**Tempo**: 6.17 ms / 829.51 ms **Memoria**: 0.019 MB / 4.75 MB Application: afterRenderModule mod_search (Cerca)

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

**Tempo**: 14.28 ms / 843.86 ms **Memoria**: 0.149 MB / 4.89 MB Application: afterRenderModule mod_menu (Menù Generale)

**Tempo**: 0.06 ms / 843.92 ms **Memoria**: 0.000 MB / 4.89 MB Application: beforeRenderModule mod_custom (amazon)

**Tempo**: 2.64 ms / 846.56 ms **Memoria**: 0.004 MB / 4.89 MB Application: afterRenderModule mod_custom (amazon)

**Tempo**: 0.10 ms / 846.66 ms **Memoria**: 0.000 MB / 4.89 MB Application: beforeRenderModule mod_syndicate (Syndication)

**Tempo**: 9.14 ms / 855.80 ms **Memoria**: 0.007 MB / 4.90 MB Application: afterRenderModule mod_syndicate (Syndication)

**Tempo**: 0.07 ms / 855.87 ms **Memoria**: 0.000 MB / 4.90 MB Application: beforeRenderModule mod_banners (Scopri il Palazzo Farnese)

**Tempo**: 12.16 ms / 868.03 ms **Memoria**: 0.043 MB / 4.94 MB Application: afterRenderModule mod_banners (Scopri il Palazzo Farnese)

**Tempo**: 0.06 ms / 868.09 ms **Memoria**: 0.000 MB / 4.94 MB Application: beforeRenderModule mod_banners (ufficio turistico)

**Tempo**: 10.03 ms / 878.11 ms **Memoria**: 0.028 MB / 4.97 MB Application: afterRenderModule mod_banners (ufficio turistico)

**Tempo**: 0.06 ms / 878.17 ms **Memoria**: 0.000 MB / 4.96 MB Application: beforeRenderModule mod_custom (banner-120-dx)

**Tempo**: 2.77 ms / 880.94 ms **Memoria**: 0.004 MB / 4.96 MB Application: afterRenderModule mod_custom (banner-120-dx)

**Tempo**: 0.10 ms / 881.04 ms **Memoria**: 0.000 MB / 4.96 MB Application: beforeRenderModule mod_custom (Video cesti)

**Tempo**: 2.85 ms / 883.89 ms **Memoria**: 0.004 MB / 4.97 MB Application: afterRenderModule mod_custom (Video cesti)

**Tempo**: 0.10 ms / 883.98 ms **Memoria**: 0.000 MB / 4.97 MB Application: beforeRenderModule mod_banners (DOVE MANGIARE A CAPRAROLA)

**Tempo**: 16.77 ms / 900.76 ms **Memoria**: 0.029 MB / 5.00 MB Application: afterRenderModule mod_banners (DOVE MANGIARE A CAPRAROLA)

**Tempo**: 0.10 ms / 900.86 ms **Memoria**: 0.000 MB / 4.99 MB Application: beforeRenderModule mod_menu (Menu top)

**Tempo**: 1.27 ms / 902.13 ms **Memoria**: 0.003 MB / 4.99 MB Application: afterRenderModule mod_menu (Menu top)

**Tempo**: 0.04 ms / 902.17 ms **Memoria**: 0.000 MB / 4.99 MB Application: beforeRenderModule mod_banners (Trattoria Tipica a Caprarola)

**Tempo**: 22.62 ms / 924.79 ms **Memoria**: 0.028 MB / 5.02 MB Application: afterRenderModule mod_banners (Trattoria Tipica a Caprarola)

**Tempo**: 0.10 ms / 924.89 ms **Memoria**: 0.000 MB / 5.02 MB Application: beforeRenderModule mod_banners (Delizie 300)

**Tempo**: 38.89 ms / 963.78 ms **Memoria**: 0.035 MB / 5.05 MB Application: afterRenderModule mod_banners (Delizie 300)

**Tempo**: 0.14 ms / 963.92 ms **Memoria**: 0.000 MB / 5.05 MB Application: beforeRenderModule mod_banners (Visite Guidate)

**Tempo**: 37.34 ms / 1001.26 ms **Memoria**: 0.032 MB / 5.08 MB Application: afterRenderModule mod_banners (Visite Guidate)

**Tempo**: 0.08 ms / 1001.34 ms **Memoria**: 0.000 MB / 5.07 MB Application: beforeRenderModule mod_custom (Top-testo)

**Tempo**: 2.68 ms / 1004.02 ms **Memoria**: 0.004 MB / 5.08 MB Application: afterRenderModule mod_custom (Top-testo)

**Tempo**: 0.08 ms / 1004.10 ms **Memoria**: 0.000 MB / 5.08 MB Application: beforeRenderModule mod_custom (logo-template)

**Tempo**: 2.50 ms / 1006.60 ms **Memoria**: 0.004 MB / 5.08 MB Application: afterRenderModule mod_custom (logo-template)

**Tempo**: 5.73 ms / 1012.34 ms **Memoria**: 0.200 MB / 5.28 MB Application: afterRender

**Query totali del database: 188.40 ms**

Utilizzo memoria

Query Database

124 query eseguite 188.40 ms

Trovati 63 duplicati!

**4 duplicati**: #9 #11 #14 #15

**9 duplicati**: #53 #54 #71 #76 #77 #78 #86 #95 #100

**16 duplicati**: #55 #56 #57 #58 #59 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70

**4 duplicati**: #72 #73 #74 #75

**7 duplicati**: #79 #80 #81 #82 #83 #84 #85

**8 duplicati**: #87 #88 #89 #90 #91 #92 #93 #94

**4 duplicati**: #96 #97 #98 #99

**5 duplicati**: #101 #102 #103 #104 #105

**6 duplicati**: #106 #109 #112 #115 #118 #122

**Tempo della query: 0.34 ms** **Memoria query: 0.003 MB memoria prima della query: 0.674 MB**

DELETE 

  FROM `j25_session`

  WHERE `time` < '1675403861'

**Explain**

**EXPLAIN non possibile sulla query: DELETE FROM `j25_session` WHERE `time` < '1675403861'**

**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
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

**Tempo della query: 0.40 ms** **Dopo l'ultima query: 1.35 ms** **Memoria query: 0.023 MB memoria prima della query: 0.683 MB** **Righe restituite: 0**

SELECT `data`

  FROM `j25_session`

  WHERE `session_id` = 'd54evb4einbvbd7e3lb1625g3i'

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

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

**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.42 ms** **Dopo l'ultima query: 2.60 ms** **Memoria query: 0.019 MB memoria prima della query: 0.696 MB** **Righe restituite: 0**

SELECT `session_id`

  FROM `j25_session`

  WHERE `session_id` = 'd54evb4einbvbd7e3lb1625g3i' 
  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.91 ms** **Dopo l'ultima query: 0.07 ms** **Memoria query: 0.003 MB memoria prima della query: 0.701 MB**

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

**Explain**

**EXPLAIN non possibile sulla query: INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('d54evb4einbvbd7e3lb1625g3i', 1, '1675404761', 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.67 ms** **Dopo l'ultima query: 7.36 ms** **Memoria query: 0.023 MB memoria prima della query: 0.723 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.25 ms** **Dopo l'ultima query: 7.54 ms** **Memoria query: 0.021 MB memoria prima della query: 0.748 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.30 ms** **Dopo l'ultima query: 1.34 ms** **Memoria query: 0.021 MB memoria prima della query: 0.752 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: 1.52 ms** **Dopo l'ultima query: 0.17 ms** **Memoria query: 0.041 MB memoria prima della query: 0.779 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.31 ms** **Dopo l'ultima query: 17.50 ms** **Memoria query: 0.021 MB memoria prima della query: 1.054 MB** **Righe restituite: 1**

**Query duplicate**: #11 #14 #15

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.36 ms** **Dopo l'ultima query: 0.18 ms** **Memoria query: 0.025 MB memoria prima della query: 1.067 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.30 ms** **Dopo l'ultima query: 1.91 ms** **Memoria query: 0.020 MB memoria prima della query: 1.125 MB** **Righe restituite: 1**

**Query duplicate**: #9 #14 #15

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: 2.94 ms** **Dopo l'ultima query: 24.04 ms** **Memoria query: 0.166 MB memoria prima della query: 1.402 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.80 ms** **Dopo l'ultima query: 26.66 ms** **Memoria query: 0.021 MB memoria prima della query: 1.890 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.35 ms** **Dopo l'ultima query: 2.77 ms** **Memoria query: 0.021 MB memoria prima della query: 1.919 MB** **Righe restituite: 1**

**Query duplicate**: #9 #11 #15

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.32 ms** **Dopo l'ultima query: 1.03 ms** **Memoria query: 0.021 MB memoria prima della query: 1.925 MB** **Righe restituite: 1**

**Query duplicate**: #9 #11 #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/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.63 ms** **Dopo l'ultima query: 42.32 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: 1.64 ms** **Dopo l'ultima query: 0.13 ms** **Memoria query: 0.005 MB memoria prima della query: 2.027 MB**

UPDATE `j25_extensions`

  SET `params` = '{\"mediaversion\":\"28a55b1853d248c692c33fe5836a8d38\"}'

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

**Explain**

**EXPLAIN non possibile sulla query: UPDATE `j25_extensions` SET `params` = '{\"mediaversion\":\"28a55b1853d248c692c33fe5836a8d38\"}' 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.31 ms** **Dopo l'ultima query: 2.17 ms** **Memoria query: 0.019 MB memoria prima della query: 2.056 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: 4.29 ms** **Dopo l'ultima query: 21.45 ms** **Memoria query: 0.130 MB memoria prima della query: 2.222 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.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-03 06:12:41') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-03 06:12:41')

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	1	const	289	Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	Sql274670_3.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.created_by	1
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.modified_by	1
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.c.parent_id	1
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.id	1

**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/model/legacy.php:307
15	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
14	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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.37 ms** **Dopo l'ultima query: 4.20 ms** **Memoria query: 0.025 MB memoria prima della query: 2.420 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` = 676 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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.27 ms** **Memoria query: 0.023 MB memoria prima della query: 2.446 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` = 675 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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: 2.87 ms** **Dopo l'ultima query: 0.25 ms** **Memoria query: 0.024 MB memoria prima della query: 2.464 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` = 669 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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: 3.00 ms** **Dopo l'ultima query: 0.23 ms** **Memoria query: 0.024 MB memoria prima della query: 2.486 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` = 668 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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: 3.76 ms** **Dopo l'ultima query: 0.28 ms** **Memoria query: 0.024 MB memoria prima della query: 2.507 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` = 667 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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: 2.68 ms** **Dopo l'ultima query: 0.26 ms** **Memoria query: 0.024 MB memoria prima della query: 2.531 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` = 611 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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: 2.70 ms** **Dopo l'ultima query: 0.27 ms** **Memoria query: 0.024 MB memoria prima della query: 2.555 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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: 2.66 ms** **Dopo l'ultima query: 0.20 ms** **Memoria query: 0.024 MB memoria prima della query: 2.579 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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: 3.81 ms** **Dopo l'ultima query: 0.18 ms** **Memoria query: 0.024 MB memoria prima della query: 2.602 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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: 2.87 ms** **Dopo l'ultima query: 0.19 ms** **Memoria query: 0.023 MB memoria prima della query: 2.624 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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: 2.92 ms** **Dopo l'ultima query: 0.22 ms** **Memoria query: 0.024 MB memoria prima della query: 2.642 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` = 644 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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.25 ms** **Memoria query: 0.024 MB memoria prima della query: 2.666 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` = 481 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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.38 ms** **Dopo l'ultima query: 0.24 ms** **Memoria query: 0.023 MB memoria prima della query: 2.689 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` = 545 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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.20 ms** **Memoria query: 0.026 MB memoria prima della query: 2.716 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` = 339 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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.24 ms** **Memoria query: 0.024 MB memoria prima della query: 2.741 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` = 649 
  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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:101
12	ContentModelFeatured->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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: 3.28 ms** **Dopo l'ultima query: 1.25 ms** **Memoria query: 0.023 MB memoria prima della query: 2.741 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.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-02-03 06:12:41') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-03 06:12:41')

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	PRIMARY,idx_access	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	55	Using where
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	5	const,Sql274670_3.c.id	12	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.created_by	1	Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.modified_by	1	Using index
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.c.parent_id	1	Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.a.id	1	Using index

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
12	JModelList->getPagination()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->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.44 ms** **Dopo l'ultima query: 18.60 ms** **Memoria query: 0.026 MB memoria prima della query: 2.827 MB** **Righe restituite: 2**

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

  FROM 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=&#

Cioccofest - Caprarola, ad ottobre

Caprarola 10 agosto: LOCUS AMŒNUS / LOCUS TERRIBILIS SCIENTIA MUNDI

Caprarola, panorami intensi

Visitiamo il Palazzo Farnese, Domenica 24 marzo

La Via Francigena a Caprarola

Monte Venere - L'ultimo vulcano

La Cappella

La Casina del Piacere e i Giardini alti

Il Cortile Circolare

Dove parcheggiare

Date e Orari del Presepe Vivente di Caprarola

Altri articoli...

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

124 query eseguite 188.40 ms

Trovati 63 duplicati!

**Altri articoli...**

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

**124 query eseguite** 188.40 ms

**Trovati 63 duplicati!**

Altri articoli...

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

124 query eseguite 188.40 ms

Trovati 63 duplicati!