4.85 ms (36.14%)
|
44 |
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 = 2;
|
2.71 ms (20.23%)
|
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.84 ms (13.75%)
|
44 |
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 = 2;
|
1.40 ms (10.41%)
|
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 (6.83%)
|
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 = 10;
|
0.88 ms (6.54%)
|
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 = 54;
|
0.46 ms (3.46%)
|
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 = 10;
|
0.36 ms (2.65%)
|
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 = 10;
|