Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• 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.games AS games_4, t0.points_win_high_pinfall AS points_win_high_pinfall_5, t0.points_win_equal_pinfall AS points_win_equal_pinfall_6, t0.points_win_low_pinfall AS points_win_low_pinfall_7, t0.points_draw_high_pinfall AS points_draw_high_pinfall_8, t0.points_draw_equal_pinfall AS points_draw_equal_pinfall_9, t0.points_draw_low_pinfall AS points_draw_low_pinfall_10, t0.points_loss_high_pinfall AS points_loss_high_pinfall_11, t0.points_loss_equal_pinfall AS points_loss_equal_pinfall_12, t0.points_loss_low_pinfall AS points_loss_low_pinfall_13, t0.match_type AS match_type_14, t0.league_id AS league_id_15 FROM division t0 WHERE t0.id = ?

[
  "20"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.rounds AS rounds_3,
  t0.games AS games_4,
  t0.points_win_high_pinfall AS points_win_high_pinfall_5,
  t0.points_win_equal_pinfall AS points_win_equal_pinfall_6,
  t0.points_win_low_pinfall AS points_win_low_pinfall_7,
  t0.points_draw_high_pinfall AS points_draw_high_pinfall_8,
  t0.points_draw_equal_pinfall AS points_draw_equal_pinfall_9,
  t0.points_draw_low_pinfall AS points_draw_low_pinfall_10,
  t0.points_loss_high_pinfall AS points_loss_high_pinfall_11,
  t0.points_loss_equal_pinfall AS points_loss_equal_pinfall_12,
  t0.points_loss_low_pinfall AS points_loss_low_pinfall_13,
  t0.match_type AS match_type_14,
  t0.league_id AS league_id_15
FROM
  division t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.rounds AS rounds_3, t0.games AS games_4, t0.points_win_high_pinfall AS points_win_high_pinfall_5, t0.points_win_equal_pinfall AS points_win_equal_pinfall_6, t0.points_win_low_pinfall AS points_win_low_pinfall_7, t0.points_draw_high_pinfall AS points_draw_high_pinfall_8, t0.points_draw_equal_pinfall AS points_draw_equal_pinfall_9, t0.points_draw_low_pinfall AS points_draw_low_pinfall_10, t0.points_loss_high_pinfall AS points_loss_high_pinfall_11, t0.points_loss_equal_pinfall AS points_loss_equal_pinfall_12, t0.points_loss_low_pinfall AS points_loss_low_pinfall_13, t0.match_type AS match_type_14, t0.league_id AS league_id_15 FROM division t0 WHERE t0.id = '20';

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

[
  20
]

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

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

[
  20
]

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

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

[
  20
  11
]

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 = 20 AND l2_.round <= 11;

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

[
  20
  11
]

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 = 20 AND l0_.round = 11 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 <= ?

[
  20
  11
]

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 = 20 AND l3_.round <= 11;

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

[
  13
]

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