Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.is_active AS is_active_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.disabled_at AS disabled_at_10,
  t0.last_login_at AS last_login_at_11
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.disabled_at AS disabled_at_10, t0.last_login_at AS last_login_at_11 FROM app_user t0 WHERE t0.id = 1;

SELECT
  p0_.id AS id_0,
  p0_.label AS label_1,
  p0_.start_date AS start_date_2,
  p0_.end_date AS end_date_3,
  p0_.effective_start_date AS effective_start_date_4,
  p0_.effective_end_date AS effective_end_date_5,
  p0_.is_active AS is_active_6,
  p0_.is_archived AS is_archived_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9
FROM
  promo p0_
ORDER BY
  p0_.is_archived ASC,
  p0_.is_active DESC,
  p0_.start_date DESC

SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.effective_start_date AS effective_start_date_4, p0_.effective_end_date AS effective_end_date_5, p0_.is_active AS is_active_6, p0_.is_archived AS is_archived_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9 FROM promo p0_ ORDER BY p0_.is_archived ASC, p0_.is_active DESC, p0_.start_date DESC;

SELECT
  p0_.id AS id_0,
  p0_.label AS label_1,
  p0_.start_date AS start_date_2,
  p0_.end_date AS end_date_3,
  p0_.effective_start_date AS effective_start_date_4,
  p0_.effective_end_date AS effective_end_date_5,
  p0_.is_active AS is_active_6,
  p0_.is_archived AS is_archived_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9
FROM
  promo p0_
WHERE
  p0_.is_active = ?
  AND p0_.is_archived = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.effective_start_date AS effective_start_date_4, p0_.effective_end_date AS effective_end_date_5, p0_.is_active AS is_active_6, p0_.is_archived AS is_archived_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9 FROM promo p0_ WHERE p0_.is_active = 1 AND p0_.is_archived = 0 LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.assigned_at AS assigned_at_1,
  e0_.is_active AS is_active_2,
  e0_.handicap_description AS handicap_description_3,
  e0_.aesh_support AS aesh_support_4,
  e0_.created_at AS created_at_5,
  e0_.updated_at AS updated_at_6,
  a1_.id AS id_7,
  a1_.email AS email_8,
  a1_.roles AS roles_9,
  a1_.password AS password_10,
  a1_.first_name AS first_name_11,
  a1_.last_name AS last_name_12,
  a1_.is_active AS is_active_13,
  a1_.created_at AS created_at_14,
  a1_.updated_at AS updated_at_15,
  a1_.disabled_at AS disabled_at_16,
  a1_.last_login_at AS last_login_at_17,
  p2_.id AS id_18,
  p2_.label AS label_19,
  p2_.start_date AS start_date_20,
  p2_.end_date AS end_date_21,
  p2_.effective_start_date AS effective_start_date_22,
  p2_.effective_end_date AS effective_end_date_23,
  p2_.is_active AS is_active_24,
  p2_.is_archived AS is_archived_25,
  p2_.created_at AS created_at_26,
  p2_.updated_at AS updated_at_27,
  s3_.id AS id_28,
  s3_.name AS name_29,
  s3_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_30,
  s3_.watch_enabled AS watch_enabled_31,
  s3_.stages_enabled AS stages_enabled_32,
  s3_.is_active AS is_active_33,
  s3_.created_at AS created_at_34,
  s3_.updated_at AS updated_at_35,
  e0_.student_id AS student_id_36,
  e0_.promo_id AS promo_id_37,
  e0_.school_class_id AS school_class_id_38
FROM
  enrollment e0_
  LEFT JOIN app_user a1_ ON e0_.student_id = a1_.id
  LEFT JOIN promo p2_ ON e0_.promo_id = p2_.id
  LEFT JOIN school_class s3_ ON e0_.school_class_id = s3_.id
WHERE
  e0_.promo_id = ?
ORDER BY
  p2_.start_date DESC,
  s3_.name ASC,
  a1_.last_name ASC,
  a1_.first_name ASC

SELECT e0_.id AS id_0, e0_.assigned_at AS assigned_at_1, e0_.is_active AS is_active_2, e0_.handicap_description AS handicap_description_3, e0_.aesh_support AS aesh_support_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, a1_.id AS id_7, a1_.email AS email_8, a1_.roles AS roles_9, a1_.password AS password_10, a1_.first_name AS first_name_11, a1_.last_name AS last_name_12, a1_.is_active AS is_active_13, a1_.created_at AS created_at_14, a1_.updated_at AS updated_at_15, a1_.disabled_at AS disabled_at_16, a1_.last_login_at AS last_login_at_17, p2_.id AS id_18, p2_.label AS label_19, p2_.start_date AS start_date_20, p2_.end_date AS end_date_21, p2_.effective_start_date AS effective_start_date_22, p2_.effective_end_date AS effective_end_date_23, p2_.is_active AS is_active_24, p2_.is_archived AS is_archived_25, p2_.created_at AS created_at_26, p2_.updated_at AS updated_at_27, s3_.id AS id_28, s3_.name AS name_29, s3_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_30, s3_.watch_enabled AS watch_enabled_31, s3_.stages_enabled AS stages_enabled_32, s3_.is_active AS is_active_33, s3_.created_at AS created_at_34, s3_.updated_at AS updated_at_35, e0_.student_id AS student_id_36, e0_.promo_id AS promo_id_37, e0_.school_class_id AS school_class_id_38 FROM enrollment e0_ LEFT JOIN app_user a1_ ON e0_.student_id = a1_.id LEFT JOIN promo p2_ ON e0_.promo_id = p2_.id LEFT JOIN school_class s3_ ON e0_.school_class_id = s3_.id WHERE e0_.promo_id = 1 ORDER BY p2_.start_date DESC, s3_.name ASC, a1_.last_name ASC, a1_.first_name ASC;

SELECT
  s0_.enrollment_id AS sclr_0,
  COUNT(s0_.id) AS sclr_1
FROM
  student_convocation s0_
WHERE
  s0_.enrollment_id IN (?, ?, ?)
  AND s0_.archived_at IS NULL
GROUP BY
  s0_.enrollment_id

SELECT s0_.enrollment_id AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM student_convocation s0_ WHERE s0_.enrollment_id IN (3, 1, 2) AND s0_.archived_at IS NULL GROUP BY s0_.enrollment_id;

SELECT
  a0_.enrollment_id AS sclr_0,
  COUNT(a0_.id) AS sclr_1
FROM
  ancillary_fee a0_
WHERE
  a0_.enrollment_id IN (?, ?, ?)
GROUP BY
  a0_.enrollment_id

SELECT a0_.enrollment_id AS sclr_0, COUNT(a0_.id) AS sclr_1 FROM ancillary_fee a0_ WHERE a0_.enrollment_id IN (3, 1, 2) GROUP BY a0_.enrollment_id;

SELECT
  a0_.enrollment_id AS sclr_0,
  SUM(a0_.amount) AS sclr_1
FROM
  ancillary_fee a0_
WHERE
  a0_.enrollment_id IN (?, ?, ?)
  AND a0_.status IN (?, ?, ?)
GROUP BY
  a0_.enrollment_id

SELECT a0_.enrollment_id AS sclr_0, SUM(a0_.amount) AS sclr_1 FROM ancillary_fee a0_ WHERE a0_.enrollment_id IN (3, 1, 2) AND a0_.status IN ('SUBMITTED', 'APPROVED', 'LOCKED') GROUP BY a0_.enrollment_id;

SELECT
  a0_.id AS id_0,
  a0_.type AS type_1,
  a0_.label AS label_2,
  a0_.description AS description_3,
  a0_.amount AS amount_4,
  a0_.status AS status_5,
  a0_.accounting_comment AS accounting_comment_6,
  a0_.processed_at AS processed_at_7,
  a0_.locked_at AS locked_at_8,
  a0_.created_at AS created_at_9,
  a0_.updated_at AS updated_at_10,
  a0_.cancelled_at AS cancelled_at_11,
  e1_.id AS id_12,
  e1_.assigned_at AS assigned_at_13,
  e1_.is_active AS is_active_14,
  e1_.handicap_description AS handicap_description_15,
  e1_.aesh_support AS aesh_support_16,
  e1_.created_at AS created_at_17,
  e1_.updated_at AS updated_at_18,
  a0_.student_id AS student_id_19,
  a0_.promo_id AS promo_id_20,
  a0_.enrollment_id AS enrollment_id_21,
  a0_.school_class_id AS school_class_id_22,
  a0_.created_by_id AS created_by_id_23,
  a0_.processed_by_id AS processed_by_id_24,
  a0_.locked_by_id AS locked_by_id_25,
  a0_.cancelled_by_id AS cancelled_by_id_26,
  e1_.student_id AS student_id_27,
  e1_.promo_id AS promo_id_28,
  e1_.school_class_id AS school_class_id_29
FROM
  ancillary_fee a0_
  LEFT JOIN enrollment e1_ ON a0_.enrollment_id = e1_.id
WHERE
  a0_.enrollment_id IN (?, ?, ?)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.label AS label_2, a0_.description AS description_3, a0_.amount AS amount_4, a0_.status AS status_5, a0_.accounting_comment AS accounting_comment_6, a0_.processed_at AS processed_at_7, a0_.locked_at AS locked_at_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.cancelled_at AS cancelled_at_11, e1_.id AS id_12, e1_.assigned_at AS assigned_at_13, e1_.is_active AS is_active_14, e1_.handicap_description AS handicap_description_15, e1_.aesh_support AS aesh_support_16, e1_.created_at AS created_at_17, e1_.updated_at AS updated_at_18, a0_.student_id AS student_id_19, a0_.promo_id AS promo_id_20, a0_.enrollment_id AS enrollment_id_21, a0_.school_class_id AS school_class_id_22, a0_.created_by_id AS created_by_id_23, a0_.processed_by_id AS processed_by_id_24, a0_.locked_by_id AS locked_by_id_25, a0_.cancelled_by_id AS cancelled_by_id_26, e1_.student_id AS student_id_27, e1_.promo_id AS promo_id_28, e1_.school_class_id AS school_class_id_29 FROM ancillary_fee a0_ LEFT JOIN enrollment e1_ ON a0_.enrollment_id = e1_.id WHERE a0_.enrollment_id IN (3, 1, 2) ORDER BY a0_.created_at DESC;

SELECT
  e0_.id AS id_0,
  e0_.assigned_at AS assigned_at_1,
  e0_.is_active AS is_active_2,
  e0_.handicap_description AS handicap_description_3,
  e0_.aesh_support AS aesh_support_4,
  e0_.created_at AS created_at_5,
  e0_.updated_at AS updated_at_6,
  a1_.id AS id_7,
  a1_.email AS email_8,
  a1_.roles AS roles_9,
  a1_.password AS password_10,
  a1_.first_name AS first_name_11,
  a1_.last_name AS last_name_12,
  a1_.is_active AS is_active_13,
  a1_.created_at AS created_at_14,
  a1_.updated_at AS updated_at_15,
  a1_.disabled_at AS disabled_at_16,
  a1_.last_login_at AS last_login_at_17,
  p2_.id AS id_18,
  p2_.label AS label_19,
  p2_.start_date AS start_date_20,
  p2_.end_date AS end_date_21,
  p2_.effective_start_date AS effective_start_date_22,
  p2_.effective_end_date AS effective_end_date_23,
  p2_.is_active AS is_active_24,
  p2_.is_archived AS is_archived_25,
  p2_.created_at AS created_at_26,
  p2_.updated_at AS updated_at_27,
  s3_.id AS id_28,
  s3_.name AS name_29,
  s3_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_30,
  s3_.watch_enabled AS watch_enabled_31,
  s3_.stages_enabled AS stages_enabled_32,
  s3_.is_active AS is_active_33,
  s3_.created_at AS created_at_34,
  s3_.updated_at AS updated_at_35,
  e0_.student_id AS student_id_36,
  e0_.promo_id AS promo_id_37,
  e0_.school_class_id AS school_class_id_38
FROM
  enrollment e0_
  LEFT JOIN app_user a1_ ON e0_.student_id = a1_.id
  LEFT JOIN promo p2_ ON e0_.promo_id = p2_.id
  LEFT JOIN school_class s3_ ON e0_.school_class_id = s3_.id
WHERE
  e0_.is_active = ?
ORDER BY
  p2_.start_date DESC,
  s3_.name ASC,
  a1_.last_name ASC,
  a1_.first_name ASC

SELECT e0_.id AS id_0, e0_.assigned_at AS assigned_at_1, e0_.is_active AS is_active_2, e0_.handicap_description AS handicap_description_3, e0_.aesh_support AS aesh_support_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, a1_.id AS id_7, a1_.email AS email_8, a1_.roles AS roles_9, a1_.password AS password_10, a1_.first_name AS first_name_11, a1_.last_name AS last_name_12, a1_.is_active AS is_active_13, a1_.created_at AS created_at_14, a1_.updated_at AS updated_at_15, a1_.disabled_at AS disabled_at_16, a1_.last_login_at AS last_login_at_17, p2_.id AS id_18, p2_.label AS label_19, p2_.start_date AS start_date_20, p2_.end_date AS end_date_21, p2_.effective_start_date AS effective_start_date_22, p2_.effective_end_date AS effective_end_date_23, p2_.is_active AS is_active_24, p2_.is_archived AS is_archived_25, p2_.created_at AS created_at_26, p2_.updated_at AS updated_at_27, s3_.id AS id_28, s3_.name AS name_29, s3_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_30, s3_.watch_enabled AS watch_enabled_31, s3_.stages_enabled AS stages_enabled_32, s3_.is_active AS is_active_33, s3_.created_at AS created_at_34, s3_.updated_at AS updated_at_35, e0_.student_id AS student_id_36, e0_.promo_id AS promo_id_37, e0_.school_class_id AS school_class_id_38 FROM enrollment e0_ LEFT JOIN app_user a1_ ON e0_.student_id = a1_.id LEFT JOIN promo p2_ ON e0_.promo_id = p2_.id LEFT JOIN school_class s3_ ON e0_.school_class_id = s3_.id WHERE e0_.is_active = 1 ORDER BY p2_.start_date DESC, s3_.name ASC, a1_.last_name ASC, a1_.first_name ASC;

SELECT
  f0_.id AS id_0,
  f0_.period_start AS period_start_1,
  f0_.period_end AS period_end_2,
  f0_.status AS status_3,
  f0_.validated_at AS validated_at_4,
  f0_.model_pdf_path AS model_pdf_path_5,
  f0_.signed_pdf_path AS signed_pdf_path_6,
  f0_.signed_pdf_uploaded_at AS signed_pdf_uploaded_at_7,
  f0_.created_at AS created_at_8,
  f0_.updated_at AS updated_at_9,
  e1_.id AS id_10,
  e1_.assigned_at AS assigned_at_11,
  e1_.is_active AS is_active_12,
  e1_.handicap_description AS handicap_description_13,
  e1_.aesh_support AS aesh_support_14,
  e1_.created_at AS created_at_15,
  e1_.updated_at AS updated_at_16,
  a2_.id AS id_17,
  a2_.email AS email_18,
  a2_.roles AS roles_19,
  a2_.password AS password_20,
  a2_.first_name AS first_name_21,
  a2_.last_name AS last_name_22,
  a2_.is_active AS is_active_23,
  a2_.created_at AS created_at_24,
  a2_.updated_at AS updated_at_25,
  a2_.disabled_at AS disabled_at_26,
  a2_.last_login_at AS last_login_at_27,
  p3_.id AS id_28,
  p3_.label AS label_29,
  p3_.start_date AS start_date_30,
  p3_.end_date AS end_date_31,
  p3_.effective_start_date AS effective_start_date_32,
  p3_.effective_end_date AS effective_end_date_33,
  p3_.is_active AS is_active_34,
  p3_.is_archived AS is_archived_35,
  p3_.created_at AS created_at_36,
  p3_.updated_at AS updated_at_37,
  s4_.id AS id_38,
  s4_.name AS name_39,
  s4_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_40,
  s4_.watch_enabled AS watch_enabled_41,
  s4_.stages_enabled AS stages_enabled_42,
  s4_.is_active AS is_active_43,
  s4_.created_at AS created_at_44,
  s4_.updated_at AS updated_at_45,
  f0_.enrollment_id AS enrollment_id_46,
  f0_.student_id AS student_id_47,
  f0_.promo_id AS promo_id_48,
  f0_.school_class_id AS school_class_id_49,
  e1_.student_id AS student_id_50,
  e1_.promo_id AS promo_id_51,
  e1_.school_class_id AS school_class_id_52
FROM
  follow_up_sheet f0_
  LEFT JOIN enrollment e1_ ON f0_.enrollment_id = e1_.id
  LEFT JOIN app_user a2_ ON f0_.student_id = a2_.id
  LEFT JOIN promo p3_ ON f0_.promo_id = p3_.id
  LEFT JOIN school_class s4_ ON f0_.school_class_id = s4_.id
WHERE
  f0_.enrollment_id IN (?, ?, ?)
ORDER BY
  a2_.last_name ASC,
  a2_.first_name ASC,
  f0_.period_start ASC

SELECT f0_.id AS id_0, f0_.period_start AS period_start_1, f0_.period_end AS period_end_2, f0_.status AS status_3, f0_.validated_at AS validated_at_4, f0_.model_pdf_path AS model_pdf_path_5, f0_.signed_pdf_path AS signed_pdf_path_6, f0_.signed_pdf_uploaded_at AS signed_pdf_uploaded_at_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9, e1_.id AS id_10, e1_.assigned_at AS assigned_at_11, e1_.is_active AS is_active_12, e1_.handicap_description AS handicap_description_13, e1_.aesh_support AS aesh_support_14, e1_.created_at AS created_at_15, e1_.updated_at AS updated_at_16, a2_.id AS id_17, a2_.email AS email_18, a2_.roles AS roles_19, a2_.password AS password_20, a2_.first_name AS first_name_21, a2_.last_name AS last_name_22, a2_.is_active AS is_active_23, a2_.created_at AS created_at_24, a2_.updated_at AS updated_at_25, a2_.disabled_at AS disabled_at_26, a2_.last_login_at AS last_login_at_27, p3_.id AS id_28, p3_.label AS label_29, p3_.start_date AS start_date_30, p3_.end_date AS end_date_31, p3_.effective_start_date AS effective_start_date_32, p3_.effective_end_date AS effective_end_date_33, p3_.is_active AS is_active_34, p3_.is_archived AS is_archived_35, p3_.created_at AS created_at_36, p3_.updated_at AS updated_at_37, s4_.id AS id_38, s4_.name AS name_39, s4_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_40, s4_.watch_enabled AS watch_enabled_41, s4_.stages_enabled AS stages_enabled_42, s4_.is_active AS is_active_43, s4_.created_at AS created_at_44, s4_.updated_at AS updated_at_45, f0_.enrollment_id AS enrollment_id_46, f0_.student_id AS student_id_47, f0_.promo_id AS promo_id_48, f0_.school_class_id AS school_class_id_49, e1_.student_id AS student_id_50, e1_.promo_id AS promo_id_51, e1_.school_class_id AS school_class_id_52 FROM follow_up_sheet f0_ LEFT JOIN enrollment e1_ ON f0_.enrollment_id = e1_.id LEFT JOIN app_user a2_ ON f0_.student_id = a2_.id LEFT JOIN promo p3_ ON f0_.promo_id = p3_.id LEFT JOIN school_class s4_ ON f0_.school_class_id = s4_.id WHERE f0_.enrollment_id IN (3, 1, 2) ORDER BY a2_.last_name ASC, a2_.first_name ASC, f0_.period_start ASC;

SELECT
  f0_.id AS id_0,
  f0_.period_start AS period_start_1,
  f0_.period_end AS period_end_2,
  f0_.status AS status_3,
  f0_.validated_at AS validated_at_4,
  f0_.model_pdf_path AS model_pdf_path_5,
  f0_.signed_pdf_path AS signed_pdf_path_6,
  f0_.signed_pdf_uploaded_at AS signed_pdf_uploaded_at_7,
  f0_.created_at AS created_at_8,
  f0_.updated_at AS updated_at_9,
  e1_.id AS id_10,
  e1_.assigned_at AS assigned_at_11,
  e1_.is_active AS is_active_12,
  e1_.handicap_description AS handicap_description_13,
  e1_.aesh_support AS aesh_support_14,
  e1_.created_at AS created_at_15,
  e1_.updated_at AS updated_at_16,
  a2_.id AS id_17,
  a2_.email AS email_18,
  a2_.roles AS roles_19,
  a2_.password AS password_20,
  a2_.first_name AS first_name_21,
  a2_.last_name AS last_name_22,
  a2_.is_active AS is_active_23,
  a2_.created_at AS created_at_24,
  a2_.updated_at AS updated_at_25,
  a2_.disabled_at AS disabled_at_26,
  a2_.last_login_at AS last_login_at_27,
  p3_.id AS id_28,
  p3_.label AS label_29,
  p3_.start_date AS start_date_30,
  p3_.end_date AS end_date_31,
  p3_.effective_start_date AS effective_start_date_32,
  p3_.effective_end_date AS effective_end_date_33,
  p3_.is_active AS is_active_34,
  p3_.is_archived AS is_archived_35,
  p3_.created_at AS created_at_36,
  p3_.updated_at AS updated_at_37,
  s4_.id AS id_38,
  s4_.name AS name_39,
  s4_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_40,
  s4_.watch_enabled AS watch_enabled_41,
  s4_.stages_enabled AS stages_enabled_42,
  s4_.is_active AS is_active_43,
  s4_.created_at AS created_at_44,
  s4_.updated_at AS updated_at_45,
  f0_.enrollment_id AS enrollment_id_46,
  f0_.student_id AS student_id_47,
  f0_.promo_id AS promo_id_48,
  f0_.school_class_id AS school_class_id_49,
  e1_.student_id AS student_id_50,
  e1_.promo_id AS promo_id_51,
  e1_.school_class_id AS school_class_id_52
FROM
  follow_up_sheet f0_
  LEFT JOIN enrollment e1_ ON f0_.enrollment_id = e1_.id
  LEFT JOIN app_user a2_ ON f0_.student_id = a2_.id
  LEFT JOIN promo p3_ ON f0_.promo_id = p3_.id
  LEFT JOIN school_class s4_ ON f0_.school_class_id = s4_.id
WHERE
  f0_.enrollment_id IN (?, ?, ?)
ORDER BY
  a2_.last_name ASC,
  a2_.first_name ASC,
  f0_.period_start ASC

SELECT f0_.id AS id_0, f0_.period_start AS period_start_1, f0_.period_end AS period_end_2, f0_.status AS status_3, f0_.validated_at AS validated_at_4, f0_.model_pdf_path AS model_pdf_path_5, f0_.signed_pdf_path AS signed_pdf_path_6, f0_.signed_pdf_uploaded_at AS signed_pdf_uploaded_at_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9, e1_.id AS id_10, e1_.assigned_at AS assigned_at_11, e1_.is_active AS is_active_12, e1_.handicap_description AS handicap_description_13, e1_.aesh_support AS aesh_support_14, e1_.created_at AS created_at_15, e1_.updated_at AS updated_at_16, a2_.id AS id_17, a2_.email AS email_18, a2_.roles AS roles_19, a2_.password AS password_20, a2_.first_name AS first_name_21, a2_.last_name AS last_name_22, a2_.is_active AS is_active_23, a2_.created_at AS created_at_24, a2_.updated_at AS updated_at_25, a2_.disabled_at AS disabled_at_26, a2_.last_login_at AS last_login_at_27, p3_.id AS id_28, p3_.label AS label_29, p3_.start_date AS start_date_30, p3_.end_date AS end_date_31, p3_.effective_start_date AS effective_start_date_32, p3_.effective_end_date AS effective_end_date_33, p3_.is_active AS is_active_34, p3_.is_archived AS is_archived_35, p3_.created_at AS created_at_36, p3_.updated_at AS updated_at_37, s4_.id AS id_38, s4_.name AS name_39, s4_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_40, s4_.watch_enabled AS watch_enabled_41, s4_.stages_enabled AS stages_enabled_42, s4_.is_active AS is_active_43, s4_.created_at AS created_at_44, s4_.updated_at AS updated_at_45, f0_.enrollment_id AS enrollment_id_46, f0_.student_id AS student_id_47, f0_.promo_id AS promo_id_48, f0_.school_class_id AS school_class_id_49, e1_.student_id AS student_id_50, e1_.promo_id AS promo_id_51, e1_.school_class_id AS school_class_id_52 FROM follow_up_sheet f0_ LEFT JOIN enrollment e1_ ON f0_.enrollment_id = e1_.id LEFT JOIN app_user a2_ ON f0_.student_id = a2_.id LEFT JOIN promo p3_ ON f0_.promo_id = p3_.id LEFT JOIN school_class s4_ ON f0_.school_class_id = s4_.id WHERE f0_.enrollment_id IN (3, 1, 2) ORDER BY a2_.last_name ASC, a2_.first_name ASC, f0_.period_start ASC;

SELECT
  s0_.id AS id_0,
  s0_.start_date AS start_date_1,
  s0_.end_date AS end_date_2,
  s0_.status AS status_3,
  s0_.break_reason AS break_reason_4,
  s0_.contract_cost AS contract_cost_5,
  s0_.broken_at AS broken_at_6,
  s0_.ended_at AS ended_at_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9,
  c1_.id AS id_10,
  c1_.name AS name_11,
  c1_.generic_email AS generic_email_12,
  c1_.address AS address_13,
  c1_.postal_code AS postal_code_14,
  c1_.city AS city_15,
  c1_.siret AS siret_16,
  c1_.naf_ape AS naf_ape_17,
  c1_.legal_form AS legal_form_18,
  c1_.sector AS sector_19,
  c1_.is_active AS is_active_20,
  c1_.created_at AS created_at_21,
  c1_.updated_at AS updated_at_22,
  c2_.id AS id_23,
  c2_.first_name AS first_name_24,
  c2_.last_name AS last_name_25,
  c2_.email AS email_26,
  c2_.phone AS phone_27,
  c2_.is_active AS is_active_28,
  c2_.created_at AS created_at_29,
  c2_.updated_at AS updated_at_30,
  e3_.id AS id_31,
  e3_.assigned_at AS assigned_at_32,
  e3_.is_active AS is_active_33,
  e3_.handicap_description AS handicap_description_34,
  e3_.aesh_support AS aesh_support_35,
  e3_.created_at AS created_at_36,
  e3_.updated_at AS updated_at_37,
  s0_.student_id AS student_id_38,
  s0_.enrollment_id AS enrollment_id_39,
  s0_.promo_id AS promo_id_40,
  s0_.company_id AS company_id_41,
  s0_.company_tutor_id AS company_tutor_id_42,
  c2_.company_id AS company_id_43,
  e3_.student_id AS student_id_44,
  e3_.promo_id AS promo_id_45,
  e3_.school_class_id AS school_class_id_46
FROM
  student_contract s0_
  LEFT JOIN company c1_ ON s0_.company_id = c1_.id
  LEFT JOIN company_tutor c2_ ON s0_.company_tutor_id = c2_.id
  LEFT JOIN enrollment e3_ ON s0_.enrollment_id = e3_.id
WHERE
  s0_.enrollment_id IN (?, ?, ?)
  AND s0_.status = ?