Actualités de la Municipalité
Association Gymnastique Volontaire rentrée 2021
INFORMATION La fibre arrive chez vous Covid19 post confinement
La Région Grand Est et son concessionnaire procèdent à l’ouverture commerciale du réseau optique Très Haut Débit Losange sur certaines communes de votre département.
Dans ce cadre, il est usuel que la Région Grand Est et Losange organisent localement, en partenariat avec le Département et l’intercommunalité concernée, une réunion publique pour informer les entreprises et les particuliers sur les modalités d’accès à la fibre.
Toutefois, la situation sanitaire actuelle interdit une telle possibilité. En effet, il est primordial que soient strictement respectées les mesures barrières, pour garantir la meilleure santé des concitoyens et des intervenants.
LE SIEDMTO VOUS INFORME 
Horaires des déchetteries :
Conditions d'accès :
- Carte d'accès obligatoire.
- Gestes barrières à respecter et à faire respecter.
- Port du masque et gants obligatoire.
- Nombre de véhicules en haut de quai limité à trois selon l'activité sur le site.
- Pas d'aide des gardiens au déchargement.
- Pas de mise à disposition de matériels ni d'outils aux usager.
Participation Citoyenne - Opération Tranquillité
Vous vous absentez de votre domicile durant plusieurs jours.
Vous pouvez vous présenter à la brigade de Gendarmerie compétente afin d'y déposer le formulaire " tranquillité vacances" ci dessous.
L'opération tranquillité Vacances contribue:
- à mieux lutter contre les cambriolages;
- à rassurer la population avec des passages réguliers des patrouilles de Gendarmerie sur les secteurs identifiés;
- à accroître l'efficacité des missions de prévention de proximité.
Contacts utiles :
Gendarmerie de Lusigny-sur-Barse: 03.25.41.20.09
"Un village champenois: Mesnil-Sellières"
Gérard le Berre a vécu plus de quarante ans dans le village. Il a exploré les chemins et les archives, recueilli les témoignages. Il propose ici un petit guide de promenade illustré et érudit pour des découvertes inattendues.
Promenade guidée dans un petit village champenois, apologie de la marche lente, éclairée par une connaissance approfondie de lieux anodins en apparence.
L'auteur, instituteur durant trente ans dans la commune, puis retraité, souhaite partager une expérience de découvertes et de dévoilements avec humour et érudition. Nombreuses illustrations et tout ce que le GPS ne vous dit pas....
Ce guide est disponible uniquement sur Amazon pour le prix de 9.03 €.
https://www.amazon.fr/village-champenois-Mesnil-Selli%C3%A8res-G%C3%A9rard-Berre/dp/1983336076/ref=sr_1_1?ie=UTF8&qid=1532162274&sr=8-1&keywords=mesnil+sellieres
Powered by Phoca Download
Contact
Besoin de plus d'information, de nous contacter ? Merci de remplir le formulaire.
Inscrivez-vous à notre "Info Lettre" gratuite
pour recevoir nos dernières informations.
 |
AdresseMairie deMESNIL SELLIERES.
41, Grande rue. 10220 MESNIL SELLIERES. 03 25 80 20 30 Ouverture.
Le Mardi de 16h à 18h Le Samedi de 10h à 12h Mr le Maire Le Samedi de 10h30 à 12h |
En visitant ce site, vous acceptez l'utilisation de cookies afin de vous proposer les meilleurs services possibles.
Console de débogage Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1685245697,
"last": 1685245697,
"now": 1685245697
},
"token": "KlsCjBsW7YHW3eQ41vMWfwDn671vFaxf"
},
"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
Temps: 14.76 ms / 14.76 ms Mémoire: 2.003 MB / 2.39 MB Application: afterLoad
Temps: 146.81 ms / 161.57 ms Mémoire: 6.520 MB / 8.91 MB Application: afterInitialise
Temps: 9.61 ms / 171.18 ms Mémoire: 0.815 MB / 9.73 MB Application: afterRoute
Temps: 1.15 ms / 172.33 ms Mémoire: 0.047 MB / 9.77 MB Application: beforeRenderComponent com_phocadownload
Temps: 25.88 ms / 198.21 ms Mémoire: 1.850 MB / 11.62 MB Application: afterRenderComponent com_phocadownload
Temps: 5.15 ms / 203.36 ms Mémoire: 0.407 MB / 12.03 MB Application: afterDispatch
Temps: 11.22 ms / 214.58 ms Mémoire: 0.862 MB / 12.89 MB Application: beforeRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 0.54 ms / 215.11 ms Mémoire: 0.032 MB / 12.92 MB Application: afterRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 0.21 ms / 215.33 ms Mémoire: 0.021 MB / 12.94 MB Application: beforeRenderModule mod_custom (Mentions légales)
Temps: 0.64 ms / 215.97 ms Mémoire: 0.006 MB / 12.95 MB Application: afterRenderModule mod_custom (Mentions légales)
Temps: 0.25 ms / 216.22 ms Mémoire: -0.020 MB / 12.93 MB Application: beforeRenderModule mod_hobosm (Map Module)
Temps: 238.30 ms / 454.51 ms Mémoire: 0.667 MB / 13.60 MB Application: afterRenderModule mod_hobosm (Map Module)
Temps: 0.30 ms / 454.81 ms Mémoire: 0.017 MB / 13.61 MB Application: beforeRenderModule mod_custom (Abonnez-vous)
Temps: 9.86 ms / 464.67 ms Mémoire: 0.749 MB / 14.36 MB Application: afterRenderModule mod_custom (Abonnez-vous)
Temps: 81.40 ms / 546.07 ms Mémoire: -0.003 MB / 14.36 MB Application: beforeRenderModule mod_custom (Contact)
Temps: 0.79 ms / 546.86 ms Mémoire: 0.006 MB / 14.37 MB Application: afterRenderModule mod_custom (Contact)
Temps: 0.39 ms / 547.26 ms Mémoire: 0.003 MB / 14.37 MB Application: beforeRenderModule mod_parallax_scroll (Photo avant contact)
Temps: 0.97 ms / 548.23 ms Mémoire: 0.029 MB / 14.40 MB Application: afterRenderModule mod_parallax_scroll (Photo avant contact)
Temps: 0.35 ms / 548.58 ms Mémoire: -0.006 MB / 14.39 MB Application: beforeRenderModule mod_menu (Menu)
Temps: 2.08 ms / 550.66 ms Mémoire: 0.056 MB / 14.45 MB Application: afterRenderModule mod_menu (Menu)
Temps: 0.16 ms / 550.82 ms Mémoire: -0.017 MB / 14.43 MB Application: beforeRenderModule mod_iccalendar (Dates à retenir)
Temps: 16.34 ms / 567.16 ms Mémoire: 0.698 MB / 15.13 MB Application: afterRenderModule mod_iccalendar (Dates à retenir)
Temps: 0.04 ms / 567.20 ms Mémoire: -0.047 MB / 15.08 MB Application: beforeRenderModule mod_iccalendar (Location Salle des fêtes)
Temps: 10.50 ms / 577.70 ms Mémoire: 0.108 MB / 15.19 MB Application: afterRenderModule mod_iccalendar (Location Salle des fêtes)
Temps: 11.20 ms / 588.89 ms Mémoire: 0.352 MB / 15.54 MB Application: afterRender
Total de requêtes base de données : 21.53 ms
16,00 MB (16 782 376 Bytes)
31 requêtes exécutées 21.53 ms
6 doubles découverts!
- Temps de requête : 0.31 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.160 MB Rangées retournées : 0
SELECT `data`
FROM `wjf2o_session`
WHERE `session_id` = X'6665323164643264646437653033333230633837636131373365393939306238'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.03 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 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.23 ms Après la dernière requête : 1.01 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.256 MB Rangées retournées : 0
SELECT `session_id`
FROM `wjf2o_session`
WHERE `session_id` = X'6665323164643264646437653033333230633837636131373365393939306238'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 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 : 3.35 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.004 MB mémoire avant requête : 4.261 MB
INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6665323164643264646437653033333230633837636131373365393939306238', 1, 1685245697, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6665323164643264646437653033333230633837636131373365393939306238', 1, 1685245697, 0, '', 0)Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.01 ms Update 0.06 ms Waiting for query cache lock 0.01 ms Update 0.00 ms End of update loop 0.01 ms Query end 0.00 ms Commit 3.12 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 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:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 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.45 ms Après la dernière requête : 3.07 ms Mémoire de requête : 0.040 MB mémoire avant requête : 4.610 MB Rangées retournées : 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `wjf2o_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_extensions ref extension extension 82 const 43 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.20 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.22 ms Après la dernière requête : 3.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.815 MB Rangées retournées : 5
SELECT id, rules
FROM `wjf2o_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_viewlevels ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 5 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.27 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.827 MB Rangées retournées : 1
SELECT b.id
FROM wjf2o_usergroups AS a
LEFT JOIN wjf2o_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 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:318 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:225 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.67 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.899 MB Rangées retournées : 106
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM wjf2o_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_extensions ALL extension INDEX N'A PU ÊTRE UTILISÉ NULL NULL 289 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.46 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 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:351 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:356 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.44 ms Après la dernière requête : 28.25 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.764 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `wjf2o_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 20 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 19 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Même appel que celui de la ligne ci-dessous. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 16 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 15 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 14 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/helix/core/helix.php:50 10 Helix::getDocument() JROOT/plugins/system/helix/core/helix.php:36 9 Helix::getInstance() JROOT/plugins/system/helix/helix.php:21 8 plgSystemHelix->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.81 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.007 MB mémoire avant requête : 7.758 MB
UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"5ca76e59eaf5061c1cc214bd8a6b9cb9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `wjf2o_extensions` SET `params` = '{\"mediaversion\":\"5ca76e59eaf5061c1cc214bd8a6b9cb9\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.05 ms Updating 0.05 ms End of update loop 0.01 ms Waiting for query cache lock 0.00 ms End of update loop 0.01 ms Query end 0.00 ms Commit 1.51 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 15 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 14 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/helix/core/helix.php:50 10 Helix::getDocument() JROOT/plugins/system/helix/core/helix.php:36 9 Helix::getInstance() JROOT/plugins/system/helix/helix.php:21 8 plgSystemHelix->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.98 ms Après la dernière requête : 2.39 ms Mémoire de requête : 0.074 MB mémoire avant requête : 8.066 MB Rangées retournées : 53
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 wjf2o_menu AS m
LEFT JOIN wjf2o_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 type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 56 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 thevenin_commune10.m.component_id 1 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.55 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 23 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() 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/Menu/SiteMenu.php:101 20 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 19 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 18 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 17 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 16 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 15 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:434 14 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/helix/core/helix.php:65 13 Helix::themeName() JROOT/plugins/system/helix/core/helix.php:114 12 Helix::themePath() JROOT/plugins/system/helix/core/helix.php:302 11 Helix::_Import() JROOT/plugins/system/helix/core/helix.php:290 10 Helix::Import() JROOT/plugins/system/helix/core/helix.php:1592 9 Helix::loadHelixOverwrite() JROOT/plugins/system/helix/helix.php:22 8 plgSystemHelix->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.39 ms Après la dernière requête : 4.48 ms Mémoire de requête : 0.038 MB mémoire avant requête : 8.262 MB Rangées retournées : 3
SELECT id, home, template, s.params
FROM wjf2o_template_styles as s
LEFT JOIN wjf2o_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 type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 3 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 thevenin_commune10.s.template,const 1 Using index condition; Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.09 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 14 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/helix/core/helix.php:65 13 Helix::themeName() JROOT/plugins/system/helix/core/helix.php:114 12 Helix::themePath() JROOT/plugins/system/helix/core/helix.php:302 11 Helix::_Import() JROOT/plugins/system/helix/core/helix.php:290 10 Helix::Import() JROOT/plugins/system/helix/core/helix.php:1592 9 Helix::loadHelixOverwrite() JROOT/plugins/system/helix/helix.php:22 8 plgSystemHelix->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.36 ms Après la dernière requête : 90.21 ms Mémoire de requête : 0.020 MB mémoire avant requête : 9.757 MB Rangées retournées : 2
SELECT *
FROM wjf2o_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_languages ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.94 ms Après la dernière requête : 6.42 ms Mémoire de requête : 0.022 MB mémoire avant requête : 10.439 MB Rangées retournées : 1
SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parentid, pc.alias as parentalias
FROM wjf2o_phocadownload_categories AS cc
LEFT JOIN wjf2o_phocadownload_categories AS pc
ON pc.id = cc.parent_id
WHERE cc.id= 1
AND cc.access IN (1,1)
AND cc.published = 1
ORDER BY cc.ordering
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE pc const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.49 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.04 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 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/MVC/Model/BaseDatabaseModel.php:322 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/components/com_phocadownload/models/category.php:88 11 PhocaDownloadModelCategory->getCategory() JROOT/components/com_phocadownload/views/category/view.html.php:41 10 PhocaDownloadViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocadownload/controller.php:34 8 PhocaDownloadController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocadownload/phocadownload.php:56 6 require_once JROOT/components/com_phocadownload/phocadownload.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.00 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.022 MB mémoire avant requête : 10.476 MB Rangées retournées : 0
SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc
FROM wjf2o_phocadownload_categories AS cc
LEFT JOIN wjf2o_phocadownload AS c
ON c.catid = cc.id
AND c.published = 1
AND c.textonly = 0
WHERE cc.parent_id = 1
AND cc.access IN (1,1)
AND cc.published = 1
GROUP BY cc.id, cc.title, cc.alias, cc.access, cc.accessuserid
ORDER BY cc.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc ALL idx_access INDEX N'A PU ÊTRE UTILISÉ NULL NULL 23 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE c ref catid catid 5 thevenin_commune10.cc.id,const 2 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.28 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.06 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.18 ms Creating sort index 0.02 ms Removing tmp table 0.04 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 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/MVC/Model/BaseDatabaseModel.php:322 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/components/com_phocadownload/models/category.php:96 11 PhocaDownloadModelCategory->getSubcategories() JROOT/components/com_phocadownload/views/category/view.html.php:42 10 PhocaDownloadViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocadownload/controller.php:34 8 PhocaDownloadController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocadownload/phocadownload.php:56 6 require_once JROOT/components/com_phocadownload/phocadownload.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.37 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.047 MB mémoire avant requête : 10.485 MB Rangées retournées : 8
SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid
FROM wjf2o_phocadownload AS c
LEFT JOIN wjf2o_phocadownload_categories AS cc
ON cc.id = c.catid
LEFT JOIN wjf2o_phocadownload_file_votes_statistics AS r
ON r.fileid = c.id
WHERE c.catid= 1
AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0
AND c.access IN (1,1) ) )
AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0
AND cc.access IN (1,1) ) )
AND c.published = 1
AND c.approved = 1
AND cc.published = 1
AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-05-28 03:48:18' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-05-28 03:48:18' )
ORDER BY c.ordering ASC
LIMIT 0, 20id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc const PRIMARY,idx_access PRIMARY 4 const 1 Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE c ref catid catid 5 const,const 8 Using where 1 SIMPLE r ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.19 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Creating tmp table 0.09 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.39 ms Creating sort index 0.10 ms Removing tmp table 0.05 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 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/MVC/Model/BaseDatabaseModel.php:322 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/components/com_phocadownload/models/category.php:80 11 PhocaDownloadModelCategory->getFileList() JROOT/components/com_phocadownload/views/category/view.html.php:43 10 PhocaDownloadViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocadownload/controller.php:34 8 PhocaDownloadController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocadownload/phocadownload.php:56 6 require_once JROOT/components/com_phocadownload/phocadownload.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.46 ms Après la dernière requête : 1.01 ms Mémoire de requête : 0.022 MB mémoire avant requête : 10.613 MB Rangées retournées : 8
SELECT c.id
FROM wjf2o_phocadownload AS c
LEFT JOIN wjf2o_phocadownload_categories AS cc
ON cc.id = c.catid
WHERE c.catid= 1
AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0
AND c.access IN (1,1) ) )
AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0
AND cc.access IN (1,1) ) )
AND c.published = 1
AND c.approved = 1
AND cc.published = 1
AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-05-28 03:48:18' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-05-28 03:48:18' )
ORDER BY c.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE c ref catid catid 5 const,const 8 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/components/com_phocadownload/models/category.php:72 12 PhocaDownloadModelCategory->getTotal() JROOT/components/com_phocadownload/models/category.php:64 11 PhocaDownloadModelCategory->getPagination() JROOT/components/com_phocadownload/views/category/view.html.php:44 10 PhocaDownloadViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocadownload/controller.php:34 8 PhocaDownloadController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocadownload/phocadownload.php:56 6 require_once JROOT/components/com_phocadownload/phocadownload.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:225 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.63 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.672 MB Rangées retournées : 3
SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM wjf2o_phocadownload_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 6 Using where; Utilisation du tri complet de type filesort Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.21 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_phocadownload/libraries/phocadownload/render/renderfront.php:22 11 PhocaDownloadRenderFront::renderAllCSS() JROOT/components/com_phocadownload/views/category/view.html.php:46 10 PhocaDownloadViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocadownload/controller.php:34 8 PhocaDownloadController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocadownload/phocadownload.php:56 6 require_once JROOT/components/com_phocadownload/phocadownload.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.58 ms Après la dernière requête : 13.87 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.638 MB Rangées retournées : 8
SHOW FULL COLUMNS
FROM `wjf2o_template_styles`EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `wjf2o_template_styles`Status Duration Starting 0.03 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.16 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.05 ms closing tables 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.06 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 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/joomla/database/driver/mysqli.php:448 12 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 11 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 10 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_templates/tables/style.php:30 9 TemplatesTableStyle->__construct() JROOT/libraries/src/Table/Table.php:328 8 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/helix/helix.php:83 7 plgSystemHelix->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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.31 ms Après la dernière requête : 0.48 ms Mémoire de requête : 0.021 MB mémoire avant requête : 11.671 MB Rangées retournées : 1
SELECT *
FROM wjf2o_template_styles
WHERE `id` = '18'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_template_styles const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 9 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 8 Joomla\CMS\Table\Table->load() JROOT/plugins/system/helix/helix.php:84 7 plgSystemHelix->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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.10 ms Après la dernière requête : 12.08 ms Mémoire de requête : 0.042 MB mémoire avant requête : 12.835 MB Rangées retournées : 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM wjf2o_modules AS m
LEFT JOIN wjf2o_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN wjf2o_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-05-28 03:48:18')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-28 03:48:18')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 267 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds INDEX N'A PU ÊTRE UTILISÉ NULL NULL 90 Using where; Utilisation du tri complet de type filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 thevenin_commune10.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 thevenin_commune10.m.module,const 1 Using index condition; Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.13 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.53 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() Même appel que celui de la ligne ci-dessous. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/helix/core/helix.php:735 11 Helix::countModules() JROOT/plugins/system/helix/core/helix.php:351 10 Helix::showRow() JROOT/plugins/system/helix/core/helix.php:448 9 Helix::generatelayout() JROOT/plugins/system/helix/core/helix.php:713 8 Helix::layout() JROOT/templates/shaper_xeon/index.php:49 7 require JROOT/templates/shaper_xeon/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.22 ms Après la dernière requête : 4.41 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.605 MB Rangées retournées : 0
SELECT *
FROM `wjf2o_hobosm_license_active`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_hobosm_license_active system NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 Const row not found Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/modules/mod_hobosm/helper.php:99 11 ModHobOsmHelper::getLicense() JROOT/modules/mod_hobosm/mod_hobosm.php:23 10 include JROOT/modules/mod_hobosm/mod_hobosm.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.40 ms Après la dernière requête : 236.19 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.613 MB Rangées retournées : 1
SELECT h.greeting, h.params, h.image as image, c.title as category, h.latitude as latitude, h.longitude as longitude, h.zoom as zoom, h.scale as scale, h.width as width, h.position_horizontal as position_horizontal, h.position_vertical as position_vertical
FROM wjf2o_hobosm as h
LEFT JOIN wjf2o_categories as c
ON h.catid=c.id
WHERE h.id=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE h system PRIMARY INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/modules/mod_hobosm/helper.php:115 11 ModHobOsmHelper::getData() JROOT/modules/mod_hobosm/mod_hobosm.php:28 10 include JROOT/modules/mod_hobosm/mod_hobosm.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.07 ms Après la dernière requête : 7.89 ms Mémoire de requête : 0.027 MB mémoire avant requête : 14.337 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 wjf2o_fields AS a
LEFT JOIN `wjf2o_languages` AS l
ON l.lang_code = a.language
LEFT JOIN wjf2o_users AS uc
ON uc.id=a.checked_out
LEFT JOIN wjf2o_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN wjf2o_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN wjf2o_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 thevenin_commune10.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.group_id 1 Using where Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.09 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.26 ms Creating sort index 0.03 ms Removing tmp table 0.07 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.03 ms # Appel Fichier et numéro de ligne 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 24 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 23 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 22 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 21 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 20 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 19 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 18 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 17 JHtmlContent::prepare() Même appel que celui de la ligne ci-dessous. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 13 include JROOT/modules/mod_custom/mod_custom.php JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190 12 JModuleHelper::renderModule() Même appel que celui de la ligne ci-dessous. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:606 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.46 ms Après la dernière requête : 90.62 ms Mémoire de requête : 0.023 MB mémoire avant requête : 14.712 MB Rangées retournées : 31Requêtes dupliquées: #28
SELECT id AS nbevt
FROM `wjf2o_icagenda_events` AS e
WHERE e.state = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref idx_state idx_state 1 const 31 Using index Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/modules/mod_iccalendar/helper.php:132 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.42 ms Après la dernière requête : 0.50 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.764 MB Rangées retournées : 1Requêtes dupliquées: #29
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `wjf2o_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_menu ALL idx_client_id_parent_id_alias_language INDEX N'A PU ÊTRE UTILISÉ NULL NULL 123 Using where Status Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.14 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 12 iCutilities\Menus\Menus::iClistMenuItemsInfo() JROOT/modules/mod_iccalendar/helper.php:167 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 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.27 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.780 MB Rangées retournées : 0
SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as cat_alias, c.color as cat_color, c.ordering as cat_order ,feat.count AS features,r.count AS reg_people, r.date AS reg_date
FROM `wjf2o_icagenda_events` AS e
LEFT JOIN `wjf2o_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM `wjf2o_icagenda_feature_xref` AS fx
INNER JOIN `wjf2o_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN ( SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `wjf2o_icagenda_registration` AS r
WHERE r.state > 0
GROUP BY r.eventid) AS r
ON e.id=r.eventid
WHERE c.state = 1
AND e.state = 1
AND e.approval = 0
AND ((`e`.`next` >= '2023-05-01') OR (`e`.`startdate` <= '2023-05-01'
AND `e`.`enddate` >= '2023-05-01'
AND `e`.`weekdays` = ""))
AND e.catid IN (5, 6, 7)
AND e.access IN (1, 1)
AND e.language IN ('fr-FR','*')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c ALL PRIMARY,idx_state INDEX N'A PU ÊTRE UTILISÉ NULL NULL 7 Using where 1 PRIMARY e ref idx_state,idx_approval,idx_language,idx_catid idx_catid 4 thevenin_commune10.c.id 3 Using index condition; Using where 1 PRIMARY <derived2> ref key0 key0 5 thevenin_commune10.e.id 2 Using where 1 PRIMARY <derived3> ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 Using where; Using join buffer (flat, BNL join) 3 DERIVED r range idx_state,idx_eventid idx_state 1 NULL 1 Using index condition; Using temporary; Utilisation du tri complet de type filesort 2 DERIVED fx ALL idx_event_id,idx_feature_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 Using temporary; Utilisation du tri complet de type filesort 2 DERIVED f eq_ref PRIMARY,idx_state PRIMARY 4 thevenin_commune10.fx.feature_id 1 Using where Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.18 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.12 ms Optimizing 0.03 ms Optimizing 0.01 ms Statistics 0.03 ms Optimizing 0.01 ms Statistics 0.02 ms Statistics 0.09 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Preparing 0.01 ms Creating tmp table 0.01 ms Sorting result 0.01 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.14 ms Removing tmp table 0.01 ms Sending data 0.00 ms Removing tmp table 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.03 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_iccalendar/helper.php:285 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.28 ms Après la dernière requête : 1.41 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.958 MB Rangées retournées : 0Requêtes dupliquées: #31
SELECT r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS people
FROM wjf2o_icagenda_registration AS r
WHERE r.status = 1
AND r.state = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ref idx_state,idx_status idx_state 1 const 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Events/EventsData.php:1582 12 iCutilities\Events\EventsData::registeredList() JROOT/modules/mod_iccalendar/helper.php:287 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.29 ms Après la dernière requête : 9.74 ms Mémoire de requête : 0.023 MB mémoire avant requête : 15.136 MB Rangées retournées : 31Requêtes dupliquées: #24
SELECT id AS nbevt
FROM `wjf2o_icagenda_events` AS e
WHERE e.state = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref idx_state idx_state 1 const 31 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/modules/mod_iccalendar/helper.php:132 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.36 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.022 MB mémoire avant requête : 15.145 MB Rangées retournées : 1Requêtes dupliquées: #25
SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `wjf2o_menu`
WHERE `link` = 'index.php?option=com_icagenda&view=list'
AND `published` > 0
AND `client_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_menu ALL idx_client_id_parent_id_alias_language INDEX N'A PU ÊTRE UTILISÉ NULL NULL 123 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.13 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Menus/Menus.php:75 12 iCutilities\Menus\Menus::iClistMenuItemsInfo() JROOT/modules/mod_iccalendar/helper.php:167 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 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.20 ms Mémoire de requête : 0.022 MB mémoire avant requête : 15.158 MB Rangées retournées : 0
SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as cat_alias, c.color as cat_color, c.ordering as cat_order ,feat.count AS features,r.count AS reg_people, r.date AS reg_date
FROM `wjf2o_icagenda_events` AS e
LEFT JOIN `wjf2o_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM `wjf2o_icagenda_feature_xref` AS fx
INNER JOIN `wjf2o_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN ( SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `wjf2o_icagenda_registration` AS r
WHERE r.state > 0
GROUP BY r.eventid) AS r
ON e.id=r.eventid
WHERE c.state = 1
AND e.state = 1
AND e.approval = 0
AND ((`e`.`next` >= '2023-05-01') OR (`e`.`startdate` <= '2023-05-01'
AND `e`.`enddate` >= '2023-05-01'
AND `e`.`weekdays` = ""))
AND e.catid IN (4)
AND e.access IN (1, 1)
AND e.language IN ('fr-FR','*')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c const PRIMARY,idx_state PRIMARY 4 const 1 1 PRIMARY e ref idx_state,idx_approval,idx_language,idx_catid idx_catid 4 const 3 Using where 1 PRIMARY <derived2> ref key0 key0 5 thevenin_commune10.e.id 2 Using where 1 PRIMARY <derived3> ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 Using where; Using join buffer (flat, BNL join) 3 DERIVED r range idx_state,idx_eventid idx_state 1 NULL 1 Using index condition; Using temporary; Utilisation du tri complet de type filesort 2 DERIVED fx ALL idx_event_id,idx_feature_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 Using temporary; Utilisation du tri complet de type filesort 2 DERIVED f eq_ref PRIMARY,idx_state PRIMARY 4 thevenin_commune10.fx.feature_id 1 Using where Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.03 ms Optimizing 0.01 ms Statistics 0.03 ms Optimizing 0.01 ms Statistics 0.02 ms Statistics 0.08 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Preparing 0.01 ms Creating tmp table 0.01 ms Sorting result 0.01 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms Removing tmp table 0.01 ms Sending data 0.00 ms Removing tmp table 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_iccalendar/helper.php:285 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.23 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 15.167 MB Rangées retournées : 0Requêtes dupliquées: #27
SELECT r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS people
FROM wjf2o_icagenda_registration AS r
WHERE r.status = 1
AND r.state = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ref idx_state,idx_status idx_state 1 const 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.02 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/src/Utilities/Events/EventsData.php:1582 12 iCutilities\Events\EventsData::registeredList() JROOT/modules/mod_iccalendar/helper.php:287 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:149 10 include JROOT/modules/mod_iccalendar/mod_iccalendar.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
26 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
2 × SELECT r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS people
FROM wjf2o_icagenda_registration AS r2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `wjf2o_extensions`2 × SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as cat_alias, c.color as cat_color, c.ordering as cat_order ,feat.count AS features,r.count AS reg_people, r.date AS reg_date
FROM `wjf2o_icagenda_events` AS e
LEFT JOIN `wjf2o_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM `wjf2o_icagenda_feature_xref` AS fx
INNER JOIN `wjf2o_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN ( SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `wjf2o_icagenda_registration` AS r2 × SELECT `id`,`title`,`link`,`published`,`client_id`,`params`,`language`
FROM `wjf2o_menu`2 × SELECT id AS nbevt
FROM `wjf2o_icagenda_events` AS e1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM wjf2o_phocadownload_styles AS a1 × 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 wjf2o_fields AS a
LEFT JOIN `wjf2o_languages` AS l
ON l.lang_code = a.language
LEFT JOIN wjf2o_users AS uc
ON uc.id=a.checked_out
LEFT JOIN wjf2o_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN wjf2o_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN wjf2o_fields_groups AS g
ON g.id = a.group_id1 × SELECT h.greeting, h.params, h.image as image, c.title as category, h.latitude as latitude, h.longitude as longitude, h.zoom as zoom, h.scale as scale, h.width as width, h.position_horizontal as position_horizontal, h.position_vertical as position_vertical
FROM wjf2o_hobosm as h
LEFT JOIN wjf2o_categories as c
ON h.catid=c.id1 × SELECT *
FROM `wjf2o_hobosm_license_active1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM wjf2o_modules AS m
LEFT JOIN wjf2o_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN wjf2o_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM wjf2o_template_styles1 × SELECT `data`
FROM `wjf2o_session`1 × SELECT c.id
FROM wjf2o_phocadownload AS c
LEFT JOIN wjf2o_phocadownload_categories AS cc
ON cc.id = c.catid1 × SELECT `session_id`
FROM `wjf2o_session`1 × SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc
FROM wjf2o_phocadownload_categories AS cc
LEFT JOIN wjf2o_phocadownload AS c
ON c.catid = cc.id
AND c.published = 1
AND c.textonly = 01 × SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parentid, pc.alias as parentalias
FROM wjf2o_phocadownload_categories AS cc
LEFT JOIN wjf2o_phocadownload_categories AS pc
ON pc.id = cc.parent_id1 × SELECT *
FROM wjf2o_languages1 × SELECT id, home, template, s.params
FROM wjf2o_template_styles as s
LEFT JOIN wjf2o_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 wjf2o_menu AS m
LEFT JOIN wjf2o_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 wjf2o_extensions1 × SELECT b.id
FROM wjf2o_usergroups AS a
LEFT JOIN wjf2o_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `wjf2o_viewlevels1 × SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid
FROM wjf2o_phocadownload AS c
LEFT JOIN wjf2o_phocadownload_categories AS cc
ON cc.id = c.catid
LEFT JOIN wjf2o_phocadownload_file_votes_statistics AS r
ON r.fileid = c.id
Autres tables :
1 × INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6665323164643264646437653033333230633837636131373365393939306238', 1, 1685245697, 0, '', 01 × UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"5ca76e59eaf5061c1cc214bd8a6b9cb9\"}'1 × SHOW FULL COLUMNS
FROM `wjf2o_template_styles