pinterest
behance
linkdin
facebook
instagram
mail
Alessandro Santoriello

Alessandro Santoriello

Visual Designer

Menù
  • Home
  • Progetti
  • Side Projects
  • About
Behance linkdin facebook instagram mail
  • Arena - IDoo Tags

  • Baleone

  • Freak Parade

  • Playground Day

  • Prowlers 2004-2014

  • Prowlers Pick

  • Tipico.tips

  • Wabi-Sabi Sushi Bar

  • Zoppas

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.690 MB / 0.69 MB Application: afterLoad
Tempo: 443.5 ms / 443.5 ms Memoria: 6.032 MB / 6.72 MB Application: afterInitialise
Tempo: 13.6 ms / 457.1 ms Memoria: 0.402 MB / 7.12 MB Application: afterRoute
Tempo: 125.6 ms / 582.8 ms Memoria: 3.313 MB / 10.44 MB Application: afterDispatch
Tempo: 6.4 ms / 589.2 ms Memoria: 0.168 MB / 10.61 MB Application: beforeRenderModule mod_menu (Menu Principale)
Tempo: 6.5 ms / 595.7 ms Memoria: 0.089 MB / 10.69 MB Application: afterRenderModule mod_menu (Menu Principale)
Tempo: 8.1 ms / 603.8 ms Memoria: 0.265 MB / 10.96 MB Application: afterRender

Query totali del database: 42.7 ms

Utilizzo memoria

11.73 MB (12.299.464 Bytes)

Query Database

38 query eseguite 42.7 ms


Trovati 6 duplicati!

2 duplicati: #10  #11
2 duplicati: #17  #19
2 duplicati: #29  #30
  1. Tempo della query: 0.50 ms Memoria query: 0.013 MB memoria prima della query: 2.294 MB Righe restituite: 0
    SELECT `data`
    
      FROM `hr2hx_session`
      WHERE `session_id` = 'lc4tm9q3q148fd37vuunl2gfk0'
    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.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/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.47 ms Dopo l'ultima query: 4.04 ms Memoria query: 0.008 MB memoria prima della query: 2.440 MB
    DELETE 
    
      FROM `hr2hx_session`
      WHERE `time` < '1746771235'
    Explain
    EXPLAIN non possibile sulla query: DELETE FROM `hr2hx_session` WHERE `time` < '1746771235'
    Profilo
    StatusDuration
    starting0.0 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.0 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.47 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.010 MB memoria prima della query: 2.452 MB Righe restituite: 0
    SELECT `session_id`
    
      FROM `hr2hx_session`
      WHERE `session_id` = 'lc4tm9q3q148fd37vuunl2gfk0'
      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.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/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.51 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 ('lc4tm9q3q148fd37vuunl2gfk0', 0, '1746772135')
    Explain
    EXPLAIN non possibile sulla query: INSERT INTO `hr2hx_session` (`session_id`, `client_id`, `time`) VALUES ('lc4tm9q3q148fd37vuunl2gfk0', 0, '1746772135')
    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.50 ms Dopo l'ultima query: 8.98 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.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.1 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.93 ms Dopo l'ultima query: 3.64 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.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.4 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.2 ms
    freeing items0.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.55 ms Dopo l'ultima query: 1.21 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.1 ms
    freeing items0.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: 0.83 ms Dopo l'ultima query: 0.31 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.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.2 ms
    Sending data0.1 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/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.61 ms Dopo l'ultima query: 0.62 ms Memoria query: 0.012 MB memoria prima della query: 3.085 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.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.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/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.55 ms Dopo l'ultima query: 45.14 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.31 ms Dopo l'ultima query: 0.15 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.81 ms Dopo l'ultima query: 18.21 ms Memoria query: 0.013 MB memoria prima della query: 4.289 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.2 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/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: 2.38 ms Dopo l'ultima query: 31.72 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.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.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: 1.47 ms Dopo l'ultima query: 0.48 ms Memoria query: 0.018 MB memoria prima della query: 5.075 MB
    UPDATE `hr2hx_extensions`
    
      SET `params` = '{\"mediaversion\":\"a5315df0d999afc0a1e7b953f5863dfc\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN non possibile sulla query: UPDATE `hr2hx_extensions` SET `params` = '{\"mediaversion\":\"a5315df0d999afc0a1e7b953f5863dfc\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profilo
    StatusDuration
    starting0.1 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.0 ms
    init0.1 ms
    Updating0.1 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/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: 2.91 ms Dopo l'ultima query: 19.04 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.9 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.1 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.1 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.7 ms
    closing tables0.0 ms
    freeing items0.1 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.89 ms Dopo l'ultima query: 2.85 ms Memoria query: 0.014 MB memoria prima della query: 5.898 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.1 ms
    checking query cache for query0.1 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    System lock0.1 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.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.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.64 ms Dopo l'ultima query: 0.25 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.1 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
    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: 0.34 ms Dopo l'ultima query: 0.38 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 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/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.37 ms Dopo l'ultima query: 0.24 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.13 ms Dopo l'ultima query: 257.18 ms Memoria query: 0.018 MB memoria prima della query: 6.933 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.1 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.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/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: 0.61 ms Dopo l'ultima query: 5.05 ms Memoria query: 0.025 MB memoria prima della query: 7.111 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.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/components/com_tags/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: 0.61 ms Dopo l'ultima query: 1.76 ms Memoria query: 0.009 MB memoria prima della query: 7.161 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.0 ms
    init0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sorting result0.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/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: 0.58 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.013 MB memoria prima della query: 7.195 MB Righe restituite: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM hr2hx_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_menus'
    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:363
    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]

  24. Tempo della query: 0.87 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.008 MB memoria prima della query: 7.200 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.0 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.2 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]

  25. Tempo della query: 1.10 ms Dopo l'ultima query: 27.05 ms Memoria query: 0.023 MB memoria prima della query: 8.027 MB Righe restituite: 15
    SELECT *
    
      FROM `hr2hx_content_types`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_content_typesALLNULLNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL15
    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.1 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.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.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/helper/tags.php:729
    JROOT/libraries/cms/helper/tags.php:563
    JROOT/components/com_tags/models/tag.php:147
    JROOT/libraries/legacy/model/list.php:131
    JROOT/libraries/legacy/model/list.php:183
    JROOT/components/com_tags/models/tag.php:85
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/components/com_tags/views/tag/view.html.php:51
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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: 3.65 ms Dopo l'ultima query: 0.49 ms Memoria query: 0.021 MB memoria prima della query: 8.053 MB Righe restituite: 9
    SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count,  MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
      CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
      CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
      FROM hr2hx_contentitem_tag_map AS m
      INNER JOIN hr2hx_ucm_content AS c
      ON m.type_alias = c.core_type_alias
      AND m.core_content_id = c.core_content_id
      AND c.core_state IN (1)
      AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2025-05-09 06:28:55')
      AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2025-05-09 06:28:55')
      INNER JOIN hr2hx_content_types AS ct
      ON ct.type_alias = m.type_alias
      LEFT JOIN hr2hx_users AS ua
      ON ua.id = c.core_created_user_id
      WHERE m.tag_id IN (6)
      AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category')
      AND c.core_access IN (0,1,5)
      GROUP BY m.type_alias, m.content_item_id, m.core_content_id
      ORDER BY MAX(`c`.`core_title`) ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmindex_mergeidx_tag_type,idx_tag,idx_core_content_ididx_tag,idx_tag_type4,4NULL1Using intersect(idx_tag,idx_tag_type); Using where; Using temporary; Using filesort
    1SIMPLEctrefidx_aliasidx_alias767Sql875898_1.m.type_alias1
    1SIMPLEceq_refPRIMARY,tag_idx,idx_access,idx_content_typePRIMARY4Sql875898_1.m.core_content_id1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4Sql875898_1.c.core_created_user_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.3 ms
    checking permissions0.0 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.2 ms
    optimizing0.0 ms
    statistics0.4 ms
    preparing0.1 ms
    Creating tmp table0.5 ms
    executing0.0 ms
    Copying to tmp table0.9 ms
    Sorting result0.1 ms
    Sending data0.2 ms
    end0.0 ms
    removing tmp table0.3 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/legacy/model/legacy.php:332
    JROOT/libraries/legacy/model/list.php:292
    JROOT/libraries/legacy/model/list.php:326
    JROOT/libraries/legacy/model/list.php:187
    JROOT/components/com_tags/models/tag.php:85
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/components/com_tags/views/tag/view.html.php:51
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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: 3.64 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.020 MB memoria prima della query: 8.077 MB Righe restituite: 9
    SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count,  MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
      CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
      CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
      FROM hr2hx_contentitem_tag_map AS m
      INNER JOIN hr2hx_ucm_content AS c
      ON m.type_alias = c.core_type_alias
      AND m.core_content_id = c.core_content_id
      AND c.core_state IN (1)
      AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2025-05-09 06:28:55')
      AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2025-05-09 06:28:55')
      INNER JOIN hr2hx_content_types AS ct
      ON ct.type_alias = m.type_alias
      LEFT JOIN hr2hx_users AS ua
      ON ua.id = c.core_created_user_id
      WHERE m.tag_id IN (6)
      AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category')
      AND c.core_access IN (0,1,5)
      GROUP BY m.type_alias, m.content_item_id, m.core_content_id
      ORDER BY MAX(`c`.`core_title`) ASC
      LIMIT 0, 20
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmindex_mergeidx_tag_type,idx_tag,idx_core_content_ididx_tag,idx_tag_type4,4NULL1Using intersect(idx_tag,idx_tag_type); Using where; Using temporary; Using filesort
    1SIMPLEctrefidx_aliasidx_alias767Sql875898_1.m.type_alias1
    1SIMPLEceq_refPRIMARY,tag_idx,idx_access,idx_content_typePRIMARY4Sql875898_1.m.core_content_id1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4Sql875898_1.c.core_created_user_id1
    Profilo
    StatusDuration
    starting0.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.1 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.0 ms
    Waiting for query cache lock0.0 ms
    Waiting on query cache mutex0.1 ms
    init0.1 ms
    optimizing0.0 ms
    statistics0.4 ms
    preparing0.1 ms
    Creating tmp table0.6 ms
    executing0.0 ms
    Copying to tmp table0.8 ms
    Sorting result0.1 ms
    Sending data0.2 ms
    end0.0 ms
    removing tmp table0.3 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/legacy/model/legacy.php:301
    JROOT/libraries/legacy/model/list.php:187
    JROOT/components/com_tags/models/tag.php:85
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/components/com_tags/views/tag/view.html.php:51
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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: 1.89 ms Dopo l'ultima query: 7.01 ms Memoria query: 0.024 MB memoria prima della query: 8.471 MB Righe restituite: 30
    SHOW FULL COLUMNS 
      FROM `hr2hx_tags`
    Explain
    EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `hr2hx_tags`
    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
    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.1 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.1 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/administrator/components/com_tags/tables/tag.php:28
    JROOT/libraries/joomla/table/table.php:301
    JROOT/components/com_tags/models/tag.php:276
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/components/com_tags/views/tag/view.html.php:52
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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: 1.17 ms Dopo l'ultima query: 5.76 ms Memoria query: 0.019 MB memoria prima della query: 8.626 MB Righe restituite: 1
    Query duplicate: #30
    SELECT *
    
      FROM hr2hx_tags
      WHERE `id` = '6'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_tagsconstPRIMARYPRIMARY4const1
    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.2 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/table.php:723
    JROOT/components/com_tags/models/tag.php:284
    JROOT/libraries/legacy/view/legacy.php:398
    JROOT/components/com_tags/views/tag/view.html.php:52
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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: 0.38 ms Dopo l'ultima query: 39.80 ms Memoria query: 0.018 MB memoria prima della query: 9.579 MB Righe restituite: 1
    Query duplicate: #29
    SELECT *
    
      FROM hr2hx_tags
      WHERE `id` = '6'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEhr2hx_tagsconstPRIMARYPRIMARY4const1
    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/components/com_tags/models/tag.php:328
    JROOT/components/com_tags/views/tag/view.html.php:181
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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: 0.58 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.016 MB memoria prima della query: 9.595 MB
    UPDATE hr2hx_tags
    
      SET `hits` = (`hits` + 1)
      WHERE `id` = '6'
    Explain
    EXPLAIN non possibile sulla query: UPDATE hr2hx_tags SET `hits` = (`hits` + 1) WHERE `id` = '6'
    Profilo
    StatusDuration
    starting0.0 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.0 ms
    logging slow query0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/table/table.php:1233
    JROOT/components/com_tags/models/tag.php:329
    JROOT/components/com_tags/views/tag/view.html.php:181
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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: 0.32 ms Dopo l'ultima query: 7.30 ms Memoria query: 0.024 MB memoria prima della query: 9.733 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 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/access/access.php:248
    JROOT/libraries/joomla/user/user.php:364
    JROOT/templates/santoriello/html/com_tags/tag/default_items.php:22
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/components/com_tags/views/tag/tmpl/default.php:51
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/components/com_tags/views/tag/view.html.php:185
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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: 2.05 ms Dopo l'ultima query: 1.55 ms Memoria query: 0.025 MB memoria prima della query: 9.793 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_tags')
      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
    1SIMPLEbALLidx_lft_rgtNON E' POSSIBILE UTILIZZARE ALCUN INDICENULLNULL119
    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.6 ms
    executing0.0 ms
    Copying to tmp table0.3 ms
    Sorting result0.0 ms
    Sending data0.0 ms
    end0.0 ms
    removing tmp table0.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/joomla/access/access.php:248
    JROOT/libraries/joomla/access/access.php:109
    JROOT/libraries/joomla/user/user.php:373
    JROOT/templates/santoriello/html/com_tags/tag/default_items.php:22
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/components/com_tags/views/tag/tmpl/default.php:51
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/components/com_tags/views/tag/view.html.php:185
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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: 0.42 ms Dopo l'ultima query: 4.50 ms Memoria query: 0.026 MB memoria prima della query: 10.078 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.0 ms
    checking privileges on cached 0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.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/legacy/categories/categories.php:288
    JROOT/libraries/legacy/categories/categories.php:181
    JROOT/components/com_content/helpers/route.php:41
    JROOT/components/com_tags/helpers/route.php:56
    JROOT/templates/santoriello/html/com_tags/tag/default_items.php:70
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/components/com_tags/views/tag/tmpl/default.php:51
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/components/com_tags/views/tag/view.html.php:185
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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: 0.33 ms Dopo l'ultima query: 0.39 ms Memoria query: 0.029 MB memoria prima della query: 10.134 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 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/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/components/com_content/helpers/route.php:161
    JROOT/components/com_content/helpers/route.php:62
    JROOT/components/com_tags/helpers/route.php:56
    JROOT/templates/santoriello/html/com_tags/tag/default_items.php:70
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/components/com_tags/views/tag/tmpl/default.php:51
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/components/com_tags/views/tag/view.html.php:185
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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: 4.88 ms Dopo l'ultima query: 3.45 ms Memoria query: 0.026 MB memoria prima della query: 10.367 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=9
      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.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.1 ms
    init0.1 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.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.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/categories/categories.php:288
    JROOT/libraries/legacy/categories/categories.php:181
    JROOT/components/com_content/helpers/route.php:41
    JROOT/components/com_tags/helpers/route.php:56
    JROOT/templates/santoriello/html/com_tags/tag/default_items.php:70
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/components/com_tags/views/tag/tmpl/default.php:51
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/components/com_tags/views/tag/view.html.php:185
    JROOT/libraries/legacy/controller/legacy.php:693
    JROOT/components/com_tags/controller.php:54
    JROOT/libraries/legacy/controller/legacy.php:730
    JROOT/components/com_tags/tags.php:15
    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.77 ms Dopo l'ultima query: 5.53 ms Memoria query: 0.015 MB memoria prima della query: 10.572 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 06:28:55')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-05-09 06:28:55')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 0 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.0 ms
    init0.1 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.1 ms
    executing0.0 ms
    Sorting result0.1 ms
    Sending data0.2 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.1 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/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]

  38. Tempo della query: 0.69 ms Dopo l'ultima query: 17.41 ms Memoria query: 0.003 MB memoria prima della query: 10.949 MB
    UPDATE `hr2hx_session`
    
      SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1746772135;s:18:\"session.timer.last\";i:1746772135;s:17:\"session.timer.now\";i:1746772135;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` = '1746772135'
      WHERE `session_id` = 'lc4tm9q3q148fd37vuunl2gfk0'
    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:1746772135;s:18:\"session.timer.last\";i:1746772135;s:17:\"session.timer.now\";i:1746772135;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` = '1746772135' WHERE `session_id` = 'lc4tm9q3q148fd37vuunl2gfk0'
    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]

27 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:
  1. 6 × SELECT extension_id AS id, element AS "option", params, enabled 
      FROM hr2hx_extensions
  2. 2 × SELECT `extension_id` 
      FROM `hr2hx_extensions`
  3. 2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count,  MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
      CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
      CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
      FROM hr2hx_contentitem_tag_map AS m
      INNER JOIN hr2hx_ucm_content AS c
      ON m.type_alias = c.core_type_alias
      AND m.core_content_id = c.core_content_id
      AND c.core_state IN (1)
      AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2025-05-09 06:28:55')
      AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2025-05-09 06:28:55')
      INNER JOIN hr2hx_content_types AS ct
      ON ct.type_alias = m.type_alias
      LEFT JOIN hr2hx_users AS ua
      ON ua.id = c.core_created_user_id
  4. 2 × SELECT * 
      FROM hr2hx_tags
  5. 2 × SELECT template 
      FROM hr2hx_template_styles as s
  6. 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
  7. 2 × SELECT * 
      FROM hr2hx_extensions
  8. 1 × SELECT a.rules 
      FROM hr2hx_assets AS a
  9. 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
  10. 1 × SELECT b.rules 
      FROM hr2hx_assets AS a
      LEFT JOIN hr2hx_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  11. 1 × SELECT `session_id` 
      FROM `hr2hx_session`
  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 id, rules 
      FROM `hr2hx_viewlevels
  14. 1 × SELECT * 
      FROM `hr2hx_content_types
  15. 1 × SELECT `data` 
      FROM `hr2hx_session`
  16. 1 × SELECT folder AS type, element AS name, params 
      FROM hr2hx_extensions
  17. 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
  18. 1 × SELECT * 
      FROM hr2hx_languages
  19. 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
  20. 1 × SELECT extension, file, type 
      FROM hr2hx_rokcommon_configs
ALTRE tabelle:
  1. 1 × UPDATE hr2hx_tags 
      SET `hits` = (`hits` + 1)
  2. 1 × UPDATE `hr2hx_session` 
      SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1746772135;s:18:\"session.timer.last\";i:1746772135;s:17:\"session.timer.now\";i:1746772135;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` = '1746772135'
  3. 1 × SHOW FULL COLUMNS 
      FROM `hr2hx_tags
  4. 1 × SHOW FULL COLUMNS 
      FROM `hr2hx_extensions
  5. 1 × INSERT INTO `hr2hx_session` (`session_id`, `client_id`, `time`) 
      VALUES ('lc4tm9q3q148fd37vuunl2gfk0', 0, '1746772135'
  6. 1 × UPDATE `hr2hx_extensions` 
      SET `params` = '{\"mediaversion\":\"a5315df0d999afc0a1e7b953f5863dfc\"}'
  7. 1 × DELETE  
      FROM `hr2hx_session`