Actualités de la Municipalité
LE SIEDMTO VOUS INFORME 
NOUVEAU POINTS DE REGROUPEMENT DES ORDURES MÉNAGÈRES 2024
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.
"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": 1725779865,
"last": 1725779865,
"now": 1725779865
},
"token": "iYkmUIunvzqWVMmh0Lm3zeEZQCirk8DI"
},
"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: 8.51 ms / 8.51 ms Mémoire: 0.410 MB / 0.76 MB Application: afterLoad
Temps: 54.23 ms / 62.74 ms Mémoire: 1.619 MB / 2.37 MB Application: afterInitialise
Temps: 7.63 ms / 70.37 ms Mémoire: 0.190 MB / 2.56 MB Application: afterRoute
Temps: 1.12 ms / 71.49 ms Mémoire: 0.042 MB / 2.61 MB Application: beforeRenderComponent com_phocadownload
Temps: 25.78 ms / 97.27 ms Mémoire: 0.366 MB / 2.97 MB Application: afterRenderComponent com_phocadownload
Temps: 5.74 ms / 103.01 ms Mémoire: 0.057 MB / 3.03 MB Application: afterDispatch
Temps: 9.74 ms / 112.75 ms Mémoire: 0.113 MB / 3.14 MB Application: beforeRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 0.54 ms / 113.29 ms Mémoire: 0.007 MB / 3.15 MB Application: afterRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 0.55 ms / 113.84 ms Mémoire: 0.002 MB / 3.15 MB Application: beforeRenderModule mod_hobosm (Map Module)
Temps: 26.97 ms / 140.81 ms Mémoire: 0.021 MB / 3.17 MB Application: afterRenderModule mod_hobosm (Map Module)
Temps: 1.34 ms / 142.15 ms Mémoire: 0.023 MB / 3.20 MB Application: beforeRenderModule mod_iccalendar (Dates à retenir)
Temps: 30.57 ms / 172.71 ms Mémoire: 0.343 MB / 3.54 MB Application: afterRenderModule mod_iccalendar (Dates à retenir)
Temps: 0.12 ms / 172.83 ms Mémoire: -0.072 MB / 3.47 MB Application: beforeRenderModule mod_iccalendar (Location Salle des fêtes)
Temps: 22.29 ms / 195.12 ms Mémoire: 0.164 MB / 3.63 MB Application: afterRenderModule mod_iccalendar (Location Salle des fêtes)
Temps: 16.51 ms / 211.63 ms Mémoire: 0.101 MB / 3.73 MB Application: afterRender
Total de requêtes base de données : 25.98 ms
4,19 MB (4 389 040 Bytes)
30 requêtes exécutées 25.98 ms
6 doubles découverts!
- Temps de requête : 0.58 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.036 MB Rangées retournées : 0
SELECT `data`
FROM `wjf2o_session`
WHERE `session_id` = X'3239616562303530636233326134393830396535323131626638616138356435'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.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 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 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.51 ms Après la dernière requête : 0.71 ms Mémoire de requête : 0.020 MB mémoire avant requête : 1.050 MB Rangées retournées : 0
SELECT `session_id`
FROM `wjf2o_session`
WHERE `session_id` = X'3239616562303530636233326134393830396535323131626638616138356435'
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.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.06 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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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 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.53 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.055 MB
INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3239616562303530636233326134393830396535323131626638616138356435', 1, 1725779865, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3239616562303530636233326134393830396535323131626638616138356435', 1, 1725779865, 0, '', 0)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 for update 0.03 ms Update 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.08 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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 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.55 ms Après la dernière requête : 3.94 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.143 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.05 ms checking permissions 0.01 ms Opening tables 0.04 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.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.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: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.59 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.155 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.06 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.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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: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.73 ms Après la dernière requête : 26.01 ms Mémoire de requête : 0.007 MB mémoire avant requête : 2.000 MB
UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"5d4dddcf997f1921fae87f89be2c0138\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `wjf2o_extensions` SET `params` = '{\"mediaversion\":\"5d4dddcf997f1921fae87f89be2c0138\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init for update 0.11 ms Updating 0.12 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.06 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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 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.85 ms Après la dernière requête : 23.21 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.784 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.12 ms checking permissions 0.02 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.09 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 Query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/components/com_phocadownload/models/category.php:88 11 PhocaDownloadModelCategory->getCategory() JROOT/components/com_phocadownload/views/category/view.html.php:41 10 PhocaDownloadViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocadownload/controller.php:34 8 PhocaDownloadController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocadownload/phocadownload.php:56 6 require_once JROOT/components/com_phocadownload/phocadownload.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.29 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.792 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.11 ms checking permissions 0.01 ms Opening tables 0.04 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.08 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.33 ms Creating sort index 0.05 ms Removing tmp table 0.08 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 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: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 : 2.10 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.046 MB mémoire avant requête : 2.803 MB Rangées retournées : 5
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 <= '2024-09-08 07:17:45' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-09-08 07:17:45' )
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 5 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.17 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.11 ms Optimizing 0.08 ms Statistics 0.13 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.06 ms Creating tmp table 0.14 ms Sorting result 0.04 ms Executing 0.01 ms Sending data 0.60 ms Creating sort index 0.16 ms Removing tmp table 0.10 ms Creating sort index 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.03 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.95 ms Après la dernière requête : 0.67 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.831 MB Rangées retournées : 5
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 <= '2024-09-08 07:17:45' )
AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-09-08 07:17:45' )
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 5 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.06 ms Optimizing 0.08 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 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.64 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.837 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.07 ms checking permissions 0.02 ms Opening tables 0.03 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.02 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.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_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 : 1.19 ms Après la dernière requête : 13.57 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.979 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.06 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.30 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 Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms checking permissions 0.12 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.12 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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: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.63 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.998 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.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.06 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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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 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 : 0.47 ms Après la dernière requête : 14.87 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.175 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.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.02 ms init 0.02 ms Optimizing 0.02 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 closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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.84 ms Après la dernière requête : 24.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.183 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.13 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.03 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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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: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.67 ms Après la dernière requête : 4.42 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.255 MB Rangées retournées : 32Requêtes dupliquées: #22
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 32 Using index Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.04 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.03 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.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:134 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.85 ms Après la dernière requête : 0.43 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.274 MB Rangées retournées : 1Requêtes dupliquées: #23
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.07 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.26 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.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 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:169 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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 : 2.78 ms Après la dernière requête : 0.89 ms Mémoire de requête : 0.039 MB mémoire avant requête : 3.290 MB Rangées retournées : 2
SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as cat_alias, c.color as cat_color, c.ordering as cat_order ,feat.count AS features,r.count AS reg_people, r.date AS reg_date
FROM `wjf2o_icagenda_events` AS e
LEFT JOIN `wjf2o_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM `wjf2o_icagenda_feature_xref` AS fx
INNER JOIN `wjf2o_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN ( SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `wjf2o_icagenda_registration` AS 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` >= '2024-09-01') OR (`e`.`startdate` <= '2024-09-01'
AND `e`.`enddate` >= '2024-09-01'
AND `e`.`weekdays` = ""))
AND e.catid IN (5, 6, 8)
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 2 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.21 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.21 ms Optimizing 0.07 ms Optimizing 0.02 ms Statistics 0.07 ms Optimizing 0.02 ms Statistics 0.03 ms Statistics 0.22 ms Preparing 0.04 ms Creating tmp table 0.04 ms Sorting result 0.02 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Preparing 0.10 ms Executing 0.01 ms Sending data 0.18 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.33 ms Executing 0.01 ms Sending data 0.19 ms Creating sort index 0.05 ms Removing tmp table 0.07 ms Creating sort index 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 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.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 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:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_iccalendar/helper.php:287 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.64 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.309 MB Rangées retournées : 0Requêtes dupliquées: #25
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.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.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.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 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:289 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.60 ms Après la dernière requête : 7.99 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.470 MB Rangées retournées : 1
SELECT e.params
FROM `wjf2o_icagenda_events` AS `e`
WHERE `e`.`id` = 8id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.08 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.03 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.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:621 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.55 ms Après la dernière requête : 4.63 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.523 MB Rangées retournées : 1
SELECT e.params
FROM `wjf2o_icagenda_events` AS `e`
WHERE `e`.`id` = 45id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 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.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:621 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.68 ms Après la dernière requête : 9.05 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.495 MB Rangées retournées : 32Requê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 Extra 1 SIMPLE e ref idx_state idx_state 1 const 32 Using index Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 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:134 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.80 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.503 MB Rangées retournées : 1Requêtes dupliquées: #17
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.06 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.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.25 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.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 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:169 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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 : 2.69 ms Après la dernière requête : 0.48 ms Mémoire de requête : 0.046 MB mémoire avant requête : 3.517 MB Rangées retournées : 5
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` >= '2024-09-01') OR (`e`.`startdate` <= '2024-09-01'
AND `e`.`enddate` >= '2024-09-01'
AND `e`.`weekdays` = ""))
AND e.catid IN (4, 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 2 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.23 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.20 ms Optimizing 0.07 ms Optimizing 0.02 ms Statistics 0.08 ms Optimizing 0.02 ms Statistics 0.03 ms Statistics 0.18 ms Preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.02 ms Preparing 0.09 ms Executing 0.01 ms Sending data 0.17 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.36 ms Executing 0.01 ms Sending data 0.17 ms Creating sort index 0.04 ms Removing tmp table 0.09 ms Creating sort index 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.05 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.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 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:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_iccalendar/helper.php:287 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.54 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.546 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.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.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.05 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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/src/Utilities/Events/EventsData.php:1582 12 iCutilities\Events\EventsData::registeredList() JROOT/modules/mod_iccalendar/helper.php:289 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.53 ms Après la dernière requête : 4.99 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.606 MB Rangées retournées : 1
SELECT e.params
FROM `wjf2o_icagenda_events` AS `e`
WHERE `e`.`id` = 24id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 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.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:621 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.59 ms Après la dernière requête : 2.08 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.620 MB Rangées retournées : 1
SELECT e.params
FROM `wjf2o_icagenda_events` AS `e`
WHERE `e`.`id` = 23id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.04 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.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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:621 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.61 ms Après la dernière requête : 1.40 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.630 MB Rangées retournées : 1
SELECT e.params
FROM `wjf2o_icagenda_events` AS `e`
WHERE `e`.`id` = 25id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:621 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.53 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.637 MB Rangées retournées : 1
SELECT e.params
FROM `wjf2o_icagenda_events` AS `e`
WHERE `e`.`id` = 26id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 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.03 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.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:621 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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.48 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.645 MB Rangées retournées : 1
SELECT e.params
FROM `wjf2o_icagenda_events` AS `e`
WHERE `e`.`id` = 47id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e const PRIMARY PRIMARY 4 const 1 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.04 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 Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 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 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:373 13 iCutilities\Event\Event::getParams() JROOT/administrator/components/com_icagenda/src/Utilities/Event/Event.php:621 12 iCutilities\Event\Event::cancelledButton() JROOT/modules/mod_iccalendar/helper.php:510 11 modiCcalendarHelper->getStamp() JROOT/modules/mod_iccalendar/mod_iccalendar.php:151 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 :
7 × SELECT e.params
FROM `wjf2o_icagenda_events` AS `e`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 `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'3239616562303530636233326134393830396535323131626638616138356435', 1, 1725779865, 0, '', 01 × UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"5d4dddcf997f1921fae87f89be2c0138\"}'1 × SHOW FULL COLUMNS
FROM `wjf2o_template_styles