Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.active_session_token AS active_session_token_5, t0.full_name AS full_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.access_until AS access_until_9 FROM "user" t0 WHERE t0.id = ?

[
  55
]

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.active_session_token AS active_session_token_5,
  t0.full_name AS full_name_6,
  t0.is_active AS is_active_7,
  t0.created_at AS created_at_8,
  t0.access_until AS access_until_9
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.active_session_token AS active_session_token_5, t0.full_name AS full_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.access_until AS access_until_9 FROM "user" t0 WHERE t0.id = 55;

SELECT t0.id AS id_1, t0.selected_option_ids AS selected_option_ids_2, t0.is_correct AS is_correct_3, t0.points AS points_4, t0.attempt_id AS attempt_id_5, t0.question_id AS question_id_6 FROM attempt_answer t0 WHERE t0.attempt_id = ? ORDER BY t0.id ASC

[
  2296
]

SELECT
  t0.id AS id_1,
  t0.selected_option_ids AS selected_option_ids_2,
  t0.is_correct AS is_correct_3,
  t0.points AS points_4,
  t0.attempt_id AS attempt_id_5,
  t0.question_id AS question_id_6
FROM
  attempt_answer t0
WHERE
  t0.attempt_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.selected_option_ids AS selected_option_ids_2, t0.is_correct AS is_correct_3, t0.points AS points_4, t0.attempt_id AS attempt_id_5, t0.question_id AS question_id_6 FROM attempt_answer t0 WHERE t0.attempt_id = 2296 ORDER BY t0.id ASC;

SELECT t0.id AS id_1, t0.text AS text_2, t0.explanation AS explanation_3, t0.type AS type_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6, t0.points AS points_7, t0.section_id AS section_id_8 FROM question t0 WHERE t0.id = ?

[
  5817
]

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.explanation AS explanation_3,
  t0.type AS type_4,
  t0.sort_order AS sort_order_5,
  t0.is_active AS is_active_6,
  t0.points AS points_7,
  t0.section_id AS section_id_8
FROM
  question t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.explanation AS explanation_3, t0.type AS type_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6, t0.points AS points_7, t0.section_id AS section_id_8 FROM question t0 WHERE t0.id = 5817;

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT t0.id AS id_1, t0.question_ids AS question_ids_2, t0.current_index AS current_index_3, t0.started_at AS started_at_4, t0.expires_at AS expires_at_5, t0.finished_at AS finished_at_6, t0.score AS score_7, t0.max_score AS max_score_8, t0.passed AS passed_9, t0.user_id AS user_id_10, t0.section_id AS section_id_11, t0.subcategory_id AS subcategory_id_12, t0.section_group_id AS section_group_id_13 FROM attempt t0 WHERE t0.id = ?

[
  2296
]

SELECT
  t0.id AS id_1,
  t0.question_ids AS question_ids_2,
  t0.current_index AS current_index_3,
  t0.started_at AS started_at_4,
  t0.expires_at AS expires_at_5,
  t0.finished_at AS finished_at_6,
  t0.score AS score_7,
  t0.max_score AS max_score_8,
  t0.passed AS passed_9,
  t0.user_id AS user_id_10,
  t0.section_id AS section_id_11,
  t0.subcategory_id AS subcategory_id_12,
  t0.section_group_id AS section_group_id_13
FROM
  attempt t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.question_ids AS question_ids_2, t0.current_index AS current_index_3, t0.started_at AS started_at_4, t0.expires_at AS expires_at_5, t0.finished_at AS finished_at_6, t0.score AS score_7, t0.max_score AS max_score_8, t0.passed AS passed_9, t0.user_id AS user_id_10, t0.section_id AS section_id_11, t0.subcategory_id AS subcategory_id_12, t0.section_group_id AS section_group_id_13 FROM attempt t0 WHERE t0.id = 2296;

INSERT INTO attempt_answer (selected_option_ids, is_correct, points, attempt_id, question_id) VALUES (?, ?, ?, ?, ?)

[
  "[20551]"
  1
  1
  2296
  5817
]

INSERT INTO attempt_answer (
  selected_option_ids, is_correct,
  points, attempt_id, question_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO attempt_answer (selected_option_ids, is_correct, points, attempt_id, question_id) VALUES ('[20551]', 1, 1, 2296, 5817);

SELECT a0_.id AS id_0 FROM answer_option a0_ WHERE a0_.question_id = ? AND a0_.is_correct = true

[
  5817
]

SELECT
  a0_.id AS id_0
FROM
  answer_option a0_
WHERE
  a0_.question_id = ?
  AND a0_.is_correct = true

SELECT a0_.id AS id_0 FROM answer_option a0_ WHERE a0_.question_id = 5817 AND a0_.is_correct = true;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE attempt SET current_index = ? WHERE id = ?

[
  9
  2296
]

UPDATE
  attempt
SET
  current_index = ?
WHERE
  id = ?

UPDATE attempt SET current_index = 9 WHERE id = 2296;

SELECT t0.id AS id_1, t0.selected_option_ids AS selected_option_ids_2, t0.is_correct AS is_correct_3, t0.points AS points_4, t0.attempt_id AS attempt_id_5, t0.question_id AS question_id_6 FROM attempt_answer t0 WHERE t0.attempt_id = ? AND t0.question_id = ? LIMIT 1

[
  2296
  5817
]

SELECT
  t0.id AS id_1,
  t0.selected_option_ids AS selected_option_ids_2,
  t0.is_correct AS is_correct_3,
  t0.points AS points_4,
  t0.attempt_id AS attempt_id_5,
  t0.question_id AS question_id_6
FROM
  attempt_answer t0
WHERE
  t0.attempt_id = ?
  AND t0.question_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.selected_option_ids AS selected_option_ids_2, t0.is_correct AS is_correct_3, t0.points AS points_4, t0.attempt_id AS attempt_id_5, t0.question_id AS question_id_6 FROM attempt_answer t0 WHERE t0.attempt_id = 2296 AND t0.question_id = 5817 LIMIT 1;