CNPF

CNPF
  • CNPF
      • Mot de la présidence
      • Conseil d'administration
      • Membres de l'équipe et organismes membres de la CNPF
      • Nos partenaires
      • La CNPF en image
      • Espace des membres
  • Continuum de ressources
      • Petite enfance
      • Élémentaire
      • Secondaire
      • Postsecondaire
  • Publication
      • Nouvelles de la CNPF
      • Communiqués de presse
      • Rapports annuels
      • Planification stratégique
      • On parle de nous
  • Initiatives
      • Petite enfance
      • Intégration des nouveaux arrivants
      • Valoriser le français des parents
      • Parents d’ados et de jeunes adultes
      • Pour le développement social
      • Conversation pour parents
      • Voir loin voir grand
      • Familles exogames 
  • Contact
  • Accueil | 
  • Publication | 
  • Communiqués de presse | 
  • Assemblée générale annuelle de la CNPF
Assemblée générale annuelle de la CNPF

Ottawa, le 8 novembre 2021 – La Commission nationale des parents francophones (CNPF) a tenu le 3 novembre dernier sa 41 e Assemblée générale annuelle. Compte tenu de la pandémie, il s’agissait d’une deuxième AGA à s’être déroulée virtuellement.

La force de notre réseau de parents s’est exprimée et c’est une chance de compter sur des personnes extraordinaires, engagées et passionnées pour la cause dans des parents et par la Francophonie.

Les membres de la CNPF ont élu pour un premier mandat à titre de présidente, Gillian Anderson. Le président sortant M. Louis Kdouh a été élu vice-président de la CNPF.

Madame Gillian Anderson est la maman de trois enfants d’une famille exogame. Toujours très impliquée dans sa communauté, elle siège sur plusieurs comités dont des conseilsGillian2017 d'écoles, des associations de parents et plusieurs équipes sportives. La francophonie lui tient à coeur et tous ses enfants sont inscrits dans des écoles francophones. Elle est engagée très activement depuis plusieurs années à défendre la cause des parents francophones en situation minoritaire en rejoignant en 2021 le conseil d’administration de la Fédération des parents francophones de l’Alberta (FPFA) et en devenant la présidente de l’organisme de 2017 à 2021. Depuis 2018, Gillian Anderson est aussi la vice-présidente de la CNPF.

Voici la composition du nouveau conseil d’administration 2021-2022 de la CNPF

Gillian Anderson, présidence
Louis Kdouh, vice-présidence
Paul Baril (Ontario)
Melissa MacDonald (Île-du-Prince-Édouard)
Suzana Straus (Colombie-Britannique)
Jacques Lamarche (Territoire-du-Nord-Ouest)
Leslie Larbalestrier (Yukon)
Edgard Assoua (Saskatchewan)
Nadine Morton (Alberta)
Kristin Chartrand (Manitoba)
Caroline Arsenault (Nouvelle-Écosse)
Annette Hondas (Nouveau-Brunswick)

La CNPF aimerait profiter de cette occasion pour remercier Louis Kdouh pour les 4 années passées à servir la CNPF au poste de la présidence de la CNPF, ainsi que Badrieh Kojok et Philolin Ngomo pour leur profond engagement et leur dévouement au sein de la CNPF et dont le mandat au conseil d’administration de la CNPF s’est terminé.

La Commission nationale des parents francophones (CNPF) est un organisme sans but lucratif dont la mission consiste à regrouper, représenter et appuyer les organismes provinciaux et territoriaux tout en renforçant leur capacité d’accompagner le parent dans son milieu familial et communautaire. La CNPF travaille étroitement avec de nombreux partenaires nationaux qui agissent dans les secteurs de l’éducation, de la petite enfance et de la représentation des communautés francophones et acadienne du Canada.

 

- 30 -

 

Renseignements :
Myriam Romanin
Agente de communication
(613) 288-0958 poste 4
communications@cnpf.ca

 

Crédit Photo: FPFA

Recherche

Publication

  • Nouvelles de la CNPF
  • Communiqués de presse
  • Rapports annuels
  • Planification stratégique
  • Bulletins électronique
  • On parle de nous
CNPF

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679734032,
                "last": 1679734032,
                "now": 1679734032
            }
        },
        "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: 43.78 ms / 43.78 ms Mémoire: 1.790 MB / 2.17 MB Application: afterLoad
Temps: 112.49 ms / 156.26 ms Mémoire: 4.765 MB / 6.93 MB Application: afterInitialise
Temps: 32.29 ms / 188.56 ms Mémoire: 1.401 MB / 8.33 MB Application: afterRoute
Temps: 11.25 ms / 199.80 ms Mémoire: 0.397 MB / 8.73 MB Application: beforeRenderComponent com_content
Temps: 3.67 ms / 203.47 ms Mémoire: 0.234 MB / 8.96 MB Application: Before Access::preloadComponents (all components)
Temps: 2.63 ms / 206.11 ms Mémoire: 0.072 MB / 9.03 MB Application: After Access::preloadComponents (all components)
Temps: 0.10 ms / 206.21 ms Mémoire: 0.000 MB / 9.03 MB Application: Before Access::preloadPermissions (com_content)
Temps: 7.38 ms / 213.59 ms Mémoire: 0.766 MB / 9.80 MB Application: After Access::preloadPermissions (com_content)
Temps: 0.08 ms / 213.68 ms Mémoire: 0.000 MB / 9.76 MB Application: Before Access::getAssetRules (id:1526 name:com_content.article.729)
Temps: 0.90 ms / 214.58 ms Mémoire: 0.027 MB / 9.79 MB Application: After Access::getAssetRules (id:1526 name:com_content.article.729)
Temps: 79.10 ms / 293.68 ms Mémoire: 1.759 MB / 11.55 MB Application: afterRenderComponent com_content
Temps: 2.21 ms / 295.89 ms Mémoire: 0.098 MB / 11.65 MB Application: afterDispatch
Temps: 13.96 ms / 309.85 ms Mémoire: 0.257 MB / 11.90 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher(do not delete))
Temps: 3.00 ms / 312.85 ms Mémoire: 0.041 MB / 11.94 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Temps: 0.16 ms / 313.01 ms Mémoire: 0.007 MB / 11.95 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Temps: 1.90 ms / 314.91 ms Mémoire: 0.016 MB / 11.97 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher(do not delete))
Temps: 0.17 ms / 315.08 ms Mémoire: 0.001 MB / 11.97 MB Application: beforeRenderModule mod_search (Recherche)
Temps: 2.75 ms / 317.83 ms Mémoire: 0.017 MB / 11.98 MB Application: afterRenderModule mod_search (Recherche)
Temps: 0.10 ms / 317.93 ms Mémoire: 0.000 MB / 11.98 MB Application: beforeRenderModule mod_menu (Publication)
Temps: 5.93 ms / 323.86 ms Mémoire: 0.109 MB / 12.09 MB Application: afterRenderModule mod_menu (Publication)
Temps: 0.09 ms / 323.96 ms Mémoire: 0.000 MB / 12.09 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Temps: 1.58 ms / 325.54 ms Mémoire: 0.024 MB / 12.11 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Temps: 0.10 ms / 325.63 ms Mémoire: 0.000 MB / 12.11 MB Application: beforeRenderModule mod_icemegamenu (Main menu)
Temps: 40.76 ms / 366.40 ms Mémoire: 0.926 MB / 13.03 MB Application: afterRenderModule mod_icemegamenu (Main menu)
Temps: 5.41 ms / 371.80 ms Mémoire: 0.124 MB / 13.16 MB Application: afterRender

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

Occupation de la mémoire

13,63 MB (14 295 864 Bytes)

Requêtes de base de données

27 requêtes exécutées 47.86 ms


  1. Temps de requête : 0.97 ms Mémoire de requête : 0.005 MB mémoire avant requête : 3.987 MB Rangées retournées : 0
    SELECT `session_id`

      FROM `k7n8e_session`

      WHERE `session_id` = X'6164363234373161303733346138343830396335303131656633306235313664' 
      LIMIT 1
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_sessionconstPRIMARYPRIMARY194const1Using index
    Profil
    StatusDuration
    Starting0.18 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.02 ms
    Executing0.03 ms
    End of update loop0.03 ms
    Query end0.03 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.13 ms
    Updating status0.07 ms
    Reset for next command0.03 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    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:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    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 : 1.73 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.004 MB mémoire avant requête : 3.993 MB
    INSERT INTO `k7n8e_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES 
(X'6164363234373161303733346138343830396335303131656633306235313664', 1, 1679734032, 0, '', 0)
    Explication
    EXPLAIN impossible sur la requête : INSERT INTO `k7n8e_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6164363234373161303733346138343830396335303131656633306235313664', 1, 1679734032, 0, '', 0)
    Profil
    StatusDuration
    Starting0.14 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init for update0.02 ms
    Update0.08 ms
    Waiting for query cache lock0.01 ms
    Update0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.84 ms
    closing tables0.03 ms
    Unlocking tables0.02 ms
    closing tables0.03 ms
    Starting cleanup0.04 ms
    Freeing items0.18 ms
    Updating status0.12 ms
    Reset for next command0.03 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    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 : 1.90 ms Après la dernière requête : 4.70 ms Mémoire de requête : 0.006 MB mémoire avant requête : 4.207 MB Rangées retournées : 47
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

      FROM `k7n8e_extensions`

      WHERE `type` = 'component' 
      AND `state` = 0 
      AND `enabled` = 1
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_extensionsrefextensionextension82const50Using index condition; Using where
    Profil
    StatusDuration
    Starting0.31 ms
    checking permissions0.03 ms
    Opening tables0.07 ms
    After opening tables0.02 ms
    System lock0.04 ms
    table lock0.03 ms
    init0.05 ms
    Optimizing0.05 ms
    Statistics0.10 ms
    Preparing0.06 ms
    Executing0.02 ms
    Sending data0.57 ms
    End of update loop0.06 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.03 ms
    Starting cleanup0.03 ms
    Freeing items0.15 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    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}()Même appel que celui de la ligne ci-dessous.
    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:196
    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]
  4. Temps de requête : 1.09 ms Après la dernière requête : 3.23 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.406 MB Rangées retournées : 5
    SELECT id, rules

      FROM `k7n8e_viewlevels`
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_viewlevelsALLNULLINDEX N'A PU ÊTRE UTILISÉNULLNULL5
    Profil
    StatusDuration
    Starting0.26 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Executing0.02 ms
    Sending data0.11 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.04 ms
    Starting cleanup0.04 ms
    Freeing items0.15 ms
    Updating status0.06 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    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:321
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.21 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.419 MB Rangées retournées : 2
    SELECT b.id

      FROM k7n8e_usergroups AS a

      LEFT JOIN k7n8e_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

      WHERE a.id = 9
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2Using where; Using index
    Profil
    StatusDuration
    Starting0.21 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.04 ms
    Optimizing0.04 ms
    Statistics0.10 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.05 ms
    Executing0.02 ms
    Sending data0.10 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.03 ms
    closing tables0.03 ms
    Unlocking tables0.06 ms
    closing tables0.04 ms
    Starting cleanup0.01 ms
    Freeing items0.16 ms
    Updating status0.05 ms
    Reset for next command0.03 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    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:321
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 2.45 ms Après la dernière requête : 0.73 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.487 MB Rangées retournées : 132
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

      FROM k7n8e_extensions

      WHERE enabled = 1 
      AND type = 'plugin' 
      AND state IN (0,1) 
      AND access IN (1,1,5)

      ORDER BY ordering
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_extensionsALLextensionINDEX N'A PU ÊTRE UTILISÉNULLNULL371Using where; Utilisation du tri complet de type filesort
    Profil
    StatusDuration
    Starting0.27 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.06 ms
    Optimizing0.05 ms
    Statistics0.09 ms
    Preparing0.04 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.03 ms
    Creating sort index1.12 ms
    End of update loop0.04 ms
    Query end0.04 ms
    Commit0.03 ms
    closing tables0.03 ms
    Unlocking tables0.04 ms
    closing tables0.04 ms
    Starting cleanup0.04 ms
    Freeing items0.16 ms
    Updating status0.08 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:354
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Même appel que celui de la ligne ci-dessous.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:359
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.37 ms Après la dernière requête : 52.82 ms Mémoire de requête : 0.005 MB mémoire avant requête : 6.793 MB Rangées retournées : 10
    SELECT * 
      FROM k7n8e_loginradius_settings
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_loginradius_settingsALLNULLINDEX N'A PU ÊTRE UTILISÉNULLNULL10
    Profil
    StatusDuration
    Starting0.30 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.04 ms
    Optimizing0.03 ms
    Statistics0.12 ms
    Preparing0.04 ms
    Executing0.02 ms
    Sending data0.09 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Starting cleanup0.03 ms
    Freeing items0.17 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    10JDatabaseDriver->loadAssocList()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58
    9plgSystemSocialLoginTools::sociallogin_getsettings()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51
    8plgSystemSocialLoginAndSocialShare->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:626
    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:196
    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 : 3.97 ms Après la dernière requête : 7.83 ms Mémoire de requête : 0.009 MB mémoire avant requête : 7.115 MB Rangées retournées : 118
    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 k7n8e_menu AS m

      LEFT JOIN k7n8e_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_language1const199Using index condition; Using where; Utilisation du tri complet de type filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4cnpfca_cnpf.m.component_id1Using where
    Profil
    StatusDuration
    Starting0.31 ms
    checking permissions0.03 ms
    Opening tables0.09 ms
    After opening tables0.02 ms
    System lock0.03 ms
    table lock0.03 ms
    init0.07 ms
    Optimizing0.05 ms
    Statistics0.11 ms
    Preparing0.06 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.04 ms
    Creating sort index2.37 ms
    End of update loop0.04 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.04 ms
    Unlocking tables0.04 ms
    closing tables0.05 ms
    Starting cleanup0.06 ms
    Freeing items0.17 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Même appel que celui de la ligne ci-dessous.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:76
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:375
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:64
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:491
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1073
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.43 ms Après la dernière requête : 21.19 ms Mémoire de requête : 0.007 MB mémoire avant requête : 8.322 MB Rangées retournées : 0
    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 `k7n8e_categories` AS `s`

      INNER JOIN `k7n8e_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)

      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 729

      ORDER BY c.lft
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLINDEX N'A PU ÊTRE UTILISÉNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profil
    StatusDuration
    Starting0.40 ms
    checking permissions0.03 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.11 ms
    Optimizing0.07 ms
    Statistics0.09 ms
    Preparing0.02 ms
    Executing0.07 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.03 ms
    closing tables0.03 ms
    Unlocking tables0.03 ms
    closing tables0.03 ms
    Starting cleanup0.04 ms
    Freeing items0.19 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    12Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    11Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/helpers/legacyrouter.php:350
    10ContentRouterRulesLegacy->parse()JROOT/libraries/src/Component/Router/RouterView.php:266
    9Joomla\CMS\Component\Router\RouterView->parse()JROOT/libraries/src/Router/SiteRouter.php:437
    8Joomla\CMS\Router\SiteRouter->parseSefRoute()JROOT/libraries/src/Router/Router.php:482
    7Joomla\CMS\Router\Router->_parseSefRoute()JROOT/libraries/src/Router/Router.php:227
    6Joomla\CMS\Router\Router->parse()JROOT/libraries/src/Router/SiteRouter.php:138
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1074
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.09 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.006 MB mémoire avant requête : 8.327 MB Rangées retournées : 1
    SELECT `alias`,`catid`

      FROM `k7n8e_content`

      WHERE `id` = 729
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_contentconstPRIMARYPRIMARY4const1
    Profil
    StatusDuration
    Starting0.20 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.02 ms
    Unlocking tables0.04 ms
    Preparing0.03 ms
    Executing0.03 ms
    Sending data0.04 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.03 ms
    Unlocking tables0.02 ms
    closing tables0.06 ms
    Starting cleanup0.03 ms
    Freeing items0.15 ms
    Updating status0.06 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    11JDatabaseDriver->loadObject()JROOT/components/com_content/helpers/legacyrouter.php:366
    10ContentRouterRulesLegacy->parse()JROOT/libraries/src/Component/Router/RouterView.php:266
    9Joomla\CMS\Component\Router\RouterView->parse()JROOT/libraries/src/Router/SiteRouter.php:437
    8Joomla\CMS\Router\SiteRouter->parseSefRoute()JROOT/libraries/src/Router/Router.php:482
    7Joomla\CMS\Router\Router->_parseSefRoute()JROOT/libraries/src/Router/Router.php:227
    6Joomla\CMS\Router\Router->parse()JROOT/libraries/src/Router/SiteRouter.php:138
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1074
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.34 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.007 MB mémoire avant requête : 8.429 MB Rangées retournées : 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

      FROM `k7n8e_extensions`

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profil
    StatusDuration
    Starting0.27 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.04 ms
    Optimizing0.04 ms
    Statistics0.13 ms
    Preparing0.05 ms
    Executing0.02 ms
    Sending data0.10 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.03 ms
    closing tables0.07 ms
    Unlocking tables0.03 ms
    closing tables0.03 ms
    Starting cleanup0.03 ms
    Freeing items0.20 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Même appel que celui de la ligne ci-dessous.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1130
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 2.22 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.005 MB mémoire avant requête : 8.420 MB
    UPDATE `k7n8e_extensions`

      SET `params` = '{\"mediaversion\":\"836ac27461330f401f7c210a2e4e9e81\"}'

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Explication
    EXPLAIN impossible sur la requête : UPDATE `k7n8e_extensions` SET `params` = '{\"mediaversion\":\"836ac27461330f401f7c210a2e4e9e81\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profil
    StatusDuration
    Starting0.20 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init for update0.12 ms
    Updating0.15 ms
    End of update loop0.02 ms
    Waiting for query cache lock0.02 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit1.15 ms
    closing tables0.03 ms
    Unlocking tables0.02 ms
    closing tables0.03 ms
    Starting cleanup0.03 ms
    Freeing items0.15 ms
    Updating status0.07 ms
    Reset for next command0.01 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1130
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.32 ms Après la dernière requête : 2.49 ms Mémoire de requête : 0.003 MB mémoire avant requête : 8.605 MB Rangées retournées : 2
    SELECT *

      FROM k7n8e_languages

      WHERE published=1

      ORDER BY ordering ASC
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_languagesALLNULLINDEX N'A PU ÊTRE UTILISÉNULLNULL2Using where; Utilisation du tri complet de type filesort
    Profil
    StatusDuration
    Starting0.23 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.03 ms
    Preparing0.04 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.03 ms
    Creating sort index0.11 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.11 ms
    closing tables0.08 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Starting cleanup0.03 ms
    Freeing items0.15 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    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:196
    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 : 1.64 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.003 MB mémoire avant requête : 8.626 MB Rangées retournées : 12
    SELECT id, home, template, s.params

      FROM k7n8e_template_styles as s

      LEFT JOIN k7n8e_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
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionextension82const6Using index condition; Using where
    1SIMPLEsrefidx_templateidx_template202cnpfca_cnpf.e.element1Using index condition; Using where
    Profil
    StatusDuration
    Starting0.29 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.05 ms
    Optimizing0.05 ms
    Statistics0.11 ms
    Preparing0.06 ms
    Executing0.02 ms
    Sending data0.33 ms
    End of update loop0.03 ms
    Query end0.03 ms
    Commit0.12 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.03 ms
    Starting cleanup0.03 ms
    Freeing items0.15 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 2.35 ms Après la dernière requête : 5.08 ms Mémoire de requête : 0.009 MB mémoire avant requête : 8.967 MB Rangées retournées : 47
    SELECT `id`,`name`,`rules`,`parent_id`

      FROM `k7n8e_assets`

      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','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_jce','com_jmwascanner','com_joomailermailchimpintegration','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_search','com_slogin','com_socialloginandsocialshare','com_tags','com_tcpdf','com_templates','com_tmbox','com_uniterevolution2','com_users','com_weblinks','com_wrapper')
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_assetsrangeidx_asset_nameidx_asset_name202NULL48Using index condition
    Profil
    StatusDuration
    Starting0.31 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.17 ms
    Optimizing0.03 ms
    Statistics0.24 ms
    Preparing0.04 ms
    Executing0.02 ms
    Sending data0.90 ms
    End of update loop0.03 ms
    Query end0.03 ms
    Commit0.03 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Starting cleanup0.03 ms
    Freeing items0.17 ms
    Updating status0.06 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    16Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    15Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    14Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    13Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    12Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/article.php:58
    11ContentModelArticle->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    10Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/components/com_content/models/article.php:251
    9ContentModelArticle->hit()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 3.15 ms Après la dernière requête : 0.48 ms Mémoire de requête : 0.009 MB mémoire avant requête : 9.031 MB Rangées retournées : 799
    SELECT `id`,`name`,`rules`,`parent_id`

      FROM `k7n8e_assets`

      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_assetsALLidx_asset_name,idx_parent_idINDEX N'A PU ÊTRE UTILISÉNULLNULL1160Using where
    Profil
    StatusDuration
    Starting0.22 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.03 ms
    System lock0.01 ms
    table lock0.04 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.10 ms
    Preparing0.04 ms
    Executing0.02 ms
    Sending data1.97 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.03 ms
    closing tables0.08 ms
    Unlocking tables0.04 ms
    closing tables0.03 ms
    Starting cleanup0.03 ms
    Freeing items0.14 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    16Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    15Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    14Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    13Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    12Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/article.php:58
    11ContentModelArticle->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    10Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/components/com_content/models/article.php:251
    9ContentModelArticle->hit()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 2.29 ms Après la dernière requête : 5.96 ms Mémoire de requête : 0.008 MB mémoire avant requête : 9.822 MB Rangées retournées : 31
    SHOW FULL COLUMNS 
      FROM `k7n8e_content`
    Explication
    EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `k7n8e_content`
    Profil
    StatusDuration
    Starting0.22 ms
    checking permissions0.03 ms
    closing tables0.01 ms
    Opening tables0.59 ms
    After opening tables0.03 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Executing0.02 ms
    Filling schema table0.03 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    checking permissions0.26 ms
    closing tables0.03 ms
    Executing0.02 ms
    Sending data0.16 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Removing tmp table0.15 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Starting cleanup0.03 ms
    Freeing items0.14 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:445
    14JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:245
    13Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:164
    12Joomla\CMS\Table\Table->__construct()JROOT/libraries/src/Table/Content.php:39
    11Joomla\CMS\Table\Content->__construct()JROOT/libraries/src/Table/Table.php:312
    10Joomla\CMS\Table\Table::getInstance()JROOT/components/com_content/models/article.php:253
    9ContentModelArticle->hit()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.96 ms Après la dernière requête : 6.27 ms Mémoire de requête : 0.005 MB mémoire avant requête : 10.129 MB
    UPDATE k7n8e_content

      SET `hits` = (`hits` + 1)

      WHERE `id` = '729'
    Explication
    EXPLAIN impossible sur la requête : UPDATE k7n8e_content SET `hits` = (`hits` + 1) WHERE `id` = '729'
    Profil
    StatusDuration
    Starting0.19 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.02 ms
    table lock0.02 ms
    init for update0.07 ms
    Updating0.10 ms
    End of update loop0.02 ms
    Waiting for query cache lock0.02 ms
    End of update loop0.02 ms
    Query end0.04 ms
    Commit0.97 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.03 ms
    Starting cleanup0.06 ms
    Freeing items0.10 ms
    Updating status0.07 ms
    Reset for next command0.01 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    11JDatabaseDriverMysqli->execute()JROOT/libraries/src/Table/Table.php:1245
    10Joomla\CMS\Table\Table->hit()JROOT/components/com_content/models/article.php:254
    9ContentModelArticle->hit()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.57 ms Après la dernière requête : 2.98 ms Mémoire de requête : 0.007 MB mémoire avant requête : 10.252 MB Rangées retournées : 1
    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

      FROM k7n8e_content AS a

      INNER JOIN k7n8e_categories AS c 
      on c.id = a.catid

      LEFT JOIN k7n8e_users AS u 
      on u.id = a.created_by

      LEFT JOIN k7n8e_categories as parent 
      ON parent.id = c.parent_id

      LEFT JOIN k7n8e_content_rating AS v 
      ON a.id = v.content_id

      WHERE a.id = 729 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-25 08:47:12') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-25 08:47:12') 
      AND (a.state = 1 OR a.state =2)
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARY,idx_state,idx_catidPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const1
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    1SIMPLEvconstPRIMARYPRIMARY4const0Unique row not found
    Profil
    StatusDuration
    Starting0.33 ms
    checking permissions0.02 ms
    Opening tables0.06 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.13 ms
    Optimizing0.03 ms
    Statistics0.16 ms
    Preparing0.02 ms
    Unlocking tables0.03 ms
    Preparing0.04 ms
    Executing0.02 ms
    Sending data0.14 ms
    End of update loop0.04 ms
    Query end0.02 ms
    Commit0.03 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.17 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    13JDatabaseDriver->loadObject()JROOT/components/com_content/models/article.php:151
    12ContentModelArticle->getItem()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/article/view.html.php:42
    10ContentViewArticle->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.29 ms Après la dernière requête : 3.41 ms Mémoire de requête : 0.011 MB mémoire avant requête : 10.362 MB Rangées retournées : 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

      FROM `k7n8e_categories` AS `s`

      INNER JOIN `k7n8e_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)

      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 120

      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ÉNULLNULL185Using where; Utilisation du tri complet de type filesort
    Profil
    StatusDuration
    Starting0.22 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.06 ms
    Optimizing0.04 ms
    Statistics0.12 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.03 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.23 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.15 ms
    Updating status0.05 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    22Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    21Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    20ContentRouter->getCategorySegment()Même appel que celui de la ligne ci-dessous.
    19call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    18Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    17Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    16Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:672
    15Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    14Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    13Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    12Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    11Joomla\CMS\Router\Route::_()JROOT/components/com_content/views/article/view.html.php:71
    10ContentViewArticle->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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.90 ms Après la dernière requête : 1.52 ms Mémoire de requête : 0.006 MB mémoire avant requête : 10.415 MB Rangées retournées : 0
    SELECT `m`.`tag_id`,`t`.*

      FROM `k7n8e_contentitem_tag_map` AS m 

      INNER JOIN `k7n8e_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`

      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 729 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeINDEX N'A PU ÊTRE UTILISÉNULLNULL48Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4cnpfca_cnpf.m.tag_id1Using where
    Profil
    StatusDuration
    Starting0.14 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.03 ms
    table lock0.03 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.06 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.12 ms
    Updating status0.05 ms
    Reset for next command0.03 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    12JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    11Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/views/article/view.html.php:184
    10ContentViewArticle->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 2.99 ms Après la dernière requête : 7.12 ms Mémoire de requête : 0.009 MB mémoire avant requête : 10.881 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 k7n8e_fields AS a

      LEFT JOIN `k7n8e_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN k7n8e_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN k7n8e_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN k7n8e_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN k7n8e_fields_groups AS g 
      ON g.id = a.group_id

      LEFT JOIN `k7n8e_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 (120,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    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_langcode28cnpfca_cnpf.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4cnpfca_cnpf.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4cnpfca_cnpf.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4cnpfca_cnpf.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4cnpfca_cnpf.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4cnpfca_cnpf.a.id1Using where; Using index; Distinct
    Profil
    StatusDuration
    Starting0.40 ms
    checking permissions0.03 ms
    Opening tables0.09 ms
    After opening tables0.03 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.11 ms
    Optimizing0.08 ms
    Statistics0.20 ms
    Preparing0.09 ms
    Creating tmp table0.10 ms
    Sorting result0.06 ms
    Executing0.02 ms
    Sending data0.78 ms
    Creating sort index0.08 ms
    Removing tmp table0.17 ms
    Creating sort index0.06 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.06 ms
    closing tables0.06 ms
    Starting cleanup0.04 ms
    Freeing items0.17 ms
    Updating status0.10 ms
    Reset for next command0.04 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php: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/article/view.html.php:193
    10ContentViewArticle->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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 : 1.16 ms Après la dernière requête : 51.17 ms Mémoire de requête : 0.006 MB mémoire avant requête : 11.804 MB Rangées retournées : 1
    SELECT template 
      FROM k7n8e_template_styles 
      WHERE client_id = 1 
      AND home = 1
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_template_stylesALLidx_homeINDEX N'A PU ÊTRE UTILISÉNULLNULL14Using where
    Profil
    StatusDuration
    Starting0.29 ms
    checking permissions0.03 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.04 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.07 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.03 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.08 ms
    Updating status0.03 ms
    Reset for next command0.04 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    9JDatabaseDriver->loadResult()JROOT/templates/theme3092/includes/includes.php:31
    8include_once JROOT/templates/theme3092/includes/includes.phpJROOT/templates/theme3092/index.php:3
    7require JROOT/templates/theme3092/index.phpJROOT/libraries/src/Document/HtmlDocument.php:668
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:730
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:545
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1030
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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 : 3.82 ms Après la dernière requête : 2.65 ms Mémoire de requête : 0.008 MB mémoire avant requête : 11.908 MB Rangées retournées : 19
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

      FROM k7n8e_modules AS m

      LEFT JOIN k7n8e_modules_menu AS mm 
      ON mm.moduleid = m.id

      LEFT JOIN k7n8e_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-03-25 08:47:12') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-25 08:47:12') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 718 OR mm.menuid <= 0)

      ORDER BY m.position, m.ordering
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const80Using index condition; Using where; Utilisation du tri complet de type filesort
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403cnpfca_cnpf.m.module,const1Using index condition; Using where
    1SIMPLEmmrefPRIMARYPRIMARY4cnpfca_cnpf.m.id1Using where; Using index
    Profil
    StatusDuration
    Starting0.38 ms
    checking permissions0.03 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.10 ms
    Optimizing0.08 ms
    Statistics0.15 ms
    Preparing0.10 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.03 ms
    Creating sort index2.25 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    closing tables0.03 ms
    Unlocking tables0.03 ms
    closing tables0.05 ms
    Starting cleanup0.02 ms
    Freeing items0.10 ms
    Updating status0.07 ms
    Reset for next command0.00 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()Même appel que celui de la ligne ci-dessous.
    14call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:432
    12Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:362
    11Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    10Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:591
    9Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/theme3092/includes/includes.php:114
    8include_once JROOT/templates/theme3092/includes/includes.phpJROOT/templates/theme3092/index.php:3
    7require JROOT/templates/theme3092/index.phpJROOT/libraries/src/Document/HtmlDocument.php:668
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:730
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:545
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1030
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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 : 1.18 ms Après la dernière requête : 29.57 ms Mémoire de requête : 0.010 MB mémoire avant requête : 12.662 MB Rangées retournées : 1
    SELECT id,parent_id 
      FROM k7n8e_menu 
      WHERE id = 718
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_menuconstPRIMARYPRIMARY4const1
    Profil
    StatusDuration
    Starting0.24 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.04 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.02 ms
    Unlocking tables0.03 ms
    Preparing0.05 ms
    Executing0.02 ms
    Sending data0.03 ms
    End of update loop0.05 ms
    Query end0.04 ms
    Commit0.03 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.05 ms
    Starting cleanup0.03 ms
    Freeing items0.13 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:46
    17modIceMegamenuHelper::buildXML()Même appel que celui de la ligne ci-dessous.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:115
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:154
    12modIceMegamenuHelper->render()JROOT/templates/theme3092/html/mod_icemegamenu/default.php:27
    11require JROOT/templates/theme3092/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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.76 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.010 MB mémoire avant requête : 12.672 MB Rangées retournées : 1
    SELECT id,parent_id 
      FROM k7n8e_menu 
      WHERE id = 717
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_menuconstPRIMARYPRIMARY4const1
    Profil
    StatusDuration
    Starting0.13 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Unlocking tables0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.05 ms
    closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.12 ms
    Updating status0.06 ms
    Reset for next command0.01 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:46
    17modIceMegamenuHelper::buildXML()Même appel que celui de la ligne ci-dessous.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:115
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:154
    12modIceMegamenuHelper->render()JROOT/templates/theme3092/html/mod_icemegamenu/default.php:27
    11require JROOT/templates/theme3092/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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]
  27. Temps de requête : 0.71 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.010 MB mémoire avant requête : 12.682 MB Rangées retournées : 1
    SELECT id,parent_id 
      FROM k7n8e_menu 
      WHERE id = 1
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_menuconstPRIMARYPRIMARY4const1
    Profil
    StatusDuration
    Starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Unlocking tables0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.04 ms
    closing tables0.02 ms
    Starting cleanup0.03 ms
    Freeing items0.10 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:46
    17modIceMegamenuHelper::buildXML()Même appel que celui de la ligne ci-dessous.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:115
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:154
    12modIceMegamenuHelper->render()JROOT/templates/theme3092/html/mod_icemegamenu/default.php:27
    11require JROOT/templates/theme3092/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :
  1. 3 × SELECT id,parent_id 
      FROM k7n8e_menu
  2. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `k7n8e_extensions`
  3. 2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
      FROM `k7n8e_categories` AS `s` 
      INNER JOIN `k7n8e_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
  4. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `k7n8e_assets`
  5. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM k7n8e_modules AS m 
      LEFT JOIN k7n8e_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN k7n8e_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
  6. 1 × SELECT template 
      FROM k7n8e_template_styles
  7. 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 k7n8e_fields AS a 
      LEFT JOIN `k7n8e_languages` AS l 
      ON l.lang_code = a.language 
      LEFT JOIN k7n8e_users AS uc 
      ON uc.id=a.checked_out 
      LEFT JOIN k7n8e_viewlevels AS ag 
      ON ag.id = a.access 
      LEFT JOIN k7n8e_users AS ua 
      ON ua.id = a.created_user_id 
      LEFT JOIN k7n8e_fields_groups AS g 
      ON g.id = a.group_id 
      LEFT JOIN `k7n8e_fields_categories` AS fc 
      ON fc.field_id = a.id
  8. 1 × SELECT `m`.`tag_id`,`t`.* 
      FROM `k7n8e_contentitem_tag_map` AS m  
      INNER JOIN `k7n8e_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
  9. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
      FROM k7n8e_content AS a 
      INNER JOIN k7n8e_categories AS c 
      on c.id = a.catid 
      LEFT JOIN k7n8e_users AS u 
      on u.id = a.created_by 
      LEFT JOIN k7n8e_categories as parent 
      ON parent.id = c.parent_id 
      LEFT JOIN k7n8e_content_rating AS v 
      ON a.id = v.content_id
  10. 1 × SELECT `session_id` 
      FROM `k7n8e_session`
  11. 1 × SELECT id, home, template, s.params 
      FROM k7n8e_template_styles as s 
      LEFT JOIN k7n8e_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
  12. 1 × SELECT `alias`,`catid` 
      FROM `k7n8e_content`
  13. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM k7n8e_menu AS m 
      LEFT JOIN k7n8e_extensions AS e 
      ON m.component_id = e.extension_id
  14. 1 × SELECT * 
      FROM k7n8e_loginradius_setting
  15. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM k7n8e_extensions
  16. 1 × SELECT b.id 
      FROM k7n8e_usergroups AS a 
      LEFT JOIN k7n8e_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
  17. 1 × SELECT id, rules 
      FROM `k7n8e_viewlevels
  18. 1 × SELECT * 
      FROM k7n8e_languages
Autres tables :
  1. 1 × INSERT INTO `k7n8e_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES  (X'6164363234373161303733346138343830396335303131656633306235313664', 1, 1679734032, 0, '', 0
  2. 1 × UPDATE `k7n8e_extensions` 
      SET `params` = '{\"mediaversion\":\"836ac27461330f401f7c210a2e4e9e81\"}'
  3. 1 × SHOW FULL COLUMNS 
      FROM `k7n8e_content
  4. 1 × UPDATE k7n8e_content 
      SET `hits` = (`hits` + 1)