Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695393549,
                "last": 1695393549,
                "now": 1695393549
            }
        },
        "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": {
                "34d1b0fdfa7b924dad6467e18e57ff02c1350855": {
                    "link": "http:\/\/lnx.caprarola.com\/artisti-caprolatti\/203-brunofiata-intanto.html",
                    "expiry": 1695393549
                },
                "d748e30d88287e68db423fcfda5d6149c457dd5d": {
                    "link": "http:\/\/lnx.caprarola.com\/artisti-caprolatti\/185-bruno-fiata-il-nuovo-libro.html",
                    "expiry": 1695393549
                },
                "b6d60b7adddbbc3837770770ce7083cc3865e40d": {
                    "link": "http:\/\/lnx.caprarola.com\/artisti-caprolatti\/81-bruno-fiata.html",
                    "expiry": 1695393549
                },
                "e827fe02f9c74193fe1520cd77de91c5db43ca63": {
                    "link": "http:\/\/lnx.caprarola.com\/artisti-caprolatti\/79-gianluca-giganti.html",
                    "expiry": 1695393549
                },
                "b19ed807a7ce64ad8e51297d2a9f7dbc9a81c8bf": {
                    "link": "http:\/\/lnx.caprarola.com\/artisti-caprolatti\/83-mimmo-fabrizi.html",
                    "expiry": 1695393549
                },
                "f170ce0f96c3ad05dd1c620b9be9c5f03c3dee53": {
                    "link": "http:\/\/lnx.caprarola.com\/artisti-caprolatti\/80-pp-scenografic.html",
                    "expiry": 1695393549
                },
                "7b55a03ba1b0b79f6288110865d98698a892a506": {
                    "link": "http:\/\/lnx.caprarola.com\/artisti-caprolatti\/82-roberto-pecorelli.html",
                    "expiry": 1695393549
                }
            }
        }
    }
}

Informazioni profilo

Tempo

Memoria

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

**Tempo**: 47.00 ms / 69.30 ms **Memoria**: 0.666 MB / 1.06 MB Application: Before JAccess::preloadComponents (all components)

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

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

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

**Tempo**: 12.78 ms / 83.71 ms **Memoria**: 0.249 MB / 1.37 MB Application: afterInitialise

**Tempo**: 47.26 ms / 130.97 ms **Memoria**: 0.639 MB / 2.01 MB Application: afterRoute

**Tempo**: 4.09 ms / 135.06 ms **Memoria**: 0.049 MB / 2.06 MB Application: beforeRenderComponent com_content

**Tempo**: 12.54 ms / 147.60 ms **Memoria**: 0.162 MB / 2.22 MB Application: Before JAccess::preloadPermissions (com_content)

**Tempo**: 1.72 ms / 149.32 ms **Memoria**: 0.609 MB / 2.83 MB Application: After JAccess::preloadPermissions (com_content)

**Tempo**: 0.05 ms / 149.37 ms **Memoria**: 0.000 MB / 2.80 MB Application: Before JAccess::getAssetRules (id:78 name:com_content.category.45)

**Tempo**: 0.05 ms / 149.42 ms **Memoria**: 0.007 MB / 2.80 MB Application: After JAccess::getAssetRules (id:78 name:com_content.category.45)

**Tempo**: 7.44 ms / 156.86 ms **Memoria**: 0.039 MB / 2.84 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

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

**Tempo**: 135.27 ms / 292.14 ms **Memoria**: 0.764 MB / 3.61 MB Application: afterRenderComponent com_content

**Tempo**: 0.61 ms / 292.76 ms **Memoria**: 0.005 MB / 3.61 MB Application: afterDispatch

**Tempo**: 9.42 ms / 302.18 ms **Memoria**: 0.106 MB / 3.72 MB Application: beforeRenderModule mod_menu ()

**Tempo**: 92.69 ms / 394.87 ms **Memoria**: 0.936 MB / 4.66 MB Application: afterRenderModule mod_menu ()

**Tempo**: 13.20 ms / 408.07 ms **Memoria**: 0.065 MB / 4.72 MB Application: beforeRenderModule mod_menu ()

**Tempo**: 34.96 ms / 443.03 ms **Memoria**: 0.016 MB / 4.74 MB Application: afterRenderModule mod_menu ()

**Tempo**: 2.97 ms / 446.00 ms **Memoria**: 0.007 MB / 4.74 MB Application: beforeRenderModule mod_custom (Informazioni sul sito)

**Tempo**: 4.20 ms / 450.20 ms **Memoria**: 0.006 MB / 4.75 MB Application: afterRenderModule mod_custom (Informazioni sul sito)

**Tempo**: 0.07 ms / 450.27 ms **Memoria**: 0.000 MB / 4.75 MB Application: beforeRenderModule mod_custom (Social)

**Tempo**: 2.61 ms / 452.88 ms **Memoria**: 0.004 MB / 4.75 MB Application: afterRenderModule mod_custom (Social)

**Tempo**: 0.06 ms / 452.93 ms **Memoria**: 0.000 MB / 4.75 MB Application: beforeRenderModule mod_menu (Risorse esterne)

**Tempo**: 9.99 ms / 462.92 ms **Memoria**: 0.022 MB / 4.77 MB Application: afterRenderModule mod_menu (Risorse esterne)

**Tempo**: 0.12 ms / 463.04 ms **Memoria**: 0.000 MB / 4.77 MB Application: beforeRenderModule mod_menu (Altri siti su Caprarola)

**Tempo**: 8.88 ms / 471.93 ms **Memoria**: 0.023 MB / 4.79 MB Application: afterRenderModule mod_menu (Altri siti su Caprarola)

**Tempo**: 0.09 ms / 472.02 ms **Memoria**: 0.000 MB / 4.79 MB Application: beforeRenderModule mod_search (Cerca)

**Tempo**: 4.81 ms / 476.83 ms **Memoria**: 0.019 MB / 4.81 MB Application: afterRenderModule mod_search (Cerca)

**Tempo**: 0.04 ms / 476.88 ms **Memoria**: 0.000 MB / 4.80 MB Application: beforeRenderModule mod_menu (Menù Generale)

**Tempo**: 14.76 ms / 491.63 ms **Memoria**: 0.138 MB / 4.94 MB Application: afterRenderModule mod_menu (Menù Generale)

**Tempo**: 0.05 ms / 491.69 ms **Memoria**: 0.000 MB / 4.94 MB Application: beforeRenderModule mod_custom (amazon)

**Tempo**: 3.62 ms / 495.30 ms **Memoria**: 0.006 MB / 4.95 MB Application: afterRenderModule mod_custom (amazon)

**Tempo**: 0.06 ms / 495.36 ms **Memoria**: 0.000 MB / 4.94 MB Application: beforeRenderModule mod_syndicate (Syndication)

**Tempo**: 7.34 ms / 502.71 ms **Memoria**: 0.007 MB / 4.95 MB Application: afterRenderModule mod_syndicate (Syndication)

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

**Tempo**: 13.80 ms / 516.55 ms **Memoria**: 0.041 MB / 4.99 MB Application: afterRenderModule mod_banners (Scopri il Palazzo Farnese)

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

**Tempo**: 5.03 ms / 521.61 ms **Memoria**: 0.028 MB / 5.01 MB Application: afterRenderModule mod_banners (ufficio turistico)

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

**Tempo**: 3.53 ms / 525.17 ms **Memoria**: 0.004 MB / 5.01 MB Application: afterRenderModule mod_custom (banner-120-dx)

**Tempo**: 0.12 ms / 525.29 ms **Memoria**: 0.000 MB / 5.01 MB Application: beforeRenderModule mod_custom (Video cesti)

**Tempo**: 3.04 ms / 528.34 ms **Memoria**: 0.004 MB / 5.02 MB Application: afterRenderModule mod_custom (Video cesti)

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

**Tempo**: 4.44 ms / 532.84 ms **Memoria**: 0.029 MB / 5.04 MB Application: afterRenderModule mod_banners (DOVE MANGIARE A CAPRAROLA)

**Tempo**: 0.07 ms / 532.91 ms **Memoria**: 0.000 MB / 5.04 MB Application: beforeRenderModule mod_menu (Menu top)

**Tempo**: 1.43 ms / 534.34 ms **Memoria**: 0.003 MB / 5.04 MB Application: afterRenderModule mod_menu (Menu top)

**Tempo**: 0.06 ms / 534.40 ms **Memoria**: 0.000 MB / 5.04 MB Application: beforeRenderModule mod_banners (Trattoria Tipica a Caprarola)

**Tempo**: 4.27 ms / 538.66 ms **Memoria**: 0.028 MB / 5.07 MB Application: afterRenderModule mod_banners (Trattoria Tipica a Caprarola)

**Tempo**: 0.09 ms / 538.75 ms **Memoria**: 0.000 MB / 5.07 MB Application: beforeRenderModule mod_banners (Delizie 300)

**Tempo**: 5.21 ms / 543.96 ms **Memoria**: 0.035 MB / 5.10 MB Application: afterRenderModule mod_banners (Delizie 300)

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

**Tempo**: 11.80 ms / 555.81 ms **Memoria**: 0.028 MB / 5.12 MB Application: afterRenderModule mod_banners (Visite Guidate)

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

**Tempo**: 5.73 ms / 561.61 ms **Memoria**: 0.004 MB / 5.12 MB Application: afterRenderModule mod_custom (Top-testo)

**Tempo**: 0.06 ms / 561.67 ms **Memoria**: 0.000 MB / 5.12 MB Application: beforeRenderModule mod_custom (logo-template)

**Tempo**: 3.09 ms / 564.75 ms **Memoria**: 0.004 MB / 5.12 MB Application: afterRenderModule mod_custom (logo-template)

**Tempo**: 3.61 ms / 568.37 ms **Memoria**: 0.122 MB / 5.25 MB Application: afterRender

**Query totali del database: 73.93 ms**

Utilizzo memoria

Query Database

108 query eseguite 73.93 ms

Trovati 63 duplicati!

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

**9 duplicati**: #37 #38 #55 #60 #61 #62 #70 #79 #84

**16 duplicati**: #39 #40 #41 #42 #43 #44 #45 #46 #47 #48 #49 #50 #51 #52 #53 #54

**4 duplicati**: #56 #57 #58 #59

**7 duplicati**: #63 #64 #65 #66 #67 #68 #69

**8 duplicati**: #71 #72 #73 #74 #75 #76 #77 #78

**4 duplicati**: #80 #81 #82 #83

**5 duplicati**: #85 #86 #87 #88 #89

**6 duplicati**: #90 #93 #96 #99 #102 #106

**Tempo della query: 0.42 ms** **Memoria query: 0.003 MB memoria prima della query: 0.673 MB**

DELETE 

  FROM `j25_session`

  WHERE `time` < '1695392649'

**Explain**

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

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

SELECT `data`

  FROM `j25_session`

  WHERE `session_id` = 'ois3k9596hhujkeho4p0cacij8'

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

SELECT `session_id`

  FROM `j25_session`

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

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

**Explain**

**EXPLAIN non possibile sulla query: INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('ois3k9596hhujkeho4p0cacij8', 1, '1695393549', 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.89 ms** **Dopo l'ultima query: 2.54 ms** **Memoria query: 0.023 MB memoria prima della query: 0.722 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.23 ms** **Dopo l'ultima query: 4.35 ms** **Memoria query: 0.021 MB memoria prima della query: 0.747 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.58 ms** **Memoria query: 0.021 MB memoria prima della query: 0.751 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.16 ms** **Memoria query: 0.041 MB memoria prima della query: 0.778 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.26 ms** **Dopo l'ultima query: 11.00 ms** **Memoria query: 0.021 MB memoria prima della query: 1.053 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.35 ms** **Dopo l'ultima query: 0.27 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.24 ms** **Dopo l'ultima query: 1.23 ms** **Memoria query: 0.020 MB memoria prima della query: 1.124 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: 3.22 ms** **Dopo l'ultima query: 14.99 ms** **Memoria query: 0.166 MB memoria prima della query: 1.401 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.65 ms** **Dopo l'ultima query: 18.54 ms** **Memoria query: 0.021 MB memoria prima della query: 1.889 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.24 ms** **Dopo l'ultima query: 2.14 ms** **Memoria query: 0.021 MB memoria prima della query: 1.918 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.23 ms** **Dopo l'ultima query: 0.62 ms** **Memoria query: 0.021 MB memoria prima della query: 1.924 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: 19.67 ms** **Memoria query: 0.022 MB memoria prima della query: 2.032 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.21 ms** **Dopo l'ultima query: 0.15 ms** **Memoria query: 0.005 MB memoria prima della query: 2.024 MB**

UPDATE `j25_extensions`

  SET `params` = '{\"mediaversion\":\"4d1d2cd83b69cef0f6211ceadd9d0614\"}'

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

**Explain**

**EXPLAIN non possibile sulla query: UPDATE `j25_extensions` SET `params` = '{\"mediaversion\":\"4d1d2cd83b69cef0f6211ceadd9d0614\"}' 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.27 ms** **Dopo l'ultima query: 1.06 ms** **Memoria query: 0.019 MB memoria prima della query: 2.053 MB** **Righe restituite: 2**

SELECT *

  FROM j25_languages

  WHERE published=1

  ORDER BY ordering ASC

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.83 ms** **Dopo l'ultima query: 12.79 ms** **Memoria query: 0.130 MB memoria prima della query: 2.224 MB** **Righe restituite: 731**

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

  FROM `j25_assets`

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

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/components/com_content/models/category.php:142
13	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 2.51 ms** **Dopo l'ultima query: 3.55 ms** **Memoria query: 0.025 MB memoria prima della query: 2.812 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,COUNT(i.`id`) AS numitems

  FROM j25_categories as c

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

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

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

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

  ORDER BY c.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	55	Using where
1	SIMPLE	i	ref	idx_state,idx_catid	idx_catid	4	Sql274670_3.c.id	19

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
14	JCategories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:121
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 2.32 ms** **Dopo l'ultima query: 2.38 ms** **Memoria query: 0.064 MB memoria prima della query: 2.842 MB** **Righe restituite: 7**

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM j25_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 45 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-22 14:39:09') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-22 14:39:09')

  ORDER BY  c.lft,  a.title,  a.created   
  LIMIT 15

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	7	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	const	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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 3.49 ms** **Dopo l'ultima query: 1.16 ms** **Memoria query: 0.024 MB memoria prima della query: 2.943 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` = 203 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 2.62 ms** **Dopo l'ultima query: 0.17 ms** **Memoria query: 0.024 MB memoria prima della query: 2.964 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` = 185 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 2.98 ms** **Dopo l'ultima query: 0.16 ms** **Memoria query: 0.024 MB memoria prima della query: 2.979 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` = 81 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 2.92 ms** **Dopo l'ultima query: 0.18 ms** **Memoria query: 0.024 MB memoria prima della query: 2.997 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` = 79 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 2.57 ms** **Dopo l'ultima query: 0.17 ms** **Memoria query: 0.024 MB memoria prima della query: 3.015 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` = 83 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 2.61 ms** **Dopo l'ultima query: 0.17 ms** **Memoria query: 0.024 MB memoria prima della query: 3.034 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` = 80 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 2.61 ms** **Dopo l'ultima query: 0.16 ms** **Memoria query: 0.024 MB memoria prima della query: 3.055 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` = 82 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.65 ms** **Dopo l'ultima query: 1.55 ms** **Memoria query: 0.024 MB memoria prima della query: 3.062 MB** **Righe restituite: 1**

SELECT COUNT(*)

  FROM j25_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 45 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-22 14:39:09') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-22 14:39:09')

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	7	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	const	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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
12	YjsgJViewLegacyDefault->get()	JROOT/libraries/legacy/view/category.php:143
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 3.28 ms** **Dopo l'ultima query: 0.17 ms** **Memoria query: 0.022 MB memoria prima della query: 3.065 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.category' 
  AND `m`.`content_item_id` = 45 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:225
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.38 ms** **Dopo l'ultima query: 7.86 ms** **Memoria query: 0.026 MB memoria prima della query: 3.149 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='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=45

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

  ORDER BY c.lft

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
18	JCategories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
17	FieldsModelFields->getListQuery()	JROOT/libraries/legacy/model/list.php:132
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 1.14 ms** **Dopo l'ultima query: 0.14 ms** **Memoria query: 0.025 MB memoria prima della query: 3.167 MB** **Righe restituite: 0**

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM j25_fields AS a

  LEFT JOIN `j25_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN j25_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN j25_viewlevels AS ag 
  ON ag.id = a.access

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

  LEFT JOIN j25_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `j25_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (45,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering DESC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
17	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
16	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 1.25 ms** **Dopo l'ultima query: 87.99 ms** **Memoria query: 0.034 MB memoria prima della query: 3.537 MB** **Righe restituite: 16**

SHOW FULL COLUMNS 
  FROM `j25_users`

**Explain**

**EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `j25_users`**

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
29	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
28	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
27	JTable->__construct()	JROOT/libraries/joomla/table/user.php:40
26	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:311
25	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:598
24	JUser::getTable()	JROOT/libraries/joomla/user/user.php:872
23	JUser->load()	JROOT/libraries/joomla/user/user.php:243
22	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
21	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
20	JFactory::getUser()	JROOT/components/com_content/helpers/icon.php:125
19	JHtmlIcon::edit()	JROOT/libraries/cms/html/html.php:233
18	JHtml::call()	JROOT/libraries/cms/html/html.php:105
17	JHtml::_()	JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog_item.php:52
16	include JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog_item.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
15	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog.php:99
14	include JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:229
12	YjsgJViewLegacyDefault->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.29 ms** **Dopo l'ultima query: 2.41 ms** **Memoria query: 0.028 MB memoria prima della query: 3.572 MB** **Righe restituite: 1**

SELECT *

  FROM `j25_users`

  WHERE `id` = 62

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
25	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:86
24	JTableUser->load()	JROOT/libraries/joomla/user/user.php:875
23	JUser->load()	JROOT/libraries/joomla/user/user.php:243
22	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
21	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
20	JFactory::getUser()	JROOT/components/com_content/helpers/icon.php:125
19	JHtmlIcon::edit()	JROOT/libraries/cms/html/html.php:233
18	JHtml::call()	JROOT/libraries/cms/html/html.php:105
17	JHtml::_()	JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog_item.php:52
16	include JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog_item.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
15	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog.php:99
14	include JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:229
12	YjsgJViewLegacyDefault->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.22 ms** **Dopo l'ultima query: 0.12 ms** **Memoria query: 0.028 MB memoria prima della query: 3.586 MB** **Righe restituite: 1**

SELECT `g`.`id`,`g`.`title`

  FROM `j25_usergroups` AS g

  INNER JOIN `j25_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 62

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.m.group_id	1

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
25	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:111
24	JTableUser->load()	JROOT/libraries/joomla/user/user.php:875
23	JUser->load()	JROOT/libraries/joomla/user/user.php:243
22	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
21	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
20	JFactory::getUser()	JROOT/components/com_content/helpers/icon.php:125
19	JHtmlIcon::edit()	JROOT/libraries/cms/html/html.php:233
18	JHtml::call()	JROOT/libraries/cms/html/html.php:105
17	JHtml::_()	JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog_item.php:52
16	include JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog_item.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
15	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog.php:99
14	include JROOT/plugins/system/yjsg/legacy/html/com_content/category/blog.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:229
12	YjsgJViewLegacyDefault->display()	JROOT/libraries/legacy/view/category.php:241
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 1.26 ms** **Dopo l'ultima query: 7.10 ms** **Memoria query: 0.026 MB memoria prima della query: 3.692 MB** **Righe restituite: 21**

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

  FROM j25_modules AS m

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

  LEFT JOIN j25_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-09-22 14:39:09') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-22 14:39:09') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 70 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJModuleHelperDefault30.php:424
12	YjsgJModuleHelperDefault::getModuleList()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJModuleHelperDefault30.php:360
11	YjsgJModuleHelperDefault::load()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/module/helper.php:174
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
9	JDocumentHtml->countModules()	JROOT/plugins/system/yjsg/includes/yjsgcore/yjsg_core.php:211
8	require JROOT/plugins/system/yjsg/includes/yjsgcore/yjsg_core.php	JROOT/templates/yoububble/index.php:24
7	require JROOT/templates/yoububble/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1105
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.35 ms** **Dopo l'ultima query: 14.53 ms** **Memoria query: 0.025 MB memoria prima della query: 4.155 MB** **Righe restituite: 0**

**Query duplicate**: #38 #55 #60 #61 #62 #70 #79 #84

SELECT params 
  FROM j25_menu 
  WHERE id = 1 
  AND params !=""

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**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/plugins/system/yjsg/legacy/html/mod_menu/yjsgmegalegacy/yjsg_modhelper.php:57
14	require JROOT/plugins/system/yjsg/legacy/html/mod_menu/yjsgmegalegacy/yjsg_modhelper.php	JROOT/plugins/system/yjsg/legacy/html/mod_menu/yjsgmegalegacy/default.php:52
13	require JROOT/plugins/system/yjsg/legacy/html/mod_menu/yjsgmegalegacy/default.php	JROOT/plugins/system/yjsg/legacy/html/mod_menu/default.php:61
12	require JROOT/plugins/system/yjsg/legacy/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
11	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/module/helper.php:68
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/plugins/system/yjsg/includes/yjsgcore/yjsg_core.php:284
8	require JROOT/plugins/system/yjsg/includes/yjsgcore/yjsg_core.php	JROOT/templates/yoububble/index.php:24
7	require JROOT/templates/yoububble/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1105
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.25 ms** **Dopo l'ultima query: 1.08 ms** **Memoria query: 0.025 MB memoria prima della query: 4.165 MB** **Righe restituite: 0**

**Query duplicate**: #37 #55 #60 #61 #62 #70 #79 #84

SELECT params 
  FROM j25_menu 
  WHERE id = 1 
  AND params !=""

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**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/plugins/system/yjsg/legacy/html/mod_menu/yjsgmegalegacy/yjsg_modhelper.php:57
14	require JROOT/plugins/system/yjsg/legacy/html/mod_menu/yjsgmegalegacy/yjsg_modhelper.php	JROOT/plugins/system/yjsg/legacy/html/mod_menu/yjsgmegalegacy/default.php:52
13	require JROOT/plugins/system/yjsg/legacy/html/mod_menu/yjsgmegalegacy/default.php	JROOT/plugins/system/yjsg/legacy/html/mod_menu/default.php:61
12	require JROOT/plugins/system/yjsg/legacy/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
11	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/module/helper.php:68
10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
9	JDocumentRendererHtmlModule->render()	JROOT/plugins/system/yjsg/includes/yjsgcore/yjsg_core.php:284
8	require JROOT/plugins/system/yjsg/includes/yjsgcore/yjsg_core.php	JROOT/templates/yoububble/index.php:24
7	require JROOT/templates/yoububble/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1105
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.30 ms** **Dopo l'ultima query: 0.92 ms** **Memoria query: 0.025 MB memoria prima della query: 4.174 MB** **Righe restituite: 1**

Artisti Caprolatti

Bruno Fiata - Intanto la cerea donzella dei cieli...

Bruno Fiata, il nuovo libro

Bruno Fiata, Il Poeta nascosto - Il suo ultimo libro

Gianluca Giganti - Violoncellista caprolatto

Mimmo Fabrizi Grande Fotografo del Mondo

P&P Scenographic Productions

Roberto Pecorelli, Trombonista di successo

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

108 query eseguite 73.93 ms

Trovati 63 duplicati!

Artisti Caprolatti

Bruno Fiata - Intanto la cerea donzella dei cieli...

Bruno Fiata, il nuovo libro

Bruno Fiata, Il Poeta nascosto - Il suo ultimo libro

Gianluca Giganti - Violoncellista caprolatto

Mimmo Fabrizi Grande Fotografo del Mondo

P&P Scenographic Productions

Roberto Pecorelli, Trombonista di successo

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

**108 query eseguite** 73.93 ms

**Trovati 63 duplicati!**

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

108 query eseguite 73.93 ms

Trovati 63 duplicati!