https://central-edu.net/online/api/v1/parent/abonnement/32645/establishment?online%2Fapi%2Fv1%2Fparent%2Fabonnement%2F32645%2Festablishment=

Method
GET
HTTP Status
200
IP
160.155.128.189
Profiled on
Token
4ee71b

Query Metrics

3 Database Queries
3 Different statements
1.11 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.52 ms 
SELECT t0.id AS id_1, t0.is_redoubling AS is_redoubling_2, t0.is_diet AS is_diet_3, t0.is_internal AS is_internal_4, t0.is_affected AS is_affected_5, t0.registered_at AS registered_at_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, t0.last_amount_paid AS last_amount_paid_11, t0.last_payment_id AS last_payment_id_12, t0.last_payment_at AS last_payment_at_13, t0.image AS image_14, t0.is_abandonned AS is_abandonned_15, t0.as_food_restrictions AS as_food_restrictions_16, t0.is_meatless_menu AS is_meatless_menu_17, t0.is_menu_without_pork AS is_menu_without_pork_18, t0.is_can_eat_alone AS is_can_eat_alone_19, t0.is_can_do_his_business_alone AS is_can_do_his_business_alone_20, t0.is_falls_sleep_easily AS is_falls_sleep_easily_21, t0.is_new AS is_new_22, t0.portal_login AS portal_login_23, t0.portal_password AS portal_password_24, t0.is_authorized_alone AS is_authorized_alone_25, t0.status AS status_26, t0.establishment_id AS establishment_id_27, t0.student_id AS student_id_28, t0.school_year_id AS school_year_id_29, t0.classroom_id AS classroom_id_30, t0.registration_student_pre_registration_id AS registration_student_pre_registration_id_31 FROM registration_student_registration t0 WHERE t0.id = ?
Parameters: 
[
  "32645"
]
View formatted query    View runnable query    Explain query
2 0.33 ms 
SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.phone_number AS phone_number_4, t0.username AS username_5, t0.password AS password_6, t0.device_token AS device_token_7, t0.is_enabled AS is_enabled_8, t0.is_password_changed AS is_password_changed_9, t0.last_auth_time AS last_auth_time_10, t0.token AS token_11, t0.create_at AS create_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.device AS device_17, t0.establishment_id AS establishment_id_18 FROM mobile_parent_app_account t0 WHERE t0.token = ? LIMIT 1
Parameters: 
[
  "849a1c356bfd763c1e1112739722515d4833"
]
View formatted query    View runnable query    Explain query
3 0.26 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: 
[
  3
]
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\RegistrationStudentRegistration No errors.
App\Entity\Establishment No errors.
App\Entity\RegistrationStudent No errors.
App\Entity\SchoolYear No errors.
App\Entity\SettingClassroom No errors.
App\Entity\RegistrationStudentPreRegistration No errors.
App\Entity\AccountingStudentRegistrationFee 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\AccountingStudentRegistrationPayment No errors.
App\Entity\RegistrationClassChange No errors.
App\Entity\RegistrationStudentDowngrade No errors.
App\Entity\RegistrationStudentAbandonment No errors.
App\Entity\RegistrationTransportCheckpoint No errors.
App\Entity\SchoolAbsenceAndDelay No errors.
App\Entity\SettingDocumentToProvide No errors.
App\Entity\CommunicationMessage No errors.
App\Entity\StockStudentKitEntry No errors.
App\Entity\StockKitOut No errors.
App\Entity\AccountingCredit No errors.
App\Entity\SchoolStudentAverage No errors.
App\Entity\NurseryTimeSheet No errors.
App\Entity\SchoolTeacherCallSheetLine No errors.
App\Entity\AccountingChequeTrackingLine No errors.
App\Entity\SchoolReportCardAbsence No errors.
App\Entity\WavePayment No errors.
App\Entity\RegistrationStudentContact No errors.
App\Entity\TransportCallSheetLine No errors.
App\Entity\StockExitSlip No errors.
App\Entity\MobileParentAppAccount No errors.
App\Entity\MobileParentAppAccountActivity 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\SettingLevel No errors.
App\Entity\SettingFaculty No errors.
App\Entity\SettingRound No errors.
App\Entity\SettingFee No errors.
App\Entity\SettingFeeProvider No errors.
App\Entity\SettingFeeShedul 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\ReportCard No errors.
App\Entity\RegistrationStudentDowngradeLine 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\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\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\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\StockStudentKitEntryLine No errors.
App\Entity\StockKitOutLine No errors.
App\Entity\StockProductOut No errors.
App\Entity\XlsImportation No errors.
App\Entity\AccountingCreditLine No errors.
App\Entity\SchoolAverage No errors.
App\Entity\SchoolCertificate No errors.
App\Entity\SchoolCertificateLine No errors.
App\Entity\SettingRoom No errors.
App\Entity\SettingTimeTable No errors.
App\Entity\SchoolWorkingTime No errors.
App\Entity\SchoolWorkingTimeHourLesson No errors.
App\Entity\FoundingNotification No errors.
App\Entity\EquivalentMatter No errors.
App\Entity\SchoolTeacherCallSheet 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\SalaryBandScale No errors.
App\Entity\TaxReductionShedule No errors.
App\Entity\LogOperation 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\TransportCallSheet 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.
App\Entity\PayrollRecord No errors.