sliebridgeparis

Home

Championnat de France Promotion par quatre

Victoire parisienne lors de la finale nationale de l'open promotion /4 samedi 9 et dimanche 10 février à Saint-Cloud. Salomé Montini, Camille Sauvain, Axel Bacher, Louis Dubrule, Junkang Li, Enguérand Petit et Julien Moussou, étudiants à l'Ecole Normale Supérieure, remportent le titre de Champion de France de la catégorie. Le Comité de Paris, à l'origine de ce club créé au sein de l'école de la rue d'Ulm, est particulièrement heureux de cette réussite. Bravo et merci à notre internationale française Jennifer Mourgues, la prof de bridge de ces sympathiques jeunes bridgeurs.

Communiqué de presse FFB :

Division Nationale Mixte /2

Véronique et Thomas Bessis s'adjugent un 4e titre depuis 2008 en DN mixte /2. Le podium est complété par Sylvie Willard et Philippe Soulet sur la deuxième marche, et la paire Carole Puillet-Simon Poulat, médaille de bronze.

Coupe Epsilon du 24 octobre 2018

La 5e édition de la Coupe Epsilon a eu lieu le 24 octobre 2018 au Manège du Paris Country Club :

Les photos de l'événement sont dans le diaporama.

Voici les résultats de la Coupe Epsilon :

Elections FFB : nouvelle équipe

La liste menée par Patrick Bogacki a été élue vendredi 26 octobre, lors de l’Assemblée Générale qui désignait le Président de la FFB et son équipe, au siège de la Fédération Française de Bridge, à Saint-Cloud.

Deux listes étaient candidates :

La liste de Patrick Bogacki (Sylviane Becker, David Harari, Martine Marié, Emmanuelle Monod, Serge Plasterie, Franck Riehm, Eve Scheltens et Jean-Claude Thuillier) a obtenu 53,67%.

La liste de Bernard Dauvergne (Anne-Elisabeth Celli, Jean-Louis Counil, Anne Dumortier, Olivier Grosjean, Solweig Henry, Jean-Jacques Merret, Michèle Rouanet Labé et Alain Verdier) a obtenu 46.33%.

Palmarès 2017 - 2018 : champions de Paris

Ci-joint le palmarès complet des champions de Paris 2017 - 2018 :

Début «1 2 34

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: 3803278

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1563631199,
                "last": 1563631199,
                "now": 1563631199
            },
            "token": "d9vpo0qAJuzNkNQG1sbjjvEKAcTTTyPS"
        },
        "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: 27.81 ms / 27.81 ms Mémoire: 1.788 MB / 2.00 MB Application: afterLoad

Temps: 93.96 ms / 121.77 ms Mémoire: 5.033 MB / 7.04 MB Application: afterInitialise

Temps: 23.59 ms / 145.36 ms Mémoire: 1.710 MB / 8.75 MB Application: afterRoute

Temps: 4.79 ms / 150.15 ms Mémoire: 0.065 MB / 8.81 MB Application: beforeRenderComponent com_content

Temps: 16.36 ms / 166.51 ms Mémoire: 1.073 MB / 9.88 MB Application: Before Access::preloadComponents (all components)

Temps: 1.38 ms / 167.89 ms Mémoire: 0.093 MB / 9.98 MB Application: After Access::preloadComponents (all components)

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

Temps: 1.03 ms / 168.98 ms Mémoire: 0.046 MB / 10.02 MB Application: After Access::getAssetRules (id:8 name:com_content)

Temps: 56.08 ms / 225.06 ms Mémoire: 2.253 MB / 12.27 MB Application: afterRenderComponent com_content

Temps: 28.49 ms / 253.55 ms Mémoire: 1.305 MB / 13.58 MB Application: afterDispatch

Temps: 13.43 ms / 266.98 ms Mémoire: 0.522 MB / 14.10 MB Application: beforeRenderModule mod_custom (logo)

Temps: 2.49 ms / 269.47 ms Mémoire: 0.075 MB / 14.17 MB Application: afterRenderModule mod_custom (logo)

Temps: 1.39 ms / 270.86 ms Mémoire: 0.001 MB / 14.17 MB Application: beforeRenderModule mod_menu (Menu principal horizontal)

Temps: 26.17 ms / 297.03 ms Mémoire: 0.555 MB / 14.73 MB Application: afterRenderModule mod_menu (Menu principal horizontal)

Temps: 14.95 ms / 311.98 ms Mémoire: 0.246 MB / 14.97 MB Application: beforeRenderModule mod_custom (Venez vous entrainer)

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

Temps: 1.53 ms / 314.31 ms Mémoire: 0.000 MB / 14.98 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 2.78 ms / 317.09 ms Mémoire: 0.077 MB / 15.06 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 1.25 ms / 318.34 ms Mémoire: 0.000 MB / 15.05 MB Application: beforeRenderModule mod_custom (Adresse mail Directeur des Tournois)

Temps: 0.53 ms / 318.87 ms Mémoire: 0.007 MB / 15.06 MB Application: afterRenderModule mod_custom (Adresse mail Directeur des Tournois)

Temps: 0.12 ms / 318.98 ms Mémoire: 0.002 MB / 15.06 MB Application: beforeRenderModule mod_bridgeresultats (Calendrier)

Temps: 6.08 ms / 325.06 ms Mémoire: 0.483 MB / 15.55 MB Application: afterRenderModule mod_bridgeresultats (Calendrier)

Temps: 0.16 ms / 325.23 ms Mémoire: 0.000 MB / 15.53 MB Application: beforeRenderModule mod_custom (Partenaire)

Temps: 0.64 ms / 325.87 ms Mémoire: 0.007 MB / 15.54 MB Application: afterRenderModule mod_custom (Partenaire)

Temps: 0.08 ms / 325.95 ms Mémoire: 0.000 MB / 15.53 MB Application: beforeRenderModule mod_widgetkit (Accordéon bridgeresultats)

Temps: 11.06 ms / 337.01 ms Mémoire: 0.629 MB / 16.16 MB Application: beforeRenderModule mod_bridgeresultats (Prochaines épreuves fédérales module)

Temps: 1.72 ms / 338.73 ms Mémoire: 0.139 MB / 16.30 MB Application: afterRenderModule mod_bridgeresultats (Prochaines épreuves fédérales module)

Temps: 0.17 ms / 338.90 ms Mémoire: 0.000 MB / 16.29 MB Application: beforeRenderModule mod_bridgeresultats (Prochaines épreuves comité module)

Temps: 1.26 ms / 340.15 ms Mémoire: 0.137 MB / 16.43 MB Application: afterRenderModule mod_bridgeresultats (Prochaines épreuves comité module)

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

Temps: 1.59 ms / 341.87 ms Mémoire: 0.151 MB / 16.56 MB Application: afterRenderModule mod_bridgeresultats (Interclubs module)

Temps: 0.20 ms / 342.07 ms Mémoire: 0.000 MB / 16.54 MB Application: beforeRenderModule mod_bridgeresultats (Derniers résultats module)

Temps: 4.93 ms / 347.01 ms Mémoire: 0.570 MB / 17.11 MB Application: afterRenderModule mod_bridgeresultats (Derniers résultats module)

Temps: 0.35 ms / 347.35 ms Mémoire: 0.000 MB / 17.04 MB Application: afterRenderModule mod_widgetkit (Accordéon bridgeresultats)

Temps: 0.14 ms / 347.50 ms Mémoire: 0.000 MB / 17.03 MB Application: beforeRenderModule mod_login (Espace réservé aux clubs)

Temps: 7.81 ms / 355.31 ms Mémoire: 0.354 MB / 17.39 MB Application: afterRenderModule mod_login (Espace réservé aux clubs)

Temps: 0.15 ms / 355.45 ms Mémoire: 0.000 MB / 17.38 MB Application: beforeRenderModule mod_stats (Statistiques)

Temps: 2.03 ms / 357.49 ms Mémoire: 0.073 MB / 17.46 MB Application: afterRenderModule mod_stats (Statistiques)

Temps: 4.21 ms / 361.70 ms Mémoire: 0.011 MB / 17.47 MB Application: beforeRenderModule mod_custom (Footer)

Temps: 0.99 ms / 362.69 ms Mémoire: 0.007 MB / 17.47 MB Application: afterRenderModule mod_custom (Footer)

Temps: 10.26 ms / 372.95 ms Mémoire: 0.195 MB / 17.67 MB Application: afterRender

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

Occupation de la mémoire

Requêtes de base de données

49 requêtes exécutées 19.72 ms

12 doubles découverts!

2 requêtes dupliquées: #27 #30

4 requêtes dupliquées: #28 #31 #34 #37

2 requêtes dupliquées: #33 #36

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

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

Temps de requête : 0.35 ms Mémoire de requête : 0.008 MB mémoire avant requête : 4.197 MB

DELETE 

  FROM `paris_session`

  WHERE `time` < '1563630299'

Explication

EXPLAIN impossible sur la requête : DELETE FROM `paris_session` WHERE `time` < '1563630299'

Profil

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:824
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 : 0.59 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.228 MB Rangées retournées : 0

SELECT `data`

  FROM `paris_session`

  WHERE `session_id` = 'e90184d4a23ece3d49741679bd6e6813'

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.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 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.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.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.30 ms Après la dernière requête : 2.12 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.380 MB Rangées retournées : 0

SELECT `session_id`

  FROM `paris_session`

  WHERE `session_id` = 'e90184d4a23ece3d49741679bd6e6813' 
  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.00 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.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.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.01 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.69 ms Après la dernière requête : 0.60 ms Mémoire de requête : 0.009 MB mémoire avant requête : 4.395 MB

INSERT INTO `paris_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('e90184d4a23ece3d49741679bd6e6813', 1, '1563631199', 0, '', 0)

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
update	0.07 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	0.43 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 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.19 ms Après la dernière requête : 5.58 ms Mémoire de requête : 0.019 MB mémoire avant requête : 4.718 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.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.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: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 : 4.40 ms Mémoire de requête : 0.015 MB mémoire avant requête : 5.017 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.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
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.042 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.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
sending cached result to clien	0.02 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: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 : 0.13 ms Après la dernière requête : 1.45 ms Mémoire de requête : 0.018 MB mémoire avant requête : 5.136 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.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.02 ms
logging slow query	0.01 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 : 0.38 ms Après la dernière requête : 48.56 ms Mémoire de requête : 0.040 MB mémoire avant requête : 7.355 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.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 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()	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.17 ms Après la dernière requête : 14.65 ms Mémoire de requête : 0.025 MB mémoire avant requête : 8.437 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.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.02 ms
logging slow query	0.01 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.70 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.018 MB mémoire avant requête : 8.444 MB

UPDATE `paris_extensions`

  SET `params` = '{\"mediaversion\":\"3a17dffb0f20e69564b4acb8048d2c96\"}'

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

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.22 ms
Updating	0.08 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.22 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.01 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.34 ms Après la dernière requête : 4.21 ms Mémoire de requête : 0.014 MB mémoire avant requête : 8.767 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.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.01 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.67 ms Après la dernière requête : 1.68 ms Mémoire de requête : 0.010 MB mémoire avant requête : 8.800 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.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 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.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.22 ms Après la dernière requête : 18.06 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.891 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 : 6.48 ms Après la dernière requête : 3.98 ms Mémoire de requête : 0.036 MB mémoire avant requête : 10.097 MB Rangées retournées : 5

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-20 13:59:59') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-07-20 13:59:59')

  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 18, 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.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.27 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.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.05 ms
init	0.14 ms
optimizing	0.03 ms
statistics	0.21 ms
preparing	0.04 ms
Creating tmp table	0.60 ms
executing	0.01 ms
Copying to tmp table	3.17 ms
Sorting result	0.39 ms
Sending data	0.44 ms
end	0.01 ms
removing tmp table	0.47 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.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.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 : 0.99 ms Après la dernière requête : 6.13 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.505 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-20 13:59:59') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-07-20 13:59:59')

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.01 ms
checking query cache for query	0.09 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.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.43 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.12 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/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 : 10.19 ms Mémoire de requête : 0.034 MB mémoire avant requête : 11.088 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.00 ms
checking permissions	0.01 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
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.25 ms Après la dernière requête : 1.07 ms Mémoire de requête : 0.032 MB mémoire avant requête : 11.187 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.01 ms
sending cached result to clien	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 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.47 ms Après la dernière requête : 29.97 ms Mémoire de requête : 0.021 MB mémoire avant requête : 12.378 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.02 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 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.13 ms
logging slow query	0.01 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.15 ms Après la dernière requête : 0.94 ms Mémoire de requête : 0.016 MB mémoire avant requête : 12.402 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.45 ms Après la dernière requête : 29.46 ms Mémoire de requête : 0.028 MB mémoire avant requête : 13.909 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-20 13:59:59') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-07-20 13:59:59') 
  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.01 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.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.16 ms
Sending data	0.68 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.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.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.22 ms Après la dernière requête : 9.38 ms Mémoire de requête : 0.043 MB mémoire avant requête : 14.135 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.01 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
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
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.14 ms Après la dernière requête : 54.32 ms Mémoire de requête : 0.026 MB mémoire avant requête : 15.465 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.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
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.16 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.026 MB mémoire avant requête : 15.494 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.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
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	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.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.66 ms Mémoire de requête : 0.028 MB mémoire avant requête : 15.606 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.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.01 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.77 ms Après la dernière requête : 1.73 ms Mémoire de requête : 0.040 MB mémoire avant requête : 15.722 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.04 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
System lock	0.01 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.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.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.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.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Sending data	0.41 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.20 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.01 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.13 ms Après la dernière requête : 7.02 ms Mémoire de requête : 0.040 MB mémoire avant requête : 16.213 MB Rangées retournées : 1

Requêtes dupliquées: #30

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.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: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.16 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.253 MB Rangées retournées : 1

Requêtes dupliquées: #31 #34 #37

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.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: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.18 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.295 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-20' 
  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-20' 
  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-20' 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-20' 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.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.94 ms Mémoire de requête : 0.040 MB mémoire avant requête : 16.338 MB Rangées retournées : 1

Requêtes dupliquées: #27

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.14 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.378 MB Rangées retournées : 1

Requêtes dupliquées: #28 #34 #37

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.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.12 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.421 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-20' 
  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-20' 
  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-20' 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-20' 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.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: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.10 ms Après la dernière requête : 0.77 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.463 MB Rangées retournées : 1

Requêtes dupliquées: #36

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.15 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.503 MB Rangées retournées : 1

Requêtes dupliquées: #28 #31 #37

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.21 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: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.24 ms Mémoire de requête : 0.043 MB mémoire avant requête : 16.549 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.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
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.12 ms Après la dernière requête : 1.28 ms Mémoire de requête : 0.040 MB mémoire avant requête : 16.591 MB Rangées retournées : 1

Requêtes dupliquées: #33

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.15 ms Mémoire de requête : 0.041 MB mémoire avant requête : 16.631 MB Rangées retournées : 1

Requêtes dupliquées: #28 #31 #34

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.26 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.044 MB mémoire avant requête : 16.679 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.01 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	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.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.13 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.042 MB mémoire avant requête : 16.735 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.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.01 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.12 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.042 MB mémoire avant requête : 16.776 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.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
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.09 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.042 MB mémoire avant requête : 16.818 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.12 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.859 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.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
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.13 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.042 MB mémoire avant requête : 16.901 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.02 ms
logging slow query	0.01 ms
cleaning up	0.01 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.12 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.042 MB mémoire avant requête : 16.942 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.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
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.09 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.042 MB mémoire avant requête : 16.984 MB Rangées retournées : 0

Requêtes dupliquées: #47

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.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.024 MB Rangées retournées : 1

Requêtes dupliquées: #48

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.21 ms Mémoire de requête : 0.042 MB mémoire avant requête : 17.066 MB Rangées retournées : 0

Requêtes dupliquées: #45

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.13 ms Mémoire de requête : 0.042 MB mémoire avant requête : 17.107 MB Rangées retournées : 1

Requêtes dupliquées: #46

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.14 ms Après la dernière requête : 10.41 ms Mémoire de requête : 0.026 MB mémoire avant requête : 17.450 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.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.01 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]

33 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 × (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  ('e90184d4a23ece3d49741679bd6e6813', 1, '1563631199', 0, '', 0

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

```
1 × DELETE  
  FROM `paris_session`
```