Symfony Profiler

SELECT
  DISTINCT id_0,
  MIN(sclr_24) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.uid AS uid_1,
      p0_.created_at AS created_at_2,
      p0_.updated_at AS updated_at_3,
      p0_.status AS status_4,
      p0_.state AS state_5,
      p0_.type AS type_6,
      p0_.area AS area_7,
      p0_.rooms AS rooms_8,
      p0_.floor AS floor_9,
      p0_.elevator AS elevator_10,
      p0_.furnished AS furnished_11,
      p0_.heating AS heating_12,
      p0_.equipments AS equipments_13,
      p0_.benefits AS benefits_14,
      p0_.rent AS rent_15,
      p0_.charges AS charges_16,
      p0_.services AS services_17,
      p0_.availability_date AS availability_date_18,
      p0_.description AS description_19,
      p0_.title AS title_20,
      p0_.active AS active_21,
      p0_.score AS score_22,
      p0_.extrafields AS extrafields_23,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.active DESC,
          CASE WHEN a1_.slug = ? THEN
            1
          ELSE
            0
          END DESC,
          CASE WHEN a1_.city LIKE ? THEN
            1
          ELSE
            0
          END DESC,
          p0_.score DESC,
          p0_.created_at DESC
      ) AS sclr_24
    FROM
      property p0_
      LEFT JOIN address a1_ ON p0_.address_id = a1_.id
    WHERE
      p0_.status = 2
      AND p0_.furnished = true
      AND a1_.city IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?
      )
      AND a1_.slug IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?
      )
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  20

SELECT DISTINCT id_0, MIN(sclr_24) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.uid AS uid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.status AS status_4, p0_.state AS state_5, p0_.type AS type_6, p0_.area AS area_7, p0_.rooms AS rooms_8, p0_.floor AS floor_9, p0_.elevator AS elevator_10, p0_.furnished AS furnished_11, p0_.heating AS heating_12, p0_.equipments AS equipments_13, p0_.benefits AS benefits_14, p0_.rent AS rent_15, p0_.charges AS charges_16, p0_.services AS services_17, p0_.availability_date AS availability_date_18, p0_.description AS description_19, p0_.title AS title_20, p0_.active AS active_21, p0_.score AS score_22, p0_.extrafields AS extrafields_23, ROW_NUMBER() OVER(ORDER BY p0_.active DESC, CASE WHEN a1_.slug = 'uccle-1180' THEN 1 ELSE 0 END DESC, CASE WHEN a1_.city LIKE 'Uccle%' THEN 1 ELSE 0 END DESC, p0_.score DESC, p0_.created_at DESC) AS sclr_24 FROM property p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id WHERE p0_.status = 2 AND p0_.furnished = true AND a1_.city IN ('Uccle', 'Bruxelles', 'Schaerbeek', 'Etterbeek', 'Ixelles', 'Saint-Gilles', 'Anderlecht', 'Molenbeek-Saint-Jean', 'Koekelberg', 'Berchem-Sainte-Agathe', 'Ganshoren', 'Evere', 'Woluwe-Saint-Pierre', 'Auderghem', 'Watermael-Boitsfort', 'Forest', 'Woluwe-Saint-Lambert', 'Saint-Josse-ten-Noode - Sint-Joost-ten-Node', 'Buizingen', 'Sint-Pieters-Leeuw', 'Ruisbroek', 'Vlezenbeek', 'Drogenbos', 'Linkebeek', 'Rhode-Saint-Genèse', 'Beersel', 'Lot', 'Alsemberg', 'Huizingen', 'Dilbeek', 'Itterbeek', 'Groot-Bijgaarden', 'Sint-Stevens-Woluwe') AND a1_.slug IN ('uccle-1180', 'bruxelles-1000', 'schaerbeek-1030', 'etterbeek-1040', 'ixelles-1050', 'saint-gilles-1060', 'anderlecht-1070', 'molenbeek-saint-jean-1080', 'koekelberg-1081', 'berchem-sainte-agathe-1082', 'ganshoren-1083', 'evere-1140', 'woluwe-saint-pierre-1150', 'auderghem-1160', 'watermael-boitsfort-1170', 'forest-1190', 'woluwe-saint-lambert-1200', 'saint-josse-ten-noode-sint-joost-ten-node-1210', 'buizingen-1501', 'sint-pieters-leeuw-1600', 'ruisbroek-1601', 'vlezenbeek-1602', 'drogenbos-1620', 'linkebeek-1630', 'rhode-saint-genese-1640', 'beersel-1650', 'lot-1651', 'alsemberg-1652', 'huizingen-1654', 'dilbeek-1700', 'itterbeek-1701', 'groot-bijgaarden-1702', 'sint-stevens-woluwe-1932')) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 20;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.uid AS uid_1,
          p0_.created_at AS created_at_2,
          p0_.updated_at AS updated_at_3,
          p0_.status AS status_4,
          p0_.state AS state_5,
          p0_.type AS type_6,
          p0_.area AS area_7,
          p0_.rooms AS rooms_8,
          p0_.floor AS floor_9,
          p0_.elevator AS elevator_10,
          p0_.furnished AS furnished_11,
          p0_.heating AS heating_12,
          p0_.equipments AS equipments_13,
          p0_.benefits AS benefits_14,
          p0_.rent AS rent_15,
          p0_.charges AS charges_16,
          p0_.services AS services_17,
          p0_.availability_date AS availability_date_18,
          p0_.description AS description_19,
          p0_.title AS title_20,
          p0_.active AS active_21,
          p0_.score AS score_22,
          p0_.extrafields AS extrafields_23
        FROM
          property p0_
          LEFT JOIN address a1_ ON p0_.address_id = a1_.id
        WHERE
          p0_.status = 2
          AND p0_.furnished = true
          AND a1_.city IN (
            ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
            ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
            ?, ?
          )
          AND a1_.slug IN (
            ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
            ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
            ?, ?
          )
        ORDER BY
          p0_.active DESC,
          CASE WHEN a1_.slug = ? THEN
            1
          ELSE
            0
          END DESC,
          CASE WHEN a1_.city LIKE ? THEN
            1
          ELSE
            0
          END DESC,
          p0_.score DESC,
          p0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.uid AS uid_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.status AS status_4, p0_.state AS state_5, p0_.type AS type_6, p0_.area AS area_7, p0_.rooms AS rooms_8, p0_.floor AS floor_9, p0_.elevator AS elevator_10, p0_.furnished AS furnished_11, p0_.heating AS heating_12, p0_.equipments AS equipments_13, p0_.benefits AS benefits_14, p0_.rent AS rent_15, p0_.charges AS charges_16, p0_.services AS services_17, p0_.availability_date AS availability_date_18, p0_.description AS description_19, p0_.title AS title_20, p0_.active AS active_21, p0_.score AS score_22, p0_.extrafields AS extrafields_23 FROM property p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id WHERE p0_.status = 2 AND p0_.furnished = true AND a1_.city IN ('Uccle', 'Bruxelles', 'Schaerbeek', 'Etterbeek', 'Ixelles', 'Saint-Gilles', 'Anderlecht', 'Molenbeek-Saint-Jean', 'Koekelberg', 'Berchem-Sainte-Agathe', 'Ganshoren', 'Evere', 'Woluwe-Saint-Pierre', 'Auderghem', 'Watermael-Boitsfort', 'Forest', 'Woluwe-Saint-Lambert', 'Saint-Josse-ten-Noode - Sint-Joost-ten-Node', 'Buizingen', 'Sint-Pieters-Leeuw', 'Ruisbroek', 'Vlezenbeek', 'Drogenbos', 'Linkebeek', 'Rhode-Saint-Genèse', 'Beersel', 'Lot', 'Alsemberg', 'Huizingen', 'Dilbeek', 'Itterbeek', 'Groot-Bijgaarden', 'Sint-Stevens-Woluwe') AND a1_.slug IN ('uccle-1180', 'bruxelles-1000', 'schaerbeek-1030', 'etterbeek-1040', 'ixelles-1050', 'saint-gilles-1060', 'anderlecht-1070', 'molenbeek-saint-jean-1080', 'koekelberg-1081', 'berchem-sainte-agathe-1082', 'ganshoren-1083', 'evere-1140', 'woluwe-saint-pierre-1150', 'auderghem-1160', 'watermael-boitsfort-1170', 'forest-1190', 'woluwe-saint-lambert-1200', 'saint-josse-ten-noode-sint-joost-ten-node-1210', 'buizingen-1501', 'sint-pieters-leeuw-1600', 'ruisbroek-1601', 'vlezenbeek-1602', 'drogenbos-1620', 'linkebeek-1630', 'rhode-saint-genese-1640', 'beersel-1650', 'lot-1651', 'alsemberg-1652', 'huizingen-1654', 'dilbeek-1700', 'itterbeek-1701', 'groot-bijgaarden-1702', 'sint-stevens-woluwe-1932') ORDER BY p0_.active DESC, CASE WHEN a1_.slug = 'uccle-1180' THEN 1 ELSE 0 END DESC, CASE WHEN a1_.city LIKE 'Uccle%' THEN 1 ELSE 0 END DESC, p0_.score DESC, p0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT l0_.locality AS locality_0,
  l0_.city AS city_1,
  l0_.slug AS slug_2,
  l0_.zipcode AS zipcode_3,
  l0_.latitude AS latitude_4,
  l0_.longitude AS longitude_5
FROM
  locality l0_
WHERE
  l0_.latitude > ?
  AND l0_.latitude < ?
  AND l0_.longitude > ?
  AND l0_.longitude < ?
  AND l0_.slug <> ?
  AND (
    l0_.slug LIKE ?
    OR l0_.slug LIKE ?
    OR l0_.slug LIKE ?
    OR l0_.slug LIKE ?
    OR l0_.slug LIKE ?
    OR l0_.slug LIKE ?
    OR l0_.slug LIKE ?
    OR l0_.slug LIKE ?
    OR l0_.slug LIKE ?
    OR l0_.slug LIKE ?
  )
ORDER BY
  l0_.zipcode ASC,
  l0_.city ASC

SELECT DISTINCT l0_.locality AS locality_0, l0_.city AS city_1, l0_.slug AS slug_2, l0_.zipcode AS zipcode_3, l0_.latitude AS latitude_4, l0_.longitude AS longitude_5 FROM locality l0_ WHERE l0_.latitude > 50.731678847349 AND l0_.latitude < 50.875409352651 AND l0_.longitude > 4.2201303044861 AND l0_.longitude < 4.4475586955139 AND l0_.slug <> 'uccle-1180' AND (l0_.slug LIKE '%0%' OR l0_.slug LIKE '%1%' OR l0_.slug LIKE '%2%' OR l0_.slug LIKE '%3%' OR l0_.slug LIKE '%4%' OR l0_.slug LIKE '%5%' OR l0_.slug LIKE '%6%' OR l0_.slug LIKE '%7%' OR l0_.slug LIKE '%8%' OR l0_.slug LIKE '%9%') ORDER BY l0_.zipcode ASC, l0_.city ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.content AS content_3,
  t0.h1 AS h1_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6,
  t0.canonical AS canonical_7,
  t0.locality_id AS locality_id_8
FROM
  locality_description t0
WHERE
  t0.locality_id = ?
  AND t0.type IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.content AS content_3, t0.h1 AS h1_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.canonical AS canonical_7, t0.locality_id AS locality_id_8 FROM locality_description t0 WHERE t0.locality_id = 19 AND t0.type IS NULL LIMIT 1;

SELECT
  MAX(p0_.rent) AS sclr_0
FROM
  property p0_
  LEFT JOIN address a1_ ON p0_.address_id = a1_.id
WHERE
  p0_.status = 2
  AND a1_.city IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
  AND a1_.zipcode IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
  AND p0_.furnished = true

SELECT MAX(p0_.rent) AS sclr_0 FROM property p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id WHERE p0_.status = 2 AND a1_.city IN ('Uccle', 'Bruxelles', 'Schaerbeek', 'Etterbeek', 'Ixelles', 'Saint-Gilles', 'Anderlecht', 'Molenbeek-Saint-Jean', 'Koekelberg', 'Berchem-Sainte-Agathe', 'Ganshoren', 'Evere', 'Woluwe-Saint-Pierre', 'Auderghem', 'Watermael-Boitsfort', 'Forest', 'Woluwe-Saint-Lambert', 'Saint-Josse-ten-Noode - Sint-Joost-ten-Node', 'Buizingen', 'Sint-Pieters-Leeuw', 'Ruisbroek', 'Vlezenbeek', 'Drogenbos', 'Linkebeek', 'Rhode-Saint-Genèse', 'Beersel', 'Lot', 'Alsemberg', 'Huizingen', 'Dilbeek', 'Itterbeek', 'Groot-Bijgaarden', 'Sint-Stevens-Woluwe') AND a1_.zipcode IN ('1180', '1000', '1030', '1040', '1050', '1060', '1070', '1080', '1081', '1082', '1083', '1140', '1150', '1160', '1170', '1190', '1200', '1210', '1501', '1600', '1601', '1602', '1620', '1630', '1640', '1650', '1651', '1652', '1654', '1700', '1701', '1702', '1932') AND p0_.furnished = true;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.locality AS locality_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.osm AS osm_6,
  t0.tier AS tier_7,
  t0.city AS city_8,
  t0.slug AS slug_9,
  t0.search AS search_10,
  t0.area AS area_11,
  t0.state AS state_12,
  t0.illustration AS illustration_13,
  t0.priority AS priority_14
FROM
  locality t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.locality AS locality_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.osm AS osm_6, t0.tier AS tier_7, t0.city AS city_8, t0.slug AS slug_9, t0.search AS search_10, t0.area AS area_11, t0.state AS state_12, t0.illustration AS illustration_13, t0.priority AS priority_14 FROM locality t0 WHERE t0.slug = 'uccle-1180' LIMIT 1;

SELECT
  MIN(p0_.rent) AS sclr_0
FROM
  property p0_
  LEFT JOIN address a1_ ON p0_.address_id = a1_.id
WHERE
  p0_.status = 2
  AND a1_.city IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
  AND a1_.zipcode IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
  AND p0_.furnished = true

SELECT MIN(p0_.rent) AS sclr_0 FROM property p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id WHERE p0_.status = 2 AND a1_.city IN ('Uccle', 'Bruxelles', 'Schaerbeek', 'Etterbeek', 'Ixelles', 'Saint-Gilles', 'Anderlecht', 'Molenbeek-Saint-Jean', 'Koekelberg', 'Berchem-Sainte-Agathe', 'Ganshoren', 'Evere', 'Woluwe-Saint-Pierre', 'Auderghem', 'Watermael-Boitsfort', 'Forest', 'Woluwe-Saint-Lambert', 'Saint-Josse-ten-Noode - Sint-Joost-ten-Node', 'Buizingen', 'Sint-Pieters-Leeuw', 'Ruisbroek', 'Vlezenbeek', 'Drogenbos', 'Linkebeek', 'Rhode-Saint-Genèse', 'Beersel', 'Lot', 'Alsemberg', 'Huizingen', 'Dilbeek', 'Itterbeek', 'Groot-Bijgaarden', 'Sint-Stevens-Woluwe') AND a1_.zipcode IN ('1180', '1000', '1030', '1040', '1050', '1060', '1070', '1080', '1081', '1082', '1083', '1140', '1150', '1160', '1170', '1190', '1200', '1210', '1501', '1600', '1601', '1602', '1620', '1630', '1640', '1650', '1651', '1652', '1654', '1700', '1701', '1702', '1932') AND p0_.furnished = true;

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.locality AS locality_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.osm AS osm_6,
  t0.tier AS tier_7,
  t0.city AS city_8,
  t0.slug AS slug_9,
  t0.search AS search_10,
  t0.area AS area_11,
  t0.state AS state_12,
  t0.illustration AS illustration_13,
  t0.priority AS priority_14
FROM
  locality t0
WHERE
  t0.city = ?
  AND t0.zipcode = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.locality AS locality_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.osm AS osm_6, t0.tier AS tier_7, t0.city AS city_8, t0.slug AS slug_9, t0.search AS search_10, t0.area AS area_11, t0.state AS state_12, t0.illustration AS illustration_13, t0.priority AS priority_14 FROM locality t0 WHERE t0.city = 'Uccle' AND t0.zipcode = '1180' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.content AS content_3,
  t0.h1 AS h1_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6,
  t0.canonical AS canonical_7,
  t0.locality_id AS locality_id_8
FROM
  locality_description t0
WHERE
  t0.locality_id = ?
  AND t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.content AS content_3, t0.h1 AS h1_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.canonical AS canonical_7, t0.locality_id AS locality_id_8 FROM locality_description t0 WHERE t0.locality_id = 19 AND t0.type = 4 LIMIT 1;