Voci di Pace

Voci di Pace

Menu
  • Home
  • About
      • Storia
      • Il gruppo
  • Gallery
  • News
  • Dicono di noi
  • Contatti

Voci di Pace

  • La nostra esperienza
  • Concerti
  • Tour natalizio
  • Rassegne corali
  • Matrimoni
  • Chi siamo
  • Storia

Contacts

Mobile: +39 328/0115304

E-mail: info@corovocidipace.it
corovocidipace@gmail.com

Location

87019 Spezzano Albanese
Italy

Get Directions

Voci di Pace © 2025 • Privacy policy

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1750489351,
                "last": 1750489351,
                "now": 1750489351
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 24.40 ms / 24.40 ms Memoria: 0.409 MB / 0.75 MB Application: afterLoad
Tempo: 86.72 ms / 111.11 ms Memoria: 0.995 MB / 1.75 MB Application: afterInitialise
Tempo: 16.71 ms / 127.82 ms Memoria: 0.357 MB / 2.11 MB Application: afterRoute
Tempo: 16.75 ms / 144.57 ms Memoria: 0.078 MB / 2.18 MB Application: beforeRenderComponent com_content
Tempo: 7.66 ms / 152.23 ms Memoria: 0.235 MB / 2.42 MB Application: Before Access::preloadComponents (all components)
Tempo: 7.85 ms / 160.08 ms Memoria: 0.057 MB / 2.48 MB Application: After Access::preloadComponents (all components)
Tempo: 0.04 ms / 160.12 ms Memoria: -0.004 MB / 2.47 MB Application: Before Access::preloadPermissions (com_content)
Tempo: 2.13 ms / 162.26 ms Memoria: 0.179 MB / 2.65 MB Application: After Access::preloadPermissions (com_content)
Tempo: 0.04 ms / 162.30 ms Memoria: -0.011 MB / 2.64 MB Application: Before Access::getAssetRules (id:64 name:com_content.category.8)
Tempo: 0.96 ms / 163.26 ms Memoria: 0.009 MB / 2.65 MB Application: After Access::getAssetRules (id:64 name:com_content.category.8)
Tempo: 29.03 ms / 192.29 ms Memoria: 0.064 MB / 2.71 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Tempo: 0.14 ms / 192.43 ms Memoria: 0.007 MB / 2.72 MB Application: After Access::getAssetRules (id:8 name:com_content)
Tempo: 98.54 ms / 290.97 ms Memoria: 0.485 MB / 3.20 MB Application: afterRenderComponent com_content
Tempo: 3.97 ms / 294.94 ms Memoria: 0.008 MB / 3.21 MB Application: afterDispatch
Tempo: 27.16 ms / 322.10 ms Memoria: 0.087 MB / 3.30 MB Application: beforeRenderModule mod_articles_single (footer link)
Tempo: 1.67 ms / 323.78 ms Memoria: 0.036 MB / 3.33 MB Application: Before Access::getAssetRules (id:393 name:com_content.article.134)
Tempo: 0.08 ms / 323.85 ms Memoria: 0.007 MB / 3.34 MB Application: After Access::getAssetRules (id:393 name:com_content.article.134)
Tempo: 8.02 ms / 331.87 ms Memoria: 0.056 MB / 3.40 MB Application: afterRenderModule mod_articles_single (footer link)
Tempo: 0.08 ms / 331.95 ms Memoria: -0.018 MB / 3.38 MB Application: beforeRenderModule mod_menu (Voci di Pace)
Tempo: 3.27 ms / 335.21 ms Memoria: 0.051 MB / 3.43 MB Application: afterRenderModule mod_menu (Voci di Pace)
Tempo: 0.04 ms / 335.25 ms Memoria: -0.003 MB / 3.43 MB Application: beforeRenderModule mod_articles_single (Contacts)
Tempo: 0.33 ms / 335.59 ms Memoria: 0.026 MB / 3.45 MB Application: Before Access::getAssetRules (id:362 name:com_content.article.114)
Tempo: 0.02 ms / 335.61 ms Memoria: 0.002 MB / 3.45 MB Application: After Access::getAssetRules (id:362 name:com_content.article.114)
Tempo: 4.36 ms / 339.97 ms Memoria: 0.025 MB / 3.48 MB Application: afterRenderModule mod_articles_single (Contacts)
Tempo: 0.06 ms / 340.03 ms Memoria: -0.016 MB / 3.46 MB Application: beforeRenderModule mod_articles_single (Location)
Tempo: 0.47 ms / 340.50 ms Memoria: 0.026 MB / 3.49 MB Application: Before Access::getAssetRules (id:364 name:com_content.article.115)
Tempo: 0.03 ms / 340.53 ms Memoria: 0.002 MB / 3.49 MB Application: After Access::getAssetRules (id:364 name:com_content.article.115)
Tempo: 4.71 ms / 345.24 ms Memoria: 0.023 MB / 3.51 MB Application: afterRenderModule mod_articles_single (Location)
Tempo: 0.09 ms / 345.33 ms Memoria: -0.017 MB / 3.50 MB Application: beforeRenderModule mod_menu (Social media)
Tempo: 5.23 ms / 350.56 ms Memoria: 0.023 MB / 3.52 MB Application: afterRenderModule mod_menu (Social media)
Tempo: 0.16 ms / 350.72 ms Memoria: -0.002 MB / 3.52 MB Application: beforeRenderModule mod_icemegamenu (IceMegaMenu Module)
Tempo: 17.84 ms / 368.56 ms Memoria: 0.230 MB / 3.75 MB Application: afterRenderModule mod_icemegamenu (IceMegaMenu Module)
Tempo: 3.22 ms / 371.78 ms Memoria: 0.038 MB / 3.78 MB Application: afterRender

Query totali del database: 166.40 ms

Utilizzo memoria

4,56 MB (4.785.600 Bytes)

Query Database

46 query eseguite 166.40 ms


  1. Tempo della query: 4.21 ms Memoria query: 0.023 MB memoria prima della query: 1.034 MB Righe restituite: 0
    SELECT `data`
    
      FROM `jm5sn_session`
      WHERE `session_id` = X'6f666e6674666d70756e64337034377332646b31616c6f70766e'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_sessionconstPRIMARYPRIMARY194const1
    Profilo
    StatusDuration
    Starting0.06 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics3.82 ms
    Preparing0.02 ms
    Executing0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Chiamata uguale alla linea sottostante.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:661
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:621
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:499
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:456
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:826
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  2. Tempo della query: 0.32 ms Dopo l'ultima query: 0.80 ms Memoria query: 0.020 MB memoria prima della query: 1.048 MB Righe restituite: 0
    SELECT `session_id`
    
      FROM `jm5sn_session`
      WHERE `session_id` = X'6f666e6674666d70756e64337034377332646b31616c6f70766e'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_sessionconstPRIMARYPRIMARY194const1Using index
    Profilo
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Executing0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  3. Tempo della query: 10.76 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.004 MB memoria prima della query: 1.053 MB
    INSERT INTO `jm5sn_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6f666e6674666d70756e64337034377332646b31616c6f70766e', 1, 1750489351, 0, '', 0)
    Explain
    EXPLAIN non possibile sulla query: INSERT INTO `jm5sn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6f666e6674666d70756e64337034377332646b31616c6f70766e', 1, 1750489351, 0, '', 0)
    Profilo
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init for update0.02 ms
    Update6.50 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit3.94 ms
    Query end0.02 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  4. Tempo della query: 11.07 ms Dopo l'ultima query: 2.05 ms Memoria query: 0.024 MB memoria prima della query: 1.084 MB Righe restituite: 39
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `jm5sn_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_extensionsrefextensionextension82const39Using index condition; Using where
    Profilo
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.60 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data9.97 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Chiamata uguale alla linea sottostante.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:594
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  5. Tempo della query: 3.35 ms Dopo l'ultima query: 3.34 ms Memoria query: 0.021 MB memoria prima della query: 1.121 MB Righe restituite: 5
    SELECT id, rules
    
      FROM `jm5sn_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_viewlevelsALLNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL5
    Profilo
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data2.97 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  6. Tempo della query: 6.08 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.021 MB memoria prima della query: 1.133 MB Righe restituite: 2
    SELECT b.id
    
      FROM jm5sn_usergroups AS a
      LEFT JOIN jm5sn_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_lookup4NULL2Using where; Using index
    Profilo
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics5.38 ms
    Preparing0.04 ms
    Unlocking tables0.02 ms
    Preparing0.06 ms
    Executing0.02 ms
    Sending data0.07 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.02 ms
    Updating status0.04 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  7. Tempo della query: 5.38 ms Dopo l'ultima query: 0.81 ms Memoria query: 0.030 MB memoria prima della query: 1.154 MB Righe restituite: 103
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM jm5sn_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_extensionsALLextensionNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL264Using where; Using filesort
    Profilo
    StatusDuration
    Starting0.12 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.07 ms
    Optimizing0.06 ms
    Statistics0.09 ms
    Preparing0.04 ms
    Sorting result0.02 ms
    Executing0.02 ms
    Sending data0.03 ms
    Creating sort index4.49 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:351
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Chiamata uguale alla linea sottostante.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:356
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  8. Tempo della query: 0.69 ms Dopo l'ultima query: 26.16 ms Memoria query: 0.022 MB memoria prima della query: 1.702 MB Righe restituite: 15
    SELECT * 
      FROM jm5sn_loginradius_settings
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_loginradius_settingsALLNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL15
    Profilo
    StatusDuration
    Starting0.09 ms
    checking permissions0.03 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Executing0.02 ms
    Sending data0.08 ms
    End of update loop0.02 ms
    Query end0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    10JDatabaseDriver->loadAssocList()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58
    9plgSystemSocialLoginTools::sociallogin_getsettings()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51
    8plgSystemSocialLoginAndSocialShare->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  9. Tempo della query: 6.98 ms Dopo l'ultima query: 3.54 ms Memoria query: 0.072 MB memoria prima della query: 1.779 MB Righe restituite: 48
    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 jm5sn_menu AS m
      LEFT JOIN jm5sn_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_language1const85Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4admin_vdp.m.component_id1Using where
    Profilo
    StatusDuration
    Starting0.17 ms
    checking permissions0.03 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.07 ms
    Optimizing0.06 ms
    Statistics1.01 ms
    Preparing0.08 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.05 ms
    Creating sort index5.16 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Chiamata uguale alla linea sottostante.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:78
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:142
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:417
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:65
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:533
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1141
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  10. Tempo della query: 6.66 ms Dopo l'ultima query: 8.41 ms Memoria query: 0.022 MB memoria prima della query: 2.123 MB Righe restituite: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `jm5sn_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profilo
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics6.15 ms
    Preparing0.05 ms
    Executing0.01 ms
    Sending data0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Chiamata uguale alla linea sottostante.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  11. Tempo della query: 0.49 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.005 MB memoria prima della query: 2.114 MB
    UPDATE `jm5sn_extensions`
    
      SET `params` = '{\"mediaversion\":\"362e8ede80d508f4a0ab89c035808804\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN non possibile sulla query: UPDATE `jm5sn_extensions` SET `params` = '{\"mediaversion\":\"362e8ede80d508f4a0ab89c035808804\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profilo
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init for update0.06 ms
    Updating0.06 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.10 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.02 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  12. Tempo della query: 1.74 ms Dopo l'ultima query: 1.19 ms Memoria query: 0.019 MB memoria prima della query: 2.142 MB Righe restituite: 2
    SELECT *
    
      FROM jm5sn_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_languagesALLNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL2Using where; Using filesort
    Profilo
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index1.25 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  13. Tempo della query: 4.40 ms Dopo l'ultima query: 0.37 ms Memoria query: 0.019 MB memoria prima della query: 2.161 MB Righe restituite: 3
    SELECT id, home, template, s.params
    
      FROM jm5sn_template_styles as s
      LEFT JOIN jm5sn_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
    1SIMPLEsrefidx_template,idx_client_id,idx_client_id_homeidx_client_id1const3
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403admin_vdp.s.template,const1Using index condition; Using where
    Profilo
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.03 ms
    Statistics3.73 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.29 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  14. Tempo della query: 7.49 ms Dopo l'ultima query: 9.06 ms Memoria query: 0.028 MB memoria prima della query: 2.422 MB Righe restituite: 39
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jm5sn_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jevents','com_joomgallery','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_socialloginandsocialshare','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_assetsrangeidx_asset_nameidx_asset_name202NULL40Using index condition
    Profilo
    StatusDuration
    Starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.06 ms
    Optimizing0.02 ms
    Statistics0.14 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data6.86 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    18Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  15. Tempo della query: 1.53 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.055 MB memoria prima della query: 2.473 MB Righe restituite: 184
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jm5sn_assets`
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_assetsALLidx_asset_name,idx_parent_idNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL514Using where
    Profilo
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.71 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.53 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    18Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  16. Tempo della query: 24.09 ms Dopo l'ultima query: 3.89 ms Memoria query: 0.032 MB memoria prima della query: 2.647 MB Righe restituite: 9
    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,( SELECT COUNT(i.`id`)
      FROM `jm5sn_content` AS `i`
      WHERE i.`catid` = c.id
      AND i.state = 1) AS numitems
      FROM `jm5sn_categories` AS `s`
      INNER JOIN `jm5sn_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.published = 1
      AND s.id = 8
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1
    1PRIMARYcALLcat_idx,idx_left_rightNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL47Using where; Using filesort
    2DEPENDENT SUBQUERYirefidx_state,idx_catididx_catid4admin_vdp.c.id1Using index condition; Using where
    Profilo
    StatusDuration
    Starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.02 ms
    table lock0.01 ms
    init0.06 ms
    Optimizing0.03 ms
    Statistics4.55 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.03 ms
    Optimizing0.02 ms
    Statistics0.34 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.09 ms
    Executing0.01 ms
    Sending data1.06 ms
    Executing0.01 ms
    Sending data2.81 ms
    Executing0.01 ms
    Sending data1.91 ms
    Executing0.01 ms
    Sending data3.78 ms
    Executing0.02 ms
    Sending data2.92 ms
    Executing0.02 ms
    Sending data2.65 ms
    Executing0.01 ms
    Sending data0.02 ms
    Executing0.01 ms
    Sending data3.09 ms
    Executing0.01 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Removing tmp table0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    15Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    14Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/models/category.php:355
    13ContentModelCategory->getCategory()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:122
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  17. Tempo della query: 20.47 ms Dopo l'ultima query: 2.85 ms Memoria query: 0.068 MB memoria prima della query: 2.717 MB Righe restituite: 12
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM jm5sn_content AS a
      LEFT JOIN jm5sn_categories AS c
      ON c.id = a.catid
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jm5sn_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jm5sn_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jm5sn_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.catid = 8 OR a.catid IN ( SELECT sub.id
      FROM jm5sn_categories as sub
      INNER JOIN jm5sn_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 8))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-21 07:02:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-21 07:02:32')
      ORDER BY c.lft, a.ordering, a.created
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcALLPRIMARY,idx_accessNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL47Using where; Using temporary; Using filesort
    1PRIMARYaref|filteridx_access,idx_state,idx_catididx_catid|idx_state4|1admin_vdp.c.id1 (38%)Using index condition; Using where; Using rowid filter
    1PRIMARYuaeq_refPRIMARYPRIMARY4admin_vdp.a.created_by1Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4admin_vdp.a.modified_by1Using where
    1PRIMARYparenteq_refPRIMARYPRIMARY4admin_vdp.c.parent_id1Using where
    1PRIMARYveq_refPRIMARYPRIMARY4admin_vdp.a.id1Using where
    2MATERIALIZEDthisconstPRIMARY,idx_left_rightPRIMARY4const1
    2MATERIALIZEDsubrangePRIMARY,idx_left_rightidx_left_right4NULL44Using where; Using index
    Profilo
    StatusDuration
    Starting0.15 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.08 ms
    Optimizing0.04 ms
    Statistics2.62 ms
    Preparing0.06 ms
    Optimizing0.02 ms
    Statistics0.08 ms
    Preparing0.04 ms
    Creating tmp table0.07 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data3.13 ms
    Executing0.02 ms
    Sending data13.54 ms
    Creating sort index0.12 ms
    Removing tmp table0.10 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Removing tmp table0.01 ms
    Freeing items0.02 ms
    Removing tmp table0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  18. Tempo della query: 1.49 ms Dopo l'ultima query: 3.46 ms Memoria query: 0.024 MB memoria prima della query: 2.918 MB Righe restituite: 1
    SELECT COUNT(*)
    
      FROM jm5sn_content AS a
      LEFT JOIN jm5sn_categories AS c
      ON c.id = a.catid
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jm5sn_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jm5sn_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jm5sn_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.catid = 8 OR a.catid IN ( SELECT sub.id
      FROM jm5sn_categories as sub
      INNER JOIN jm5sn_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 8))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-21 07:02:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-21 07:02:32')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcALLPRIMARY,idx_accessNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL47Using where
    1PRIMARYaref|filteridx_access,idx_state,idx_catididx_catid|idx_state4|1admin_vdp.c.id1 (38%)Using index condition; Using where; Using rowid filter
    2MATERIALIZEDthisconstPRIMARY,idx_left_rightPRIMARY4const1
    2MATERIALIZEDsubrangePRIMARY,idx_left_rightidx_left_right4NULL44Using where; Using index
    Profilo
    StatusDuration
    Starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.06 ms
    Optimizing0.05 ms
    Statistics0.11 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.05 ms
    Optimizing0.02 ms
    Statistics0.08 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.12 ms
    Executing0.01 ms
    Sending data0.39 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Removing tmp table0.01 ms
    Freeing items0.02 ms
    Removing tmp table0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    17JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:289
    15Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:239
    14Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  19. Tempo della query: 5.75 ms Dopo l'ultima query: 1.89 ms Memoria query: 0.022 MB memoria prima della query: 2.924 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jm5sn_contentitem_tag_map` AS m
      INNER JOIN `jm5sn_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 8
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL16Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4admin_vdp.m.tag_id1Using where
    Profilo
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics3.91 ms
    Preparing0.06 ms
    Executing0.01 ms
    Sending data1.22 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    12Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/libraries/src/MVC/View/CategoryView.php:229
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  20. Tempo della query: 1.06 ms Dopo l'ultima query: 6.24 ms Memoria query: 0.027 MB memoria prima della query: 3.029 MB Righe restituite: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jm5sn_categories` AS `s`
      INNER JOIN `jm5sn_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 18
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL4Using index condition; Using where
    Profilo
    StatusDuration
    Starting0.16 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.08 ms
    Optimizing0.05 ms
    Statistics0.14 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.05 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.12 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  21. Tempo della query: 5.07 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.025 MB memoria prima della query: 3.050 MB Righe restituite: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM jm5sn_fields AS a
      LEFT JOIN `jm5sn_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jm5sn_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jm5sn_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jm5sn_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jm5sn_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (18,0,8))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28admin_vdp.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4admin_vdp.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4admin_vdp.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4admin_vdp.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4admin_vdp.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4admin_vdp.a.id1Using where; Using index; Distinct
    Profilo
    StatusDuration
    Starting0.23 ms
    checking permissions0.02 ms
    Opening tables0.06 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.12 ms
    Optimizing0.09 ms
    Statistics3.56 ms
    Preparing0.08 ms
    Creating tmp table0.05 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.35 ms
    Creating sort index0.03 ms
    Removing tmp table0.09 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  22. Tempo della query: 0.96 ms Dopo l'ultima query: 7.13 ms Memoria query: 0.027 MB memoria prima della query: 3.089 MB Righe restituite: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jm5sn_categories` AS `s`
      INNER JOIN `jm5sn_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 41
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL8Using index condition; Using where
    Profilo
    StatusDuration
    Starting0.14 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.07 ms
    Optimizing0.05 ms
    Statistics0.13 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.04 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.11 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  23. Tempo della query: 1.50 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.025 MB memoria prima della query: 3.095 MB Righe restituite: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM jm5sn_fields AS a
      LEFT JOIN `jm5sn_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jm5sn_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jm5sn_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jm5sn_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jm5sn_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (41,0,8))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28admin_vdp.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4admin_vdp.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4admin_vdp.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4admin_vdp.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4admin_vdp.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4admin_vdp.a.id1Using where; Using index; Distinct
    Profilo
    StatusDuration
    Starting0.14 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.07 ms
    Optimizing0.06 ms
    Statistics0.13 ms
    Preparing0.06 ms
    Creating tmp table0.07 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.47 ms
    Creating sort index0.04 ms
    Removing tmp table0.11 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  24. Tempo della query: 1.18 ms Dopo l'ultima query: 4.82 ms Memoria query: 0.027 MB memoria prima della query: 3.116 MB Righe restituite: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jm5sn_categories` AS `s`
      INNER JOIN `jm5sn_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 42
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL9Using index condition; Using where
    Profilo
    StatusDuration
    Starting0.19 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.09 ms
    Optimizing0.06 ms
    Statistics0.17 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.06 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.14 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  25. Tempo della query: 1.93 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.025 MB memoria prima della query: 3.122 MB Righe restituite: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM jm5sn_fields AS a
      LEFT JOIN `jm5sn_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jm5sn_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jm5sn_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jm5sn_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jm5sn_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (42,0,8))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28admin_vdp.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4admin_vdp.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4admin_vdp.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4admin_vdp.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4admin_vdp.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4admin_vdp.a.id1Using where; Using index; Distinct
    Profilo
    StatusDuration
    Starting0.18 ms
    checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.10 ms
    Optimizing0.07 ms
    Statistics0.17 ms
    Preparing0.08 ms
    Creating tmp table0.09 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.62 ms
    Creating sort index0.05 ms
    Removing tmp table0.14 ms
    Creating sort index0.02 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  26. Tempo della query: 1.15 ms Dopo l'ultima query: 1.54 ms Memoria query: 0.027 MB memoria prima della query: 3.141 MB Righe restituite: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jm5sn_categories` AS `s`
      INNER JOIN `jm5sn_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 43
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL10Using index condition; Using where
    Profilo
    StatusDuration
    Starting0.17 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.09 ms
    Optimizing0.06 ms
    Statistics0.17 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.06 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.14 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  27. Tempo della query: 1.98 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.025 MB memoria prima della query: 3.147 MB Righe restituite: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM jm5sn_fields AS a
      LEFT JOIN `jm5sn_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jm5sn_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jm5sn_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jm5sn_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jm5sn_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (43,0,8))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28admin_vdp.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4admin_vdp.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4admin_vdp.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4admin_vdp.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4admin_vdp.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4admin_vdp.a.id1Using where; Using index; Distinct
    Profilo
    StatusDuration
    Starting0.18 ms
    checking permissions0.03 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.10 ms
    Optimizing0.07 ms
    Statistics0.17 ms
    Preparing0.08 ms
    Creating tmp table0.09 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.60 ms
    Creating sort index0.05 ms
    Removing tmp table0.14 ms
    Creating sort index0.02 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  28. Tempo della query: 1.37 ms Dopo l'ultima query: 1.75 ms Memoria query: 0.027 MB memoria prima della query: 3.166 MB Righe restituite: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jm5sn_categories` AS `s`
      INNER JOIN `jm5sn_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 44
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL47Using where; Using filesort
    Profilo
    StatusDuration
    Starting0.19 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.12 ms
    Optimizing0.07 ms
    Statistics0.18 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.05 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.05 ms
    Creating sort index0.20 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  29. Tempo della query: 2.16 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.025 MB memoria prima della query: 3.173 MB Righe restituite: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM jm5sn_fields AS a
      LEFT JOIN `jm5sn_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jm5sn_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jm5sn_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jm5sn_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jm5sn_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (44,0,8))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28admin_vdp.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4admin_vdp.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4admin_vdp.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4admin_vdp.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4admin_vdp.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4admin_vdp.a.id1Using where; Using index; Distinct
    Profilo
    StatusDuration
    Starting0.19 ms
    checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.11 ms
    Optimizing0.08 ms
    Statistics0.19 ms
    Preparing0.09 ms
    Creating tmp table0.10 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.65 ms
    Creating sort index0.06 ms
    Removing tmp table0.15 ms
    Creating sort index0.02 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.05 ms
    Starting cleanup0.01 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  30. Tempo della query: 1.43 ms Dopo l'ultima query: 2.16 ms Memoria query: 0.027 MB memoria prima della query: 3.192 MB Righe restituite: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jm5sn_categories` AS `s`
      INNER JOIN `jm5sn_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 45
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL47Using where; Using filesort
    Profilo
    StatusDuration
    Starting0.19 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.10 ms
    Optimizing0.07 ms
    Statistics0.18 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.05 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.05 ms
    Creating sort index0.20 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  31. Tempo della query: 2.17 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.025 MB memoria prima della query: 3.198 MB Righe restituite: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM jm5sn_fields AS a
      LEFT JOIN `jm5sn_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jm5sn_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jm5sn_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jm5sn_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jm5sn_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (45,0,8))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28admin_vdp.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4admin_vdp.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4admin_vdp.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4admin_vdp.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4admin_vdp.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4admin_vdp.a.id1Using where; Using index; Distinct
    Profilo
    StatusDuration
    Starting0.20 ms
    checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.11 ms
    Optimizing0.08 ms
    Statistics0.21 ms
    Preparing0.09 ms
    Creating tmp table0.10 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.65 ms
    Creating sort index0.06 ms
    Removing tmp table0.15 ms
    Creating sort index0.02 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  32. Tempo della query: 0.91 ms Dopo l'ultima query: 22.41 ms Memoria query: 0.021 MB memoria prima della query: 3.233 MB Righe restituite: 1
    SELECT template 
      FROM jm5sn_template_styles
      WHERE client_id = 1
      AND home = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_template_stylesrefidx_client_id,idx_client_id_homeidx_client_id1const2Using where
    Profilo
    StatusDuration
    Starting0.10 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.05 ms
    Optimizing0.05 ms
    Statistics0.10 ms
    Preparing0.05 ms
    Executing0.02 ms
    Sending data0.07 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    9JDatabaseDriver->loadResult()JROOT/templates/theme3078/includes/includes.php:21
    8include_once JROOT/templates/theme3078/includes/includes.phpJROOT/templates/theme3078/index.php:4
    7require JROOT/templates/theme3078/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1098
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  33. Tempo della query: 7.89 ms Dopo l'ultima query: 0.64 ms Memoria query: 0.025 MB memoria prima della query: 3.278 MB Righe restituite: 7
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jm5sn_modules AS m
      LEFT JOIN jm5sn_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jm5sn_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-06-21 07:02:32')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-21 07:02:32')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 317 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const29Using index condition; Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4admin_vdp.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403admin_vdp.m.module,const1Using index condition; Using where
    Profilo
    StatusDuration
    Starting0.17 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.09 ms
    Optimizing0.10 ms
    Statistics1.04 ms
    Preparing0.13 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.03 ms
    Creating sort index5.91 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()Chiamata uguale alla linea sottostante.
    14call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:441
    12Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
    11Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    10Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:601
    9Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/theme3078/includes/includes.php:77
    8include_once JROOT/templates/theme3078/includes/includes.phpJROOT/templates/theme3078/index.php:4
    7require JROOT/templates/theme3078/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1098
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  34. Tempo della query: 1.65 ms Dopo l'ultima query: 18.97 ms Memoria query: 0.023 MB memoria prima della query: 3.340 MB Righe restituite: 1
    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM jm5sn_content AS a
      INNER JOIN jm5sn_categories AS c
      on c.id = a.catid
      LEFT JOIN jm5sn_users AS u
      on u.id = a.created_by
      LEFT JOIN jm5sn_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jm5sn_content_rating AS v
      ON a.id = v.content_id
      WHERE a.id = 134
      AND c.published > 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-21 07:02:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-21 07:02:32')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARY,idx_catidPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const1
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    1SIMPLEvconstPRIMARYPRIMARY4const0Unique row not found
    Profilo
    StatusDuration
    Starting0.31 ms
    checking permissions0.03 ms
    Opening tables0.07 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.19 ms
    Optimizing0.11 ms
    Statistics0.24 ms
    Preparing0.03 ms
    Unlocking tables0.03 ms
    Preparing0.05 ms
    Executing0.02 ms
    Sending data0.13 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.03 ms
    Query end0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.04 ms
    Updating status0.05 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    13JDatabaseDriver->loadObject()JROOT/components/com_content/models/article.php:151
    12ContentModelArticle->getItem()JROOT/modules/mod_articles_single/helper.php:26
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  35. Tempo della query: 0.73 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.026 MB memoria prima della query: 3.360 MB Righe restituite: 1
    SELECT `alias`
    
      FROM `jm5sn_content`
      WHERE id = '134'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_contentconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    Starting0.07 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.04 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.03 ms
    Executing0.02 ms
    Sending data0.03 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.02 ms
    Updating status0.04 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    22JDatabaseDriver->loadResult()JROOT/components/com_content/router.php:125
    21ContentRouter->getArticleSegment()Chiamata uguale alla linea sottostante.
    20call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    19Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    17Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
    16Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  36. Tempo della query: 1.14 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.028 MB memoria prima della query: 3.374 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 `jm5sn_categories` AS `s`
      INNER JOIN `jm5sn_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 46
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL47Using where; Using filesort
    Profilo
    StatusDuration
    Starting0.17 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.09 ms
    Optimizing0.06 ms
    Statistics0.15 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.04 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.04 ms
    Creating sort index0.22 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    23Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    22Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    21ContentRouter->getCategorySegment()Chiamata uguale alla linea sottostante.
    20call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    19Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    17Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
    16Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  37. Tempo della query: 0.46 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.025 MB memoria prima della query: 3.386 MB Righe restituite: 1
    SELECT alias
    
      FROM jm5sn_content
      WHERE id=134
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_contentconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    Starting0.05 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    20JDatabaseDriver->loadResult()JROOT/components/com_content/helpers/legacyrouter.php:140
    19ContentRouterRulesLegacy->build()JROOT/libraries/src/Component/Router/RouterView.php:244
    18Joomla\CMS\Component\Router\RouterView->build()JROOT/libraries/src/Router/SiteRouter.php:532
    17Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    16Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  38. Tempo della query: 1.82 ms Dopo l'ultima query: 0.92 ms Memoria query: 0.027 MB memoria prima della query: 3.397 MB Righe restituite: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM jm5sn_fields AS a
      LEFT JOIN `jm5sn_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jm5sn_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jm5sn_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jm5sn_fields_groups AS g
      ON g.id = a.group_id
      WHERE a.context = 'mod_articles_single.content'
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28admin_vdp.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4admin_vdp.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4admin_vdp.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4admin_vdp.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4admin_vdp.a.group_id1Using where
    Profilo
    StatusDuration
    Starting0.15 ms
    checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.09 ms
    Optimizing0.06 ms
    Statistics0.15 ms
    Preparing0.08 ms
    Creating tmp table0.10 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.61 ms
    Creating sort index0.06 ms
    Removing tmp table0.14 ms
    Creating sort index0.02 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    22Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    21FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    20Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    19FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    18PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    15JHtmlContent::prepare()Chiamata uguale alla linea sottostante.
    14call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    13Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    12Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_articles_single/helper.php:33
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  39. Tempo della query: 1.34 ms Dopo l'ultima query: 4.44 ms Memoria query: 0.023 MB memoria prima della query: 3.456 MB Righe restituite: 1
    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM jm5sn_content AS a
      INNER JOIN jm5sn_categories AS c
      on c.id = a.catid
      LEFT JOIN jm5sn_users AS u
      on u.id = a.created_by
      LEFT JOIN jm5sn_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jm5sn_content_rating AS v
      ON a.id = v.content_id
      WHERE a.id = 114
      AND c.published > 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-21 07:02:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-21 07:02:32')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARY,idx_catidPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const1
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    1SIMPLEvconstPRIMARYPRIMARY4const0Unique row not found
    Profilo
    StatusDuration
    Starting0.31 ms
    checking permissions0.02 ms
    Opening tables0.06 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.14 ms
    Optimizing0.09 ms
    Statistics0.19 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.03 ms
    Executing0.02 ms
    Sending data0.09 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    13JDatabaseDriver->loadObject()JROOT/components/com_content/models/article.php:151
    12ContentModelArticle->getItem()JROOT/modules/mod_articles_single/helper.php:26
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  40. Tempo della query: 0.68 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.026 MB memoria prima della query: 3.476 MB Righe restituite: 1
    SELECT `alias`
    
      FROM `jm5sn_content`
      WHERE id = '114'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_contentconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    Starting0.06 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.04 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.02 ms
    Executing0.02 ms
    Sending data0.02 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.47 ms
    Reset for next command0.03 ms
    Call Stack
    #CallerFile e numero di linea
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    22JDatabaseDriver->loadResult()JROOT/components/com_content/router.php:125
    21ContentRouter->getArticleSegment()Chiamata uguale alla linea sottostante.
    20call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    19Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    17Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
    16Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  41. Tempo della query: 0.70 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.025 MB memoria prima della query: 3.485 MB Righe restituite: 1
    SELECT alias
    
      FROM jm5sn_content
      WHERE id=114
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_contentconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    Starting0.06 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.02 ms
    Executing0.02 ms
    Sending data0.02 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    20JDatabaseDriver->loadResult()JROOT/components/com_content/helpers/legacyrouter.php:140
    19ContentRouterRulesLegacy->build()JROOT/libraries/src/Component/Router/RouterView.php:244
    18Joomla\CMS\Component\Router\RouterView->build()JROOT/libraries/src/Router/SiteRouter.php:532
    17Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    16Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  42. Tempo della query: 1.33 ms Dopo l'ultima query: 1.54 ms Memoria query: 0.023 MB memoria prima della query: 3.491 MB Righe restituite: 1
    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM jm5sn_content AS a
      INNER JOIN jm5sn_categories AS c
      on c.id = a.catid
      LEFT JOIN jm5sn_users AS u
      on u.id = a.created_by
      LEFT JOIN jm5sn_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jm5sn_content_rating AS v
      ON a.id = v.content_id
      WHERE a.id = 115
      AND c.published > 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-21 07:02:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-21 07:02:32')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARY,idx_catidPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const1
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    1SIMPLEvconstPRIMARYPRIMARY4const0Unique row not found
    Profilo
    StatusDuration
    Starting0.29 ms
    checking permissions0.02 ms
    Opening tables0.06 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.13 ms
    Optimizing0.11 ms
    Statistics0.17 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.03 ms
    Executing0.02 ms
    Sending data0.10 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.01 ms
    closing tables0.02 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.03 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    13JDatabaseDriver->loadObject()JROOT/components/com_content/models/article.php:151
    12ContentModelArticle->getItem()JROOT/modules/mod_articles_single/helper.php:26
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  43. Tempo della query: 0.63 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.026 MB memoria prima della query: 3.510 MB Righe restituite: 1
    SELECT `alias`
    
      FROM `jm5sn_content`
      WHERE id = '115'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_contentconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    Starting0.07 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.02 ms
    Executing0.02 ms
    Sending data0.02 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.01 ms
    closing tables0.02 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    22JDatabaseDriver->loadResult()JROOT/components/com_content/router.php:125
    21ContentRouter->getArticleSegment()Chiamata uguale alla linea sottostante.
    20call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    19Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    17Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
    16Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  44. Tempo della query: 0.68 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.025 MB memoria prima della query: 3.520 MB Righe restituite: 1
    SELECT alias
    
      FROM jm5sn_content
      WHERE id=115
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_contentconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    Starting0.05 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.03 ms
    Unlocking tables0.02 ms
    Preparing0.02 ms
    Executing0.02 ms
    Sending data0.02 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Query end0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Query end0.02 ms
    Starting cleanup0.05 ms
    Freeing items0.02 ms
    Updating status4.00 ms
    Reset for next command0.04 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    20JDatabaseDriver->loadResult()JROOT/components/com_content/helpers/legacyrouter.php:140
    19ContentRouterRulesLegacy->build()JROOT/libraries/src/Component/Router/RouterView.php:244
    18Joomla\CMS\Component\Router\RouterView->build()JROOT/libraries/src/Router/SiteRouter.php:532
    17Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    16Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    15Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    14Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    13Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  45. Tempo della query: 0.69 ms Dopo l'ultima query: 11.77 ms Memoria query: 0.026 MB memoria prima della query: 3.637 MB Righe restituite: 1
    SELECT id,parent_id 
      FROM jm5sn_menu
      WHERE id = 317
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_menuconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    Starting0.12 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.04 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.01 ms
    Unlocking tables0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:45
    17modIceMegamenuHelper::buildXML()Chiamata uguale alla linea sottostante.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:114
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:153
    12modIceMegamenuHelper->render()JROOT/templates/theme3078/html/mod_icemegamenu/default.php:16
    11require JROOT/templates/theme3078/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  46. Tempo della query: 0.85 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.026 MB memoria prima della query: 3.648 MB Righe restituite: 1
    SELECT id,parent_id 
      FROM jm5sn_menu
      WHERE id = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEjm5sn_menuconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    Starting0.05 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.39 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:45
    17modIceMegamenuHelper::buildXML()Chiamata uguale alla linea sottostante.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:114
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:153
    12modIceMegamenuHelper->render()JROOT/templates/theme3078/html/mod_icemegamenu/default.php:16
    11require JROOT/templates/theme3078/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

26 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:
  1. 7 × 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 `jm5sn_categories` AS `s`
      INNER JOIN `jm5sn_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  2. 6 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM jm5sn_fields AS a
      LEFT JOIN `jm5sn_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jm5sn_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jm5sn_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jm5sn_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jm5sn_fields_categories` AS fc
      ON fc.field_id = a.id
  3. 3 × SELECT alias 
      FROM jm5sn_content
  4. 3 × SELECT `alias` 
      FROM `jm5sn_content`
  5. 3 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM jm5sn_content AS a
      INNER JOIN jm5sn_categories AS c
      on c.id = a.catid
      LEFT JOIN jm5sn_users AS u
      on u.id = a.created_by
      LEFT JOIN jm5sn_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jm5sn_content_rating AS v
      ON a.id = v.content_id
  6. 2 × SELECT id,parent_id 
      FROM jm5sn_menu
  7. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `jm5sn_extensions`
  8. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `jm5sn_assets`
  9. 1 × SELECT `m`.`tag_id`,`t`.* 
      FROM `jm5sn_contentitem_tag_map` AS m
      INNER JOIN `jm5sn_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  10. 1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM jm5sn_fields AS a
      LEFT JOIN `jm5sn_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jm5sn_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jm5sn_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jm5sn_fields_groups AS g
      ON g.id = a.group_id
  11. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM jm5sn_modules AS m
      LEFT JOIN jm5sn_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jm5sn_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  12. 1 × SELECT template 
      FROM jm5sn_template_styles
  13. 1 × SELECT `data` 
      FROM `jm5sn_session`
  14. 1 × SELECT COUNT(*) 
      FROM jm5sn_content AS a
      LEFT JOIN jm5sn_categories AS c
      ON c.id = a.catid
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jm5sn_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jm5sn_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jm5sn_content_rating AS v
      ON a.id = v.content_id
  15. 1 × SELECT `session_id` 
      FROM `jm5sn_session`
  16. 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,( SELECT COUNT(i.`id`)
      FROM `jm5sn_content` AS `i`
  17. 1 × SELECT id, home, template, s.params 
      FROM jm5sn_template_styles as s
      LEFT JOIN jm5sn_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  18. 1 × SELECT * 
      FROM jm5sn_languages
  19. 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 jm5sn_menu AS m
      LEFT JOIN jm5sn_extensions AS e
      ON m.component_id = e.extension_id
  20. 1 × SELECT * 
      FROM jm5sn_loginradius_setting
  21. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM jm5sn_extensions
  22. 1 × SELECT b.id 
      FROM jm5sn_usergroups AS a
      LEFT JOIN jm5sn_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  23. 1 × SELECT id, rules 
      FROM `jm5sn_viewlevels
  24. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM jm5sn_content AS a
      LEFT JOIN jm5sn_categories AS c
      ON c.id = a.catid
      LEFT JOIN jm5sn_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jm5sn_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jm5sn_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jm5sn_content_rating AS v
      ON a.id = v.content_id
ALTRE tabelle:
  1. 1 × INSERT INTO `jm5sn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6f666e6674666d70756e64337034377332646b31616c6f70766e', 1, 1750489351, 0, '', 0
  2. 1 × UPDATE `jm5sn_extensions` 
      SET `params` = '{\"mediaversion\":\"362e8ede80d508f4a0ab89c035808804\"}'