Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.number_of_balls AS number_of_balls_3, t0.number_of_jokers AS number_of_jokers_4, t0.number_of_stars AS number_of_stars_5, t0.max_number AS max_number_6, t0.max_star_number AS max_star_number_7, t0.days AS days_8, t0.strategy_identifier AS strategy_identifier_9 FROM game t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number_of_balls AS number_of_balls_3,
  t0.number_of_jokers AS number_of_jokers_4,
  t0.number_of_stars AS number_of_stars_5,
  t0.max_number AS max_number_6,
  t0.max_star_number AS max_star_number_7,
  t0.days AS days_8,
  t0.strategy_identifier AS strategy_identifier_9
FROM
  game t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number_of_balls AS number_of_balls_3, t0.number_of_jokers AS number_of_jokers_4, t0.number_of_stars AS number_of_stars_5, t0.max_number AS max_number_6, t0.max_star_number AS max_star_number_7, t0.days AS days_8, t0.strategy_identifier AS strategy_identifier_9 FROM game t0 WHERE t0.id = 1;

SELECT p0_.rank AS rank_0, AVG(p0_.prize_amount) AS sclr_1, MAX(p0_.prize_amount) AS sclr_2, MIN(p0_.prize_amount) AS sclr_3, SUM(p0_.winners_france) AS sclr_4, COUNT(p0_.id) AS sclr_5 FROM prize p0_ INNER JOIN draw d1_ ON p0_.draw_id = d1_.id WHERE d1_.game_id = ? AND p0_.prize_amount IS NOT NULL GROUP BY p0_.rank ORDER BY p0_.rank ASC

[
  1
]

SELECT
  p0_.rank AS rank_0,
  AVG(p0_.prize_amount) AS sclr_1,
  MAX(p0_.prize_amount) AS sclr_2,
  MIN(p0_.prize_amount) AS sclr_3,
  SUM(p0_.winners_france) AS sclr_4,
  COUNT(p0_.id) AS sclr_5
FROM
  prize p0_
  INNER JOIN draw d1_ ON p0_.draw_id = d1_.id
WHERE
  d1_.game_id = ?
  AND p0_.prize_amount IS NOT NULL
GROUP BY
  p0_.rank
ORDER BY
  p0_.rank ASC

SELECT p0_.rank AS rank_0, AVG(p0_.prize_amount) AS sclr_1, MAX(p0_.prize_amount) AS sclr_2, MIN(p0_.prize_amount) AS sclr_3, SUM(p0_.winners_france) AS sclr_4, COUNT(p0_.id) AS sclr_5 FROM prize p0_ INNER JOIN draw d1_ ON p0_.draw_id = d1_.id WHERE d1_.game_id = 1 AND p0_.prize_amount IS NOT NULL GROUP BY p0_.rank ORDER BY p0_.rank ASC;

SELECT p0_.prize_amount AS prize_amount_0, p0_.winners_france AS winners_france_1, d1_.date AS date_2 FROM prize p0_ INNER JOIN draw d1_ ON p0_.draw_id = d1_.id WHERE d1_.game_id = ? AND p0_.rank = 1 AND p0_.prize_amount IS NOT NULL ORDER BY d1_.date DESC

[
  1
]

SELECT
  p0_.prize_amount AS prize_amount_0,
  p0_.winners_france AS winners_france_1,
  d1_.date AS date_2
FROM
  prize p0_
  INNER JOIN draw d1_ ON p0_.draw_id = d1_.id
WHERE
  d1_.game_id = ?
  AND p0_.rank = 1
  AND p0_.prize_amount IS NOT NULL
ORDER BY
  d1_.date DESC

SELECT p0_.prize_amount AS prize_amount_0, p0_.winners_france AS winners_france_1, d1_.date AS date_2 FROM prize p0_ INNER JOIN draw d1_ ON p0_.draw_id = d1_.id WHERE d1_.game_id = 1 AND p0_.rank = 1 AND p0_.prize_amount IS NOT NULL ORDER BY d1_.date DESC;