Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.sort AS sort_6,
  t0.room_capacity AS room_capacity_7,
  t0.room_area AS room_area_8,
  t0.motivator AS motivator_9,
  t0.choosing_bad AS choosing_bad_10,
  t0.ulid AS ulid_11,
  t0.max_main_place AS max_main_place_12,
  t0.for_storage AS for_storage_13,
  t0.baby_without_place AS baby_without_place_14,
  t0.tour AS tour_15,
  t0.video AS video_16,
  t0.hotel_id AS hotel_id_17,
  t0.building_id AS building_id_18
FROM
  hotel_room_type t0
WHERE
  t0.code = ?
  AND t0.hotel_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.code = 'STD' AND t0.hotel_id = 32 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.hotel_room_type_id AS hotel_room_type_id_3
FROM
  hotel_room_type_image t0
WHERE
  t0.hotel_room_type_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.hotel_room_type_id AS hotel_room_type_id_3 FROM hotel_room_type_image t0 WHERE t0.hotel_room_type_id = 69;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.sort AS sort_4,
  t0.hotel_id AS hotel_id_5,
  t0.category_id AS category_id_6
FROM
  hotel_room_type_equipment t0
  INNER JOIN hotel_room_type_equipment_hotel_room_type ON t0.id = hotel_room_type_equipment_hotel_room_type.hotel_room_type_equipment_id
WHERE
  hotel_room_type_equipment_hotel_room_type.hotel_room_type_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.sort AS sort_4, t0.hotel_id AS hotel_id_5, t0.category_id AS category_id_6 FROM hotel_room_type_equipment t0 INNER JOIN hotel_room_type_equipment_hotel_room_type ON t0.id = hotel_room_type_equipment_hotel_room_type.hotel_room_type_equipment_id WHERE hotel_room_type_equipment_hotel_room_type.hotel_room_type_id = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.sort AS sort_6,
  t0.room_capacity AS room_capacity_7,
  t0.room_area AS room_area_8,
  t0.motivator AS motivator_9,
  t0.choosing_bad AS choosing_bad_10,
  t0.ulid AS ulid_11,
  t0.max_main_place AS max_main_place_12,
  t0.for_storage AS for_storage_13,
  t0.baby_without_place AS baby_without_place_14,
  t0.tour AS tour_15,
  t0.video AS video_16,
  t0.hotel_id AS hotel_id_17,
  t0.building_id AS building_id_18
FROM
  hotel_room_type t0
WHERE
  t0.hotel_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.hotel_id = 32 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.deleted AS deleted_4,
  t0.api_url AS api_url_5,
  t0.second_api_url AS second_api_url_6,
  t0.email AS email_7,
  t0.phone AS phone_8,
  t0.whatsapp AS whatsapp_9,
  t0.tax_type AS tax_type_10,
  t0.logo_image AS logo_image_11,
  t0.icon_image AS icon_image_12,
  t0.output_type AS output_type_13,
  t0.slug AS slug_14,
  t0.emails_notification AS emails_notification_15,
  t0.max_age_child AS max_age_child_16,
  t0.accommodation_child_text AS accommodation_child_text_17,
  t0.site AS site_18,
  t0.time_from AS time_from_19,
  t0.time_to AS time_to_20,
  t0.interactions_id AS interactions_id_21,
  t0.pms_type AS pms_type_22,
  t0.resort_fee AS resort_fee_23,
  t0.request_reservation_id AS request_reservation_id_24,
  t0.reservation_id AS reservation_id_25,
  t0.external_terminal_id AS external_terminal_id_26,
  t0.work_time_start AS work_time_start_27,
  t0.vk AS vk_28,
  t0.telegram AS telegram_29,
  t0.address AS address_30,
  t0.active AS active_31,
  t0.for_storage AS for_storage_32,
  t0.company_id AS company_id_33
FROM
  hotel t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.deleted AS deleted_4, t0.api_url AS api_url_5, t0.second_api_url AS second_api_url_6, t0.email AS email_7, t0.phone AS phone_8, t0.whatsapp AS whatsapp_9, t0.tax_type AS tax_type_10, t0.logo_image AS logo_image_11, t0.icon_image AS icon_image_12, t0.output_type AS output_type_13, t0.slug AS slug_14, t0.emails_notification AS emails_notification_15, t0.max_age_child AS max_age_child_16, t0.accommodation_child_text AS accommodation_child_text_17, t0.site AS site_18, t0.time_from AS time_from_19, t0.time_to AS time_to_20, t0.interactions_id AS interactions_id_21, t0.pms_type AS pms_type_22, t0.resort_fee AS resort_fee_23, t0.request_reservation_id AS request_reservation_id_24, t0.reservation_id AS reservation_id_25, t0.external_terminal_id AS external_terminal_id_26, t0.work_time_start AS work_time_start_27, t0.vk AS vk_28, t0.telegram AS telegram_29, t0.address AS address_30, t0.active AS active_31, t0.for_storage AS for_storage_32, t0.company_id AS company_id_33 FROM hotel t0 WHERE t0.slug = 'more.stage.mind4.me' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.second_code AS second_code_4,
  t0.description AS description_5,
  t0.short_description AS short_description_6,
  t0.active AS active_7,
  t0.main AS main_8,
  t0.period_from AS period_from_9,
  t0.period_to AS period_to_10,
  t0.vat_type AS vat_type_11,
  t0.service_description AS service_description_12,
  t0.promo_code AS promo_code_13,
  t0.icon_image AS icon_image_14,
  t0.sort AS sort_15,
  t0.time_from AS time_from_16,
  t0.time_to AS time_to_17,
  t0.hide_main AS hide_main_18,
  t0.source_profile AS source_profile_19,
  t0.source AS source_20,
  t0.structure_guests AS structure_guests_21,
  t0.free_kids AS free_kids_22,
  t0.ulid AS ulid_23,
  t0.for_storage AS for_storage_24,
  t0.hotel_id AS hotel_id_25,
  t0.default_payment_id AS default_payment_id_26,
  t0.rules_pay_back_id AS rules_pay_back_id_27
FROM
  hotel_rate t0
WHERE
  t0.hotel_id = ?
  AND t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.second_code AS second_code_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.active AS active_7, t0.main AS main_8, t0.period_from AS period_from_9, t0.period_to AS period_to_10, t0.vat_type AS vat_type_11, t0.service_description AS service_description_12, t0.promo_code AS promo_code_13, t0.icon_image AS icon_image_14, t0.sort AS sort_15, t0.time_from AS time_from_16, t0.time_to AS time_to_17, t0.hide_main AS hide_main_18, t0.source_profile AS source_profile_19, t0.source AS source_20, t0.structure_guests AS structure_guests_21, t0.free_kids AS free_kids_22, t0.ulid AS ulid_23, t0.for_storage AS for_storage_24, t0.hotel_id AS hotel_id_25, t0.default_payment_id AS default_payment_id_26, t0.rules_pay_back_id AS rules_pay_back_id_27 FROM hotel_rate t0 WHERE t0.hotel_id = 32 AND t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.count AS count_3,
  t0.hotel_room_type_id AS hotel_room_type_id_4
FROM
  category_restriction_day t0
WHERE
  t0.hotel_room_type_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.count AS count_3, t0.hotel_room_type_id AS hotel_room_type_id_4 FROM category_restriction_day t0 WHERE t0.hotel_room_type_id = 69;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.deleted AS deleted_4,
  t0.api_url AS api_url_5,
  t0.second_api_url AS second_api_url_6,
  t0.email AS email_7,
  t0.phone AS phone_8,
  t0.whatsapp AS whatsapp_9,
  t0.tax_type AS tax_type_10,
  t0.logo_image AS logo_image_11,
  t0.icon_image AS icon_image_12,
  t0.output_type AS output_type_13,
  t0.slug AS slug_14,
  t0.emails_notification AS emails_notification_15,
  t0.max_age_child AS max_age_child_16,
  t0.accommodation_child_text AS accommodation_child_text_17,
  t0.site AS site_18,
  t0.time_from AS time_from_19,
  t0.time_to AS time_to_20,
  t0.interactions_id AS interactions_id_21,
  t0.pms_type AS pms_type_22,
  t0.resort_fee AS resort_fee_23,
  t0.request_reservation_id AS request_reservation_id_24,
  t0.reservation_id AS reservation_id_25,
  t0.external_terminal_id AS external_terminal_id_26,
  t0.work_time_start AS work_time_start_27,
  t0.vk AS vk_28,
  t0.telegram AS telegram_29,
  t0.address AS address_30,
  t0.active AS active_31,
  t0.for_storage AS for_storage_32,
  t0.company_id AS company_id_33
FROM
  hotel t0
WHERE
  t0.slug = ?
  AND t0.deleted = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.deleted AS deleted_4, t0.api_url AS api_url_5, t0.second_api_url AS second_api_url_6, t0.email AS email_7, t0.phone AS phone_8, t0.whatsapp AS whatsapp_9, t0.tax_type AS tax_type_10, t0.logo_image AS logo_image_11, t0.icon_image AS icon_image_12, t0.output_type AS output_type_13, t0.slug AS slug_14, t0.emails_notification AS emails_notification_15, t0.max_age_child AS max_age_child_16, t0.accommodation_child_text AS accommodation_child_text_17, t0.site AS site_18, t0.time_from AS time_from_19, t0.time_to AS time_to_20, t0.interactions_id AS interactions_id_21, t0.pms_type AS pms_type_22, t0.resort_fee AS resort_fee_23, t0.request_reservation_id AS request_reservation_id_24, t0.reservation_id AS reservation_id_25, t0.external_terminal_id AS external_terminal_id_26, t0.work_time_start AS work_time_start_27, t0.vk AS vk_28, t0.telegram AS telegram_29, t0.address AS address_30, t0.active AS active_31, t0.for_storage AS for_storage_32, t0.company_id AS company_id_33 FROM hotel t0 WHERE t0.slug = 'more.stage.mind4.me' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort AS sort_3,
  t0.column_number AS column_number_4,
  t0.hotel_id AS hotel_id_5
FROM
  hotel_room_type_equipment_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3, t0.column_number AS column_number_4, t0.hotel_id AS hotel_id_5 FROM hotel_room_type_equipment_category t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.sort AS sort_6,
  t0.room_capacity AS room_capacity_7,
  t0.room_area AS room_area_8,
  t0.motivator AS motivator_9,
  t0.choosing_bad AS choosing_bad_10,
  t0.ulid AS ulid_11,
  t0.max_main_place AS max_main_place_12,
  t0.for_storage AS for_storage_13,
  t0.baby_without_place AS baby_without_place_14,
  t0.tour AS tour_15,
  t0.video AS video_16,
  t0.hotel_id AS hotel_id_17,
  t0.building_id AS building_id_18
FROM
  hotel_room_type t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.hotel_id = 32;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.sort AS sort_6,
  t0.room_capacity AS room_capacity_7,
  t0.room_area AS room_area_8,
  t0.motivator AS motivator_9,
  t0.choosing_bad AS choosing_bad_10,
  t0.ulid AS ulid_11,
  t0.max_main_place AS max_main_place_12,
  t0.for_storage AS for_storage_13,
  t0.baby_without_place AS baby_without_place_14,
  t0.tour AS tour_15,
  t0.video AS video_16,
  t0.hotel_id AS hotel_id_17,
  t0.building_id AS building_id_18
FROM
  hotel_room_type t0
  INNER JOIN hotel_room_type_hotel_rate ON t0.id = hotel_room_type_hotel_rate.hotel_room_type_id
WHERE
  hotel_room_type_hotel_rate.hotel_rate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 INNER JOIN hotel_room_type_hotel_rate ON t0.id = hotel_room_type_hotel_rate.hotel_room_type_id WHERE hotel_room_type_hotel_rate.hotel_rate_id = 19;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.period_show_from AS period_show_from_3,
  t0.period_show_to AS period_show_to_4,
  t0.hotel_id AS hotel_id_5
FROM
  discount_item t0
  INNER JOIN discount_item_hotel_rate ON t0.id = discount_item_hotel_rate.discount_item_id
WHERE
  discount_item_hotel_rate.hotel_rate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.period_show_from AS period_show_from_3, t0.period_show_to AS period_show_to_4, t0.hotel_id AS hotel_id_5 FROM discount_item t0 INNER JOIN discount_item_hotel_rate ON t0.id = discount_item_hotel_rate.discount_item_id WHERE discount_item_hotel_rate.hotel_rate_id = 19;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_3,
  t0.min_age AS min_age_4,
  t0.max_age AS max_age_5,
  t0.hotel_id AS hotel_id_6
FROM
  type_age t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.min_age AS min_age_4, t0.max_age AS max_age_5, t0.hotel_id AS hotel_id_6 FROM type_age t0 WHERE t0.hotel_id = 32;

SELECT
  t0.id AS id_1,
  t0.data AS data_2,
  t0.type AS type_3,
  t0.value AS value_4,
  t0.discount_item_id AS discount_item_id_5
FROM
  discount_day t0
WHERE
  t0.discount_item_id = ?

SELECT t0.id AS id_1, t0.data AS data_2, t0.type AS type_3, t0.value AS value_4, t0.discount_item_id AS discount_item_id_5 FROM discount_day t0 WHERE t0.discount_item_id = 28;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.stop_sale AS stop_sale_3,
  t0.min_los AS min_los_4,
  t0.max_los AS max_los_5,
  t0.min_adv_booking AS min_adv_booking_6,
  t0.max_adv_booking AS max_adv_booking_7,
  t0.ctd AS ctd_8,
  t0.cta AS cta_9,
  t0.restriction_item_id AS restriction_item_id_10,
  t0.hotel_rate_id AS hotel_rate_id_11
FROM
  restriction_day t0
WHERE
  t0.hotel_rate_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.stop_sale AS stop_sale_3, t0.min_los AS min_los_4, t0.max_los AS max_los_5, t0.min_adv_booking AS min_adv_booking_6, t0.max_adv_booking AS max_adv_booking_7, t0.ctd AS ctd_8, t0.cta AS cta_9, t0.restriction_item_id AS restriction_item_id_10, t0.hotel_rate_id AS hotel_rate_id_11 FROM restriction_day t0 WHERE t0.hotel_rate_id = 19;