Symfony Profiler

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.slug = ?
  AND t0.active = ?
LIMIT
  1

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.slug = 'centre-social-romain-rolland-saint-tronc' AND t0.active = 1 LIMIT 1;

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.type AS type_21,
  t0.visible AS visible_22,
  t0.header AS header_23,
  t0.header_mobile AS header_mobile_24,
  t0.band AS band_25,
  t0.link_registration AS link_registration_26,
  t0.link_opinion AS link_opinion_27,
  t0.team_img AS team_img_28,
  t0.image_vignette AS image_vignette_29,
  t0.latitude AS latitude_30,
  t0.longitude AS longitude_31,
  t0.quotation_id AS quotation_id_32
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.type AS type_21, t0.visible AS visible_22, t0.header AS header_23, t0.header_mobile AS header_mobile_24, t0.band AS band_25, t0.link_registration AS link_registration_26, t0.link_opinion AS link_opinion_27, t0.team_img AS team_img_28, t0.image_vignette AS image_vignette_29, t0.latitude AS latitude_30, t0.longitude AS longitude_31, t0.quotation_id AS quotation_id_32 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.name AS name_2,
  t0.position AS position_3,
  t0.quotation AS quotation_4,
  t0.image_name AS image_name_5,
  t0.image_size AS image_size_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t9.id AS id_10,
  t9.created_at AS created_at_11,
  t9.updated_at AS updated_at_12,
  t9.name AS name_13,
  t9.address AS address_14,
  t9.mail AS mail_15,
  t9.slug AS slug_16,
  t9.meta_title AS meta_title_17,
  t9.meta_desc AS meta_desc_18,
  t9.title AS title_19,
  t9.welcome_text AS welcome_text_20,
  t9.educative_project AS educative_project_21,
  t9.price AS price_22,
  t9.team_text AS team_text_23,
  t9.team_list AS team_list_24,
  t9.contact_phone AS contact_phone_25,
  t9.welcome_hours AS welcome_hours_26,
  t9.closure_hours AS closure_hours_27,
  t9.city AS city_28,
  t9.zip_code AS zip_code_29,
  t9.type AS type_30,
  t9.visible AS visible_31,
  t9.header AS header_32,
  t9.header_mobile AS header_mobile_33,
  t9.band AS band_34,
  t9.link_registration AS link_registration_35,
  t9.link_opinion AS link_opinion_36,
  t9.team_img AS team_img_37,
  t9.image_vignette AS image_vignette_38,
  t9.latitude AS latitude_39,
  t9.longitude AS longitude_40,
  t9.quotation_id AS quotation_id_41,
  t42.id AS id_43,
  t42.name AS name_44,
  t42.slug AS slug_45,
  t42.address AS address_46,
  t42.picto AS picto_47,
  t42.created_at AS created_at_48,
  t42.updated_at AS updated_at_49,
  t42.content_first AS content_first_50,
  t42.content_second AS content_second_51,
  t42.image_name AS image_name_52,
  t42.image_size AS image_size_53,
  t42.kpi1 AS kpi1_54,
  t42.kpi2 AS kpi2_55,
  t42.kpi3 AS kpi3_56,
  t42.banner_image_mobile AS banner_image_mobile_57,
  t42.banner_image_desktop AS banner_image_desktop_58,
  t42.kpi_text1 AS kpi_text1_59,
  t42.kpi_text2 AS kpi_text2_60,
  t42.kpi_text3 AS kpi_text3_61,
  t42.active AS active_62,
  t42.phone AS phone_63,
  t42.email AS email_64,
  t42.brochure AS brochure_65,
  t42.cost AS cost_66,
  t42.video_url AS video_url_67,
  t42.opening_hours AS opening_hours_68,
  t42.acm_title AS acm_title_69,
  t42.acm_description AS acm_description_70,
  t42.acm_age_range AS acm_age_range_71,
  t42.google_review_url AS google_review_url_72,
  t42.meta_title AS meta_title_73,
  t42.meta_description AS meta_description_74,
  t42.latitude AS latitude_75,
  t42.longitude AS longitude_76,
  t42.video_thumbnail AS video_thumbnail_77,
  t42.content_image1 AS content_image1_78,
  t42.content_image2 AS content_image2_79,
  t42.quotation_id AS quotation_id_80
FROM
  quotation t0
  LEFT JOIN nursery t9 ON t9.quotation_id = t0.id
  LEFT JOIN community_center t42 ON t42.quotation_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.quotation AS quotation_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.created_at AS created_at_11, t9.updated_at AS updated_at_12, t9.name AS name_13, t9.address AS address_14, t9.mail AS mail_15, t9.slug AS slug_16, t9.meta_title AS meta_title_17, t9.meta_desc AS meta_desc_18, t9.title AS title_19, t9.welcome_text AS welcome_text_20, t9.educative_project AS educative_project_21, t9.price AS price_22, t9.team_text AS team_text_23, t9.team_list AS team_list_24, t9.contact_phone AS contact_phone_25, t9.welcome_hours AS welcome_hours_26, t9.closure_hours AS closure_hours_27, t9.city AS city_28, t9.zip_code AS zip_code_29, t9.type AS type_30, t9.visible AS visible_31, t9.header AS header_32, t9.header_mobile AS header_mobile_33, t9.band AS band_34, t9.link_registration AS link_registration_35, t9.link_opinion AS link_opinion_36, t9.team_img AS team_img_37, t9.image_vignette AS image_vignette_38, t9.latitude AS latitude_39, t9.longitude AS longitude_40, t9.quotation_id AS quotation_id_41, t42.id AS id_43, t42.name AS name_44, t42.slug AS slug_45, t42.address AS address_46, t42.picto AS picto_47, t42.created_at AS created_at_48, t42.updated_at AS updated_at_49, t42.content_first AS content_first_50, t42.content_second AS content_second_51, t42.image_name AS image_name_52, t42.image_size AS image_size_53, t42.kpi1 AS kpi1_54, t42.kpi2 AS kpi2_55, t42.kpi3 AS kpi3_56, t42.banner_image_mobile AS banner_image_mobile_57, t42.banner_image_desktop AS banner_image_desktop_58, t42.kpi_text1 AS kpi_text1_59, t42.kpi_text2 AS kpi_text2_60, t42.kpi_text3 AS kpi_text3_61, t42.active AS active_62, t42.phone AS phone_63, t42.email AS email_64, t42.brochure AS brochure_65, t42.cost AS cost_66, t42.video_url AS video_url_67, t42.opening_hours AS opening_hours_68, t42.acm_title AS acm_title_69, t42.acm_description AS acm_description_70, t42.acm_age_range AS acm_age_range_71, t42.google_review_url AS google_review_url_72, t42.meta_title AS meta_title_73, t42.meta_description AS meta_description_74, t42.latitude AS latitude_75, t42.longitude AS longitude_76, t42.video_thumbnail AS video_thumbnail_77, t42.content_image1 AS content_image1_78, t42.content_image2 AS content_image2_79, t42.quotation_id AS quotation_id_80 FROM quotation t0 LEFT JOIN nursery t9 ON t9.quotation_id = t0.id LEFT JOIN community_center t42 ON t42.quotation_id = t0.id WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.category AS category_5,
  t0.age_range AS age_range_6,
  t0.schedule AS schedule_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  community_center_activity t0
  INNER JOIN community_center_community_center_activity ON t0.id = community_center_community_center_activity.community_center_activity_id
WHERE
  community_center_community_center_activity.community_center_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.name AS name_3, t0.description AS description_4, t0.category AS category_5, t0.age_range AS age_range_6, t0.schedule AS schedule_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM community_center_activity t0 INNER JOIN community_center_community_center_activity ON t0.id = community_center_community_center_activity.community_center_activity_id WHERE community_center_community_center_activity.community_center_id = 6;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.community_center_id AS community_center_id_6
FROM
  community_center_image t0
WHERE
  t0.community_center_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.community_center_id AS community_center_id_6 FROM community_center_image t0 WHERE t0.community_center_id = 6;

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
WHERE
  t0.community_center_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 WHERE t0.community_center_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo_name AS logo_name_3,
  t0.logo_size AS logo_size_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.community_center_id AS community_center_id_7
FROM
  community_center_partner t0
WHERE
  t0.community_center_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo_name AS logo_name_3, t0.logo_size AS logo_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.community_center_id AS community_center_id_7 FROM community_center_partner t0 WHERE t0.community_center_id = 6;