Pour la 8ème année consécutive, Ensemble 77 a organisé les Journées Départementales Prévention, Santé, Sécurité sur une durée de 2 semaines, du 5 au 16 février 2018.
Les :
- 21 formations proposées sur des thématiques prévention et sécurité destinées aux salariés d'entreprise et agents de collectivités locales, gratuites ou à tarif préférentiel
- 2 sessions de sensibilisation à la prévention du risque routier, sous forme d'exercices pratiques, le 5 février 2018 de 8 h à 13 h 30 sur le site de Centaure à Réau et le 16 février 2018 de 8 h 15 à 13 h 30 sur le site de l'Automobile Club Prévention à La Brosse Monceaux.
ont rassemblé 400 participants dont 50 % d'agents de collectivités.
Les Journées Départementales Prévention Santé Sécurité remportent, chaque année, un succès grandissant.
Certaines collectivités se sont même déjà inscrites pour les formations 2019 !
Peut être faudra-t-il, en 2019, ajouter une semaine pour permettre l'accès à de nouveaux participants...
Conférences de clôture des Journées Départementales Prévention, Santé, Sécurité
Les conférences qui clôturent, comme chaque année, les Journées Départementales Prévention Santé Sécurité se sont tenues le 15 mars 2018 devant un auditoir d'une centaine de participants sur les thématiques des troubles musculo-squelettiques et de la prévention du risque routier professionnel avec la présentation des nouveaux outils mis à disposition par Ensemble 77 et la signature d'entreprises et collectivités de la Campagne "Pro au Travail, Pro au Volant".
Tous secteurs d'activité confondus, au plan national
- les accidents liés aux déplacements pour des raisons professionnelles sont la 1ère cause d'accidents mortels au travail
- les Troubles Musculo Squelettiques (TMS) représentent la 1ère cause de maladie professionnelle.
Dans un cas comme dans l'autre, les atteintes à la personne engendrent absentéisme, arrêts de travail, restrictions médicales voire inaptitudes qui ont des conséquences lourdes tant humaines qu'économiques.
Le cadre des conférences de clôture des 8ème Journées Départementales Prévention Santé Sécurité était posé !
Nouvelles approches pour réduire les risques de troubles musculosquelettiques (TMS) dans les gestes professionnels quotidiens :
Après une définition par Lilian DEVIDET, Ergonome du SIST BTP 77, 3 binômes (entreprise et expert) sont venus présenter des pratiques nouvelles mises en oeuvre sur les chantiers pour combattre les risques de TMS : échauffements musculaires, accompagnement par une étiopathe, observation des chantiers, .....
Gilles BREVAN, Contrôleur de Sécurité de l'antenne 77 de la CRAMIF, a ensuite conclu en rappelant la nécessité d'une approche globale de l'organisation de l'entreprise et de la prévention, en terminant par la présentation d'un outil national : TMS Pro.
Comment réduire les risques d'accidents du travail et de troubles musculosquelettiques lors de l'utilisation du matériel sur les chantiers ?
Suite à une présentation par Lilian DEVIDET, Ergonome du SIST BTP 77, des risques générés par l'utilisation du matériel sur les chantiers et leurs impacts sur la santé,
- Christophe GRÜN, Adjoint au Directeur d'Agence IdF de l'OPPBTP, a décrit quelques exemples dans le domaine des Travaux Publics des études économiques menées avec des entreprises pour évaluer l'impact économique de choix d'investissements destinés à améliorer la prévention des accidents et des TMS sur les chantiers.
- Vincent BLAZY, Directeur Général du groupe Melun, et Eric LANDRAIN, Directeur Technique de Région du groupe Kiloutou, ont développé l'importance de l'évolution technique du matériel et du conseil dans la prévention des risques d'accidents et de l'atteinte à la santé
- Catherine JAROSZ, Chargée de Mission Matériels, Direction Technique et de la Recherche de la FNTP, et Philippe HERITIER, Président de la commission Prévention Santé Sécurité de la CSTP 77, ont conclu par un focus sur l'atout d'une approche organisationnelle de l'entreprise et de l'existence d'une politique d'achat et de la location du matériel.
Consultez ici les présentations de cette 2ème table ronde.
Prévention du risque routier professionnel : Agissez !
Pour cette dernière table ronde destinée à faire un point d'étape sur les actions engendrées par la démarche de prévention du risque routier professionnel impulsée par Ensemble 77, deux binômes sont venus présenter des initiatives mises en oeuvre
- Cécile CAZAS, Responsable Prévention-Hygiène-Sécurité chez WIAME VRD, et Sébastien CHARLES, Directeur du Centre CENTAURE à Réau, ont détaillé une démarche de certification des conducteurs transportant du personnel, basée sur la formation certifiante "CARD PRO" portée par CENTAURE
- Nathalie CERVEIRA, Directrice des Ressources Humaines, Chargée de la Mutualisation, Communauté de Communes du Pays de Montereau, et Stéphanie KANDEL, Responsable de Centre, Automobile Club Prévention, ont détaillé les atouts et les enjeux de l'éco-conduite.
- Nathalie CERVEIRA a enchainé en explicitant la démarche de prévention du risque routier professionnel engagée par la Communauté de Communes pour ses agents mais aussi pour les agents des communes adhérentes et l'appui qu'elle trouva dans les actions proposées par Ensemble 77 auxquelles elle a apporté son concours par son retour d'expériences. Alain DEMEULIN, Vice-président Délégué au personnel, qui l'accompagnait a formalisé cet engagement en signant la Campagne "Pro au Travail, Pro au Volant" 2016-2019.
- Philippe HERITIER a enfin conclu en présentant la démarche d'Ensemble 77 dans le domaine de la prévention et plus particulièrement la prévention du risque routier professionnel, et dévoilé les nouveaux outils élaborés pour accompagner les entreprises comme les collectivités.
Consultez ici les présentations de cette 3ème table ronde ainsi que le film de présentation de la formation "CARD PRO"
Les interventions de François BLANCHARD, Ingénieur Conseil Régional CRAMIF, Francisco DA CUNHA, Président de la CSTP 77, et Anne-Claire CARATY, Cheffe du Bureau de la sécurité routière, Direction des Sécurité de la Préfecture, ont conclu cette matinée riche en témoignages et en expériences.
Une séance de signatures de la Campagne "Pro au Travail, Pro au Volant" 2016-2019 a démontré l'engagement des entreprises de Travaux Publics de Seine-et-Marne, comme celui des collectivités qui rejoignent progressivement la démarche.
Les "7èmes Journées Départementales Prévention, Santé, Sécurité" organisées par le groupe Ensemble 77 se dérouleront cette année du 20 février au 3 mars 2017 afin de répondre à la demande grandissante tant des collectivités que des entreprises !
Elles se décomposeront traditionnellement selon 3 axes :
- 20 formations sur des thématiques prévention et sécurité destinées aux salariés d'entreprise et agents de collectivités locales
- 2 conférences, le 2 mars 2017 de 9 h à 12 h, sur 2 enjeux fondamentaux : "Sécurité et santé au travail : comprendre les enjeux et les ressources à votre disposition" et "élus et chefs d'entreprises, comment vous prémunir de la faute inexcusable ?"
- exercices pratiques sur la prévention du risque routier, le 20 février 2017 de 9 h à 13 h sur le site de Centaure à Réau ainsi que le 3 mars 2017de 9 h à 13 h sur le site de l'Automobile Club Prévention à La Brosse Monceaux.
Téléchargez ici :
Les "6èmes Journées Départementales Prévention, Santé, Sécurité" organisées par le groupe Ensemble 77 qui se sont tenues cette année du 8 au 12 Février 2016 ont remporté un vif succès !
16 formations, gratuites pour certaines ou à coût préférentiel, ont rassemblé 186 participants avec une moyenne de 35 % d'agents de collectivités :
Le groupe Ensemble 77 poursuit la dynamique d'organisation des Journées Départementales Prévention, Santé et Sécurité avec la tenue des "5èmes Journées Départementales Prévention, Santé, Sécurité" du 2 au 6 Février 2015 !
Elles ont réuni, pour cette 5ème édition, 159 participants (dont 17% de représentants de collectivités) sur 5 jours dans le cadre de 11 formations.
Chaque année le nombre de participants augmente (même le taux de participation des agents de collectivités a été plus bas en 2015 que les années précédentes) tout comme le nombre de formations, puisque 3 nouvelles formations ont été créées spécifiquement pour répondre à des besoins exprimés par les entreprises :
- savoir accueillir un nouvel arrivant à son poste de travail
- savoir identifier les situations génératrices de troubles musculo-squelettiques
- prévenir les risques liés à l'utilisation des outils tenus à la main.
N'hésitez pas à nous faire part de vos questions et/ou de vos attentes dans les domaines de la prévention, santé et sécurité.
Nous mobiliserons des experts pour vous répondre et mettrons en place les actions d'information/formation utiles !
Rendez-vous le 5 novembre 2015 matin pour une demi-journée sur l'actualité réglementaire (travaux à proximité des réseaux, amiante/HAP, pénibilité,...).
Pour tout renseignement complémentaire, vous pouvez contacter Ariane GRAZIANI au 01.64.87.66.04 ou par mail Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser.
Nicole KLEIN, Préfète de Seine-et-Marne, a introduit, le 30 Janvier 2014, la journée de conférences qui a clos les "4èmes Journées Départementales Prévention, Santé, Sécurité" qui se sont déroulées du 27 au 31 Janvier 2014.
Nicole KLEIN, Préfète de Seine-et-Marne, André Aubert, Vice-président du Conseil général, Jean-Claude SIMON, membre de l'Union des Maires, et l'ensemble des membres du groupe Ensemble 77 ont lancé la campagne "Bonne Conduite" en clôture des "3èmes Journées Départementales Prévention, Santé, Sécurité" le 31 Janvier 2013.
Ils ont signé la Charte "Bonne Conduite" Ensemble 77 qui vient consolider et expliciter les chartes individuellement signées par les collectivités et les entreprises.
La commission Prévention / Santé / Sécurité pilotée par Philippe HERITIER a pris la dimension Ensemble 77 en acceptant de prendre en charge les travaux concernant la sécurité définis dans la déclinaison seine-et-marnaise de la
"convention d'engagement volontaire des acteurs de conception, réalisation et maintenance des infrastructures routières, voirie et espace public urbain"
signée par les acteurs économiques du département le 10 Juin 2010 à l'occasion du 15 ème Forum des Collectivités Locales et des Travaux Publics.
Le groupe Ensemble 77 a décidé de poursuivre la dynamique enclenchée le 5 Mai 2011 avec le lancement de la "1ère journée de la Prévention, de la Santé et de la Sécurité" en créant les
"2èmes Journées Départementales Prévention, Santé, Sécurité" !
De nouvelles réglementations dans le domaine de la prévention des risques prendront effet au 1er janvier 2012.
Tous les secteurs d’activité du domaine privé et public assujettis au code du travail sont concernés.
-
Avr 04, 10:25 am
8èmes journées départementales Prévention, Santé, Sécurité
-
Jan 30, 17:25 pm
7èmes Journées Départementales Prévention, Santé, Sécurité
-
Mar 23, 17:25 pm
6èmes Journées Départementales Prévention, Santé, Sécurité
-
Déc 17, 17:25 pm
5èmes Journées Départementales Prévention, Santé, Sécurité
-
Fév 11, 17:25 pm
4èmes Journées Départementales Prévention, Santé, Sécurité
-
Jui 02, 17:25 pm
3èmes Journées Départementales Prévention, Santé, Sécurité
-
Jui 20, 17:25 pm
1ère Journée de la Prévention, de la Santé et de la Sécurité le 5 Mai 2011
-
Jui 20, 17:25 pm
2èmes Journées Départementales Prévention, Santé, Sécurité les 7, 8 et 9 Février 2012
-
Jui 20, 11:17 am
Enjeux et évolutions réglementaires 2012, Ensemble 77 vous informe
Social & Newsletter
Console de débogage Joomla!
{ "__default": { "session": { "counter": 1, "timer": { "start": 1711694087, "last": 1711694087, "now": 1711694087 }, "client": { "forwarded": "3.234.143.63" }, "token": "nbEyILFLLUj0g6MH5H4J5MDDeOFGwXBL" }, "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 } } }
Temps
Mémoire
65 requêtes exécutées 92.29 ms
21 doubles découverts!
- Temps de requête : 0.69 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.804 MB Rangées retournées : 0
SELECT `data`
FROM `g9vdn_session`
WHERE `session_id` = '8102ede432a071675ff6e70639b26989'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.02 ms Opening tables 0.19 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Même appel que celui de la ligne ci-dessous. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 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 - Temps de requête : 0.47 ms Après la dernière requête : 4.14 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.900 MB Rangées retournées : 0
SELECT `session_id`
FROM `g9vdn_session`
WHERE `session_id` = '8102ede432a071675ff6e70639b26989'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 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 - Temps de requête : 1.98 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.004 MB mémoire avant requête : 3.905 MB
INSERT INTO `g9vdn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('8102ede432a071675ff6e70639b26989', 1, 1711694087, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `g9vdn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('8102ede432a071675ff6e70639b26989', 1, 1711694087, 0, '', 0)Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms update 0.11 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.01 ms query end 1.11 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.02 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 - Temps de requête : 1.70 ms Après la dernière requête : 10.43 ms Mémoire de requête : 0.095 MB mémoire avant requête : 4.182 MB Rangées retournées : 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `g9vdn_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref extension extension 82 const 44 1.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.24 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.34 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 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 - Temps de requête : 0.95 ms Après la dernière requête : 9.51 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.419 MB Rangées retournées : 8
SELECT id, rules
FROM `g9vdn_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_viewlevels NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 8 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.05 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.03 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.06 ms cleaning up 0.01 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 - Temps de requête : 0.89 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.432 MB Rangées retournées : 2
SELECT b.id
FROM g9vdn_usergroups AS a
LEFT JOIN g9vdn_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 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 - Temps de requête : 1.89 ms Après la dernière requête : 1.93 ms Mémoire de requête : 0.031 MB mémoire avant requête : 4.501 MB Rangées retournées : 124
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM g9vdn_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref extension extension 82 const 157 0.60 Using index condition; Using where; Utilisation du tri complet de type filesort Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 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 - Temps de requête : 4.54 ms Après la dernière requête : 64.36 ms Mémoire de requête : 0.174 MB mémoire avant requête : 7.051 MB Rangées retournées : 80
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 g9vdn_menu AS m
LEFT JOIN g9vdn_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 113 10.00 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 ensemblepnbackup.m.component_id 1 100.00 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.36 ms init 0.06 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 2.32 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 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 - Temps de requête : 1.02 ms Après la dernière requête : 53.55 ms Mémoire de requête : 0.025 MB mémoire avant requête : 8.270 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `g9vdn_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.13 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/gdpr/gdpr.php:838 8 plgSystemGdpr->onAfterRoute() 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:1122 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 - Temps de requête : 2.44 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.006 MB mémoire avant requête : 8.263 MB
UPDATE `g9vdn_extensions`
SET `params` = '{\"mediaversion\":\"9de57f0dc472faa4959bc641ff465a15\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE g9vdn_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.11 ms updating 0.11 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 1.56 ms closing tables 0.05 ms freeing items 0.08 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/gdpr/gdpr.php:838 8 plgSystemGdpr->onAfterRoute() 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:1122 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 - Temps de requête : 1.15 ms Après la dernière requête : 5.25 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.512 MB Rangées retournées : 1
SELECT *
FROM g9vdn_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_languages NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 4 25.00 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.09 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.01 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 - Temps de requête : 1.70 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.035 MB mémoire avant requête : 8.529 MB Rangées retournées : 5
SELECT id, home, template, s.params
FROM g9vdn_template_styles as s
LEFT JOIN g9vdn_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 = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 5 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 ensemblepnbackup.e.element 1 71.43 Using index condition; Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.28 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.05 ms executing 0.01 ms Sending data 0.27 ms end 0.03 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 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 - Temps de requête : 1.94 ms Après la dernière requête : 31.26 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.299 MB Rangées retournées : 44
SELECT `id`,`name`,`rules`,`parent_id`
FROM `g9vdn_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_aemagnet','com_ajax','com_allevents','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoconnectivity6','com_chronoforms6','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gdpr','com_installer','com_jce','com_jlexreview','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_sppolls','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_assets NULL range idx_asset_name idx_asset_name 202 NULL 45 100.00 Using index condition Status Duration starting 0.13 ms checking permissions 0.01 ms Opening tables 0.24 ms init 0.07 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.20 ms preparing 0.02 ms executing 0.01 ms Sending data 0.67 ms end 0.01 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.06 ms cleaning up 0.01 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 - Temps de requête : 1.76 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.072 MB mémoire avant requête : 9.352 MB Rangées retournées : 339
SELECT `id`,`name`,`rules`,`parent_id`
FROM `g9vdn_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_assets NULL ALL idx_asset_name,idx_parent_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 612 21.01 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.76 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 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 - Temps de requête : 3.38 ms Après la dernière requête : 8.50 ms Mémoire de requête : 0.025 MB mémoire avant requête : 9.692 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 `g9vdn_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `g9vdn_categories` AS `s`
INNER JOIN `g9vdn_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 = 103
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Utilisation du tri complet de type filesort 1 PRIMARY c NULL ALL cat_idx,idx_left_right INDEX N'A PU ÊTRE UTILISÉ NULL NULL 134 23.16 Using where 2 DEPENDENT SUBQUERY i NULL ref idx_state,idx_catid idx_catid 4 ensemblepnbackup.c.id 3 100.00 Using index condition; Using where Status Duration starting 0.20 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.59 ms init 0.09 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.03 ms Sorting result 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.26 ms executing 0.01 ms Sending data 0.04 ms executing 0.01 ms Sending data 1.18 ms end 0.02 ms query end 0.02 ms closing tables 0.08 ms freeing items 0.09 ms cleaning up 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 - Temps de requête : 5.80 ms Après la dernière requête : 4.55 ms Mémoire de requête : 0.158 MB mémoire avant requête : 9.853 MB Rangées retournées : 9
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 g9vdn_content AS a
LEFT JOIN g9vdn_categories AS c
ON c.id = a.catid
LEFT JOIN g9vdn_users AS ua
ON ua.id = a.created_by
LEFT JOIN g9vdn_users AS uam
ON uam.id = a.modified_by
LEFT JOIN g9vdn_categories as parent
ON parent.id = c.parent_id
LEFT JOIN g9vdn_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 = 103
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 06:34:47')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 06:34:47')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 72id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Utilisation du tri complet de type filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 9 16.00 Using index condition; Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 ensemblepnbackup.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 ensemblepnbackup.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 ensemblepnbackup.a.id 1 100.00 Using where Status Duration starting 0.30 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.55 ms init 0.16 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.18 ms preparing 0.06 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.05 ms Creating sort index 3.67 ms end 0.02 ms query end 0.02 ms closing tables 0.05 ms freeing items 0.06 ms cleaning up 0.02 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 - Temps de requête : 1.27 ms Après la dernière requête : 3.42 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.149 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `g9vdn_contentitem_tag_map` AS m
INNER JOIN `g9vdn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 197
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ensemblepnbackup.m.tag_id 1 100.00 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.39 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 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 - Temps de requête : 0.95 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.167 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `g9vdn_contentitem_tag_map` AS m
INNER JOIN `g9vdn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 196
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ensemblepnbackup.m.tag_id 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 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 - Temps de requête : 0.95 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.185 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `g9vdn_contentitem_tag_map` AS m
INNER JOIN `g9vdn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 195
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ensemblepnbackup.m.tag_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 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 - Temps de requête : 0.91 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.203 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `g9vdn_contentitem_tag_map` AS m
INNER JOIN `g9vdn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 194
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ensemblepnbackup.m.tag_id 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 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 - Temps de requête : 0.89 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.221 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `g9vdn_contentitem_tag_map` AS m
INNER JOIN `g9vdn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 193
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ensemblepnbackup.m.tag_id 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 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 - Temps de requête : 0.84 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.239 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `g9vdn_contentitem_tag_map` AS m
INNER JOIN `g9vdn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 192
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ensemblepnbackup.m.tag_id 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 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 - Temps de requête : 1.07 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.257 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `g9vdn_contentitem_tag_map` AS m
INNER JOIN `g9vdn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 188
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ensemblepnbackup.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 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 - Temps de requête : 1.11 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.274 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `g9vdn_contentitem_tag_map` AS m
INNER JOIN `g9vdn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 191
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ensemblepnbackup.m.tag_id 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 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 - Temps de requête : 1.06 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.292 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `g9vdn_contentitem_tag_map` AS m
INNER JOIN `g9vdn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 218
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ensemblepnbackup.m.tag_id 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 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 - Temps de requête : 1.23 ms Après la dernière requête : 5.41 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.381 MB Rangées retournées : 1
SELECT COUNT(*)
FROM g9vdn_content AS a
LEFT JOIN g9vdn_categories AS c
ON c.id = a.catid
LEFT JOIN g9vdn_users AS ua
ON ua.id = a.created_by
LEFT JOIN g9vdn_users AS uam
ON uam.id = a.modified_by
LEFT JOIN g9vdn_categories as parent
ON parent.id = c.parent_id
LEFT JOIN g9vdn_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 = 103
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 06:34:47')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 06:34:47')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 9 16.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 ensemblepnbackup.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 ensemblepnbackup.a.modified_by 1 100.00 Using where; Using index 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where; Using index 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 ensemblepnbackup.a.id 1 100.00 Using where; Using index Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.03 ms executing 0.01 ms Sending data 0.16 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 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 - Temps de requête : 1.14 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.022 MB mémoire avant requête : 10.383 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `g9vdn_contentitem_tag_map` AS m
INNER JOIN `g9vdn_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 103
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 ensemblepnbackup.m.tag_id 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.04 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 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 - Temps de requête : 1.55 ms Après la dernière requête : 25.96 ms Mémoire de requête : 0.026 MB mémoire avant requête : 10.962 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 `g9vdn_categories` AS `s`
INNER JOIN `g9vdn_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 = 103
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Utilisation du tri complet de type filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right INDEX N'A PU ÊTRE UTILISÉ NULL NULL 134 23.89 Using where Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.08 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.21 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.30 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 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 - Temps de requête : 2.76 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.025 MB mémoire avant requête : 10.979 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 g9vdn_fields AS a
LEFT JOIN `g9vdn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN g9vdn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN g9vdn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN g9vdn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN g9vdn_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `g9vdn_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 (103,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 ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 ensemblepnbackup.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 ensemblepnbackup.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 ensemblepnbackup.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 ensemblepnbackup.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 ensemblepnbackup.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 ensemblepnbackup.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.03 ms init 0.10 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.24 ms preparing 0.06 ms Creating tmp table 0.08 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.26 ms Creating sort index 0.05 ms end 0.01 ms query end 0.02 ms removing tmp table 0.05 ms query end 0.01 ms closing tables 0.06 ms freeing items 0.09 ms cleaning up 0.02 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:135 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 - Temps de requête : 1.02 ms Après la dernière requête : 6.41 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.272 MB Rangées retournées : 1
SELECT enabled
FROM g9vdn_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96 14 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80 13 PlgContentSppagebuilder->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 - Temps de requête : 1.04 ms Après la dernière requête : 3.14 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.355 MB Rangées retournées : 1
SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `g9vdn_contact_details` AS `contact`
WHERE contact.published = 1
AND contact.user_id = 102id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE contact NULL ALL idx_state INDEX N'A PU ÊTRE UTILISÉ NULL NULL 8 12.50 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.03 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/plugins/content/contact/contact.php:125 14 PlgContentContact->getContactData() JROOT/plugins/content/contact/contact.php:66 13 PlgContentContact->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 - Temps de requête : 0.87 ms Après la dernière requête : 0.34 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.363 MB Rangées retournées : 1
SELECT parent_id
FROM g9vdn_categories
WHERE extension='com_content'
AND id=103id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_categories NULL const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/plugins/content/jlexreview/jlexreview.php:116 15 plgContentJLexReview->_contentCategoryPermission() JROOT/plugins/content/jlexreview/jlexreview.php:74 14 plgContentJLexReview->p2show() JROOT/plugins/content/jlexreview/jlexreview.php:190 13 plgContentJLexReview->onContentBeforeDisplay() 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:121 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 - Temps de requête : 0.82 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.377 MB Rangées retournées : 1
SELECT enabled
FROM g9vdn_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96 14 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80 13 PlgContentSppagebuilder->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 - Temps de requête : 0.73 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.387 MB Rangées retournées : 1
SELECT parent_id
FROM g9vdn_categories
WHERE extension='com_content'
AND id=103id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_categories NULL const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.80 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/plugins/content/jlexreview/jlexreview.php:116 15 plgContentJLexReview->_contentCategoryPermission() JROOT/plugins/content/jlexreview/jlexreview.php:74 14 plgContentJLexReview->p2show() JROOT/plugins/content/jlexreview/jlexreview.php:190 13 plgContentJLexReview->onContentBeforeDisplay() 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:121 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 - Temps de requête : 0.82 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.394 MB Rangées retournées : 1
SELECT enabled
FROM g9vdn_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96 14 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80 13 PlgContentSppagebuilder->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 - Temps de requête : 0.43 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.403 MB Rangées retournées : 1
SELECT parent_id
FROM g9vdn_categories
WHERE extension='com_content'
AND id=103id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_categories NULL const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/plugins/content/jlexreview/jlexreview.php:116 15 plgContentJLexReview->_contentCategoryPermission() JROOT/plugins/content/jlexreview/jlexreview.php:74 14 plgContentJLexReview->p2show() JROOT/plugins/content/jlexreview/jlexreview.php:190 13 plgContentJLexReview->onContentBeforeDisplay() 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:121 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 - Temps de requête : 0.46 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.410 MB Rangées retournées : 1
SELECT enabled
FROM g9vdn_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96 14 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80 13 PlgContentSppagebuilder->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 - Temps de requête : 0.65 ms Après la dernière requête : 13.07 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.399 MB Rangées retournées : 1
SELECT parent_id
FROM g9vdn_categories
WHERE extension='com_content'
AND id=103id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_categories NULL const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/plugins/content/jlexreview/jlexreview.php:116 15 plgContentJLexReview->_contentCategoryPermission() JROOT/plugins/content/jlexreview/jlexreview.php:74 14 plgContentJLexReview->p2show() JROOT/plugins/content/jlexreview/jlexreview.php:190 13 plgContentJLexReview->onContentBeforeDisplay() 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:121 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 - Temps de requête : 0.68 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.407 MB Rangées retournées : 1
SELECT enabled
FROM g9vdn_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96 14 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80 13 PlgContentSppagebuilder->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 - Temps de requête : 0.60 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.415 MB Rangées retournées : 1
SELECT parent_id
FROM g9vdn_categories
WHERE extension='com_content'
AND id=103id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_categories NULL const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/plugins/content/jlexreview/jlexreview.php:116 15 plgContentJLexReview->_contentCategoryPermission() JROOT/plugins/content/jlexreview/jlexreview.php:74 14 plgContentJLexReview->p2show() JROOT/plugins/content/jlexreview/jlexreview.php:190 13 plgContentJLexReview->onContentBeforeDisplay() 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:121 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 - Temps de requête : 0.81 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.423 MB Rangées retournées : 1
SELECT enabled
FROM g9vdn_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96 14 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80 13 PlgContentSppagebuilder->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 - Temps de requête : 0.69 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.431 MB Rangées retournées : 1
SELECT parent_id
FROM g9vdn_categories
WHERE extension='com_content'
AND id=103id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_categories NULL const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/plugins/content/jlexreview/jlexreview.php:116 15 plgContentJLexReview->_contentCategoryPermission() JROOT/plugins/content/jlexreview/jlexreview.php:74 14 plgContentJLexReview->p2show() JROOT/plugins/content/jlexreview/jlexreview.php:190 13 plgContentJLexReview->onContentBeforeDisplay() 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:121 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 - Temps de requête : 3.12 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.439 MB Rangées retournées : 1
SELECT enabled
FROM g9vdn_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96 14 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80 13 PlgContentSppagebuilder->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 - Temps de requête : 0.56 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.448 MB Rangées retournées : 1
SELECT parent_id
FROM g9vdn_categories
WHERE extension='com_content'
AND id=103id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_categories NULL const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/plugins/content/jlexreview/jlexreview.php:116 15 plgContentJLexReview->_contentCategoryPermission() JROOT/plugins/content/jlexreview/jlexreview.php:74 14 plgContentJLexReview->p2show() JROOT/plugins/content/jlexreview/jlexreview.php:190 13 plgContentJLexReview->onContentBeforeDisplay() 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:121 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 - Temps de requête : 0.70 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.455 MB Rangées retournées : 1
SELECT enabled
FROM g9vdn_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96 14 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80 13 PlgContentSppagebuilder->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 - Temps de requête : 0.55 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.464 MB Rangées retournées : 1
SELECT parent_id
FROM g9vdn_categories
WHERE extension='com_content'
AND id=103id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_categories NULL const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/plugins/content/jlexreview/jlexreview.php:116 15 plgContentJLexReview->_contentCategoryPermission() JROOT/plugins/content/jlexreview/jlexreview.php:74 14 plgContentJLexReview->p2show() JROOT/plugins/content/jlexreview/jlexreview.php:190 13 plgContentJLexReview->onContentBeforeDisplay() 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:121 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 - Temps de requête : 0.62 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.471 MB Rangées retournées : 1
SELECT enabled
FROM g9vdn_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96 14 PlgContentSppagebuilder->isSppagebuilderEnabled() JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80 13 PlgContentSppagebuilder->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 - Temps de requête : 0.51 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.480 MB Rangées retournées : 1
SELECT parent_id
FROM g9vdn_categories
WHERE extension='com_content'
AND id=103id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_categories NULL const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/plugins/content/jlexreview/jlexreview.php:116 15 plgContentJLexReview->_contentCategoryPermission() JROOT/plugins/content/jlexreview/jlexreview.php:74 14 plgContentJLexReview->p2show() JROOT/plugins/content/jlexreview/jlexreview.php:190 13 plgContentJLexReview->onContentBeforeDisplay() 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:121 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 - Temps de requête : 0.79 ms Après la dernière requête : 67.60 ms Mémoire de requête : 0.020 MB mémoire avant requête : 13.281 MB Rangées retournées : 0
SELECT id,placeholder
FROM `g9vdn_gdpr_checkbox`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_gdpr_checkbox NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 8 JDatabaseDriver->loadObjectList() JROOT/plugins/system/gdpr/gdpr.php:1091 7 plgSystemGdpr->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 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 - Temps de requête : 0.89 ms Après la dernière requête : 45.11 ms Mémoire de requête : 0.025 MB mémoire avant requête : 14.253 MB Rangées retournées : 1
SELECT id, title, module, position, content, showtitle, params
FROM g9vdn_modules AS m
WHERE m.published = 1
AND m.id = 150
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-03-29 06:34:47')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-29 06:34:47')
AND m.access IN (1,1,5)
AND m.client_id = 0
ORDER BY position, orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL const PRIMARY,published PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.21 ms init 0.04 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/plugins/system/helix3/core/classes/menu.php:516 17 Helix3Menu->load_module() JROOT/plugins/system/helix3/core/classes/menu.php:354 16 Helix3Menu->mega() JROOT/plugins/system/helix3/core/classes/menu.php:214 15 Helix3Menu->getItem() JROOT/plugins/system/helix3/core/classes/menu.php:189 14 Helix3Menu->navigation() JROOT/plugins/system/helix3/core/classes/menu.php:132 13 Helix3Menu->render() JROOT/plugins/system/helix3/core/classes/menu.php:32 12 Helix3Menu->__construct() JROOT/plugins/system/helix3/core/helix3.php:838 11 Helix3::loadMegaMenu() JROOT/templates/shaper_newskit/features/menu.php:34 10 Helix3FeatureMenu->renderFeature() JROOT/plugins/system/helix3/core/helix3.php:204 9 Helix3::importFeatures() JROOT/plugins/system/helix3/core/helix3.php:246 8 Helix3::generatelayout() JROOT/templates/shaper_newskit/index.php:187 7 require JROOT/templates/shaper_newskit/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 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 - Temps de requête : 4.99 ms Après la dernière requête : 24.66 ms Mémoire de requête : 0.078 MB mémoire avant requête : 15.843 MB Rangées retournées : 0
SELECT a.*, DATE_FORMAT(a.date, "%Y-%m-%d %H:%i") mydatetime, DATE_FORMAT(a.enddate, "%Y-%m-%d %H:%i") myenddatetime,ag.vignette as agenda_vignette, ag.couleur, ag.couleur_texte, a.agenda_id, ag.titre as agenda_titre,ac.vignette as activity_vignette, ac.couleur as activity_couleur, ac.couleur_texte as activity_couleur_texte, a.activity_id, ac.titre as activity_titre,ca.vignette as category_vignette, ca.couleur as category_couleur, ca.couleur_texte as category_couleur_texte, a.category_id, ca.titre as category_titre,a.place_id, pl.titre as place_titre,a.public_id, pu.titre as public_titre,a.ressource_id, re.titre as ressource_titre,a.section_id, se.titre as section_titre,a.description
FROM `g9vdn_allevents_events` AS a
LEFT JOIN `g9vdn_allevents_agenda` AS ag
ON ag.id = a.agenda_id
and ag.published = 1
LEFT JOIN `g9vdn_allevents_activities` AS ac
ON ac.id = a.activity_id
and ac.published = 1
LEFT JOIN `g9vdn_allevents_categories` AS ca
ON ca.id = a.category_id
and ca.published = 1
LEFT JOIN `g9vdn_allevents_places` AS pl
ON pl.id = a.place_id
and pl.published = 1
LEFT JOIN `g9vdn_allevents_public` AS pu
ON pu.id = a.public_id
and pu.published = 1
LEFT JOIN `g9vdn_allevents_ressources` AS re
ON re.id = a.ressource_id
and re.published = 1
LEFT JOIN `g9vdn_allevents_sections` AS se
ON se.id = a.section_id
and se.published = 1
WHERE (a.published = 1)
AND (a.cancelled = 0)
AND (a.proposal = 0)
AND (ifnull(a.publishingdate,now()) <= now())
AND (a.access IN (1,1,5) or (a.access=0))
AND (ifnull(ag.access,1) IN (1,1,5) or (ag.access=0))
AND (ifnull(ac.access,1) IN (1,1,5) or (ac.access=0))
AND (ifnull(ca.access,1) IN (1,1,5) or (ca.access=0))
AND (ifnull(pl.access,1) IN (1,1,5) or (pl.access=0))
AND (ifnull(pu.access,1) IN (1,1,5) or (pu.access=0))
AND (ifnull(re.access,1) IN (1,1,5) or (re.access=0))
AND (ifnull(se.access,1) IN (1,1,5) or (se.access=0))
AND (a.hot = 1)
AND ((DATE_FORMAT(a.date,'%Y%m%d') > DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d')) or (DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d') between DATE_FORMAT(a.date,'%Y%m%d')
and DATE_FORMAT(a.enddate,'%Y%m%d')))
ORDER BY
case a.allday when 0 then a.date when 1 then date(a.date) end ASC, weight DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pu NULL system PRIMARY,ndx_published INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 0.00 const row not found 1 SIMPLE re NULL system PRIMARY,ndx_published INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 0.00 const row not found 1 SIMPLE se NULL system PRIMARY,ndx_published INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 0.00 const row not found 1 SIMPLE a NULL ref ndx_access,ndx_published ndx_published 1 const 90 1.05 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE ag NULL eq_ref PRIMARY,ndx_published PRIMARY 4 ensemblepnbackup.a.agenda_id 1 75.00 Using where 1 SIMPLE ac NULL eq_ref PRIMARY,ndx_published PRIMARY 4 ensemblepnbackup.a.activity_id 1 100.00 Using where 1 SIMPLE ca NULL eq_ref PRIMARY,ndx_published PRIMARY 4 ensemblepnbackup.a.category_id 1 75.00 Using where 1 SIMPLE pl NULL eq_ref PRIMARY,ndx_published PRIMARY 4 ensemblepnbackup.a.place_id 1 80.00 Using where Status Duration starting 0.59 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.14 ms init 0.41 ms System lock 0.03 ms optimizing 0.09 ms statistics 0.34 ms preparing 0.14 ms Sorting result 0.03 ms executing 0.01 ms Sending data 0.25 ms Creating sort index 1.11 ms end 0.02 ms query end 0.02 ms closing tables 0.22 ms freeing items 0.10 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 24 JDatabaseDriverMysqli->execute() JROOT/modules/mod_aelist/helper.php:230 23 modAEListHelper::getItems() Même appel que celui de la ligne ci-dessous. 22 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 21 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:557 20 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_aelist/mod_aelist.php:64 19 include JROOT/modules/mod_aelist/mod_aelist.php JROOT/libraries/src/Helper/ModuleHelper.php:200 18 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/plugins/system/helix3/core/classes/menu.php:531 17 Helix3Menu->load_module() JROOT/plugins/system/helix3/core/classes/menu.php:354 16 Helix3Menu->mega() JROOT/plugins/system/helix3/core/classes/menu.php:214 15 Helix3Menu->getItem() JROOT/plugins/system/helix3/core/classes/menu.php:189 14 Helix3Menu->navigation() JROOT/plugins/system/helix3/core/classes/menu.php:132 13 Helix3Menu->render() JROOT/plugins/system/helix3/core/classes/menu.php:32 12 Helix3Menu->__construct() JROOT/plugins/system/helix3/core/helix3.php:838 11 Helix3::loadMegaMenu() JROOT/templates/shaper_newskit/features/menu.php:34 10 Helix3FeatureMenu->renderFeature() JROOT/plugins/system/helix3/core/helix3.php:204 9 Helix3::importFeatures() JROOT/plugins/system/helix3/core/helix3.php:246 8 Helix3::generatelayout() JROOT/templates/shaper_newskit/index.php:187 7 require JROOT/templates/shaper_newskit/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 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 - Temps de requête : 4.01 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.074 MB mémoire avant requête : 15.860 MB Rangées retournées : 0
SELECT a.*, DATE_FORMAT(a.date, "%Y-%m-%d %H:%i") mydatetime, DATE_FORMAT(a.enddate, "%Y-%m-%d %H:%i") myenddatetime,ag.vignette as agenda_vignette, ag.couleur, ag.couleur_texte, a.agenda_id, ag.titre as agenda_titre,ac.vignette as activity_vignette, ac.couleur as activity_couleur, ac.couleur_texte as activity_couleur_texte, a.activity_id, ac.titre as activity_titre,ca.vignette as category_vignette, ca.couleur as category_couleur, ca.couleur_texte as category_couleur_texte, a.category_id, ca.titre as category_titre,a.place_id, pl.titre as place_titre,a.public_id, pu.titre as public_titre,a.ressource_id, re.titre as ressource_titre,a.section_id, se.titre as section_titre,a.description
FROM `g9vdn_allevents_events` AS a
LEFT JOIN `g9vdn_allevents_agenda` AS ag
ON ag.id = a.agenda_id
and ag.published = 1
LEFT JOIN `g9vdn_allevents_activities` AS ac
ON ac.id = a.activity_id
and ac.published = 1
LEFT JOIN `g9vdn_allevents_categories` AS ca
ON ca.id = a.category_id
and ca.published = 1
LEFT JOIN `g9vdn_allevents_places` AS pl
ON pl.id = a.place_id
and pl.published = 1
LEFT JOIN `g9vdn_allevents_public` AS pu
ON pu.id = a.public_id
and pu.published = 1
LEFT JOIN `g9vdn_allevents_ressources` AS re
ON re.id = a.ressource_id
and re.published = 1
LEFT JOIN `g9vdn_allevents_sections` AS se
ON se.id = a.section_id
and se.published = 1
WHERE (a.published = 1)
AND (a.cancelled = 0)
AND (a.proposal = 0)
AND (ifnull(a.publishingdate,now()) <= now())
AND (a.access IN (1,1,5) or (a.access=0))
AND (ifnull(ag.access,1) IN (1,1,5) or (ag.access=0))
AND (ifnull(ac.access,1) IN (1,1,5) or (ac.access=0))
AND (ifnull(ca.access,1) IN (1,1,5) or (ca.access=0))
AND (ifnull(pl.access,1) IN (1,1,5) or (pl.access=0))
AND (ifnull(pu.access,1) IN (1,1,5) or (pu.access=0))
AND (ifnull(re.access,1) IN (1,1,5) or (re.access=0))
AND (ifnull(se.access,1) IN (1,1,5) or (se.access=0))
AND (a.hot = 1)
AND ((DATE_FORMAT(a.date,'%Y%m%d') > DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d')) or (DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d') between DATE_FORMAT(a.date,'%Y%m%d')
and DATE_FORMAT(a.enddate,'%Y%m%d')))
ORDER BY
case a.allday when 0 then a.date when 1 then date(a.date) end ASC, weight DESC
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE pu NULL system PRIMARY,ndx_published INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 0.00 const row not found 1 SIMPLE re NULL system PRIMARY,ndx_published INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 0.00 const row not found 1 SIMPLE se NULL system PRIMARY,ndx_published INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 0.00 const row not found 1 SIMPLE a NULL ref ndx_access,ndx_published ndx_published 1 const 90 1.05 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE ag NULL eq_ref PRIMARY,ndx_published PRIMARY 4 ensemblepnbackup.a.agenda_id 1 75.00 Using where 1 SIMPLE ac NULL eq_ref PRIMARY,ndx_published PRIMARY 4 ensemblepnbackup.a.activity_id 1 100.00 Using where 1 SIMPLE ca NULL eq_ref PRIMARY,ndx_published PRIMARY 4 ensemblepnbackup.a.category_id 1 75.00 Using where 1 SIMPLE pl NULL eq_ref PRIMARY,ndx_published PRIMARY 4 ensemblepnbackup.a.place_id 1 80.00 Using where Status Duration starting 0.51 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.51 ms init 0.34 ms System lock 0.02 ms optimizing 0.08 ms statistics 0.33 ms preparing 0.12 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.27 ms Creating sort index 1.08 ms end 0.01 ms query end 0.02 ms closing tables 0.07 ms freeing items 0.11 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/modules/mod_aelist/helper.php:239 23 modAEListHelper::getItems() Même appel que celui de la ligne ci-dessous. 22 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 21 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:557 20 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_aelist/mod_aelist.php:64 19 include JROOT/modules/mod_aelist/mod_aelist.php JROOT/libraries/src/Helper/ModuleHelper.php:200 18 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/plugins/system/helix3/core/classes/menu.php:531 17 Helix3Menu->load_module() JROOT/plugins/system/helix3/core/classes/menu.php:354 16 Helix3Menu->mega() JROOT/plugins/system/helix3/core/classes/menu.php:214 15 Helix3Menu->getItem() JROOT/plugins/system/helix3/core/classes/menu.php:189 14 Helix3Menu->navigation() JROOT/plugins/system/helix3/core/classes/menu.php:132 13 Helix3Menu->render() JROOT/plugins/system/helix3/core/classes/menu.php:32 12 Helix3Menu->__construct() JROOT/plugins/system/helix3/core/helix3.php:838 11 Helix3::loadMegaMenu() JROOT/templates/shaper_newskit/features/menu.php:34 10 Helix3FeatureMenu->renderFeature() JROOT/plugins/system/helix3/core/helix3.php:204 9 Helix3::importFeatures() JROOT/plugins/system/helix3/core/helix3.php:246 8 Helix3::generatelayout() JROOT/templates/shaper_newskit/index.php:187 7 require JROOT/templates/shaper_newskit/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 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 - Temps de requête : 2.19 ms Après la dernière requête : 7.91 ms Mémoire de requête : 0.060 MB mémoire avant requête : 15.884 MB Rangées retournées : 29
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM g9vdn_modules AS m
LEFT JOIN g9vdn_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN g9vdn_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-03-29 06:34:47')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-29 06:34:47')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 604 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 43 1.60 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 ensemblepnbackup.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 ensemblepnbackup.m.id 2 40.00 Using where; Using index Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.40 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.90 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() 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/Helper/ModuleHelper.php:432 14 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 13 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 12 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 11 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/helix3/core/helix3.php:512 10 Helix3::countModules() JROOT/plugins/system/helix3/core/helix3.php:459 9 Helix3::rowColumns() JROOT/plugins/system/helix3/core/helix3.php:268 8 Helix3::generatelayout() JROOT/templates/shaper_newskit/index.php:187 7 require JROOT/templates/shaper_newskit/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 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 - Temps de requête : 3.03 ms Après la dernière requête : 43.11 ms Mémoire de requête : 0.022 MB mémoire avant requête : 16.295 MB Rangées retournées : 0
SELECT *
FROM `g9vdn_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder'
AND `extension_view` = 'module'
AND `view_id` = '109'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_sppagebuilder NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 315 0.32 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.36 ms init 0.08 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.03 ms preparing 0.03 ms executing 0.01 ms Sending data 1.86 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/modules/mod_sppagebuilder/helper.php:38 12 ModSPagebuilderHelper::pageBuilderData() JROOT/modules/mod_sppagebuilder/helper.php:14 11 ModSPagebuilderHelper::getData() JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:13 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 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 - Temps de requête : 0.71 ms Après la dernière requête : 9.09 ms Mémoire de requête : 0.024 MB mémoire avant requête : 16.508 MB Rangées retournées : 1
SELECT `template`
FROM `g9vdn_template_styles`
WHERE `client_id` = 0
AND `home` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_template_styles NULL ref idx_client_id,idx_client_id_home idx_client_id 1 const 5 14.29 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_sppagebuilder/parser/addon-parser.php:633 14 AddonParser::getTemplateName() JROOT/components/com_sppagebuilder/parser/addon-parser.php:154 13 AddonParser::getAddons() JROOT/components/com_sppagebuilder/parser/addon-parser.php:729 12 require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php JROOT/modules/mod_sppagebuilder/tmpl/default.php:11 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 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 - Temps de requête : 0.95 ms Après la dernière requête : 113.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 19.856 MB Rangées retournées : 1
SELECT `template`
FROM `g9vdn_template_styles`
WHERE `client_id` = 0
AND `home` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_template_styles NULL ref idx_client_id,idx_client_id_home idx_client_id 1 const 5 14.29 Using where Status Duration starting 0.11 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.09 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.02 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37 14 SpPgaeBuilderBase::getTemplateName() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45 13 SpPgaeBuilderBase::loadAddons() JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 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 - Temps de requête : 1.14 ms Après la dernière requête : 10.51 ms Mémoire de requête : 0.025 MB mémoire avant requête : 20.339 MB Rangées retournées : 0
SELECT a.enabled
FROM `g9vdn_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 285 10.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.21 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545 15 SpPgaeBuilderBase::k2CatList() JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138 14 require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68 13 SpPgaeBuilderBase::loadAddons() JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 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 - Temps de requête : 0.94 ms Après la dernière requête : 37.95 ms Mémoire de requête : 0.024 MB mémoire avant requête : 21.628 MB Rangées retournées : 2
SELECT `id`,`title`
FROM g9vdn_itemrating_group
WHERE state=1
ORDER BY title ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_itemrating_group NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 50.00 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.08 ms checking permissions 0.02 ms Opening tables 0.17 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_sppagebuilder/addons/itemrating/admin.php:20 14 require_once JROOT/components/com_sppagebuilder/addons/itemrating/admin.php JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68 13 SpPgaeBuilderBase::loadAddons() JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 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 - Temps de requête : 0.90 ms Après la dernière requête : 8.09 ms Mémoire de requête : 0.025 MB mémoire avant requête : 22.281 MB Rangées retournées : 1
SELECT a.enabled
FROM `g9vdn_extensions` AS `a`
WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL range element_clientid,element_folder_clientid element_clientid 402 NULL 2 100.00 Using index condition Status Duration starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.02 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:470 15 SpPgaeBuilderBase::acymailingList() JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:162 14 require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68 13 SpPgaeBuilderBase::loadAddons() JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 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 - Temps de requête : 0.75 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.025 MB mémoire avant requête : 22.292 MB Rangées retournées : 1
SELECT `e`.`manifest_cache`
FROM `g9vdn_extensions` AS `e`
WHERE e.element = 'com_acymailing' OR e.element = 'com_acym'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL range element_clientid,element_folder_clientid element_clientid 402 NULL 2 100.00 Using index condition Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:529 16 SpPgaeBuilderBase::getExtensionVersion() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:475 15 SpPgaeBuilderBase::acymailingList() JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:162 14 require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68 13 SpPgaeBuilderBase::loadAddons() JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 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 - Temps de requête : 0.95 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.025 MB mémoire avant requête : 22.301 MB Rangées retournées : 1
SELECT `listid`,`name`
FROM `g9vdn_acymailing_list`
WHERE `published` = '1'
ORDER BY name DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_acymailing_list NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where; Utilisation du tri complet de type filesort Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.29 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:492 15 SpPgaeBuilderBase::acymailingList() JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:162 14 require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68 13 SpPgaeBuilderBase::loadAddons() JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 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 - Temps de requête : 2.50 ms Après la dernière requête : 43.62 ms Mémoire de requête : 0.022 MB mémoire avant requête : 23.179 MB Rangées retournées : 0
SELECT *
FROM `g9vdn_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder'
AND `extension_view` = 'module'
AND `view_id` = '137'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_sppagebuilder NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 315 0.32 Using where Status Duration starting 0.08 ms checking permissions 0.02 ms Opening tables 0.27 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.03 ms preparing 0.03 ms executing 0.01 ms Sending data 1.44 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/modules/mod_sppagebuilder/helper.php:38 12 ModSPagebuilderHelper::pageBuilderData() JROOT/modules/mod_sppagebuilder/helper.php:14 11 ModSPagebuilderHelper::getData() JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:13 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 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 - Temps de requête : 1.13 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.023 MB mémoire avant requête : 23.210 MB Rangées retournées : 1
SELECT `template`
FROM `g9vdn_template_styles`
WHERE `client_id` = 0
AND `home` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_template_styles NULL ref idx_client_id,idx_client_id_home idx_client_id 1 const 5 14.29 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.32 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37 14 SpPgaeBuilderBase::getTemplateName() JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45 13 SpPgaeBuilderBase::loadAddons() JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 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 - Temps de requête : 1.30 ms Après la dernière requête : 33.06 ms Mémoire de requête : 0.027 MB mémoire avant requête : 24.109 MB Rangées retournées : 86
SELECT *
FROM g9vdn_acymailing_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE g9vdn_acymailing_config NULL ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 86 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.15 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:481 13 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 12 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:438 11 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:822 10 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:22 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:22 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:146 7 plgSystemRegacymailing->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 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 - Temps de requête : 1.39 ms Après la dernière requête : 3.47 ms Mémoire de requête : 0.030 MB mémoire avant requête : 24.478 MB Rangées retournées : 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 `g9vdn_categories` AS `s`
INNER JOIN `g9vdn_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 = 94
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Utilisation du tri complet de type filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right INDEX N'A PU ÊTRE UTILISÉ NULL NULL 134 21.00 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 16 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/helpers/legacyrouter.php:173 15 ContentRouterRulesLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:528 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 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
32 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
10 × SELECT `m`.`tag_id`,`t`.*
FROM `g9vdn_contentitem_tag_map` AS m
INNER JOIN `g9vdn_tags` AS t
ON `m`.`tag_id` = `t`.`id`9 × SELECT enabled
FROM g9vdn_extensions9 × SELECT parent_id
FROM g9vdn_categories3 × SELECT `template`
FROM `g9vdn_template_styles`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 `g9vdn_categories` AS `s`
INNER JOIN `g9vdn_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT a.*, DATE_FORMAT(a.date, "%Y-%m-%d %H:%i") mydatetime, DATE_FORMAT(a.enddate, "%Y-%m-%d %H:%i") myenddatetime,ag.vignette as agenda_vignette, ag.couleur, ag.couleur_texte, a.agenda_id, ag.titre as agenda_titre,ac.vignette as activity_vignette, ac.couleur as activity_couleur, ac.couleur_texte as activity_couleur_texte, a.activity_id, ac.titre as activity_titre,ca.vignette as category_vignette, ca.couleur as category_couleur, ca.couleur_texte as category_couleur_texte, a.category_id, ca.titre as category_titre,a.place_id, pl.titre as place_titre,a.public_id, pu.titre as public_titre,a.ressource_id, re.titre as ressource_titre,a.section_id, se.titre as section_titre,a.description
FROM `g9vdn_allevents_events` AS a
LEFT JOIN `g9vdn_allevents_agenda` AS ag
ON ag.id = a.agenda_id
and ag.published = 1
LEFT JOIN `g9vdn_allevents_activities` AS ac
ON ac.id = a.activity_id
and ac.published = 1
LEFT JOIN `g9vdn_allevents_categories` AS ca
ON ca.id = a.category_id
and ca.published = 1
LEFT JOIN `g9vdn_allevents_places` AS pl
ON pl.id = a.place_id
and pl.published = 1
LEFT JOIN `g9vdn_allevents_public` AS pu
ON pu.id = a.public_id
and pu.published = 1
LEFT JOIN `g9vdn_allevents_ressources` AS re
ON re.id = a.ressource_id
and re.published = 1
LEFT JOIN `g9vdn_allevents_sections` AS se
ON se.id = a.section_id
and se.published = 12 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `g9vdn_assets`2 × SELECT *
FROM `g9vdn_sppagebuilder`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `g9vdn_extensions`2 × SELECT a.enabled
FROM `g9vdn_extensions` AS `a`1 × SELECT `id`,`title`
FROM g9vdn_itemrating_group1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM g9vdn_modules AS m
LEFT JOIN g9vdn_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN g9vdn_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `e`.`manifest_cache`
FROM `g9vdn_extensions` AS `e`1 × SELECT `listid`,`name`
FROM `g9vdn_acymailing_list`1 × SELECT id, title, module, position, content, showtitle, params
FROM g9vdn_modules AS m1 × SELECT id,placeholder
FROM `g9vdn_gdpr_checkbox1 × SELECT `data`
FROM `g9vdn_session`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 g9vdn_fields AS a
LEFT JOIN `g9vdn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN g9vdn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN g9vdn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN g9vdn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN g9vdn_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `g9vdn_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `g9vdn_contact_details` AS `contact`1 × SELECT `session_id`
FROM `g9vdn_session`1 × SELECT COUNT(*)
FROM g9vdn_content AS a
LEFT JOIN g9vdn_categories AS c
ON c.id = a.catid
LEFT JOIN g9vdn_users AS ua
ON ua.id = a.created_by
LEFT JOIN g9vdn_users AS uam
ON uam.id = a.modified_by
LEFT JOIN g9vdn_categories as parent
ON parent.id = c.parent_id
LEFT JOIN g9vdn_content_rating AS v
ON a.id = v.content_id1 × 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 g9vdn_content AS a
LEFT JOIN g9vdn_categories AS c
ON c.id = a.catid
LEFT JOIN g9vdn_users AS ua
ON ua.id = a.created_by
LEFT JOIN g9vdn_users AS uam
ON uam.id = a.modified_by
LEFT JOIN g9vdn_categories as parent
ON parent.id = c.parent_id
LEFT JOIN g9vdn_content_rating AS v
ON a.id = v.content_id1 × 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 `g9vdn_content` AS `i`1 × SELECT id, home, template, s.params
FROM g9vdn_template_styles as s
LEFT JOIN g9vdn_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM g9vdn_languages1 × 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 g9vdn_menu AS m
LEFT JOIN g9vdn_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM g9vdn_extensions1 × SELECT b.id
FROM g9vdn_usergroups AS a
LEFT JOIN g9vdn_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `g9vdn_viewlevels1 × SELECT *
FROM g9vdn_acymailing_confi
Autres tables :
1 × INSERT INTO `g9vdn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('8102ede432a071675ff6e70639b26989', 1, 1711694087, 0, '', 01 × UPDATE `g9vdn_extensions`
SET `params` = '{\"mediaversion\":\"9de57f0dc472faa4959bc641ff465a15\"}'