Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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
]

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;

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
]

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;

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 = ?

[
  2
]

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 = 2;

SELECT p0_.username AS username_0, p0_.roles AS roles_1, p0_.password AS password_2, p0_.id AS id_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5 FROM player p0_ INNER JOIN team_player t2_ ON p0_.id = t2_.player_id INNER JOIN team t1_ ON t1_.id = t2_.team_id INNER JOIN game_team g4_ ON t1_.id = g4_.team_id INNER JOIN game g3_ ON g3_.id = g4_.game_id WHERE g3_.played_at >= ? AND g3_.played_at < ? ORDER BY g3_.played_at DESC

[
  "2025-01-01"
  "2026-01-01"
]

SELECT
  p0_.username AS username_0,
  p0_.roles AS roles_1,
  p0_.password AS password_2,
  p0_.id AS id_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5
FROM
  player p0_
  INNER JOIN team_player t2_ ON p0_.id = t2_.player_id
  INNER JOIN team t1_ ON t1_.id = t2_.team_id
  INNER JOIN game_team g4_ ON t1_.id = g4_.team_id
  INNER JOIN game g3_ ON g3_.id = g4_.game_id
WHERE
  g3_.played_at >= ?
  AND g3_.played_at < ?
ORDER BY
  g3_.played_at DESC

SELECT p0_.username AS username_0, p0_.roles AS roles_1, p0_.password AS password_2, p0_.id AS id_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5 FROM player p0_ INNER JOIN team_player t2_ ON p0_.id = t2_.player_id INNER JOIN team t1_ ON t1_.id = t2_.team_id INNER JOIN game_team g4_ ON t1_.id = g4_.team_id INNER JOIN game g3_ ON g3_.id = g4_.game_id WHERE g3_.played_at >= '2025-01-01' AND g3_.played_at < '2026-01-01' ORDER BY g3_.played_at DESC;

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 = ?

[
  2
]

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 = 2;

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 = ?

[
  36
]

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 = 36;

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3 FROM team t0 WHERE t0.id = ?

[
  70
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3
FROM
  team t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3 FROM team t0 WHERE t0.id = 70;