Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
0.36 ms
(0.00%)
1
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 ORDER BY t0.id DESC
Parameters:
[]
0.35 ms
(0.00%)
1
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:
[
  685
]
0.25 ms
(0.00%)
1
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 ORDER BY t0.id DESC
Parameters:
[]
0.25 ms
(0.00%)
1
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 INNER JOIN user_establishment ON t0.id = user_establishment.establishment_id WHERE user_establishment.user_id = ?
Parameters:
[
  685
]
0.23 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.is_closed AS is_closed_3, t0.create_at AS create_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.is_founder_valedated AS is_founder_valedated_9, t0.is_founder_rejected AS is_founder_rejected_10, t0.establishment_id AS establishment_id_11, t0.checkout_id AS checkout_id_12, t0.school_year_id AS school_year_id_13 FROM treasury_cash_register t0 WHERE t0.id = ?
Parameters:
[
  "6049"
]
0.22 ms
(0.00%)
1
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:
[]

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\TreasuryCashRegister No errors.
App\Entity\TreasuryCheckout No errors.
App\Entity\TreasuryCashMovement No errors.
App\Entity\AccountingStudentRegistrationFeeShedulPayment No errors.
App\Entity\AccountingStudentRegistrationPayment No errors.
App\Entity\TreasuryPayment No errors.
App\Entity\AccountingCreditLine 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\SettingLevel No errors.
App\Entity\SettingFaculty No errors.
App\Entity\SettingRound No errors.
App\Entity\SettingClassroom No errors.
App\Entity\RegistrationStudent 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\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\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\RegistrationStudentPreRegistration 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\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.