https://central-edu.net/accounting/student-registration-fee-shedul/cancel/258683?accounting%2Fstudent-registration-fee-shedul%2Fcancel%2F258683=&shedulAmount=50000

Method
GET
HTTP Status
302
IP
160.154.199.149
Profiled on
Token
8ed7ca

Query Metrics

7 Database Queries
7 Different statements
4.02 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.76 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.zkbio_emp_code AS zkbio_emp_code_17, t14.last_name AS last_name_18, t14.first_name AS first_name_19, t14.gender AS gender_20, t14.phone_number AS phone_number_21, t14.mobile_number AS mobile_number_22, t14.email AS email_23, t14.address AS address_24, t14.location AS location_25, t14.birth_day AS birth_day_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.created_by AS created_by_29, t14.updated_by AS updated_by_30, t14.image AS image_31, t14.hiring_date AS hiring_date_32, t14.date_of_departure AS date_of_departure_33, t14.nationality AS nationality_34, t14.identification_id AS identification_id_35, t14.passport_id AS passport_id_36, t14.bank_code AS bank_code_37, t14.bank_name AS bank_name_38, t14.bank_account_number AS bank_account_number_39, t14.finet_account_number AS finet_account_number_40, t14.counter_code AS counter_code_41, t14.hourly_rate AS hourly_rate_42, t14.default_number_hour_performed AS default_number_hour_performed_43, t14.number_of_children AS number_of_children_44, t14.family_situation AS family_situation_45, t14.base_salary AS base_salary_46, t14.social_number AS social_number_47, t14.is_permanent AS is_permanent_48, t14.is_declared AS is_declared_49, t14.establishment_id AS establishment_id_50, t14.user_id AS user_id_51, t14.rh_job_id AS rh_job_id_52, t14.rh_department_id AS rh_department_id_53, t14.statut_id AS statut_id_54, t0.school_year_id AS school_year_id_55 FROM user t0 LEFT JOIN rh_salary t14 ON t14.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
2 0.41 ms 
SELECT t0.id AS id_1, t0.order_num AS order_num_2, t0.date_due AS date_due_3, t0.amount AS amount_4, t0.amount_paid AS amount_paid_5, t0.last_amount_paid AS last_amount_paid_6, t0.last_payment_id AS last_payment_id_7, t0.last_payment_at AS last_payment_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.amount_cancel AS amount_cancel_13, t0.is_cancel AS is_cancel_14, t0.amount_reported AS amount_reported_15, t0.is_reported AS is_reported_16, t0.establishment_id AS establishment_id_17, t0.student_registration_fee_id AS student_registration_fee_id_18 FROM accounting_student_registration_fee_shedul t0 WHERE t0.id = ?
Parameters: 
[
  "258683"
]
View formatted query    View runnable query    Explain query
3 0.18 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.43 ms 
UPDATE accounting_student_registration_fee_shedul SET amount_cancel = ?, updated_at = ?, updated_by = ? WHERE id = ?
Parameters: 
[
  50000.0
  "2026-03-23 16:20:10"
  2
  258683
]
View formatted query    View runnable query    Explain query
5 1.22 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 0.33 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.amount AS amount_4, t0.last_amount_paid AS last_amount_paid_5, t0.last_payment_id AS last_payment_id_6, t0.last_payment_at AS last_payment_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.amount_cancel AS amount_cancel_12, t0.amount_reported AS amount_reported_13, t0.is_reported AS is_reported_14, t0.is_cancel AS is_cancel_15, t0.is_archived AS is_archived_16, t0.duration AS duration_17, t0.start_at AS start_at_18, t0.end_at AS end_at_19, t0.establishment_id AS establishment_id_20, t0.student_registration_id AS student_registration_id_21, t0.fee_id AS fee_id_22 FROM accounting_student_registration_fee t0 WHERE t0.id = ?
Parameters: 
[
  171832
]
View formatted query    View runnable query    Explain query
7 0.70 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.zkbio_server_ip AS zkbio_server_ip_33, t0.zkbio_server_port AS zkbio_server_port_34, t0.zkbio_username AS zkbio_username_35, t0.zkbio_password AS zkbio_password_36, t0.zkbio_default_area_id AS zkbio_default_area_id_37, t0.wave_api_location AS wave_api_location_38, t0.wave_api_store_merchant_id AS wave_api_store_merchant_id_39, t0.wave_api_reinbursement_code AS wave_api_reinbursement_code_40, t0.wave_api_setup_number AS wave_api_setup_number_41, t0.wave_api_code_secret AS wave_api_code_secret_42, t0.recovery_put_out_amount AS recovery_put_out_amount_43, t0.fee_shedul_end_date AS fee_shedul_end_date_44, t0.establishment_group_id AS establishment_group_id_45, t0.parent_id AS parent_id_46 FROM establishment t0 WHERE t0.id = ?
Parameters: 
[
  2
]
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\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\AccountingStudentRegistrationFeeShedul No errors.
App\Entity\AccountingStudentRegistrationFee No errors.
App\Entity\AccountingStudentRegistrationFeeShedulPayment No errors.
App\Entity\RegistrationStudentRegistration No errors.
App\Entity\SettingFee No errors.
App\Entity\AccountingAccount No errors.
App\Entity\SettingFeeProvider No errors.
App\Entity\RegistrationStudent No errors.
App\Entity\SettingClassroom No errors.
App\Entity\RegistrationStudentPreRegistration No errors.
App\Entity\SettingLevel No errors.
App\Entity\SettingFaculty No errors.
App\Entity\SettingRound No errors.
App\Entity\SettingMedicalHistory No errors.
App\Entity\SettingLearningDifficulty No errors.
App\Entity\RegistrationStudentDowngradeLine No errors.
App\Entity\RegistrationStudentAbandonmentLine No errors.
App\Entity\AccountingCredit No errors.
App\Entity\StockKitOut 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\SettingFeeShedul No errors.
App\Entity\TreasuryCheckout No errors.
App\Entity\TreasuryCashRegister No errors.
App\Entity\TreasuryCashMovement 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\RegistrationStudentAbandonment 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\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\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\StockKitOutLine No errors.
App\Entity\XlsImportation 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\BudgetForecast No errors.
App\Entity\BankJournal No errors.
App\Entity\BankTransaction 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.