Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.accommodation_id AS accommodation_id_2,
  t0.user_id AS user_id_3,
  t0.company AS company_4,
  t0.company_id AS company_id_5,
  t0.accommodation_name AS accommodation_name_6,
  t0.id_gallery AS id_gallery_7,
  t0.occupational_rule_id AS occupational_rule_id_8,
  t0.price_modifier_id AS price_modifier_id_9,
  t0.purpose AS purpose_10,
  t0.kind_id AS kind_id_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.accommodation_units AS accommodation_units_14,
  t0.currency AS currency_15,
  t0.vat_included AS vat_included_16,
  t0.touristic_registration_number AS touristic_registration_number_17,
  t0.location_id AS location_id_18,
  t19.id AS id_20,
  t19.people_capacity AS people_capacity_21,
  t19.minimum_occupation AS minimum_occupation_22,
  t19.accept_youngsters AS accept_youngsters_23,
  t19.occupation_without_supplement AS occupation_without_supplement_24,
  t19.bedrooms AS bedrooms_25,
  t19.double_beds AS double_beds_26,
  t19.individual_beds AS individual_beds_27,
  t19.individual_sofa_bed AS individual_sofa_bed_28,
  t19.double_sofa_bed AS double_sofa_bed_29,
  t19.queen_beds AS queen_beds_30,
  t19.king_beds AS king_beds_31,
  t19.toilets AS toilets_32,
  t19.bathroom_with_bathtub AS bathroom_with_bathtub_33,
  t19.bathroom_with_shower AS bathroom_with_shower_34,
  t19.berths AS berths_35,
  t19.area_housing AS area_housing_36,
  t19.area_housing_unit AS area_housing_unit_37,
  t19.area_plot AS area_plot_38,
  t19.area_plot_unit AS area_plot_unit_39,
  t19.adults_capacity AS adults_capacity_40,
  t19.accommodation_id AS accommodation_id_41,
  t42.id AS id_43,
  t42.tv AS tv_44,
  t42.garden AS garden_45,
  t42.garden_furniture AS garden_furniture_46,
  t42.iron AS iron_47,
  t42.fire_place AS fire_place_48,
  t42.barbacue AS barbacue_49,
  t42.radio AS radio_50,
  t42.mini_bar AS mini_bar_51,
  t42.terrace AS terrace_52,
  t42.fenced_plot AS fenced_plot_53,
  t42.security_box AS security_box_54,
  t42.elevator AS elevator_55,
  t42.dvd AS dvd_56,
  t42.balcony AS balcony_57,
  t42.juice_squeezer AS juice_squeezer_58,
  t42.electric_kettle AS electric_kettle_59,
  t42.hair_dryer AS hair_dryer_60,
  t42.children_area AS children_area_61,
  t42.gym AS gym_62,
  t42.alarm AS alarm_63,
  t42.tennis AS tennis_64,
  t42.squash AS squash_65,
  t42.paddel AS paddel_66,
  t42.sauna AS sauna_67,
  t42.handicapped_facilities AS handicapped_facilities_68,
  t42.jacuzzi AS jacuzzi_69,
  t42.smoking_allowed AS smoking_allowed_70,
  t42.num_of_televisions AS num_of_televisions_71,
  t42.num_of_fans AS num_of_fans_72,
  t42.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_73,
  t42.window_screens AS window_screens_74,
  t42.acswimming_pool_id AS acswimming_pool_id_75,
  t42.tv_satellite_id AS tv_satellite_id_76,
  t42.ackitchen_id AS ackitchen_id_77,
  t42.accommodation_id AS accommodation_id_78,
  t79.id AS id_80,
  t79.name AS name_81,
  t79.video AS video_82,
  t79.code AS code_83,
  t79.accommodation_id AS accommodation_id_84
FROM
  accommodation t0
  LEFT JOIN ac_distribution t19 ON t19.accommodation_id = t0.id
  LEFT JOIN ac_house_characteristics t42 ON t42.accommodation_id = t0.id
  LEFT JOIN video t79 ON t79.accommodation_id = t0.id
WHERE
  t0.accommodation_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.accommodation_id AS accommodation_id_2, t0.user_id AS user_id_3, t0.company AS company_4, t0.company_id AS company_id_5, t0.accommodation_name AS accommodation_name_6, t0.id_gallery AS id_gallery_7, t0.occupational_rule_id AS occupational_rule_id_8, t0.price_modifier_id AS price_modifier_id_9, t0.purpose AS purpose_10, t0.kind_id AS kind_id_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.accommodation_units AS accommodation_units_14, t0.currency AS currency_15, t0.vat_included AS vat_included_16, t0.touristic_registration_number AS touristic_registration_number_17, t0.location_id AS location_id_18, t19.id AS id_20, t19.people_capacity AS people_capacity_21, t19.minimum_occupation AS minimum_occupation_22, t19.accept_youngsters AS accept_youngsters_23, t19.occupation_without_supplement AS occupation_without_supplement_24, t19.bedrooms AS bedrooms_25, t19.double_beds AS double_beds_26, t19.individual_beds AS individual_beds_27, t19.individual_sofa_bed AS individual_sofa_bed_28, t19.double_sofa_bed AS double_sofa_bed_29, t19.queen_beds AS queen_beds_30, t19.king_beds AS king_beds_31, t19.toilets AS toilets_32, t19.bathroom_with_bathtub AS bathroom_with_bathtub_33, t19.bathroom_with_shower AS bathroom_with_shower_34, t19.berths AS berths_35, t19.area_housing AS area_housing_36, t19.area_housing_unit AS area_housing_unit_37, t19.area_plot AS area_plot_38, t19.area_plot_unit AS area_plot_unit_39, t19.adults_capacity AS adults_capacity_40, t19.accommodation_id AS accommodation_id_41, t42.id AS id_43, t42.tv AS tv_44, t42.garden AS garden_45, t42.garden_furniture AS garden_furniture_46, t42.iron AS iron_47, t42.fire_place AS fire_place_48, t42.barbacue AS barbacue_49, t42.radio AS radio_50, t42.mini_bar AS mini_bar_51, t42.terrace AS terrace_52, t42.fenced_plot AS fenced_plot_53, t42.security_box AS security_box_54, t42.elevator AS elevator_55, t42.dvd AS dvd_56, t42.balcony AS balcony_57, t42.juice_squeezer AS juice_squeezer_58, t42.electric_kettle AS electric_kettle_59, t42.hair_dryer AS hair_dryer_60, t42.children_area AS children_area_61, t42.gym AS gym_62, t42.alarm AS alarm_63, t42.tennis AS tennis_64, t42.squash AS squash_65, t42.paddel AS paddel_66, t42.sauna AS sauna_67, t42.handicapped_facilities AS handicapped_facilities_68, t42.jacuzzi AS jacuzzi_69, t42.smoking_allowed AS smoking_allowed_70, t42.num_of_televisions AS num_of_televisions_71, t42.num_of_fans AS num_of_fans_72, t42.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_73, t42.window_screens AS window_screens_74, t42.acswimming_pool_id AS acswimming_pool_id_75, t42.tv_satellite_id AS tv_satellite_id_76, t42.ackitchen_id AS ackitchen_id_77, t42.accommodation_id AS accommodation_id_78, t79.id AS id_80, t79.name AS name_81, t79.video AS video_82, t79.code AS code_83, t79.accommodation_id AS accommodation_id_84 FROM accommodation t0 LEFT JOIN ac_distribution t19 ON t19.accommodation_id = t0.id LEFT JOIN ac_house_characteristics t42 ON t42.accommodation_id = t0.id LEFT JOIN video t79 ON t79.accommodation_id = t0.id WHERE t0.accommodation_id = '165242' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.locale AS locale_3,
  t0.text AS text_4
FROM
  kind t0
WHERE
  t0.code = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.locale AS locale_3, t0.text AS text_4 FROM kind t0 WHERE t0.code = 2 AND t0.locale = 'pt' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.name AS name_2,
  p0_.supplement AS supplement_3,
  p0_.cumulative AS cumulative_4,
  p0_.start_date AS start_date_5,
  p0_.end_date AS end_date_6,
  p0_.number_of_nights AS number_of_nights_7,
  p0_.type AS type_8,
  p0_.discount_supplement_type AS discount_supplement_type_9,
  p0_.amount AS amount_10
FROM
  price_modifier p0_
WHERE
  p0_.code = ?
  AND (
    ? BETWEEN p0_.start_date
    AND p0_.end_date
  )
  AND p0_.number_of_nights = ?

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.supplement AS supplement_3, p0_.cumulative AS cumulative_4, p0_.start_date AS start_date_5, p0_.end_date AS end_date_6, p0_.number_of_nights AS number_of_nights_7, p0_.type AS type_8, p0_.discount_supplement_type AS discount_supplement_type_9, p0_.amount AS amount_10 FROM price_modifier p0_ WHERE p0_.code = 2603655 AND ('2026-09-03 13:40:57' BETWEEN p0_.start_date AND p0_.end_date) AND p0_.number_of_nights = 1;

SELECT
  r0_.id AS id_0,
  r0_.capacity AS capacity_1,
  r0_.start_date AS start_date_2,
  r0_.end_date AS end_date_3,
  r0_.type AS type_4,
  r0_.price AS price_5,
  r0_.applicable_from_number_people AS applicable_from_number_people_6,
  r0_.supplement AS supplement_7,
  r0_.accommodation_id AS accommodation_id_8
FROM
  rate r0_
WHERE
  r0_.accommodation_id = ?
  AND r0_.start_date >= ?
  AND r0_.end_date <= ?
ORDER BY
  r0_.start_date ASC

SELECT r0_.id AS id_0, r0_.capacity AS capacity_1, r0_.start_date AS start_date_2, r0_.end_date AS end_date_3, r0_.type AS type_4, r0_.price AS price_5, r0_.applicable_from_number_people AS applicable_from_number_people_6, r0_.supplement AS supplement_7, r0_.accommodation_id AS accommodation_id_8 FROM rate r0_ WHERE r0_.accommodation_id = 8 AND r0_.start_date >= '2026-09-03 13:40:57' AND r0_.end_date <= '2028-03-03 13:40:57' ORDER BY r0_.start_date ASC;

SELECT
  t0.id AS id_1,
  t0.startday AS startday_2,
  t0.startmonth AS startmonth_3,
  t0.finalday AS finalday_4,
  t0.finalmonth AS finalmonth_5,
  t0.timefrom AS timefrom_6,
  t0.timeto AS timeto_7,
  t0.monday AS monday_8,
  t0.tuesday AS tuesday_9,
  t0.wednesday AS wednesday_10,
  t0.thursday AS thursday_11,
  t0.friday AS friday_12,
  t0.saturday AS saturday_13,
  t0.sunday AS sunday_14,
  t0.checkout AS checkout_15,
  t0.accommodation_id AS accommodation_id_16
FROM
  ac_check_in_out t0
WHERE
  t0.accommodation_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.startday AS startday_2, t0.startmonth AS startmonth_3, t0.finalday AS finalday_4, t0.finalmonth AS finalmonth_5, t0.timefrom AS timefrom_6, t0.timeto AS timeto_7, t0.monday AS monday_8, t0.tuesday AS tuesday_9, t0.wednesday AS wednesday_10, t0.thursday AS thursday_11, t0.friday AS friday_12, t0.saturday AS saturday_13, t0.sunday AS sunday_14, t0.checkout AS checkout_15, t0.accommodation_id AS accommodation_id_16 FROM ac_check_in_out t0 WHERE t0.accommodation_id = 8 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.guestname AS guestname_2,
  t0.language AS language_3,
  t0.rating AS rating_4,
  t0.title AS title_5,
  t0.positivecomment AS positivecomment_6,
  t0.negativecomment AS negativecomment_7,
  t0.bookingstartdate AS bookingstartdate_8,
  t0.bookingenddate AS bookingenddate_9,
  t0.reviewdate AS reviewdate_10,
  t0.reply AS reply_11,
  t0.accommodation_id AS accommodation_id_12
FROM
  reviews t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.guestname AS guestname_2, t0.language AS language_3, t0.rating AS rating_4, t0.title AS title_5, t0.positivecomment AS positivecomment_6, t0.negativecomment AS negativecomment_7, t0.bookingstartdate AS bookingstartdate_8, t0.bookingenddate AS bookingenddate_9, t0.reviewdate AS reviewdate_10, t0.reply AS reply_11, t0.accommodation_id AS accommodation_id_12 FROM reviews t0 WHERE t0.accommodation_id = 8;

SELECT
  t0.id AS id_1,
  t0.locationviews_id AS locationviews_id_2,
  t0.accommodation_id AS accommodation_id_3
FROM
  ac_location t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.locationviews_id AS locationviews_id_2, t0.accommodation_id AS accommodation_id_3 FROM ac_location t0 WHERE t0.accommodation_id = 8;

SELECT
  t0.id AS id_1,
  t0.place_type AS place_type_2,
  t0.value AS value_3,
  t0.unit AS unit_4,
  t0.name AS name_5,
  t0.ac_location_id AS ac_location_id_6
FROM
  ac_nearest_place t0
WHERE
  t0.ac_location_id IN (?)

SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.value AS value_3, t0.unit AS unit_4, t0.name AS name_5, t0.ac_location_id AS ac_location_id_6 FROM ac_nearest_place t0 WHERE t0.ac_location_id IN (8);

SELECT
  t0.id AS id_1,
  t0.locationviews_id AS locationviews_id_2,
  t0.accommodation_id AS accommodation_id_3
FROM
  ac_location t0
WHERE
  t0.accommodation_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locationviews_id AS locationviews_id_2, t0.accommodation_id AS accommodation_id_3 FROM ac_location t0 WHERE t0.accommodation_id = 8 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.place_type AS place_type_2,
  t0.value AS value_3,
  t0.unit AS unit_4,
  t0.name AS name_5,
  t0.ac_location_id AS ac_location_id_6
FROM
  ac_nearest_place t0
WHERE
  t0.ac_location_id = ?

SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.value AS value_3, t0.unit AS unit_4, t0.name AS name_5, t0.ac_location_id AS ac_location_id_6 FROM ac_nearest_place t0 WHERE t0.ac_location_id = 8;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.code AS code_3,
  t0.includedinprice AS includedinprice_4,
  t0.quantity AS quantity_5,
  t0.application AS application_6,
  t0.maxprice AS maxprice_7,
  t0.minprice AS minprice_8,
  t0.paytime AS paytime_9,
  t0.comparison AS comparison_10,
  t0.comparisonvalue AS comparisonvalue_11,
  t0.countable AS countable_12,
  t0.countablelimit AS countablelimit_13,
  t0.startday AS startday_14,
  t0.startmonth AS startmonth_15,
  t0.finalday AS finalday_16,
  t0.finalmonth AS finalmonth_17,
  t0.change_bed_clothes AS change_bed_clothes_18,
  t0.change_frequency AS change_frequency_19,
  t0.change_towels AS change_towels_20,
  t0.unit AS unit_21,
  t0.accommodation_id AS accommodation_id_22
FROM
  ac_special_service t0
WHERE
  t0.accommodation_id = ?
  AND t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.includedinprice AS includedinprice_4, t0.quantity AS quantity_5, t0.application AS application_6, t0.maxprice AS maxprice_7, t0.minprice AS minprice_8, t0.paytime AS paytime_9, t0.comparison AS comparison_10, t0.comparisonvalue AS comparisonvalue_11, t0.countable AS countable_12, t0.countablelimit AS countablelimit_13, t0.startday AS startday_14, t0.startmonth AS startmonth_15, t0.finalday AS finalday_16, t0.finalmonth AS finalmonth_17, t0.change_bed_clothes AS change_bed_clothes_18, t0.change_frequency AS change_frequency_19, t0.change_towels AS change_towels_20, t0.unit AS unit_21, t0.accommodation_id AS accommodation_id_22 FROM ac_special_service t0 WHERE t0.accommodation_id = 8 AND t0.code = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.tv AS tv_2,
  t0.garden AS garden_3,
  t0.garden_furniture AS garden_furniture_4,
  t0.iron AS iron_5,
  t0.fire_place AS fire_place_6,
  t0.barbacue AS barbacue_7,
  t0.radio AS radio_8,
  t0.mini_bar AS mini_bar_9,
  t0.terrace AS terrace_10,
  t0.fenced_plot AS fenced_plot_11,
  t0.security_box AS security_box_12,
  t0.elevator AS elevator_13,
  t0.dvd AS dvd_14,
  t0.balcony AS balcony_15,
  t0.juice_squeezer AS juice_squeezer_16,
  t0.electric_kettle AS electric_kettle_17,
  t0.hair_dryer AS hair_dryer_18,
  t0.children_area AS children_area_19,
  t0.gym AS gym_20,
  t0.alarm AS alarm_21,
  t0.tennis AS tennis_22,
  t0.squash AS squash_23,
  t0.paddel AS paddel_24,
  t0.sauna AS sauna_25,
  t0.handicapped_facilities AS handicapped_facilities_26,
  t0.jacuzzi AS jacuzzi_27,
  t0.smoking_allowed AS smoking_allowed_28,
  t0.num_of_televisions AS num_of_televisions_29,
  t0.num_of_fans AS num_of_fans_30,
  t0.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_31,
  t0.window_screens AS window_screens_32,
  t0.acswimming_pool_id AS acswimming_pool_id_33,
  t0.tv_satellite_id AS tv_satellite_id_34,
  t0.ackitchen_id AS ackitchen_id_35,
  t0.accommodation_id AS accommodation_id_36
FROM
  ac_house_characteristics t0
WHERE
  t0.accommodation_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.tv AS tv_2, t0.garden AS garden_3, t0.garden_furniture AS garden_furniture_4, t0.iron AS iron_5, t0.fire_place AS fire_place_6, t0.barbacue AS barbacue_7, t0.radio AS radio_8, t0.mini_bar AS mini_bar_9, t0.terrace AS terrace_10, t0.fenced_plot AS fenced_plot_11, t0.security_box AS security_box_12, t0.elevator AS elevator_13, t0.dvd AS dvd_14, t0.balcony AS balcony_15, t0.juice_squeezer AS juice_squeezer_16, t0.electric_kettle AS electric_kettle_17, t0.hair_dryer AS hair_dryer_18, t0.children_area AS children_area_19, t0.gym AS gym_20, t0.alarm AS alarm_21, t0.tennis AS tennis_22, t0.squash AS squash_23, t0.paddel AS paddel_24, t0.sauna AS sauna_25, t0.handicapped_facilities AS handicapped_facilities_26, t0.jacuzzi AS jacuzzi_27, t0.smoking_allowed AS smoking_allowed_28, t0.num_of_televisions AS num_of_televisions_29, t0.num_of_fans AS num_of_fans_30, t0.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_31, t0.window_screens AS window_screens_32, t0.acswimming_pool_id AS acswimming_pool_id_33, t0.tv_satellite_id AS tv_satellite_id_34, t0.ackitchen_id AS ackitchen_id_35, t0.accommodation_id AS accommodation_id_36 FROM ac_house_characteristics t0 WHERE t0.accommodation_id = 8 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.pool_type AS pool_type_2,
  t0.dimensions AS dimensions_3,
  t0.minimum_depth AS minimum_depth_4,
  t0.maximum_depth AS maximum_depth_5,
  t0.depth_unit AS depth_unit_6,
  t0.opening_day AS opening_day_7,
  t0.opening_month AS opening_month_8,
  t0.closing_day AS closing_day_9,
  t0.closing_month AS closing_month_10,
  t11.id AS id_12,
  t11.tv AS tv_13,
  t11.garden AS garden_14,
  t11.garden_furniture AS garden_furniture_15,
  t11.iron AS iron_16,
  t11.fire_place AS fire_place_17,
  t11.barbacue AS barbacue_18,
  t11.radio AS radio_19,
  t11.mini_bar AS mini_bar_20,
  t11.terrace AS terrace_21,
  t11.fenced_plot AS fenced_plot_22,
  t11.security_box AS security_box_23,
  t11.elevator AS elevator_24,
  t11.dvd AS dvd_25,
  t11.balcony AS balcony_26,
  t11.juice_squeezer AS juice_squeezer_27,
  t11.electric_kettle AS electric_kettle_28,
  t11.hair_dryer AS hair_dryer_29,
  t11.children_area AS children_area_30,
  t11.gym AS gym_31,
  t11.alarm AS alarm_32,
  t11.tennis AS tennis_33,
  t11.squash AS squash_34,
  t11.paddel AS paddel_35,
  t11.sauna AS sauna_36,
  t11.handicapped_facilities AS handicapped_facilities_37,
  t11.jacuzzi AS jacuzzi_38,
  t11.smoking_allowed AS smoking_allowed_39,
  t11.num_of_televisions AS num_of_televisions_40,
  t11.num_of_fans AS num_of_fans_41,
  t11.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_42,
  t11.window_screens AS window_screens_43,
  t11.acswimming_pool_id AS acswimming_pool_id_44,
  t11.tv_satellite_id AS tv_satellite_id_45,
  t11.ackitchen_id AS ackitchen_id_46,
  t11.accommodation_id AS accommodation_id_47
FROM
  ac_swimming_pool t0
  LEFT JOIN ac_house_characteristics t11 ON t11.acswimming_pool_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.pool_type AS pool_type_2, t0.dimensions AS dimensions_3, t0.minimum_depth AS minimum_depth_4, t0.maximum_depth AS maximum_depth_5, t0.depth_unit AS depth_unit_6, t0.opening_day AS opening_day_7, t0.opening_month AS opening_month_8, t0.closing_day AS closing_day_9, t0.closing_month AS closing_month_10, t11.id AS id_12, t11.tv AS tv_13, t11.garden AS garden_14, t11.garden_furniture AS garden_furniture_15, t11.iron AS iron_16, t11.fire_place AS fire_place_17, t11.barbacue AS barbacue_18, t11.radio AS radio_19, t11.mini_bar AS mini_bar_20, t11.terrace AS terrace_21, t11.fenced_plot AS fenced_plot_22, t11.security_box AS security_box_23, t11.elevator AS elevator_24, t11.dvd AS dvd_25, t11.balcony AS balcony_26, t11.juice_squeezer AS juice_squeezer_27, t11.electric_kettle AS electric_kettle_28, t11.hair_dryer AS hair_dryer_29, t11.children_area AS children_area_30, t11.gym AS gym_31, t11.alarm AS alarm_32, t11.tennis AS tennis_33, t11.squash AS squash_34, t11.paddel AS paddel_35, t11.sauna AS sauna_36, t11.handicapped_facilities AS handicapped_facilities_37, t11.jacuzzi AS jacuzzi_38, t11.smoking_allowed AS smoking_allowed_39, t11.num_of_televisions AS num_of_televisions_40, t11.num_of_fans AS num_of_fans_41, t11.num_of_electronic_mosquito_repeller AS num_of_electronic_mosquito_repeller_42, t11.window_screens AS window_screens_43, t11.acswimming_pool_id AS acswimming_pool_id_44, t11.tv_satellite_id AS tv_satellite_id_45, t11.ackitchen_id AS ackitchen_id_46, t11.accommodation_id AS accommodation_id_47 FROM ac_swimming_pool t0 LEFT JOIN ac_house_characteristics t11 ON t11.acswimming_pool_id = t0.id WHERE t0.id = 8 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.people_capacity AS people_capacity_2,
  t0.minimum_occupation AS minimum_occupation_3,
  t0.accept_youngsters AS accept_youngsters_4,
  t0.occupation_without_supplement AS occupation_without_supplement_5,
  t0.bedrooms AS bedrooms_6,
  t0.double_beds AS double_beds_7,
  t0.individual_beds AS individual_beds_8,
  t0.individual_sofa_bed AS individual_sofa_bed_9,
  t0.double_sofa_bed AS double_sofa_bed_10,
  t0.queen_beds AS queen_beds_11,
  t0.king_beds AS king_beds_12,
  t0.toilets AS toilets_13,
  t0.bathroom_with_bathtub AS bathroom_with_bathtub_14,
  t0.bathroom_with_shower AS bathroom_with_shower_15,
  t0.berths AS berths_16,
  t0.area_housing AS area_housing_17,
  t0.area_housing_unit AS area_housing_unit_18,
  t0.area_plot AS area_plot_19,
  t0.area_plot_unit AS area_plot_unit_20,
  t0.adults_capacity AS adults_capacity_21,
  t0.accommodation_id AS accommodation_id_22
FROM
  ac_distribution t0
WHERE
  t0.accommodation_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.people_capacity AS people_capacity_2, t0.minimum_occupation AS minimum_occupation_3, t0.accept_youngsters AS accept_youngsters_4, t0.occupation_without_supplement AS occupation_without_supplement_5, t0.bedrooms AS bedrooms_6, t0.double_beds AS double_beds_7, t0.individual_beds AS individual_beds_8, t0.individual_sofa_bed AS individual_sofa_bed_9, t0.double_sofa_bed AS double_sofa_bed_10, t0.queen_beds AS queen_beds_11, t0.king_beds AS king_beds_12, t0.toilets AS toilets_13, t0.bathroom_with_bathtub AS bathroom_with_bathtub_14, t0.bathroom_with_shower AS bathroom_with_shower_15, t0.berths AS berths_16, t0.area_housing AS area_housing_17, t0.area_housing_unit AS area_housing_unit_18, t0.area_plot AS area_plot_19, t0.area_plot_unit AS area_plot_unit_20, t0.adults_capacity AS adults_capacity_21, t0.accommodation_id AS accommodation_id_22 FROM ac_distribution t0 WHERE t0.accommodation_id = 8 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.description AS description_3,
  t0.accommodation_id AS accommodation_id_4
FROM
  description t0
WHERE
  t0.accommodation_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.accommodation_id AS accommodation_id_4 FROM description t0 WHERE t0.accommodation_id = 8;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.name AS name_3,
  t0.code AS code_4,
  t0.locale AS locale_5,
  t0.accommodation_id AS accommodation_id_6
FROM
  extrasincluded t0
WHERE
  t0.accommodation_id = ?
  AND t0.locale = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.name AS name_3, t0.code AS code_4, t0.locale AS locale_5, t0.accommodation_id AS accommodation_id_6 FROM extrasincluded t0 WHERE t0.accommodation_id = 8 AND t0.locale = 'pt';