Query Metrics

12 Database Queries
11 Different statements
10.46 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.55 ms
(0.00%)
1
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 = ? AND t0.school_year_id = ? ORDER BY t0.label ASC
Parameters:
[
  190
  3
]
1.49 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.counter_code AS counter_code_39, t14.hourly_rate AS hourly_rate_40, t14.default_number_hour_performed AS default_number_hour_performed_41, t14.number_of_children AS number_of_children_42, t14.family_situation AS family_situation_43, t14.base_salary AS base_salary_44, t14.social_number AS social_number_45, t14.is_permanent AS is_permanent_46, t14.is_declared AS is_declared_47, t14.establishment_id AS establishment_id_48, t14.user_id AS user_id_49, t14.rh_job_id AS rh_job_id_50, t14.rh_department_id AS rh_department_id_51, t14.statut_id AS statut_id_52, t0.school_year_id AS school_year_id_53 FROM user t0 LEFT JOIN rh_salary t14 ON t14.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  631
]
1.49 ms
(0.00%)
1
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.id = ?
Parameters:
[
  23591
]
1.44 ms
(0.00%)
2
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.sms_gateway AS sms_gateway_25, t0.stamp AS stamp_26, t0.badge_color AS badge_color_27, t0.sms_bank_payment AS sms_bank_payment_28, t0.sms_recovery AS sms_recovery_29, t0.is_send_absence_sms AS is_send_absence_sms_30, t0.wave_api_location AS wave_api_location_31, t0.wave_api_store_merchant_id AS wave_api_store_merchant_id_32, t0.wave_api_reinbursement_code AS wave_api_reinbursement_code_33, t0.wave_api_setup_number AS wave_api_setup_number_34, t0.wave_api_code_secret AS wave_api_code_secret_35, t0.establishment_group_id AS establishment_group_id_36, t0.parent_id AS parent_id_37 FROM establishment t0 WHERE t0.id = ?
Parameters:
[
  21
]
1.00 ms
(0.00%)
1
SELECT s0_.id AS id_0, s0_.label AS label_1, s0_.capacity AS capacity_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.created_by AS created_by_5, s0_.updated_by AS updated_by_6, s0_.is_excellent AS is_excellent_7, s1_.id AS id_8, s1_.label AS label_9, s1_.created_at AS created_at_10, s1_.updated_at AS updated_at_11, s1_.created_by AS created_by_12, s1_.updated_by AS updated_by_13, s1_.is_student_entry_test_do AS is_student_entry_test_do_14, s1_.is_student_toxicological_test_do AS is_student_toxicological_test_do_15, s1_.is_student_psychological_test_do AS is_student_psychological_test_do_16, s1_.is_student_cbe_affected AS is_student_cbe_affected_17, s1_.num_order AS num_order_18, s0_.establishment_id AS establishment_id_19, s0_.level_id AS level_id_20, s0_.faculty_id AS faculty_id_21, s0_.round_id AS round_id_22, s0_.school_year_id AS school_year_id_23, s1_.establishment_id AS establishment_id_24, s1_.cycle_id AS cycle_id_25, s1_.parent_id AS parent_id_26 FROM setting_classroom s0_ INNER JOIN setting_level s1_ ON s0_.level_id = s1_.id WHERE s0_.establishment_id = ? AND s0_.school_year_id = ? AND s1_.parent_id = ?
Parameters:
[
  21
  3
  null
]
0.98 ms
(0.00%)
1
SELECT s0_.id AS id_0, s0_.label AS label_1, s0_.capacity AS capacity_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.created_by AS created_by_5, s0_.updated_by AS updated_by_6, s0_.is_excellent AS is_excellent_7, s1_.id AS id_8, s1_.label AS label_9, s1_.created_at AS created_at_10, s1_.updated_at AS updated_at_11, s1_.created_by AS created_by_12, s1_.updated_by AS updated_by_13, s1_.is_student_entry_test_do AS is_student_entry_test_do_14, s1_.is_student_toxicological_test_do AS is_student_toxicological_test_do_15, s1_.is_student_psychological_test_do AS is_student_psychological_test_do_16, s1_.is_student_cbe_affected AS is_student_cbe_affected_17, s1_.num_order AS num_order_18, s0_.establishment_id AS establishment_id_19, s0_.level_id AS level_id_20, s0_.faculty_id AS faculty_id_21, s0_.round_id AS round_id_22, s0_.school_year_id AS school_year_id_23, s1_.establishment_id AS establishment_id_24, s1_.cycle_id AS cycle_id_25, s1_.parent_id AS parent_id_26 FROM setting_classroom s0_ INNER JOIN setting_level s1_ ON s0_.level_id = s1_.id WHERE s0_.establishment_id = ? AND s0_.school_year_id = ? AND s0_.level_id = ?
Parameters:
[
  21
  3
  190
]
0.80 ms
(0.00%)
1
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.establishment_id AS establishment_id_25, t0.student_id AS student_id_26, t0.school_year_id AS school_year_id_27, t0.classroom_id AS classroom_id_28, t0.registration_student_pre_registration_id AS registration_student_pre_registration_id_29 FROM registration_student_registration t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  23614
]
0.70 ms
(0.00%)
1
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:
[
  190
]
0.39 ms
(0.00%)
1
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.student_registration_id = ?
Parameters:
[
  23614
]
0.35 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.method AS method_3, t0.memo AS memo_4, t0.amount AS amount_5, t0.create_at AS create_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.establishment_id AS establishment_id_11, t0.student_registration_id AS student_registration_id_12, t0.cash_register_id AS cash_register_id_13, t0.school_year_id AS school_year_id_14 FROM accounting_student_registration_payment t0 WHERE t0.student_registration_id = ?
Parameters:
[
  23614
]
0.26 ms
(0.00%)
1
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.id = ?
Parameters:
[
  1334
]

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\RegistrationStudentRegistration No errors.
App\Entity\SettingClassroom No errors.
App\Entity\RegistrationStudent 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\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\SettingLevel No errors.
App\Entity\SettingFaculty No errors.
App\Entity\SettingRound No errors.
App\Entity\SchoolAverage No errors.
App\Entity\SchoolWorkingTime No errors.
App\Entity\SchoolWorkingTimeHourLesson No errors.
App\Entity\SchoolTeacherCallSheet No errors.
App\Entity\SchoolTeacherMatterClassroom No errors.
App\Entity\SchoolTeacherTimeSheet No errors.
App\Entity\SchoolTeacherAbsence
  • The association App\Entity\SchoolTeacherAbsence#settingTimeTable refers to the inverse side field App\Entity\SettingTimeTable#schoolTeacherAbsences which does not exist.
App\Entity\SchoolMatter No errors.
App\Entity\SchoolSubMatter No errors.
App\Entity\ReportCard No errors.
App\Entity\SettingFee No errors.
App\Entity\EntreTestReportCard No errors.
App\Entity\PreRegistrationEntreTestReportCard No errors.
App\Entity\SchoolAssessment No errors.
App\Entity\SettingMedicalHistory No errors.
App\Entity\SettingLearningDifficulty No errors.
App\Entity\RegistrationDiet No errors.
App\Entity\SchoolCertificate No errors.
App\Entity\MobileParentAppAccount 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\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\SchoolYearPeriode No errors.
App\Entity\SchoolMatterType No errors.
App\Entity\SchoolNoteAppreciation No errors.
App\Entity\RegistrationStudentDowngradeLine No errors.
App\Entity\RegistrationStudentAbandonmentLine No errors.
App\Entity\TreasuryPayment 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\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\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\StockStudentKitEntryLine No errors.
App\Entity\StockKitOutLine No errors.
App\Entity\XlsImportation No errors.
App\Entity\AccountingCreditLine No errors.
App\Entity\SchoolCertificateLine No errors.
App\Entity\SettingRoom No errors.
App\Entity\SettingTimeTable No errors.
App\Entity\FoundingNotification No errors.
App\Entity\EquivalentMatter No errors.
App\Entity\RhSalaryPaySlipPayment No errors.
App\Entity\RhSalaryContractItem No errors.
App\Entity\AccountingExpenseCategory 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\GescotiContribution No errors.