Terres de Café aux Galeries Lafayette Gourmet à Paris

Catégorie

Gastronomie

Date

1 avril 2018 11:00 - 19:00

Lieu

Galeries Lafayette Gourmet - 35 Boulevard Haussmann
75009 Paris, France

Téléphone

01 40 23 52 67

Avec l'ouverture d'une première boutique à Paris en 2009, Terres de Café fait figure de pionnier en France dans le domaine des cafés de Spécialité. Christophe Servell, fondateur de la marque, sillonne depuis des années les pays producteurs à la recherche des meilleurs cafés du monde. Au fil du temps, ce fils et petit-fils de torréfacteur, a tissé de solides liens avec les producteurs de café les plus haut de gamme. Il assure ainsi le sourcing exclusif des plus beaux crus pour Terres de Café. Ce passionné exigeant, nommé Meilleur Torréfacteur de France par le Comité Français du Café, participe à l'amélioration de la qualité des cafés récolte après récolte. Il propose une vision du café dont les principes fondateurs sont, à l'instar des grands vins, la traçabilité, le respect de la nature et la valorisation des savoir-faire. Christophe Servell concentre ses recherches sur les cafés de forêts, cultivés en agro foresterie sans aucun intrant chimique, « véritable gage d'avenir des cafés de haute qualité ».

Christophe Servell, meilleur torréfacteur de France et fondateur de Terres de Café, inaugure un corner entièrement dédié au café de spécialité aux Galeries Lafayette Gourmet. Créé dans l’esprit de la boutique Terres de café située rue des Blancs-Manteaux, ce corner invite les amateurs de café à savourer les meilleurs crus dans un cadre moderne et chaleureux imaginé par le studio Arles et Dion. Les adeptes de café peuvent découvrir aux Galeries Lafayette l’intégralité des produits Terres de Café.

Ils ont la possibilité de les déguster sur place en présence d'un barista aguerri qui les conseille et les oriente tout au long de cette expérience gustative.

Conçu comme une boutique, ce stand de 40m² fait la part belle aux cafés d’exception issus des gammes Fresh ou Geisha. Ces crus sont sélectionnés avec soin par le fondateur, Christophe Servell, pour leurs qualités aromatiques et la traçabilité de leur production. Guidée par une passion et une exigence constantes, la marque fait figure de pionnier en France dans le domaine des cafés dits "de spécialité".

TerresdeCafeGaleriesLafayette 01

Avec un éventail de plus de 30 cafés exclusifs en grain ou moulus et 12 sortes de capsules compatibles, Terres de Café offre la plus large gamme de cafés de spécialité en Europe. La nouvelle devrait donc ravir les amoureux du p’tit noir !

Du 31 mars au 31 août 2018 - Galeries Lafayette Gourmet : 35, boulevard Haussmann 75009 Paris - 01 40 23 52 67 - Ouvert du lundi au samedi de 8h30 à 21h30 et le dimanche de 11h à 19h - Site officiel : www.terresdecafe.com - Facebook : www.facebook.com/terresdecafe - Instagram : www.instagram.com/terres_de_cafe.

Toutes les Dates

Du 31 mars 2018 11:00 au 31 août 2018 19:00

Propulsé par iCagenda

Connectez-vous

Se connecter

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1524735216,
                "last": 1524735216,
                "now": 1524735216
            },
            "token": "AIlPeBRcWFKRU0RndZnIbKmbnxVIRaHy"
        },
        "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": 8883,
        "event_date": "2018-04-01 11:00:00",
        "session_date": "2018-04-01 11:00:00"
    }
}

Profil d'information

Temps

Mémoire

Temps: 14.61 ms / 14.61 ms Mémoire: 1.416 MB / 1.75 MB Application: afterLoad

Temps: 83.45 ms / 98.05 ms Mémoire: 4.480 MB / 6.23 MB Application: afterInitialise

Temps: 15.51 ms / 113.56 ms Mémoire: 1.138 MB / 7.36 MB Application: afterRoute

Temps: 1.83 ms / 115.39 ms Mémoire: 0.047 MB / 7.41 MB Application: beforeRenderComponent com_icagenda

Temps: 11.06 ms / 126.44 ms Mémoire: 0.730 MB / 8.14 MB Application: Before Access::preloadComponents (all components)

Temps: 0.63 ms / 127.07 ms Mémoire: 0.059 MB / 8.20 MB Application: After Access::preloadComponents (all components)

Temps: 0.03 ms / 127.10 ms Mémoire: 0.000 MB / 8.20 MB Application: Before Access::getAssetRules (id:156 name:com_icagenda)

Temps: 0.58 ms / 127.69 ms Mémoire: 0.030 MB / 8.23 MB Application: After Access::getAssetRules (id:156 name:com_icagenda)

Temps: 75.26 ms / 202.95 ms Mémoire: 1.946 MB / 10.17 MB Application: afterRenderComponent com_icagenda

Temps: 0.45 ms / 203.40 ms Mémoire: 0.006 MB / 10.18 MB Application: afterDispatch

Temps: 6.85 ms / 210.25 ms Mémoire: 0.280 MB / 10.46 MB Application: beforeRenderModule mod_login (Se connecter)

Temps: 3.21 ms / 213.46 ms Mémoire: 0.135 MB / 10.59 MB Application: afterRenderModule mod_login (Se connecter)

Temps: 0.10 ms / 213.56 ms Mémoire: 0.010 MB / 10.60 MB Application: beforeRenderModule mod_social_slider (Suivez nous)

Temps: 1.32 ms / 214.87 ms Mémoire: 0.122 MB / 10.72 MB Application: afterRenderModule mod_social_slider (Suivez nous)

Temps: 0.07 ms / 214.95 ms Mémoire: 0.000 MB / 10.70 MB Application: beforeRenderModule mod_search (Chercher)

Temps: 0.87 ms / 215.82 ms Mémoire: 0.018 MB / 10.71 MB Application: afterRenderModule mod_search (Chercher)

Temps: 0.08 ms / 215.90 ms Mémoire: 0.016 MB / 10.73 MB Application: beforeRenderModule mod_accordeonck (Catégories)

Temps: 15.44 ms / 231.34 ms Mémoire: 0.845 MB / 11.57 MB Application: afterRenderModule mod_accordeonck (Catégories)

Temps: 0.11 ms / 231.44 ms Mémoire: 0.000 MB / 11.54 MB Application: beforeRenderModule mod_menu (Main Menu)

Temps: 2.31 ms / 233.76 ms Mémoire: 0.060 MB / 11.60 MB Application: afterRenderModule mod_menu (Main Menu)

Temps: 25.66 ms / 259.42 ms Mémoire: 0.708 MB / 12.31 MB Application: afterRender

Total de requêtes base de données : 38.75 ms

Occupation de la mémoire

Requêtes de base de données

44 requêtes exécutées 38.75 ms

Temps de requête : 0.44 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.449 MB Rangées retournées : 0

SELECT `data`

  FROM `rux82nykm1jos_session`

  WHERE `session_id` = 'f6f16d48aeef7ce521fe17e670028ae3'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rux82nykm1jos_session	const	PRIMARY	PRIMARY	766	const	1

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:764
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:144
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:352
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]

Temps de requête : 0.32 ms Après la dernière requête : 1.78 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.536 MB Rangées retournées : 0

SELECT `session_id`

  FROM `rux82nykm1jos_session`

  WHERE `session_id` = 'f6f16d48aeef7ce521fe17e670028ae3' 
  LIMIT 1

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:161
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:766
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:144
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:352
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]

Temps de requête : 5.06 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.004 MB mémoire avant requête : 3.542 MB

INSERT INTO `rux82nykm1jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('f6f16d48aeef7ce521fe17e670028ae3', 1, '1524735216', 0, '', 0)

Explication

EXPLAIN impossible sur la requête : INSERT INTO `rux82nykm1jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('f6f16d48aeef7ce521fe17e670028ae3', 1, '1524735216', 0, '', 0)

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
System lock	0.01 ms
init	0.01 ms
update	1.04 ms
Waiting for query cache lock	0.01 ms
update	0.79 ms
end	0.02 ms
query end	0.77 ms
closing tables	0.03 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 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:161
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:766
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:144
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:352
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]

Temps de requête : 1.15 ms Après la dernière requête : 4.58 ms Mémoire de requête : 0.048 MB mémoire avant requête : 3.747 MB Rangées retournées : 38

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `rux82nykm1jos_extensions`

  WHERE `type` = 'component'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rux82nykm1jos_extensions	ref	extension	extension	82	const	38	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.57 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:431
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
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:204
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]

Temps de requête : 0.28 ms Après la dernière requête : 3.94 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.032 MB Rangées retournées : 5

SELECT id, rules

  FROM `rux82nykm1jos_viewlevels`

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rux82nykm1jos_viewlevels	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
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:310
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:606
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:204
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]

Temps de requête : 0.25 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.044 MB Rangées retournées : 1

SELECT b.id

  FROM rux82nykm1jos_usergroups AS a

  LEFT JOIN rux82nykm1jos_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	Using index

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
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:310
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:606
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:204
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]

Temps de requête : 0.39 ms Après la dernière requête : 1.12 ms Mémoire de requête : 0.034 MB mémoire avant requête : 4.106 MB Rangées retournées : 96

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM rux82nykm1jos_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rux82nykm1jos_extensions	ref	extension	extension	82	const	110	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
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:606
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:204
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]

Temps de requête : 0.24 ms Après la dernière requête : 11.40 ms Mémoire de requête : 0.022 MB mémoire avant requête : 5.038 MB Rangées retournées : 1

SELECT `enabled`

  FROM `rux82nykm1jos_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rux82nykm1jos_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:74
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:631
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:204
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]

Temps de requête : 0.87 ms Après la dernière requête : 15.11 ms Mémoire de requête : 0.027 MB mémoire avant requête : 5.815 MB Rangées retournées : 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `rux82nykm1jos_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rux82nykm1jos_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/googlic_analytics/googlic_analytics.php:38
8	plgSystemGOOGLIC_analytics->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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:204
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]

Temps de requête : 5.67 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.006 MB mémoire avant requête : 5.807 MB

UPDATE `rux82nykm1jos_extensions`

  SET `params` = '{\"mediaversion\":\"f203af41101fa9e4342fac897eb1aebf\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.06 ms
Updating	0.03 ms
end	0.00 ms
query end	5.26 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/googlic_analytics/googlic_analytics.php:38
8	plgSystemGOOGLIC_analytics->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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:204
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]

Temps de requête : 2.29 ms Après la dernière requête : 7.42 ms Mémoire de requête : 0.140 MB mémoire avant requête : 6.410 MB Rangées retournées : 75

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM rux82nykm1jos_menu AS m

  LEFT JOIN rux82nykm1jos_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	78	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db526864428.m.component_id	1

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.19 ms
Sending data	1.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:383
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:497
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1079
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:204
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]

Temps de requête : 0.37 ms Après la dernière requête : 11.00 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.392 MB Rangées retournées : 1

SELECT *

  FROM rux82nykm1jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rux82nykm1jos_languages	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:204
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]

Temps de requête : 0.75 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.401 MB Rangées retournées : 6

SELECT id, home, template, s.params

  FROM rux82nykm1jos_template_styles as s

  LEFT JOIN rux82nykm1jos_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db526864428.s.template,const	1	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:204
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]

Temps de requête : 0.38 ms Après la dernière requête : 11.45 ms Mémoire de requête : 0.031 MB mémoire avant requête : 8.146 MB Rangées retournées : 38

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `rux82nykm1jos_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_icagenda','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sexypolling','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rux82nykm1jos_assets	range	idx_asset_name	idx_asset_name	202	NULL	39	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
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:70
14	iCagendaModelEvent->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_icagenda/models/event.php:95
12	iCagendaModelEvent->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_icagenda/views/event/view.html.php:52
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 3.44 ms Après la dernière requête : 2.45 ms Mémoire de requête : 0.024 MB mémoire avant requête : 8.347 MB Rangées retournées : 1

SELECT e.params

  FROM `rux82nykm1jos_icagenda_events` AS `e`

  WHERE `e`.`id` = 8883

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.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	3.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.06 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/event/event.php:1025
13	icagendaEvent::getParams()	JROOT/components/com_icagenda/models/event.php:140
12	iCagendaModelEvent->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_icagenda/views/event/view.html.php:52
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.85 ms Après la dernière requête : 0.49 ms Mémoire de requête : 0.039 MB mémoire avant requête : 8.363 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 rux82nykm1jos_icagenda_events AS e

  LEFT JOIN rux82nykm1jos_icagenda_category AS c 
  ON c.id = e.catid

  LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count

  FROM `rux82nykm1jos_icagenda_feature_xref` AS fx

  INNER JOIN `rux82nykm1jos_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 `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`state` = 1 
  AND (r.date = '2018-04-01 11: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 = 8883

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	0	const row not found
1	PRIMARY	<derived3>	system	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	0	const row not found
1	PRIMARY	e	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
3	DERIVED	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	no matching row in const table
2	DERIVED	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.06 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Waiting for query cache lock	0.00 ms
executing	0.03 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_icagenda/models/event.php:225
12	iCagendaModelEvent->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_icagenda/views/event/view.html.php:52
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.50 ms Après la dernière requête : 4.29 ms Mémoire de requête : 0.007 MB mémoire avant requête : 8.657 MB

UPDATE rux82nykm1jos_icagenda_events 
  SET hits = hits + 1 
  WHERE id = 8883

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.00 ms
init	0.03 ms
Updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.11 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 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:322
11	iCagendaModelEvent->hit()	JROOT/components/com_icagenda/views/event/view.html.php:135
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.52 ms Après la dernière requête : 8.57 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.231 MB Rangées retournées : 1

SELECT alias

  FROM rux82nykm1jos_icagenda_events

  WHERE id=8883

Explication

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

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.04 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.07 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
23	JDatabaseDriver->loadResult()	JROOT/components/com_icagenda/router.php:63
22	iCagendaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_icagenda/views/event/tmpl/default_top.php:28
15	include JROOT/components/com_icagenda/views/event/tmpl/default_top.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_icagenda/views/event/tmpl/default.php:28
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.49 ms Après la dernière requête : 6.32 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.483 MB Rangées retournées : 0

SELECT cfd.*, cf.title AS title, cf.type AS type

  FROM `rux82nykm1jos_icagenda_customfields_data` AS cfd

  LEFT JOIN rux82nykm1jos_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 8883 
  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	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
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:950
15	icagendaEvent::getCustomFields()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:29
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.51 ms Après la dernière requête : 13.31 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.872 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-04-01 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.07 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.53 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.883 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-04-08 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.40 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.895 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-04-15 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.04 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.83 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.906 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-04-22 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.34 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.07 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.39 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.917 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-04-29 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.42 ms Après la dernière requête : 0.48 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.929 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-05-06 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.38 ms Après la dernière requête : 0.41 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.940 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-05-13 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.49 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.952 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-05-20 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.07 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.39 ms Après la dernière requête : 0.45 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.963 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-05-27 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.42 ms Après la dernière requête : 0.43 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.974 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-06-03 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.37 ms Après la dernière requête : 0.46 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.986 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-06-10 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.39 ms Après la dernière requête : 0.43 ms Mémoire de requête : 0.028 MB mémoire avant requête : 9.998 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-06-17 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.43 ms Après la dernière requête : 0.41 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.009 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-06-24 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.36 ms Après la dernière requête : 0.45 ms Mémoire de requête : 0.029 MB mémoire avant requête : 10.027 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-07-01 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.35 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.040 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-07-08 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.46 ms Après la dernière requête : 0.46 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.051 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-07-15 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.08 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.37 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.062 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-07-22 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.39 ms Après la dernière requête : 0.43 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.073 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-07-29 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.37 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.085 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-08-05 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 3.21 ms Après la dernière requête : 0.43 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.096 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-08-12 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	2.83 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.56 ms Après la dernière requête : 0.51 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.107 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-08-19 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.17 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.00 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.06 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.40 ms Après la dernière requête : 0.45 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.119 MB Rangées retournées : 1

SELECT sum(`r`.`people`) AS total

  FROM `rux82nykm1jos_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 8883 
  AND `r`.`state` = 1 
  AND (r.date = '2018-08-26 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:62
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:99
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:134
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:207
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:665
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:292
15	icagendaRegistration::reg()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:319
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 0.51 ms Après la dernière requête : 10.23 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.108 MB Rangées retournées : 0

SELECT  r.id AS regID, r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail,
						u.name AS name, u.username AS username

  FROM rux82nykm1jos_icagenda_registration AS r

  LEFT JOIN rux82nykm1jos_users as u 
  ON u.id = r.userid

  WHERE r.eventid = 8883 
  AND r.state = 1 
  AND (r.date = '2018-04-01 11:00:00' OR (r.date = "" 
  AND r.period = 1))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/registration/participants.php:139
15	icagendaRegistrationParticipants::registeredUsers()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:345
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:193
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:62
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:152
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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]

Temps de requête : 1.06 ms Après la dernière requête : 7.46 ms Mémoire de requête : 0.054 MB mémoire avant requête : 10.440 MB Rangées retournées : 34

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM rux82nykm1jos_modules AS m

  LEFT JOIN rux82nykm1jos_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN rux82nykm1jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-04-26 09:33:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-04-26 09:33:37') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	13	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db526864428.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	db526864428.m.module,const	1	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.09 ms
Sending data	0.15 ms
Waiting for query cache lock	0.00 ms
Sending data	0.14 ms
Waiting for query cache lock	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/people/functions.php:4
8	require JROOT/templates/people/functions.php	JROOT/templates/people/index.php:8
7	require JROOT/templates/people/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1036
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
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]

Temps de requête : 0.48 ms Après la dernière requête : 11.74 ms Mémoire de requête : 0.037 MB mémoire avant requête : 11.099 MB Rangées retournées : 24

SELECT *
			
  FROM rux82nykm1jos_modules
			
  WHERE published=1
			
  ORDER BY id
			;

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rux82nykm1jos_modules	ref	published	published	1	const	24	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.07 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_accordeonck/helper.php:251
12	modAccordeonckHelper::CreateModulesList()	JROOT/modules/mod_accordeonck/helper.php:45
11	modAccordeonckHelper::GetItems()	JROOT/modules/mod_accordeonck/mod_accordeonck.php:21
10	include JROOT/modules/mod_accordeonck/mod_accordeonck.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
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 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

22 × SELECT sum(`r`.`people`) AS total 
  FROM `rux82nykm1jos_icagenda_registration` AS `r`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `rux82nykm1jos_extensions`

1 × SELECT `data` 
  FROM `rux82nykm1jos_session`

1 × SELECT e.params 
  FROM `rux82nykm1jos_icagenda_events` AS `e`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM rux82nykm1jos_modules AS m 
  LEFT JOIN rux82nykm1jos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN rux82nykm1jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT  r.id AS regID, r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail,       u.name AS name, u.username AS username 
  FROM rux82nykm1jos_icagenda_registration AS r 
  LEFT JOIN rux82nykm1jos_users as u 
  ON u.id = r.userid

1 × SELECT cfd.*, cf.title AS title, cf.type AS type 
  FROM `rux82nykm1jos_icagenda_customfields_data` AS cfd 
  LEFT JOIN rux82nykm1jos_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

1 × SELECT alias 
  FROM rux82nykm1jos_icagenda_events

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 rux82nykm1jos_icagenda_events AS e 
  LEFT JOIN rux82nykm1jos_icagenda_category AS c 
  ON c.id = e.catid 
  LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count 
  FROM `rux82nykm1jos_icagenda_feature_xref` AS fx 
  INNER JOIN `rux82nykm1jos_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 `rux82nykm1jos_icagenda_registration` AS `r`

1 × SELECT id, home, template, s.params 
  FROM rux82nykm1jos_template_styles as s 
  LEFT JOIN rux82nykm1jos_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `rux82nykm1jos_assets`

1 × SELECT `session_id` 
  FROM `rux82nykm1jos_session`

1 × SELECT * 
  FROM rux82nykm1jos_languages

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM rux82nykm1jos_menu AS m 
  LEFT JOIN rux82nykm1jos_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `enabled` 
  FROM `rux82nykm1jos_extensions`

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM rux82nykm1jos_extensions

1 × SELECT b.id 
  FROM rux82nykm1jos_usergroups AS a 
  LEFT JOIN rux82nykm1jos_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `rux82nykm1jos_viewlevels

1 × SELECT *
    
  FROM rux82nykm1jos_modules

Autres tables :

1 × INSERT INTO `rux82nykm1jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('f6f16d48aeef7ce521fe17e670028ae3', 1, '1524735216', 0, '', 0

1 × UPDATE `rux82nykm1jos_extensions` 
  SET `params` = '{\"mediaversion\":\"f203af41101fa9e4342fac897eb1aebf\"}'

1 × UPDATE rux82nykm1jos_icagenda_events 
  SET hits = hits + 1