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.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_image AS seo_image_8,
  t0.locale AS locale_9,
  t0.translatable_id AS translatable_id_10
FROM
  occasion_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.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_image AS seo_image_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM occasion_translation t0 WHERE t0.slug = 'team-building-au-boa-karaoke' 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.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_image AS seo_image_8,
  t0.locale AS locale_9,
  t0.translatable_id AS translatable_id_10
FROM
  occasion_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.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_image AS seo_image_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM occasion_translation t0 WHERE t0.translatable_id = 4 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.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_image AS seo_image_8,
  t0.locale AS locale_9,
  t0.translatable_id AS translatable_id_10
FROM
  occasion_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.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_image AS seo_image_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM occasion_translation t0 WHERE t0.slug = 'team-building-au-boa-karaoke' 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.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_image AS seo_image_8,
  t0.locale AS locale_9,
  t0.translatable_id AS translatable_id_10
FROM
  occasion_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.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_image AS seo_image_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM occasion_translation t0 WHERE t0.translatable_id = 4 AND t0.locale = 'nl' LIMIT 1;

SELECT
  o0_.id AS id_0,
  o0_.sort AS sort_1,
  o0_.image AS image_2,
  o1_.id AS id_3,
  o1_.title AS title_4,
  o1_.slug AS slug_5,
  o1_.short_title AS short_title_6,
  o1_.sub_title AS sub_title_7,
  o1_.seo_title AS seo_title_8,
  o1_.seo_description AS seo_description_9,
  o1_.seo_image AS seo_image_10,
  o1_.locale AS locale_11,
  c2_.id AS id_12,
  c2_.type AS type_13,
  c2_.background_color AS background_color_14,
  c2_.image1 AS image1_15,
  c2_.image2 AS image2_16,
  c2_.image_type AS image_type_17,
  c2_.images_position AS images_position_18,
  c2_.google_score AS google_score_19,
  c2_.google_nb_reviews AS google_nb_reviews_20,
  c2_.is_display_shape AS is_display_shape_21,
  c2_.sort AS sort_22,
  c3_.id AS id_23,
  c3_.title AS title_24,
  c3_.description AS description_25,
  c3_.text AS text_26,
  c3_.locale AS locale_27,
  c4_.id AS id_28,
  c4_.icon AS icon_29,
  c4_.image AS image_30,
  c4_.sort AS sort_31,
  c5_.id AS id_32,
  c5_.title AS title_33,
  c5_.description AS description_34,
  c5_.button AS button_35,
  c5_.url AS url_36,
  c5_.locale AS locale_37,
  c6_.id AS id_38,
  c6_.sort AS sort_39,
  c7_.id AS id_40,
  c7_.title AS title_41,
  c7_.description AS description_42,
  c7_.author AS author_43,
  c7_.locale AS locale_44,
  c8_.id AS id_45,
  c8_.sort AS sort_46,
  c9_.id AS id_47,
  c9_.link AS link_48,
  c9_.locale AS locale_49,
  c10_.id AS id_50,
  c10_.image AS image_51,
  c10_.sort AS sort_52,
  c11_.id AS id_53,
  c11_.alt AS alt_54,
  c11_.locale AS locale_55,
  o1_.translatable_id AS translatable_id_56,
  c2_.establishment_id AS establishment_id_57,
  c2_.room_id AS room_id_58,
  c2_.occasion_id AS occasion_id_59,
  c3_.translatable_id AS translatable_id_60,
  c4_.content_id AS content_id_61,
  c5_.translatable_id AS translatable_id_62,
  c6_.content_id AS content_id_63,
  c7_.translatable_id AS translatable_id_64,
  c8_.content_id AS content_id_65,
  c9_.translatable_id AS translatable_id_66,
  c10_.content_id AS content_id_67,
  c11_.translatable_id AS translatable_id_68
FROM
  occasion o0_
  LEFT JOIN occasion_translation o1_ ON o0_.id = o1_.translatable_id
  AND (o1_.locale = ?)
  LEFT JOIN content c2_ ON o0_.id = c2_.occasion_id
  LEFT JOIN content_translation c3_ ON c2_.id = c3_.translatable_id
  AND (c3_.locale = ?)
  LEFT JOIN content_item c4_ ON c2_.id = c4_.content_id
  LEFT JOIN content_item_translation c5_ ON c4_.id = c5_.translatable_id
  AND (c5_.locale = ?)
  LEFT JOIN content_dropdown c6_ ON c2_.id = c6_.content_id
  LEFT JOIN content_dropdown_translation c7_ ON c6_.id = c7_.translatable_id
  AND (c7_.locale = ?)
  LEFT JOIN content_button c8_ ON c2_.id = c8_.content_id
  LEFT JOIN content_button_translation c9_ ON c8_.id = c9_.translatable_id
  AND (c9_.locale = ?)
  LEFT JOIN content_image c10_ ON c2_.id = c10_.content_id
  LEFT JOIN content_image_translation c11_ ON c10_.id = c11_.translatable_id
  AND (c11_.locale = ?)
WHERE
  o1_.slug = ?
ORDER BY
  o0_.sort ASC,
  c2_.sort ASC,
  c4_.sort ASC,
  c6_.sort ASC,
  c8_.sort ASC,
  c10_.sort ASC

SELECT o0_.id AS id_0, o0_.sort AS sort_1, o0_.image AS image_2, o1_.id AS id_3, o1_.title AS title_4, o1_.slug AS slug_5, o1_.short_title AS short_title_6, o1_.sub_title AS sub_title_7, o1_.seo_title AS seo_title_8, o1_.seo_description AS seo_description_9, o1_.seo_image AS seo_image_10, o1_.locale AS locale_11, c2_.id AS id_12, c2_.type AS type_13, c2_.background_color AS background_color_14, c2_.image1 AS image1_15, c2_.image2 AS image2_16, c2_.image_type AS image_type_17, c2_.images_position AS images_position_18, c2_.google_score AS google_score_19, c2_.google_nb_reviews AS google_nb_reviews_20, c2_.is_display_shape AS is_display_shape_21, c2_.sort AS sort_22, c3_.id AS id_23, c3_.title AS title_24, c3_.description AS description_25, c3_.text AS text_26, c3_.locale AS locale_27, c4_.id AS id_28, c4_.icon AS icon_29, c4_.image AS image_30, c4_.sort AS sort_31, c5_.id AS id_32, c5_.title AS title_33, c5_.description AS description_34, c5_.button AS button_35, c5_.url AS url_36, c5_.locale AS locale_37, c6_.id AS id_38, c6_.sort AS sort_39, c7_.id AS id_40, c7_.title AS title_41, c7_.description AS description_42, c7_.author AS author_43, c7_.locale AS locale_44, c8_.id AS id_45, c8_.sort AS sort_46, c9_.id AS id_47, c9_.link AS link_48, c9_.locale AS locale_49, c10_.id AS id_50, c10_.image AS image_51, c10_.sort AS sort_52, c11_.id AS id_53, c11_.alt AS alt_54, c11_.locale AS locale_55, o1_.translatable_id AS translatable_id_56, c2_.establishment_id AS establishment_id_57, c2_.room_id AS room_id_58, c2_.occasion_id AS occasion_id_59, c3_.translatable_id AS translatable_id_60, c4_.content_id AS content_id_61, c5_.translatable_id AS translatable_id_62, c6_.content_id AS content_id_63, c7_.translatable_id AS translatable_id_64, c8_.content_id AS content_id_65, c9_.translatable_id AS translatable_id_66, c10_.content_id AS content_id_67, c11_.translatable_id AS translatable_id_68 FROM occasion o0_ LEFT JOIN occasion_translation o1_ ON o0_.id = o1_.translatable_id AND (o1_.locale = 'fr') LEFT JOIN content c2_ ON o0_.id = c2_.occasion_id LEFT JOIN content_translation c3_ ON c2_.id = c3_.translatable_id AND (c3_.locale = 'fr') LEFT JOIN content_item c4_ ON c2_.id = c4_.content_id LEFT JOIN content_item_translation c5_ ON c4_.id = c5_.translatable_id AND (c5_.locale = 'fr') LEFT JOIN content_dropdown c6_ ON c2_.id = c6_.content_id LEFT JOIN content_dropdown_translation c7_ ON c6_.id = c7_.translatable_id AND (c7_.locale = 'fr') LEFT JOIN content_button c8_ ON c2_.id = c8_.content_id LEFT JOIN content_button_translation c9_ ON c8_.id = c9_.translatable_id AND (c9_.locale = 'fr') LEFT JOIN content_image c10_ ON c2_.id = c10_.content_id LEFT JOIN content_image_translation c11_ ON c10_.id = c11_.translatable_id AND (c11_.locale = 'fr') WHERE o1_.slug = 'team-building-au-boa-karaoke' ORDER BY o0_.sort ASC, c2_.sort ASC, c4_.sort ASC, c6_.sort ASC, c8_.sort ASC, c10_.sort ASC;