Symfony Profiler

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.slug AS slug_5,
  t0.visible AS visible_6,
  t0.in_progress AS in_progress_7,
  t0.end_stat1_figure AS end_stat1_figure_8,
  t0.end_stat1_label AS end_stat1_label_9,
  t0.end_stat2_figure AS end_stat2_figure_10,
  t0.end_stat2_label AS end_stat2_label_11,
  t0.meta_title AS meta_title_12,
  t0.meta_desc AS meta_desc_13,
  t0.header_title AS header_title_14,
  t0.header_description AS header_description_15,
  t0.cta_text AS cta_text_16,
  t0.cta_link AS cta_link_17,
  t0.header_image AS header_image_18,
  t0.intro_title AS intro_title_19,
  t0.intro_subtitle AS intro_subtitle_20,
  t0.intro_content AS intro_content_21,
  t0.intro_date_range AS intro_date_range_22,
  t0.intro_location AS intro_location_23,
  t0.intro_address AS intro_address_24,
  t0.intro_tags AS intro_tags_25,
  t0.intro_image1 AS intro_image1_26,
  t0.intro_image2 AS intro_image2_27,
  t0.partners_logos AS partners_logos_28,
  t0.partners_cta_text AS partners_cta_text_29,
  t0.partners_cta_link AS partners_cta_link_30,
  t0.talents_title AS talents_title_31,
  t0.talents_subtitle AS talents_subtitle_32,
  t0.talents_content AS talents_content_33,
  t0.companies_title AS companies_title_34,
  t0.companies_subtitle AS companies_subtitle_35,
  t0.companies_content AS companies_content_36,
  t0.companies_box_content AS companies_box_content_37,
  t0.companies_image1 AS companies_image1_38,
  t0.companies_image2 AS companies_image2_39,
  t0.action_title AS action_title_40,
  t0.action_subtitle AS action_subtitle_41,
  t0.action_content AS action_content_42,
  t0.faq_category_id AS faq_category_id_43
FROM
  insertion_project t0
WHERE
  t0.slug = ?
  AND t0.visible = ?
LIMIT
  1

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.slug AS slug_5, t0.visible AS visible_6, t0.in_progress AS in_progress_7, t0.end_stat1_figure AS end_stat1_figure_8, t0.end_stat1_label AS end_stat1_label_9, t0.end_stat2_figure AS end_stat2_figure_10, t0.end_stat2_label AS end_stat2_label_11, t0.meta_title AS meta_title_12, t0.meta_desc AS meta_desc_13, t0.header_title AS header_title_14, t0.header_description AS header_description_15, t0.cta_text AS cta_text_16, t0.cta_link AS cta_link_17, t0.header_image AS header_image_18, t0.intro_title AS intro_title_19, t0.intro_subtitle AS intro_subtitle_20, t0.intro_content AS intro_content_21, t0.intro_date_range AS intro_date_range_22, t0.intro_location AS intro_location_23, t0.intro_address AS intro_address_24, t0.intro_tags AS intro_tags_25, t0.intro_image1 AS intro_image1_26, t0.intro_image2 AS intro_image2_27, t0.partners_logos AS partners_logos_28, t0.partners_cta_text AS partners_cta_text_29, t0.partners_cta_link AS partners_cta_link_30, t0.talents_title AS talents_title_31, t0.talents_subtitle AS talents_subtitle_32, t0.talents_content AS talents_content_33, t0.companies_title AS companies_title_34, t0.companies_subtitle AS companies_subtitle_35, t0.companies_content AS companies_content_36, t0.companies_box_content AS companies_box_content_37, t0.companies_image1 AS companies_image1_38, t0.companies_image2 AS companies_image2_39, t0.action_title AS action_title_40, t0.action_subtitle AS action_subtitle_41, t0.action_content AS action_content_42, t0.faq_category_id AS faq_category_id_43 FROM insertion_project t0 WHERE t0.slug = 'green-skills' AND t0.visible = 1 LIMIT 1;

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.updated_at AS updated_at_2,
  i0_.name AS name_3,
  i0_.slug AS slug_4,
  i0_.visible AS visible_5,
  i0_.in_progress AS in_progress_6,
  i0_.end_stat1_figure AS end_stat1_figure_7,
  i0_.end_stat1_label AS end_stat1_label_8,
  i0_.end_stat2_figure AS end_stat2_figure_9,
  i0_.end_stat2_label AS end_stat2_label_10,
  i0_.meta_title AS meta_title_11,
  i0_.meta_desc AS meta_desc_12,
  i0_.header_title AS header_title_13,
  i0_.header_description AS header_description_14,
  i0_.cta_text AS cta_text_15,
  i0_.cta_link AS cta_link_16,
  i0_.header_image AS header_image_17,
  i0_.intro_title AS intro_title_18,
  i0_.intro_subtitle AS intro_subtitle_19,
  i0_.intro_content AS intro_content_20,
  i0_.intro_date_range AS intro_date_range_21,
  i0_.intro_location AS intro_location_22,
  i0_.intro_address AS intro_address_23,
  i0_.intro_tags AS intro_tags_24,
  i0_.intro_image1 AS intro_image1_25,
  i0_.intro_image2 AS intro_image2_26,
  i0_.partners_logos AS partners_logos_27,
  i0_.partners_cta_text AS partners_cta_text_28,
  i0_.partners_cta_link AS partners_cta_link_29,
  i0_.talents_title AS talents_title_30,
  i0_.talents_subtitle AS talents_subtitle_31,
  i0_.talents_content AS talents_content_32,
  i0_.companies_title AS companies_title_33,
  i0_.companies_subtitle AS companies_subtitle_34,
  i0_.companies_content AS companies_content_35,
  i0_.companies_box_content AS companies_box_content_36,
  i0_.companies_image1 AS companies_image1_37,
  i0_.companies_image2 AS companies_image2_38,
  i0_.action_title AS action_title_39,
  i0_.action_subtitle AS action_subtitle_40,
  i0_.action_content AS action_content_41,
  i0_.faq_category_id AS faq_category_id_42
FROM
  insertion_project i0_
WHERE
  i0_.slug <> ?
  AND i0_.visible = 1
ORDER BY
  i0_.created_at DESC
LIMIT
  3

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.updated_at AS updated_at_2, i0_.name AS name_3, i0_.slug AS slug_4, i0_.visible AS visible_5, i0_.in_progress AS in_progress_6, i0_.end_stat1_figure AS end_stat1_figure_7, i0_.end_stat1_label AS end_stat1_label_8, i0_.end_stat2_figure AS end_stat2_figure_9, i0_.end_stat2_label AS end_stat2_label_10, i0_.meta_title AS meta_title_11, i0_.meta_desc AS meta_desc_12, i0_.header_title AS header_title_13, i0_.header_description AS header_description_14, i0_.cta_text AS cta_text_15, i0_.cta_link AS cta_link_16, i0_.header_image AS header_image_17, i0_.intro_title AS intro_title_18, i0_.intro_subtitle AS intro_subtitle_19, i0_.intro_content AS intro_content_20, i0_.intro_date_range AS intro_date_range_21, i0_.intro_location AS intro_location_22, i0_.intro_address AS intro_address_23, i0_.intro_tags AS intro_tags_24, i0_.intro_image1 AS intro_image1_25, i0_.intro_image2 AS intro_image2_26, i0_.partners_logos AS partners_logos_27, i0_.partners_cta_text AS partners_cta_text_28, i0_.partners_cta_link AS partners_cta_link_29, i0_.talents_title AS talents_title_30, i0_.talents_subtitle AS talents_subtitle_31, i0_.talents_content AS talents_content_32, i0_.companies_title AS companies_title_33, i0_.companies_subtitle AS companies_subtitle_34, i0_.companies_content AS companies_content_35, i0_.companies_box_content AS companies_box_content_36, i0_.companies_image1 AS companies_image1_37, i0_.companies_image2 AS companies_image2_38, i0_.action_title AS action_title_39, i0_.action_subtitle AS action_subtitle_40, i0_.action_content AS action_content_41, i0_.faq_category_id AS faq_category_id_42 FROM insertion_project i0_ WHERE i0_.slug <> 'green-skills' AND i0_.visible = 1 ORDER BY i0_.created_at DESC LIMIT 3;

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.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.icon AS icon_4,
  t0.figure AS figure_5,
  t0.description AS description_6,
  t0.ranking AS ranking_7,
  t0.project_id AS project_id_8
FROM
  insertion_project_key_figure t0
WHERE
  t0.project_id = ?
ORDER BY
  t0.ranking ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.icon AS icon_4, t0.figure AS figure_5, t0.description AS description_6, t0.ranking AS ranking_7, t0.project_id AS project_id_8 FROM insertion_project_key_figure t0 WHERE t0.project_id = 1 ORDER BY t0.ranking 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 = ?
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.quote AS quote_2,
  t0.name AS name_3,
  t0.call_yourself AS call_yourself_4,
  t0.image AS image_5,
  t0.is_visible AS is_visible_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.region_id AS region_id_9,
  t0.community_center_id AS community_center_id_10
FROM
  testimonial t0
  INNER JOIN insertion_project_testimonial ON t0.id = insertion_project_testimonial.testimonial_id
WHERE
  insertion_project_testimonial.insertion_project_id = ?

SELECT t0.id AS id_1, t0.quote AS quote_2, t0.name AS name_3, t0.call_yourself AS call_yourself_4, t0.image AS image_5, t0.is_visible AS is_visible_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.region_id AS region_id_9, t0.community_center_id AS community_center_id_10 FROM testimonial t0 INNER JOIN insertion_project_testimonial ON t0.id = insertion_project_testimonial.testimonial_id WHERE insertion_project_testimonial.insertion_project_id = 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.action1_title AS action1_title_6,
  t0.action1_description AS action1_description_7,
  t0.action2_title AS action2_title_8,
  t0.action2_description AS action2_description_9,
  t0.image AS image_10,
  t0.cta_text AS cta_text_11,
  t0.cta_link AS cta_link_12,
  t0.position AS position_13,
  t0.project_id AS project_id_14
FROM
  insertion_project_action t0
WHERE
  t0.project_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.description AS description_5, t0.action1_title AS action1_title_6, t0.action1_description AS action1_description_7, t0.action2_title AS action2_title_8, t0.action2_description AS action2_description_9, t0.image AS image_10, t0.cta_text AS cta_text_11, t0.cta_link AS cta_link_12, t0.position AS position_13, t0.project_id AS project_id_14 FROM insertion_project_action t0 WHERE t0.project_id = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.image AS image_4,
  t0.title AS title_5,
  t0.description AS description_6,
  t0.position AS position_7,
  t0.project_id AS project_id_8
FROM
  insertion_project_feature t0
WHERE
  t0.project_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.image AS image_4, t0.title AS title_5, t0.description AS description_6, t0.position AS position_7, t0.project_id AS project_id_8 FROM insertion_project_feature t0 WHERE t0.project_id = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.image AS image_3,
  t0.alt AS alt_4,
  t0.position AS position_5,
  t0.project_id AS project_id_6
FROM
  insertion_project_gallery t0
WHERE
  t0.project_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.alt AS alt_4, t0.position AS position_5, t0.project_id AS project_id_6 FROM insertion_project_gallery t0 WHERE t0.project_id = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.location AS location_6,
  t0.image AS image_7,
  t0.cta_text AS cta_text_8,
  t0.cta_link AS cta_link_9,
  t0.position AS position_10,
  t0.project_id AS project_id_11
FROM
  insertion_project_event t0
WHERE
  t0.project_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.description AS description_5, t0.location AS location_6, t0.image AS image_7, t0.cta_text AS cta_text_8, t0.cta_link AS cta_link_9, t0.position AS position_10, t0.project_id AS project_id_11 FROM insertion_project_event t0 WHERE t0.project_id = 1 ORDER BY t0.position 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;