Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.subtitle AS subtitle_4,
  t0.short_description AS short_description_5,
  t0.image AS image_6,
  t0.age_range AS age_range_7,
  t0.players AS players_8,
  t0.duration AS duration_9,
  t0.category AS category_10,
  t0.manufacturing_info AS manufacturing_info_11,
  t0.game_description AS game_description_12,
  t0.game_rules AS game_rules_13,
  t0.pedagogical_objectives AS pedagogical_objectives_14,
  t0.game_content AS game_content_15,
  t0.video_url AS video_url_16,
  t0.video_thumbnail AS video_thumbnail_17,
  t0.showcase_image1 AS showcase_image1_18,
  t0.showcase_image2 AS showcase_image2_19,
  t0.showcase_image3 AS showcase_image3_20,
  t0.video_title AS video_title_21,
  t0.video_highlighted_title AS video_highlighted_title_22,
  t0.price AS price_23,
  t0.delivery_info AS delivery_info_24,
  t0.badge AS badge_25,
  t0.meta_title AS meta_title_26,
  t0.meta_description AS meta_description_27,
  t0.is_published AS is_published_28,
  t0.is_coming_soon AS is_coming_soon_29,
  t0.created_at AS created_at_30,
  t0.updated_at AS updated_at_31
FROM
  educational_game t0
WHERE
  t0.slug = ?
  AND t0.is_published = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.short_description AS short_description_5, t0.image AS image_6, t0.age_range AS age_range_7, t0.players AS players_8, t0.duration AS duration_9, t0.category AS category_10, t0.manufacturing_info AS manufacturing_info_11, t0.game_description AS game_description_12, t0.game_rules AS game_rules_13, t0.pedagogical_objectives AS pedagogical_objectives_14, t0.game_content AS game_content_15, t0.video_url AS video_url_16, t0.video_thumbnail AS video_thumbnail_17, t0.showcase_image1 AS showcase_image1_18, t0.showcase_image2 AS showcase_image2_19, t0.showcase_image3 AS showcase_image3_20, t0.video_title AS video_title_21, t0.video_highlighted_title AS video_highlighted_title_22, t0.price AS price_23, t0.delivery_info AS delivery_info_24, t0.badge AS badge_25, t0.meta_title AS meta_title_26, t0.meta_description AS meta_description_27, t0.is_published AS is_published_28, t0.is_coming_soon AS is_coming_soon_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31 FROM educational_game t0 WHERE t0.slug = 'roule-qui-peut' AND t0.is_published = 1 LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.slug AS slug_2,
  e0_.subtitle AS subtitle_3,
  e0_.short_description AS short_description_4,
  e0_.image AS image_5,
  e0_.age_range AS age_range_6,
  e0_.players AS players_7,
  e0_.duration AS duration_8,
  e0_.category AS category_9,
  e0_.manufacturing_info AS manufacturing_info_10,
  e0_.game_description AS game_description_11,
  e0_.game_rules AS game_rules_12,
  e0_.pedagogical_objectives AS pedagogical_objectives_13,
  e0_.game_content AS game_content_14,
  e0_.video_url AS video_url_15,
  e0_.video_thumbnail AS video_thumbnail_16,
  e0_.showcase_image1 AS showcase_image1_17,
  e0_.showcase_image2 AS showcase_image2_18,
  e0_.showcase_image3 AS showcase_image3_19,
  e0_.video_title AS video_title_20,
  e0_.video_highlighted_title AS video_highlighted_title_21,
  e0_.price AS price_22,
  e0_.delivery_info AS delivery_info_23,
  e0_.badge AS badge_24,
  e0_.meta_title AS meta_title_25,
  e0_.meta_description AS meta_description_26,
  e0_.is_published AS is_published_27,
  e0_.is_coming_soon AS is_coming_soon_28,
  e0_.created_at AS created_at_29,
  e0_.updated_at AS updated_at_30
FROM
  educational_game e0_
WHERE
  e0_.is_published = ?
  AND e0_.id <> ?
ORDER BY
  e0_.created_at DESC
LIMIT
  3

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.subtitle AS subtitle_3, e0_.short_description AS short_description_4, e0_.image AS image_5, e0_.age_range AS age_range_6, e0_.players AS players_7, e0_.duration AS duration_8, e0_.category AS category_9, e0_.manufacturing_info AS manufacturing_info_10, e0_.game_description AS game_description_11, e0_.game_rules AS game_rules_12, e0_.pedagogical_objectives AS pedagogical_objectives_13, e0_.game_content AS game_content_14, e0_.video_url AS video_url_15, e0_.video_thumbnail AS video_thumbnail_16, e0_.showcase_image1 AS showcase_image1_17, e0_.showcase_image2 AS showcase_image2_18, e0_.showcase_image3 AS showcase_image3_19, e0_.video_title AS video_title_20, e0_.video_highlighted_title AS video_highlighted_title_21, e0_.price AS price_22, e0_.delivery_info AS delivery_info_23, e0_.badge AS badge_24, e0_.meta_title AS meta_title_25, e0_.meta_description AS meta_description_26, e0_.is_published AS is_published_27, e0_.is_coming_soon AS is_coming_soon_28, e0_.created_at AS created_at_29, e0_.updated_at AS updated_at_30 FROM educational_game e0_ WHERE e0_.is_published = 1 AND e0_.id <> 3 ORDER BY e0_.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address AS address_4,
  t0.description AS description_5,
  t0.content_description AS content_description_6,
  t0.header_image AS header_image_7,
  t0.map_image AS map_image_8,
  t0.map_image_mobile AS map_image_mobile_9,
  t0.content_title AS content_title_10,
  t0.content_accroche AS content_accroche_11,
  t0.content_image1 AS content_image1_12,
  t0.content_image2 AS content_image2_13,
  t0.kpi1 AS kpi1_14,
  t0.kpi_text1 AS kpi_text1_15,
  t0.kpi2 AS kpi2_16,
  t0.kpi_text2 AS kpi_text2_17,
  t0.kpi3 AS kpi3_18,
  t0.kpi_text3 AS kpi_text3_19,
  t0.phone AS phone_20,
  t0.opening_hours AS opening_hours_21,
  t0.latitude AS latitude_22,
  t0.longitude AS longitude_23,
  t0.active AS active_24,
  t0.updated_at AS updated_at_25
FROM
  region t0
WHERE
  t0.active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.description AS description_5, t0.content_description AS content_description_6, t0.header_image AS header_image_7, t0.map_image AS map_image_8, t0.map_image_mobile AS map_image_mobile_9, t0.content_title AS content_title_10, t0.content_accroche AS content_accroche_11, t0.content_image1 AS content_image1_12, t0.content_image2 AS content_image2_13, t0.kpi1 AS kpi1_14, t0.kpi_text1 AS kpi_text1_15, t0.kpi2 AS kpi2_16, t0.kpi_text2 AS kpi_text2_17, t0.kpi3 AS kpi3_18, t0.kpi_text3 AS kpi_text3_19, t0.phone AS phone_20, t0.opening_hours AS opening_hours_21, t0.latitude AS latitude_22, t0.longitude AS longitude_23, t0.active AS active_24, t0.updated_at AS updated_at_25 FROM region t0 WHERE t0.active = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.address AS address_5,
  t0.mail AS mail_6,
  t0.slug AS slug_7,
  t0.meta_title AS meta_title_8,
  t0.meta_desc AS meta_desc_9,
  t0.title AS title_10,
  t0.welcome_text AS welcome_text_11,
  t0.educative_project AS educative_project_12,
  t0.price AS price_13,
  t0.team_text AS team_text_14,
  t0.team_list AS team_list_15,
  t0.contact_phone AS contact_phone_16,
  t0.welcome_hours AS welcome_hours_17,
  t0.closure_hours AS closure_hours_18,
  t0.city AS city_19,
  t0.zip_code AS zip_code_20,
  t0.visible AS visible_21,
  t0.header AS header_22,
  t0.header_mobile AS header_mobile_23,
  t0.band AS band_24,
  t0.link_registration AS link_registration_25,
  t0.link_opinion AS link_opinion_26,
  t0.team_img AS team_img_27,
  t0.image_vignette AS image_vignette_28,
  t0.latitude AS latitude_29,
  t0.longitude AS longitude_30,
  t0.brand AS brand_31,
  t0.format AS format_32,
  t0.video_url AS video_url_33,
  t0.video_title AS video_title_34,
  t0.video_title_highlight AS video_title_highlight_35,
  t0.video_thumbnail AS video_thumbnail_36,
  t0.faq_category_slug AS faq_category_slug_37,
  t0.quotation_id AS quotation_id_38
FROM
  nursery t0
WHERE
  t0.visible = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.address AS address_5, t0.mail AS mail_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_desc AS meta_desc_9, t0.title AS title_10, t0.welcome_text AS welcome_text_11, t0.educative_project AS educative_project_12, t0.price AS price_13, t0.team_text AS team_text_14, t0.team_list AS team_list_15, t0.contact_phone AS contact_phone_16, t0.welcome_hours AS welcome_hours_17, t0.closure_hours AS closure_hours_18, t0.city AS city_19, t0.zip_code AS zip_code_20, t0.visible AS visible_21, t0.header AS header_22, t0.header_mobile AS header_mobile_23, t0.band AS band_24, t0.link_registration AS link_registration_25, t0.link_opinion AS link_opinion_26, t0.team_img AS team_img_27, t0.image_vignette AS image_vignette_28, t0.latitude AS latitude_29, t0.longitude AS longitude_30, t0.brand AS brand_31, t0.format AS format_32, t0.video_url AS video_url_33, t0.video_title AS video_title_34, t0.video_title_highlight AS video_title_highlight_35, t0.video_thumbnail AS video_thumbnail_36, t0.faq_category_slug AS faq_category_slug_37, t0.quotation_id AS quotation_id_38 FROM nursery t0 WHERE t0.visible = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address AS address_4,
  t0.picto AS picto_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.content_first AS content_first_8,
  t0.content_second AS content_second_9,
  t0.image_name AS image_name_10,
  t0.image_size AS image_size_11,
  t0.kpi1 AS kpi1_12,
  t0.kpi2 AS kpi2_13,
  t0.kpi3 AS kpi3_14,
  t0.banner_image_mobile AS banner_image_mobile_15,
  t0.banner_image_desktop AS banner_image_desktop_16,
  t0.kpi_text1 AS kpi_text1_17,
  t0.kpi_text2 AS kpi_text2_18,
  t0.kpi_text3 AS kpi_text3_19,
  t0.active AS active_20,
  t0.phone AS phone_21,
  t0.email AS email_22,
  t0.brochure AS brochure_23,
  t0.cost AS cost_24,
  t0.video_url AS video_url_25,
  t0.opening_hours AS opening_hours_26,
  t0.acm_title AS acm_title_27,
  t0.acm_description AS acm_description_28,
  t0.acm_age_range AS acm_age_range_29,
  t0.google_review_url AS google_review_url_30,
  t0.meta_title AS meta_title_31,
  t0.meta_description AS meta_description_32,
  t0.latitude AS latitude_33,
  t0.longitude AS longitude_34,
  t0.video_thumbnail AS video_thumbnail_35,
  t0.content_image1 AS content_image1_36,
  t0.content_image2 AS content_image2_37,
  t0.quotation_id AS quotation_id_38
FROM
  community_center t0
WHERE
  t0.active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.picto AS picto_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.content_first AS content_first_8, t0.content_second AS content_second_9, t0.image_name AS image_name_10, t0.image_size AS image_size_11, t0.kpi1 AS kpi1_12, t0.kpi2 AS kpi2_13, t0.kpi3 AS kpi3_14, t0.banner_image_mobile AS banner_image_mobile_15, t0.banner_image_desktop AS banner_image_desktop_16, t0.kpi_text1 AS kpi_text1_17, t0.kpi_text2 AS kpi_text2_18, t0.kpi_text3 AS kpi_text3_19, t0.active AS active_20, t0.phone AS phone_21, t0.email AS email_22, t0.brochure AS brochure_23, t0.cost AS cost_24, t0.video_url AS video_url_25, t0.opening_hours AS opening_hours_26, t0.acm_title AS acm_title_27, t0.acm_description AS acm_description_28, t0.acm_age_range AS acm_age_range_29, t0.google_review_url AS google_review_url_30, t0.meta_title AS meta_title_31, t0.meta_description AS meta_description_32, t0.latitude AS latitude_33, t0.longitude AS longitude_34, t0.video_thumbnail AS video_thumbnail_35, t0.content_image1 AS content_image1_36, t0.content_image2 AS content_image2_37, t0.quotation_id AS quotation_id_38 FROM community_center t0 WHERE t0.active = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.cta_text AS cta_text_3,
  t0.cta_link AS cta_link_4,
  t0.active AS active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  notification_bar t0
WHERE
  t0.active = ?
ORDER BY
  t0.updated_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2, t0.cta_text AS cta_text_3, t0.cta_link AS cta_link_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM notification_bar t0 WHERE t0.active = 1 ORDER BY t0.updated_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.alt AS alt_3,
  t0.position AS position_4,
  t0.updated_at AS updated_at_5,
  t0.educational_game_id AS educational_game_id_6
FROM
  educational_game_gallery t0
WHERE
  t0.educational_game_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.alt AS alt_3, t0.position AS position_4, t0.updated_at AS updated_at_5, t0.educational_game_id AS educational_game_id_6 FROM educational_game_gallery t0 WHERE t0.educational_game_id = 3;

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.position AS position_5,
  t0.educational_game_id AS educational_game_id_6
FROM
  educational_game_feature t0
WHERE
  t0.educational_game_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.icon AS icon_2, t0.title AS title_3, t0.description AS description_4, t0.position AS position_5, t0.educational_game_id AS educational_game_id_6 FROM educational_game_feature t0 WHERE t0.educational_game_id = 3 ORDER BY t0.position ASC;