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,
  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 = 'fr') 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.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-ixelles' 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 = ?
  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 = 1 AND t0.locale = 'en' 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 = ?
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-ixelles' 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 = ?
  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 = 1 AND t0.locale = 'nl' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.field AS field_2,
  c0_.controller AS controller_3,
  c0_.action AS action_4,
  c0_.is_sitemap AS is_sitemap_5,
  c0_.is_contain_default_content_generator AS is_contain_default_content_generator_6,
  c0_.sort AS sort_7,
  c1_.id AS id_8,
  c1_.path AS path_9,
  c1_.seo_title AS seo_title_10,
  c1_.seo_description AS seo_description_11,
  c1_.seo_image AS seo_image_12,
  c1_.locale AS locale_13,
  c2_.id AS id_14,
  c2_.is_deletable AS is_deletable_15,
  c2_.sort AS sort_16,
  c3_.id AS id_17,
  c3_.name AS name_18,
  c3_.field AS field_19,
  c3_.type AS type_20,
  c4_.id AS id_21,
  c4_.name AS name_22,
  c4_.field AS field_23,
  c4_.type AS type_24,
  c4_.description AS description_25,
  c4_.options AS options_26,
  c4_.is_translation AS is_translation_27,
  c4_.is_required AS is_required_28,
  c4_.sort AS sort_29,
  c5_.id AS id_30,
  c5_.value AS value_31,
  c6_.id AS id_32,
  c6_.translation AS translation_33,
  c6_.locale AS locale_34,
  c7_.id AS id_35,
  c7_.name AS name_36,
  c7_.field AS field_37,
  c7_.type AS type_38,
  c7_.description AS description_39,
  c7_.options AS options_40,
  c7_.is_translation AS is_translation_41,
  c7_.is_required AS is_required_42,
  c7_.sort AS sort_43,
  c1_.translatable_id AS translatable_id_44,
  c2_.cms_generator_id AS cms_generator_id_45,
  c2_.cms_page_id AS cms_page_id_46,
  c4_.cms_generator_id AS cms_generator_id_47,
  c5_.cms_generator_page_id AS cms_generator_page_id_48,
  c5_.cms_generator_content_id AS cms_generator_content_id_49,
  c6_.translatable_id AS translatable_id_50,
  c7_.cms_generator_id AS cms_generator_id_51
FROM
  cms_page c0_
  LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.translatable_id
  AND (c1_.locale = ?)
  LEFT JOIN cms_generator_page c2_ ON c0_.id = c2_.cms_page_id
  LEFT JOIN cms_generator c3_ ON c2_.cms_generator_id = c3_.id
  LEFT JOIN cms_generator_content c4_ ON c3_.id = c4_.cms_generator_id
  LEFT JOIN cms_page_content c5_ ON c2_.id = c5_.cms_generator_page_id
  LEFT JOIN cms_page_content_translation c6_ ON c5_.id = c6_.translatable_id
  AND (c6_.locale = ?)
  LEFT JOIN cms_generator_content c7_ ON c5_.cms_generator_content_id = c7_.id
WHERE
  c0_.field = ?
ORDER BY
  c2_.sort ASC,
  c4_.sort ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.field AS field_2, c0_.controller AS controller_3, c0_.action AS action_4, c0_.is_sitemap AS is_sitemap_5, c0_.is_contain_default_content_generator AS is_contain_default_content_generator_6, c0_.sort AS sort_7, c1_.id AS id_8, c1_.path AS path_9, c1_.seo_title AS seo_title_10, c1_.seo_description AS seo_description_11, c1_.seo_image AS seo_image_12, c1_.locale AS locale_13, c2_.id AS id_14, c2_.is_deletable AS is_deletable_15, c2_.sort AS sort_16, c3_.id AS id_17, c3_.name AS name_18, c3_.field AS field_19, c3_.type AS type_20, c4_.id AS id_21, c4_.name AS name_22, c4_.field AS field_23, c4_.type AS type_24, c4_.description AS description_25, c4_.options AS options_26, c4_.is_translation AS is_translation_27, c4_.is_required AS is_required_28, c4_.sort AS sort_29, c5_.id AS id_30, c5_.value AS value_31, c6_.id AS id_32, c6_.translation AS translation_33, c6_.locale AS locale_34, c7_.id AS id_35, c7_.name AS name_36, c7_.field AS field_37, c7_.type AS type_38, c7_.description AS description_39, c7_.options AS options_40, c7_.is_translation AS is_translation_41, c7_.is_required AS is_required_42, c7_.sort AS sort_43, c1_.translatable_id AS translatable_id_44, c2_.cms_generator_id AS cms_generator_id_45, c2_.cms_page_id AS cms_page_id_46, c4_.cms_generator_id AS cms_generator_id_47, c5_.cms_generator_page_id AS cms_generator_page_id_48, c5_.cms_generator_content_id AS cms_generator_content_id_49, c6_.translatable_id AS translatable_id_50, c7_.cms_generator_id AS cms_generator_id_51 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = 'fr') LEFT JOIN cms_generator_page c2_ ON c0_.id = c2_.cms_page_id LEFT JOIN cms_generator c3_ ON c2_.cms_generator_id = c3_.id LEFT JOIN cms_generator_content c4_ ON c3_.id = c4_.cms_generator_id LEFT JOIN cms_page_content c5_ ON c2_.id = c5_.cms_generator_page_id LEFT JOIN cms_page_content_translation c6_ ON c5_.id = c6_.translatable_id AND (c6_.locale = 'fr') LEFT JOIN cms_generator_content c7_ ON c5_.cms_generator_content_id = c7_.id WHERE c0_.field = 'establishment_detail' ORDER BY c2_.sort ASC, c4_.sort ASC;

SELECT
  c0_.id AS id_0,
  c0_.image AS image_1,
  c0_.sort AS sort_2,
  e1_.id AS id_3,
  e1_.post_code AS post_code_4,
  e1_.facebook_link AS facebook_link_5,
  e1_.instagram_link AS instagram_link_6,
  e1_.pinterest_link AS pinterest_link_7,
  e1_.linkedin_link AS linkedin_link_8,
  e1_.tiktok_link AS tiktok_link_9,
  e1_.youtube_link AS youtube_link_10,
  e1_.vimeo_link AS vimeo_link_11,
  e1_.email_link AS email_link_12,
  e1_.phone_link AS phone_link_13,
  e1_.email_order AS email_order_14,
  e1_.mollie_api_key AS mollie_api_key_15,
  e1_.image AS image_16,
  e1_.is_active AS is_active_17,
  e1_.sort AS sort_18,
  e2_.id AS id_19,
  e2_.title AS title_20,
  e2_.slug AS slug_21,
  e2_.short_title AS short_title_22,
  e2_.sub_title AS sub_title_23,
  e2_.address AS address_24,
  e2_.city AS city_25,
  e2_.country AS country_26,
  e2_.schedule AS schedule_27,
  e2_.additional_information AS additional_information_28,
  e2_.seo_title AS seo_title_29,
  e2_.seo_description AS seo_description_30,
  e2_.seo_image AS seo_image_31,
  e2_.locale AS locale_32,
  r3_.id AS id_33,
  r3_.minimum_number_of_people AS minimum_number_of_people_34,
  r3_.maximum_number_of_people AS maximum_number_of_people_35,
  r3_.percentage_of_deposit AS percentage_of_deposit_36,
  r3_.minimum_price_with_tax AS minimum_price_with_tax_37,
  r3_.sort AS sort_38,
  r3_.background_color_checkout AS background_color_checkout_39,
  r4_.id AS id_40,
  r4_.title AS title_41,
  r4_.slug AS slug_42,
  r4_.seo_title AS seo_title_43,
  r4_.seo_description AS seo_description_44,
  r4_.seo_image AS seo_image_45,
  r4_.locale AS locale_46,
  r5_.id AS id_47,
  r5_.image AS image_48,
  r5_.sort AS sort_49,
  r6_.id AS id_50,
  r6_.sort AS sort_51,
  r7_.id AS id_52,
  r7_.title AS title_53,
  r7_.locale AS locale_54,
  c8_.id AS id_55,
  c8_.type AS type_56,
  c8_.background_color AS background_color_57,
  c8_.image1 AS image1_58,
  c8_.image2 AS image2_59,
  c8_.image_type AS image_type_60,
  c8_.images_position AS images_position_61,
  c8_.google_score AS google_score_62,
  c8_.google_nb_reviews AS google_nb_reviews_63,
  c8_.is_display_shape AS is_display_shape_64,
  c8_.sort AS sort_65,
  c9_.id AS id_66,
  c9_.title AS title_67,
  c9_.description AS description_68,
  c9_.text AS text_69,
  c9_.locale AS locale_70,
  c10_.id AS id_71,
  c10_.icon AS icon_72,
  c10_.image AS image_73,
  c10_.sort AS sort_74,
  c11_.id AS id_75,
  c11_.title AS title_76,
  c11_.description AS description_77,
  c11_.button AS button_78,
  c11_.url AS url_79,
  c11_.locale AS locale_80,
  c12_.id AS id_81,
  c12_.sort AS sort_82,
  c13_.id AS id_83,
  c13_.title AS title_84,
  c13_.description AS description_85,
  c13_.author AS author_86,
  c13_.locale AS locale_87,
  c14_.id AS id_88,
  c14_.sort AS sort_89,
  c15_.id AS id_90,
  c15_.link AS link_91,
  c15_.locale AS locale_92,
  c0_.id AS id_93,
  c0_.image AS image_94,
  c0_.sort AS sort_95,
  c16_.id AS id_96,
  c16_.alt AS alt_97,
  c16_.locale AS locale_98,
  c0_.content_id AS content_id_99,
  e2_.translatable_id AS translatable_id_100,
  r3_.establishment_id AS establishment_id_101,
  r4_.translatable_id AS translatable_id_102,
  r5_.room_id AS room_id_103,
  r6_.room_id AS room_id_104,
  r7_.translatable_id AS translatable_id_105,
  c8_.establishment_id AS establishment_id_106,
  c8_.room_id AS room_id_107,
  c8_.occasion_id AS occasion_id_108,
  c9_.translatable_id AS translatable_id_109,
  c10_.content_id AS content_id_110,
  c11_.translatable_id AS translatable_id_111,
  c12_.content_id AS content_id_112,
  c13_.translatable_id AS translatable_id_113,
  c14_.content_id AS content_id_114,
  c15_.translatable_id AS translatable_id_115,
  c16_.translatable_id AS translatable_id_116
FROM
  establishment e1_
  LEFT JOIN establishment_translation e2_ ON e1_.id = e2_.translatable_id
  AND (e2_.locale = ?)
  LEFT JOIN room r3_ ON e1_.id = r3_.establishment_id
  LEFT JOIN room_translation r4_ ON r3_.id = r4_.translatable_id
  AND (r4_.locale = ?)
  LEFT JOIN room_image r5_ ON r3_.id = r5_.room_id
  LEFT JOIN room_option r6_ ON r3_.id = r6_.room_id
  LEFT JOIN room_option_translation r7_ ON r6_.id = r7_.translatable_id
  AND (r7_.locale = ?)
  LEFT JOIN activity_room a18_ ON r3_.id = a18_.room_id
  LEFT JOIN activity a17_ ON a17_.id = a18_.activity_id
  LEFT JOIN content c8_ ON e1_.id = c8_.establishment_id
  LEFT JOIN content_translation c9_ ON c8_.id = c9_.translatable_id
  AND (c9_.locale = ?)
  LEFT JOIN content_item c10_ ON c8_.id = c10_.content_id
  LEFT JOIN content_item_translation c11_ ON c10_.id = c11_.translatable_id
  AND (c11_.locale = ?)
  LEFT JOIN content_dropdown c12_ ON c8_.id = c12_.content_id
  LEFT JOIN content_dropdown_translation c13_ ON c12_.id = c13_.translatable_id
  AND (c13_.locale = ?)
  LEFT JOIN content_button c14_ ON c8_.id = c14_.content_id
  LEFT JOIN content_button_translation c15_ ON c14_.id = c15_.translatable_id
  AND (c15_.locale = ?)
  LEFT JOIN content_image c0_ ON c8_.id = c0_.content_id
  LEFT JOIN content_image_translation c16_ ON c0_.id = c16_.translatable_id
  AND (c16_.locale = ?)
WHERE
  e1_.is_active = ?
  AND e2_.slug = ?
ORDER BY
  r3_.sort ASC,
  c0_.sort ASC,
  r5_.sort ASC,
  r6_.sort ASC,
  c8_.sort ASC,
  c10_.sort ASC,
  c12_.sort ASC,
  c14_.sort ASC

SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.sort AS sort_2, e1_.id AS id_3, e1_.post_code AS post_code_4, e1_.facebook_link AS facebook_link_5, e1_.instagram_link AS instagram_link_6, e1_.pinterest_link AS pinterest_link_7, e1_.linkedin_link AS linkedin_link_8, e1_.tiktok_link AS tiktok_link_9, e1_.youtube_link AS youtube_link_10, e1_.vimeo_link AS vimeo_link_11, e1_.email_link AS email_link_12, e1_.phone_link AS phone_link_13, e1_.email_order AS email_order_14, e1_.mollie_api_key AS mollie_api_key_15, e1_.image AS image_16, e1_.is_active AS is_active_17, e1_.sort AS sort_18, e2_.id AS id_19, e2_.title AS title_20, e2_.slug AS slug_21, e2_.short_title AS short_title_22, e2_.sub_title AS sub_title_23, e2_.address AS address_24, e2_.city AS city_25, e2_.country AS country_26, e2_.schedule AS schedule_27, e2_.additional_information AS additional_information_28, e2_.seo_title AS seo_title_29, e2_.seo_description AS seo_description_30, e2_.seo_image AS seo_image_31, e2_.locale AS locale_32, r3_.id AS id_33, r3_.minimum_number_of_people AS minimum_number_of_people_34, r3_.maximum_number_of_people AS maximum_number_of_people_35, r3_.percentage_of_deposit AS percentage_of_deposit_36, r3_.minimum_price_with_tax AS minimum_price_with_tax_37, r3_.sort AS sort_38, r3_.background_color_checkout AS background_color_checkout_39, r4_.id AS id_40, r4_.title AS title_41, r4_.slug AS slug_42, r4_.seo_title AS seo_title_43, r4_.seo_description AS seo_description_44, r4_.seo_image AS seo_image_45, r4_.locale AS locale_46, r5_.id AS id_47, r5_.image AS image_48, r5_.sort AS sort_49, r6_.id AS id_50, r6_.sort AS sort_51, r7_.id AS id_52, r7_.title AS title_53, r7_.locale AS locale_54, c8_.id AS id_55, c8_.type AS type_56, c8_.background_color AS background_color_57, c8_.image1 AS image1_58, c8_.image2 AS image2_59, c8_.image_type AS image_type_60, c8_.images_position AS images_position_61, c8_.google_score AS google_score_62, c8_.google_nb_reviews AS google_nb_reviews_63, c8_.is_display_shape AS is_display_shape_64, c8_.sort AS sort_65, c9_.id AS id_66, c9_.title AS title_67, c9_.description AS description_68, c9_.text AS text_69, c9_.locale AS locale_70, c10_.id AS id_71, c10_.icon AS icon_72, c10_.image AS image_73, c10_.sort AS sort_74, c11_.id AS id_75, c11_.title AS title_76, c11_.description AS description_77, c11_.button AS button_78, c11_.url AS url_79, c11_.locale AS locale_80, c12_.id AS id_81, c12_.sort AS sort_82, c13_.id AS id_83, c13_.title AS title_84, c13_.description AS description_85, c13_.author AS author_86, c13_.locale AS locale_87, c14_.id AS id_88, c14_.sort AS sort_89, c15_.id AS id_90, c15_.link AS link_91, c15_.locale AS locale_92, c0_.id AS id_93, c0_.image AS image_94, c0_.sort AS sort_95, c16_.id AS id_96, c16_.alt AS alt_97, c16_.locale AS locale_98, c0_.content_id AS content_id_99, e2_.translatable_id AS translatable_id_100, r3_.establishment_id AS establishment_id_101, r4_.translatable_id AS translatable_id_102, r5_.room_id AS room_id_103, r6_.room_id AS room_id_104, r7_.translatable_id AS translatable_id_105, c8_.establishment_id AS establishment_id_106, c8_.room_id AS room_id_107, c8_.occasion_id AS occasion_id_108, c9_.translatable_id AS translatable_id_109, c10_.content_id AS content_id_110, c11_.translatable_id AS translatable_id_111, c12_.content_id AS content_id_112, c13_.translatable_id AS translatable_id_113, c14_.content_id AS content_id_114, c15_.translatable_id AS translatable_id_115, c16_.translatable_id AS translatable_id_116 FROM establishment e1_ LEFT JOIN establishment_translation e2_ ON e1_.id = e2_.translatable_id AND (e2_.locale = 'fr') LEFT JOIN room r3_ ON e1_.id = r3_.establishment_id LEFT JOIN room_translation r4_ ON r3_.id = r4_.translatable_id AND (r4_.locale = 'fr') LEFT JOIN room_image r5_ ON r3_.id = r5_.room_id LEFT JOIN room_option r6_ ON r3_.id = r6_.room_id LEFT JOIN room_option_translation r7_ ON r6_.id = r7_.translatable_id AND (r7_.locale = 'fr') LEFT JOIN activity_room a18_ ON r3_.id = a18_.room_id LEFT JOIN activity a17_ ON a17_.id = a18_.activity_id LEFT JOIN content c8_ ON e1_.id = c8_.establishment_id LEFT JOIN content_translation c9_ ON c8_.id = c9_.translatable_id AND (c9_.locale = 'fr') LEFT JOIN content_item c10_ ON c8_.id = c10_.content_id LEFT JOIN content_item_translation c11_ ON c10_.id = c11_.translatable_id AND (c11_.locale = 'fr') LEFT JOIN content_dropdown c12_ ON c8_.id = c12_.content_id LEFT JOIN content_dropdown_translation c13_ ON c12_.id = c13_.translatable_id AND (c13_.locale = 'fr') LEFT JOIN content_button c14_ ON c8_.id = c14_.content_id LEFT JOIN content_button_translation c15_ ON c14_.id = c15_.translatable_id AND (c15_.locale = 'fr') LEFT JOIN content_image c0_ ON c8_.id = c0_.content_id LEFT JOIN content_image_translation c16_ ON c0_.id = c16_.translatable_id AND (c16_.locale = 'fr') WHERE e1_.is_active = 1 AND e2_.slug = 'boa-karaoke-ixelles' ORDER BY r3_.sort ASC, c0_.sort ASC, r5_.sort ASC, r6_.sort ASC, c8_.sort ASC, c10_.sort ASC, c12_.sort ASC, c14_.sort ASC;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.sort AS sort_3,
  t0.content_id AS content_id_4
FROM
  content_image t0
WHERE
  t0.content_id IN (?, ?, ?, ?, ?, ?, ?)
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.content_id AS content_id_4 FROM content_image t0 WHERE t0.content_id IN (1, 4, 6, 7, 8, 9, 5) ORDER BY t0.sort ASC;