Symfony Profiler

Query Metrics

15 Database Queries

8 Different statements

66.84 ms Query time

1 Invalid entities

Queries


SELECT t0.id AS id_1, t0.type AS type_2, t0.borough AS borough_3, t0.street AS street_4, t0.street_number AS street_number_5, t0.country AS country_6, t0.created_at AS created_at_7, t0.date_start_at AS date_start_at_8, t0.title AS title_9, t0.status AS status_10, t0.state AS state_11, t0.guarantee_type AS guarantee_type_12, t0.is_active AS is_active_13, t0.number_id AS number_id_14, t0.rent AS rent_15, t0.description AS description_16, t0.lease_term AS lease_term_17, t0.edited_at AS edited_at_18, t0.house_rules AS house_rules_19, t0.interior AS interior_20, t0.exterior AS exterior_21, t0.charges AS charges_22, t0.lease_drafting_fees AS lease_drafting_fees_23, t0.contact_name AS contact_name_24, t0.mail_contact AS mail_contact_25, t0.phone_contact AS phone_contact_26, t0.security_deposit AS security_deposit_27, t0.expenses AS expenses_28, t0.expenses_description AS expenses_description_29, t0.surface AS surface_30, t0.surface_bedroom AS surface_bedroom_31, t0.is_furniture AS is_furniture_32, t0.is_aid_eligible AS is_aid_eligible_33, t0.format AS format_34, t0.postal_code AS postal_code_35, t0.is_blocked AS is_blocked_36, t0.is_floor AS is_floor_37, t0.floor AS floor_38, t0.pdl AS pdl_39, t0.wifi AS wifi_40, t0.dep AS dep_41, t0.ges AS ges_42, t0.max_folders AS max_folders_43, t0.unique_id AS unique_id_44, t0.min_income AS min_income_45, t0.is_end AS is_end_46, t0.lat AS lat_47, t0.lng AS lng_48, t0.is_authorize_atestation AS is_authorize_atestation_49, t0.last_atestation AS last_atestation_50, t0.has_guarantor AS has_guarantor_51, t0.time_bail AS time_bail_52, t0.type_bed AS type_bed_53, t0.private_bathroom AS private_bathroom_54, t0.bathrooms AS bathrooms_55, t0.complex_property AS complex_property_56, t0.complex_property_id AS complex_property_id_57, t0.cover AS cover_58, t0.has_reservation AS has_reservation_59, t0.hide_address AS hide_address_60, t0.bedroom_number AS bedroom_number_61, t0.discount_price AS discount_price_62, t0.date_end_promo AS date_end_promo_63, t0.property_manager_id AS property_manager_id_64, t0.tenant_id AS tenant_id_65, t0.city_entity_id AS city_entity_id_66, t0.residence_id AS residence_id_67 FROM building t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.building_id AS building_id_4 FROM liked_building t0 WHERE t0.user_id IS NULL AND t0.building_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.complex_property_id = ?
SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.borough AS borough_2, b0_.street AS street_3, b0_.street_number AS street_number_4, b0_.country AS country_5, b0_.created_at AS created_at_6, b0_.date_start_at AS date_start_at_7, b0_.title AS title_8, b0_.status AS status_9, b0_.state AS state_10, b0_.guarantee_type AS guarantee_type_11, b0_.is_active AS is_active_12, b0_.number_id AS number_id_13, b0_.rent AS rent_14, b0_.description AS description_15, b0_.lease_term AS lease_term_16, b0_.edited_at AS edited_at_17, b0_.house_rules AS house_rules_18, b0_.interior AS interior_19, b0_.exterior AS exterior_20, b0_.charges AS charges_21, b0_.lease_drafting_fees AS lease_drafting_fees_22, b0_.contact_name AS contact_name_23, b0_.mail_contact AS mail_contact_24, b0_.phone_contact AS phone_contact_25, b0_.security_deposit AS security_deposit_26, b0_.expenses AS expenses_27, b0_.expenses_description AS expenses_description_28, b0_.surface AS surface_29, b0_.surface_bedroom AS surface_bedroom_30, b0_.is_furniture AS is_furniture_31, b0_.is_aid_eligible AS is_aid_eligible_32, b0_.format AS format_33, b0_.postal_code AS postal_code_34, b0_.is_blocked AS is_blocked_35, b0_.is_floor AS is_floor_36, b0_.floor AS floor_37, b0_.pdl AS pdl_38, b0_.wifi AS wifi_39, b0_.dep AS dep_40, b0_.ges AS ges_41, b0_.max_folders AS max_folders_42, b0_.unique_id AS unique_id_43, b0_.min_income AS min_income_44, b0_.is_end AS is_end_45, b0_.lat AS lat_46, b0_.lng AS lng_47, b0_.is_authorize_atestation AS is_authorize_atestation_48, b0_.last_atestation AS last_atestation_49, b0_.has_guarantor AS has_guarantor_50, b0_.time_bail AS time_bail_51, b0_.type_bed AS type_bed_52, b0_.private_bathroom AS private_bathroom_53, b0_.bathrooms AS bathrooms_54, b0_.complex_property AS complex_property_55, b0_.complex_property_id AS complex_property_id_56, b0_.cover AS cover_57, b0_.has_reservation AS has_reservation_58, b0_.hide_address AS hide_address_59, b0_.bedroom_number AS bedroom_number_60, b0_.discount_price AS discount_price_61, b0_.date_end_promo AS date_end_promo_62, b0_.property_manager_id AS property_manager_id_63, b0_.tenant_id AS tenant_id_64, b0_.city_entity_id AS city_entity_id_65, b0_.residence_id AS residence_id_66 FROM building b0_ WHERE b0_.complex_property_id = ? ORDER BY b0_.created_at DESC
SELECT t0.id AS id_1, t0.country AS country_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.district AS district_5, t0.alert_count AS alert_count_6, t0.is_inside_homepage AS is_inside_homepage_7 FROM city t0 WHERE t0.id = ?
SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.borough AS borough_2, b0_.street AS street_3, b0_.street_number AS street_number_4, b0_.country AS country_5, b0_.created_at AS created_at_6, b0_.date_start_at AS date_start_at_7, b0_.title AS title_8, b0_.status AS status_9, b0_.state AS state_10, b0_.guarantee_type AS guarantee_type_11, b0_.is_active AS is_active_12, b0_.number_id AS number_id_13, b0_.rent AS rent_14, b0_.description AS description_15, b0_.lease_term AS lease_term_16, b0_.edited_at AS edited_at_17, b0_.house_rules AS house_rules_18, b0_.interior AS interior_19, b0_.exterior AS exterior_20, b0_.charges AS charges_21, b0_.lease_drafting_fees AS lease_drafting_fees_22, b0_.contact_name AS contact_name_23, b0_.mail_contact AS mail_contact_24, b0_.phone_contact AS phone_contact_25, b0_.security_deposit AS security_deposit_26, b0_.expenses AS expenses_27, b0_.expenses_description AS expenses_description_28, b0_.surface AS surface_29, b0_.surface_bedroom AS surface_bedroom_30, b0_.is_furniture AS is_furniture_31, b0_.is_aid_eligible AS is_aid_eligible_32, b0_.format AS format_33, b0_.postal_code AS postal_code_34, b0_.is_blocked AS is_blocked_35, b0_.is_floor AS is_floor_36, b0_.floor AS floor_37, b0_.pdl AS pdl_38, b0_.wifi AS wifi_39, b0_.dep AS dep_40, b0_.ges AS ges_41, b0_.max_folders AS max_folders_42, b0_.unique_id AS unique_id_43, b0_.min_income AS min_income_44, b0_.is_end AS is_end_45, b0_.lat AS lat_46, b0_.lng AS lng_47, b0_.is_authorize_atestation AS is_authorize_atestation_48, b0_.last_atestation AS last_atestation_49, b0_.has_guarantor AS has_guarantor_50, b0_.time_bail AS time_bail_51, b0_.type_bed AS type_bed_52, b0_.private_bathroom AS private_bathroom_53, b0_.bathrooms AS bathrooms_54, b0_.complex_property AS complex_property_55, b0_.complex_property_id AS complex_property_id_56, b0_.cover AS cover_57, b0_.has_reservation AS has_reservation_58, b0_.hide_address AS hide_address_59, b0_.bedroom_number AS bedroom_number_60, b0_.discount_price AS discount_price_61, b0_.date_end_promo AS date_end_promo_62, b0_.property_manager_id AS property_manager_id_63, b0_.tenant_id AS tenant_id_64, b0_.city_entity_id AS city_entity_id_65, b0_.residence_id AS residence_id_66 FROM building b0_ INNER JOIN city c1_ ON b0_.city_entity_id = c1_.id WHERE c1_.city = ? AND (b0_.surface BETWEEN ? AND ?) AND (b0_.rent BETWEEN ? AND ?) AND b0_.complex_property_id <> ? AND b0_.id <> ? ORDER BY b0_.created_at DESC LIMIT 3
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ?
SELECT t0.id AS id_1, t0.country AS country_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.district AS district_5, t0.alert_count AS alert_count_6, t0.is_inside_homepage AS is_inside_homepage_7 FROM city t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.phone AS phone_6, t0.is_active AS is_active_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.country AS country_10, t0.city AS city_11, t0.lessor_type AS lessor_type_12, t0.registration_finalized AS registration_finalized_13, t0.nationality AS nationality_14, t0.agent_type AS agent_type_15, t0.representative_name AS representative_name_16, t0.sign_at AS sign_at_17, t0.edited_at AS edited_at_18, t0.customer_type AS customer_type_19, t0.head_office AS head_office_20, t0.number_tva AS number_tva_21, t0.company_type AS company_type_22, t0.street AS street_23, t0.street_number AS street_number_24, t0.adress2 AS adress2_25, t0.adress1 AS adress1_26, t0.last_postal_code AS last_postal_code_27, t0.last_city AS last_city_28, t0.last_country AS last_country_29, t0.visa_type AS visa_type_30, t0.postal_code AS postal_code_31, t0.birth_date AS birth_date_32, t0.civility AS civility_33, t0.name_legal AS name_legal_34, t0.first_name_legal AS first_name_legal_35, t0.phone_legal AS phone_legal_36, t0.email_legal AS email_legal_37, t0.activity AS activity_38, t0.first_lease AS first_lease_39, t0.commercial_mail AS commercial_mail_40, t0.pack_attestation AS pack_attestation_41, t0.agent_ender_control AS agent_ender_control_42, t0.consulat_country AS consulat_country_43, t0.step_profil AS step_profil_44, t0.date_start_at AS date_start_at_45, t0.rental_duration AS rental_duration_46, t0.status AS status_47, t0.formation_name AS formation_name_48, t0.school_name AS school_name_49, t0.school_address AS school_address_50, t0.study_level AS study_level_51, t0.company AS company_52, t0.employement_contract AS employement_contract_53, t0.trial_period AS trial_period_54, t0.net_monthly_salary AS net_monthly_salary_55, t0.guarantor_type AS guarantor_type_56, t0.physical_guarantor_type AS physical_guarantor_type_57, t0.statut_residence_principale AS statut_residence_principale_58, t0.mensual_rent AS mensual_rent_59, t0.contract_type AS contract_type_60, t0.finished_trial_period AS finished_trial_period_61, t0.income AS income_62, t0.additional_income_sources AS additional_income_sources_63, t0.additional_income_sources_student AS additional_income_sources_student_64, t0.guarantor_status AS guarantor_status_65, t0.professional_guarantee AS professional_guarantee_66, t0.physical_guarantor_nationality AS physical_guarantor_nationality_67, t0.application_message AS application_message_68, t0.local_agreement_number AS local_agreement_number_69, t0.company_address AS company_address_70, t0.representative_title AS representative_title_71, t0.representative_first_name AS representative_first_name_72, t0.send_sms AS send_sms_73, t0.managed_by_id AS managed_by_id_74, t0.team_with_id AS team_with_id_75 FROM `user` t0 WHERE t0.id = ?

#▲	Time	Info
1	1.15 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.borough AS borough_3, t0.street AS street_4, t0.street_number AS street_number_5, t0.country AS country_6, t0.created_at AS created_at_7, t0.date_start_at AS date_start_at_8, t0.title AS title_9, t0.status AS status_10, t0.state AS state_11, t0.guarantee_type AS guarantee_type_12, t0.is_active AS is_active_13, t0.number_id AS number_id_14, t0.rent AS rent_15, t0.description AS description_16, t0.lease_term AS lease_term_17, t0.edited_at AS edited_at_18, t0.house_rules AS house_rules_19, t0.interior AS interior_20, t0.exterior AS exterior_21, t0.charges AS charges_22, t0.lease_drafting_fees AS lease_drafting_fees_23, t0.contact_name AS contact_name_24, t0.mail_contact AS mail_contact_25, t0.phone_contact AS phone_contact_26, t0.security_deposit AS security_deposit_27, t0.expenses AS expenses_28, t0.expenses_description AS expenses_description_29, t0.surface AS surface_30, t0.surface_bedroom AS surface_bedroom_31, t0.is_furniture AS is_furniture_32, t0.is_aid_eligible AS is_aid_eligible_33, t0.format AS format_34, t0.postal_code AS postal_code_35, t0.is_blocked AS is_blocked_36, t0.is_floor AS is_floor_37, t0.floor AS floor_38, t0.pdl AS pdl_39, t0.wifi AS wifi_40, t0.dep AS dep_41, t0.ges AS ges_42, t0.max_folders AS max_folders_43, t0.unique_id AS unique_id_44, t0.min_income AS min_income_45, t0.is_end AS is_end_46, t0.lat AS lat_47, t0.lng AS lng_48, t0.is_authorize_atestation AS is_authorize_atestation_49, t0.last_atestation AS last_atestation_50, t0.has_guarantor AS has_guarantor_51, t0.time_bail AS time_bail_52, t0.type_bed AS type_bed_53, t0.private_bathroom AS private_bathroom_54, t0.bathrooms AS bathrooms_55, t0.complex_property AS complex_property_56, t0.complex_property_id AS complex_property_id_57, t0.cover AS cover_58, t0.has_reservation AS has_reservation_59, t0.hide_address AS hide_address_60, t0.bedroom_number AS bedroom_number_61, t0.discount_price AS discount_price_62, t0.date_end_promo AS date_end_promo_63, t0.property_manager_id AS property_manager_id_64, t0.tenant_id AS tenant_id_65, t0.city_entity_id AS city_entity_id_66, t0.residence_id AS residence_id_67 FROM building t0 WHERE t0.id = ? Parameters: [`"37385"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.borough AS borough_3, t0.street AS street_4, t0.street_number AS street_number_5, t0.country AS country_6, t0.created_at AS created_at_7, t0.date_start_at AS date_start_at_8, t0.title AS title_9, t0.status AS status_10, t0.state AS state_11, t0.guarantee_type AS guarantee_type_12, t0.is_active AS is_active_13, t0.number_id AS number_id_14, t0.rent AS rent_15, t0.description AS description_16, t0.lease_term AS lease_term_17, t0.edited_at AS edited_at_18, t0.house_rules AS house_rules_19, t0.interior AS interior_20, t0.exterior AS exterior_21, t0.charges AS charges_22, t0.lease_drafting_fees AS lease_drafting_fees_23, t0.contact_name AS contact_name_24, t0.mail_contact AS mail_contact_25, t0.phone_contact AS phone_contact_26, t0.security_deposit AS security_deposit_27, t0.expenses AS expenses_28, t0.expenses_description AS expenses_description_29, t0.surface AS surface_30, t0.surface_bedroom AS surface_bedroom_31, t0.is_furniture AS is_furniture_32, t0.is_aid_eligible AS is_aid_eligible_33, t0.format AS format_34, t0.postal_code AS postal_code_35, t0.is_blocked AS is_blocked_36, t0.is_floor AS is_floor_37, t0.floor AS floor_38, t0.pdl AS pdl_39, t0.wifi AS wifi_40, t0.dep AS dep_41, t0.ges AS ges_42, t0.max_folders AS max_folders_43, t0.unique_id AS unique_id_44, t0.min_income AS min_income_45, t0.is_end AS is_end_46, t0.lat AS lat_47, t0.lng AS lng_48, t0.is_authorize_atestation AS is_authorize_atestation_49, t0.last_atestation AS last_atestation_50, t0.has_guarantor AS has_guarantor_51, t0.time_bail AS time_bail_52, t0.type_bed AS type_bed_53, t0.private_bathroom AS private_bathroom_54, t0.bathrooms AS bathrooms_55, t0.complex_property AS complex_property_56, t0.complex_property_id AS complex_property_id_57, t0.cover AS cover_58, t0.has_reservation AS has_reservation_59, t0.hide_address AS hide_address_60, t0.bedroom_number AS bedroom_number_61, t0.discount_price AS discount_price_62, t0.date_end_promo AS date_end_promo_63, t0.property_manager_id AS property_manager_id_64, t0.tenant_id AS tenant_id_65, t0.city_entity_id AS city_entity_id_66, t0.residence_id AS residence_id_67 FROM building t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.type AS type_2, t0.borough AS borough_3, t0.street AS street_4, t0.street_number AS street_number_5, t0.country AS country_6, t0.created_at AS created_at_7, t0.date_start_at AS date_start_at_8, t0.title AS title_9, t0.status AS status_10, t0.state AS state_11, t0.guarantee_type AS guarantee_type_12, t0.is_active AS is_active_13, t0.number_id AS number_id_14, t0.rent AS rent_15, t0.description AS description_16, t0.lease_term AS lease_term_17, t0.edited_at AS edited_at_18, t0.house_rules AS house_rules_19, t0.interior AS interior_20, t0.exterior AS exterior_21, t0.charges AS charges_22, t0.lease_drafting_fees AS lease_drafting_fees_23, t0.contact_name AS contact_name_24, t0.mail_contact AS mail_contact_25, t0.phone_contact AS phone_contact_26, t0.security_deposit AS security_deposit_27, t0.expenses AS expenses_28, t0.expenses_description AS expenses_description_29, t0.surface AS surface_30, t0.surface_bedroom AS surface_bedroom_31, t0.is_furniture AS is_furniture_32, t0.is_aid_eligible AS is_aid_eligible_33, t0.format AS format_34, t0.postal_code AS postal_code_35, t0.is_blocked AS is_blocked_36, t0.is_floor AS is_floor_37, t0.floor AS floor_38, t0.pdl AS pdl_39, t0.wifi AS wifi_40, t0.dep AS dep_41, t0.ges AS ges_42, t0.max_folders AS max_folders_43, t0.unique_id AS unique_id_44, t0.min_income AS min_income_45, t0.is_end AS is_end_46, t0.lat AS lat_47, t0.lng AS lng_48, t0.is_authorize_atestation AS is_authorize_atestation_49, t0.last_atestation AS last_atestation_50, t0.has_guarantor AS has_guarantor_51, t0.time_bail AS time_bail_52, t0.type_bed AS type_bed_53, t0.private_bathroom AS private_bathroom_54, t0.bathrooms AS bathrooms_55, t0.complex_property AS complex_property_56, t0.complex_property_id AS complex_property_id_57, t0.cover AS cover_58, t0.has_reservation AS has_reservation_59, t0.hide_address AS hide_address_60, t0.bedroom_number AS bedroom_number_61, t0.discount_price AS discount_price_62, t0.date_end_promo AS date_end_promo_63, t0.property_manager_id AS property_manager_id_64, t0.tenant_id AS tenant_id_65, t0.city_entity_id AS city_entity_id_66, t0.residence_id AS residence_id_67 FROM building t0 WHERE t0.id = '37385';
2	0.74 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.building_id AS building_id_4 FROM liked_building t0 WHERE t0.user_id IS NULL AND t0.building_id = ? LIMIT 1 Parameters: [`37385`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.building_id AS building_id_4 FROM liked_building t0 WHERE t0.user_id IS NULL AND t0.building_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.building_id AS building_id_4 FROM liked_building t0 WHERE t0.user_id IS NULL AND t0.building_id = 37385 LIMIT 1;
3	24.18 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.complex_property_id = ? Parameters: [`2127649517`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.complex_property_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.complex_property_id = 2127649517;
4	20.55 ms	SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.borough AS borough_2, b0_.street AS street_3, b0_.street_number AS street_number_4, b0_.country AS country_5, b0_.created_at AS created_at_6, b0_.date_start_at AS date_start_at_7, b0_.title AS title_8, b0_.status AS status_9, b0_.state AS state_10, b0_.guarantee_type AS guarantee_type_11, b0_.is_active AS is_active_12, b0_.number_id AS number_id_13, b0_.rent AS rent_14, b0_.description AS description_15, b0_.lease_term AS lease_term_16, b0_.edited_at AS edited_at_17, b0_.house_rules AS house_rules_18, b0_.interior AS interior_19, b0_.exterior AS exterior_20, b0_.charges AS charges_21, b0_.lease_drafting_fees AS lease_drafting_fees_22, b0_.contact_name AS contact_name_23, b0_.mail_contact AS mail_contact_24, b0_.phone_contact AS phone_contact_25, b0_.security_deposit AS security_deposit_26, b0_.expenses AS expenses_27, b0_.expenses_description AS expenses_description_28, b0_.surface AS surface_29, b0_.surface_bedroom AS surface_bedroom_30, b0_.is_furniture AS is_furniture_31, b0_.is_aid_eligible AS is_aid_eligible_32, b0_.format AS format_33, b0_.postal_code AS postal_code_34, b0_.is_blocked AS is_blocked_35, b0_.is_floor AS is_floor_36, b0_.floor AS floor_37, b0_.pdl AS pdl_38, b0_.wifi AS wifi_39, b0_.dep AS dep_40, b0_.ges AS ges_41, b0_.max_folders AS max_folders_42, b0_.unique_id AS unique_id_43, b0_.min_income AS min_income_44, b0_.is_end AS is_end_45, b0_.lat AS lat_46, b0_.lng AS lng_47, b0_.is_authorize_atestation AS is_authorize_atestation_48, b0_.last_atestation AS last_atestation_49, b0_.has_guarantor AS has_guarantor_50, b0_.time_bail AS time_bail_51, b0_.type_bed AS type_bed_52, b0_.private_bathroom AS private_bathroom_53, b0_.bathrooms AS bathrooms_54, b0_.complex_property AS complex_property_55, b0_.complex_property_id AS complex_property_id_56, b0_.cover AS cover_57, b0_.has_reservation AS has_reservation_58, b0_.hide_address AS hide_address_59, b0_.bedroom_number AS bedroom_number_60, b0_.discount_price AS discount_price_61, b0_.date_end_promo AS date_end_promo_62, b0_.property_manager_id AS property_manager_id_63, b0_.tenant_id AS tenant_id_64, b0_.city_entity_id AS city_entity_id_65, b0_.residence_id AS residence_id_66 FROM building b0_ WHERE b0_.complex_property_id = ? ORDER BY b0_.created_at DESC Parameters: [`2127649517`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.borough AS borough_2, b0_.street AS street_3, b0_.street_number AS street_number_4, b0_.country AS country_5, b0_.created_at AS created_at_6, b0_.date_start_at AS date_start_at_7, b0_.title AS title_8, b0_.status AS status_9, b0_.state AS state_10, b0_.guarantee_type AS guarantee_type_11, b0_.is_active AS is_active_12, b0_.number_id AS number_id_13, b0_.rent AS rent_14, b0_.description AS description_15, b0_.lease_term AS lease_term_16, b0_.edited_at AS edited_at_17, b0_.house_rules AS house_rules_18, b0_.interior AS interior_19, b0_.exterior AS exterior_20, b0_.charges AS charges_21, b0_.lease_drafting_fees AS lease_drafting_fees_22, b0_.contact_name AS contact_name_23, b0_.mail_contact AS mail_contact_24, b0_.phone_contact AS phone_contact_25, b0_.security_deposit AS security_deposit_26, b0_.expenses AS expenses_27, b0_.expenses_description AS expenses_description_28, b0_.surface AS surface_29, b0_.surface_bedroom AS surface_bedroom_30, b0_.is_furniture AS is_furniture_31, b0_.is_aid_eligible AS is_aid_eligible_32, b0_.format AS format_33, b0_.postal_code AS postal_code_34, b0_.is_blocked AS is_blocked_35, b0_.is_floor AS is_floor_36, b0_.floor AS floor_37, b0_.pdl AS pdl_38, b0_.wifi AS wifi_39, b0_.dep AS dep_40, b0_.ges AS ges_41, b0_.max_folders AS max_folders_42, b0_.unique_id AS unique_id_43, b0_.min_income AS min_income_44, b0_.is_end AS is_end_45, b0_.lat AS lat_46, b0_.lng AS lng_47, b0_.is_authorize_atestation AS is_authorize_atestation_48, b0_.last_atestation AS last_atestation_49, b0_.has_guarantor AS has_guarantor_50, b0_.time_bail AS time_bail_51, b0_.type_bed AS type_bed_52, b0_.private_bathroom AS private_bathroom_53, b0_.bathrooms AS bathrooms_54, b0_.complex_property AS complex_property_55, b0_.complex_property_id AS complex_property_id_56, b0_.cover AS cover_57, b0_.has_reservation AS has_reservation_58, b0_.hide_address AS hide_address_59, b0_.bedroom_number AS bedroom_number_60, b0_.discount_price AS discount_price_61, b0_.date_end_promo AS date_end_promo_62, b0_.property_manager_id AS property_manager_id_63, b0_.tenant_id AS tenant_id_64, b0_.city_entity_id AS city_entity_id_65, b0_.residence_id AS residence_id_66 FROM building b0_ WHERE b0_.complex_property_id = ? ORDER BY b0_.created_at DESC SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.borough AS borough_2, b0_.street AS street_3, b0_.street_number AS street_number_4, b0_.country AS country_5, b0_.created_at AS created_at_6, b0_.date_start_at AS date_start_at_7, b0_.title AS title_8, b0_.status AS status_9, b0_.state AS state_10, b0_.guarantee_type AS guarantee_type_11, b0_.is_active AS is_active_12, b0_.number_id AS number_id_13, b0_.rent AS rent_14, b0_.description AS description_15, b0_.lease_term AS lease_term_16, b0_.edited_at AS edited_at_17, b0_.house_rules AS house_rules_18, b0_.interior AS interior_19, b0_.exterior AS exterior_20, b0_.charges AS charges_21, b0_.lease_drafting_fees AS lease_drafting_fees_22, b0_.contact_name AS contact_name_23, b0_.mail_contact AS mail_contact_24, b0_.phone_contact AS phone_contact_25, b0_.security_deposit AS security_deposit_26, b0_.expenses AS expenses_27, b0_.expenses_description AS expenses_description_28, b0_.surface AS surface_29, b0_.surface_bedroom AS surface_bedroom_30, b0_.is_furniture AS is_furniture_31, b0_.is_aid_eligible AS is_aid_eligible_32, b0_.format AS format_33, b0_.postal_code AS postal_code_34, b0_.is_blocked AS is_blocked_35, b0_.is_floor AS is_floor_36, b0_.floor AS floor_37, b0_.pdl AS pdl_38, b0_.wifi AS wifi_39, b0_.dep AS dep_40, b0_.ges AS ges_41, b0_.max_folders AS max_folders_42, b0_.unique_id AS unique_id_43, b0_.min_income AS min_income_44, b0_.is_end AS is_end_45, b0_.lat AS lat_46, b0_.lng AS lng_47, b0_.is_authorize_atestation AS is_authorize_atestation_48, b0_.last_atestation AS last_atestation_49, b0_.has_guarantor AS has_guarantor_50, b0_.time_bail AS time_bail_51, b0_.type_bed AS type_bed_52, b0_.private_bathroom AS private_bathroom_53, b0_.bathrooms AS bathrooms_54, b0_.complex_property AS complex_property_55, b0_.complex_property_id AS complex_property_id_56, b0_.cover AS cover_57, b0_.has_reservation AS has_reservation_58, b0_.hide_address AS hide_address_59, b0_.bedroom_number AS bedroom_number_60, b0_.discount_price AS discount_price_61, b0_.date_end_promo AS date_end_promo_62, b0_.property_manager_id AS property_manager_id_63, b0_.tenant_id AS tenant_id_64, b0_.city_entity_id AS city_entity_id_65, b0_.residence_id AS residence_id_66 FROM building b0_ WHERE b0_.complex_property_id = 2127649517 ORDER BY b0_.created_at DESC;
5	0.43 ms	SELECT t0.id AS id_1, t0.country AS country_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.district AS district_5, t0.alert_count AS alert_count_6, t0.is_inside_homepage AS is_inside_homepage_7 FROM city t0 WHERE t0.id = ? Parameters: [`28279`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.country AS country_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.district AS district_5, t0.alert_count AS alert_count_6, t0.is_inside_homepage AS is_inside_homepage_7 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.country AS country_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.district AS district_5, t0.alert_count AS alert_count_6, t0.is_inside_homepage AS is_inside_homepage_7 FROM city t0 WHERE t0.id = 28279;
6	14.89 ms	SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.borough AS borough_2, b0_.street AS street_3, b0_.street_number AS street_number_4, b0_.country AS country_5, b0_.created_at AS created_at_6, b0_.date_start_at AS date_start_at_7, b0_.title AS title_8, b0_.status AS status_9, b0_.state AS state_10, b0_.guarantee_type AS guarantee_type_11, b0_.is_active AS is_active_12, b0_.number_id AS number_id_13, b0_.rent AS rent_14, b0_.description AS description_15, b0_.lease_term AS lease_term_16, b0_.edited_at AS edited_at_17, b0_.house_rules AS house_rules_18, b0_.interior AS interior_19, b0_.exterior AS exterior_20, b0_.charges AS charges_21, b0_.lease_drafting_fees AS lease_drafting_fees_22, b0_.contact_name AS contact_name_23, b0_.mail_contact AS mail_contact_24, b0_.phone_contact AS phone_contact_25, b0_.security_deposit AS security_deposit_26, b0_.expenses AS expenses_27, b0_.expenses_description AS expenses_description_28, b0_.surface AS surface_29, b0_.surface_bedroom AS surface_bedroom_30, b0_.is_furniture AS is_furniture_31, b0_.is_aid_eligible AS is_aid_eligible_32, b0_.format AS format_33, b0_.postal_code AS postal_code_34, b0_.is_blocked AS is_blocked_35, b0_.is_floor AS is_floor_36, b0_.floor AS floor_37, b0_.pdl AS pdl_38, b0_.wifi AS wifi_39, b0_.dep AS dep_40, b0_.ges AS ges_41, b0_.max_folders AS max_folders_42, b0_.unique_id AS unique_id_43, b0_.min_income AS min_income_44, b0_.is_end AS is_end_45, b0_.lat AS lat_46, b0_.lng AS lng_47, b0_.is_authorize_atestation AS is_authorize_atestation_48, b0_.last_atestation AS last_atestation_49, b0_.has_guarantor AS has_guarantor_50, b0_.time_bail AS time_bail_51, b0_.type_bed AS type_bed_52, b0_.private_bathroom AS private_bathroom_53, b0_.bathrooms AS bathrooms_54, b0_.complex_property AS complex_property_55, b0_.complex_property_id AS complex_property_id_56, b0_.cover AS cover_57, b0_.has_reservation AS has_reservation_58, b0_.hide_address AS hide_address_59, b0_.bedroom_number AS bedroom_number_60, b0_.discount_price AS discount_price_61, b0_.date_end_promo AS date_end_promo_62, b0_.property_manager_id AS property_manager_id_63, b0_.tenant_id AS tenant_id_64, b0_.city_entity_id AS city_entity_id_65, b0_.residence_id AS residence_id_66 FROM building b0_ INNER JOIN city c1_ ON b0_.city_entity_id = c1_.id WHERE c1_.city = ? AND (b0_.surface BETWEEN ? AND ?) AND (b0_.rent BETWEEN ? AND ?) AND b0_.complex_property_id <> ? AND b0_.id <> ? ORDER BY b0_.created_at DESC LIMIT 3 Parameters: [`"LYON" 75.0 225.0 45000.0 135000.0 2127649517 37385`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.borough AS borough_2, b0_.street AS street_3, b0_.street_number AS street_number_4, b0_.country AS country_5, b0_.created_at AS created_at_6, b0_.date_start_at AS date_start_at_7, b0_.title AS title_8, b0_.status AS status_9, b0_.state AS state_10, b0_.guarantee_type AS guarantee_type_11, b0_.is_active AS is_active_12, b0_.number_id AS number_id_13, b0_.rent AS rent_14, b0_.description AS description_15, b0_.lease_term AS lease_term_16, b0_.edited_at AS edited_at_17, b0_.house_rules AS house_rules_18, b0_.interior AS interior_19, b0_.exterior AS exterior_20, b0_.charges AS charges_21, b0_.lease_drafting_fees AS lease_drafting_fees_22, b0_.contact_name AS contact_name_23, b0_.mail_contact AS mail_contact_24, b0_.phone_contact AS phone_contact_25, b0_.security_deposit AS security_deposit_26, b0_.expenses AS expenses_27, b0_.expenses_description AS expenses_description_28, b0_.surface AS surface_29, b0_.surface_bedroom AS surface_bedroom_30, b0_.is_furniture AS is_furniture_31, b0_.is_aid_eligible AS is_aid_eligible_32, b0_.format AS format_33, b0_.postal_code AS postal_code_34, b0_.is_blocked AS is_blocked_35, b0_.is_floor AS is_floor_36, b0_.floor AS floor_37, b0_.pdl AS pdl_38, b0_.wifi AS wifi_39, b0_.dep AS dep_40, b0_.ges AS ges_41, b0_.max_folders AS max_folders_42, b0_.unique_id AS unique_id_43, b0_.min_income AS min_income_44, b0_.is_end AS is_end_45, b0_.lat AS lat_46, b0_.lng AS lng_47, b0_.is_authorize_atestation AS is_authorize_atestation_48, b0_.last_atestation AS last_atestation_49, b0_.has_guarantor AS has_guarantor_50, b0_.time_bail AS time_bail_51, b0_.type_bed AS type_bed_52, b0_.private_bathroom AS private_bathroom_53, b0_.bathrooms AS bathrooms_54, b0_.complex_property AS complex_property_55, b0_.complex_property_id AS complex_property_id_56, b0_.cover AS cover_57, b0_.has_reservation AS has_reservation_58, b0_.hide_address AS hide_address_59, b0_.bedroom_number AS bedroom_number_60, b0_.discount_price AS discount_price_61, b0_.date_end_promo AS date_end_promo_62, b0_.property_manager_id AS property_manager_id_63, b0_.tenant_id AS tenant_id_64, b0_.city_entity_id AS city_entity_id_65, b0_.residence_id AS residence_id_66 FROM building b0_ INNER JOIN city c1_ ON b0_.city_entity_id = c1_.id WHERE c1_.city = ? AND ( b0_.surface BETWEEN ? AND ? ) AND ( b0_.rent BETWEEN ? AND ? ) AND b0_.complex_property_id <> ? AND b0_.id <> ? ORDER BY b0_.created_at DESC LIMIT 3 SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.borough AS borough_2, b0_.street AS street_3, b0_.street_number AS street_number_4, b0_.country AS country_5, b0_.created_at AS created_at_6, b0_.date_start_at AS date_start_at_7, b0_.title AS title_8, b0_.status AS status_9, b0_.state AS state_10, b0_.guarantee_type AS guarantee_type_11, b0_.is_active AS is_active_12, b0_.number_id AS number_id_13, b0_.rent AS rent_14, b0_.description AS description_15, b0_.lease_term AS lease_term_16, b0_.edited_at AS edited_at_17, b0_.house_rules AS house_rules_18, b0_.interior AS interior_19, b0_.exterior AS exterior_20, b0_.charges AS charges_21, b0_.lease_drafting_fees AS lease_drafting_fees_22, b0_.contact_name AS contact_name_23, b0_.mail_contact AS mail_contact_24, b0_.phone_contact AS phone_contact_25, b0_.security_deposit AS security_deposit_26, b0_.expenses AS expenses_27, b0_.expenses_description AS expenses_description_28, b0_.surface AS surface_29, b0_.surface_bedroom AS surface_bedroom_30, b0_.is_furniture AS is_furniture_31, b0_.is_aid_eligible AS is_aid_eligible_32, b0_.format AS format_33, b0_.postal_code AS postal_code_34, b0_.is_blocked AS is_blocked_35, b0_.is_floor AS is_floor_36, b0_.floor AS floor_37, b0_.pdl AS pdl_38, b0_.wifi AS wifi_39, b0_.dep AS dep_40, b0_.ges AS ges_41, b0_.max_folders AS max_folders_42, b0_.unique_id AS unique_id_43, b0_.min_income AS min_income_44, b0_.is_end AS is_end_45, b0_.lat AS lat_46, b0_.lng AS lng_47, b0_.is_authorize_atestation AS is_authorize_atestation_48, b0_.last_atestation AS last_atestation_49, b0_.has_guarantor AS has_guarantor_50, b0_.time_bail AS time_bail_51, b0_.type_bed AS type_bed_52, b0_.private_bathroom AS private_bathroom_53, b0_.bathrooms AS bathrooms_54, b0_.complex_property AS complex_property_55, b0_.complex_property_id AS complex_property_id_56, b0_.cover AS cover_57, b0_.has_reservation AS has_reservation_58, b0_.hide_address AS hide_address_59, b0_.bedroom_number AS bedroom_number_60, b0_.discount_price AS discount_price_61, b0_.date_end_promo AS date_end_promo_62, b0_.property_manager_id AS property_manager_id_63, b0_.tenant_id AS tenant_id_64, b0_.city_entity_id AS city_entity_id_65, b0_.residence_id AS residence_id_66 FROM building b0_ INNER JOIN city c1_ ON b0_.city_entity_id = c1_.id WHERE c1_.city = 'LYON' AND (b0_.surface BETWEEN 75 AND 225) AND (b0_.rent BETWEEN 45000 AND 135000) AND b0_.complex_property_id <> 2127649517 AND b0_.id <> 37385 ORDER BY b0_.created_at DESC LIMIT 3;
7	0.73 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? Parameters: [`37385`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = 37385;
8	0.59 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? Parameters: [`29649`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = 29649;
9	0.52 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? Parameters: [`26229`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = 26229;
10	0.53 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? Parameters: [`21697`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = 21697;
11	0.87 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? Parameters: [`37384`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = 37384;
12	0.52 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? Parameters: [`37383`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = 37383;
13	0.23 ms	SELECT t0.id AS id_1, t0.country AS country_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.district AS district_5, t0.alert_count AS alert_count_6, t0.is_inside_homepage AS is_inside_homepage_7 FROM city t0 WHERE t0.id = ? Parameters: [`31`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.country AS country_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.district AS district_5, t0.alert_count AS alert_count_6, t0.is_inside_homepage AS is_inside_homepage_7 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.country AS country_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.district AS district_5, t0.alert_count AS alert_count_6, t0.is_inside_homepage AS is_inside_homepage_7 FROM city t0 WHERE t0.id = 31;
14	0.46 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? Parameters: [`37382`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = 37382;
15	0.44 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.phone AS phone_6, t0.is_active AS is_active_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.country AS country_10, t0.city AS city_11, t0.lessor_type AS lessor_type_12, t0.registration_finalized AS registration_finalized_13, t0.nationality AS nationality_14, t0.agent_type AS agent_type_15, t0.representative_name AS representative_name_16, t0.sign_at AS sign_at_17, t0.edited_at AS edited_at_18, t0.customer_type AS customer_type_19, t0.head_office AS head_office_20, t0.number_tva AS number_tva_21, t0.company_type AS company_type_22, t0.street AS street_23, t0.street_number AS street_number_24, t0.adress2 AS adress2_25, t0.adress1 AS adress1_26, t0.last_postal_code AS last_postal_code_27, t0.last_city AS last_city_28, t0.last_country AS last_country_29, t0.visa_type AS visa_type_30, t0.postal_code AS postal_code_31, t0.birth_date AS birth_date_32, t0.civility AS civility_33, t0.name_legal AS name_legal_34, t0.first_name_legal AS first_name_legal_35, t0.phone_legal AS phone_legal_36, t0.email_legal AS email_legal_37, t0.activity AS activity_38, t0.first_lease AS first_lease_39, t0.commercial_mail AS commercial_mail_40, t0.pack_attestation AS pack_attestation_41, t0.agent_ender_control AS agent_ender_control_42, t0.consulat_country AS consulat_country_43, t0.step_profil AS step_profil_44, t0.date_start_at AS date_start_at_45, t0.rental_duration AS rental_duration_46, t0.status AS status_47, t0.formation_name AS formation_name_48, t0.school_name AS school_name_49, t0.school_address AS school_address_50, t0.study_level AS study_level_51, t0.company AS company_52, t0.employement_contract AS employement_contract_53, t0.trial_period AS trial_period_54, t0.net_monthly_salary AS net_monthly_salary_55, t0.guarantor_type AS guarantor_type_56, t0.physical_guarantor_type AS physical_guarantor_type_57, t0.statut_residence_principale AS statut_residence_principale_58, t0.mensual_rent AS mensual_rent_59, t0.contract_type AS contract_type_60, t0.finished_trial_period AS finished_trial_period_61, t0.income AS income_62, t0.additional_income_sources AS additional_income_sources_63, t0.additional_income_sources_student AS additional_income_sources_student_64, t0.guarantor_status AS guarantor_status_65, t0.professional_guarantee AS professional_guarantee_66, t0.physical_guarantor_nationality AS physical_guarantor_nationality_67, t0.application_message AS application_message_68, t0.local_agreement_number AS local_agreement_number_69, t0.company_address AS company_address_70, t0.representative_title AS representative_title_71, t0.representative_first_name AS representative_first_name_72, t0.send_sms AS send_sms_73, t0.managed_by_id AS managed_by_id_74, t0.team_with_id AS team_with_id_75 FROM `user` t0 WHERE t0.id = ? Parameters: [`527`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.phone AS phone_6, t0.is_active AS is_active_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.country AS country_10, t0.city AS city_11, t0.lessor_type AS lessor_type_12, t0.registration_finalized AS registration_finalized_13, t0.nationality AS nationality_14, t0.agent_type AS agent_type_15, t0.representative_name AS representative_name_16, t0.sign_at AS sign_at_17, t0.edited_at AS edited_at_18, t0.customer_type AS customer_type_19, t0.head_office AS head_office_20, t0.number_tva AS number_tva_21, t0.company_type AS company_type_22, t0.street AS street_23, t0.street_number AS street_number_24, t0.adress2 AS adress2_25, t0.adress1 AS adress1_26, t0.last_postal_code AS last_postal_code_27, t0.last_city AS last_city_28, t0.last_country AS last_country_29, t0.visa_type AS visa_type_30, t0.postal_code AS postal_code_31, t0.birth_date AS birth_date_32, t0.civility AS civility_33, t0.name_legal AS name_legal_34, t0.first_name_legal AS first_name_legal_35, t0.phone_legal AS phone_legal_36, t0.email_legal AS email_legal_37, t0.activity AS activity_38, t0.first_lease AS first_lease_39, t0.commercial_mail AS commercial_mail_40, t0.pack_attestation AS pack_attestation_41, t0.agent_ender_control AS agent_ender_control_42, t0.consulat_country AS consulat_country_43, t0.step_profil AS step_profil_44, t0.date_start_at AS date_start_at_45, t0.rental_duration AS rental_duration_46, t0.status AS status_47, t0.formation_name AS formation_name_48, t0.school_name AS school_name_49, t0.school_address AS school_address_50, t0.study_level AS study_level_51, t0.company AS company_52, t0.employement_contract AS employement_contract_53, t0.trial_period AS trial_period_54, t0.net_monthly_salary AS net_monthly_salary_55, t0.guarantor_type AS guarantor_type_56, t0.physical_guarantor_type AS physical_guarantor_type_57, t0.statut_residence_principale AS statut_residence_principale_58, t0.mensual_rent AS mensual_rent_59, t0.contract_type AS contract_type_60, t0.finished_trial_period AS finished_trial_period_61, t0.income AS income_62, t0.additional_income_sources AS additional_income_sources_63, t0.additional_income_sources_student AS additional_income_sources_student_64, t0.guarantor_status AS guarantor_status_65, t0.professional_guarantee AS professional_guarantee_66, t0.physical_guarantor_nationality AS physical_guarantor_nationality_67, t0.application_message AS application_message_68, t0.local_agreement_number AS local_agreement_number_69, t0.company_address AS company_address_70, t0.representative_title AS representative_title_71, t0.representative_first_name AS representative_first_name_72, t0.send_sms AS send_sms_73, t0.managed_by_id AS managed_by_id_74, t0.team_with_id AS team_with_id_75 FROM `user` t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.phone AS phone_6, t0.is_active AS is_active_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.country AS country_10, t0.city AS city_11, t0.lessor_type AS lessor_type_12, t0.registration_finalized AS registration_finalized_13, t0.nationality AS nationality_14, t0.agent_type AS agent_type_15, t0.representative_name AS representative_name_16, t0.sign_at AS sign_at_17, t0.edited_at AS edited_at_18, t0.customer_type AS customer_type_19, t0.head_office AS head_office_20, t0.number_tva AS number_tva_21, t0.company_type AS company_type_22, t0.street AS street_23, t0.street_number AS street_number_24, t0.adress2 AS adress2_25, t0.adress1 AS adress1_26, t0.last_postal_code AS last_postal_code_27, t0.last_city AS last_city_28, t0.last_country AS last_country_29, t0.visa_type AS visa_type_30, t0.postal_code AS postal_code_31, t0.birth_date AS birth_date_32, t0.civility AS civility_33, t0.name_legal AS name_legal_34, t0.first_name_legal AS first_name_legal_35, t0.phone_legal AS phone_legal_36, t0.email_legal AS email_legal_37, t0.activity AS activity_38, t0.first_lease AS first_lease_39, t0.commercial_mail AS commercial_mail_40, t0.pack_attestation AS pack_attestation_41, t0.agent_ender_control AS agent_ender_control_42, t0.consulat_country AS consulat_country_43, t0.step_profil AS step_profil_44, t0.date_start_at AS date_start_at_45, t0.rental_duration AS rental_duration_46, t0.status AS status_47, t0.formation_name AS formation_name_48, t0.school_name AS school_name_49, t0.school_address AS school_address_50, t0.study_level AS study_level_51, t0.company AS company_52, t0.employement_contract AS employement_contract_53, t0.trial_period AS trial_period_54, t0.net_monthly_salary AS net_monthly_salary_55, t0.guarantor_type AS guarantor_type_56, t0.physical_guarantor_type AS physical_guarantor_type_57, t0.statut_residence_principale AS statut_residence_principale_58, t0.mensual_rent AS mensual_rent_59, t0.contract_type AS contract_type_60, t0.finished_trial_period AS finished_trial_period_61, t0.income AS income_62, t0.additional_income_sources AS additional_income_sources_63, t0.additional_income_sources_student AS additional_income_sources_student_64, t0.guarantor_status AS guarantor_status_65, t0.professional_guarantee AS professional_guarantee_66, t0.physical_guarantor_nationality AS physical_guarantor_nationality_67, t0.application_message AS application_message_68, t0.local_agreement_number AS local_agreement_number_69, t0.company_address AS company_address_70, t0.representative_title AS representative_title_71, t0.representative_first_name AS representative_first_name_72, t0.send_sms AS send_sms_73, t0.managed_by_id AS managed_by_id_74, t0.team_with_id AS team_with_id_75 FROM `user` t0 WHERE t0.id = 527;

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.

Entities Mapping

Class	Mapping errors
App\Entity\Building	No errors.
App\Entity\User	The field App\Entity\User#invoices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Invoice#user does not contain the required 'inversedBy="invoices"' attribute.
App\Entity\City	No errors.
App\Entity\Residence	No errors.
App\Entity\RentalHistory	No errors.
App\Entity\BuildingEquipment	No errors.
App\Entity\BuildingDocument	No errors.
App\Entity\BuildingEditHistory	No errors.
App\Entity\BuildingReportingHistory	No errors.
App\Entity\BuildingFolder	No errors.
App\Entity\HousingCertificate	No errors.
App\Entity\WantedVisio	No errors.
App\Entity\LikedBuilding	No errors.
App\Entity\AgentCountryCovered	No errors.
App\Entity\Document	No errors.
App\Entity\RefusedVisa	No errors.
App\Entity\HistoryUser	No errors.
App\Entity\Invoice	No errors.

Symfony Profiler

GET https://preprod.roomlers.com/building/37385

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping