Informazioni principali:

Comunicazione ai sensi dir. 2009/136/CE: questo sito utilizza cookies tecnici anche di terze parti.

Note:

L'uso del sito costituisce accettazione implicità dell'uso dei cookies. Per revocare il consenso è sufficiente cancellare i cookies di dominio dal browser.
PRIVACY
ic28aliotta.gov.it
  • HOME
  • ISTITUTO
    • UN PO' DI STORIA
    • FINALITA' SCUOLA INFANZIA
    • FINALITA' SCUOLA PRIMARIA
    • FINALITA' SCUOLA SECONDARIA
    • FINALITA' SCUOLA IN OSPEDALE
    • PTOF
    • SEDI
    • CALENDARIO SCOLASTICO
    • DIRIGENTE SCOLASTICO
    • LO STAFF
    • FUNZIONIGRAMMA
    • SEGRETERIA - URP
    • ORGANI COLLEGIALI
    • ORARI DI FUNZIONAMENTO
    • REGOLAMENTI
    • CARTA DEI SERVIZI
    • QUALITÀ E PROCEDURE
    • CODICE COMPORTAMENTALE
  • NOTIZIE
  • DIDATTICA
    • SCUOLA DELL' INFANZIA
    • SCUOLA PRIMARIA
    • SCUOLA SECONDARIA
    • SCUOLA IN OSPEDALE
  • DIDATTICA ONLINE
    • SCUOLA DELL' INFANZIA ONLINE
    • SCUOLA PRIMARIA ONLINE
      • PRIME ONLINE
      • SECONDE ONLINE
      • TERZE ONLINE
      • QUARTE ONLINE
      • QUINTE ONLINE
    • SCUOLA SECONDARIA ONLINE
      • SECONDARIA PRIME
      • SECONDARIA SECONDA
      • SECONDARIA TERZE
    • GIOCHI MATEMATICI
  • ATA
  • GENITORI
    • ASSICURAZIONE
    • REFEZIONE SCOLASTICA
    • PATTO DI CORRESPONSABILITA'
    • LIBRI DI TESTO
    • OBBLIGO VACCINALE
  • ALUNNI
    • I LAVORI PIU' BELLI
    • RICONOSCIMENTI E PREMI
    • ESPLORANDO IL WEB
    • ORIENTAMENTO
  • FOTO
  • VIDEO
  • MODULI
    • MODULISTICA PER DOCENTI
    • MODULISTICA PER GENITORI
    • MODULISTICA PER ATA
  • ALBO PRETORIO
  • Sei qui:  
  • Home |
  • ISTITUTO |
  • LO STAFF

Staff AS 2016-2017

  • Stampa
  • Email

 

 

 

 

 

 

 

 

 

 

 

 

 


 
 

 

 

 

 

 

 

Scritto da Giovanni Salatiello
Categoria principale: L'ISTITUTO
Categoria: Lo Staff
Pubblicato: 07 Gennaio 2017

AREA RISERVATA

  • Nome utente dimenticato?
  • Password dimenticata?

DIDATTICA ONLINE

Care alunne e cari alunni,
Uno dei rischi più grandi, oggi, è l'ozio e l'apatia.
Tenete vivo il contatto con la scuola
Lavoriamo insieme con la Didattica OnLine.
Buon lavoro e a presto
I vostri Insegnanti

Link


TUTTO ANDRA' BENE

I Lavori dei Nostri Alunni

VIDEO


MARIO, IL SIMBOLO DELLA NOSTRA RESILIENZA

Articolo sul Mattino

Link


La Scuola di Napoli Non Si Ferma

Portale di Notizie e Consigli per la Scuola di Napoli

Clicca





 

Attività dell'Istituto

  • Pon
    • FSE 2016
  • Calendario Scolastico
  • Orari
  • P.O.F.
  • Laboratori
  • Progetti
    • La scuola e la città
  • Iniziative e attività
  • D.S.A.
  • Disabilità
  • Orientamento
  • Valutazione
  • Telethon
  • Trinity College
  • Fondo Europeo Sviluppo Regionale
  • Libera
  • Save the Children
  • PNSD
    • Progetto atelier creativi
    • Piano della formazione
  • Eipass
  • Sicurezza

SITI TEMATICI

  • Agenzia Nazionale per lo sviluppo dell'Autonomia scolastica - ex INDIRE
  • ARAN Contratti ScuolaMIUR
  • Città Metropolitana di Napoli
  • Comune di Napoli
  • CSA Napoli
  • Invalsi
  • Linea Amica
  • Miur Iscrizioni on line - Polis
  • Miur - PON Fondi Strutturali Europei 2007/13
  • Portale Europeo per i Giovani
  • Regione Campania
  • Sito Generale della Commissione EuropeaUsr
  • Ufficio Scolastico Regionale della Campania

Copyright © 2021 ic28aliotta.gov.it. Tutti i diritti riservati.
Joomla! è un software libero rilasciato sotto licenza GNU/GPL.
  • Privacy Policy
  • Note Legali
  • Contattaci
  • Dove Siamo

Back to Top

Codice Fiscale: 80031860630

Citazione Malala

"Un bambino, un maestro, una penna e un libro possono cambiare il mondo."

Malala Yousafzai, 15 luglio 2013.

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1614790751,
                "last": 1614790751,
                "now": 1614790751
            },
            "token": "oFnJ84Wbx6SV6h7jvr7nFUcb4cMo8ivU"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuaWMyOGFsaW90dGEuZWR1Lml0L2luZGV4LnBocC9sLWlzdGl0dXRvL2RpcmlnZW50ZS1hbW1pbmlzdHJhdGl2bz8%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
        },
        "com_mailto": {
            "links": {
                "7003e271ffb963f99bf7c9150858a912c6cf5e00": {
                    "link": "https:\/\/www.ic28aliotta.edu.it\/index.php\/l-istituto\/dirigente-amministrativo",
                    "expiry": 1614790752
                }
            }
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 138.25 ms / 138.25 ms Memoria: 0.740 MB / 0.96 MB Application: afterLoad
Tempo: 328.66 ms / 466.91 ms Memoria: 5.019 MB / 5.98 MB Application: afterInitialise
Tempo: 165.96 ms / 632.88 ms Memoria: 1.905 MB / 7.89 MB Application: afterRoute
Tempo: 16.43 ms / 649.30 ms Memoria: 0.071 MB / 7.96 MB Application: beforeRenderComponent com_content
Tempo: 30.40 ms / 679.70 ms Memoria: 0.573 MB / 8.53 MB Application: Before JAccess::preloadComponents (all components)
Tempo: 1.40 ms / 681.10 ms Memoria: 0.095 MB / 8.63 MB Application: After JAccess::preloadComponents (all components)
Tempo: 0.11 ms / 681.21 ms Memoria: 0.000 MB / 8.62 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)
Tempo: 4.86 ms / 686.07 ms Memoria: 0.046 MB / 8.67 MB Application: After JAccess::getAssetRules (id:8 name:com_content)
Tempo: 161.56 ms / 847.63 ms Memoria: 2.190 MB / 10.86 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)
Tempo: 0.20 ms / 847.84 ms Memoria: 0.013 MB / 10.87 MB Application: After JAccess::getAssetRules (id:1 name:root.1)
Tempo: 440.97 ms / 1288.81 ms Memoria: 4.070 MB / 14.94 MB Application: Before JAccess::preloadPermissions (com_content)
Tempo: 6.49 ms / 1295.29 ms Memoria: 1.400 MB / 16.34 MB Application: After JAccess::preloadPermissions (com_content)
Tempo: 0.42 ms / 1295.71 ms Memoria: 0.000 MB / 16.26 MB Application: Before JAccess::getAssetRules (id:93 name:com_content.article.18)
Tempo: 0.16 ms / 1295.87 ms Memoria: 0.014 MB / 16.27 MB Application: After JAccess::getAssetRules (id:93 name:com_content.article.18)
Tempo: 11.48 ms / 1307.35 ms Memoria: 0.151 MB / 16.42 MB Application: Before JAccess::getAssetRules (id:98 name:com_attachments)
Tempo: 0.14 ms / 1307.49 ms Memoria: 0.013 MB / 16.44 MB Application: After JAccess::getAssetRules (id:98 name:com_attachments)
Tempo: 61.09 ms / 1368.58 ms Memoria: 0.260 MB / 16.70 MB Application: afterRenderComponent com_content
Tempo: 1.55 ms / 1370.13 ms Memoria: 0.007 MB / 16.70 MB Application: afterDispatch
Tempo: 26.74 ms / 1396.87 ms Memoria: 0.247 MB / 16.95 MB Application: beforeRenderModule mod_custom (Citazione Malala)
Tempo: 16.29 ms / 1413.16 ms Memoria: 0.046 MB / 17.00 MB Application: afterRenderModule mod_custom (Citazione Malala)
Tempo: 5.64 ms / 1418.80 ms Memoria: 0.000 MB / 17.00 MB Application: beforeRenderModule mod_footer (mod_Footer)
Tempo: 40.99 ms / 1459.79 ms Memoria: 0.013 MB / 17.01 MB Application: afterRenderModule mod_footer (mod_Footer)
Tempo: 7.52 ms / 1467.31 ms Memoria: 0.000 MB / 17.01 MB Application: beforeRenderModule mod_menu (foot2)
Tempo: 29.99 ms / 1497.30 ms Memoria: 0.154 MB / 17.16 MB Application: afterRenderModule mod_menu (foot2)
Tempo: 2.64 ms / 1499.94 ms Memoria: 0.000 MB / 17.13 MB Application: beforeRenderModule mod_login (AREA RISERVATA)
Tempo: 33.47 ms / 1533.41 ms Memoria: 0.181 MB / 17.31 MB Application: afterRenderModule mod_login (AREA RISERVATA)
Tempo: 3.99 ms / 1537.40 ms Memoria: 0.016 MB / 17.33 MB Application: beforeRenderModule mod_custom (NEWS IMAGE)
Tempo: 2.51 ms / 1539.91 ms Memoria: 0.007 MB / 17.33 MB Application: afterRenderModule mod_custom (NEWS IMAGE)
Tempo: 1.81 ms / 1541.72 ms Memoria: 0.000 MB / 17.32 MB Application: beforeRenderModule mod_newsscroller_self_dhtml (NEWS)
Tempo: 10.94 ms / 1552.66 ms Memoria: 0.067 MB / 17.39 MB Application: afterRenderModule mod_newsscroller_self_dhtml (NEWS)
Tempo: 3.41 ms / 1556.07 ms Memoria: 0.000 MB / 17.38 MB Application: beforeRenderModule mod_custom (amm_trasp_logo)
Tempo: 2.29 ms / 1558.35 ms Memoria: 0.007 MB / 17.39 MB Application: afterRenderModule mod_custom (amm_trasp_logo)
Tempo: 4.25 ms / 1562.60 ms Memoria: 0.000 MB / 17.39 MB Application: beforeRenderModule mod_menu (Attività dell'Istituto)
Tempo: 45.39 ms / 1607.99 ms Memoria: 0.317 MB / 17.71 MB Application: afterRenderModule mod_menu (Attività dell'Istituto)
Tempo: 4.71 ms / 1612.70 ms Memoria: 0.000 MB / 17.70 MB Application: beforeRenderModule mod_custom (SITI TEMATICI)
Tempo: 2.55 ms / 1615.25 ms Memoria: 0.007 MB / 17.71 MB Application: afterRenderModule mod_custom (SITI TEMATICI)
Tempo: 2.51 ms / 1617.77 ms Memoria: 0.000 MB / 17.68 MB Application: beforeRenderModule mod_breadcrumbs (Percorso)
Tempo: 13.73 ms / 1631.50 ms Memoria: 0.125 MB / 17.80 MB Application: afterRenderModule mod_breadcrumbs (Percorso)
Tempo: 21.59 ms / 1653.09 ms Memoria: 0.019 MB / 17.82 MB Application: beforeRenderModule mod_search (Cerca)
Tempo: 14.27 ms / 1667.37 ms Memoria: 0.031 MB / 17.86 MB Application: afterRenderModule mod_search (Cerca)
Tempo: 5.61 ms / 1672.98 ms Memoria: 0.000 MB / 17.84 MB Application: beforeRenderModule mod_menu (Menu Principale)
Tempo: 101.40 ms / 1774.38 ms Memoria: 0.844 MB / 18.69 MB Application: afterRenderModule mod_menu (Menu Principale)
Tempo: 23.77 ms / 1798.14 ms Memoria: 0.133 MB / 18.82 MB Application: afterRender

Query totali del database: 48.56 ms

Utilizzo memoria

19,53 MB (20.479.184 Bytes)

Query Database

30 query eseguite 48.56 ms


  1. Tempo della query: 1.54 ms Memoria query: 0.008 MB memoria prima della query: 3.042 MB
    DELETE 
    
      FROM `i9hrp_session`
      WHERE `time` < '1614789851'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1DELETEi9hrp_sessionNULLrangetimetime59const1100.00Using where
    Profilo
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.07 ms
    init0.03 ms
    System lock0.07 ms
    updating0.40 ms
    end0.01 ms
    Waiting for query cache lock0.01 ms
    end0.01 ms
    query end0.07 ms
    closing tables0.05 ms
    freeing items0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    6JDatabaseDriverMysqli->execute()JROOT/libraries/cms/application/cms.php:818
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:412
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  2. Tempo della query: 6.01 ms Dopo l'ultima query: 3.38 ms Memoria query: 0.020 MB memoria prima della query: 3.073 MB Righe restituite: 0
    SELECT `data`
    
      FROM `i9hrp_session`
      WHERE `session_id` = '6e0hida285jbev4acpimkmk4g1'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_sessionNULLconstPRIMARYPRIMARY766const1100.00NULL
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.00 ms
    checking query cache for query0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.02 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables5.45 ms
    freeing items0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.06 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 ms
    freeing items0.00 ms
    storing result in query cache0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Chiamata uguale alla linea sottostante.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:82
    10JSessionHandlerJoomla->start()JROOT/libraries/joomla/session/session.php:648
    9JSession->_start()JROOT/libraries/joomla/session/session.php:608
    8JSession->start()JROOT/libraries/joomla/session/session.php:486
    7JSession->get()JROOT/libraries/joomla/session/session.php:443
    6JSession->isNew()JROOT/libraries/cms/application/cms.php:825
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:412
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  3. Tempo della query: 0.52 ms Dopo l'ultima query: 7.57 ms Memoria query: 0.012 MB memoria prima della query: 3.215 MB Righe restituite: 0
    SELECT `session_id`
    
      FROM `i9hrp_session`
      WHERE `session_id` = '6e0hida285jbev4acpimkmk4g1'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_sessionNULLconstPRIMARYPRIMARY766const1100.00Using index
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    starting0.00 ms
    checking query cache for query0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.03 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.04 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    7JDatabaseDriver->loadResult()JROOT/libraries/cms/application/cms.php:176
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:827
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:412
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  4. Tempo della query: 0.47 ms Dopo l'ultima query: 0.37 ms Memoria query: 0.009 MB memoria prima della query: 3.231 MB
    INSERT INTO `i9hrp_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('6e0hida285jbev4acpimkmk4g1', 1, '1614790751', 0, '', 0)
    Explain
    EXPLAIN non possibile sulla query: INSERT INTO `i9hrp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('6e0hida285jbev4acpimkmk4g1', 1, '1614790751', 0, '', 0)
    Profilo
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    update0.06 ms
    Waiting for query cache lock0.00 ms
    update0.03 ms
    end0.00 ms
    query end0.04 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    7JDatabaseDriverMysqli->execute()JROOT/libraries/cms/application/cms.php:216
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:827
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:412
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  5. Tempo della query: 1.32 ms Dopo l'ultima query: 25.71 ms Memoria query: 0.019 MB memoria prima della query: 3.608 MB Righe restituite: 39
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `i9hrp_extensions`
      WHERE `type` = 'component'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_extensionsNULLrefextensionextension82const39100.00NULL
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.09 ms
    starting0.01 ms
    checking query cache for query0.08 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.31 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.04 ms
    Waiting for query cache lock23.70 ms
    Waiting on query cache mutex0.01 ms
    freeing items0.00 ms
    storing result in query cache0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    10JDatabaseDriver->loadObjectList()JROOT/libraries/cms/component/helper.php:452
    9JComponentHelper::{closure}()Chiamata uguale alla linea sottostante.
    8call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:169
    7JCacheControllerCallback->get()JROOT/libraries/cms/component/helper.php:460
    6JComponentHelper::load()JROOT/libraries/cms/component/helper.php:43
    5JComponentHelper::getComponent()JROOT/libraries/cms/component/helper.php:111
    4JComponentHelper::getParams()JROOT/libraries/cms/application/site.php:593
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  6. Tempo della query: 4.75 ms Dopo l'ultima query: 18.88 ms Memoria query: 0.015 MB memoria prima della query: 3.889 MB Righe restituite: 2
    SELECT b.id
    
      FROM i9hrp_usergroups AS a
      LEFT JOIN i9hrp_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbNULLrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2100.00Using where; Using index
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.01 ms
    starting0.01 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    sending cached result to clien0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1530
    10JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:978
    9JAccess::getGroupsByUser()JROOT/libraries/joomla/access/access.php:1047
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:453
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:293
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:603
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  7. Tempo della query: 0.38 ms Dopo l'ultima query: 3.13 ms Memoria query: 0.014 MB memoria prima della query: 3.966 MB Righe restituite: 5
    SELECT id, rules
    
      FROM `i9hrp_viewlevels`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_viewlevelsNULLALLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL5100.00NULL
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.03 ms
    starting0.01 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.01 ms
    checking permissions0.01 ms
    sending cached result to clien0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1486
    9JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:1064
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:453
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:293
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:603
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  8. Tempo della query: 1.95 ms Dopo l'ultima query: 3.26 ms Memoria query: 0.020 MB memoria prima della query: 4.009 MB Righe restituite: 84
    SELECT `folder` AS `type`,`element` AS `name`,`params`
    
      FROM i9hrp_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_extensionsNULLrefextensionextension82const990.60Using index condition; Using where; Using filesort
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.02 ms
    Waiting on query cache mutex0.00 ms
    starting0.02 ms
    checking query cache for query0.09 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.04 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.04 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.04 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.91 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.05 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    10JDatabaseDriver->loadObjectList()JROOT/libraries/cms/plugin/helper.php:311
    9JPluginHelper::{closure}()Chiamata uguale alla linea sottostante.
    8call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:169
    7JCacheControllerCallback->get()JROOT/libraries/cms/plugin/helper.php:316
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:603
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  9. Tempo della query: 3.86 ms Dopo l'ultima query: 191.45 ms Memoria query: 0.043 MB memoria prima della query: 6.245 MB Righe restituite: 99
    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 i9hrp_menu AS m
      LEFT JOIN i9hrp_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
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_client_id_parent_id_alias_languageNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1456.97Using where; Using filesort
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4Sql1464388_2.m.component_id1100.00Using where
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.10 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.05 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.06 ms
    optimizing0.02 ms
    statistics0.10 ms
    preparing0.03 ms
    Sorting result0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.52 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    Creating sort index0.28 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    Creating sort index0.30 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    Creating sort index0.62 ms
    Waiting for query cache lock0.02 ms
    Waiting on query cache mutex0.00 ms
    Creating sort index0.39 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    Creating sort index0.28 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    Creating sort index0.26 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.05 ms
    freeing items0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.06 ms
    freeing items0.03 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    18JDatabaseDriver->loadObjectList()JROOT/libraries/cms/menu/site.php:88
    17JMenuSite->{closure}()Chiamata uguale alla linea sottostante.
    16call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:169
    15JCacheControllerCallback->get()JROOT/libraries/cms/menu/site.php:96
    14JMenuSite->load()JROOT/libraries/cms/menu/menu.php:74
    13JMenu->__construct()JROOT/libraries/cms/menu/site.php:57
    12JMenuSite->__construct()JROOT/libraries/cms/menu/menu.php:129
    11JMenu::getInstance()JROOT/libraries/cms/application/cms.php:443
    10JApplicationCms->getMenu()JROOT/libraries/cms/application/site.php:272
    9JApplicationSite->getMenu()JROOT/libraries/cms/router/site.php:59
    8JRouterSite->__construct()JROOT/libraries/cms/router/router.php:198
    7JRouter::getInstance()JROOT/libraries/cms/application/cms.php:548
    6JApplicationCms::getRouter()JROOT/libraries/cms/application/site.php:402
    5JApplicationSite::getRouter()JROOT/libraries/cms/application/cms.php:1141
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:795
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  10. Tempo della query: 0.90 ms Dopo l'ultima query: 83.79 ms Memoria query: 0.025 MB memoria prima della query: 7.629 MB Righe restituite: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `i9hrp_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.03 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.02 ms
    System lock0.03 ms
    optimizing0.02 ms
    statistics0.15 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.08 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile e numero di linea
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1642
    19JDatabaseDriver->loadObject()JROOT/libraries/cms/library/helper.php:166
    18JLibraryHelper::{closure}()Chiamata uguale alla linea sottostante.
    17call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:169
    16JCacheControllerCallback->get()JROOT/libraries/cms/library/helper.php:174
    15JLibraryHelper::loadLibrary()JROOT/libraries/cms/library/helper.php:42
    14JLibraryHelper::getLibrary()JROOT/libraries/cms/library/helper.php:89
    13JLibraryHelper::getParams()JROOT/libraries/cms/version/version.php:270
    12JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    11JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    10JFactory::getDocument()JROOT/plugins/system/jqueryeasy/jqueryeasy.php:53
    9plgSystemJqueryeasy->onAfterRoute()Chiamata uguale alla linea sottostante.
    8call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1151
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:795
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  11. Tempo della query: 0.97 ms Dopo l'ultima query: 1.97 ms Memoria query: 0.018 MB memoria prima della query: 7.635 MB
    UPDATE `i9hrp_extensions`
    
      SET `params` = '{\"mediaversion\":\"a4ebb218d63b66203405dd1837433d76\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEi9hrp_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profilo
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.13 ms
    updating0.08 ms
    end0.01 ms
    Waiting for query cache lock0.00 ms
    end0.19 ms
    query end0.06 ms
    closing tables0.04 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    15JDatabaseDriverMysqli->execute()JROOT/libraries/cms/library/helper.php:116
    14JLibraryHelper::saveParams()JROOT/libraries/cms/version/version.php:321
    13JVersion->setMediaVersion()JROOT/libraries/cms/version/version.php:280
    12JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    11JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    10JFactory::getDocument()JROOT/plugins/system/jqueryeasy/jqueryeasy.php:53
    9plgSystemJqueryeasy->onAfterRoute()Chiamata uguale alla linea sottostante.
    8call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1151
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:795
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  12. Tempo della query: 0.74 ms Dopo l'ultima query: 10.66 ms Memoria query: 0.014 MB memoria prima della query: 7.909 MB Righe restituite: 2
    SELECT *
    
      FROM i9hrp_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_languagesNULLALLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL250.00Using where; Using filesort
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 ms
    starting0.01 ms
    checking query cache for query0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    Creating sort index0.09 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.04 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile e numero di linea
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    6JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/language/helper.php:148
    5JLanguageHelper::getLanguages()JROOT/libraries/cms/application/site.php:327
    4JApplicationSite->getParams()JROOT/libraries/cms/application/site.php:135
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  13. Tempo della query: 1.20 ms Dopo l'ultima query: 5.17 ms Memoria query: 0.010 MB memoria prima della query: 7.941 MB Righe restituite: 6
    SELECT id, home, template, s.params
    
      FROM i9hrp_template_styles as s
      LEFT JOIN i9hrp_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
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLALLidx_templateNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL812.50Using where
    1SIMPLEeNULLrefelement_clientid,element_folder_clientid,extensionelement_clientid403Sql1464388_2.s.template,const14.60Using index condition; Using where
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.09 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    init0.04 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.04 ms
    optimizing0.02 ms
    statistics0.12 ms
    preparing0.04 ms
    executing0.01 ms
    Sending data0.25 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.17 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    5JDatabaseDriver->loadObjectList()JROOT/libraries/cms/application/site.php:485
    4JApplicationSite->getTemplate()JROOT/libraries/cms/application/site.php:165
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  14. Tempo della query: 0.57 ms Dopo l'ultima query: 37.11 ms Memoria query: 0.026 MB memoria prima della query: 8.537 MB Righe restituite: 39
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `i9hrp_assets`
      WHERE `name` IN ('com_accesskeys','com_admin','com_ajax','com_akeeba','com_albopretorio','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contentmap','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_oziogallery3','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR `parent_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_assetsNULLindex_mergeidx_asset_name,idx_parent_ididx_asset_name,idx_parent_id202,4NULL40100.00Using sort_union(idx_asset_name,idx_parent_id); Using where
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.02 ms
    Waiting on query cache mutex0.01 ms
    starting0.01 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.02 ms
    checking permissions0.01 ms
    sending cached result to clien0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    17JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/access/access.php:427
    16JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:211
    15JAccess::preload()JROOT/libraries/joomla/access/access.php:529
    14JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    13JAccess::check()JROOT/libraries/joomla/user/user.php:393
    12JUser->authorise()JROOT/components/com_content/models/article.php:55
    11ContentModelArticle->populateState()JROOT/libraries/legacy/model/legacy.php:434
    10JModelLegacy->getState()JROOT/components/com_content/models/article.php:248
    9ContentModelArticle->hit()JROOT/components/com_content/controller.php:109
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  15. Tempo della query: 1.66 ms Dopo l'ultima query: 11.57 ms Memoria query: 0.025 MB memoria prima della query: 8.743 MB Righe restituite: 30
    SHOW FULL COLUMNS 
      FROM `i9hrp_content`
    Explain
    EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `i9hrp_content`
    Profilo
    StatusDuration
    starting0.06 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.24 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.02 ms
    Opening tables0.02 ms
    checking permissions0.05 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.04 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.03 ms
    checking permissions0.02 ms
    checking permissions0.03 ms
    checking permissions0.03 ms
    Sending data0.18 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.06 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    15JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    14JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:244
    13JTable->getFields()JROOT/libraries/joomla/table/table.php:163
    12JTable->__construct()JROOT/libraries/legacy/table/content.php:33
    11JTableContent->__construct()JROOT/libraries/joomla/table/table.php:311
    10JTable::getInstance()JROOT/components/com_content/models/article.php:250
    9ContentModelArticle->hit()JROOT/components/com_content/controller.php:109
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  16. Tempo della query: 0.95 ms Dopo l'ultima query: 29.35 ms Memoria query: 0.024 MB memoria prima della query: 9.117 MB Righe restituite: 1
    SELECT *
    
      FROM i9hrp_content
      WHERE `id` = '18'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_contentNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.06 ms
    checking permissions0.03 ms
    Opening tables0.02 ms
    init0.06 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.01 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.03 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.01 ms
    freeing items0.04 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.13 ms
    cleaning up0.04 ms
    Call Stack
    #CallerFile e numero di linea
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    11JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    10JTable->load()JROOT/components/com_content/models/article.php:251
    9ContentModelArticle->hit()JROOT/components/com_content/controller.php:109
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  17. Tempo della query: 1.22 ms Dopo l'ultima query: 0.47 ms Memoria query: 0.014 MB memoria prima della query: 9.132 MB
    UPDATE i9hrp_content
    
      SET `hits` = (`hits` + 1)
      WHERE `id` = '18'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEi9hrp_contentNULLrangePRIMARYPRIMARY4const1100.00Using where
    Profilo
    StatusDuration
    starting0.05 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.06 ms
    updating0.11 ms
    end0.01 ms
    Waiting for query cache lock0.01 ms
    end0.45 ms
    query end0.06 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/table/table.php:1240
    10JTable->hit()JROOT/components/com_content/models/article.php:252
    9ContentModelArticle->hit()JROOT/components/com_content/controller.php:109
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  18. Tempo della query: 1.62 ms Dopo l'ultima query: 27.37 ms Memoria query: 0.029 MB memoria prima della query: 9.376 MB Righe restituite: 1
    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM i9hrp_content AS a
      INNER JOIN i9hrp_categories AS c
      on c.id = a.catid
      LEFT JOIN i9hrp_users AS u
      on u.id = a.created_by
      LEFT JOIN i9hrp_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN i9hrp_content_rating AS v
      ON a.id = v.content_id
      WHERE a.id = 18
      AND c.published > 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-03 16:59:11')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-03 16:59:11')
      AND (a.state = 1 OR a.state =2)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARY,idx_state,idx_catidPRIMARY4const1100.00NULL
    1SIMPLEcNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEuNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEparentNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEvNULLconstPRIMARYPRIMARY4const00.00unique row not found
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    starting0.02 ms
    checking query cache for query0.29 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.17 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.09 ms
    optimizing0.03 ms
    statistics0.18 ms
    preparing0.03 ms
    executing0.00 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.05 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1642
    14JDatabaseDriver->loadObject()JROOT/components/com_content/models/article.php:148
    13ContentModelArticle->getItem()JROOT/libraries/legacy/view/legacy.php:422
    12JViewLegacy->get()JROOT/components/com_content/views/article/view.html.php:42
    11ContentViewArticle->display()JROOT/libraries/joomla/cache/controller/view.php:98
    10JCacheControllerView->get()JROOT/libraries/legacy/controller/legacy.php:662
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  19. Tempo della query: 1.79 ms Dopo l'ultima query: 18.86 ms Memoria query: 0.037 MB memoria prima della query: 9.671 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 i9hrp_categories as c
      LEFT JOIN i9hrp_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,5)
      AND c.published = 1
      AND s.id=36
      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
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Using filesort
    1SIMPLEcNULLALLcat_idx,idx_access,idx_left_rightNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL11045.96Using where
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    starting0.03 ms
    checking query cache for query0.23 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.16 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.05 ms
    optimizing0.03 ms
    statistics0.23 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.02 ms
    Sending data0.04 ms
    Creating sort index0.36 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.03 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.14 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    23JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:301
    22JCategories->_load()JROOT/libraries/legacy/categories/categories.php:182
    21JCategories->get()JROOT/components/com_content/router.php:70
    20ContentRouter->getCategorySegment()Chiamata uguale alla linea sottostante.
    19call_user_func_array()JROOT/libraries/cms/component/router/view.php:117
    18JComponentRouterView->getPath()JROOT/libraries/cms/component/router/rules/menu.php:82
    17JComponentRouterRulesMenu->preprocess()JROOT/libraries/cms/component/router/view.php:219
    16JComponentRouterView->preprocess()JROOT/libraries/cms/router/site.php:660
    15JRouterSite->processBuildRules()JROOT/libraries/cms/router/router.php:267
    14JRouter->build()JROOT/libraries/cms/router/site.php:149
    13JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    12JRoute::_()JROOT/components/com_content/views/article/view.html.php:71
    11ContentViewArticle->display()JROOT/libraries/joomla/cache/controller/view.php:98
    10JCacheControllerView->get()JROOT/libraries/legacy/controller/legacy.php:662
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  20. Tempo della query: 1.00 ms Dopo l'ultima query: 1.45 ms Memoria query: 0.026 MB memoria prima della query: 9.736 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `i9hrp_contentitem_tag_map` AS m
      INNER JOIN `i9hrp_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 18
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL250.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4Sql1464388_2.m.tag_id1100.00Using where
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 ms
    starting0.01 ms
    checking query cache for query0.08 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.07 ms
    System lock0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.03 ms
    optimizing0.03 ms
    statistics0.10 ms
    preparing0.03 ms
    executing0.00 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.05 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.03 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    13JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    12JHelperTags->getItemTags()JROOT/components/com_content/views/article/view.html.php:180
    11ContentViewArticle->display()JROOT/libraries/joomla/cache/controller/view.php:98
    10JCacheControllerView->get()JROOT/libraries/legacy/controller/legacy.php:662
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  21. Tempo della query: 2.04 ms Dopo l'ultima query: 70.18 ms Memoria query: 0.033 MB memoria prima della query: 10.867 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 i9hrp_fields AS a
      LEFT JOIN `i9hrp_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN i9hrp_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN i9hrp_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN i9hrp_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN i9hrp_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `i9hrp_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (36,0,10))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
      ORDER BY a.ordering DESC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_contextidx_state1const1100.00Using index condition; Using where; Using temporary; Using filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28Sql1464388_2.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4Sql1464388_2.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4Sql1464388_2.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4Sql1464388_2.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4Sql1464388_2.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4Sql1464388_2.a.id1100.00Using where; Using index
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    starting0.02 ms
    checking query cache for query0.22 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    init0.13 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    System lock0.06 ms
    optimizing0.03 ms
    statistics0.15 ms
    preparing0.06 ms
    Creating tmp table0.14 ms
    Sorting result0.02 ms
    executing0.01 ms
    Sending data0.29 ms
    Creating sort index0.06 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.06 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 ms
    freeing items0.11 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.08 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    20JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:307
    19JModelLegacy->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    18FieldsModelFields->_getList()JROOT/libraries/legacy/model/list.php:186
    17JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    16FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    15PlgSystemFields->onContentPrepare()Chiamata uguale alla linea sottostante.
    14call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/article/view.html.php:190
    11ContentViewArticle->display()JROOT/libraries/joomla/cache/controller/view.php:98
    10JCacheControllerView->get()JROOT/libraries/legacy/controller/legacy.php:662
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  22. Tempo della query: 1.10 ms Dopo l'ultima query: 384.62 ms Memoria query: 0.024 MB memoria prima della query: 13.787 MB Righe restituite: 1
    SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid
    
      FROM `i9hrp_contact_details` AS `contact`
      WHERE contact.published = 1
      AND contact.user_id = 455
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcontactNULLrefidx_stateidx_state1const110.00Using where
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.02 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.07 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.05 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.03 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.04 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.06 ms
    freeing items0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.21 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.01 ms
    freeing items0.01 ms
    storing result in query cache0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1642
    17JDatabaseDriver->loadObject()JROOT/plugins/content/contact/contact.php:108
    16PlgContentContact->getContactId()JROOT/plugins/content/contact/contact.php:60
    15PlgContentContact->onContentPrepare()Chiamata uguale alla linea sottostante.
    14call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/article/view.html.php:190
    11ContentViewArticle->display()JROOT/libraries/joomla/cache/controller/view.php:98
    10JCacheControllerView->get()JROOT/libraries/legacy/controller/legacy.php:662
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  23. Tempo della query: 0.36 ms Dopo l'ultima query: 2.30 ms Memoria query: 0.032 MB memoria prima della query: 13.822 MB Righe restituite: 0
    SELECT `alias`
    
      FROM `i9hrp_contact_details`
      WHERE id = '0'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULLNULLNULLno matching row in const table
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.03 ms
    sending cached result to clien0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    26JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    25JDatabaseDriver->loadResult()JROOT/components/com_contact/router.php:121
    24ContactRouter->getContactSegment()Chiamata uguale alla linea sottostante.
    23call_user_func_array()JROOT/libraries/cms/component/router/view.php:117
    22JComponentRouterView->getPath()JROOT/libraries/cms/component/router/rules/menu.php:82
    21JComponentRouterRulesMenu->preprocess()JROOT/libraries/cms/component/router/view.php:219
    20JComponentRouterView->preprocess()JROOT/libraries/cms/router/site.php:660
    19JRouterSite->processBuildRules()JROOT/libraries/cms/router/router.php:267
    18JRouter->build()JROOT/libraries/cms/router/site.php:149
    17JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    16JRoute::_()JROOT/plugins/content/contact/contact.php:66
    15PlgContentContact->onContentPrepare()Chiamata uguale alla linea sottostante.
    14call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/article/view.html.php:190
    11ContentViewArticle->display()JROOT/libraries/joomla/cache/controller/view.php:98
    10JCacheControllerView->get()JROOT/libraries/legacy/controller/legacy.php:662
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  24. Tempo della query: 0.49 ms Dopo l'ultima query: 2.12 ms Memoria query: 0.041 MB memoria prima della query: 13.868 MB Righe restituite: 5
    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 i9hrp_categories as c
      WHERE (c.extension='com_contact' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      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
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLrangecat_idx,idx_accesscat_idx207NULL7100.00Using index condition; Using filesort
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.02 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.01 ms
    sending cached result to clien0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    27JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:301
    26JCategories->_load()JROOT/libraries/legacy/categories/categories.php:182
    25JCategories->get()JROOT/components/com_contact/router.php:68
    24ContactRouter->getCategorySegment()Chiamata uguale alla linea sottostante.
    23call_user_func_array()JROOT/libraries/cms/component/router/view.php:121
    22JComponentRouterView->getPath()JROOT/libraries/cms/component/router/rules/menu.php:82
    21JComponentRouterRulesMenu->preprocess()JROOT/libraries/cms/component/router/view.php:219
    20JComponentRouterView->preprocess()JROOT/libraries/cms/router/site.php:660
    19JRouterSite->processBuildRules()JROOT/libraries/cms/router/router.php:267
    18JRouter->build()JROOT/libraries/cms/router/site.php:149
    17JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    16JRoute::_()JROOT/plugins/content/contact/contact.php:66
    15PlgContentContact->onContentPrepare()Chiamata uguale alla linea sottostante.
    14call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/article/view.html.php:190
    11ContentViewArticle->display()JROOT/libraries/joomla/cache/controller/view.php:98
    10JCacheControllerView->get()JROOT/libraries/legacy/controller/legacy.php:662
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  25. Tempo della query: 0.84 ms Dopo l'ultima query: 44.08 ms Memoria query: 0.024 MB memoria prima della query: 14.891 MB Righe restituite: 1
    SELECT created_by, catid
    
      FROM i9hrp_content
      WHERE id = 18
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_contentNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 ms
    System lock0.04 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 ms
    freeing items0.09 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    17JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    16AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:312
    15plgContentAttachments->onContentBeforeDisplay()Chiamata uguale alla linea sottostante.
    14call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/article/view.html.php:196
    11ContentViewArticle->display()JROOT/libraries/joomla/cache/controller/view.php:98
    10JCacheControllerView->get()JROOT/libraries/legacy/controller/legacy.php:662
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  26. Tempo della query: 2.17 ms Dopo l'ultima query: 2.90 ms Memoria query: 0.066 MB memoria prima della query: 14.941 MB Righe restituite: 887
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `i9hrp_assets`
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_assetsNULLALLidx_asset_name,idx_parent_idNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL99220.94Using where
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.01 ms
    sending cached result to clien1.34 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    24JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/access/access.php:357
    23JAccess::preloadPermissions()JROOT/libraries/joomla/access/access.php:224
    22JAccess::preload()JROOT/libraries/joomla/access/access.php:538
    21JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    20JAccess::check()JROOT/libraries/joomla/user/user.php:393
    19JUser->authorise()JROOT/administrator/components/com_attachments/permissions.php:125
    18AttachmentsPermissions::userMayEditArticle()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:884
    17AttachmentsPlugin_Com_Content->userMayAddAttachment()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:862
    16AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:318
    15plgContentAttachments->onContentBeforeDisplay()Chiamata uguale alla linea sottostante.
    14call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/article/view.html.php:196
    11ContentViewArticle->display()JROOT/libraries/joomla/cache/controller/view.php:98
    10JCacheControllerView->get()JROOT/libraries/legacy/controller/legacy.php:662
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  27. Tempo della query: 3.40 ms Dopo l'ultima query: 16.48 ms Memoria query: 0.033 MB memoria prima della query: 16.435 MB Righe restituite: 0
    SELECT a.*, u.name as creator_name
    
      FROM i9hrp_attachments AS a
      LEFT JOIN i9hrp_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=18
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      ORDER BY created DESC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLALLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL15870.06Using where; Using filesort
    1SIMPLEuNULLeq_refPRIMARYPRIMARY4Sql1464388_2.a.created_by1100.00NULL
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.02 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.09 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.07 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.03 ms
    optimizing0.03 ms
    statistics0.04 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    Creating sort index2.16 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.20 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.01 ms
    storing result in query cache0.01 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    20JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    19AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    18AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    17AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    16AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:318
    15plgContentAttachments->onContentBeforeDisplay()Chiamata uguale alla linea sottostante.
    14call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/article/view.html.php:196
    11ContentViewArticle->display()JROOT/libraries/joomla/cache/controller/view.php:98
    10JCacheControllerView->get()JROOT/libraries/legacy/controller/legacy.php:662
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:709
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:39
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:394
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:369
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:265
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  28. Tempo della query: 2.95 ms Dopo l'ultima query: 69.08 ms Memoria query: 0.022 MB memoria prima della query: 16.886 MB Righe restituite: 12
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM i9hrp_modules AS m
      LEFT JOIN i9hrp_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN i9hrp_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 <= '2021-03-03 16:59:11')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-03 16:59:11')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 114 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLPRIMARY,published,newsfeedsNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL472.13Using where; Using filesort
    1SIMPLEeNULLrefelement_clientid,element_folder_clientidelement_clientid403Sql1464388_2.m.module,const110.00Using index condition; Using where
    1SIMPLEmmNULLrefPRIMARYPRIMARY4Sql1464388_2.m.id540.00Using where; Using index
    Profilo
    StatusDuration
    starting0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.17 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.09 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.06 ms
    optimizing0.04 ms
    statistics0.15 ms
    preparing0.05 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.02 ms
    Creating sort index1.70 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.05 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 ms
    freeing items0.00 ms
    storing result in query cache0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    14JDatabaseDriver->loadObjectList()Chiamata uguale alla linea sottostante.
    13call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:169
    12JCacheControllerCallback->get()JROOT/libraries/cms/module/helper.php:424
    11JModuleHelper::getModuleList()JROOT/libraries/cms/module/helper.php:360
    10JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
    9JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:576
    8JDocumentHtml->countModules()JROOT/templates/copia_protostar/index.php:108
    7require JROOT/templates/copia_protostar/index.phpJROOT/libraries/joomla/document/html.php:653
    6JDocumentHtml->_loadTemplate()JROOT/libraries/joomla/document/html.php:715
    5JDocumentHtml->_fetchTemplate()JROOT/libraries/joomla/document/html.php:530
    4JDocumentHtml->parse()JROOT/libraries/cms/application/cms.php:1098
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:777
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:271
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  29. Tempo della query: 0.57 ms Dopo l'ultima query: 242.90 ms Memoria query: 0.028 MB memoria prima della query: 17.732 MB Righe restituite: 1
    SELECT `alias`
    
      FROM `i9hrp_content`
      WHERE id = '18'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_contentNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.00 ms
    checking query cache for query0.02 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.00 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.02 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.00 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile e numero di linea
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    21JDatabaseDriver->loadResult()JROOT/components/com_content/router.php:123
    20ContentRouter->getArticleSegment()Chiamata uguale alla linea sottostante.
    19call_user_func_array()JROOT/libraries/cms/component/router/view.php:117
    18JComponentRouterView->getPath()JROOT/libraries/cms/component/router/rules/menu.php:82
    17JComponentRouterRulesMenu->preprocess()JROOT/libraries/cms/component/router/view.php:219
    16JComponentRouterView->preprocess()JROOT/libraries/cms/router/site.php:660
    15JRouterSite->processBuildRules()JROOT/libraries/cms/router/router.php:267
    14JRouter->build()JROOT/libraries/cms/router/site.php:149
    13JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    12JRoute::_()JROOT/modules/mod_breadcrumbs/helper.php:56
    11ModBreadCrumbsHelper::getList()JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
    10include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.phpJROOT/libraries/cms/module/helper.php:198
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:486
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:777
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:552
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1112
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:777
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:271
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  30. Tempo della query: 1.23 ms Dopo l'ultima query: 0.52 ms Memoria query: 0.037 MB memoria prima della query: 17.764 MB Righe restituite: 5
    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 i9hrp_categories as c
      LEFT JOIN i9hrp_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,5)
      AND c.published = 1
      AND s.id=18
      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
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Using filesort
    1SIMPLEcNULLALLcat_idx,idx_access,idx_left_rightNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL11045.96Using where
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.19 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.08 ms
    System lock0.00 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.13 ms
    preparing0.02 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.26 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.06 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile e numero di linea
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    23JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:301
    22JCategories->_load()JROOT/libraries/legacy/categories/categories.php:182
    21JCategories->get()JROOT/components/com_content/router.php:70
    20ContentRouter->getCategorySegment()Chiamata uguale alla linea sottostante.
    19call_user_func_array()JROOT/libraries/cms/component/router/view.php:121
    18JComponentRouterView->getPath()JROOT/libraries/cms/component/router/rules/menu.php:82
    17JComponentRouterRulesMenu->preprocess()JROOT/libraries/cms/component/router/view.php:219
    16JComponentRouterView->preprocess()JROOT/libraries/cms/router/site.php:660
    15JRouterSite->processBuildRules()JROOT/libraries/cms/router/router.php:267
    14JRouter->build()JROOT/libraries/cms/router/site.php:149
    13JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    12JRoute::_()JROOT/modules/mod_breadcrumbs/helper.php:56
    11ModBreadCrumbsHelper::getList()JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
    10include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.phpJROOT/libraries/cms/module/helper.php:198
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:486
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:777
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:552
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1112
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:777
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:271
    1JApplicationCms->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

27 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:
  1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `i9hrp_extensions`
  2. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `i9hrp_assets`
  3. 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 i9hrp_categories as c
      LEFT JOIN i9hrp_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
  4. 1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid 
      FROM `i9hrp_contact_details` AS `contact`
  5. 1 × 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 i9hrp_fields AS a
      LEFT JOIN `i9hrp_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN i9hrp_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN i9hrp_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN i9hrp_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN i9hrp_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `i9hrp_fields_categories` AS fc
      ON fc.field_id = a.id
  6. 1 × SELECT `m`.`tag_id`,`t`.* 
      FROM `i9hrp_contentitem_tag_map` AS m
      INNER JOIN `i9hrp_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  7. 1 × SELECT `alias` 
      FROM `i9hrp_contact_details`
  8. 1 × SELECT created_by, catid 
      FROM i9hrp_content
  9. 1 × SELECT `alias` 
      FROM `i9hrp_content`
  10. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM i9hrp_modules AS m
      LEFT JOIN i9hrp_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN i9hrp_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  11. 1 × SELECT a.*, u.name as creator_name 
      FROM i9hrp_attachments AS a
      LEFT JOIN i9hrp_users AS u
      ON u.id = a.created_by
  12. 1 × 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 i9hrp_categories as c
  13. 1 × SELECT * 
      FROM i9hrp_content
  14. 1 × SELECT id, rules 
      FROM `i9hrp_viewlevels
  15. 1 × SELECT b.id 
      FROM i9hrp_usergroups AS a
      LEFT JOIN i9hrp_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  16. 1 × SELECT `session_id` 
      FROM `i9hrp_session`
  17. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
      FROM i9hrp_extensions
  18. 1 × 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 i9hrp_menu AS m
      LEFT JOIN i9hrp_extensions AS e
      ON m.component_id = e.extension_id
  19. 1 × SELECT `data` 
      FROM `i9hrp_session`
  20. 1 × SELECT id, home, template, s.params 
      FROM i9hrp_template_styles as s
      LEFT JOIN i9hrp_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  21. 1 × SELECT * 
      FROM i9hrp_languages
  22. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM i9hrp_content AS a
      INNER JOIN i9hrp_categories AS c
      on c.id = a.catid
      LEFT JOIN i9hrp_users AS u
      on u.id = a.created_by
      LEFT JOIN i9hrp_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN i9hrp_content_rating AS v
      ON a.id = v.content_id
ALTRE tabelle:
  1. 1 × UPDATE i9hrp_content 
      SET `hits` = (`hits` + 1)
  2. 1 × SHOW FULL COLUMNS 
      FROM `i9hrp_content
  3. 1 × UPDATE `i9hrp_extensions` 
      SET `params` = '{\"mediaversion\":\"a4ebb218d63b66203405dd1837433d76\"}'
  4. 1 × INSERT INTO `i9hrp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('6e0hida285jbev4acpimkmk4g1', 1, '1614790751', 0, '', 0
  5. 1 × DELETE  
      FROM `i9hrp_session`