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 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, d0_.game_id AS game_id_8 FROM draw d0_ WHERE d0_.game_id = ? ORDER BY d0_.date DESC LIMIT 5

[
  2
]

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,
  d0_.game_id AS game_id_8
FROM
  draw d0_
WHERE
  d0_.game_id = ?
ORDER BY
  d0_.date DESC
LIMIT
  5

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, d0_.game_id AS game_id_8 FROM draw d0_ WHERE d0_.game_id = 2 ORDER BY d0_.date DESC LIMIT 5;

SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.type AS type_4, t0.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = ?

[
  7460
]

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.position AS position_3,
  t0.type AS type_4,
  t0.is_complementary AS is_complementary_5,
  t0.draw_id AS draw_id_6
FROM
  ball 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.is_complementary AS is_complementary_5, t0.draw_id AS draw_id_6 FROM ball t0 WHERE t0.draw_id = 7460;

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;

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

[
  2
]

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

SELECT COUNT(d0_.id) AS sclr_0 FROM draw d0_ WHERE d0_.game_id = 2;

SELECT COUNT(s0_.id) AS sclr_0 FROM sync s0_ WHERE s0_.status = ?

[
  "success"
]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sync s0_
WHERE
  s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sync s0_ WHERE s0_.status = 'success';

SELECT t0.id AS id_1, t0.last_sync_date AS last_sync_date_2, t0.last_data_date AS last_data_date_3, t0.total_records AS total_records_4, t0.last_import_records AS last_import_records_5, t0.last_import_file AS last_import_file_6, t0.status AS status_7, t0.last_error AS last_error_8, t0.processed_rows AS processed_rows_9, t0.total_rows AS total_rows_10, t0.last_processed_file AS last_processed_file_11, t0.last_file_hash AS last_file_hash_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.game_id AS game_id_15 FROM sync t0 WHERE t0.game_id = ? LIMIT 1

[
  2
]

SELECT
  t0.id AS id_1,
  t0.last_sync_date AS last_sync_date_2,
  t0.last_data_date AS last_data_date_3,
  t0.total_records AS total_records_4,
  t0.last_import_records AS last_import_records_5,
  t0.last_import_file AS last_import_file_6,
  t0.status AS status_7,
  t0.last_error AS last_error_8,
  t0.processed_rows AS processed_rows_9,
  t0.total_rows AS total_rows_10,
  t0.last_processed_file AS last_processed_file_11,
  t0.last_file_hash AS last_file_hash_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.game_id AS game_id_15
FROM
  sync t0
WHERE
  t0.game_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.last_sync_date AS last_sync_date_2, t0.last_data_date AS last_data_date_3, t0.total_records AS total_records_4, t0.last_import_records AS last_import_records_5, t0.last_import_file AS last_import_file_6, t0.status AS status_7, t0.last_error AS last_error_8, t0.processed_rows AS processed_rows_9, t0.total_rows AS total_rows_10, t0.last_processed_file AS last_processed_file_11, t0.last_file_hash AS last_file_hash_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.game_id AS game_id_15 FROM sync t0 WHERE t0.game_id = 2 LIMIT 1;

SELECT COUNT(s0_.id) AS sclr_0 FROM sync s0_

[]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sync s0_

SELECT COUNT(s0_.id) AS sclr_0 FROM sync s0_;

SELECT SUM(s0_.total_records) AS sclr_0 FROM sync s0_

[]

SELECT
  SUM(s0_.total_records) AS sclr_0
FROM
  sync s0_

SELECT SUM(s0_.total_records) AS sclr_0 FROM sync s0_;