Symfony Profiler

SELECT
  DISTINCT q0_.id AS id_0,
  q0_.wall_id AS sclr_1
FROM
  qrcode q0_
  LEFT JOIN wall w1_ ON q0_.wall_id = w1_.id
  LEFT JOIN statistic s2_ ON q0_.id = s2_.qrcode_id
GROUP BY
  q0_.id
ORDER BY
  q0_.wall_id DESC
LIMIT
  20

SELECT DISTINCT q0_.id AS id_0, q0_.wall_id AS sclr_1 FROM qrcode q0_ LEFT JOIN wall w1_ ON q0_.wall_id = w1_.id LEFT JOIN statistic s2_ ON q0_.id = s2_.qrcode_id GROUP BY q0_.id ORDER BY q0_.wall_id DESC LIMIT 20;

SELECT
  q0_.id AS id_0,
  q0_.pin_code AS pin_code_1,
  q0_.short_slug AS short_slug_2,
  q0_.name AS name_3,
  q0_.mode AS mode_4,
  q0_.assigned_at AS assigned_at_5,
  q0_.image_name AS image_name_6,
  q0_.created_at AS created_at_7,
  q0_.updated_at AS updated_at_8,
  COUNT(s1_.id) AS sclr_9,
  q0_.owner_id AS owner_id_10,
  q0_.wall_id AS wall_id_11
FROM
  qrcode q0_
  LEFT JOIN wall w2_ ON q0_.wall_id = w2_.id
  LEFT JOIN statistic s1_ ON q0_.id = s1_.qrcode_id
WHERE
  q0_.id IN (?)
GROUP BY
  q0_.id
ORDER BY
  q0_.wall_id DESC

SELECT q0_.id AS id_0, q0_.pin_code AS pin_code_1, q0_.short_slug AS short_slug_2, q0_.name AS name_3, q0_.mode AS mode_4, q0_.assigned_at AS assigned_at_5, q0_.image_name AS image_name_6, q0_.created_at AS created_at_7, q0_.updated_at AS updated_at_8, COUNT(s1_.id) AS sclr_9, q0_.owner_id AS owner_id_10, q0_.wall_id AS wall_id_11 FROM qrcode q0_ LEFT JOIN wall w2_ ON q0_.wall_id = w2_.id LEFT JOIN statistic s1_ ON q0_.id = s1_.qrcode_id WHERE q0_.id IN (0x01A191616C0C7881A6EADB42E404AA72) GROUP BY q0_.id ORDER BY q0_.wall_id DESC;

SELECT
  count(DISTINCT q0_.id) AS sclr_0
FROM
  qrcode q0_
  LEFT JOIN wall w1_ ON q0_.wall_id = w1_.id
  LEFT JOIN statistic s2_ ON q0_.id = s2_.qrcode_id
GROUP BY
  q0_.id

SELECT count(DISTINCT q0_.id) AS sclr_0 FROM qrcode q0_ LEFT JOIN wall w1_ ON q0_.wall_id = w1_.id LEFT JOIN statistic s2_ ON q0_.id = s2_.qrcode_id GROUP BY q0_.id;

SELECT
  t0.id AS id_1,
  t0.ip_address AS ip_address_2,
  t0.created_at AS created_at_3,
  t0.qrcode_id AS qrcode_id_4
FROM
  statistic t0
WHERE
  t0.qrcode_id = ?

SELECT t0.id AS id_1, t0.ip_address AS ip_address_2, t0.created_at AS created_at_3, t0.qrcode_id AS qrcode_id_4 FROM statistic t0 WHERE t0.qrcode_id = 0x01A191616C0C7881A6EADB42E404AA72;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5 FROM user t0 WHERE t0.id = 0x01A150BDB534792FAFDFA442CADC9F63;