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 |
  • DIDATTICA ONLINE |
  • SCUOLA PRIMARIA ONLINE |
  • TERZE ONLINE

TERZE ONLINE

Filtri
Lista degli articoli nella categoria TERZE ONLINE
Titolo Data pubblicazione Autore
Portali primaria 3 Lun Mar 2020 Scritto da Domenico Cozzolino
Link primaria 3 Lun Mar 2020 Scritto da Domenico Cozzolino
Lezioni primaria 3 Lun Mar 2020 Scritto da Domenico Cozzolino

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": 1614793881,
                "last": 1614793881,
                "now": 1614793881
            },
            "token": "KHD0O5cVWPSWgLhqQJQyTGFqFRMz9lmq"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuaWMyOGFsaW90dGEuZWR1Lml0L2luZGV4LnBocC9kaWRhdHRpY2Etb25saW5lL3NjdW9sYS1wcmltYXJpYS1kaXBhcnRpbWVudG8tbGluZ3VlL3RlcnplLW9ubGluZT8%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
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 139.43 ms / 139.43 ms Memoria: 0.740 MB / 0.96 MB Application: afterLoad
Tempo: 303.86 ms / 443.30 ms Memoria: 4.990 MB / 5.95 MB Application: afterInitialise
Tempo: 128.26 ms / 571.55 ms Memoria: 1.859 MB / 7.81 MB Application: afterRoute
Tempo: 12.40 ms / 583.96 ms Memoria: 0.057 MB / 7.87 MB Application: beforeRenderComponent com_content
Tempo: 64.54 ms / 648.49 ms Memoria: 0.998 MB / 8.87 MB Application: Before JAccess::preloadComponents (all components)
Tempo: 1.56 ms / 650.06 ms Memoria: 0.099 MB / 8.97 MB Application: After JAccess::preloadComponents (all components)
Tempo: 0.08 ms / 650.13 ms Memoria: 0.000 MB / 8.96 MB Application: Before JAccess::preloadPermissions (com_content)
Tempo: 6.14 ms / 656.28 ms Memoria: 1.457 MB / 10.42 MB Application: After JAccess::preloadPermissions (com_content)
Tempo: 0.29 ms / 656.56 ms Memoria: 0.000 MB / 10.34 MB Application: Before JAccess::getAssetRules (id:1064 name:com_content.category.165)
Tempo: 4.78 ms / 661.34 ms Memoria: 0.046 MB / 10.38 MB Application: After JAccess::getAssetRules (id:1064 name:com_content.category.165)
Tempo: 16.45 ms / 677.80 ms Memoria: 0.365 MB / 10.75 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)
Tempo: 0.04 ms / 677.83 ms Memoria: 0.003 MB / 10.75 MB Application: After JAccess::getAssetRules (id:8 name:com_content)
Tempo: 110.08 ms / 787.92 ms Memoria: 1.598 MB / 12.35 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)
Tempo: 0.20 ms / 788.12 ms Memoria: 0.013 MB / 12.36 MB Application: After JAccess::getAssetRules (id:1 name:root.1)
Tempo: 562.13 ms / 1350.25 ms Memoria: 4.211 MB / 16.57 MB Application: Before JAccess::getAssetRules (id:1063 name:com_content.article.721)
Tempo: 0.17 ms / 1350.42 ms Memoria: 0.014 MB / 16.59 MB Application: After JAccess::getAssetRules (id:1063 name:com_content.article.721)
Tempo: 14.42 ms / 1364.84 ms Memoria: 0.151 MB / 16.74 MB Application: Before JAccess::getAssetRules (id:98 name:com_attachments)
Tempo: 0.17 ms / 1365.01 ms Memoria: 0.014 MB / 16.75 MB Application: After JAccess::getAssetRules (id:98 name:com_attachments)
Tempo: 19.36 ms / 1384.37 ms Memoria: 0.070 MB / 16.82 MB Application: Before JAccess::getAssetRules (id:1062 name:com_content.article.720)
Tempo: 0.05 ms / 1384.42 ms Memoria: 0.003 MB / 16.83 MB Application: After JAccess::getAssetRules (id:1062 name:com_content.article.720)
Tempo: 20.67 ms / 1405.09 ms Memoria: 0.075 MB / 16.90 MB Application: Before JAccess::getAssetRules (id:1061 name:com_content.article.719)
Tempo: 0.07 ms / 1405.15 ms Memoria: 0.003 MB / 16.90 MB Application: After JAccess::getAssetRules (id:1061 name:com_content.article.719)
Tempo: 125.36 ms / 1530.51 ms Memoria: 1.304 MB / 18.21 MB Application: Before JAccess::getAssetRules (id:417 name:com_content.article.165)
Tempo: 0.09 ms / 1530.61 ms Memoria: 0.003 MB / 18.21 MB Application: After JAccess::getAssetRules (id:417 name:com_content.article.165)
Tempo: 55.10 ms / 1585.71 ms Memoria: 0.445 MB / 18.66 MB Application: afterRenderComponent com_content
Tempo: 2.68 ms / 1588.39 ms Memoria: 0.007 MB / 18.66 MB Application: afterDispatch
Tempo: 42.78 ms / 1631.17 ms Memoria: 0.264 MB / 18.93 MB Application: beforeRenderModule mod_menu (foot2)
Tempo: 39.79 ms / 1670.97 ms Memoria: 0.188 MB / 19.12 MB Application: afterRenderModule mod_menu (foot2)
Tempo: 1.68 ms / 1672.65 ms Memoria: 0.000 MB / 19.08 MB Application: beforeRenderModule mod_breadcrumbs (Percorso)
Tempo: 11.50 ms / 1684.15 ms Memoria: 0.039 MB / 19.12 MB Application: afterRenderModule mod_breadcrumbs (Percorso)
Tempo: 4.13 ms / 1688.28 ms Memoria: 0.016 MB / 19.14 MB Application: beforeRenderModule mod_menu (Menu Principale)
Tempo: 113.28 ms / 1801.57 ms Memoria: 0.840 MB / 19.98 MB Application: afterRenderModule mod_menu (Menu Principale)
Tempo: 21.73 ms / 1823.30 ms Memoria: 0.109 MB / 20.09 MB Application: afterRender

Query totali del database: 75.08 ms

Utilizzo memoria

21,26 MB (22.287.520 Bytes)

Query Database

54 query eseguite 75.08 ms


Trovati 12 duplicati!

12 duplicati: #32  #33  #34  #35  #36  #37  #38  #39  #40  #41  #49  #50
  1. Tempo della query: 0.65 ms Memoria query: 0.008 MB memoria prima della query: 3.043 MB
    DELETE 
    
      FROM `i9hrp_session`
      WHERE `time` < '1614792981'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1DELETEi9hrp_sessionNULLrangetimetime59const1100.00Using where
    Profilo
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.02 ms
    System lock0.08 ms
    updating0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 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: 0.78 ms Dopo l'ultima query: 3.22 ms Memoria query: 0.020 MB memoria prima della query: 3.074 MB Righe restituite: 0
    SELECT `data`
    
      FROM `i9hrp_session`
      WHERE `session_id` = 'ptsqf4djeq88c36geho49puo21'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_sessionNULLconstPRIMARYPRIMARY766const1100.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.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.04 ms
    executing0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.13 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
    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.61 ms Dopo l'ultima query: 9.95 ms Memoria query: 0.012 MB memoria prima della query: 3.216 MB Righe restituite: 0
    SELECT `session_id`
    
      FROM `i9hrp_session`
      WHERE `session_id` = 'ptsqf4djeq88c36geho49puo21'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_sessionNULLconstPRIMARYPRIMARY766const1100.00Using index
    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.05 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.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.04 ms
    executing0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 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.01 ms
    freeing items0.00 ms
    storing result in query cache0.09 ms
    cleaning up0.03 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.54 ms Dopo l'ultima query: 0.23 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 ('ptsqf4djeq88c36geho49puo21', 1, '1614793881', 0, '', 0)
    Explain
    EXPLAIN non possibile sulla query: INSERT INTO `i9hrp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('ptsqf4djeq88c36geho49puo21', 1, '1614793881', 0, '', 0)
    Profilo
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    update0.08 ms
    Waiting for query cache lock0.00 ms
    update0.02 ms
    end0.01 ms
    query end0.07 ms
    closing tables0.02 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: 0.56 ms Dopo l'ultima query: 47.95 ms Memoria query: 0.015 MB memoria prima della query: 3.878 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.00 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]

  6. Tempo della query: 0.46 ms Dopo l'ultima query: 3.77 ms Memoria query: 0.014 MB memoria prima della query: 3.955 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.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 clien0.04 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]

  7. Tempo della query: 0.83 ms Dopo l'ultima query: 232.76 ms Memoria query: 0.018 MB memoria prima della query: 7.560 MB
    UPDATE `i9hrp_extensions`
    
      SET `params` = '{\"mediaversion\":\"e1dd7ac98b6c8fcb75ef2baf0956f6c1\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEi9hrp_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profilo
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.12 ms
    updating0.09 ms
    end0.01 ms
    Waiting for query cache lock0.00 ms
    end0.10 ms
    query end0.06 ms
    closing tables0.03 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]

  8. Tempo della query: 0.68 ms Dopo l'ultima query: 86.58 ms Memoria query: 0.030 MB memoria prima della query: 8.874 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.01 ms
    Waiting on query cache mutex0.00 ms
    starting0.02 ms
    checking query cache for query0.02 ms
    checking privileges on cached 0.00 ms
    checking permissions0.01 ms
    sending cached result to clien0.05 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/joomla/access/access.php:427
    19JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:211
    18JAccess::preload()JROOT/libraries/joomla/access/access.php:529
    17JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    16JAccess::check()JROOT/libraries/joomla/user/user.php:393
    15JUser->authorise()JROOT/components/com_content/models/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:434
    13JModelLegacy->getState()JROOT/libraries/legacy/view/category.php:115
    12JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    11ContentViewCategory->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]

  9. Tempo della query: 2.15 ms Dopo l'ultima query: 0.62 ms Memoria query: 0.062 MB memoria prima della query: 8.963 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.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 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 clien1.28 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/joomla/access/access.php:357
    19JAccess::preloadPermissions()JROOT/libraries/joomla/access/access.php:224
    18JAccess::preload()JROOT/libraries/joomla/access/access.php:538
    17JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    16JAccess::check()JROOT/libraries/joomla/user/user.php:393
    15JUser->authorise()JROOT/components/com_content/models/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:434
    13JModelLegacy->getState()JROOT/libraries/legacy/view/category.php:115
    12JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    11ContentViewCategory->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]

  10. Tempo della query: 3.68 ms Dopo l'ultima query: 16.54 ms Memoria query: 0.030 MB memoria prima della query: 10.512 MB Righe restituite: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
      FROM 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)
      LEFT JOIN `i9hrp_content` AS i
      ON i.`catid` = c.id
      AND i.state = 1
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.published = 1
      AND s.id=165
      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 temporary; Using filesort
    1SIMPLEcNULLALLcat_idx,idx_left_rightNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL11046.97Using where
    1SIMPLEiNULLrefidx_state,idx_catididx_catid4Sql1464388_2.c.id8100.00Using where
    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.29 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.23 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.01 ms
    System lock0.07 ms
    optimizing0.04 ms
    statistics0.27 ms
    preparing0.11 ms
    Creating tmp table0.23 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data1.29 ms
    Creating sort index0.11 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.32 ms
    query end0.01 ms
    closing tables0.05 ms
    freeing items0.04 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.02 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.04 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/legacy/categories/categories.php:301
    16JCategories->_load()JROOT/libraries/legacy/categories/categories.php:182
    15JCategories->get()JROOT/components/com_content/models/category.php:355
    14ContentModelCategory->getCategory()JROOT/libraries/legacy/view/legacy.php:422
    13JViewLegacy->get()JROOT/libraries/legacy/view/category.php:121
    12JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    11ContentViewCategory->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]

  11. Tempo della query: 12.83 ms Dopo l'ultima query: 5.35 ms Memoria query: 0.041 MB memoria prima della query: 10.745 MB Righe restituite: 3
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM i9hrp_content AS a
      LEFT JOIN i9hrp_categories AS c
      ON c.id = a.catid
      LEFT JOIN i9hrp_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN i9hrp_users AS uam
      ON uam.id = a.modified_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.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.catid = 165 OR a.catid IN ( SELECT sub.id
      FROM i9hrp_categories as sub
      INNER JOIN i9hrp_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 165))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-03 17:51:21')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-03 17:51:21')
      ORDER BY c.lft, a.ordering, a.created
      LIMIT 10
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcNULLALLPRIMARY,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1109.73Using where; Using temporary; Using filesort
    1PRIMARYaNULLrefidx_access,idx_state,idx_catididx_catid4Sql1464388_2.c.id816.00Using index condition; Using where
    1PRIMARYuaNULLeq_refPRIMARYPRIMARY4Sql1464388_2.a.created_by1100.00Using where
    1PRIMARYuamNULLeq_refPRIMARYPRIMARY4Sql1464388_2.a.modified_by1100.00Using where
    1PRIMARYparentNULLeq_refPRIMARYPRIMARY4Sql1464388_2.c.parent_id1100.00Using where
    1PRIMARYvNULLALLPRIMARYNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1100.00Using where; Using join buffer (Block Nested Loop)
    2SUBQUERYthisNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    2SUBQUERYsubNULLrangePRIMARY,idx_left_rightidx_left_right4NULL533.33Using where; Using index
    Profilo
    StatusDuration
    starting0.03 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    starting0.03 ms
    checking query cache for query0.37 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.25 ms
    init0.20 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    System lock0.11 ms
    optimizing0.04 ms
    statistics0.20 ms
    preparing0.10 ms
    Creating tmp table0.21 ms
    Sorting result0.01 ms
    optimizing0.02 ms
    statistics0.16 ms
    preparing0.05 ms
    executing0.00 ms
    Sending data0.16 ms
    executing0.00 ms
    Sending data8.92 ms
    Creating sort index0.14 ms
    end0.01 ms
    query end0.08 ms
    removing tmp table0.05 ms
    query end0.01 ms
    closing tables0.08 ms
    freeing items0.02 ms
    removing tmp table0.01 ms
    freeing items0.04 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.00 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/legacy/model/legacy.php:307
    17JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:186
    16JModelList->getItems()JROOT/components/com_content/models/articles.php:536
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:422
    13JViewLegacy->get()JROOT/libraries/legacy/view/category.php:143
    12JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    11ContentViewCategory->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]

  12. Tempo della query: 0.71 ms Dopo l'ultima query: 7.45 ms Memoria query: 0.030 MB memoria prima della query: 11.035 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` = 721
      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.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.00 ms
    checking query cache for query0.05 ms
    checking permissions0.01 ms
    checking permissions0.00 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.02 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 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.01 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.13 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/cms/helper/tags.php:450
    16JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:422
    13JViewLegacy->get()JROOT/libraries/legacy/view/category.php:143
    12JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    11ContentViewCategory->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]

  13. Tempo della query: 0.55 ms Dopo l'ultima query: 0.54 ms Memoria query: 0.030 MB memoria prima della query: 11.076 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` = 720
      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.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.00 ms
    checking query cache for query0.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.00 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    System lock0.02 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    Waiting for query cache lock0.01 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.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile e numero di linea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    17JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    16JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:422
    13JViewLegacy->get()JROOT/libraries/legacy/view/category.php:143
    12JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    11ContentViewCategory->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]

  14. Tempo della query: 0.56 ms Dopo l'ultima query: 0.71 ms Memoria query: 0.030 MB memoria prima della query: 11.117 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` = 719
      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.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.00 ms
    checking query cache for query0.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 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.04 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.03 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.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.11 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile e numero di linea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    17JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    16JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:662
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:422
    13JViewLegacy->get()JROOT/libraries/legacy/view/category.php:143
    12JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    11ContentViewCategory->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]

  15. Tempo della query: 5.32 ms Dopo l'ultima query: 4.04 ms Memoria query: 0.025 MB memoria prima della query: 11.273 MB Righe restituite: 1
    SELECT COUNT(*)
    
      FROM i9hrp_content AS a
      LEFT JOIN i9hrp_categories AS c
      ON c.id = a.catid
      LEFT JOIN i9hrp_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN i9hrp_users AS uam
      ON uam.id = a.modified_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.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.catid = 165 OR a.catid IN ( SELECT sub.id
      FROM i9hrp_categories as sub
      INNER JOIN i9hrp_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 165))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-03 17:51:21')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-03 17:51:21')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcNULLALLPRIMARY,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1109.73Using where
    1PRIMARYaNULLrefidx_access,idx_state,idx_catididx_catid4Sql1464388_2.c.id816.00Using index condition; Using where
    1PRIMARYuaNULLeq_refPRIMARYPRIMARY4Sql1464388_2.a.created_by1100.00Using where; Using index
    1PRIMARYuamNULLeq_refPRIMARYPRIMARY4Sql1464388_2.a.modified_by1100.00Using where; Using index
    1PRIMARYparentNULLeq_refPRIMARYPRIMARY4Sql1464388_2.c.parent_id1100.00Using where; Using index
    1PRIMARYvNULLeq_refPRIMARYPRIMARY4Sql1464388_2.a.id1100.00Using where; Using index
    2SUBQUERYthisNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    2SUBQUERYsubNULLrangePRIMARY,idx_left_rightidx_left_right4NULL533.33Using where; Using index
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 ms
    starting0.01 ms
    checking query cache for query0.12 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 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.05 ms
    optimizing0.03 ms
    statistics0.13 ms
    preparing0.04 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.25 ms
    executing0.00 ms
    Sending data3.91 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.05 ms
    freeing items0.01 ms
    removing tmp table0.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.07 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    18JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:334
    17JModelLegacy->_getListCount()JROOT/libraries/legacy/model/list.php:281
    16JModelList->getTotal()JROOT/libraries/legacy/model/list.php:231
    15JModelList->getPagination()JROOT/components/com_content/models/category.php:265
    14ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:422
    13JViewLegacy->get()JROOT/libraries/legacy/view/category.php:143
    12JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    11ContentViewCategory->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]

  16. Tempo della query: 0.73 ms Dopo l'ultima query: 0.49 ms Memoria query: 0.027 MB memoria prima della query: 11.284 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.category'
      AND `m`.`content_item_id` = 165
      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.01 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.00 ms
    checking permissions0.00 ms
    Opening tables0.01 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.07 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.00 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.01 ms
    freeing items0.00 ms
    storing result in query cache0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    14JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:450
    13JHelperTags->getItemTags()JROOT/libraries/legacy/view/category.php:225
    12JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    11ContentViewCategory->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]

  17. Tempo della query: 1.95 ms Dopo l'ultima query: 73.59 ms Memoria query: 0.036 MB memoria prima della query: 12.305 MB Righe restituite: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM 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=165
      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.02 ms
    starting0.02 ms
    checking query cache for query0.27 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.15 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 ms
    System lock0.07 ms
    optimizing0.03 ms
    statistics0.26 ms
    preparing0.04 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.04 ms
    Creating sort index0.35 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.03 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.08 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.11 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    22JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:301
    21JCategories->_load()JROOT/libraries/legacy/categories/categories.php:182
    20JCategories->get()JROOT/administrator/components/com_fields/models/fields.php:197
    19FieldsModelFields->getListQuery()JROOT/libraries/legacy/model/list.php:132
    18JModelList->_getListQuery()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/category/view.html.php:108
    11ContentViewCategory->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]

  18. Tempo della query: 1.89 ms Dopo l'ultima query: 0.85 ms Memoria query: 0.033 MB memoria prima della query: 12.359 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 (165,0))
      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.00 ms
    Waiting on query cache mutex0.01 ms
    starting0.02 ms
    checking query cache for query0.20 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    init0.12 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.08 ms
    optimizing0.03 ms
    statistics0.14 ms
    preparing0.06 ms
    Creating tmp table0.13 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.32 ms
    Creating sort index0.05 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.00 ms
    freeing items0.07 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
    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/category/view.html.php:108
    11ContentViewCategory->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: 0.87 ms Dopo l'ultima query: 543.96 ms Memoria query: 0.023 MB memoria prima della query: 16.341 MB Righe restituite: 0
    SELECT id
    
      FROM i9hrp_categories
      WHERE id = 721
      LIMIT 1
    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.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.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.05 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.18 ms
    Waiting for query cache lock0.00 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:1720
    17JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    16AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:196
    15plgContentAttachments->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/category/view.html.php:108
    11ContentViewCategory->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: 0.30 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.024 MB memoria prima della query: 16.366 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 = 459
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcontactNULLrefidx_stateidx_state1const110.00Using where
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 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
    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/category/view.html.php:108
    11ContentViewCategory->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: 0.44 ms Dopo l'ultima query: 4.34 ms Memoria query: 0.032 MB memoria prima della query: 16.416 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.01 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 clien0.04 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/category/view.html.php:108
    11ContentViewCategory->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: 0.55 ms Dopo l'ultima query: 2.56 ms Memoria query: 0.041 MB memoria prima della query: 16.462 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.03 ms
    checking privileges on cached 0.01 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/category/view.html.php:108
    11ContentViewCategory->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.75 ms Dopo l'ultima query: 2.41 ms Memoria query: 0.024 MB memoria prima della query: 16.527 MB Righe restituite: 1
    SELECT created_by, catid
    
      FROM i9hrp_content
      WHERE id = 721
    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.05 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.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.16 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
    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/category/view.html.php:116
    11ContentViewCategory->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: 3.42 ms Dopo l'ultima query: 18.43 ms Memoria query: 0.033 MB memoria prima della query: 16.752 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=721
      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.03 ms
    Waiting for query cache lock0.01 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.01 ms
    System lock0.04 ms
    optimizing0.03 ms
    statistics0.04 ms
    preparing0.02 ms
    Sorting result0.02 ms
    executing0.00 ms
    Sending data0.04 ms
    Creating sort index2.40 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.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.01 ms
    cleaning up0.01 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/category/view.html.php:116
    11ContentViewCategory->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.69 ms Dopo l'ultima query: 12.48 ms Memoria query: 0.024 MB memoria prima della query: 16.776 MB Righe restituite: 0
    SELECT id
    
      FROM i9hrp_categories
      WHERE id = 720
      LIMIT 1
    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.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.02 ms
    System lock0.03 ms
    optimizing0.02 ms
    statistics0.07 ms
    executing0.02 ms
    end0.03 ms
    query end0.01 ms
    closing tables0.01 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.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:1720
    17JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    16AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:196
    15plgContentAttachments->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/category/view.html.php:108
    11ContentViewCategory->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: 0.65 ms Dopo l'ultima query: 1.41 ms Memoria query: 0.024 MB memoria prima della query: 16.799 MB Righe restituite: 1
    SELECT created_by, catid
    
      FROM i9hrp_content
      WHERE id = 720
    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.01 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.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 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.01 ms
    Waiting on query cache mutex0.01 ms
    freeing items0.02 ms
    storing result in query cache0.16 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/category/view.html.php:116
    11ContentViewCategory->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: 4.21 ms Dopo l'ultima query: 1.13 ms Memoria query: 0.033 MB memoria prima della query: 16.835 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=720
      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.01 ms
    Waiting on query cache mutex0.01 ms
    starting0.01 ms
    checking query cache for query0.12 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.10 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.01 ms
    System lock0.05 ms
    optimizing0.03 ms
    statistics0.05 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.06 ms
    Creating sort index3.18 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.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.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/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/category/view.html.php:116
    11ContentViewCategory->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: 0.86 ms Dopo l'ultima query: 12.01 ms Memoria query: 0.023 MB memoria prima della query: 16.854 MB Righe restituite: 0
    SELECT id
    
      FROM i9hrp_categories
      WHERE id = 719
      LIMIT 1
    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.05 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.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.04 ms
    executing0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.15 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.00 ms
    Call Stack
    #CallerFile e numero di linea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    17JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    16AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:196
    15plgContentAttachments->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/category/view.html.php:108
    11ContentViewCategory->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]

  29. Tempo della query: 0.70 ms Dopo l'ultima query: 1.45 ms Memoria query: 0.024 MB memoria prima della query: 16.877 MB Righe restituite: 1
    SELECT created_by, catid
    
      FROM i9hrp_content
      WHERE id = 719
    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.04 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    init0.02 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.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 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.07 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.00 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/category/view.html.php:116
    11ContentViewCategory->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]

  30. Tempo della query: 2.92 ms Dopo l'ultima query: 1.87 ms Memoria query: 0.034 MB memoria prima della query: 16.912 MB Righe restituite: 5
    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=719
      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.00 ms
    Waiting on query cache mutex0.00 ms
    starting0.01 ms
    checking query cache for query0.07 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.07 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    System lock0.04 ms
    optimizing0.02 ms
    statistics0.04 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    Creating sort index1.90 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 ms
    freeing items0.20 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.00 ms
    storing result in query cache0.09 ms
    cleaning up0.01 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/category/view.html.php:116
    11ContentViewCategory->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]

  31. Tempo della query: 1.07 ms Dopo l'ultima query: 7.88 ms Memoria query: 0.041 MB memoria prima della query: 17.454 MB Righe restituite: 8
    SHOW FULL COLUMNS 
      FROM `i9hrp_assets`
    Explain
    EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `i9hrp_assets`
    Profilo
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.21 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.02 ms
    checking permissions0.05 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.03 ms
    checking permissions0.03 ms
    Sending data0.08 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.05 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    31JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    30JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    29JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:244
    28JTable->getFields()JROOT/libraries/joomla/table/table.php:163
    27JTable->__construct()JROOT/libraries/joomla/table/asset.php:60
    26JTableAsset->__construct()JROOT/libraries/joomla/table/table.php:311
    25JTable::getInstance()JROOT/libraries/joomla/access/access.php:781
    24JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    23JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    22JAccess::check()JROOT/libraries/joomla/user/user.php:393
    21JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
    20AttachmentsPlugin_Com_Content->userMayDeleteAttachment()JROOT/components/com_attachments/models/attachments.php:462
    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/category/view.html.php:116
    11ContentViewCategory->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]

  32. Tempo della query: 0.53 ms Dopo l'ultima query: 15.09 ms Memoria query: 0.035 MB memoria prima della query: 17.539 MB Righe restituite: 0
    Query duplicate: #33  #34  #35  #36  #37  #38  #39  #40  #41  #49  #50
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    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.01 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.02 ms
    sending cached result to clien0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    26JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    25JTable->load()JROOT/libraries/joomla/access/access.php:782
    24JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    23JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    22JAccess::check()JROOT/libraries/joomla/user/user.php:393
    21JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
    20AttachmentsPlugin_Com_Content->userMayDeleteAttachment()JROOT/components/com_attachments/models/attachments.php:462
    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/category/view.html.php:116
    11ContentViewCategory->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]

  33. Tempo della query: 0.32 ms Dopo l'ultima query: 1.32 ms Memoria query: 0.036 MB memoria prima della query: 17.573 MB Righe restituite: 0
    Query duplicate: #32  #34  #35  #36  #37  #38  #39  #40  #41  #49  #50
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULLNULLNULLno matching row in const table
    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.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
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    26JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    25JTable->load()JROOT/libraries/joomla/access/access.php:782
    24JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    23JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    22JAccess::check()JROOT/libraries/joomla/user/user.php:393
    21JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
    20AttachmentsPlugin_Com_Content->userMayEditAttachment()JROOT/components/com_attachments/models/attachments.php:463
    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/category/view.html.php:116
    11ContentViewCategory->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]

  34. Tempo della query: 0.34 ms Dopo l'ultima query: 0.94 ms Memoria query: 0.035 MB memoria prima della query: 17.607 MB Righe restituite: 0
    Query duplicate: #32  #33  #35  #36  #37  #38  #39  #40  #41  #49  #50
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULLNULLNULLno matching row in const table
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 ms
    starting0.02 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
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    26JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    25JTable->load()JROOT/libraries/joomla/access/access.php:782
    24JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    23JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    22JAccess::check()JROOT/libraries/joomla/user/user.php:393
    21JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
    20AttachmentsPlugin_Com_Content->userMayDeleteAttachment()JROOT/components/com_attachments/models/attachments.php:462
    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/category/view.html.php:116
    11ContentViewCategory->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]

  35. Tempo della query: 0.39 ms Dopo l'ultima query: 0.96 ms Memoria query: 0.035 MB memoria prima della query: 17.640 MB Righe restituite: 0
    Query duplicate: #32  #33  #34  #36  #37  #38  #39  #40  #41  #49  #50
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    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.01 ms
    checking permissions0.01 ms
    sending cached result to clien0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    26JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    25JTable->load()JROOT/libraries/joomla/access/access.php:782
    24JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    23JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    22JAccess::check()JROOT/libraries/joomla/user/user.php:393
    21JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
    20AttachmentsPlugin_Com_Content->userMayEditAttachment()JROOT/components/com_attachments/models/attachments.php:463
    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/category/view.html.php:116
    11ContentViewCategory->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]

  36. Tempo della query: 0.32 ms Dopo l'ultima query: 0.91 ms Memoria query: 0.035 MB memoria prima della query: 17.673 MB Righe restituite: 0
    Query duplicate: #32  #33  #34  #35  #37  #38  #39  #40  #41  #49  #50
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULLNULLNULLno matching row in const table
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 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
    sending cached result to clien0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    26JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    25JTable->load()JROOT/libraries/joomla/access/access.php:782
    24JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    23JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    22JAccess::check()JROOT/libraries/joomla/user/user.php:393
    21JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
    20AttachmentsPlugin_Com_Content->userMayDeleteAttachment()JROOT/components/com_attachments/models/attachments.php:462
    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/category/view.html.php:116
    11ContentViewCategory->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]

  37. Tempo della query: 0.30 ms Dopo l'ultima query: 0.89 ms Memoria query: 0.035 MB memoria prima della query: 17.706 MB Righe restituite: 0
    Query duplicate: #32  #33  #34  #35  #36  #38  #39  #40  #41  #49  #50
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULLNULLNULLno matching row in const table
    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.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.01 ms
    sending cached result to clien0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    26JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    25JTable->load()JROOT/libraries/joomla/access/access.php:782
    24JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    23JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    22JAccess::check()JROOT/libraries/joomla/user/user.php:393
    21JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
    20AttachmentsPlugin_Com_Content->userMayEditAttachment()JROOT/components/com_attachments/models/attachments.php:463
    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/category/view.html.php:116
    11ContentViewCategory->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]

  38. Tempo della query: 0.41 ms Dopo l'ultima query: 0.98 ms Memoria query: 0.035 MB memoria prima della query: 17.739 MB Righe restituite: 0
    Query duplicate: #32  #33  #34  #35  #36  #37  #39  #40  #41  #49  #50
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    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.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
    sending cached result to clien0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    26JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    25JTable->load()JROOT/libraries/joomla/access/access.php:782
    24JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    23JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    22JAccess::check()JROOT/libraries/joomla/user/user.php:393
    21JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
    20AttachmentsPlugin_Com_Content->userMayDeleteAttachment()JROOT/components/com_attachments/models/attachments.php:462
    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/category/view.html.php:116
    11ContentViewCategory->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]

  39. Tempo della query: 0.34 ms Dopo l'ultima query: 0.97 ms Memoria query: 0.035 MB memoria prima della query: 17.772 MB Righe restituite: 0
    Query duplicate: #32  #33  #34  #35  #36  #37  #38  #40  #41  #49  #50
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULLNULLNULLno matching row in const table
    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.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
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    26JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    25JTable->load()JROOT/libraries/joomla/access/access.php:782
    24JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    23JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    22JAccess::check()JROOT/libraries/joomla/user/user.php:393
    21JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
    20AttachmentsPlugin_Com_Content->userMayEditAttachment()JROOT/components/com_attachments/models/attachments.php:463
    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/category/view.html.php:116
    11ContentViewCategory->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]

  40. Tempo della query: 0.32 ms Dopo l'ultima query: 0.91 ms Memoria query: 0.035 MB memoria prima della query: 17.805 MB Righe restituite: 0
    Query duplicate: #32  #33  #34  #35  #36  #37  #38  #39  #41  #49  #50
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULLNULLNULLno matching row in const table
    Profilo
    StatusDuration
    starting0.01 ms
    Waiting for query cache lock0.00 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
    sending cached result to clien0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    26JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    25JTable->load()JROOT/libraries/joomla/access/access.php:782
    24JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    23JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    22JAccess::check()JROOT/libraries/joomla/user/user.php:393
    21JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
    20AttachmentsPlugin_Com_Content->userMayDeleteAttachment()JROOT/components/com_attachments/models/attachments.php:462
    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/category/view.html.php:116
    11ContentViewCategory->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]

  41. Tempo della query: 0.48 ms Dopo l'ultima query: 0.98 ms Memoria query: 0.035 MB memoria prima della query: 17.838 MB Righe restituite: 0
    Query duplicate: #32  #33  #34  #35  #36  #37  #38  #39  #40  #49  #50
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    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.01 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 clien0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    26JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    25JTable->load()JROOT/libraries/joomla/access/access.php:782
    24JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    23JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    22JAccess::check()JROOT/libraries/joomla/user/user.php:393
    21JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
    20AttachmentsPlugin_Com_Content->userMayEditAttachment()JROOT/components/com_attachments/models/attachments.php:463
    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/category/view.html.php:116
    11ContentViewCategory->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]

  42. Tempo della query: 0.74 ms Dopo l'ultima query: 8.20 ms Memoria query: 0.029 MB memoria prima della query: 17.776 MB Righe restituite: 1
    SELECT id
    
      FROM i9hrp_content
      WHERE id=719
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_contentNULLconstPRIMARYPRIMARY4const1100.00Using index
    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.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.02 ms
    System lock0.03 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.02 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.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
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    22JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:648
    21AttachmentsPlugin->parentExists()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:344
    20AttachmentsPlugin->getTitle()JROOT/components/com_attachments/models/attachments.php:254
    19AttachmentsModelAttachments->getParentTitle()JROOT/components/com_attachments/views/attachments/view.html.php:152
    18AttachmentsViewAttachments->display()JROOT/components/com_attachments/controllers/attachments.php:133
    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/category/view.html.php:116
    11ContentViewCategory->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]

  43. Tempo della query: 0.50 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.028 MB memoria prima della query: 17.805 MB Righe restituite: 1
    SELECT title
    
      FROM i9hrp_content
      WHERE id=719
    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.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.02 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.01 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.01 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.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    21JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:359
    20AttachmentsPlugin->getTitle()JROOT/components/com_attachments/models/attachments.php:254
    19AttachmentsModelAttachments->getParentTitle()JROOT/components/com_attachments/views/attachments/view.html.php:152
    18AttachmentsViewAttachments->display()JROOT/components/com_attachments/controllers/attachments.php:133
    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/category/view.html.php:116
    11ContentViewCategory->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]

  44. Tempo della query: 1.90 ms Dopo l'ultima query: 53.39 ms Memoria query: 0.041 MB memoria prima della query: 18.072 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.categories'
      AND (fc.category_id IS NULL OR fc.category_id IN (165,0))
      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.25 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.13 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.08 ms
    optimizing0.03 ms
    statistics0.16 ms
    preparing0.06 ms
    Creating tmp table0.09 ms
    Sorting result0.01 ms
    executing0.02 ms
    Sending data0.31 ms
    Creating sort index0.05 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.06 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    Waiting for query cache lock0.01 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
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    27JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:307
    26JModelLegacy->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    25FieldsModelFields->_getList()JROOT/libraries/legacy/model/list.php:186
    24JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    23FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    22PlgSystemFields->onContentPrepare()Chiamata uguale alla linea sottostante.
    21call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:25
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    17JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    16JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:694
    14JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:229
    13JViewLegacy->display()JROOT/libraries/legacy/view/category.php:241
    12JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:260
    11ContentViewCategory->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]

  45. Tempo della query: 0.66 ms Dopo l'ultima query: 11.08 ms Memoria query: 0.032 MB memoria prima della query: 18.108 MB Righe restituite: 1
    SELECT id
    
      FROM i9hrp_categories
      WHERE id = 165
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_categoriesNULLconstPRIMARYPRIMARY4const1100.00Using 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.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    Waiting for query cache lock0.02 ms
    Waiting on query cache mutex0.00 ms
    System lock0.03 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.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
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    24JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    23AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:196
    22plgContentAttachments->onContentPrepare()Chiamata uguale alla linea sottostante.
    21call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:25
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    17JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    16JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:694
    14JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:229
    13JViewLegacy->display()JROOT/libraries/legacy/view/category.php:241
    12JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:260
    11ContentViewCategory->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]

  46. Tempo della query: 3.90 ms Dopo l'ultima query: 0.95 ms Memoria query: 0.041 MB memoria prima della query: 18.149 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=165
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='category'
      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.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.01 ms
    Opening tables0.03 ms
    init0.07 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    System lock0.04 ms
    optimizing0.02 ms
    statistics0.04 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.04 ms
    Creating sort index2.79 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.01 ms
    storing result in query cache0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    27JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    26AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    25AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    24AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    23AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:212
    22plgContentAttachments->onContentPrepare()Chiamata uguale alla linea sottostante.
    21call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:25
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    17JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    16JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:694
    14JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:229
    13JViewLegacy->display()JROOT/libraries/legacy/view/category.php:241
    12JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:260
    11ContentViewCategory->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]

  47. Tempo della query: 0.68 ms Dopo l'ultima query: 1.91 ms Memoria query: 0.032 MB memoria prima della query: 18.176 MB Righe restituite: 1
    SELECT created_by, catid
    
      FROM i9hrp_content
      WHERE id = 165
    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.05 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.00 ms
    System lock0.04 ms
    optimizing0.02 ms
    statistics0.07 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.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.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    24JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    23AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:312
    22plgContentAttachments->onContentBeforeDisplay()Chiamata uguale alla linea sottostante.
    21call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:31
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    17JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    16JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:694
    14JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:229
    13JViewLegacy->display()JROOT/libraries/legacy/view/category.php:241
    12JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:260
    11ContentViewCategory->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]

  48. Tempo della query: 3.04 ms Dopo l'ultima query: 1.44 ms Memoria query: 0.042 MB memoria prima della query: 18.220 MB Righe restituite: 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
      WHERE a.parent_id=165
      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.00 ms
    Waiting on query cache mutex0.01 ms
    starting0.01 ms
    checking query cache for query0.10 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 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.02 ms
    statistics0.04 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.04 ms
    Creating sort index2.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.02 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.01 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
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    27JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    26AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    25AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    24AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    23AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:318
    22plgContentAttachments->onContentBeforeDisplay()Chiamata uguale alla linea sottostante.
    21call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:31
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    17JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    16JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:694
    14JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:229
    13JViewLegacy->display()JROOT/libraries/legacy/view/category.php:241
    12JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:260
    11ContentViewCategory->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]

  49. Tempo della query: 0.29 ms Dopo l'ultima query: 0.72 ms Memoria query: 0.044 MB memoria prima della query: 18.418 MB Righe restituite: 0
    Query duplicate: #32  #33  #34  #35  #36  #37  #38  #39  #40  #41  #50
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    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.01 ms
    sending cached result to clien0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    34JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    33JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    32JTable->load()JROOT/libraries/joomla/access/access.php:782
    31JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    30JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    29JAccess::check()JROOT/libraries/joomla/user/user.php:393
    28JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
    27AttachmentsPlugin_Com_Content->userMayDeleteAttachment()JROOT/components/com_attachments/models/attachments.php:462
    26AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    25AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    24AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    23AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:318
    22plgContentAttachments->onContentBeforeDisplay()Chiamata uguale alla linea sottostante.
    21call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:31
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    17JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    16JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:694
    14JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:229
    13JViewLegacy->display()JROOT/libraries/legacy/view/category.php:241
    12JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:260
    11ContentViewCategory->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]

  50. Tempo della query: 0.28 ms Dopo l'ultima query: 0.70 ms Memoria query: 0.044 MB memoria prima della query: 18.460 MB Righe restituite: 0
    Query duplicate: #32  #33  #34  #35  #36  #37  #38  #39  #40  #41  #49
    SELECT *
    
      FROM i9hrp_assets
      WHERE `name` = 'edit'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULLNULLNULLno matching row in const table
    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.01 ms
    checking privileges on cached 0.00 ms
    checking permissions0.01 ms
    sending cached result to clien0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile e numero di linea
    34JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1445
    33JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:729
    32JTable->load()JROOT/libraries/joomla/access/access.php:782
    31JAccess::getAssetId()JROOT/libraries/joomla/access/access.php:542
    30JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:181
    29JAccess::check()JROOT/libraries/joomla/user/user.php:393
    28JUser->authorise()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
    27AttachmentsPlugin_Com_Content->userMayEditAttachment()JROOT/components/com_attachments/models/attachments.php:463
    26AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    25AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    24AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    23AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:318
    22plgContentAttachments->onContentBeforeDisplay()Chiamata uguale alla linea sottostante.
    21call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:31
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    17JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    16JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:694
    14JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:229
    13JViewLegacy->display()JROOT/libraries/legacy/view/category.php:241
    12JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:260
    11ContentViewCategory->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]

  51. Tempo della query: 0.92 ms Dopo l'ultima query: 1.64 ms Memoria query: 0.038 MB memoria prima della query: 18.339 MB Righe restituite: 1
    SELECT id
    
      FROM i9hrp_content
      WHERE id=165
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEi9hrp_contentNULLconstPRIMARYPRIMARY4const1100.00Using index
    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.05 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.00 ms
    System lock0.03 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 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.20 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
    30JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    29JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:648
    28AttachmentsPlugin->parentExists()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:344
    27AttachmentsPlugin->getTitle()JROOT/components/com_attachments/models/attachments.php:254
    26AttachmentsModelAttachments->getParentTitle()JROOT/components/com_attachments/views/attachments/view.html.php:152
    25AttachmentsViewAttachments->display()JROOT/components/com_attachments/controllers/attachments.php:133
    24AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    23AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:318
    22plgContentAttachments->onContentBeforeDisplay()Chiamata uguale alla linea sottostante.
    21call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:31
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    17JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    16JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:694
    14JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:229
    13JViewLegacy->display()JROOT/libraries/legacy/view/category.php:241
    12JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:260
    11ContentViewCategory->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]

  52. Tempo della query: 0.58 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.037 MB memoria prima della query: 18.377 MB Righe restituite: 1
    SELECT title
    
      FROM i9hrp_content
      WHERE id=165
    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.01 ms
    checking query cache for query0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    System lock0.02 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 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.07 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
    29JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1720
    28JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:359
    27AttachmentsPlugin->getTitle()JROOT/components/com_attachments/models/attachments.php:254
    26AttachmentsModelAttachments->getParentTitle()JROOT/components/com_attachments/views/attachments/view.html.php:152
    25AttachmentsViewAttachments->display()JROOT/components/com_attachments/controllers/attachments.php:133
    24AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    23AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:318
    22plgContentAttachments->onContentBeforeDisplay()Chiamata uguale alla linea sottostante.
    21call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:31
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    17JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    16JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:694
    14JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:229
    13JViewLegacy->display()JROOT/libraries/legacy/view/category.php:241
    12JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:260
    11ContentViewCategory->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]

  53. Tempo della query: 2.19 ms Dopo l'ultima query: 7.93 ms Memoria query: 0.045 MB memoria prima della query: 18.387 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.category.title'
      AND (fc.category_id IS NULL OR fc.category_id IN (165,0))
      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.01 ms
    starting0.02 ms
    checking query cache for query0.30 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.18 ms
    System lock0.02 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    System lock0.09 ms
    optimizing0.05 ms
    statistics0.20 ms
    preparing0.06 ms
    Creating tmp table0.12 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.29 ms
    Creating sort index0.05 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.06 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    Waiting for query cache lock0.00 ms
    Waiting on query cache mutex0.00 ms
    freeing items0.18 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
    32JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1681
    31JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:307
    30JModelLegacy->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    29FieldsModelFields->_getList()JROOT/libraries/legacy/model/list.php:186
    28JModelList->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:134
    27FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    26PlgSystemFields->onContentPrepare()Chiamata uguale alla linea sottostante.
    25call_user_func_array()JROOT/libraries/joomla/event/event.php:70
    24JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    23JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    22JHtmlContent::prepare()Chiamata uguale alla linea sottostante.
    21call_user_func_array()JROOT/libraries/cms/html/html.php:233
    20JHtml::call()JROOT/libraries/cms/html/html.php:140
    19JHtml::_()JROOT/layouts/joomla/content/category_default.php:57
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    17JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    16JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:694
    14JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:229
    13JViewLegacy->display()JROOT/libraries/legacy/view/category.php:241
    12JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:260
    11ContentViewCategory->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]

  54. Tempo della query: 2.74 ms Dopo l'ultima query: 49.67 ms Memoria query: 0.021 MB memoria prima della query: 18.850 MB Righe restituite: 5
    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 17:51:21')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-03 17:51:21')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 292 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.16 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    init0.09 ms
    System lock0.01 ms
    Waiting for query cache lock0.01 ms
    Waiting on query cache mutex0.00 ms
    System lock0.06 ms
    optimizing0.04 ms
    statistics0.14 ms
    preparing0.05 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    Creating sort index1.51 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.05 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]

25 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:
  1. 12 × SELECT * 
      FROM i9hrp_assets
  2. 5 × SELECT a.*, u.name as creator_name 
      FROM i9hrp_attachments AS a
      LEFT JOIN i9hrp_users AS u
      ON u.id = a.created_by
  3. 4 × SELECT id 
      FROM i9hrp_categories
  4. 4 × SELECT created_by, catid 
      FROM i9hrp_content
  5. 4 × SELECT `m`.`tag_id`,`t`.* 
      FROM `i9hrp_contentitem_tag_map` AS m
      INNER JOIN `i9hrp_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  6. 3 × 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
  7. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `i9hrp_assets`
  8. 2 × SELECT title 
      FROM i9hrp_content
  9. 2 × SELECT id 
      FROM i9hrp_content
  10. 1 × SELECT id, rules 
      FROM `i9hrp_viewlevels
  11. 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
  12. 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
  13. 1 × SELECT `session_id` 
      FROM `i9hrp_session`
  14. 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
  15. 1 × SELECT `alias` 
      FROM `i9hrp_contact_details`
  16. 1 × SELECT COUNT(*) 
      FROM i9hrp_content AS a
      LEFT JOIN i9hrp_categories AS c
      ON c.id = a.catid
      LEFT JOIN i9hrp_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN i9hrp_users AS uam
      ON uam.id = a.modified_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
  17. 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,COUNT(i.`id`) AS numitems
      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)
      LEFT JOIN `i9hrp_content` AS i
      ON i.`catid` = c.id
      AND i.state = 1
  18. 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
      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)
  19. 1 × SELECT `data` 
      FROM `i9hrp_session`
  20. 1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid 
      FROM `i9hrp_contact_details` AS `contact`
  21. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM i9hrp_content AS a
      LEFT JOIN i9hrp_categories AS c
      ON c.id = a.catid
      LEFT JOIN i9hrp_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN i9hrp_users AS uam
      ON uam.id = a.modified_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 × SHOW FULL COLUMNS 
      FROM `i9hrp_assets
  2. 1 × UPDATE `i9hrp_extensions` 
      SET `params` = '{\"mediaversion\":\"e1dd7ac98b6c8fcb75ef2baf0956f6c1\"}'
  3. 1 × INSERT INTO `i9hrp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('ptsqf4djeq88c36geho49puo21', 1, '1614793881', 0, '', 0
  4. 1 × DELETE  
      FROM `i9hrp_session`