Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.api_id AS api_id_2,
  t0.agency_name AS agency_name_3,
  t0.agency_reference AS agency_reference_4,
  t0.lastupdate AS lastupdate_5,
  t0.status_id AS status_id_6,
  t0.reference AS reference_7,
  t0.name AS name_8,
  t0.adresse AS adresse_9,
  t0.price AS price_10,
  t0.surface AS surface_11,
  t0.rooms AS rooms_12,
  t0.bathrooms AS bathrooms_13,
  t0.showerrooms AS showerrooms_14,
  t0.bedrooms AS bedrooms_15,
  t0.floor AS floor_16,
  t0.description AS description_17,
  t0.promotion_id AS promotion_id_18,
  t0.transaction_type AS transaction_type_19,
  t0.enabled AS enabled_20,
  t0.featured AS featured_21,
  t0.type_property AS type_property_22,
  t0.longitude AS longitude_23,
  t0.latitude AS latitude_24,
  t0.zip AS zip_25,
  t0.videos_object AS videos_object_26,
  t0.visit3ds_object AS visit3ds_object_27,
  t0.disponibilite_date AS disponibilite_date_28,
  t0.status AS status_29,
  t0.country_fr AS country_fr_30,
  t0.district_fr AS district_fr_31,
  t0.canton_fr AS canton_fr_32,
  t0.quarter_fr AS quarter_fr_33,
  t0.zone_fr AS zone_fr_34,
  t0.city_fr AS city_fr_35,
  t0.disponible_fr AS disponible_fr_36,
  t0.broker_id AS broker_id_37,
  t0.country_id AS country_id_38,
  t0.canton_id AS canton_id_39,
  t0.district_id AS district_id_40,
  t0.quarter_id AS quarter_id_41,
  t0.zone_id AS zone_id_42,
  t0.city_id AS city_id_43,
  t0.type_id AS type_id_44,
  t0.disponible_id AS disponible_id_45
FROM
  property t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.api_id AS api_id_2, t0.agency_name AS agency_name_3, t0.agency_reference AS agency_reference_4, t0.lastupdate AS lastupdate_5, t0.status_id AS status_id_6, t0.reference AS reference_7, t0.name AS name_8, t0.adresse AS adresse_9, t0.price AS price_10, t0.surface AS surface_11, t0.rooms AS rooms_12, t0.bathrooms AS bathrooms_13, t0.showerrooms AS showerrooms_14, t0.bedrooms AS bedrooms_15, t0.floor AS floor_16, t0.description AS description_17, t0.promotion_id AS promotion_id_18, t0.transaction_type AS transaction_type_19, t0.enabled AS enabled_20, t0.featured AS featured_21, t0.type_property AS type_property_22, t0.longitude AS longitude_23, t0.latitude AS latitude_24, t0.zip AS zip_25, t0.videos_object AS videos_object_26, t0.visit3ds_object AS visit3ds_object_27, t0.disponibilite_date AS disponibilite_date_28, t0.status AS status_29, t0.country_fr AS country_fr_30, t0.district_fr AS district_fr_31, t0.canton_fr AS canton_fr_32, t0.quarter_fr AS quarter_fr_33, t0.zone_fr AS zone_fr_34, t0.city_fr AS city_fr_35, t0.disponible_fr AS disponible_fr_36, t0.broker_id AS broker_id_37, t0.country_id AS country_id_38, t0.canton_id AS canton_id_39, t0.district_id AS district_id_40, t0.quarter_id AS quarter_id_41, t0.zone_id AS zone_id_42, t0.city_id AS city_id_43, t0.type_id AS type_id_44, t0.disponible_id AS disponible_id_45 FROM property t0 WHERE t0.id = 137;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.code AS code_3,
  t0.periorite AS periorite_4
FROM
  type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.periorite AS periorite_4 FROM type t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.path AS path_3,
  t0.ref AS ref_4,
  t0.ordre AS ordre_5,
  t0.property_id AS property_id_6,
  t0.broker_id AS broker_id_7
FROM
  photo t0
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.ref AS ref_4, t0.ordre AS ordre_5, t0.property_id AS property_id_6, t0.broker_id AS broker_id_7 FROM photo t0 WHERE t0.property_id = 137;

SELECT
  t0.id AS id_1,
  t0.broker_id AS broker_id_2,
  t0.last_name AS last_name_3,
  t0.first_name AS first_name_4,
  t0.job AS job_5,
  t0.email AS email_6,
  t0.phone AS phone_7,
  t0.mobile AS mobile_8
FROM
  broker t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.broker_id AS broker_id_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.job AS job_5, t0.email AS email_6, t0.phone AS phone_7, t0.mobile AS mobile_8 FROM broker t0 WHERE t0.id = 6;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.api_id AS api_id_1,
  p0_.agency_name AS agency_name_2,
  p0_.agency_reference AS agency_reference_3,
  p0_.lastupdate AS lastupdate_4,
  p0_.status_id AS status_id_5,
  p0_.reference AS reference_6,
  p0_.name AS name_7,
  p0_.adresse AS adresse_8,
  p0_.price AS price_9,
  p0_.surface AS surface_10,
  p0_.rooms AS rooms_11,
  p0_.bathrooms AS bathrooms_12,
  p0_.showerrooms AS showerrooms_13,
  p0_.bedrooms AS bedrooms_14,
  p0_.floor AS floor_15,
  p0_.description AS description_16,
  p0_.promotion_id AS promotion_id_17,
  p0_.transaction_type AS transaction_type_18,
  p0_.enabled AS enabled_19,
  p0_.featured AS featured_20,
  p0_.type_property AS type_property_21,
  p0_.longitude AS longitude_22,
  p0_.latitude AS latitude_23,
  p0_.zip AS zip_24,
  p0_.videos_object AS videos_object_25,
  p0_.visit3ds_object AS visit3ds_object_26,
  p0_.disponibilite_date AS disponibilite_date_27,
  p0_.status AS status_28,
  p0_.country_fr AS country_fr_29,
  p0_.district_fr AS district_fr_30,
  p0_.canton_fr AS canton_fr_31,
  p0_.quarter_fr AS quarter_fr_32,
  p0_.zone_fr AS zone_fr_33,
  p0_.city_fr AS city_fr_34,
  p0_.disponible_fr AS disponible_fr_35,
  SQRT(
    (p1_.latitude - p0_.latitude) * (p1_.latitude - p0_.latitude) + (p1_.longitude - p0_.longitude) * (p1_.longitude - p0_.longitude)
  ) AS sclr_36,
  p0_.broker_id AS broker_id_37,
  p0_.country_id AS country_id_38,
  p0_.canton_id AS canton_id_39,
  p0_.district_id AS district_id_40,
  p0_.quarter_id AS quarter_id_41,
  p0_.zone_id AS zone_id_42,
  p0_.city_id AS city_id_43,
  p0_.type_id AS type_id_44,
  p0_.disponible_id AS disponible_id_45
FROM
  property p0_
  INNER JOIN property p1_
WHERE
  p0_.transaction_type = ?
  AND p1_.id = 137
  AND p0_.id <> 137
  AND p1_.type_id = p0_.type_id
  AND p0_.surface <= p1_.surface + (p1_.surface * 0.5)
  AND p0_.surface >= p1_.surface - (p1_.surface * 0.5)
  AND p0_.price <= p1_.price + (p1_.price * 0.5)
  AND p0_.price >= p1_.price - (p1_.price * 0.5)
HAVING
  sclr_36 <= 35000
ORDER BY
  p0_.id DESC

SELECT DISTINCT p0_.id AS id_0, p0_.api_id AS api_id_1, p0_.agency_name AS agency_name_2, p0_.agency_reference AS agency_reference_3, p0_.lastupdate AS lastupdate_4, p0_.status_id AS status_id_5, p0_.reference AS reference_6, p0_.name AS name_7, p0_.adresse AS adresse_8, p0_.price AS price_9, p0_.surface AS surface_10, p0_.rooms AS rooms_11, p0_.bathrooms AS bathrooms_12, p0_.showerrooms AS showerrooms_13, p0_.bedrooms AS bedrooms_14, p0_.floor AS floor_15, p0_.description AS description_16, p0_.promotion_id AS promotion_id_17, p0_.transaction_type AS transaction_type_18, p0_.enabled AS enabled_19, p0_.featured AS featured_20, p0_.type_property AS type_property_21, p0_.longitude AS longitude_22, p0_.latitude AS latitude_23, p0_.zip AS zip_24, p0_.videos_object AS videos_object_25, p0_.visit3ds_object AS visit3ds_object_26, p0_.disponibilite_date AS disponibilite_date_27, p0_.status AS status_28, p0_.country_fr AS country_fr_29, p0_.district_fr AS district_fr_30, p0_.canton_fr AS canton_fr_31, p0_.quarter_fr AS quarter_fr_32, p0_.zone_fr AS zone_fr_33, p0_.city_fr AS city_fr_34, p0_.disponible_fr AS disponible_fr_35, SQRT((p1_.latitude - p0_.latitude) * (p1_.latitude - p0_.latitude) + (p1_.longitude - p0_.longitude) * (p1_.longitude - p0_.longitude)) AS sclr_36, p0_.broker_id AS broker_id_37, p0_.country_id AS country_id_38, p0_.canton_id AS canton_id_39, p0_.district_id AS district_id_40, p0_.quarter_id AS quarter_id_41, p0_.zone_id AS zone_id_42, p0_.city_id AS city_id_43, p0_.type_id AS type_id_44, p0_.disponible_id AS disponible_id_45 FROM property p0_ INNER JOIN property p1_ WHERE p0_.transaction_type = 2 AND p1_.id = 137 AND p0_.id <> 137 AND p1_.type_id = p0_.type_id AND p0_.surface <= p1_.surface + (p1_.surface * 0.5) AND p0_.surface >= p1_.surface - (p1_.surface * 0.5) AND p0_.price <= p1_.price + (p1_.price * 0.5) AND p0_.price >= p1_.price - (p1_.price * 0.5) HAVING sclr_36 <= 35000 ORDER BY p0_.id DESC;