Roland Garros 2023 Men's Singles (May 28 - June 11)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Carlos Alcaraz
				Carlos Alcaraz
2.		[Q]	Flavio Cobolli	6-0 6-2 7-5
					Carlos Alcaraz
3.			Taro Daniel		6-1 3-6 6-1 6-2
				Taro Daniel
4.			Christopher O'Connell	6-0 6-2 6-4
						Carlos Alcaraz
5.			Matteo Arnaldi			6-1 6-4 6-2
				Matteo Arnaldi
6.			Daniel Elahi Galan	2-6 6-3 6-0 6-2
					Denis Shapovalov
7.		[26]	Denis Shapovalov		6-2 3-6 6-3 6-3
				Denis Shapovalov
8.			Brandon Nakashima	6-4 7-5 4-6 3-6 6-3
							Carlos Alcaraz
9.		[17]	Lorenzo Musetti				6-3 6-2 6-2
				Lorenzo Musetti
10.			Mikael Ymer	7-5 6-2 6-4
					Lorenzo Musetti
11.			Alexander Shevchenko		6-1 6-1 6-2
				Alexander Shevchenko
12.			Oscar Otte	7-5 4-6 6-1 7-6(2)
						Lorenzo Musetti
13.		[Q]	Lucas Pouille			6-1 6-2 6-4
				Lucas Pouille
14.		[LL]	Jurij Rodionov	6-2 6-4 6-3
					Cameron Norrie
15.		[14]	Cameron Norrie		6-1 6-3 6-3
				Cameron Norrie
16.		[WC]	Benoit Paire	7-5 4-6 3-6 6-1 6-4
								Carlos Alcaraz
17.			Fabio Fognini					6-2 6-1 7-6(5)
				Fabio Fognini
18.		[10]	Felix Auger-Aliassime	6-4 6-4 6-3
					Fabio Fognini
19.			Jason Kubler		6-4 7-6(5) 6-2
				Jason Kubler
20.		[LL]	Facundo Diaz Acosta	1-6 6-3 6-4 3-6 6-1
						Sebastian Ofner
21.		[Q]	Sebastian Ofner			5-7 6-3 7-5 1-6 6-4
				Sebastian Ofner
22.			Maxime Cressy	6-4 7-6(6) 6-2
					Sebastian Ofner
23.		[24]	Sebastian Korda		6-3 7-6(1) 6-4
				Sebastian Korda
24.			Mackenzie McDonald	6-4 7-5 6-4
							Stefanos Tsitsipas
25.			Diego Schwartzman				7-5 6-3 6-0
				Diego Schwartzman
26.		[32]	Bernabe Zapata Miralles	1-6 6-7(5) 6-2 6-0 6-4
					Diego Schwartzman
27.			Nuno Borges		7-6(3) 6-4 6-3
				Nuno Borges
28.			John Isner	6-4 5-7 7-6(3) 4-6 7-6(9)
						Stefanos Tsitsipas
29.			Roberto Carballes Baena			6-2 6-2 6-3
				Roberto Carballes Baena
30.		[Q]	Emilio Nava	7-6(5) 6-3 6-2
					Stefanos Tsitsipas
31.		[5]	Stefanos Tsitsipas		6-3 7-6(4) 6-2
				Stefanos Tsitsipas
32.			Jiri Vesely	7-5 6-3 4-6 7-6(7)
									Novak Djokovic
33.		[3]	Novak Djokovic						6-3 5-7 6-1 6-1
				Novak Djokovic
34.			Aleksandar Kovacevic	6-3 6-2 7-6(1)
					Novak Djokovic
35.			Marton Fucsovics		7-6(2) 6-0 6-3
				Marton Fucsovics
36.		[WC]	Hugo Grenier	6-3 5-7 6-1 6-3
						Novak Djokovic
37.			Luca van Assche			7-6(4) 7-6(5) 6-2
				Luca van Assche
38.			Marco Cecchinato	6-1 6-1 6-3
					Alejandro Davidovich Fokina
39.		[29]	Alejandro Davidovich Fokina		6-4 6-3 7-6(6)
				Alejandro Davidovich Fokina
40.		[WC]	Arthur Fils	6-1 4-6 6-3 6-3
							Novak Djokovic
41.		[19]	Roberto Bautista Agut				6-3 6-2 6-2
				Roberto Bautista Agut
42.			Yibing Wu	7-6(4) 6-1 6-1
					Juan Pablo Varillas
43.			Juan Pablo Varillas		1-6 4-6 6-3 6-1 6-1
				Juan Pablo Varillas
44.		[Q]	Juncheng Shang	4-6 2-6 6-2 6-3 6-1
						Juan Pablo Varillas
45.			Tallon Griekspoor			3-6 6-3 7-6(3) 4-6 6-2
				Tallon Griekspoor
46.		[Q]	Pedro Martinez	6-4 2-6 0-6 7-5 6-3
					Hubert Hurkacz
47.		[13]	Hubert Hurkacz		6-3 5-7 6-7(13) 7-6(5) 6-4
				Hubert Hurkacz
48.			David Goffin	6-3 5-7 6-2 2-6 6-4
								Novak Djokovic
49.		[11]	Karen Khachanov					4-6 7-6(0) 6-2 6-4
				Karen Khachanov
50.			Constant Lestienne	3-6 1-6 6-2 6-1 6-3
					Karen Khachanov
51.		[Q]	Radu Albot		6-3 6-4 6-2
				Radu Albot
52.		[WC]	Patrick Kypson	6-3 6-2 4-6 6-1
						Karen Khachanov
53.			Stan Wawrinka			6-4 6-1 3-6 7-6(5)
				Stan Wawrinka
54.			Albert Ramos-Vinolas	7-6(5) 6-4 6-7(2) 1-6 6-4
					Thanasi Kokkinakis
55.		[WC]	Thanasi Kokkinakis		3-6 7-5 6-3 6-7(4) 6-3
				Thanasi Kokkinakis
56.		[20]	Daniel Evans	6-4 6-4 6-4
							Karen Khachanov
57.			Lorenzo Sonego				1-6 6-4 7-6(7) 6-1
				Lorenzo Sonego
58.		[30]	Ben Shelton	6-4 3-6 6-3 6-3
					Lorenzo Sonego
59.			Ugo Humbert		6-4 6-3 7-6(3)
				Ugo Humbert
60.			Adrian Mannarino	6-3 6-3 6-1
						Lorenzo Sonego
61.			Corentin Moutet			5-7 0-6 6-3 7-6(5) 6-3
				Corentin Moutet
62.		[WC]	Arthur Cazaux	6-1 6-3 4-6 6-4
					Andrey Rublev
63.		[7]	Andrey Rublev		6-4 6-2 3-6 6-3
				Andrey Rublev
64.			Laslo Djere	6-1 3-6 6-3 6-4
										Novak Djokovic
65.		[6]	Holger Rune							7-6(1) 6-3 7-5
				Holger Rune
66.			Christopher Eubanks	6-4 3-6 7-6(2) 6-2
					Holger Rune
67.			Gael Monfils		w/o
				Gael Monfils
68.			Sebastian Baez	3-6 6-3 7-5 1-6 7-5
						Holger Rune
69.		[Q]	Genaro Alberto Oliveri			6-4 6-1 6-3
				Genaro Alberto Oliveri
70.		[WC]	Giovanni Mpetshi Perricard	7-6(3) 4-6 4-6 7-5 6-1
					Genaro Alberto Oliveri
71.		[Q]	Andrea Vavassori		7-6(7) 3-6 6-4 7-6(3)
				Andrea Vavassori
72.		[31]	Miomir Kecmanovic	5-7 2-6 7-6(8) 7-6(3) 7-6(9)
							Holger Rune
73.		[23]	Francisco Cerundolo				7-6(3) 3-6 6-4 1-6 7-6
				Francisco Cerundolo
74.			Jaume Munar	6-1 2-6 7-6(5) 6-1
					Francisco Cerundolo
75.		[LL]	Yannick Hanfmann		6-3 6-3 6-4
				Yannick Hanfmann
76.			Thiago Monteiro	6-3 7-5 6-7(6) 6-7(2) 6-4
						Francisco Cerundolo
77.			Arthur Rinderknech			3-6 6-3 6-4 7-5
				Arthur Rinderknech
78.			Richard Gasquet	6-4 2-6 6-4 7-6(4)
					Taylor Fritz
79.		[9]	Taylor Fritz		2-6 6-4 6-3 6-4
				Taylor Fritz
80.			Michael Mmoh	6-2 6-1 6-1
								Casper Ruud
81.		[16]	Tommy Paul					6-1 6-2 3-6 6-3
				Tommy Paul
82.		[LL]	Dominic Stricker	6-3 6-2 6-4
					Nicolas Jarry
83.			Nicolas Jarry		3-6 6-1 6-4 6-7-5
				Nicolas Jarry
84.			Hugo Dellien	6-4 6-4 6-2
						Nicolas Jarry
85.			Marcos Giron			6-2 6-3 6-7(7) 6-3
				Marcos Giron
86.		[Q]	Hamad Medjedovic	6-0 6-2 1-6 6-0
					Marcos Giron
87.			Jiri Lehecka		6-2 6-3 6-1
				Jiri Lehecka
88.		[21]	Jan-Lennard Struff	7-5 1-6 6-3 3-6 6-1
							Casper Ruud
89.		[Q]	Thiago Agustin Tirante				7-6(3) 7-5 7-5
				Thiago Agustin Tirante
90.		[25]	Botic van de Zandschulp	6-2 4-6 6-3 6-4
					Zhizhen Zhang
91.			Zhizhen Zhang		7-6(3) 6-3 6-4
				Zhizhen Zhang
92.			Dusan Lajovic	6-1 4-1 rtd.
						Casper Ruud
93.		[Q]	Giulio Zeppieri			4-6 6-4 6-1 6-4
				Giulio Zeppieri
94.			Alexander Bublik	6-0 4-6 4-6 6-3 7-5
					Casper Ruud
95.		[4]	Casper Ruud		6-3 6-2 4-6 7-5
				Casper Ruud
96.		[Q]	Elias Ymer	6-4 6-3 6-2
									Casper Ruud
97.		[8]	Jannik Sinner						6-3 6-4 6-0
				Jannik Sinner
98.			Alexandre Muller	6-1 6-4 6-1
					Daniel Altmaier
99.			Daniel Altmaier		6-7(0) 7-6(7) 1-6 7-6(4) 7-5
				Daniel Altmaier
100.			Marc-Andrea Huesler	6-3 6-4 6-4
						Grigor Dimitrov
101.			Emil Ruusuvuori			6-4 6-3 6-1
				Emil Ruusuvuori
102.			Gregoire Barrere	6-2 6-7(7) 5-7 6-1 6-4
					Grigor Dimitrov
103.		[28]	Grigor Dimitrov		7-6(4) 6-3 6-4
				Grigor Dimitrov
104.		[Q]	Timofey Skatov	6-0 6-3 6-2
							Alexander Zverev
105.		[22]	Alexander Zverev				6-1 6-4 6-3
				Alexander Zverev
106.			Lloyd Harris	7-6(6) 7-6(0) 6-1
					Alexander Zverev
107.			Alex Molcan		6-4 6-2 6-1
				Alex Molcan
108.		[WC]	Hugo Gaston	6-1 7-6(4) 6-4
						Alexander Zverev
109.		[Q]	Aslan Karatsev			3-6 7-6(3) 6-1 7-6(5)
				Aslan Karatsev
110.			Alexei Popyrin	6-3 6-7(4) 6-1 6-2
					Frances Tiafoe
111.		[12]	Frances Tiafoe		3-6 6-3 7-5 6-2
				Frances Tiafoe
112.			Filip Krajinovic	6-3 6-4 6-2
								Alexander Zverev
113.		[15]	Borna Coric					6-5 3-6 6-3 6-4
				Borna Coric
114.			Federico Coria	7-6(3) 6-7(5) 6-3 6-3
					Borna Coric
115.			Pedro Cachin		6-3 4-6 4-6 6-3 6-4
				Pedro Cachin
116.			Dominic Thiem	6-3 6-2 6-7(1) 4-6 6-2
						Tomas Martin Etcheverry
117.			Tomas Martin Etcheverry			6-3 7-6(5) 6-2
				Tomas Martin Etcheverry
118.			Jack Draper	6-4 1-0 rtd.
					Tomas Martin Etcheverry
119.		[18]	Alex de Minaur		6-3 7-6(2) 6-3
				Alex de Minaur
120.			Ilya Ivashka	6-1 5-7 6-1 6-3
							Tomas Martin Etcheverry
121.		[27]	Yoshihito Nishioka				7-6(8) 6-0 6-1
				Yoshihito Nishioka
122.			Jeffrey Wolf	1-6 3-6 6-4 6-3 6-3
					Yoshihito Nishioka
123.			Max Purcell		4-6 6-2 7-5 6-4
				Max Purcell
124.			Jordan Thompson	7-5 1-6 6-4 6-4
						Yoshihito Nishioka
125.			Guido Pella			3-6 7-6(8) 2-6 6-4 6-0
				Guido Pella
126.			Quentin Halys	6-4 6-7(7) 2-6 7-6(4) 7-6(4)
					Thiago Seyboth Wild
127.		[Q]	Thiago Seyboth Wild		6-3 3-6 6-4 6-3
				Thiago Seyboth Wild
128.		[2]	Daniil Medvedev	7-6(5) 6-7(6) 2-6 6-3 6-4

(default) 17 queries took 24 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`slug` = 'roland-garros' LIMIT 1	1	1	1
2	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`tournament_id` = (2)	5	5	1
3	SELECT `Quote`.`id`, `Quote`.`tournament_id`, `Quote`.`quote`, `Quote`.`by`, `Quote`.`source`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `zavoihu1_db4tennis`.`quotes` AS `Quote` WHERE `Quote`.`tournament_id` = (2)	5	5	1
4	SELECT `Tournamenttotal`.`id`, `Tournamenttotal`.`tournament_id`, `Tournamenttotal`.`year`, `Tournamenttotal`.`price_money`, `Tournamenttotal`.`attendance`, `Tournamenttotal`.`created`, `Tournamenttotal`.`created_by`, `Tournamenttotal`.`modified`, `Tournamenttotal`.`modified_by` FROM `zavoihu1_db4tennis`.`tournamenttotals` AS `Tournamenttotal` WHERE `Tournamenttotal`.`tournament_id` = (2)	5	5	1
5	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`categories` AS `Category` LEFT JOIN `zavoihu1_db4tennis`.`tournaments` AS `Tournament` ON (`Category`.`tournament_id` = `Tournament`.`id`) WHERE `Tournament`.`slug` = 'roland-garros' AND `Category`.`slug` = 'men-singles' LIMIT 1	1	1	1
6	SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = (12) ORDER BY `Contest`.`year` ASC	123	123	2
7	SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` LEFT JOIN `zavoihu1_db4tennis`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Category`.`tournament_id` = 2 AND `Contest`.`category_id` = 12 AND `Contest`.`slug` = '2023' LIMIT 1	1	1	2
8	SELECT `Match`.`id`, `Match`.`contest_id`, `Match`.`player_a_id`, `Match`.`player_aa_id`, `Match`.`player_b_id`, `Match`.`player_bb_id`, `Match`.`results`, `Match`.`long`, `Match`.`attendance`, `Match`.`no`, `Match`.`round`, `Match`.`round_id`, `Match`.`note`, `Match`.`created`, `Match`.`created_by`, `Match`.`modified`, `Match`.`modified_by` FROM `zavoihu1_db4tennis`.`matches` AS `Match` WHERE `Match`.`contest_id` = (2311) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	2
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (14464, 14604, 13871, 14239, 14605, 14416, 14252, 14432, 14468, 14387, 14606, 14274, 11452, 14450, 14248, 157, 119, 14330, 7856, 14607, 14257, 14429, 14428, 14220, 13616, 14469, 14539, 164, 14196, 14484, 14245, 11453, 52, 14608, 14221, 14553, 14596, 14146, 14389, 14609, 113, 14571, 14530, 14594, 14414, 14386, 14270, 3725, 14224, 14597, 13869, 14311, 156, 149, 10251, 9051, 14267, 14570, 14333, 130, 14261, 14470, 14154, 14197, 14483, 14312, 99, 14497, 14610, 14611, 14550, 14347, 14476, 14265, 14335, 14236, 14445, 75, 14178, 14086, 14153, 14612, 14241, 14390, 13867, 14613, 14502, 11457, 14614, 14463, 14479, 13562, 14538, 14235, 14258, 14093, 14400, 14244, 14446, 14552, 14433, 14194, 161, 14503, 14136, 14332, 14485, 14410, 14460, 14266, 14087, 8925, 13870, 14443, 14537, 13580, 14501, 14477, 14234, 14222, 13874, 14434, 14417, 13568, 6780, 14125, 14436, 14237) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	3
10	SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 2311	128	128	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 92, 178, 197, 29, 179, 53, 147, 133, 68, 74, 10, 13, 14, 72, 96, 154, 36, 67, 139, 54, 173, 196, 94, 168, 164, 41, 20, 149, 172, 21, 43, 84, 31, 26, 50, 150, 153)	38	38	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 92, 178, 197, 29, 179, 53, 147, 133, 68, 74, 10, 13, 14, 72, 96, 154, 36, 67, 139, 54, 173, 196, 94, 168, 164, 41, 20, 149, 172, 21, 43, 84, 31, 26, 50, 150, 153)	38	38	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14464, 14604, 13871, 14239, 14605, 14416, 14252, 14432, 14468, 14387, 14606, 14274, 11452, 14450, 14248, 157, 119, 14330, 7856, 14607, 14257, 14429, 14428, 14220, 13616, 14469, 14539, 164, 14196, 14484, 14245, 11453, 52, 14608, 14221, 14553, 14596, 14146, 14389, 14609, 113, 14571, 14530, 14594, 14414, 14386, 14270, 3725, 14224, 14597, 13869, 14311, 156, 149, 10251, 9051, 14267, 14570, 14333, 130, 14261, 14470, 14154, 14197, 14483, 14312, 99, 14497, 14610, 14611, 14550, 14347, 14476, 14265, 14335, 14236, 14445, 75, 14178, 14086, 14153, 14612, 14241, 14390, 13867, 14613, 14502, 11457, 14614, 14463, 14479, 13562, 14538, 14235, 14258, 14093, 14400, 14244, 14446, 14552, 14433, 14194, 161, 14503, 14136, 14332, 14485, 14410, 14460, 14266, 14087, 8925, 13870, 14443, 14537, 13580, 14501, 14477, 14234, 14222, 13874, 14434, 14417, 13568, 6780, 14125, 14436, 14237)) AND (`Playercontest`.`contest_id` = 2311))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 12 ORDER BY `Contest`.`date_from` ASC	123	123	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2023	10	10	2
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (3, 1, 12, 14, 17, 19, 22, 24, 2, 4) AND `Category`.`gender` = 'Men' AND `Category`.`type` = 'Singles'	4	4	1
17	SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)	4	4	1

(default) 17 queries took 24 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`slug` = 'roland-garros' LIMIT 1

SELECT `Quote`.`id`, `Quote`.`tournament_id`, `Quote`.`quote`, `Quote`.`by`, `Quote`.`source`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `zavoihu1_db4tennis`.`quotes` AS `Quote` WHERE `Quote`.`tournament_id` = (2)

SELECT `Tournamenttotal`.`id`, `Tournamenttotal`.`tournament_id`, `Tournamenttotal`.`year`, `Tournamenttotal`.`price_money`, `Tournamenttotal`.`attendance`, `Tournamenttotal`.`created`, `Tournamenttotal`.`created_by`, `Tournamenttotal`.`modified`, `Tournamenttotal`.`modified_by` FROM `zavoihu1_db4tennis`.`tournamenttotals` AS `Tournamenttotal` WHERE `Tournamenttotal`.`tournament_id` = (2)

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`categories` AS `Category` LEFT JOIN `zavoihu1_db4tennis`.`tournaments` AS `Tournament` ON (`Category`.`tournament_id` = `Tournament`.`id`) WHERE `Tournament`.`slug` = 'roland-garros' AND `Category`.`slug` = 'men-singles' LIMIT 1

123

SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` LEFT JOIN `zavoihu1_db4tennis`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Category`.`tournament_id` = 2 AND `Contest`.`category_id` = 12 AND `Contest`.`slug` = '2023' LIMIT 1

SELECT `Match`.`id`, `Match`.`contest_id`, `Match`.`player_a_id`, `Match`.`player_aa_id`, `Match`.`player_b_id`, `Match`.`player_bb_id`, `Match`.`results`, `Match`.`long`, `Match`.`attendance`, `Match`.`no`, `Match`.`round`, `Match`.`round_id`, `Match`.`note`, `Match`.`created`, `Match`.`created_by`, `Match`.`modified`, `Match`.`modified_by` FROM `zavoihu1_db4tennis`.`matches` AS `Match` WHERE `Match`.`contest_id` = (2311) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC

127

SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (14464, 14604, 13871, 14239, 14605, 14416, 14252, 14432, 14468, 14387, 14606, 14274, 11452, 14450, 14248, 157, 119, 14330, 7856, 14607, 14257, 14429, 14428, 14220, 13616, 14469, 14539, 164, 14196, 14484, 14245, 11453, 52, 14608, 14221, 14553, 14596, 14146, 14389, 14609, 113, 14571, 14530, 14594, 14414, 14386, 14270, 3725, 14224, 14597, 13869, 14311, 156, 149, 10251, 9051, 14267, 14570, 14333, 130, 14261, 14470, 14154, 14197, 14483, 14312, 99, 14497, 14610, 14611, 14550, 14347, 14476, 14265, 14335, 14236, 14445, 75, 14178, 14086, 14153, 14612, 14241, 14390, 13867, 14613, 14502, 11457, 14614, 14463, 14479, 13562, 14538, 14235, 14258, 14093, 14400, 14244, 14446, 14552, 14433, 14194, 161, 14503, 14136, 14332, 14485, 14410, 14460, 14266, 14087, 8925, 13870, 14443, 14537, 13580, 14501, 14477, 14234, 14222, 13874, 14434, 14417, 13568, 6780, 14125, 14436, 14237) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

128

SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 2311

128

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 92, 178, 197, 29, 179, 53, 147, 133, 68, 74, 10, 13, 14, 72, 96, 154, 36, 67, 139, 54, 173, 196, 94, 168, 164, 41, 20, 149, 172, 21, 43, 84, 31, 26, 50, 150, 153)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (42, 92, 178, 197, 29, 179, 53, 147, 133, 68, 74, 10, 13, 14, 72, 96, 154, 36, 67, 139, 54, 173, 196, 94, 168, 164, 41, 20, 149, 172, 21, 43, 84, 31, 26, 50, 150, 153)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (14464, 14604, 13871, 14239, 14605, 14416, 14252, 14432, 14468, 14387, 14606, 14274, 11452, 14450, 14248, 157, 119, 14330, 7856, 14607, 14257, 14429, 14428, 14220, 13616, 14469, 14539, 164, 14196, 14484, 14245, 11453, 52, 14608, 14221, 14553, 14596, 14146, 14389, 14609, 113, 14571, 14530, 14594, 14414, 14386, 14270, 3725, 14224, 14597, 13869, 14311, 156, 149, 10251, 9051, 14267, 14570, 14333, 130, 14261, 14470, 14154, 14197, 14483, 14312, 99, 14497, 14610, 14611, 14550, 14347, 14476, 14265, 14335, 14236, 14445, 75, 14178, 14086, 14153, 14612, 14241, 14390, 13867, 14613, 14502, 11457, 14614, 14463, 14479, 13562, 14538, 14235, 14258, 14093, 14400, 14244, 14446, 14552, 14433, 14194, 161, 14503, 14136, 14332, 14485, 14410, 14460, 14266, 14087, 8925, 13870, 14443, 14537, 13580, 14501, 14477, 14234, 14222, 13874, 14434, 14417, 13568, 6780, 14125, 14436, 14237)) AND (`Playercontest`.`contest_id` = 2311))

128

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 12 ORDER BY `Contest`.`date_from` ASC

123

SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 2023

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (3, 1, 12, 14, 17, 19, 22, 24, 2, 4) AND `Category`.`gender` = 'Men' AND `Category`.`type` = 'Singles'

SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)