0.95 ms (24.09%)
|
2 |
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 = 31;
|
0.88 ms (22.47%)
|
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 = 26;
|
0.51 ms (12.84%)
|
2 |
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 = 107;
|
0.44 ms (11.26%)
|
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 = 26;
|
0.36 ms (9.17%)
|
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 = 26;
|
0.29 ms (7.29%)
|
2 |
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 = 31;
|
0.27 ms (6.88%)
|
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 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 = 52;
|
0.24 ms (5.99%)
|
1 |
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 = 52;
|