Symfony Profiler

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  real_estate r0_
WHERE
  r0_.status = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM real_estate r0_ WHERE r0_.status = 'publish';

SELECT
  r0_.id AS id_0,
  r0_.internal AS internal_1,
  r0_.reference AS reference_2,
  r0_.type AS type_3,
  r0_.category AS category_4,
  r0_.contract AS contract_5,
  r0_.status AS status_6,
  r0_.title AS title_7,
  r0_.description AS description_8,
  r0_.slug AS slug_9,
  r0_.virtual_tour AS virtual_tour_10,
  r0_.images AS images_11,
  r0_.available_at AS available_at_12,
  r1_.id AS id_13,
  r1_.visible AS visible_14,
  r1_.street AS street_15,
  r1_.zipcode AS zipcode_16,
  r1_.city AS city_17,
  r1_.borough AS borough_18,
  r1_.latitude AS latitude_19,
  r1_.longitude AS longitude_20,
  r2_.id AS id_21,
  r2_.building_year AS building_year_22,
  r2_.energy_grade AS energy_grade_23,
  r2_.energy_consumption AS energy_consumption_24,
  r2_.energy_cost_min AS energy_cost_min_25,
  r2_.energy_cost_max AS energy_cost_max_26,
  r2_.energy_cost_year AS energy_cost_year_27,
  r2_.ges_grade AS ges_grade_28,
  r2_.ges_value AS ges_value_29,
  r2_.surface_carrez AS surface_carrez_30,
  r2_.surface AS surface_31,
  r2_.rooms AS rooms_32,
  r2_.bedrooms AS bedrooms_33,
  r2_.bathrooms AS bathrooms_34,
  r2_.wc AS wc_35,
  r2_.floors AS floors_36,
  r2_.balcony AS balcony_37,
  r2_.terrace AS terrace_38,
  r2_.garage AS garage_39,
  r2_.parking AS parking_40,
  r2_.heating_type AS heating_type_41,
  r2_.heating_mode AS heating_mode_42,
  r2_.hotwater AS hotwater_43,
  r2_.kitchen AS kitchen_44,
  r2_.aspect AS aspect_45,
  r2_.windows AS windows_46,
  r2_.proximities AS proximities_47,
  r2_.equipments AS equipments_48,
  r3_.id AS id_49,
  r3_.price AS price_50,
  r3_.annual_charges AS annual_charges_51,
  r3_.fees_percent AS fees_percent_52,
  r3_.price_fees_excl AS price_fees_excl_53,
  r3_.buyer_fees AS buyer_fees_54,
  r3_.nb_lots AS nb_lots_55,
  r3_.nb_lots_hab AS nb_lots_hab_56,
  r3_.nb_procedures AS nb_procedures_57,
  r4_.id AS id_58,
  r4_.price_hc AS price_hc_59,
  r4_.charges AS charges_60,
  r4_.price_cc AS price_cc_61,
  r4_.alur AS alur_62,
  r4_.rent_base AS rent_base_63,
  r4_.rent_ref AS rent_ref_64,
  r4_.deposit AS deposit_65,
  r4_.checkin_fees AS checkin_fees_66,
  r1_.parent_id AS parent_id_67,
  r2_.parent_id AS parent_id_68,
  r3_.parent_id AS parent_id_69,
  r4_.parent_id AS parent_id_70
FROM
  real_estate r0_
  LEFT JOIN real_estate_address r1_ ON r0_.id = r1_.parent_id
  LEFT JOIN real_estate_details r2_ ON r0_.id = r2_.parent_id
  LEFT JOIN real_estate_sale r3_ ON r0_.id = r3_.parent_id
  LEFT JOIN real_estate_rental r4_ ON r0_.id = r4_.parent_id
WHERE
  r0_.status = ?
ORDER BY
  r0_.contract ASC,
  r3_.price ASC,
  r4_.price_cc ASC
LIMIT
  24

SELECT r0_.id AS id_0, r0_.internal AS internal_1, r0_.reference AS reference_2, r0_.type AS type_3, r0_.category AS category_4, r0_.contract AS contract_5, r0_.status AS status_6, r0_.title AS title_7, r0_.description AS description_8, r0_.slug AS slug_9, r0_.virtual_tour AS virtual_tour_10, r0_.images AS images_11, r0_.available_at AS available_at_12, r1_.id AS id_13, r1_.visible AS visible_14, r1_.street AS street_15, r1_.zipcode AS zipcode_16, r1_.city AS city_17, r1_.borough AS borough_18, r1_.latitude AS latitude_19, r1_.longitude AS longitude_20, r2_.id AS id_21, r2_.building_year AS building_year_22, r2_.energy_grade AS energy_grade_23, r2_.energy_consumption AS energy_consumption_24, r2_.energy_cost_min AS energy_cost_min_25, r2_.energy_cost_max AS energy_cost_max_26, r2_.energy_cost_year AS energy_cost_year_27, r2_.ges_grade AS ges_grade_28, r2_.ges_value AS ges_value_29, r2_.surface_carrez AS surface_carrez_30, r2_.surface AS surface_31, r2_.rooms AS rooms_32, r2_.bedrooms AS bedrooms_33, r2_.bathrooms AS bathrooms_34, r2_.wc AS wc_35, r2_.floors AS floors_36, r2_.balcony AS balcony_37, r2_.terrace AS terrace_38, r2_.garage AS garage_39, r2_.parking AS parking_40, r2_.heating_type AS heating_type_41, r2_.heating_mode AS heating_mode_42, r2_.hotwater AS hotwater_43, r2_.kitchen AS kitchen_44, r2_.aspect AS aspect_45, r2_.windows AS windows_46, r2_.proximities AS proximities_47, r2_.equipments AS equipments_48, r3_.id AS id_49, r3_.price AS price_50, r3_.annual_charges AS annual_charges_51, r3_.fees_percent AS fees_percent_52, r3_.price_fees_excl AS price_fees_excl_53, r3_.buyer_fees AS buyer_fees_54, r3_.nb_lots AS nb_lots_55, r3_.nb_lots_hab AS nb_lots_hab_56, r3_.nb_procedures AS nb_procedures_57, r4_.id AS id_58, r4_.price_hc AS price_hc_59, r4_.charges AS charges_60, r4_.price_cc AS price_cc_61, r4_.alur AS alur_62, r4_.rent_base AS rent_base_63, r4_.rent_ref AS rent_ref_64, r4_.deposit AS deposit_65, r4_.checkin_fees AS checkin_fees_66, r1_.parent_id AS parent_id_67, r2_.parent_id AS parent_id_68, r3_.parent_id AS parent_id_69, r4_.parent_id AS parent_id_70 FROM real_estate r0_ LEFT JOIN real_estate_address r1_ ON r0_.id = r1_.parent_id LEFT JOIN real_estate_details r2_ ON r0_.id = r2_.parent_id LEFT JOIN real_estate_sale r3_ ON r0_.id = r3_.parent_id LEFT JOIN real_estate_rental r4_ ON r0_.id = r4_.parent_id WHERE r0_.status = 'publish' ORDER BY r0_.contract ASC, r3_.price ASC, r4_.price_cc ASC LIMIT 24;

SELECT
  s0_.label AS label_0,
  s0_.slug AS slug_1,
  s0_.type AS type_2,
  r1_.charvalue AS charvalue_3,
  r1_.numvalue AS numvalue_4,
  COUNT(DISTINCT r2_.id) AS sclr_5
FROM
  real_estate_search_facet r1_
  INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id
  INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id
WHERE
  s0_.active = true
GROUP BY
  s0_.label,
  s0_.slug,
  r1_.charvalue,
  r1_.numvalue,
  s0_.order,
  s0_.type
ORDER BY
  s0_.order ASC,
  r1_.numvalue ASC,
  r1_.charvalue ASC

SELECT s0_.label AS label_0, s0_.slug AS slug_1, s0_.type AS type_2, r1_.charvalue AS charvalue_3, r1_.numvalue AS numvalue_4, COUNT(DISTINCT r2_.id) AS sclr_5 FROM real_estate_search_facet r1_ INNER JOIN search_facet s0_ ON r1_.facet_id = s0_.id INNER JOIN real_estate r2_ ON r1_.real_estate_id = r2_.id WHERE s0_.active = true GROUP BY s0_.label, s0_.slug, r1_.charvalue, r1_.numvalue, s0_.order, s0_.type ORDER BY s0_.order ASC, r1_.numvalue ASC, r1_.charvalue ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 170;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 174;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 169;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 166;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 45;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 171;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 168;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 165;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 130;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 167;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 162;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 161;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 19;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 157;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 164;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 154;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.distance AS distance_3,
  t0.lines AS lines_4,
  t0.place_id AS place_id_5,
  t0.parent_id AS parent_id_6
FROM
  real_estate_nearby t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.distance AS distance_3, t0.lines AS lines_4, t0.place_id AS place_id_5, t0.parent_id AS parent_id_6 FROM real_estate_nearby t0 WHERE t0.parent_id = 160;