Symfony Profiler

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

Query Metrics

SELECT COUNT(p0_.id) AS sclr_0 FROM prediction_log p0_

[]

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  prediction_log p0_

SELECT COUNT(p0_.id) AS sclr_0 FROM prediction_log p0_;

SELECT p0_.id AS id_0, p0_.strategy AS strategy_1, p0_.main_numbers AS main_numbers_2, p0_.secondary_numbers AS secondary_numbers_3, p0_.confidence AS confidence_4, p0_.reasoning AS reasoning_5, p0_.created_at AS created_at_6, p0_.validated AS validated_7, p0_.validated_at AS validated_at_8, p0_.main_numbers_matched AS main_numbers_matched_9, p0_.secondary_numbers_matched AS secondary_numbers_matched_10, p0_.is_winner AS is_winner_11, p0_.prize_category AS prize_category_12, p0_.session_id AS session_id_13, p0_.game_id AS game_id_14, p0_.validated_against_draw_id AS validated_against_draw_id_15 FROM prediction_log p0_ WHERE p0_.validated = ? ORDER BY p0_.created_at DESC

[
  0
]

SELECT
  p0_.id AS id_0,
  p0_.strategy AS strategy_1,
  p0_.main_numbers AS main_numbers_2,
  p0_.secondary_numbers AS secondary_numbers_3,
  p0_.confidence AS confidence_4,
  p0_.reasoning AS reasoning_5,
  p0_.created_at AS created_at_6,
  p0_.validated AS validated_7,
  p0_.validated_at AS validated_at_8,
  p0_.main_numbers_matched AS main_numbers_matched_9,
  p0_.secondary_numbers_matched AS secondary_numbers_matched_10,
  p0_.is_winner AS is_winner_11,
  p0_.prize_category AS prize_category_12,
  p0_.session_id AS session_id_13,
  p0_.game_id AS game_id_14,
  p0_.validated_against_draw_id AS validated_against_draw_id_15
FROM
  prediction_log p0_
WHERE
  p0_.validated = ?
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.strategy AS strategy_1, p0_.main_numbers AS main_numbers_2, p0_.secondary_numbers AS secondary_numbers_3, p0_.confidence AS confidence_4, p0_.reasoning AS reasoning_5, p0_.created_at AS created_at_6, p0_.validated AS validated_7, p0_.validated_at AS validated_at_8, p0_.main_numbers_matched AS main_numbers_matched_9, p0_.secondary_numbers_matched AS secondary_numbers_matched_10, p0_.is_winner AS is_winner_11, p0_.prize_category AS prize_category_12, p0_.session_id AS session_id_13, p0_.game_id AS game_id_14, p0_.validated_against_draw_id AS validated_against_draw_id_15 FROM prediction_log p0_ WHERE p0_.validated = 0 ORDER BY p0_.created_at DESC;

SELECT p0_.id AS id_0, p0_.strategy AS strategy_1, p0_.main_numbers AS main_numbers_2, p0_.secondary_numbers AS secondary_numbers_3, p0_.confidence AS confidence_4, p0_.reasoning AS reasoning_5, p0_.created_at AS created_at_6, p0_.validated AS validated_7, p0_.validated_at AS validated_at_8, p0_.main_numbers_matched AS main_numbers_matched_9, p0_.secondary_numbers_matched AS secondary_numbers_matched_10, p0_.is_winner AS is_winner_11, p0_.prize_category AS prize_category_12, p0_.session_id AS session_id_13, p0_.game_id AS game_id_14, p0_.validated_against_draw_id AS validated_against_draw_id_15 FROM prediction_log p0_ WHERE p0_.is_winner = ? ORDER BY p0_.validated_at DESC

[
  1
]

SELECT
  p0_.id AS id_0,
  p0_.strategy AS strategy_1,
  p0_.main_numbers AS main_numbers_2,
  p0_.secondary_numbers AS secondary_numbers_3,
  p0_.confidence AS confidence_4,
  p0_.reasoning AS reasoning_5,
  p0_.created_at AS created_at_6,
  p0_.validated AS validated_7,
  p0_.validated_at AS validated_at_8,
  p0_.main_numbers_matched AS main_numbers_matched_9,
  p0_.secondary_numbers_matched AS secondary_numbers_matched_10,
  p0_.is_winner AS is_winner_11,
  p0_.prize_category AS prize_category_12,
  p0_.session_id AS session_id_13,
  p0_.game_id AS game_id_14,
  p0_.validated_against_draw_id AS validated_against_draw_id_15
FROM
  prediction_log p0_
WHERE
  p0_.is_winner = ?
ORDER BY
  p0_.validated_at DESC

SELECT p0_.id AS id_0, p0_.strategy AS strategy_1, p0_.main_numbers AS main_numbers_2, p0_.secondary_numbers AS secondary_numbers_3, p0_.confidence AS confidence_4, p0_.reasoning AS reasoning_5, p0_.created_at AS created_at_6, p0_.validated AS validated_7, p0_.validated_at AS validated_at_8, p0_.main_numbers_matched AS main_numbers_matched_9, p0_.secondary_numbers_matched AS secondary_numbers_matched_10, p0_.is_winner AS is_winner_11, p0_.prize_category AS prize_category_12, p0_.session_id AS session_id_13, p0_.game_id AS game_id_14, p0_.validated_against_draw_id AS validated_against_draw_id_15 FROM prediction_log p0_ WHERE p0_.is_winner = 1 ORDER BY p0_.validated_at DESC;

SELECT p0_.id AS id_0, p0_.strategy AS strategy_1, p0_.main_numbers AS main_numbers_2, p0_.secondary_numbers AS secondary_numbers_3, p0_.confidence AS confidence_4, p0_.reasoning AS reasoning_5, p0_.created_at AS created_at_6, p0_.validated AS validated_7, p0_.validated_at AS validated_at_8, p0_.main_numbers_matched AS main_numbers_matched_9, p0_.secondary_numbers_matched AS secondary_numbers_matched_10, p0_.is_winner AS is_winner_11, p0_.prize_category AS prize_category_12, p0_.session_id AS session_id_13, p0_.game_id AS game_id_14, p0_.validated_against_draw_id AS validated_against_draw_id_15 FROM prediction_log p0_ ORDER BY p0_.created_at DESC LIMIT 10

[]

SELECT
  p0_.id AS id_0,
  p0_.strategy AS strategy_1,
  p0_.main_numbers AS main_numbers_2,
  p0_.secondary_numbers AS secondary_numbers_3,
  p0_.confidence AS confidence_4,
  p0_.reasoning AS reasoning_5,
  p0_.created_at AS created_at_6,
  p0_.validated AS validated_7,
  p0_.validated_at AS validated_at_8,
  p0_.main_numbers_matched AS main_numbers_matched_9,
  p0_.secondary_numbers_matched AS secondary_numbers_matched_10,
  p0_.is_winner AS is_winner_11,
  p0_.prize_category AS prize_category_12,
  p0_.session_id AS session_id_13,
  p0_.game_id AS game_id_14,
  p0_.validated_against_draw_id AS validated_against_draw_id_15
FROM
  prediction_log p0_
ORDER BY
  p0_.created_at DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.strategy AS strategy_1, p0_.main_numbers AS main_numbers_2, p0_.secondary_numbers AS secondary_numbers_3, p0_.confidence AS confidence_4, p0_.reasoning AS reasoning_5, p0_.created_at AS created_at_6, p0_.validated AS validated_7, p0_.validated_at AS validated_at_8, p0_.main_numbers_matched AS main_numbers_matched_9, p0_.secondary_numbers_matched AS secondary_numbers_matched_10, p0_.is_winner AS is_winner_11, p0_.prize_category AS prize_category_12, p0_.session_id AS session_id_13, p0_.game_id AS game_id_14, p0_.validated_against_draw_id AS validated_against_draw_id_15 FROM prediction_log p0_ ORDER BY p0_.created_at DESC LIMIT 10;

SELECT p0_.strategy AS strategy_0, COUNT(p0_.id) AS sclr_1, SUM(CASE WHEN p0_.validated = true THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN p0_.is_winner = true THEN 1 ELSE 0 END) AS sclr_3, AVG(p0_.main_numbers_matched) AS sclr_4, AVG(p0_.secondary_numbers_matched) AS sclr_5 FROM prediction_log p0_ GROUP BY p0_.strategy ORDER BY sclr_3 DESC

[]

SELECT
  p0_.strategy AS strategy_0,
  COUNT(p0_.id) AS sclr_1,
  SUM(
    CASE WHEN p0_.validated = true THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(
    CASE WHEN p0_.is_winner = true THEN
      1
    ELSE
      0
    END
  ) AS sclr_3,
  AVG(p0_.main_numbers_matched) AS sclr_4,
  AVG(p0_.secondary_numbers_matched) AS sclr_5
FROM
  prediction_log p0_
GROUP BY
  p0_.strategy
ORDER BY
  sclr_3 DESC

SELECT p0_.strategy AS strategy_0, COUNT(p0_.id) AS sclr_1, SUM(CASE WHEN p0_.validated = true THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN p0_.is_winner = true THEN 1 ELSE 0 END) AS sclr_3, AVG(p0_.main_numbers_matched) AS sclr_4, AVG(p0_.secondary_numbers_matched) AS sclr_5 FROM prediction_log p0_ GROUP BY p0_.strategy ORDER BY sclr_3 DESC;

SELECT p0_.strategy AS strategy_0, COUNT(p0_.id) AS sclr_1, SUM(CASE WHEN p0_.validated = true THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN p0_.is_winner = true THEN 1 ELSE 0 END) AS sclr_3, AVG(p0_.main_numbers_matched) AS sclr_4, AVG(p0_.secondary_numbers_matched) AS sclr_5 FROM prediction_log p0_ GROUP BY p0_.strategy ORDER BY sclr_3 DESC

[]

SELECT
  p0_.strategy AS strategy_0,
  COUNT(p0_.id) AS sclr_1,
  SUM(
    CASE WHEN p0_.validated = true THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(
    CASE WHEN p0_.is_winner = true THEN
      1
    ELSE
      0
    END
  ) AS sclr_3,
  AVG(p0_.main_numbers_matched) AS sclr_4,
  AVG(p0_.secondary_numbers_matched) AS sclr_5
FROM
  prediction_log p0_
GROUP BY
  p0_.strategy
ORDER BY
  sclr_3 DESC

SELECT p0_.strategy AS strategy_0, COUNT(p0_.id) AS sclr_1, SUM(CASE WHEN p0_.validated = true THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN p0_.is_winner = true THEN 1 ELSE 0 END) AS sclr_3, AVG(p0_.main_numbers_matched) AS sclr_4, AVG(p0_.secondary_numbers_matched) AS sclr_5 FROM prediction_log p0_ GROUP BY p0_.strategy ORDER BY sclr_3 DESC;

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;