Symfony Profiler

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  game g0_
WHERE
  g0_.played_at >= ?
  AND g0_.played_at < ?

SELECT COUNT(g0_.id) AS sclr_0 FROM game g0_ WHERE g0_.played_at >= '2025-01-01' AND g0_.played_at < '2026-01-01';

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  stats_player s0_
  INNER JOIN player p1_ ON s0_.player_id = p1_.id
WHERE
  s0_.year = ?
  AND s0_.championship_ranking > 0

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM stats_player s0_ INNER JOIN player p1_ ON s0_.player_id = p1_.id WHERE s0_.year = 2025 AND s0_.championship_ranking > 0;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.championship_ranking AS championship_ranking_1
FROM
  stats_player s0_
  INNER JOIN player p1_ ON s0_.player_id = p1_.id
WHERE
  s0_.year = ?
  AND s0_.championship_ranking > 0
ORDER BY
  s0_.championship_ranking ASC
LIMIT
  50

SELECT DISTINCT s0_.id AS id_0, s0_.championship_ranking AS championship_ranking_1 FROM stats_player s0_ INNER JOIN player p1_ ON s0_.player_id = p1_.id WHERE s0_.year = 2025 AND s0_.championship_ranking > 0 ORDER BY s0_.championship_ranking ASC LIMIT 50;

SELECT
  s0_.year AS year_0,
  s0_.nb_games AS nb_games_1,
  s0_.nb_victories AS nb_victories_2,
  s0_.nb_defeats AS nb_defeats_3,
  s0_.goal_average AS goal_average_4,
  s0_.ranking AS ranking_5,
  s0_.championship_ranking AS championship_ranking_6,
  s0_.points AS points_7,
  s0_.victory_rate AS victory_rate_8,
  s0_.id AS id_9,
  s0_.player_id AS player_id_10
FROM
  stats_player s0_
  INNER JOIN player p1_ ON s0_.player_id = p1_.id
WHERE
  s0_.year = ?
  AND s0_.championship_ranking > 0
  AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  s0_.championship_ranking ASC

SELECT s0_.year AS year_0, s0_.nb_games AS nb_games_1, s0_.nb_victories AS nb_victories_2, s0_.nb_defeats AS nb_defeats_3, s0_.goal_average AS goal_average_4, s0_.ranking AS ranking_5, s0_.championship_ranking AS championship_ranking_6, s0_.points AS points_7, s0_.victory_rate AS victory_rate_8, s0_.id AS id_9, s0_.player_id AS player_id_10 FROM stats_player s0_ INNER JOIN player p1_ ON s0_.player_id = p1_.id WHERE s0_.year = 2025 AND s0_.championship_ranking > 0 AND s0_.id IN (1629, 1630, 1634, 1645, 1631, 1635, 1637, 1640, 1636, 1638, 1639) ORDER BY s0_.championship_ranking ASC;

SELECT
  s0_.year AS year_0,
  s0_.nb_games AS nb_games_1,
  s0_.nb_victories AS nb_victories_2,
  s0_.nb_defeats AS nb_defeats_3,
  s0_.goal_average AS goal_average_4,
  s0_.ranking AS ranking_5,
  s0_.championship_ranking AS championship_ranking_6,
  s0_.points AS points_7,
  s0_.victory_rate AS victory_rate_8,
  s0_.id AS id_9,
  s0_.player_id AS player_id_10
FROM
  stats_player s0_
  INNER JOIN player p1_ ON s0_.player_id = p1_.id
WHERE
  s0_.year = ?
  AND s0_.championship_ranking > 0
ORDER BY
  s0_.championship_ranking ASC
LIMIT
  3

SELECT s0_.year AS year_0, s0_.nb_games AS nb_games_1, s0_.nb_victories AS nb_victories_2, s0_.nb_defeats AS nb_defeats_3, s0_.goal_average AS goal_average_4, s0_.ranking AS ranking_5, s0_.championship_ranking AS championship_ranking_6, s0_.points AS points_7, s0_.victory_rate AS victory_rate_8, s0_.id AS id_9, s0_.player_id AS player_id_10 FROM stats_player s0_ INNER JOIN player p1_ ON s0_.player_id = p1_.id WHERE s0_.year = 2025 AND s0_.championship_ranking > 0 ORDER BY s0_.championship_ranking ASC LIMIT 3;

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

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

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

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

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;

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;

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

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

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;