Genitori

1 1

Filtro

Filtro titolo

Visualizza n.

Titolo	Visite
Nuovo IBAN I.C. Carmignano-Fontaniva	20
Informativa privacy Invalsi	23
Iscrizioni scuola secondaria primo grado a.s. 2019/2020	39
Iscrizioni scuola primaria a.s. 2019/2020	22
Privacy per iscrizioni scuola infanzia	31
MODULO ISCRIZIONE INFANZIA alunni residenti a Carmignano di Brenta	41
- MODULO ISCRIZIONE INFANZIA alunni non residenti a Carmignano di Brenta	53
Iscrizioni scuola dell'Infanzia a.s. 2019/20	32
Guida informativa multilingue sul sistema educativo in Veneto e in alcuni paesi del mondo.	24
CONSEGNA PASSWORD REGISTRO ELETTRONICO AI GENITORI DEGLI ALUNNI DELLE SCUOLE SECONDARIE DEL NS. ISTITUTO	120

Pagina 1 di 3

ISTITUTO COMPRENSIVO STATALE CARMIGNANO-FONTANIVA
Via Ugo Foscolo, 1 12345 - Carmignano di Brenta (PD)
Telefono: 049.5957050; Fax: 049.9430850;
Email:pdic83600c@istruzione.it
PEC: pdic83600c@pec.istruzione.it
Codice Meccanografico: PDIC83600C - Codice Fiscale: 81004750287 - Codice Univoco d'ufficio: UFIWEY

I cookie ci aiutano a fornire i nostri servizi. Utilizzando tali servizi accetti l'utilizzo dei cookie da parte nostra.

Leggi l'informativa

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1548272970,
                "last": 1548272970,
                "now": 1548272970
            },
            "token": "C9jPpmGjvgDM3cWZ3z5JRSrXpwtGopkm"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cDovL3d3dy5pY3NjYXJtaWduYW5vZm9udGFuaXZhLmVkdS5pdC9pbmRleC5waHAvYXJlYS1nZW5pdG9yaT8%3D"
            }
        },
        "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
        },
        "plg_system_notificationary": null
    },
    "__JPluginGJFields": {
        "DefaultParams": {
            "{notificationgroup": "JGLOBAL_ARTICLES",
            "isenabled": "1",
            "ausers_notifyon": "0",
            "status_action_to_notify": "always",
            "ausers_notifyonlyifcanview": "1",
            "oncontentchangestate": "1",
            "context_or_contenttype": "content_type",
            "context": "",
            "content_type": "1",
            "ausers_articlegroups": "0",
            "allow_subscribe": "1",
            "allow_subscribe_default": "1",
            "content_language": "always",
            "ausers_articles": "0",
            "ausers_notifyusergroups": "1",
            "ausers_notifyusers": "0",
            "ausers_excludeusers": "arygroup@gmail.com",
            "author_notifyonaction": "6",
            "author_foranyuserchanges": "1",
            "author_mailbody_type": "inherit",
            "ausers_notifymodifier": "0",
            "modifier_mailbody_type": "inherit",
            "ausers_allowusergroups": "0",
            "ausers_allowusers": "0",
            "shownotificationswitch": "1",
            "notificationswitchdefault": "1",
            "notificationswitchfrontend": "1",
            "notificationswitchaddconfirmation": "0",
            "ausers_allowswitchforusergroups": "0",
            "ausers_allowswitchforusers": "0",
            "sender_name": "",
            "sender_email": "",
            "replyto_name": "",
            "replyto_email": "",
            "emailformat": "plaintext",
            "attachpreviousversion": "0",
            "attachdiffinfo": "0",
            "messagebodysource": "hardcoded",
            "strip_plugin_tags": "1",
            "make_image_path_absolute": "absolute",
            "personalize": "0",
            "ausers_includearticletitle": "1",
            "ausers_includecontenttype": "0",
            "ausers_includecategorytree": "1",
            "ausers_includeauthorname": "1",
            "ausers_includemodifiername": "1",
            "ausers_includecreateddate": "1",
            "ausers_includemodifieddate": "1",
            "ausers_includeintrotext": "1",
            "ausers_includefulltext": "1",
            "includediffinfo_text": "none",
            "includediffinfo_html": "none",
            "ausers_includefrontendviewlink": "1",
            "ausers_includefrontendeditlink": "1",
            "ausers_includebackendeditlink": "1",
            "ausers_includeunsubscribelink": "1",
            "manage_subscription_link": "",
            "messagesubjectcustom": "PLG_SYSTEM_NOTIFICATIONARY_FIELD_MESSAGE_SUBJECT_PLACEHOLDERS_DEFAULT",
            "add_menu_item": "1",
            "replacement_type": "default",
            "useajax": "0",
            "verbose": "0",
            "ajax_allow_to_cancel": "0",
            "ajax_allowusergroups": "0",
            "ajax_allowusers": "0",
            "ajax_delay": "0",
            "mails_per_iteration": "3",
            "forceNotTimeLimit": "0",
            "showsuccessmessage": "0",
            "successmessage": "PLG_SYSTEM_NOTIFICATIONARY_FIELD_MAIL_HAS_BEEN_SENT",
            "successmessagenumberofusers": "0",
            "showerrormessage": "0",
            "errormessage": "PLG_SYSTEM_NOTIFICATIONARY_FIELD_MAIL_COULD_NOT_BE_SENT",
            "showContext": "0",
            "debug": "0",
            "generatefakeusers": "0",
            "fakeusersnumber": "1"
        }
    },
    "__notificationary": {
        "AjaxHash": null
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 6.53 ms / 6.53 ms Memoria: 0.820 MB / 1.03 MB Application: afterLoad

Tempo: 55.46 ms / 61.99 ms Memoria: 2.591 MB / 3.63 MB Application: afterInitialise

Tempo: 13.72 ms / 75.71 ms Memoria: 0.903 MB / 4.53 MB Application: afterRoute

Tempo: 3.09 ms / 78.80 ms Memoria: 0.079 MB / 4.61 MB Application: beforeRenderComponent com_content

Tempo: 6.62 ms / 85.42 ms Memoria: 0.245 MB / 4.85 MB Application: Before Access::preloadComponents (all components)

Tempo: 1.94 ms / 87.36 ms Memoria: 0.109 MB / 4.96 MB Application: After Access::preloadComponents (all components)

Tempo: 0.06 ms / 87.42 ms Memoria: 0.000 MB / 4.96 MB Application: Before Access::preloadPermissions (com_content)

Tempo: 4.09 ms / 91.51 ms Memoria: 0.701 MB / 5.66 MB Application: After Access::preloadPermissions (com_content)

Tempo: 0.17 ms / 91.68 ms Memoria: 0.000 MB / 5.61 MB Application: Before Access::getAssetRules (id:76 name:com_content.category.12)

Tempo: 0.48 ms / 92.17 ms Memoria: 0.024 MB / 5.64 MB Application: After Access::getAssetRules (id:76 name:com_content.category.12)

Tempo: 4.33 ms / 96.50 ms Memoria: 0.197 MB / 5.84 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tempo: 0.17 ms / 96.66 ms Memoria: 0.014 MB / 5.85 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tempo: 68.82 ms / 165.49 ms Memoria: 2.093 MB / 7.94 MB Application: Before Access::getAssetRules (id:721 name:com_content.article.1106)

Tempo: 0.07 ms / 165.56 ms Memoria: 0.003 MB / 7.95 MB Application: After Access::getAssetRules (id:721 name:com_content.article.1106)

Tempo: 1.11 ms / 166.67 ms Memoria: 0.069 MB / 8.02 MB Application: Before Access::getAssetRules (id:65 name:com_attachments)

Tempo: 0.17 ms / 166.84 ms Memoria: 0.013 MB / 8.03 MB Application: After Access::getAssetRules (id:65 name:com_attachments)

Tempo: 0.15 ms / 166.98 ms Memoria: 0.001 MB / 8.03 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Tempo: 0.14 ms / 167.12 ms Memoria: 0.013 MB / 8.04 MB Application: After Access::getAssetRules (id:1 name:root.1)

Tempo: 51.17 ms / 218.29 ms Memoria: 0.860 MB / 8.90 MB Application: Before Access::getAssetRules (id:720 name:com_content.article.1105)

Tempo: 0.06 ms / 218.35 ms Memoria: 0.003 MB / 8.91 MB Application: After Access::getAssetRules (id:720 name:com_content.article.1105)

Tempo: 44.00 ms / 262.35 ms Memoria: 0.454 MB / 9.36 MB Application: Before Access::getAssetRules (id:707 name:com_content.article.1092)

Tempo: 0.06 ms / 262.41 ms Memoria: 0.003 MB / 9.36 MB Application: After Access::getAssetRules (id:707 name:com_content.article.1092)

Tempo: 42.99 ms / 305.40 ms Memoria: 0.451 MB / 9.82 MB Application: Before Access::getAssetRules (id:706 name:com_content.article.1091)

Tempo: 0.08 ms / 305.48 ms Memoria: 0.003 MB / 9.82 MB Application: After Access::getAssetRules (id:706 name:com_content.article.1091)

Tempo: 42.62 ms / 348.10 ms Memoria: 0.452 MB / 10.27 MB Application: Before Access::getAssetRules (id:704 name:com_content.article.1089)

Tempo: 0.06 ms / 348.16 ms Memoria: 0.003 MB / 10.27 MB Application: After Access::getAssetRules (id:704 name:com_content.article.1089)

Tempo: 43.35 ms / 391.51 ms Memoria: 0.579 MB / 10.85 MB Application: Before Access::getAssetRules (id:703 name:com_content.article.1088)

Tempo: 0.06 ms / 391.57 ms Memoria: 0.003 MB / 10.86 MB Application: After Access::getAssetRules (id:703 name:com_content.article.1088)

Tempo: 42.61 ms / 434.18 ms Memoria: 0.458 MB / 11.31 MB Application: Before Access::getAssetRules (id:702 name:com_content.article.1087)

Tempo: 0.08 ms / 434.26 ms Memoria: 0.003 MB / 11.32 MB Application: After Access::getAssetRules (id:702 name:com_content.article.1087)

Tempo: 40.49 ms / 474.75 ms Memoria: 0.454 MB / 11.77 MB Application: Before Access::getAssetRules (id:701 name:com_content.article.1086)

Tempo: 0.06 ms / 474.81 ms Memoria: 0.003 MB / 11.77 MB Application: After Access::getAssetRules (id:701 name:com_content.article.1086)

Tempo: 41.46 ms / 516.27 ms Memoria: 0.452 MB / 12.23 MB Application: Before Access::getAssetRules (id:695 name:com_content.article.1080)

Tempo: 0.07 ms / 516.35 ms Memoria: 0.004 MB / 12.23 MB Application: After Access::getAssetRules (id:695 name:com_content.article.1080)

Tempo: 40.00 ms / 556.35 ms Memoria: 0.453 MB / 12.68 MB Application: Before Access::getAssetRules (id:663 name:com_content.article.1049)

Tempo: 0.06 ms / 556.40 ms Memoria: 0.003 MB / 12.69 MB Application: After Access::getAssetRules (id:663 name:com_content.article.1049)

Tempo: 51.11 ms / 607.51 ms Memoria: 0.648 MB / 13.33 MB Application: Before Access::getAssetRules (id:205 name:com_content.article.12)

Tempo: 0.24 ms / 607.76 ms Memoria: 0.014 MB / 13.35 MB Application: After Access::getAssetRules (id:205 name:com_content.article.12)

Tempo: 16.27 ms / 624.03 ms Memoria: 0.053 MB / 13.40 MB Application: afterRenderComponent com_content

Tempo: 1.82 ms / 625.85 ms Memoria: 0.008 MB / 13.41 MB Application: afterDispatch

Tempo: 13.40 ms / 639.25 ms Memoria: 0.143 MB / 13.55 MB Application: beforeRenderModule mod_menu (Footer menu)

Tempo: 7.29 ms / 646.54 ms Memoria: 0.133 MB / 13.68 MB Application: afterRenderModule mod_menu (Footer menu)

Tempo: 0.12 ms / 646.66 ms Memoria: 0.000 MB / 13.67 MB Application: beforeRenderModule mod_custom (Footer)

Tempo: 1.21 ms / 647.87 ms Memoria: 0.012 MB / 13.69 MB Application: afterRenderModule mod_custom (Footer)

Tempo: 0.28 ms / 648.16 ms Memoria: 0.000 MB / 13.68 MB Application: beforeRenderModule mod_custom (Iscrizioni 2019-2020)

Tempo: 0.33 ms / 648.49 ms Memoria: 0.007 MB / 13.69 MB Application: afterRenderModule mod_custom (Iscrizioni 2019-2020)

Tempo: 0.07 ms / 648.56 ms Memoria: 0.000 MB / 13.69 MB Application: beforeRenderModule mod_menu (Comunicazioni)

Tempo: 2.23 ms / 650.79 ms Memoria: 0.058 MB / 13.75 MB Application: afterRenderModule mod_menu (Comunicazioni)

Tempo: 0.06 ms / 650.86 ms Memoria: 0.000 MB / 13.74 MB Application: beforeRenderModule mod_menu (Ricevimenti)

Tempo: 0.37 ms / 651.23 ms Memoria: 0.009 MB / 13.75 MB Application: afterRenderModule mod_menu (Ricevimenti)

Tempo: 0.07 ms / 651.29 ms Memoria: 0.000 MB / 13.74 MB Application: beforeRenderModule mod_articles_latest (Ultimi Articoli)

Tempo: 19.01 ms / 670.30 ms Memoria: 0.245 MB / 13.99 MB Application: afterRenderModule mod_articles_latest (Ultimi Articoli)

Tempo: 0.25 ms / 670.55 ms Memoria: 0.000 MB / 13.83 MB Application: beforeRenderModule mod_custom (Banner amministrazione trasparente)

Tempo: 0.29 ms / 670.83 ms Memoria: 0.007 MB / 13.84 MB Application: afterRenderModule mod_custom (Banner amministrazione trasparente)

Tempo: 0.06 ms / 670.89 ms Memoria: 0.000 MB / 13.84 MB Application: beforeRenderModule mod_banners (Banner_pon)

Tempo: 17.60 ms / 688.49 ms Memoria: 0.116 MB / 13.95 MB Application: afterRenderModule mod_banners (Banner_pon)

Tempo: 0.13 ms / 688.62 ms Memoria: 0.000 MB / 13.94 MB Application: beforeRenderModule mod_custom (Banner Albo)

Tempo: 0.29 ms / 688.91 ms Memoria: 0.007 MB / 13.95 MB Application: afterRenderModule mod_custom (Banner Albo)

Tempo: 0.06 ms / 688.97 ms Memoria: 0.000 MB / 13.94 MB Application: beforeRenderModule mod_custom (Banner Portale Argo)

Tempo: 0.24 ms / 689.21 ms Memoria: 0.007 MB / 13.95 MB Application: afterRenderModule mod_custom (Banner Portale Argo)

Tempo: 0.06 ms / 689.28 ms Memoria: 0.000 MB / 13.95 MB Application: beforeRenderModule mod_custom (Banner ANAC pubblicazione dati)

Tempo: 0.25 ms / 689.53 ms Memoria: 0.007 MB / 13.95 MB Application: afterRenderModule mod_custom (Banner ANAC pubblicazione dati)

Tempo: 0.20 ms / 689.72 ms Memoria: 0.000 MB / 13.95 MB Application: beforeRenderModule mod_menu (Il nostro istituto)

Tempo: 5.64 ms / 695.36 ms Memoria: 0.169 MB / 14.12 MB Application: afterRenderModule mod_menu (Il nostro istituto)

Tempo: 0.11 ms / 695.47 ms Memoria: 0.000 MB / 14.12 MB Application: beforeRenderModule mod_menu (Uffici)

Tempo: 1.98 ms / 697.46 ms Memoria: 0.039 MB / 14.15 MB Application: afterRenderModule mod_menu (Uffici)

Tempo: 0.07 ms / 697.53 ms Memoria: 0.000 MB / 14.15 MB Application: beforeRenderModule mod_menu (Pubblicità legale)

Tempo: 1.49 ms / 699.02 ms Memoria: 0.045 MB / 14.19 MB Application: afterRenderModule mod_menu (Pubblicità legale)

Tempo: 0.08 ms / 699.10 ms Memoria: 0.000 MB / 14.19 MB Application: beforeRenderModule mod_menu (Risorse)

Tempo: 0.50 ms / 699.61 ms Memoria: 0.009 MB / 14.19 MB Application: afterRenderModule mod_menu (Risorse)

Tempo: 0.22 ms / 699.82 ms Memoria: 0.000 MB / 14.19 MB Application: beforeRenderModule mod_menu (Top menu)

Tempo: 11.59 ms / 711.41 ms Memoria: 0.392 MB / 14.58 MB Application: afterRenderModule mod_menu (Top menu)

Tempo: 0.22 ms / 711.63 ms Memoria: 0.000 MB / 14.58 MB Application: beforeRenderModule mod_search (Cerca)

Tempo: 1.87 ms / 713.50 ms Memoria: 0.050 MB / 14.63 MB Application: afterRenderModule mod_search (Cerca)

Tempo: 0.16 ms / 713.66 ms Memoria: 0.000 MB / 14.62 MB Application: beforeRenderModule mod_breadcrumbs (percorso)

Tempo: 1.87 ms / 715.53 ms Memoria: 0.022 MB / 14.64 MB Application: afterRenderModule mod_breadcrumbs (percorso)

Tempo: 0.16 ms / 715.68 ms Memoria: 0.000 MB / 14.63 MB Application: beforeRenderModule mod_accessibility_links (Accessibility Links)

Tempo: 1.75 ms / 717.43 ms Memoria: 0.025 MB / 14.65 MB Application: afterRenderModule mod_accessibility_links (Accessibility Links)

Tempo: 0.08 ms / 717.51 ms Memoria: 0.000 MB / 14.65 MB Application: beforeRenderModule mod_menu (support-menu)

Tempo: 1.91 ms / 719.41 ms Memoria: 0.042 MB / 14.69 MB Application: afterRenderModule mod_menu (support-menu)

Tempo: 13.97 ms / 733.38 ms Memoria: 0.122 MB / 14.82 MB Application: afterRender

Query totali del database: 130.98 ms

Utilizzo memoria

Query Database

200 query eseguite 130.98 ms

Trovati 100 duplicati!

20 duplicati: #39 #40 #56 #57 #71 #72 #86 #87 #101 #102 #116 #117 #131 #132 #146 #147 #161 #162 #176 #177

20 duplicati: #44 #49 #60 #64 #75 #79 #90 #94 #105 #109 #120 #124 #135 #139 #150 #154 #165 #169 #180 #184

20 duplicati: #45 #50 #61 #65 #76 #80 #91 #95 #106 #110 #121 #125 #136 #140 #151 #155 #166 #170 #181 #185

20 duplicati: #46 #51 #62 #66 #77 #81 #92 #96 #107 #111 #122 #126 #137 #141 #152 #156 #167 #171 #182 #186

2 duplicati: #48 #52

2 duplicati: #63 #67

2 duplicati: #78 #82

2 duplicati: #93 #97

2 duplicati: #108 #112

2 duplicati: #123 #127

2 duplicati: #138 #142

2 duplicati: #153 #157

2 duplicati: #168 #172

2 duplicati: #183 #187

Tempo della query: 0.40 ms Memoria query: 0.021 MB memoria prima della query: 1.595 MB Righe restituite: 0

SELECT `data`

  FROM `jhost_session`

  WHERE `session_id` = 'efioc4o7k1pvg23s2s06kt4ol5'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jhost_session	const	PRIMARY	PRIMARY	766	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:1734
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:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tempo della query: 0.80 ms Dopo l'ultima query: 1.45 ms Memoria query: 0.013 MB memoria prima della query: 1.656 MB Righe restituite: 0

SELECT `session_id`

  FROM `jhost_session`

  WHERE `session_id` = 'efioc4o7k1pvg23s2s06kt4ol5' 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tempo della query: 1.57 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.010 MB memoria prima della query: 1.673 MB

INSERT INTO `jhost_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('efioc4o7k1pvg23s2s06kt4ol5', 1, 1548272970, 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `jhost_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('efioc4o7k1pvg23s2s06kt4ol5', 1, 1548272970, 0, '', 0)

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/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tempo della query: 0.62 ms Dopo l'ultima query: 1.23 ms Memoria query: 0.022 MB memoria prima della query: 1.752 MB Righe restituite: 45

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

  FROM `jhost_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jhost_extensions	ref	extension	extension	82	const	47	Using index condition; 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:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.30 ms Dopo l'ultima query: 1.12 ms Memoria query: 0.015 MB memoria prima della query: 1.857 MB Righe restituite: 9

SELECT id, rules

  FROM `jhost_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jhost_viewlevels	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9

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:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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: 0.17 ms Memoria query: 0.016 MB memoria prima della query: 1.884 MB Righe restituite: 2

SELECT b.id

  FROM jhost_usergroups AS a

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

  WHERE a.id = 9

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	3	Using where; Using index

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:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.94 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.024 MB memoria prima della query: 1.923 MB Righe restituite: 98

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

  FROM jhost_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jhost_extensions	ref	extension	extension	82	const	121	Using index condition; Using where; Using filesort

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:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.95 ms Dopo l'ultima query: 31.07 ms Memoria query: 0.026 MB memoria prima della query: 3.406 MB Righe restituite: 8

SHOW FULL COLUMNS 
  FROM `jhost_content_types`

Explain

EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `jhost_content_types`

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:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/ContentType.php:29
13	Joomla\CMS\Table\ContentType->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/notificationary/notificationary.php:468
11	PlgSystemNotificationaryCore->_getExtensionInfo()	JROOT/plugins/system/notificationary/notificationary.php:314
10	PlgSystemNotificationaryCore->_prepareParams()	JROOT/plugins/system/notificationary/notificationary.php:6449
9	PlgSystemNotificationaryCore->onAfterInitialise()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.32 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.021 MB memoria prima della query: 3.461 MB Righe restituite: 1

SELECT *

  FROM jhost_content_types

  WHERE `type_id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jhost_content_types	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:1459
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/notificationary/notificationary.php:469
11	PlgSystemNotificationaryCore->_getExtensionInfo()	JROOT/plugins/system/notificationary/notificationary.php:314
10	PlgSystemNotificationaryCore->_prepareParams()	JROOT/plugins/system/notificationary/notificationary.php:6449
9	PlgSystemNotificationaryCore->onAfterInitialise()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.36 ms Dopo l'ultima query: 0.39 ms Memoria query: 0.020 MB memoria prima della query: 3.501 MB Righe restituite: 1

SELECT *

  FROM jhost_content_types

  WHERE `type_alias` = 'com_content.category'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jhost_content_types	ref	idx_alias	idx_alias	402	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:1459
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/notificationary/notificationary.php:509
11	PlgSystemNotificationaryCore->_getExtensionInfo()	JROOT/plugins/system/notificationary/notificationary.php:314
10	PlgSystemNotificationaryCore->_prepareParams()	JROOT/plugins/system/notificationary/notificationary.php:6449
9	PlgSystemNotificationaryCore->onAfterInitialise()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.32 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.017 MB memoria prima della query: 3.506 MB Righe restituite: 0

SELECT `id`

  FROM `jhost_users`

  WHERE `email` = '' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jhost_users	ref	email	email	402	const	1	Using where; Using index

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/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/notificationary/helpers/helper.php:406
11	NotificationAryHelper::getUserByEmail()	JROOT/plugins/system/notificationary/notificationary.php:434
10	PlgSystemNotificationaryCore->_prepareParams()	JROOT/plugins/system/notificationary/notificationary.php:6449
9	PlgSystemNotificationaryCore->onAfterInitialise()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.36 ms Dopo l'ultima query: 0.41 ms Memoria query: 0.026 MB memoria prima della query: 3.521 MB Righe restituite: 1

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

  FROM `jhost_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jhost_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profilo

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

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/eorisis_google_analytics/eorisis_google_analytics.php:52
9	plgSystemEorisis_google_analytics->onAfterInitialise()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 2.49 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.018 MB memoria prima della query: 3.529 MB

UPDATE `jhost_extensions`

  SET `params` = '{\"mediaversion\":\"87a7affb6f32cc4937b37cd9c82fdeba\"}'

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

Explain

EXPLAIN non possibile sulla query: UPDATE `jhost_extensions` SET `params` = '{\"mediaversion\":\"87a7affb6f32cc4937b37cd9c82fdeba\"}' 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/eorisis_google_analytics/eorisis_google_analytics.php:52
9	plgSystemEorisis_google_analytics->onAfterInitialise()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.90 ms Dopo l'ultima query: 2.76 ms Memoria query: 0.041 MB memoria prima della query: 3.705 MB Righe restituite: 81

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

  LEFT JOIN jhost_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	188	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	uznu10y1_nuovo.m.component_id	1	Using where

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:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.49 ms Dopo l'ultima query: 10.94 ms Memoria query: 0.014 MB memoria prima della query: 4.550 MB Righe restituite: 2

SELECT *

  FROM jhost_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jhost_languages	ALL	NULL	NON È 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:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.49 ms Dopo l'ultima query: 0.75 ms Memoria query: 0.010 MB memoria prima della query: 4.585 MB Righe restituite: 3

SELECT id, home, template, s.params

  FROM jhost_template_styles as s

  LEFT JOIN jhost_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profilo

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

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.25 ms Dopo l'ultima query: 7.86 ms Memoria query: 0.030 MB memoria prima della query: 4.860 MB Righe restituite: 45

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

  FROM `jhost_assets`

  WHERE `name` IN ('root.1','com_accesskeys','com_admin','com_ajax','com_akeeba','com_albopretorio_online','com_associations','com_attachments','com_banners','com_buttons','com_cache','com_categories','com_checkin','com_chronoconnectivity5','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_receivements','com_redirect','com_remository','com_search','com_tags','com_templates','com_users','com_wrapper','com_xmap')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jhost_assets	range	idx_asset_name	idx_asset_name	202	NULL	46	Using index condition

Profilo

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

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.18 ms Dopo l'ultima query: 0.67 ms Memoria query: 0.045 MB memoria prima della query: 4.957 MB Righe restituite: 467

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

  FROM `jhost_assets`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jhost_assets	ALL	idx_asset_name,idx_parent_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	616	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.69 ms Dopo l'ultima query: 4.47 ms Memoria query: 0.030 MB memoria prima della query: 5.654 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 `jhost_categories` AS `s`

  INNER JOIN `jhost_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  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
1	SIMPLE	c	range	cat_idx,idx_left_right	idx_left_right	4	NULL	13	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.30 ms Dopo l'ultima query: 2.93 ms Memoria query: 0.038 MB memoria prima della query: 5.849 MB Righe restituite: 10

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

  FROM jhost_content AS a

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

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

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

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

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

  WHERE c.published = 1 
  AND a.state = 1 
  AND a.catid = 12 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-01-23 19:49:31') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-01-23 19:49:31')

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using filesort
1	SIMPLE	a	ref	idx_state,idx_catid	idx_catid	4	const	31	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	uznu10y1_nuovo.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	uznu10y1_nuovo.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	uznu10y1_nuovo.a.id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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: 1.26 ms Memoria query: 0.030 MB memoria prima della query: 6.009 MB Righe restituite: 0

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

  FROM `jhost_contentitem_tag_map` AS m 

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	uznu10y1_nuovo.m.tag_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.43 ms Dopo l'ultima query: 0.37 ms Memoria query: 0.030 MB memoria prima della query: 6.050 MB Righe restituite: 0

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

  FROM `jhost_contentitem_tag_map` AS m 

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	uznu10y1_nuovo.m.tag_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.39 ms Dopo l'ultima query: 0.51 ms Memoria query: 0.030 MB memoria prima della query: 6.092 MB Righe restituite: 0

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

  FROM `jhost_contentitem_tag_map` AS m 

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	uznu10y1_nuovo.m.tag_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.39 ms Memoria query: 0.030 MB memoria prima della query: 6.133 MB Righe restituite: 0