Symfony Profiler

SELECT
  mg.user_id,
  @rownum := @rownum + 1 rownum,
  (mg.points + a.points + m.points) as points,
  (
    (a.end - a.start) + (mg.end - mg.start) +(m.end - m.start)
  ) as exectime,
  b.username as nick,
  b.firstname,
  b.lastname,
  b.email
FROM
  `memory_game` mg,
  answear a,
  matcher m,
  user b,
  (
    SELECT
      @rownum := 0
  ) r
WHERE
  a.user_id = mg.user_id
  AND m.user_id = a.user_id
  AND a.user_id = b.id
  AND a.quiz = :quiz
  AND mg.quiz = :quiz
  AND m.quiz = :quiz
ORDER BY
  points DESC,
  exectime ASC,
  a.start ASC
LIMIT
  3

SELECT mg.user_id,@rownum:=@rownum+1 rownum, (mg.points + a.points + m.points) as points, ((a.end-a.start) + (mg.end-mg.start) +(m.end-m.start)) as exectime , b.username as nick, b.firstname, b.lastname, b.email FROM `memory_game` mg, answear a ,matcher m ,user b, (SELECT @rownum:=0) r WHERE a.user_id = mg.user_id AND m.user_id = a.user_id AND a.user_id = b.id AND a.quiz= :quiz AND mg.quiz = :quiz AND m.quiz = :quiz ORDER BY points DESC, exectime ASC, a.start ASC LIMIT 3;

SELECT
  mg.user_id,
  @rownum := @rownum + 1 rownum,
  (mg.points + a.points + m.points) as points,
  (
    (a.end - a.start) + (mg.end - mg.start) + (m.end - m.start)
  ) as exectime,
  b.username as nick,
  b.firstname,
  b.lastname,
  b.email
FROM
  `memory_game` mg,
  answear a,
  matcher m,
  user b,
  (
    SELECT
      @rownum := 0
  ) r
WHERE
  a.user_id = mg.user_id
  AND m.user_id = a.user_id
  AND a.user_id = b.id
ORDER BY
  points DESC,
  exectime ASC,
  a.start ASC
LIMIT
  3

SELECT mg.user_id,@rownum:=@rownum+1 rownum, (mg.points + a.points + m.points) as points, ((a.end-a.start) + (mg.end-mg.start) + (m.end-m.start)) as exectime , b.username as nick, b.firstname, b.lastname, b.email FROM `memory_game` mg, answear a, matcher m ,user b, (SELECT @rownum:=0) r WHERE a.user_id = mg.user_id AND m.user_id = a.user_id AND a.user_id = b.id ORDER BY points DESC, exectime ASC, a.start ASC LIMIT 3;

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 = ?
ORDER BY
  t0.id DESC
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 ORDER BY t0.id DESC 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 = ?
ORDER BY
  t0.id DESC
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 ORDER BY t0.id DESC LIMIT 1;