61.61 ms
(40.38%)
|
95 |
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"
"2021"
"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 = '2021' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC LIMIT 1;
|
44.96 ms
(29.47%)
|
48 |
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;
|
2.00 ms
(1.31%)
|
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_.player_goals AS player_goals_6, v0_.assists AS assists_7, v0_.points AS points_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.points90 AS points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpmapu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists 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_.born AS born_5, v0_.player_goals AS player_goals_6, v0_.assists AS assists_7, v0_.points AS points_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.points90 AS points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpmapu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 7 ORDER BY v0_.points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists DESC, v0_.points DESC, v0_.player ASC LIMIT 20;
|
1.98 ms
(1.30%)
|
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 = 7 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;
|
1.56 ms
(1.02%)
|
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 = 7 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;
|
1.55 ms
(1.02%)
|
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 = 7 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;
|
1.52 ms
(1.00%)
|
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 = 7 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;
|
1.49 ms
(0.98%)
|
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 = 7 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;
|
1.46 ms
(0.96%)
|
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 = 7 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;
|
1.42 ms
(0.93%)
|
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 = 7 ORDER BY v0_.chanses90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20;
|
1.42 ms
(0.93%)
|
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 = 7 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;
|
1.41 ms
(0.92%)
|
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 = 7 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;
|
1.37 ms
(0.90%)
|
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 = 7 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;
|
1.34 ms
(0.88%)
|
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 = 7 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;
|
1.32 ms
(0.87%)
|
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 = 7 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;
|
1.29 ms
(0.85%)
|
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 = 7 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;
|
1.25 ms
(0.82%)
|
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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2001 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2001 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;
|
1.02 ms
(0.67%)
|
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_.smart_passes AS smart_passes_9, v0_.progressive_passes AS progressive_passes_10, v0_.smart_progressive_passes90 AS smart_progressive_passes90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpsppu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.smart_progressive_passes90 DESC, v0_.born 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_.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_.smart_passes AS smart_passes_9, v0_.progressive_passes AS progressive_passes_10, v0_.smart_progressive_passes90 AS smart_progressive_passes90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpsppu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 7 ORDER BY v0_.smart_progressive_passes90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.player ASC LIMIT 20;
|
0.98 ms
(0.64%)
|
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_.passes AS passes_6, v0_.successfull_passes AS successfull_passes_7, v0_.pass_percentage AS pass_percentage_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.role_code2 AS role_code2_12, v0_.tournament_id AS tournament_id_13 FROM view_tppppu2101 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_.born 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_.born AS born_5, v0_.passes AS passes_6, v0_.successfull_passes AS successfull_passes_7, v0_.pass_percentage AS pass_percentage_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.role_code2 AS role_code2_12, v0_.tournament_id AS tournament_id_13 FROM view_tppppu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND v0_.tournament_id = 7 ORDER BY v0_.pass_percentage DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.player ASC LIMIT 20;
|
0.97 ms
(0.64%)
|
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_.goals90 AS goals90_8, v0_.shots90 AS shots90_9, v0_.goals AS goals_10, v0_.shots AS shots_11, v0_.tournament_id AS tournament_id_12 FROM view_spmvs9001 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.player ASC
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_.goals90 AS goals90_8, v0_.shots90 AS shots90_9, v0_.goals AS goals_10, v0_.shots AS shots_11, v0_.tournament_id AS tournament_id_12 FROM view_spmvs9001 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.player ASC;
|
0.94 ms
(0.62%)
|
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_.passes AS passes_6, v0_.key_passes AS key_passes_7, v0_.key_passes90 AS key_passes90_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.tournament_id AS tournament_id_12 FROM view_tpnpu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.key_passes90 DESC, v0_.born 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_.born AS born_5, v0_.passes AS passes_6, v0_.key_passes AS key_passes_7, v0_.key_passes90 AS key_passes90_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.tournament_id AS tournament_id_12 FROM view_tpnpu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 7 ORDER BY v0_.key_passes90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.player ASC LIMIT 20;
|
0.94 ms
(0.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_.born AS born_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_.tournament_id AS tournament_id_9 FROM view_tpsu1801 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu1801 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;
|
0.93 ms
(0.61%)
|
1 |
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttat01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.position ASC
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttat01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.position ASC;
|
0.92 ms
(0.60%)
|
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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu1901 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu1901 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;
|
0.91 ms
(0.60%)
|
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_.chances_created AS chances_created_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.matches_played AS matches_played_9, v0_.chanses90 AS chanses90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpscu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.chanses90 DESC, v0_.born 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_.born AS born_5, v0_.chances_created AS chances_created_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.matches_played AS matches_played_9, v0_.chanses90 AS chanses90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpscu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 7 ORDER BY v0_.chanses90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20;
|
0.91 ms
(0.60%)
|
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_tpxgxaxpu2101 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_tpxgxaxpu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 7 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.86 ms
(0.56%)
|
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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2101 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played 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_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2101 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;
|
0.82 ms
(0.54%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.long_passes AS long_passes_5, v0_.through_balls AS through_balls_6, v0_.long_passes_through_balls AS long_passes_through_balls_7, v0_.long_passes_through_balls90 AS long_passes_through_balls90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttlpgs01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.long_passes_through_balls90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.long_passes DESC, v0_.through_balls DESC, v0_.long_passes_through_balls DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.long_passes AS long_passes_5, v0_.through_balls AS through_balls_6, v0_.long_passes_through_balls AS long_passes_through_balls_7, v0_.long_passes_through_balls90 AS long_passes_through_balls90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttlpgs01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.long_passes_through_balls90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.long_passes DESC, v0_.through_balls DESC, v0_.long_passes_through_balls DESC, v0_.team ASC;
|
0.80 ms
(0.52%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.chances_created AS chances_created_3, v0_.matches_played AS matches_played_4, v0_.goals_scored AS goals_scored_5, v0_.goals_concieved AS goals_concieved_6, v0_.chances_created_against AS chances_created_against_7, v0_.chanses90 AS chanses90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttsm01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.chanses90 DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.chances_created DESC, v0_.goals_concieved DESC, v0_.chances_created_against DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.chances_created AS chances_created_3, v0_.matches_played AS matches_played_4, v0_.goals_scored AS goals_scored_5, v0_.goals_concieved AS goals_concieved_6, v0_.chances_created_against AS chances_created_against_7, v0_.chanses90 AS chanses90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttsm01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.chanses90 DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.chances_created DESC, v0_.goals_concieved DESC, v0_.chances_created_against DESC, v0_.team ASC;
|
0.78 ms
(0.51%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.goals AS goals_3, v0_.x_g AS x_g_4, v0_.matches_played AS matches_played_5, v0_.goals_scored AS goals_scored_6, v0_.set_pieces AS set_pieces_7, v0_.tournament_id AS tournament_id_8 FROM view_ttfs01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.goals DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.set_pieces DESC, v0_.x_g DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.goals AS goals_3, v0_.x_g AS x_g_4, v0_.matches_played AS matches_played_5, v0_.goals_scored AS goals_scored_6, v0_.set_pieces AS set_pieces_7, v0_.tournament_id AS tournament_id_8 FROM view_ttfs01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.goals DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.set_pieces DESC, v0_.x_g DESC, v0_.team ASC;
|
0.77 ms
(0.50%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.smart_passes AS smart_passes_5, v0_.progressive_passes AS progressive_passes_6, v0_.smart_progressive_passes AS smart_progressive_passes_7, v0_.smart_progressive_passes90 AS smart_progressive_passes90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttspp01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.smart_progressive_passes90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.smart_progressive_passes DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.smart_passes AS smart_passes_5, v0_.progressive_passes AS progressive_passes_6, v0_.smart_progressive_passes AS smart_progressive_passes_7, v0_.smart_progressive_passes90 AS smart_progressive_passes90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttspp01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.smart_progressive_passes90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.smart_progressive_passes DESC, v0_.team ASC;
|
0.68 ms
(0.44%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.goals AS goals_3, v0_.shots AS shots_4, v0_.goals_per_shot AS goals_per_shot_5, v0_.matches_played AS matches_played_6, v0_.shots_on_goal AS shots_on_goal_7, v0_.tournament_id AS tournament_id_8 FROM view_ttkg01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.goals_per_shot DESC, v0_.matches_played DESC, v0_.goals DESC, v0_.shots DESC, v0_.shots_on_goal DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.goals AS goals_3, v0_.shots AS shots_4, v0_.goals_per_shot AS goals_per_shot_5, v0_.matches_played AS matches_played_6, v0_.shots_on_goal AS shots_on_goal_7, v0_.tournament_id AS tournament_id_8 FROM view_ttkg01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.goals_per_shot DESC, v0_.matches_played DESC, v0_.goals DESC, v0_.shots DESC, v0_.shots_on_goal DESC, v0_.team ASC;
|
0.67 ms
(0.44%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.clean_sheets AS clean_sheets_3, v0_.goals_conceded AS goals_conceded_4, v0_.chances_created_against AS chances_created_against_5, v0_.matches_played AS matches_played_6, v0_.shots_against AS shots_against_7, v0_.chanses90 AS chanses90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttds01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.chanses90 ASC, v0_.matches_played DESC, v0_.goals_conceded DESC, v0_.clean_sheets DESC, v0_.shots_against DESC, v0_.chances_created_against DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.clean_sheets AS clean_sheets_3, v0_.goals_conceded AS goals_conceded_4, v0_.chances_created_against AS chances_created_against_5, v0_.matches_played AS matches_played_6, v0_.shots_against AS shots_against_7, v0_.chanses90 AS chanses90_8, v0_.tournament_id AS tournament_id_9 FROM view_ttds01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.chanses90 ASC, v0_.matches_played DESC, v0_.goals_conceded DESC, v0_.clean_sheets DESC, v0_.shots_against DESC, v0_.chances_created_against DESC, v0_.team ASC;
|
0.66 ms
(0.43%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1801 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1801 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC;
|
0.66 ms
(0.43%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2101 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2101 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC;
|
0.65 ms
(0.43%)
|
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 = 7 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.62 ms
(0.41%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.goals_scored AS goals_scored_4, v0_.shots AS shots_5, v0_.shots_on_goal AS shots_on_goal_6, v0_.shots_on_goal90 AS shots_on_goal90_7, v0_.tournament_id AS tournament_id_8 FROM view_ttspm01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.shots_on_goal90 DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.shots DESC, v0_.shots_on_goal DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.goals_scored AS goals_scored_4, v0_.shots AS shots_5, v0_.shots_on_goal AS shots_on_goal_6, v0_.shots_on_goal90 AS shots_on_goal90_7, v0_.tournament_id AS tournament_id_8 FROM view_ttspm01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.shots_on_goal90 DESC, v0_.matches_played DESC, v0_.goals_scored DESC, v0_.shots DESC, v0_.shots_on_goal DESC, v0_.team ASC;
|
0.60 ms
(0.39%)
|
1 |
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttaht01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttaht01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC;
|
0.58 ms
(0.38%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.games_matches AS games_matches_3, v0_.won AS won_4, v0_.tied_draw AS tied_draw_5, v0_.lost AS lost_6, v0_.goals_scored AS goals_scored_7, v0_.goals_conceded AS goals_conceded_8, v0_.points AS points_9, v0_.ordinary_position AS ordinary_position_10, v0_.tournament_id AS tournament_id_11 FROM view_ttatxg01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.won DESC, v0_.goals_scored ASC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.games_matches AS games_matches_3, v0_.won AS won_4, v0_.tied_draw AS tied_draw_5, v0_.lost AS lost_6, v0_.goals_scored AS goals_scored_7, v0_.goals_conceded AS goals_conceded_8, v0_.points AS points_9, v0_.ordinary_position AS ordinary_position_10, v0_.tournament_id AS tournament_id_11 FROM view_ttatxg01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.won DESC, v0_.goals_scored ASC, v0_.team ASC;
|
0.58 ms
(0.38%)
|
1 |
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttabt01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttabt01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC;
|
0.58 ms
(0.38%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.penalties AS penalties_4, v0_.penalties_goals AS penalties_goals_5, v0_.penalties_against AS penalties_against_6, v0_.penalties_goals_against AS penalties_goals_against_7, v0_.tournament_id AS tournament_id_8 FROM view_tts01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.penalties DESC, v0_.matches_played DESC, v0_.penalties_goals DESC, v0_.penalties_against DESC, v0_.penalties_goals_against DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.penalties AS penalties_4, v0_.penalties_goals AS penalties_goals_5, v0_.penalties_against AS penalties_against_6, v0_.penalties_goals_against AS penalties_goals_against_7, v0_.tournament_id AS tournament_id_8 FROM view_tts01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.penalties DESC, v0_.matches_played DESC, v0_.penalties_goals DESC, v0_.penalties_against DESC, v0_.penalties_goals_against DESC, v0_.team ASC;
|
0.57 ms
(0.37%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2001 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2001 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC;
|
0.57 ms
(0.37%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.accelerations AS accelerations_4, v0_.progressive_run AS progressive_run_5, v0_.accelerations90 AS accelerations90_6, v0_.progressive_run90 AS progressive_run90_7, v0_.tournament_id AS tournament_id_8 FROM view_ttamub01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.progressive_run90 DESC, v0_.accelerations90 DESC, v0_.matches_played DESC, v0_.accelerations DESC, v0_.progressive_run DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.accelerations AS accelerations_4, v0_.progressive_run AS progressive_run_5, v0_.accelerations90 AS accelerations90_6, v0_.progressive_run90 AS progressive_run90_7, v0_.tournament_id AS tournament_id_8 FROM view_ttamub01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.progressive_run90 DESC, v0_.accelerations90 DESC, v0_.matches_played DESC, v0_.accelerations DESC, v0_.progressive_run DESC, v0_.team ASC;
|
0.56 ms
(0.37%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.yellow_cards AS yellow_cards_4, v0_.red_cards AS red_cards_5, v0_.yellow_cards90 AS yellow_cards90_6, v0_.tournament_id AS tournament_id_7 FROM view_ttgrk01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.yellow_cards90 DESC, v0_.matches_played DESC, v0_.yellow_cards DESC, v0_.red_cards DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.yellow_cards AS yellow_cards_4, v0_.red_cards AS red_cards_5, v0_.yellow_cards90 AS yellow_cards90_6, v0_.tournament_id AS tournament_id_7 FROM view_ttgrk01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.yellow_cards90 DESC, v0_.matches_played DESC, v0_.yellow_cards DESC, v0_.red_cards DESC, v0_.team ASC;
|
0.56 ms
(0.37%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1901 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1901 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC;
|
0.55 ms
(0.36%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.avg_age_match_squad AS avg_age_match_squad_4, v0_.avg_age_starting_eleven AS avg_age_starting_eleven_5, v0_.avg_age_bench AS avg_age_bench_6, v0_.avg_age_substituted_in AS avg_age_substituted_in_7, v0_.tournament_id AS tournament_id_8 FROM view_ttga01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.avg_age_substituted_in DESC, v0_.matches_played DESC, v0_.avg_age_match_squad DESC, v0_.avg_age_starting_eleven DESC, v0_.avg_age_bench DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.avg_age_match_squad AS avg_age_match_squad_4, v0_.avg_age_starting_eleven AS avg_age_starting_eleven_5, v0_.avg_age_bench AS avg_age_bench_6, v0_.avg_age_substituted_in AS avg_age_substituted_in_7, v0_.tournament_id AS tournament_id_8 FROM view_ttga01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.avg_age_substituted_in DESC, v0_.matches_played DESC, v0_.avg_age_match_squad DESC, v0_.avg_age_starting_eleven DESC, v0_.avg_age_bench DESC, v0_.team ASC;
|
0.53 ms
(0.35%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.passes AS passes_3, v0_.successfull_passes AS successfull_passes_4, v0_.pass_percentage AS pass_percentage_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttppp01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.pass_percentage DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.passes AS passes_3, v0_.successfull_passes AS successfull_passes_4, v0_.pass_percentage AS pass_percentage_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttppp01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.pass_percentage DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.team ASC;
|
0.49 ms
(0.32%)
|
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 = 7 ORDER BY v0_.penalties_goals DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.penalties DESC, v0_.player ASC LIMIT 20;
|
0.48 ms
(0.32%)
|
1 |
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.key_passes AS key_passes_5, v0_.key_passes90 AS key_passes90_6, v0_.tournament_id AS tournament_id_7 FROM view_ttnp01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.key_passes90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.team ASC
SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.passes AS passes_4, v0_.key_passes AS key_passes_5, v0_.key_passes90 AS key_passes90_6, v0_.tournament_id AS tournament_id_7 FROM view_ttnp01 v0_ WHERE v0_.tournament_id = 7 ORDER BY v0_.key_passes90 DESC, v0_.matches_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.team ASC;
|
0.45 ms
(0.29%)
|
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;
|