Symfony Profiler

SELECT
  DISTINCT id_5,
  MIN(sclr_7) AS dctrn_minrownum
FROM
  (
    SELECT
      c0_.name AS name_0,
      c0_.okato AS okato_1,
      c0_.name_full AS name_full_2,
      c0_.name_eng AS name_eng_3,
      c0_.updated_at AS updated_at_4,
      c0_.id AS id_5,
      c0_.deleted_at AS deleted_at_6,
      ROW_NUMBER() OVER(
        ORDER BY
          c0_.name ASC
      ) AS sclr_7
    FROM
      cities c0_
    WHERE
      (c0_.deleted_at IS NULL)
  ) dctrn_result
GROUP BY
  id_5
ORDER BY
  dctrn_minrownum ASC
LIMIT
  25

SELECT DISTINCT id_5, MIN(sclr_7) AS dctrn_minrownum FROM (SELECT c0_.name AS name_0, c0_.okato AS okato_1, c0_.name_full AS name_full_2, c0_.name_eng AS name_eng_3, c0_.updated_at AS updated_at_4, c0_.id AS id_5, c0_.deleted_at AS deleted_at_6, ROW_NUMBER() OVER(ORDER BY c0_.name ASC) AS sclr_7 FROM cities c0_ WHERE (c0_.deleted_at IS NULL)) dctrn_result GROUP BY id_5 ORDER BY dctrn_minrownum ASC LIMIT 25;

SELECT
  c0_.name AS name_0,
  c0_.okato AS okato_1,
  c0_.name_full AS name_full_2,
  c0_.name_eng AS name_eng_3,
  c0_.updated_at AS updated_at_4,
  c0_.id AS id_5,
  c0_.deleted_at AS deleted_at_6,
  c0_.region_id AS region_id_7
FROM
  cities c0_
WHERE
  (
    c0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.name ASC

SELECT c0_.name AS name_0, c0_.okato AS okato_1, c0_.name_full AS name_full_2, c0_.name_eng AS name_eng_3, c0_.updated_at AS updated_at_4, c0_.id AS id_5, c0_.deleted_at AS deleted_at_6, c0_.region_id AS region_id_7 FROM cities c0_ WHERE (c0_.id IN ('20d1c5bd-e166-47f0-b05a-25fecf7b44e0', '0cf981fb-bed1-4cfe-8248-a8ebe635aa85', 'c93ed54b-3878-4039-a32f-d6d5e4514a97', '9e8280a5-70bc-43d4-bce8-acfd3c65a872', '207da504-c9ff-46a6-a8ab-917930cdbcfb', '10455498-c311-49f8-bfcf-409ea3e0eff5', 'b20dff67-e35e-4776-bd61-88098c973e6e', '5c54de66-58c2-4c35-b605-56037a90b532', 'c57bbeae-ec67-4328-a229-b5f38b074f7b', 'b9936242-d9f4-4a17-959d-6155f5688fd4', '34585d5d-3555-4109-a062-a262aebd9d4a', '331fe89f-50f4-4b15-95ac-f4bf9de7c835', 'd2f0081b-170a-473c-b2cb-9b6b8d8aab28', 'ff705bfc-9dbb-4aba-a1b5-64820e9d1dfd', '56d74828-62c1-46f8-b086-4035b6da8dd6', '701a466b-9596-47f6-ab52-37b2aa855096', '7460ed1e-6a47-4768-bbd4-e5465b035474', 'ed3de610-3dd5-4c93-b209-01fb375f99e5', 'e769c1eb-2b9b-431a-abbd-d6eaca09f7c6', 'b47e2c96-2b6f-47fb-bbc7-0d4049681a21', '9fe08753-46d4-42c8-9a17-46489a697c33', 'dcf7adcf-6905-47dc-aad3-1e7f30bfd671', '2212efe7-73d8-4d97-80b4-8be028f1c34f', 'a15f230b-4ce9-4b32-97b0-77358fb24dbc', '6395a2b7-9bf2-4656-ad36-9575bc451394')) AND (c0_.deleted_at IS NULL) ORDER BY c0_.name ASC;

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = 'b4489800-5660-4610-8e1b-3f0556a1849a' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = 'add9bcd5-2d18-476f-94e6-8facf3f272e7' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = 'ee7455f8-75f4-4ae0-bd01-5cef3dbb0372' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = 'eaaf6bcb-96a3-410f-ae3a-ee45bcfc04be' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = 'da2fb174-9189-403e-973c-280bedc75747' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = '6002e1a6-a786-4c19-b822-65d16edfa6c7' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = '21422329-0c20-4737-ac94-cb2d2e8e1d45' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = '55208f0c-dcc3-424c-9643-16872ee4a29a' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = '08a272d6-39a7-4742-8d63-5eb659b2b005' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = 'ea8898a6-0ac0-49fe-b783-200104ef71ca' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = '741bb511-4c42-4dc7-b7af-7a2c8312133b' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_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.state_id AS state_id_8 FROM regions t0 WHERE t0.id = '934fda57-9ae3-4d2a-b6a1-992dfea1694f' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_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.state_id AS state_id_8
FROM
  regions t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )