Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679858645,
                "last": 1679858645,
                "now": 1679858645
            }
        },
        "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": {
                "9a77fbe71f036e479d41048cbdd846cba7cc1f15": {
                    "link": "http:\/\/www.caprarola.com\/arte-e-cultura\/303-maurizio-vecchi-presenta-la-nuova-guida-della-tuscia-15-aprile.html",
                    "expiry": 1679858646
                },
                "10352e0e68559ac37b892f1fde175404b8864852": {
                    "link": "http:\/\/www.caprarola.com\/notizie\/304-corso-biennale-per-addetto-segreteria.html",
                    "expiry": 1679858646
                },
                "55ba09436f53c8c9531fcbaad4e0e2c3a08b1788": {
                    "link": "http:\/\/www.caprarola.com\/notizie\/302-cara-cecilia.html",
                    "expiry": 1679858646
                },
                "a6df3119d08d324f47d52b203b0d9f096e01df8c": {
                    "link": "http:\/\/www.caprarola.com\/notizie\/299-corse-cavalli-ronciglione.html",
                    "expiry": 1679858646
                },
                "aa6f940e86d411983e833314c5b699628904e84d": {
                    "link": "http:\/\/www.caprarola.com\/notizie\/288-sulle-orme-dei-farnese-conferenza-itinerante-del-pws.html",
                    "expiry": 1679858646
                },
                "950ed47d513846033b9b95b7519154342ed02bd2": {
                    "link": "http:\/\/www.caprarola.com\/41-salviamo-il-lago\/287-lago-di-vico-tempi-lunghi-per-la-bonifica-del-centro-chimico.html",
                    "expiry": 1679858646
                },
                "73d62b85bfa78c4e8253927014d0d329226d7147": {
                    "link": "http:\/\/www.caprarola.com\/notizie\/286-tragedia-a-ronciglione-cadono-i-cavalli-uno-muore-con-la-testa-fracassata.html",
                    "expiry": 1679858646
                },
                "a280e368c9207ed49e9443c710848e222b8fd06e": {
                    "link": "http:\/\/www.caprarola.com\/turismo\/285-tuscia-doc-promuove-caprarola-al-btsa-e-ospita-23-giornalisti-di-settore.html",
                    "expiry": 1679858646
                },
                "d524eec3796c62f6a102ace3e2a7fd6b7d3c8662": {
                    "link": "http:\/\/www.caprarola.com\/notizie\/284-a-proposito.html",
                    "expiry": 1679858646
                },
                "1c1955a389f3712632040f4c3a9738cbe0d377f3": {
                    "link": "http:\/\/www.caprarola.com\/turismo\/283-bike-bird.html",
                    "expiry": 1679858646
                },
                "f7a0a885c2df6737167d0c7b8d1913d2614a781b": {
                    "link": "http:\/\/www.caprarola.com\/agricoltura\/282-nocciole-cresce-produzione-turchia.html",
                    "expiry": 1679858646
                }
            }
        }
    }
}

Informazioni profilo

Tempo

Memoria

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

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

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

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

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

**Tempo**: 15.17 ms / 98.93 ms **Memoria**: 0.249 MB / 1.37 MB Application: afterInitialise

**Tempo**: 51.69 ms / 150.62 ms **Memoria**: 0.640 MB / 2.01 MB Application: afterRoute

**Tempo**: 5.17 ms / 155.79 ms **Memoria**: 0.049 MB / 2.06 MB Application: beforeRenderComponent com_content

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

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

**Tempo**: 238.00 ms / 402.46 ms **Memoria**: 1.436 MB / 3.58 MB Application: afterRenderComponent com_content

**Tempo**: 0.63 ms / 403.09 ms **Memoria**: 0.005 MB / 3.58 MB Application: afterDispatch

**Tempo**: 11.09 ms / 414.17 ms **Memoria**: 0.106 MB / 3.69 MB Application: beforeRenderModule mod_menu ()

**Tempo**: 99.61 ms / 513.78 ms **Memoria**: 0.930 MB / 4.62 MB Application: afterRenderModule mod_menu ()

**Tempo**: 14.05 ms / 527.83 ms **Memoria**: 0.065 MB / 4.68 MB Application: beforeRenderModule mod_menu ()

**Tempo**: 35.34 ms / 563.18 ms **Memoria**: 0.016 MB / 4.70 MB Application: afterRenderModule mod_menu ()

**Tempo**: 3.66 ms / 566.83 ms **Memoria**: 0.000 MB / 4.64 MB Application: beforeRenderModule mod_custom (Informazioni sul sito)

**Tempo**: 3.81 ms / 570.64 ms **Memoria**: 0.007 MB / 4.65 MB Application: afterRenderModule mod_custom (Informazioni sul sito)

**Tempo**: 0.08 ms / 570.72 ms **Memoria**: 0.000 MB / 4.65 MB Application: beforeRenderModule mod_custom (Social)

**Tempo**: 2.86 ms / 573.58 ms **Memoria**: 0.004 MB / 4.65 MB Application: afterRenderModule mod_custom (Social)

**Tempo**: 0.09 ms / 573.66 ms **Memoria**: 0.000 MB / 4.65 MB Application: beforeRenderModule mod_menu (Risorse esterne)

**Tempo**: 12.05 ms / 585.72 ms **Memoria**: 0.022 MB / 4.67 MB Application: afterRenderModule mod_menu (Risorse esterne)

**Tempo**: 0.10 ms / 585.82 ms **Memoria**: 0.000 MB / 4.67 MB Application: beforeRenderModule mod_menu (Altri siti su Caprarola)

**Tempo**: 9.16 ms / 594.98 ms **Memoria**: 0.023 MB / 4.69 MB Application: afterRenderModule mod_menu (Altri siti su Caprarola)

**Tempo**: 0.11 ms / 595.09 ms **Memoria**: 0.000 MB / 4.69 MB Application: beforeRenderModule mod_search (Cerca)

**Tempo**: 5.00 ms / 600.09 ms **Memoria**: 0.020 MB / 4.71 MB Application: afterRenderModule mod_search (Cerca)

**Tempo**: 0.05 ms / 600.14 ms **Memoria**: 0.000 MB / 4.70 MB Application: beforeRenderModule mod_menu (Menù Generale)

**Tempo**: 15.43 ms / 615.57 ms **Memoria**: 0.149 MB / 4.85 MB Application: afterRenderModule mod_menu (Menù Generale)

**Tempo**: 0.04 ms / 615.61 ms **Memoria**: 0.000 MB / 4.85 MB Application: beforeRenderModule mod_custom (amazon)

**Tempo**: 2.57 ms / 618.18 ms **Memoria**: 0.004 MB / 4.85 MB Application: afterRenderModule mod_custom (amazon)

**Tempo**: 0.07 ms / 618.25 ms **Memoria**: 0.000 MB / 4.85 MB Application: beforeRenderModule mod_syndicate (Syndication)

**Tempo**: 5.00 ms / 623.25 ms **Memoria**: 0.007 MB / 4.86 MB Application: afterRenderModule mod_syndicate (Syndication)

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

**Tempo**: 8.68 ms / 631.98 ms **Memoria**: 0.043 MB / 4.90 MB Application: afterRenderModule mod_banners (Scopri il Palazzo Farnese)

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

**Tempo**: 5.13 ms / 637.15 ms **Memoria**: 0.028 MB / 4.92 MB Application: afterRenderModule mod_banners (ufficio turistico)

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

**Tempo**: 4.07 ms / 641.28 ms **Memoria**: 0.004 MB / 4.92 MB Application: afterRenderModule mod_custom (banner-120-dx)

**Tempo**: 0.11 ms / 641.38 ms **Memoria**: 0.000 MB / 4.92 MB Application: beforeRenderModule mod_custom (Video cesti)

**Tempo**: 3.27 ms / 644.66 ms **Memoria**: 0.004 MB / 4.93 MB Application: afterRenderModule mod_custom (Video cesti)

**Tempo**: 0.11 ms / 644.76 ms **Memoria**: 0.000 MB / 4.93 MB Application: beforeRenderModule mod_banners (DOVE MANGIARE A CAPRAROLA)

**Tempo**: 4.82 ms / 649.59 ms **Memoria**: 0.029 MB / 4.95 MB Application: afterRenderModule mod_banners (DOVE MANGIARE A CAPRAROLA)

**Tempo**: 0.08 ms / 649.66 ms **Memoria**: 0.000 MB / 4.95 MB Application: beforeRenderModule mod_menu (Menu top)

**Tempo**: 1.33 ms / 650.99 ms **Memoria**: 0.003 MB / 4.95 MB Application: afterRenderModule mod_menu (Menu top)

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

**Tempo**: 4.84 ms / 655.87 ms **Memoria**: 0.028 MB / 4.98 MB Application: afterRenderModule mod_banners (Trattoria Tipica a Caprarola)

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

**Tempo**: 6.24 ms / 662.17 ms **Memoria**: 0.038 MB / 5.01 MB Application: afterRenderModule mod_banners (Delizie 300)

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

**Tempo**: 5.01 ms / 667.24 ms **Memoria**: 0.028 MB / 5.04 MB Application: afterRenderModule mod_banners (Visite Guidate)

**Tempo**: 0.07 ms / 667.31 ms **Memoria**: 0.000 MB / 5.03 MB Application: beforeRenderModule mod_custom (Top-testo)

**Tempo**: 3.17 ms / 670.48 ms **Memoria**: 0.004 MB / 5.04 MB Application: afterRenderModule mod_custom (Top-testo)

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

**Tempo**: 3.01 ms / 673.56 ms **Memoria**: 0.004 MB / 5.04 MB Application: afterRenderModule mod_custom (logo-template)

**Tempo**: 5.57 ms / 679.12 ms **Memoria**: 0.200 MB / 5.24 MB Application: afterRender

**Query totali del database: 109.69 ms**

Utilizzo memoria

Query Database

125 query eseguite 109.69 ms

Trovati 63 duplicati!

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

**9 duplicati**: #54 #55 #72 #77 #78 #79 #87 #96 #101

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

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

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

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

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

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

**6 duplicati**: #107 #110 #113 #116 #119 #123

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

DELETE 

  FROM `j25_session`

  WHERE `time` < '1679857745'

**Explain**

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

**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.30 ms** **Dopo l'ultima query: 0.74 ms** **Memoria query: 0.023 MB memoria prima della query: 0.683 MB** **Righe restituite: 0**

SELECT `data`

  FROM `j25_session`

  WHERE `session_id` = 'rnugetltdr8riddiqnt67pk9vg'

**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.29 ms** **Dopo l'ultima query: 1.14 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` = 'rnugetltdr8riddiqnt67pk9vg' 
  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.44 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 
('rnugetltdr8riddiqnt67pk9vg', 1, '1679858645', 0, '', 0)

**Explain**

**EXPLAIN non possibile sulla query: INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('rnugetltdr8riddiqnt67pk9vg', 1, '1679858645', 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: 1.49 ms** **Dopo l'ultima query: 4.26 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: 5.24 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.24 ms** **Dopo l'ultima query: 0.77 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.47 ms** **Dopo l'ultima query: 0.09 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.33 ms** **Dopo l'ultima query: 10.94 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.33 ms** **Dopo l'ultima query: 0.22 ms** **Memoria query: 0.025 MB memoria prima della query: 1.066 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.33 ms** **Dopo l'ultima query: 1.42 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: 5.93 ms** **Dopo l'ultima query: 17.02 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: 1.03 ms** **Dopo l'ultima query: 16.64 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.25 ms** **Dopo l'ultima query: 2.05 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.24 ms** **Dopo l'ultima query: 0.49 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.67 ms** **Dopo l'ultima query: 23.66 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.15 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\":\"38b7b2a1229d9fbf3069b48c23943c60\"}'

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

**Explain**

**EXPLAIN non possibile sulla query: UPDATE `j25_extensions` SET `params` = '{\"mediaversion\":\"38b7b2a1229d9fbf3069b48c23943c60\"}' 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.36 ms** **Dopo l'ultima query: 1.77 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: 7.54 ms** **Dopo l'ultima query: 10.10 ms** **Memoria query: 0.114 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-03-26 19:24:06') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-26 19:24:06')

  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 242, 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	290	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: 2.67 ms** **Dopo l'ultima query: 2.29 ms** **Memoria query: 0.027 MB memoria prima della query: 2.394 MB** **Righe restituite: 7**

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` = 303 
  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.60 ms** **Dopo l'ultima query: 0.24 ms** **Memoria query: 0.023 MB memoria prima della query: 2.425 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` = 304 
  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.69 ms** **Dopo l'ultima query: 0.19 ms** **Memoria query: 0.023 MB memoria prima della query: 2.445 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` = 302 
  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.65 ms** **Dopo l'ultima query: 0.22 ms** **Memoria query: 0.023 MB memoria prima della query: 2.466 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` = 299 
  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.58 ms** **Dopo l'ultima query: 0.23 ms** **Memoria query: 0.023 MB memoria prima della query: 2.486 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` = 288 
  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.51 ms** **Dopo l'ultima query: 0.19 ms** **Memoria query: 0.023 MB memoria prima della query: 2.503 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` = 287 
  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.77 ms** **Dopo l'ultima query: 0.24 ms** **Memoria query: 0.023 MB memoria prima della query: 2.524 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` = 286 
  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.61 ms** **Dopo l'ultima query: 0.22 ms** **Memoria query: 0.023 MB memoria prima della query: 2.541 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` = 285 
  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.79 ms** **Dopo l'ultima query: 0.19 ms** **Memoria query: 0.023 MB memoria prima della query: 2.562 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` = 284 
  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: 4.69 ms** **Dopo l'ultima query: 0.19 ms** **Memoria query: 0.023 MB memoria prima della query: 2.579 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` = 283 
  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.67 ms** **Dopo l'ultima query: 0.22 ms** **Memoria query: 0.023 MB memoria prima della query: 2.600 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` = 282 
  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: 4.00 ms** **Dopo l'ultima query: 0.22 ms** **Memoria query: 0.024 MB memoria prima della query: 2.617 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` = 270 
  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.80 ms** **Dopo l'ultima query: 0.25 ms** **Memoria query: 0.023 MB memoria prima della query: 2.640 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` = 267 
  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.85 ms** **Dopo l'ultima query: 0.24 ms** **Memoria query: 0.025 MB memoria prima della query: 2.666 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` = 266 
  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.91 ms** **Dopo l'ultima query: 0.22 ms** **Memoria query: 0.023 MB memoria prima della query: 2.687 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` = 265 
  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.25 ms** **Dopo l'ultima query: 0.84 ms** **Memoria query: 0.023 MB memoria prima della query: 2.686 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-03-26 19:24:06') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-26 19:24:06')

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

Maurizio Vecchi presenta la Nuova Guida della Tuscia: 15 aprile

Corso Biennale per Addetto Segreteria

Cara Cecilia

Il Ministro Brambilla: Corse di Ronciglione da cancellare per sempre

Sulle orme dei Farnese - Conferenza del PWS

Lago di Vico - Tempi Lunghi per la bonifica del centro chimico

Tragedia a Ronciglione, cadono i cavalli, uno si schianta e muore

Tuscia Doc promuove Caprarola al BTSA e ospita 23 giornalisti di settore.

A proposito dell'indignazione delle Donne

Bike e Bird - Escursione sul Lago di Vico

Nocciole: in Turchia cresce la produzione... e l'esportazione?

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

125 query eseguite 109.69 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**

**125 query eseguite** 109.69 ms

**Trovati 63 duplicati!**

Altri articoli...

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

125 query eseguite 109.69 ms

Trovati 63 duplicati!