Symfony Profiler

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  estate_estate e0_
WHERE
  (e0_.enable = 1)
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.sort ASC,
  e0_.id DESC

SELECT COUNT(e0_.id) AS sclr_0 FROM estate_estate e0_ WHERE (e0_.enable = 1) AND (e0_.deleted_at IS NULL) ORDER BY e0_.sort ASC, e0_.id DESC;

SELECT
  e0_.item_count AS item_count_0,
  e0_.deleted_at AS deleted_at_1,
  e0_.created_at AS created_at_2,
  e0_.updated_at AS updated_at_3,
  e0_.id AS id_4,
  e0_.name AS name_5,
  e0_.enable AS enable_6,
  e0_.sort AS sort_7
FROM
  estate_master_area e0_
WHERE
  (e0_.enable = 1)
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.sort ASC,
  e0_.id DESC

SELECT e0_.item_count AS item_count_0, e0_.deleted_at AS deleted_at_1, e0_.created_at AS created_at_2, e0_.updated_at AS updated_at_3, e0_.id AS id_4, e0_.name AS name_5, e0_.enable AS enable_6, e0_.sort AS sort_7 FROM estate_master_area e0_ WHERE (e0_.enable = 1) AND (e0_.deleted_at IS NULL) ORDER BY e0_.sort ASC, e0_.id DESC;

SELECT
  e0_.item_count AS item_count_0,
  e0_.unit AS unit_1,
  e0_.deleted_at AS deleted_at_2,
  e0_.created_at AS created_at_3,
  e0_.updated_at AS updated_at_4,
  e0_.id AS id_5,
  e0_.name AS name_6,
  e0_.enable AS enable_7,
  e0_.sort AS sort_8
FROM
  estate_master_division e0_
WHERE
  (e0_.enable = 1)
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.sort ASC,
  e0_.id DESC

SELECT e0_.item_count AS item_count_0, e0_.unit AS unit_1, e0_.deleted_at AS deleted_at_2, e0_.created_at AS created_at_3, e0_.updated_at AS updated_at_4, e0_.id AS id_5, e0_.name AS name_6, e0_.enable AS enable_7, e0_.sort AS sort_8 FROM estate_master_division e0_ WHERE (e0_.enable = 1) AND (e0_.deleted_at IS NULL) ORDER BY e0_.sort ASC, e0_.id DESC;

SELECT
  DISTINCT id_8
FROM
  (
    SELECT
      DISTINCT id_8,
      sort_10
    FROM
      (
        SELECT
          e0_.name AS name_0,
          e0_.structure AS structure_1,
          e0_.photo AS photo_2,
          e0_.photo_width AS photo_width_3,
          e0_.photo_height AS photo_height_4,
          e0_.deleted_at AS deleted_at_5,
          e0_.created_at AS created_at_6,
          e0_.updated_at AS updated_at_7,
          e0_.id AS id_8,
          e0_.enable AS enable_9,
          e0_.sort AS sort_10
        FROM
          estate_estate e0_
        WHERE
          (
            e0_.enable = 1
            AND e0_.area_id = ?
          )
          AND (e0_.deleted_at IS NULL)
      ) dctrn_result_inner
    ORDER BY
      sort_10 ASC,
      id_8 DESC
  ) dctrn_result
LIMIT
  10 OFFSET 90

SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, sort_10 FROM (SELECT e0_.name AS name_0, e0_.structure AS structure_1, e0_.photo AS photo_2, e0_.photo_width AS photo_width_3, e0_.photo_height AS photo_height_4, e0_.deleted_at AS deleted_at_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.id AS id_8, e0_.enable AS enable_9, e0_.sort AS sort_10 FROM estate_estate e0_ WHERE (e0_.enable = 1 AND e0_.area_id = 1) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY sort_10 ASC, id_8 DESC) dctrn_result LIMIT 10 OFFSET 90;

SELECT
  e0_.name AS name_0,
  e0_.structure AS structure_1,
  e0_.photo AS photo_2,
  e0_.photo_width AS photo_width_3,
  e0_.photo_height AS photo_height_4,
  e0_.deleted_at AS deleted_at_5,
  e0_.created_at AS created_at_6,
  e0_.updated_at AS updated_at_7,
  e0_.id AS id_8,
  e0_.enable AS enable_9,
  e0_.sort AS sort_10,
  e0_.area_id AS area_id_11,
  e0_.division_id AS division_id_12
FROM
  estate_estate e0_
WHERE
  (
    e0_.enable = 1
    AND e0_.area_id = ?
    AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.sort ASC,
  e0_.id DESC

SELECT e0_.name AS name_0, e0_.structure AS structure_1, e0_.photo AS photo_2, e0_.photo_width AS photo_width_3, e0_.photo_height AS photo_height_4, e0_.deleted_at AS deleted_at_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.id AS id_8, e0_.enable AS enable_9, e0_.sort AS sort_10, e0_.area_id AS area_id_11, e0_.division_id AS division_id_12 FROM estate_estate e0_ WHERE (e0_.enable = 1 AND e0_.area_id = 1 AND e0_.id IN (19, 18, 16, 14, 13, 11, 10, 6, 5)) AND (e0_.deleted_at IS NULL) ORDER BY e0_.sort ASC, e0_.id DESC;

SELECT
  DISTINCT id_8
FROM
  (
    SELECT
      DISTINCT id_8,
      sort_10
    FROM
      (
        SELECT
          e0_.name AS name_0,
          e0_.structure AS structure_1,
          e0_.photo AS photo_2,
          e0_.photo_width AS photo_width_3,
          e0_.photo_height AS photo_height_4,
          e0_.deleted_at AS deleted_at_5,
          e0_.created_at AS created_at_6,
          e0_.updated_at AS updated_at_7,
          e0_.id AS id_8,
          e0_.enable AS enable_9,
          e0_.sort AS sort_10
        FROM
          estate_estate e0_
        WHERE
          (
            e0_.enable = 1
            AND e0_.area_id = ?
          )
          AND (e0_.deleted_at IS NULL)
      ) dctrn_result_inner
    ORDER BY
      sort_10 ASC,
      id_8 DESC
  ) dctrn_result
LIMIT
  10 OFFSET 90

SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, sort_10 FROM (SELECT e0_.name AS name_0, e0_.structure AS structure_1, e0_.photo AS photo_2, e0_.photo_width AS photo_width_3, e0_.photo_height AS photo_height_4, e0_.deleted_at AS deleted_at_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.id AS id_8, e0_.enable AS enable_9, e0_.sort AS sort_10 FROM estate_estate e0_ WHERE (e0_.enable = 1 AND e0_.area_id = 1) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY sort_10 ASC, id_8 DESC) dctrn_result LIMIT 10 OFFSET 90;

SELECT
  e0_.name AS name_0,
  e0_.structure AS structure_1,
  e0_.photo AS photo_2,
  e0_.photo_width AS photo_width_3,
  e0_.photo_height AS photo_height_4,
  e0_.deleted_at AS deleted_at_5,
  e0_.created_at AS created_at_6,
  e0_.updated_at AS updated_at_7,
  e0_.id AS id_8,
  e0_.enable AS enable_9,
  e0_.sort AS sort_10,
  e0_.area_id AS area_id_11,
  e0_.division_id AS division_id_12
FROM
  estate_estate e0_
WHERE
  (
    e0_.enable = 1
    AND e0_.area_id = ?
    AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.sort ASC,
  e0_.id DESC

SELECT e0_.name AS name_0, e0_.structure AS structure_1, e0_.photo AS photo_2, e0_.photo_width AS photo_width_3, e0_.photo_height AS photo_height_4, e0_.deleted_at AS deleted_at_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.id AS id_8, e0_.enable AS enable_9, e0_.sort AS sort_10, e0_.area_id AS area_id_11, e0_.division_id AS division_id_12 FROM estate_estate e0_ WHERE (e0_.enable = 1 AND e0_.area_id = 1 AND e0_.id IN (19, 18, 16, 14, 13, 11, 10, 6, 5)) AND (e0_.deleted_at IS NULL) ORDER BY e0_.sort ASC, e0_.id DESC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_8
    FROM
      (
        SELECT
          e0_.name AS name_0,
          e0_.structure AS structure_1,
          e0_.photo AS photo_2,
          e0_.photo_width AS photo_width_3,
          e0_.photo_height AS photo_height_4,
          e0_.deleted_at AS deleted_at_5,
          e0_.created_at AS created_at_6,
          e0_.updated_at AS updated_at_7,
          e0_.id AS id_8,
          e0_.enable AS enable_9,
          e0_.sort AS sort_10
        FROM
          estate_estate e0_
        WHERE
          (
            e0_.enable = 1
            AND e0_.area_id = ?
          )
          AND (e0_.deleted_at IS NULL)
        ORDER BY
          e0_.sort ASC,
          e0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT e0_.name AS name_0, e0_.structure AS structure_1, e0_.photo AS photo_2, e0_.photo_width AS photo_width_3, e0_.photo_height AS photo_height_4, e0_.deleted_at AS deleted_at_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.id AS id_8, e0_.enable AS enable_9, e0_.sort AS sort_10 FROM estate_estate e0_ WHERE (e0_.enable = 1 AND e0_.area_id = 1) AND (e0_.deleted_at IS NULL) ORDER BY e0_.sort ASC, e0_.id DESC) dctrn_result) dctrn_table;