Symfony Profiler

SELECT
  h0_.id AS id_0,
  h0_.type AS type_1,
  h0_.type_event AS type_event_2,
  h0_.ref AS ref_3,
  h0_.name AS name_4,
  h0_.description AS description_5,
  h0_.website AS website_6,
  h0_.stars AS stars_7,
  h0_.you_tube_video_id AS you_tube_video_id_8,
  h0_.phone AS phone_9,
  h0_.email AS email_10,
  h0_.reservation_email AS reservation_email_11,
  h0_.accompanist_email AS accompanist_email_12,
  h0_.trip_advisor_widget AS trip_advisor_widget_13,
  h0_.min_nights AS min_nights_14,
  h0_.google_map_url AS google_map_url_15,
  h0_.check_in_time AS check_in_time_16,
  h0_.check_out_time AS check_out_time_17,
  h0_.teen_age_max AS teen_age_max_18,
  h0_.child_age_max AS child_age_max_19,
  h0_.baby_age_max AS baby_age_max_20,
  h0_.margin AS margin_21,
  h0_.free_for_children_sharing_room AS free_for_children_sharing_room_22,
  h0_.free_age_min AS free_age_min_23,
  h0_.free_age_max AS free_age_max_24,
  h0_.strict_departure_countries AS strict_departure_countries_25,
  h0_.hotel_only_disable AS hotel_only_disable_26,
  h0_.active AS active_27,
  h0_.created_uid AS created_uid_28,
  h0_.updated_uid AS updated_uid_29,
  h0_.created_at AS created_at_30,
  h0_.updated_at AS updated_at_31,
  h0_.contact_name AS contact_name_32,
  h0_.contact_email AS contact_email_33,
  h0_.contact_phone AS contact_phone_34,
  h0_.contact_role AS contact_role_35,
  h0_.address_line_1 AS address_line_1_36,
  h0_.address_line_2 AS address_line_2_37,
  h0_.address_postal_code AS address_postal_code_38,
  h0_.address_city AS address_city_39,
  h0_.address_country AS address_country_40,
  h0_.pension_type_id AS pension_type_id_41,
  h0_.default_formule_id AS default_formule_id_42,
  h0_.default_supplement_id AS default_supplement_id_43,
  h0_.booking_fee_id AS booking_fee_id_44,
  h0_.country_id AS country_id_45,
  h0_.home_image_id AS home_image_id_46,
  h0_.main_image_id AS main_image_id_47,
  h0_.gallery_id AS gallery_id_48
FROM
  hotel h0_
WHERE
  h0_.active = 1

SELECT h0_.id AS id_0, h0_.type AS type_1, h0_.type_event AS type_event_2, h0_.ref AS ref_3, h0_.name AS name_4, h0_.description AS description_5, h0_.website AS website_6, h0_.stars AS stars_7, h0_.you_tube_video_id AS you_tube_video_id_8, h0_.phone AS phone_9, h0_.email AS email_10, h0_.reservation_email AS reservation_email_11, h0_.accompanist_email AS accompanist_email_12, h0_.trip_advisor_widget AS trip_advisor_widget_13, h0_.min_nights AS min_nights_14, h0_.google_map_url AS google_map_url_15, h0_.check_in_time AS check_in_time_16, h0_.check_out_time AS check_out_time_17, h0_.teen_age_max AS teen_age_max_18, h0_.child_age_max AS child_age_max_19, h0_.baby_age_max AS baby_age_max_20, h0_.margin AS margin_21, h0_.free_for_children_sharing_room AS free_for_children_sharing_room_22, h0_.free_age_min AS free_age_min_23, h0_.free_age_max AS free_age_max_24, h0_.strict_departure_countries AS strict_departure_countries_25, h0_.hotel_only_disable AS hotel_only_disable_26, h0_.active AS active_27, h0_.created_uid AS created_uid_28, h0_.updated_uid AS updated_uid_29, h0_.created_at AS created_at_30, h0_.updated_at AS updated_at_31, h0_.contact_name AS contact_name_32, h0_.contact_email AS contact_email_33, h0_.contact_phone AS contact_phone_34, h0_.contact_role AS contact_role_35, h0_.address_line_1 AS address_line_1_36, h0_.address_line_2 AS address_line_2_37, h0_.address_postal_code AS address_postal_code_38, h0_.address_city AS address_city_39, h0_.address_country AS address_country_40, h0_.pension_type_id AS pension_type_id_41, h0_.default_formule_id AS default_formule_id_42, h0_.default_supplement_id AS default_supplement_id_43, h0_.booking_fee_id AS booking_fee_id_44, h0_.country_id AS country_id_45, h0_.home_image_id AS home_image_id_46, h0_.main_image_id AS main_image_id_47, h0_.gallery_id AS gallery_id_48 FROM hotel h0_ WHERE h0_.active = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.inclusions AS inclusions_5,
  t0.exclusions AS exclusions_6,
  t0.departure_date AS departure_date_7,
  t0.returning_date AS returning_date_8,
  t0.length_in_days AS length_in_days_9,
  t0.other_dates AS other_dates_10,
  t0.country AS country_11,
  t0.country_description AS country_description_12,
  t0.price AS price_13,
  t0.price_starting_at AS price_starting_at_14,
  t0.price_label AS price_label_15,
  t0.specifications AS specifications_16,
  t0.conditions AS conditions_17,
  t0.comment AS comment_18,
  t0.active AS active_19,
  t0.created_uid AS created_uid_20,
  t0.updated_uid AS updated_uid_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.main_image_id AS main_image_id_24,
  t0.gallery_id AS gallery_id_25
FROM
  tour t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.inclusions AS inclusions_5, t0.exclusions AS exclusions_6, t0.departure_date AS departure_date_7, t0.returning_date AS returning_date_8, t0.length_in_days AS length_in_days_9, t0.other_dates AS other_dates_10, t0.country AS country_11, t0.country_description AS country_description_12, t0.price AS price_13, t0.price_starting_at AS price_starting_at_14, t0.price_label AS price_label_15, t0.specifications AS specifications_16, t0.conditions AS conditions_17, t0.comment AS comment_18, t0.active AS active_19, t0.created_uid AS created_uid_20, t0.updated_uid AS updated_uid_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.main_image_id AS main_image_id_24, t0.gallery_id AS gallery_id_25 FROM tour t0 WHERE t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.has_separate_bedroom AS has_separate_bedroom_4,
  t0.services AS services_5,
  t0.active AS active_6,
  t0.position AS position_7,
  t0.hotel_id AS hotel_id_8,
  t0.main_image_id AS main_image_id_9,
  t0.gallery_id AS gallery_id_10
FROM
  room t0
WHERE
  (
    t0.active = ?
    AND t0.hotel_id = ?
  )
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.has_separate_bedroom AS has_separate_bedroom_4, t0.services AS services_5, t0.active AS active_6, t0.position AS position_7, t0.hotel_id AS hotel_id_8, t0.main_image_id AS main_image_id_9, t0.gallery_id AS gallery_id_10 FROM room t0 WHERE (t0.active = 1 AND t0.hotel_id = 4) ORDER BY t0.id ASC;