Noëlle NOÊL
Les Décès
mercredi 29 janvier 2020
Toutes les dates
- mercredi 29 janvier 2020
Propulsé par iCagenda
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": 1728264049,
"last": 1728264049,
"now": 1728264049
},
"token": "DNCxRmiy4w5TQtoOWy2KgyKgfg8uhag9"
},
"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
},
"event_id": 42,
"event_date": "2020-01-29 00:00:00",
"session_date": "2020-01-29 00:00:00"
}
}
Temps
Mémoire
Temps: 8.27 ms / 8.27 ms Mémoire: 0.410 MB / 0.76 MB Application: afterLoad
Temps: 91.48 ms / 99.75 ms Mémoire: 1.620 MB / 2.38 MB Application: afterInitialise
Temps: 15.74 ms / 115.49 ms Mémoire: 0.265 MB / 2.64 MB Application: afterRoute
Temps: 1.37 ms / 116.85 ms Mémoire: 0.040 MB / 2.68 MB Application: beforeRenderComponent com_icagenda
Temps: 11.67 ms / 128.53 ms Mémoire: 0.070 MB / 2.75 MB Application: Before Access::preloadComponents (all components)
Temps: 1.87 ms / 130.39 ms Mémoire: 0.061 MB / 2.81 MB Application: After Access::preloadComponents (all components)
Temps: 0.06 ms / 130.46 ms Mémoire: -0.002 MB / 2.81 MB Application: Before Access::getAssetRules (id:128 name:com_icagenda)
Temps: 0.67 ms / 131.13 ms Mémoire: 0.020 MB / 2.83 MB Application: After Access::getAssetRules (id:128 name:com_icagenda)
Temps: 70.81 ms / 201.93 ms Mémoire: 0.290 MB / 3.12 MB Application: afterRenderComponent com_icagenda
Temps: 4.69 ms / 206.63 ms Mémoire: 0.114 MB / 3.23 MB Application: afterDispatch
Temps: 23.45 ms / 230.07 ms Mémoire: 0.112 MB / 3.34 MB Application: beforeRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 1.89 ms / 231.96 ms Mémoire: 0.014 MB / 3.36 MB Application: afterRenderModule joomlapage_background_changer (Individual Page Background Changer)
Temps: 0.47 ms / 232.43 ms Mémoire: 0.022 MB / 3.38 MB Application: beforeRenderModule mod_custom (Mentions légales)
Temps: 0.85 ms / 233.29 ms Mémoire: 0.005 MB / 3.38 MB Application: afterRenderModule mod_custom (Mentions légales)
Temps: 0.38 ms / 233.67 ms Mémoire: -0.020 MB / 3.37 MB Application: beforeRenderModule mod_hobosm (Map Module)
Temps: 20.34 ms / 254.00 ms Mémoire: 0.020 MB / 3.39 MB Application: afterRenderModule mod_hobosm (Map Module)
Temps: 1.11 ms / 255.11 ms Mémoire: 0.034 MB / 3.42 MB Application: beforeRenderModule mod_parallax_scroll (Photo avant contact)
Temps: 1.28 ms / 256.39 ms Mémoire: 0.023 MB / 3.44 MB Application: afterRenderModule mod_parallax_scroll (Photo avant contact)
Temps: 10.03 ms / 266.42 ms Mémoire: 0.043 MB / 3.49 MB Application: afterRender
Total de requêtes base de données : 21.17 ms
3,83 MB (4 016 216 Bytes)
23 requêtes exécutées 21.17 ms
- Temps de requête : 0.64 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'3061643434373763333533346233656235323932373239646433376661386361'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.02 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.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 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.52 ms Après la dernière requête : 0.78 ms Mémoire de requête : 0.020 MB mémoire avant requête : 1.051 MB Rangées retournées : 0
SELECT `session_id`
FROM `wjf2o_session`
WHERE `session_id` = X'3061643434373763333533346233656235323932373239646433376661386361'
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.59 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.056 MB
INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3061643434373763333533346233656235323932373239646433376661386361', 1, 1728264049, 0, '', 0)EXPLAIN impossible sur la requête : INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3061643434373763333533346233656235323932373239646433376661386361', 1, 1728264049, 0, '', 0)Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Update 0.13 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.05 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.59 ms Après la dernière requête : 2.84 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.144 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.03 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.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: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.60 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.156 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.08 ms Preparing 0.01 ms Unlocking tables 0.01 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.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 : 27.95 ms Mémoire de requête : 0.007 MB mémoire avant requête : 2.000 MB
UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"301271f833557dba55d559abb29eae76\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN impossible sur la requête : UPDATE `wjf2o_extensions` SET `params` = '{\"mediaversion\":\"301271f833557dba55d559abb29eae76\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init for update 0.12 ms Updating 0.13 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.72 ms Après la dernière requête : 59.06 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.634 MB Rangées retournées : 0
SELECT `id`
FROM `wjf2o_icagenda_events`
WHERE `alias` = '42-noelle-noel'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_icagenda_events ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 47 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.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms 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/components/com_icagenda/router.php:358 11 iCagendaRouter->getEventId() JROOT/components/com_icagenda/router.php:334 10 iCagendaRouter->fixSegmentID() JROOT/components/com_icagenda/router.php:220 9 iCagendaRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 1.39 ms Après la dernière requête : 14.99 ms Mémoire de requête : 0.029 MB mémoire avant requête : 2.755 MB Rangées retournées : 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `wjf2o_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyslider','com_fields','com_finder','com_hobosm','com_icagenda','com_installer','com_jaextmanager','com_joomlaupdate','com_languages','com_login','com_mailjet','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE wjf2o_assets ALL idx_asset_name INDEX N'A PU ÊTRE UTILISÉ NULL NULL 257 Using where Status Duration Starting 0.12 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.10 ms Optimizing 0.03 ms Statistics 0.18 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.52 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 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_icagenda/models/event.php:64 14 iCagendaModelEvent->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_icagenda/models/event.php:88 12 iCagendaModelEvent->getItem() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394 11 JViewLegacy->get() JROOT/components/com_icagenda/views/event/view.html.php:51 10 iCagendaViewEvent->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_icagenda/controller.php:52 8 iCagendaController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_icagenda/icagenda.php:119 6 require_once JROOT/components/com_icagenda/icagenda.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.60 ms Après la dernière requête : 1.71 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.840 MB Rangées retournées : 1Requêtes dupliquées: #12
SELECT e.params
FROM `wjf2o_icagenda_events` AS `e`
WHERE `e`.`id` = 42id 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.04 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms 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/utilities/event/event.php:358 13 icagendaEvent::getParams() JROOT/components/com_icagenda/models/event.php:133 12 iCagendaModelEvent->getItem() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394 11 JViewLegacy->get() JROOT/components/com_icagenda/views/event/view.html.php:51 10 iCagendaViewEvent->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_icagenda/controller.php:52 8 iCagendaController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_icagenda/icagenda.php:119 6 require_once JROOT/components/com_icagenda/icagenda.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.91 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.849 MB Rangées retournées : 1
SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features,`r`.`count` AS `registered`
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
FROM `wjf2o_icagenda_registration` AS `r`
WHERE `r`.`status` = 1
AND `r`.`state` = 1
AND (r.date = '2020-01-29 00:00:00' OR (r.date = ""
AND r.period = 1))
GROUP BY r.eventid) AS r
ON e.id = r.eventid
WHERE e.state = 1
AND c.state = 1
AND e.id = 42id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY e const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 PRIMARY c const PRIMARY,idx_state PRIMARY 4 const 1 1 PRIMARY <derived2> ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 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 ref idx_state,idx_status idx_state 1 const 1 Using where; Using temporary; Utilisation du tri complet de type filesort 2 DERIVED fx ALL 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.20 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.20 ms Optimizing 0.05 ms Optimizing 0.02 ms Statistics 0.08 ms Optimizing 0.04 ms Statistics 0.05 ms Statistics 0.12 ms Preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.03 ms Preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.06 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 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.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/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_icagenda/models/event.php:219 12 iCagendaModelEvent->getItem() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394 11 JViewLegacy->get() JROOT/components/com_icagenda/views/event/view.html.php:51 10 iCagendaViewEvent->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_icagenda/controller.php:52 8 iCagendaController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_icagenda/icagenda.php:119 6 require_once JROOT/components/com_icagenda/icagenda.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.69 ms Après la dernière requête : 21.76 ms Mémoire de requête : 0.006 MB mémoire avant requête : 2.943 MB
UPDATE wjf2o_icagenda_events
SET hits = hits + 1
WHERE id = 42EXPLAIN impossible sur la requête : UPDATE wjf2o_icagenda_events SET hits = hits + 1 WHERE id = 42Status 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 for update 0.07 ms Updating 0.14 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 12 JDatabase->query() JROOT/components/com_icagenda/models/event.php:304 11 iCagendaModelEvent->hit() JROOT/components/com_icagenda/views/event/view.html.php:131 10 iCagendaViewEvent->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_icagenda/controller.php:52 8 iCagendaController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_icagenda/icagenda.php:119 6 require_once JROOT/components/com_icagenda/icagenda.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 : 4.13 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.018 MB Rangées retournées : 1Requêtes dupliquées: #9
SELECT e.params
FROM `wjf2o_icagenda_events` AS `e`
WHERE `e`.`id` = 42id 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.07 ms checking permissions 0.02 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.03 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.03 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 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/utilities/event/event.php:358 17 icagendaEvent::getParams() JROOT/administrator/components/com_icagenda/utilities/event/event.php:451 16 icagendaEvent::backArrow() JROOT/components/com_icagenda/views/event/tmpl/default_top.php:28 15 include JROOT/components/com_icagenda/views/event/tmpl/default_top.php JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661 14 JViewLegacy->loadTemplate() JROOT/components/com_icagenda/views/event/tmpl/default.php:32 13 include JROOT/components/com_icagenda/views/event/tmpl/default.php JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661 12 JViewLegacy->loadTemplate() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207 11 JViewLegacy->display() JROOT/components/com_icagenda/views/event/view.html.php:170 10 iCagendaViewEvent->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_icagenda/controller.php:52 8 iCagendaController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_icagenda/icagenda.php:119 6 require_once JROOT/components/com_icagenda/icagenda.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.84 ms Après la dernière requête : 1.98 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.043 MB Rangées retournées : 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM wjf2o_fields AS a
LEFT JOIN `wjf2o_languages` AS l
ON l.lang_code = a.language
LEFT JOIN wjf2o_users AS uc
ON uc.id=a.checked_out
LEFT JOIN wjf2o_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN wjf2o_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN wjf2o_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_icagenda.event'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 thevenin_commune10.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 thevenin_commune10.a.group_id 1 Using where Status Duration Starting 0.18 ms checking permissions 0.02 ms Opening tables 0.09 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.01 ms init 0.10 ms Optimizing 0.06 ms Statistics 0.18 ms Preparing 0.07 ms Creating tmp table 0.13 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.42 ms Creating sort index 0.06 ms Removing tmp table 0.08 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.02 ms Query end 0.02 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 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 24 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 23 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 22 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 21 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 20 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 19 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 18 JHtmlContent::prepare() Même appel que celui de la ligne ci-dessous. 17 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 16 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 15 Joomla\CMS\HTML\HTMLHelper::_() JROOT/components/com_icagenda/add/elements/icevent_vars.php:34 14 require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php JROOT/components/com_icagenda/views/event/tmpl/default.php:40 13 include JROOT/components/com_icagenda/views/event/tmpl/default.php JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661 12 JViewLegacy->loadTemplate() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207 11 JViewLegacy->display() JROOT/components/com_icagenda/views/event/view.html.php:170 10 iCagendaViewEvent->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_icagenda/controller.php:52 8 iCagendaController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_icagenda/icagenda.php:119 6 require_once JROOT/components/com_icagenda/icagenda.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.32 ms Après la dernière requête : 4.32 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.082 MB Rangées retournées : 0
SELECT cfd.*, cf.*
FROM `wjf2o_icagenda_customfields_data` AS cfd
LEFT JOIN wjf2o_icagenda_customfields AS cf
ON cf.slug = cfd.slug
WHERE `cfd`.`parent_id` = 42
AND `cfd`.`parent_form` = 2
AND `cf`.`parent_form` = 2
AND `cfd`.`state` = 1
AND `cf`.`state` = 1
AND `cfd`.`value` NOT IN ("", "{}")
ORDER BY cf.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cfd ref idx_state,idx_parent_form,idx_parent_id idx_state 1 const 1 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE cf ref idx_state,idx_parent_form idx_state 1 const 1 Using where Status Duration Starting 0.10 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.07 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.05 ms Creating tmp table 0.07 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.07 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.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/utilities/event/data.php:60 16 icagendaEventData::loadEventCustomFields() JROOT/administrator/components/com_icagenda/utilities/event/event.php:1420 15 icagendaEvent::getCustomFields() JROOT/components/com_icagenda/add/elements/icevent_vars.php:39 14 require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php JROOT/components/com_icagenda/views/event/tmpl/default.php:40 13 include JROOT/components/com_icagenda/views/event/tmpl/default.php JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661 12 JViewLegacy->loadTemplate() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207 11 JViewLegacy->display() JROOT/components/com_icagenda/views/event/view.html.php:170 10 iCagendaViewEvent->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_icagenda/controller.php:52 8 iCagendaController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_icagenda/icagenda.php:119 6 require_once JROOT/components/com_icagenda/icagenda.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.77 ms Après la dernière requête : 23.05 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.108 MB Rangées retournées : 1Requêtes dupliquées: #16
SELECT sum(`r`.`people`) AS total
FROM `wjf2o_icagenda_registration` AS `r`
WHERE `r`.`eventid` = 42
AND `r`.`status` = 1
AND `r`.`state` = 1
AND (r.date = '2020-01-29 00:00:00' OR (r.date = ""
AND r.period = 1))id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ref idx_state,idx_eventid,idx_status idx_state 1 const 1 Using where Status Duration Starting 0.10 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.05 ms Optimizing 0.04 ms Statistics 0.10 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.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 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 21 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:65 20 icagendaRegistration::getRegisteredTotal() JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:103 19 icagendaRegistration::getTicketsAvailable() JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:138 18 icagendaRegistration::getTicketsBookable() JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:290 17 icagendaRegistration::formDatesList() JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:882 16 icagendaRegistration::upcomingDatesBooking() JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:522 15 icagendaRegistration::registerButton() JROOT/components/com_icagenda/add/elements/icevent_vars.php:339 14 require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php JROOT/components/com_icagenda/views/event/tmpl/default.php:40 13 include JROOT/components/com_icagenda/views/event/tmpl/default.php JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661 12 JViewLegacy->loadTemplate() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207 11 JViewLegacy->display() JROOT/components/com_icagenda/views/event/view.html.php:170 10 iCagendaViewEvent->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_icagenda/controller.php:52 8 iCagendaController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_icagenda/icagenda.php:119 6 require_once JROOT/components/com_icagenda/icagenda.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.71 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.119 MB Rangées retournées : 1Requêtes dupliquées: #15
SELECT sum(`r`.`people`) AS total
FROM `wjf2o_icagenda_registration` AS `r`
WHERE `r`.`eventid` = 42
AND `r`.`status` = 1
AND `r`.`state` = 1
AND (r.date = '2020-01-29 00:00:00' OR (r.date = ""
AND r.period = 1))id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ref idx_state,idx_eventid,idx_status idx_state 1 const 1 Using where 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.03 ms table lock 0.01 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.07 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.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 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:65 17 icagendaRegistration::getRegisteredTotal() JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:945 16 icagendaRegistration::ticketsCouldBeBooked() JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:523 15 icagendaRegistration::registerButton() JROOT/components/com_icagenda/add/elements/icevent_vars.php:339 14 require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php JROOT/components/com_icagenda/views/event/tmpl/default.php:40 13 include JROOT/components/com_icagenda/views/event/tmpl/default.php JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661 12 JViewLegacy->loadTemplate() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207 11 JViewLegacy->display() JROOT/components/com_icagenda/views/event/view.html.php:170 10 iCagendaViewEvent->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_icagenda/controller.php:52 8 iCagendaController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_icagenda/icagenda.php:119 6 require_once JROOT/components/com_icagenda/icagenda.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.63 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.129 MB Rangées retournées : 1
SELECT sum(`r`.`people`) AS total
FROM `wjf2o_icagenda_registration` AS `r`
WHERE `r`.`eventid` = 42
AND `r`.`status` = 1
AND `r`.`state` = 1
AND (r.date = '2020-01-29-00-00' OR (r.date = ""
AND r.period = 1))id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ref idx_state,idx_eventid,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.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 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.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:65 16 icagendaRegistration::getRegisteredTotal() JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:551 15 icagendaRegistration::registerButton() JROOT/components/com_icagenda/add/elements/icevent_vars.php:339 14 require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php JROOT/components/com_icagenda/views/event/tmpl/default.php:40 13 include JROOT/components/com_icagenda/views/event/tmpl/default.php JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661 12 JViewLegacy->loadTemplate() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207 11 JViewLegacy->display() JROOT/components/com_icagenda/views/event/view.html.php:170 10 iCagendaViewEvent->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_icagenda/controller.php:52 8 iCagendaController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_icagenda/icagenda.php:119 6 require_once JROOT/components/com_icagenda/icagenda.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.45 ms Après la dernière requête : 0.58 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.141 MB Rangées retournées : 0
SELECT r.id AS regID, r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail, u.name AS name, u.username AS username, GROUP_CONCAT(ua.user_action) AS user_action
FROM wjf2o_icagenda_registration AS r
LEFT JOIN wjf2o_users as u
ON u.id = r.userid
LEFT JOIN wjf2o_icagenda_user_actions as ua
ON ua.parent_id = r.id
WHERE r.eventid = 42
AND r.status = 1
AND r.state = 1
AND (r.date = '2020-01-29 00:00:00' OR (r.date = ""
AND r.period = 1))
GROUP BY r.id, ua.parent_idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ref idx_state,idx_eventid,idx_status idx_state 1 const 1 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE u eq_ref PRIMARY PRIMARY 4 thevenin_commune10.r.userid 1 1 SIMPLE ua ALL idx_parent_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 Using where; Using join buffer (flat, BNL join) 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.01 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.06 ms Creating tmp table 0.09 ms Sorting result 0.05 ms Executing 0.01 ms Sending data 0.28 ms Creating sort index 0.08 ms Removing tmp table 0.08 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.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Removing tmp table 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 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_icagenda/utilities/registration/participants.php:151 15 icagendaRegistrationParticipants::registeredUsers() JROOT/components/com_icagenda/add/elements/icevent_vars.php:373 14 require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php JROOT/components/com_icagenda/views/event/tmpl/default.php:40 13 include JROOT/components/com_icagenda/views/event/tmpl/default.php JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661 12 JViewLegacy->loadTemplate() JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207 11 JViewLegacy->display() JROOT/components/com_icagenda/views/event/view.html.php:170 10 iCagendaViewEvent->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_icagenda/controller.php:52 8 iCagendaController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_icagenda/icagenda.php:119 6 require_once JROOT/components/com_icagenda/icagenda.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.10 ms Après la dernière requête : 2.79 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.122 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.28 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.06 ms End of update loop 0.02 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.10 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.66 ms Après la dernière requête : 0.53 ms Mémoire de requête : 0.021 MB mémoire avant requête : 3.140 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.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.03 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 : 1.85 ms Après la dernière requête : 17.58 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.319 MB Rangées retournées : 8
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 <= '2024-10-07 01:20:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-07 01:20:49')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 233 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds INDEX N'A PU ÊTRE UTILISÉ NULL NULL 91 Using where; Utilisation du tri complet de type filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 thevenin_commune10.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 thevenin_commune10.m.module,const 1 Using index condition; Using where Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.07 ms Optimizing 0.07 ms Statistics 0.11 ms Preparing 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.93 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.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Appel Fichier et numéro de ligne 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() Même appel que celui de la ligne ci-dessous. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/helix/core/helix.php:735 11 Helix::countModules() JROOT/plugins/system/helix/core/helix.php:351 10 Helix::showRow() JROOT/plugins/system/helix/core/helix.php:448 9 Helix::generatelayout() JROOT/plugins/system/helix/core/helix.php:713 8 Helix::layout() JROOT/templates/shaper_xeon/index.php:49 7 require JROOT/templates/shaper_xeon/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Temps de requête : 0.48 ms Après la dernière requête : 10.37 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.387 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.01 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.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: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.77 ms Après la dernière requête : 18.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.395 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.11 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 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.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 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
20 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
3 × SELECT sum(`r`.`people`) AS total
FROM `wjf2o_icagenda_registration` AS `r`2 × SELECT e.params
FROM `wjf2o_icagenda_events` AS `e`1 × 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 `id`
FROM `wjf2o_icagenda_events`1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `wjf2o_assets`1 × SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features,`r`.`count` AS `registered`
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
FROM `wjf2o_icagenda_registration` AS `r`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM wjf2o_fields AS a
LEFT JOIN `wjf2o_languages` AS l
ON l.lang_code = a.language
LEFT JOIN wjf2o_users AS uc
ON uc.id=a.checked_out
LEFT JOIN wjf2o_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN wjf2o_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN wjf2o_fields_groups AS g
ON g.id = a.group_id1 × SELECT cfd.*, cf.*
FROM `wjf2o_icagenda_customfields_data` AS cfd
LEFT JOIN wjf2o_icagenda_customfields AS cf
ON cf.slug = cfd.slug1 × SELECT r.id AS regID, r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail, u.name AS name, u.username AS username, GROUP_CONCAT(ua.user_action) AS user_action
FROM wjf2o_icagenda_registration AS r
LEFT JOIN wjf2o_users as u
ON u.id = r.userid
LEFT JOIN wjf2o_icagenda_user_actions as ua
ON ua.parent_id = r.id1 × 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_id1 × SELECT *
FROM `wjf2o_hobosm_license_active1 × 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
Autres tables :
1 × INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3061643434373763333533346233656235323932373239646433376661386361', 1, 1728264049, 0, '', 01 × UPDATE `wjf2o_extensions`
SET `params` = '{\"mediaversion\":\"301271f833557dba55d559abb29eae76\"}'1 × UPDATE wjf2o_icagenda_events
SET hits = hits + 11 × SHOW FULL COLUMNS
FROM `wjf2o_template_styles