Symfony Profiler

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

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  prediction_log p0_
WHERE
  p0_.game_id = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM prediction_log p0_ WHERE p0_.game_id = 2;

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 = ?
  AND p0_.game_id = ?
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 AND p0_.game_id = 2 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 = ?
  AND p0_.game_id = ?
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 AND p0_.game_id = 2 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_.game_id = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  20

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_.game_id = 2 ORDER BY p0_.created_at DESC LIMIT 20;

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_
WHERE
  p0_.game_id = ?
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_ WHERE p0_.game_id = 2 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_
WHERE
  p0_.game_id = ?
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_ WHERE p0_.game_id = 2 GROUP BY p0_.strategy ORDER BY sclr_3 DESC;