Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1696474926,
                "last": 1696474926,
                "now": 1696474926
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informazioni profilo

Tempo

Memoria

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

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

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

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

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

**Tempo**: 22.93 ms / 178.84 ms **Memoria**: 0.249 MB / 1.37 MB Application: afterInitialise

**Tempo**: 85.68 ms / 264.52 ms **Memoria**: 0.641 MB / 2.01 MB Application: afterRoute

**Tempo**: 5.77 ms / 270.29 ms **Memoria**: 0.041 MB / 2.05 MB Application: beforeRenderComponent com_tags

**Tempo**: 169.87 ms / 440.16 ms **Memoria**: 0.614 MB / 2.67 MB Application: Before JAccess::getAssetRules (id:672 name:com_tags)

**Tempo**: 0.08 ms / 440.24 ms **Memoria**: 0.007 MB / 2.67 MB Application: After JAccess::getAssetRules (id:672 name:com_tags)

**Tempo**: 10.79 ms / 451.03 ms **Memoria**: 0.145 MB / 2.82 MB Application: afterRenderComponent com_tags

**Tempo**: 2.50 ms / 453.53 ms **Memoria**: 0.005 MB / 2.82 MB Application: afterDispatch

**Tempo**: 12.16 ms / 465.69 ms **Memoria**: 0.112 MB / 2.94 MB Application: beforeRenderModule mod_menu ()

**Tempo**: 118.39 ms / 584.08 ms **Memoria**: 0.953 MB / 3.89 MB Application: afterRenderModule mod_menu ()

**Tempo**: 33.78 ms / 617.86 ms **Memoria**: 0.074 MB / 3.96 MB Application: beforeRenderModule mod_menu ()

**Tempo**: 5.48 ms / 623.34 ms **Memoria**: 0.025 MB / 3.99 MB Application: afterRenderModule mod_menu ()

**Tempo**: 2.56 ms / 625.90 ms **Memoria**: 0.000 MB / 3.94 MB Application: beforeRenderModule mod_custom (Informazioni sul sito)

**Tempo**: 5.20 ms / 631.10 ms **Memoria**: 0.007 MB / 3.94 MB Application: afterRenderModule mod_custom (Informazioni sul sito)

**Tempo**: 0.08 ms / 631.18 ms **Memoria**: 0.000 MB / 3.94 MB Application: beforeRenderModule mod_custom (Social)

**Tempo**: 1.46 ms / 632.64 ms **Memoria**: 0.004 MB / 3.95 MB Application: afterRenderModule mod_custom (Social)

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

**Tempo**: 4.75 ms / 637.47 ms **Memoria**: 0.024 MB / 3.97 MB Application: afterRenderModule mod_menu (Risorse esterne)

**Tempo**: 0.06 ms / 637.53 ms **Memoria**: 0.000 MB / 3.96 MB Application: beforeRenderModule mod_menu (Altri siti su Caprarola)

**Tempo**: 2.09 ms / 639.61 ms **Memoria**: 0.024 MB / 3.99 MB Application: afterRenderModule mod_menu (Altri siti su Caprarola)

**Tempo**: 0.06 ms / 639.67 ms **Memoria**: 0.000 MB / 3.98 MB Application: beforeRenderModule mod_search (Cerca)

**Tempo**: 6.45 ms / 646.12 ms **Memoria**: 0.019 MB / 4.00 MB Application: afterRenderModule mod_search (Cerca)

**Tempo**: 0.03 ms / 646.16 ms **Memoria**: 0.000 MB / 4.00 MB Application: beforeRenderModule mod_menu (Menù Generale)

**Tempo**: 3.42 ms / 649.58 ms **Memoria**: 0.144 MB / 4.14 MB Application: afterRenderModule mod_menu (Menù Generale)

**Tempo**: 0.03 ms / 649.61 ms **Memoria**: 0.000 MB / 4.14 MB Application: beforeRenderModule mod_custom (amazon)

**Tempo**: 1.42 ms / 651.03 ms **Memoria**: 0.004 MB / 4.15 MB Application: afterRenderModule mod_custom (amazon)

**Tempo**: 0.06 ms / 651.09 ms **Memoria**: 0.000 MB / 4.14 MB Application: beforeRenderModule mod_syndicate (Syndication)

**Tempo**: 5.51 ms / 656.60 ms **Memoria**: 0.007 MB / 4.15 MB Application: afterRenderModule mod_syndicate (Syndication)

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

**Tempo**: 13.77 ms / 670.40 ms **Memoria**: 0.042 MB / 4.19 MB Application: afterRenderModule mod_banners (Scopri il Palazzo Farnese)

**Tempo**: 0.07 ms / 670.47 ms **Memoria**: 0.000 MB / 4.19 MB Application: beforeRenderModule mod_banners (ufficio turistico)

**Tempo**: 5.76 ms / 676.23 ms **Memoria**: 0.029 MB / 4.22 MB Application: afterRenderModule mod_banners (ufficio turistico)

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

**Tempo**: 2.63 ms / 678.90 ms **Memoria**: 0.004 MB / 4.22 MB Application: afterRenderModule mod_custom (banner-120-dx)

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

**Tempo**: 2.18 ms / 681.15 ms **Memoria**: 0.004 MB / 4.22 MB Application: afterRenderModule mod_custom (Video cesti)

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

**Tempo**: 5.30 ms / 686.55 ms **Memoria**: 0.029 MB / 4.25 MB Application: afterRenderModule mod_banners (DOVE MANGIARE A CAPRAROLA)

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

**Tempo**: 1.11 ms / 687.74 ms **Memoria**: 0.003 MB / 4.24 MB Application: afterRenderModule mod_menu (Menu top)

**Tempo**: 0.10 ms / 687.84 ms **Memoria**: 0.000 MB / 4.24 MB Application: beforeRenderModule mod_banners (Trattoria Tipica a Caprarola)

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

**Tempo**: 0.18 ms / 692.95 ms **Memoria**: 0.000 MB / 4.27 MB Application: beforeRenderModule mod_banners (Delizie 300)

**Tempo**: 5.50 ms / 698.45 ms **Memoria**: 0.035 MB / 4.30 MB Application: afterRenderModule mod_banners (Delizie 300)

**Tempo**: 0.08 ms / 698.53 ms **Memoria**: 0.000 MB / 4.30 MB Application: beforeRenderModule mod_banners (Visite Guidate)

**Tempo**: 4.74 ms / 703.27 ms **Memoria**: 0.028 MB / 4.33 MB Application: afterRenderModule mod_banners (Visite Guidate)

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

**Tempo**: 2.21 ms / 705.55 ms **Memoria**: 0.004 MB / 4.33 MB Application: afterRenderModule mod_custom (Top-testo)

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

**Tempo**: 1.61 ms / 707.24 ms **Memoria**: 0.004 MB / 4.33 MB Application: afterRenderModule mod_custom (logo-template)

**Tempo**: 5.66 ms / 712.89 ms **Memoria**: 0.122 MB / 4.45 MB Application: afterRender

**Query totali del database: 155.37 ms**

Utilizzo memoria

Query Database

105 query eseguite 155.37 ms

Trovati 65 duplicati!

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

**2 duplicati**: #22 #25

**9 duplicati**: #34 #35 #52 #57 #58 #59 #67 #76 #81

**16 duplicati**: #36 #37 #38 #39 #40 #41 #42 #43 #44 #45 #46 #47 #48 #49 #50 #51

**4 duplicati**: #53 #54 #55 #56

**7 duplicati**: #60 #61 #62 #63 #64 #65 #66

**8 duplicati**: #68 #69 #70 #71 #72 #73 #74 #75

**4 duplicati**: #77 #78 #79 #80

**5 duplicati**: #82 #83 #84 #85 #86

**6 duplicati**: #87 #90 #93 #96 #99 #103

**Tempo della query: 3.99 ms** **Memoria query: 0.023 MB memoria prima della query: 0.677 MB** **Righe restituite: 0**

SELECT `data`

  FROM `j25_session`

  WHERE `session_id` = 'geicelqrn7qa7dug6kpk2sgir1'

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	*Chiamata uguale alla linea sottostante.*
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:832
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

**Tempo della query: 2.53 ms** **Dopo l'ultima query: 2.47 ms** **Memoria query: 0.019 MB memoria prima della query: 0.691 MB** **Righe restituite: 0**

SELECT `session_id`

  FROM `j25_session`

  WHERE `session_id` = 'geicelqrn7qa7dug6kpk2sgir1' 
  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: 2.66 ms** **Dopo l'ultima query: 0.11 ms** **Memoria query: 0.003 MB memoria prima della query: 0.695 MB**

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

**Explain**

**EXPLAIN non possibile sulla query: INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('geicelqrn7qa7dug6kpk2sgir1', 1, '1696474926', 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: 3.24 ms** **Dopo l'ultima query: 4.94 ms** **Memoria query: 0.023 MB memoria prima della query: 0.719 MB** **Righe restituite: 39**

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

  FROM `j25_extensions`

  WHERE `type` = 'component'

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.29 ms** **Dopo l'ultima query: 6.06 ms** **Memoria query: 0.021 MB memoria prima della query: 0.744 MB** **Righe restituite: 1**

SELECT b.id

  FROM j25_usergroups AS a

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

  WHERE a.id = 1

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 1.59 ms** **Dopo l'ultima query: 2.27 ms** **Memoria query: 0.021 MB memoria prima della query: 0.749 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.56 ms** **Dopo l'ultima query: 0.14 ms** **Memoria query: 0.041 MB memoria prima della query: 0.775 MB** **Righe restituite: 74**

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

  FROM j25_extensions

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

  ORDER BY ordering

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.29 ms** **Dopo l'ultima query: 21.77 ms** **Memoria query: 0.020 MB memoria prima della query: 1.050 MB** **Righe restituite: 1**

**Query duplicate**: #10 #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.44 ms** **Dopo l'ultima query: 1.21 ms** **Memoria query: 0.025 MB memoria prima della query: 1.063 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.35 ms** **Dopo l'ultima query: 1.91 ms** **Memoria query: 0.020 MB memoria prima della query: 1.122 MB** **Righe restituite: 1**

**Query duplicate**: #8 #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.15 ms** **Dopo l'ultima query: 25.86 ms** **Memoria query: 0.166 MB memoria prima della query: 1.398 MB** **Righe restituite: 106**

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

  FROM j25_menu AS m

  LEFT JOIN j25_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	101	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.m.component_id	1

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:450
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:555
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1148
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.64 ms** **Dopo l'ultima query: 30.90 ms** **Memoria query: 0.021 MB memoria prima della query: 1.885 MB** **Righe restituite: 1**

SELECT id

  FROM `j25_tags`

  WHERE `alias` = 'palazzo-farnese'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_tags	ref	idx_alias	idx_alias	302	const	1	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/components/com_tags/router.php:179
10	TagsRouter->fixSegment()	JROOT/components/com_tags/router.php:147
9	TagsRouter->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1149
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.84 ms** **Dopo l'ultima query: 0.12 ms** **Memoria query: 0.021 MB memoria prima della query: 1.892 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.40 ms** **Dopo l'ultima query: 3.52 ms** **Memoria query: 0.021 MB memoria prima della query: 1.921 MB** **Righe restituite: 1**

**Query duplicate**: #8 #10 #15

SELECT a.template

  FROM `j25_template_styles` AS a

  WHERE client_id = 0 
  AND a.home = 1

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:504
10	Yjsg::getDefaultTemplate()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/yjsg.class.php:565
9	Yjsg->cleanup()	JROOT/plugins/system/yjsg/yjsg.php:240
8	plgSystemYjsg->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.32 ms** **Dopo l'ultima query: 1.29 ms** **Memoria query: 0.021 MB memoria prima della query: 1.927 MB** **Righe restituite: 1**

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

SELECT a.template

  FROM `j25_template_styles` AS a

  WHERE client_id = 0 
  AND a.home = 1

**Explain**

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

**Profilo**

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

**Call Stack**

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

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

  FROM `j25_extensions`

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

**Explain**

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

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
12	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.74 ms** **Dopo l'ultima query: 0.18 ms** **Memoria query: 0.005 MB memoria prima della query: 2.023 MB**

UPDATE `j25_extensions`

  SET `params` = '{\"mediaversion\":\"99bde95ed65ab54f7c37560c816e0db2\"}'

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

**Explain**

**EXPLAIN non possibile sulla query: UPDATE `j25_extensions` SET `params` = '{\"mediaversion\":\"99bde95ed65ab54f7c37560c816e0db2\"}' 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.40 ms** **Dopo l'ultima query: 1.92 ms** **Memoria query: 0.019 MB memoria prima della query: 2.044 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.62 ms** **Dopo l'ultima query: 18.59 ms** **Memoria query: 0.043 MB memoria prima della query: 2.180 MB** **Righe restituite: 15**

SELECT *

  FROM `j25_content_types`

**Explain**

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

**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:1486
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/cms/helper/tags.php:790
17	JHelperTags::getTypes()	JROOT/libraries/cms/helper/tags.php:624
16	JHelperTags->getTagItemsQuery()	JROOT/components/com_tags/models/tag.php:148
15	TagsModelTag->getListQuery()	JROOT/libraries/legacy/model/list.php:132
14	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 8.56 ms** **Dopo l'ultima query: 0.23 ms** **Memoria query: 0.078 MB memoria prima della query: 2.191 MB** **Righe restituite: 20**

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM j25_contentitem_tag_map AS m

  INNER JOIN j25_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2023-10-05 03:02:06')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2023-10-05 03:02:06')

  INNER JOIN j25_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN j25_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN j25_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (3) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email

  ORDER BY MAX(`c`.`core_title`) ASC 
  LIMIT 20

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	32	Using where; Using temporary; Using filesort
1	SIMPLE	ct	ref	idx_alias	idx_alias	302	Sql274670_3.m.type_alias	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	Sql274670_3.m.core_content_id	1	Using where
1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.c.core_catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.c.core_created_user_id	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:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.74 ms** **Dopo l'ultima query: 4.71 ms** **Memoria query: 0.033 MB memoria prima della query: 2.305 MB** **Righe restituite: 30**

SHOW FULL COLUMNS 
  FROM `j25_tags`

**Explain**

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

**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/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
15	JTable->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:29
14	TagsTableTag->__construct()	JROOT/libraries/joomla/table/table.php:311
13	JTable::getInstance()	JROOT/components/com_tags/models/tag.php:281
12	TagsModelTag->getItem()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.47 ms** **Dopo l'ultima query: 6.40 ms** **Memoria query: 0.023 MB memoria prima della query: 2.352 MB** **Righe restituite: 1**

**Query duplicate**: #25

SELECT *

  FROM j25_tags

  WHERE `id` = '3'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_tags	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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
13	JTable->load()	JROOT/components/com_tags/models/tag.php:290
12	TagsModelTag->getItem()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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: 6.12 ms** **Dopo l'ultima query: 0.28 ms** **Memoria query: 0.117 MB memoria prima della query: 2.378 MB** **Righe restituite: 35**

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM j25_contentitem_tag_map AS m

  INNER JOIN j25_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2023-10-05 03:02:06')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2023-10-05 03:02:06')

  INNER JOIN j25_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN j25_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN j25_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (3) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email

  ORDER BY MAX(`c`.`core_title`) ASC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	32	Using where; Using temporary; Using filesort
1	SIMPLE	ct	ref	idx_alias	idx_alias	302	Sql274670_3.m.type_alias	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	Sql274670_3.m.core_content_id	1	Using where
1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.c.core_catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Sql274670_3.c.core_created_user_id	1

**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/legacy/model/legacy.php:347
14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
12	JModelList->getPagination()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:422
11	YjsgJViewLegacyDefault->get()	JROOT/components/com_tags/views/tag/view.html.php:55
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.48 ms** **Dopo l'ultima query: 15.84 ms** **Memoria query: 0.025 MB memoria prima della query: 2.450 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

  WHERE a.context = 'com_tags.tag' 
  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)

  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_tags/views/tag/view.html.php:99
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.03 ms** **Dopo l'ultima query: 84.05 ms** **Memoria query: 0.023 MB memoria prima della query: 2.594 MB** **Righe restituite: 1**

**Query duplicate**: #22

SELECT *

  FROM j25_tags

  WHERE `id` = '3'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_tags	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_tags/models/tag.php:345
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:197
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.82 ms** **Dopo l'ultima query: 0.16 ms** **Memoria query: 0.006 MB memoria prima della query: 2.600 MB**

UPDATE j25_tags

  SET `hits` = (`hits` + 1)

  WHERE `id` = '3'

**Explain**

**EXPLAIN non possibile sulla query: UPDATE j25_tags SET `hits` = (`hits` + 1) WHERE `id` = '3'**

**Profilo**

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

**Call Stack**

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
12	JTable->hit()	JROOT/components/com_tags/models/tag.php:346
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:197
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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: 9.37 ms** **Memoria query: 0.027 MB memoria prima della query: 2.631 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

  WHERE a.context = 'com_tag.tag' 
  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)

  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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
23	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
22	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
21	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
19	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
16	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
15	JHtml::call()	JROOT/libraries/cms/html/html.php:140
14	JHtml::_()	JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php:24
13	include JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:229
11	YjsgJViewLegacyDefault->display()	JROOT/components/com_tags/views/tag/view.html.php:201
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.46 ms** **Dopo l'ultima query: 10.17 ms** **Memoria query: 0.029 MB memoria prima della query: 2.694 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=34

  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
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
24	JCategories->get()	JROOT/components/com_content/router.php:70
23	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default_items.php:65
15	include JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default_items.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
14	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php:51
13	include JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:229
11	YjsgJViewLegacyDefault->display()	JROOT/components/com_tags/views/tag/view.html.php:201
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.41 ms** **Dopo l'ultima query: 0.73 ms** **Memoria query: 0.030 MB memoria prima della query: 2.718 MB** **Righe restituite: 3**

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

  FROM j25_categories as c

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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=94

  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
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
24	JCategories->get()	JROOT/components/com_content/router.php:70
23	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default_items.php:65
15	include JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default_items.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
14	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php:51
13	include JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:229
11	YjsgJViewLegacyDefault->display()	JROOT/components/com_tags/views/tag/view.html.php:201
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.42 ms** **Dopo l'ultima query: 0.55 ms** **Memoria query: 0.030 MB memoria prima della query: 2.744 MB** **Righe restituite: 4**

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=71

  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
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
24	JCategories->get()	JROOT/components/com_content/router.php:70
23	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default_items.php:65
15	include JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default_items.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
14	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php:51
13	include JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:229
11	YjsgJViewLegacyDefault->display()	JROOT/components/com_tags/views/tag/view.html.php:201
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.35 ms** **Dopo l'ultima query: 0.84 ms** **Memoria query: 0.029 MB memoria prima della query: 2.777 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=83

  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
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
24	JCategories->get()	JROOT/components/com_content/router.php:70
23	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default_items.php:65
15	include JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default_items.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
14	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php:51
13	include JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:229
11	YjsgJViewLegacyDefault->display()	JROOT/components/com_tags/views/tag/view.html.php:201
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

**Tempo della query: 0.37 ms** **Dopo l'ultima query: 1.16 ms** **Memoria query: 0.029 MB memoria prima della query: 2.801 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=35

  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
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
24	JCategories->get()	JROOT/components/com_content/router.php:70
23	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default_items.php:65
15	include JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default_items.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
14	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php:51
13	include JROOT/plugins/system/yjsg/legacy/html/com_tags/tag/default.php	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/30/component/view.php:118
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/yjsg/includes/yjsgcore/classes/extend/classes/YjsgJViewLegacyDefault30.php:229
11	YjsgJViewLegacyDefault->display()	JROOT/components/com_tags/views/tag/view.html.php:201
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.33 ms** **Dopo l'ultima query: 9.14 ms** **Memoria query: 0.027 MB memoria prima della query: 2.908 MB** **Righe restituite: 20**

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-10-05 03:02:06') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-10-05 03:02:06') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 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.34 ms** **Dopo l'ultima query: 23.06 ms** **Memoria query: 0.025 MB memoria prima della query: 3.369 MB** **Righe restituite: 0**

**Query duplicate**: #35 #52 #57 #58 #59 #67 #76 #81

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: 0.67 ms** **Memoria query: 0.025 MB memoria prima della query: 3.379 MB** **Righe restituite: 0**

**Query duplicate**: #34 #52 #57 #58 #59 #67 #76 #81

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.29 ms** **Dopo l'ultima query: 0.19 ms** **Memoria query: 0.025 MB memoria prima della query: 3.388 MB** **Righe restituite: 1**

**Query duplicate**: #37 #38 #39 #40 #41 #42 #43 #44 #45 #46 #47 #48 #49 #50 #51

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_menu	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
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.41 ms** **Dopo l'ultima query: 0.22 ms** **Memoria query: 0.025 MB memoria prima della query: 3.411 MB** **Righe restituite: 1**

**Query duplicate**: #36 #38 #39 #40 #41 #42 #43 #44 #45 #46 #47 #48 #49 #50 #51

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_menu	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
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.27 ms** **Memoria query: 0.025 MB memoria prima della query: 3.420 MB** **Righe restituite: 1**

**Query duplicate**: #36 #37 #39 #40 #41 #42 #43 #44 #45 #46 #47 #48 #49 #50 #51

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_menu	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
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.64 ms** **Dopo l'ultima query: 0.20 ms** **Memoria query: 0.025 MB memoria prima della query: 3.430 MB** **Righe restituite: 1**

Palazzo Farnese

10 Novembre ore 15,00 - Visita Guidata a Palazzo Farnese

5 luglio, visita guidata a Palazzo

Camera dell'Aurora

Come arrivare a Palazzo

Dal Barco ai giardini di Caprarola 4 luglio 2015

Fuga Romantica a Caprarola

I Giardini di Palazzo Farnese

Il Cortile Circolare

Il nuovo libro sul Palazzo Farnese di Caprarola

La Cappella

La Casina del Piacere e i Giardini alti

La famiglia Farnese ha origini nella Tuscia

La Guida cartacea

La Scala Regia

La Stanza dei Sogni e degli angeli messaggeri

La Via Dritta a Caprarola

Le Stanze e gli affreschi

Le Vedute prospettiche del Palazzo

Orari Palazzo Farnese Caprarola e biglietti

Palazzo Farnese di Caprarola

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

105 query eseguite 155.37 ms

Trovati 65 duplicati!

Palazzo Farnese

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

**105 query eseguite** 155.37 ms

**Trovati 65 duplicati!**

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

105 query eseguite 155.37 ms

Trovati 65 duplicati!