pinterest
behance
linkdin
facebook
instagram
mail
Alessandro Santoriello

Alessandro Santoriello

Visual Designer

Menù
  • Home
  • Progetti
  • Side Projects
  • About
Behance linkdin facebook instagram mail
Titolo Autore Visite
Strateg.ee Scritto da Super User Visite: 404
Superlizzy Scritto da Super User Visite: 393
DeCecco Scritto da Super User Visite: 926
Bio Snail Scritto da Super User Visite: 1150
Targetti Scritto da Super User Visite: 408
Bijouets Scritto da Super User Visite: 856
Mobilfer Scritto da Super User Visite: 932
Miscela d'Oro Scritto da Super User Visite: 526
Giorgetti Scritto da Super User Visite: 522
Panaria Scritto da Super User Visite: 480

Pagina 1 di 5

  • Inizio
  • Indietro
  • 1
  • 2
  • 3
  • 4
  • 5
  • Avanti
  • Fine
Back to Top

© 2025 Santoriello / all rights reserved

P.IVA 02766600411 / REA PS n.279001

This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

Console Debug Joomla!

Sessione

__default

Informazioni profilo

Tempo

Memoria

Tempo: 0.0 ms / 0.0 ms Memoria: 0.689 MB / 0.69 MB Application: afterLoad
Tempo: 430.2 ms / 430.2 ms Memoria: 6.032 MB / 6.72 MB Application: afterInitialise
Tempo: 12.1 ms / 442.3 ms Memoria: 0.438 MB / 7.16 MB Application: afterRoute
Tempo: 198.9 ms / 641.2 ms Memoria: 3.711 MB / 10.87 MB Application: afterDispatch
Tempo: 9.4 ms / 650.6 ms Memoria: 0.168 MB / 11.04 MB Application: beforeRenderModule mod_menu (Menu Principale)
Tempo: 13.2 ms / 663.8 ms Memoria: 0.089 MB / 11.13 MB Application: afterRenderModule mod_menu (Menu Principale)
Tempo: 13.2 ms / 676.9 ms Memoria: 0.198 MB / 11.33 MB Application: afterRender

Query totali del database: 67.5 ms

Utilizzo memoria

12.41 MB (13.011.664 Bytes)

Query Database

44 query eseguite 67.5 ms


Trovati 4 duplicati!

2 duplicati: #10  #11
2 duplicati: #17  #19
  1. Tempo della query: 0.56 ms Memoria query: 0.013 MB memoria prima della query: 2.294 MB Righe restituite: 0
    SELECT `data`
    
      FROM `hr2hx_session`
      WHERE `session_id` = 'p676s5khvhvfr9f2914psfe7a6'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_sessionconstPRIMARYPRIMARY602const1
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/session/storage/database.php:46
    JROOT/libraries/joomla/session/session.php:658
    JROOT/libraries/joomla/session/session.php:596
    JROOT/libraries/cms/application/cms.php:668
    JROOT/libraries/cms/application/cms.php:131
    JROOT/libraries/cms/application/site.php:63
    JROOT/libraries/cms/application/cms.php:328
    JROOT/libraries/joomla/factory.php:124
    JROOT/index.php:37
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  2. Tempo della query: 0.71 ms Dopo l'ultima query: 4.11 ms Memoria query: 0.008 MB memoria prima della query: 2.439 MB
    DELETE 
    
      FROM `hr2hx_session`
      WHERE `time` < '1746760555'
    Explain
    EXPLAIN non possibile sulla query: DELETE FROM `hr2hx_session` WHERE `time` < '1746760555'
    Profilo
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    init0.1 ms
    updating0.1 ms
    end0.0 ms
    Waiting for query cache lock0.0 ms
    end0.1 ms
    query end0.1 ms
    closing tables0.0 ms
    freeing items0.1 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/application/cms.php:685
    JROOT/libraries/cms/application/cms.php:131
    JROOT/libraries/cms/application/site.php:63
    JROOT/libraries/cms/application/cms.php:328
    JROOT/libraries/joomla/factory.php:124
    JROOT/index.php:37
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  3. Tempo della query: 0.52 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.010 MB memoria prima della query: 2.451 MB Righe restituite: 0
    SELECT `session_id`
    
      FROM `hr2hx_session`
      WHERE `session_id` = 'p676s5khvhvfr9f2914psfe7a6'
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_sessionconstPRIMARYPRIMARY602const1Using index
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/application/cms.php:175
    JROOT/libraries/cms/application/cms.php:694
    JROOT/libraries/cms/application/cms.php:131
    JROOT/libraries/cms/application/site.php:63
    JROOT/libraries/cms/application/cms.php:328
    JROOT/libraries/joomla/factory.php:124
    JROOT/index.php:37
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  4. Tempo della query: 0.48 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.009 MB memoria prima della query: 2.464 MB
    INSERT INTO `hr2hx_session`
    (`session_id`, `client_id`, `time`) 
      VALUES ('p676s5khvhvfr9f2914psfe7a6', 0, '1746761455')
    Explain
    EXPLAIN non possibile sulla query: INSERT INTO `hr2hx_session` (`session_id`, `client_id`, `time`) VALUES ('p676s5khvhvfr9f2914psfe7a6', 0, '1746761455')
    Profilo
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    init0.0 ms
    update0.1 ms
    Waiting for query cache lock0.0 ms
    update0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/application/cms.php:207
    JROOT/libraries/cms/application/cms.php:694
    JROOT/libraries/cms/application/cms.php:131
    JROOT/libraries/cms/application/site.php:63
    JROOT/libraries/cms/application/cms.php:328
    JROOT/libraries/joomla/factory.php:124
    JROOT/index.php:37
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  5. Tempo della query: 0.65 ms Dopo l'ultima query: 9.18 ms Memoria query: 0.012 MB memoria prima della query: 2.828 MB Righe restituite: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM hr2hx_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid302const1Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/libraries/cms/application/site.php:570
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  6. Tempo della query: 0.69 ms Dopo l'ultima query: 3.06 ms Memoria query: 0.013 MB memoria prima della query: 2.932 MB Righe restituite: 2
    SELECT b.id
    
      FROM hr2hx_usergroups AS a
      LEFT JOIN hr2hx_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL3Using where; Using index
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/access/access.php:334
    JROOT/libraries/joomla/access/access.php:403
    JROOT/libraries/joomla/user/user.php:428
    JROOT/libraries/cms/plugin/helper.php:298
    JROOT/libraries/cms/plugin/helper.php:165
    JROOT/libraries/cms/application/site.php:575
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  7. Tempo della query: 0.50 ms Dopo l'ultima query: 1.11 ms Memoria query: 0.011 MB memoria prima della query: 2.998 MB Righe restituite: 5
    SELECT id, rules
    
      FROM `hr2hx_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_viewlevelsALLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL5
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/access/access.php:420
    JROOT/libraries/joomla/user/user.php:428
    JROOT/libraries/cms/plugin/helper.php:298
    JROOT/libraries/cms/plugin/helper.php:165
    JROOT/libraries/cms/application/site.php:575
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  8. Tempo della query: 1.58 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.009 MB memoria prima della query: 3.017 MB Righe restituite: 44
    SELECT folder AS type, element AS name, params
    
      FROM hr2hx_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_extensionsrefextensionextension62const57Using where; Using filesort
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sorting result0.4 ms
    Sending data0.4 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/plugin/helper.php:312
    JROOT/libraries/cms/plugin/helper.php:165
    JROOT/libraries/cms/application/site.php:575
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  9. Tempo della query: 0.60 ms Dopo l'ultima query: 0.37 ms Memoria query: 0.012 MB memoria prima della query: 3.084 MB Righe restituite: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM hr2hx_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid302const1Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/libraries/cms/application/site.php:628
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  10. Tempo della query: 0.63 ms Dopo l'ultima query: 45.32 ms Memoria query: 0.018 MB memoria prima della query: 3.939 MB Righe restituite: 1
    Query duplicate: #11
    SELECT template
    
      FROM hr2hx_template_styles as s
      WHERE s.client_id = 0
      AND s.home = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsALLidx_homeNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
    JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
    JROOT/libraries/rokcommon/RokCommon/Service.php:71
    JROOT/libraries/rokcommon/include.php:38
    JROOT/plugins/system/rokcommon/rokcommon.php:99
    JROOT/plugins/system/rokcommon/rokcommon.php:57
    JROOT/libraries/cms/plugin/helper.php:257
    JROOT/libraries/cms/plugin/helper.php:172
    JROOT/libraries/cms/application/cms.php:582
    JROOT/libraries/cms/application/site.php:649
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  11. Tempo della query: 0.29 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.019 MB memoria prima della query: 3.958 MB Righe restituite: 1
    Query duplicate: #10
    SELECT template
    
      FROM hr2hx_template_styles as s
      WHERE s.client_id = 0
      AND s.home = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsALLidx_homeNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking privileges on cached 0.0 ms
    checking permissions0.0 ms
    sending cached result to clien0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
    JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
    JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
    JROOT/libraries/rokcommon/RokCommon/Service.php:71
    JROOT/libraries/rokcommon/include.php:38
    JROOT/plugins/system/rokcommon/rokcommon.php:99
    JROOT/plugins/system/rokcommon/rokcommon.php:57
    JROOT/libraries/cms/plugin/helper.php:257
    JROOT/libraries/cms/plugin/helper.php:172
    JROOT/libraries/cms/application/cms.php:582
    JROOT/libraries/cms/application/site.php:649
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  12. Tempo della query: 0.64 ms Dopo l'ultima query: 18.19 ms Memoria query: 0.013 MB memoria prima della query: 4.288 MB Righe restituite: 2
    SELECT extension, file, type
    
      FROM hr2hx_rokcommon_configs
      ORDER BY priority
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_rokcommon_configsALLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL2Using filesort
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sorting result0.1 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/plugins/system/rokcommon/rokcommon.php:130
    JROOT/plugins/system/rokcommon/rokcommon.php:78
    JROOT/libraries/cms/plugin/helper.php:257
    JROOT/libraries/cms/plugin/helper.php:172
    JROOT/libraries/cms/application/cms.php:582
    JROOT/libraries/cms/application/site.php:649
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  13. Tempo della query: 0.65 ms Dopo l'ultima query: 29.22 ms Memoria query: 0.022 MB memoria prima della query: 5.067 MB Righe restituite: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM hr2hx_extensions
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_extensionsrefelement_clientid,element_folder_clientid,extensionextension364const,const1Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.1 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.1 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/library/helper.php:156
    JROOT/libraries/cms/library/helper.php:47
    JROOT/libraries/cms/library/helper.php:90
    JROOT/libraries/cms/version/version.php:179
    JROOT/libraries/joomla/factory.php:734
    JROOT/libraries/joomla/factory.php:215
    JROOT/plugins/system/fmalertcookies/fmalertcookies.php:35
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/cms.php:583
    JROOT/libraries/cms/application/site.php:649
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  14. Tempo della query: 0.55 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.018 MB memoria prima della query: 5.075 MB
    UPDATE `hr2hx_extensions`
    
      SET `params` = '{\"mediaversion\":\"e93badfd6e8ea162c059604a9d775e4b\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN non possibile sulla query: UPDATE `hr2hx_extensions` SET `params` = '{\"mediaversion\":\"e93badfd6e8ea162c059604a9d775e4b\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profilo
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    init0.1 ms
    Updating0.1 ms
    end0.0 ms
    Waiting for query cache lock0.0 ms
    end0.0 ms
    query end0.1 ms
    closing tables0.0 ms
    freeing items0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/library/helper.php:119
    JROOT/libraries/cms/version/version.php:230
    JROOT/libraries/cms/version/version.php:189
    JROOT/libraries/joomla/factory.php:734
    JROOT/libraries/joomla/factory.php:215
    JROOT/plugins/system/fmalertcookies/fmalertcookies.php:35
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/cms.php:583
    JROOT/libraries/cms/application/site.php:649
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  15. Tempo della query: 1.62 ms Dopo l'ultima query: 17.77 ms Memoria query: 0.019 MB memoria prima della query: 5.815 MB Righe restituite: 17
    SHOW FULL COLUMNS 
      FROM `hr2hx_extensions`
    Explain
    EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `hr2hx_extensions`
    Profilo
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.5 ms
    System lock0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Opening tables0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Sending data0.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    removing tmp table0.3 ms
    closing tables0.0 ms
    freeing items0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/table/table.php:237
    JROOT/libraries/joomla/table/table.php:158
    JROOT/libraries/joomla/table/extension.php:31
    JROOT/libraries/joomla/table/table.php:301
    JROOT/plugins/system/roksprocket/roksprocket.php:46
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/cms.php:583
    JROOT/libraries/cms/application/site.php:649
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  16. Tempo della query: 0.57 ms Dopo l'ultima query: 3.89 ms Memoria query: 0.014 MB memoria prima della query: 5.897 MB Righe restituite: 1
    SELECT `extension_id`
    
      FROM `hr2hx_extensions`
      WHERE type = 'component'
      AND element = 'com_roksprocket'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid302const1Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.1 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/table/extension.php:108
    JROOT/plugins/system/roksprocket/roksprocket.php:50
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/cms.php:583
    JROOT/libraries/cms/application/site.php:649
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  17. Tempo della query: 0.57 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.014 MB memoria prima della query: 5.916 MB Righe restituite: 1
    Query duplicate: #19
    SELECT *
    
      FROM hr2hx_extensions
      WHERE `extension_id` = '10010'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_extensionsconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.3 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/table/table.php:723
    JROOT/plugins/system/roksprocket/roksprocket.php:55
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/cms.php:583
    JROOT/libraries/cms/application/site.php:649
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  18. Tempo della query: 1.34 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.014 MB memoria prima della query: 5.930 MB Righe restituite: 1
    SELECT `extension_id`
    
      FROM `hr2hx_extensions`
      WHERE type = 'module'
      AND element = 'mod_roksprocket'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid302const1Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.1 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.1 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/table/extension.php:108
    JROOT/plugins/system/roksprocket/roksprocket.php:73
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/cms.php:583
    JROOT/libraries/cms/application/site.php:649
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  19. Tempo della query: 0.38 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.014 MB memoria prima della query: 5.946 MB Righe restituite: 1
    Query duplicate: #17
    SELECT *
    
      FROM hr2hx_extensions
      WHERE `extension_id` = '10010'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_extensionsconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking privileges on cached 0.0 ms
    checking permissions0.0 ms
    sending cached result to clien0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/table/table.php:723
    JROOT/plugins/system/roksprocket/roksprocket.php:77
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/cms.php:583
    JROOT/libraries/cms/application/site.php:649
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  20. Tempo della query: 1.18 ms Dopo l'ultima query: 247.00 ms Memoria query: 0.018 MB memoria prima della query: 6.932 MB Righe restituite: 10
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM hr2hx_menu AS m
      LEFT JOIN hr2hx_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const11Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4Sql875898_1.m.component_id1
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sorting result0.1 ms
    Sending data0.2 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.1 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/menu/site.php:47
    JROOT/libraries/cms/menu/menu.php:64
    JROOT/libraries/cms/menu/menu.php:118
    JROOT/libraries/cms/application/cms.php:353
    JROOT/libraries/cms/application/site.php:279
    JROOT/libraries/cms/router/site.php:218
    JROOT/libraries/cms/router/router.php:408
    JROOT/libraries/cms/router/router.php:192
    JROOT/libraries/cms/router/site.php:90
    JROOT/libraries/cms/application/cms.php:1018
    JROOT/libraries/cms/application/site.php:749
    JROOT/libraries/cms/application/site.php:231
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  21. Tempo della query: 1.45 ms Dopo l'ultima query: 4.41 ms Memoria query: 0.025 MB memoria prima della query: 7.139 MB Righe restituite: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM hr2hx_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid302const1Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/components/com_content/router.php:37
    JROOT/libraries/cms/router/site.php:463
    JROOT/libraries/cms/router/site.php:426
    JROOT/libraries/cms/router/router.php:231
    JROOT/libraries/cms/router/site.php:106
    JROOT/libraries/joomla/application/route.php:64
    JROOT/plugins/system/sef/sef.php:49
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/cms.php:1027
    JROOT/libraries/cms/application/site.php:749
    JROOT/libraries/cms/application/site.php:231
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  22. Tempo della query: 1.91 ms Dopo l'ultima query: 1.31 ms Memoria query: 0.009 MB memoria prima della query: 7.206 MB Righe restituite: 2
    SELECT *
    
      FROM hr2hx_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_languagesALLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL2Using where; Using filesort
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.1 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sorting result0.1 ms
    Sending data0.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/language/helper.php:166
    JROOT/libraries/cms/application/site.php:336
    JROOT/libraries/cms/application/site.php:135
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  23. Tempo della query: 2.13 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.008 MB memoria prima della query: 7.230 MB Righe restituite: 3
    SELECT id, home, template, s.params
    
      FROM hr2hx_template_styles as s
      LEFT JOIN hr2hx_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsALLidx_templateNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL5Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid303Sql875898_1.s.template,const1Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.1 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/application/site.php:486
    JROOT/libraries/cms/application/site.php:165
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  24. Tempo della query: 0.62 ms Dopo l'ultima query: 23.51 ms Memoria query: 0.022 MB memoria prima della query: 8.016 MB Righe restituite: 1
    SELECT a.rules
    
      FROM hr2hx_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id, a.rules, a.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/access/access.php:248
    JROOT/libraries/joomla/user/user.php:364
    JROOT/components/com_content/models/category.php:137
    JROOT/libraries/legacy/model/legacy.php:415
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:107
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  25. Tempo della query: 1.61 ms Dopo l'ultima query: 1.76 ms Memoria query: 0.024 MB memoria prima della query: 8.073 MB Righe restituite: 3
    SELECT b.rules
    
      FROM hr2hx_assets AS a
      LEFT JOIN hr2hx_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.name = 'com_content.category.2')
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstidx_asset_nameidx_asset_name152const1Using temporary; Using filesort
    1SIMPLEbrangeidx_lft_rgtidx_lft_rgt4NULL12Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    Creating tmp table0.5 ms
    executing0.0 ms
    Copying to tmp table0.1 ms
    Sorting result0.1 ms
    Sending data0.0 ms
    end0.0 ms
    removing tmp table0.2 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/access/access.php:248
    JROOT/libraries/joomla/access/access.php:109
    JROOT/libraries/joomla/user/user.php:373
    JROOT/components/com_content/models/category.php:137
    JROOT/libraries/legacy/model/legacy.php:415
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:107
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  26. Tempo della query: 9.26 ms Dopo l'ultima query: 3.32 ms Memoria query: 0.022 MB memoria prima della query: 8.220 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 hr2hx_categories as c
      LEFT JOIN hr2hx_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 (SELECT cat.id as id
      FROM hr2hx_categories AS cat JOIN hr2hx_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN `hr2hx_content` AS i
      ON i.`catid` = c.id
      AND i.state = 1
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id=2
      AND badcats.id is null
      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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL0const row not found
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1Using temporary; Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_rightNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL9Using where
    1PRIMARYirefidx_state,idx_catididx_catid4Sql875898_1.c.id10
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL9Using where; Using index; Using join buffer
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.4 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing3.3 ms
    Creating tmp table0.0 ms
    executing0.0 ms
    Copying to tmp table0.1 ms
    Sorting result0.0 ms
    Sending data0.0 ms
    removing tmp table0.0 ms
    Sending data0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    Sending data0.1 ms
    init0.2 ms
    optimizing0.0 ms
    statistics0.2 ms
    preparing0.1 ms
    Creating tmp table0.7 ms
    executing0.0 ms
    Copying to tmp table2.6 ms
    Sorting result0.1 ms
    Sending data0.1 ms
    end0.0 ms
    removing tmp table0.4 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    removing tmp table0.0 ms
    closing tables0.1 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/legacy/categories/categories.php:288
    JROOT/libraries/legacy/categories/categories.php:181
    JROOT/components/com_content/models/category.php:336
    JROOT/components/com_content/models/category.php:224
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  27. Tempo della query: 1.91 ms Dopo l'ultima query: 3.64 ms Memoria query: 0.027 MB memoria prima della query: 8.415 MB Righe restituite: 2
    SELECT b.rules
    
      FROM hr2hx_assets AS a
      LEFT JOIN hr2hx_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.name = 'com_content')
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstidx_asset_nameidx_asset_name152const1Using temporary; Using filesort
    1SIMPLEbrangeidx_lft_rgtidx_lft_rgt4NULL11Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    Creating tmp table0.5 ms
    executing0.0 ms
    Copying to tmp table0.1 ms
    Sorting result0.1 ms
    Sending data0.0 ms
    end0.0 ms
    removing tmp table0.5 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.2 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/access/access.php:248
    JROOT/libraries/joomla/access/access.php:109
    JROOT/libraries/joomla/user/user.php:373
    JROOT/components/com_content/models/articles.php:449
    JROOT/libraries/legacy/model/list.php:131
    JROOT/libraries/legacy/model/list.php:183
    JROOT/components/com_content/models/articles.php:537
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  28. Tempo della query: 6.93 ms Dopo l'ultima query: 0.49 ms Memoria query: 0.022 MB memoria prima della query: 8.447 MB Righe restituite: 10
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM hr2hx_content AS a
      LEFT JOIN hr2hx_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN hr2hx_categories AS c
      ON c.id = a.catid
      LEFT JOIN hr2hx_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN hr2hx_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN hr2hx_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN hr2hx_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM hr2hx_categories AS cat JOIN hr2hx_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 2
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-05-09 03:30:56')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-05-09 03:30:56')
      ORDER BY c.lft,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
      LIMIT 0, 10
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL0const row not found
    1PRIMARYcconstPRIMARY,idx_accessPRIMARY4const1Using filesort
    1PRIMARYarefidx_access,idx_catididx_catid4const45Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4Sql875898_1.a.created_by1
    1PRIMARYuameq_refPRIMARYPRIMARY4Sql875898_1.a.modified_by1
    1PRIMARYfpeq_refPRIMARYPRIMARY4Sql875898_1.a.id1Using index
    1PRIMARYparenteq_refPRIMARYPRIMARY4const1
    1PRIMARYveq_refPRIMARYPRIMARY4Sql875898_1.a.id1
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL9Using where; Using index; Using join buffer
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.4 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.1 ms
    System lock0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing3.0 ms
    Creating tmp table0.0 ms
    executing0.0 ms
    Copying to tmp table0.1 ms
    Sorting result0.0 ms
    Sending data0.0 ms
    removing tmp table0.0 ms
    Sending data0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    Sending data0.2 ms
    init0.3 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.1 ms
    executing0.0 ms
    Sorting result0.4 ms
    Sending data1.2 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    Sending data0.2 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    removing tmp table0.0 ms
    closing tables0.1 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.1 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/legacy/model/legacy.php:301
    JROOT/libraries/legacy/model/list.php:187
    JROOT/components/com_content/models/articles.php:537
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  29. Tempo della query: 0.73 ms Dopo l'ultima query: 5.73 ms Memoria query: 0.026 MB memoria prima della query: 8.801 MB Righe restituite: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM hr2hx_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid302const1Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/libraries/cms/helper/tags.php:392
    JROOT/components/com_content/models/articles.php:663
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  30. Tempo della query: 1.29 ms Dopo l'ultima query: 0.42 ms Memoria query: 0.021 MB memoria prima della query: 8.816 MB Righe restituite: 3
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 59
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL12Using where
    1SIMPLEmrefidx_tag_type,idx_tagidx_tag_type4Sql875898_1.t.id5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.5 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.1 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  31. Tempo della query: 1.25 ms Dopo l'ultima query: 0.96 ms Memoria query: 0.021 MB memoria prima della query: 8.874 MB Righe restituite: 3
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 57
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL12Using where
    1SIMPLEmrefidx_tag_type,idx_tagidx_tag_type4Sql875898_1.t.id5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.4 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  32. Tempo della query: 1.33 ms Dopo l'ultima query: 0.86 ms Memoria query: 0.021 MB memoria prima della query: 8.932 MB Righe restituite: 3
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 56
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL12Using where
    1SIMPLEmrefidx_tag_type,idx_tagidx_tag_type4Sql875898_1.t.id5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.5 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  33. Tempo della query: 1.26 ms Dopo l'ultima query: 0.97 ms Memoria query: 0.022 MB memoria prima della query: 8.991 MB Righe restituite: 1
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 55
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL12Using where
    1SIMPLEmrefidx_tag_type,idx_tagidx_tag_type4Sql875898_1.t.id5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.4 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  34. Tempo della query: 1.15 ms Dopo l'ultima query: 0.84 ms Memoria query: 0.021 MB memoria prima della query: 9.037 MB Righe restituite: 1
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 54
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL12Using where
    1SIMPLEmrefidx_tag_type,idx_tagidx_tag_type4Sql875898_1.t.id5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.4 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  35. Tempo della query: 1.35 ms Dopo l'ultima query: 0.84 ms Memoria query: 0.021 MB memoria prima della query: 9.082 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 53
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL12Using where
    1SIMPLEmrefidx_tag_type,idx_tagidx_tag_type4Sql875898_1.t.id5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.5 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.1 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  36. Tempo della query: 1.18 ms Dopo l'ultima query: 0.75 ms Memoria query: 0.021 MB memoria prima della query: 9.122 MB Righe restituite: 1
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 52
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL12Using where
    1SIMPLEmrefidx_tag_type,idx_tagidx_tag_type4Sql875898_1.t.id5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.1 ms
    init0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.4 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.2 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  37. Tempo della query: 1.15 ms Dopo l'ultima query: 0.82 ms Memoria query: 0.021 MB memoria prima della query: 9.167 MB Righe restituite: 1
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 51
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL12Using where
    1SIMPLEmrefidx_tag_type,idx_tagidx_tag_type4Sql875898_1.t.id5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.4 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.1 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  38. Tempo della query: 1.19 ms Dopo l'ultima query: 0.79 ms Memoria query: 0.021 MB memoria prima della query: 9.213 MB Righe restituite: 2
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 50
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL12Using where
    1SIMPLEmrefidx_tag_type,idx_tagidx_tag_type4Sql875898_1.t.id5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.4 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.2 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  39. Tempo della query: 1.45 ms Dopo l'ultima query: 0.86 ms Memoria query: 0.021 MB memoria prima della query: 9.265 MB Righe restituite: 3
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 49
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL12Using where
    1SIMPLEmrefidx_tag_type,idx_tagidx_tag_type4Sql875898_1.t.id5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.2 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.1 ms
    init0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.5 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.1 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/components/com_content/models/category.php:244
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  40. Tempo della query: 5.24 ms Dopo l'ultima query: 3.19 ms Memoria query: 0.022 MB memoria prima della query: 9.445 MB Righe restituite: 1
    SELECT COUNT(*)
    
      FROM hr2hx_content AS a
      LEFT JOIN hr2hx_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN hr2hx_categories AS c
      ON c.id = a.catid
      LEFT JOIN hr2hx_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN hr2hx_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN hr2hx_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN hr2hx_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM hr2hx_categories AS cat JOIN hr2hx_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 2
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-05-09 03:30:56')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-05-09 03:30:56')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL0const row not found
    1PRIMARYcconstPRIMARY,idx_accessPRIMARY4const1
    1PRIMARYarefidx_access,idx_catididx_catid4const45Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4Sql875898_1.a.created_by1Using index
    1PRIMARYuameq_refPRIMARYPRIMARY4Sql875898_1.a.modified_by1Using index
    1PRIMARYfpeq_refPRIMARYPRIMARY4Sql875898_1.a.id1Using index
    1PRIMARYparenteq_refPRIMARYPRIMARY4const1Using index
    1PRIMARYveq_refPRIMARYPRIMARY4Sql875898_1.a.id1Using index
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL9Using where; Using index; Using join buffer
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.2 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing3.3 ms
    Creating tmp table0.0 ms
    executing0.0 ms
    Copying to tmp table0.1 ms
    Sorting result0.0 ms
    Sending data0.0 ms
    removing tmp table0.0 ms
    Sending data0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    Sending data0.1 ms
    init0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.5 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    removing tmp table0.0 ms
    closing tables0.1 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/legacy/model/legacy.php:327
    JROOT/libraries/legacy/model/list.php:292
    JROOT/libraries/legacy/model/list.php:237
    JROOT/components/com_content/models/category.php:256
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/libraries/legacy/view/category.php:108
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  41. Tempo della query: 1.26 ms Dopo l'ultima query: 0.68 ms Memoria query: 0.018 MB memoria prima della query: 9.451 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 2
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL12Using where
    1SIMPLEmrefidx_tag_type,idx_tagidx_tag_type4Sql875898_1.t.id5Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    init0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.4 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.1 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/libraries/legacy/view/category.php:179
    JROOT/components/com_content/views/category/view.html.php:72
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  42. Tempo della query: 5.27 ms Dopo l'ultima query: 89.30 ms Memoria query: 0.030 MB memoria prima della query: 10.944 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 hr2hx_categories as c
      LEFT JOIN hr2hx_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 (SELECT cat.id as id
      FROM hr2hx_categories AS cat JOIN hr2hx_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id=2
      AND badcats.id is null
      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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARY<derived2>systemNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL0const row not found
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_rightNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL9Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2Using where; Using temporary; Using filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL9Using where; Using index; Using join buffer
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.3 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing3.1 ms
    Creating tmp table0.1 ms
    executing0.0 ms
    Copying to tmp table0.1 ms
    Sorting result0.1 ms
    Sending data0.0 ms
    removing tmp table0.0 ms
    Sending data0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    Sending data0.1 ms
    init0.2 ms
    optimizing0.0 ms
    statistics0.2 ms
    preparing0.0 ms
    executing0.0 ms
    Sorting result0.1 ms
    Sending data0.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    removing tmp table0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.2 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/legacy/categories/categories.php:288
    JROOT/libraries/legacy/categories/categories.php:181
    JROOT/components/com_content/helpers/route.php:41
    JROOT/components/com_content/views/category/tmpl/default_articles.php:114
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/layouts/joomla/content/category_default.php:52
    JROOT/libraries/cms/layout/file.php:97
    JROOT/libraries/cms/layout/helper.php:50
    JROOT/components/com_content/views/category/tmpl/default.php:20
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/libraries/legacy/view/category.php:195
    JROOT/components/com_content/views/category/view.html.php:260
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_content/controller.php:79
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_content/content.php:38
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/site.php:191
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  43. Tempo della query: 1.17 ms Dopo l'ultima query: 12.11 ms Memoria query: 0.015 MB memoria prima della query: 11.006 MB Righe restituite: 1
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM hr2hx_modules AS m
      LEFT JOIN hr2hx_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN hr2hx_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 <= '2025-05-09 03:30:56')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-05-09 03:30:56')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 109 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const6Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4Sql875898_1.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid303Sql875898_1.m.module,const1Using where
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.1 ms
    init0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.1 ms
    executing0.0 ms
    Sorting result0.1 ms
    Sending data0.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.0 ms
    freeing items0.0 ms
    storing result in query cache0.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/module/helper.php:385
    JROOT/libraries/cms/module/helper.php:84
    JROOT/libraries/joomla/document/html/html.php:497
    JROOT/templates/santoriello/index.php:125
    JROOT/libraries/joomla/document/html/html.php:576
    JROOT/libraries/joomla/document/html/html.php:634
    JROOT/libraries/joomla/document/html/html.php:452
    JROOT/libraries/cms/application/cms.php:974
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  44. Tempo della query: 0.68 ms Dopo l'ultima query: 31.18 ms Memoria query: 0.003 MB memoria prima della query: 11.327 MB
    UPDATE `hr2hx_session`
    
      SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1746761455;s:18:\"session.timer.last\";i:1746761455;s:17:\"session.timer.now\";i:1746761455;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1746761456'
      WHERE `session_id` = 'p676s5khvhvfr9f2914psfe7a6'
    Explain
    EXPLAIN non possibile sulla query: UPDATE `hr2hx_session` SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1746761455;s:18:\"session.timer.last\";i:1746761455;s:17:\"session.timer.now\";i:1746761455;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1746761456' WHERE `session_id` = 'p676s5khvhvfr9f2914psfe7a6'
    Profilo
    StatusDuration
    starting0.1 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    init0.0 ms
    Updating0.1 ms
    end0.0 ms
    Waiting for query cache lock0.0 ms
    end0.0 ms
    query end0.1 ms
    closing tables0.0 ms
    freeing items0.1 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/session/storage/database.php:85
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

26 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:
  1. 11 × SELECT `m`.`tag_id`,`t`.* 
      FROM `hr2hx_contentitem_tag_map` AS m
      INNER JOIN `hr2hx_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  2. 5 × SELECT extension_id AS id, element AS "option", params, enabled 
      FROM hr2hx_extensions
  3. 2 × SELECT * 
      FROM hr2hx_extensions
  4. 2 × SELECT b.rules 
      FROM hr2hx_assets AS a
      LEFT JOIN hr2hx_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  5. 2 × SELECT `extension_id` 
      FROM `hr2hx_extensions`
  6. 2 × SELECT template 
      FROM hr2hx_template_styles as s
  7. 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 hr2hx_categories as c
      LEFT JOIN hr2hx_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 (SELECT cat.id as id
      FROM hr2hx_categories AS cat JOIN hr2hx_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  8. 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 hr2hx_categories as c
      LEFT JOIN hr2hx_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 (SELECT cat.id as id
      FROM hr2hx_categories AS cat JOIN hr2hx_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  9. 1 × SELECT COUNT(*) 
      FROM hr2hx_content AS a
      LEFT JOIN hr2hx_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN hr2hx_categories AS c
      ON c.id = a.catid
      LEFT JOIN hr2hx_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN hr2hx_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN hr2hx_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN hr2hx_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM hr2hx_categories AS cat JOIN hr2hx_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  10. 1 × SELECT a.rules 
      FROM hr2hx_assets AS a
  11. 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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM hr2hx_content AS a
      LEFT JOIN hr2hx_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN hr2hx_categories AS c
      ON c.id = a.catid
      LEFT JOIN hr2hx_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN hr2hx_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN hr2hx_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN hr2hx_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM hr2hx_categories AS cat JOIN hr2hx_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  12. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM hr2hx_modules AS m
      LEFT JOIN hr2hx_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN hr2hx_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  13. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM hr2hx_menu AS m
      LEFT JOIN hr2hx_extensions AS e
      ON m.component_id = e.extension_id
  14. 1 × SELECT id, rules 
      FROM `hr2hx_viewlevels
  15. 1 × SELECT b.id 
      FROM hr2hx_usergroups AS a
      LEFT JOIN hr2hx_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  16. 1 × SELECT `session_id` 
      FROM `hr2hx_session`
  17. 1 × SELECT folder AS type, element AS name, params 
      FROM hr2hx_extensions
  18. 1 × SELECT extension, file, type 
      FROM hr2hx_rokcommon_configs
  19. 1 × SELECT * 
      FROM hr2hx_languages
  20. 1 × SELECT `data` 
      FROM `hr2hx_session`
  21. 1 × SELECT id, home, template, s.params 
      FROM hr2hx_template_styles as s
      LEFT JOIN hr2hx_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
ALTRE tabelle:
  1. 1 × UPDATE `hr2hx_session` 
      SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1746761455;s:18:\"session.timer.last\";i:1746761455;s:17:\"session.timer.now\";i:1746761455;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1746761456'
  2. 1 × SHOW FULL COLUMNS 
      FROM `hr2hx_extensions
  3. 1 × UPDATE `hr2hx_extensions` 
      SET `params` = '{\"mediaversion\":\"e93badfd6e8ea162c059604a9d775e4b\"}'
  4. 1 × INSERT INTO `hr2hx_session` (`session_id`, `client_id`, `time`) 
      VALUES ('p676s5khvhvfr9f2914psfe7a6', 0, '1746761455'
  5. 1 × DELETE  
      FROM `hr2hx_session`