Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.day_of_the_week AS day_of_the_week_1,
          a0_.start_time AS start_time_2,
          a0_.duration AS duration_3,
          a0_.cost AS cost_4,
          a0_.nb_child AS nb_child_5,
          a0_.nb_waitinglist AS nb_waitinglist_6,
          a0_.nb_participant AS nb_participant_7,
          a0_.picture_src AS picture_src_8,
          a0_.deletedAt AS deletedAt_9
        FROM
          activity_instance a0_
          LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id
          LEFT JOIN period p2_ ON a0_.period_id = p2_.id
        WHERE
          (
            a1_.type_activity = ?
            AND (
              ? BETWEEN p2_.publicationDate
              AND p2_.end_registration_date
            )
            AND p2_.archived = 0
          )
          AND (a0_.deletedAt IS NULL)
        ORDER BY
          a0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.day_of_the_week AS day_of_the_week_1, a0_.start_time AS start_time_2, a0_.duration AS duration_3, a0_.cost AS cost_4, a0_.nb_child AS nb_child_5, a0_.nb_waitinglist AS nb_waitinglist_6, a0_.nb_participant AS nb_participant_7, a0_.picture_src AS picture_src_8, a0_.deletedAt AS deletedAt_9 FROM activity_instance a0_ LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id LEFT JOIN period p2_ ON a0_.period_id = p2_.id WHERE (a1_.type_activity = 'GRP' AND ('2026-05-13 12:47:24' BETWEEN p2_.publicationDate AND p2_.end_registration_date) AND p2_.archived = 0) AND (a0_.deletedAt IS NULL) ORDER BY a0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.day_of_the_week AS day_of_the_week_1,
          a0_.start_time AS start_time_2,
          a0_.duration AS duration_3,
          a0_.cost AS cost_4,
          a0_.nb_child AS nb_child_5,
          a0_.nb_waitinglist AS nb_waitinglist_6,
          a0_.nb_participant AS nb_participant_7,
          a0_.picture_src AS picture_src_8,
          a0_.deletedAt AS deletedAt_9,
          a1_.id AS id_10,
          a1_.type_activity AS type_activity_11,
          a1_.order_ihm AS order_ihm_12,
          a1_.level AS level_13,
          p2_.id AS id_14,
          p2_.archived AS archived_15,
          p2_.publicationDate AS publicationDate_16,
          p2_.registration_start_date AS registration_start_date_17,
          p2_.member_registration_start_date AS member_registration_start_date_18,
          p2_.end_registration_date AS end_registration_date_19,
          p2_.payment_delay AS payment_delay_20,
          p2_.payment_delay_waiting_list AS payment_delay_waiting_list_21,
          p2_.cost30min AS cost30min_22,
          p2_.cost45min AS cost45min_23,
          p2_.cost60min AS cost60min_24
        FROM
          activity_instance a0_
          LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id
          LEFT JOIN period p2_ ON a0_.period_id = p2_.id
        WHERE
          (
            a1_.type_activity = ?
            AND (
              ? BETWEEN p2_.publicationDate
              AND p2_.end_registration_date
            )
            AND p2_.archived = 0
          )
          AND (a0_.deletedAt IS NULL)
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  500

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.day_of_the_week AS day_of_the_week_1, a0_.start_time AS start_time_2, a0_.duration AS duration_3, a0_.cost AS cost_4, a0_.nb_child AS nb_child_5, a0_.nb_waitinglist AS nb_waitinglist_6, a0_.nb_participant AS nb_participant_7, a0_.picture_src AS picture_src_8, a0_.deletedAt AS deletedAt_9, a1_.id AS id_10, a1_.type_activity AS type_activity_11, a1_.order_ihm AS order_ihm_12, a1_.level AS level_13, p2_.id AS id_14, p2_.archived AS archived_15, p2_.publicationDate AS publicationDate_16, p2_.registration_start_date AS registration_start_date_17, p2_.member_registration_start_date AS member_registration_start_date_18, p2_.end_registration_date AS end_registration_date_19, p2_.payment_delay AS payment_delay_20, p2_.payment_delay_waiting_list AS payment_delay_waiting_list_21, p2_.cost30min AS cost30min_22, p2_.cost45min AS cost45min_23, p2_.cost60min AS cost60min_24 FROM activity_instance a0_ LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id LEFT JOIN period p2_ ON a0_.period_id = p2_.id WHERE (a1_.type_activity = 'GRP' AND ('2026-05-13 12:47:24' BETWEEN p2_.publicationDate AND p2_.end_registration_date) AND p2_.archived = 0) AND (a0_.deletedAt IS NULL)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 500;

SELECT
  a0_.id AS id_0,
  a0_.day_of_the_week AS day_of_the_week_1,
  a0_.start_time AS start_time_2,
  a0_.duration AS duration_3,
  a0_.cost AS cost_4,
  a0_.nb_child AS nb_child_5,
  a0_.nb_waitinglist AS nb_waitinglist_6,
  a0_.nb_participant AS nb_participant_7,
  a0_.picture_src AS picture_src_8,
  a0_.deletedAt AS deletedAt_9,
  a0_.activity_category_id AS activity_category_id_10,
  a0_.default_classroom_id AS default_classroom_id_11,
  a0_.period_id AS period_id_12,
  a0_.building_id AS building_id_13,
  a0_.activity_instance_id_src_copy AS activity_instance_id_src_copy_14
FROM
  activity_instance a0_
  LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id
  LEFT JOIN period p2_ ON a0_.period_id = p2_.id
WHERE
  (
    a1_.type_activity = ?
    AND (
      ? BETWEEN p2_.publicationDate
      AND p2_.end_registration_date
    )
    AND p2_.archived = 0
    AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  AND (a0_.deletedAt IS NULL)
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.day_of_the_week AS day_of_the_week_1, a0_.start_time AS start_time_2, a0_.duration AS duration_3, a0_.cost AS cost_4, a0_.nb_child AS nb_child_5, a0_.nb_waitinglist AS nb_waitinglist_6, a0_.nb_participant AS nb_participant_7, a0_.picture_src AS picture_src_8, a0_.deletedAt AS deletedAt_9, a0_.activity_category_id AS activity_category_id_10, a0_.default_classroom_id AS default_classroom_id_11, a0_.period_id AS period_id_12, a0_.building_id AS building_id_13, a0_.activity_instance_id_src_copy AS activity_instance_id_src_copy_14 FROM activity_instance a0_ LEFT JOIN activity_category a1_ ON a0_.activity_category_id = a1_.id LEFT JOIN period p2_ ON a0_.period_id = p2_.id WHERE (a1_.type_activity = 'GRP' AND ('2026-05-13 12:47:24' BETWEEN p2_.publicationDate AND p2_.end_registration_date) AND p2_.archived = 0 AND a0_.id IN (5321, 5320, 5319, 5318, 5317, 5315, 5313, 5312, 5311)) AND (a0_.deletedAt IS NULL) ORDER BY a0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.reg_val AS reg_val_2,
  t0.reg_pen AS reg_pen_3,
  t0.reg_wai AS reg_wai_4,
  t0.reg_req AS reg_req_5,
  t0.activity_instance_id AS activity_instance_id_6
FROM
  v_nb_participants_per_activity t0
WHERE
  t0.activity_instance_id = ?

SELECT t0.id AS id_1, t0.reg_val AS reg_val_2, t0.reg_pen AS reg_pen_3, t0.reg_wai AS reg_wai_4, t0.reg_req AS reg_req_5, t0.activity_instance_id AS activity_instance_id_6 FROM v_nb_participants_per_activity t0 WHERE t0.activity_instance_id = 5321;

SELECT
  t0.id AS id_1,
  t0.reg_val AS reg_val_2,
  t0.reg_pen AS reg_pen_3,
  t0.reg_wai AS reg_wai_4,
  t0.reg_req AS reg_req_5,
  t0.activity_instance_id AS activity_instance_id_6
FROM
  v_nb_participants_per_activity t0
WHERE
  t0.activity_instance_id = ?

SELECT t0.id AS id_1, t0.reg_val AS reg_val_2, t0.reg_pen AS reg_pen_3, t0.reg_wai AS reg_wai_4, t0.reg_req AS reg_req_5, t0.activity_instance_id AS activity_instance_id_6 FROM v_nb_participants_per_activity t0 WHERE t0.activity_instance_id = 5320;

SELECT
  t0.id AS id_1,
  t0.reg_val AS reg_val_2,
  t0.reg_pen AS reg_pen_3,
  t0.reg_wai AS reg_wai_4,
  t0.reg_req AS reg_req_5,
  t0.activity_instance_id AS activity_instance_id_6
FROM
  v_nb_participants_per_activity t0
WHERE
  t0.activity_instance_id = ?

SELECT t0.id AS id_1, t0.reg_val AS reg_val_2, t0.reg_pen AS reg_pen_3, t0.reg_wai AS reg_wai_4, t0.reg_req AS reg_req_5, t0.activity_instance_id AS activity_instance_id_6 FROM v_nb_participants_per_activity t0 WHERE t0.activity_instance_id = 5319;

SELECT
  t0.id AS id_1,
  t0.reg_val AS reg_val_2,
  t0.reg_pen AS reg_pen_3,
  t0.reg_wai AS reg_wai_4,
  t0.reg_req AS reg_req_5,
  t0.activity_instance_id AS activity_instance_id_6
FROM
  v_nb_participants_per_activity t0
WHERE
  t0.activity_instance_id = ?

SELECT t0.id AS id_1, t0.reg_val AS reg_val_2, t0.reg_pen AS reg_pen_3, t0.reg_wai AS reg_wai_4, t0.reg_req AS reg_req_5, t0.activity_instance_id AS activity_instance_id_6 FROM v_nb_participants_per_activity t0 WHERE t0.activity_instance_id = 5318;

SELECT
  t0.id AS id_1,
  t0.reg_val AS reg_val_2,
  t0.reg_pen AS reg_pen_3,
  t0.reg_wai AS reg_wai_4,
  t0.reg_req AS reg_req_5,
  t0.activity_instance_id AS activity_instance_id_6
FROM
  v_nb_participants_per_activity t0
WHERE
  t0.activity_instance_id = ?

SELECT t0.id AS id_1, t0.reg_val AS reg_val_2, t0.reg_pen AS reg_pen_3, t0.reg_wai AS reg_wai_4, t0.reg_req AS reg_req_5, t0.activity_instance_id AS activity_instance_id_6 FROM v_nb_participants_per_activity t0 WHERE t0.activity_instance_id = 5317;

SELECT
  t0.id AS id_1,
  t0.reg_val AS reg_val_2,
  t0.reg_pen AS reg_pen_3,
  t0.reg_wai AS reg_wai_4,
  t0.reg_req AS reg_req_5,
  t0.activity_instance_id AS activity_instance_id_6
FROM
  v_nb_participants_per_activity t0
WHERE
  t0.activity_instance_id = ?

SELECT t0.id AS id_1, t0.reg_val AS reg_val_2, t0.reg_pen AS reg_pen_3, t0.reg_wai AS reg_wai_4, t0.reg_req AS reg_req_5, t0.activity_instance_id AS activity_instance_id_6 FROM v_nb_participants_per_activity t0 WHERE t0.activity_instance_id = 5315;

SELECT
  t0.id AS id_1,
  t0.reg_val AS reg_val_2,
  t0.reg_pen AS reg_pen_3,
  t0.reg_wai AS reg_wai_4,
  t0.reg_req AS reg_req_5,
  t0.activity_instance_id AS activity_instance_id_6
FROM
  v_nb_participants_per_activity t0
WHERE
  t0.activity_instance_id = ?

SELECT t0.id AS id_1, t0.reg_val AS reg_val_2, t0.reg_pen AS reg_pen_3, t0.reg_wai AS reg_wai_4, t0.reg_req AS reg_req_5, t0.activity_instance_id AS activity_instance_id_6 FROM v_nb_participants_per_activity t0 WHERE t0.activity_instance_id = 5313;

SELECT
  t0.id AS id_1,
  t0.reg_val AS reg_val_2,
  t0.reg_pen AS reg_pen_3,
  t0.reg_wai AS reg_wai_4,
  t0.reg_req AS reg_req_5,
  t0.activity_instance_id AS activity_instance_id_6
FROM
  v_nb_participants_per_activity t0
WHERE
  t0.activity_instance_id = ?

SELECT t0.id AS id_1, t0.reg_val AS reg_val_2, t0.reg_pen AS reg_pen_3, t0.reg_wai AS reg_wai_4, t0.reg_req AS reg_req_5, t0.activity_instance_id AS activity_instance_id_6 FROM v_nb_participants_per_activity t0 WHERE t0.activity_instance_id = 5312;

SELECT
  t0.id AS id_1,
  t0.reg_val AS reg_val_2,
  t0.reg_pen AS reg_pen_3,
  t0.reg_wai AS reg_wai_4,
  t0.reg_req AS reg_req_5,
  t0.activity_instance_id AS activity_instance_id_6
FROM
  v_nb_participants_per_activity t0
WHERE
  t0.activity_instance_id = ?

SELECT t0.id AS id_1, t0.reg_val AS reg_val_2, t0.reg_pen AS reg_pen_3, t0.reg_wai AS reg_wai_4, t0.reg_req AS reg_req_5, t0.activity_instance_id AS activity_instance_id_6 FROM v_nb_participants_per_activity t0 WHERE t0.activity_instance_id = 5311;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.addInfo AS addInfo_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  activity_instance_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.addInfo AS addInfo_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM activity_instance_translation t0 WHERE t0.translatable_id = 5321;

SELECT
  t0.id AS id_1,
  t0.order_ihm AS order_ihm_2
FROM
  cycle t0
  INNER JOIN activity_cycle ON t0.id = activity_cycle.cycle_id
WHERE
  activity_cycle.activity_instance_id = ?

SELECT t0.id AS id_1, t0.order_ihm AS order_ihm_2 FROM cycle t0 INNER JOIN activity_cycle ON t0.id = activity_cycle.cycle_id WHERE activity_cycle.activity_instance_id = 5321;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  cycle_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM cycle_translation t0 WHERE t0.translatable_id = 41;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  cycle_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM cycle_translation t0 WHERE t0.translatable_id = 42;