sliebridgeparis

Home

Erreur page 83 de l'agenda 2019-20

Erreur page 83 concernant deux épreuves 3e et 4e séries. Les bonnes dates sont :

PAIRES MIXTES 3e et 4e SÉRIES A 14H15

Finale D.L.I. 15/10

Lundi 21 et mardi 22 octobre à 14h15

PAIRES OPEN 3e et 4e SÉRIES A 9h45 ET 14H30

Finale D.L.I. 05/10

Vendredi 11 octobre à 9h45 et 14h30

Challenge du Comité 2018-19

La première page du classement du Challenge saison 2018-19 est disponible ci-contre :

Agenda du Comité de Paris 2019-2020

L'agenda du Comité de Paris saison 2019-2020 est disponible ci-contre : agenda 2019-20 et couverture 2019-20.

Championnat de France senior /4

Les finales nationales du senior open par quatre ont eu lieu jeudi 13 et vendredi 14 juin à la Fédération Française de Bridge. Carton plein pour Paris. En excellence, victoire d'Alain Coriat, de Michel Lebel, Michel Volcker, Serge Bergheimer, Simon Magnis et Philippe Soulet. Une seconde équipe parisienne composée de Sylvie Willard, Pascal Gombert, Patrick Dadoun et Gilles Maarek, monte sur la troisième marche du podium.

La promotion, copie conforme de l'excellence avec Paris 1er et 3e. Médaille d'or pour Luc Le Masne, Gérard Le Clerre, Odile Prugnaud et Henri Flikier. Quant à Jean et Françoise Rambaud, Michel Delaunay, Bernard Langlois, Jean-Marie Huot et Philippe Renard, ils terminent 3e. Bravo à toutes et tous.

Communiqué de presse FFB disponible ci-contre :

Eté 2019 au cercle Sembat bridge de Boulogne

Comme tous les ans, le cercle Sembat bridge de Boulogne-Billancourt reste ouvert tout l’été :

du 8 Juillet au 1^er Septembre,

tournois Ronde de France tous les jours, du lundi au samedi, à 14h.

Nous serons heureux d’accueillir tous les bridgeurs orphelins de la région parisienne. Que vous soyez seul ou en paire, pas besoin de vous inscrire à l’avance, vous pourrez jouer dans notre club :

Cercle Sembat Bridge

11, rue de Clamart - 92100 Boulogne-Billancourt

M° Marcel Sembat / Bus 42-123-126-175

Championnat de France senior mixte /4

Les finales nationales du senior mixte par quatre ont eu lieu à Saint-Cloud les 11 et 12 juin 2019. En excellence, l'équipe parisienne composée de Laurence Baco, Véronique Bessis, Alain Lévy et Bernard Laugier, termine sur la deuxième marche du podium derrière l'équipe de Basse-Normandie de Martine Rossard. L'équipe d'Hélène Zuccarelli (Côte d'Azur) est 3e. En promotion, les parisiens Jean-Daniel et Marie-Claude Weiss, Annie Rougeot et Martin Rembry sont Champions de France. Bravo à eux pour ce magnifique titre.

Plus d'articles...

12 3 4 »Fin

Le comité de Paris

Compétitions, renseignements, Inscription, Modifications, Scratch ...

benoit.deveze@yahoo.com

Calendrier

Juillet 2019

Partenaire

Prochaines épreuves fédérales

Prochaines épreuves de comité

Interclubs

15 Jui		Interclub D2 /4
11 Mai		Interclub D3 /4
11 Mai		Interclub D4 /4

Derniers résultats mis à jour

24 Jui		Coupe Claude Delmouly /2 S3 BRIDGE CLUB SAINT HONORE
25 Jui		Coupe de départ /2 S2 Groupe A
22 Jui		Espérance /2 S2 Groupe C
21 Jui		4 mixtes 2e séries /4 S1 COMITE DE PARIS
19 Jui		Coupe des 3e et 4e séries /2 S2 COMITE DE PARIS

Espace réservé aux clubs

Statistiques

Compteur d'affichages des articles: 3803188

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1563481612,
                "last": 1563481612,
                "now": 1563481612
            },
            "token": "sYbGmrRiENLNNaFKMtclBhWL75cebd0z"
        },
        "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
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 22.98 ms / 22.98 ms Mémoire: 1.788 MB / 2.00 MB Application: afterLoad

Temps: 83.47 ms / 106.44 ms Mémoire: 5.024 MB / 7.03 MB Application: afterInitialise

Temps: 24.25 ms / 130.69 ms Mémoire: 1.710 MB / 8.74 MB Application: afterRoute

Temps: 2.27 ms / 132.97 ms Mémoire: 0.065 MB / 8.80 MB Application: beforeRenderComponent com_content

Temps: 11.47 ms / 144.44 ms Mémoire: 1.073 MB / 9.87 MB Application: Before Access::preloadComponents (all components)

Temps: 0.90 ms / 145.33 ms Mémoire: 0.093 MB / 9.97 MB Application: After Access::preloadComponents (all components)

Temps: 0.06 ms / 145.40 ms Mémoire: 0.000 MB / 9.96 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Temps: 0.98 ms / 146.37 ms Mémoire: 0.046 MB / 10.01 MB Application: After Access::getAssetRules (id:8 name:com_content)

Temps: 50.04 ms / 196.42 ms Mémoire: 2.412 MB / 12.42 MB Application: afterRenderComponent com_content

Temps: 25.29 ms / 221.71 ms Mémoire: 1.305 MB / 13.72 MB Application: afterDispatch

Temps: 12.51 ms / 234.22 ms Mémoire: 0.522 MB / 14.25 MB Application: beforeRenderModule mod_custom (logo)

Temps: 2.92 ms / 237.14 ms Mémoire: 0.075 MB / 14.32 MB Application: afterRenderModule mod_custom (logo)

Temps: 1.16 ms / 238.29 ms Mémoire: 0.001 MB / 14.32 MB Application: beforeRenderModule mod_menu (Menu principal horizontal)

Temps: 23.67 ms / 261.96 ms Mémoire: 0.555 MB / 14.88 MB Application: afterRenderModule mod_menu (Menu principal horizontal)

Temps: 15.48 ms / 277.44 ms Mémoire: 0.246 MB / 15.12 MB Application: beforeRenderModule mod_custom (Venez vous entrainer)

Temps: 0.80 ms / 278.24 ms Mémoire: 0.007 MB / 15.13 MB Application: afterRenderModule mod_custom (Venez vous entrainer)

Temps: 1.72 ms / 279.96 ms Mémoire: 0.000 MB / 15.13 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 3.51 ms / 283.47 ms Mémoire: 0.077 MB / 15.20 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 1.70 ms / 285.17 ms Mémoire: 0.000 MB / 15.20 MB Application: beforeRenderModule mod_custom (Adresse mail Directeur des Tournois)

Temps: 0.76 ms / 285.93 ms Mémoire: 0.007 MB / 15.21 MB Application: afterRenderModule mod_custom (Adresse mail Directeur des Tournois)

Temps: 0.18 ms / 286.11 ms Mémoire: 0.002 MB / 15.21 MB Application: beforeRenderModule mod_bridgeresultats (Calendrier)

Temps: 7.35 ms / 293.46 ms Mémoire: 0.483 MB / 15.69 MB Application: afterRenderModule mod_bridgeresultats (Calendrier)

Temps: 0.14 ms / 293.60 ms Mémoire: 0.000 MB / 15.68 MB Application: beforeRenderModule mod_custom (Partenaire)

Temps: 0.62 ms / 294.22 ms Mémoire: 0.007 MB / 15.68 MB Application: afterRenderModule mod_custom (Partenaire)

Temps: 0.09 ms / 294.30 ms Mémoire: 0.000 MB / 15.68 MB Application: beforeRenderModule mod_widgetkit (Accordéon bridgeresultats)

Temps: 9.45 ms / 303.75 ms Mémoire: 0.629 MB / 16.31 MB Application: beforeRenderModule mod_bridgeresultats (Prochaines épreuves fédérales module)

Temps: 1.74 ms / 305.49 ms Mémoire: 0.139 MB / 16.45 MB Application: afterRenderModule mod_bridgeresultats (Prochaines épreuves fédérales module)

Temps: 0.13 ms / 305.62 ms Mémoire: 0.000 MB / 16.44 MB Application: beforeRenderModule mod_bridgeresultats (Prochaines épreuves comité module)

Temps: 1.34 ms / 306.96 ms Mémoire: 0.137 MB / 16.57 MB Application: afterRenderModule mod_bridgeresultats (Prochaines épreuves comité module)

Temps: 0.13 ms / 307.09 ms Mémoire: 0.000 MB / 16.56 MB Application: beforeRenderModule mod_bridgeresultats (Interclubs module)

Temps: 1.47 ms / 308.56 ms Mémoire: 0.151 MB / 16.71 MB Application: afterRenderModule mod_bridgeresultats (Interclubs module)

Temps: 0.14 ms / 308.70 ms Mémoire: 0.000 MB / 16.69 MB Application: beforeRenderModule mod_bridgeresultats (Derniers résultats module)

Temps: 4.85 ms / 313.55 ms Mémoire: 0.570 MB / 17.26 MB Application: afterRenderModule mod_bridgeresultats (Derniers résultats module)

Temps: 0.31 ms / 313.86 ms Mémoire: 0.000 MB / 17.19 MB Application: afterRenderModule mod_widgetkit (Accordéon bridgeresultats)

Temps: 0.13 ms / 313.99 ms Mémoire: 0.000 MB / 17.18 MB Application: beforeRenderModule mod_login (Espace réservé aux clubs)

Temps: 6.76 ms / 320.75 ms Mémoire: 0.354 MB / 17.54 MB Application: afterRenderModule mod_login (Espace réservé aux clubs)

Temps: 0.14 ms / 320.89 ms Mémoire: 0.000 MB / 17.53 MB Application: beforeRenderModule mod_stats (Statistiques)

Temps: 2.00 ms / 322.89 ms Mémoire: 0.073 MB / 17.60 MB Application: afterRenderModule mod_stats (Statistiques)

Temps: 4.26 ms / 327.15 ms Mémoire: 0.011 MB / 17.62 MB Application: beforeRenderModule mod_custom (Footer)

Temps: 0.74 ms / 327.88 ms Mémoire: 0.007 MB / 17.62 MB Application: afterRenderModule mod_custom (Footer)

Temps: 9.80 ms / 337.69 ms Mémoire: 0.199 MB / 17.82 MB Application: afterRender

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

Occupation de la mémoire

Requêtes de base de données

48 requêtes exécutées 21.25 ms

12 doubles découverts!

2 requêtes dupliquées: #26 #29

4 requêtes dupliquées: #27 #30 #33 #36

2 requêtes dupliquées: #32 #35

2 requêtes dupliquées: #44 #46

2 requêtes dupliquées: #45 #47

Temps de requête : 0.41 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.216 MB Rangées retournées : 0

SELECT `data`

  FROM `paris_session`

  WHERE `session_id` = '5a86e9e05ca685dd72211bd0cf98b8ec'

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 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.01 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
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:831
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
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:415
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.29 ms Après la dernière requête : 1.89 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.367 MB Rangées retournées : 0

SELECT `session_id`

  FROM `paris_session`

  WHERE `session_id` = '5a86e9e05ca685dd72211bd0cf98b8ec' 
  LIMIT 1

Explication

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.02 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.03 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 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.11 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:178
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
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:415
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.54 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.009 MB mémoire avant requête : 4.383 MB

INSERT INTO `paris_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('5a86e9e05ca685dd72211bd0cf98b8ec', 1, '1563481612', 0, '', 0)

Explication

EXPLAIN impossible sur la requête : INSERT INTO `paris_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('5a86e9e05ca685dd72211bd0cf98b8ec', 1, '1563481612', 0, '', 0)

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
update	0.06 ms
Waiting for query cache lock	0.00 ms
update	0.01 ms
end	0.01 ms
query end	0.32 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:218
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
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:415
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.67 ms Après la dernière requête : 4.52 ms Mémoire de requête : 0.019 MB mémoire avant requête : 4.708 MB Rangées retournées : 38

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

  FROM `paris_extensions`

  WHERE `type` = 'component'

Explication

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.21 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.01 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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:450
9	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:458
6	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:46
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:114
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:267
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.12 ms Après la dernière requête : 3.81 ms Mémoire de requête : 0.015 MB mémoire avant requête : 5.007 MB Rangées retournées : 7

SELECT id, rules

  FROM `paris_viewlevels`

Explication

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

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.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
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:267
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.09 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.015 MB mémoire avant requête : 5.032 MB Rangées retournées : 1

SELECT b.id

  FROM paris_usergroups AS a

  LEFT JOIN paris_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	11	Using index

Profil

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

Call Stack

#	Caller	File and line number
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:267
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.71 ms Après la dernière requête : 1.08 ms Mémoire de requête : 0.018 MB mémoire avant requête : 5.126 MB Rangées retournées : 75

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

  FROM paris_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	paris_extensions	ref	extension	extension	82	const	78	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.07 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.03 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.76 ms
Sending data	0.50 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.01 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

Call Stack

#	Caller	File and line number
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}()	Same as call in the line below.
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:267
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.87 ms Après la dernière requête : 45.30 ms Mémoire de requête : 0.040 MB mémoire avant requête : 7.345 MB Rangées retournées : 76

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 paris_menu AS m

  LEFT JOIN paris_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	1	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.m.component_id	1

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.08 ms
checking permissions	0.01 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.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.47 ms
Sending data	0.31 ms
Waiting for query cache lock	0.01 ms
Sending data	0.27 ms
Waiting for query cache lock	0.01 ms
Sending data	0.29 ms
end	0.01 ms
query end	0.01 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.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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}()	Same as call in the line below.
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:446
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:551
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:1146
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:267
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.72 ms Après la dernière requête : 14.63 ms Mémoire de requête : 0.025 MB mémoire avant requête : 8.426 MB Rangées retournées : 1

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

  FROM `paris_extensions`

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

Explication

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

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.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.24 ms
preparing	0.02 ms
executing	0.01 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.01 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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cssconfig/cssconfig.php:53
9	plgSystemCSSConfig->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1156
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:267
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 : 0.39 ms Mémoire de requête : 0.018 MB mémoire avant requête : 8.434 MB

UPDATE `paris_extensions`

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

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

Explication

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.14 ms
Updating	0.06 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.18 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cssconfig/cssconfig.php:53
9	plgSystemCSSConfig->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1156
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:267
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.12 ms Après la dernière requête : 3.24 ms Mémoire de requête : 0.014 MB mémoire avant requête : 8.757 MB Rangées retournées : 2

SELECT *

  FROM paris_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
starting	0.01 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.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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:267
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.61 ms Après la dernière requête : 0.71 ms Mémoire de requête : 0.010 MB mémoire avant requête : 8.790 MB Rangées retournées : 6

SELECT id, home, template, s.params

  FROM paris_template_styles as s

  LEFT JOIN paris_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	9	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	comites_paris2.s.template,const	1	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.01 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.03 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.13 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.01 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
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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:267
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.21 ms Après la dernière requête : 12.30 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.881 MB Rangées retournées : 36

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

  FROM `paris_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_bridgeresultats','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_generate_user','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_tags','com_templates','com_userport','com_users','com_weblinks','com_widgetkit','com_wrapper')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	paris_assets	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	243	Using where

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.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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_content/models/articles.php:114
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:54
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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 : 4.98 ms Après la dernière requête : 3.17 ms Mémoire de requête : 0.038 MB mémoire avant requête : 10.088 MB Rangées retournées : 10

SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM paris_content AS a

  LEFT JOIN paris_categories AS c 
  ON c.id = a.catid

  LEFT JOIN paris_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN paris_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN paris_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN paris_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-07-18 20:26:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-07-18 20:26:52')

  ORDER BY c.lft,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 10

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_state	1	const	36	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	comites_paris2.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.created_by	1
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.modified_by	1
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.c.parent_id	1
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.id	1

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.20 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.10 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.03 ms
Creating tmp table	0.60 ms
executing	0.01 ms
Copying to tmp table	2.59 ms
Sorting result	0.38 ms
Sending data	0.18 ms
Waiting for query cache lock	0.01 ms
Sending data	0.10 ms
end	0.01 ms
removing tmp table	0.33 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.09 ms Après la dernière requête : 5.99 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.635 MB Rangées retournées : 1

SELECT COUNT(*)

  FROM paris_content AS a

  LEFT JOIN paris_categories AS c 
  ON c.id = a.catid

  LEFT JOIN paris_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN paris_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN paris_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN paris_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-07-18 20:26:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-07-18 20:26:52')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_state	1	const	36	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	comites_paris2.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.created_by	1	Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.modified_by	1	Using index
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.c.parent_id	1	Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.id	1	Using index

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.44 ms
end	0.01 ms
query end	0.01 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.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.21 ms Après la dernière requête : 7.45 ms Mémoire de requête : 0.034 MB mémoire avant requête : 11.218 MB Rangées retournées : 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM paris_categories as c

  LEFT JOIN paris_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=11

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Utilisation du tri complet de type filesort
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	3	Using where

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.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.14 ms Après la dernière requête : 1.01 ms Mémoire de requête : 0.032 MB mémoire avant requête : 11.317 MB Rangées retournées : 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM paris_fields AS a

  LEFT JOIN `paris_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN paris_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN paris_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN paris_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN paris_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `paris_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (11,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	comites_paris2.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	comites_paris2.a.id	1	Using where; 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.00 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
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.58 ms Après la dernière requête : 28.84 ms Mémoire de requête : 0.021 MB mémoire avant requête : 12.527 MB Rangées retournées : 1

SELECT params 
  FROM paris_extensions AS e 
  WHERE e.element='com_widgetkit'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	402	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.05 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.04 ms
optimizing	0.01 ms
statistics	0.18 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 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.01 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.19 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:278
14	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
13	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
12	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
11	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
10	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
9	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
8	plgSystemWidgetkit_System->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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.09 ms Après la dernière requête : 0.87 ms Mémoire de requête : 0.016 MB mémoire avant requête : 12.551 MB Rangées retournées : 1

SELECT id,template 
  FROM paris_template_styles 
  WHERE client_id=0 
  AND home=1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	paris_template_styles	ALL	idx_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	9	Using where

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
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/system.php:78
10	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
9	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
8	plgSystemWidgetkit_System->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
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.18 ms Après la dernière requête : 26.07 ms Mémoire de requête : 0.028 MB mémoire avant requête : 14.058 MB Rangées retournées : 33

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

  FROM paris_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-07-18 20:26:52') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-07-18 20:26:52') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 237 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	range	PRIMARY,published,newsfeeds	published	6	NULL	29	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	comites_paris2.m.module,const	1	Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	comites_paris2.m.id	2	Using where; Using index

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.16 ms
Sending data	0.47 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.10 ms
storing result in query cache	0.07 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:49
11	ModulesWarpHelper->count()	JROOT/templates/yoo_sphere/layouts/template.config.php:23
10	include JROOT/templates/yoo_sphere/layouts/template.config.php	JROOT/templates/yoo_sphere/layouts/template.php:10
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.18 ms Après la dernière requête : 9.22 ms Mémoire de requête : 0.043 MB mémoire avant requête : 14.283 MB Rangées retournées : 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM paris_fields AS a

  LEFT JOIN `paris_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN paris_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN paris_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN paris_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN paris_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `paris_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'mod_custom.content' 
  AND (fc.category_id IS NULL OR fc.category_id IN (11,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	comites_paris2.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	comites_paris2.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	comites_paris2.a.id	1	Using where; Using index

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
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
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
24	PlgSystemFields->onContentPrepare()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
20	JHtmlContent::prepare()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
16	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:59
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.16 ms Après la dernière requête : 55.19 ms Mémoire de requête : 0.026 MB mémoire avant requête : 15.613 MB Rangées retournées : 1

select Ligue as ligue, Zone as zone 
  from eq57401.comites 
  where Comite = 'paris'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	comites	const	Ref	Ref	22	const	1

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.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
18	JDatabaseDriver->loadObject()	JROOT/modules/mod_bridgeresultats/helper.php:179
17	modBridgeresultatsHelper::calendrier()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
16	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.20 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.026 MB mémoire avant requête : 15.642 MB Rangées retournées : 0

(select c.Date as date, e.Libelle as epreuve, t.Libelle as tour 
  from `bridgeresultats_paris`.`paris_calendrier` as c      
  left join `bridgeresultats_paris`.`paris_epreuves` as e 
  on e.Ref = c.Epreuve      
  left join `bridgeresultats_paris`.`paris_tour` as t 
  on t.Ref = c.Tour 
  where c.Date >=  '2019-07-01' 
  and c.Date <= '2019-07-31') union (select c.Date as date, e.Libelle as epreuve, t.Libelle as tour 
  from `bridgeresultats_ligue12`.`ligue12_calendrier` as c      
  left join `bridgeresultats_ligue12`.`ligue12_epreuves` as e 
  on e.Ref = c.Epreuve      
  left join `bridgeresultats_ligue12`.`ligue12_tour` as t 
  on t.Ref = c.Tour 
  where c.Date >=  '2019-07-01' 
  and c.Date <= '2019-07-31') union (select c.Date as date, e.Libelle as epreuve, t.Libelle as tour 
  from `bridgeresultats_zone08`.`zone08_calendrier` as c      
  left join `bridgeresultats_zone08`.`zone08_epreuves` as e 
  on e.Ref = c.Epreuve      
  left join `bridgeresultats_zone08`.`zone08_tour` as t 
  on t.Ref = c.Tour 
  where c.Date >=  '2019-07-01' 
  and c.Date <= '2019-07-31')

Explication

EXPLAIN impossible sur la requête : (select c.Date as date, e.Libelle as epreuve, t.Libelle as tour from `bridgeresultats_paris`.`paris_calendrier` as c left join `bridgeresultats_paris`.`paris_epreuves` as e on e.Ref = c.Epreuve left join `bridgeresultats_paris`.`paris_tour` as t on t.Ref = c.Tour where c.Date >= '2019-07-01' and c.Date <= '2019-07-31') union (select c.Date as date, e.Libelle as epreuve, t.Libelle as tour from `bridgeresultats_ligue12`.`ligue12_calendrier` as c left join `bridgeresultats_ligue12`.`ligue12_epreuves` as e on e.Ref = c.Epreuve left join `bridgeresultats_ligue12`.`ligue12_tour` as t on t.Ref = c.Tour where c.Date >= '2019-07-01' and c.Date <= '2019-07-31') union (select c.Date as date, e.Libelle as epreuve, t.Libelle as tour from `bridgeresultats_zone08`.`zone08_calendrier` as c left join `bridgeresultats_zone08`.`zone08_epreuves` as e on e.Ref = c.Epreuve left join `bridgeresultats_zone08`.`zone08_tour` as t on t.Ref = c.Tour where c.Date >= '2019-07-01' and c.Date <= '2019-07-31')

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.00 ms
checking permissions	0.00 ms
checking permissions	0.01 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
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_bridgeresultats/helper.php:207
17	modBridgeresultatsHelper::calendrier()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
16	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.11 ms Après la dernière requête : 3.26 ms Mémoire de requête : 0.028 MB mémoire avant requête : 15.754 MB Rangées retournées : 1

SELECT * 
  FROM paris_widgetkit_widget 
  WHERE id=53

Explication

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

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.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:42
18	WidgetWidgetkitHelper->get()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:160
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.23 ms Après la dernière requête : 1.51 ms Mémoire de requête : 0.040 MB mémoire avant requête : 15.870 MB Rangées retournées : 30

SHOW FULL COLUMNS 
  FROM `paris_content`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `paris_content`

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
System lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.12 ms
closing tables	0.00 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
23	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
22	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:101
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.19 ms Après la dernière requête : 6.37 ms Mémoire de requête : 0.040 MB mémoire avant requête : 16.361 MB Rangées retournées : 1

Requêtes dupliquées: #29

select Ligue 
  from eq57401.comites 
  where Comite = 'paris'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	comites	const	Ref	Ref	22	const	1

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.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
31	JDatabaseDriver->loadResult()	JROOT/modules/mod_bridgeresultats/helper.php:327
30	modBridgeresultatsHelper::pef()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.10 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.401 MB Rangées retournées : 1

Requêtes dupliquées: #30 #33 #36

select Saison as saison, Annee1 as annee1, Annee2 as annee2, Mois as mois 
  from `bridgeresultats_paris`.`paris_saison` 
  where Saison = 20

Explication

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

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
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
31	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_bridgeresultats/helper.php:334
30	modBridgeresultatsHelper::pef()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.13 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.443 MB Rangées retournées : 0

(select min(calendrier.Date) as date, epreuves.Libelle as libelle, epreuves.Ref as epreuve,       calendrier.Description as description ,epreuves.Type as typepr, tour.Color as color, tour.Libelle as libtour  
  from `bridgeresultats_paris`.`paris_calendrier` as calendrier      
  left join `bridgeresultats_paris`.`paris_epreuves` as epreuves 
  on epreuves.Ref = calendrier.Epreuve      
  left join `bridgeresultats_paris`.`paris_tour` as tour 
  on tour.Ref = calendrier.Tour 
  where calendrier.Tour != 0 
  and Date >= '2019-07-18' 
  and epreuves.Ref < 1000 
  group by epreuves.Ref 
  order by date 
  limit 0, 5) union (select min(calendrier.Date) as date, epreuves.Libelle as libelle, epreuves.Ref as epreuve,       calendrier.Description as description ,epreuves.Type as typepr, tour.Color as color, tour.Libelle as libtour  
  from `bridgeresultats_ligue12`.`ligue12_calendrier` as calendrier      
  left join `bridgeresultats_ligue12`.`ligue12_epreuves` as epreuves 
  on epreuves.Ref = calendrier.Epreuve      
  left join `bridgeresultats_ligue12`.`ligue12_tour` as tour 
  on tour.Ref = calendrier.Tour 
  where calendrier.Tour != 0 
  and Date >= '2019-07-18' 
  and epreuves.Ref < 1000 
  group by epreuves.Ref 
  order by date 
  limit 0, 5) 
  order by 1 
  limit 0, 5

Explication

EXPLAIN impossible sur la requête : (select min(calendrier.Date) as date, epreuves.Libelle as libelle, epreuves.Ref as epreuve, calendrier.Description as description ,epreuves.Type as typepr, tour.Color as color, tour.Libelle as libtour from `bridgeresultats_paris`.`paris_calendrier` as calendrier left join `bridgeresultats_paris`.`paris_epreuves` as epreuves on epreuves.Ref = calendrier.Epreuve left join `bridgeresultats_paris`.`paris_tour` as tour on tour.Ref = calendrier.Tour where calendrier.Tour != 0 and Date >= '2019-07-18' and epreuves.Ref < 1000 group by epreuves.Ref order by date limit 0, 5) union (select min(calendrier.Date) as date, epreuves.Libelle as libelle, epreuves.Ref as epreuve, calendrier.Description as description ,epreuves.Type as typepr, tour.Color as color, tour.Libelle as libtour from `bridgeresultats_ligue12`.`ligue12_calendrier` as calendrier left join `bridgeresultats_ligue12`.`ligue12_epreuves` as epreuves on epreuves.Ref = calendrier.Epreuve left join `bridgeresultats_ligue12`.`ligue12_tour` as tour on tour.Ref = calendrier.Tour where calendrier.Tour != 0 and Date >= '2019-07-18' and epreuves.Ref < 1000 group by epreuves.Ref order by date limit 0, 5) order by 1 limit 0, 5

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
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	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

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
31	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_bridgeresultats/helper.php:345
30	modBridgeresultatsHelper::pef()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.09 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.040 MB mémoire avant requête : 16.486 MB Rangées retournées : 1

Requêtes dupliquées: #26

select Ligue 
  from eq57401.comites 
  where Comite = 'paris'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	comites	const	Ref	Ref	22	const	1

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
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
31	JDatabaseDriver->loadResult()	JROOT/modules/mod_bridgeresultats/helper.php:368
30	modBridgeresultatsHelper::pec()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.09 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.526 MB Rangées retournées : 1

Requêtes dupliquées: #27 #33 #36

select Saison as saison, Annee1 as annee1, Annee2 as annee2, Mois as mois 
  from `bridgeresultats_paris`.`paris_saison` 
  where Saison = 20

Explication

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

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
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
31	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_bridgeresultats/helper.php:375
30	modBridgeresultatsHelper::pec()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.11 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.569 MB Rangées retournées : 0

(select min(calendrier.Date) as date, epreuves.Libelle as libelle, epreuves.Ref as epreuve,       calendrier.Description as description ,epreuves.Type as typepr, tour.Color as color, tour.Libelle as libtour  
  from `bridgeresultats_paris`.`paris_calendrier` as calendrier      
  left join `bridgeresultats_paris`.`paris_epreuves` as epreuves 
  on epreuves.Ref = calendrier.Epreuve      
  left join `bridgeresultats_paris`.`paris_tour` as tour 
  on tour.Ref = calendrier.Tour 
  where epreuves.Ref >= 1000 
  and calendrier.Tour != 0 
  and Date >= '2019-07-18' 
  group by epreuves.Ref 
  order by date 
  limit 0, 5) union (select min(calendrier.Date) as date, epreuves.Libelle as libelle, epreuves.Ref as epreuve,       calendrier.Description as description ,epreuves.Type as typepr, tour.Color as color, tour.Libelle as libtour  
  from `bridgeresultats_ligue12`.`ligue12_calendrier` as calendrier      
  left join `bridgeresultats_ligue12`.`ligue12_epreuves` as epreuves 
  on epreuves.Ref = calendrier.Epreuve      
  left join `bridgeresultats_ligue12`.`ligue12_tour` as tour 
  on tour.Ref = calendrier.Tour 
  where calendrier.Tour != 0 
  and Date >= '2019-07-18' 
  and epreuves.Ref < 1000 
  group by epreuves.Ref 
  order by date 
  limit 0, 5) 
  order by 1 
  limit 0, 5

Explication

EXPLAIN impossible sur la requête : (select min(calendrier.Date) as date, epreuves.Libelle as libelle, epreuves.Ref as epreuve, calendrier.Description as description ,epreuves.Type as typepr, tour.Color as color, tour.Libelle as libtour from `bridgeresultats_paris`.`paris_calendrier` as calendrier left join `bridgeresultats_paris`.`paris_epreuves` as epreuves on epreuves.Ref = calendrier.Epreuve left join `bridgeresultats_paris`.`paris_tour` as tour on tour.Ref = calendrier.Tour where epreuves.Ref >= 1000 and calendrier.Tour != 0 and Date >= '2019-07-18' group by epreuves.Ref order by date limit 0, 5) union (select min(calendrier.Date) as date, epreuves.Libelle as libelle, epreuves.Ref as epreuve, calendrier.Description as description ,epreuves.Type as typepr, tour.Color as color, tour.Libelle as libtour from `bridgeresultats_ligue12`.`ligue12_calendrier` as calendrier left join `bridgeresultats_ligue12`.`ligue12_epreuves` as epreuves on epreuves.Ref = calendrier.Epreuve left join `bridgeresultats_ligue12`.`ligue12_tour` as tour on tour.Ref = calendrier.Tour where calendrier.Tour != 0 and Date >= '2019-07-18' and epreuves.Ref < 1000 group by epreuves.Ref order by date limit 0, 5) order by 1 limit 0, 5

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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
31	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_bridgeresultats/helper.php:386
30	modBridgeresultatsHelper::pec()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.09 ms Après la dernière requête : 0.81 ms Mémoire de requête : 0.040 MB mémoire avant requête : 16.610 MB Rangées retournées : 1

Requêtes dupliquées: #35

select Ligue as ligue, Zone as zone 
  from `eq57401`.`comites` 
  where Comite = 'paris'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	comites	const	Ref	Ref	22	const	1

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
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
31	JDatabaseDriver->loadObject()	JROOT/modules/mod_bridgeresultats/helper.php:650
30	modBridgeresultatsHelper::interclubs()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.09 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.651 MB Rangées retournées : 1

Requêtes dupliquées: #27 #30 #36

select Saison as saison, Annee1 as annee1, Annee2 as annee2, Mois as mois 
  from `bridgeresultats_paris`.`paris_saison` 
  where Saison = 20

Explication

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

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
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
31	JDatabaseDriver->loadObject()	JROOT/modules/mod_bridgeresultats/helper.php:659
30	modBridgeresultatsHelper::interclubs()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.16 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.043 MB mémoire avant requête : 16.697 MB Rangées retournées : 3

(SELECT max(c.Seance) as seance, c.Date as date, e.Libelle as epreuve, e.Type as type, c.url as url, t.Libelle as tour, t.Color as color,        c.Saison as annee, c.Epreuve as refepr, c.Tour as reftour, c.Groupe as groupe, 'paris' as base, c.Ref as cref, 'paris' as comite 
  FROM `bridgeresultats_paris`.`paris_calendrier` AS c RIGHT JOIN `bridgeresultats_paris`.`paris_lastupdate` AS u 
  ON u.Calendrier = c.Ref 
  LEFT JOIN `bridgeresultats_paris`.`paris_epreuves` as e 
  ON e.Ref = c.Epreuve 
  LEFT JOIN `bridgeresultats_paris`.`paris_tour` as t 
  on t.Ref = c.Tour 
  WHERE epreuve IN ( 71, 72, 73, 74 )  
  and c.Saison in (19, 20) 
  GROUP BY c.Saison, c.Epreuve, c.Tour 
  ORDER BY c.Date DESC 
  LIMIT 0,5) union (SELECT max(c.Seance) as seance, c.Date as date, e.Libelle as epreuve, e.Type as type, c.url as url, t.Libelle as tour, t.Color as color,        c.Saison as annee, c.Epreuve as refepr, c.Tour as reftour, c.Groupe as groupe, 'ligue12' as base, c.Ref as cref, 'paris' as comite 
  FROM `bridgeresultats_ligue12`.`ligue12_calendrier` AS c RIGHT JOIN `bridgeresultats_ligue12`.`ligue12_lastupdate` AS u 
  ON u.Calendrier = c.Ref 
  LEFT JOIN `bridgeresultats_ligue12`.`ligue12_epreuves` as e 
  ON e.Ref = c.Epreuve 
  LEFT JOIN `bridgeresultats_ligue12`.`ligue12_tour` as t 
  on t.Ref = c.Tour 
  WHERE epreuve IN ( 71, 72, 73, 74 )  
  and c.Saison in (19, 20) 
  GROUP BY c.Saison, c.Epreuve, c.Tour 
  ORDER BY c.Date DESC 
  LIMIT 0,5) union (SELECT max(c.Seance) as seance, c.Date as date, e.Libelle as epreuve, e.Type as type, c.url as url, t.Libelle as tour, t.Color as color,        c.Saison as annee, c.Epreuve as refepr, c.Tour as reftour, c.Groupe as groupe, '0000000' as base, c.Ref as cref, 'paris' as comite 
  FROM `bridgeresultats_0000000`.`0000000_calendrier` AS c RIGHT JOIN `bridgeresultats_0000000`.`0000000_lastupdate` AS u 
  ON u.Calendrier = c.Ref 
  LEFT JOIN `bridgeresultats_0000000`.`0000000_epreuves` as e 
  ON e.Ref = c.Epreuve 
  LEFT JOIN `bridgeresultats_0000000`.`0000000_tour` as t 
  on t.Ref = c.Tour 
  WHERE epreuve IN ( 71, 72, 73, 74 ) 
  and c.Saison in (19, 20) 
  GROUP BY c.Saison, c.Epreuve, c.Tour 
  ORDER BY c.Date DESC 
  LIMIT 0,5) 
  order by 2 desc, 3 
  limit 0,5

Explication

EXPLAIN impossible sur la requête : (SELECT max(c.Seance) as seance, c.Date as date, e.Libelle as epreuve, e.Type as type, c.url as url, t.Libelle as tour, t.Color as color, c.Saison as annee, c.Epreuve as refepr, c.Tour as reftour, c.Groupe as groupe, 'paris' as base, c.Ref as cref, 'paris' as comite FROM `bridgeresultats_paris`.`paris_calendrier` AS c RIGHT JOIN `bridgeresultats_paris`.`paris_lastupdate` AS u ON u.Calendrier = c.Ref LEFT JOIN `bridgeresultats_paris`.`paris_epreuves` as e ON e.Ref = c.Epreuve LEFT JOIN `bridgeresultats_paris`.`paris_tour` as t on t.Ref = c.Tour WHERE epreuve IN ( 71, 72, 73, 74 ) and c.Saison in (19, 20) GROUP BY c.Saison, c.Epreuve, c.Tour ORDER BY c.Date DESC LIMIT 0,5) union (SELECT max(c.Seance) as seance, c.Date as date, e.Libelle as epreuve, e.Type as type, c.url as url, t.Libelle as tour, t.Color as color, c.Saison as annee, c.Epreuve as refepr, c.Tour as reftour, c.Groupe as groupe, 'ligue12' as base, c.Ref as cref, 'paris' as comite FROM `bridgeresultats_ligue12`.`ligue12_calendrier` AS c RIGHT JOIN `bridgeresultats_ligue12`.`ligue12_lastupdate` AS u ON u.Calendrier = c.Ref LEFT JOIN `bridgeresultats_ligue12`.`ligue12_epreuves` as e ON e.Ref = c.Epreuve LEFT JOIN `bridgeresultats_ligue12`.`ligue12_tour` as t on t.Ref = c.Tour WHERE epreuve IN ( 71, 72, 73, 74 ) and c.Saison in (19, 20) GROUP BY c.Saison, c.Epreuve, c.Tour ORDER BY c.Date DESC LIMIT 0,5) union (SELECT max(c.Seance) as seance, c.Date as date, e.Libelle as epreuve, e.Type as type, c.url as url, t.Libelle as tour, t.Color as color, c.Saison as annee, c.Epreuve as refepr, c.Tour as reftour, c.Groupe as groupe, '0000000' as base, c.Ref as cref, 'paris' as comite FROM `bridgeresultats_0000000`.`0000000_calendrier` AS c RIGHT JOIN `bridgeresultats_0000000`.`0000000_lastupdate` AS u ON u.Calendrier = c.Ref LEFT JOIN `bridgeresultats_0000000`.`0000000_epreuves` as e ON e.Ref = c.Epreuve LEFT JOIN `bridgeresultats_0000000`.`0000000_tour` as t on t.Ref = c.Tour WHERE epreuve IN ( 71, 72, 73, 74 ) and c.Saison in (19, 20) GROUP BY c.Saison, c.Epreuve, c.Tour ORDER BY c.Date DESC LIMIT 0,5) order by 2 desc, 3 limit 0,5

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 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
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
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
31	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_bridgeresultats/helper.php:688
30	modBridgeresultatsHelper::interclubs()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.09 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.040 MB mémoire avant requête : 16.739 MB Rangées retournées : 1

Requêtes dupliquées: #32

select Ligue as ligue, Zone as zone 
  from `eq57401`.`comites` 
  where Comite = 'paris'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	comites	const	Ref	Ref	22	const	1

Profil

Status	Duration
starting	0.01 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.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
31	JDatabaseDriver->loadObject()	JROOT/modules/mod_bridgeresultats/helper.php:523
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.09 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.779 MB Rangées retournées : 1

Requêtes dupliquées: #27 #30 #33

select Saison as saison, Annee1 as annee1, Annee2 as annee2, Mois as mois 
  from `bridgeresultats_paris`.`paris_saison` 
  where Saison = 20

Explication

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

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
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
31	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_bridgeresultats/helper.php:530
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.18 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.044 MB mémoire avant requête : 16.827 MB Rangées retournées : 5

(select l1.Ref, l1.`Typepr` as type1, l1.`Typepr` as type, DATE(l1.Date) as date1, max(c1.Date) as date, t1.Color as color,         e1.Libelle as libepr, e1.Ref as refepr, e1.Type as typepr, t1.Libelle as libtour, max(c1.Seance) as seance,         c1.Groupe as groupe, t1.Ref as reftour, l1.url as url, 'paris' as base, c1.Saison as saison 
  from `bridgeresultats_paris`.`paris_lastupdate` as l1    
  left join `bridgeresultats_paris`.`paris_calendrier` as c1 
  on c1.Ref = l1.Calendrier   
  left join `bridgeresultats_paris`.`paris_epreuves` as e1 
  on e1.Ref = c1.Epreuve   
  left join `bridgeresultats_paris`.`paris_tour` as t1 
  on t1.Ref = c1.Tour 
  where 1  
  group by c1.Saison, c1.Epreuve, c1.Tour, c1.Groupe 
  order by max(c1.Date) desc 
  limit 0, 5)
 union 
(select l2.Ref, l2.`Typepr` as type1, l2.`Typepr` as type, DATE(l2.Date) as date1, max(c2.Date) as date, t2.Color as color,        e2.Libelle as libepr, e2.Ref as refepr, e2.Type as typepr, t2.Libelle as libtour, max(c2.Seance) as seance,        c2.Groupe as groupe, t2.Ref as reftour, l2.url as url, 'ligue12' as base, c2.Saison as saison 
  from `bridgeresultats_ligue12`.`ligue12_lastupdate` as l2    
  left join `bridgeresultats_ligue12`.`ligue12_calendrier` as c2 
  on c2.Ref = l2.Calendrier   
  left join `bridgeresultats_ligue12`.`ligue12_epreuves` as e2 
  on e2.Ref = c2.Epreuve   
  left join `bridgeresultats_ligue12`.`ligue12_tour` as t2 
  on t2.Ref = c2.Tour 
  where 1  
  group by c2.Saison, c2.Epreuve, c2.Tour, c2.Groupe 
  order by max(c2.Date) desc 
  limit 0, 5)
 union 
(select l3.Ref, l3.Typepr as type1, l3.`Typepr` as type, DATE(l3.Date) as date1, max(c3.Date) as date, t3.Color as color,        e3.Libelle as libepr, e3.Ref as refepr, e3.Type as typepr, t3.Libelle as libtour, max(c3.Seance) as seance,        c3.Groupe as groupe, t3.Ref as reftour, l3.url as url, 'zone08' as base, c3.Saison as saison 
  from `bridgeresultats_zone08`.`zone08_lastupdate` as l3    
  left join `bridgeresultats_zone08`.`zone08_calendrier` as c3 
  on c3.Ref = l3.Calendrier   
  left join `bridgeresultats_zone08`.`zone08_epreuves` as e3 
  on e3.Ref = c3.Epreuve   
  left join `bridgeresultats_zone08`.`zone08_tour` as t3 
  on t3.Ref =  c3.Tour 
  where 1  
  group by c3.Saison, c3.Epreuve, c3.Tour, c3.Groupe 
  order by max(c3.Date) desc 
  limit 0, 5)
 union 
(select l4.Ref, 100 as type1, l4.`Type` as type, DATE(l4.Date) as date1, max(c4.Date) as date, t4.Color as color,        concat(t4.Description,' ',e4.Libelle) as libepr, e4.Epreuve as refepr, e4.Type as typepr, '' as libtour,        max( c4.Seance ) as seance, t4.Annee as groupe, t4.Ref as reftour,'' as url, '' as base, '' as saison 
  from eq57401.lastupdate as l4    
  left join eq57401.calendrier as c4 
  on c4.Ref = l4.Calendrier    
  left join eq57401.epreuves as e4 
  on e4.Ref = c4.Epreuve    
  left join eq57401.tournois as t4 
  on t4.Ref = e4.Tournoi 
  and t4.Annee = e4.Annee 
  where l4.`Type` = 'paris'  
  group by e4.Ref 
  order by max(c4.Date) desc 
  limit 0,5) 
  order by 4 desc 
  limit 0,5

Explication

EXPLAIN impossible sur la requête : (select l1.Ref, l1.`Typepr` as type1, l1.`Typepr` as type, DATE(l1.Date) as date1, max(c1.Date) as date, t1.Color as color, e1.Libelle as libepr, e1.Ref as refepr, e1.Type as typepr, t1.Libelle as libtour, max(c1.Seance) as seance, c1.Groupe as groupe, t1.Ref as reftour, l1.url as url, 'paris' as base, c1.Saison as saison from `bridgeresultats_paris`.`paris_lastupdate` as l1 left join `bridgeresultats_paris`.`paris_calendrier` as c1 on c1.Ref = l1.Calendrier left join `bridgeresultats_paris`.`paris_epreuves` as e1 on e1.Ref = c1.Epreuve left join `bridgeresultats_paris`.`paris_tour` as t1 on t1.Ref = c1.Tour where 1 group by c1.Saison, c1.Epreuve, c1.Tour, c1.Groupe order by max(c1.Date) desc limit 0, 5) union (select l2.Ref, l2.`Typepr` as type1, l2.`Typepr` as type, DATE(l2.Date) as date1, max(c2.Date) as date, t2.Color as color, e2.Libelle as libepr, e2.Ref as refepr, e2.Type as typepr, t2.Libelle as libtour, max(c2.Seance) as seance, c2.Groupe as groupe, t2.Ref as reftour, l2.url as url, 'ligue12' as base, c2.Saison as saison from `bridgeresultats_ligue12`.`ligue12_lastupdate` as l2 left join `bridgeresultats_ligue12`.`ligue12_calendrier` as c2 on c2.Ref = l2.Calendrier left join `bridgeresultats_ligue12`.`ligue12_epreuves` as e2 on e2.Ref = c2.Epreuve left join `bridgeresultats_ligue12`.`ligue12_tour` as t2 on t2.Ref = c2.Tour where 1 group by c2.Saison, c2.Epreuve, c2.Tour, c2.Groupe order by max(c2.Date) desc limit 0, 5) union (select l3.Ref, l3.Typepr as type1, l3.`Typepr` as type, DATE(l3.Date) as date1, max(c3.Date) as date, t3.Color as color, e3.Libelle as libepr, e3.Ref as refepr, e3.Type as typepr, t3.Libelle as libtour, max(c3.Seance) as seance, c3.Groupe as groupe, t3.Ref as reftour, l3.url as url, 'zone08' as base, c3.Saison as saison from `bridgeresultats_zone08`.`zone08_lastupdate` as l3 left join `bridgeresultats_zone08`.`zone08_calendrier` as c3 on c3.Ref = l3.Calendrier left join `bridgeresultats_zone08`.`zone08_epreuves` as e3 on e3.Ref = c3.Epreuve left join `bridgeresultats_zone08`.`zone08_tour` as t3 on t3.Ref = c3.Tour where 1 group by c3.Saison, c3.Epreuve, c3.Tour, c3.Groupe order by max(c3.Date) desc limit 0, 5) union (select l4.Ref, 100 as type1, l4.`Type` as type, DATE(l4.Date) as date1, max(c4.Date) as date, t4.Color as color, concat(t4.Description,' ',e4.Libelle) as libepr, e4.Epreuve as refepr, e4.Type as typepr, '' as libtour, max( c4.Seance ) as seance, t4.Annee as groupe, t4.Ref as reftour,'' as url, '' as base, '' as saison from eq57401.lastupdate as l4 left join eq57401.calendrier as c4 on c4.Ref = l4.Calendrier left join eq57401.epreuves as e4 on e4.Ref = c4.Epreuve left join eq57401.tournois as t4 on t4.Ref = e4.Tournoi and t4.Annee = e4.Annee where l4.`Type` = 'paris' group by e4.Ref order by max(c4.Date) desc limit 0,5) order by 4 desc limit 0,5

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 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
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
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
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
31	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_bridgeresultats/helper.php:601
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.09 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.042 MB mémoire avant requête : 16.883 MB Rangées retournées : 0

select Club as club, Lieu as lieu 
  from `bridgeresultats_paris`.`paris_groupes` 
  where Ref = '5000082'

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.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
32	JDatabaseDriver->loadObject()	JROOT/modules/mod_bridgeresultats/helper.php:813
31	modBridgeresultatsHelper::libgroupe()	JROOT/modules/mod_bridgeresultats/helper.php:614
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.09 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.042 MB mémoire avant requête : 16.924 MB Rangées retournées : 1

select Nom 
  from `bridgeresultats_paris`.`paris_clubs` 
  where Ref = '5000082'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	paris_clubs	const	PRIMARY	PRIMARY	12	const	1

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.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
32	JDatabaseDriver->loadResult()	JROOT/modules/mod_bridgeresultats/helper.php:827
31	modBridgeresultatsHelper::libgroupe()	JROOT/modules/mod_bridgeresultats/helper.php:614
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.08 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.042 MB mémoire avant requête : 16.966 MB Rangées retournées : 0

select Club as club, Lieu as lieu 
  from `bridgeresultats_paris`.`paris_groupes` 
  where Ref = '50999'

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.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
32	JDatabaseDriver->loadObject()	JROOT/modules/mod_bridgeresultats/helper.php:813
31	modBridgeresultatsHelper::libgroupe()	JROOT/modules/mod_bridgeresultats/helper.php:614
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.15 ms Mémoire de requête : 0.042 MB mémoire avant requête : 17.007 MB Rangées retournées : 1

select Nom 
  from `bridgeresultats_paris`.`paris_clubs` 
  where Ref = '50999'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	paris_clubs	const	PRIMARY	PRIMARY	12	const	1

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
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
32	JDatabaseDriver->loadResult()	JROOT/modules/mod_bridgeresultats/helper.php:827
31	modBridgeresultatsHelper::libgroupe()	JROOT/modules/mod_bridgeresultats/helper.php:614
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.08 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.042 MB mémoire avant requête : 17.049 MB Rangées retournées : 0

select Club as club, Lieu as lieu 
  from `bridgeresultats_paris`.`paris_groupes` 
  where Ref = '50997'

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.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
32	JDatabaseDriver->loadObject()	JROOT/modules/mod_bridgeresultats/helper.php:813
31	modBridgeresultatsHelper::libgroupe()	JROOT/modules/mod_bridgeresultats/helper.php:614
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.08 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.042 MB mémoire avant requête : 17.090 MB Rangées retournées : 1

select Nom 
  from `bridgeresultats_paris`.`paris_clubs` 
  where Ref = '50997'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	paris_clubs	const	PRIMARY	PRIMARY	12	const	1

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
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
32	JDatabaseDriver->loadResult()	JROOT/modules/mod_bridgeresultats/helper.php:827
31	modBridgeresultatsHelper::libgroupe()	JROOT/modules/mod_bridgeresultats/helper.php:614
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.27 ms Mémoire de requête : 0.042 MB mémoire avant requête : 17.132 MB Rangées retournées : 0

Requêtes dupliquées: #46

select Club as club, Lieu as lieu 
  from `bridgeresultats_paris`.`paris_groupes` 
  where Ref = '5000000'

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.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
32	JDatabaseDriver->loadObject()	JROOT/modules/mod_bridgeresultats/helper.php:813
31	modBridgeresultatsHelper::libgroupe()	JROOT/modules/mod_bridgeresultats/helper.php:614
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.08 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.042 MB mémoire avant requête : 17.172 MB Rangées retournées : 1

Requêtes dupliquées: #47

select Nom 
  from `bridgeresultats_paris`.`paris_clubs` 
  where Ref = '5000000'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	paris_clubs	const	PRIMARY	PRIMARY	12	const	1

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
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
32	JDatabaseDriver->loadResult()	JROOT/modules/mod_bridgeresultats/helper.php:827
31	modBridgeresultatsHelper::libgroupe()	JROOT/modules/mod_bridgeresultats/helper.php:614
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.08 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.042 MB mémoire avant requête : 17.214 MB Rangées retournées : 0

Requêtes dupliquées: #44

select Club as club, Lieu as lieu 
  from `bridgeresultats_paris`.`paris_groupes` 
  where Ref = '5000000'

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.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
32	JDatabaseDriver->loadObject()	JROOT/modules/mod_bridgeresultats/helper.php:813
31	modBridgeresultatsHelper::libgroupe()	JROOT/modules/mod_bridgeresultats/helper.php:614
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.10 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.042 MB mémoire avant requête : 17.255 MB Rangées retournées : 1

Requêtes dupliquées: #45

select Nom 
  from `bridgeresultats_paris`.`paris_clubs` 
  where Ref = '5000000'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	paris_clubs	const	PRIMARY	PRIMARY	12	const	1

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
sending cached result to clien	0.01 ms
logging slow query	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
32	JDatabaseDriver->loadResult()	JROOT/modules/mod_bridgeresultats/helper.php:827
31	modBridgeresultatsHelper::libgroupe()	JROOT/modules/mod_bridgeresultats/helper.php:614
30	modBridgeresultatsHelper::commaj()	JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php:37
29	include JROOT/modules/mod_bridgeresultats/mod_bridgeresultats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
27	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:143
26	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
25	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:105
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
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.32 ms Après la dernière requête : 9.09 ms Mémoire de requête : 0.026 MB mémoire avant requête : 17.598 MB Rangées retournées : 1

SELECT SUM(hits) AS count_hits

  FROM paris_content

  WHERE state = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	paris_content	ref	idx_state	idx_state	1	const	36

Profil

Status	Duration
starting	0.17 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.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
18	JDatabaseDriver->loadResult()	JROOT/modules/mod_stats/helper.php:129
17	ModStatsHelper::getList()	JROOT/modules/mod_stats/mod_stats.php:17
16	include JROOT/modules/mod_stats/mod_stats.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_sphere/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_sphere/layouts/template.php:126
9	include JROOT/templates/yoo_sphere/layouts/template.php	JROOT/templates/yoo_sphere/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_sphere/index.php:21
7	require JROOT/templates/yoo_sphere/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:1103
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:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

32 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

5 × select Club as club, Lieu as lieu 
  from `bridgeresultats_paris`.`paris_groupes`

5 × select Nom 
  from `bridgeresultats_paris`.`paris_clubs`

4 × select Saison as saison, Annee1 as annee1, Annee2 as annee2, Mois as mois 
  from `bridgeresultats_paris`.`paris_saison`

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

2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM paris_fields AS a 
  LEFT JOIN `paris_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN paris_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN paris_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN paris_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN paris_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `paris_fields_categories` AS fc 
  ON fc.field_id = a.id

2 × select Ligue 
  from eq57401.comites

2 × select Ligue as ligue, Zone as zone 
  from `eq57401`.`comites`

1 × SELECT id,template 
  FROM paris_template_styles

1 × SELECT params 
  FROM paris_extensions AS e

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

1 × select Ligue as ligue, Zone as zone 
  from eq57401.comites

1 × SELECT SUM(hits) AS count_hits 
  FROM paris_content

1 × SELECT * 
  FROM paris_widgetkit_widget

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM paris_categories as c 
  LEFT JOIN paris_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

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

1 × SELECT id, rules 
  FROM `paris_viewlevels

1 × SELECT `session_id` 
  FROM `paris_session`

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 paris_menu AS m 
  LEFT JOIN paris_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM paris_languages
```

1 × SELECT COUNT(*) 
  FROM paris_content AS a 
  LEFT JOIN paris_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN paris_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN paris_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN paris_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN paris_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,         COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM paris_content AS a 
  LEFT JOIN paris_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN paris_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN paris_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN paris_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN paris_content_rating AS v 
  ON a.id = v.content_id

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

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

1 × SELECT `data` 
  FROM `paris_session`

Autres tables :

2 × (select min(calendrier.Date) as date, epreuves.Libelle as libelle, epreuves.Ref as epreuve,       calendrier.Description as description ,epreuves.Type as typepr, tour.Color as color, tour.Libelle as libtour  
  from `bridgeresultats_paris`.`paris_calendrier` as calendrier      
  left join `bridgeresultats_paris`.`paris_epreuves` as epreuves 
  on epreuves.Ref = calendrier.Epreuve      
  left join `bridgeresultats_paris`.`paris_tour` as tour 
  on tour.Ref = calendrier.Tour

1 × (SELECT max(c.Seance) as seance, c.Date as date, e.Libelle as epreuve, e.Type as type, c.url as url, t.Libelle as tour, t.Color as color,        c.Saison as annee, c.Epreuve as refepr, c.Tour as reftour, c.Groupe as groupe, 'paris' as base, c.Ref as cref, 'paris' as comite 
  FROM `bridgeresultats_paris`.`paris_calendrier` AS c RIGHT JOIN `bridgeresultats_paris`.`paris_lastupdate` AS u 
  ON u.Calendrier = c.Ref 
  LEFT JOIN `bridgeresultats_paris`.`paris_epreuves` as e 
  ON e.Ref = c.Epreuve 
  LEFT JOIN `bridgeresultats_paris`.`paris_tour` as t 
  on t.Ref = c.Tour

1 × (select l1.Ref, l1.`Typepr` as type1, l1.`Typepr` as type, DATE(l1.Date) as date1, max(c1.Date) as date, t1.Color as color,         e1.Libelle as libepr, e1.Ref as refepr, e1.Type as typepr, t1.Libelle as libtour, max(c1.Seance) as seance,         c1.Groupe as groupe, t1.Ref as reftour, l1.url as url, 'paris' as base, c1.Saison as saison 
  from `bridgeresultats_paris`.`paris_lastupdate` as l1    
  left join `bridgeresultats_paris`.`paris_calendrier` as c1 
  on c1.Ref = l1.Calendrier   
  left join `bridgeresultats_paris`.`paris_epreuves` as e1 
  on e1.Ref = c1.Epreuve   
  left join `bridgeresultats_paris`.`paris_tour` as t1 
  on t1.Ref = c1.Tour

1 × SHOW FULL COLUMNS 
  FROM `paris_content

1 × UPDATE `paris_extensions` 
  SET `params` = '{\"mediaversion\":\"aaa9c16eda363086a0fa3cc510a8df20\"}'

1 × (select c.Date as date, e.Libelle as epreuve, t.Libelle as tour 
  from `bridgeresultats_paris`.`paris_calendrier` as c      
  left join `bridgeresultats_paris`.`paris_epreuves` as e 
  on e.Ref = c.Epreuve      
  left join `bridgeresultats_paris`.`paris_tour` as t 
  on t.Ref = c.Tour

1 × INSERT INTO `paris_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('5a86e9e05ca685dd72211bd0cf98b8ec', 1, '1563481612', 0, '', 0