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": 1701827720,
"last": 1701827720,
"now": 1701827720
},
"token": "OH1csyTVLujd41vgat3MSbZLKQDmvZ7e"
},
"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: 15.11 ms / 15.11 ms Mémoire: 2.003 MB / 2.39 MB Application: afterLoad
Temps: 112.83 ms / 127.95 ms Mémoire: 6.543 MB / 8.93 MB Application: afterInitialise
Temps: 9.61 ms / 137.56 ms Mémoire: 0.815 MB / 9.75 MB Application: afterRoute
Temps: 0.57 ms / 138.14 ms Mémoire: 0.044 MB / 9.79 MB Application: beforeRenderComponent com_phocadownload
Temps: 24.17 ms / 162.31 ms Mémoire: 1.828 MB / 11.62 MB Application: afterRenderComponent com_phocadownload
Temps: 5.43 ms / 167.74 ms Mémoire: 0.434 MB / 12.05 MB Application: afterDispatch
Temps: 11.60 ms / 179.34 ms Mémoire: 0.861 MB / 12.91 MB Application: beforeRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 1.00 ms / 180.34 ms Mémoire: 0.657 MB / 13.57 MB Application: afterRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 0.24 ms / 180.58 ms Mémoire: 0.021 MB / 13.59 MB Application: beforeRenderModule mod_custom (Mentions légales)
Temps: 0.60 ms / 181.18 ms Mémoire: 0.006 MB / 13.60 MB Application: afterRenderModule mod_custom (Mentions légales)
Temps: 0.21 ms / 181.39 ms Mémoire: -0.020 MB / 13.58 MB Application: beforeRenderModule mod_hobosm (Map Module)
Temps: 223.83 ms / 405.22 ms Mémoire: 0.042 MB / 13.62 MB Application: afterRenderModule mod_hobosm (Map Module)
Temps: 0.62 ms / 405.84 ms Mémoire: 0.034 MB / 13.65 MB Application: beforeRenderModule mod_parallax_scroll (Photo avant contact)
Temps: 0.96 ms / 406.80 ms Mémoire: 0.028 MB / 13.68 MB Application: afterRenderModule mod_parallax_scroll (Photo avant contact)
Temps: 11.65 ms / 418.44 ms Mémoire: -0.005 MB / 13.68 MB Application: beforeRenderModule mod_menu (Menu)
Temps: 3.98 ms / 422.43 ms Mémoire: 0.057 MB / 13.73 MB Application: afterRenderModule mod_menu (Menu)
Temps: 0.19 ms / 422.62 ms Mémoire: -0.017 MB / 13.71 MB Application: beforeRenderModule mod_iccalendar (Dates à retenir)
Temps: 16.55 ms / 439.17 ms Mémoire: 0.712 MB / 14.43 MB Application: afterRenderModule mod_iccalendar (Dates à retenir)
Temps: 0.06 ms / 439.22 ms Mémoire: -0.047 MB / 14.38 MB Application: beforeRenderModule mod_iccalendar (Location Salle des fêtes)
Temps: 10.89 ms / 450.11 ms Mémoire: 0.108 MB / 14.49 MB Application: afterRenderModule mod_iccalendar (Location Salle des fêtes)
Temps: 9.69 ms / 459.81 ms Mémoire: 0.410 MB / 14.90 MB Application: afterRender
Total de requêtes base de données : 11.58 ms
15,25 MB (15 988 288 Bytes)
24 requêtes exécutées 11.58 ms
6 doubles découverts!
- Temps de requête : 0.34 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'3034396531643236383364336265313466613466613036663264656633306230'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.05 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.02 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.01 ms Commit 0.01 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.02 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.22 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'3034396531643236383364336265313466613466613036663264656633306230'
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.01 ms Commit 0.01 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 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 : 0.31 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'3034396531643236383364336265313466613466613036663264656633306230', 1, 1701827720, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3034396531643236383364336265313466613466613036663264656633306230', 1, 1701827720, 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.10 ms Waiting for query cache lock 0.01 ms Update 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 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 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.34 ms Après la dernière requête : 4.62 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.823 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.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 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.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 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.31 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.836 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.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.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 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.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 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.42 ms Après la dernière requête : 26.90 ms Mémoire de requête : 0.007 MB mémoire avant requête : 7.753 MB
UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"de9d483193708cb809b25bffcf3d2517\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `wjf2o_extensions` SET `params` = '{\"mediaversion\":\"de9d483193708cb809b25bffcf3d2517\"}' WHERE `type` = 'library' AND `element` = 'joomla'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 for update 0.08 ms Updating 0.08 ms End of update loop 0.01 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 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.02 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.47 ms Après la dernière requête : 80.40 ms Mémoire de requête : 0.022 MB mémoire avant requête : 10.458 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.10 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.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 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.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 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 : 0.62 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.495 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.05 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.02 ms Statistics 0.04 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 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.01 ms Commit 0.01 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 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.03 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.047 MB mémoire avant requête : 10.505 MB Rangées retournées : 6
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-12-06 01:55:20' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-12-06 01:55:20' )
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 6 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.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.31 ms Creating sort index 0.09 ms Removing tmp table 0.06 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.01 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 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.07 ms Mémoire de requête : 0.022 MB mémoire avant requête : 10.627 MB Rangées retournées : 6
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-12-06 01:55:20' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-12-06 01:55:20' )
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 6 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.05 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.04 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.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 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.33 ms Après la dernière requête : 0.62 ms Mémoire de requête : 0.022 MB mémoire avant requête : 10.684 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.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.01 ms Sending data 0.01 ms Creating sort index 0.04 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.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 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.69 ms Après la dernière requête : 13.40 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.636 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.04 ms checking permissions 0.01 ms closing tables 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.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.06 ms closing tables 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.06 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 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.33 ms Après la dernière requête : 0.50 ms Mémoire de requête : 0.021 MB mémoire avant requête : 11.669 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.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.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 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.01 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 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.02 ms Après la dernière requête : 12.29 ms Mémoire de requête : 0.042 MB mémoire avant requête : 12.858 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-12-06 01:55:20')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-06 01:55:20')
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.11 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.05 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.48 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.01 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 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.24 ms Après la dernière requête : 4.55 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.628 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.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 Executing 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.01 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 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.42 ms Après la dernière requête : 222.35 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.636 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.07 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.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 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 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 : 0.43 ms Après la dernière requête : 20.75 ms Mémoire de requête : 0.023 MB mémoire avant requête : 14.070 MB Rangées retournées : 31Requêtes dupliquées: #21
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.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.02 ms Executing 0.01 ms Sending data 0.04 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.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 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.45 ms Après la dernière requête : 0.53 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.123 MB Rangées retournées : 1Requêtes dupliquées: #22
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.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.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.12 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.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 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.96 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.138 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-12-01') OR (`e`.`startdate` <= '2023-12-01'
AND `e`.`enddate` >= '2023-12-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.11 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.10 ms Optimizing 0.03 ms Optimizing 0.01 ms Statistics 0.03 ms Optimizing 0.01 ms Statistics 0.02 ms Statistics 0.10 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.15 ms Removing tmp table 0.01 ms Sending data 0.01 ms Removing tmp table 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.00 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.04 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 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.32 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.316 MB Rangées retournées : 0Requêtes dupliquées: #24
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.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.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 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.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.34 ms Après la dernière requête : 10.06 ms Mémoire de requête : 0.023 MB mémoire avant requête : 14.434 MB Rangées retournées : 31Requêtes dupliquées: #17
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.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.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 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.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 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.37 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.443 MB Rangées retournées : 1Requêtes dupliquées: #18
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.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.12 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.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.87 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.457 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-12-01') OR (`e`.`startdate` <= '2023-12-01'
AND `e`.`enddate` >= '2023-12-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.12 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.10 ms Optimizing 0.03 ms Optimizing 0.01 ms Statistics 0.04 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.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms Removing tmp table 0.01 ms Sending data 0.01 ms Removing tmp table 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.00 ms Removing tmp table 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 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.25 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.465 MB Rangées retournées : 0Requêtes dupliquées: #20
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.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 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.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
20 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 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 *
FROM wjf2o_template_styles1 × 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 `data`
FROM `wjf2o_session`1 × SELECT `session_id`
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 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.id1 × 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 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 a.filename as filename, a.type as type, a.menulink as menulink
FROM wjf2o_phocadownload_styles AS a
Autres tables :
1 × INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3034396531643236383364336265313466613466613036663264656633306230', 1, 1701827720, 0, '', 01 × UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"de9d483193708cb809b25bffcf3d2517\"}'1 × SHOW FULL COLUMNS
FROM `wjf2o_template_styles