• Torino: 011 630 80 75
  • Roma: 06 811 76 915
  • Pescara: 800 480 775
Sentiamoci Group | Acufene | Problemi Udito
  • Home
  • Chi Siamo
  • Acufene
  • Blog
  • Contatti
  • Search
Blog
  • Home/
  • Blog

Blog

Inquinamento Acustico

il 03 Marzo 2020

Acufene e Rumore

il 03 Marzo 2020

Ipoacusia da Rumore

il 03 Marzo 2020

Mal di viaggio: Cinetosi

il 03 Marzo 2020

Rimedi naturali contro l’acufene

il 03 Marzo 2020

Otomicosi

il 03 Marzo 2020

Udito e Vacanze

il 03 Marzo 2020

Declino Cognitivo e Isolamento

il 03 Marzo 2020

Widex Evoke: l’apparecchio acustico Intelligente

il 03 Marzo 2020
  • 1
  • 2
Sentiamoci Group | Acufene | Problemi Udito © 2023 Privacy Policy
Login or register
Nome utente dimenticato? / Password dimenticata?
Login with Facebook
Login with Google +

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695523768,
                "last": 1695523768,
                "now": 1695523768
            },
            "token": "MfrmC7q8zEkm7jc7o7QCQK08tAUzjZjg"
        },
        "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: 430.52 ms / 430.52 ms Memoria: 0.633 MB / 1.01 MB Application: afterLoad
Tempo: 889.51 ms / 1320.02 ms Memoria: 1.451 MB / 2.46 MB Application: afterInitialise
Tempo: 283.85 ms / 1603.87 ms Memoria: 0.449 MB / 2.91 MB Application: afterRoute
Tempo: 44.92 ms / 1648.79 ms Memoria: 0.150 MB / 3.06 MB Application: beforeRenderComponent com_content
Tempo: 93.47 ms / 1742.26 ms Memoria: 0.226 MB / 3.29 MB Application: Before Access::preloadComponents (all components)
Tempo: 6.73 ms / 1748.99 ms Memoria: 0.056 MB / 3.35 MB Application: After Access::preloadComponents (all components)
Tempo: 0.05 ms / 1749.04 ms Memoria: 0.000 MB / 3.34 MB Application: Before Access::preloadPermissions (com_content)
Tempo: 2.01 ms / 1751.06 ms Memoria: 0.169 MB / 3.51 MB Application: After Access::preloadPermissions (com_content)
Tempo: 0.04 ms / 1751.10 ms Memoria: 0.000 MB / 3.50 MB Application: Before Access::getAssetRules (id:67 name:com_content.category.11)
Tempo: 12.73 ms / 1763.83 ms Memoria: 0.010 MB / 3.51 MB Application: After Access::getAssetRules (id:67 name:com_content.category.11)
Tempo: 62.33 ms / 1826.16 ms Memoria: 0.036 MB / 3.55 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Tempo: 0.07 ms / 1826.23 ms Memoria: 0.007 MB / 3.55 MB Application: After Access::getAssetRules (id:8 name:com_content)
Tempo: 367.60 ms / 2193.83 ms Memoria: 0.712 MB / 4.27 MB Application: afterRenderComponent com_content
Tempo: 2.72 ms / 2196.55 ms Memoria: 0.007 MB / 4.27 MB Application: afterDispatch
Tempo: 159.10 ms / 2355.65 ms Memoria: 0.286 MB / 4.56 MB Application: beforeRenderModule mod_socialloginandsocialshare (Login or register)
Tempo: 129.36 ms / 2485.00 ms Memoria: 0.073 MB / 4.63 MB Application: afterRenderModule mod_socialloginandsocialshare (Login or register)
Tempo: 0.08 ms / 2485.08 ms Memoria: 0.000 MB / 4.63 MB Application: beforeRenderModule mod_tm_olark_chat (Olark)
Tempo: 24.30 ms / 2509.38 ms Memoria: 0.009 MB / 4.64 MB Application: afterRenderModule mod_tm_olark_chat (Olark)
Tempo: 0.18 ms / 2509.57 ms Memoria: 0.000 MB / 4.63 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Tempo: 25.31 ms / 2534.88 ms Memoria: 0.085 MB / 4.72 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Tempo: 0.09 ms / 2534.97 ms Memoria: 0.007 MB / 4.73 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Tempo: 0.18 ms / 2535.14 ms Memoria: 0.000 MB / 4.71 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Tempo: 0.13 ms / 2535.27 ms Memoria: 0.000 MB / 4.71 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Tempo: 43.30 ms / 2578.57 ms Memoria: 0.012 MB / 4.72 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Tempo: 0.12 ms / 2578.68 ms Memoria: 0.000 MB / 4.72 MB Application: beforeRenderModule mod_icemegamenu (Main menu)
Tempo: 87.13 ms / 2665.81 ms Memoria: 0.237 MB / 4.96 MB Application: beforeRenderModule mod_search (Menu search)
Tempo: 25.96 ms / 2691.77 ms Memoria: 0.015 MB / 4.97 MB Application: afterRenderModule mod_search (Menu search)
Tempo: 13.78 ms / 2705.55 ms Memoria: 0.000 MB / 4.97 MB Application: afterRenderModule mod_icemegamenu (Main menu)
Tempo: 0.10 ms / 2705.65 ms Memoria: 0.000 MB / 4.97 MB Application: beforeRenderModule mod_menu (Social media)
Tempo: 23.84 ms / 2729.49 ms Memoria: 0.009 MB / 4.98 MB Application: afterRenderModule mod_menu (Social media)
Tempo: 0.05 ms / 2729.54 ms Memoria: 0.000 MB / 4.97 MB Application: beforeRenderModule mod_menu (Address)
Tempo: 18.98 ms / 2748.52 ms Memoria: 0.012 MB / 4.99 MB Application: afterRenderModule mod_menu (Address)
Tempo: 0.07 ms / 2748.59 ms Memoria: 0.000 MB / 4.98 MB Application: beforeRenderModule mod_menu (Telephone)
Tempo: 0.44 ms / 2749.03 ms Memoria: 0.006 MB / 4.99 MB Application: afterRenderModule mod_menu (Telephone)
Tempo: 31.51 ms / 2780.54 ms Memoria: 0.129 MB / 5.12 MB Application: afterRender

Query totali del database: 101.10 ms

Utilizzo memoria

5,79 MB (6.068.824 Bytes)

Query Database

36 query eseguite 101.10 ms


Trovati 2 duplicati!

2 duplicati: #8  #33
  1. Tempo della query: 3.54 ms Memoria query: 0.025 MB memoria prima della query: 1.482 MB Righe restituite: 0
    SELECT `data`
    
      FROM `mrfej_session`
      WHERE `session_id` = 'i0ll6i9a7bo1110tcee1s6nnp7'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_sessionconstPRIMARYPRIMARY194const1
    Profilo
    StatusDuration
    Starting0.11 ms
    Checking permissions0.01 ms
    Opening tables0.89 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.03 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics2.19 ms
    Preparing0.01 ms
    Executing0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    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:660
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:620
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:498
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:455
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:765
    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:351
    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.62 ms Dopo l'ultima query: 29.37 ms Memoria query: 0.022 MB memoria prima della query: 1.498 MB Righe restituite: 0
    SELECT `session_id`
    
      FROM `mrfej_session`
      WHERE `session_id` = 'i0ll6i9a7bo1110tcee1s6nnp7'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_sessionconstPRIMARYPRIMARY194const1Using index
    Profilo
    StatusDuration
    Starting0.15 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.12 ms
    Preparing0.01 ms
    Executing0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.02 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.08 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    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:767
    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:351
    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: 2.33 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.004 MB memoria prima della query: 1.503 MB
    INSERT INTO `mrfej_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('i0ll6i9a7bo1110tcee1s6nnp7', 1, 1695523768, 0, '', 0)
    Explain
    EXPLAIN non possibile sulla query: INSERT INTO `mrfej_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('i0ll6i9a7bo1110tcee1s6nnp7', 1, 1695523768, 0, '', 0)
    Profilo
    StatusDuration
    Starting0.08 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init for update0.01 ms
    Update0.10 ms
    Waiting for query cache lock0.00 ms
    Update0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit1.95 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.07 ms
    Updating status0.02 ms
    Reset for next command0.00 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:767
    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:351
    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: 8.03 ms Dopo l'ultima query: 62.15 ms Memoria query: 0.030 MB memoria prima della query: 1.602 MB Righe restituite: 39
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `mrfej_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_extensionsrefextensionextension82const39Using index condition; Using where
    Profilo
    StatusDuration
    Starting0.11 ms
    Checking permissions0.01 ms
    Opening tables1.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.04 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics2.33 ms
    Preparing0.04 ms
    Executing0.00 ms
    Sending data4.07 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.06 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:203
    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: 2.01 ms Dopo l'ultima query: 55.39 ms Memoria query: 0.023 MB memoria prima della query: 1.638 MB Righe restituite: 5
    SELECT id, rules
    
      FROM `mrfej_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_viewlevelsALLNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL5
    Profilo
    StatusDuration
    Starting0.11 ms
    Checking permissions0.01 ms
    Opening tables1.52 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.03 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.04 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1500
    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:321
    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:203
    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: 4.07 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.022 MB memoria prima della query: 1.650 MB Righe restituite: 2
    SELECT b.id
    
      FROM mrfej_usergroups AS a
      LEFT JOIN mrfej_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.08 ms
    Checking permissions0.01 ms
    Opening tables0.68 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.03 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics2.91 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.04 ms
    Executing0.00 ms
    Sending data0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.06 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    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:321
    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:203
    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: 1.17 ms Dopo l'ultima query: 2.91 ms Memoria query: 0.039 MB memoria prima della query: 1.673 MB Righe restituite: 87
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM mrfej_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
    1SIMPLEmrfej_extensionsrefextensionextension82const116Using index condition; Using where; Using filesort
    Profilo
    StatusDuration
    Starting0.14 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.61 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.04 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:354
    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:359
    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:203
    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: 2.25 ms Dopo l'ultima query: 381.56 ms Memoria query: 0.024 MB memoria prima della query: 2.355 MB Righe restituite: 10
    Query duplicate: #33
    SELECT * 
      FROM mrfej_loginradius_settings
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_loginradius_settingsALLNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL10
    Profilo
    StatusDuration
    Starting0.10 ms
    Checking permissions0.01 ms
    Opening tables1.20 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.02 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.59 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1500
    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:633
    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:203
    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: 9.96 ms Dopo l'ultima query: 72.64 ms Memoria query: 0.078 MB memoria prima della query: 2.497 MB Righe restituite: 61
    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 mrfej_menu AS m
      LEFT JOIN mrfej_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_language1const106Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4h455530_sent.m.component_id1Using where
    Profilo
    StatusDuration
    Starting0.14 ms
    Checking permissions0.01 ms
    Opening tables1.64 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.08 ms
    Closing tables0.00 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Init0.04 ms
    Optimizing0.02 ms
    Statistics2.35 ms
    Preparing0.06 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    Creating sort index5.20 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.07 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:76
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:382
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:64
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:498
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1080
    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:203
    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: 0.74 ms Dopo l'ultima query: 238.84 ms Memoria query: 0.025 MB memoria prima della query: 2.932 MB Righe restituite: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `mrfej_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profilo
    StatusDuration
    Starting0.17 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.14 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.08 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    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:1119
    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:203
    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: 1.69 ms Dopo l'ultima query: 0.30 ms Memoria query: 0.005 MB memoria prima della query: 2.922 MB
    UPDATE `mrfej_extensions`
    
      SET `params` = '{\"mediaversion\":\"307c4133f5aaad57ab890aa17c736548\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN non possibile sulla query: UPDATE `mrfej_extensions` SET `params` = '{\"mediaversion\":\"307c4133f5aaad57ab890aa17c736548\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profilo
    StatusDuration
    Starting0.09 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init for update0.07 ms
    Updating0.06 ms
    End of update loop0.00 ms
    Waiting for query cache lock0.00 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit1.27 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.06 ms
    Updating status0.01 ms
    Reset for next command0.00 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:1119
    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:203
    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.70 ms Dopo l'ultima query: 20.91 ms Memoria query: 0.025 MB memoria prima della query: 3.020 MB Righe restituite: 1
    SELECT *
    
      FROM mrfej_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_languagesALLNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1Using where; Using filesort
    Profilo
    StatusDuration
    Starting0.18 ms
    Checking permissions0.01 ms
    Opening tables0.88 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.05 ms
    Closing tables0.00 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Init0.04 ms
    Optimizing0.02 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.09 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.07 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:203
    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: 1.58 ms Dopo l'ultima query: 0.41 ms Memoria query: 0.021 MB memoria prima della query: 3.039 MB Righe restituite: 5
    SELECT id, home, template, s.params
    
      FROM mrfej_template_styles as s
      LEFT JOIN mrfej_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
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionextension82const5Using index condition; Using where
    1SIMPLEsALLidx_templateNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL7Using where; Using join buffer (flat, BNL join)
    Profilo
    StatusDuration
    Starting0.13 ms
    Checking permissions0.01 ms
    Opening tables0.86 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.03 ms
    Closing tables0.00 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Init0.03 ms
    Optimizing0.03 ms
    Statistics0.08 ms
    Preparing0.05 ms
    Executing0.00 ms
    Sending data0.11 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.06 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:203
    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: 6.39 ms Dopo l'ultima query: 102.27 ms Memoria query: 0.031 MB memoria prima della query: 3.293 MB Righe restituite: 39
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `mrfej_assets`
      WHERE `name` IN ('root.1','com_actionlogs','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_foxcontact','com_installer','com_joomgallery','com_joomlaupdate','com_kunena','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
    1SIMPLEmrfej_assetsALLidx_asset_nameNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL345Using where
    Profilo
    StatusDuration
    Starting0.14 ms
    Checking permissions0.01 ms
    Opening tables1.99 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.05 ms
    Closing tables0.00 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Init0.06 ms
    Optimizing0.02 ms
    Statistics0.15 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data3.60 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.08 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:1695
    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:435
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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.57 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.047 MB memoria prima della query: 3.343 MB Righe restituite: 169
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `mrfej_assets`
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_assetsALLidx_asset_name,idx_parent_idNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL345Using where
    Profilo
    StatusDuration
    Starting0.14 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.11 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.55 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.06 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:435
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 14.35 ms Dopo l'ultima query: 39.79 ms Memoria query: 0.037 MB memoria prima della query: 3.510 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,( SELECT COUNT(i.`id`)
      FROM `mrfej_content` AS `i`
      WHERE i.`catid` = c.id
      AND i.state = 1) AS numitems
      FROM `mrfej_categories` AS `s`
      INNER JOIN `mrfej_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 = 11
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1
    1PRIMARYcALLcat_idx,idx_left_rightNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL42Using where; Using filesort
    2DEPENDENT SUBQUERYirefidx_state,idx_catididx_catid4h455530_sent.c.id1Using index condition; Using where
    Profilo
    StatusDuration
    Starting0.24 ms
    Checking permissions0.01 ms
    Opening tables2.93 ms
    After opening tables0.02 ms
    System lock0.00 ms
    Table lock0.01 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.10 ms
    Closing tables0.00 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Init0.08 ms
    Optimizing0.03 ms
    Statistics3.27 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.03 ms
    Optimizing0.02 ms
    Statistics2.75 ms
    Preparing0.07 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    Creating sort index0.14 ms
    Executing0.00 ms
    Sending data1.65 ms
    Executing0.01 ms
    Sending data2.51 ms
    End of update loop0.02 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Removing tmp table0.01 ms
    Freeing items0.12 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 5.89 ms Dopo l'ultima query: 21.46 ms Memoria query: 0.094 MB memoria prima della query: 3.552 MB Righe restituite: 9
    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 mrfej_content AS a
      LEFT JOIN mrfej_categories AS c
      ON c.id = a.catid
      LEFT JOIN mrfej_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN mrfej_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN mrfej_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN mrfej_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 = 11 OR a.catid IN ( SELECT sub.id
      FROM mrfej_categories as sub
      INNER JOIN mrfej_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 11))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-24 02:49:29')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-24 02:49:29')
      ORDER BY
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
      LIMIT 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcALLPRIMARY,idx_accessNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL42Using where; Using temporary; Using filesort
    1PRIMARYarefidx_access,idx_state,idx_catididx_catid4h455530_sent.c.id1Using index condition; Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4h455530_sent.a.created_by1Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4h455530_sent.a.modified_by1Using where
    1PRIMARYparenteq_refPRIMARYPRIMARY4h455530_sent.c.parent_id1Using where
    1PRIMARYveq_refPRIMARYPRIMARY4h455530_sent.a.id1Using where
    2MATERIALIZEDthisconstPRIMARY,idx_left_rightPRIMARY4const1
    2MATERIALIZEDsubrangePRIMARY,idx_left_rightidx_left_right4NULL30Using where; Using index
    Profilo
    StatusDuration
    Starting0.32 ms
    Checking permissions0.01 ms
    Opening tables2.47 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.05 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Init0.13 ms
    Optimizing0.05 ms
    Statistics0.15 ms
    Preparing0.05 ms
    Optimizing0.01 ms
    Statistics0.09 ms
    Preparing0.04 ms
    Creating tmp table0.07 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.11 ms
    Executing0.00 ms
    Sending data1.37 ms
    Creating sort index0.33 ms
    Removing tmp table0.24 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.05 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Removing tmp table0.01 ms
    Freeing items0.02 ms
    Removing tmp table0.00 ms
    Freeing items0.07 ms
    Updating status0.91 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 6.67 ms Dopo l'ultima query: 15.11 ms Memoria query: 0.036 MB memoria prima della query: 3.796 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `mrfej_contentitem_tag_map` AS m
      INNER JOIN `mrfej_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 118
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4h455530_sent.m.tag_id1Using where
    Profilo
    StatusDuration
    Starting0.12 ms
    Checking permissions0.01 ms
    Opening tables3.24 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.12 ms
    Closing tables0.00 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Init0.05 ms
    Optimizing0.03 ms
    Statistics2.68 ms
    Preparing0.04 ms
    Executing0.00 ms
    Sending data0.06 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.07 ms
    Updating status0.07 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 0.69 ms Dopo l'ultima query: 0.43 ms Memoria query: 0.036 MB memoria prima della query: 3.817 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `mrfej_contentitem_tag_map` AS m
      INNER JOIN `mrfej_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 120
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4h455530_sent.m.tag_id1Using where
    Profilo
    StatusDuration
    Starting0.11 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 0.37 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.036 MB memoria prima della query: 3.838 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `mrfej_contentitem_tag_map` AS m
      INNER JOIN `mrfej_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 144
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4h455530_sent.m.tag_id1Using where
    Profilo
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 0.37 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.036 MB memoria prima della query: 3.859 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `mrfej_contentitem_tag_map` AS m
      INNER JOIN `mrfej_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 163
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4h455530_sent.m.tag_id1Using where
    Profilo
    StatusDuration
    Starting0.08 ms
    Checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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.36 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.036 MB memoria prima della query: 3.881 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `mrfej_contentitem_tag_map` AS m
      INNER JOIN `mrfej_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 165
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4h455530_sent.m.tag_id1Using where
    Profilo
    StatusDuration
    Starting0.06 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 0.38 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.036 MB memoria prima della query: 3.902 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `mrfej_contentitem_tag_map` AS m
      INNER JOIN `mrfej_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 166
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4h455530_sent.m.tag_id1Using where
    Profilo
    StatusDuration
    Starting0.07 ms
    Checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 0.39 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.036 MB memoria prima della query: 3.923 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `mrfej_contentitem_tag_map` AS m
      INNER JOIN `mrfej_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 167
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4h455530_sent.m.tag_id1Using where
    Profilo
    StatusDuration
    Starting0.08 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.04 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 0.76 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.036 MB memoria prima della query: 3.944 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `mrfej_contentitem_tag_map` AS m
      INNER JOIN `mrfej_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 168
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4h455530_sent.m.tag_id1Using where
    Profilo
    StatusDuration
    Starting0.08 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.02 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 0.42 ms Dopo l'ultima query: 0.30 ms Memoria query: 0.036 MB memoria prima della query: 3.965 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `mrfej_contentitem_tag_map` AS m
      INNER JOIN `mrfej_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 169
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4h455530_sent.m.tag_id1Using where
    Profilo
    StatusDuration
    Starting0.09 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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.63 ms Dopo l'ultima query: 4.33 ms Memoria query: 0.026 MB memoria prima della query: 3.975 MB Righe restituite: 1
    SELECT COUNT(*)
    
      FROM mrfej_content AS a
      LEFT JOIN mrfej_categories AS c
      ON c.id = a.catid
      LEFT JOIN mrfej_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN mrfej_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN mrfej_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN mrfej_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 = 11 OR a.catid IN ( SELECT sub.id
      FROM mrfej_categories as sub
      INNER JOIN mrfej_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 11))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-24 02:49:29')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-24 02:49:29')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcALLPRIMARY,idx_accessNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL42Using where
    1PRIMARYarefidx_access,idx_state,idx_catididx_catid4h455530_sent.c.id1Using index condition; Using where
    2MATERIALIZEDthisconstPRIMARY,idx_left_rightPRIMARY4const1
    2MATERIALIZEDsubrangePRIMARY,idx_left_rightidx_left_right4NULL30Using where; Using index
    Profilo
    StatusDuration
    Starting0.17 ms
    Checking permissions0.01 ms
    Opening tables0.09 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.05 ms
    Optimizing0.04 ms
    Statistics0.10 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.04 ms
    Optimizing0.01 ms
    Statistics0.08 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.12 ms
    Executing0.00 ms
    Sending data0.66 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Removing tmp table0.01 ms
    Freeing items0.01 ms
    Removing tmp table0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    17JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:282
    15Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:232
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 0.43 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.035 MB memoria prima della query: 3.980 MB Righe restituite: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `mrfej_contentitem_tag_map` AS m
      INNER JOIN `mrfej_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 11
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4h455530_sent.m.tag_id1Using where
    Profilo
    StatusDuration
    Starting0.09 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.04 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.04 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 1.38 ms Dopo l'ultima query: 129.49 ms Memoria query: 0.038 MB memoria prima della query: 4.089 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 `mrfej_categories` AS `s`
      INNER JOIN `mrfej_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 = 11
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL42Using where; Using filesort
    Profilo
    StatusDuration
    Starting0.39 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.05 ms
    Statistics0.22 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.03 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.16 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.08 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:1695
    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:133
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:135
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:478
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 8.24 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.037 MB memoria prima della query: 4.106 MB Righe restituite: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM mrfej_fields AS a
      LEFT JOIN `mrfej_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN mrfej_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN mrfej_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN mrfej_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN mrfej_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `mrfej_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 (11,0))
      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 filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28h455530_sent.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4h455530_sent.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4h455530_sent.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4h455530_sent.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4h455530_sent.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4h455530_sent.a.id1Using where; Using index
    Profilo
    StatusDuration
    Starting0.21 ms
    Checking permissions0.01 ms
    Opening tables3.32 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.12 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Init0.11 ms
    Optimizing0.04 ms
    Statistics3.74 ms
    Preparing0.08 ms
    Sorting result0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    Creating sort index0.09 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.07 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:1695
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:135
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:478
    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:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:203
    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: 6.32 ms Dopo l'ultima query: 221.35 ms Memoria query: 0.030 MB memoria prima della query: 4.397 MB Righe restituite: 18
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM mrfej_modules AS m
      LEFT JOIN mrfej_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN mrfej_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 <= '2023-09-24 02:49:29')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-24 02:49:29')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 285 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const50Using index condition; Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4h455530_sent.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403h455530_sent.m.module,const1Using index condition; Using where
    Profilo
    StatusDuration
    Starting0.13 ms
    Checking permissions0.01 ms
    Opening tables1.35 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.04 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics1.86 ms
    Preparing0.06 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index2.51 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.06 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:581
    9Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/theme3348/includes/includes.php:126
    8include_once JROOT/templates/theme3348/includes/includes.phpJROOT/templates/theme3348/index.php:2
    7require JROOT/templates/theme3348/index.phpJROOT/libraries/src/Document/HtmlDocument.php:658
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:720
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:535
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1037
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:209
    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: 1.30 ms Dopo l'ultima query: 30.87 ms Memoria query: 0.030 MB memoria prima della query: 4.443 MB Righe restituite: 1
    SELECT * 
      FROM mrfej_kunena_configuration
      WHERE id=1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_kunena_configurationconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.90 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.02 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    26JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1459
    25JDatabaseDriver->loadAssoc()JROOT/libraries/kunena/config.php:1227
    24KunenaConfig->load()JROOT/libraries/kunena/config.php:1174
    23KunenaConfig::getInstance()JROOT/libraries/kunena/factory.php:28
    22KunenaFactory::getConfig()JROOT/libraries/kunena/route/route.php:429
    21KunenaRoute::initialize()JROOT/libraries/kunena/route/route.php:17
    20include_once JROOT/libraries/kunena/route/route.phpJROOT/libraries/loader.php:759
    19JLoader::_load()JROOT/libraries/loader.php:707
    18JLoader::_autoload()Chiamata uguale alla linea sottostante.
    17spl_autoload_call()JROOT/components/com_kunena/router.php:38
    16KunenaBuildRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    15Joomla\CMS\Component\Router\RouterLegacy->build()JROOT/libraries/src/Router/SiteRouter.php:528
    14Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:498
    13Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    12Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    11Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:102
    10Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:52
    9Joomla\CMS\Router\Route::_()JROOT/templates/theme3348/includes/includes.php:170
    8include_once JROOT/templates/theme3348/includes/includes.phpJROOT/templates/theme3348/index.php:2
    7require JROOT/templates/theme3348/index.phpJROOT/libraries/src/Document/HtmlDocument.php:658
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:720
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:535
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1037
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:209
    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: 0.44 ms Dopo l'ultima query: 116.41 ms Memoria query: 0.026 MB memoria prima della query: 4.604 MB Righe restituite: 10
    Query duplicate: #8
    SELECT * 
      FROM mrfej_loginradius_settings
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_loginradius_settingsALLNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL10
    Profilo
    StatusDuration
    Starting0.11 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
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.04 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1500
    12JDatabaseDriver->loadAssocList()JROOT/modules/mod_socialloginandsocialshare/helper.php:96
    11modSocialLoginAndSocialShareHelper::sociallogin_getsettings()JROOT/modules/mod_socialloginandsocialshare/mod_socialloginandsocialshare.php:19
    10include JROOT/modules/mod_socialloginandsocialshare/mod_socialloginandsocialshare.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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1051
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:209
    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: 0.49 ms Dopo l'ultima query: 269.30 ms Memoria query: 0.028 MB memoria prima della query: 4.826 MB Righe restituite: 1
    SELECT id,parent_id 
      FROM mrfej_menu
      WHERE id = 285
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_menuconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    Starting0.12 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.06 ms
    Preparing0.00 ms
    Unlocking tables0.02 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    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:46
    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:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3348/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3348/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1051
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:209
    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: 1.90 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.028 MB memoria prima della query: 4.837 MB Righe restituite: 1
    SELECT id,parent_id 
      FROM mrfej_menu
      WHERE id = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrfej_menuconstPRIMARYPRIMARY4const1
    Profilo
    StatusDuration
    Starting0.07 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics1.59 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.05 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    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:46
    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:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3348/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3348/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1051
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:209
    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: 0.67 ms Dopo l'ultima query: 10.99 ms Memoria query: 0.030 MB memoria prima della query: 4.926 MB Righe restituite: 1
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM mrfej_modules AS m
      LEFT JOIN mrfej_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.id in(195)
      AND m.published > 0
      ORDER BY position, ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmconstPRIMARY,publishedPRIMARY4const1Using temporary
    1SIMPLEmmrefPRIMARYPRIMARY4const1Using index
    Profilo
    StatusDuration
    Starting0.14 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.09 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.02 ms
    Creating tmp table0.03 ms
    Executing0.00 ms
    Sending data0.03 ms
    Removing duplicates0.01 ms
    Removing tmp table0.01 ms
    Removing duplicates0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.04 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile e numero di linea
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    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:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3348/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3348/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    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:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1051
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:209
    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 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:
  1. 10 × SELECT `m`.`tag_id`,`t`.* 
      FROM `mrfej_contentitem_tag_map` AS m
      INNER JOIN `mrfej_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  2. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `mrfej_assets`
  3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `mrfej_extensions`
  4. 2 × SELECT id,parent_id 
      FROM mrfej_menu
  5. 2 × SELECT * 
      FROM mrfej_loginradius_setting
  6. 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 mrfej_content AS a
      LEFT JOIN mrfej_categories AS c
      ON c.id = a.catid
      LEFT JOIN mrfej_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN mrfej_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN mrfej_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN mrfej_content_rating AS v
      ON a.id = v.content_id
  7. 1 × SELECT * 
      FROM mrfej_kunena_configuration
  8. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM mrfej_modules AS m
      LEFT JOIN mrfej_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN mrfej_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  9. 1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM mrfej_fields AS a
      LEFT JOIN `mrfej_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN mrfej_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN mrfej_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN mrfej_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN mrfej_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `mrfej_fields_categories` AS fc
      ON fc.field_id = a.id
  10. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `mrfej_categories` AS `s`
      INNER JOIN `mrfej_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  11. 1 × SELECT COUNT(*) 
      FROM mrfej_content AS a
      LEFT JOIN mrfej_categories AS c
      ON c.id = a.catid
      LEFT JOIN mrfej_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN mrfej_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN mrfej_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN mrfej_content_rating AS v
      ON a.id = v.content_id
  12. 1 × SELECT `data` 
      FROM `mrfej_session`
  13. 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 `mrfej_content` AS `i`
  14. 1 × SELECT `session_id` 
      FROM `mrfej_session`
  15. 1 × SELECT id, home, template, s.params 
      FROM mrfej_template_styles as s
      LEFT JOIN mrfej_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  16. 1 × SELECT * 
      FROM mrfej_languages
  17. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM mrfej_menu AS m
      LEFT JOIN mrfej_extensions AS e
      ON m.component_id = e.extension_id
  18. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM mrfej_extensions
  19. 1 × SELECT b.id 
      FROM mrfej_usergroups AS a
      LEFT JOIN mrfej_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  20. 1 × SELECT id, rules 
      FROM `mrfej_viewlevels
  21. 1 × SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM mrfej_modules AS m
      LEFT JOIN mrfej_modules_menu AS mm
      ON mm.moduleid = m.id
ALTRE tabelle:
  1. 1 × INSERT INTO `mrfej_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('i0ll6i9a7bo1110tcee1s6nnp7', 1, 1695523768, 0, '', 0
  2. 1 × UPDATE `mrfej_extensions` 
      SET `params` = '{\"mediaversion\":\"307c4133f5aaad57ab890aa17c736548\"}'