Symfony Profiler

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,
  e3_.id AS id_30,
  e3_.title AS title_31,
  e3_.slug AS slug_32,
  e3_.short_title AS short_title_33,
  e3_.sub_title AS sub_title_34,
  e3_.address AS address_35,
  e3_.city AS city_36,
  e3_.country AS country_37,
  e3_.schedule AS schedule_38,
  e3_.additional_information AS additional_information_39,
  e3_.seo_title AS seo_title_40,
  e3_.seo_description AS seo_description_41,
  e3_.seo_image AS seo_image_42,
  e3_.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,
  c5_.id AS id_52,
  c5_.type AS type_53,
  c5_.background_color AS background_color_54,
  c5_.image1 AS image1_55,
  c5_.image2 AS image2_56,
  c5_.image_type AS image_type_57,
  c5_.images_position AS images_position_58,
  c5_.google_score AS google_score_59,
  c5_.google_nb_reviews AS google_nb_reviews_60,
  c5_.is_display_shape AS is_display_shape_61,
  c5_.sort AS sort_62,
  c6_.id AS id_63,
  c6_.title AS title_64,
  c6_.description AS description_65,
  c6_.text AS text_66,
  c6_.locale AS locale_67,
  c7_.id AS id_68,
  c7_.icon AS icon_69,
  c7_.image AS image_70,
  c7_.sort AS sort_71,
  c8_.id AS id_72,
  c8_.title AS title_73,
  c8_.description AS description_74,
  c8_.button AS button_75,
  c8_.url AS url_76,
  c8_.locale AS locale_77,
  c9_.id AS id_78,
  c9_.sort AS sort_79,
  c10_.id AS id_80,
  c10_.title AS title_81,
  c10_.description AS description_82,
  c10_.author AS author_83,
  c10_.locale AS locale_84,
  c11_.id AS id_85,
  c11_.sort AS sort_86,
  c12_.id AS id_87,
  c12_.link AS link_88,
  c12_.locale AS locale_89,
  c13_.id AS id_90,
  c13_.image AS image_91,
  c13_.sort AS sort_92,
  c14_.id AS id_93,
  c14_.alt AS alt_94,
  c14_.locale AS locale_95,
  r0_.establishment_id AS establishment_id_96,
  r1_.translatable_id AS translatable_id_97,
  e3_.translatable_id AS translatable_id_98,
  r4_.room_id AS room_id_99,
  c5_.establishment_id AS establishment_id_100,
  c5_.room_id AS room_id_101,
  c5_.occasion_id AS occasion_id_102,
  c6_.translatable_id AS translatable_id_103,
  c7_.content_id AS content_id_104,
  c8_.translatable_id AS translatable_id_105,
  c9_.content_id AS content_id_106,
  c10_.translatable_id AS translatable_id_107,
  c11_.content_id AS content_id_108,
  c12_.translatable_id AS translatable_id_109,
  c13_.content_id AS content_id_110,
  c14_.translatable_id AS translatable_id_111
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 establishment_translation e3_ ON e2_.id = e3_.translatable_id
  AND (e3_.locale = ?)
  LEFT JOIN room_price r4_ ON r0_.id = r4_.room_id
  LEFT JOIN content c5_ ON r0_.id = c5_.room_id
  LEFT JOIN content_translation c6_ ON c5_.id = c6_.translatable_id
  AND (c6_.locale = ?)
  LEFT JOIN content_item c7_ ON c5_.id = c7_.content_id
  LEFT JOIN content_item_translation c8_ ON c7_.id = c8_.translatable_id
  AND (c8_.locale = ?)
  LEFT JOIN content_dropdown c9_ ON c5_.id = c9_.content_id
  LEFT JOIN content_dropdown_translation c10_ ON c9_.id = c10_.translatable_id
  AND (c10_.locale = ?)
  LEFT JOIN content_button c11_ ON c5_.id = c11_.content_id
  LEFT JOIN content_button_translation c12_ ON c11_.id = c12_.translatable_id
  AND (c12_.locale = ?)
  LEFT JOIN content_image c13_ ON c5_.id = c13_.content_id
  LEFT JOIN content_image_translation c14_ ON c13_.id = c14_.translatable_id
  AND (c14_.locale = ?)
WHERE
  r1_.slug = ?
  AND e3_.slug = ?
  AND e2_.is_active = ?
ORDER BY
  r0_.sort ASC,
  e2_.sort ASC,
  r4_.sort ASC,
  c5_.sort ASC,
  c7_.sort ASC,
  c9_.sort ASC,
  c11_.sort ASC,
  c13_.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, e3_.id AS id_30, e3_.title AS title_31, e3_.slug AS slug_32, e3_.short_title AS short_title_33, e3_.sub_title AS sub_title_34, e3_.address AS address_35, e3_.city AS city_36, e3_.country AS country_37, e3_.schedule AS schedule_38, e3_.additional_information AS additional_information_39, e3_.seo_title AS seo_title_40, e3_.seo_description AS seo_description_41, e3_.seo_image AS seo_image_42, e3_.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, c5_.id AS id_52, c5_.type AS type_53, c5_.background_color AS background_color_54, c5_.image1 AS image1_55, c5_.image2 AS image2_56, c5_.image_type AS image_type_57, c5_.images_position AS images_position_58, c5_.google_score AS google_score_59, c5_.google_nb_reviews AS google_nb_reviews_60, c5_.is_display_shape AS is_display_shape_61, c5_.sort AS sort_62, c6_.id AS id_63, c6_.title AS title_64, c6_.description AS description_65, c6_.text AS text_66, c6_.locale AS locale_67, c7_.id AS id_68, c7_.icon AS icon_69, c7_.image AS image_70, c7_.sort AS sort_71, c8_.id AS id_72, c8_.title AS title_73, c8_.description AS description_74, c8_.button AS button_75, c8_.url AS url_76, c8_.locale AS locale_77, c9_.id AS id_78, c9_.sort AS sort_79, c10_.id AS id_80, c10_.title AS title_81, c10_.description AS description_82, c10_.author AS author_83, c10_.locale AS locale_84, c11_.id AS id_85, c11_.sort AS sort_86, c12_.id AS id_87, c12_.link AS link_88, c12_.locale AS locale_89, c13_.id AS id_90, c13_.image AS image_91, c13_.sort AS sort_92, c14_.id AS id_93, c14_.alt AS alt_94, c14_.locale AS locale_95, r0_.establishment_id AS establishment_id_96, r1_.translatable_id AS translatable_id_97, e3_.translatable_id AS translatable_id_98, r4_.room_id AS room_id_99, c5_.establishment_id AS establishment_id_100, c5_.room_id AS room_id_101, c5_.occasion_id AS occasion_id_102, c6_.translatable_id AS translatable_id_103, c7_.content_id AS content_id_104, c8_.translatable_id AS translatable_id_105, c9_.content_id AS content_id_106, c10_.translatable_id AS translatable_id_107, c11_.content_id AS content_id_108, c12_.translatable_id AS translatable_id_109, c13_.content_id AS content_id_110, c14_.translatable_id AS translatable_id_111 FROM room r0_ LEFT JOIN room_translation r1_ ON r0_.id = r1_.translatable_id AND (r1_.locale = 'fr') LEFT JOIN establishment e2_ ON r0_.establishment_id = e2_.id LEFT JOIN establishment_translation e3_ ON e2_.id = e3_.translatable_id AND (e3_.locale = 'fr') LEFT JOIN room_price r4_ ON r0_.id = r4_.room_id LEFT JOIN content c5_ ON r0_.id = c5_.room_id LEFT JOIN content_translation c6_ ON c5_.id = c6_.translatable_id AND (c6_.locale = 'fr') LEFT JOIN content_item c7_ ON c5_.id = c7_.content_id LEFT JOIN content_item_translation c8_ ON c7_.id = c8_.translatable_id AND (c8_.locale = 'fr') LEFT JOIN content_dropdown c9_ ON c5_.id = c9_.content_id LEFT JOIN content_dropdown_translation c10_ ON c9_.id = c10_.translatable_id AND (c10_.locale = 'fr') LEFT JOIN content_button c11_ ON c5_.id = c11_.content_id LEFT JOIN content_button_translation c12_ ON c11_.id = c12_.translatable_id AND (c12_.locale = 'fr') LEFT JOIN content_image c13_ ON c5_.id = c13_.content_id LEFT JOIN content_image_translation c14_ ON c13_.id = c14_.translatable_id AND (c14_.locale = 'fr') WHERE r1_.slug = 'perroquet-room' AND e3_.slug = 'boa-karaoke-bruxelles-centre' AND e2_.is_active = 1 ORDER BY r0_.sort ASC, e2_.sort ASC, r4_.sort ASC, c5_.sort ASC, c7_.sort ASC, c9_.sort ASC, c11_.sort ASC, c13_.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 = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  room_option_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM room_option_translation t0 WHERE t0.translatable_id = 3;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.sort AS sort_3,
  t0.room_id AS room_id_4
FROM
  room_image t0
WHERE
  t0.room_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.room_id AS room_id_4 FROM room_image t0 WHERE t0.room_id = 7 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.day_of_week AS day_of_week_2,
  t0.hour_begin AS hour_begin_3,
  t0.hour_end AS hour_end_4,
  t0.date_begin AS date_begin_5,
  t0.date_end AS date_end_6,
  t0.price_with_tax AS price_with_tax_7,
  t0.sort AS sort_8,
  t0.room_id AS room_id_9
FROM
  room_price t0
WHERE
  t0.room_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.day_of_week AS day_of_week_2, t0.hour_begin AS hour_begin_3, t0.hour_end AS hour_end_4, t0.date_begin AS date_begin_5, t0.date_end AS date_end_6, t0.price_with_tax AS price_with_tax_7, t0.sort AS sort_8, t0.room_id AS room_id_9 FROM room_price t0 WHERE t0.room_id = 1 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.seo_title AS seo_title_4,
  t0.seo_description AS seo_description_5,
  t0.seo_image AS seo_image_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  room_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.seo_image AS seo_image_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM room_translation t0 WHERE t0.translatable_id = 1;

SELECT
  t0.id AS id_1,
  t0.sort AS sort_2,
  t0.room_id AS room_id_3
FROM
  room_option t0
WHERE
  t0.room_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.sort AS sort_2, t0.room_id AS room_id_3 FROM room_option t0 WHERE t0.room_id = 1 ORDER BY t0.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-bruxelles-centre' 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 = 'fr') ORDER BY e0_.sort ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.seo_title AS seo_title_4,
  t0.seo_description AS seo_description_5,
  t0.seo_image AS seo_image_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  room_translation t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.seo_image AS seo_image_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM room_translation t0 WHERE t0.slug = 'perroquet-room' 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
WHERE
  t0.establishment_id = ?
ORDER BY
  t0.sort ASC

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 WHERE t0.establishment_id = 2 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.seo_title AS seo_title_4,
  t0.seo_description AS seo_description_5,
  t0.seo_image AS seo_image_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  room_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.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.seo_image AS seo_image_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM room_translation t0 WHERE t0.translatable_id = 7 AND t0.locale = 'en' LIMIT 1;