Symfony Profiler

SELECT
  h0_.id AS id_0,
  h0_.created_at AS created_at_1,
  h0_.updated_at AS updated_at_2,
  h0_.area AS area_3,
  h0_.bedrooms AS bedrooms_4,
  h0_.bathrooms AS bathrooms_5,
  h0_.double_beds AS double_beds_6,
  h0_.single_beds AS single_beds_7,
  h0_.child_beds AS child_beds_8,
  h0_.baby_beds AS baby_beds_9,
  h0_.is_draft AS is_draft_10,
  h0_.form_step AS form_step_11,
  h0_.draft_token AS draft_token_12,
  h0_.is_enabled AS is_enabled_13,
  h0_.points_by_night AS points_by_night_14,
  h0_.min_recommended_nights AS min_recommended_nights_15,
  h0_.last_inactivity_reminder_at AS last_inactivity_reminder_at_16,
  h0_.address_street AS address_street_17,
  h0_.address_city AS address_city_18,
  h0_.address_zip AS address_zip_19,
  h0_.address_region AS address_region_20,
  h0_.address_country AS address_country_21,
  h0_.address_full_address AS address_full_address_22,
  h0_.address_latitude AS address_latitude_23,
  h0_.address_longitude AS address_longitude_24,
  h0_.address_public_latitude AS address_public_latitude_25,
  h0_.address_public_longitude AS address_public_longitude_26,
  h0_.address_place_id AS address_place_id_27,
  f1_.id AS id_28,
  f1_.points AS points_29,
  f1_.is_enabled AS is_enabled_30,
  f1_.position AS position_31,
  t2_.id AS id_32,
  t2_.entity_class AS entity_class_33,
  t2_.entity_id AS entity_id_34,
  t2_.field_name AS field_name_35,
  t3_.id AS id_36,
  t3_.entity_class AS entity_class_37,
  t3_.entity_id AS entity_id_38,
  t3_.field_name AS field_name_39,
  t4_.id AS id_40,
  t4_.entity_class AS entity_class_41,
  t4_.entity_id AS entity_id_42,
  t4_.field_name AS field_name_43,
  t5_.id AS id_44,
  t5_.entity_class AS entity_class_45,
  t5_.entity_id AS entity_id_46,
  t5_.field_name AS field_name_47,
  h6_.id AS id_48,
  h6_.file_name AS file_name_49,
  h6_.dimensions AS dimensions_50,
  h6_.updated_at AS updated_at_51,
  h6_.position AS position_52,
  t7_.id AS id_53,
  t7_.entity_class AS entity_class_54,
  t7_.entity_id AS entity_id_55,
  t7_.field_name AS field_name_56,
  p8_.id AS id_57,
  p8_.start_at AS start_at_58,
  p8_.end_at AS end_at_59,
  p8_.type AS type_60,
  h0_.user_id AS user_id_61,
  h0_.title_id AS title_id_62,
  h0_.description_id AS description_id_63,
  h0_.neighborhood_description_id AS neighborhood_description_id_64,
  h0_.rules_id AS rules_id_65,
  f1_.type_id AS type_id_66,
  f1_.title_id AS title_id_67,
  f1_.subtitle_id AS subtitle_id_68,
  f1_.description_id AS description_id_69,
  f1_.icon_id AS icon_id_70,
  h6_.alt_id AS alt_id_71,
  h6_.home_id AS home_id_72,
  p8_.home_id AS home_id_73
FROM
  home h0_
  LEFT JOIN home_feature h9_ ON h0_.id = h9_.home_id
  LEFT JOIN feature f1_ ON f1_.id = h9_.feature_id
  LEFT JOIN text_content t2_ ON h0_.title_id = t2_.id
  LEFT JOIN text_content t3_ ON h0_.description_id = t3_.id
  LEFT JOIN text_content t4_ ON h0_.neighborhood_description_id = t4_.id
  LEFT JOIN text_content t5_ ON h0_.rules_id = t5_.id
  LEFT JOIN home_image h6_ ON h0_.id = h6_.home_id
  LEFT JOIN text_content t7_ ON h6_.alt_id = t7_.id
  LEFT JOIN period p8_ ON h0_.id = p8_.home_id
WHERE
  h0_.user_id = ?
ORDER BY
  h0_.id ASC,
  h6_.position ASC

SELECT h0_.id AS id_0, h0_.created_at AS created_at_1, h0_.updated_at AS updated_at_2, h0_.area AS area_3, h0_.bedrooms AS bedrooms_4, h0_.bathrooms AS bathrooms_5, h0_.double_beds AS double_beds_6, h0_.single_beds AS single_beds_7, h0_.child_beds AS child_beds_8, h0_.baby_beds AS baby_beds_9, h0_.is_draft AS is_draft_10, h0_.form_step AS form_step_11, h0_.draft_token AS draft_token_12, h0_.is_enabled AS is_enabled_13, h0_.points_by_night AS points_by_night_14, h0_.min_recommended_nights AS min_recommended_nights_15, h0_.last_inactivity_reminder_at AS last_inactivity_reminder_at_16, h0_.address_street AS address_street_17, h0_.address_city AS address_city_18, h0_.address_zip AS address_zip_19, h0_.address_region AS address_region_20, h0_.address_country AS address_country_21, h0_.address_full_address AS address_full_address_22, h0_.address_latitude AS address_latitude_23, h0_.address_longitude AS address_longitude_24, h0_.address_public_latitude AS address_public_latitude_25, h0_.address_public_longitude AS address_public_longitude_26, h0_.address_place_id AS address_place_id_27, f1_.id AS id_28, f1_.points AS points_29, f1_.is_enabled AS is_enabled_30, f1_.position AS position_31, t2_.id AS id_32, t2_.entity_class AS entity_class_33, t2_.entity_id AS entity_id_34, t2_.field_name AS field_name_35, t3_.id AS id_36, t3_.entity_class AS entity_class_37, t3_.entity_id AS entity_id_38, t3_.field_name AS field_name_39, t4_.id AS id_40, t4_.entity_class AS entity_class_41, t4_.entity_id AS entity_id_42, t4_.field_name AS field_name_43, t5_.id AS id_44, t5_.entity_class AS entity_class_45, t5_.entity_id AS entity_id_46, t5_.field_name AS field_name_47, h6_.id AS id_48, h6_.file_name AS file_name_49, h6_.dimensions AS dimensions_50, h6_.updated_at AS updated_at_51, h6_.position AS position_52, t7_.id AS id_53, t7_.entity_class AS entity_class_54, t7_.entity_id AS entity_id_55, t7_.field_name AS field_name_56, p8_.id AS id_57, p8_.start_at AS start_at_58, p8_.end_at AS end_at_59, p8_.type AS type_60, h0_.user_id AS user_id_61, h0_.title_id AS title_id_62, h0_.description_id AS description_id_63, h0_.neighborhood_description_id AS neighborhood_description_id_64, h0_.rules_id AS rules_id_65, f1_.type_id AS type_id_66, f1_.title_id AS title_id_67, f1_.subtitle_id AS subtitle_id_68, f1_.description_id AS description_id_69, f1_.icon_id AS icon_id_70, h6_.alt_id AS alt_id_71, h6_.home_id AS home_id_72, p8_.home_id AS home_id_73 FROM home h0_ LEFT JOIN home_feature h9_ ON h0_.id = h9_.home_id LEFT JOIN feature f1_ ON f1_.id = h9_.feature_id LEFT JOIN text_content t2_ ON h0_.title_id = t2_.id LEFT JOIN text_content t3_ ON h0_.description_id = t3_.id LEFT JOIN text_content t4_ ON h0_.neighborhood_description_id = t4_.id LEFT JOIN text_content t5_ ON h0_.rules_id = t5_.id LEFT JOIN home_image h6_ ON h0_.id = h6_.home_id LEFT JOIN text_content t7_ ON h6_.alt_id = t7_.id LEFT JOIN period p8_ ON h0_.id = p8_.home_id WHERE h0_.user_id = NULL ORDER BY h0_.id ASC, h6_.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_main AS is_main_4,
  t0.image_id AS image_id_5,
  t6.id AS id_7,
  t6.alt AS alt_8,
  t6.file_name AS file_name_9,
  t6.dimensions AS dimensions_10,
  t6.updated_at AS updated_at_11
FROM
  language t0
  LEFT JOIN language_image t6 ON t0.image_id = t6.id
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.code = 'fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_main AS is_main_4,
  t0.image_id AS image_id_5,
  t6.id AS id_7,
  t6.alt AS alt_8,
  t6.file_name AS file_name_9,
  t6.dimensions AS dimensions_10,
  t6.updated_at AS updated_at_11
FROM
  language t0
  LEFT JOIN language_image t6 ON t0.image_id = t6.id
WHERE
  t0.is_main = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_main AS is_main_4, t0.image_id AS image_id_5, t6.id AS id_7, t6.alt AS alt_8, t6.file_name AS file_name_9, t6.dimensions AS dimensions_10, t6.updated_at AS updated_at_11 FROM language t0 LEFT JOIN language_image t6 ON t0.image_id = t6.id WHERE t0.is_main = 1 LIMIT 1;