LIGUE D'AEROMODELISME NOUVELLE-AQUITAINE

Essai2

Filters
List of articles in category Exploits et réalisations pendant le confinement
Titre
Fouga de Jacques (2)
Le Longtarin de Michel Gauthier
  • Accueil
  • /Les réalisations des modélistes

Menu principal

  • ASSEMBLEE GENERALE 2022
  • Accueil
  • Nos jeunes
  • NOUVELLES DES CLUBS
  • Trouver un club et la carte des exemptions de signalement
  • PROCHAINES ACTIVITES EN AQUITAINE
  • PROCHAINES ACTIVITES DES CLUBS
  • NEWS de la FFAM
  • Le réseau de contrôle sportif (juges aquitains),examinateurs QPDD, officiels ailes, rotors et brevets
  • DATES A RETENIR (dont QPDD, ailes et brevets, Nouvelle Aquitaine)
  • JOURNEES LIGUE d'AEROMODELISME NOUVELLE AQUITAINE 2018
  • les bonnes adresses pour les clubs
  • LES EXAMENS DE PILOTES DE DEMONSTRATIONS
  • Offres commerciales
  • JOURNEE LIGUE 2019
  • L'Agence Nationale du Sport (ANS)
  • Les réalisations des modélistes
  • ACTIVITES PASSEES LIGUE

Haut de page

© 2023 LIGUE D'AEROMODELISME NOUVELLE-AQUITAINE

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695807509,
                "last": 1695807509,
                "now": 1695807509
            },
            "client": {
                "forwarded": "34.239.148.127"
            },
            "token": "mm6scEHRcosciTwy3lB3jKaj2SehHKe0"
        },
        "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
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 6.91 ms / 6.91 ms Mémoire: 0.415 MB / 0.75 MB Application: afterLoad
Temps: 21.19 ms / 28.11 ms Mémoire: 0.945 MB / 1.69 MB Application: afterInitialise
Temps: 3.16 ms / 31.27 ms Mémoire: 0.142 MB / 1.83 MB Application: afterRoute
Temps: 0.69 ms / 31.96 ms Mémoire: 0.034 MB / 1.87 MB Application: beforeRenderComponent com_content
Temps: 2.42 ms / 34.38 ms Mémoire: 0.160 MB / 2.03 MB Application: Before Access::preloadComponents (all components)
Temps: 0.86 ms / 35.24 ms Mémoire: 0.054 MB / 2.08 MB Application: After Access::preloadComponents (all components)
Temps: 0.02 ms / 35.26 ms Mémoire: -0.003 MB / 2.08 MB Application: Before Access::preloadPermissions (com_content)
Temps: 0.85 ms / 36.11 ms Mémoire: 0.262 MB / 2.34 MB Application: After Access::preloadPermissions (com_content)
Temps: 0.03 ms / 36.14 ms Mémoire: -0.018 MB / 2.32 MB Application: Before Access::getAssetRules (id:276 name:com_content.category.50)
Temps: 0.23 ms / 36.37 ms Mémoire: 0.009 MB / 2.33 MB Application: After Access::getAssetRules (id:276 name:com_content.category.50)
Temps: 1.71 ms / 38.07 ms Mémoire: 0.036 MB / 2.37 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Temps: 0.01 ms / 38.09 ms Mémoire: 0.002 MB / 2.37 MB Application: After Access::getAssetRules (id:8 name:com_content)
Temps: 17.88 ms / 55.97 ms Mémoire: 0.320 MB / 2.69 MB Application: afterRenderComponent com_content
Temps: 0.82 ms / 56.79 ms Mémoire: 0.005 MB / 2.69 MB Application: afterDispatch
Temps: 3.43 ms / 60.22 ms Mémoire: 0.047 MB / 2.74 MB Application: beforeRenderModule mod_menu (Menu principal)
Temps: 2.70 ms / 62.92 ms Mémoire: 0.168 MB / 2.91 MB Application: afterRenderModule mod_menu (Menu principal)
Temps: 0.04 ms / 62.96 ms Mémoire: -0.003 MB / 2.90 MB Application: beforeRenderModule mod_breadcrumbs (Fil de navigation)
Temps: 0.57 ms / 63.53 ms Mémoire: 0.010 MB / 2.91 MB Application: afterRenderModule mod_breadcrumbs (Fil de navigation)
Temps: 0.99 ms / 64.51 ms Mémoire: 0.090 MB / 3.00 MB Application: afterRender

Total de requêtes base de données : 9.51 ms

Occupation de la mémoire

3,41 MB (3 579 904 Bytes)

Requêtes de base de données

26 requêtes exécutées 9.51 ms


  1. Temps de requête : 0.20 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.027 MB Rangées retournées : 0
    SELECT `data`
    
      FROM `y5gw2_session`
      WHERE `session_id` = X'6c307133357261686f34316f757274616e6b6a346d7064766335'
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEy5gw2_sessionconstPRIMARYPRIMARY194const1
    Profil
    StatusDuration
    Starting0.01 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.02 ms
    Checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.00 ms
    Executing0.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.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Same as call in the line below.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:661
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:621
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:499
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:456
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:826
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  2. Temps de requête : 0.12 ms Après la dernière requête : 0.50 ms Mémoire de requête : 0.020 MB mémoire avant requête : 1.041 MB Rangées retournées : 0
    SELECT `session_id`
    
      FROM `y5gw2_session`
      WHERE `session_id` = X'6c307133357261686f34316f757274616e6b6a346d7064766335'
      LIMIT 1
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEy5gw2_sessionconstPRIMARYPRIMARY194const1Using index
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.01 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
    Statistics0.01 ms
    Preparing0.00 ms
    Executing0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  3. Temps de requête : 0.21 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.046 MB
    INSERT INTO `y5gw2_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6c307133357261686f34316f757274616e6b6a346d7064766335', 1, 1695807509, 0, '', 0)
    Explication
    EXPLAIN impossible sur la requête : INSERT INTO `y5gw2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6c307133357261686f34316f757274616e6b6a346d7064766335', 1, 1695807509, 0, '', 0)
    Profil
    StatusDuration
    Starting0.02 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.07 ms
    Waiting for query cache lock0.00 ms
    Update0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.05 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  4. Temps de requête : 0.34 ms Après la dernière requête : 0.57 ms Mémoire de requête : 0.024 MB mémoire avant requête : 1.078 MB Rangées retournées : 36
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `y5gw2_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEy5gw2_extensionsrefextensionextension82const36Using index condition; Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.03 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.01 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.13 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Same as call in the line below.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:594
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  5. Temps de requête : 0.13 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.102 MB Rangées retournées : 3
    SELECT id, rules
    
      FROM `y5gw2_viewlevels`
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEy5gw2_viewlevelsALLNULLINDEX N'A PU ÊTRE UTILISÉNULLNULL3
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.01 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.00 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  6. Temps de requête : 0.19 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.114 MB Rangées retournées : 1
    SELECT b.id
    
      FROM y5gw2_usergroups AS a
      LEFT JOIN y5gw2_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 1
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL1Using where; Using index
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.02 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
    Statistics0.03 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  7. Temps de requête : 0.59 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.030 MB mémoire avant requête : 1.135 MB Rangées retournées : 82
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM y5gw2_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1)
      ORDER BY ordering
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEy5gw2_extensionsrefextensionextension82const103Using index condition; Using where; Utilisation du tri complet de type filesort
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.03 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.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.36 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:351
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:356
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  8. Temps de requête : 0.20 ms Après la dernière requête : 7.30 ms Mémoire de requête : 0.025 MB mémoire avant requête : 1.555 MB Rangées retournées : 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `y5gw2_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEy5gw2_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.02 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
    Statistics0.04 ms
    Preparing0.01 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.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    20JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    19Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    18call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    16Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    15Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    14Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    13Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    12Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    11Joomla\CMS\Factory::getDocument()JROOT/plugins/system/helix/core/helix.php:50
    10Helix::getDocument()JROOT/plugins/system/helix/core/helix.php:36
    9Helix::getInstance()JROOT/plugins/system/helix/helix.php:21
    8plgSystemHelix->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  9. Temps de requête : 0.20 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.007 MB mémoire avant requête : 1.549 MB
    UPDATE `y5gw2_extensions`
    
      SET `params` = '{\"mediaversion\":\"5562a7cf5bb7e15fb6726de9654e6646\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explication
    EXPLAIN impossible sur la requête : UPDATE `y5gw2_extensions` SET `params` = '{\"mediaversion\":\"5562a7cf5bb7e15fb6726de9654e6646\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profil
    StatusDuration
    Starting0.02 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.04 ms
    Updating0.06 ms
    End of update loop0.00 ms
    Waiting for query cache lock0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.02 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    15Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    14Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    13Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    12Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    11Joomla\CMS\Factory::getDocument()JROOT/plugins/system/helix/core/helix.php:50
    10Helix::getDocument()JROOT/plugins/system/helix/core/helix.php:36
    9Helix::getInstance()JROOT/plugins/system/helix/helix.php:21
    8plgSystemHelix->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  10. Temps de requête : 0.43 ms Après la dernière requête : 0.81 ms Mémoire de requête : 0.066 MB mémoire avant requête : 1.594 MB Rangées retournées : 20
    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 y5gw2_menu AS m
      LEFT JOIN y5gw2_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
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const34Using index condition; Using where; Utilisation du tri complet de type filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4ffam-lamna.m.component_id1Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.04 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.01 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.20 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.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    23Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    22call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    21Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    20Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:78
    19Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    18Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:142
    17Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:417
    16Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    15Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:434
    14Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/plugins/system/helix/core/helix.php:65
    13Helix::themeName()JROOT/plugins/system/helix/core/helix.php:114
    12Helix::themePath()JROOT/plugins/system/helix/core/helix.php:302
    11Helix::_Import()JROOT/plugins/system/helix/core/helix.php:290
    10Helix::Import()JROOT/plugins/system/helix/core/helix.php:1592
    9Helix::loadHelixOverwrite()JROOT/plugins/system/helix/helix.php:22
    8plgSystemHelix->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  11. Temps de requête : 0.29 ms Après la dernière requête : 0.41 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.675 MB Rangées retournées : 6
    SELECT id, home, template, s.params
    
      FROM y5gw2_template_styles as s
      LEFT JOIN y5gw2_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
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsALLidx_template,idx_client_id,idx_client_id_homeINDEX N'A PU ÊTRE UTILISÉNULLNULL10Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403ffam-lamna.s.template,const1Using index condition; Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.03 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.01 ms
    Statistics0.04 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.07 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.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    14Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/plugins/system/helix/core/helix.php:65
    13Helix::themeName()JROOT/plugins/system/helix/core/helix.php:114
    12Helix::themePath()JROOT/plugins/system/helix/core/helix.php:302
    11Helix::_Import()JROOT/plugins/system/helix/core/helix.php:290
    10Helix::Import()JROOT/plugins/system/helix/core/helix.php:1592
    9Helix::loadHelixOverwrite()JROOT/plugins/system/helix/helix.php:22
    8plgSystemHelix->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  12. Temps de requête : 0.19 ms Après la dernière requête : 6.02 ms Mémoire de requête : 0.020 MB mémoire avant requête : 1.848 MB Rangées retournées : 2
    SELECT *
    
      FROM y5gw2_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEy5gw2_languagesALLNULLINDEX N'A PU ÊTRE UTILISÉNULLNULL2Using where; Utilisation du tri complet de type filesort
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.01 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
    Statistics0.01 ms
    Preparing0.01 ms
    Sorting result0.00 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.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.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  13. Temps de requête : 0.72 ms Après la dernière requête : 2.86 ms Mémoire de requête : 0.028 MB mémoire avant requête : 2.032 MB Rangées retournées : 36
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `y5gw2_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_installer','com_jaextmanager','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEy5gw2_assetsALLidx_asset_nameINDEX N'A PU ÊTRE UTILISÉNULLNULL305Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.03 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.04 ms
    Optimizing0.01 ms
    Statistics0.08 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.45 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    18Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  14. Temps de requête : 0.46 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.068 MB mémoire avant requête : 2.080 MB Rangées retournées : 264
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `y5gw2_assets`
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEy5gw2_assetsALLidx_asset_name,idx_parent_idINDEX N'A PU ÊTRE UTILISÉNULLNULL305Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.02 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
    Statistics0.03 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.27 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    18Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  15. Temps de requête : 0.58 ms Après la dernière requête : 1.23 ms Mémoire de requête : 0.026 MB mémoire avant requête : 2.329 MB Rangées retournées : 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
      FROM `y5gw2_content` AS `i`
      WHERE i.`catid` = c.id
      AND i.state = 1) AS numitems
      FROM `y5gw2_categories` AS `s`
      INNER JOIN `y5gw2_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 = 50
      ORDER BY c.lft
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1
    1PRIMARYcALLcat_idx,idx_left_rightINDEX N'A PU ÊTRE UTILISÉNULLNULL52Using where; Utilisation du tri complet de type filesort
    2DEPENDENT SUBQUERYirefidx_state,idx_catididx_catid4ffam-lamna.c.id4Using index condition; Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.08 ms
    Checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.04 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Sorting result0.00 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.09 ms
    Executing0.00 ms
    Sending data0.02 ms
    Executing0.00 ms
    Sending data0.01 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.00 ms
    Freeing items0.00 ms
    Removing tmp table0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    15Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    14Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/models/category.php:355
    13ContentModelCategory->getCategory()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:122
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  16. Temps de requête : 0.64 ms Après la dernière requête : 0.54 ms Mémoire de requête : 0.058 MB mémoire avant requête : 2.367 MB Rangées retournées : 2
    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 y5gw2_content AS a
      LEFT JOIN y5gw2_categories AS c
      ON c.id = a.catid
      LEFT JOIN y5gw2_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN y5gw2_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN y5gw2_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN y5gw2_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND c.published = 1
      AND a.state = 1
      AND a.catid = 50
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-27 09:38:29')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-27 09:38:29')
      ORDER BY c.lft,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END , a.created
      LIMIT 10
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
    1SIMPLEaindex_mergeidx_access,idx_state,idx_catididx_catid,idx_state4,1NULL1Using intersect(idx_catid,idx_state); Using where; Utilisation du tri complet de type filesort
    1SIMPLEuaeq_refPRIMARYPRIMARY4ffam-lamna.a.created_by1Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4ffam-lamna.a.modified_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4const1Using where
    1SIMPLEveq_refPRIMARYPRIMARY4ffam-lamna.a.id1Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.14 ms
    Checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.06 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.17 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.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  17. Temps de requête : 0.24 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.429 MB Rangées retournées : 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `y5gw2_contentitem_tag_map` AS m
      INNER JOIN `y5gw2_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 190
      AND `t`.`published` = 1
      AND t.access IN (1,1)
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeINDEX N'A PU ÊTRE UTILISÉNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4ffam-lamna.m.tag_id1Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.03 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.03 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    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:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  18. Temps de requête : 0.21 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.450 MB Rangées retournées : 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `y5gw2_contentitem_tag_map` AS m
      INNER JOIN `y5gw2_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 191
      AND `t`.`published` = 1
      AND t.access IN (1,1)
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeINDEX N'A PU ÊTRE UTILISÉNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4ffam-lamna.m.tag_id1Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.03 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.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    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:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  19. Temps de requête : 0.37 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.466 MB Rangées retournées : 1
    SELECT COUNT(*)
    
      FROM y5gw2_content AS a
      LEFT JOIN y5gw2_categories AS c
      ON c.id = a.catid
      LEFT JOIN y5gw2_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN y5gw2_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN y5gw2_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN y5gw2_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND c.published = 1
      AND a.state = 1
      AND a.catid = 50
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-27 09:38:29')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-27 09:38:29')
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
    1SIMPLEaindex_mergeidx_access,idx_state,idx_catididx_catid,idx_state4,1NULL1Using intersect(idx_catid,idx_state); Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.05 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.06 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.09 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.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    17JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:289
    15Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:239
    14Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  20. Temps de requête : 0.23 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.472 MB Rangées retournées : 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `y5gw2_contentitem_tag_map` AS m
      INNER JOIN `y5gw2_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 50
      AND `t`.`published` = 1
      AND t.access IN (1,1)
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeINDEX N'A PU ÊTRE UTILISÉNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4ffam-lamna.m.tag_id1Using where
    Profil
    StatusDuration
    Starting0.01 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.03 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.01 ms
    Statistics0.03 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.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    12Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/libraries/src/MVC/View/CategoryView.php:229
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  21. Temps de requête : 0.40 ms Après la dernière requête : 1.21 ms Mémoire de requête : 0.027 MB mémoire avant requête : 2.575 MB Rangées retournées : 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `y5gw2_categories` AS `s`
      INNER JOIN `y5gw2_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)
      AND c.published = 1
      AND s.id = 50
      ORDER BY c.lft
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightINDEX N'A PU ÊTRE UTILISÉNULLNULL52Using where; Utilisation du tri complet de type filesort
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.06 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.06 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.09 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  22. Temps de requête : 0.73 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.596 MB Rangées retournées : 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM y5gw2_fields AS a
      LEFT JOIN `y5gw2_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN y5gw2_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN y5gw2_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN y5gw2_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN y5gw2_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `y5gw2_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 (50,0,49))
      AND a.access IN (1,1)
      AND (a.group_id = 0 OR g.access IN (1,1))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Utilisation du tri complet de type filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28ffam-lamna.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4ffam-lamna.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4ffam-lamna.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4ffam-lamna.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4ffam-lamna.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4ffam-lamna.a.id1Using where; Using index; Distinct
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.08 ms
    Checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.01 ms
    Table lock0.00 ms
    Init0.04 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.03 ms
    Creating tmp table0.04 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.23 ms
    Creating sort index0.02 ms
    Removing tmp table0.05 ms
    Creating sort index0.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.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  23. Temps de requête : 0.20 ms Après la dernière requête : 0.49 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.625 MB Rangées retournées : 1
    SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
    
      FROM `y5gw2_contact_details` AS `contact`
      WHERE contact.published = 1
      AND contact.user_id = 983
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcontactrefidx_stateidx_state1const1Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.03 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.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    15JDatabaseDriver->loadObject()JROOT/plugins/content/contact/contact.php:125
    14PlgContentContact->getContactData()JROOT/plugins/content/contact/contact.php:66
    13PlgContentContact->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  24. Temps de requête : 0.63 ms Après la dernière requête : 7.50 ms Mémoire de requête : 0.028 MB mémoire avant requête : 2.690 MB Rangées retournées : 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM y5gw2_fields AS a
      LEFT JOIN `y5gw2_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN y5gw2_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN y5gw2_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN y5gw2_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN y5gw2_fields_groups AS g
      ON g.id = a.group_id
      WHERE a.context = 'com_content.categories'
      AND a.access IN (1,1)
      AND (a.group_id = 0 OR g.access IN (1,1))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Utilisation du tri complet de type filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28ffam-lamna.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4ffam-lamna.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4ffam-lamna.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4ffam-lamna.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4ffam-lamna.a.group_id1Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.07 ms
    Checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.02 ms
    Creating tmp table0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.20 ms
    Creating sort index0.02 ms
    Removing tmp table0.04 ms
    Creating sort index0.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.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    26JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    25JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    24Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    23FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    22Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    21FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    20PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    19JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    18JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:25
    17include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/src/Layout/FileLayout.php:125
    16Joomla\CMS\Layout\FileLayout->render()JROOT/libraries/src/Layout/LayoutHelper.php:73
    15Joomla\CMS\Layout\LayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    14include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  25. Temps de requête : 0.65 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.029 MB mémoire avant requête : 2.705 MB Rangées retournées : 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM y5gw2_fields AS a
      LEFT JOIN `y5gw2_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN y5gw2_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN y5gw2_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN y5gw2_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN y5gw2_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `y5gw2_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.categories'
      AND (fc.category_id IS NULL OR fc.category_id IN (50,0,49))
      AND a.access IN (1,1)
      AND (a.group_id = 0 OR g.access IN (1,1))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Utilisation du tri complet de type filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28ffam-lamna.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4ffam-lamna.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4ffam-lamna.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4ffam-lamna.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4ffam-lamna.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4ffam-lamna.a.id1Using where; Using index; Distinct
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.08 ms
    Checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.04 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Creating tmp table0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.19 ms
    Creating sort index0.01 ms
    Removing tmp table0.05 ms
    Creating sort index0.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.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    26JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    25Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    24FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    23Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    22FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:404
    21PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:324
    20PlgSystemFields->onContentAfterTitle()JROOT/libraries/joomla/event/event.php:70
    19JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    18JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:28
    17include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/src/Layout/FileLayout.php:125
    16Joomla\CMS\Layout\FileLayout->render()JROOT/libraries/src/Layout/LayoutHelper.php:73
    15Joomla\CMS\Layout\LayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    14include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  26. Temps de requête : 0.36 ms Après la dernière requête : 6.07 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.741 MB Rangées retournées : 2
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM y5gw2_modules AS m
      LEFT JOIN y5gw2_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN y5gw2_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-27 09:38:29')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-27 09:38:29')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 144 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrangePRIMARY,published,newsfeedspublished5NULL3Using index condition; Using where; Utilisation du tri complet de type filesort
    1SIMPLEmmrefPRIMARYPRIMARY4ffam-lamna.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403ffam-lamna.m.module,const1Using index condition; Using where
    Profil
    StatusDuration
    Starting0.00 ms
    Waiting for query cache lock0.00 ms
    Init0.00 ms
    Checking query cache for query0.05 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.04 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.08 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.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:441
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:601
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:91
    7require JROOT/templates/protostar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1098
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

21 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :
  1. 3 × SELECT `m`.`tag_id`,`t`.* 
      FROM `y5gw2_contentitem_tag_map` AS m
      INNER JOIN `y5gw2_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  2. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `y5gw2_assets`
  3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `y5gw2_extensions`
  4. 2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM y5gw2_fields AS a
      LEFT JOIN `y5gw2_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN y5gw2_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN y5gw2_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN y5gw2_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN y5gw2_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `y5gw2_fields_categories` AS fc
      ON fc.field_id = a.id
  5. 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 y5gw2_content AS a
      LEFT JOIN y5gw2_categories AS c
      ON c.id = a.catid
      LEFT JOIN y5gw2_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN y5gw2_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN y5gw2_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN y5gw2_content_rating AS v
      ON a.id = v.content_id
  6. 1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM y5gw2_fields AS a
      LEFT JOIN `y5gw2_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN y5gw2_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN y5gw2_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN y5gw2_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN y5gw2_fields_groups AS g
      ON g.id = a.group_id
  7. 1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to 
      FROM `y5gw2_contact_details` AS `contact`
  8. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `y5gw2_categories` AS `s`
      INNER JOIN `y5gw2_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  9. 1 × SELECT COUNT(*) 
      FROM y5gw2_content AS a
      LEFT JOIN y5gw2_categories AS c
      ON c.id = a.catid
      LEFT JOIN y5gw2_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN y5gw2_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN y5gw2_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN y5gw2_content_rating AS v
      ON a.id = v.content_id
  10. 1 × SELECT `data` 
      FROM `y5gw2_session`
  11. 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 `y5gw2_content` AS `i`
  12. 1 × SELECT `session_id` 
      FROM `y5gw2_session`
  13. 1 × SELECT * 
      FROM y5gw2_languages
  14. 1 × SELECT id, home, template, s.params 
      FROM y5gw2_template_styles as s
      LEFT JOIN y5gw2_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  15. 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 y5gw2_menu AS m
      LEFT JOIN y5gw2_extensions AS e
      ON m.component_id = e.extension_id
  16. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM y5gw2_extensions
  17. 1 × SELECT b.id 
      FROM y5gw2_usergroups AS a
      LEFT JOIN y5gw2_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  18. 1 × SELECT id, rules 
      FROM `y5gw2_viewlevels
  19. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM y5gw2_modules AS m
      LEFT JOIN y5gw2_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN y5gw2_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
Autres tables :
  1. 1 × INSERT INTO `y5gw2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6c307133357261686f34316f757274616e6b6a346d7064766335', 1, 1695807509, 0, '', 0
  2. 1 × UPDATE `y5gw2_extensions` 
      SET `params` = '{\"mediaversion\":\"5562a7cf5bb7e15fb6726de9654e6646\"}'