Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.price AS price_2,
  p0_.description AS description_3,
  p0_.size AS size_4,
  p0_.floors AS floors_5,
  p0_.rooms AS rooms_6,
  p0_.bathrooms AS bathrooms_7,
  p0_.bedrooms AS bedrooms_8,
  p0_.garages AS garages_9,
  p0_.address_street AS address_street_10,
  p0_.address_city AS address_city_11,
  p0_.address_region AS address_region_12,
  p0_.address_zip_code AS address_zip_code_13,
  p0_.address_country AS address_country_14,
  p0_.contact_phone AS contact_phone_15,
  p0_.contact_email AS contact_email_16,
  p0_.contact_www AS contact_www_17,
  p0_.video AS video_18,
  p0_.slug AS slug_19,
  p0_.latitude AS latitude_20,
  p0_.longitude AS longitude_21,
  p0_.address_district AS address_district_22,
  p0_.meter_price AS meter_price_23,
  p0_.offer_status AS offer_status_24,
  p0_.created_at AS created_at_25,
  p0_.modified_at AS modified_at_26,
  p0_.is_active AS is_active_27,
  p0_.agent_id AS agent_id_28,
  p0_.category_id AS category_id_29,
  p0_.offer_type_id AS offer_type_id_30
FROM
  property p0_
WHERE
  p0_.is_active = 1
  AND p0_.offer_status NOT IN (?, ?)
ORDER BY
  p0_.created_at DESC
LIMIT
  8

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.price AS price_2, p0_.description AS description_3, p0_.size AS size_4, p0_.floors AS floors_5, p0_.rooms AS rooms_6, p0_.bathrooms AS bathrooms_7, p0_.bedrooms AS bedrooms_8, p0_.garages AS garages_9, p0_.address_street AS address_street_10, p0_.address_city AS address_city_11, p0_.address_region AS address_region_12, p0_.address_zip_code AS address_zip_code_13, p0_.address_country AS address_country_14, p0_.contact_phone AS contact_phone_15, p0_.contact_email AS contact_email_16, p0_.contact_www AS contact_www_17, p0_.video AS video_18, p0_.slug AS slug_19, p0_.latitude AS latitude_20, p0_.longitude AS longitude_21, p0_.address_district AS address_district_22, p0_.meter_price AS meter_price_23, p0_.offer_status AS offer_status_24, p0_.created_at AS created_at_25, p0_.modified_at AS modified_at_26, p0_.is_active AS is_active_27, p0_.agent_id AS agent_id_28, p0_.category_id AS category_id_29, p0_.offer_type_id AS offer_type_id_30 FROM property p0_ WHERE p0_.is_active = 1 AND p0_.offer_status NOT IN ('A', 'N') ORDER BY p0_.created_at DESC LIMIT 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3
FROM
  property_category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3 FROM property_category t0;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.icon AS icon_2
FROM
  property_amenity p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.icon AS icon_2 FROM property_amenity p0_;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.price AS price_2,
  p0_.description AS description_3,
  p0_.size AS size_4,
  p0_.floors AS floors_5,
  p0_.rooms AS rooms_6,
  p0_.bathrooms AS bathrooms_7,
  p0_.bedrooms AS bedrooms_8,
  p0_.garages AS garages_9,
  p0_.address_street AS address_street_10,
  p0_.address_city AS address_city_11,
  p0_.address_region AS address_region_12,
  p0_.address_zip_code AS address_zip_code_13,
  p0_.address_country AS address_country_14,
  p0_.contact_phone AS contact_phone_15,
  p0_.contact_email AS contact_email_16,
  p0_.contact_www AS contact_www_17,
  p0_.video AS video_18,
  p0_.slug AS slug_19,
  p0_.latitude AS latitude_20,
  p0_.longitude AS longitude_21,
  p0_.address_district AS address_district_22,
  p0_.meter_price AS meter_price_23,
  p0_.offer_status AS offer_status_24,
  p0_.created_at AS created_at_25,
  p0_.modified_at AS modified_at_26,
  p0_.is_active AS is_active_27,
  p0_.agent_id AS agent_id_28,
  p0_.category_id AS category_id_29,
  p0_.offer_type_id AS offer_type_id_30
FROM
  property p0_
WHERE
  p0_.is_active = 1
  AND p0_.meter_price > 0
  AND p0_.offer_status NOT IN (?, ?)
ORDER BY
  p0_.meter_price ASC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.price AS price_2, p0_.description AS description_3, p0_.size AS size_4, p0_.floors AS floors_5, p0_.rooms AS rooms_6, p0_.bathrooms AS bathrooms_7, p0_.bedrooms AS bedrooms_8, p0_.garages AS garages_9, p0_.address_street AS address_street_10, p0_.address_city AS address_city_11, p0_.address_region AS address_region_12, p0_.address_zip_code AS address_zip_code_13, p0_.address_country AS address_country_14, p0_.contact_phone AS contact_phone_15, p0_.contact_email AS contact_email_16, p0_.contact_www AS contact_www_17, p0_.video AS video_18, p0_.slug AS slug_19, p0_.latitude AS latitude_20, p0_.longitude AS longitude_21, p0_.address_district AS address_district_22, p0_.meter_price AS meter_price_23, p0_.offer_status AS offer_status_24, p0_.created_at AS created_at_25, p0_.modified_at AS modified_at_26, p0_.is_active AS is_active_27, p0_.agent_id AS agent_id_28, p0_.category_id AS category_id_29, p0_.offer_type_id AS offer_type_id_30 FROM property p0_ WHERE p0_.is_active = 1 AND p0_.meter_price > 0 AND p0_.offer_status NOT IN ('A', 'N') ORDER BY p0_.meter_price ASC LIMIT 10;

SELECT
  f0_.id AS id_0,
  f0_.added_at AS added_at_1,
  f0_.modified_at AS modified_at_2,
  f0_.added_by_id AS added_by_id_3,
  f0_.property_id AS property_id_4
FROM
  featured_offer f0_
  INNER JOIN property p1_ ON f0_.property_id = p1_.id
WHERE
  p1_.is_active = 1
  AND p1_.offer_status <> ?
ORDER BY
  f0_.added_at DESC
LIMIT
  3

SELECT f0_.id AS id_0, f0_.added_at AS added_at_1, f0_.modified_at AS modified_at_2, f0_.added_by_id AS added_by_id_3, f0_.property_id AS property_id_4 FROM featured_offer f0_ INNER JOIN property p1_ ON f0_.property_id = p1_.id WHERE p1_.is_active = 1 AND p1_.offer_status <> 'A' ORDER BY f0_.added_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.is_youtube AS is_youtube_4,
  t0.created_at AS created_at_5,
  t0.modified_at AS modified_at_6,
  t0.is_active AS is_active_7,
  t0.start_time AS start_time_8,
  t0.end_time AS end_time_9,
  t0.created_by_id AS created_by_id_10
FROM
  home_hero t0
WHERE
  t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.is_youtube AS is_youtube_4, t0.created_at AS created_at_5, t0.modified_at AS modified_at_6, t0.is_active AS is_active_7, t0.start_time AS start_time_8, t0.end_time AS end_time_9, t0.created_by_id AS created_by_id_10 FROM home_hero t0 WHERE t0.is_active = 1 LIMIT 1;

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1
FROM
  offer_type o0_

SELECT o0_.id AS id_0, o0_.name AS name_1 FROM offer_type o0_;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.icon AS icon_2
FROM
  property_category p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.icon AS icon_2 FROM property_category p0_;