Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 350
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• PHPCR
• Debug
• Emails
• Serializer
• JMS Serializer 0 + 0
• Sulu
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.crm_link AS crm_link_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.emails AS emails_5, t0.phone_numbers AS phone_numbers_6, t0.appraisal_reason AS appraisal_reason_7, t0.appraisal_perceived_value AS appraisal_perceived_value_8, t0.sale_horizon AS sale_horizon_9, t0.buy_horizon AS buy_horizon_10, t0.source_name AS source_name_11, t0.lead_property_data AS lead_property_data_12, t0.api_created_at AS api_created_at_13, t0.synced_at AS synced_at_14, t0.property_id AS property_id_15 FROM realadvisor_lead t0 WHERE t0.property_id = ?

[
  10
]

SELECT
  t0.id AS id_1,
  t0.crm_link AS crm_link_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.emails AS emails_5,
  t0.phone_numbers AS phone_numbers_6,
  t0.appraisal_reason AS appraisal_reason_7,
  t0.appraisal_perceived_value AS appraisal_perceived_value_8,
  t0.sale_horizon AS sale_horizon_9,
  t0.buy_horizon AS buy_horizon_10,
  t0.source_name AS source_name_11,
  t0.lead_property_data AS lead_property_data_12,
  t0.api_created_at AS api_created_at_13,
  t0.synced_at AS synced_at_14,
  t0.property_id AS property_id_15
FROM
  realadvisor_lead t0
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.crm_link AS crm_link_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.emails AS emails_5, t0.phone_numbers AS phone_numbers_6, t0.appraisal_reason AS appraisal_reason_7, t0.appraisal_perceived_value AS appraisal_perceived_value_8, t0.sale_horizon AS sale_horizon_9, t0.buy_horizon AS buy_horizon_10, t0.source_name AS source_name_11, t0.lead_property_data AS lead_property_data_12, t0.api_created_at AS api_created_at_13, t0.synced_at AS synced_at_14, t0.property_id AS property_id_15 FROM realadvisor_lead t0 WHERE t0.property_id = 10;

SELECT r0_.id AS id_0, r0_.api_id AS api_id_1, r0_.lot_reference AS lot_reference_2, r0_.status AS status_3, r0_.offer_type AS offer_type_4, r0_.currency AS currency_5, r0_.sale_price AS sale_price_6, r0_.rent_net AS rent_net_7, r0_.rent_extra AS rent_extra_8, r0_.title_translations AS title_translations_9, r0_.description_translations AS description_translations_10, r0_.available_from AS available_from_11, r0_.hide_price AS hide_price_12, r0_.virtual_visit_url AS virtual_visit_url_13, r0_.video_url AS video_url_14, r0_.lat AS lat_15, r0_.lng AS lng_16, r0_.route AS route_17, r0_.locality_translations AS locality_translations_18, r0_.state_translations AS state_translations_19, r0_.postcode AS postcode_20, r0_.country_code AS country_code_21, r0_.number_of_rooms AS number_of_rooms_22, r0_.number_of_bedrooms AS number_of_bedrooms_23, r0_.number_of_bathrooms AS number_of_bathrooms_24, r0_.number_of_floors AS number_of_floors_25, r0_.floor_of_flat AS floor_of_flat_26, r0_.living_surface AS living_surface_27, r0_.land_surface AS land_surface_28, r0_.garden_surface AS garden_surface_29, r0_.balcony_surface AS balcony_surface_30, r0_.terrace_surface AS terrace_surface_31, r0_.weighted_floor_surface AS weighted_floor_surface_32, r0_.construction_year AS construction_year_33, r0_.renovation_year AS renovation_year_34, r0_.heating AS heating_35, r0_.number_of_indoor_parkings AS number_of_indoor_parkings_36, r0_.number_of_outdoor_parkings AS number_of_outdoor_parkings_37, r0_.has_view AS has_view_38, r0_.has_elevator AS has_elevator_39, r0_.has_gym AS has_gym_40, r0_.has_sauna AS has_sauna_41, r0_.has_fireplace AS has_fireplace_42, r0_.has_swimming_pool AS has_swimming_pool_43, r0_.has_cellar AS has_cellar_44, r0_.is_child_friendly AS is_child_friendly_45, r0_.is_luxury AS is_luxury_46, r0_.is_new_development AS is_new_development_47, r0_.is_wheelchair_accessible AS is_wheelchair_accessible_48, r0_.property_type_name AS property_type_name_49, r0_.property_type_label_translations AS property_type_label_translations_50, r0_.slug_en AS slug_en_51, r0_.slug_fr AS slug_fr_52, r0_.images AS images_53, r0_.api_created_at AS api_created_at_54, r0_.api_updated_at AS api_updated_at_55, r0_.synced_at AS synced_at_56, r0_.development_id AS development_id_57, r0_.broker_id AS broker_id_58 FROM realadvisor_property r0_ WHERE LOWER(r0_.status) <> ? ORDER BY r0_.api_updated_at DESC

[
  "sold"
]

SELECT
  r0_.id AS id_0,
  r0_.api_id AS api_id_1,
  r0_.lot_reference AS lot_reference_2,
  r0_.status AS status_3,
  r0_.offer_type AS offer_type_4,
  r0_.currency AS currency_5,
  r0_.sale_price AS sale_price_6,
  r0_.rent_net AS rent_net_7,
  r0_.rent_extra AS rent_extra_8,
  r0_.title_translations AS title_translations_9,
  r0_.description_translations AS description_translations_10,
  r0_.available_from AS available_from_11,
  r0_.hide_price AS hide_price_12,
  r0_.virtual_visit_url AS virtual_visit_url_13,
  r0_.video_url AS video_url_14,
  r0_.lat AS lat_15,
  r0_.lng AS lng_16,
  r0_.route AS route_17,
  r0_.locality_translations AS locality_translations_18,
  r0_.state_translations AS state_translations_19,
  r0_.postcode AS postcode_20,
  r0_.country_code AS country_code_21,
  r0_.number_of_rooms AS number_of_rooms_22,
  r0_.number_of_bedrooms AS number_of_bedrooms_23,
  r0_.number_of_bathrooms AS number_of_bathrooms_24,
  r0_.number_of_floors AS number_of_floors_25,
  r0_.floor_of_flat AS floor_of_flat_26,
  r0_.living_surface AS living_surface_27,
  r0_.land_surface AS land_surface_28,
  r0_.garden_surface AS garden_surface_29,
  r0_.balcony_surface AS balcony_surface_30,
  r0_.terrace_surface AS terrace_surface_31,
  r0_.weighted_floor_surface AS weighted_floor_surface_32,
  r0_.construction_year AS construction_year_33,
  r0_.renovation_year AS renovation_year_34,
  r0_.heating AS heating_35,
  r0_.number_of_indoor_parkings AS number_of_indoor_parkings_36,
  r0_.number_of_outdoor_parkings AS number_of_outdoor_parkings_37,
  r0_.has_view AS has_view_38,
  r0_.has_elevator AS has_elevator_39,
  r0_.has_gym AS has_gym_40,
  r0_.has_sauna AS has_sauna_41,
  r0_.has_fireplace AS has_fireplace_42,
  r0_.has_swimming_pool AS has_swimming_pool_43,
  r0_.has_cellar AS has_cellar_44,
  r0_.is_child_friendly AS is_child_friendly_45,
  r0_.is_luxury AS is_luxury_46,
  r0_.is_new_development AS is_new_development_47,
  r0_.is_wheelchair_accessible AS is_wheelchair_accessible_48,
  r0_.property_type_name AS property_type_name_49,
  r0_.property_type_label_translations AS property_type_label_translations_50,
  r0_.slug_en AS slug_en_51,
  r0_.slug_fr AS slug_fr_52,
  r0_.images AS images_53,
  r0_.api_created_at AS api_created_at_54,
  r0_.api_updated_at AS api_updated_at_55,
  r0_.synced_at AS synced_at_56,
  r0_.development_id AS development_id_57,
  r0_.broker_id AS broker_id_58
FROM
  realadvisor_property r0_
WHERE
  LOWER(r0_.status) <> ?
ORDER BY
  r0_.api_updated_at DESC

SELECT r0_.id AS id_0, r0_.api_id AS api_id_1, r0_.lot_reference AS lot_reference_2, r0_.status AS status_3, r0_.offer_type AS offer_type_4, r0_.currency AS currency_5, r0_.sale_price AS sale_price_6, r0_.rent_net AS rent_net_7, r0_.rent_extra AS rent_extra_8, r0_.title_translations AS title_translations_9, r0_.description_translations AS description_translations_10, r0_.available_from AS available_from_11, r0_.hide_price AS hide_price_12, r0_.virtual_visit_url AS virtual_visit_url_13, r0_.video_url AS video_url_14, r0_.lat AS lat_15, r0_.lng AS lng_16, r0_.route AS route_17, r0_.locality_translations AS locality_translations_18, r0_.state_translations AS state_translations_19, r0_.postcode AS postcode_20, r0_.country_code AS country_code_21, r0_.number_of_rooms AS number_of_rooms_22, r0_.number_of_bedrooms AS number_of_bedrooms_23, r0_.number_of_bathrooms AS number_of_bathrooms_24, r0_.number_of_floors AS number_of_floors_25, r0_.floor_of_flat AS floor_of_flat_26, r0_.living_surface AS living_surface_27, r0_.land_surface AS land_surface_28, r0_.garden_surface AS garden_surface_29, r0_.balcony_surface AS balcony_surface_30, r0_.terrace_surface AS terrace_surface_31, r0_.weighted_floor_surface AS weighted_floor_surface_32, r0_.construction_year AS construction_year_33, r0_.renovation_year AS renovation_year_34, r0_.heating AS heating_35, r0_.number_of_indoor_parkings AS number_of_indoor_parkings_36, r0_.number_of_outdoor_parkings AS number_of_outdoor_parkings_37, r0_.has_view AS has_view_38, r0_.has_elevator AS has_elevator_39, r0_.has_gym AS has_gym_40, r0_.has_sauna AS has_sauna_41, r0_.has_fireplace AS has_fireplace_42, r0_.has_swimming_pool AS has_swimming_pool_43, r0_.has_cellar AS has_cellar_44, r0_.is_child_friendly AS is_child_friendly_45, r0_.is_luxury AS is_luxury_46, r0_.is_new_development AS is_new_development_47, r0_.is_wheelchair_accessible AS is_wheelchair_accessible_48, r0_.property_type_name AS property_type_name_49, r0_.property_type_label_translations AS property_type_label_translations_50, r0_.slug_en AS slug_en_51, r0_.slug_fr AS slug_fr_52, r0_.images AS images_53, r0_.api_created_at AS api_created_at_54, r0_.api_updated_at AS api_updated_at_55, r0_.synced_at AS synced_at_56, r0_.development_id AS development_id_57, r0_.broker_id AS broker_id_58 FROM realadvisor_property r0_ WHERE LOWER(r0_.status) <> 'sold' ORDER BY r0_.api_updated_at DESC;