Symfony Profiler

SELECT
  t0.first_name AS first_name_1,
  t0.last_name AS last_name_2,
  t0.relationship AS relationship_3,
  t0.phone AS phone_4,
  t0.secondary_phone AS secondary_phone_5,
  t0.email AS email_6,
  t0.occupation AS occupation_7,
  t0.address AS address_8,
  t0.is_primary_contact AS is_primary_contact_9,
  t0.can_pickup AS can_pickup_10,
  t0.id AS id_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.user_id AS user_id_15
FROM
  guardians t0
  INNER JOIN student_guardians ON t0.id = student_guardians.guardian_id
WHERE
  student_guardians.student_id = ?

SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.relationship AS relationship_3, t0.phone AS phone_4, t0.secondary_phone AS secondary_phone_5, t0.email AS email_6, t0.occupation AS occupation_7, t0.address AS address_8, t0.is_primary_contact AS is_primary_contact_9, t0.can_pickup AS can_pickup_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.user_id AS user_id_15 FROM guardians t0 INNER JOIN student_guardians ON t0.id = student_guardians.guardian_id WHERE student_guardians.student_id = '019c9b01-a1a4-74b2-ad7c-de95da57b354';

SELECT
  t0.enrollment_number AS enrollment_number_1,
  t0.enrollment_type AS enrollment_type_2,
  t0.enrollment_date AS enrollment_date_3,
  t0.status AS status_4,
  t0.validation_date AS validation_date_5,
  t0.notes AS notes_6,
  t0.cancellation_reason AS cancellation_reason_7,
  t0.id AS id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.academic_year_id AS academic_year_id_12,
  t0.section_id AS section_id_13,
  t0.student_id AS student_id_14,
  t0.validated_by_id AS validated_by_id_15,
  t0.cancelled_by_id AS cancelled_by_id_16
FROM
  enrollments t0
WHERE
  t0.student_id = ?

SELECT t0.enrollment_number AS enrollment_number_1, t0.enrollment_type AS enrollment_type_2, t0.enrollment_date AS enrollment_date_3, t0.status AS status_4, t0.validation_date AS validation_date_5, t0.notes AS notes_6, t0.cancellation_reason AS cancellation_reason_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.academic_year_id AS academic_year_id_12, t0.section_id AS section_id_13, t0.student_id AS student_id_14, t0.validated_by_id AS validated_by_id_15, t0.cancelled_by_id AS cancelled_by_id_16 FROM enrollments t0 WHERE t0.student_id = '019c9b01-a1a4-74b2-ad7c-de95da57b354';

SELECT
  t0.registration_number AS registration_number_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.date_of_birth AS date_of_birth_4,
  t0.place_of_birth AS place_of_birth_5,
  t0.gender AS gender_6,
  t0.photo AS photo_7,
  t0.nationality AS nationality_8,
  t0.address AS address_9,
  t0.personal_email AS personal_email_10,
  t0.personal_phone AS personal_phone_11,
  t0.initial_enrollment_date AS initial_enrollment_date_12,
  t0.previous_school AS previous_school_13,
  t0.current_status AS current_status_14,
  t0.id AS id_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.deleted_at AS deleted_at_18,
  t0.establishment_id AS establishment_id_19,
  t0.financial_guardian_id AS financial_guardian_id_20
FROM
  students t0
  INNER JOIN student_guardians ON t0.id = student_guardians.student_id
WHERE
  student_guardians.guardian_id = ?

SELECT t0.registration_number AS registration_number_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.date_of_birth AS date_of_birth_4, t0.place_of_birth AS place_of_birth_5, t0.gender AS gender_6, t0.photo AS photo_7, t0.nationality AS nationality_8, t0.address AS address_9, t0.personal_email AS personal_email_10, t0.personal_phone AS personal_phone_11, t0.initial_enrollment_date AS initial_enrollment_date_12, t0.previous_school AS previous_school_13, t0.current_status AS current_status_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18, t0.establishment_id AS establishment_id_19, t0.financial_guardian_id AS financial_guardian_id_20 FROM students t0 INNER JOIN student_guardians ON t0.id = student_guardians.student_id WHERE student_guardians.guardian_id = '019c9b00-6c0d-77c4-8570-b764b12c0567';

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  enrollments e0_
  LEFT JOIN students s1_ ON e0_.student_id = s1_.id
  LEFT JOIN academic_years a2_ ON e0_.academic_year_id = a2_.id
  LEFT JOIN sections s3_ ON e0_.section_id = s3_.id
WHERE
  e0_.deleted_at IS NULL
  AND s1_.establishment_id = ?
  AND s1_.deleted_at IS NULL
  AND e0_.status = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM enrollments e0_ LEFT JOIN students s1_ ON e0_.student_id = s1_.id LEFT JOIN academic_years a2_ ON e0_.academic_year_id = a2_.id LEFT JOIN sections s3_ ON e0_.section_id = s3_.id WHERE e0_.deleted_at IS NULL AND s1_.establishment_id = '019c6bc6-7a9f-74a1-8839-c09403fb8f9b' AND s1_.deleted_at IS NULL AND e0_.status = 'PENDING';

SELECT
  t0.registration_number AS registration_number_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.date_of_birth AS date_of_birth_4,
  t0.place_of_birth AS place_of_birth_5,
  t0.gender AS gender_6,
  t0.photo AS photo_7,
  t0.nationality AS nationality_8,
  t0.address AS address_9,
  t0.personal_email AS personal_email_10,
  t0.personal_phone AS personal_phone_11,
  t0.initial_enrollment_date AS initial_enrollment_date_12,
  t0.previous_school AS previous_school_13,
  t0.current_status AS current_status_14,
  t0.id AS id_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.deleted_at AS deleted_at_18,
  t0.establishment_id AS establishment_id_19,
  t0.financial_guardian_id AS financial_guardian_id_20
FROM
  students t0
WHERE
  t0.id = ?

SELECT t0.registration_number AS registration_number_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.date_of_birth AS date_of_birth_4, t0.place_of_birth AS place_of_birth_5, t0.gender AS gender_6, t0.photo AS photo_7, t0.nationality AS nationality_8, t0.address AS address_9, t0.personal_email AS personal_email_10, t0.personal_phone AS personal_phone_11, t0.initial_enrollment_date AS initial_enrollment_date_12, t0.previous_school AS previous_school_13, t0.current_status AS current_status_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18, t0.establishment_id AS establishment_id_19, t0.financial_guardian_id AS financial_guardian_id_20 FROM students t0 WHERE t0.id = '019c94bf-43b8-7533-9f0b-285d95e3b194';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  academic_years a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.establishment_id = ?
  AND a0_.is_active = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM academic_years a0_ WHERE a0_.deleted_at IS NULL AND a0_.establishment_id = '019c6bc6-7a9f-74a1-8839-c09403fb8f9b' AND a0_.is_active = 1;

SELECT
  t0.name AS name_1,
  t0.code AS code_2,
  t0.types AS types_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.postal_code AS postal_code_6,
  t0.phone AS phone_7,
  t0.email AS email_8,
  t0.website AS website_9,
  t0.logo AS logo_10,
  t0.director AS director_11,
  t0.slogan AS slogan_12,
  t0.tenant_key AS tenant_key_13,
  t0.due_day_at AS due_day_at_14,
  t0.id AS id_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.deleted_at AS deleted_at_18,
  t0.is_active AS is_active_19
FROM
  establishments t0
  INNER JOIN user_establishments ON t0.id = user_establishments.establishment_id
WHERE
  user_establishments.user_id = ?

SELECT t0.name AS name_1, t0.code AS code_2, t0.types AS types_3, t0.address AS address_4, t0.city AS city_5, t0.postal_code AS postal_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.website AS website_9, t0.logo AS logo_10, t0.director AS director_11, t0.slogan AS slogan_12, t0.tenant_key AS tenant_key_13, t0.due_day_at AS due_day_at_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18, t0.is_active AS is_active_19 FROM establishments t0 INNER JOIN user_establishments ON t0.id = user_establishments.establishment_id WHERE user_establishments.user_id = '019cd0ec-7eee-7412-9ac2-b8f3d874390d';

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.phone AS phone_6,
  t0.gender AS gender_7,
  t0.id AS id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.is_active AS is_active_12
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.gender AS gender_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.is_active AS is_active_12 FROM users t0 WHERE t0.id = '019cd0ec-7eee-7412-9ac2-b8f3d874390d';

SELECT
  a0_.label AS label_0,
  a0_.start_date AS start_date_1,
  a0_.end_date AS end_date_2,
  a0_.enrollment_start_date AS enrollment_start_date_3,
  a0_.enrollment_end_date AS enrollment_end_date_4,
  a0_.id AS id_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.deleted_at AS deleted_at_8,
  a0_.is_active AS is_active_9,
  a0_.establishment_id AS establishment_id_10
FROM
  academic_years a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.establishment_id = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.created_at DESC
LIMIT
  50

SELECT a0_.label AS label_0, a0_.start_date AS start_date_1, a0_.end_date AS end_date_2, a0_.enrollment_start_date AS enrollment_start_date_3, a0_.enrollment_end_date AS enrollment_end_date_4, a0_.id AS id_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.deleted_at AS deleted_at_8, a0_.is_active AS is_active_9, a0_.establishment_id AS establishment_id_10 FROM academic_years a0_ WHERE a0_.deleted_at IS NULL AND a0_.establishment_id = '019c6bc6-7a9f-74a1-8839-c09403fb8f9b' AND a0_.is_active = 1 ORDER BY a0_.created_at DESC LIMIT 50;

SELECT
  e0_.enrollment_number AS enrollment_number_0,
  e0_.enrollment_type AS enrollment_type_1,
  e0_.enrollment_date AS enrollment_date_2,
  e0_.status AS status_3,
  e0_.validation_date AS validation_date_4,
  e0_.notes AS notes_5,
  e0_.cancellation_reason AS cancellation_reason_6,
  e0_.id AS id_7,
  e0_.created_at AS created_at_8,
  e0_.updated_at AS updated_at_9,
  e0_.deleted_at AS deleted_at_10,
  e0_.academic_year_id AS academic_year_id_11,
  e0_.section_id AS section_id_12,
  e0_.student_id AS student_id_13,
  e0_.validated_by_id AS validated_by_id_14,
  e0_.cancelled_by_id AS cancelled_by_id_15
FROM
  enrollments e0_
  LEFT JOIN students s1_ ON e0_.student_id = s1_.id
  LEFT JOIN academic_years a2_ ON e0_.academic_year_id = a2_.id
  LEFT JOIN sections s3_ ON e0_.section_id = s3_.id
WHERE
  e0_.deleted_at IS NULL
  AND s1_.establishment_id = ?
  AND s1_.deleted_at IS NULL
  AND e0_.status = ?
ORDER BY
  e0_.enrollment_date DESC
LIMIT
  5

SELECT e0_.enrollment_number AS enrollment_number_0, e0_.enrollment_type AS enrollment_type_1, e0_.enrollment_date AS enrollment_date_2, e0_.status AS status_3, e0_.validation_date AS validation_date_4, e0_.notes AS notes_5, e0_.cancellation_reason AS cancellation_reason_6, e0_.id AS id_7, e0_.created_at AS created_at_8, e0_.updated_at AS updated_at_9, e0_.deleted_at AS deleted_at_10, e0_.academic_year_id AS academic_year_id_11, e0_.section_id AS section_id_12, e0_.student_id AS student_id_13, e0_.validated_by_id AS validated_by_id_14, e0_.cancelled_by_id AS cancelled_by_id_15 FROM enrollments e0_ LEFT JOIN students s1_ ON e0_.student_id = s1_.id LEFT JOIN academic_years a2_ ON e0_.academic_year_id = a2_.id LEFT JOIN sections s3_ ON e0_.section_id = s3_.id WHERE e0_.deleted_at IS NULL AND s1_.establishment_id = '019c6bc6-7a9f-74a1-8839-c09403fb8f9b' AND s1_.deleted_at IS NULL AND e0_.status = 'PENDING' ORDER BY e0_.enrollment_date DESC LIMIT 5;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sections s0_
WHERE
  s0_.deleted_at IS NULL
  AND s0_.establishment_id = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sections s0_ WHERE s0_.deleted_at IS NULL AND s0_.establishment_id = '019c6bc6-7a9f-74a1-8839-c09403fb8f9b';

SELECT
  DISTINCT s0_.registration_number AS registration_number_0,
  s0_.first_name AS first_name_1,
  s0_.last_name AS last_name_2,
  s0_.date_of_birth AS date_of_birth_3,
  s0_.place_of_birth AS place_of_birth_4,
  s0_.gender AS gender_5,
  s0_.photo AS photo_6,
  s0_.nationality AS nationality_7,
  s0_.address AS address_8,
  s0_.personal_email AS personal_email_9,
  s0_.personal_phone AS personal_phone_10,
  s0_.initial_enrollment_date AS initial_enrollment_date_11,
  s0_.previous_school AS previous_school_12,
  s0_.current_status AS current_status_13,
  s0_.id AS id_14,
  s0_.created_at AS created_at_15,
  s0_.updated_at AS updated_at_16,
  s0_.deleted_at AS deleted_at_17,
  s0_.establishment_id AS establishment_id_18,
  s0_.financial_guardian_id AS financial_guardian_id_19
FROM
  students s0_
WHERE
  s0_.deleted_at IS NULL
  AND s0_.establishment_id = ?
ORDER BY
  s0_.last_name ASC

SELECT DISTINCT s0_.registration_number AS registration_number_0, s0_.first_name AS first_name_1, s0_.last_name AS last_name_2, s0_.date_of_birth AS date_of_birth_3, s0_.place_of_birth AS place_of_birth_4, s0_.gender AS gender_5, s0_.photo AS photo_6, s0_.nationality AS nationality_7, s0_.address AS address_8, s0_.personal_email AS personal_email_9, s0_.personal_phone AS personal_phone_10, s0_.initial_enrollment_date AS initial_enrollment_date_11, s0_.previous_school AS previous_school_12, s0_.current_status AS current_status_13, s0_.id AS id_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16, s0_.deleted_at AS deleted_at_17, s0_.establishment_id AS establishment_id_18, s0_.financial_guardian_id AS financial_guardian_id_19 FROM students s0_ WHERE s0_.deleted_at IS NULL AND s0_.establishment_id = '019c6bc6-7a9f-74a1-8839-c09403fb8f9b' ORDER BY s0_.last_name ASC;

SELECT
  s0_.name AS name_0,
  s0_.max_capacity AS max_capacity_1,
  s0_.current_capacity AS current_capacity_2,
  s0_.room AS room_3,
  s0_.schooling_months AS schooling_months_4,
  s0_.id AS id_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7,
  s0_.deleted_at AS deleted_at_8,
  s0_.establishment_id AS establishment_id_9
FROM
  sections s0_
WHERE
  s0_.deleted_at IS NULL
  AND s0_.establishment_id = ?
ORDER BY
  s0_.created_at DESC
LIMIT
  50

SELECT s0_.name AS name_0, s0_.max_capacity AS max_capacity_1, s0_.current_capacity AS current_capacity_2, s0_.room AS room_3, s0_.schooling_months AS schooling_months_4, s0_.id AS id_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.deleted_at AS deleted_at_8, s0_.establishment_id AS establishment_id_9 FROM sections s0_ WHERE s0_.deleted_at IS NULL AND s0_.establishment_id = '019c6bc6-7a9f-74a1-8839-c09403fb8f9b' ORDER BY s0_.created_at DESC LIMIT 50;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  students s0_
WHERE
  s0_.deleted_at IS NULL
  AND s0_.establishment_id = ?

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM students s0_ WHERE s0_.deleted_at IS NULL AND s0_.establishment_id = '019c6bc6-7a9f-74a1-8839-c09403fb8f9b';