CNPF

CNPF

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

Nouvelles récentes

Un nouveau protocole d’entente pour soutenir l’enseignement dans la langue officielle de la minorité et de la langue seconde : Un grand pas vers l'avant pour l'éducation en français en milieu minoritaire

Ottawa, 4 septembre 2019 : La Commission nationale des parents francophones (CNPF) a assisté aujourd’hui à l’annonce d’un nouveau protocole d’entente entre le gouvernement fédéral et les provinces et territoires pour soutenir l’enseignement dans la langue officielle de la minorité et de la langue seconde, présentée par la ministre du Tourisme, des Langues officielles et de la Francophonie, l’honorable Mélanie Joly.

04 septembre 2019
Félicitations aux récipiendaires des 3 bourses de 1200$

L’équipe de la Commission nationale des parents francophones (CNPF) est fière de vous annoncer le nom des trois récipiendaires des trois bourses de 1200$ offertes par notre organisme. Ces bourses sont données à 3 garderies, prématernelles ou centres d’appui à l’enfance et à la famille, afin d’encourager leurs éducatrices, aide-éducatrices, directrices, coordonnatrices de services à s’inscrire aux Stages de perfectionnement de l'ACELF.

Récipiendaires:

Monica Herrel, Garderie Plein Soleil, Territoires du Nord-Ouest
Nathalie St-Onge, Centre éducatif Village d'Élisabeth, Ontario
Geneviève Gélinas, École Voyageur, Alberta

Les Stages de perfectionnement de l'ACELF sont une formation de 8 jours d'échanges et de réflexions centrés sur la construction identitaire.

09 mai 2019
Le crédit d’impôt pour les services de garde en Ontario n’est pas la solution pour les Franco-Ontariens

Ottawa, 15 avril 2019 : La Commission nationale des parents francophones (CNPF) tient à faire savoir que les mesures prises par le gouvernement progressiste-conservateur de l'Ontario concernant l’accès aux services de garde ne répondent aucunement aux besoins des francophones d’avoir de nouveaux services en Ontario et cela s’applique pour l’ensemble des francophones en milieu minoritaire au pays.

Dans son budget déposé le 11 avril dernier à Queen’s Park, le gouvernement de Doug Ford propose un nouveau crédit d’impôt pour faciliter l’accès aux services de garde d’enfants et l’allégement des dépenses. La CNPF est d’avis que le crédit d’impôt n’est pas la solution au développement et à la qualité des services de garde pour les francophones et qu’il est essentiel de maintenir les investissements directs en petite enfance pour les parents francophones.

En effet, le crédit d’impôt n’améliore aucunement la prestation des services en français. « Un crédit d’impôt n’a pas de langue! », affirme Louis Kdouh, président de la CNPF. « En d’autres termes, les parents francophones qui reçoivent un crédit d’impôt n’ont pas de meilleures options pour avoir accès à une garderie francophone. Les parents seront contraints alors de choisir la garderie anglophone, faute de places pour les services en français, ce qui amène les jeunes francophones à totalement s’assimiler »

Pour assurer une offre adéquate de service en français en petite enfance, il n’y a qu’une seule solution, soit un investissement important des gouvernements pour assurer le déploiement d’une offre de service adéquate en petite enfance pour les francophones en milieu minoritaire. « Et une chose est sure, affirme M. Kdouh, le crédit d’impôt pour les services de garde n’apporte aucune solution pour les francophones.

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 des communications
(613) 288-0958 poste 4
communications@cnpf.ca

15 avril 2019
Les Franco-colombiens seront entendus par la Cour suprême du Canada et défendront la cause de l’éducation en français

Ottawa, 11 avril 2019 : La Commission nationale des parents francophones (CNPF) se réjouit de la décision de la Cour suprême du Canada d’entendre en appel la cause sur l'éducation en français qui oppose le Conseil scolaire francophone de la Colombie-Britannique (CSF), la Fédération des parents francophones de Colombie-Britannique (FPFCB), des parents coappelants au gouvernement de la province. Aucune date d’audience n’a encore été annoncée.

Rappelons que la cause juridique opposant les demandeurs au gouvernement de la Colombie-Britannique a été entendue pour la première fois en décembre 2013 et contestait le système de financement des infrastructures dans son ensemble et le défaut de la province de financer plusieurs projets pour améliorer les infrastructures des écoles de langue française en Colombie-Britannique. En 2016, la Cour suprême de la Colombie-Britannique rendait son jugement qui comptait de nombreux gains pour la communauté francophone de la Colombie-Britannique. En octobre 2018, les demandeurs ont demandé au plus haut tribunal du pays d’entendre leur cause suite au rejet de l’appel par la Cour d’appel de la Colombie-Britannique.

La Cour suprême du Canada doit maintenant se prononcer sur au moins trois enjeux d’intérêt public et national dont les critères de l’équivalence réelle, les limites de l’article premier de la Charte canadienne des droits et libertés et la compensation financière pour une violation de la Charte. Il est entendu que les gains qui ont déjà été réalisés devant la Cour suprême de la Colombie-Britannique demeureront intacts, peu importe la décision de la Cour suprême du Canada.

« Depuis les derniers mois, certaines décisions prises par des gouvernements provinciaux réduisent les droits des communautés francophones en situation minoritaire. Nous avons bon espoir que le plus haut tribunal de justice du Canada viendra en aide aux communautés francophones en situation minoritaire et fera respecter leurs droits dans le domaine de l’éducation », affirme Louis Kdouh, président de la CNPF.

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 des communications
(613) 288-0958 poste 4
communications@cnpf.ca

11 avril 2019
Une joyeuse fête des mères

fête des mères CNPF

09 avril 2019
Journée internationale de la Francophonie

La CNPF se joint aux francophones et francophiles de l’ensemble de la planète pour souligner aujourd’hui la Journée internationale de la Francophonie. Mise de l’avant par l’Organisation internationale de la Francophonie (OIF) sous le thème « En français… s’il vous plaît ;-) », cette journée permet à 300 millions de francophones de fêter leur langue en partage et dans la diversité de la Francophonie.

Ici, au Canada, près de 10.4 millions de personnes dont 2,7 millions d’entre elles habitent à l’extérieur du Québec (Statistique Canada, Recensement 2016) font vivre et rayonner quotidiennement la langue française que nous célébrons depuis le 1er mars par le biais des Rendez-vous de la Francophonie.

Tous les parents francophones au pays se joignent à cette célébration pour que tous ensemble, continuons à faire vibrer notre dynamisme, notre diversité et notre dualité linguistique.

Une excellente Journée internationale de la Francophonie à tous et à toutes!

 

20 mars 2019
  • 1
  • 2
  • 3
  • ...
  • 5
  • 6
  • 7
  • 8

Recherche

Publication

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

partenaires baspage


Contactez-Nous

La Commission nationale des parents francophones

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

facebook   twitter youtube cnpf

CNPF

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679649297,
                "last": 1679649297,
                "now": 1679649297
            }
        },
        "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: 20.31 ms / 20.31 ms Mémoire: 1.791 MB / 2.17 MB Application: afterLoad
Temps: 105.88 ms / 126.19 ms Mémoire: 4.765 MB / 6.93 MB Application: afterInitialise
Temps: 28.16 ms / 154.35 ms Mémoire: 1.338 MB / 8.27 MB Application: afterRoute
Temps: 14.08 ms / 168.43 ms Mémoire: 0.397 MB / 8.67 MB Application: beforeRenderComponent com_content
Temps: 9.06 ms / 177.49 ms Mémoire: 0.526 MB / 9.19 MB Application: Before Access::preloadComponents (all components)
Temps: 2.76 ms / 180.25 ms Mémoire: 0.073 MB / 9.27 MB Application: After Access::preloadComponents (all components)
Temps: 0.06 ms / 180.30 ms Mémoire: 0.000 MB / 9.26 MB Application: Before Access::preloadPermissions (com_content)
Temps: 6.30 ms / 186.60 ms Mémoire: 0.767 MB / 10.03 MB Application: After Access::preloadPermissions (com_content)
Temps: 0.24 ms / 186.84 ms Mémoire: 0.000 MB / 9.99 MB Application: Before Access::getAssetRules (id:67 name:com_content.category.11)
Temps: 0.91 ms / 187.74 ms Mémoire: 0.027 MB / 10.02 MB Application: After Access::getAssetRules (id:67 name:com_content.category.11)
Temps: 8.98 ms / 196.72 ms Mémoire: 0.210 MB / 10.23 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Temps: 0.16 ms / 196.88 ms Mémoire: 0.007 MB / 10.24 MB Application: After Access::getAssetRules (id:8 name:com_content)
Temps: 84.29 ms / 281.17 ms Mémoire: 1.186 MB / 11.42 MB Application: afterRenderComponent com_content
Temps: 6.53 ms / 287.70 ms Mémoire: 0.333 MB / 11.76 MB Application: afterDispatch
Temps: 12.19 ms / 299.89 ms Mémoire: 0.298 MB / 12.05 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher(do not delete))
Temps: 1.20 ms / 301.09 ms Mémoire: 0.041 MB / 12.10 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Temps: 0.06 ms / 301.15 ms Mémoire: 0.007 MB / 12.10 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Temps: 0.62 ms / 301.78 ms Mémoire: 0.018 MB / 12.12 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher(do not delete))
Temps: 0.06 ms / 301.84 ms Mémoire: 0.000 MB / 12.12 MB Application: beforeRenderModule mod_custom (Contacts)
Temps: 0.71 ms / 302.55 ms Mémoire: 0.006 MB / 12.13 MB Application: afterRenderModule mod_custom (Contacts)
Temps: 0.06 ms / 302.60 ms Mémoire: 0.000 MB / 12.12 MB Application: beforeRenderModule mod_custom (partenaires)
Temps: 0.20 ms / 302.80 ms Mémoire: 0.003 MB / 12.13 MB Application: afterRenderModule mod_custom (partenaires)
Temps: 0.05 ms / 302.85 ms Mémoire: 0.000 MB / 12.13 MB Application: beforeRenderModule mod_search (Recherche)
Temps: 0.87 ms / 303.72 ms Mémoire: 0.016 MB / 12.14 MB Application: afterRenderModule mod_search (Recherche)
Temps: 0.05 ms / 303.78 ms Mémoire: 0.000 MB / 12.14 MB Application: beforeRenderModule mod_menu (Publication)
Temps: 2.25 ms / 306.03 ms Mémoire: 0.109 MB / 12.25 MB Application: afterRenderModule mod_menu (Publication)
Temps: 0.07 ms / 306.09 ms Mémoire: 0.000 MB / 12.25 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Temps: 1.02 ms / 307.12 ms Mémoire: 0.024 MB / 12.27 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Temps: 0.07 ms / 307.18 ms Mémoire: 0.000 MB / 12.27 MB Application: beforeRenderModule mod_icemegamenu (Main menu)
Temps: 46.94 ms / 354.12 ms Mémoire: 0.929 MB / 13.20 MB Application: afterRenderModule mod_icemegamenu (Main menu)
Temps: 3.31 ms / 357.44 ms Mémoire: 0.162 MB / 13.36 MB Application: afterRender

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

Occupation de la mémoire

13,85 MB (14 521 456 Bytes)

Requêtes de base de données

25 requêtes exécutées 59.05 ms


  1. Temps de requête : 0.91 ms Mémoire de requête : 0.005 MB mémoire avant requête : 3.989 MB Rangées retournées : 0
    SELECT `session_id`
    
      FROM `k7n8e_session`
      WHERE `session_id` = X'6138633731336436333461613935633062363236303330396130316238323932'
      LIMIT 1
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_sessionconstPRIMARYPRIMARY194const1Using index
    Profil
    StatusDuration
    Starting0.14 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.08 ms
    Preparing0.01 ms
    Executing0.00 ms
    End of update loop0.05 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.10 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  2. Temps de requête : 1.43 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.004 MB mémoire avant requête : 3.995 MB
    INSERT INTO `k7n8e_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6138633731336436333461613935633062363236303330396130316238323932', 1, 1679649297, 0, '', 0)
    Explication
    EXPLAIN impossible sur la requête : INSERT INTO `k7n8e_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6138633731336436333461613935633062363236303330396130316238323932', 1, 1679649297, 0, '', 0)
    Profil
    StatusDuration
    Starting0.11 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.00 ms
    init for update0.00 ms
    Update0.00 ms
    Waiting for query cache lock0.00 ms
    Update0.00 ms
    End of update loop0.15 ms
    Query end0.01 ms
    Commit0.80 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.21 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 : 0.97 ms Après la dernière requête : 5.69 ms Mémoire de requête : 0.006 MB mémoire avant requête : 4.209 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.11 ms
    checking permissions0.03 ms
    Opening tables0.00 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.05 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.00 ms
    Executing0.00 ms
    Sending data0.33 ms
    End of update loop0.00 ms
    Query end0.04 ms
    Commit0.00 ms
    closing tables0.03 ms
    Unlocking tables0.01 ms
    closing tables0.02 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
    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.85 ms Après la dernière requête : 4.29 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.408 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.11 ms
    checking permissions0.00 ms
    Opening tables0.07 ms
    After opening tables0.03 ms
    System lock0.00 ms
    table lock0.03 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.00 ms
    Preparing0.00 ms
    Executing0.00 ms
    Sending data0.18 ms
    End of update loop0.04 ms
    Query end0.00 ms
    Commit0.02 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.14 ms
    Updating status0.03 ms
    Reset for next command0.03 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:321
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  5. Temps de requête : 1.02 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.421 MB Rangées retournées : 2
    SELECT b.id
    
      FROM k7n8e_usergroups AS a
      LEFT JOIN k7n8e_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2Using where; Using index
    Profil
    StatusDuration
    Starting0.19 ms
    checking permissions0.04 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.00 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.00 ms
    Executing0.00 ms
    Sending data0.33 ms
    End of update loop0.04 ms
    Query end0.00 ms
    Commit0.03 ms
    closing tables0.01 ms
    Unlocking tables0.04 ms
    closing tables0.03 ms
    Starting cleanup0.05 ms
    Freeing items0.11 ms
    Updating status0.05 ms
    Reset for next command0.00 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.14 ms Après la dernière requête : 1.25 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.489 MB Rangées retournées : 132
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM k7n8e_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_extensionsALLextensionINDEX N'A PU ÊTRE UTILISÉNULLNULL371Using where; Utilisation du tri complet de type filesort
    Profil
    StatusDuration
    Starting0.21 ms
    checking permissions0.00 ms
    Opening tables0.06 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.00 ms
    Preparing0.00 ms
    Sorting result0.28 ms
    Executing0.02 ms
    Sending data0.02 ms
    Creating sort index0.98 ms
    End of update loop0.01 ms
    Query end0.05 ms
    Commit0.00 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.04 ms
    Starting cleanup0.03 ms
    Freeing items0.17 ms
    Updating status0.04 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.05 ms Après la dernière requête : 51.93 ms Mémoire de requête : 0.005 MB mémoire avant requête : 6.796 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.23 ms
    checking permissions0.05 ms
    Opening tables0.03 ms
    After opening tables0.03 ms
    System lock0.01 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.00 ms
    Preparing0.16 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.35 ms
    Updating status0.04 ms
    Reset for next command0.00 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    10JDatabaseDriver->loadAssocList()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58
    9plgSystemSocialLoginTools::sociallogin_getsettings()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51
    8plgSystemSocialLoginAndSocialShare->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:626
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  8. Temps de requête : 3.76 ms Après la dernière requête : 6.24 ms Mémoire de requête : 0.009 MB mémoire avant requête : 7.117 MB Rangées retournées : 118
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM k7n8e_menu AS m
      LEFT JOIN k7n8e_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const199Using index condition; Using where; Utilisation du tri complet de type filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4cnpfca_cnpf.m.component_id1Using where
    Profil
    StatusDuration
    Starting0.26 ms
    checking permissions0.06 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.26 ms
    Preparing0.00 ms
    Sorting result0.00 ms
    Executing0.00 ms
    Sending data0.00 ms
    Creating sort index2.63 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.36 ms
    Reset for next command0.00 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.25 ms Après la dernière requête : 21.87 ms Mémoire de requête : 0.007 MB mémoire avant requête : 8.306 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.23 ms
    checking permissions0.00 ms
    Opening tables0.08 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.28 ms
    Preparing0.00 ms
    Executing0.00 ms
    Sending data0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.03 ms
    Starting cleanup0.03 ms
    Freeing items0.44 ms
    Updating status0.06 ms
    Reset for next command0.04 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Même appel que celui de la ligne ci-dessous.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1130
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  10. Temps de requête : 2.23 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.005 MB mémoire avant requête : 8.297 MB
    UPDATE `k7n8e_extensions`
    
      SET `params` = '{\"mediaversion\":\"6bb2f17f0a35bc9e89554c59f0954b20\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explication
    EXPLAIN impossible sur la requête : UPDATE `k7n8e_extensions` SET `params` = '{\"mediaversion\":\"6bb2f17f0a35bc9e89554c59f0954b20\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profil
    StatusDuration
    Starting0.19 ms
    checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.00 ms
    table lock0.03 ms
    init for update0.00 ms
    Updating0.24 ms
    End of update loop0.00 ms
    Waiting for query cache lock0.18 ms
    End of update loop0.03 ms
    Query end0.00 ms
    Commit1.04 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.26 ms
    Updating status0.07 ms
    Reset for next command0.00 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1130
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  11. Temps de requête : 1.29 ms Après la dernière requête : 5.12 ms Mémoire de requête : 0.003 MB mémoire avant requête : 8.544 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.26 ms
    checking permissions0.02 ms
    Opening tables0.00 ms
    After opening tables0.05 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.05 ms
    Optimizing0.01 ms
    Statistics0.00 ms
    Preparing0.00 ms
    Sorting result0.00 ms
    Executing0.00 ms
    Sending data0.00 ms
    Creating sort index0.28 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.10 ms
    Unlocking tables0.02 ms
    closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.26 ms
    Reset for next command0.00 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  12. Temps de requête : 1.36 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.003 MB mémoire avant requête : 8.565 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.19 ms
    checking permissions0.00 ms
    Opening tables0.00 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.09 ms
    Preparing0.06 ms
    Executing0.02 ms
    Sending data0.50 ms
    End of update loop0.02 ms
    Query end0.03 ms
    Commit0.10 ms
    closing tables0.02 ms
    Unlocking tables0.01 ms
    closing tables0.04 ms
    Starting cleanup0.01 ms
    Freeing items0.15 ms
    Updating status0.05 ms
    Reset for next command0.00 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  13. Temps de requête : 2.27 ms Après la dernière requête : 10.76 ms Mémoire de requête : 0.009 MB mémoire avant requête : 9.198 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.33 ms
    checking permissions0.00 ms
    Opening tables0.00 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.25 ms
    Preparing0.04 ms
    Executing0.34 ms
    Sending data0.81 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.03 ms
    Unlocking tables0.03 ms
    closing tables0.03 ms
    Starting cleanup0.03 ms
    Freeing items0.15 ms
    Updating status0.04 ms
    Reset for next command0.00 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    18Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  14. Temps de requête : 3.02 ms Après la dernière requête : 0.46 ms Mémoire de requête : 0.009 MB mémoire avant requête : 9.262 MB Rangées retournées : 799
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `k7n8e_assets`
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEk7n8e_assetsALLidx_asset_name,idx_parent_idINDEX N'A PU ÊTRE UTILISÉNULLNULL1160Using where
    Profil
    StatusDuration
    Starting0.20 ms
    checking permissions0.06 ms
    Opening tables0.01 ms
    After opening tables0.03 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.00 ms
    Preparing0.21 ms
    Executing0.00 ms
    Sending data1.76 ms
    End of update loop0.27 ms
    Query end0.05 ms
    Commit0.03 ms
    closing tables0.01 ms
    Unlocking tables0.04 ms
    closing tables0.02 ms
    Starting cleanup0.03 ms
    Freeing items0.01 ms
    Updating status0.18 ms
    Reset for next command0.00 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.55 ms Après la dernière requête : 6.83 ms Mémoire de requête : 0.008 MB mémoire avant requête : 10.066 MB Rangées retournées : 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
      FROM `k7n8e_content` AS `i`
      WHERE i.`catid` = c.id
      AND i.state = 1) AS numitems
      FROM `k7n8e_categories` AS `s`
      INNER JOIN `k7n8e_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.published = 1
      AND s.id = 11
      ORDER BY c.lft
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1
    1PRIMARYcrangecat_idx,idx_left_rightidx_left_right4NULL22Using index condition; Using where
    2DEPENDENT SUBQUERYirefidx_state,idx_catididx_catid4cnpfca_cnpf.c.id3Using index condition; Using where
    Profil
    StatusDuration
    Starting0.36 ms
    checking permissions0.04 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.16 ms
    Optimizing0.08 ms
    Statistics0.10 ms
    Preparing0.12 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Optimizing0.10 ms
    Statistics0.05 ms
    Preparing0.06 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.14 ms
    Executing0.02 ms
    Sending data0.07 ms
    Executing0.02 ms
    Sending data0.53 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.05 ms
    closing tables0.04 ms
    Starting cleanup0.03 ms
    Freeing items0.01 ms
    Removing tmp table0.02 ms
    Freeing items0.16 ms
    Updating status0.07 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.26 ms Après la dernière requête : 4.14 ms Mémoire de requête : 0.009 MB mémoire avant requête : 10.234 MB Rangées retournées : 6
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM k7n8e_content AS a
      LEFT JOIN k7n8e_categories AS c
      ON c.id = a.catid
      LEFT JOIN k7n8e_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN k7n8e_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN k7n8e_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN k7n8e_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.catid = 11 OR a.catid IN ( SELECT sub.id
      FROM k7n8e_categories as sub
      INNER JOIN k7n8e_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 11))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-24 09:14:57')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-24 09:14:57')
      ORDER BY c.lft, a.ordering, a.created
      LIMIT 30, 6
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcrangePRIMARY,idx_accessidx_access4NULL184Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
    1PRIMARYarefidx_access,idx_state,idx_catididx_catid4cnpfca_cnpf.c.id3Using index condition; Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4cnpfca_cnpf.a.created_by1Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4cnpfca_cnpf.a.modified_by1Using where
    1PRIMARYparenteq_refPRIMARYPRIMARY4cnpfca_cnpf.c.parent_id1Using where
    1PRIMARYveq_refPRIMARYPRIMARY4cnpfca_cnpf.a.id1Using where
    2MATERIALIZEDthisconstPRIMARY,idx_left_rightPRIMARY4const1
    2MATERIALIZEDsubrangePRIMARY,idx_left_rightidx_left_right4NULL172Using where; Using index
    Profil
    StatusDuration
    Starting0.55 ms
    checking permissions0.00 ms
    Opening tables0.16 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.04 ms
    Statistics0.18 ms
    Preparing0.11 ms
    Optimizing0.03 ms
    Statistics0.15 ms
    Preparing0.38 ms
    Creating tmp table0.11 ms
    Sorting result0.03 ms
    Executing0.00 ms
    Sending data0.28 ms
    Executing0.00 ms
    Sending data8.16 ms
    Creating sort index0.65 ms
    Removing tmp table0.56 ms
    Creating sort index0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.26 ms
    closing tables0.04 ms
    Unlocking tables0.01 ms
    closing tables0.06 ms
    Starting cleanup0.03 ms
    Freeing items0.03 ms
    Removing tmp table0.03 ms
    Freeing items0.02 ms
    Removing tmp table0.03 ms
    Freeing items0.18 ms
    Updating status0.06 ms
    Reset for next command0.00 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 : 7.25 ms Après la dernière requête : 2.28 ms Mémoire de requête : 0.009 MB mémoire avant requête : 10.451 MB Rangées retournées : 1
    SELECT COUNT(*)
    
      FROM k7n8e_content AS a
      LEFT JOIN k7n8e_categories AS c
      ON c.id = a.catid
      LEFT JOIN k7n8e_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN k7n8e_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN k7n8e_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN k7n8e_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.catid = 11 OR a.catid IN ( SELECT sub.id
      FROM k7n8e_categories as sub
      INNER JOIN k7n8e_categories as this
      ON sub.lft > this.lft
      AND sub.rgt < this.rgt
      WHERE this.id = 11))
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-24 09:14:57')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-24 09:14:57')
    Explication
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcALLPRIMARY,idx_accessINDEX N'A PU ÊTRE UTILISÉNULLNULL185Using where
    1PRIMARYarefidx_access,idx_state,idx_catididx_catid4cnpfca_cnpf.c.id3Using index condition; Using where
    2MATERIALIZEDthisconstPRIMARY,idx_left_rightPRIMARY4const1
    2MATERIALIZEDsubrangePRIMARY,idx_left_rightidx_left_right4NULL172Using where; Using index
    Profil
    StatusDuration
    Starting0.24 ms
    checking permissions0.00 ms
    Opening tables0.00 ms
    After opening tables0.00 ms
    System lock0.01 ms
    table lock0.03 ms
    init0.10 ms
    Optimizing0.08 ms
    Statistics0.18 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.09 ms
    Optimizing0.03 ms
    Statistics0.43 ms
    Preparing0.00 ms
    Executing0.00 ms
    Sending data0.00 ms
    Executing0.01 ms
    Sending data5.42 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.09 ms
    closing tables0.02 ms
    Unlocking tables0.03 ms
    closing tables0.03 ms
    Starting cleanup0.03 ms
    Freeing items0.03 ms
    Removing tmp table0.03 ms
    Freeing items0.02 ms
    Removing tmp table0.00 ms
    Freeing items0.16 ms
    Updating status0.07 ms
    Reset for next command0.02 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    17JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:282
    15Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:232
    14Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  18. Temps de requête : 1.26 ms Après la dernière requête : 2.13 ms Mémoire de requête : 0.007 MB mémoire avant requête : 10.584 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.23 ms
    checking permissions0.00 ms
    Opening tables0.00 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.30 ms
    Statistics0.00 ms
    Preparing0.00 ms
    Executing0.00 ms
    Sending data0.28 ms
    End of update loop0.02 ms
    Query end0.00 ms
    Commit0.02 ms
    closing tables0.04 ms
    Unlocking tables0.01 ms
    closing tables0.04 ms
    Starting cleanup0.02 ms
    Freeing items0.18 ms
    Updating status0.04 ms
    Reset for next command0.00 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.67 ms Après la dernière requête : 5.46 ms Mémoire de requête : 0.010 MB mémoire avant requête : 10.990 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.33 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.15 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.37 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.18 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.03 ms
    closing tables0.02 ms
    Unlocking tables0.00 ms
    closing tables0.07 ms
    Starting cleanup0.02 ms
    Freeing items0.11 ms
    Updating status0.11 ms
    Reset for next command0.00 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:133
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  20. Temps de requête : 2.58 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.009 MB mémoire avant requête : 11.007 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.18 ms
    checking permissions0.00 ms
    Opening tables0.00 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.03 ms
    init0.37 ms
    Optimizing0.00 ms
    Statistics0.00 ms
    Preparing0.07 ms
    Creating tmp table0.09 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.86 ms
    Creating sort index0.00 ms
    Removing tmp table0.11 ms
    Creating sort index0.36 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.02 ms
    closing tables0.03 ms
    Unlocking tables0.01 ms
    closing tables0.05 ms
    Starting cleanup0.01 ms
    Freeing items0.18 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.19 ms Après la dernière requête : 59.21 ms Mémoire de requête : 0.006 MB mémoire avant requête : 11.940 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.27 ms
    checking permissions0.00 ms
    Opening tables0.08 ms
    After opening tables0.03 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.12 ms
    Statistics0.03 ms
    Preparing0.00 ms
    Executing0.00 ms
    Sending data0.22 ms
    End of update loop0.01 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.03 ms
    closing tables0.04 ms
    Starting cleanup0.03 ms
    Freeing items0.13 ms
    Updating status0.06 ms
    Reset for next command0.04 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    9JDatabaseDriver->loadResult()JROOT/templates/theme3092/includes/includes.php:31
    8include_once JROOT/templates/theme3092/includes/includes.phpJROOT/templates/theme3092/index.php:3
    7require JROOT/templates/theme3092/index.phpJROOT/libraries/src/Document/HtmlDocument.php:668
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:730
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:545
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1030
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  22. Temps de requête : 3.72 ms Après la dernière requête : 2.10 ms Mémoire de requête : 0.008 MB mémoire avant requête : 12.043 MB Rangées retournées : 19
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM k7n8e_modules AS m
      LEFT JOIN k7n8e_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN k7n8e_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-24 09:14:57')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-24 09:14:57')
      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,newsfeedspublished1const80Using index condition; Using where; Utilisation du tri complet de type filesort
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403cnpfca_cnpf.m.module,const1Using index condition; Using where
    1SIMPLEmmrefPRIMARYPRIMARY4cnpfca_cnpf.m.id1Using where; Using index
    Profil
    StatusDuration
    Starting0.20 ms
    checking permissions0.00 ms
    Opening tables0.00 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.31 ms
    Optimizing0.00 ms
    Statistics0.00 ms
    Preparing0.03 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.03 ms
    Creating sort index2.60 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.03 ms
    Unlocking tables0.03 ms
    closing tables0.06 ms
    Starting cleanup0.01 ms
    Freeing items0.00 ms
    Updating status0.23 ms
    Reset for next command0.00 ms
    Pile d'appels
    #AppelFichier et numéro de ligne
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()Même appel que celui de la ligne ci-dessous.
    14call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:432
    12Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:362
    11Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    10Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:591
    9Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/theme3092/includes/includes.php:114
    8include_once JROOT/templates/theme3092/includes/includes.phpJROOT/templates/theme3092/index.php:3
    7require JROOT/templates/theme3092/index.phpJROOT/libraries/src/Document/HtmlDocument.php:668
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:730
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:545
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1030
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

  23. Temps de requête : 1.06 ms Après la dernière requête : 15.65 ms Mémoire de requête : 0.010 MB mémoire avant requête : 12.825 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.25 ms
    checking permissions0.00 ms
    Opening tables0.00 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.00 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.34 ms
    Executing0.02 ms
    Sending data0.03 ms
    End of update loop0.04 ms
    Query end0.03 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.16 ms
    Updating status0.06 ms
    Reset for next command0.04 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.96 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.010 MB mémoire avant requête : 12.835 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.20 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.03 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Unlocking tables0.03 ms
    Preparing0.02 ms
    Executing0.02 ms
    Sending data0.02 ms
    End of update loop0.04 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Starting cleanup0.03 ms
    Freeing items0.13 ms
    Updating status0.08 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.98 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.010 MB mémoire avant requête : 12.845 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.18 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    After opening tables0.03 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Unlocking tables0.03 ms
    Preparing0.02 ms
    Executing0.02 ms
    Sending data0.04 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.02 ms
    closing tables0.02 ms
    Unlocking tables0.01 ms
    closing tables0.03 ms
    Starting cleanup0.03 ms
    Freeing items0.13 ms
    Updating status0.07 ms
    Reset for next command0.03 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'6138633731336436333461613935633062363236303330396130316238323932', 1, 1679649297, 0, '', 0
  2. 1 × UPDATE `k7n8e_extensions` 
      SET `params` = '{\"mediaversion\":\"6bb2f17f0a35bc9e89554c59f0954b20\"}'