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 | 
  • Nouvelles de la CNPF

Nouvelles récentes

8 mars: Journée internationale des droits des femmes

Célébrée le 8 mars, la Journée internationale des droits des femmes est une journée d’action, de sensibilisation et de mobilisation dédiée à la lutte pour les droits des femmes, l’égalité et la justice.

08 mars 2023
La CNPF en Cour suprême du Canada en solidarité avec les parents franco-ténois

Ottawa (Ontario), 09 février 2023 : La Commission nationale des parents francophones (CNPF) a comparu devant la Cour suprême du Canada pour défendre le droit des parents francophones vivant en situation minoritaire dans la cause Conseil scolaire francophone des Territoires du Nord-Ouest, A.B., et al c. Ministre de l’Éducation, de la Culture et de la Formation des Territoires du Nord-Ouest et al.

09 février 2023
Mars, Mois de la Francophonie

La Francophonie au plurielle
Chaque année, partout à travers le monde, on célèbre la Francophonie au mois de mars.
La Francophonie, c’est avant tout des femmes et des hommes qui partagent une langue commune, le français. Tout un mois dédié à promouvoir cette langue dans toute sa diversité et ses nombreuses déclinaisons culturelles.

01 mars 2023
Webinaire – Dévoilement des données du Recensement de 2021 sur les ayants droit

RÉSERVEZ LA DATE

  • Sortie des Statistiques – 3o novembre 2022
  • Statistiques visibles sur le quotidien de StatCan
  • Webinaire en français – 7 décembre, de 11 h à 12 h 30 (HNE)
  • Webinaire gratuit

Mise en contexte

Statistique Canada diffusera la dernière série de données provenant du Recensement de 2021. Ces données porteront sur :

  • La langue de travail
  • La langue d’instruction, c’est-à-dire le dénombrement exact des ayants droit à l’éducation dans la langue de la minorité en vertu de la Charte

Pour les deux sujets, Statistique Canada offrira une panoplie de produits (infographies, cartes, tableaux). Statistique Canada nous informe également que ces données forment un écosystème qui se complètera par d’autres études dans les prochains mois : https://www12.statcan.gc.ca/census-recensement/2021/ref/98-20-0001/982000012022001-fra.cfm

En ce qui concerne les données sur les ayants droit

Ces données sont issues de questions ajoutées au Recensement de 2021

Comme les données sont nouvelles, StatCan recommande de lire le Guide de référence sur l’instruction dans la langue officielle minoritaire, Recensement de la population, 2021. Ce court document explique comment les données ont été considérées pour établir la quantité d’« enfants admissibles à l’instruction dans la langue officielle minoritaire ». La dénomination permet de distinguer les concepts statistiques mis en œuvre dans le recensement et les concepts légaux établis dans l’article 23 de la Charte et sa jurisprudence.

Un autre élément important à considérer : quoique les questions sur la langue d’instruction font partie du questionnaire court, ce questionnaire n’inclut pas de question sur la citoyenneté. Cela signifie que les nombres dévoilés le 30 novembre incluront tant des citoyens et des citoyennes que des personnes qui ne possèdent pas encore la citoyenneté canadienne. En principe, les droits prévus à l’article 23 de la Charte s’appliquent aux citoyens et aux citoyennes, quoiqu’en pratique, dans plusieurs provinces et territoires les conseils scolaires peuvent choisir d’admettre des enfants de résidents permanents et résidentes permanentes.

En savoir plus

Statistique Canada offrira deux webinaires la semaine suivant le dévoilement des données et pourra y répondre à vos questions.

Langue, date, heure et liens pour vous inscrire

Français : Le 7 décembre, de 11 h à 12 h 30, heure de l’Est – Pour vous inscrire : Webinaire en français du 7 décembre 2022
Anglais : Le 7 décembre, de 13 h à 14 h 30, heure de l’Est – Pour vous inscrire : Webinaire en anglais du 7 décembre 2022

01 décembre 2022
Concours petite enfance


Bandeau du concours petite enfance 2023 acelf infolettre ajusté

Créez une mosaïque pour faire rayonner le moment préféré des enfants dans leur milieu éducatif francophone

Célébrez la francophonie avec les enfants de 5 ans et moins en participant à ce concours passionnant! Cette activité ludique et rassembleuse leur permettra de prendre conscience des moments positifs vécus en français dans leur milieu éducatif. Et d’associer ces expériences amusantes à leur francophonie!

Ce concours créatif mènera les enfants à créer une mosaïque. Leur offrira beaucoup de fierté. Et inspirera les membres de notre réseau pancanadien par de vibrantes idées d’activités à réaliser!

Un concours qui s'adresse aux éducateurs et éducatrices en petite enfance et aux enseignants et enseignantes du préscolaire.

Pour plus d'informations et remplir le formulaire d'inscription, vous pouvez visiter le site de la Francosphère de la petite enfance https://francospherepetiteenfance.acelf.ca/concours/

Date limite : 31 mars

Bonne chance!

Ce concours organisé par l'ACELF dans le cadre des Rendez-vous de la Francophonie.

02 mars 2023
593 000 enfants admissibles à l’éducation en français en milieu minoritaire : Enfin des données tangibles et précises pour le développement de l’éducation en français au Canada

COMMUNIQUÉ                                                             Pour diffusion immédiate

Ottawa, le 30 novembre 2022 – La Commission nationale des parents francophones (CNPF) a accueilli avec enthousiasme la publication de la dernière diffusion de données de Statistique Canada pour le Recensement de 2021.  Cette diffusion inclut, pour la première fois, les données du nombre d’enfants admissibles à l’instruction dans la langue officielle de la minorité en fonction des critères énoncés à l’article 23 de la Charte canadienne des droits et libertés.

30 novembre 2022
  • 1
  • 2
  • 3
  • 4
  • ...
  • 6
  • 7
  • 8

Recherche

Publication

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

partenaires baspage

Contactez-Nous

La Commission nationale des parents francophones

450, rue Rideau, bureau 300, Ottawa ON K1N 5Z4
Sans-frais : 1-800-665-5148 I  Courriel : info@cnpf.ca

facebook   twitter youtube cnpf

CNPF

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679733928,
                "last": 1679733928,
                "now": 1679733928
            }
        },
        "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: 33.90 ms / 33.90 ms Mémoire: 1.790 MB / 2.17 MB Application: afterLoad
Temps: 104.06 ms / 137.96 ms Mémoire: 4.764 MB / 6.93 MB Application: afterInitialise
Temps: 31.55 ms / 169.51 ms Mémoire: 1.338 MB / 8.27 MB Application: afterRoute
Temps: 12.07 ms / 181.59 ms Mémoire: 0.397 MB / 8.66 MB Application: beforeRenderComponent com_content
Temps: 6.85 ms / 188.44 ms Mémoire: 0.526 MB / 9.19 MB Application: Before Access::preloadComponents (all components)
Temps: 2.80 ms / 191.24 ms Mémoire: 0.073 MB / 9.26 MB Application: After Access::preloadComponents (all components)
Temps: 0.06 ms / 191.30 ms Mémoire: 0.000 MB / 9.26 MB Application: Before Access::preloadPermissions (com_content)
Temps: 7.27 ms / 198.57 ms Mémoire: 0.767 MB / 10.03 MB Application: After Access::preloadPermissions (com_content)
Temps: 0.24 ms / 198.80 ms Mémoire: 0.000 MB / 9.99 MB Application: Before Access::getAssetRules (id:67 name:com_content.category.11)
Temps: 1.03 ms / 199.83 ms Mémoire: 0.027 MB / 10.02 MB Application: After Access::getAssetRules (id:67 name:com_content.category.11)
Temps: 9.45 ms / 209.29 ms Mémoire: 0.210 MB / 10.23 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Temps: 0.14 ms / 209.42 ms Mémoire: 0.007 MB / 10.23 MB Application: After Access::getAssetRules (id:8 name:com_content)
Temps: 123.52 ms / 332.94 ms Mémoire: 1.194 MB / 11.43 MB Application: afterRenderComponent com_content
Temps: 8.67 ms / 341.61 ms Mémoire: 0.333 MB / 11.76 MB Application: afterDispatch
Temps: 14.28 ms / 355.89 ms Mémoire: 0.298 MB / 12.06 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher(do not delete))
Temps: 1.24 ms / 357.13 ms Mémoire: 0.041 MB / 12.10 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Temps: 0.06 ms / 357.19 ms Mémoire: 0.007 MB / 12.11 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Temps: 0.64 ms / 357.83 ms Mémoire: 0.018 MB / 12.13 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher(do not delete))
Temps: 0.07 ms / 357.89 ms Mémoire: 0.000 MB / 12.13 MB Application: beforeRenderModule mod_custom (Contacts)
Temps: 0.67 ms / 358.57 ms Mémoire: 0.006 MB / 12.13 MB Application: afterRenderModule mod_custom (Contacts)
Temps: 0.06 ms / 358.62 ms Mémoire: 0.000 MB / 12.13 MB Application: beforeRenderModule mod_custom (partenaires)
Temps: 0.22 ms / 358.84 ms Mémoire: 0.003 MB / 12.13 MB Application: afterRenderModule mod_custom (partenaires)
Temps: 0.04 ms / 358.88 ms Mémoire: 0.000 MB / 12.13 MB Application: beforeRenderModule mod_search (Recherche)
Temps: 0.85 ms / 359.73 ms Mémoire: 0.016 MB / 12.15 MB Application: afterRenderModule mod_search (Recherche)
Temps: 0.04 ms / 359.77 ms Mémoire: 0.000 MB / 12.15 MB Application: beforeRenderModule mod_menu (Publication)
Temps: 2.21 ms / 361.98 ms Mémoire: 0.099 MB / 12.25 MB Application: afterRenderModule mod_menu (Publication)
Temps: 0.05 ms / 362.04 ms Mémoire: 0.000 MB / 12.24 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Temps: 0.99 ms / 363.02 ms Mémoire: 0.023 MB / 12.27 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Temps: 0.08 ms / 363.10 ms Mémoire: 0.000 MB / 12.26 MB Application: beforeRenderModule mod_icemegamenu (Main menu)
Temps: 33.24 ms / 396.34 ms Mémoire: 0.929 MB / 13.19 MB Application: afterRenderModule mod_icemegamenu (Main menu)
Temps: 3.48 ms / 399.82 ms Mémoire: 0.155 MB / 13.35 MB Application: afterRender

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

Occupation de la mémoire

13,82 MB (14 492 064 Bytes)

Requêtes de base de données

24 requêtes exécutées 67.08 ms


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

      FROM `k7n8e_session`

      WHERE `session_id` = X'3637323965353665323566633466333463393539656630376364346464373035' 
      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.02 ms
    Query end0.01 ms
    Commit0.02 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.15 ms
    Updating status0.04 ms
    Reset for next command0.01 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.43 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.004 MB mémoire avant requête : 3.992 MB
    INSERT INTO `k7n8e_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES 
(X'3637323965353665323566633466333463393539656630376364346464373035', 1, 1679733928, 0, '', 0)
    Explication
    EXPLAIN impossible sur la requête : INSERT INTO `k7n8e_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3637323965353665323566633466333463393539656630376364346464373035', 1, 1679733928, 0, '', 0)
    Profil
    StatusDuration
    Starting0.12 ms
    checking permissions0.02 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init for update0.02 ms
    Update0.07 ms
    Waiting for query cache lock0.01 ms
    Update0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.83 ms
    closing tables0.02 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.09 ms
    Updating status0.04 ms
    Reset for next command0.01 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.49 ms Après la dernière requête : 4.23 ms Mémoire de requête : 0.006 MB mémoire avant requête : 4.206 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.15 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.10 ms
    Preparing0.06 ms
    Executing0.02 ms
    Sending data0.42 ms
    End of update loop0.02 ms
    Query end0.06 ms
    Commit0.04 ms
    closing tables0.03 ms
    Unlocking tables0.03 ms
    closing tables0.05 ms
    Starting cleanup0.03 ms
    Freeing items0.16 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: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.11 ms Après la dernière requête : 3.21 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.405 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.03 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.08 ms
    End of update loop0.03 ms
    Query end0.04 ms
    Commit0.03 ms
    closing tables0.02 ms
    Unlocking tables0.01 ms
    closing tables0.04 ms
    Starting cleanup0.03 ms
    Freeing items0.17 ms
    Updating status0.06 ms
    Reset for next command0.04 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.36 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.418 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.25 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.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.06 ms
    Freeing items0.15 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: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 : 1.68 ms Après la dernière requête : 1.38 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.17 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.03 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.05 ms
    Preparing0.03 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.62 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.05 ms
    Freeing items0.13 ms
    Updating status0.05 ms
    Reset for next command0.01 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.39 ms Après la dernière requête : 53.84 ms Mémoire de requête : 0.005 MB mémoire avant requête : 6.792 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.29 ms
    checking permissions0.03 ms
    Opening tables0.06 ms
    After opening tables0.01 ms
    System lock0.02 ms
    table lock0.05 ms
    init0.03 ms
    Optimizing0.04 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Executing0.02 ms
    Sending data0.16 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.03 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.05 ms
    Freeing items0.16 ms
    Updating status0.09 ms
    Reset for next command0.00 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 : 5.04 ms Après la dernière requête : 8.01 ms Mémoire de requête : 0.009 MB mémoire avant requête : 7.114 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.34 ms
    checking permissions0.03 ms
    Opening tables0.07 ms
    After opening tables0.00 ms
    System lock0.05 ms
    table lock0.01 ms
    init0.08 ms
    Optimizing0.03 ms
    Statistics0.12 ms
    Preparing0.08 ms
    Sorting result0.02 ms
    Executing0.03 ms
    Sending data0.05 ms
    Creating sort index3.12 ms
    End of update loop0.03 ms
    Query end0.03 ms
    Commit0.01 ms
    closing tables0.07 ms
    Unlocking tables0.05 ms
    closing tables0.06 ms
    Starting cleanup0.13 ms
    Freeing items0.26 ms
    Updating status0.09 ms
    Reset for next command0.03 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.47 ms Après la dernière requête : 22.65 ms Mémoire de requête : 0.007 MB mémoire avant requête : 8.303 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.31 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.06 ms
    Optimizing0.04 ms
    Statistics0.20 ms
    Preparing0.09 ms
    Executing0.01 ms
    Sending data0.12 ms
    End of update loop0.02 ms
    Query end0.03 ms
    Commit0.03 ms
    closing tables0.03 ms
    Unlocking tables0.01 ms
    closing tables0.05 ms
    Starting cleanup0.05 ms
    Freeing items0.14 ms
    Updating status0.06 ms
    Reset for next command0.04 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]
  10. Temps de requête : 1.75 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.005 MB mémoire avant requête : 8.294 MB
    UPDATE `k7n8e_extensions`

      SET `params` = '{\"mediaversion\":\"218d6df14f0f3b0158ac27497ac6c8dc\"}'

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Explication
    EXPLAIN impossible sur la requête : UPDATE `k7n8e_extensions` SET `params` = '{\"mediaversion\":\"218d6df14f0f3b0158ac27497ac6c8dc\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profil
    StatusDuration
    Starting0.16 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.02 ms
    table lock0.01 ms
    init for update0.08 ms
    Updating0.07 ms
    End of update loop0.01 ms
    Waiting for query cache lock0.01 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.90 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.16 ms
    Updating status0.06 ms
    Reset for next command0.02 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]
  11. Temps de requête : 1.23 ms Après la dernière requête : 3.62 ms Mémoire de requête : 0.003 MB mémoire avant requête : 8.542 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.22 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Sorting result0.02 ms
    Executing0.02 ms
    Sending data0.03 ms
    Creating sort index0.13 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.05 ms
    closing tables0.06 ms
    Starting cleanup0.04 ms
    Freeing items0.12 ms
    Updating status0.06 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]
  12. Temps de requête : 1.29 ms Après la dernière requête : 0.65 ms Mémoire de requête : 0.003 MB mémoire avant requête : 8.562 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.21 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.05 ms
    Optimizing0.05 ms
    Statistics0.10 ms
    Preparing0.06 ms
    Executing0.02 ms
    Sending data0.20 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.03 ms
    closing tables0.05 ms
    Starting cleanup0.03 ms
    Freeing items0.12 ms
    Updating status0.06 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]
  13. Temps de requête : 2.37 ms Après la dernière requête : 8.44 ms Mémoire de requête : 0.009 MB mémoire avant requête : 9.195 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.21 ms
    checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.14 ms
    Optimizing0.04 ms
    Statistics0.26 ms
    Preparing0.05 ms
    Executing0.03 ms
    Sending data0.78 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.04 ms
    Unlocking tables0.04 ms
    closing tables0.08 ms
    Starting cleanup0.04 ms
    Freeing items0.23 ms
    Updating status0.09 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    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:440
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php: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 : 3.27 ms Après la dernière requête : 0.54 ms Mémoire de requête : 0.009 MB mémoire avant requête : 9.259 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.28 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.05 ms
    Optimizing0.04 ms
    Statistics0.11 ms
    Preparing0.04 ms
    Executing0.02 ms
    Sending data1.94 ms
    End of update loop0.02 ms
    Query end0.03 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.03 ms
    Starting cleanup0.07 ms
    Freeing items0.18 ms
    Updating status0.10 ms
    Reset for next command0.03 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    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:440
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php: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.92 ms Après la dernière requête : 7.26 ms Mémoire de requête : 0.008 MB mémoire avant requête : 10.063 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,(
SELECT COUNT(i.`id`)

      FROM `k7n8e_content` AS `i`

      WHERE i.`catid` = c.id 
      AND i.state = 1) AS numitems

      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.published = 1 
      AND s.id = 11

      ORDER BY c.lft
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1
    1PRIMARYcrangecat_idx,idx_left_rightidx_left_right4NULL22Using index condition; Using where
    2DEPENDENT SUBQUERYirefidx_state,idx_catididx_catid4cnpfca_cnpf.c.id3Using index condition; Using where
    Profil
    StatusDuration
    Starting0.38 ms
    checking permissions0.03 ms
    Opening tables0.06 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.06 ms
    init0.11 ms
    Optimizing0.06 ms
    Statistics0.17 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.06 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.06 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.14 ms
    Executing0.02 ms
    Sending data0.08 ms
    Executing0.02 ms
    Sending data0.55 ms
    End of update loop0.04 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.09 ms
    Starting cleanup0.05 ms
    Freeing items0.03 ms
    Removing tmp table0.03 ms
    Freeing items0.17 ms
    Updating status0.26 ms
    Reset for next command0.03 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    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: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]
  16. Temps de requête : 15.74 ms Après la dernière requête : 4.61 ms Mémoire de requête : 0.009 MB mémoire avant requête : 10.231 MB Rangées retournées : 6
    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 k7n8e_content AS a

      LEFT JOIN k7n8e_categories AS c 
      ON c.id = a.catid

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

      LEFT JOIN k7n8e_users AS uam 
      ON uam.id = a.modified_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.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 11 OR a.catid IN (
SELECT sub.id

      FROM k7n8e_categories as sub

      INNER JOIN k7n8e_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt

      WHERE this.id = 11)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-25 08:45:28') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-25 08:45:28')

      ORDER BY  c.lft,  a.ordering,  a.created   
      LIMIT 6
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcrangePRIMARY,idx_accessidx_access4NULL184Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
    1PRIMARYarefidx_access,idx_state,idx_catididx_catid4cnpfca_cnpf.c.id3Using index condition; Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4cnpfca_cnpf.a.created_by1Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4cnpfca_cnpf.a.modified_by1Using where
    1PRIMARYparenteq_refPRIMARYPRIMARY4cnpfca_cnpf.c.parent_id1Using where
    1PRIMARYveq_refPRIMARYPRIMARY4cnpfca_cnpf.a.id1Using where
    2MATERIALIZEDthisconstPRIMARY,idx_left_rightPRIMARY4const1
    2MATERIALIZEDsubrangePRIMARY,idx_left_rightidx_left_right4NULL172Using where; Using index
    Profil
    StatusDuration
    Starting0.51 ms
    checking permissions0.03 ms
    Opening tables0.09 ms
    After opening tables0.03 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.18 ms
    Optimizing0.12 ms
    Statistics0.18 ms
    Preparing0.11 ms
    Optimizing0.04 ms
    Statistics0.14 ms
    Preparing0.08 ms
    Creating tmp table0.13 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.23 ms
    Executing0.02 ms
    Sending data11.28 ms
    Creating sort index0.57 ms
    Removing tmp table0.72 ms
    Creating sort index0.03 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.04 ms
    closing tables0.03 ms
    Unlocking tables0.02 ms
    closing tables0.08 ms
    Starting cleanup0.05 ms
    Freeing items0.05 ms
    Removing tmp table0.11 ms
    Freeing items0.04 ms
    Removing tmp table0.02 ms
    Freeing items0.31 ms
    Updating status0.11 ms
    Reset for next command0.04 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php: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 : 8.29 ms Après la dernière requête : 4.01 ms Mémoire de requête : 0.009 MB mémoire avant requête : 10.457 MB Rangées retournées : 1
    SELECT COUNT(*)

      FROM k7n8e_content AS a

      LEFT JOIN k7n8e_categories AS c 
      ON c.id = a.catid

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

      LEFT JOIN k7n8e_users AS uam 
      ON uam.id = a.modified_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.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 11 OR a.catid IN (
SELECT sub.id

      FROM k7n8e_categories as sub

      INNER JOIN k7n8e_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt

      WHERE this.id = 11)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-25 08:45:28') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-25 08:45:28')
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcALLPRIMARY,idx_accessINDEX N'A PU ÊTRE UTILISÉNULLNULL185Using where
    1PRIMARYarefidx_access,idx_state,idx_catididx_catid4cnpfca_cnpf.c.id3Using index condition; Using where
    2MATERIALIZEDthisconstPRIMARY,idx_left_rightPRIMARY4const1
    2MATERIALIZEDsubrangePRIMARY,idx_left_rightidx_left_right4NULL172Using where; Using index
    Profil
    StatusDuration
    Starting0.40 ms
    checking permissions0.12 ms
    Opening tables0.09 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.10 ms
    Optimizing0.12 ms
    Statistics0.18 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.09 ms
    Optimizing0.10 ms
    Statistics0.20 ms
    Preparing0.09 ms
    Executing0.02 ms
    Sending data0.17 ms
    Executing0.02 ms
    Sending data5.70 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.04 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.06 ms
    Starting cleanup0.05 ms
    Freeing items0.03 ms
    Removing tmp table0.04 ms
    Freeing items0.04 ms
    Removing tmp table0.05 ms
    Freeing items0.16 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:1740
    17JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:282
    15Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:232
    14Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php: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.74 ms Après la dernière requête : 4.68 ms Mémoire de requête : 0.007 MB mémoire avant requête : 10.590 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.category' 
      AND `m`.`content_item_id` = 11 
      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.34 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.08 ms
    Optimizing0.05 ms
    Statistics0.13 ms
    Preparing0.06 ms
    Executing0.02 ms
    Sending data0.15 ms
    End of update loop0.04 ms
    Query end0.00 ms
    Commit0.04 ms
    closing tables0.02 ms
    Unlocking tables0.04 ms
    closing tables0.05 ms
    Starting cleanup0.06 ms
    Freeing items0.26 ms
    Updating status0.10 ms
    Reset for next command0.04 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    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: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]
  19. Temps de requête : 2.01 ms Après la dernière requête : 10.44 ms Mémoire de requête : 0.010 MB mémoire avant requête : 10.996 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 = 11

      ORDER BY c.lft
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL22Using index condition; Using where
    Profil
    StatusDuration
    Starting0.39 ms
    checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.10 ms
    Optimizing0.06 ms
    Statistics0.21 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.07 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.35 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.03 ms
    closing tables0.03 ms
    Unlocking tables0.03 ms
    closing tables0.05 ms
    Starting cleanup0.03 ms
    Freeing items0.13 ms
    Updating status0.09 ms
    Reset for next command0.00 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    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:133
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php: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: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 : 2.91 ms Après la dernière requête : 0.31 ms Mémoire de requête : 0.009 MB mémoire avant requête : 11.013 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 (11,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    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.34 ms
    checking permissions0.03 ms
    Opening tables0.09 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.11 ms
    Optimizing0.07 ms
    Statistics0.23 ms
    Preparing0.09 ms
    Creating tmp table0.10 ms
    Sorting result0.04 ms
    Executing0.02 ms
    Sending data0.79 ms
    Creating sort index0.08 ms
    Removing tmp table0.13 ms
    Creating sort index0.05 ms
    End of update loop0.03 ms
    Query end0.03 ms
    Commit0.04 ms
    closing tables0.06 ms
    Unlocking tables0.03 ms
    closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.15 ms
    Updating status0.08 ms
    Reset for next command0.01 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/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php: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 : 1.54 ms Après la dernière requête : 87.80 ms Mémoire de requête : 0.006 MB mémoire avant requête : 11.945 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.35 ms
    checking permissions0.03 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.06 ms
    Optimizing0.05 ms
    Statistics0.06 ms
    Preparing0.05 ms
    Executing0.02 ms
    Sending data0.11 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.04 ms
    Unlocking tables0.12 ms
    closing tables0.04 ms
    Starting cleanup0.04 ms
    Freeing items0.17 ms
    Updating status0.07 ms
    Reset for next command0.02 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]
  22. Temps de requête : 3.86 ms Après la dernière requête : 1.55 ms Mémoire de requête : 0.008 MB mémoire avant requête : 12.048 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:45:28') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-25 08:45:28') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 858 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.32 ms
    checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.08 ms
    Optimizing0.08 ms
    Statistics0.15 ms
    Preparing0.10 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.05 ms
    Creating sort index2.33 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.16 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()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]
  23. Temps de requête : 1.25 ms Après la dernière requête : 15.33 ms Mémoire de requête : 0.010 MB mémoire avant requête : 12.830 MB Rangées retournées : 1
    SELECT id,parent_id 
      FROM k7n8e_menu 
      WHERE id = 858
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_menuconstPRIMARYPRIMARY4const1
    Profil
    StatusDuration
    Starting0.25 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.04 ms
    Preparing0.03 ms
    Executing0.02 ms
    Sending data0.03 ms
    End of update loop0.02 ms
    Query end0.05 ms
    Commit0.03 ms
    closing tables0.06 ms
    Unlocking tables0.03 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
    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]
  24. Temps de requête : 1.10 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.841 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.20 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Unlocking tables0.04 ms
    Preparing0.05 ms
    Executing0.02 ms
    Sending data0.06 ms
    End of update loop0.06 ms
    Query end0.03 ms
    Commit0.03 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.03 ms
    Starting cleanup0.03 ms
    Freeing items0.14 ms
    Updating status0.06 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]

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

Tables sélectionnées :
  1. 2 × 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 `id`,`name`,`rules`,`parent_id` 
      FROM `k7n8e_assets`
  4. 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
  5. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM k7n8e_extensions
  6. 1 × SELECT * 
      FROM k7n8e_loginradius_setting
  7. 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
  8. 1 × SELECT * 
      FROM k7n8e_languages
  9. 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
  10. 1 × SELECT id, rules 
      FROM `k7n8e_viewlevels
  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 `k7n8e_content` AS `i`
  12. 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 k7n8e_content AS a 
      LEFT JOIN k7n8e_categories AS c 
      ON c.id = a.catid 
      LEFT JOIN k7n8e_users AS ua 
      ON ua.id = a.created_by 
      LEFT JOIN k7n8e_users AS uam 
      ON uam.id = a.modified_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
  13. 1 × SELECT COUNT(*) 
      FROM k7n8e_content AS a 
      LEFT JOIN k7n8e_categories AS c 
      ON c.id = a.catid 
      LEFT JOIN k7n8e_users AS ua 
      ON ua.id = a.created_by 
      LEFT JOIN k7n8e_users AS uam 
      ON uam.id = a.modified_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
  14. 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`
  15. 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 `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)
  16. 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
  17. 1 × SELECT template 
      FROM k7n8e_template_styles
  18. 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
  19. 1 × SELECT `session_id` 
      FROM `k7n8e_session`
Autres tables :
  1. 1 × INSERT INTO `k7n8e_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES  (X'3637323965353665323566633466333463393539656630376364346464373035', 1, 1679733928, 0, '', 0
  2. 1 × UPDATE `k7n8e_extensions` 
      SET `params` = '{\"mediaversion\":\"218d6df14f0f3b0158ac27497ac6c8dc\"}'