Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.pdf AS pdf_2, t0.status AS status_3, t0.name AS name_4, t0.exam_duration AS exam_duration_5, t0.exam_question_number AS exam_question_number_6, t0.exam_answer_number AS exam_answer_number_7, t0.score_error AS score_error_8, t0.score_blank AS score_blank_9, t0.score_correct AS score_correct_10, t0.score_type AS score_type_11, t0.score_threshold AS score_threshold_12, t0.created_at AS created_at_13, t0.dataset_id AS dataset_id_14 FROM dataset_version t0 WHERE t0.id = ?

[
  "36"
]

SELECT
  t0.id AS id_1,
  t0.pdf AS pdf_2,
  t0.status AS status_3,
  t0.name AS name_4,
  t0.exam_duration AS exam_duration_5,
  t0.exam_question_number AS exam_question_number_6,
  t0.exam_answer_number AS exam_answer_number_7,
  t0.score_error AS score_error_8,
  t0.score_blank AS score_blank_9,
  t0.score_correct AS score_correct_10,
  t0.score_type AS score_type_11,
  t0.score_threshold AS score_threshold_12,
  t0.created_at AS created_at_13,
  t0.dataset_id AS dataset_id_14
FROM
  dataset_version t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.pdf AS pdf_2, t0.status AS status_3, t0.name AS name_4, t0.exam_duration AS exam_duration_5, t0.exam_question_number AS exam_question_number_6, t0.exam_answer_number AS exam_answer_number_7, t0.score_error AS score_error_8, t0.score_blank AS score_blank_9, t0.score_correct AS score_correct_10, t0.score_type AS score_type_11, t0.score_threshold AS score_threshold_12, t0.created_at AS created_at_13, t0.dataset_id AS dataset_id_14 FROM dataset_version t0 WHERE t0.id = '36';

SELECT d0_.id AS id_0, d0_.number AS number_1, d0_.dataset_version_id AS dataset_version_id_2, d0_.subject_id AS subject_id_3 FROM dataset_version_has_subject d0_ INNER JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.dataset_version_id = ?

[
  36
]

SELECT
  d0_.id AS id_0,
  d0_.number AS number_1,
  d0_.dataset_version_id AS dataset_version_id_2,
  d0_.subject_id AS subject_id_3
FROM
  dataset_version_has_subject d0_
  INNER JOIN subject s1_ ON d0_.subject_id = s1_.id
WHERE
  d0_.dataset_version_id = ?

SELECT d0_.id AS id_0, d0_.number AS number_1, d0_.dataset_version_id AS dataset_version_id_2, d0_.subject_id AS subject_id_3 FROM dataset_version_has_subject d0_ INNER JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.dataset_version_id = 36;

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

[
  8
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 8;

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

[
  949
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 949;

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

[
  950
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 950;

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

[
  6
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 6;

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

[
  952
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 952;

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

[
  18
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 18;

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

[
  5
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 5;

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

[
  948
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 948;

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

[
  13
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 13;

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = ?

[
  1104
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM subject t0 WHERE t0.id = 1104;

SELECT SUM(d0_.number) AS sclr_0 FROM dataset_version_has_subject d0_ WHERE d0_.dataset_version_id = ?

[
  36
]

SELECT
  SUM(d0_.number) AS sclr_0
FROM
  dataset_version_has_subject d0_
WHERE
  d0_.dataset_version_id = ?

SELECT SUM(d0_.number) AS sclr_0 FROM dataset_version_has_subject d0_ WHERE d0_.dataset_version_id = 36;

SELECT d0_.id AS id_0, d0_.number AS number_1, s1_.id AS id_2, s1_.name AS name_3, d0_.dataset_version_id AS dataset_version_id_4, d0_.subject_id AS subject_id_5 FROM dataset_version_has_subject d0_ LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.id = ? ORDER BY d0_.id ASC LIMIT 20

[
  36
]

SELECT
  d0_.id AS id_0,
  d0_.number AS number_1,
  s1_.id AS id_2,
  s1_.name AS name_3,
  d0_.dataset_version_id AS dataset_version_id_4,
  d0_.subject_id AS subject_id_5
FROM
  dataset_version_has_subject d0_
  LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id
WHERE
  d0_.id = ?
ORDER BY
  d0_.id ASC
LIMIT
  20

SELECT d0_.id AS id_0, d0_.number AS number_1, s1_.id AS id_2, s1_.name AS name_3, d0_.dataset_version_id AS dataset_version_id_4, d0_.subject_id AS subject_id_5 FROM dataset_version_has_subject d0_ LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.id = 36 ORDER BY d0_.id ASC LIMIT 20;

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dataset_version_has_subject d0_ LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.id = ?

[
  36
]

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  dataset_version_has_subject d0_
  LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id
WHERE
  d0_.id = ?

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dataset_version_has_subject d0_ LEFT JOIN subject s1_ ON d0_.subject_id = s1_.id WHERE d0_.id = 36;