{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728264167,
                "last": 1728264167,
                "now": 1728264167
            },
            "token": "8h5fp0F4s4WFIza27KKjeSP6JRb2kAqs"
        },
        "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": 8,
        "event_date": "2021-08-30 00:00:00",
        "session_date": "2021-08-30 00:00:00"
    }
}

Temps

Mémoire

87 requêtes exécutées 61.95 ms

1. Temps de requête : 0.61 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.038 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `wjf2o_session`
   
     WHERE `session_id` = X'6364323935373330346265363734626264353536306564373332623162353236'

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	wjf2o_session	const	PRIMARY	PRIMARY	194	const	1

   Profil

   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.04 ms
   Optimizing	0.03 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

   Pile d'appels

   #	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

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

2. Temps de requête : 0.50 ms Après la dernière requête : 0.80 ms Mémoire de requête : 0.020 MB mémoire avant requête : 1.052 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `wjf2o_session`
   
     WHERE `session_id` = X'6364323935373330346265363734626264353536306564373332623162353236' 
     LIMIT 1

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	wjf2o_session	const	PRIMARY	PRIMARY	194	const	1	Using index

   Profil

   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.04 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.02 ms
   Reset for next command	0.01 ms

   Pile d'appels

   #	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

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

3. Temps de requête : 0.59 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.057 MB

   INSERT INTO `wjf2o_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6364323935373330346265363734626264353536306564373332623162353236', 1, 1728264167, 0, '', 0)

   Explication

   EXPLAIN impossible sur la requête : INSERT INTO `wjf2o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6364323935373330346265363734626264353536306564373332623162353236', 1, 1728264167, 0, '', 0)

   Profil

   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.04 ms
   Update	0.14 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

   Pile d'appels

   #	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

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

4. Temps de requête : 0.56 ms Après la dernière requête : 3.00 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.145 MB Rangées retournées : 5

   SELECT id, rules
   
     FROM `wjf2o_viewlevels`

   Explication

   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

   Profil

   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.02 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

   Pile d'appels

   #	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

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

5. Temps de requête : 0.60 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.157 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 = 1

   Explication

   id	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

   Profil

   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.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

   Pile d'appels

   #	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

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

6. Temps de requête : 0.74 ms Après la dernière requête : 24.60 ms Mémoire de requête : 0.007 MB mémoire avant requête : 2.002 MB

   UPDATE `wjf2o_extensions`
   
     SET `params` = '{\"mediaversion\":\"365f44266542ee7ea4ac495fefb5205e\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explication

   EXPLAIN impossible sur la requête : UPDATE `wjf2o_extensions` SET `params` = '{\"mediaversion\":\"365f44266542ee7ea4ac495fefb5205e\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profil

   Status	Duration
   Starting	0.09 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 for update	0.12 ms
   Updating	0.12 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.05 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.05 ms
   Reset for next command	0.02 ms

   Pile d'appels

   #	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

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

7. Temps de requête : 0.74 ms Après la dernière requête : 31.59 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.636 MB Rangées retournées : 1

   SELECT `id`
   
     FROM `wjf2o_icagenda_events`
   
     WHERE `alias` = '8-tri-selectif'

   Explication

   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

   Profil

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.02 ms
   Opening tables	0.04 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.04 ms
   Executing	0.01 ms
   Sending data	0.13 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   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

   Pile d'appels

   #	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

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

8. Temps de requête : 1.40 ms Après la dernière requête : 10.59 ms Mémoire de requête : 0.029 MB mémoire avant requête : 2.752 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')

   Explication

   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

   Profil

   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.01 ms
   init	0.09 ms
   Optimizing	0.03 ms
   Statistics	0.19 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.53 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

   Pile d'appels

   #	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

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

9. Temps de requête : 0.58 ms Après la dernière requête : 1.25 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.837 MB Rangées retournées : 1
   Requêtes dupliquées: #12  #79

   SELECT e.params
   
     FROM `wjf2o_icagenda_events` AS `e`
   
     WHERE `e`.`id` = 8

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	e	const	PRIMARY	PRIMARY	4	const	1

   Profil

   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.06 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.03 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

   Pile d'appels

   #	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

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

10. Temps de requête : 1.95 ms Après la dernière requête : 0.49 ms Mémoire de requête : 0.039 MB mémoire avant requête : 2.846 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 = '2021-08-30 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 = 8

    Explication

    id	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

    Profil

    Status	Duration
    Starting	0.20 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    After opening tables	0.02 ms
    System lock	0.01 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.06 ms
    Statistics	0.12 ms
    Preparing	0.04 ms
    Creating tmp table	0.04 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.02 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.07 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.03 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.06 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

11. Temps de requête : 0.64 ms Après la dernière requête : 2.11 ms Mémoire de requête : 0.006 MB mémoire avant requête : 2.940 MB

    UPDATE wjf2o_icagenda_events 
      SET hits = hits + 1 
      WHERE id = 8

    Explication

    EXPLAIN impossible sur la requête : UPDATE wjf2o_icagenda_events SET hits = hits + 1 WHERE id = 8

    Profil

    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 for update	0.09 ms
    Updating	0.11 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.05 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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

12. Temps de requête : 0.59 ms Après la dernière requête : 3.58 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.015 MB Rangées retournées : 1
    Requêtes dupliquées: #9  #79

    SELECT e.params
    
      FROM `wjf2o_icagenda_events` AS `e`
    
      WHERE `e`.`id` = 8

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	const	PRIMARY	PRIMARY	4	const	1

    Profil

    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.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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

13. Temps de requête : 1.77 ms Après la dernière requête : 1.90 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.040 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 ASC

    Explication

    id	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

    Profil

    Status	Duration
    Starting	0.17 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.10 ms
    Optimizing	0.10 ms
    Statistics	0.18 ms
    Preparing	0.07 ms
    Creating tmp table	0.11 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.41 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.09 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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

14. Temps de requête : 1.31 ms Après la dernière requête : 4.23 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.084 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` = 8 
      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 ASC

    Explication

    id	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

    Profil

    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.10 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.30 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.07 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.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

15. Temps de requête : 0.68 ms Après la dernière requête : 7.55 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.132 MB Rangées retournées : 1
    Requêtes dupliquées: #42

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-01-02 19:17:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.04 ms
    Optimizing	0.04 ms
    Statistics	0.08 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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

16. Temps de requête : 0.57 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.143 MB Rangées retournées : 1
    Requêtes dupliquées: #43

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-01-15 19:17:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.06 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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

17. Temps de requête : 0.61 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.027 MB mémoire avant requête : 3.155 MB Rangées retournées : 1
    Requêtes dupliquées: #44

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-01-29 19:17:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.06 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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

18. Temps de requête : 0.58 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.167 MB Rangées retournées : 1
    Requêtes dupliquées: #45

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-02-12 19:17:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.02 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.06 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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

19. Temps de requête : 0.59 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.177 MB Rangées retournées : 1
    Requêtes dupliquées: #46

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-02-26 19:17:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.04 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.06 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.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

20. Temps de requête : 0.52 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.188 MB Rangées retournées : 1
    Requêtes dupliquées: #47

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-03-11 19:18:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

21. Temps de requête : 0.55 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.199 MB Rangées retournées : 1
    Requêtes dupliquées: #48

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-03-25 19:18:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

22. Temps de requête : 0.56 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.210 MB Rangées retournées : 1
    Requêtes dupliquées: #49

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-04-08 19:18:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.02 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.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.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

23. Temps de requête : 0.62 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.221 MB Rangées retournées : 1
    Requêtes dupliquées: #50

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-04-22 19:18:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.03 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.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

24. Temps de requête : 0.57 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.232 MB Rangées retournées : 1
    Requêtes dupliquées: #51

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-05-06 19:18:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.04 ms
    Optimizing	0.03 ms
    Statistics	0.06 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.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

25. Temps de requête : 0.52 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.243 MB Rangées retournées : 1
    Requêtes dupliquées: #52

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-05-21 19:19:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

26. Temps de requête : 0.56 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.253 MB Rangées retournées : 1
    Requêtes dupliquées: #53

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-06-03 19:19:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.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.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

27. Temps de requête : 0.99 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.264 MB Rangées retournées : 1
    Requêtes dupliquées: #54

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-06-17 19:19:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    Status	Duration
    Starting	0.49 ms
    checking permissions	0.02 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.06 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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

28. Temps de requête : 0.57 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.275 MB Rangées retournées : 1
    Requêtes dupliquées: #55

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-07-01 19:19:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.04 ms
    Statistics	0.06 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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

29. Temps de requête : 0.61 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.286 MB Rangées retournées : 1
    Requêtes dupliquées: #56

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-07-15 19:20:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.05 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.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

30. Temps de requête : 0.60 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.297 MB Rangées retournées : 1
    Requêtes dupliquées: #57

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-07-29 19:20:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.06 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.03 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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

31. Temps de requête : 0.55 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.308 MB Rangées retournées : 1
    Requêtes dupliquées: #58

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-08-12 19:20:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

32. Temps de requête : 0.54 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.318 MB Rangées retournées : 1
    Requêtes dupliquées: #59

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-08-26 19:20:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

33. Temps de requête : 0.78 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.336 MB Rangées retournées : 1
    Requêtes dupliquées: #60

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-09-09 19:20:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.05 ms
    Statistics	0.09 ms
    Preparing	0.05 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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

34. Temps de requête : 0.63 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.348 MB Rangées retournées : 1
    Requêtes dupliquées: #61

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-09-23 19:21:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.03 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.06 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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

35. Temps de requête : 0.74 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.359 MB Rangées retournées : 1
    Requêtes dupliquées: #62

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-10-07 19:21:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    Status	Duration
    Starting	0.08 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.01 ms
    init	0.04 ms
    Optimizing	0.05 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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

36. Temps de requête : 0.72 ms Après la dernière requête : 0.42 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.370 MB Rangées retournées : 1
    Requêtes dupliquées: #63

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-10-21 19:21:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.08 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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

37. Temps de requête : 0.71 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.381 MB Rangées retournées : 1
    Requêtes dupliquées: #64

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-11-04 19:21:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

38. Temps de requête : 0.65 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.392 MB Rangées retournées : 1
    Requêtes dupliquées: #65

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-11-18 19:21:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.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

    Pile d'appels

    #	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

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

39. Temps de requête : 0.68 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.403 MB Rangées retournées : 1
    Requêtes dupliquées: #66

    SELECT sum(`r`.`people`) AS total
    
      FROM `wjf2o_icagenda_registration` AS `r`
    
      WHERE `r`.`eventid` = 8 
      AND `r`.`status` = 1 
      AND `r`.`state` = 1 
      AND (r.date = '2024-12-02 19:22:00' OR (r.date = "" 
      AND r.period = 1))

    Explication

    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

    Profil

    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.02 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.08 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

    Pile d'appels

    #	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::executeCompo