Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.post_code AS post_code_1,
  e0_.facebook_link AS facebook_link_2,
  e0_.instagram_link AS instagram_link_3,
  e0_.pinterest_link AS pinterest_link_4,
  e0_.linkedin_link AS linkedin_link_5,
  e0_.tiktok_link AS tiktok_link_6,
  e0_.youtube_link AS youtube_link_7,
  e0_.vimeo_link AS vimeo_link_8,
  e0_.email_link AS email_link_9,
  e0_.phone_link AS phone_link_10,
  e0_.email_order AS email_order_11,
  e0_.mollie_api_key AS mollie_api_key_12,
  e0_.image AS image_13,
  e0_.is_active AS is_active_14,
  e0_.sort AS sort_15,
  e1_.id AS id_16,
  e1_.title AS title_17,
  e1_.slug AS slug_18,
  e1_.short_title AS short_title_19,
  e1_.sub_title AS sub_title_20,
  e1_.address AS address_21,
  e1_.city AS city_22,
  e1_.country AS country_23,
  e1_.schedule AS schedule_24,
  e1_.additional_information AS additional_information_25,
  e1_.seo_title AS seo_title_26,
  e1_.seo_description AS seo_description_27,
  e1_.seo_image AS seo_image_28,
  e1_.locale AS locale_29,
  r2_.id AS id_30,
  r2_.minimum_number_of_people AS minimum_number_of_people_31,
  r2_.maximum_number_of_people AS maximum_number_of_people_32,
  r2_.percentage_of_deposit AS percentage_of_deposit_33,
  r2_.minimum_price_with_tax AS minimum_price_with_tax_34,
  r2_.sort AS sort_35,
  r2_.background_color_checkout AS background_color_checkout_36,
  r3_.id AS id_37,
  r3_.title AS title_38,
  r3_.slug AS slug_39,
  r3_.seo_title AS seo_title_40,
  r3_.seo_description AS seo_description_41,
  r3_.seo_image AS seo_image_42,
  r3_.locale AS locale_43,
  r4_.id AS id_44,
  r4_.day_of_week AS day_of_week_45,
  r4_.hour_begin AS hour_begin_46,
  r4_.hour_end AS hour_end_47,
  r4_.date_begin AS date_begin_48,
  r4_.date_end AS date_end_49,
  r4_.price_with_tax AS price_with_tax_50,
  r4_.sort AS sort_51,
  r5_.id AS id_52,
  r5_.image AS image_53,
  r5_.sort AS sort_54,
  a6_.id AS id_55,
  a6_.duration AS duration_56,
  a6_.days_of_week AS days_of_week_57,
  a6_.is_price_depend_number_of_people AS is_price_depend_number_of_people_58,
  a6_.price_per_person AS price_per_person_59,
  a6_.is_price_supplement AS is_price_supplement_60,
  a6_.price_supplement_type AS price_supplement_type_61,
  a6_.price_supplement_value AS price_supplement_value_62,
  a6_.duration_between_booking AS duration_between_booking_63,
  a6_.sort AS sort_64,
  a7_.id AS id_65,
  a7_.title AS title_66,
  a7_.description AS description_67,
  a7_.message_error AS message_error_68,
  a7_.locale AS locale_69,
  e1_.translatable_id AS translatable_id_70,
  r2_.establishment_id AS establishment_id_71,
  r3_.translatable_id AS translatable_id_72,
  r4_.room_id AS room_id_73,
  r5_.room_id AS room_id_74,
  a7_.translatable_id AS translatable_id_75
FROM
  establishment e0_
  LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id
  AND (e1_.locale = ?)
  LEFT JOIN room r2_ ON e0_.id = r2_.establishment_id
  LEFT JOIN room_translation r3_ ON r2_.id = r3_.translatable_id
  AND (r3_.locale = ?)
  LEFT JOIN room_price r4_ ON r2_.id = r4_.room_id
  LEFT JOIN room_image r5_ ON r2_.id = r5_.room_id
  LEFT JOIN activity_room a8_ ON r2_.id = a8_.room_id
  LEFT JOIN activity a6_ ON a6_.id = a8_.activity_id
  LEFT JOIN activity_translation a7_ ON a6_.id = a7_.translatable_id
  AND (a7_.locale = ?)
WHERE
  e0_.is_active = ?
  AND e1_.slug = ?
ORDER BY
  e0_.sort ASC,
  r2_.sort ASC,
  r4_.sort ASC,
  r5_.sort ASC

SELECT e0_.id AS id_0, e0_.post_code AS post_code_1, e0_.facebook_link AS facebook_link_2, e0_.instagram_link AS instagram_link_3, e0_.pinterest_link AS pinterest_link_4, e0_.linkedin_link AS linkedin_link_5, e0_.tiktok_link AS tiktok_link_6, e0_.youtube_link AS youtube_link_7, e0_.vimeo_link AS vimeo_link_8, e0_.email_link AS email_link_9, e0_.phone_link AS phone_link_10, e0_.email_order AS email_order_11, e0_.mollie_api_key AS mollie_api_key_12, e0_.image AS image_13, e0_.is_active AS is_active_14, e0_.sort AS sort_15, e1_.id AS id_16, e1_.title AS title_17, e1_.slug AS slug_18, e1_.short_title AS short_title_19, e1_.sub_title AS sub_title_20, e1_.address AS address_21, e1_.city AS city_22, e1_.country AS country_23, e1_.schedule AS schedule_24, e1_.additional_information AS additional_information_25, e1_.seo_title AS seo_title_26, e1_.seo_description AS seo_description_27, e1_.seo_image AS seo_image_28, e1_.locale AS locale_29, r2_.id AS id_30, r2_.minimum_number_of_people AS minimum_number_of_people_31, r2_.maximum_number_of_people AS maximum_number_of_people_32, r2_.percentage_of_deposit AS percentage_of_deposit_33, r2_.minimum_price_with_tax AS minimum_price_with_tax_34, r2_.sort AS sort_35, r2_.background_color_checkout AS background_color_checkout_36, r3_.id AS id_37, r3_.title AS title_38, r3_.slug AS slug_39, r3_.seo_title AS seo_title_40, r3_.seo_description AS seo_description_41, r3_.seo_image AS seo_image_42, r3_.locale AS locale_43, r4_.id AS id_44, r4_.day_of_week AS day_of_week_45, r4_.hour_begin AS hour_begin_46, r4_.hour_end AS hour_end_47, r4_.date_begin AS date_begin_48, r4_.date_end AS date_end_49, r4_.price_with_tax AS price_with_tax_50, r4_.sort AS sort_51, r5_.id AS id_52, r5_.image AS image_53, r5_.sort AS sort_54, a6_.id AS id_55, a6_.duration AS duration_56, a6_.days_of_week AS days_of_week_57, a6_.is_price_depend_number_of_people AS is_price_depend_number_of_people_58, a6_.price_per_person AS price_per_person_59, a6_.is_price_supplement AS is_price_supplement_60, a6_.price_supplement_type AS price_supplement_type_61, a6_.price_supplement_value AS price_supplement_value_62, a6_.duration_between_booking AS duration_between_booking_63, a6_.sort AS sort_64, a7_.id AS id_65, a7_.title AS title_66, a7_.description AS description_67, a7_.message_error AS message_error_68, a7_.locale AS locale_69, e1_.translatable_id AS translatable_id_70, r2_.establishment_id AS establishment_id_71, r3_.translatable_id AS translatable_id_72, r4_.room_id AS room_id_73, r5_.room_id AS room_id_74, a7_.translatable_id AS translatable_id_75 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id AND (e1_.locale = 'nl') LEFT JOIN room r2_ ON e0_.id = r2_.establishment_id LEFT JOIN room_translation r3_ ON r2_.id = r3_.translatable_id AND (r3_.locale = 'nl') LEFT JOIN room_price r4_ ON r2_.id = r4_.room_id LEFT JOIN room_image r5_ ON r2_.id = r5_.room_id LEFT JOIN activity_room a8_ ON r2_.id = a8_.room_id LEFT JOIN activity a6_ ON a6_.id = a8_.activity_id LEFT JOIN activity_translation a7_ ON a6_.id = a7_.translatable_id AND (a7_.locale = 'nl') WHERE e0_.is_active = 1 AND e1_.slug = 'boa-karaoke-brussel-centrum' ORDER BY e0_.sort ASC, r2_.sort ASC, r4_.sort ASC, r5_.sort ASC;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.percent_value AS percent_value_2,
  f0_.available_hours_before_booking AS available_hours_before_booking_3,
  f0_.is_active AS is_active_4,
  r1_.id AS id_5,
  r1_.minimum_number_of_people AS minimum_number_of_people_6,
  r1_.maximum_number_of_people AS maximum_number_of_people_7,
  r1_.percentage_of_deposit AS percentage_of_deposit_8,
  r1_.minimum_price_with_tax AS minimum_price_with_tax_9,
  r1_.sort AS sort_10,
  r1_.background_color_checkout AS background_color_checkout_11,
  r1_.establishment_id AS establishment_id_12
FROM
  flash_sale f0_
  INNER JOIN flash_sale_room f2_ ON f0_.id = f2_.flash_sale_id
  INNER JOIN room r1_ ON r1_.id = f2_.room_id
  INNER JOIN flash_sale_activity f4_ ON f0_.id = f4_.flash_sale_id
  INNER JOIN activity a3_ ON a3_.id = f4_.activity_id
WHERE
  r1_.id IN (?, ?, ?, ?, ?, ?)
  AND a3_.id IN (?)
  AND DATE_ADD(
    CURRENT_TIMESTAMP, INTERVAL f0_.available_hours_before_booking HOUR
  ) >= ?
  AND f0_.is_active = ?
ORDER BY
  f0_.id ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.percent_value AS percent_value_2, f0_.available_hours_before_booking AS available_hours_before_booking_3, f0_.is_active AS is_active_4, r1_.id AS id_5, r1_.minimum_number_of_people AS minimum_number_of_people_6, r1_.maximum_number_of_people AS maximum_number_of_people_7, r1_.percentage_of_deposit AS percentage_of_deposit_8, r1_.minimum_price_with_tax AS minimum_price_with_tax_9, r1_.sort AS sort_10, r1_.background_color_checkout AS background_color_checkout_11, r1_.establishment_id AS establishment_id_12 FROM flash_sale f0_ INNER JOIN flash_sale_room f2_ ON f0_.id = f2_.flash_sale_id INNER JOIN room r1_ ON r1_.id = f2_.room_id INNER JOIN flash_sale_activity f4_ ON f0_.id = f4_.flash_sale_id INNER JOIN activity a3_ ON a3_.id = f4_.activity_id WHERE r1_.id IN (10, 9, 7, 8, 2, 1) AND a3_.id IN (2) AND DATE_ADD(CURRENT_TIMESTAMP, INTERVAL f0_.available_hours_before_booking HOUR) >= '2026-08-25 01:37:00' AND f0_.is_active = 1 ORDER BY f0_.id ASC;

SELECT
  r0_.id AS id_0,
  r0_.minimum_number_of_people AS minimum_number_of_people_1,
  r0_.maximum_number_of_people AS maximum_number_of_people_2,
  r0_.percentage_of_deposit AS percentage_of_deposit_3,
  r0_.minimum_price_with_tax AS minimum_price_with_tax_4,
  r0_.sort AS sort_5,
  r0_.background_color_checkout AS background_color_checkout_6,
  r1_.id AS id_7,
  r1_.title AS title_8,
  r1_.slug AS slug_9,
  r1_.seo_title AS seo_title_10,
  r1_.seo_description AS seo_description_11,
  r1_.seo_image AS seo_image_12,
  r1_.locale AS locale_13,
  e2_.id AS id_14,
  e2_.post_code AS post_code_15,
  e2_.facebook_link AS facebook_link_16,
  e2_.instagram_link AS instagram_link_17,
  e2_.pinterest_link AS pinterest_link_18,
  e2_.linkedin_link AS linkedin_link_19,
  e2_.tiktok_link AS tiktok_link_20,
  e2_.youtube_link AS youtube_link_21,
  e2_.vimeo_link AS vimeo_link_22,
  e2_.email_link AS email_link_23,
  e2_.phone_link AS phone_link_24,
  e2_.email_order AS email_order_25,
  e2_.mollie_api_key AS mollie_api_key_26,
  e2_.image AS image_27,
  e2_.is_active AS is_active_28,
  e2_.sort AS sort_29,
  a3_.id AS id_30,
  a3_.duration AS duration_31,
  a3_.days_of_week AS days_of_week_32,
  a3_.is_price_depend_number_of_people AS is_price_depend_number_of_people_33,
  a3_.price_per_person AS price_per_person_34,
  a3_.is_price_supplement AS is_price_supplement_35,
  a3_.price_supplement_type AS price_supplement_type_36,
  a3_.price_supplement_value AS price_supplement_value_37,
  a3_.duration_between_booking AS duration_between_booking_38,
  a3_.sort AS sort_39,
  a4_.id AS id_40,
  a4_.day_of_week AS day_of_week_41,
  a4_.hour_begin AS hour_begin_42,
  a4_.hour_end AS hour_end_43,
  a4_.date_begin AS date_begin_44,
  a4_.date_end AS date_end_45,
  a4_.sort AS sort_46,
  r5_.id AS id_47,
  r5_.day_of_week AS day_of_week_48,
  r5_.hour_begin AS hour_begin_49,
  r5_.hour_end AS hour_end_50,
  r5_.date_begin AS date_begin_51,
  r5_.date_end AS date_end_52,
  r5_.price_with_tax AS price_with_tax_53,
  r5_.sort AS sort_54,
  a6_.id AS id_55,
  a6_.duration AS duration_56,
  a6_.days_of_week AS days_of_week_57,
  a6_.is_price_depend_number_of_people AS is_price_depend_number_of_people_58,
  a6_.price_per_person AS price_per_person_59,
  a6_.is_price_supplement AS is_price_supplement_60,
  a6_.price_supplement_type AS price_supplement_type_61,
  a6_.price_supplement_value AS price_supplement_value_62,
  a6_.duration_between_booking AS duration_between_booking_63,
  a6_.sort AS sort_64,
  r7_.id AS id_65,
  r7_.type AS type_66,
  r7_.day_of_week AS day_of_week_67,
  r7_.hour_begin AS hour_begin_68,
  r7_.hour_end AS hour_end_69,
  r7_.sort AS sort_70,
  r0_.establishment_id AS establishment_id_71,
  r1_.translatable_id AS translatable_id_72,
  a4_.activity_id AS activity_id_73,
  r5_.room_id AS room_id_74,
  r7_.room_id AS room_id_75
FROM
  room r0_
  LEFT JOIN room_translation r1_ ON r0_.id = r1_.translatable_id
  AND (r1_.locale = ?)
  LEFT JOIN establishment e2_ ON r0_.establishment_id = e2_.id
  LEFT JOIN activity_room a8_ ON r0_.id = a8_.room_id
  LEFT JOIN activity a3_ ON a3_.id = a8_.activity_id
  LEFT JOIN activity_schedule a4_ ON a3_.id = a4_.activity_id
  LEFT JOIN room_price r5_ ON r0_.id = r5_.room_id
  LEFT JOIN room_price_activity r9_ ON r5_.id = r9_.room_price_id
  LEFT JOIN activity a6_ ON a6_.id = r9_.activity_id
  LEFT JOIN room_schedule r7_ ON r0_.id = r7_.room_id
WHERE
  e2_.id = ?
  AND e2_.is_active = ?
  AND a3_.id = ?
  AND r7_.day_of_week = ?
  AND r7_.type = ?
ORDER BY
  r0_.maximum_number_of_people ASC,
  a4_.sort ASC,
  r5_.sort ASC,
  r7_.sort ASC

SELECT r0_.id AS id_0, r0_.minimum_number_of_people AS minimum_number_of_people_1, r0_.maximum_number_of_people AS maximum_number_of_people_2, r0_.percentage_of_deposit AS percentage_of_deposit_3, r0_.minimum_price_with_tax AS minimum_price_with_tax_4, r0_.sort AS sort_5, r0_.background_color_checkout AS background_color_checkout_6, r1_.id AS id_7, r1_.title AS title_8, r1_.slug AS slug_9, r1_.seo_title AS seo_title_10, r1_.seo_description AS seo_description_11, r1_.seo_image AS seo_image_12, r1_.locale AS locale_13, e2_.id AS id_14, e2_.post_code AS post_code_15, e2_.facebook_link AS facebook_link_16, e2_.instagram_link AS instagram_link_17, e2_.pinterest_link AS pinterest_link_18, e2_.linkedin_link AS linkedin_link_19, e2_.tiktok_link AS tiktok_link_20, e2_.youtube_link AS youtube_link_21, e2_.vimeo_link AS vimeo_link_22, e2_.email_link AS email_link_23, e2_.phone_link AS phone_link_24, e2_.email_order AS email_order_25, e2_.mollie_api_key AS mollie_api_key_26, e2_.image AS image_27, e2_.is_active AS is_active_28, e2_.sort AS sort_29, a3_.id AS id_30, a3_.duration AS duration_31, a3_.days_of_week AS days_of_week_32, a3_.is_price_depend_number_of_people AS is_price_depend_number_of_people_33, a3_.price_per_person AS price_per_person_34, a3_.is_price_supplement AS is_price_supplement_35, a3_.price_supplement_type AS price_supplement_type_36, a3_.price_supplement_value AS price_supplement_value_37, a3_.duration_between_booking AS duration_between_booking_38, a3_.sort AS sort_39, a4_.id AS id_40, a4_.day_of_week AS day_of_week_41, a4_.hour_begin AS hour_begin_42, a4_.hour_end AS hour_end_43, a4_.date_begin AS date_begin_44, a4_.date_end AS date_end_45, a4_.sort AS sort_46, r5_.id AS id_47, r5_.day_of_week AS day_of_week_48, r5_.hour_begin AS hour_begin_49, r5_.hour_end AS hour_end_50, r5_.date_begin AS date_begin_51, r5_.date_end AS date_end_52, r5_.price_with_tax AS price_with_tax_53, r5_.sort AS sort_54, a6_.id AS id_55, a6_.duration AS duration_56, a6_.days_of_week AS days_of_week_57, a6_.is_price_depend_number_of_people AS is_price_depend_number_of_people_58, a6_.price_per_person AS price_per_person_59, a6_.is_price_supplement AS is_price_supplement_60, a6_.price_supplement_type AS price_supplement_type_61, a6_.price_supplement_value AS price_supplement_value_62, a6_.duration_between_booking AS duration_between_booking_63, a6_.sort AS sort_64, r7_.id AS id_65, r7_.type AS type_66, r7_.day_of_week AS day_of_week_67, r7_.hour_begin AS hour_begin_68, r7_.hour_end AS hour_end_69, r7_.sort AS sort_70, r0_.establishment_id AS establishment_id_71, r1_.translatable_id AS translatable_id_72, a4_.activity_id AS activity_id_73, r5_.room_id AS room_id_74, r7_.room_id AS room_id_75 FROM room r0_ LEFT JOIN room_translation r1_ ON r0_.id = r1_.translatable_id AND (r1_.locale = 'nl') LEFT JOIN establishment e2_ ON r0_.establishment_id = e2_.id LEFT JOIN activity_room a8_ ON r0_.id = a8_.room_id LEFT JOIN activity a3_ ON a3_.id = a8_.activity_id LEFT JOIN activity_schedule a4_ ON a3_.id = a4_.activity_id LEFT JOIN room_price r5_ ON r0_.id = r5_.room_id LEFT JOIN room_price_activity r9_ ON r5_.id = r9_.room_price_id LEFT JOIN activity a6_ ON a6_.id = r9_.activity_id LEFT JOIN room_schedule r7_ ON r0_.id = r7_.room_id WHERE e2_.id = 2 AND e2_.is_active = 1 AND a3_.id = 2 AND r7_.day_of_week = '2' AND r7_.type = 'open' ORDER BY r0_.maximum_number_of_people ASC, a4_.sort ASC, r5_.sort ASC, r7_.sort ASC;

SELECT
  b0_.id AS id_0,
  b0_.status AS status_1,
  b0_.date_time_begin AS date_time_begin_2,
  b0_.date_time_end AS date_time_end_3,
  b0_.number_of_people AS number_of_people_4,
  b0_.deposit_price_with_tax AS deposit_price_with_tax_5,
  b0_.rest_price_with_tax AS rest_price_with_tax_6,
  b0_.total_price_with_tax AS total_price_with_tax_7,
  b0_.created_at AS created_at_8,
  r1_.id AS id_9,
  r1_.minimum_number_of_people AS minimum_number_of_people_10,
  r1_.maximum_number_of_people AS maximum_number_of_people_11,
  r1_.percentage_of_deposit AS percentage_of_deposit_12,
  r1_.minimum_price_with_tax AS minimum_price_with_tax_13,
  r1_.sort AS sort_14,
  r1_.background_color_checkout AS background_color_checkout_15,
  b0_.activity_id AS activity_id_16,
  b0_.room_id AS room_id_17,
  r1_.establishment_id AS establishment_id_18
FROM
  booking b0_
  LEFT JOIN room r1_ ON b0_.room_id = r1_.id
WHERE
  b0_.status = ?
  AND r1_.id IN (?, ?, ?, ?, ?, ?)
  AND b0_.date_time_begin < ?
  AND b0_.date_time_end > ?

SELECT b0_.id AS id_0, b0_.status AS status_1, b0_.date_time_begin AS date_time_begin_2, b0_.date_time_end AS date_time_end_3, b0_.number_of_people AS number_of_people_4, b0_.deposit_price_with_tax AS deposit_price_with_tax_5, b0_.rest_price_with_tax AS rest_price_with_tax_6, b0_.total_price_with_tax AS total_price_with_tax_7, b0_.created_at AS created_at_8, r1_.id AS id_9, r1_.minimum_number_of_people AS minimum_number_of_people_10, r1_.maximum_number_of_people AS maximum_number_of_people_11, r1_.percentage_of_deposit AS percentage_of_deposit_12, r1_.minimum_price_with_tax AS minimum_price_with_tax_13, r1_.sort AS sort_14, r1_.background_color_checkout AS background_color_checkout_15, b0_.activity_id AS activity_id_16, b0_.room_id AS room_id_17, r1_.establishment_id AS establishment_id_18 FROM booking b0_ LEFT JOIN room r1_ ON b0_.room_id = r1_.id WHERE b0_.status = 'active' AND r1_.id IN (10, 9, 7, 8, 2, 1) AND b0_.date_time_begin < '2026-08-26 01:37:00' AND b0_.date_time_end > '2026-08-25 01:37:00';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.short_title AS short_title_4,
  t0.sub_title AS sub_title_5,
  t0.address AS address_6,
  t0.city AS city_7,
  t0.country AS country_8,
  t0.schedule AS schedule_9,
  t0.additional_information AS additional_information_10,
  t0.seo_title AS seo_title_11,
  t0.seo_description AS seo_description_12,
  t0.seo_image AS seo_image_13,
  t0.locale AS locale_14,
  t0.translatable_id AS translatable_id_15
FROM
  establishment_translation t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_title AS short_title_4, t0.sub_title AS sub_title_5, t0.address AS address_6, t0.city AS city_7, t0.country AS country_8, t0.schedule AS schedule_9, t0.additional_information AS additional_information_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_image AS seo_image_13, t0.locale AS locale_14, t0.translatable_id AS translatable_id_15 FROM establishment_translation t0 WHERE t0.slug = 'boa-karaoke-brussel-centrum' LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.post_code AS post_code_1,
  e0_.facebook_link AS facebook_link_2,
  e0_.instagram_link AS instagram_link_3,
  e0_.pinterest_link AS pinterest_link_4,
  e0_.linkedin_link AS linkedin_link_5,
  e0_.tiktok_link AS tiktok_link_6,
  e0_.youtube_link AS youtube_link_7,
  e0_.vimeo_link AS vimeo_link_8,
  e0_.email_link AS email_link_9,
  e0_.phone_link AS phone_link_10,
  e0_.email_order AS email_order_11,
  e0_.mollie_api_key AS mollie_api_key_12,
  e0_.image AS image_13,
  e0_.is_active AS is_active_14,
  e0_.sort AS sort_15,
  e1_.id AS id_16,
  e1_.title AS title_17,
  e1_.slug AS slug_18,
  e1_.short_title AS short_title_19,
  e1_.sub_title AS sub_title_20,
  e1_.address AS address_21,
  e1_.city AS city_22,
  e1_.country AS country_23,
  e1_.schedule AS schedule_24,
  e1_.additional_information AS additional_information_25,
  e1_.seo_title AS seo_title_26,
  e1_.seo_description AS seo_description_27,
  e1_.seo_image AS seo_image_28,
  e1_.locale AS locale_29,
  e1_.translatable_id AS translatable_id_30
FROM
  establishment e0_
  LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id
  AND (e1_.locale = ?)
ORDER BY
  e0_.sort ASC

SELECT e0_.id AS id_0, e0_.post_code AS post_code_1, e0_.facebook_link AS facebook_link_2, e0_.instagram_link AS instagram_link_3, e0_.pinterest_link AS pinterest_link_4, e0_.linkedin_link AS linkedin_link_5, e0_.tiktok_link AS tiktok_link_6, e0_.youtube_link AS youtube_link_7, e0_.vimeo_link AS vimeo_link_8, e0_.email_link AS email_link_9, e0_.phone_link AS phone_link_10, e0_.email_order AS email_order_11, e0_.mollie_api_key AS mollie_api_key_12, e0_.image AS image_13, e0_.is_active AS is_active_14, e0_.sort AS sort_15, e1_.id AS id_16, e1_.title AS title_17, e1_.slug AS slug_18, e1_.short_title AS short_title_19, e1_.sub_title AS sub_title_20, e1_.address AS address_21, e1_.city AS city_22, e1_.country AS country_23, e1_.schedule AS schedule_24, e1_.additional_information AS additional_information_25, e1_.seo_title AS seo_title_26, e1_.seo_description AS seo_description_27, e1_.seo_image AS seo_image_28, e1_.locale AS locale_29, e1_.translatable_id AS translatable_id_30 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id AND (e1_.locale = 'nl') ORDER BY e0_.sort ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.short_title AS short_title_4,
  t0.sub_title AS sub_title_5,
  t0.address AS address_6,
  t0.city AS city_7,
  t0.country AS country_8,
  t0.schedule AS schedule_9,
  t0.additional_information AS additional_information_10,
  t0.seo_title AS seo_title_11,
  t0.seo_description AS seo_description_12,
  t0.seo_image AS seo_image_13,
  t0.locale AS locale_14,
  t0.translatable_id AS translatable_id_15
FROM
  establishment_translation t0
WHERE
  t0.translatable_id = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_title AS short_title_4, t0.sub_title AS sub_title_5, t0.address AS address_6, t0.city AS city_7, t0.country AS country_8, t0.schedule AS schedule_9, t0.additional_information AS additional_information_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_image AS seo_image_13, t0.locale AS locale_14, t0.translatable_id AS translatable_id_15 FROM establishment_translation t0 WHERE t0.translatable_id = 2 AND t0.locale = 'fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.minimum_number_of_people AS minimum_number_of_people_2,
  t0.maximum_number_of_people AS maximum_number_of_people_3,
  t0.percentage_of_deposit AS percentage_of_deposit_4,
  t0.minimum_price_with_tax AS minimum_price_with_tax_5,
  t0.sort AS sort_6,
  t0.background_color_checkout AS background_color_checkout_7,
  t0.establishment_id AS establishment_id_8
FROM
  room t0
  INNER JOIN activity_room ON t0.id = activity_room.room_id
WHERE
  activity_room.activity_id = ?

SELECT t0.id AS id_1, t0.minimum_number_of_people AS minimum_number_of_people_2, t0.maximum_number_of_people AS maximum_number_of_people_3, t0.percentage_of_deposit AS percentage_of_deposit_4, t0.minimum_price_with_tax AS minimum_price_with_tax_5, t0.sort AS sort_6, t0.background_color_checkout AS background_color_checkout_7, t0.establishment_id AS establishment_id_8 FROM room t0 INNER JOIN activity_room ON t0.id = activity_room.room_id WHERE activity_room.activity_id = 2;