https://central-edu.net/online/pre-registration/etablissement/20?matricule=24007857U&online%2Fpre-registration%2Fetablissement%2F20=&type=old Return to referer URL

Query Metrics

29 Database Queries
14 Different statements
512.83 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.37 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_enabled AS is_enabled_5, t0.is_password_changed AS is_password_changed_6, t0.last_login_at AS last_login_at_7, t0.last_auth_time AS last_auth_time_8, t0.token_live_time AS token_live_time_9, t0.token AS token_10, t0.is_can_aproved_expense AS is_can_aproved_expense_11, t0.establishment_id AS establishment_id_12, t0.establishment_group_id AS establishment_group_id_13, t14.id AS id_15, t14.code AS code_16, t14.last_name AS last_name_17, t14.first_name AS first_name_18, t14.gender AS gender_19, t14.phone_number AS phone_number_20, t14.mobile_number AS mobile_number_21, t14.email AS email_22, t14.address AS address_23, t14.location AS location_24, t14.birth_day AS birth_day_25, t14.created_at AS created_at_26, t14.updated_at AS updated_at_27, t14.created_by AS created_by_28, t14.updated_by AS updated_by_29, t14.image AS image_30, t14.hiring_date AS hiring_date_31, t14.date_of_departure AS date_of_departure_32, t14.nationality AS nationality_33, t14.identification_id AS identification_id_34, t14.passport_id AS passport_id_35, t14.bank_code AS bank_code_36, t14.bank_name AS bank_name_37, t14.bank_account_number AS bank_account_number_38, t14.finet_account_number AS finet_account_number_39, t14.counter_code AS counter_code_40, t14.hourly_rate AS hourly_rate_41, t14.default_number_hour_performed AS default_number_hour_performed_42, t14.number_of_children AS number_of_children_43, t14.family_situation AS family_situation_44, t14.base_salary AS base_salary_45, t14.social_number AS social_number_46, t14.is_permanent AS is_permanent_47, t14.is_declared AS is_declared_48, t14.establishment_id AS establishment_id_49, t14.user_id AS user_id_50, t14.rh_job_id AS rh_job_id_51, t14.rh_department_id AS rh_department_id_52, t14.statut_id AS statut_id_53, t0.school_year_id AS school_year_id_54 FROM user t0 LEFT JOIN rh_salary t14 ON t14.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  641
]
2 0.37 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.short_name AS short_name_4, t0.type AS type_5, t0.phone_number AS phone_number_6, t0.mobile_number AS mobile_number_7, t0.email AS email_8, t0.website AS website_9, t0.address AS address_10, t0.city AS city_11, t0.location AS location_12, t0.under_supervision AS under_supervision_13, t0.regional_directorate AS regional_directorate_14, t0.main_activity AS main_activity_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19, t0.image AS image_20, t0.sms_sender AS sms_sender_21, t0.sms_login AS sms_login_22, t0.sms_password AS sms_password_23, t0.oci_sms_sender AS oci_sms_sender_24, t0.oci_sms_phone AS oci_sms_phone_25, t0.sms_gateway AS sms_gateway_26, t0.stamp AS stamp_27, t0.badge_color AS badge_color_28, t0.sms_bank_payment AS sms_bank_payment_29, t0.sms_recovery AS sms_recovery_30, t0.is_send_absence_sms AS is_send_absence_sms_31, t0.is_face_attendance_enabled AS is_face_attendance_enabled_32, t0.wave_api_location AS wave_api_location_33, t0.wave_api_store_merchant_id AS wave_api_store_merchant_id_34, t0.wave_api_reinbursement_code AS wave_api_reinbursement_code_35, t0.wave_api_setup_number AS wave_api_setup_number_36, t0.wave_api_code_secret AS wave_api_code_secret_37, t0.recovery_put_out_amount AS recovery_put_out_amount_38, t0.fee_shedul_end_date AS fee_shedul_end_date_39, t0.establishment_group_id AS establishment_group_id_40, t0.parent_id AS parent_id_41 FROM establishment t0 WHERE t0.id = ?
Parameters:
[
  20
]
3 0.35 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.notification_phone_number AS notification_phone_number_5, t0.notification_name AS notification_name_6, t0.notification_watsapp_number AS notification_watsapp_number_7, t0.observation AS observation_8, t0.location AS location_9, t0.gender AS gender_10, t0.birthday AS birthday_11, t0.birth_location AS birth_location_12, t0.birth_certificate_number AS birth_certificate_number_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.image AS image_18, t0.create_date AS create_date_19, t0.is_affected AS is_affected_20, t0.is_redoubling AS is_redoubling_21, t0.last_school_attended AS last_school_attended_22, t0.last_school_attended_type AS last_school_attended_type_23, t0.registration_number AS registration_number_24, t0.lv1 AS lv1_25, t0.lv2 AS lv2_26, t0.art_or_musique AS art_or_musique_27, t0.nationality AS nationality_28, t0.where_resides AS where_resides_29, t0.parent_status AS parent_status_30, t0.is_parntal_authority_father AS is_parntal_authority_father_31, t0.is_father_call_to_emergency AS is_father_call_to_emergency_32, t0.father_last_name AS father_last_name_33, t0.father_first_name AS father_first_name_34, t0.father_address AS father_address_35, t0.father_phone_number AS father_phone_number_36, t0.father_post AS father_post_37, t0.father_location AS father_location_38, t0.father_email AS father_email_39, t0.is_parntal_authority_mother AS is_parntal_authority_mother_40, t0.is_mother_call_to_emergency AS is_mother_call_to_emergency_41, t0.mother_last_name AS mother_last_name_42, t0.mother_first_name AS mother_first_name_43, t0.mother_address AS mother_address_44, t0.mother_phone_number AS mother_phone_number_45, t0.mother_post AS mother_post_46, t0.mother_location AS mother_location_47, t0.mother_email AS mother_email_48, t0.responsible_of_schooling AS responsible_of_schooling_49, t0.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_50, t0.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_51, t0.responsible_of_schooling_address AS responsible_of_schooling_address_52, t0.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_53, t0.responsible_of_schooling_post AS responsible_of_schooling_post_54, t0.responsible_of_schooling_location AS responsible_of_schooling_location_55, t0.accompanying_person_name AS accompanying_person_name_56, t0.accompanying_person_phone_number AS accompanying_person_phone_number_57, t0.accompanying_person_name_2 AS accompanying_person_name_2_58, t0.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_59, t0.accompanying_person_name_3 AS accompanying_person_name_3_60, t0.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_61, t0.doctor_name AS doctor_name_62, t0.doctor_phone_number AS doctor_phone_number_63, t0.other_medical_history AS other_medical_history_64, t0.other_learning_difficulty AS other_learning_difficulty_65, t0.teacher_observation AS teacher_observation_66, t0.parent_observation AS parent_observation_67, t0.anterior_balance AS anterior_balance_68, t0.is_archived AS is_archived_69, t0.establishment_id AS establishment_id_70, t0.entry_level_id AS entry_level_id_71, t0.medical_history_id AS medical_history_id_72, t0.learning_difficulty_id AS learning_difficulty_id_73 FROM registration_student t0 WHERE t0.establishment_id = ? AND t0.registration_number = ? AND t0.is_archived = ? LIMIT 1
Parameters:
[
  20
  "24007857U"
  0
]
4 0.26 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.is_student_entry_test_do AS is_student_entry_test_do_7, t0.is_student_toxicological_test_do AS is_student_toxicological_test_do_8, t0.is_student_psychological_test_do AS is_student_psychological_test_do_9, t0.is_student_cbe_affected AS is_student_cbe_affected_10, t0.num_order AS num_order_11, t0.establishment_id AS establishment_id_12, t0.cycle_id AS cycle_id_13, t0.parent_id AS parent_id_14 FROM setting_level t0 WHERE t0.establishment_id = ?
Parameters:
[
  20
]
5 0.26 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  171
]
6 0.30 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  172
]
7 0.26 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  173
]
8 0.26 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  174
]
9 0.19 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  175
]
10 0.13 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  176
]
11 0.25 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  177
]
12 0.21 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  178
]
13 0.18 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  179
]
14 0.18 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  180
]
15 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  181
]
16 0.12 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  182
]
17 0.20 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.level_id = ? ORDER BY t0.label ASC
Parameters:
[
  183
]
18 0.27 ms
SELECT t0.id AS id_1, t0.is_ongoing AS is_ongoing_2, t0.is_archived AS is_archived_3, t0.code AS code_4, t0.label AS label_5, t0.fiscal_year AS fiscal_year_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM school_year t0 ORDER BY t0.id DESC
Parameters:
[]
19 0.22 ms
SELECT t0.id AS id_1, t0.is_ongoing AS is_ongoing_2, t0.is_archived AS is_archived_3, t0.code AS code_4, t0.label AS label_5, t0.fiscal_year AS fiscal_year_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM school_year t0 ORDER BY t0.id DESC
Parameters:
[]
20 44.90 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.num_cmu AS num_cmu_3, t0.last_name AS last_name_4, t0.first_name AS first_name_5, t0.notification_phone_number AS notification_phone_number_6, t0.notification_name AS notification_name_7, t0.notification_watsapp_number AS notification_watsapp_number_8, t0.observation AS observation_9, t0.location AS location_10, t0.gender AS gender_11, t0.birthday AS birthday_12, t0.birth_certificate_number AS birth_certificate_number_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.image AS image_18, t0.create_date AS create_date_19, t0.is_affected AS is_affected_20, t0.is_redoubling AS is_redoubling_21, t0.last_school_attended AS last_school_attended_22, t0.last_school_attended_type AS last_school_attended_type_23, t0.birth_location AS birth_location_24, t0.is_subject_entry_test AS is_subject_entry_test_25, t0.is_entry_test_done AS is_entry_test_done_26, t0.is_entry_test_performed AS is_entry_test_performed_27, t0.entry_test_result AS entry_test_result_28, t0.is_subject_toxicological_test AS is_subject_toxicological_test_29, t0.is_toxicological_test_performed AS is_toxicological_test_performed_30, t0.is_toxicological_test_refused AS is_toxicological_test_refused_31, t0.toxicological_test_appreciation AS toxicological_test_appreciation_32, t0.toxicological_test_result AS toxicological_test_result_33, t0.is_subject_psychological_test AS is_subject_psychological_test_34, t0.is_psychological_test_performed AS is_psychological_test_performed_35, t0.psychological_test_result AS psychological_test_result_36, t0.registration_number AS registration_number_37, t0.lv1 AS lv1_38, t0.lv2 AS lv2_39, t0.art_or_musique AS art_or_musique_40, t0.nationality AS nationality_41, t0.where_resides AS where_resides_42, t0.parent_status AS parent_status_43, t0.is_parntal_authority_father AS is_parntal_authority_father_44, t0.is_father_call_to_emergency AS is_father_call_to_emergency_45, t0.father_last_name AS father_last_name_46, t0.father_first_name AS father_first_name_47, t0.father_address AS father_address_48, t0.father_phone_number AS father_phone_number_49, t0.father_post AS father_post_50, t0.father_location AS father_location_51, t0.father_email AS father_email_52, t0.is_parntal_authority_mother AS is_parntal_authority_mother_53, t0.is_mother_call_to_emergency AS is_mother_call_to_emergency_54, t0.mother_last_name AS mother_last_name_55, t0.mother_first_name AS mother_first_name_56, t0.mother_address AS mother_address_57, t0.mother_phone_number AS mother_phone_number_58, t0.mother_post AS mother_post_59, t0.mother_location AS mother_location_60, t0.mother_email AS mother_email_61, t0.responsible_of_schooling AS responsible_of_schooling_62, t0.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_63, t0.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_64, t0.responsible_of_schooling_address AS responsible_of_schooling_address_65, t0.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_66, t0.responsible_of_schooling_post AS responsible_of_schooling_post_67, t0.responsible_of_schooling_location AS responsible_of_schooling_location_68, t0.is_need_canteen AS is_need_canteen_69, t0.is_need_transport AS is_need_transport_70, t0.is_need_keep AS is_need_keep_71, t0.is_need_extrat_activity AS is_need_extrat_activity_72, t0.hold_student_id AS hold_student_id_73, t0.accompanying_person_name AS accompanying_person_name_74, t0.accompanying_person_phone_number AS accompanying_person_phone_number_75, t0.accompanying_person_name_2 AS accompanying_person_name_2_76, t0.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_77, t0.accompanying_person_name_3 AS accompanying_person_name_3_78, t0.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_79, t0.final_decision_note AS final_decision_note_80, t0.last_previous_class AS last_previous_class_81, t0.student_id AS student_id_82, t0.establishment_id AS establishment_id_83, t0.entry_level_id AS entry_level_id_84, t0.school_year_id AS school_year_id_85 FROM registration_student_pre_registration t0 WHERE t0.school_year_id = ? AND t0.registration_number = ? LIMIT 1
Parameters:
[
  4
  "24007857U"
]
21 455.67 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.num_cmu AS num_cmu_3, t0.last_name AS last_name_4, t0.first_name AS first_name_5, t0.notification_phone_number AS notification_phone_number_6, t0.notification_name AS notification_name_7, t0.notification_watsapp_number AS notification_watsapp_number_8, t0.observation AS observation_9, t0.location AS location_10, t0.gender AS gender_11, t0.birthday AS birthday_12, t0.birth_certificate_number AS birth_certificate_number_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.image AS image_18, t0.create_date AS create_date_19, t0.is_affected AS is_affected_20, t0.is_redoubling AS is_redoubling_21, t0.last_school_attended AS last_school_attended_22, t0.last_school_attended_type AS last_school_attended_type_23, t0.birth_location AS birth_location_24, t0.is_subject_entry_test AS is_subject_entry_test_25, t0.is_entry_test_done AS is_entry_test_done_26, t0.is_entry_test_performed AS is_entry_test_performed_27, t0.entry_test_result AS entry_test_result_28, t0.is_subject_toxicological_test AS is_subject_toxicological_test_29, t0.is_toxicological_test_performed AS is_toxicological_test_performed_30, t0.is_toxicological_test_refused AS is_toxicological_test_refused_31, t0.toxicological_test_appreciation AS toxicological_test_appreciation_32, t0.toxicological_test_result AS toxicological_test_result_33, t0.is_subject_psychological_test AS is_subject_psychological_test_34, t0.is_psychological_test_performed AS is_psychological_test_performed_35, t0.psychological_test_result AS psychological_test_result_36, t0.registration_number AS registration_number_37, t0.lv1 AS lv1_38, t0.lv2 AS lv2_39, t0.art_or_musique AS art_or_musique_40, t0.nationality AS nationality_41, t0.where_resides AS where_resides_42, t0.parent_status AS parent_status_43, t0.is_parntal_authority_father AS is_parntal_authority_father_44, t0.is_father_call_to_emergency AS is_father_call_to_emergency_45, t0.father_last_name AS father_last_name_46, t0.father_first_name AS father_first_name_47, t0.father_address AS father_address_48, t0.father_phone_number AS father_phone_number_49, t0.father_post AS father_post_50, t0.father_location AS father_location_51, t0.father_email AS father_email_52, t0.is_parntal_authority_mother AS is_parntal_authority_mother_53, t0.is_mother_call_to_emergency AS is_mother_call_to_emergency_54, t0.mother_last_name AS mother_last_name_55, t0.mother_first_name AS mother_first_name_56, t0.mother_address AS mother_address_57, t0.mother_phone_number AS mother_phone_number_58, t0.mother_post AS mother_post_59, t0.mother_location AS mother_location_60, t0.mother_email AS mother_email_61, t0.responsible_of_schooling AS responsible_of_schooling_62, t0.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_63, t0.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_64, t0.responsible_of_schooling_address AS responsible_of_schooling_address_65, t0.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_66, t0.responsible_of_schooling_post AS responsible_of_schooling_post_67, t0.responsible_of_schooling_location AS responsible_of_schooling_location_68, t0.is_need_canteen AS is_need_canteen_69, t0.is_need_transport AS is_need_transport_70, t0.is_need_keep AS is_need_keep_71, t0.is_need_extrat_activity AS is_need_extrat_activity_72, t0.hold_student_id AS hold_student_id_73, t0.accompanying_person_name AS accompanying_person_name_74, t0.accompanying_person_phone_number AS accompanying_person_phone_number_75, t0.accompanying_person_name_2 AS accompanying_person_name_2_76, t0.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_77, t0.accompanying_person_name_3 AS accompanying_person_name_3_78, t0.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_79, t0.final_decision_note AS final_decision_note_80, t0.last_previous_class AS last_previous_class_81, t0.student_id AS student_id_82, t0.establishment_id AS establishment_id_83, t0.entry_level_id AS entry_level_id_84, t0.school_year_id AS school_year_id_85 FROM registration_student_pre_registration t0
Parameters:
[]
22 0.51 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.is_student_entry_test_do AS is_student_entry_test_do_7, t0.is_student_toxicological_test_do AS is_student_toxicological_test_do_8, t0.is_student_psychological_test_do AS is_student_psychological_test_do_9, t0.is_student_cbe_affected AS is_student_cbe_affected_10, t0.num_order AS num_order_11, t0.establishment_id AS establishment_id_12, t0.cycle_id AS cycle_id_13, t0.parent_id AS parent_id_14 FROM setting_level t0 WHERE t0.establishment_id = ? AND t0.is_student_toxicological_test_do = ?
Parameters:
[
  20
  1
]
23 0.27 ms
"START TRANSACTION"
Parameters:
[]
24 1.01 ms
INSERT INTO registration_student_pre_registration (code, num_cmu, last_name, first_name, notification_phone_number, notification_name, notification_watsapp_number, observation, location, gender, birthday, birth_certificate_number, created_at, updated_at, created_by, updated_by, image, create_date, is_affected, is_redoubling, last_school_attended, last_school_attended_type, birth_location, is_subject_entry_test, is_entry_test_done, is_entry_test_performed, entry_test_result, is_subject_toxicological_test, is_toxicological_test_performed, is_toxicological_test_refused, toxicological_test_appreciation, toxicological_test_result, is_subject_psychological_test, is_psychological_test_performed, psychological_test_result, registration_number, lv1, lv2, art_or_musique, nationality, where_resides, parent_status, is_parntal_authority_father, is_father_call_to_emergency, father_last_name, father_first_name, father_address, father_phone_number, father_post, father_location, father_email, is_parntal_authority_mother, is_mother_call_to_emergency, mother_last_name, mother_first_name, mother_address, mother_phone_number, mother_post, mother_location, mother_email, responsible_of_schooling, responsible_of_schooling_last_name, responsible_of_schooling_first_name, responsible_of_schooling_address, responsible_of_schooling_phone_number, responsible_of_schooling_post, responsible_of_schooling_location, is_need_canteen, is_need_transport, is_need_keep, is_need_extrat_activity, hold_student_id, accompanying_person_name, accompanying_person_phone_number, accompanying_person_name_2, accompanying_person_phone_number_2, accompanying_person_name_3, accompanying_person_phone_number_3, final_decision_note, last_previous_class, student_id, establishment_id, entry_level_id, school_year_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "PRE-2025-36350"
  2 => null
  3 => "COULIBALY"
  4 => "KOROTOUM"
  5 => "0757748127"
  6 => null
  7 => null
  8 => null
  9 => "ABOBO"
  10 => "FEMININ"
  11 => "2011-04-12"
  12 => null
  13 => "2025-09-18 07:46:22"
  14 => "2025-09-18 07:46:22"
  15 => 641
  16 => 641
  17 => null
  18 => "2025-09-18"
  19 => 1
  20 => 0
  21 => "EPP RAIL 4C"
  22 => "PRIVEE"
  23 => "ABOBO"
  24 => 0
  25 => 0
  26 => 0
  27 => "EN COURS"
  28 => 0
  29 => 0
  30 => 0
  31 => null
  32 => "EN COURS"
  33 => 0
  34 => 0
  35 => "EN COURS"
  36 => "24007857U"
  37 => "ANGLAIS"
  38 => "AUCUN"
  39 => null
  40 => "IVOIRIENNE"
  41 => "CHEZ SES PARENTS"
  42 => "CELIBATAIRE"
  43 => 1
  44 => 1
  45 => "TRAORE"
  46 => "DORH"
  47 => null
  48 => "0757748127"
  49 => null
  50 => null
  51 => null
  52 => 0
  53 => 0
  54 => null
  55 => null
  56 => null
  57 => null
  58 => null
  59 => null
  60 => null
  61 => "LE PERE ET LA MERE"
  62 => null
  63 => null
  64 => null
  65 => null
  66 => null
  67 => null
  68 => 0
  69 => 0
  70 => 0
  71 => 0
  72 => 26820
  73 => null
  74 => null
  75 => null
  76 => null
  77 => null
  78 => null
  79 => null
  80 => null
  81 => null
  82 => 20
  83 => 172
  84 => 4
]
25 0.49 ms
UPDATE user SET last_login_at = ? WHERE id = ?
Parameters:
[
  "2025-09-18 07:46:25"
  641
]
26 1.98 ms
"COMMIT"
Parameters:
[]
27 0.24 ms
"START TRANSACTION"
Parameters:
[]
28 0.70 ms
UPDATE registration_student_pre_registration SET code = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "PRE-2025-37061"
  "2025-09-18 07:46:28"
  37061
]
29 1.55 ms
"COMMIT"
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Establishment No errors.
App\Entity\EstablishmentGroup No errors.
App\Entity\RhSalary No errors.
App\Entity\RhJob No errors.
App\Entity\RhDepartment No errors.
App\Entity\RhStatut No errors.
App\Entity\SchoolYear No errors.
App\Entity\RhSalaryPaySlip No errors.
App\Entity\AccountingExpense No errors.
App\Entity\TransportVehicle No errors.
App\Entity\TransportVehicleMaintenance No errors.
App\Entity\TransportVehicleFuelTracking No errors.
App\Entity\SettingCycle No errors.
App\Entity\CommunicationMessage No errors.
App\Entity\SchoolTeacher No errors.
App\Entity\StockProductOut No errors.
App\Entity\RhSalarySalaryAccessory No errors.
App\Entity\RhSalaryContract No errors.
App\Entity\RhSalaryCredit No errors.
App\Entity\StockExitSlip No errors.
App\Entity\PayrollRecord No errors.
App\Entity\RegistrationStudent No errors.
App\Entity\RegistrationStudentPreRegistration No errors.
App\Entity\SettingLevel No errors.
App\Entity\RhPaySlip No errors.
App\Entity\RhRetainedItem No errors.
App\Entity\RhTaxableItem No errors.
App\Entity\RhNonTaxableItem No errors.
App\Entity\RhPaySlipRetainedItem No errors.
App\Entity\RhPaySlipTaxableItem No errors.
App\Entity\RhPaySlipNonTaxableItem No errors.
App\Entity\SettingFaculty No errors.
App\Entity\SettingRound No errors.
App\Entity\SettingClassroom No errors.
App\Entity\RegistrationStudentRegistration No errors.
App\Entity\SettingFee No errors.
App\Entity\SettingFeeProvider No errors.
App\Entity\SettingFeeShedul No errors.
App\Entity\AccountingStudentRegistrationFee No errors.
App\Entity\AccountingStudentRegistrationFeeShedul No errors.
App\Entity\TreasuryCheckout No errors.
App\Entity\TreasuryCashRegister No errors.
App\Entity\TreasuryCashMovement No errors.
App\Entity\AccountingStudentRegistrationFeeShedulPayment No errors.
App\Entity\SchoolYearPeriode No errors.
App\Entity\SchoolMatterType No errors.
App\Entity\SchoolMatter No errors.
App\Entity\SchoolNoteAppreciation No errors.
App\Entity\SchoolSubMatter No errors.
App\Entity\SchoolReportCard No errors.
App\Entity\SchoolAverageReportCard No errors.
App\Entity\SchoolAssessmentByClass No errors.
App\Entity\SchoolAssessmentByLevel No errors.
App\Entity\SchoolAssessmentByClassByMatter No errors.
App\Entity\SchoolAssessmentByLevelByMatter No errors.
App\Entity\ReportCard No errors.
App\Entity\AccountingStudentRegistrationPayment No errors.
App\Entity\RegistrationClassChange No errors.
App\Entity\RegistrationStudentDowngrade No errors.
App\Entity\RegistrationStudentDowngradeLine No errors.
App\Entity\RegistrationStudentAbandonment No errors.
App\Entity\RegistrationStudentAbandonmentLine No errors.
App\Entity\TreasuryPayment No errors.
App\Entity\EntreTestReportCard No errors.
App\Entity\PreRegistrationEntreTestReportCard No errors.
App\Entity\MatterAveragePreRegistrationEntryTest No errors.
App\Entity\TransportVehicleModel No errors.
App\Entity\TransportVehicleAdministrativeDocument No errors.
App\Entity\TransportVehicleMechanicalPiece No errors.
App\Entity\TransportZone No errors.
App\Entity\TransportZoneCheckPoint No errors.
App\Entity\RegistrationTransportCheckpoint No errors.
App\Entity\SettingDocumentToProvide No errors.
App\Entity\SettingMedicalHistory No errors.
App\Entity\CanteenUtensil No errors.
App\Entity\CanteenStockMovement No errors.
App\Entity\CanteenDish No errors.
App\Entity\CanteenTime No errors.
App\Entity\CanteenMenu No errors.
App\Entity\CanteenMenuItem No errors.
App\Entity\RegistrationDiet No errors.
App\Entity\SchoolAbsenceAndDelay No errors.
App\Entity\SchoolAbsenceAndDelayNotification No errors.
App\Entity\SchoolAbsenceAndDelayNotificationLine No errors.
App\Entity\SchoolAbsenceAndDelaySetting No errors.
App\Entity\SchoolAbsenceAndDelayReportCardNotification No errors.
App\Entity\SchoolAbsenceAndDelayReportCardNotificationLine No errors.
App\Entity\SettingLearningDifficulty No errors.
App\Entity\CommunicationPredefinedMessage No errors.
App\Entity\StockProduct No errors.
App\Entity\StockKitCategory No errors.
App\Entity\StockKitProduct No errors.
App\Entity\StockProductEntry No errors.
App\Entity\StockProductEntryLine No errors.
App\Entity\StockProviderKitEntry No errors.
App\Entity\StockProviderKitEntryLine No errors.
App\Entity\StockStudentKitEntry No errors.
App\Entity\StockStudentKitEntryLine No errors.
App\Entity\StockKitOut No errors.
App\Entity\StockKitOutLine No errors.
App\Entity\XlsImportation No errors.
App\Entity\AccountingCredit No errors.
App\Entity\AccountingCreditLine No errors.
App\Entity\SchoolAverage No errors.
App\Entity\SchoolStudentAverage No errors.
App\Entity\SchoolCertificate No errors.
App\Entity\SchoolCertificateLine No errors.
App\Entity\NurseryTimeSheet No errors.
App\Entity\SettingRoom No errors.
App\Entity\SettingTimeTable No errors.
App\Entity\SchoolWorkingTime No errors.
App\Entity\SchoolWorkingTimeHourLesson No errors.
App\Entity\MobileParentAppAccount No errors.
App\Entity\FoundingNotification No errors.
App\Entity\EquivalentMatter No errors.
App\Entity\SchoolTeacherCallSheet No errors.
App\Entity\SchoolTeacherCallSheetLine No errors.
App\Entity\SchoolTeacherMatterClassroom No errors.
App\Entity\RhSalaryPaySlipPayment No errors.
App\Entity\RhSalaryContractItem No errors.
App\Entity\SchoolTeacherTimeSheet No errors.
App\Entity\AccountingExpenseCategory No errors.
App\Entity\SchoolAssessment No errors.
App\Entity\RhSalaryCreditShedul No errors.
App\Entity\SettingFeeProviderDistribution No errors.
App\Entity\AccountingChequeTracking No errors.
App\Entity\AccountingChequeTrackingLine No errors.
App\Entity\SalaryBandScale No errors.
App\Entity\TaxReductionShedule No errors.
App\Entity\LogOperation No errors.
App\Entity\SchoolReportCardAbsence No errors.
App\Entity\WavePayment No errors.
App\Entity\ToxicologicalTestResult No errors.
App\Entity\ToxicologicalTestResultLine No errors.
App\Entity\ToxicologicalTestLaboratory No errors.
App\Entity\SchoolTeacherAbsence No errors.
App\Entity\GescotiContribution No errors.
App\Entity\RegistrationStudentContact No errors.
App\Entity\TransportCallSheet No errors.
App\Entity\TransportCallSheetLine No errors.
App\Entity\CommunicationMessageQueue No errors.
App\Entity\StockWarehouse No errors.
App\Entity\StockMovement No errors.
App\Entity\StockDeliveryNote No errors.
App\Entity\StockDeliveryNoteLine No errors.
App\Entity\StockReceptionVoucher No errors.
App\Entity\StockReceptionVoucherLine No errors.
App\Entity\Stockinventory No errors.
App\Entity\StockinventoryLine No errors.
App\Entity\Stocktransfer No errors.
App\Entity\StocktransferLine No errors.
App\Entity\DocManager No errors.
App\Entity\DocManagerArticle No errors.
App\Entity\TransportCallSheetCheckpoint No errors.
App\Entity\TransportCallSheetCheckpointLine No errors.
App\Entity\TransportCallJourney No errors.
App\Entity\PayrollSync No errors.