Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.uuid AS uuid_1,
  p0_.created AS created_2,
  p0_.modified AS modified_3,
  p0_.listing_type AS listing_type_4,
  p0_.reference AS reference_5,
  p0_.date_available AS date_available_6,
  p0_.name_number AS name_number_7,
  p0_.address2 AS address2_8,
  p0_.address3 AS address3_9,
  p0_.address4 AS address4_10,
  p0_.town AS town_11,
  p0_.postcode AS postcode_12,
  p0_.latitude AS latitude_13,
  p0_.longitude AS longitude_14,
  p0_.rental_price AS rental_price_15,
  p0_.monthly_rental_price AS monthly_rental_price_16,
  p0_.rent_frequency AS rent_frequency_17,
  p0_.sale_price AS sale_price_18,
  p0_.corner_banner AS corner_banner_19,
  p0_.summary AS summary_20,
  p0_.description AS description_21,
  p0_.bedrooms AS bedrooms_22,
  p0_.bathrooms AS bathrooms_23,
  p0_.reception_rooms AS reception_rooms_24,
  p0_.epc_url AS epc_url_25,
  p0_.show_on_website AS show_on_website_26,
  p0_.show_on_right_move AS show_on_right_move_27,
  p0_.right_move_status AS right_move_status_28,
  p0_.right_move_last_updated AS right_move_last_updated_29,
  p0_.right_move_listing_url AS right_move_listing_url_30,
  p0_.show_on_zoopla AS show_on_zoopla_31,
  p0_.zoopla_status AS zoopla_status_32,
  p0_.zoopla_last_updated AS zoopla_last_updated_33,
  p0_.zoopla_listing_url AS zoopla_listing_url_34,
  p0_.billable_monthly_rent AS billable_monthly_rent_35,
  p0_.landlord_id AS landlord_id_36,
  p0_.type_id AS type_id_37,
  p0_.area_id AS area_id_38,
  p0_.featured_image_id AS featured_image_id_39
FROM
  properties_property p0_
WHERE
  p0_.reference = ?
  AND p0_.show_on_website = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created AS created_2, p0_.modified AS modified_3, p0_.listing_type AS listing_type_4, p0_.reference AS reference_5, p0_.date_available AS date_available_6, p0_.name_number AS name_number_7, p0_.address2 AS address2_8, p0_.address3 AS address3_9, p0_.address4 AS address4_10, p0_.town AS town_11, p0_.postcode AS postcode_12, p0_.latitude AS latitude_13, p0_.longitude AS longitude_14, p0_.rental_price AS rental_price_15, p0_.monthly_rental_price AS monthly_rental_price_16, p0_.rent_frequency AS rent_frequency_17, p0_.sale_price AS sale_price_18, p0_.corner_banner AS corner_banner_19, p0_.summary AS summary_20, p0_.description AS description_21, p0_.bedrooms AS bedrooms_22, p0_.bathrooms AS bathrooms_23, p0_.reception_rooms AS reception_rooms_24, p0_.epc_url AS epc_url_25, p0_.show_on_website AS show_on_website_26, p0_.show_on_right_move AS show_on_right_move_27, p0_.right_move_status AS right_move_status_28, p0_.right_move_last_updated AS right_move_last_updated_29, p0_.right_move_listing_url AS right_move_listing_url_30, p0_.show_on_zoopla AS show_on_zoopla_31, p0_.zoopla_status AS zoopla_status_32, p0_.zoopla_last_updated AS zoopla_last_updated_33, p0_.zoopla_listing_url AS zoopla_listing_url_34, p0_.billable_monthly_rent AS billable_monthly_rent_35, p0_.landlord_id AS landlord_id_36, p0_.type_id AS type_id_37, p0_.area_id AS area_id_38, p0_.featured_image_id AS featured_image_id_39 FROM properties_property p0_ WHERE p0_.reference = 6045 AND p0_.show_on_website = 1 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.identifier AS identifier_3,
  c0_.name AS name_4,
  c0_.is_locked AS is_locked_5,
  c0_.disable_child_items AS disable_child_items_6
FROM
  content_menus_menu c0_
WHERE
  c0_.identifier = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.identifier AS identifier_3, c0_.name AS name_4, c0_.is_locked AS is_locked_5, c0_.disable_child_items AS disable_child_items_6 FROM content_menus_menu c0_ WHERE c0_.identifier = 'primary' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.name AS name_4,
  t0.content AS content_5,
  t0.slug AS slug_6,
  t0.path AS path_7,
  t0.primary_image AS primary_image_8,
  t0.seo_page_title AS seo_page_title_9,
  t0.seo_description AS seo_description_10,
  t0.seo_keywords AS seo_keywords_11,
  t0.display_order AS display_order_12,
  t0.parent_id AS parent_id_13
FROM
  content_pages_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.content AS content_5, t0.slug AS slug_6, t0.path AS path_7, t0.primary_image AS primary_image_8, t0.seo_page_title AS seo_page_title_9, t0.seo_description AS seo_description_10, t0.seo_keywords AS seo_keywords_11, t0.display_order AS display_order_12, t0.parent_id AS parent_id_13 FROM content_pages_page t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.label AS label_4,
  t0.url AS url_5,
  t0.auto_update AS auto_update_6,
  t0.open_new_window AS open_new_window_7,
  t0.display_order AS display_order_8,
  t0.type AS type_9,
  t0.menu_id AS menu_id_10,
  t0.page_id AS page_id_11,
  t0.parent_id AS parent_id_12
FROM
  content_menus_menuitem t0
WHERE
  t0.menu_id = ?
ORDER BY
  t0.display_order ASC

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.menu_id = 1 ORDER BY t0.display_order ASC;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.label AS label_4,
  t0.url AS url_5,
  t0.auto_update AS auto_update_6,
  t0.open_new_window AS open_new_window_7,
  t0.display_order AS display_order_8,
  t0.type AS type_9,
  t0.menu_id AS menu_id_10,
  t0.page_id AS page_id_11,
  t0.parent_id AS parent_id_12
FROM
  content_menus_menuitem t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.display_order ASC

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.label AS label_4, t0.url AS url_5, t0.auto_update AS auto_update_6, t0.open_new_window AS open_new_window_7, t0.display_order AS display_order_8, t0.type AS type_9, t0.menu_id AS menu_id_10, t0.page_id AS page_id_11, t0.parent_id AS parent_id_12 FROM content_menus_menuitem t0 WHERE t0.parent_id = 4 ORDER BY t0.display_order ASC;

SELECT
  p0_.id AS id_0,
  p0_.uuid AS uuid_1,
  p0_.created AS created_2,
  p0_.modified AS modified_3,
  p0_.listing_type AS listing_type_4,
  p0_.reference AS reference_5,
  p0_.date_available AS date_available_6,
  p0_.name_number AS name_number_7,
  p0_.address2 AS address2_8,
  p0_.address3 AS address3_9,
  p0_.address4 AS address4_10,
  p0_.town AS town_11,
  p0_.postcode AS postcode_12,
  p0_.latitude AS latitude_13,
  p0_.longitude AS longitude_14,
  p0_.rental_price AS rental_price_15,
  p0_.monthly_rental_price AS monthly_rental_price_16,
  p0_.rent_frequency AS rent_frequency_17,
  p0_.sale_price AS sale_price_18,
  p0_.corner_banner AS corner_banner_19,
  p0_.summary AS summary_20,
  p0_.description AS description_21,
  p0_.bedrooms AS bedrooms_22,
  p0_.bathrooms AS bathrooms_23,
  p0_.reception_rooms AS reception_rooms_24,
  p0_.epc_url AS epc_url_25,
  p0_.show_on_website AS show_on_website_26,
  p0_.show_on_right_move AS show_on_right_move_27,
  p0_.right_move_status AS right_move_status_28,
  p0_.right_move_last_updated AS right_move_last_updated_29,
  p0_.right_move_listing_url AS right_move_listing_url_30,
  p0_.show_on_zoopla AS show_on_zoopla_31,
  p0_.zoopla_status AS zoopla_status_32,
  p0_.zoopla_last_updated AS zoopla_last_updated_33,
  p0_.zoopla_listing_url AS zoopla_listing_url_34,
  p0_.billable_monthly_rent AS billable_monthly_rent_35,
  p0_.landlord_id AS landlord_id_36,
  p0_.type_id AS type_id_37,
  p0_.area_id AS area_id_38,
  p0_.featured_image_id AS featured_image_id_39
FROM
  properties_property p0_
WHERE
  p0_.show_on_website = ?
  AND p0_.listing_type = ?
  AND p0_.id <> ?
  AND (
    p0_.area_id = ?
    OR p0_.bedrooms = ?
  )
LIMIT
  3

SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created AS created_2, p0_.modified AS modified_3, p0_.listing_type AS listing_type_4, p0_.reference AS reference_5, p0_.date_available AS date_available_6, p0_.name_number AS name_number_7, p0_.address2 AS address2_8, p0_.address3 AS address3_9, p0_.address4 AS address4_10, p0_.town AS town_11, p0_.postcode AS postcode_12, p0_.latitude AS latitude_13, p0_.longitude AS longitude_14, p0_.rental_price AS rental_price_15, p0_.monthly_rental_price AS monthly_rental_price_16, p0_.rent_frequency AS rent_frequency_17, p0_.sale_price AS sale_price_18, p0_.corner_banner AS corner_banner_19, p0_.summary AS summary_20, p0_.description AS description_21, p0_.bedrooms AS bedrooms_22, p0_.bathrooms AS bathrooms_23, p0_.reception_rooms AS reception_rooms_24, p0_.epc_url AS epc_url_25, p0_.show_on_website AS show_on_website_26, p0_.show_on_right_move AS show_on_right_move_27, p0_.right_move_status AS right_move_status_28, p0_.right_move_last_updated AS right_move_last_updated_29, p0_.right_move_listing_url AS right_move_listing_url_30, p0_.show_on_zoopla AS show_on_zoopla_31, p0_.zoopla_status AS zoopla_status_32, p0_.zoopla_last_updated AS zoopla_last_updated_33, p0_.zoopla_listing_url AS zoopla_listing_url_34, p0_.billable_monthly_rent AS billable_monthly_rent_35, p0_.landlord_id AS landlord_id_36, p0_.type_id AS type_id_37, p0_.area_id AS area_id_38, p0_.featured_image_id AS featured_image_id_39 FROM properties_property p0_ WHERE p0_.show_on_website = 1 AND p0_.listing_type = 'letting' AND p0_.id <> 1346 AND (p0_.area_id = 2 OR p0_.bedrooms = 7) LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.filename AS filename_4,
  t0.display_order AS display_order_5,
  t0.property_id AS property_id_6
FROM
  properties_image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.filename AS filename_4, t0.display_order AS display_order_5, t0.property_id AS property_id_6 FROM properties_image t0 WHERE t0.id = 766;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.`key` AS key_4,
  t0.value AS value_5
FROM
  system_config t0

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.`key` AS key_4, t0.value AS value_5 FROM system_config t0;

SELECT
  p0_.id AS id_0,
  p0_.uuid AS uuid_1,
  p0_.created AS created_2,
  p0_.filename AS filename_3,
  p0_.display_order AS display_order_4,
  p0_.property_id AS property_id_5
FROM
  properties_image p0_
WHERE
  p0_.property_id = ?
ORDER BY
  p0_.display_order ASC

SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created AS created_2, p0_.filename AS filename_3, p0_.display_order AS display_order_4, p0_.property_id AS property_id_5 FROM properties_image p0_ WHERE p0_.property_id = 1346 ORDER BY p0_.display_order ASC;

SELECT
  p0_.id AS id_0,
  p0_.uuid AS uuid_1,
  p0_.created AS created_2,
  p0_.name AS name_3
FROM
  properties_feature p0_
  INNER JOIN properties_propertyfeature p1_ ON p0_.id = p1_.feature_id
WHERE
  p1_.property_id = ?

SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created AS created_2, p0_.name AS name_3 FROM properties_feature p0_ INNER JOIN properties_propertyfeature p1_ ON p0_.id = p1_.feature_id WHERE p1_.property_id = 1346;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.name AS name_4
FROM
  properties_area t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4 FROM properties_area t0 WHERE t0.id = 2;