Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

41 Database Queries

15 Different statements

26.18 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_enabled AS is_enabled_5, t0.is_password_changed AS is_password_changed_6, t0.last_login_at AS last_login_at_7, t0.last_auth_time AS last_auth_time_8, t0.token_live_time AS token_live_time_9, t0.token AS token_10, t0.is_can_aproved_expense AS is_can_aproved_expense_11, t0.establishment_id AS establishment_id_12, t0.establishment_group_id AS establishment_group_id_13, t14.id AS id_15, t14.code AS code_16, t14.zkbio_emp_code AS zkbio_emp_code_17, t14.last_name AS last_name_18, t14.first_name AS first_name_19, t14.gender AS gender_20, t14.phone_number AS phone_number_21, t14.mobile_number AS mobile_number_22, t14.email AS email_23, t14.address AS address_24, t14.location AS location_25, t14.birth_day AS birth_day_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.created_by AS created_by_29, t14.updated_by AS updated_by_30, t14.image AS image_31, t14.hiring_date AS hiring_date_32, t14.date_of_departure AS date_of_departure_33, t14.nationality AS nationality_34, t14.identification_id AS identification_id_35, t14.passport_id AS passport_id_36, t14.bank_code AS bank_code_37, t14.bank_name AS bank_name_38, t14.bank_account_number AS bank_account_number_39, t14.finet_account_number AS finet_account_number_40, t14.counter_code AS counter_code_41, t14.hourly_rate AS hourly_rate_42, t14.default_number_hour_performed AS default_number_hour_performed_43, t14.number_of_children AS number_of_children_44, t14.family_situation AS family_situation_45, t14.base_salary AS base_salary_46, t14.social_number AS social_number_47, t14.is_permanent AS is_permanent_48, t14.is_declared AS is_declared_49, t14.establishment_id AS establishment_id_50, t14.user_id AS user_id_51, t14.rh_job_id AS rh_job_id_52, t14.rh_department_id AS rh_department_id_53, t14.statut_id AS statut_id_54, t0.school_year_id AS school_year_id_55 FROM user t0 LEFT JOIN rh_salary t14 ON t14.user_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.day AS day_2, t0.create_date AS create_date_3, t0.create_time AS create_time_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_validated AS is_validated_9, t0.is_aproved AS is_aproved_10, t0.defaut_duration AS defaut_duration_11, t0.status AS status_12, t0.rejection_reason AS rejection_reason_13, t0.establishment_id AS establishment_id_14, t0.school_year_id AS school_year_id_15, t0.setting_classroom_id AS setting_classroom_id_16, t0.school_working_time_id AS school_working_time_id_17, t0.setting_time_table_id AS setting_time_table_id_18, t0.school_matter_id AS school_matter_id_19, t0.school_teacher_id AS school_teacher_id_20 FROM school_teacher_call_sheet t0 WHERE t0.id = ?
SELECT s0_.id AS id_0, s0_.is_presente AS is_presente_1, s0_.is_absent AS is_absent_2, s0_.day AS day_3, s0_.create_date AS create_date_4, s0_.create_time AS create_time_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by AS created_by_8, s0_.updated_by AS updated_by_9, r1_.id AS id_10, r1_.is_redoubling AS is_redoubling_11, r1_.is_diet AS is_diet_12, r1_.is_internal AS is_internal_13, r1_.is_affected AS is_affected_14, r1_.registered_at AS registered_at_15, r1_.created_at AS created_at_16, r1_.updated_at AS updated_at_17, r1_.created_by AS created_by_18, r1_.updated_by AS updated_by_19, r1_.last_amount_paid AS last_amount_paid_20, r1_.last_payment_id AS last_payment_id_21, r1_.last_payment_at AS last_payment_at_22, r1_.image AS image_23, r1_.is_abandonned AS is_abandonned_24, r1_.as_food_restrictions AS as_food_restrictions_25, r1_.is_meatless_menu AS is_meatless_menu_26, r1_.is_menu_without_pork AS is_menu_without_pork_27, r1_.is_can_eat_alone AS is_can_eat_alone_28, r1_.is_can_do_his_business_alone AS is_can_do_his_business_alone_29, r1_.is_falls_sleep_easily AS is_falls_sleep_easily_30, r1_.is_new AS is_new_31, r1_.portal_login AS portal_login_32, r1_.portal_password AS portal_password_33, r1_.is_authorized_alone AS is_authorized_alone_34, r1_.status AS status_35, r2_.id AS id_36, r2_.code AS code_37, r2_.last_name AS last_name_38, r2_.first_name AS first_name_39, r2_.notification_phone_number AS notification_phone_number_40, r2_.notification_name AS notification_name_41, r2_.notification_watsapp_number AS notification_watsapp_number_42, r2_.observation AS observation_43, r2_.location AS location_44, r2_.gender AS gender_45, r2_.birthday AS birthday_46, r2_.birth_location AS birth_location_47, r2_.birth_certificate_number AS birth_certificate_number_48, r2_.created_at AS created_at_49, r2_.updated_at AS updated_at_50, r2_.created_by AS created_by_51, r2_.updated_by AS updated_by_52, r2_.image AS image_53, r2_.create_date AS create_date_54, r2_.is_affected AS is_affected_55, r2_.is_redoubling AS is_redoubling_56, r2_.last_school_attended AS last_school_attended_57, r2_.last_school_attended_type AS last_school_attended_type_58, r2_.registration_number AS registration_number_59, r2_.lv1 AS lv1_60, r2_.lv2 AS lv2_61, r2_.art_or_musique AS art_or_musique_62, r2_.nationality AS nationality_63, r2_.where_resides AS where_resides_64, r2_.parent_status AS parent_status_65, r2_.is_parntal_authority_father AS is_parntal_authority_father_66, r2_.is_father_call_to_emergency AS is_father_call_to_emergency_67, r2_.father_last_name AS father_last_name_68, r2_.father_first_name AS father_first_name_69, r2_.father_address AS father_address_70, r2_.father_phone_number AS father_phone_number_71, r2_.father_post AS father_post_72, r2_.father_location AS father_location_73, r2_.father_email AS father_email_74, r2_.is_parntal_authority_mother AS is_parntal_authority_mother_75, r2_.is_mother_call_to_emergency AS is_mother_call_to_emergency_76, r2_.mother_last_name AS mother_last_name_77, r2_.mother_first_name AS mother_first_name_78, r2_.mother_address AS mother_address_79, r2_.mother_phone_number AS mother_phone_number_80, r2_.mother_post AS mother_post_81, r2_.mother_location AS mother_location_82, r2_.mother_email AS mother_email_83, r2_.responsible_of_schooling AS responsible_of_schooling_84, r2_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_85, r2_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_86, r2_.responsible_of_schooling_address AS responsible_of_schooling_address_87, r2_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_88, r2_.responsible_of_schooling_post AS responsible_of_schooling_post_89, r2_.responsible_of_schooling_location AS responsible_of_schooling_location_90, r2_.accompanying_person_name AS accompanying_person_name_91, r2_.accompanying_person_phone_number AS accompanying_person_phone_number_92, r2_.accompanying_person_name_2 AS accompanying_person_name_2_93, r2_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_94, r2_.accompanying_person_name_3 AS accompanying_person_name_3_95, r2_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_96, r2_.doctor_name AS doctor_name_97, r2_.doctor_phone_number AS doctor_phone_number_98, r2_.other_medical_history AS other_medical_history_99, r2_.other_learning_difficulty AS other_learning_difficulty_100, r2_.teacher_observation AS teacher_observation_101, r2_.parent_observation AS parent_observation_102, r2_.anterior_balance AS anterior_balance_103, r2_.is_archived AS is_archived_104, s0_.school_teacher_call_sheet_id AS school_teacher_call_sheet_id_105, s0_.establishment_id AS establishment_id_106, s0_.school_year_id AS school_year_id_107, s0_.registration_student_registration_id AS registration_student_registration_id_108, r1_.establishment_id AS establishment_id_109, r1_.student_id AS student_id_110, r1_.school_year_id AS school_year_id_111, r1_.classroom_id AS classroom_id_112, r1_.registration_student_pre_registration_id AS registration_student_pre_registration_id_113, r2_.establishment_id AS establishment_id_114, r2_.entry_level_id AS entry_level_id_115, r2_.medical_history_id AS medical_history_id_116, r2_.learning_difficulty_id AS learning_difficulty_id_117 FROM school_teacher_call_sheet_line s0_ INNER JOIN registration_student_registration r1_ ON s0_.registration_student_registration_id = r1_.id INNER JOIN registration_student r2_ ON r1_.student_id = r2_.id WHERE s0_.school_teacher_call_sheet_id = ? ORDER BY r2_.last_name ASC
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 = ?
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
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 ORDER BY t0.id DESC
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, t0.begin_at AS begin_at_11, t0.end_at AS end_at_12 FROM school_year t0 ORDER BY t0.id DESC
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 INNER JOIN user_establishment ON t0.id = user_establishment.establishment_id WHERE user_establishment.user_id = ?
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SELECT DATABASE()
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
SELECT DATABASE()
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
SELECT DATABASE()
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
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'
SELECT * FROM doctrine_migration_versions
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SELECT DATABASE()
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
SELECT DATABASE()
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
SELECT DATABASE()
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
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'
SELECT * FROM doctrine_migration_versions
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
SELECT DATABASE()
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
SELECT DATABASE()
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
SELECT DATABASE()
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
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'
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()
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
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 ORDER BY t0.id DESC

#▲	Time	Info
1	0.86 ms	SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_enabled AS is_enabled_5, t0.is_password_changed AS is_password_changed_6, t0.last_login_at AS last_login_at_7, t0.last_auth_time AS last_auth_time_8, t0.token_live_time AS token_live_time_9, t0.token AS token_10, t0.is_can_aproved_expense AS is_can_aproved_expense_11, t0.establishment_id AS establishment_id_12, t0.establishment_group_id AS establishment_group_id_13, t14.id AS id_15, t14.code AS code_16, t14.zkbio_emp_code AS zkbio_emp_code_17, t14.last_name AS last_name_18, t14.first_name AS first_name_19, t14.gender AS gender_20, t14.phone_number AS phone_number_21, t14.mobile_number AS mobile_number_22, t14.email AS email_23, t14.address AS address_24, t14.location AS location_25, t14.birth_day AS birth_day_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.created_by AS created_by_29, t14.updated_by AS updated_by_30, t14.image AS image_31, t14.hiring_date AS hiring_date_32, t14.date_of_departure AS date_of_departure_33, t14.nationality AS nationality_34, t14.identification_id AS identification_id_35, t14.passport_id AS passport_id_36, t14.bank_code AS bank_code_37, t14.bank_name AS bank_name_38, t14.bank_account_number AS bank_account_number_39, t14.finet_account_number AS finet_account_number_40, t14.counter_code AS counter_code_41, t14.hourly_rate AS hourly_rate_42, t14.default_number_hour_performed AS default_number_hour_performed_43, t14.number_of_children AS number_of_children_44, t14.family_situation AS family_situation_45, t14.base_salary AS base_salary_46, t14.social_number AS social_number_47, t14.is_permanent AS is_permanent_48, t14.is_declared AS is_declared_49, t14.establishment_id AS establishment_id_50, t14.user_id AS user_id_51, t14.rh_job_id AS rh_job_id_52, t14.rh_department_id AS rh_department_id_53, t14.statut_id AS statut_id_54, t0.school_year_id AS school_year_id_55 FROM user t0 LEFT JOIN rh_salary t14 ON t14.user_id = t0.id WHERE t0.id = ? Parameters: [`395`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_enabled AS is_enabled_5, t0.is_password_changed AS is_password_changed_6, t0.last_login_at AS last_login_at_7, t0.last_auth_time AS last_auth_time_8, t0.token_live_time AS token_live_time_9, t0.token AS token_10, t0.is_can_aproved_expense AS is_can_aproved_expense_11, t0.establishment_id AS establishment_id_12, t0.establishment_group_id AS establishment_group_id_13, t14.id AS id_15, t14.code AS code_16, t14.zkbio_emp_code AS zkbio_emp_code_17, t14.last_name AS last_name_18, t14.first_name AS first_name_19, t14.gender AS gender_20, t14.phone_number AS phone_number_21, t14.mobile_number AS mobile_number_22, t14.email AS email_23, t14.address AS address_24, t14.location AS location_25, t14.birth_day AS birth_day_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.created_by AS created_by_29, t14.updated_by AS updated_by_30, t14.image AS image_31, t14.hiring_date AS hiring_date_32, t14.date_of_departure AS date_of_departure_33, t14.nationality AS nationality_34, t14.identification_id AS identification_id_35, t14.passport_id AS passport_id_36, t14.bank_code AS bank_code_37, t14.bank_name AS bank_name_38, t14.bank_account_number AS bank_account_number_39, t14.finet_account_number AS finet_account_number_40, t14.counter_code AS counter_code_41, t14.hourly_rate AS hourly_rate_42, t14.default_number_hour_performed AS default_number_hour_performed_43, t14.number_of_children AS number_of_children_44, t14.family_situation AS family_situation_45, t14.base_salary AS base_salary_46, t14.social_number AS social_number_47, t14.is_permanent AS is_permanent_48, t14.is_declared AS is_declared_49, t14.establishment_id AS establishment_id_50, t14.user_id AS user_id_51, t14.rh_job_id AS rh_job_id_52, t14.rh_department_id AS rh_department_id_53, t14.statut_id AS statut_id_54, t0.school_year_id AS school_year_id_55 FROM user t0 LEFT JOIN rh_salary t14 ON t14.user_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_enabled AS is_enabled_5, t0.is_password_changed AS is_password_changed_6, t0.last_login_at AS last_login_at_7, t0.last_auth_time AS last_auth_time_8, t0.token_live_time AS token_live_time_9, t0.token AS token_10, t0.is_can_aproved_expense AS is_can_aproved_expense_11, t0.establishment_id AS establishment_id_12, t0.establishment_group_id AS establishment_group_id_13, t14.id AS id_15, t14.code AS code_16, t14.zkbio_emp_code AS zkbio_emp_code_17, t14.last_name AS last_name_18, t14.first_name AS first_name_19, t14.gender AS gender_20, t14.phone_number AS phone_number_21, t14.mobile_number AS mobile_number_22, t14.email AS email_23, t14.address AS address_24, t14.location AS location_25, t14.birth_day AS birth_day_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.created_by AS created_by_29, t14.updated_by AS updated_by_30, t14.image AS image_31, t14.hiring_date AS hiring_date_32, t14.date_of_departure AS date_of_departure_33, t14.nationality AS nationality_34, t14.identification_id AS identification_id_35, t14.passport_id AS passport_id_36, t14.bank_code AS bank_code_37, t14.bank_name AS bank_name_38, t14.bank_account_number AS bank_account_number_39, t14.finet_account_number AS finet_account_number_40, t14.counter_code AS counter_code_41, t14.hourly_rate AS hourly_rate_42, t14.default_number_hour_performed AS default_number_hour_performed_43, t14.number_of_children AS number_of_children_44, t14.family_situation AS family_situation_45, t14.base_salary AS base_salary_46, t14.social_number AS social_number_47, t14.is_permanent AS is_permanent_48, t14.is_declared AS is_declared_49, t14.establishment_id AS establishment_id_50, t14.user_id AS user_id_51, t14.rh_job_id AS rh_job_id_52, t14.rh_department_id AS rh_department_id_53, t14.statut_id AS statut_id_54, t0.school_year_id AS school_year_id_55 FROM user t0 LEFT JOIN rh_salary t14 ON t14.user_id = t0.id WHERE t0.id = 395;
2	0.46 ms	SELECT t0.id AS id_1, t0.day AS day_2, t0.create_date AS create_date_3, t0.create_time AS create_time_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_validated AS is_validated_9, t0.is_aproved AS is_aproved_10, t0.defaut_duration AS defaut_duration_11, t0.status AS status_12, t0.rejection_reason AS rejection_reason_13, t0.establishment_id AS establishment_id_14, t0.school_year_id AS school_year_id_15, t0.setting_classroom_id AS setting_classroom_id_16, t0.school_working_time_id AS school_working_time_id_17, t0.setting_time_table_id AS setting_time_table_id_18, t0.school_matter_id AS school_matter_id_19, t0.school_teacher_id AS school_teacher_id_20 FROM school_teacher_call_sheet t0 WHERE t0.id = ? Parameters: [`"180064"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.day AS day_2, t0.create_date AS create_date_3, t0.create_time AS create_time_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_validated AS is_validated_9, t0.is_aproved AS is_aproved_10, t0.defaut_duration AS defaut_duration_11, t0.status AS status_12, t0.rejection_reason AS rejection_reason_13, t0.establishment_id AS establishment_id_14, t0.school_year_id AS school_year_id_15, t0.setting_classroom_id AS setting_classroom_id_16, t0.school_working_time_id AS school_working_time_id_17, t0.setting_time_table_id AS setting_time_table_id_18, t0.school_matter_id AS school_matter_id_19, t0.school_teacher_id AS school_teacher_id_20 FROM school_teacher_call_sheet t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.day AS day_2, t0.create_date AS create_date_3, t0.create_time AS create_time_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_validated AS is_validated_9, t0.is_aproved AS is_aproved_10, t0.defaut_duration AS defaut_duration_11, t0.status AS status_12, t0.rejection_reason AS rejection_reason_13, t0.establishment_id AS establishment_id_14, t0.school_year_id AS school_year_id_15, t0.setting_classroom_id AS setting_classroom_id_16, t0.school_working_time_id AS school_working_time_id_17, t0.setting_time_table_id AS setting_time_table_id_18, t0.school_matter_id AS school_matter_id_19, t0.school_teacher_id AS school_teacher_id_20 FROM school_teacher_call_sheet t0 WHERE t0.id = '180064';
3	4.90 ms	SELECT s0_.id AS id_0, s0_.is_presente AS is_presente_1, s0_.is_absent AS is_absent_2, s0_.day AS day_3, s0_.create_date AS create_date_4, s0_.create_time AS create_time_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by AS created_by_8, s0_.updated_by AS updated_by_9, r1_.id AS id_10, r1_.is_redoubling AS is_redoubling_11, r1_.is_diet AS is_diet_12, r1_.is_internal AS is_internal_13, r1_.is_affected AS is_affected_14, r1_.registered_at AS registered_at_15, r1_.created_at AS created_at_16, r1_.updated_at AS updated_at_17, r1_.created_by AS created_by_18, r1_.updated_by AS updated_by_19, r1_.last_amount_paid AS last_amount_paid_20, r1_.last_payment_id AS last_payment_id_21, r1_.last_payment_at AS last_payment_at_22, r1_.image AS image_23, r1_.is_abandonned AS is_abandonned_24, r1_.as_food_restrictions AS as_food_restrictions_25, r1_.is_meatless_menu AS is_meatless_menu_26, r1_.is_menu_without_pork AS is_menu_without_pork_27, r1_.is_can_eat_alone AS is_can_eat_alone_28, r1_.is_can_do_his_business_alone AS is_can_do_his_business_alone_29, r1_.is_falls_sleep_easily AS is_falls_sleep_easily_30, r1_.is_new AS is_new_31, r1_.portal_login AS portal_login_32, r1_.portal_password AS portal_password_33, r1_.is_authorized_alone AS is_authorized_alone_34, r1_.status AS status_35, r2_.id AS id_36, r2_.code AS code_37, r2_.last_name AS last_name_38, r2_.first_name AS first_name_39, r2_.notification_phone_number AS notification_phone_number_40, r2_.notification_name AS notification_name_41, r2_.notification_watsapp_number AS notification_watsapp_number_42, r2_.observation AS observation_43, r2_.location AS location_44, r2_.gender AS gender_45, r2_.birthday AS birthday_46, r2_.birth_location AS birth_location_47, r2_.birth_certificate_number AS birth_certificate_number_48, r2_.created_at AS created_at_49, r2_.updated_at AS updated_at_50, r2_.created_by AS created_by_51, r2_.updated_by AS updated_by_52, r2_.image AS image_53, r2_.create_date AS create_date_54, r2_.is_affected AS is_affected_55, r2_.is_redoubling AS is_redoubling_56, r2_.last_school_attended AS last_school_attended_57, r2_.last_school_attended_type AS last_school_attended_type_58, r2_.registration_number AS registration_number_59, r2_.lv1 AS lv1_60, r2_.lv2 AS lv2_61, r2_.art_or_musique AS art_or_musique_62, r2_.nationality AS nationality_63, r2_.where_resides AS where_resides_64, r2_.parent_status AS parent_status_65, r2_.is_parntal_authority_father AS is_parntal_authority_father_66, r2_.is_father_call_to_emergency AS is_father_call_to_emergency_67, r2_.father_last_name AS father_last_name_68, r2_.father_first_name AS father_first_name_69, r2_.father_address AS father_address_70, r2_.father_phone_number AS father_phone_number_71, r2_.father_post AS father_post_72, r2_.father_location AS father_location_73, r2_.father_email AS father_email_74, r2_.is_parntal_authority_mother AS is_parntal_authority_mother_75, r2_.is_mother_call_to_emergency AS is_mother_call_to_emergency_76, r2_.mother_last_name AS mother_last_name_77, r2_.mother_first_name AS mother_first_name_78, r2_.mother_address AS mother_address_79, r2_.mother_phone_number AS mother_phone_number_80, r2_.mother_post AS mother_post_81, r2_.mother_location AS mother_location_82, r2_.mother_email AS mother_email_83, r2_.responsible_of_schooling AS responsible_of_schooling_84, r2_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_85, r2_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_86, r2_.responsible_of_schooling_address AS responsible_of_schooling_address_87, r2_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_88, r2_.responsible_of_schooling_post AS responsible_of_schooling_post_89, r2_.responsible_of_schooling_location AS responsible_of_schooling_location_90, r2_.accompanying_person_name AS accompanying_person_name_91, r2_.accompanying_person_phone_number AS accompanying_person_phone_number_92, r2_.accompanying_person_name_2 AS accompanying_person_name_2_93, r2_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_94, r2_.accompanying_person_name_3 AS accompanying_person_name_3_95, r2_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_96, r2_.doctor_name AS doctor_name_97, r2_.doctor_phone_number AS doctor_phone_number_98, r2_.other_medical_history AS other_medical_history_99, r2_.other_learning_difficulty AS other_learning_difficulty_100, r2_.teacher_observation AS teacher_observation_101, r2_.parent_observation AS parent_observation_102, r2_.anterior_balance AS anterior_balance_103, r2_.is_archived AS is_archived_104, s0_.school_teacher_call_sheet_id AS school_teacher_call_sheet_id_105, s0_.establishment_id AS establishment_id_106, s0_.school_year_id AS school_year_id_107, s0_.registration_student_registration_id AS registration_student_registration_id_108, r1_.establishment_id AS establishment_id_109, r1_.student_id AS student_id_110, r1_.school_year_id AS school_year_id_111, r1_.classroom_id AS classroom_id_112, r1_.registration_student_pre_registration_id AS registration_student_pre_registration_id_113, r2_.establishment_id AS establishment_id_114, r2_.entry_level_id AS entry_level_id_115, r2_.medical_history_id AS medical_history_id_116, r2_.learning_difficulty_id AS learning_difficulty_id_117 FROM school_teacher_call_sheet_line s0_ INNER JOIN registration_student_registration r1_ ON s0_.registration_student_registration_id = r1_.id INNER JOIN registration_student r2_ ON r1_.student_id = r2_.id WHERE s0_.school_teacher_call_sheet_id = ? ORDER BY r2_.last_name ASC Parameters: [`180064`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.is_presente AS is_presente_1, s0_.is_absent AS is_absent_2, s0_.day AS day_3, s0_.create_date AS create_date_4, s0_.create_time AS create_time_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by AS created_by_8, s0_.updated_by AS updated_by_9, r1_.id AS id_10, r1_.is_redoubling AS is_redoubling_11, r1_.is_diet AS is_diet_12, r1_.is_internal AS is_internal_13, r1_.is_affected AS is_affected_14, r1_.registered_at AS registered_at_15, r1_.created_at AS created_at_16, r1_.updated_at AS updated_at_17, r1_.created_by AS created_by_18, r1_.updated_by AS updated_by_19, r1_.last_amount_paid AS last_amount_paid_20, r1_.last_payment_id AS last_payment_id_21, r1_.last_payment_at AS last_payment_at_22, r1_.image AS image_23, r1_.is_abandonned AS is_abandonned_24, r1_.as_food_restrictions AS as_food_restrictions_25, r1_.is_meatless_menu AS is_meatless_menu_26, r1_.is_menu_without_pork AS is_menu_without_pork_27, r1_.is_can_eat_alone AS is_can_eat_alone_28, r1_.is_can_do_his_business_alone AS is_can_do_his_business_alone_29, r1_.is_falls_sleep_easily AS is_falls_sleep_easily_30, r1_.is_new AS is_new_31, r1_.portal_login AS portal_login_32, r1_.portal_password AS portal_password_33, r1_.is_authorized_alone AS is_authorized_alone_34, r1_.status AS status_35, r2_.id AS id_36, r2_.code AS code_37, r2_.last_name AS last_name_38, r2_.first_name AS first_name_39, r2_.notification_phone_number AS notification_phone_number_40, r2_.notification_name AS notification_name_41, r2_.notification_watsapp_number AS notification_watsapp_number_42, r2_.observation AS observation_43, r2_.location AS location_44, r2_.gender AS gender_45, r2_.birthday AS birthday_46, r2_.birth_location AS birth_location_47, r2_.birth_certificate_number AS birth_certificate_number_48, r2_.created_at AS created_at_49, r2_.updated_at AS updated_at_50, r2_.created_by AS created_by_51, r2_.updated_by AS updated_by_52, r2_.image AS image_53, r2_.create_date AS create_date_54, r2_.is_affected AS is_affected_55, r2_.is_redoubling AS is_redoubling_56, r2_.last_school_attended AS last_school_attended_57, r2_.last_school_attended_type AS last_school_attended_type_58, r2_.registration_number AS registration_number_59, r2_.lv1 AS lv1_60, r2_.lv2 AS lv2_61, r2_.art_or_musique AS art_or_musique_62, r2_.nationality AS nationality_63, r2_.where_resides AS where_resides_64, r2_.parent_status AS parent_status_65, r2_.is_parntal_authority_father AS is_parntal_authority_father_66, r2_.is_father_call_to_emergency AS is_father_call_to_emergency_67, r2_.father_last_name AS father_last_name_68, r2_.father_first_name AS father_first_name_69, r2_.father_address AS father_address_70, r2_.father_phone_number AS father_phone_number_71, r2_.father_post AS father_post_72, r2_.father_location AS father_location_73, r2_.father_email AS father_email_74, r2_.is_parntal_authority_mother AS is_parntal_authority_mother_75, r2_.is_mother_call_to_emergency AS is_mother_call_to_emergency_76, r2_.mother_last_name AS mother_last_name_77, r2_.mother_first_name AS mother_first_name_78, r2_.mother_address AS mother_address_79, r2_.mother_phone_number AS mother_phone_number_80, r2_.mother_post AS mother_post_81, r2_.mother_location AS mother_location_82, r2_.mother_email AS mother_email_83, r2_.responsible_of_schooling AS responsible_of_schooling_84, r2_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_85, r2_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_86, r2_.responsible_of_schooling_address AS responsible_of_schooling_address_87, r2_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_88, r2_.responsible_of_schooling_post AS responsible_of_schooling_post_89, r2_.responsible_of_schooling_location AS responsible_of_schooling_location_90, r2_.accompanying_person_name AS accompanying_person_name_91, r2_.accompanying_person_phone_number AS accompanying_person_phone_number_92, r2_.accompanying_person_name_2 AS accompanying_person_name_2_93, r2_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_94, r2_.accompanying_person_name_3 AS accompanying_person_name_3_95, r2_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_96, r2_.doctor_name AS doctor_name_97, r2_.doctor_phone_number AS doctor_phone_number_98, r2_.other_medical_history AS other_medical_history_99, r2_.other_learning_difficulty AS other_learning_difficulty_100, r2_.teacher_observation AS teacher_observation_101, r2_.parent_observation AS parent_observation_102, r2_.anterior_balance AS anterior_balance_103, r2_.is_archived AS is_archived_104, s0_.school_teacher_call_sheet_id AS school_teacher_call_sheet_id_105, s0_.establishment_id AS establishment_id_106, s0_.school_year_id AS school_year_id_107, s0_.registration_student_registration_id AS registration_student_registration_id_108, r1_.establishment_id AS establishment_id_109, r1_.student_id AS student_id_110, r1_.school_year_id AS school_year_id_111, r1_.classroom_id AS classroom_id_112, r1_.registration_student_pre_registration_id AS registration_student_pre_registration_id_113, r2_.establishment_id AS establishment_id_114, r2_.entry_level_id AS entry_level_id_115, r2_.medical_history_id AS medical_history_id_116, r2_.learning_difficulty_id AS learning_difficulty_id_117 FROM school_teacher_call_sheet_line s0_ INNER JOIN registration_student_registration r1_ ON s0_.registration_student_registration_id = r1_.id INNER JOIN registration_student r2_ ON r1_.student_id = r2_.id WHERE s0_.school_teacher_call_sheet_id = ? ORDER BY r2_.last_name ASC SELECT s0_.id AS id_0, s0_.is_presente AS is_presente_1, s0_.is_absent AS is_absent_2, s0_.day AS day_3, s0_.create_date AS create_date_4, s0_.create_time AS create_time_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.created_by AS created_by_8, s0_.updated_by AS updated_by_9, r1_.id AS id_10, r1_.is_redoubling AS is_redoubling_11, r1_.is_diet AS is_diet_12, r1_.is_internal AS is_internal_13, r1_.is_affected AS is_affected_14, r1_.registered_at AS registered_at_15, r1_.created_at AS created_at_16, r1_.updated_at AS updated_at_17, r1_.created_by AS created_by_18, r1_.updated_by AS updated_by_19, r1_.last_amount_paid AS last_amount_paid_20, r1_.last_payment_id AS last_payment_id_21, r1_.last_payment_at AS last_payment_at_22, r1_.image AS image_23, r1_.is_abandonned AS is_abandonned_24, r1_.as_food_restrictions AS as_food_restrictions_25, r1_.is_meatless_menu AS is_meatless_menu_26, r1_.is_menu_without_pork AS is_menu_without_pork_27, r1_.is_can_eat_alone AS is_can_eat_alone_28, r1_.is_can_do_his_business_alone AS is_can_do_his_business_alone_29, r1_.is_falls_sleep_easily AS is_falls_sleep_easily_30, r1_.is_new AS is_new_31, r1_.portal_login AS portal_login_32, r1_.portal_password AS portal_password_33, r1_.is_authorized_alone AS is_authorized_alone_34, r1_.status AS status_35, r2_.id AS id_36, r2_.code AS code_37, r2_.last_name AS last_name_38, r2_.first_name AS first_name_39, r2_.notification_phone_number AS notification_phone_number_40, r2_.notification_name AS notification_name_41, r2_.notification_watsapp_number AS notification_watsapp_number_42, r2_.observation AS observation_43, r2_.location AS location_44, r2_.gender AS gender_45, r2_.birthday AS birthday_46, r2_.birth_location AS birth_location_47, r2_.birth_certificate_number AS birth_certificate_number_48, r2_.created_at AS created_at_49, r2_.updated_at AS updated_at_50, r2_.created_by AS created_by_51, r2_.updated_by AS updated_by_52, r2_.image AS image_53, r2_.create_date AS create_date_54, r2_.is_affected AS is_affected_55, r2_.is_redoubling AS is_redoubling_56, r2_.last_school_attended AS last_school_attended_57, r2_.last_school_attended_type AS last_school_attended_type_58, r2_.registration_number AS registration_number_59, r2_.lv1 AS lv1_60, r2_.lv2 AS lv2_61, r2_.art_or_musique AS art_or_musique_62, r2_.nationality AS nationality_63, r2_.where_resides AS where_resides_64, r2_.parent_status AS parent_status_65, r2_.is_parntal_authority_father AS is_parntal_authority_father_66, r2_.is_father_call_to_emergency AS is_father_call_to_emergency_67, r2_.father_last_name AS father_last_name_68, r2_.father_first_name AS father_first_name_69, r2_.father_address AS father_address_70, r2_.father_phone_number AS father_phone_number_71, r2_.father_post AS father_post_72, r2_.father_location AS father_location_73, r2_.father_email AS father_email_74, r2_.is_parntal_authority_mother AS is_parntal_authority_mother_75, r2_.is_mother_call_to_emergency AS is_mother_call_to_emergency_76, r2_.mother_last_name AS mother_last_name_77, r2_.mother_first_name AS mother_first_name_78, r2_.mother_address AS mother_address_79, r2_.mother_phone_number AS mother_phone_number_80, r2_.mother_post AS mother_post_81, r2_.mother_location AS mother_location_82, r2_.mother_email AS mother_email_83, r2_.responsible_of_schooling AS responsible_of_schooling_84, r2_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_85, r2_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_86, r2_.responsible_of_schooling_address AS responsible_of_schooling_address_87, r2_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_88, r2_.responsible_of_schooling_post AS responsible_of_schooling_post_89, r2_.responsible_of_schooling_location AS responsible_of_schooling_location_90, r2_.accompanying_person_name AS accompanying_person_name_91, r2_.accompanying_person_phone_number AS accompanying_person_phone_number_92, r2_.accompanying_person_name_2 AS accompanying_person_name_2_93, r2_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_94, r2_.accompanying_person_name_3 AS accompanying_person_name_3_95, r2_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_96, r2_.doctor_name AS doctor_name_97, r2_.doctor_phone_number AS doctor_phone_number_98, r2_.other_medical_history AS other_medical_history_99, r2_.other_learning_difficulty AS other_learning_difficulty_100, r2_.teacher_observation AS teacher_observation_101, r2_.parent_observation AS parent_observation_102, r2_.anterior_balance AS anterior_balance_103, r2_.is_archived AS is_archived_104, s0_.school_teacher_call_sheet_id AS school_teacher_call_sheet_id_105, s0_.establishment_id AS establishment_id_106, s0_.school_year_id AS school_year_id_107, s0_.registration_student_registration_id AS registration_student_registration_id_108, r1_.establishment_id AS establishment_id_109, r1_.student_id AS student_id_110, r1_.school_year_id AS school_year_id_111, r1_.classroom_id AS classroom_id_112, r1_.registration_student_pre_registration_id AS registration_student_pre_registration_id_113, r2_.establishment_id AS establishment_id_114, r2_.entry_level_id AS entry_level_id_115, r2_.medical_history_id AS medical_history_id_116, r2_.learning_difficulty_id AS learning_difficulty_id_117 FROM school_teacher_call_sheet_line s0_ INNER JOIN registration_student_registration r1_ ON s0_.registration_student_registration_id = r1_.id INNER JOIN registration_student r2_ ON r1_.student_id = r2_.id WHERE s0_.school_teacher_call_sheet_id = 180064 ORDER BY r2_.last_name ASC;
4	0.24 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 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 = ? 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 = 3;
5	0.19 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: [] View formatted query View runnable query Explain query 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 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;
6	0.25 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 ORDER BY t0.id DESC Parameters: [] View formatted query View runnable query Explain query 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 ORDER BY t0.id DESC 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 ORDER BY t0.id DESC;
7	0.18 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, t0.begin_at AS begin_at_11, t0.end_at AS end_at_12 FROM school_year t0 ORDER BY t0.id DESC Parameters: [] View formatted query View runnable query Explain query 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, t0.begin_at AS begin_at_11, t0.end_at AS end_at_12 FROM school_year t0 ORDER BY t0.id DESC 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, t0.begin_at AS begin_at_11, t0.end_at AS end_at_12 FROM school_year t0 ORDER BY t0.id DESC;
8	1.03 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 INNER JOIN user_establishment ON t0.id = user_establishment.establishment_id WHERE user_establishment.user_id = ? Parameters: [`395`] View formatted query View runnable query Explain query 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 INNER JOIN user_establishment ON t0.id = user_establishment.establishment_id WHERE user_establishment.user_id = ? 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 INNER JOIN user_establishment ON t0.id = user_establishment.establishment_id WHERE user_establishment.user_id = 395;
9	2.18 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
10	1.68 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
11	0.20 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
12	0.78 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: [] View formatted query View runnable query Explain query 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 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;
13	0.19 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
14	0.49 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: [] View formatted query View runnable query Explain query 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 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;
15	0.13 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
16	0.27 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: [] View formatted query View runnable query Explain query 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 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;
17	0.47 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: [] View formatted query View runnable query Explain query 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' 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';
18	0.20 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
19	2.17 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
20	1.45 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
21	0.24 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
22	0.71 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: [] View formatted query View runnable query Explain query 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 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;
23	0.18 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
24	0.45 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: [] View formatted query View runnable query Explain query 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 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;
25	0.11 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
26	0.25 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: [] View formatted query View runnable query Explain query 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 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;
27	0.29 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: [] View formatted query View runnable query Explain query 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' 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';
28	0.12 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
29	1.55 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
30	1.58 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
31	0.11 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
32	0.55 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: [] View formatted query View runnable query Explain query 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 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;
33	0.11 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
34	0.33 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: [] View formatted query View runnable query Explain query 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 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;
35	0.12 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
36	0.21 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: [] View formatted query View runnable query Explain query 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 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;
37	0.24 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: [] View formatted query View runnable query Explain query 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' 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';
38	0.13 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
39	0.11 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
40	0.19 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: [] View formatted query View runnable query Explain query 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 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;
41	0.27 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 ORDER BY t0.id DESC Parameters: [] View formatted query View runnable query Explain query 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 ORDER BY t0.id DESC 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 ORDER BY t0.id DESC;

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\SchoolTeacherCallSheet	No errors.
App\Entity\SettingClassroom	No errors.
App\Entity\SchoolWorkingTime	No errors.
App\Entity\SettingTimeTable	No errors.
App\Entity\SchoolMatter	No errors.
App\Entity\SchoolTeacherCallSheetLine	No errors.
App\Entity\SchoolTeacherTimeSheet	No errors.
App\Entity\RegistrationStudentRegistration	No errors.
App\Entity\RegistrationStudent	No errors.
App\Entity\RegistrationStudentPreRegistration	No errors.
App\Entity\SettingLevel	No errors.
App\Entity\SettingMedicalHistory	No errors.
App\Entity\SettingLearningDifficulty	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\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\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\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\SchoolYearPeriode	No errors.
App\Entity\SchoolMatterType	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\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\SchoolAverage	No errors.
App\Entity\SchoolCertificateLine	No errors.
App\Entity\SettingRoom	No errors.
App\Entity\SchoolWorkingTimeHourLesson	No errors.
App\Entity\FoundingNotification	No errors.
App\Entity\EquivalentMatter	No errors.
App\Entity\SchoolTeacherMatterClassroom	No errors.
App\Entity\RhSalaryPaySlipPayment	No errors.
App\Entity\RhSalaryContractItem	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\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\AccountingAccount	No errors.
App\Entity\MobileParentAppAccountActivity	No errors.
App\Entity\TransportIncident	No errors.

Symfony Profiler

https://central-edu.net/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CDefaultController%253A%253A_sidebar

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping