Actualités de la Municipalité
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
Compte rendu du conseil municipal du 8 Janvier 2019
Le compte-rendu de la dernière réunion du conseil municipal est disponible ci-dessous.
Compte rendu du conseil municipal du 26 novembre 2018
Le compte-rendu de la dernière réunion du conseil municipal est disponible ci-dessus.
Compte rendu du conseil municipal du 9 Octobre 2018
Le compte-rendu de la dernière réunion du conseil municipal est disponible ci-dessus.
Récolte de pomme de terre bio
 |
Venez en famille nous aider à récolter les pommes de terre communales !!! Rendez vous dimanche 23 Septembre 2018 à 9 heures Rue de la liberté à Mesnil-Sellières |
"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.
AdresseMairie de MESNIL SELLIERES.
41, Grande rue.
10220 MESNIL SELLIERES.
03 25 80 20 30
41, Grande rue.
10220 MESNIL SELLIERES.
03 25 80 20 30
Ouverture.
Le Lundi de 16h à 18h
Le Samedi de 10h à 12h
Mr le Maire Le Samedi de 10h30 à 12h
Le Lundi de 16h à 18h
Le Samedi de 10h à 12h
Mr le Maire Le Samedi de 10h30 à 12h
Inscrivez-vous à notre "Info Lettre" gratuite pour recevoir nos dernières informations
ABONNEZ-VOUS À LA NEWSLETTER !
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": 1569084170,
"last": 1569084170,
"now": 1569084170
},
"token": "4PbXuKmbn2uDIBfu2e9K12dwDFsYa4x6"
},
"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: 13.57 ms / 13.57 ms Mémoire: 1.788 MB / 2.16 MB Application: afterLoad
Temps: 61.13 ms / 74.70 ms Mémoire: 5.708 MB / 7.87 MB Application: afterInitialise
Temps: 9.09 ms / 83.79 ms Mémoire: 0.818 MB / 8.69 MB Application: afterRoute
Temps: 0.57 ms / 84.37 ms Mémoire: 0.043 MB / 8.73 MB Application: beforeRenderComponent com_phocadownload
Temps: 41.96 ms / 126.33 ms Mémoire: 1.796 MB / 10.53 MB Application: afterRenderComponent com_phocadownload
Temps: 10.91 ms / 137.24 ms Mémoire: 0.848 MB / 11.38 MB Application: afterDispatch
Temps: 30.03 ms / 167.26 ms Mémoire: 0.902 MB / 12.28 MB Application: beforeRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 0.95 ms / 168.22 ms Mémoire: 0.032 MB / 12.31 MB Application: afterRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 0.40 ms / 168.62 ms Mémoire: 0.021 MB / 12.33 MB Application: beforeRenderModule mod_custom (Mentions légales)
Temps: 0.71 ms / 169.33 ms Mémoire: 0.007 MB / 12.34 MB Application: afterRenderModule mod_custom (Mentions légales)
Temps: 0.82 ms / 170.15 ms Mémoire: 0.004 MB / 12.34 MB Application: beforeRenderModule mod_sp_simple_map (SP Simple Map)
Temps: 0.60 ms / 170.75 ms Mémoire: 0.010 MB / 12.35 MB Application: afterRenderModule mod_sp_simple_map (SP Simple Map)
Temps: 0.81 ms / 171.57 ms Mémoire: 0.000 MB / 12.34 MB Application: beforeRenderModule mod_easyquickcontact (Contact)
Temps: 0.86 ms / 172.42 ms Mémoire: 0.021 MB / 12.36 MB Application: afterRenderModule mod_easyquickcontact (Contact)
Temps: 0.28 ms / 172.70 ms Mémoire: 0.025 MB / 12.38 MB Application: beforeRenderModule mod_parallax_scroll (Photo avant contact)
Temps: 1.19 ms / 173.89 ms Mémoire: 0.026 MB / 12.41 MB Application: afterRenderModule mod_parallax_scroll (Photo avant contact)
Temps: 1.28 ms / 175.17 ms Mémoire: 0.000 MB / 12.40 MB Application: beforeRenderModule mod_menu (Menu)
Temps: 2.94 ms / 178.11 ms Mémoire: 0.058 MB / 12.46 MB Application: afterRenderModule mod_menu (Menu)
Temps: 0.29 ms / 178.41 ms Mémoire: 0.000 MB / 12.44 MB Application: beforeRenderModule mod_iccalendar (Dates à retenir)
Temps: 31.44 ms / 209.84 ms Mémoire: 1.436 MB / 13.88 MB Application: afterRenderModule mod_iccalendar (Dates à retenir)
Temps: 0.05 ms / 209.90 ms Mémoire: 0.000 MB / 13.82 MB Application: beforeRenderModule mod_iccalendar (Location Salle des fêtes)
Temps: 17.34 ms / 227.23 ms Mémoire: 0.112 MB / 13.93 MB Application: afterRenderModule mod_iccalendar (Location Salle des fêtes)
Temps: 16.62 ms / 243.85 ms Mémoire: 0.412 MB / 14.35 MB Application: afterRender
Total de requêtes base de données : 22.06 ms
14,80 MB (15 518 000 Bytes)
24 requêtes exécutées 22.06 ms
8 doubles découverts!
- Temps de requête : 0.35 ms Mémoire de requête : 0.007 MB mémoire avant requête : 3.846 MB Rangées retournées : 0
SELECT `data`
FROM `wjf2o_session`
WHERE `session_id` = 'bc725de75375b91048fc23f032cc6ae6'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE wjf2o_session const PRIMARY PRIMARY 194 const 1 100.00 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.01 ms Executing 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Même appel que celui de la ligne ci-dessous. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Temps de requête : 0.27 ms Après la dernière requête : 1.08 ms Mémoire de requête : 0.004 MB mémoire avant requête : 4.005 MB Rangées retournées : 0
SELECT `session_id`
FROM `wjf2o_session`
WHERE `session_id` = 'bc725de75375b91048fc23f032cc6ae6'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE wjf2o_session const PRIMARY PRIMARY 194 const 1 100.00 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.02 ms Preparing 0.01 ms Executing 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 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Temps de requête : 3.33 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.010 MB
INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('bc725de75375b91048fc23f032cc6ae6', 1, 1569084170, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('bc725de75375b91048fc23f032cc6ae6', 1, 1569084170, 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.02 ms Update 0.08 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 3.04 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Temps de requête : 0.36 ms Après la dernière requête : 5.17 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.530 MB Rangées retournées : 5
SELECT id, rules
FROM `wjf2o_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE wjf2o_viewlevels ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 5 100.00 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.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.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:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.36 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.542 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 filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 100.00 Using where; 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.02 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.01 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.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:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 6.66 ms Après la dernière requête : 22.12 ms Mémoire de requête : 0.007 MB mémoire avant requête : 6.883 MB
UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"31eb76dcc66795dc8bea92344e38ee59\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE wjf2o_extensions range element_clientid,element_folder_clientid,extension extension 484 NULL 1 100.00 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 for update 0.09 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 6.24 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:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.49 ms Après la dernière requête : 22.39 ms Mémoire de requête : 0.007 MB mémoire avant requête : 9.367 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 filtered Extra 1 SIMPLE cc const PRIMARY,idx_access PRIMARY 4 const 1 100.00 1 SIMPLE pc const PRIMARY PRIMARY 4 const 0 0.00 Unique row not found Status Duration Starting 0.08 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.07 ms Preparing 0.01 ms Unlocking tables 0.02 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.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:308 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/components/com_phocadownload/models/category.php:86 11 PhocaDownloadModelCategory->getCategory() JROOT/components/com_phocadownload/views/category/view.html.php:40 10 PhocaDownloadViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocadownload/controller.php:34 8 PhocaDownloadController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.68 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.007 MB mémoire avant requête : 9.392 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 filtered Extra 1 SIMPLE cc ALL idx_access INDEX N'A PU ÊTRE UTILISÉ NULL NULL 16 100.00 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE c ref catid catid 5 thevenin_commune10.cc.id,const 1 100.00 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.05 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.16 ms Creating sort index 0.03 ms Removing tmp table 0.04 ms Creating sort index 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:308 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/components/com_phocadownload/models/category.php:94 11 PhocaDownloadModelCategory->getSubcategories() JROOT/components/com_phocadownload/views/category/view.html.php:41 10 PhocaDownloadViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocadownload/controller.php:34 8 PhocaDownloadController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.10 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.007 MB mémoire avant requête : 9.402 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 <= '2019-09-21 16:42:50' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2019-09-21 16:42:50' )
ORDER BY c.ordering ASC
LIMIT 0, 20id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cc const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE c ref catid catid 5 const,const 6 100.00 Using where 1 SIMPLE r ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 100.00 Using where 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.06 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.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.33 ms Creating sort index 0.09 ms Removing tmp table 0.06 ms Creating sort index 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.02 ms Starting cleanup 0.01 ms Freeing items 0.02 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:308 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/components/com_phocadownload/models/category.php:78 11 PhocaDownloadModelCategory->getFileList() JROOT/components/com_phocadownload/views/category/view.html.php:42 10 PhocaDownloadViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocadownload/controller.php:34 8 PhocaDownloadController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.52 ms Après la dernière requête : 1.03 ms Mémoire de requête : 0.007 MB mémoire avant requête : 9.543 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 <= '2019-09-21 16:42:50' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2019-09-21 16:42:50' )
ORDER BY c.idid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE cc const PRIMARY,idx_access PRIMARY 4 const 1 100.00 1 SIMPLE c ref catid catid 5 const,const 6 100.00 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.01 ms Preparing 0.03 ms Sorting result 0.01 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.01 ms Closing tables 0.02 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/src/MVC/Model/BaseDatabaseModel.php:353 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/components/com_phocadownload/models/category.php:70 12 PhocaDownloadModelCategory->getTotal() JROOT/components/com_phocadownload/models/category.php:62 11 PhocaDownloadModelCategory->getPagination() JROOT/components/com_phocadownload/views/category/view.html.php:43 10 PhocaDownloadViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocadownload/controller.php:34 8 PhocaDownloadController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.35 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.006 MB mémoire avant requête : 9.577 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 filtered Extra 1 SIMPLE a ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 6 100.00 Using where; Utilisation du tri complet de type filesort 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.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.05 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:45 10 PhocaDownloadViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocadownload/controller.php:34 8 PhocaDownloadController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.62 ms Après la dernière requête : 31.69 ms Mémoire de requête : 0.006 MB mémoire avant requête : 10.547 MB Rangées retournées : 6
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.14 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.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.03 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.05 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/joomla/database/driver/mysqli.php:445 12 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 11 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 10 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_templates/tables/style.php:30 9 TemplatesTableStyle->__construct() JROOT/libraries/src/Table/Table.php:312 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.32 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.005 MB mémoire avant requête : 10.580 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 filtered Extra 1 SIMPLE wjf2o_template_styles const PRIMARY PRIMARY 4 const 1 100.00 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.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:731 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.27 ms Après la dernière requête : 21.48 ms Mémoire de requête : 0.009 MB mémoire avant requête : 12.235 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 <= '2019-09-21 16:42:50')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-09-21 16:42:50')
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 filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 56 100.00 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 thevenin_commune10.m.id 1 100.00 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 thevenin_commune10.m.module,const 1 100.00 Using index condition; Using where Status Duration Starting 0.10 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.04 ms Optimizing 0.04 ms Statistics 0.07 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.66 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 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:432 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 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:581 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:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.53 ms Après la dernière requête : 34.68 ms Mémoire de requête : 0.006 MB mémoire avant requête : 13.491 MB Rangées retournées : 0Requêtes dupliquées: #20
SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate, weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
FROM wjf2o_icagenda_events AS e
WHERE e.state = 1
AND e.next < '2019-09-21 18:42:50'
AND e.next > (DATE(NOW() - INTERVAL 2 MONTH))id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e ref idx_state idx_state 1 const 15 100.00 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.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.15 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:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/utilities/events/data.php:1167 11 icagendaEventsData::getNext() JROOT/modules/mod_iccalendar/mod_iccalendar.php:131 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.47 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.006 MB mémoire avant requête : 13.504 MB Rangées retournées : 16Requê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 filtered Extra 1 SIMPLE e ref idx_state idx_state 1 const 15 100.00 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.03 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.14 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.03 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:119 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:175 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.52 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.007 MB mémoire avant requête : 13.550 MB Rangées retournées : 1Requêtes dupliquées: #22
SELECT m.title, m.published, m.id, m.params, m.language
FROM wjf2o_menu AS m
WHERE (m.link = 'index.php?option=com_icagenda&view=list')
AND (m.published = 1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 110 100.00 Using where 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.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.17 ms End of update loop 0.03 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/administrator/components/com_icagenda/utilities/menus/menus.php:56 12 icagendaMenus::iClistMenuItemsInfo() JROOT/modules/mod_iccalendar/helper.php:154 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:175 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.20 ms Après la dernière requête : 0.39 ms Mémoire de requête : 0.006 MB mémoire avant requête : 13.571 MB Rangées retournées : 1
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 >= '2019-09-01'
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 filtered Extra 1 PRIMARY <derived2> system NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 0.00 Const row not found 1 PRIMARY <derived3> system NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 0.00 Const row not found 1 PRIMARY e ref idx_state,idx_approval,idx_language,idx_catid idx_state 1 const 15 100.00 Using where 1 PRIMARY c eq_ref PRIMARY,idx_state PRIMARY 4 thevenin_commune10.e.catid 1 100.00 Using index condition; Using where 3 DERIVED NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL no matching row in const table 2 DERIVED NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL no matching row in const table 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.11 ms Optimizing 0.03 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.10 ms Executing 0.01 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.18 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 Removing tmp table 0.01 ms Closing tables 0.02 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:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_iccalendar/helper.php:272 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:175 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.23 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.007 MB mémoire avant requête : 13.586 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.state = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL Impossible WHERE noticed after reading const tables 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.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.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/utilities/events/data.php:1562 12 icagendaEventsData::registeredList() JROOT/modules/mod_iccalendar/helper.php:274 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:175 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.51 ms Après la dernière requête : 21.24 ms Mémoire de requête : 0.006 MB mémoire avant requête : 13.882 MB Rangées retournées : 0Requêtes dupliquées: #15
SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate, weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
FROM wjf2o_icagenda_events AS e
WHERE e.state = 1
AND e.next < '2019-09-21 18:42:50'
AND e.next > (DATE(NOW() - INTERVAL 2 MONTH))id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e ref idx_state idx_state 1 const 15 100.00 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.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.17 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:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/utilities/events/data.php:1167 11 icagendaEventsData::getNext() JROOT/modules/mod_iccalendar/mod_iccalendar.php:131 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.36 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.006 MB mémoire avant requête : 13.887 MB Rangées retournées : 16Requêtes dupliquées: #16
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 filtered Extra 1 SIMPLE e ref idx_state idx_state 1 const 15 100.00 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.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.13 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:119 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:175 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.44 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.007 MB mémoire avant requête : 13.896 MB Rangées retournées : 1Requêtes dupliquées: #17
SELECT m.title, m.published, m.id, m.params, m.language
FROM wjf2o_menu AS m
WHERE (m.link = 'index.php?option=com_icagenda&view=list')
AND (m.published = 1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 110 100.00 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.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.19 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/utilities/menus/menus.php:56 12 icagendaMenus::iClistMenuItemsInfo() JROOT/modules/mod_iccalendar/helper.php:154 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:175 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.87 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.006 MB mémoire avant requête : 13.910 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 >= '2019-09-01'
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 filtered Extra 1 PRIMARY <derived2> system NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 0.00 Const row not found 1 PRIMARY <derived3> system NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 0 0.00 Const row not found 1 PRIMARY c const PRIMARY,idx_state PRIMARY 4 const 1 100.00 1 PRIMARY e ref idx_state,idx_approval,idx_language,idx_catid idx_catid 4 const 2 100.00 Using where 3 DERIVED NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL no matching row in const table 2 DERIVED NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL no matching row in const table 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.09 ms Optimizing 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.10 ms Executing 0.01 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.08 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.04 ms Closing tables 0.01 ms Removing tmp table 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:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_iccalendar/helper.php:272 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:175 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.23 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.007 MB mémoire avant requête : 13.918 MB Rangées retournées : 0Requêtes dupliquées: #19
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.state = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL NULL Impossible WHERE noticed after reading const tables 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.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.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/utilities/events/data.php:1562 12 icagendaEventsData::registeredList() JROOT/modules/mod_iccalendar/helper.php:274 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:175 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
19 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
2 × SELECT id AS nbevt
FROM `wjf2o_icagenda_events` AS e2 × SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate, weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
FROM wjf2o_icagenda_events AS e2 × SELECT m.title, m.published, m.id, m.params, m.language
FROM wjf2o_menu AS m2 × 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 r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS people
FROM wjf2o_icagenda_registration AS r1 × SELECT `data`
FROM `wjf2o_session`1 × SELECT `session_id`
FROM `wjf2o_session`1 × SELECT id, rules
FROM `wjf2o_viewlevels1 × 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 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 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 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 c.id
FROM wjf2o_phocadownload AS c
LEFT JOIN wjf2o_phocadownload_categories AS cc
ON cc.id = c.catid1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM wjf2o_phocadownload_styles AS a1 × SELECT *
FROM wjf2o_template_styles1 × 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
Autres tables :
1 × INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('bc725de75375b91048fc23f032cc6ae6', 1, 1569084170, 0, '', 01 × UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"31eb76dcc66795dc8bea92344e38ee59\"}'1 × SHOW FULL COLUMNS
FROM `wjf2o_template_styles