AFN
Association des francophones du Nunavut
981, promenade Nunavut, Boite postale 880
Iqaluit, Nunavut X0A 0H0
867-979-4606
information@afnunavut.ca
https://www.afnunavut.ca/
Président : Goump Djalogue
Directeur général: Christian Ouaka
Association des francophones du Nunavut
981, promenade Nunavut, Boite postale 880
Iqaluit, Nunavut X0A 0H0
867-979-4606
information@afnunavut.ca
https://www.afnunavut.ca/
Président : Goump Djalogue
Directeur général: Christian Ouaka
Valoriser le français des parents, un projet qui résonne
" Célébrer la diversité de la francophonie pancanadienne "
Valoriser le français des parents
Langue paternelle et insécurité linguistique
Panorama -Radio-Canada Colombie-Britannique et Yukon
Lien vers l'entrevue
" Les enfants qui parlent le français ça vient de l'école mais aussi de l'engagement des parents "
Journée Mondiale des parents
Dans la mosaïque - Radio-Canada, Toronto - Windsor
Lien vers l'entrevue
"On veut que les parents soient fiers de la façon dont ils parlent français,
on veut qu'ils se sentent confiants et ont veut que tous leurs efforts soient célébrés "
Valoriser le français des parents
Café show - Radio-Canada, Alberta
Lien vers l'entrevue
3 Partenaires nationaux
Ce projet est porté conjointement par la Commission nationale des parents francophones (CNPF), l’Alliance des femmes de la francophonie canadienne (AFFC) et la Fédération des aînées et aînés francophones du Canada (FAAFC)
Objectif du projet
Amener des organismes francophones de différents secteurs (des parents, des aînés et des femmes francophones) à travailler ensemble, grâce à l'approche intermédiaire, où plus d'une centaine d'organismes appuieront les services d'établissement francophones au pays pour favoriser l'intégration et la rétention des nouveaux arrivants à l’intérieur des CLOSM
Investissement fédéral
La mise en œuvre de ce projet a été rendue possible grâce à un financement de 2,5 M $ accordé par le gouvernement fédéral pour la période de 2020 à 2025. Ce projet est financé par le ministère Immigration, Réfugiés et Citoyenneté Canada.
Secteurs PARENTS
1re activité :
Développer un programme d'accueil et d'intégration au sein des comités de parents dans chacune des écoles francophones intéressées par l'initiative. Ces comités de parents pourraient faire le pont avec les services d'établissement francophones de nouveaux arrivants un peu partout au pays pour mieux appuyer l'arrivée des familles en sol canadien et faciliter l'intégration des enfants et des parents à l'école francophone. Cette initiative pourrait prendre la forme d'activités de promotion, de sensibilisation, de formation auprès des comités de parents dans les écoles pour les habiliter à travailler à l'intégration des familles nouvellement arrivées.
2e activité :
Explorer avec les services d'établissement francophones la possibilité de mettre en place dans la troisième année de projet différentes activités d'intégration et de réciprocité pour les familles d'expression française nouvellement arrivées pour favoriser leur intégration au sein de nos communautés. Ces activités pourraient prendre la forme de conversation avec les parents nouvellement arrivés, d'activités pour ces parents lors des soirées Voir Loin Voir Grand, de programme de jumelage entre familles citoyennes et familles nouvellement arrivées.
Organisations membres de la CNPF participant à l’initiative:
La Fédération des parents francophones de l'Alberta
Association des Parents Fransaskois
La Fédération des parents de la francophonie manitobaine
Parents partenaires en éducation
Fédération des parents acadiens de la Nouvelle-Écosse
2020-2021 FAITS SAILLANTS
• 964 personnes immigrantes ont été desservies à l'intérieur des activités menées par les parents bénévoles.
• 48 comités de parents dans les différentes écoles ont été mis en place des programmes et des activités pour les parents et les familles nouvellement arrivées.
• 59 activités de toutes sortes auront été offertes aux parents d'expression française nouvellement arrivés dans les différentes écoles.
Secteurs FEMMES
1re activité :
Réaliser une étude de besoins des femmes immigrantes francophones vivant en situation minoritaire sera réalisées dans les cinq provinces et territoires suivants : Nouvelle-Écosse, Ontario, Manitoba, Yukon, Colombie-Britannique. Cette étude de besoins sera mise en œuvre en collaboration avec les Réseaux en immigration francophone (RIF) et les organisations membres de L'AFFC.
Organisations membres de l'AFFC participant à l’initiative:
Les essentielles
Réseau-Femmes Colombie-Britannique
Pluri-elles
Mouvement ontarien des femmes immigrantes francophones
Fédération des femmes acadiennes de la Nouvelle-Écosse
2020-2021 FAITS SAILLANTS
• Au moins 5 provinces auront participé à l’étude
• Au moins 60 femmes ont participé à l’étude
Secteurs AÎNÉS
1re activité :
Développer un programme d'activités bénévoles pour les aînés et retraités francophones à l'intérieur des services d'établissement francophones de nouveaux arrivants, et ce, pour toutes les catégories d'âge de personnes immigrantes. Cette initiative vise ainsi à appuyer les services d'établissement francophones en procédant au recrutement, à l'accompagnement et à la rétention de bénévoles retraités et aînés canadiens francophones pour assurer l'accueil et l'intégration des nouveaux arrivants d'expression française dans les communautés francophones au pays. Ces activités pourraient prendre la forme de campagne de promotion pour le recrutement de bénévoles aînés, la tenue de plusieurs webinaires d'information et de sensibilisation visant le recrutement et la formation, établir des liens avec les organismes d'établissement, etc.
2e activité :
Inviter et engager des groupes d'aînés francophones dans les différentes communautés francophones au pays à organiser des activités d'intégration et de réciprocité avec les nouvelles familles arrivantes d'expression française. Ces activités pourraient prendre la forme de « grands-parents adoptifs » et de toute autre initiative qui pourrait favoriser les échanges entre les aînés canadiens francophones et les nouveaux arrivants et conduire à une plus grande intégration de ces derniers dans nos communautés francophones.
3e activités :
Appuyer et aider les services d'établissement francophones avec l'accueil et l'intégration des nouveaux arrivants âgés d'expression française en développant une série d'activités pouvant faciliter l'intégration des aînés immigrants francophones nouvellement arrivés. Proposer et mettre en œuvre plusieurs activités de différents types qui pourraient favoriser l'intégration des aînés d'expression française nouvellement arrivés aux communautés francophones en situation minoritaire.
Organisations membres de la FAAFC participant à l’initiative:
Fédération des aînés franco-albertains
Fédération des aînés et des retraités francophones de l’Ontario
Association francophone des aînés du Nouveau-Brunswick
Regroupement des aînés francophones de la Nouvelle-Écosse
2020-2021 FAITS SAILLANTS
• 207 aînés francophones ont participé comme bénévoles à l'intérieur des programmes d'établissement francophone.
• 495 personnes immigrantes ont été desservies à l'intérieur des programmes auxquels participent les aînés bénévoles.
• 28 groupes d'aînés et retraités francophones dans les communautés sont devenus des communautés d'accueil en situation minoritaire
• 42 activités de toutes sortes ont été offertes aux aînés d'expression française nouvellement arrivés
Témoignages qui résonnent
La CNPF pense qu’il est fondamental de célébrer le français des parents avec tous ses accents, ses différences et ses particularités.
Dans ce projet, des parents francophones en situation minoritaire se livrent pour raconter leur histoire à la fois unique et universelle pour que d’autres puissent se reconnaître et bâtir à leur tour leur confiance linguistique. Au total, se sont 17 capsules vidéo dont 15 témoignages vidéo qui ont été enregistrés dans le cadre de ce projet.
« Ce projet est d'une grande richesse. L'idée est de célébrer la diversité des parcours en francophonie de parents de notre réseau pancanadien, mission accomplie!!! Grâce à la transparence des témoignages, les parents nous partagent généreusement une tranche de vie personnelle...une tranche de leur histoire familiale. C'est une façon d'en apprendre un peu plus sur chacun et sur les raisons personnelles qui les motivent à faire une place importante au français. Ces témoignages accompagnés de photos permettent de réellement « connecter » avec des parents dans leur vécu quotidien. C'est là qu'on voit que chaque parent a son parcours et que chacun de ces parcours est unique... tout comme le miens, le vôtre et celui des parents dans nos communautés francophones, ces parcours sont inspirants car ils sont vrais!!! »
Richard Vaillancourt, chargé de programmes - CNPF
Restez à l’affût !
Vous pourrez découvrir les témoignages vidéo au cours des prochaines semaines et mois à venir. Ils seront publiés les uns après les autres jusqu'au mois de novembre sur notre site internet et nos réseaux sociaux (Facebook, Twitter et YouTube et Tik Tok).
« Le français a toujours été important dans ma vie..Cela a joué un rôle dans la manière d'élever mes enfants.»
Gillian Anderson, parent de l'Alberta
« Je suis vraiment fière de savoir qu'en milieu minoritaire, nous sommes entourés de l'anglais, mais en faisant un effort de parler avec eux en français, de trouver des services de garde en français, tout ça a vraiment aidé à développer cette identité francophone. »
Kristin Chartrand, parent du Manitoba
« Leur culture francophone est importante, il faut la défendre et s’assurer que nos droits sont respectés.»
Suzana Straus, parent de la Colombie-Britannique
« Le français c’est mon énergie!. »
Annette Honda, parent du Nouveau-Brunswick
« Nous avons fait le choix d’envoyer nos enfants à l’école francophone pour soutenir notre choix de vivre en français.»
Julie Duchesne, parent de l'Île-du-Prince-Édouard
« Le français c'est moi et nous tous ensemble!. »
Jacques Lamarche, parent des Territoires du Nord-Ouest
« Ce dont je suis le plus fier aujourd’hui, c’est de voir que dans la vingtaine, le français fait toujours parti du quotidien de mes enfants.»
Richard Vaillancourt, parent de l'Alberta
« Pour moi le français c'est ma fierté!»
Nadine Morton, parent de la l'Alberta
« le français c’est qui je suis!.»
Edgard Assoua, parent de la Saskatchewan
« Pour moi le français c'est mon identité!»
Nicole Dupuis, parent de la Nouvelle-Écosse
« J'ai choisi de faire le cadeau du français parce que c'est une partie importante de ma vie, de mon identité, de mes valeurs, de mon bonheur.»
Rachelle Friesen, parent du Manitoba
« Pour moi le français c'est l'Acadie et c'est qui je suis!»
Caroline Arsenault, parent de la Nouvelle-Écosse
Ce projet est rendu possible grâce à l’appui financier du gouvernement du Canada
{ "__default": { "session": { "counter": 1, "timer": { "start": 1725164022, "last": 1725164022, "now": 1725164022 } }, "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 } } }
SELECT `session_id`
FROM `k7n8e_session`
WHERE `session_id` = X'3439616466626464663336356236373262326637353433623635393736636635'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.16 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
End of update loop | 0.07 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Query end | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.09 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `k7n8e_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3439616466626464663336356236373262326637353433623635393736636635', 1, 1725164022, 0, '', 0)
Status | Duration |
---|---|
Starting | 0.17 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init for update | 0.02 ms |
Update | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
Update | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.72 ms |
Query end | 0.02 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.11 ms |
Updating status | 0.03 ms |
Reset for next command | 0.09 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `k7n8e_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_extensions | ref | extension | extension | 82 | const | 50 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.14 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.15 ms |
Optimizing | 0.00 ms |
Statistics | 0.06 ms |
Preparing | 0.04 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
End of update loop | 0.12 ms |
Query end | 0.01 ms |
Commit | 0.14 ms |
Query end | 0.00 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.03 ms |
Query end | 0.00 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.07 ms |
Updating status | 0.14 ms |
Reset for next command | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Même appel que celui de la ligne ci-dessous. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `k7n8e_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_viewlevels | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 5 |
Status | Duration |
---|---|
Starting | 0.12 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.07 ms |
init | 0.00 ms |
Optimizing | 0.02 ms |
Statistics | 0.10 ms |
Preparing | 0.00 ms |
Executing | 0.00 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.08 ms |
Freeing items | 0.08 ms |
Updating status | 0.09 ms |
Reset for next command | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.06 ms |
checking permissions | 0.04 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
Optimizing | 0.03 ms |
Statistics | 0.00 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.13 ms |
Executing | 0.12 ms |
Sending data | 0.01 ms |
End of update loop | 0.11 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.17 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_extensions | ALL | extension | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 371 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|---|
Starting | 0.24 ms |
checking permissions | 0.00 ms |
Opening tables | 0.00 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.00 ms |
Optimizing | 0.01 ms |
Statistics | 0.05 ms |
Preparing | 0.03 ms |
Sorting result | 0.00 ms |
Executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 0.88 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.04 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.03 ms |
Query end | 0.01 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.17 ms |
Updating status | 0.11 ms |
Reset for next command | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Même appel que celui de la ligne ci-dessous. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:359 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM k7n8e_loginradius_settings
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_loginradius_settings | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 10 |
Status | Duration |
---|---|
Starting | 0.30 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
table lock | 0.04 ms |
init | 0.07 ms |
Optimizing | 0.00 ms |
Statistics | 0.04 ms |
Preparing | 0.08 ms |
Executing | 0.06 ms |
Sending data | 0.07 ms |
End of update loop | 0.02 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.09 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.14 ms |
Updating status | 0.08 ms |
Reset for next command | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
10 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58 |
9 | plgSystemSocialLoginTools::sociallogin_getsettings() | JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51 |
8 | plgSystemSocialLoginAndSocialShare->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 199 | Using index condition; Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | cnpfca_cnpf.m.component_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.16 ms |
checking permissions | 0.04 ms |
Opening tables | 31.15 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.08 ms |
Optimizing | 0.09 ms |
Statistics | 0.29 ms |
Preparing | 0.04 ms |
Sorting result | 0.00 ms |
Executing | 0.00 ms |
Sending data | 0.00 ms |
Creating sort index | 2.65 ms |
End of update loop | 0.01 ms |
Query end | 0.02 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.27 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.14 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Même appel que celui de la ligne ci-dessous. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:491 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1073 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 = 2
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 2 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.34 ms |
checking permissions | 0.00 ms |
Opening tables | 0.03 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.09 ms |
Optimizing | 0.09 ms |
Statistics | 0.20 ms |
Preparing | 0.16 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.02 ms |
Sorting result | 0.05 ms |
Executing | 0.03 ms |
Sending data | 0.11 ms |
End of update loop | 0.03 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Query end | 0.03 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.20 ms |
Updating status | 0.05 ms |
Reset for next command | 0.04 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
12 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
11 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:350 |
10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `k7n8e_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|---|
Starting | 0.22 ms |
checking permissions | 0.02 ms |
Opening tables | 0.00 ms |
After opening tables | 0.07 ms |
System lock | 0.01 ms |
table lock | 0.04 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.11 ms |
Preparing | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.07 ms |
End of update loop | 0.02 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.07 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Query end | 0.03 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.19 ms |
Updating status | 0.07 ms |
Reset for next command | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
14 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Même appel que celui de la ligne ci-dessous. |
12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1130 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `k7n8e_extensions`
SET `params` = '{\"mediaversion\":\"5999d78da9313d05414b5b35f9d5f3ee\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.22 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.10 ms |
init for update | 0.08 ms |
Updating | 0.16 ms |
End of update loop | 0.02 ms |
Waiting for query cache lock | 0.03 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.73 ms |
Query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Query end | 0.00 ms |
Starting cleanup | 0.10 ms |
Freeing items | 0.15 ms |
Updating status | 0.07 ms |
Reset for next command | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1130 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM k7n8e_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_languages | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|---|
Starting | 0.21 ms |
checking permissions | 0.00 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.00 ms |
init | 0.06 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.04 ms |
Sorting result | 0.03 ms |
Executing | 0.03 ms |
Sending data | 0.03 ms |
Creating sort index | 0.09 ms |
End of update loop | 0.00 ms |
Query end | 0.08 ms |
Commit | 0.00 ms |
Query end | 0.04 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.11 ms |
Freeing items | 0.16 ms |
Updating status | 0.05 ms |
Reset for next command | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 6 | Using index condition; Using where |
1 | SIMPLE | s | ref | idx_template | idx_template | 202 | cnpfca_cnpf.e.element | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.26 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.13 ms |
Optimizing | 0.08 ms |
Statistics | 0.11 ms |
Preparing | 0.08 ms |
Executing | 0.02 ms |
Sending data | 0.17 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.06 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.05 ms |
Query end | 0.02 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.16 ms |
Updating status | 0.10 ms |
Reset for next command | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 48 | Using index condition |
Status | Duration |
---|---|
Starting | 0.41 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.04 ms |
System lock | 0.02 ms |
table lock | 0.04 ms |
init | 0.11 ms |
Optimizing | 0.06 ms |
Statistics | 0.24 ms |
Preparing | 0.06 ms |
Executing | 0.04 ms |
Sending data | 0.70 ms |
End of update loop | 0.02 ms |
Query end | 0.03 ms |
Commit | 0.02 ms |
Query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Query end | 0.02 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.15 ms |
Updating status | 0.07 ms |
Reset for next command | 0.06 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `k7n8e_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_assets | ALL | idx_asset_name,idx_parent_id | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1177 | Using where |
Status | Duration |
---|---|
Starting | 0.24 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.00 ms |
init | 0.08 ms |
Optimizing | 0.05 ms |
Statistics | 0.04 ms |
Preparing | 0.11 ms |
Executing | 0.02 ms |
Sending data | 2.60 ms |
End of update loop | 0.02 ms |
Query end | 0.00 ms |
Commit | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.14 ms |
closing tables | 0.01 ms |
Query end | 0.00 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.14 ms |
Updating status | 0.08 ms |
Reset for next command | 0.03 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 = 2
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
1 | PRIMARY | c | range | cat_idx,idx_left_right | idx_left_right | 4 | NULL | 2 | Using index condition; Using where |
2 | DEPENDENT SUBQUERY | i | ref | idx_state,idx_catid | idx_catid | 4 | cnpfca_cnpf.c.id | 2 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.52 ms |
checking permissions | 0.03 ms |
Opening tables | 0.00 ms |
After opening tables | 0.05 ms |
System lock | 0.03 ms |
table lock | 0.00 ms |
init | 0.14 ms |
Optimizing | 0.05 ms |
Statistics | 0.13 ms |
Preparing | 0.03 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.02 ms |
Optimizing | 0.11 ms |
Statistics | 0.14 ms |
Preparing | 0.08 ms |
Sorting result | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.21 ms |
Executing | 0.00 ms |
Sending data | 0.12 ms |
Executing | 0.00 ms |
Sending data | 1.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.04 ms |
Query end | 0.02 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.00 ms |
Removing tmp table | 0.00 ms |
Freeing items | 0.29 ms |
Updating status | 0.08 ms |
Reset for next command | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 |
13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 = 2 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 = 2))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-01 04:13:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-01 04:13:42')
ORDER BY c.lft, a.ordering, a.created
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | c | ALL | PRIMARY,idx_access | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 185 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | PRIMARY | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | cnpfca_cnpf.c.id | 2 | Using index condition; Using where |
1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | cnpfca_cnpf.a.created_by | 1 | Using where |
1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | cnpfca_cnpf.a.modified_by | 1 | Using where |
1 | PRIMARY | parent | eq_ref | PRIMARY | PRIMARY | 4 | cnpfca_cnpf.c.parent_id | 1 | Using where |
1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | cnpfca_cnpf.a.id | 1 | Using where |
2 | MATERIALIZED | this | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
2 | MATERIALIZED | sub | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 183 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.55 ms |
checking permissions | 0.03 ms |
Opening tables | 0.00 ms |
After opening tables | 0.12 ms |
System lock | 0.00 ms |
table lock | 0.06 ms |
init | 0.17 ms |
Optimizing | 0.08 ms |
Statistics | 0.34 ms |
Preparing | 0.08 ms |
Optimizing | 0.05 ms |
Statistics | 0.14 ms |
Preparing | 0.07 ms |
Creating tmp table | 0.14 ms |
Sorting result | 0.00 ms |
Executing | 0.00 ms |
Sending data | 4.03 ms |
Executing | 0.05 ms |
Sending data | 4.27 ms |
Creating sort index | 3.36 ms |
Removing tmp table | 1.20 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.06 ms |
Query end | 0.03 ms |
Commit | 0.05 ms |
Query end | 0.03 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.06 ms |
Query end | 0.05 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.02 ms |
Removing tmp table | 0.00 ms |
Freeing items | 0.00 ms |
Removing tmp table | 0.00 ms |
Freeing items | 0.39 ms |
Updating status | 0.13 ms |
Reset for next command | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 = 2 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 = 2))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-01 04:13:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-01 04:13:42')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | c | ALL | PRIMARY,idx_access | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 185 | Using where |
1 | PRIMARY | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | cnpfca_cnpf.c.id | 2 | Using index condition; Using where |
2 | MATERIALIZED | this | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
2 | MATERIALIZED | sub | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 183 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.39 ms |
checking permissions | 0.03 ms |
Opening tables | 0.11 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.11 ms |
Optimizing | 0.10 ms |
Statistics | 0.20 ms |
Preparing | 0.03 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.11 ms |
Optimizing | 0.05 ms |
Statistics | 0.17 ms |
Preparing | 0.08 ms |
Executing | 0.06 ms |
Sending data | 1.24 ms |
Executing | 0.00 ms |
Sending data | 4.06 ms |
End of update loop | 0.04 ms |
Query end | 0.02 ms |
Commit | 0.03 ms |
Query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.06 ms |
Query end | 0.07 ms |
Starting cleanup | 0.14 ms |
Freeing items | 0.02 ms |
Removing tmp table | 0.03 ms |
Freeing items | 0.03 ms |
Removing tmp table | 0.00 ms |
Freeing items | 0.08 ms |
Updating status | 0.12 ms |
Reset for next command | 0.03 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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` = 2
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 48 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | cnpfca_cnpf.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.30 ms |
checking permissions | 0.03 ms |
Opening tables | 0.13 ms |
After opening tables | 0.04 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.12 ms |
Optimizing | 0.33 ms |
Statistics | 0.08 ms |
Preparing | 0.14 ms |
Executing | 0.00 ms |
Sending data | 0.15 ms |
End of update loop | 0.00 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Query end | 0.00 ms |
Starting cleanup | 0.21 ms |
Freeing items | 0.09 ms |
Updating status | 0.15 ms |
Reset for next command | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:229 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 (2,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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | cnpfca_cnpf.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | cnpfca_cnpf.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | cnpfca_cnpf.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | cnpfca_cnpf.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | cnpfca_cnpf.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | cnpfca_cnpf.a.id | 1 | Using where; Using index; Distinct |
Status | Duration |
---|---|
Starting | 0.23 ms |
checking permissions | 0.02 ms |
Opening tables | 0.07 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.03 ms |
init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.17 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.07 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.53 ms |
Creating sort index | 0.06 ms |
Removing tmp table | 0.07 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.03 ms |
Query end | 0.02 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.09 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 <= '2024-09-01 04:13:42')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-01 04:13:42')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 1010 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 80 | Using index condition; Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | cnpfca_cnpf.m.module,const | 1 | Using index condition; Using where |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | cnpfca_cnpf.m.id | 1 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.38 ms |
checking permissions | 0.03 ms |
Opening tables | 0.06 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.09 ms |
Optimizing | 0.09 ms |
Statistics | 0.15 ms |
Preparing | 0.09 ms |
Sorting result | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
Creating sort index | 2.43 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.03 ms |
Query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.04 ms |
Query end | 0.03 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.17 ms |
Updating status | 0.08 ms |
Reset for next command | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | Même appel que celui de la ligne ci-dessous. |
19 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
18 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
17 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
16 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
15 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/plugins/content/loadmodule/loadmodule.php:169 |
14 | PlgContentLoadmodule->_load() | JROOT/plugins/content/loadmodule/loadmodule.php:81 |
13 | PlgContentLoadmodule->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT template
FROM k7n8e_template_styles
WHERE client_id = 1
AND home = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_template_styles | ALL | idx_home | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 14 | Using where |
Status | Duration |
---|---|
Starting | 0.37 ms |
checking permissions | 0.06 ms |
Opening tables | 0.03 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.05 ms |
init | 0.05 ms |
Optimizing | 0.08 ms |
Statistics | 0.07 ms |
Preparing | 0.07 ms |
Executing | 0.04 ms |
Sending data | 0.11 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
Query end | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.03 ms |
Query end | 0.04 ms |
Starting cleanup | 0.06 ms |
Freeing items | 0.22 ms |
Updating status | 0.08 ms |
Reset for next command | 0.03 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/templates/theme3092/includes/includes.php:31 |
8 | include_once JROOT/templates/theme3092/includes/includes.php | JROOT/templates/theme3092/index.php:3 |
7 | require JROOT/templates/theme3092/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id,parent_id
FROM k7n8e_menu
WHERE id = 1010
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_menu | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.31 ms |
checking permissions | 0.03 ms |
Opening tables | 0.04 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.03 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.07 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Query end | 0.02 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.19 ms |
Updating status | 0.11 ms |
Reset for next command | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
20 | JDatabaseDriver->loadObject() | JROOT/modules/mod_icemegamenu/libs/menucore.php:83 |
19 | IceMenuTree->getCurrentMenuItem() | JROOT/modules/mod_icemegamenu/libs/menucore.php:67 |
18 | IceMenuTree->__construct() | JROOT/modules/mod_icemegamenu/helper.php:46 |
17 | modIceMegamenuHelper::buildXML() | Même appel que celui de la ligne ci-dessous. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
14 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/modules/mod_icemegamenu/helper.php:115 |
13 | modIceMegamenuHelper->getXML() | JROOT/modules/mod_icemegamenu/helper.php:154 |
12 | modIceMegamenuHelper->render() | JROOT/templates/theme3092/html/mod_icemegamenu/default.php:27 |
11 | require JROOT/templates/theme3092/html/mod_icemegamenu/default.php | JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71 |
10 | include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id,parent_id
FROM k7n8e_menu
WHERE id = 785
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_menu | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.16 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.03 ms |
init | 0.10 ms |
Optimizing | 0.01 ms |
Statistics | 0.06 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.09 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.02 ms |
Query end | 0.08 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.02 ms |
Query end | 0.04 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.12 ms |
Updating status | 0.07 ms |
Reset for next command | 0.03 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
20 | JDatabaseDriver->loadObject() | JROOT/modules/mod_icemegamenu/libs/menucore.php:83 |
19 | IceMenuTree->getCurrentMenuItem() | JROOT/modules/mod_icemegamenu/libs/menucore.php:67 |
18 | IceMenuTree->__construct() | JROOT/modules/mod_icemegamenu/helper.php:46 |
17 | modIceMegamenuHelper::buildXML() | Même appel que celui de la ligne ci-dessous. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
14 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/modules/mod_icemegamenu/helper.php:115 |
13 | modIceMegamenuHelper->getXML() | JROOT/modules/mod_icemegamenu/helper.php:154 |
12 | modIceMegamenuHelper->render() | JROOT/templates/theme3092/html/mod_icemegamenu/default.php:27 |
11 | require JROOT/templates/theme3092/html/mod_icemegamenu/default.php | JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71 |
10 | include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id,parent_id
FROM k7n8e_menu
WHERE id = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | k7n8e_menu | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.20 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.03 ms |
init | 0.04 ms |
Optimizing | 0.04 ms |
Statistics | 0.08 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.08 ms |
End of update loop | 0.00 ms |
Query end | 0.04 ms |
Commit | 0.00 ms |
Query end | 0.06 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.03 ms |
Query end | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.14 ms |
Updating status | 0.07 ms |
Reset for next command | 0.04 ms |
# | Appel | Fichier et numéro de ligne |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
20 | JDatabaseDriver->loadObject() | JROOT/modules/mod_icemegamenu/libs/menucore.php:83 |
19 | IceMenuTree->getCurrentMenuItem() | JROOT/modules/mod_icemegamenu/libs/menucore.php:67 |
18 | IceMenuTree->__construct() | JROOT/modules/mod_icemegamenu/helper.php:46 |
17 | modIceMegamenuHelper::buildXML() | Même appel que celui de la ligne ci-dessous. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
14 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/modules/mod_icemegamenu/helper.php:115 |
13 | modIceMegamenuHelper->getXML() | JROOT/modules/mod_icemegamenu/helper.php:154 |
12 | modIceMegamenuHelper->render() | JROOT/templates/theme3092/html/mod_icemegamenu/default.php:27 |
11 | require JROOT/templates/theme3092/html/mod_icemegamenu/default.php | JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71 |
10 | include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
3 × SELECT id,parent_id
FROM k7n8e_menu
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `k7n8e_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `k7n8e_extensions`
1 × SELECT template
FROM k7n8e_template_styles
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
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
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`
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
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
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`
1 × SELECT `session_id`
FROM `k7n8e_session`
1 × SELECT *
FROM k7n8e_languages
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)
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
1 × SELECT *
FROM k7n8e_loginradius_setting
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM k7n8e_extensions
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
1 × SELECT id, rules
FROM `k7n8e_viewlevels
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
1 × INSERT INTO `k7n8e_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3439616466626464663336356236373262326637353433623635393736636635', 1, 1725164022, 0, '', 0
1 × UPDATE `k7n8e_extensions`
SET `params` = '{\"mediaversion\":\"5999d78da9313d05414b5b35f9d5f3ee\"}'