Query Metrics

122 Database Queries
17 Different statements
89.17 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.56 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.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:
[
  28
]
2 1.38 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:
[
  "16774"
]
3 0.33 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.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:
[
  4
]
4 0.92 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.establishment_id = ?
Parameters:
[
  4
]
5 1.25 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  19
]
6 1.09 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  20
]
7 1.02 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  21
]
8 1.18 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  22
]
9 0.75 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  23
]
10 0.44 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  24
]
11 0.34 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  25
]
12 0.61 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  42
]
13 0.86 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  43
]
14 0.56 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  44
]
15 0.52 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  45
]
16 0.44 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  46
]
17 0.54 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  47
]
18 0.57 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  48
]
19 0.55 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  49
]
20 0.68 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  50
]
21 0.68 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  51
]
22 0.60 ms
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 = ? ORDER BY t0.label ASC
Parameters:
[
  68
]
23 0.86 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:
[
  16774
]
24 0.29 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 ORDER BY t0.id DESC
Parameters:
[]
25 0.35 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.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 ORDER BY t0.id DESC
Parameters:
[]
26 0.25 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 ORDER BY t0.id DESC
Parameters:
[]
27 0.31 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.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 INNER JOIN user_establishment ON t0.id = user_establishment.establishment_id WHERE user_establishment.user_id = ?
Parameters:
[
  28
]
28 2.50 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
29 2.19 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
30 0.21 ms
SELECT DATABASE()
Parameters:
[]
31 1.13 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_edu_central_2022' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
32 0.16 ms
SELECT DATABASE()
Parameters:
[]
33 0.57 ms
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'db_edu_central_2022' /*!50116 AND c.constraint_schema = 'db_edu_central_2022' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
Parameters:
[]
34 0.12 ms
SELECT DATABASE()
Parameters:
[]
35 0.32 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'db_edu_central_2022' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
36 0.45 ms
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
37 0.16 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
38 2.40 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
39 2.02 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
40 0.18 ms
SELECT DATABASE()
Parameters:
[]
41 1.05 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_edu_central_2022' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
42 0.20 ms
SELECT DATABASE()
Parameters:
[]
43 0.53 ms
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'db_edu_central_2022' /*!50116 AND c.constraint_schema = 'db_edu_central_2022' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
Parameters:
[]
44 0.12 ms
SELECT DATABASE()
Parameters:
[]
45 0.32 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'db_edu_central_2022' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
46 0.40 ms
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
47 0.17 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
48 2.27 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
49 2.21 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
50 0.23 ms
SELECT DATABASE()
Parameters:
[]
51 1.07 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_edu_central_2022' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
52 0.17 ms
SELECT DATABASE()
Parameters:
[]
53 0.63 ms
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'db_edu_central_2022' /*!50116 AND c.constraint_schema = 'db_edu_central_2022' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
Parameters:
[]
54 0.15 ms
SELECT DATABASE()
Parameters:
[]
55 0.40 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'db_edu_central_2022' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
56 0.45 ms
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
57 0.17 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
58 0.22 ms
SELECT DATABASE()
Parameters:
[]
59 0.26 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 ORDER BY t0.id DESC
Parameters:
[]
60 0.28 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.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 ORDER BY t0.id DESC
Parameters:
[]
61 2.49 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
62 2.25 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
63 0.20 ms
SELECT DATABASE()
Parameters:
[]
64 1.37 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_edu_central_2022' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
65 0.21 ms
SELECT DATABASE()
Parameters:
[]
66 0.60 ms
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'db_edu_central_2022' /*!50116 AND c.constraint_schema = 'db_edu_central_2022' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
Parameters:
[]
67 0.21 ms
SELECT DATABASE()
Parameters:
[]
68 0.40 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'db_edu_central_2022' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
69 0.43 ms
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
70 0.17 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
71 2.49 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
72 2.06 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
73 0.22 ms
SELECT DATABASE()
Parameters:
[]
74 1.13 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_edu_central_2022' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
75 0.18 ms
SELECT DATABASE()
Parameters:
[]
76 0.60 ms
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'db_edu_central_2022' /*!50116 AND c.constraint_schema = 'db_edu_central_2022' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
Parameters:
[]
77 0.15 ms
SELECT DATABASE()
Parameters:
[]
78 0.47 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'db_edu_central_2022' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
79 0.43 ms
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
80 0.16 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
81 2.24 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
82 2.14 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
83 0.20 ms
SELECT DATABASE()
Parameters:
[]
84 1.00 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_edu_central_2022' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
85 0.17 ms
SELECT DATABASE()
Parameters:
[]
86 0.61 ms
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'db_edu_central_2022' /*!50116 AND c.constraint_schema = 'db_edu_central_2022' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
Parameters:
[]
87 0.18 ms
SELECT DATABASE()
Parameters:
[]
88 0.46 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'db_edu_central_2022' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
89 0.46 ms
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
90 0.18 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
91 0.23 ms
SELECT DATABASE()
Parameters:
[]
92 2.29 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
93 2.23 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
94 0.18 ms
SELECT DATABASE()
Parameters:
[]
95 1.04 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_edu_central_2022' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
96 0.15 ms
SELECT DATABASE()
Parameters:
[]
97 0.60 ms
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'db_edu_central_2022' /*!50116 AND c.constraint_schema = 'db_edu_central_2022' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
Parameters:
[]
98 0.13 ms
SELECT DATABASE()
Parameters:
[]
99 0.35 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'db_edu_central_2022' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
100 0.41 ms
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
101 0.16 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
102 2.27 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
103 2.30 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
104 0.19 ms
SELECT DATABASE()
Parameters:
[]
105 1.07 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_edu_central_2022' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
106 0.19 ms
SELECT DATABASE()
Parameters:
[]
107 0.53 ms
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'db_edu_central_2022' /*!50116 AND c.constraint_schema = 'db_edu_central_2022' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
Parameters:
[]
108 0.14 ms
SELECT DATABASE()
Parameters:
[]
109 0.33 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'db_edu_central_2022' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
110 0.44 ms
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
111 0.17 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
112 2.56 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
113 2.25 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
114 0.21 ms
SELECT DATABASE()
Parameters:
[]
115 1.04 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_edu_central_2022' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
116 0.17 ms
SELECT DATABASE()
Parameters:
[]
117 0.59 ms
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'db_edu_central_2022' /*!50116 AND c.constraint_schema = 'db_edu_central_2022' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
Parameters:
[]
118 0.14 ms
SELECT DATABASE()
Parameters:
[]
119 0.44 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'db_edu_central_2022' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
120 0.43 ms
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
121 0.18 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
122 0.21 ms
SELECT DATABASE()
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\RegistrationStudentPreRegistration No errors.
App\Entity\RegistrationStudent No errors.
App\Entity\SettingLevel No errors.
App\Entity\RegistrationStudentRegistration No errors.
App\Entity\PreRegistrationEntreTestReportCard No errors.
App\Entity\ToxicologicalTestResult 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\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\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\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\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\ToxicologicalTestResultLine No errors.
App\Entity\ToxicologicalTestLaboratory 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\GescotiContribution No errors.
App\Entity\AccountingAccount No errors.
App\Entity\MobileParentAppAccountActivity No errors.