4.49 ms (37.49%)
|
47 |
SELECT t0.played_at AS played_at_1, t0.score AS score_2, t0.in_stats AS in_stats_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.winning_team_id AS winning_team_id_7 FROM game t0 INNER JOIN game_team ON t0.id = game_team.game_id WHERE game_team.team_id = ?
SELECT t0.played_at AS played_at_1, t0.score AS score_2, t0.in_stats AS in_stats_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.winning_team_id AS winning_team_id_7 FROM game t0 INNER JOIN game_team ON t0.id = game_team.game_id WHERE game_team.team_id = 1;
|
2.31 ms (19.34%)
|
34 |
SELECT t0.username AS username_1, t0.roles AS roles_2, t0.password AS password_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM player t0 INNER JOIN team_player ON t0.id = team_player.player_id WHERE team_player.team_id = ?
SELECT t0.username AS username_1, t0.roles AS roles_2, t0.password AS password_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM player t0 INNER JOIN team_player ON t0.id = team_player.player_id WHERE team_player.team_id = 66;
|
1.41 ms (11.82%)
|
47 |
SELECT t0.played_at AS played_at_1, t0.score AS score_2, t0.in_stats AS in_stats_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.winning_team_id AS winning_team_id_7 FROM game t0 WHERE t0.winning_team_id = ?
SELECT t0.played_at AS played_at_1, t0.score AS score_2, t0.in_stats AS in_stats_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.winning_team_id AS winning_team_id_7 FROM game t0 WHERE t0.winning_team_id = 1;
|
1.18 ms (9.86%)
|
17 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3 FROM team t0 INNER JOIN game_team ON t0.id = game_team.team_id WHERE game_team.game_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3 FROM team t0 INNER JOIN game_team ON t0.id = game_team.team_id WHERE game_team.game_id = 34;
|
0.92 ms (7.71%)
|
1 |
SELECT t0.username AS username_1, t0.roles AS roles_2, t0.password AS password_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM player t0 WHERE t0.id = ?
SELECT t0.username AS username_1, t0.roles AS roles_2, t0.password AS password_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM player t0 WHERE t0.id = 3;
|
0.67 ms (5.57%)
|
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3 FROM team t0 INNER JOIN team_player ON t0.id = team_player.team_id WHERE team_player.player_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3 FROM team t0 INNER JOIN team_player ON t0.id = team_player.team_id WHERE team_player.player_id = 3;
|
0.64 ms (5.35%)
|
17 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.game_id AS game_id_4, t0.player_id AS player_id_5 FROM game_captain t0 WHERE t0.game_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.game_id AS game_id_4, t0.player_id AS player_id_5 FROM game_captain t0 WHERE t0.game_id = 53;
|
0.34 ms (2.86%)
|
1 |
SELECT t0.year AS year_1, t0.nb_games AS nb_games_2, t0.nb_victories AS nb_victories_3, t0.nb_defeats AS nb_defeats_4, t0.goal_average AS goal_average_5, t0.ranking AS ranking_6, t0.championship_ranking AS championship_ranking_7, t0.points AS points_8, t0.victory_rate AS victory_rate_9, t0.id AS id_10, t0.player_id AS player_id_11 FROM stats_player t0 WHERE t0.player_id = ?
SELECT t0.year AS year_1, t0.nb_games AS nb_games_2, t0.nb_victories AS nb_victories_3, t0.nb_defeats AS nb_defeats_4, t0.goal_average AS goal_average_5, t0.ranking AS ranking_6, t0.championship_ranking AS championship_ranking_7, t0.points AS points_8, t0.victory_rate AS victory_rate_9, t0.id AS id_10, t0.player_id AS player_id_11 FROM stats_player t0 WHERE t0.player_id = 3;
|