Symfony Profiler

SELECT
  d.pos
FROM
  (
    SELECT
      c.user_id,
      ROW_NUMBER() OVER (
        ORDER BY
          points DESC,
          exectime ASC,
          start ASC
      ) as pos,
      points
    FROM
      (
        SELECT
          mg.user_id,
          (mg.points + a.points) as points,
          (
            (a.end - a.start) + (mg.end - mg.start)
          ) as exectime,
          a.start as start
        FROM
          `memory_game` mg,
          answear a
        WHERE
          a.user_id = mg.user_id
      ) c
  ) d
WHERE
  d.user_id = ?

SELECT d.pos FROM (SELECT c.user_id, ROW_NUMBER() OVER ( ORDER BY points DESC, exectime ASC, start ASC ) as pos, points FROM (SELECT mg.user_id, (mg.points + a.points) as points, ((a.end-a.start) + (mg.end-mg.start)) as exectime, a.start as start FROM `memory_game` mg, answear a WHERE a.user_id = mg.user_id ) c) d WHERE d.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.email AS email_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.enabled AS enabled_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.enabled AS enabled_8 FROM user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.quiz AS quiz_2,
  t0.start AS start_3,
  t0.end AS end_4,
  t0.points AS points_5,
  t0.answear AS answear_6,
  t0.questions AS questions_7,
  t0.questions_start AS questions_start_8,
  t0.user_id AS user_id_9
FROM
  answear t0
WHERE
  t0.user_id = ?
  AND t0.quiz = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.quiz AS quiz_2, t0.start AS start_3, t0.end AS end_4, t0.points AS points_5, t0.answear AS answear_6, t0.questions AS questions_7, t0.questions_start AS questions_start_8, t0.user_id AS user_id_9 FROM answear t0 WHERE t0.user_id = 1 AND t0.quiz = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.start AS start_2,
  t0.end AS end_3,
  t0.points AS points_4,
  t0.items_start AS items_start_5,
  t0.move_count AS move_count_6,
  t0.items_checked AS items_checked_7,
  t0.items_left AS items_left_8,
  t0.quiz AS quiz_9,
  t0.user_id AS user_id_10
FROM
  memory_game t0
WHERE
  t0.user_id = ?
  AND t0.quiz = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.points AS points_4, t0.items_start AS items_start_5, t0.move_count AS move_count_6, t0.items_checked AS items_checked_7, t0.items_left AS items_left_8, t0.quiz AS quiz_9, t0.user_id AS user_id_10 FROM memory_game t0 WHERE t0.user_id = 1 AND t0.quiz = 1 LIMIT 1;