16.34 ms
(44.40%)
|
31 |
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name = ? AND t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1
Parameters: [
"Allsvenskan"
"SWE"
"2020"
"2015"
"2016"
"2017"
]
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = 'Allsvenskan' AND c1_.area = 'SWE') WHERE t0_.name = '2020' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
12.24 ms
(33.26%)
|
16 |
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC
Parameters: [
"Allsvenskan"
"SWE"
"2015"
"2016"
"2017"
]
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = 'Allsvenskan' AND c1_.area = 'SWE') INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC;
|
0.96 ms
(2.61%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.accelerations AS accelerations_8, v0_.progressive_run AS progressive_run_9, v0_.accelerations90 AS accelerations90_10, v0_.progressive_run90 AS progressive_run90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpamub01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.progressive_run90 DESC, v0_.accelerations90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.accelerations DESC, v0_.progressive_run DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.accelerations AS accelerations_8, v0_.progressive_run AS progressive_run_9, v0_.accelerations90 AS accelerations90_10, v0_.progressive_run90 AS progressive_run90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpamub01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 8 ORDER BY v0_.progressive_run90 DESC, v0_.accelerations90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.accelerations DESC, v0_.progressive_run DESC, v0_.player ASC LIMIT 20;
|
0.64 ms
(1.75%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.assists AS assists_8, v0_.expected_assists AS expected_assists_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_assists90 AS expected_assists90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpaxa01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.assists DESC, v0_.expected_assists90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_assists DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.assists AS assists_8, v0_.expected_assists AS expected_assists_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_assists90 AS expected_assists90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpaxa01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 8 ORDER BY v0_.assists DESC, v0_.expected_assists90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_assists DESC, v0_.player ASC LIMIT 20;
|
0.55 ms
(1.49%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.goals_scored AS goals_scored_8, v0_.expected_goals AS expected_goals_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_goals90 AS expected_goals90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmxg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.goals_scored DESC, v0_.expected_goals90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.goals_scored AS goals_scored_8, v0_.expected_goals AS expected_goals_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_goals90 AS expected_goals90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmxg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 8 ORDER BY v0_.goals_scored DESC, v0_.expected_goals90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.player ASC LIMIT 20;
|
0.49 ms
(1.35%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.player_goals AS player_goals_5, v0_.assists AS assists_6, v0_.points AS points_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.points90 AS points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmap01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.player_goals AS player_goals_5, v0_.assists AS assists_6, v0_.points AS points_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.points90 AS points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmap01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 8 ORDER BY v0_.points DESC, v0_.points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists DESC, v0_.player ASC LIMIT 20;
|
0.49 ms
(1.35%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.long_passes AS long_passes_8, v0_.through_balls AS through_balls_9, v0_.long_passes_through_balls90 AS long_passes_through_balls90_10, v0_.tournament_id AS tournament_id_11 FROM view_tplpgs01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.long_passes_through_balls90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.long_passes DESC, v0_.through_balls DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.long_passes AS long_passes_8, v0_.through_balls AS through_balls_9, v0_.long_passes_through_balls90 AS long_passes_through_balls90_10, v0_.tournament_id AS tournament_id_11 FROM view_tplpgs01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 8 ORDER BY v0_.long_passes_through_balls90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.long_passes DESC, v0_.through_balls DESC, v0_.player ASC LIMIT 20;
|
0.49 ms
(1.33%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.chances_created AS chances_created_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.chanses90 AS chanses90_9, v0_.tournament_id AS tournament_id_10 FROM view_tpsc01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.chanses90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.chances_created AS chances_created_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.chanses90 AS chanses90_9, v0_.tournament_id AS tournament_id_10 FROM view_tpsc01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 8 ORDER BY v0_.chanses90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20;
|
0.49 ms
(1.33%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.smart_passes AS smart_passes_8, v0_.progressive_passes AS progressive_passes_9, v0_.smart_progressive_passes90 AS smart_progressive_passes90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpspp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.smart_progressive_passes90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.smart_passes AS smart_passes_8, v0_.progressive_passes AS progressive_passes_9, v0_.smart_progressive_passes90 AS smart_progressive_passes90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpspp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 8 ORDER BY v0_.smart_progressive_passes90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.player ASC LIMIT 20;
|
0.49 ms
(1.33%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.penalties AS penalties_8, v0_.penalties_goals AS penalties_goals_9, v0_.tournament_id AS tournament_id_10 FROM view_tps01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.penalties > 0 AND v0_.tournament_id = ? ORDER BY v0_.penalties_goals DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.penalties DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.penalties AS penalties_8, v0_.penalties_goals AS penalties_goals_9, v0_.tournament_id AS tournament_id_10 FROM view_tps01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.penalties > 0 AND v0_.tournament_id = 8 ORDER BY v0_.penalties_goals DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.penalties DESC, v0_.player ASC LIMIT 20;
|
0.47 ms
(1.29%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.yellow_cards AS yellow_cards_8, v0_.red_cards AS red_cards_9, v0_.yellow_cards90 AS yellow_cards90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpgrk01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND ((v0_.yellow_cards > 0 OR v0_.red_cards > 0)) AND v0_.tournament_id = ? ORDER BY v0_.yellow_cards DESC, v0_.yellow_cards90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.red_cards DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.yellow_cards AS yellow_cards_8, v0_.red_cards AS red_cards_9, v0_.yellow_cards90 AS yellow_cards90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpgrk01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND ((v0_.yellow_cards > 0 OR v0_.red_cards > 0)) AND v0_.tournament_id = 8 ORDER BY v0_.yellow_cards DESC, v0_.yellow_cards90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.red_cards DESC, v0_.player ASC LIMIT 20;
|
0.47 ms
(1.26%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.expected_points AS expected_points_5, v0_.ordinary_position AS ordinary_position_6, v0_.matches_played AS matches_played_7, v0_.minutes_played AS minutes_played_8, v0_.min_minutes_played AS min_minutes_played_9, v0_.points AS points_10, v0_.expected_points90 AS expected_points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tppxp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.expected_points DESC, v0_.expected_points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.points DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.expected_points AS expected_points_5, v0_.ordinary_position AS ordinary_position_6, v0_.matches_played AS matches_played_7, v0_.minutes_played AS minutes_played_8, v0_.min_minutes_played AS min_minutes_played_9, v0_.points AS points_10, v0_.expected_points90 AS expected_points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tppxp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 8 ORDER BY v0_.expected_points DESC, v0_.expected_points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.points DESC, v0_.player ASC LIMIT 20;
|
0.46 ms
(1.26%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.expected_goals AS expected_goals_9, v0_.expected_assists AS expected_assists_10, v0_.expected_points AS expected_points_11, v0_.expected_points90 AS expected_points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpxgxaxp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.expected_points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.expected_assists DESC, v0_.expected_points DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.expected_goals AS expected_goals_9, v0_.expected_assists AS expected_assists_10, v0_.expected_points AS expected_points_11, v0_.expected_points90 AS expected_points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpxgxaxp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 8 ORDER BY v0_.expected_points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.expected_assists DESC, v0_.expected_points DESC, v0_.player ASC LIMIT 20;
|
0.46 ms
(1.26%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.passes AS passes_5, v0_.successfull_passes AS successfull_passes_6, v0_.pass_percentage AS pass_percentage_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.role_code2 AS role_code2_11, v0_.tournament_id AS tournament_id_12 FROM view_tpppp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND v0_.tournament_id = ? ORDER BY v0_.pass_percentage DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.passes AS passes_5, v0_.successfull_passes AS successfull_passes_6, v0_.pass_percentage AS pass_percentage_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.role_code2 AS role_code2_11, v0_.tournament_id AS tournament_id_12 FROM view_tpppp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND v0_.tournament_id = 8 ORDER BY v0_.pass_percentage DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.player ASC LIMIT 20;
|
0.46 ms
(1.25%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.aerial_duels AS aerial_duels_8, v0_.aerial_duels_won_perc AS aerial_duels_won_perc_9, v0_.head_pass AS head_pass_10, v0_.successful_head_pass_perc AS successful_head_pass_perc_11, v0_.role_code2 AS role_code2_12, v0_.tournament_id AS tournament_id_13 FROM view_tphs01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND (NOT (v0_.head_pass < 10 OR v0_.aerial_duels < 10)) AND v0_.tournament_id = ? ORDER BY v0_.successful_head_pass_perc DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.aerial_duels DESC, v0_.aerial_duels_won_perc DESC, v0_.head_pass DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.aerial_duels AS aerial_duels_8, v0_.aerial_duels_won_perc AS aerial_duels_won_perc_9, v0_.head_pass AS head_pass_10, v0_.successful_head_pass_perc AS successful_head_pass_perc_11, v0_.role_code2 AS role_code2_12, v0_.tournament_id AS tournament_id_13 FROM view_tphs01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND (NOT (v0_.head_pass < 10 OR v0_.aerial_duels < 10)) AND v0_.tournament_id = 8 ORDER BY v0_.successful_head_pass_perc DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.aerial_duels DESC, v0_.aerial_duels_won_perc DESC, v0_.head_pass DESC, v0_.player ASC LIMIT 20;
|
0.46 ms
(1.25%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.goals_scored AS goals_scored_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.chances_created AS chances_created_9, v0_.goals_chances_created AS goals_chances_created_10, v0_.tournament_id AS tournament_id_11 FROM view_tpkg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND (NOT (v0_.chances_created <= 2 OR v0_.goals_scored <= 1)) AND v0_.tournament_id = ? ORDER BY v0_.goals_chances_created DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.goals_scored DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.goals_scored AS goals_scored_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.chances_created AS chances_created_9, v0_.goals_chances_created AS goals_chances_created_10, v0_.tournament_id AS tournament_id_11 FROM view_tpkg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND (NOT (v0_.chances_created <= 2 OR v0_.goals_scored <= 1)) AND v0_.tournament_id = 8 ORDER BY v0_.goals_chances_created DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.goals_scored DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20;
|
0.44 ms
(1.20%)
|
1 |
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.passes AS passes_5, v0_.key_passes AS key_passes_6, v0_.key_passes90 AS key_passes90_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.tournament_id AS tournament_id_11 FROM view_tpnp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.key_passes90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.player ASC LIMIT 20
SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.passes AS passes_5, v0_.key_passes AS key_passes_6, v0_.key_passes90 AS key_passes90_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.tournament_id AS tournament_id_11 FROM view_tpnp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 8 ORDER BY v0_.key_passes90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.player ASC LIMIT 20;
|
0.38 ms
(1.03%)
|
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.area AS area_4 FROM competition t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.area AS area_4 FROM competition t0 WHERE t0.id = 1;
|