Symfony Profiler

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.id = ?

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.id = '917';

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.type_event AS type_event_3,
  t0.ref AS ref_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.website AS website_7,
  t0.stars AS stars_8,
  t0.you_tube_video_id AS you_tube_video_id_9,
  t0.phone AS phone_10,
  t0.email AS email_11,
  t0.reservation_email AS reservation_email_12,
  t0.accompanist_email AS accompanist_email_13,
  t0.trip_advisor_widget AS trip_advisor_widget_14,
  t0.min_nights AS min_nights_15,
  t0.google_map_url AS google_map_url_16,
  t0.check_in_time AS check_in_time_17,
  t0.check_out_time AS check_out_time_18,
  t0.teen_age_max AS teen_age_max_19,
  t0.child_age_max AS child_age_max_20,
  t0.baby_age_max AS baby_age_max_21,
  t0.margin AS margin_22,
  t0.free_for_children_sharing_room AS free_for_children_sharing_room_23,
  t0.free_age_min AS free_age_min_24,
  t0.free_age_max AS free_age_max_25,
  t0.strict_departure_countries AS strict_departure_countries_26,
  t0.hotel_only_disable AS hotel_only_disable_27,
  t0.active AS active_28,
  t0.created_uid AS created_uid_29,
  t0.updated_uid AS updated_uid_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.contact_name AS contact_name_33,
  t0.contact_email AS contact_email_34,
  t0.contact_phone AS contact_phone_35,
  t0.contact_role AS contact_role_36,
  t0.address_line_1 AS address_line_1_37,
  t0.address_line_2 AS address_line_2_38,
  t0.address_postal_code AS address_postal_code_39,
  t0.address_city AS address_city_40,
  t0.address_country AS address_country_41,
  t0.pension_type_id AS pension_type_id_42,
  t0.default_formule_id AS default_formule_id_43,
  t0.default_supplement_id AS default_supplement_id_44,
  t0.booking_fee_id AS booking_fee_id_45,
  t0.country_id AS country_id_46,
  t0.home_image_id AS home_image_id_47,
  t0.main_image_id AS main_image_id_48,
  t0.gallery_id AS gallery_id_49
FROM
  hotel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.type_event AS type_event_3, t0.ref AS ref_4, t0.name AS name_5, t0.description AS description_6, t0.website AS website_7, t0.stars AS stars_8, t0.you_tube_video_id AS you_tube_video_id_9, t0.phone AS phone_10, t0.email AS email_11, t0.reservation_email AS reservation_email_12, t0.accompanist_email AS accompanist_email_13, t0.trip_advisor_widget AS trip_advisor_widget_14, t0.min_nights AS min_nights_15, t0.google_map_url AS google_map_url_16, t0.check_in_time AS check_in_time_17, t0.check_out_time AS check_out_time_18, t0.teen_age_max AS teen_age_max_19, t0.child_age_max AS child_age_max_20, t0.baby_age_max AS baby_age_max_21, t0.margin AS margin_22, t0.free_for_children_sharing_room AS free_for_children_sharing_room_23, t0.free_age_min AS free_age_min_24, t0.free_age_max AS free_age_max_25, t0.strict_departure_countries AS strict_departure_countries_26, t0.hotel_only_disable AS hotel_only_disable_27, t0.active AS active_28, t0.created_uid AS created_uid_29, t0.updated_uid AS updated_uid_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.contact_name AS contact_name_33, t0.contact_email AS contact_email_34, t0.contact_phone AS contact_phone_35, t0.contact_role AS contact_role_36, t0.address_line_1 AS address_line_1_37, t0.address_line_2 AS address_line_2_38, t0.address_postal_code AS address_postal_code_39, t0.address_city AS address_city_40, t0.address_country AS address_country_41, t0.pension_type_id AS pension_type_id_42, t0.default_formule_id AS default_formule_id_43, t0.default_supplement_id AS default_supplement_id_44, t0.booking_fee_id AS booking_fee_id_45, t0.country_id AS country_id_46, t0.home_image_id AS home_image_id_47, t0.main_image_id AS main_image_id_48, t0.gallery_id AS gallery_id_49 FROM hotel t0 WHERE t0.id = 261;

SELECT
  t0.id AS id_1,
  t0.iso_code AS iso_code_2,
  t0.name AS name_3,
  t0.country AS country_4,
  t0.active AS active_5,
  t0.display_home AS display_home_6,
  t0.sort AS sort_7,
  t0.city_id AS city_id_8,
  t0.zone_id AS zone_id_9,
  t0.main_image_id AS main_image_id_10,
  t0.gallery_id AS gallery_id_11
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.iso_code AS iso_code_2, t0.name AS name_3, t0.country AS country_4, t0.active AS active_5, t0.display_home AS display_home_6, t0.sort AS sort_7, t0.city_id AS city_id_8, t0.zone_id AS zone_id_9, t0.main_image_id AS main_image_id_10, t0.gallery_id AS gallery_id_11 FROM country t0 WHERE t0.id = 4;

SELECT
  t0.name AS name_1,
  t0.context AS context_2,
  t0.default_format AS default_format_3,
  t0.enabled AS enabled_4,
  t0.updated_at AS updated_at_5,
  t0.created_at AS created_at_6,
  t0.id AS id_7,
  t0.for_tag_id AS for_tag_id_8
FROM
  media__gallery t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.context AS context_2, t0.default_format AS default_format_3, t0.enabled AS enabled_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.id AS id_7, t0.for_tag_id AS for_tag_id_8 FROM media__gallery t0 WHERE t0.id = 859;

SELECT
  t0.position AS position_1,
  t0.enabled AS enabled_2,
  t0.updated_at AS updated_at_3,
  t0.created_at AS created_at_4,
  t0.id AS id_5,
  t0.gallery_id AS gallery_id_6,
  t0.media_id AS media_id_7
FROM
  media__gallery_item t0
WHERE
  t0.gallery_id = ?
ORDER BY
  t0.position ASC

SELECT t0.position AS position_1, t0.enabled AS enabled_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.id AS id_5, t0.gallery_id AS gallery_id_6, t0.media_id AS media_id_7 FROM media__gallery_item t0 WHERE t0.gallery_id = 859 ORDER BY t0.position ASC;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 5086;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 5816;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.meta_description AS meta_description_3,
  t0.title AS title_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  page t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM page t0 WHERE t0.name = 'home' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.label AS label_1,
  s0_.resume AS resume_2,
  s0_.description AS description_3,
  s0_.eventStart AS eventStart_4,
  s0_.eventEnd AS eventEnd_5,
  s0_.sale_start AS sale_start_6,
  s0_.sale_end AS sale_end_7,
  s0_.active AS active_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10,
  s0_.event_thumbnail_id AS event_thumbnail_id_11,
  s0_.event_banner_id AS event_banner_id_12
FROM
  special_event s0_
WHERE
  s0_.sale_start <= ?
  AND ? <= s0_.sale_end
  AND s0_.active = ?

SELECT s0_.id AS id_0, s0_.label AS label_1, s0_.resume AS resume_2, s0_.description AS description_3, s0_.eventStart AS eventStart_4, s0_.eventEnd AS eventEnd_5, s0_.sale_start AS sale_start_6, s0_.sale_end AS sale_end_7, s0_.active AS active_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.event_thumbnail_id AS event_thumbnail_id_11, s0_.event_banner_id AS event_banner_id_12 FROM special_event s0_ WHERE s0_.sale_start <= '2026-07-27' AND '2026-07-27' <= s0_.sale_end AND s0_.active = 1;

SELECT
  c0_.id AS id_0,
  c0_.iso_code AS iso_code_1,
  c0_.name AS name_2,
  c0_.country AS country_3,
  c0_.active AS active_4,
  c0_.display_home AS display_home_5,
  c0_.sort AS sort_6,
  c0_.city_id AS city_id_7,
  c0_.zone_id AS zone_id_8,
  c0_.main_image_id AS main_image_id_9,
  c0_.gallery_id AS gallery_id_10
FROM
  country c0_
  INNER JOIN iata_city i1_ ON c0_.city_id = i1_.id
WHERE
  c0_.active = 1
  AND c0_.display_home = 1
ORDER BY
  c0_.sort ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.iso_code AS iso_code_1, c0_.name AS name_2, c0_.country AS country_3, c0_.active AS active_4, c0_.display_home AS display_home_5, c0_.sort AS sort_6, c0_.city_id AS city_id_7, c0_.zone_id AS zone_id_8, c0_.main_image_id AS main_image_id_9, c0_.gallery_id AS gallery_id_10 FROM country c0_ INNER JOIN iata_city i1_ ON c0_.city_id = i1_.id WHERE c0_.active = 1 AND c0_.display_home = 1 ORDER BY c0_.sort ASC, c0_.name ASC;