Symfony Profiler

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
  u0_.id AS id_0,
  u0_.first_name AS first_name_1,
  u0_.last_name AS last_name_2,
  u0_.email AS email_3,
  u0_.phone AS phone_4,
  u0_.description AS description_5,
  u0_.username AS username_6,
  u0_.roles AS roles_7,
  u0_.password AS password_8,
  u0_.created_at AS created_at_9,
  u0_.updated_at AS updated_at_10,
  u0_.reset_token AS reset_token_11,
  u0_.registration_token AS registration_token_12,
  u0_.first_home_token AS first_home_token_13,
  u0_.locale AS locale_14,
  u0_.is_founder AS is_founder_15,
  u0_.pre_reg_at AS pre_reg_at_16,
  u0_.first_reminder_pre_reg_at AS first_reminder_pre_reg_at_17,
  u0_.second_reminder_pre_reg_at AS second_reminder_pre_reg_at_18,
  u0_.registration_completed_at AS registration_completed_at_19,
  u0_.first_home_at AS first_home_at_20,
  u0_.first_reminder_home_at AS first_reminder_home_at_21,
  u0_.second_reminder_home_at AS second_reminder_home_at_22,
  u0_.first_home_completed_at AS first_home_completed_at_23,
  u0_.pre_reg_status AS pre_reg_status_24,
  u0_.first_home_status AS first_home_status_25,
  u0_.referral_code AS referral_code_26,
  u1_.id AS id_27,
  u1_.file_name AS file_name_28,
  u1_.dimensions AS dimensions_29,
  u1_.updated_at AS updated_at_30,
  t2_.id AS id_31,
  t2_.entity_class AS entity_class_32,
  t2_.entity_id AS entity_id_33,
  t2_.field_name AS field_name_34,
  h3_.id AS id_35,
  h3_.created_at AS created_at_36,
  h3_.updated_at AS updated_at_37,
  h3_.area AS area_38,
  h3_.bedrooms AS bedrooms_39,
  h3_.bathrooms AS bathrooms_40,
  h3_.double_beds AS double_beds_41,
  h3_.single_beds AS single_beds_42,
  h3_.child_beds AS child_beds_43,
  h3_.baby_beds AS baby_beds_44,
  h3_.is_draft AS is_draft_45,
  h3_.form_step AS form_step_46,
  h3_.draft_token AS draft_token_47,
  h3_.is_enabled AS is_enabled_48,
  h3_.points_by_night AS points_by_night_49,
  h3_.min_recommended_nights AS min_recommended_nights_50,
  h3_.last_inactivity_reminder_at AS last_inactivity_reminder_at_51,
  h3_.address_street AS address_street_52,
  h3_.address_city AS address_city_53,
  h3_.address_zip AS address_zip_54,
  h3_.address_region AS address_region_55,
  h3_.address_country AS address_country_56,
  h3_.address_full_address AS address_full_address_57,
  h3_.address_latitude AS address_latitude_58,
  h3_.address_longitude AS address_longitude_59,
  h3_.address_public_latitude AS address_public_latitude_60,
  h3_.address_public_longitude AS address_public_longitude_61,
  h3_.address_place_id AS address_place_id_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,
  h5_.id AS id_67,
  h5_.file_name AS file_name_68,
  h5_.dimensions AS dimensions_69,
  h5_.updated_at AS updated_at_70,
  h5_.position AS position_71,
  t6_.id AS id_72,
  t6_.entity_class AS entity_class_73,
  t6_.entity_id AS entity_id_74,
  t6_.field_name AS field_name_75,
  p7_.id AS id_76,
  p7_.from_date AS from_date_77,
  p7_.to_date AS to_date_78,
  p7_.adults AS adults_79,
  p7_.children AS children_80,
  p7_.babies AS babies_81,
  p7_.notify_by_email AS notify_by_email_82,
  p7_.address_street AS address_street_83,
  p7_.address_city AS address_city_84,
  p7_.address_zip AS address_zip_85,
  p7_.address_region AS address_region_86,
  p7_.address_country AS address_country_87,
  p7_.address_full_address AS address_full_address_88,
  p7_.address_latitude AS address_latitude_89,
  p7_.address_longitude AS address_longitude_90,
  p7_.address_public_latitude AS address_public_latitude_91,
  p7_.address_public_longitude AS address_public_longitude_92,
  p7_.address_place_id AS address_place_id_93,
  t8_.id AS id_94,
  t8_.first_name AS first_name_95,
  t8_.age_group AS age_group_96,
  t8_.relationship AS relationship_97,
  l9_.id AS id_98,
  l9_.name AS name_99,
  l9_.code AS code_100,
  l9_.is_main AS is_main_101,
  u0_.avatar_id AS avatar_id_102,
  u0_.round_id AS round_id_103,
  u0_.sponsor_id AS sponsor_id_104,
  u1_.alt_id AS alt_id_105,
  h3_.user_id AS user_id_106,
  h3_.title_id AS title_id_107,
  h3_.description_id AS description_id_108,
  h3_.neighborhood_description_id AS neighborhood_description_id_109,
  h3_.rules_id AS rules_id_110,
  h5_.alt_id AS alt_id_111,
  h5_.home_id AS home_id_112,
  p7_.user_id AS user_id_113,
  t8_.user_id AS user_id_114,
  l9_.image_id AS image_id_115
FROM
  user u0_
  LEFT JOIN user_image u1_ ON u0_.avatar_id = u1_.id
  LEFT JOIN text_content t2_ ON u1_.alt_id = t2_.id
  LEFT JOIN home h3_ ON u0_.id = h3_.user_id
  LEFT JOIN text_content t4_ ON h3_.title_id = t4_.id
  LEFT JOIN home_image h5_ ON h3_.id = h5_.home_id
  LEFT JOIN text_content t6_ ON h5_.alt_id = t6_.id
  LEFT JOIN preferred_destination p7_ ON u0_.id = p7_.user_id
  LEFT JOIN traveler t8_ ON u0_.id = t8_.user_id
  LEFT JOIN user_language u10_ ON u0_.id = u10_.user_id
  LEFT JOIN language l9_ ON l9_.id = u10_.language_id
WHERE
  u0_.id = ?
ORDER BY
  h5_.position ASC

SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.description AS description_5, u0_.username AS username_6, u0_.roles AS roles_7, u0_.password AS password_8, u0_.created_at AS created_at_9, u0_.updated_at AS updated_at_10, u0_.reset_token AS reset_token_11, u0_.registration_token AS registration_token_12, u0_.first_home_token AS first_home_token_13, u0_.locale AS locale_14, u0_.is_founder AS is_founder_15, u0_.pre_reg_at AS pre_reg_at_16, u0_.first_reminder_pre_reg_at AS first_reminder_pre_reg_at_17, u0_.second_reminder_pre_reg_at AS second_reminder_pre_reg_at_18, u0_.registration_completed_at AS registration_completed_at_19, u0_.first_home_at AS first_home_at_20, u0_.first_reminder_home_at AS first_reminder_home_at_21, u0_.second_reminder_home_at AS second_reminder_home_at_22, u0_.first_home_completed_at AS first_home_completed_at_23, u0_.pre_reg_status AS pre_reg_status_24, u0_.first_home_status AS first_home_status_25, u0_.referral_code AS referral_code_26, u1_.id AS id_27, u1_.file_name AS file_name_28, u1_.dimensions AS dimensions_29, u1_.updated_at AS updated_at_30, t2_.id AS id_31, t2_.entity_class AS entity_class_32, t2_.entity_id AS entity_id_33, t2_.field_name AS field_name_34, h3_.id AS id_35, h3_.created_at AS created_at_36, h3_.updated_at AS updated_at_37, h3_.area AS area_38, h3_.bedrooms AS bedrooms_39, h3_.bathrooms AS bathrooms_40, h3_.double_beds AS double_beds_41, h3_.single_beds AS single_beds_42, h3_.child_beds AS child_beds_43, h3_.baby_beds AS baby_beds_44, h3_.is_draft AS is_draft_45, h3_.form_step AS form_step_46, h3_.draft_token AS draft_token_47, h3_.is_enabled AS is_enabled_48, h3_.points_by_night AS points_by_night_49, h3_.min_recommended_nights AS min_recommended_nights_50, h3_.last_inactivity_reminder_at AS last_inactivity_reminder_at_51, h3_.address_street AS address_street_52, h3_.address_city AS address_city_53, h3_.address_zip AS address_zip_54, h3_.address_region AS address_region_55, h3_.address_country AS address_country_56, h3_.address_full_address AS address_full_address_57, h3_.address_latitude AS address_latitude_58, h3_.address_longitude AS address_longitude_59, h3_.address_public_latitude AS address_public_latitude_60, h3_.address_public_longitude AS address_public_longitude_61, h3_.address_place_id AS address_place_id_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, h5_.id AS id_67, h5_.file_name AS file_name_68, h5_.dimensions AS dimensions_69, h5_.updated_at AS updated_at_70, h5_.position AS position_71, t6_.id AS id_72, t6_.entity_class AS entity_class_73, t6_.entity_id AS entity_id_74, t6_.field_name AS field_name_75, p7_.id AS id_76, p7_.from_date AS from_date_77, p7_.to_date AS to_date_78, p7_.adults AS adults_79, p7_.children AS children_80, p7_.babies AS babies_81, p7_.notify_by_email AS notify_by_email_82, p7_.address_street AS address_street_83, p7_.address_city AS address_city_84, p7_.address_zip AS address_zip_85, p7_.address_region AS address_region_86, p7_.address_country AS address_country_87, p7_.address_full_address AS address_full_address_88, p7_.address_latitude AS address_latitude_89, p7_.address_longitude AS address_longitude_90, p7_.address_public_latitude AS address_public_latitude_91, p7_.address_public_longitude AS address_public_longitude_92, p7_.address_place_id AS address_place_id_93, t8_.id AS id_94, t8_.first_name AS first_name_95, t8_.age_group AS age_group_96, t8_.relationship AS relationship_97, l9_.id AS id_98, l9_.name AS name_99, l9_.code AS code_100, l9_.is_main AS is_main_101, u0_.avatar_id AS avatar_id_102, u0_.round_id AS round_id_103, u0_.sponsor_id AS sponsor_id_104, u1_.alt_id AS alt_id_105, h3_.user_id AS user_id_106, h3_.title_id AS title_id_107, h3_.description_id AS description_id_108, h3_.neighborhood_description_id AS neighborhood_description_id_109, h3_.rules_id AS rules_id_110, h5_.alt_id AS alt_id_111, h5_.home_id AS home_id_112, p7_.user_id AS user_id_113, t8_.user_id AS user_id_114, l9_.image_id AS image_id_115 FROM user u0_ LEFT JOIN user_image u1_ ON u0_.avatar_id = u1_.id LEFT JOIN text_content t2_ ON u1_.alt_id = t2_.id LEFT JOIN home h3_ ON u0_.id = h3_.user_id LEFT JOIN text_content t4_ ON h3_.title_id = t4_.id LEFT JOIN home_image h5_ ON h3_.id = h5_.home_id LEFT JOIN text_content t6_ ON h5_.alt_id = t6_.id LEFT JOIN preferred_destination p7_ ON u0_.id = p7_.user_id LEFT JOIN traveler t8_ ON u0_.id = t8_.user_id LEFT JOIN user_language u10_ ON u0_.id = u10_.user_id LEFT JOIN language l9_ ON l9_.id = u10_.language_id WHERE u0_.id = 56 ORDER BY h5_.position ASC;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.description AS description_6,
  t0.username AS username_7,
  t0.roles AS roles_8,
  t0.password AS password_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.reset_token AS reset_token_12,
  t0.registration_token AS registration_token_13,
  t0.first_home_token AS first_home_token_14,
  t0.locale AS locale_15,
  t0.is_founder AS is_founder_16,
  t0.pre_reg_at AS pre_reg_at_17,
  t0.first_reminder_pre_reg_at AS first_reminder_pre_reg_at_18,
  t0.second_reminder_pre_reg_at AS second_reminder_pre_reg_at_19,
  t0.registration_completed_at AS registration_completed_at_20,
  t0.first_home_at AS first_home_at_21,
  t0.first_reminder_home_at AS first_reminder_home_at_22,
  t0.second_reminder_home_at AS second_reminder_home_at_23,
  t0.first_home_completed_at AS first_home_completed_at_24,
  t0.pre_reg_status AS pre_reg_status_25,
  t0.first_home_status AS first_home_status_26,
  t0.referral_code AS referral_code_27,
  t0.avatar_id AS avatar_id_28,
  t0.round_id AS round_id_29,
  t0.sponsor_id AS sponsor_id_30
FROM
  user t0
WHERE
  t0.sponsor_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.description AS description_6, t0.username AS username_7, t0.roles AS roles_8, t0.password AS password_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.reset_token AS reset_token_12, t0.registration_token AS registration_token_13, t0.first_home_token AS first_home_token_14, t0.locale AS locale_15, t0.is_founder AS is_founder_16, t0.pre_reg_at AS pre_reg_at_17, t0.first_reminder_pre_reg_at AS first_reminder_pre_reg_at_18, t0.second_reminder_pre_reg_at AS second_reminder_pre_reg_at_19, t0.registration_completed_at AS registration_completed_at_20, t0.first_home_at AS first_home_at_21, t0.first_reminder_home_at AS first_reminder_home_at_22, t0.second_reminder_home_at AS second_reminder_home_at_23, t0.first_home_completed_at AS first_home_completed_at_24, t0.pre_reg_status AS pre_reg_status_25, t0.first_home_status AS first_home_status_26, t0.referral_code AS referral_code_27, t0.avatar_id AS avatar_id_28, t0.round_id AS round_id_29, t0.sponsor_id AS sponsor_id_30 FROM user t0 WHERE t0.sponsor_id = 56;

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

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;