Symfony Profiler

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

Query Metrics

SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.forclusion_date AS forclusion_date_2, d0_.draw_number AS draw_number_3, d0_.day_of_week AS day_of_week_4, d0_.draw_type AS draw_type_5, d0_.currency AS currency_6, d0_.raw AS raw_7, g1_.id AS id_8, g1_.name AS name_9, g1_.number_of_balls AS number_of_balls_10, g1_.number_of_jokers AS number_of_jokers_11, g1_.number_of_stars AS number_of_stars_12, g1_.max_number AS max_number_13, g1_.max_star_number AS max_star_number_14, g1_.days AS days_15, g1_.strategy_identifier AS strategy_identifier_16, b2_.id AS id_17, b2_.number AS number_18, b2_.position AS position_19, b2_.type AS type_20, b2_.is_complementary AS is_complementary_21, p3_.id AS id_22, p3_.rank AS rank_23, p3_.winners_france AS winners_france_24, p3_.winners_europe AS winners_europe_25, p3_.prize_amount AS prize_amount_26, p3_.currency AS currency_27, d0_.game_id AS game_id_28, b2_.draw_id AS draw_id_29, p3_.draw_id AS draw_id_30 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id LEFT JOIN ball b2_ ON d0_.id = b2_.draw_id LEFT JOIN prize p3_ ON d0_.id = p3_.draw_id WHERE d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.date DESC

[
  7425
  7424
  7423
  7422
  7421
  2021
  2629
  2022
  2630
  2631
  2023
  2632
  2024
  2633
  2634
  2025
  2635
  2026
  2636
  2637
]

SELECT
  d0_.id AS id_0,
  d0_.date AS date_1,
  d0_.forclusion_date AS forclusion_date_2,
  d0_.draw_number AS draw_number_3,
  d0_.day_of_week AS day_of_week_4,
  d0_.draw_type AS draw_type_5,
  d0_.currency AS currency_6,
  d0_.raw AS raw_7,
  g1_.id AS id_8,
  g1_.name AS name_9,
  g1_.number_of_balls AS number_of_balls_10,
  g1_.number_of_jokers AS number_of_jokers_11,
  g1_.number_of_stars AS number_of_stars_12,
  g1_.max_number AS max_number_13,
  g1_.max_star_number AS max_star_number_14,
  g1_.days AS days_15,
  g1_.strategy_identifier AS strategy_identifier_16,
  b2_.id AS id_17,
  b2_.number AS number_18,
  b2_.position AS position_19,
  b2_.type AS type_20,
  b2_.is_complementary AS is_complementary_21,
  p3_.id AS id_22,
  p3_.rank AS rank_23,
  p3_.winners_france AS winners_france_24,
  p3_.winners_europe AS winners_europe_25,
  p3_.prize_amount AS prize_amount_26,
  p3_.currency AS currency_27,
  d0_.game_id AS game_id_28,
  b2_.draw_id AS draw_id_29,
  p3_.draw_id AS draw_id_30
FROM
  draw d0_
  LEFT JOIN game g1_ ON d0_.game_id = g1_.id
  LEFT JOIN ball b2_ ON d0_.id = b2_.draw_id
  LEFT JOIN prize p3_ ON d0_.id = p3_.draw_id
WHERE
  d0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  d0_.date DESC

SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.forclusion_date AS forclusion_date_2, d0_.draw_number AS draw_number_3, d0_.day_of_week AS day_of_week_4, d0_.draw_type AS draw_type_5, d0_.currency AS currency_6, d0_.raw AS raw_7, g1_.id AS id_8, g1_.name AS name_9, g1_.number_of_balls AS number_of_balls_10, g1_.number_of_jokers AS number_of_jokers_11, g1_.number_of_stars AS number_of_stars_12, g1_.max_number AS max_number_13, g1_.max_star_number AS max_star_number_14, g1_.days AS days_15, g1_.strategy_identifier AS strategy_identifier_16, b2_.id AS id_17, b2_.number AS number_18, b2_.position AS position_19, b2_.type AS type_20, b2_.is_complementary AS is_complementary_21, p3_.id AS id_22, p3_.rank AS rank_23, p3_.winners_france AS winners_france_24, p3_.winners_europe AS winners_europe_25, p3_.prize_amount AS prize_amount_26, p3_.currency AS currency_27, d0_.game_id AS game_id_28, b2_.draw_id AS draw_id_29, p3_.draw_id AS draw_id_30 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id LEFT JOIN ball b2_ ON d0_.id = b2_.draw_id LEFT JOIN prize p3_ ON d0_.id = p3_.draw_id WHERE d0_.id IN (7425, 7424, 7423, 7422, 7421, 2021, 2629, 2022, 2630, 2631, 2023, 2632, 2024, 2633, 2634, 2025, 2635, 2026, 2636, 2637) ORDER BY d0_.date DESC;

SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = ?

[
  7425
]

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.position AS position_3,
  t0.type AS type_4,
  t0.draw_id AS draw_id_5
FROM
  joker t0
WHERE
  t0.draw_id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.draw_id AS draw_id_5 FROM joker t0 WHERE t0.draw_id = 7425;

SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id

[]

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  draw d0_
  LEFT JOIN game g1_ ON d0_.game_id = g1_.id

SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id;

SELECT d0_.date AS date_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id ORDER BY d0_.date DESC LIMIT 1

[]

SELECT
  d0_.date AS date_0
FROM
  draw d0_
  LEFT JOIN game g1_ ON d0_.game_id = g1_.id
ORDER BY
  d0_.date DESC
LIMIT
  1

SELECT d0_.date AS date_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id ORDER BY d0_.date DESC LIMIT 1;

SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ WHERE d0_.date >= ?

[
  "2025-12-10 01:03:40"
]

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  draw d0_
WHERE
  d0_.date >= ?

SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ WHERE d0_.date >= '2025-12-10 01:03:40';

SELECT d0_.id AS id_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id ORDER BY d0_.date DESC LIMIT 20

[]

SELECT
  d0_.id AS id_0
FROM
  draw d0_
  LEFT JOIN game g1_ ON d0_.game_id = g1_.id
ORDER BY
  d0_.date DESC
LIMIT
  20

SELECT d0_.id AS id_0 FROM draw d0_ LEFT JOIN game g1_ ON d0_.game_id = g1_.id ORDER BY d0_.date DESC LIMIT 20;

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

[]

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

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;