Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.rounds AS rounds_3, t0.league_id AS league_id_4 FROM division t0 WHERE t0.id = ?

[
  "4"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.rounds AS rounds_3,
  t0.league_id AS league_id_4
FROM
  division t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.rounds AS rounds_3, t0.league_id AS league_id_4 FROM division t0 WHERE t0.id = '4';

SELECT MAX(l0_.round) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = ?

[
  4
]

SELECT
  MAX(l0_.round) AS sclr_0
FROM
  league_match_team l1_
  INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id
WHERE
  l0_.division_id = ?

SELECT MAX(l0_.round) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = 4;

SELECT MAX(l0_.round) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = ? AND l1_.points > 0

[
  4
]

SELECT
  MAX(l0_.round) AS sclr_0
FROM
  league_match_team l1_
  INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id
WHERE
  l0_.division_id = ?
  AND l1_.points > 0

SELECT MAX(l0_.round) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = 4 AND l1_.points > 0;

SELECT MIN(l0_.datetime) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = ? AND l0_.round = ?

[
  4
  15
]

SELECT
  MIN(l0_.datetime) AS sclr_0
FROM
  league_match_team l1_
  INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id
WHERE
  l0_.division_id = ?
  AND l0_.round = ?

SELECT MIN(l0_.datetime) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = 4 AND l0_.round = 15;

SELECT l0_.team_id AS sclr_0, t1_.name AS name_1, l0_.league_match_id AS sclr_2, l0_.points AS points_3, l0_.pinfall AS pinfall_4 FROM league_match_team l0_ INNER JOIN team t1_ ON l0_.team_id = t1_.id INNER JOIN league_match l2_ ON l0_.league_match_id = l2_.id WHERE l2_.division_id = ? AND l2_.round <= ?

[
  4
  7
]

SELECT
  l0_.team_id AS sclr_0,
  t1_.name AS name_1,
  l0_.league_match_id AS sclr_2,
  l0_.points AS points_3,
  l0_.pinfall AS pinfall_4
FROM
  league_match_team l0_
  INNER JOIN team t1_ ON l0_.team_id = t1_.id
  INNER JOIN league_match l2_ ON l0_.league_match_id = l2_.id
WHERE
  l2_.division_id = ?
  AND l2_.round <= ?

SELECT l0_.team_id AS sclr_0, t1_.name AS name_1, l0_.league_match_id AS sclr_2, l0_.points AS points_3, l0_.pinfall AS pinfall_4 FROM league_match_team l0_ INNER JOIN team t1_ ON l0_.team_id = t1_.id INNER JOIN league_match l2_ ON l0_.league_match_id = l2_.id WHERE l2_.division_id = 4 AND l2_.round <= 7;

SELECT l0_.id AS id_0, l0_.datetime AS datetime_1, t1_.name AS name_2, l2_.points AS points_3, l2_.pinfall AS pinfall_4 FROM league_match_team l2_ INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id INNER JOIN team t1_ ON l2_.team_id = t1_.id WHERE l0_.division_id = ? AND l0_.round = ? ORDER BY l0_.datetime ASC, l0_.id ASC, l2_.ordering ASC

[
  4
  7
]

SELECT
  l0_.id AS id_0,
  l0_.datetime AS datetime_1,
  t1_.name AS name_2,
  l2_.points AS points_3,
  l2_.pinfall AS pinfall_4
FROM
  league_match_team l2_
  INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id
  INNER JOIN team t1_ ON l2_.team_id = t1_.id
WHERE
  l0_.division_id = ?
  AND l0_.round = ?
ORDER BY
  l0_.datetime ASC,
  l0_.id ASC,
  l2_.ordering ASC

SELECT l0_.id AS id_0, l0_.datetime AS datetime_1, t1_.name AS name_2, l2_.points AS points_3, l2_.pinfall AS pinfall_4 FROM league_match_team l2_ INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id INNER JOIN team t1_ ON l2_.team_id = t1_.id WHERE l0_.division_id = 4 AND l0_.round = 7 ORDER BY l0_.datetime ASC, l0_.id ASC, l2_.ordering ASC;

SELECT l0_.id AS id_0, l0_.datetime AS datetime_1, t1_.name AS name_2 FROM league_match_team l2_ INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id INNER JOIN team t1_ ON l2_.team_id = t1_.id WHERE l0_.division_id = ? AND l0_.round = ? ORDER BY l0_.datetime ASC, l0_.id ASC, l2_.ordering ASC

[
  4
  8
]

SELECT
  l0_.id AS id_0,
  l0_.datetime AS datetime_1,
  t1_.name AS name_2
FROM
  league_match_team l2_
  INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id
  INNER JOIN team t1_ ON l2_.team_id = t1_.id
WHERE
  l0_.division_id = ?
  AND l0_.round = ?
ORDER BY
  l0_.datetime ASC,
  l0_.id ASC,
  l2_.ordering ASC

SELECT l0_.id AS id_0, l0_.datetime AS datetime_1, t1_.name AS name_2 FROM league_match_team l2_ INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id INNER JOIN team t1_ ON l2_.team_id = t1_.id WHERE l0_.division_id = 4 AND l0_.round = 8 ORDER BY l0_.datetime ASC, l0_.id ASC, l2_.ordering ASC;

SELECT l0_.team_id AS sclr_0, p1_.firstname AS firstname_1, p1_.lastname AS lastname_2, l2_.scores AS scores_3 FROM league_match_participant l2_ INNER JOIN league_match_team l0_ ON l2_.league_match_team_id = l0_.id INNER JOIN league_match l3_ ON l0_.league_match_id = l3_.id INNER JOIN player p1_ ON l2_.player_id = p1_.id WHERE l3_.division_id = ? AND l3_.round <= ?

[
  4
  7
]

SELECT
  l0_.team_id AS sclr_0,
  p1_.firstname AS firstname_1,
  p1_.lastname AS lastname_2,
  l2_.scores AS scores_3
FROM
  league_match_participant l2_
  INNER JOIN league_match_team l0_ ON l2_.league_match_team_id = l0_.id
  INNER JOIN league_match l3_ ON l0_.league_match_id = l3_.id
  INNER JOIN player p1_ ON l2_.player_id = p1_.id
WHERE
  l3_.division_id = ?
  AND l3_.round <= ?

SELECT l0_.team_id AS sclr_0, p1_.firstname AS firstname_1, p1_.lastname AS lastname_2, l2_.scores AS scores_3 FROM league_match_participant l2_ INNER JOIN league_match_team l0_ ON l2_.league_match_team_id = l0_.id INNER JOIN league_match l3_ ON l0_.league_match_id = l3_.id INNER JOIN player p1_ ON l2_.player_id = p1_.id WHERE l3_.division_id = 4 AND l3_.round <= 7;

SELECT t0.id AS id_1, t0.name AS name_2, t0.default_alley_id AS default_alley_id_3 FROM league t0 WHERE t0.id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.default_alley_id AS default_alley_id_3
FROM
  league t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.default_alley_id AS default_alley_id_3 FROM league t0 WHERE t0.id = 4;