https://central-edu.net/online/pre-registration/37061/print?online%2Fpre-registration%2F37061%2Fprint=

Method
GET
HTTP Status
200
IP
216.73.216.144
Profiled on
Token
292a6d

Query Metrics

6 Database Queries
6 Different statements
4.85 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.76 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.id = ?
Parameters: 
[
  "37061"
]
View formatted query    View runnable query    Explain query
2 1.07 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
]
View formatted query    View runnable query    Explain query
3 0.66 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 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
4 0.48 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.id = ?
Parameters: 
[
  172
]
View formatted query    View runnable query    Explain query
5 0.61 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 INNER JOIN registration_student_pre_registration_setting_level ON t0.id = registration_student_pre_registration_setting_level.setting_level_id WHERE registration_student_pre_registration_setting_level.registration_student_pre_registration_id = ?
Parameters: 
[
  37061
]
View formatted query    View runnable query    Explain query
6 0.28 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_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.phone_number AS phone_number_8, t0.mobile_number AS mobile_number_9, t0.email AS email_10, t0.website AS website_11, t0.address AS address_12, t0.location AS location_13, t0.under_supervision AS under_supervision_14, t0.image AS image_15, t0.transportation_manager_id AS transportation_manager_id_16 FROM establishment_group t0 WHERE t0.id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query

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\RegistrationStudentPreRegistration No errors.
App\Entity\RegistrationStudent No errors.
App\Entity\Establishment No errors.
App\Entity\SettingLevel No errors.
App\Entity\SchoolYear No errors.
App\Entity\RegistrationStudentRegistration No errors.
App\Entity\PreRegistrationEntreTestReportCard No errors.
App\Entity\ToxicologicalTestResult No errors.
App\Entity\EstablishmentGroup No errors.
App\Entity\User No errors.
App\Entity\RhJob No errors.
App\Entity\RhDepartment No errors.
App\Entity\RhSalary No errors.
App\Entity\RhPaySlip No errors.
App\Entity\RhRetainedItem No errors.
App\Entity\RhTaxableItem No errors.
App\Entity\RhNonTaxableItem No errors.
App\Entity\RhSalaryPaySlip No errors.
App\Entity\RhPaySlipRetainedItem No errors.
App\Entity\RhPaySlipTaxableItem No errors.
App\Entity\RhPaySlipNonTaxableItem No errors.
App\Entity\SettingCycle No errors.
App\Entity\SettingFaculty No errors.
App\Entity\SettingRound No errors.
App\Entity\SettingClassroom 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\AccountingExpense 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\MatterAveragePreRegistrationEntryTest No errors.
App\Entity\CommunicationMessage No errors.
App\Entity\TransportVehicle No errors.
App\Entity\TransportVehicleModel No errors.
App\Entity\TransportVehicleAdministrativeDocument No errors.
App\Entity\TransportVehicleMechanicalPiece No errors.
App\Entity\TransportVehicleMaintenance No errors.
App\Entity\TransportVehicleFuelTracking 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\RhStatut No errors.
App\Entity\CommunicationPredefinedMessage No errors.
App\Entity\SchoolTeacher 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\StockProductOut 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\RhSalarySalaryAccessory No errors.
App\Entity\RhSalaryPaySlipPayment No errors.
App\Entity\RhSalaryContract No errors.
App\Entity\RhSalaryContractItem No errors.
App\Entity\SchoolTeacherTimeSheet No errors.
App\Entity\AccountingExpenseCategory No errors.
App\Entity\SchoolAssessment No errors.
App\Entity\RhSalaryCredit 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\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\StockExitSlip 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.
App\Entity\PayrollRecord No errors.