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
      • Voir loin voir grand
      • Pour le développement social
      • Petite enfance
      • Conversation pour parents
      • Familles exogames 
      • Parents d’ados et de jeunes adultes
      • Élections fédérales 2021
  • Contact
  • Accueil | 
  • Publication | 
  • Nouvelles de la CNPF

Nouvelles récentes

Econocoop et la CNPF sont à la recherche d'une ou d'un programmeur-analyste

La CNPF est à la recherche d'une ou d'un programmeur-analyste pour être aux commandes du développement et de la programmation informatique d'Éconocoop, notre nouvelle entreprise sociale Joignez-vous à une équipe dynamique!
Consulter l'offre d'emploi

11 janvier 2021
Dépôt du projet de loi C-32 sur les langues officielles : un pas dans la bonne voie

Ottawa, le 16 juin 2021 – La Commission nationale des parents francophones (CNPF) applaudit la ministre du Développement économique et des Langues officielles, Mélanie Joly et le gouvernement fédéral pour le dépôt du projet de loi C-32 pour moderniser la Loi sur les langues officielles.

Ce projet de loi déposé hier à la Chambre des communes s’inscrit dans la continuité du discours du trône de septembre 2020.  Le gouvernement fédéral franchit ainsi un cap important pour la protection du français au pays. 

« Nous pensons que les propositions énoncées par le gouvernement fédéral par l’entremise de ce projet de loi sont un pas dans la bonne voie et favorisent la vitalité de nos communautés de langue officielle en situation minoritaire. », affirme le président de la CNPF, M. Louis Kdouh.

La CNPF se réjouit également de voir que le gouvernement reconnaît l’importance de renforcer le continuum en éducation, depuis la petite enfance jusqu’aux études postsecondaires, dans la langue de la minorité et que cet énoncé apparaît pour la première fois dans un texte de projet de loi. « Il est grand temps, affirme Louis Kdouh, de reconnaître officiellement que les services en petite enfance sont un jalon essentiel dans la pleine réalisation de l’article 23 de la Charte des droits et libertés. De plus, la reconnaissance des études postsecondaires comme faisant partie du continuum en éducation aura un effet positif et bénéfique sur la volonté des parents et des jeunes de poursuivre les études en français au pays. »

La CNPF remercie la ministre Mélanie Joly et le gouvernement fédéral pour le dépôt de loi C-32 et s’engage à travailler avec le gouvernement à sa mise en œuvre.

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

16 juin 2021
Journée nationale de l'enfant

Tous les ans depuis 1993 nous célébrons la Journée nationale de l'enfant. Fêtée partout a pays pour souligner l'adoption par les Nations Unies de deux documents sur les droits des enfants, à savoir la Déclaration des droits de l'enfant le 20 novembre 1959 et la Convention des Nations Unies relative aux droits de l'enfant le 20 novembre 1989.

En tant que parent, vous êtes le premier responsable à l’épanouissement de votre enfant et votre rôle est essentiel dans son développement.
Voici quelques ressources et des activités compilées par le gouvernement du Canada qui vous renseigneront sur la Convention des Nations Unies relative aux droits de l'enfant et qui vous aideront à sensibiliser vos enfants.

Ressources :
https://www.canada.ca/fr/sante-publique/services/promotion-sante/enfance-adolescence/journee-nationale-enfant/liens-pour-parents-gardiens.html

Sources:
Agence de la santé publique du Canada
Unicef

"Rien n’est plus important que de bâtir un monde dans lequel tous nos enfants auront la possibilité de réaliser pleinement leur potentiel et de grandir en bonne santé, dans la paix et dans la dignité."
Kofi A. Annan, secrétaire général de l’Organisation des Nations Unies.

19 novembre 2020
Message de la part des parents francophones en lien avec l’ouverture des écoles et la pandémie

La Commission nationale des parents francophones (CNPF) est consciente de l’impact considérable créé par la crise sanitaire sur les parents francophones et leurs enfants. Voici un message de Louis Kdouh, président de la CNPF.

Lettre aux parents

14 octobre 2020
Journée mondiale des enseignants 2020

Aujourd’hui le 5 octobre, nous célébrons la Journée mondiale des enseignants. L’édition 2020 a pour thème « Enseignants : leaders en temps de crise et façonneurs d’avenir », un thème particulièrement bien choisi en ces temps difficiles. Cette journée est l’occasion de mettre la profession enseignante à l’honneur et la Commission nationale des parents francophones souhaite remercier du fond du cœur tous les enseignantes et enseignants qui prennent soin de nos enfants en cette période très éprouvante et stressante que représente la rentrée scolaire. Nous sommes conscients que cette année est particulièrement difficile et nous vous remercions pour tout votre dévouement pour la réussite de nos enfants.

Ressources :

Site Internet de l'UNESCO
https://fr.unesco.org

Page Facebook de la campagne nationale de valorisation de la profession enseignante de la Fédération Canadienne des Enseignantes et des Enseignants
Enseigner, ça me parle

 

05 octobre 2020
La Commission nationale des parents francophones accueille favorablement certains énoncés du discours du Trône

Ottawa, 24 septembre 2020: La Commission nationale des parents francophones (CNPF) accueille favorablement le discours du Trône du 23 septembre en ce qui a trait aux services d’apprentissage et de garde de jeunes enfants au pays et continue à insister sur l’importance pour les francophones en situation minoritaire d’avoir accès à leur juste part du financement qui sera accordé dans le cadre de ce programme.

24 septembre 2020
  • 1
  • 2
  • 3
  • 4
  • ...

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": 1632159293,
                "last": 1632159293,
                "now": 1632159293
            }
        },
        "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: 50.02 ms / 50.02 ms Mémoire: 0.702 MB / 1.08 MB Application: afterLoad
Temps: 140.65 ms / 190.67 ms Mémoire: 1.574 MB / 2.66 MB Application: afterInitialise
Temps: 36.84 ms / 227.51 ms Mémoire: 0.792 MB / 3.45 MB Application: afterRoute
Temps: 12.98 ms / 240.50 ms Mémoire: 0.225 MB / 3.67 MB Application: beforeRenderComponent com_content
Temps: 13.28 ms / 253.78 ms Mémoire: 0.154 MB / 3.83 MB Application: Before Access::preloadComponents (all components)
Temps: 1.97 ms / 255.75 ms Mémoire: 0.072 MB / 3.90 MB Application: After Access::preloadComponents (all components)
Temps: 0.04 ms / 255.79 ms Mémoire: 0.000 MB / 3.89 MB Application: Before Access::preloadPermissions (com_content)
Temps: 4.13 ms / 259.92 ms Mémoire: 0.730 MB / 4.62 MB Application: After Access::preloadPermissions (com_content)
Temps: 0.10 ms / 260.01 ms Mémoire: 0.000 MB / 4.59 MB Application: Before Access::getAssetRules (id:67 name:com_content.category.11)
Temps: 1.36 ms / 261.38 ms Mémoire: 0.010 MB / 4.60 MB Application: After Access::getAssetRules (id:67 name:com_content.category.11)
Temps: 10.99 ms / 272.37 ms Mémoire: 0.036 MB / 4.64 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Temps: 0.08 ms / 272.44 ms Mémoire: 0.007 MB / 4.64 MB Application: After Access::getAssetRules (id:8 name:com_content)
Temps: 102.82 ms / 375.26 ms Mémoire: 0.421 MB / 5.06 MB Application: afterRenderComponent com_content
Temps: 8.98 ms / 384.24 ms Mémoire: 0.081 MB / 5.15 MB Application: afterDispatch
Temps: 14.95 ms / 399.19 ms Mémoire: 0.179 MB / 5.32 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher(do not delete))
Temps: 1.40 ms / 400.59 ms Mémoire: 0.021 MB / 5.35 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Temps: 0.08 ms / 400.67 ms Mémoire: 0.007 MB / 5.35 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Temps: 1.64 ms / 402.31 ms Mémoire: 0.000 MB / 5.34 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher(do not delete))
Temps: 0.07 ms / 402.38 ms Mémoire: 0.000 MB / 5.34 MB Application: beforeRenderModule mod_custom (Contacts)
Temps: 0.71 ms / 403.09 ms Mémoire: 0.005 MB / 5.34 MB Application: afterRenderModule mod_custom (Contacts)
Temps: 0.06 ms / 403.15 ms Mémoire: 0.000 MB / 5.34 MB Application: beforeRenderModule mod_custom (partenaires)
Temps: 0.09 ms / 403.25 ms Mémoire: 0.003 MB / 5.35 MB Application: afterRenderModule mod_custom (partenaires)
Temps: 0.05 ms / 403.30 ms Mémoire: 0.001 MB / 5.35 MB Application: beforeRenderModule mod_search (Recherche)
Temps: 1.17 ms / 404.47 ms Mémoire: 0.014 MB / 5.36 MB Application: afterRenderModule mod_search (Recherche)
Temps: 0.04 ms / 404.51 ms Mémoire: 0.000 MB / 5.36 MB Application: beforeRenderModule mod_menu (Publication)
Temps: 3.23 ms / 407.74 ms Mémoire: 0.082 MB / 5.44 MB Application: afterRenderModule mod_menu (Publication)
Temps: 0.07 ms / 407.81 ms Mémoire: 0.000 MB / 5.44 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Temps: 1.84 ms / 409.64 ms Mémoire: 0.013 MB / 5.45 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Temps: 0.10 ms / 409.74 ms Mémoire: 0.000 MB / 5.45 MB Application: beforeRenderModule mod_icemegamenu (Main menu)
Temps: 46.04 ms / 455.79 ms Mémoire: 0.802 MB / 6.25 MB Application: afterRenderModule mod_icemegamenu (Main menu)
Temps: 6.74 ms / 462.53 ms Mémoire: 0.106 MB / 6.36 MB Application: afterRender

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

Occupation de la mémoire

6,84 MB (7 176 992 Bytes)

Requêtes de base de données

25 requêtes exécutées 51.66 ms


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

      FROM `k7n8e_session`

      WHERE `session_id` = X'3139366162653939613832636232376333636233623030383963643232666631' 
      LIMIT 1
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_sessionconstPRIMARYPRIMARY194const1Using index
    Profil
    StatusDuration
    Starting0.21 ms
    Checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Init0.03 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.02 ms
    Executing0.03 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Closing tables0.05 ms
    Unlocking tables0.02 ms
    Closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.08 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 : 2.38 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.612 MB
    INSERT INTO `k7n8e_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES 
(X'3139366162653939613832636232376333636233623030383963643232666631', 1, 1632159293, 0, '', 0)
    Explication
    EXPLAIN impossible sur la requête : INSERT INTO `k7n8e_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3139366162653939613832636232376333636233623030383963643232666631', 1, 1632159293, 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.03 ms
    Update0.09 ms
    Waiting for query cache lock0.01 ms
    Update0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit1.72 ms
    Closing tables0.02 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.11 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.10 ms Après la dernière requête : 7.29 ms Mémoire de requête : 0.006 MB mémoire avant requête : 1.648 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.16 ms
    Checking permissions0.02 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.08 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.25 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.03 ms
    Closing tables0.04 ms
    Starting cleanup0.02 ms
    Freeing items0.08 ms
    Updating status0.04 ms
    Reset for next command0.01 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 : 0.75 ms Après la dernière requête : 6.71 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.750 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.13 ms
    Checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.02 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.06 ms
    End of update loop0.03 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.04 ms
    Unlocking tables0.02 ms
    Closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.08 ms
    Updating status0.04 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 : 0.80 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.763 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
    1SIMPLEbindexidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup8NULL10Using where; Using index
    Profil
    StatusDuration
    Starting0.12 ms
    Checking permissions0.02 ms
    Opening tables0.02 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
    Unlocking tables0.01 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.05 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.03 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.04 ms
    Starting cleanup0.02 ms
    Freeing items0.10 ms
    Updating status0.04 ms
    Reset for next command0.01 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.69 ms Après la dernière requête : 2.15 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.785 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_extensionsrefextensionextension82const204Using index condition; Using where; Utilisation du tri complet de type filesort
    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
    Init0.03 ms
    Optimizing0.03 ms
    Statistics0.05 ms
    Preparing0.03 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index1.79 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.04 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.13 ms
    Updating status0.06 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.30 ms Après la dernière requête : 58.66 ms Mémoire de requête : 0.005 MB mémoire avant requête : 2.546 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.32 ms
    Checking permissions0.03 ms
    Opening tables0.05 ms
    After opening tables0.03 ms
    System lock0.03 ms
    Table lock0.03 ms
    Init0.05 ms
    Optimizing0.03 ms
    Statistics0.04 ms
    Preparing0.04 ms
    Executing0.02 ms
    Sending data0.10 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.07 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
    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.29 ms Après la dernière requête : 9.34 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.688 MB Rangées retournées : 117
    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_language1const195Using index condition; Using where; Utilisation du tri complet de type filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4cnpfca_cnpf.m.component_id1Using where
    Profil
    StatusDuration
    Starting0.33 ms
    Checking permissions0.03 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.03 ms
    Init0.07 ms
    Optimizing0.05 ms
    Statistics0.13 ms
    Preparing0.07 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.04 ms
    Creating sort index1.89 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.06 ms
    Starting cleanup0.02 ms
    Freeing items0.10 ms
    Updating status0.09 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.11 ms Après la dernière requête : 28.85 ms Mémoire de requête : 0.007 MB mémoire avant requête : 3.467 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.25 ms
    Checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.12 ms
    Preparing0.05 ms
    Executing0.01 ms
    Sending data0.10 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.05 ms
    Starting cleanup0.02 ms
    Freeing items0.09 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]
  10. Temps de requête : 1.93 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.005 MB mémoire avant requête : 3.458 MB
    UPDATE `k7n8e_extensions`

      SET `params` = '{\"mediaversion\":\"1499f210f5e187404e9c4ccd5ff0bfd1\"}'

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Explication
    EXPLAIN impossible sur la requête : UPDATE `k7n8e_extensions` SET `params` = '{\"mediaversion\":\"1499f210f5e187404e9c4ccd5ff0bfd1\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profil
    StatusDuration
    Starting0.14 ms
    Checking permissions0.02 ms
    Opening tables0.02 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init for update0.10 ms
    Updating0.08 ms
    End of update loop0.02 ms
    Waiting for query cache lock0.01 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit1.21 ms
    Closing tables0.02 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.09 ms
    Updating status0.07 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 : 0.90 ms Après la dernière requête : 5.41 ms Mémoire de requête : 0.003 MB mémoire avant requête : 3.556 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.17 ms
    Checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.10 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.03 ms
    Closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.09 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]
  12. Temps de requête : 0.93 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.003 MB mémoire avant requête : 3.577 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.16 ms
    Checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init0.03 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.13 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.10 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]
  13. Temps de requête : 1.67 ms Après la dernière requête : 14.81 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.830 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.23 ms
    Checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init0.09 ms
    Optimizing0.03 ms
    Statistics0.19 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.55 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.01 ms
    Closing tables0.05 ms
    Starting cleanup0.02 ms
    Freeing items0.09 ms
    Updating status0.05 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 : 1.97 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.895 MB Rangées retournées : 766
    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ÉNULLNULL1126Using where
    Profil
    StatusDuration
    Starting0.15 ms
    Checking permissions0.02 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.07 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data1.22 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Closing tables0.01 ms
    Unlocking tables0.03 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
    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.53 ms Après la dernière requête : 6.02 ms Mémoire de requête : 0.008 MB mémoire avant requête : 4.599 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.id2Using index condition; Using where
    Profil
    StatusDuration
    Starting0.28 ms
    Checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init0.08 ms
    Optimizing0.04 ms
    Statistics0.13 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.04 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.04 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.10 ms
    Executing0.01 ms
    Sending data0.10 ms
    Executing0.02 ms
    Sending data0.28 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.05 ms
    Starting cleanup0.02 ms
    Freeing items0.02 ms
    Removing tmp table0.74 ms
    Freeing items0.12 ms
    Updating status0.05 ms
    Reset for next command0.02 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 : 12.03 ms Après la dernière requête : 6.15 ms Mémoire de requête : 0.009 MB mémoire avant requête : 4.639 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 <= '2021-09-20 17:34:53') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-09-20 17:34:53')

      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.id2Using 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.67 ms
    Checking permissions0.03 ms
    Opening tables0.12 ms
    After opening tables0.03 ms
    System lock0.03 ms
    Table lock0.03 ms
    Init0.21 ms
    Optimizing0.10 ms
    Statistics0.23 ms
    Preparing0.12 ms
    Optimizing0.03 ms
    Statistics0.18 ms
    Preparing0.10 ms
    Creating tmp table0.39 ms
    Sorting result0.06 ms
    Executing0.04 ms
    Sending data0.27 ms
    Executing0.02 ms
    Sending data6.37 ms
    Creating sort index0.25 ms
    Removing tmp table0.35 ms
    Creating sort index0.02 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.03 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.07 ms
    Starting cleanup0.03 ms
    Freeing items0.02 ms
    Removing tmp table0.02 ms
    Freeing items1.80 ms
    Removing tmp table0.02 ms
    Freeing items0.14 ms
    Updating status0.05 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/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 : 5.03 ms Après la dernière requête : 3.73 ms Mémoire de requête : 0.009 MB mémoire avant requête : 4.862 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 <= '2021-09-20 17:34:53') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-09-20 17:34:53')
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcALLPRIMARY,idx_accessINDEX N'A PU ÊTRE UTILISÉNULLNULL185Using where
    1PRIMARYarefidx_access,idx_state,idx_catididx_catid4cnpfca_cnpf.c.id2Using index condition; Using where
    2MATERIALIZEDthisconstPRIMARY,idx_left_rightPRIMARY4const1
    2MATERIALIZEDsubrangePRIMARY,idx_left_rightidx_left_right4NULL172Using where; Using index
    Profil
    StatusDuration
    Starting0.40 ms
    Checking permissions0.04 ms
    Opening tables0.14 ms
    After opening tables0.05 ms
    System lock0.02 ms
    Table lock0.02 ms
    Init0.09 ms
    Optimizing0.06 ms
    Statistics0.13 ms
    Preparing0.03 ms
    Unlocking tables0.02 ms
    Preparing0.06 ms
    Optimizing0.02 ms
    Statistics0.12 ms
    Preparing0.07 ms
    Executing0.01 ms
    Sending data0.16 ms
    Executing0.02 ms
    Sending data2.90 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.03 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.06 ms
    Starting cleanup0.03 ms
    Freeing items0.02 ms
    Removing tmp table0.04 ms
    Freeing items0.14 ms
    Removing tmp table0.02 ms
    Freeing items0.10 ms
    Updating status0.05 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.06 ms Après la dernière requête : 4.50 ms Mémoire de requête : 0.007 MB mémoire avant requête : 4.874 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.21 ms
    Checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init0.06 ms
    Optimizing0.04 ms
    Statistics0.10 ms
    Preparing0.05 ms
    Executing0.01 ms
    Sending data0.09 ms
    End of update loop0.04 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.04 ms
    Unlocking tables0.02 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
    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 : 1.40 ms Après la dernière requête : 12.72 ms Mémoire de requête : 0.010 MB mémoire avant requête : 4.984 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.31 ms
    Checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Init0.07 ms
    Optimizing0.05 ms
    Statistics0.17 ms
    Preparing0.02 ms
    Unlocking tables0.01 ms
    Preparing0.05 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.14 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.04 ms
    Unlocking tables0.03 ms
    Closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.09 ms
    Updating status0.04 ms
    Reset for next command0.03 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 : 1.84 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.009 MB mémoire avant requête : 5.001 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.20 ms
    Checking permissions0.02 ms
    Opening tables0.07 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Init0.06 ms
    Optimizing0.04 ms
    Statistics0.11 ms
    Preparing0.06 ms
    Creating tmp table0.16 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.49 ms
    Creating sort index0.06 ms
    Removing tmp table0.08 ms
    Creating sort index0.03 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.03 ms
    Unlocking tables0.02 ms
    Closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.09 ms
    Updating status0.06 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/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.02 ms Après la dernière requête : 75.44 ms Mémoire de requête : 0.006 MB mémoire avant requête : 5.248 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.22 ms
    Checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.05 ms
    Executing0.01 ms
    Sending data0.09 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.03 ms
    Freeing items0.09 ms
    Updating status0.05 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 : 2.55 ms Après la dernière requête : 2.66 ms Mémoire de requête : 0.008 MB mémoire avant requête : 5.306 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 <= '2021-09-20 17:34:53') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-09-20 17:34:53') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 782 OR mm.menuid <= 0)

      ORDER BY m.position, m.ordering
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const81Using 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.20 ms
    Checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Init0.06 ms
    Optimizing0.05 ms
    Statistics0.09 ms
    Preparing0.06 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index1.51 ms
    End of update loop0.03 ms
    Query end0.01 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.04 ms
    Closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.10 ms
    Updating status0.06 ms
    Reset for next command0.03 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.02 ms Après la dernière requête : 25.76 ms Mémoire de requête : 0.010 MB mémoire avant requête : 5.797 MB Rangées retournées : 1
    SELECT id,parent_id 
      FROM k7n8e_menu 
      WHERE id = 782
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_menuconstPRIMARYPRIMARY4const1
    Profil
    StatusDuration
    Starting0.20 ms
    Checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init0.03 ms
    Optimizing0.04 ms
    Statistics0.11 ms
    Preparing0.03 ms
    Unlocking tables0.03 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.03 ms
    End of update loop0.02 ms
    Query end0.03 ms
    Commit0.03 ms
    Closing tables0.02 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.09 ms
    Updating status0.05 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 : 0.72 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.010 MB mémoire avant requête : 5.807 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.12 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.02 ms
    Unlocking tables0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.03 ms
    Query end0.04 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.08 ms
    Updating status0.05 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]
  25. Temps de requête : 0.72 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.010 MB mémoire avant requête : 5.817 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.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.02 ms
    Sending data0.02 ms
    End of update loop0.02 ms
    Query end0.03 ms
    Commit0.03 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.08 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. 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 `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'3139366162653939613832636232376333636233623030383963643232666631', 1, 1632159293, 0, '', 0
  2. 1 × UPDATE `k7n8e_extensions` 
      SET `params` = '{\"mediaversion\":\"1499f210f5e187404e9c4ccd5ff0bfd1\"}'