Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.config_section AS config_section_2, 
  t0.config_name AS config_name_3, 
  t0.config_key AS config_key_4, 
  t0.config_type AS config_type_5, 
  t0.config_value AS config_value_6, 
  t0.config_description AS config_description_7, 
  t0.dateCreation AS dateCreation_8, 
  t0.dateModification AS dateModification_9 
FROM 
  WebConfiguration t0 
WHERE 
  t0.config_key = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.config_section AS config_section_2, t0.config_name AS config_name_3, t0.config_key AS config_key_4, t0.config_type AS config_type_5, t0.config_value AS config_value_6, t0.config_description AS config_description_7, t0.dateCreation AS dateCreation_8, t0.dateModification AS dateModification_9 FROM WebConfiguration t0 WHERE t0.config_key = 'show_events_limit' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.config_section AS config_section_2, 
  t0.config_name AS config_name_3, 
  t0.config_key AS config_key_4, 
  t0.config_type AS config_type_5, 
  t0.config_value AS config_value_6, 
  t0.config_description AS config_description_7, 
  t0.dateCreation AS dateCreation_8, 
  t0.dateModification AS dateModification_9 
FROM 
  WebConfiguration t0 
WHERE 
  t0.config_key = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.config_section AS config_section_2, t0.config_name AS config_name_3, t0.config_key AS config_key_4, t0.config_type AS config_type_5, t0.config_value AS config_value_6, t0.config_description AS config_description_7, t0.dateCreation AS dateCreation_8, t0.dateModification AS dateModification_9 FROM WebConfiguration t0 WHERE t0.config_key = 'workshop_terms_ca' LIMIT 1;

SELECT 
  c0_.id AS id_0, 
  c0_.slug AS slug_1, 
  c0_.name AS name_2, 
  c0_.shortDescription AS shortDescription_3, 
  c0_.imageDescriptionPath AS imageDescriptionPath_4, 
  c1_.imageUrl AS imageUrl_5, 
  c1_.id AS id_6, 
  c1_.name AS name_7, 
  IFNULL(c2_.date, c2_.originalDate) AS sclr_8 
FROM 
  CourseType c0_ 
  LEFT JOIN CourseLevel c3_ ON c0_.id = c3_.courseType_id 
  LEFT JOIN Course c1_ ON c3_.id = c1_.courseLevel_id 
  LEFT JOIN Term t4_ ON c1_.term_id = t4_.id 
  LEFT JOIN CourseSession c2_ ON c1_.id = c2_.course_id 
WHERE 
  c1_.type = ? 
  AND c2_.date LIKE ? 
  AND c1_.published = 1 
  AND c2_.date <= '2026-08-31'

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.name AS name_2, c0_.shortDescription AS shortDescription_3, c0_.imageDescriptionPath AS imageDescriptionPath_4, c1_.imageUrl AS imageUrl_5, c1_.id AS id_6, c1_.name AS name_7, IFNULL(c2_.date, c2_.originalDate) AS sclr_8 FROM CourseType c0_ LEFT JOIN CourseLevel c3_ ON c0_.id = c3_.courseType_id LEFT JOIN Course c1_ ON c3_.id = c1_.courseLevel_id LEFT JOIN Term t4_ ON c1_.term_id = t4_.id LEFT JOIN CourseSession c2_ ON c1_.id = c2_.course_id WHERE c1_.type = 1 AND c2_.date LIKE '2025-03-%' AND c1_.published = 1 AND c2_.date <= '2026-08-31';

SELECT 
  a0_.id AS id_0, 
  a0_.name AS name_1, 
  a0_.description AS description_2, 
  a0_.webDescription AS webDescription_3, 
  a0_.date AS date_4, 
  a0_.timeStart AS timeStart_5, 
  a0_.timeEnd AS timeEnd_6, 
  a0_.price AS price_7, 
  a0_.capacity AS capacity_8, 
  a0_.dateTimeCreation AS dateTimeCreation_9, 
  a0_.dateTimeModification AS dateTimeModification_10, 
  a0_.type AS type_11, 
  a0_.sortValue AS sortValue_12, 
  a0_.currentStudentsFree AS currentStudentsFree_13, 
  a0_.computePoints AS computePoints_14, 
  a0_.computeCourseHours AS computeCourseHours_15, 
  a0_.computeDanceHours AS computeDanceHours_16, 
  a0_.comments AS comments_17, 
  a0_.legacyReference AS legacyReference_18, 
  a0_.legacyReferenceCourse AS legacyReferenceCourse_19, 
  a0_.as_activity AS as_activity_20, 
  a0_.publishedInAgenda AS publishedInAgenda_21, 
  a0_.background_color AS background_color_22, 
  a0_.text_color AS text_color_23, 
  a0_.imagePoster AS imagePoster_24, 
  a0_.imagePath AS imagePath_25, 
  a0_.imagePathEs AS imagePathEs_26, 
  a0_.published AS published_27, 
  a0_.category_id AS category_id_28, 
  a0_.room_id AS room_id_29, 
  a0_.expandableRoom_id AS expandableRoom_id_30, 
  a0_.term_id AS term_id_31 
FROM 
  Activity a0_ 
WHERE 
  a0_.date LIKE ? 
  AND a0_.type = ? 
  AND a0_.publishedInAgenda = 1 
  AND a0_.date <= '2026-08-31'

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.webDescription AS webDescription_3, a0_.date AS date_4, a0_.timeStart AS timeStart_5, a0_.timeEnd AS timeEnd_6, a0_.price AS price_7, a0_.capacity AS capacity_8, a0_.dateTimeCreation AS dateTimeCreation_9, a0_.dateTimeModification AS dateTimeModification_10, a0_.type AS type_11, a0_.sortValue AS sortValue_12, a0_.currentStudentsFree AS currentStudentsFree_13, a0_.computePoints AS computePoints_14, a0_.computeCourseHours AS computeCourseHours_15, a0_.computeDanceHours AS computeDanceHours_16, a0_.comments AS comments_17, a0_.legacyReference AS legacyReference_18, a0_.legacyReferenceCourse AS legacyReferenceCourse_19, a0_.as_activity AS as_activity_20, a0_.publishedInAgenda AS publishedInAgenda_21, a0_.background_color AS background_color_22, a0_.text_color AS text_color_23, a0_.imagePoster AS imagePoster_24, a0_.imagePath AS imagePath_25, a0_.imagePathEs AS imagePathEs_26, a0_.published AS published_27, a0_.category_id AS category_id_28, a0_.room_id AS room_id_29, a0_.expandableRoom_id AS expandableRoom_id_30, a0_.term_id AS term_id_31 FROM Activity a0_ WHERE a0_.date LIKE '2025-03-%' AND a0_.type = 1 AND a0_.publishedInAgenda = 1 AND a0_.date <= '2026-08-31';

SELECT 
  c0_.id AS id_0, 
  c0_.name AS name_1, 
  a1_.name AS name_2, 
  c0_.webDescription AS webDescription_3, 
  a1_.webDescription AS webDescription_4, 
  c0_.imageUrl AS imageUrl_5, 
  a1_.id AS id_6, 
  a1_.date AS date_7 
FROM 
  Activity a1_ 
  LEFT JOIN Category c0_ ON a1_.category_id = c0_.id 
WHERE 
  a1_.date LIKE ? 
  AND c0_.active = ? 
  AND a1_.published = 1 
  AND a1_.publishedInAgenda = 1 
  AND a1_.date <= '2026-08-31'

SELECT c0_.id AS id_0, c0_.name AS name_1, a1_.name AS name_2, c0_.webDescription AS webDescription_3, a1_.webDescription AS webDescription_4, c0_.imageUrl AS imageUrl_5, a1_.id AS id_6, a1_.date AS date_7 FROM Activity a1_ LEFT JOIN Category c0_ ON a1_.category_id = c0_.id WHERE a1_.date LIKE '2025-03-%' AND c0_.active = 1 AND a1_.published = 1 AND a1_.publishedInAgenda = 1 AND a1_.date <= '2026-08-31';

SELECT 
  a0_.id AS id_0, 
  a0_.category AS category_1, 
  a0_.title AS title_2, 
  a0_.description AS description_3, 
  a0_.link AS link_4, 
  a0_.as_activity AS as_activity_5, 
  a0_.recommended AS recommended_6, 
  a0_.publishedInAgenda AS publishedInAgenda_7, 
  a0_.background_color AS background_color_8, 
  a0_.text_color AS text_color_9, 
  a0_.imageUrl AS imageUrl_10, 
  a0_.imageUrlEs AS imageUrlEs_11, 
  a0_.date AS date_12, 
  a0_.dateEnd AS dateEnd_13, 
  a0_.dateCreation AS dateCreation_14, 
  a0_.dateModification AS dateModification_15, 
  a0_.sortValue AS sortValue_16, 
  a0_.dateToShow AS dateToShow_17, 
  a0_.showDate AS showDate_18 
FROM 
  Agenda a0_ 
WHERE 
  a0_.dateToShow LIKE '2025-03-%' 
  AND a0_.dateToShow <= '2026-08-31' 
  AND a0_.publishedInAgenda = 1 
ORDER BY 
  a0_.dateToShow ASC, 
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.category AS category_1, a0_.title AS title_2, a0_.description AS description_3, a0_.link AS link_4, a0_.as_activity AS as_activity_5, a0_.recommended AS recommended_6, a0_.publishedInAgenda AS publishedInAgenda_7, a0_.background_color AS background_color_8, a0_.text_color AS text_color_9, a0_.imageUrl AS imageUrl_10, a0_.imageUrlEs AS imageUrlEs_11, a0_.date AS date_12, a0_.dateEnd AS dateEnd_13, a0_.dateCreation AS dateCreation_14, a0_.dateModification AS dateModification_15, a0_.sortValue AS sortValue_16, a0_.dateToShow AS dateToShow_17, a0_.showDate AS showDate_18 FROM Agenda a0_ WHERE a0_.dateToShow LIKE '2025-03-%' AND a0_.dateToShow <= '2026-08-31' AND a0_.publishedInAgenda = 1 ORDER BY a0_.dateToShow ASC, a0_.id DESC;

SELECT 
  s0_.date AS date_0, 
  (
    SELECT 
      COUNT(s1_.id) + 1 AS sclr_2 
    FROM 
      Session s1_ 
    WHERE 
      s1_.date < s0_.date 
      AND s1_.calendar_id = c2_.id
  ) AS sclr_1 
FROM 
  Term t3_ 
  INNER JOIN Calendar c2_ ON t3_.id = c2_.term_id 
  INNER JOIN Course c4_ ON c2_.id = c4_.calendar_id 
  INNER JOIN Session s0_ ON c2_.id = s0_.calendar_id 
  INNER JOIN Category c5_ ON c4_.category_id = c5_.id 
WHERE 
  c5_.id IN (2, 11) 
  AND t3_.superTerm_id IS NOT NULL 
  AND (
    s0_.date BETWEEN ? 
    AND ?
  ) 
  AND c4_.type = ? 
  AND c4_.status <> ? 
GROUP BY 
  s0_.date

SELECT s0_.date AS date_0, (SELECT COUNT(s1_.id) + 1 AS sclr_2 FROM Session s1_ WHERE s1_.date < s0_.date AND s1_.calendar_id = c2_.id) AS sclr_1 FROM Term t3_ INNER JOIN Calendar c2_ ON t3_.id = c2_.term_id INNER JOIN Course c4_ ON c2_.id = c4_.calendar_id INNER JOIN Session s0_ ON c2_.id = s0_.calendar_id INNER JOIN Category c5_ ON c4_.category_id = c5_.id WHERE c5_.id IN (2, 11) AND t3_.superTerm_id IS NOT NULL AND (s0_.date BETWEEN '2025-03-01' AND '2025-03-31') AND c4_.type = 0 AND c4_.status <> 0 GROUP BY s0_.date;

SELECT 
  c0_.id AS id_0, 
  c0_.slug AS slug_1, 
  c0_.name AS name_2, 
  c0_.shortDescription AS shortDescription_3, 
  c0_.imageDescriptionPath AS imageDescriptionPath_4, 
  c1_.imageUrl AS imageUrl_5, 
  c1_.background_color AS background_color_6, 
  c1_.text_color AS text_color_7, 
  c1_.id AS id_8, 
  IFNULL(c2_.date, c2_.originalDate) AS sclr_9 
FROM 
  CourseType c0_ 
  LEFT JOIN CourseLevel c3_ ON c0_.id = c3_.courseType_id 
  LEFT JOIN Course c1_ ON c3_.id = c1_.courseLevel_id 
  LEFT JOIN Term t4_ ON c1_.term_id = t4_.id 
  LEFT JOIN CourseSession c2_ ON c1_.id = c2_.course_id 
WHERE 
  c1_.type = ? 
  AND (
    c2_.date >= ? 
    AND c2_.date <= ?
  ) 
  AND c1_.published = 1

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.name AS name_2, c0_.shortDescription AS shortDescription_3, c0_.imageDescriptionPath AS imageDescriptionPath_4, c1_.imageUrl AS imageUrl_5, c1_.background_color AS background_color_6, c1_.text_color AS text_color_7, c1_.id AS id_8, IFNULL(c2_.date, c2_.originalDate) AS sclr_9 FROM CourseType c0_ LEFT JOIN CourseLevel c3_ ON c0_.id = c3_.courseType_id LEFT JOIN Course c1_ ON c3_.id = c1_.courseLevel_id LEFT JOIN Term t4_ ON c1_.term_id = t4_.id LEFT JOIN CourseSession c2_ ON c1_.id = c2_.course_id WHERE c1_.type = 1 AND (c2_.date >= '2025-03-01' AND c2_.date <= '2025-03-31') AND c1_.published = 1;

SELECT 
  c0_.id AS id_0, 
  c0_.name AS name_1, 
  a1_.name AS name_2, 
  c0_.webDescription AS webDescription_3, 
  a1_.webDescription AS webDescription_4, 
  c0_.imageUrl AS imageUrl_5, 
  c0_.background_color AS background_color_6, 
  c0_.text_color AS text_color_7, 
  a1_.id AS id_8, 
  a1_.date AS date_9 
FROM 
  Activity a1_ 
  LEFT JOIN Category c0_ ON a1_.category_id = c0_.id 
WHERE 
  (
    a1_.date >= ? 
    AND a1_.date <= ?
  ) 
  AND c0_.active = ? 
  AND a1_.published = 1 
  AND a1_.publishedInAgenda = 1

SELECT c0_.id AS id_0, c0_.name AS name_1, a1_.name AS name_2, c0_.webDescription AS webDescription_3, a1_.webDescription AS webDescription_4, c0_.imageUrl AS imageUrl_5, c0_.background_color AS background_color_6, c0_.text_color AS text_color_7, a1_.id AS id_8, a1_.date AS date_9 FROM Activity a1_ LEFT JOIN Category c0_ ON a1_.category_id = c0_.id WHERE (a1_.date >= '2025-03-01' AND a1_.date <= '2025-03-31') AND c0_.active = 1 AND a1_.published = 1 AND a1_.publishedInAgenda = 1;

SELECT 
  a0_.id AS id_0, 
  a0_.name AS name_1, 
  a0_.description AS description_2, 
  a0_.webDescription AS webDescription_3, 
  a0_.date AS date_4, 
  a0_.timeStart AS timeStart_5, 
  a0_.timeEnd AS timeEnd_6, 
  a0_.price AS price_7, 
  a0_.capacity AS capacity_8, 
  a0_.dateTimeCreation AS dateTimeCreation_9, 
  a0_.dateTimeModification AS dateTimeModification_10, 
  a0_.type AS type_11, 
  a0_.sortValue AS sortValue_12, 
  a0_.currentStudentsFree AS currentStudentsFree_13, 
  a0_.computePoints AS computePoints_14, 
  a0_.computeCourseHours AS computeCourseHours_15, 
  a0_.computeDanceHours AS computeDanceHours_16, 
  a0_.comments AS comments_17, 
  a0_.legacyReference AS legacyReference_18, 
  a0_.legacyReferenceCourse AS legacyReferenceCourse_19, 
  a0_.as_activity AS as_activity_20, 
  a0_.publishedInAgenda AS publishedInAgenda_21, 
  a0_.background_color AS background_color_22, 
  a0_.text_color AS text_color_23, 
  a0_.imagePoster AS imagePoster_24, 
  a0_.imagePath AS imagePath_25, 
  a0_.imagePathEs AS imagePathEs_26, 
  a0_.published AS published_27, 
  a0_.category_id AS category_id_28, 
  a0_.room_id AS room_id_29, 
  a0_.expandableRoom_id AS expandableRoom_id_30, 
  a0_.term_id AS term_id_31 
FROM 
  Activity a0_ 
WHERE 
  (
    a0_.date >= ? 
    AND a0_.date <= ?
  ) 
  AND a0_.type = ? 
ORDER BY 
  a0_.date ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.webDescription AS webDescription_3, a0_.date AS date_4, a0_.timeStart AS timeStart_5, a0_.timeEnd AS timeEnd_6, a0_.price AS price_7, a0_.capacity AS capacity_8, a0_.dateTimeCreation AS dateTimeCreation_9, a0_.dateTimeModification AS dateTimeModification_10, a0_.type AS type_11, a0_.sortValue AS sortValue_12, a0_.currentStudentsFree AS currentStudentsFree_13, a0_.computePoints AS computePoints_14, a0_.computeCourseHours AS computeCourseHours_15, a0_.computeDanceHours AS computeDanceHours_16, a0_.comments AS comments_17, a0_.legacyReference AS legacyReference_18, a0_.legacyReferenceCourse AS legacyReferenceCourse_19, a0_.as_activity AS as_activity_20, a0_.publishedInAgenda AS publishedInAgenda_21, a0_.background_color AS background_color_22, a0_.text_color AS text_color_23, a0_.imagePoster AS imagePoster_24, a0_.imagePath AS imagePath_25, a0_.imagePathEs AS imagePathEs_26, a0_.published AS published_27, a0_.category_id AS category_id_28, a0_.room_id AS room_id_29, a0_.expandableRoom_id AS expandableRoom_id_30, a0_.term_id AS term_id_31 FROM Activity a0_ WHERE (a0_.date >= '2025-03-01' AND a0_.date <= '2025-03-31') AND a0_.type = 1 ORDER BY a0_.date ASC;

SELECT 
  a0_.id AS id_0, 
  a0_.category AS category_1, 
  a0_.title AS title_2, 
  a0_.description AS description_3, 
  a0_.link AS link_4, 
  a0_.as_activity AS as_activity_5, 
  a0_.recommended AS recommended_6, 
  a0_.publishedInAgenda AS publishedInAgenda_7, 
  a0_.background_color AS background_color_8, 
  a0_.text_color AS text_color_9, 
  a0_.imageUrl AS imageUrl_10, 
  a0_.imageUrlEs AS imageUrlEs_11, 
  a0_.date AS date_12, 
  a0_.dateEnd AS dateEnd_13, 
  a0_.dateCreation AS dateCreation_14, 
  a0_.dateModification AS dateModification_15, 
  a0_.sortValue AS sortValue_16, 
  a0_.dateToShow AS dateToShow_17, 
  a0_.showDate AS showDate_18 
FROM 
  Agenda a0_ 
WHERE 
  a0_.dateToShow LIKE '2025-03-%' 
  AND a0_.dateToShow <= '2026-08-31' 
  AND a0_.publishedInAgenda = 1 
ORDER BY 
  a0_.dateToShow ASC, 
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.category AS category_1, a0_.title AS title_2, a0_.description AS description_3, a0_.link AS link_4, a0_.as_activity AS as_activity_5, a0_.recommended AS recommended_6, a0_.publishedInAgenda AS publishedInAgenda_7, a0_.background_color AS background_color_8, a0_.text_color AS text_color_9, a0_.imageUrl AS imageUrl_10, a0_.imageUrlEs AS imageUrlEs_11, a0_.date AS date_12, a0_.dateEnd AS dateEnd_13, a0_.dateCreation AS dateCreation_14, a0_.dateModification AS dateModification_15, a0_.sortValue AS sortValue_16, a0_.dateToShow AS dateToShow_17, a0_.showDate AS showDate_18 FROM Agenda a0_ WHERE a0_.dateToShow LIKE '2025-03-%' AND a0_.dateToShow <= '2026-08-31' AND a0_.publishedInAgenda = 1 ORDER BY a0_.dateToShow ASC, a0_.id DESC;

SELECT 
  t0.id AS id_1, 
  t0.config_section AS config_section_2, 
  t0.config_name AS config_name_3, 
  t0.config_key AS config_key_4, 
  t0.config_type AS config_type_5, 
  t0.config_value AS config_value_6, 
  t0.config_description AS config_description_7, 
  t0.dateCreation AS dateCreation_8, 
  t0.dateModification AS dateModification_9 
FROM 
  WebConfiguration t0 
WHERE 
  t0.config_key = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.config_section AS config_section_2, t0.config_name AS config_name_3, t0.config_key AS config_key_4, t0.config_type AS config_type_5, t0.config_value AS config_value_6, t0.config_description AS config_description_7, t0.dateCreation AS dateCreation_8, t0.dateModification AS dateModification_9 FROM WebConfiguration t0 WHERE t0.config_key = 'show_workshop_menu' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.config_section AS config_section_2, 
  t0.config_name AS config_name_3, 
  t0.config_key AS config_key_4, 
  t0.config_type AS config_type_5, 
  t0.config_value AS config_value_6, 
  t0.config_description AS config_description_7, 
  t0.dateCreation AS dateCreation_8, 
  t0.dateModification AS dateModification_9 
FROM 
  WebConfiguration t0 
WHERE 
  t0.config_key = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.config_section AS config_section_2, t0.config_name AS config_name_3, t0.config_key AS config_key_4, t0.config_type AS config_type_5, t0.config_value AS config_value_6, t0.config_description AS config_description_7, t0.dateCreation AS dateCreation_8, t0.dateModification AS dateModification_9 FROM WebConfiguration t0 WHERE t0.config_key = 'show_online_courses' LIMIT 1;