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,
  u1_.id AS id_28,
  u1_.first_name AS first_name_29,
  u1_.last_name AS last_name_30,
  u1_.email AS email_31,
  u1_.phone AS phone_32,
  u1_.description AS description_33,
  u1_.username AS username_34,
  u1_.roles AS roles_35,
  u1_.password AS password_36,
  u1_.created_at AS created_at_37,
  u1_.updated_at AS updated_at_38,
  u1_.reset_token AS reset_token_39,
  u1_.registration_token AS registration_token_40,
  u1_.first_home_token AS first_home_token_41,
  u1_.locale AS locale_42,
  u1_.is_founder AS is_founder_43,
  u1_.pre_reg_at AS pre_reg_at_44,
  u1_.first_reminder_pre_reg_at AS first_reminder_pre_reg_at_45,
  u1_.second_reminder_pre_reg_at AS second_reminder_pre_reg_at_46,
  u1_.registration_completed_at AS registration_completed_at_47,
  u1_.first_home_at AS first_home_at_48,
  u1_.first_reminder_home_at AS first_reminder_home_at_49,
  u1_.second_reminder_home_at AS second_reminder_home_at_50,
  u1_.first_home_completed_at AS first_home_completed_at_51,
  u1_.pre_reg_status AS pre_reg_status_52,
  u1_.first_home_status AS first_home_status_53,
  u1_.referral_code AS referral_code_54,
  p2_.id AS id_55,
  p2_.start_at AS start_at_56,
  p2_.end_at AS end_at_57,
  p2_.type AS type_58,
  u3_.id AS id_59,
  u3_.file_name AS file_name_60,
  u3_.dimensions AS dimensions_61,
  u3_.updated_at AS updated_at_62,
  t4_.id AS id_63,
  t4_.entity_class AS entity_class_64,
  t4_.entity_id AS entity_id_65,
  t4_.field_name AS field_name_66,
  f5_.id AS id_67,
  f5_.points AS points_68,
  f5_.is_enabled AS is_enabled_69,
  f5_.position AS position_70,
  t6_.id AS id_71,
  t6_.entity_class AS entity_class_72,
  t6_.entity_id AS entity_id_73,
  t6_.field_name AS field_name_74,
  t7_.id AS id_75,
  t7_.entity_class AS entity_class_76,
  t7_.entity_id AS entity_id_77,
  t7_.field_name AS field_name_78,
  t8_.id AS id_79,
  t8_.entity_class AS entity_class_80,
  t8_.entity_id AS entity_id_81,
  t8_.field_name AS field_name_82,
  t9_.id AS id_83,
  t9_.entity_class AS entity_class_84,
  t9_.entity_id AS entity_id_85,
  t9_.field_name AS field_name_86,
  h10_.id AS id_87,
  h10_.file_name AS file_name_88,
  h10_.dimensions AS dimensions_89,
  h10_.updated_at AS updated_at_90,
  h10_.position AS position_91,
  t11_.id AS id_92,
  t11_.entity_class AS entity_class_93,
  t11_.entity_id AS entity_id_94,
  t11_.field_name AS field_name_95,
  h0_.user_id AS user_id_96,
  h0_.title_id AS title_id_97,
  h0_.description_id AS description_id_98,
  h0_.neighborhood_description_id AS neighborhood_description_id_99,
  h0_.rules_id AS rules_id_100,
  u1_.avatar_id AS avatar_id_101,
  u1_.round_id AS round_id_102,
  u1_.sponsor_id AS sponsor_id_103,
  p2_.home_id AS home_id_104,
  u3_.alt_id AS alt_id_105,
  f5_.type_id AS type_id_106,
  f5_.title_id AS title_id_107,
  f5_.subtitle_id AS subtitle_id_108,
  f5_.description_id AS description_id_109,
  f5_.icon_id AS icon_id_110,
  h10_.alt_id AS alt_id_111,
  h10_.home_id AS home_id_112
FROM
  home h0_
  LEFT JOIN user u1_ ON h0_.user_id = u1_.id
  LEFT JOIN preferred_destination p12_ ON u1_.id = p12_.user_id
  LEFT JOIN period p2_ ON h0_.id = p2_.home_id
  LEFT JOIN user_image u3_ ON u1_.avatar_id = u3_.id
  LEFT JOIN text_content t4_ ON u3_.alt_id = t4_.id
  LEFT JOIN home_feature h13_ ON h0_.id = h13_.home_id
  LEFT JOIN feature f5_ ON f5_.id = h13_.feature_id
  LEFT JOIN text_content t6_ ON h0_.title_id = t6_.id
  LEFT JOIN text_content t7_ ON h0_.description_id = t7_.id
  LEFT JOIN text_content t8_ ON h0_.neighborhood_description_id = t8_.id
  LEFT JOIN text_content t9_ ON h0_.rules_id = t9_.id
  LEFT JOIN home_image h10_ ON h0_.id = h10_.home_id
  LEFT JOIN text_content t11_ ON h10_.alt_id = t11_.id
WHERE
  h0_.id IN (
    SELECT
      h14_.id
    FROM
      home h14_
      LEFT JOIN user u15_ ON h14_.user_id = u15_.id
      LEFT JOIN preferred_destination p16_ ON u15_.id = p16_.user_id
      LEFT JOIN period p17_ ON h14_.id = p17_.home_id
    WHERE
      h14_.is_enabled = 1
  )
  AND h0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  h0_.id ASC,
  h10_.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, u1_.id AS id_28, u1_.first_name AS first_name_29, u1_.last_name AS last_name_30, u1_.email AS email_31, u1_.phone AS phone_32, u1_.description AS description_33, u1_.username AS username_34, u1_.roles AS roles_35, u1_.password AS password_36, u1_.created_at AS created_at_37, u1_.updated_at AS updated_at_38, u1_.reset_token AS reset_token_39, u1_.registration_token AS registration_token_40, u1_.first_home_token AS first_home_token_41, u1_.locale AS locale_42, u1_.is_founder AS is_founder_43, u1_.pre_reg_at AS pre_reg_at_44, u1_.first_reminder_pre_reg_at AS first_reminder_pre_reg_at_45, u1_.second_reminder_pre_reg_at AS second_reminder_pre_reg_at_46, u1_.registration_completed_at AS registration_completed_at_47, u1_.first_home_at AS first_home_at_48, u1_.first_reminder_home_at AS first_reminder_home_at_49, u1_.second_reminder_home_at AS second_reminder_home_at_50, u1_.first_home_completed_at AS first_home_completed_at_51, u1_.pre_reg_status AS pre_reg_status_52, u1_.first_home_status AS first_home_status_53, u1_.referral_code AS referral_code_54, p2_.id AS id_55, p2_.start_at AS start_at_56, p2_.end_at AS end_at_57, p2_.type AS type_58, u3_.id AS id_59, u3_.file_name AS file_name_60, u3_.dimensions AS dimensions_61, u3_.updated_at AS updated_at_62, t4_.id AS id_63, t4_.entity_class AS entity_class_64, t4_.entity_id AS entity_id_65, t4_.field_name AS field_name_66, f5_.id AS id_67, f5_.points AS points_68, f5_.is_enabled AS is_enabled_69, f5_.position AS position_70, t6_.id AS id_71, t6_.entity_class AS entity_class_72, t6_.entity_id AS entity_id_73, t6_.field_name AS field_name_74, t7_.id AS id_75, t7_.entity_class AS entity_class_76, t7_.entity_id AS entity_id_77, t7_.field_name AS field_name_78, t8_.id AS id_79, t8_.entity_class AS entity_class_80, t8_.entity_id AS entity_id_81, t8_.field_name AS field_name_82, t9_.id AS id_83, t9_.entity_class AS entity_class_84, t9_.entity_id AS entity_id_85, t9_.field_name AS field_name_86, h10_.id AS id_87, h10_.file_name AS file_name_88, h10_.dimensions AS dimensions_89, h10_.updated_at AS updated_at_90, h10_.position AS position_91, t11_.id AS id_92, t11_.entity_class AS entity_class_93, t11_.entity_id AS entity_id_94, t11_.field_name AS field_name_95, h0_.user_id AS user_id_96, h0_.title_id AS title_id_97, h0_.description_id AS description_id_98, h0_.neighborhood_description_id AS neighborhood_description_id_99, h0_.rules_id AS rules_id_100, u1_.avatar_id AS avatar_id_101, u1_.round_id AS round_id_102, u1_.sponsor_id AS sponsor_id_103, p2_.home_id AS home_id_104, u3_.alt_id AS alt_id_105, f5_.type_id AS type_id_106, f5_.title_id AS title_id_107, f5_.subtitle_id AS subtitle_id_108, f5_.description_id AS description_id_109, f5_.icon_id AS icon_id_110, h10_.alt_id AS alt_id_111, h10_.home_id AS home_id_112 FROM home h0_ LEFT JOIN user u1_ ON h0_.user_id = u1_.id LEFT JOIN preferred_destination p12_ ON u1_.id = p12_.user_id LEFT JOIN period p2_ ON h0_.id = p2_.home_id LEFT JOIN user_image u3_ ON u1_.avatar_id = u3_.id LEFT JOIN text_content t4_ ON u3_.alt_id = t4_.id LEFT JOIN home_feature h13_ ON h0_.id = h13_.home_id LEFT JOIN feature f5_ ON f5_.id = h13_.feature_id LEFT JOIN text_content t6_ ON h0_.title_id = t6_.id LEFT JOIN text_content t7_ ON h0_.description_id = t7_.id LEFT JOIN text_content t8_ ON h0_.neighborhood_description_id = t8_.id LEFT JOIN text_content t9_ ON h0_.rules_id = t9_.id LEFT JOIN home_image h10_ ON h0_.id = h10_.home_id LEFT JOIN text_content t11_ ON h10_.alt_id = t11_.id WHERE h0_.id IN (SELECT h14_.id FROM home h14_ LEFT JOIN user u15_ ON h14_.user_id = u15_.id LEFT JOIN preferred_destination p16_ ON u15_.id = p16_.user_id LEFT JOIN period p17_ ON h14_.id = p17_.home_id WHERE h14_.is_enabled = 1) AND h0_.id IN (11, 26, 34, 42, 60, 62, 69, 72, 80, 81, 83, 87, 92, 93, 94, 95, 96, 97, 98, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110) ORDER BY h0_.id ASC, h10_.position ASC;

SELECT
  t0.id AS id_1,
  t0.translated_text AS translated_text_2,
  t0.language_id AS language_id_3,
  t0.text_content_id AS text_content_id_4
FROM
  translation t0
WHERE
  t0.text_content_id = ?

SELECT t0.id AS id_1, t0.translated_text AS translated_text_2, t0.language_id AS language_id_3, t0.text_content_id AS text_content_id_4 FROM translation t0 WHERE t0.text_content_id = 2047;

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
  count(DISTINCT h0_.id) AS sclr_0
FROM
  home h0_
  LEFT JOIN user u1_ ON h0_.user_id = u1_.id
  LEFT JOIN preferred_destination p2_ ON u1_.id = p2_.user_id
  LEFT JOIN period p3_ ON h0_.id = p3_.home_id
  LEFT JOIN user_image u4_ ON u1_.avatar_id = u4_.id
  LEFT JOIN text_content t5_ ON u4_.alt_id = t5_.id
  LEFT JOIN home_feature h7_ ON h0_.id = h7_.home_id
  LEFT JOIN feature f6_ ON f6_.id = h7_.feature_id
  LEFT JOIN text_content t8_ ON h0_.title_id = t8_.id
  LEFT JOIN text_content t9_ ON h0_.description_id = t9_.id
  LEFT JOIN text_content t10_ ON h0_.neighborhood_description_id = t10_.id
  LEFT JOIN text_content t11_ ON h0_.rules_id = t11_.id
  LEFT JOIN home_image h12_ ON h0_.id = h12_.home_id
  LEFT JOIN text_content t13_ ON h12_.alt_id = t13_.id
WHERE
  h0_.id IN (
    SELECT
      h14_.id
    FROM
      home h14_
      LEFT JOIN user u15_ ON h14_.user_id = u15_.id
      LEFT JOIN preferred_destination p16_ ON u15_.id = p16_.user_id
      LEFT JOIN period p17_ ON h14_.id = p17_.home_id
    WHERE
      h14_.is_enabled = 1
  )

SELECT count(DISTINCT h0_.id) AS sclr_0 FROM home h0_ LEFT JOIN user u1_ ON h0_.user_id = u1_.id LEFT JOIN preferred_destination p2_ ON u1_.id = p2_.user_id LEFT JOIN period p3_ ON h0_.id = p3_.home_id LEFT JOIN user_image u4_ ON u1_.avatar_id = u4_.id LEFT JOIN text_content t5_ ON u4_.alt_id = t5_.id LEFT JOIN home_feature h7_ ON h0_.id = h7_.home_id LEFT JOIN feature f6_ ON f6_.id = h7_.feature_id LEFT JOIN text_content t8_ ON h0_.title_id = t8_.id LEFT JOIN text_content t9_ ON h0_.description_id = t9_.id LEFT JOIN text_content t10_ ON h0_.neighborhood_description_id = t10_.id LEFT JOIN text_content t11_ ON h0_.rules_id = t11_.id LEFT JOIN home_image h12_ ON h0_.id = h12_.home_id LEFT JOIN text_content t13_ ON h12_.alt_id = t13_.id WHERE h0_.id IN (SELECT h14_.id FROM home h14_ LEFT JOIN user u15_ ON h14_.user_id = u15_.id LEFT JOIN preferred_destination p16_ ON u15_.id = p16_.user_id LEFT JOIN period p17_ ON h14_.id = p17_.home_id WHERE h14_.is_enabled = 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;

SELECT
  DISTINCT h0_.id AS id_0,
  h0_.id AS id_1
FROM
  home h0_
  LEFT JOIN user u1_ ON h0_.user_id = u1_.id
  LEFT JOIN preferred_destination p2_ ON u1_.id = p2_.user_id
  LEFT JOIN period p3_ ON h0_.id = p3_.home_id
  LEFT JOIN user_image u4_ ON u1_.avatar_id = u4_.id
  LEFT JOIN text_content t5_ ON u4_.alt_id = t5_.id
  LEFT JOIN home_feature h7_ ON h0_.id = h7_.home_id
  LEFT JOIN feature f6_ ON f6_.id = h7_.feature_id
  LEFT JOIN text_content t8_ ON h0_.title_id = t8_.id
  LEFT JOIN text_content t9_ ON h0_.description_id = t9_.id
  LEFT JOIN text_content t10_ ON h0_.neighborhood_description_id = t10_.id
  LEFT JOIN text_content t11_ ON h0_.rules_id = t11_.id
  LEFT JOIN home_image h12_ ON h0_.id = h12_.home_id
  LEFT JOIN text_content t13_ ON h12_.alt_id = t13_.id
WHERE
  h0_.id IN (
    SELECT
      h14_.id
    FROM
      home h14_
      LEFT JOIN user u15_ ON h14_.user_id = u15_.id
      LEFT JOIN preferred_destination p16_ ON u15_.id = p16_.user_id
      LEFT JOIN period p17_ ON h14_.id = p17_.home_id
    WHERE
      h14_.is_enabled = 1
  )
ORDER BY
  h0_.id ASC
LIMIT
  30

SELECT DISTINCT h0_.id AS id_0, h0_.id AS id_1 FROM home h0_ LEFT JOIN user u1_ ON h0_.user_id = u1_.id LEFT JOIN preferred_destination p2_ ON u1_.id = p2_.user_id LEFT JOIN period p3_ ON h0_.id = p3_.home_id LEFT JOIN user_image u4_ ON u1_.avatar_id = u4_.id LEFT JOIN text_content t5_ ON u4_.alt_id = t5_.id LEFT JOIN home_feature h7_ ON h0_.id = h7_.home_id LEFT JOIN feature f6_ ON f6_.id = h7_.feature_id LEFT JOIN text_content t8_ ON h0_.title_id = t8_.id LEFT JOIN text_content t9_ ON h0_.description_id = t9_.id LEFT JOIN text_content t10_ ON h0_.neighborhood_description_id = t10_.id LEFT JOIN text_content t11_ ON h0_.rules_id = t11_.id LEFT JOIN home_image h12_ ON h0_.id = h12_.home_id LEFT JOIN text_content t13_ ON h12_.alt_id = t13_.id WHERE h0_.id IN (SELECT h14_.id FROM home h14_ LEFT JOIN user u15_ ON h14_.user_id = u15_.id LEFT JOIN preferred_destination p16_ ON u15_.id = p16_.user_id LEFT JOIN period p17_ ON h14_.id = p17_.home_id WHERE h14_.is_enabled = 1) ORDER BY h0_.id ASC LIMIT 30;