Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Exception
• Logs 15
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Serializer
• Mercure
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.with_dataset AS with_dataset_3, t0.active AS active_4, t0.hero_image AS hero_image_5, t0.name AS name_6, t0.content AS content_7, t0.created_at AS created_at_8 FROM competition t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1

[
  "concorso-polizia-di-stato-2025-riservato-ai-civili"
  1
]

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.with_dataset AS with_dataset_3,
  t0.active AS active_4,
  t0.hero_image AS hero_image_5,
  t0.name AS name_6,
  t0.content AS content_7,
  t0.created_at AS created_at_8
FROM
  competition t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.with_dataset AS with_dataset_3, t0.active AS active_4, t0.hero_image AS hero_image_5, t0.name AS name_6, t0.content AS content_7, t0.created_at AS created_at_8 FROM competition t0 WHERE t0.slug = 'concorso-polizia-di-stato-2025-riservato-ai-civili' AND t0.active = 1 LIMIT 1;

SELECT d0_.id AS id_0, d0_.pdf AS pdf_1, d0_.status AS status_2, d0_.name AS name_3, d0_.exam_duration AS exam_duration_4, d0_.exam_question_number AS exam_question_number_5, d0_.exam_answer_number AS exam_answer_number_6, d0_.score_error AS score_error_7, d0_.score_blank AS score_blank_8, d0_.score_correct AS score_correct_9, d0_.score_type AS score_type_10, d0_.score_threshold AS score_threshold_11, d0_.created_at AS created_at_12, d0_.dataset_id AS dataset_id_13 FROM dataset_version d0_ LEFT JOIN dataset d1_ ON d0_.dataset_id = d1_.id LEFT JOIN competition c2_ ON d1_.competition_id = c2_.id WHERE c2_.slug = ? AND d0_.status = ? AND d1_.official = 1 ORDER BY d0_.created_at DESC LIMIT 1

[
  "concorso-polizia-di-stato-2025-riservato-ai-civili"
  "ACTIVE"
]

SELECT
  d0_.id AS id_0,
  d0_.pdf AS pdf_1,
  d0_.status AS status_2,
  d0_.name AS name_3,
  d0_.exam_duration AS exam_duration_4,
  d0_.exam_question_number AS exam_question_number_5,
  d0_.exam_answer_number AS exam_answer_number_6,
  d0_.score_error AS score_error_7,
  d0_.score_blank AS score_blank_8,
  d0_.score_correct AS score_correct_9,
  d0_.score_type AS score_type_10,
  d0_.score_threshold AS score_threshold_11,
  d0_.created_at AS created_at_12,
  d0_.dataset_id AS dataset_id_13
FROM
  dataset_version d0_
  LEFT JOIN dataset d1_ ON d0_.dataset_id = d1_.id
  LEFT JOIN competition c2_ ON d1_.competition_id = c2_.id
WHERE
  c2_.slug = ?
  AND d0_.status = ?
  AND d1_.official = 1
ORDER BY
  d0_.created_at DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.pdf AS pdf_1, d0_.status AS status_2, d0_.name AS name_3, d0_.exam_duration AS exam_duration_4, d0_.exam_question_number AS exam_question_number_5, d0_.exam_answer_number AS exam_answer_number_6, d0_.score_error AS score_error_7, d0_.score_blank AS score_blank_8, d0_.score_correct AS score_correct_9, d0_.score_type AS score_type_10, d0_.score_threshold AS score_threshold_11, d0_.created_at AS created_at_12, d0_.dataset_id AS dataset_id_13 FROM dataset_version d0_ LEFT JOIN dataset d1_ ON d0_.dataset_id = d1_.id LEFT JOIN competition c2_ ON d1_.competition_id = c2_.id WHERE c2_.slug = 'concorso-polizia-di-stato-2025-riservato-ai-civili' AND d0_.status = 'ACTIVE' AND d1_.official = 1 ORDER BY d0_.created_at DESC LIMIT 1;

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.facebook_group AS facebook_group_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.official AS official_8, t0.competition_id AS competition_id_9 FROM dataset t0 WHERE t0.id = ?

[
  20
]

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.facebook_group AS facebook_group_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.official AS official_8,
  t0.competition_id AS competition_id_9
FROM
  dataset t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.facebook_group AS facebook_group_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.official AS official_8, t0.competition_id AS competition_id_9 FROM dataset t0 WHERE t0.id = 20;