5.73 ms (37.20%)
|
49 |
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;
|
3.13 ms (20.32%)
|
40 |
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;
|
2.04 ms (13.24%)
|
49 |
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.63 ms (10.57%)
|
20 |
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;
|
1.00 ms (6.50%)
|
20 |
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.92 ms (5.95%)
|
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 = 6;
|
0.61 ms (3.96%)
|
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 = 6;
|
0.35 ms (2.28%)
|
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 = 6;
|