Symfony Profiler

SELECT
  t0.token AS token_1,
  t0.expire AS expire_2,
  t0.lifetime AS lifetime_3,
  t0.user_id AS user_id_4,
  t0.tablet_id AS tablet_id_5
FROM
  api_token t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.token AS token_1, t0.expire AS expire_2, t0.lifetime AS lifetime_3, t0.user_id AS user_id_4, t0.tablet_id AS tablet_id_5 FROM api_token t0 WHERE t0.token = '7b400796b66145700a155511240366fd897ac53a00e336fa3b58859894ed79d5' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.status AS status_5,
  t0.deleted AS deleted_6
FROM
  `user` t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted IS NULL)
  )

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.status AS status_5, t0.deleted AS deleted_6 FROM `user` t0 WHERE t0.id = 17 AND ((t0.deleted IS NULL));

SELECT
  l0_.id AS id_0,
  l0_.type AS type_1,
  l0_.title AS title_2,
  l0_.phone AS phone_3,
  l0_.marker_color AS marker_color_4,
  a1_.id AS id_5,
  a1_.company AS company_6,
  a1_.responsible_person AS responsible_person_7,
  a1_.address AS address_8,
  a1_.city AS city_9,
  a1_.postalcode AS postalcode_10,
  a1_.country AS country_11,
  a1_.latitude AS latitude_12,
  a1_.longitude AS longitude_13,
  a1_.nav_latitude AS nav_latitude_14,
  a1_.nav_longitude AS nav_longitude_15,
  ST_AsBinary(a1_.point) AS point_16,
  l0_.address_id AS address_id_17
FROM
  location l0_
  INNER JOIN address a1_ ON l0_.address_id = a1_.id
ORDER BY
  l0_.id ASC
LIMIT
  100 OFFSET 100

SELECT l0_.id AS id_0, l0_.type AS type_1, l0_.title AS title_2, l0_.phone AS phone_3, l0_.marker_color AS marker_color_4, a1_.id AS id_5, a1_.company AS company_6, a1_.responsible_person AS responsible_person_7, a1_.address AS address_8, a1_.city AS city_9, a1_.postalcode AS postalcode_10, a1_.country AS country_11, a1_.latitude AS latitude_12, a1_.longitude AS longitude_13, a1_.nav_latitude AS nav_latitude_14, a1_.nav_longitude AS nav_longitude_15, ST_AsBinary(a1_.point) AS point_16, l0_.address_id AS address_id_17 FROM location l0_ INNER JOIN address a1_ ON l0_.address_id = a1_.id ORDER BY l0_.id ASC LIMIT 100 OFFSET 100;

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  location l0_
  INNER JOIN address a1_ ON l0_.address_id = a1_.id

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM location l0_ INNER JOIN address a1_ ON l0_.address_id = a1_.id;