Symfony Profiler

• Request / Response
• Performance
• Exception
• Logs
• Events
• Routing
• Cache
• Security
• Twig
• Doctrine
• Emails
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.questionid AS questionid_2, t0.category AS category_3, t0.points AS points_4, t0.mintreffer AS mintreffer_5, t0.questiontype AS questiontype_6, t0.correctanswer AS correctanswer_7, t0.question AS question_8, t0.answer AS answer_9, t0.path_picture_question AS path_picture_question_10, t0.path_picture_answer AS path_picture_answer_11, t0.comment AS comment_12, t0.quizid_id AS quizid_id_13 FROM questions t0 WHERE t0.questionid = ? LIMIT 1

[
  "Beruf_100_mc_frage_1302085847683e86e8c97cd2.73176942"
]

SELECT
  t0.id AS id_1,
  t0.questionid AS questionid_2,
  t0.category AS category_3,
  t0.points AS points_4,
  t0.mintreffer AS mintreffer_5,
  t0.questiontype AS questiontype_6,
  t0.correctanswer AS correctanswer_7,
  t0.question AS question_8,
  t0.answer AS answer_9,
  t0.path_picture_question AS path_picture_question_10,
  t0.path_picture_answer AS path_picture_answer_11,
  t0.comment AS comment_12,
  t0.quizid_id AS quizid_id_13
FROM
  questions t0
WHERE
  t0.questionid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.questionid AS questionid_2, t0.category AS category_3, t0.points AS points_4, t0.mintreffer AS mintreffer_5, t0.questiontype AS questiontype_6, t0.correctanswer AS correctanswer_7, t0.question AS question_8, t0.answer AS answer_9, t0.path_picture_question AS path_picture_question_10, t0.path_picture_answer AS path_picture_answer_11, t0.comment AS comment_12, t0.quizid_id AS quizid_id_13 FROM questions t0 WHERE t0.questionid = 'Beruf_100_mc_frage_1302085847683e86e8c97cd2.73176942' LIMIT 1;

SELECT q.questionid, q.points, ua.userid_id, ua.answered_correctly
            FROM user_answers ua
            LEFT JOIN questions q
            ON ua.questionid_id = q.id
            WHERE ua.userid_id = ?
            AND q.questionid = ?;

[
  730
  "Beruf_100_mc_frage_1302085847683e86e8c97cd2.73176942"
]

SELECT
  q.questionid,
  q.points,
  ua.userid_id,
  ua.answered_correctly
FROM
  user_answers ua
  LEFT JOIN questions q ON ua.questionid_id = q.id
WHERE
  ua.userid_id = ?
  AND q.questionid = ?;

SELECT q.questionid, q.points, ua.userid_id, ua.answered_correctly
            FROM user_answers ua
            LEFT JOIN questions q
            ON ua.questionid_id = q.id
            WHERE ua.userid_id = 730
            AND q.questionid = 'Beruf_100_mc_frage_1302085847683e86e8c97cd2.73176942';;

SELECT t0.id AS id_1, t0.email AS email_2, t0.code AS code_3, t0.active AS active_4, t0.nickname AS nickname_5, t0.createdat AS createdat_6, t0.lastlogin AS lastlogin_7, t0.avatar AS avatar_8, t0.awards AS awards_9 FROM user t0 WHERE t0.id = ? LIMIT 1

[
  730
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.code AS code_3,
  t0.active AS active_4,
  t0.nickname AS nickname_5,
  t0.createdat AS createdat_6,
  t0.lastlogin AS lastlogin_7,
  t0.avatar AS avatar_8,
  t0.awards AS awards_9
FROM
  user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.code AS code_3, t0.active AS active_4, t0.nickname AS nickname_5, t0.createdat AS createdat_6, t0.lastlogin AS lastlogin_7, t0.avatar AS avatar_8, t0.awards AS awards_9 FROM user t0 WHERE t0.id = 730 LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO user_answers (useranswer, answered_correctly, userid_id, questionid_id, teamid_id) VALUES (?, ?, ?, ?, ?)

[
  "["Sie besch\u00e4ftigen sich mit dem Thema Ern\u00e4hrung."]"
  1
  730
  10680
  null
]

INSERT INTO user_answers (
  useranswer, answered_correctly, userid_id,
  questionid_id, teamid_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO user_answers (useranswer, answered_correctly, userid_id, questionid_id, teamid_id) VALUES ('[\"Sie besch\\u00e4ftigen sich mit dem Thema Ern\\u00e4hrung.\"]', 1, 730, 10680, NULL);

"COMMIT"

[]

"COMMIT"

"COMMIT";