GET https://oakswell.ewm.dev/api/properties

Response
200 OK
Browse referrer URL
IP
193.95.3.193
Profiled on
Token
20dc97

Query Metrics

43 Database Queries
2 Different statements
5.71 ms Query time
0 Invalid entities
50 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.44 ms 
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
Parameters: 
[
  "sold"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.19 ms 
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 = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.11 ms 
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 = ?
Parameters: 
[
  42
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.12 ms 
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 = ?
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.10 ms 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.09 ms 
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 = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.08 ms 
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 = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.09 ms 
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 = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.08 ms 
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 = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.09 ms 
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 = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.08 ms 
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 = ?
Parameters: 
[
  30
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.08 ms 
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 = ?
Parameters: 
[
  23
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.09 ms 
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 = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.09 ms 
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 = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.08 ms 
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 = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.08 ms 
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 = ?
Parameters: 
[
  39
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.09 ms 
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 = ?
Parameters: 
[
  26
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.09 ms 
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 = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.10 ms 
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 = ?
Parameters: 
[
  41
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.09 ms 
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 = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.08 ms 
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 = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.08 ms 
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 = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.09 ms 
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 = ?
Parameters: 
[
  40
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.08 ms 
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 = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.08 ms 
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 = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.08 ms 
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 = ?
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.08 ms 
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 = ?
Parameters: 
[
  25
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.08 ms 
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 = ?
Parameters: 
[
  24
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.08 ms 
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 = ?
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.08 ms 
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 = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.08 ms 
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 = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.08 ms 
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 = ?
Parameters: 
[
  33
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.22 ms 
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 = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.11 ms 
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 = ?
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.13 ms 
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 = ?
Parameters: 
[
  27
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.16 ms 
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 = ?
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.17 ms 
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 = ?
Parameters: 
[
  31
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.12 ms 
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 = ?
Parameters: 
[
  32
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.12 ms 
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 = ?
Parameters: 
[
  34
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.12 ms 
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 = ?
Parameters: 
[
  35
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.11 ms 
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 = ?
Parameters: 
[
  36
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.10 ms 
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 = ?
Parameters: 
[
  37
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.10 ms 
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 = ?
Parameters: 
[
  38
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Property 42
App\Entity\Broker 5
App\Entity\Development 3

Entities Mapping

Class Mapping errors
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Bundle\SecurityBundle\Entity\Group No errors.
App\Entity\Property No errors.
App\Entity\Development No errors.
App\Entity\Broker No errors.
App\Entity\Lead No errors.