Symfony Profiler

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.city = ?
LIMIT
  1

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.city = 'Lyon' LIMIT 1;

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_.contact_name AS contact_name_22,
  b0_.mail_contact AS mail_contact_23,
  b0_.phone_contact AS phone_contact_24,
  b0_.security_deposit AS security_deposit_25,
  b0_.expenses AS expenses_26,
  b0_.expenses_description AS expenses_description_27,
  b0_.surface AS surface_28,
  b0_.surface_bedroom AS surface_bedroom_29,
  b0_.is_furniture AS is_furniture_30,
  b0_.is_aid_eligible AS is_aid_eligible_31,
  b0_.format AS format_32,
  b0_.postal_code AS postal_code_33,
  b0_.is_blocked AS is_blocked_34,
  b0_.is_floor AS is_floor_35,
  b0_.floor AS floor_36,
  b0_.pdl AS pdl_37,
  b0_.wifi AS wifi_38,
  b0_.dep AS dep_39,
  b0_.ges AS ges_40,
  b0_.max_folders AS max_folders_41,
  b0_.unique_id AS unique_id_42,
  b0_.min_income AS min_income_43,
  b0_.is_end AS is_end_44,
  b0_.lat AS lat_45,
  b0_.lng AS lng_46,
  b0_.is_authorize_atestation AS is_authorize_atestation_47,
  b0_.last_atestation AS last_atestation_48,
  b0_.has_guarantor AS has_guarantor_49,
  b0_.time_bail AS time_bail_50,
  b0_.type_bed AS type_bed_51,
  b0_.private_bathroom AS private_bathroom_52,
  b0_.bathrooms AS bathrooms_53,
  b0_.complex_property AS complex_property_54,
  b0_.complex_property_id AS complex_property_id_55,
  b0_.cover AS cover_56,
  b0_.has_reservation AS has_reservation_57,
  b0_.hide_address AS hide_address_58,
  b0_.bedroom_number AS bedroom_number_59,
  b0_.property_manager_id AS property_manager_id_60,
  b0_.tenant_id AS tenant_id_61,
  b0_.city_entity_id AS city_entity_id_62,
  b0_.residence_id AS residence_id_63
FROM
  building b0_
  INNER JOIN city c1_ ON b0_.city_entity_id = c1_.id
WHERE
  b0_.is_active = ?
  AND c1_.city = ?
ORDER BY
  b0_.id DESC
LIMIT
  16

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_.contact_name AS contact_name_22, b0_.mail_contact AS mail_contact_23, b0_.phone_contact AS phone_contact_24, b0_.security_deposit AS security_deposit_25, b0_.expenses AS expenses_26, b0_.expenses_description AS expenses_description_27, b0_.surface AS surface_28, b0_.surface_bedroom AS surface_bedroom_29, b0_.is_furniture AS is_furniture_30, b0_.is_aid_eligible AS is_aid_eligible_31, b0_.format AS format_32, b0_.postal_code AS postal_code_33, b0_.is_blocked AS is_blocked_34, b0_.is_floor AS is_floor_35, b0_.floor AS floor_36, b0_.pdl AS pdl_37, b0_.wifi AS wifi_38, b0_.dep AS dep_39, b0_.ges AS ges_40, b0_.max_folders AS max_folders_41, b0_.unique_id AS unique_id_42, b0_.min_income AS min_income_43, b0_.is_end AS is_end_44, b0_.lat AS lat_45, b0_.lng AS lng_46, b0_.is_authorize_atestation AS is_authorize_atestation_47, b0_.last_atestation AS last_atestation_48, b0_.has_guarantor AS has_guarantor_49, b0_.time_bail AS time_bail_50, b0_.type_bed AS type_bed_51, b0_.private_bathroom AS private_bathroom_52, b0_.bathrooms AS bathrooms_53, b0_.complex_property AS complex_property_54, b0_.complex_property_id AS complex_property_id_55, b0_.cover AS cover_56, b0_.has_reservation AS has_reservation_57, b0_.hide_address AS hide_address_58, b0_.bedroom_number AS bedroom_number_59, b0_.property_manager_id AS property_manager_id_60, b0_.tenant_id AS tenant_id_61, b0_.city_entity_id AS city_entity_id_62, b0_.residence_id AS residence_id_63 FROM building b0_ INNER JOIN city c1_ ON b0_.city_entity_id = c1_.id WHERE b0_.is_active = 1 AND c1_.city = 'LYON' ORDER BY b0_.id DESC LIMIT 16;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  building b0_
  INNER JOIN city c1_ ON b0_.city_entity_id = c1_.id
WHERE
  b0_.is_active = ?
  AND c1_.city = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM building b0_ INNER JOIN city c1_ ON b0_.city_entity_id = c1_.id WHERE b0_.is_active = 1 AND c1_.city = 'LYON';

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.contact_name AS contact_name_31,
  t8.mail_contact AS mail_contact_32,
  t8.phone_contact AS phone_contact_33,
  t8.security_deposit AS security_deposit_34,
  t8.expenses AS expenses_35,
  t8.expenses_description AS expenses_description_36,
  t8.surface AS surface_37,
  t8.surface_bedroom AS surface_bedroom_38,
  t8.is_furniture AS is_furniture_39,
  t8.is_aid_eligible AS is_aid_eligible_40,
  t8.format AS format_41,
  t8.postal_code AS postal_code_42,
  t8.is_blocked AS is_blocked_43,
  t8.is_floor AS is_floor_44,
  t8.floor AS floor_45,
  t8.pdl AS pdl_46,
  t8.wifi AS wifi_47,
  t8.dep AS dep_48,
  t8.ges AS ges_49,
  t8.max_folders AS max_folders_50,
  t8.unique_id AS unique_id_51,
  t8.min_income AS min_income_52,
  t8.is_end AS is_end_53,
  t8.lat AS lat_54,
  t8.lng AS lng_55,
  t8.is_authorize_atestation AS is_authorize_atestation_56,
  t8.last_atestation AS last_atestation_57,
  t8.has_guarantor AS has_guarantor_58,
  t8.time_bail AS time_bail_59,
  t8.type_bed AS type_bed_60,
  t8.private_bathroom AS private_bathroom_61,
  t8.bathrooms AS bathrooms_62,
  t8.complex_property AS complex_property_63,
  t8.complex_property_id AS complex_property_id_64,
  t8.cover AS cover_65,
  t8.has_reservation AS has_reservation_66,
  t8.hide_address AS hide_address_67,
  t8.bedroom_number AS bedroom_number_68,
  t8.property_manager_id AS property_manager_id_69,
  t8.tenant_id AS tenant_id_70,
  t8.city_entity_id AS city_entity_id_71,
  t8.residence_id AS residence_id_72,
  t0.residence_id AS residence_id_73
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.contact_name AS contact_name_31, t8.mail_contact AS mail_contact_32, t8.phone_contact AS phone_contact_33, t8.security_deposit AS security_deposit_34, t8.expenses AS expenses_35, t8.expenses_description AS expenses_description_36, t8.surface AS surface_37, t8.surface_bedroom AS surface_bedroom_38, t8.is_furniture AS is_furniture_39, t8.is_aid_eligible AS is_aid_eligible_40, t8.format AS format_41, t8.postal_code AS postal_code_42, t8.is_blocked AS is_blocked_43, t8.is_floor AS is_floor_44, t8.floor AS floor_45, t8.pdl AS pdl_46, t8.wifi AS wifi_47, t8.dep AS dep_48, t8.ges AS ges_49, t8.max_folders AS max_folders_50, t8.unique_id AS unique_id_51, t8.min_income AS min_income_52, t8.is_end AS is_end_53, t8.lat AS lat_54, t8.lng AS lng_55, t8.is_authorize_atestation AS is_authorize_atestation_56, t8.last_atestation AS last_atestation_57, t8.has_guarantor AS has_guarantor_58, t8.time_bail AS time_bail_59, t8.type_bed AS type_bed_60, t8.private_bathroom AS private_bathroom_61, t8.bathrooms AS bathrooms_62, t8.complex_property AS complex_property_63, t8.complex_property_id AS complex_property_id_64, t8.cover AS cover_65, t8.has_reservation AS has_reservation_66, t8.hide_address AS hide_address_67, t8.bedroom_number AS bedroom_number_68, t8.property_manager_id AS property_manager_id_69, t8.tenant_id AS tenant_id_70, t8.city_entity_id AS city_entity_id_71, t8.residence_id AS residence_id_72, t0.residence_id AS residence_id_73 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = 10396;

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 = 67;

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.contact_name AS contact_name_31,
  t8.mail_contact AS mail_contact_32,
  t8.phone_contact AS phone_contact_33,
  t8.security_deposit AS security_deposit_34,
  t8.expenses AS expenses_35,
  t8.expenses_description AS expenses_description_36,
  t8.surface AS surface_37,
  t8.surface_bedroom AS surface_bedroom_38,
  t8.is_furniture AS is_furniture_39,
  t8.is_aid_eligible AS is_aid_eligible_40,
  t8.format AS format_41,
  t8.postal_code AS postal_code_42,
  t8.is_blocked AS is_blocked_43,
  t8.is_floor AS is_floor_44,
  t8.floor AS floor_45,
  t8.pdl AS pdl_46,
  t8.wifi AS wifi_47,
  t8.dep AS dep_48,
  t8.ges AS ges_49,
  t8.max_folders AS max_folders_50,
  t8.unique_id AS unique_id_51,
  t8.min_income AS min_income_52,
  t8.is_end AS is_end_53,
  t8.lat AS lat_54,
  t8.lng AS lng_55,
  t8.is_authorize_atestation AS is_authorize_atestation_56,
  t8.last_atestation AS last_atestation_57,
  t8.has_guarantor AS has_guarantor_58,
  t8.time_bail AS time_bail_59,
  t8.type_bed AS type_bed_60,
  t8.private_bathroom AS private_bathroom_61,
  t8.bathrooms AS bathrooms_62,
  t8.complex_property AS complex_property_63,
  t8.complex_property_id AS complex_property_id_64,
  t8.cover AS cover_65,
  t8.has_reservation AS has_reservation_66,
  t8.hide_address AS hide_address_67,
  t8.bedroom_number AS bedroom_number_68,
  t8.property_manager_id AS property_manager_id_69,
  t8.tenant_id AS tenant_id_70,
  t8.city_entity_id AS city_entity_id_71,
  t8.residence_id AS residence_id_72,
  t0.residence_id AS residence_id_73
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.contact_name AS contact_name_31, t8.mail_contact AS mail_contact_32, t8.phone_contact AS phone_contact_33, t8.security_deposit AS security_deposit_34, t8.expenses AS expenses_35, t8.expenses_description AS expenses_description_36, t8.surface AS surface_37, t8.surface_bedroom AS surface_bedroom_38, t8.is_furniture AS is_furniture_39, t8.is_aid_eligible AS is_aid_eligible_40, t8.format AS format_41, t8.postal_code AS postal_code_42, t8.is_blocked AS is_blocked_43, t8.is_floor AS is_floor_44, t8.floor AS floor_45, t8.pdl AS pdl_46, t8.wifi AS wifi_47, t8.dep AS dep_48, t8.ges AS ges_49, t8.max_folders AS max_folders_50, t8.unique_id AS unique_id_51, t8.min_income AS min_income_52, t8.is_end AS is_end_53, t8.lat AS lat_54, t8.lng AS lng_55, t8.is_authorize_atestation AS is_authorize_atestation_56, t8.last_atestation AS last_atestation_57, t8.has_guarantor AS has_guarantor_58, t8.time_bail AS time_bail_59, t8.type_bed AS type_bed_60, t8.private_bathroom AS private_bathroom_61, t8.bathrooms AS bathrooms_62, t8.complex_property AS complex_property_63, t8.complex_property_id AS complex_property_id_64, t8.cover AS cover_65, t8.has_reservation AS has_reservation_66, t8.hide_address AS hide_address_67, t8.bedroom_number AS bedroom_number_68, t8.property_manager_id AS property_manager_id_69, t8.tenant_id AS tenant_id_70, t8.city_entity_id AS city_entity_id_71, t8.residence_id AS residence_id_72, t0.residence_id AS residence_id_73 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = 10395;

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.contact_name AS contact_name_31,
  t8.mail_contact AS mail_contact_32,
  t8.phone_contact AS phone_contact_33,
  t8.security_deposit AS security_deposit_34,
  t8.expenses AS expenses_35,
  t8.expenses_description AS expenses_description_36,
  t8.surface AS surface_37,
  t8.surface_bedroom AS surface_bedroom_38,
  t8.is_furniture AS is_furniture_39,
  t8.is_aid_eligible AS is_aid_eligible_40,
  t8.format AS format_41,
  t8.postal_code AS postal_code_42,
  t8.is_blocked AS is_blocked_43,
  t8.is_floor AS is_floor_44,
  t8.floor AS floor_45,
  t8.pdl AS pdl_46,
  t8.wifi AS wifi_47,
  t8.dep AS dep_48,
  t8.ges AS ges_49,
  t8.max_folders AS max_folders_50,
  t8.unique_id AS unique_id_51,
  t8.min_income AS min_income_52,
  t8.is_end AS is_end_53,
  t8.lat AS lat_54,
  t8.lng AS lng_55,
  t8.is_authorize_atestation AS is_authorize_atestation_56,
  t8.last_atestation AS last_atestation_57,
  t8.has_guarantor AS has_guarantor_58,
  t8.time_bail AS time_bail_59,
  t8.type_bed AS type_bed_60,
  t8.private_bathroom AS private_bathroom_61,
  t8.bathrooms AS bathrooms_62,
  t8.complex_property AS complex_property_63,
  t8.complex_property_id AS complex_property_id_64,
  t8.cover AS cover_65,
  t8.has_reservation AS has_reservation_66,
  t8.hide_address AS hide_address_67,
  t8.bedroom_number AS bedroom_number_68,
  t8.property_manager_id AS property_manager_id_69,
  t8.tenant_id AS tenant_id_70,
  t8.city_entity_id AS city_entity_id_71,
  t8.residence_id AS residence_id_72,
  t0.residence_id AS residence_id_73
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.contact_name AS contact_name_31, t8.mail_contact AS mail_contact_32, t8.phone_contact AS phone_contact_33, t8.security_deposit AS security_deposit_34, t8.expenses AS expenses_35, t8.expenses_description AS expenses_description_36, t8.surface AS surface_37, t8.surface_bedroom AS surface_bedroom_38, t8.is_furniture AS is_furniture_39, t8.is_aid_eligible AS is_aid_eligible_40, t8.format AS format_41, t8.postal_code AS postal_code_42, t8.is_blocked AS is_blocked_43, t8.is_floor AS is_floor_44, t8.floor AS floor_45, t8.pdl AS pdl_46, t8.wifi AS wifi_47, t8.dep AS dep_48, t8.ges AS ges_49, t8.max_folders AS max_folders_50, t8.unique_id AS unique_id_51, t8.min_income AS min_income_52, t8.is_end AS is_end_53, t8.lat AS lat_54, t8.lng AS lng_55, t8.is_authorize_atestation AS is_authorize_atestation_56, t8.last_atestation AS last_atestation_57, t8.has_guarantor AS has_guarantor_58, t8.time_bail AS time_bail_59, t8.type_bed AS type_bed_60, t8.private_bathroom AS private_bathroom_61, t8.bathrooms AS bathrooms_62, t8.complex_property AS complex_property_63, t8.complex_property_id AS complex_property_id_64, t8.cover AS cover_65, t8.has_reservation AS has_reservation_66, t8.hide_address AS hide_address_67, t8.bedroom_number AS bedroom_number_68, t8.property_manager_id AS property_manager_id_69, t8.tenant_id AS tenant_id_70, t8.city_entity_id AS city_entity_id_71, t8.residence_id AS residence_id_72, t0.residence_id AS residence_id_73 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = 10192;

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 = 28282;

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.contact_name AS contact_name_31,
  t8.mail_contact AS mail_contact_32,
  t8.phone_contact AS phone_contact_33,
  t8.security_deposit AS security_deposit_34,
  t8.expenses AS expenses_35,
  t8.expenses_description AS expenses_description_36,
  t8.surface AS surface_37,
  t8.surface_bedroom AS surface_bedroom_38,
  t8.is_furniture AS is_furniture_39,
  t8.is_aid_eligible AS is_aid_eligible_40,
  t8.format AS format_41,
  t8.postal_code AS postal_code_42,
  t8.is_blocked AS is_blocked_43,
  t8.is_floor AS is_floor_44,
  t8.floor AS floor_45,
  t8.pdl AS pdl_46,
  t8.wifi AS wifi_47,
  t8.dep AS dep_48,
  t8.ges AS ges_49,
  t8.max_folders AS max_folders_50,
  t8.unique_id AS unique_id_51,
  t8.min_income AS min_income_52,
  t8.is_end AS is_end_53,
  t8.lat AS lat_54,
  t8.lng AS lng_55,
  t8.is_authorize_atestation AS is_authorize_atestation_56,
  t8.last_atestation AS last_atestation_57,
  t8.has_guarantor AS has_guarantor_58,
  t8.time_bail AS time_bail_59,
  t8.type_bed AS type_bed_60,
  t8.private_bathroom AS private_bathroom_61,
  t8.bathrooms AS bathrooms_62,
  t8.complex_property AS complex_property_63,
  t8.complex_property_id AS complex_property_id_64,
  t8.cover AS cover_65,
  t8.has_reservation AS has_reservation_66,
  t8.hide_address AS hide_address_67,
  t8.bedroom_number AS bedroom_number_68,
  t8.property_manager_id AS property_manager_id_69,
  t8.tenant_id AS tenant_id_70,
  t8.city_entity_id AS city_entity_id_71,
  t8.residence_id AS residence_id_72,
  t0.residence_id AS residence_id_73
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.contact_name AS contact_name_31, t8.mail_contact AS mail_contact_32, t8.phone_contact AS phone_contact_33, t8.security_deposit AS security_deposit_34, t8.expenses AS expenses_35, t8.expenses_description AS expenses_description_36, t8.surface AS surface_37, t8.surface_bedroom AS surface_bedroom_38, t8.is_furniture AS is_furniture_39, t8.is_aid_eligible AS is_aid_eligible_40, t8.format AS format_41, t8.postal_code AS postal_code_42, t8.is_blocked AS is_blocked_43, t8.is_floor AS is_floor_44, t8.floor AS floor_45, t8.pdl AS pdl_46, t8.wifi AS wifi_47, t8.dep AS dep_48, t8.ges AS ges_49, t8.max_folders AS max_folders_50, t8.unique_id AS unique_id_51, t8.min_income AS min_income_52, t8.is_end AS is_end_53, t8.lat AS lat_54, t8.lng AS lng_55, t8.is_authorize_atestation AS is_authorize_atestation_56, t8.last_atestation AS last_atestation_57, t8.has_guarantor AS has_guarantor_58, t8.time_bail AS time_bail_59, t8.type_bed AS type_bed_60, t8.private_bathroom AS private_bathroom_61, t8.bathrooms AS bathrooms_62, t8.complex_property AS complex_property_63, t8.complex_property_id AS complex_property_id_64, t8.cover AS cover_65, t8.has_reservation AS has_reservation_66, t8.hide_address AS hide_address_67, t8.bedroom_number AS bedroom_number_68, t8.property_manager_id AS property_manager_id_69, t8.tenant_id AS tenant_id_70, t8.city_entity_id AS city_entity_id_71, t8.residence_id AS residence_id_72, t0.residence_id AS residence_id_73 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = 10191;