Symfony Profiler

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

Query Metrics

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 = ?

[
  237
]

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 = ?

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 = 237;

SELECT
            q2.id AS quizid,
            q2.gametype, 
            ua.userid_id AS userid,
            IF(u.nickname IS NULL OR u.nickname = '','Anonymus',u.nickname) AS nickname,
            SUM(q.points) AS highscore_points
            FROM user_answers ua
            LEFT JOIN questions q
            ON ua.questionid_id = q.id
            LEFT JOIN user u
            ON ua.userid_id = u.id
            LEFT JOIN quiz q2 
            ON q.quizid_id = q2.id
            WHERE ua.answered_correctly = 1
            AND (q2.gametype = 'single')
            GROUP BY ua.userid_id
            ORDER BY highscore_points DESC;

[]

SELECT
  q2.id AS quizid,
  q2.gametype,
  ua.userid_id AS userid,
  IF(
    u.nickname IS NULL
    OR u.nickname = '',
    'Anonymus',
    u.nickname
  ) AS nickname,
  SUM(q.points) AS highscore_points
FROM
  user_answers ua
  LEFT JOIN questions q ON ua.questionid_id = q.id
  LEFT JOIN user u ON ua.userid_id = u.id
  LEFT JOIN quiz q2 ON q.quizid_id = q2.id
WHERE
  ua.answered_correctly = 1
  AND (q2.gametype = 'single')
GROUP BY
  ua.userid_id
ORDER BY
  highscore_points DESC;

SELECT
            q2.id AS quizid,
            q2.gametype, 
            ua.userid_id AS userid,
            IF(u.nickname IS NULL OR u.nickname = '','Anonymus',u.nickname) AS nickname,
            SUM(q.points) AS highscore_points
            FROM user_answers ua
            LEFT JOIN questions q
            ON ua.questionid_id = q.id
            LEFT JOIN user u
            ON ua.userid_id = u.id
            LEFT JOIN quiz q2 
            ON q.quizid_id = q2.id
            WHERE ua.answered_correctly = 1
            AND (q2.gametype = 'single')
            GROUP BY ua.userid_id
            ORDER BY highscore_points DESC;;

SELECT
            q2.id AS quizid,
            q2.gametype, 
            ua.userid_id AS userid,
            IF(u.nickname IS NULL OR u.nickname = '','Anonymus',u.nickname) AS nickname,
            SUM(q.points) AS highscore_points
            FROM user_answers ua
            LEFT JOIN questions q
            ON ua.questionid_id = q.id
            LEFT JOIN user u
            ON ua.userid_id = u.id
            LEFT JOIN quiz q2 
            ON q.quizid_id = q2.id
            WHERE ua.answered_correctly = 1
            AND q2.gametype = 'blitz'
            GROUP BY ua.userid_id
            ORDER BY highscore_points DESC;

[]

SELECT
  q2.id AS quizid,
  q2.gametype,
  ua.userid_id AS userid,
  IF(
    u.nickname IS NULL
    OR u.nickname = '',
    'Anonymus',
    u.nickname
  ) AS nickname,
  SUM(q.points) AS highscore_points
FROM
  user_answers ua
  LEFT JOIN questions q ON ua.questionid_id = q.id
  LEFT JOIN user u ON ua.userid_id = u.id
  LEFT JOIN quiz q2 ON q.quizid_id = q2.id
WHERE
  ua.answered_correctly = 1
  AND q2.gametype = 'blitz'
GROUP BY
  ua.userid_id
ORDER BY
  highscore_points DESC;

SELECT
            q2.id AS quizid,
            q2.gametype, 
            ua.userid_id AS userid,
            IF(u.nickname IS NULL OR u.nickname = '','Anonymus',u.nickname) AS nickname,
            SUM(q.points) AS highscore_points
            FROM user_answers ua
            LEFT JOIN questions q
            ON ua.questionid_id = q.id
            LEFT JOIN user u
            ON ua.userid_id = u.id
            LEFT JOIN quiz q2 
            ON q.quizid_id = q2.id
            WHERE ua.answered_correctly = 1
            AND q2.gametype = 'blitz'
            GROUP BY ua.userid_id
            ORDER BY highscore_points DESC;;

SELECT
            ua.teamid_id AS teamid,
            t.teamname,
            SUM(q.points) AS highscore_points
            FROM user_answers ua
            LEFT JOIN questions q
            ON ua.questionid_id = q.id
            LEFT JOIN quiz q2 
            ON q.quizid_id = q2.id
            LEFT JOIN teams t
            ON t.id = ua.teamid_id
            WHERE ua.answered_correctly = 1
            AND q2.gametype = 'multi'
            AND ua.teamid_id IS NOT NULL
            GROUP BY ua.teamid_id
            ORDER BY highscore_points DESC;

[]

SELECT
  ua.teamid_id AS teamid,
  t.teamname,
  SUM(q.points) AS highscore_points
FROM
  user_answers ua
  LEFT JOIN questions q ON ua.questionid_id = q.id
  LEFT JOIN quiz q2 ON q.quizid_id = q2.id
  LEFT JOIN teams t ON t.id = ua.teamid_id
WHERE
  ua.answered_correctly = 1
  AND q2.gametype = 'multi'
  AND ua.teamid_id IS NOT NULL
GROUP BY
  ua.teamid_id
ORDER BY
  highscore_points DESC;

SELECT
            ua.teamid_id AS teamid,
            t.teamname,
            SUM(q.points) AS highscore_points
            FROM user_answers ua
            LEFT JOIN questions q
            ON ua.questionid_id = q.id
            LEFT JOIN quiz q2 
            ON q.quizid_id = q2.id
            LEFT JOIN teams t
            ON t.id = ua.teamid_id
            WHERE ua.answered_correctly = 1
            AND q2.gametype = 'multi'
            AND ua.teamid_id IS NOT NULL
            GROUP BY ua.teamid_id
            ORDER BY highscore_points DESC;;