Symfony Profiler

SELECT
  DISTINCT id_7,
  MIN(sclr_9) AS dctrn_minrownum
FROM
  (
    SELECT
      s0_.address AS address_0,
      s0_.address_text AS address_text_1,
      s0_.point AS point_2,
      s0_.phone AS phone_3,
      s0_.phones AS phones_4,
      s0_.email AS email_5,
      s0_.updated_at AS updated_at_6,
      s0_.id AS id_7,
      s0_.deleted_at AS deleted_at_8,
      ROW_NUMBER() OVER(
        ORDER BY
          c1_.name ASC,
          s0_.address_text ASC
      ) AS sclr_9
    FROM
      shops s0_
      LEFT JOIN cities c1_ ON s0_.city_id = c1_.id
      AND (c1_.deleted_at IS NULL)
    WHERE
      (s0_.deleted_at IS NULL)
  ) dctrn_result
GROUP BY
  id_7
ORDER BY
  dctrn_minrownum ASC
LIMIT
  25

SELECT DISTINCT id_7, MIN(sclr_9) AS dctrn_minrownum FROM (SELECT s0_.address AS address_0, s0_.address_text AS address_text_1, s0_.point AS point_2, s0_.phone AS phone_3, s0_.phones AS phones_4, s0_.email AS email_5, s0_.updated_at AS updated_at_6, s0_.id AS id_7, s0_.deleted_at AS deleted_at_8, ROW_NUMBER() OVER(ORDER BY c1_.name ASC, s0_.address_text ASC) AS sclr_9 FROM shops s0_ LEFT JOIN cities c1_ ON s0_.city_id = c1_.id AND (c1_.deleted_at IS NULL) WHERE (s0_.deleted_at IS NULL)) dctrn_result GROUP BY id_7 ORDER BY dctrn_minrownum ASC LIMIT 25;

SELECT
  s0_.address AS address_0,
  s0_.address_text AS address_text_1,
  s0_.point AS point_2,
  s0_.phone AS phone_3,
  s0_.phones AS phones_4,
  s0_.email AS email_5,
  s0_.updated_at AS updated_at_6,
  s0_.id AS id_7,
  s0_.deleted_at AS deleted_at_8,
  s0_.city_id AS city_id_9
FROM
  shops s0_
  LEFT JOIN cities c1_ ON s0_.city_id = c1_.id
  AND (c1_.deleted_at IS NULL)
WHERE
  (
    s0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  AND (s0_.deleted_at IS NULL)
ORDER BY
  c1_.name ASC,
  s0_.address_text ASC

SELECT s0_.address AS address_0, s0_.address_text AS address_text_1, s0_.point AS point_2, s0_.phone AS phone_3, s0_.phones AS phones_4, s0_.email AS email_5, s0_.updated_at AS updated_at_6, s0_.id AS id_7, s0_.deleted_at AS deleted_at_8, s0_.city_id AS city_id_9 FROM shops s0_ LEFT JOIN cities c1_ ON s0_.city_id = c1_.id AND (c1_.deleted_at IS NULL) WHERE (s0_.id IN ('10ecdabc-b33d-4ce3-b2a8-f46a09cc98f6', '6f111056-e9cf-4a03-ab91-f6206b551fd8', 'da62b91d-f581-4f39-a8d4-50248f383519', '5a6625f5-4e71-4131-add2-b7e85c741099', '33619c40-1877-4bda-b8d1-ba8f39815132', '0fb2c29b-435f-4afd-a2ae-eed46114b06c', '38ee642e-37e6-4a88-8ba6-bc7a021e47c4', 'edd00af2-78ee-4880-9dd1-b845f87f290f', '4893ffdd-f246-41d2-8820-13ea03db1517', '9836e10a-0aea-4dec-81ff-2c32b5d51aed', '5094480c-c893-4d41-85ea-fcf96c45bf49', '24b07c3b-9bf2-4e23-91ce-6747f1424acd', '64ec6067-19db-463d-96fe-55fa03a1749b', '648a0938-6a7a-4166-92f6-48d6b0223327', '73d648cb-9c13-4d91-ae01-d8738c2667b5', '4c371217-f077-46b4-990a-f3c630d0de81', '97fbde3e-63cb-4f8a-b0f1-9ba1d26e3426', '8c86e44d-5f27-4aee-af58-e404d3da29af', '30b5131b-bf3d-44a9-8e49-423ca7fd202c', '15450ed2-7195-4528-b424-a4b5d9d0645f', '4762414e-6030-47d3-98ad-86987e4a1bb2', 'a4be2658-e003-45cd-82fa-cc874776a064', '0cb09bc6-3a5a-4947-9b51-f2444a5762a2', 'f1570be1-087f-4184-8b55-74908acbca38', 'ee428f23-466c-4349-bcb6-dae05c78746d')) AND (s0_.deleted_at IS NULL) ORDER BY c1_.name ASC, s0_.address_text ASC;

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = 'c1c7cbeb-fbff-4f58-9384-3f26f5810a79' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = '8b37b71e-4409-4997-8d00-f0e5f8f04bed' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = 'd7505210-a0c5-4218-9385-5af1e36705ab' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = '0a78a503-ec54-42b9-b00e-eed54ddc2b4a' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = '528a117b-4b27-4f7e-b162-60e7d2e42c84' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = '16f8ac31-2a2f-4396-825e-9b598141978d' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = '05a560f3-6b8c-4813-a20b-553a2f4ca413' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = 'ce0737a3-ec6c-4467-8881-812b9a4d6bf2' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = 'c36a8422-c4c3-4866-9d41-2a2e837c4d9d' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = 'b7322156-0471-4fa0-95b9-d0300cff249b' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = 'd2f0fe49-ab21-45f1-86e9-347ee1390fdc' AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.okato AS okato_2,
  t0.name_full AS name_full_3,
  t0.name_eng AS name_eng_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.name AS name_1, t0.okato AS okato_2, t0.name_full AS name_full_3, t0.name_eng AS name_eng_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = '49abd619-3141-4a52-8fa2-534b605c6fd9' AND ((t0.deleted_at IS NULL));