Redirect 302 redirect from GET @app.establishment.index (336489)

GET https://ianatra.mypreprod.xyz/establishment/dashboard

Query Metrics

128 Database Queries
14 Different statements
70.53 ms Query time
0 Invalid entities
192 Managed entities

Queries

Group similar statements

# Time Info
1 1.32 ms
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 = ?
Parameters:
[
  "019cd0ec-7eee-7412-9ac2-b8f3d874390d"
]
2 1.83 ms
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 = ?
Parameters:
[
  "019cd0ec-7eee-7412-9ac2-b8f3d874390d"
]
3 1.93 ms
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 = ?
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1318
    __toString(): "019c6bc6-7a9f-74a1-8839-c09403fb8f9b"
  }
  1
]
4 1.07 ms
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
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1318
    __toString(): "019c6bc6-7a9f-74a1-8839-c09403fb8f9b"
  }
  1
]
5 0.96 ms
SELECT COUNT(s0_.id) AS sclr_0 FROM sections s0_ WHERE s0_.deleted_at IS NULL AND s0_.establishment_id = ?
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1508
    __toString(): "019c6bc6-7a9f-74a1-8839-c09403fb8f9b"
  }
]
6 0.57 ms
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
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1508
    __toString(): "019c6bc6-7a9f-74a1-8839-c09403fb8f9b"
  }
]
7 2.44 ms
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 = ?
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1741
    __toString(): "019c6bc6-7a9f-74a1-8839-c09403fb8f9b"
  }
  "PENDING"
]
8 1.06 ms
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
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1741
    __toString(): "019c6bc6-7a9f-74a1-8839-c09403fb8f9b"
  }
  "PENDING"
]
9 0.85 ms
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 = ?
Parameters:
[
  "019c94bf-43b8-7533-9f0b-285d95e3b194"
]
10 0.33 ms
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 = ?
Parameters:
[
  "019cdc17-cd9b-7278-b2a5-fb7eb502704a"
]
11 0.22 ms
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 = ?
Parameters:
[
  "019cb7cd-86e3-7d70-b020-b2de0465ba8e"
]
12 0.40 ms
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 = ?
Parameters:
[
  "019cb7cc-95cd-7f78-b2fd-fb8360d1cad7"
]
13 0.47 ms
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 = ?
Parameters:
[
  "019c94f1-24bb-7d21-a441-e006e2938a7f"
]
14 0.43 ms
SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM students s0_ WHERE s0_.deleted_at IS NULL AND s0_.establishment_id = ?
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1824
    __toString(): "019c6bc6-7a9f-74a1-8839-c09403fb8f9b"
  }
]
15 0.69 ms
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
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1824
    __toString(): "019c6bc6-7a9f-74a1-8839-c09403fb8f9b"
  }
]
16 1.00 ms
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 = ?
Parameters:
[
  "019c9b01-a1a4-74b2-ad7c-de95da57b354"
]
17 0.44 ms
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 = ?
Parameters:
[
  "019c9b00-6c0d-77c4-8570-b764b12c0567"
]
18 0.23 ms
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 = ?
Parameters:
[
  "019c9b01-a1a4-74b2-ad7c-de95da57b354"
]
19 0.25 ms
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 = ?
Parameters:
[
  "019c8acd-dbd3-79e6-9d66-2ad9e971e29b"
]
20 0.23 ms
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 = ?
Parameters:
[
  "019c8abd-bafc-764f-80dd-62d53d71c721"
]
21 0.20 ms
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 = ?
Parameters:
[
  "019c8acd-dbd3-79e6-9d66-2ad9e971e29b"
]
22 0.21 ms
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 = ?
Parameters:
[
  "019eb6fa-0f82-7c10-a1f3-a34b6679868f"
]
23 0.24 ms
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 = ?
Parameters:
[
  "019eb6fa-0f7d-75f0-8c5b-6fd7b68e0d9b"
]
24 0.18 ms
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 = ?
Parameters:
[
  "019eb6fa-0d53-7173-91fb-ae582e7a8f99"
]
25 0.13 ms
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 = ?
Parameters:
[
  "019eb6fa-0f82-7c10-a1f3-a34b6679868f"
]
26 0.18 ms
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 = ?
Parameters:
[
  "019e0678-f46d-734b-be5a-00c910792601"
]
27 0.16 ms
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 = ?
Parameters:
[
  "019e0678-ef84-71f5-a4e2-411f4247b910"
]
28 0.16 ms
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 = ?
Parameters:
[
  "019e0678-f467-7f3d-86e7-3076fa0c0853"
]
29 0.14 ms
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 = ?
Parameters:
[
  "019e0678-f46d-734b-be5a-00c910792601"
]
30 0.25 ms
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 = ?
Parameters:
[
  "019c9dbf-20b5-7d2b-9685-46b3e8562b8d"
]
31 0.16 ms
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 = ?
Parameters:
[
  "019c9dbf-20b5-7d2b-9685-46b3e8562b8d"
]
32 0.34 ms
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 = ?
Parameters:
[
  "019c9dbc-bb20-7f1e-b5cd-6574ebf70c80"
]
33 0.31 ms
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 = ?
Parameters:
[
  "019c9dbc-bb20-7f1e-b5cd-6574ebf70c80"
]
34 0.43 ms
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 = ?
Parameters:
[
  "019c9b1d-6709-77ff-8149-ed11b11f2823"
]
35 0.49 ms
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 = ?
Parameters:
[
  "019c6bce-21da-7873-b58d-34ba965b533a"
]
36 0.32 ms
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 = ?
Parameters:
[
  "019c88ef-259d-75d9-b040-3a7e72e8fa08"
]
37 0.38 ms
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 = ?
Parameters:
[
  "019c94cf-0c41-78d5-b7fa-3fb8721d9c6c"
]
38 0.26 ms
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 = ?
Parameters:
[
  "019c94f9-78c6-7772-9ffe-29aed73ae90c"
]
39 0.18 ms
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 = ?
Parameters:
[
  "019c9b1d-6709-77ff-8149-ed11b11f2823"
]
40 0.24 ms
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 = ?
Parameters:
[
  "019c8a0f-e2bc-74a1-87de-6cd4ac2700d2"
]
41 0.16 ms
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 = ?
Parameters:
[
  "019c8a0f-e2bc-74a1-87de-6cd4ac2700d2"
]
42 0.22 ms
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 = ?
Parameters:
[
  "019c94f1-24bb-7d21-a441-e006e2938a7f"
]
43 0.17 ms
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 = ?
Parameters:
[
  "019c94f1-24bb-7d21-a441-e006e2938a7f"
]
44 0.21 ms
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 = ?
Parameters:
[
  "019c99f6-b0f4-74b7-92ed-d2d714186a55"
]
45 0.24 ms
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 = ?
Parameters:
[
  "019c99f0-48e9-732e-ae6f-e7160a101c4d"
]
46 0.15 ms
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 = ?
Parameters:
[
  "019c99f6-b0f4-74b7-92ed-d2d714186a55"
]
47 0.19 ms
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 = ?
Parameters:
[
  "019c6bce-21de-7c1c-a828-aa20a0a7cb87"
]
48 0.26 ms
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 = ?
Parameters:
[
  "019c6bce-21dd-7e2e-90b5-45062017d04c"
]
49 0.14 ms
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 = ?
Parameters:
[
  "019c6bce-21de-7c1c-a828-aa20a0a7cb87"
]
50 0.19 ms
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 = ?
Parameters:
[
  "019cd284-54d3-7d33-8c37-2b1802fc7464"
]
51 0.40 ms
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 = ?
Parameters:
[
  "019cd284-54d1-7f28-84ee-9af6c208c7f6"
]
52 0.39 ms
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 = ?
Parameters:
[
  "019cd284-54d3-7d33-8c37-2b1802fc7464"
]
53 0.43 ms
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 = ?
Parameters:
[
  "019ce781-2f73-7b36-b019-5292e10295dc"
]
54 0.38 ms
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 = ?
Parameters:
[
  "019c8fd3-5c15-7559-8f95-5d1f49d941fe"
]
55 0.31 ms
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 = ?
Parameters:
[
  "019ce781-2f73-7b36-b019-5292e10295dc"
]
56 0.32 ms
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 = ?
Parameters:
[
  "019ce76b-d017-7697-9cf3-33dbeb493b78"
]
57 0.97 ms
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 = ?
Parameters:
[
  "019ce76a-91f0-7679-aa45-7b90088e68ef"
]
58 0.28 ms
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 = ?
Parameters:
[
  "019ce76b-d017-7697-9cf3-33dbeb493b78"
]
59 0.40 ms
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 = ?
Parameters:
[
  "019ce76b-3c30-773c-b7fb-cc455f8005bd"
]
60 0.27 ms
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 = ?
Parameters:
[
  "019ce76b-3c30-773c-b7fb-cc455f8005bd"
]
61 0.57 ms
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 = ?
Parameters:
[
  "019c8f72-06fc-73d8-a5a4-4c3fd283f046"
]
62 0.80 ms
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 = ?
Parameters:
[
  "019c8f72-06fc-73d8-a5a4-4c3fd283f046"
]
63 1.01 ms
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 = ?
Parameters:
[
  "019c99cc-4846-7a7c-b667-5033544f881f"
]
64 0.83 ms
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 = ?
Parameters:
[
  "019c94d6-4156-7804-a60b-aa00dfcc9db2"
]
65 0.78 ms
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 = ?
Parameters:
[
  "019c99cc-4846-7a7c-b667-5033544f881f"
]
66 0.71 ms
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 = ?
Parameters:
[
  "019ce1ed-e2ac-788e-a45e-677fde7dfa44"
]
67 0.82 ms
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 = ?
Parameters:
[
  "019ce1ed-e2ac-788e-a45e-677fde7dfa44"
]
68 0.73 ms
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 = ?
Parameters:
[
  "019cb7cc-95cd-7f78-b2fd-fb8360d1cad7"
]
69 0.42 ms
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 = ?
Parameters:
[
  "019cb7cb-74ba-7b5b-93b0-75c78255786c"
]
70 0.32 ms
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 = ?
Parameters:
[
  "019cb7cc-95cd-7f78-b2fd-fb8360d1cad7"
]
71 0.43 ms
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 = ?
Parameters:
[
  "019c8a10-611c-72fc-a70f-c130d099612e"
]
72 0.21 ms
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 = ?
Parameters:
[
  "019c8a10-611c-72fc-a70f-c130d099612e"
]
73 0.49 ms
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 = ?
Parameters:
[
  "019c9a3b-0cb9-7e5f-8132-a739af1228d0"
]
74 0.34 ms
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 = ?
Parameters:
[
  "019c9a3b-0cb9-7e5f-8132-a739af1228d0"
]
75 0.58 ms
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 = ?
Parameters:
[
  "019c894e-90b7-710d-bbe2-a8d3ae3b3087"
]
76 1.79 ms
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 = ?
Parameters:
[
  "019c894e-90b7-710d-bbe2-a8d3ae3b3087"
]
77 0.68 ms
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 = ?
Parameters:
[
  "019c99f5-02f2-7da5-affa-288956235891"
]
78 0.54 ms
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 = ?
Parameters:
[
  "019c99f5-02f2-7da5-affa-288956235891"
]
79 1.97 ms
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 = ?
Parameters:
[
  "019c8a90-7481-72ea-b7c6-027497362094"
]
80 0.49 ms
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 = ?
Parameters:
[
  "019c8a90-7481-72ea-b7c6-027497362094"
]
81 0.46 ms
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 = ?
Parameters:
[
  "019c94bf-43b8-7533-9f0b-285d95e3b194"
]
82 0.47 ms
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 = ?
Parameters:
[
  "019c94bf-43b8-7533-9f0b-285d95e3b194"
]
83 0.57 ms
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 = ?
Parameters:
[
  "019c6f9d-3a24-7015-99f8-64adfd596dcb"
]
84 0.34 ms
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 = ?
Parameters:
[
  "019c6f9d-3a24-7015-99f8-64adfd596dcb"
]
85 0.39 ms
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 = ?
Parameters:
[
  "019c8e85-edb1-78ac-811d-8031d7f46235"
]
86 0.80 ms
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 = ?
Parameters:
[
  "019c8e85-edb1-78ac-811d-8031d7f46235"
]
87 0.68 ms
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 = ?
Parameters:
[
  "019e39b0-1687-7370-a148-ee87708bf62e"
]
88 0.72 ms
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 = ?
Parameters:
[
  "019e39b0-1680-7f72-bf3b-412575d5f08f"
]
89 1.48 ms
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 = ?
Parameters:
[
  "019e39b0-1687-7370-a148-ee87708bf62e"
]
90 0.60 ms
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 = ?
Parameters:
[
  "019c9daf-2abc-7f6f-b6f3-ad57ffcbacfb"
]
91 0.45 ms
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 = ?
Parameters:
[
  "019c9daf-2abc-7f6f-b6f3-ad57ffcbacfb"
]
92 0.89 ms
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 = ?
Parameters:
[
  "019cdd5c-2687-7ba1-81a0-8ec039c96bf5"
]
93 0.94 ms
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 = ?
Parameters:
[
  "019cdd58-a4e6-7db8-9d30-54a956d59cfb"
]
94 1.04 ms
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 = ?
Parameters:
[
  "019cdd5c-2687-7ba1-81a0-8ec039c96bf5"
]
95 1.26 ms
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 = ?
Parameters:
[
  "019c9b00-6c0f-7325-8bec-ae50f03f409f"
]
96 0.72 ms
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 = ?
Parameters:
[
  "019c9b00-6c0f-7325-8bec-ae50f03f409f"
]
97 1.04 ms
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 = ?
Parameters:
[
  "019cb7cd-86e3-7d70-b020-b2de0465ba8e"
]
98 0.62 ms
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 = ?
Parameters:
[
  "019cb7cc-2e4a-7f7b-a9df-ed0bdab70ed9"
]
99 0.49 ms
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 = ?
Parameters:
[
  "019cb7cd-86e3-7d70-b020-b2de0465ba8e"
]
100 1.06 ms
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 = ?
Parameters:
[
  "019cd0e1-905c-7976-95b7-5009d32e64cd"
]
101 0.63 ms
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 = ?
Parameters:
[
  "019cd0e1-905a-783e-af3c-6f7bd450a8a8"
]
102 0.44 ms
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 = ?
Parameters:
[
  "019cd0e1-905c-7976-95b7-5009d32e64cd"
]
103 0.56 ms
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 = ?
Parameters:
[
  "019e2f91-f5f9-7827-98f1-ab3cf979d376"
]
104 1.02 ms
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 = ?
Parameters:
[
  "019e2f91-f5f5-7f07-ada9-f074c3c9a3e1"
]
105 0.29 ms
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 = ?
Parameters:
[
  "019e2f91-f5f9-7827-98f1-ab3cf979d376"
]
106 0.71 ms
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 = ?
Parameters:
[
  "019e2f94-76a5-7a61-9f25-5c21fcafc4a1"
]
107 0.36 ms
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 = ?
Parameters:
[
  "019e2f94-76a5-7a61-9f25-5c21fcafc4a1"
]
108 0.49 ms
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 = ?
Parameters:
[
  "019e2f95-b1a6-7834-aaba-fe51d0ac2b8d"
]
109 0.28 ms
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 = ?
Parameters:
[
  "019e2f95-b1a6-7834-aaba-fe51d0ac2b8d"
]
110 0.33 ms
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 = ?
Parameters:
[
  "019ce75f-f2a0-7d28-bf68-f8360b75487c"
]
111 0.21 ms
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 = ?
Parameters:
[
  "019ce75f-f2a0-7d28-bf68-f8360b75487c"
]
112 0.30 ms
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 = ?
Parameters:
[
  "019ce6dc-3f53-7cdd-8b2c-3976be087e80"
]
113 0.41 ms
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 = ?
Parameters:
[
  "019ce6dc-3f53-7cdd-8b2c-3976be087e80"
]
114 0.36 ms
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 = ?
Parameters:
[
  "019c8a90-daf1-7515-b011-3d33c9de03a3"
]
115 0.43 ms
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 = ?
Parameters:
[
  "019c8a90-daf1-7515-b011-3d33c9de03a3"
]
116 0.45 ms
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 = ?
Parameters:
[
  "019c935f-dea3-74b3-8e14-2afff40cc29a"
]
117 0.44 ms
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 = ?
Parameters:
[
  "019c935e-105c-7932-8b67-ed3f73f161cb"
]
118 0.50 ms
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 = ?
Parameters:
[
  "019c935f-dea3-74b3-8e14-2afff40cc29a"
]
119 0.95 ms
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 = ?
Parameters:
[
  "019cdc17-cd9b-7278-b2a5-fb7eb502704a"
]
120 0.50 ms
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 = ?
Parameters:
[
  "019cdc16-f1ca-7c5b-a9c8-4aa4705c6279"
]
121 0.28 ms
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 = ?
Parameters:
[
  "019cdc17-cd9b-7278-b2a5-fb7eb502704a"
]
122 0.59 ms
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 = ?
Parameters:
[
  "019c9516-8873-7e7d-a179-d95d24d8017b"
]
123 0.41 ms
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 = ?
Parameters:
[
  "019c9516-8873-7e7d-a179-d95d24d8017b"
]
124 0.64 ms
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 = ?
Parameters:
[
  "019c8a8f-b583-7462-8a0b-2bc429235753"
]
125 0.41 ms
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 = ?
Parameters:
[
  "019c8a8f-b583-7462-8a0b-2bc429235753"
]
126 0.44 ms
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 = ?
Parameters:
[
  "019ecb09-56d3-77b8-a4f1-e456b05b8e2f"
]
127 0.50 ms
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 = ?
Parameters:
[
  "019ecb09-56cb-74c1-ab12-be81210a72de"
]
128 0.25 ms
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 = ?
Parameters:
[
  "019ecb09-56d3-77b8-a4f1-e456b05b8e2f"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Adapters\Secondary\Doctrine\Entity\Enrollment 62
App\Adapters\Secondary\Doctrine\Entity\Student 52
App\Adapters\Secondary\Doctrine\Entity\Guardian 25
App\Adapters\Secondary\Doctrine\Entity\User 23
App\Adapters\Secondary\Doctrine\Entity\Section 22
App\Adapters\Secondary\Doctrine\Entity\AcademicYear 5
App\Adapters\Secondary\Doctrine\Entity\Establishment 3