Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_password_changed AS is_password_changed_6,
  t0.last_login_at AS last_login_at_7,
  t0.last_auth_time AS last_auth_time_8,
  t0.token_live_time AS token_live_time_9,
  t0.token AS token_10,
  t0.is_can_aproved_expense AS is_can_aproved_expense_11,
  t0.establishment_id AS establishment_id_12,
  t0.establishment_group_id AS establishment_group_id_13,
  t14.id AS id_15,
  t14.code AS code_16,
  t14.last_name AS last_name_17,
  t14.first_name AS first_name_18,
  t14.gender AS gender_19,
  t14.phone_number AS phone_number_20,
  t14.mobile_number AS mobile_number_21,
  t14.email AS email_22,
  t14.address AS address_23,
  t14.location AS location_24,
  t14.birth_day AS birth_day_25,
  t14.created_at AS created_at_26,
  t14.updated_at AS updated_at_27,
  t14.created_by AS created_by_28,
  t14.updated_by AS updated_by_29,
  t14.image AS image_30,
  t14.hiring_date AS hiring_date_31,
  t14.date_of_departure AS date_of_departure_32,
  t14.nationality AS nationality_33,
  t14.identification_id AS identification_id_34,
  t14.passport_id AS passport_id_35,
  t14.bank_code AS bank_code_36,
  t14.bank_name AS bank_name_37,
  t14.bank_account_number AS bank_account_number_38,
  t14.finet_account_number AS finet_account_number_39,
  t14.counter_code AS counter_code_40,
  t14.hourly_rate AS hourly_rate_41,
  t14.default_number_hour_performed AS default_number_hour_performed_42,
  t14.number_of_children AS number_of_children_43,
  t14.family_situation AS family_situation_44,
  t14.base_salary AS base_salary_45,
  t14.social_number AS social_number_46,
  t14.is_permanent AS is_permanent_47,
  t14.is_declared AS is_declared_48,
  t14.establishment_id AS establishment_id_49,
  t14.user_id AS user_id_50,
  t14.rh_job_id AS rh_job_id_51,
  t14.rh_department_id AS rh_department_id_52,
  t14.statut_id AS statut_id_53,
  t0.school_year_id AS school_year_id_54
FROM
  user t0
  LEFT JOIN rh_salary t14 ON t14.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_enabled AS is_enabled_5, t0.is_password_changed AS is_password_changed_6, t0.last_login_at AS last_login_at_7, t0.last_auth_time AS last_auth_time_8, t0.token_live_time AS token_live_time_9, t0.token AS token_10, t0.is_can_aproved_expense AS is_can_aproved_expense_11, t0.establishment_id AS establishment_id_12, t0.establishment_group_id AS establishment_group_id_13, t14.id AS id_15, t14.code AS code_16, t14.last_name AS last_name_17, t14.first_name AS first_name_18, t14.gender AS gender_19, t14.phone_number AS phone_number_20, t14.mobile_number AS mobile_number_21, t14.email AS email_22, t14.address AS address_23, t14.location AS location_24, t14.birth_day AS birth_day_25, t14.created_at AS created_at_26, t14.updated_at AS updated_at_27, t14.created_by AS created_by_28, t14.updated_by AS updated_by_29, t14.image AS image_30, t14.hiring_date AS hiring_date_31, t14.date_of_departure AS date_of_departure_32, t14.nationality AS nationality_33, t14.identification_id AS identification_id_34, t14.passport_id AS passport_id_35, t14.bank_code AS bank_code_36, t14.bank_name AS bank_name_37, t14.bank_account_number AS bank_account_number_38, t14.finet_account_number AS finet_account_number_39, t14.counter_code AS counter_code_40, t14.hourly_rate AS hourly_rate_41, t14.default_number_hour_performed AS default_number_hour_performed_42, t14.number_of_children AS number_of_children_43, t14.family_situation AS family_situation_44, t14.base_salary AS base_salary_45, t14.social_number AS social_number_46, t14.is_permanent AS is_permanent_47, t14.is_declared AS is_declared_48, t14.establishment_id AS establishment_id_49, t14.user_id AS user_id_50, t14.rh_job_id AS rh_job_id_51, t14.rh_department_id AS rh_department_id_52, t14.statut_id AS statut_id_53, t0.school_year_id AS school_year_id_54 FROM user t0 LEFT JOIN rh_salary t14 ON t14.user_id = t0.id WHERE t0.id = 830;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.note_on AS note_on_4,
  t0.coefficient AS coefficient_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.is_validated AS is_validated_10,
  t0.establishment_id AS establishment_id_11,
  t0.school_year_id AS school_year_id_12,
  t0.school_year_periode_id AS school_year_periode_id_13,
  t0.classroom_id AS classroom_id_14,
  t0.matter_id AS matter_id_15,
  t0.sub_matter_id AS sub_matter_id_16,
  t0.school_teacher_id AS school_teacher_id_17,
  t0.school_teacher_matter_classroom_id AS school_teacher_matter_classroom_id_18
FROM
  school_average t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.note_on AS note_on_4, t0.coefficient AS coefficient_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.is_validated AS is_validated_10, t0.establishment_id AS establishment_id_11, t0.school_year_id AS school_year_id_12, t0.school_year_periode_id AS school_year_periode_id_13, t0.classroom_id AS classroom_id_14, t0.matter_id AS matter_id_15, t0.sub_matter_id AS sub_matter_id_16, t0.school_teacher_id AS school_teacher_id_17, t0.school_teacher_matter_classroom_id AS school_teacher_matter_classroom_id_18 FROM school_average t0 WHERE t0.id = '26302';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.note AS note_3,
  t0.note_on AS note_on_4,
  t0.coefficient AS coefficient_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.is_unclassified AS is_unclassified_10,
  t0.as_submatter AS as_submatter_11,
  t0.is_matter_conduct AS is_matter_conduct_12,
  t0.establishment_id AS establishment_id_13,
  t0.school_year_id AS school_year_id_14,
  t0.school_year_periode_id AS school_year_periode_id_15,
  t0.registration_student_registration_id AS registration_student_registration_id_16,
  t0.matter_id AS matter_id_17,
  t0.sub_matter_id AS sub_matter_id_18,
  t0.school_average_id AS school_average_id_19
FROM
  school_student_average t0
WHERE
  t0.school_average_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.note AS note_3, t0.note_on AS note_on_4, t0.coefficient AS coefficient_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.is_unclassified AS is_unclassified_10, t0.as_submatter AS as_submatter_11, t0.is_matter_conduct AS is_matter_conduct_12, t0.establishment_id AS establishment_id_13, t0.school_year_id AS school_year_id_14, t0.school_year_periode_id AS school_year_periode_id_15, t0.registration_student_registration_id AS registration_student_registration_id_16, t0.matter_id AS matter_id_17, t0.sub_matter_id AS sub_matter_id_18, t0.school_average_id AS school_average_id_19 FROM school_student_average t0 WHERE t0.school_average_id = 26302;

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.note AS note_2,
  s0_.note_on AS note_on_3,
  s0_.coefficient AS coefficient_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.created_by AS created_by_7,
  s0_.updated_by AS updated_by_8,
  s0_.is_unclassified AS is_unclassified_9,
  s0_.as_submatter AS as_submatter_10,
  s0_.is_matter_conduct AS is_matter_conduct_11,
  r1_.id AS id_12,
  r1_.is_redoubling AS is_redoubling_13,
  r1_.is_diet AS is_diet_14,
  r1_.is_internal AS is_internal_15,
  r1_.is_affected AS is_affected_16,
  r1_.registered_at AS registered_at_17,
  r1_.created_at AS created_at_18,
  r1_.updated_at AS updated_at_19,
  r1_.created_by AS created_by_20,
  r1_.updated_by AS updated_by_21,
  r1_.last_amount_paid AS last_amount_paid_22,
  r1_.last_payment_id AS last_payment_id_23,
  r1_.last_payment_at AS last_payment_at_24,
  r1_.image AS image_25,
  r1_.is_abandonned AS is_abandonned_26,
  r1_.as_food_restrictions AS as_food_restrictions_27,
  r1_.is_meatless_menu AS is_meatless_menu_28,
  r1_.is_menu_without_pork AS is_menu_without_pork_29,
  r1_.is_can_eat_alone AS is_can_eat_alone_30,
  r1_.is_can_do_his_business_alone AS is_can_do_his_business_alone_31,
  r1_.is_falls_sleep_easily AS is_falls_sleep_easily_32,
  r1_.is_new AS is_new_33,
  r1_.portal_login AS portal_login_34,
  r1_.portal_password AS portal_password_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_.establishment_id AS establishment_id_105,
  s0_.school_year_id AS school_year_id_106,
  s0_.school_year_periode_id AS school_year_periode_id_107,
  s0_.registration_student_registration_id AS registration_student_registration_id_108,
  s0_.matter_id AS matter_id_109,
  s0_.sub_matter_id AS sub_matter_id_110,
  s0_.school_average_id AS school_average_id_111,
  r1_.establishment_id AS establishment_id_112,
  r1_.student_id AS student_id_113,
  r1_.school_year_id AS school_year_id_114,
  r1_.classroom_id AS classroom_id_115,
  r1_.registration_student_pre_registration_id AS registration_student_pre_registration_id_116,
  r2_.establishment_id AS establishment_id_117,
  r2_.entry_level_id AS entry_level_id_118,
  r2_.medical_history_id AS medical_history_id_119,
  r2_.learning_difficulty_id AS learning_difficulty_id_120
FROM
  school_student_average 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_average_id = ?

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.note AS note_2, s0_.note_on AS note_on_3, s0_.coefficient AS coefficient_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.created_by AS created_by_7, s0_.updated_by AS updated_by_8, s0_.is_unclassified AS is_unclassified_9, s0_.as_submatter AS as_submatter_10, s0_.is_matter_conduct AS is_matter_conduct_11, r1_.id AS id_12, r1_.is_redoubling AS is_redoubling_13, r1_.is_diet AS is_diet_14, r1_.is_internal AS is_internal_15, r1_.is_affected AS is_affected_16, r1_.registered_at AS registered_at_17, r1_.created_at AS created_at_18, r1_.updated_at AS updated_at_19, r1_.created_by AS created_by_20, r1_.updated_by AS updated_by_21, r1_.last_amount_paid AS last_amount_paid_22, r1_.last_payment_id AS last_payment_id_23, r1_.last_payment_at AS last_payment_at_24, r1_.image AS image_25, r1_.is_abandonned AS is_abandonned_26, r1_.as_food_restrictions AS as_food_restrictions_27, r1_.is_meatless_menu AS is_meatless_menu_28, r1_.is_menu_without_pork AS is_menu_without_pork_29, r1_.is_can_eat_alone AS is_can_eat_alone_30, r1_.is_can_do_his_business_alone AS is_can_do_his_business_alone_31, r1_.is_falls_sleep_easily AS is_falls_sleep_easily_32, r1_.is_new AS is_new_33, r1_.portal_login AS portal_login_34, r1_.portal_password AS portal_password_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_.establishment_id AS establishment_id_105, s0_.school_year_id AS school_year_id_106, s0_.school_year_periode_id AS school_year_periode_id_107, s0_.registration_student_registration_id AS registration_student_registration_id_108, s0_.matter_id AS matter_id_109, s0_.sub_matter_id AS sub_matter_id_110, s0_.school_average_id AS school_average_id_111, r1_.establishment_id AS establishment_id_112, r1_.student_id AS student_id_113, r1_.school_year_id AS school_year_id_114, r1_.classroom_id AS classroom_id_115, r1_.registration_student_pre_registration_id AS registration_student_pre_registration_id_116, r2_.establishment_id AS establishment_id_117, r2_.entry_level_id AS entry_level_id_118, r2_.medical_history_id AS medical_history_id_119, r2_.learning_difficulty_id AS learning_difficulty_id_120 FROM school_student_average 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_average_id = 26302;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.capacity AS capacity_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.is_excellent AS is_excellent_8,
  t0.establishment_id AS establishment_id_9,
  t0.level_id AS level_id_10,
  t0.faculty_id AS faculty_id_11,
  t0.round_id AS round_id_12,
  t0.school_year_id AS school_year_id_13
FROM
  setting_classroom t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.id = 1159;

SELECT
  r0_.id AS id_0,
  r0_.is_redoubling AS is_redoubling_1,
  r0_.is_diet AS is_diet_2,
  r0_.is_internal AS is_internal_3,
  r0_.is_affected AS is_affected_4,
  r0_.registered_at AS registered_at_5,
  r0_.created_at AS created_at_6,
  r0_.updated_at AS updated_at_7,
  r0_.created_by AS created_by_8,
  r0_.updated_by AS updated_by_9,
  r0_.last_amount_paid AS last_amount_paid_10,
  r0_.last_payment_id AS last_payment_id_11,
  r0_.last_payment_at AS last_payment_at_12,
  r0_.image AS image_13,
  r0_.is_abandonned AS is_abandonned_14,
  r0_.as_food_restrictions AS as_food_restrictions_15,
  r0_.is_meatless_menu AS is_meatless_menu_16,
  r0_.is_menu_without_pork AS is_menu_without_pork_17,
  r0_.is_can_eat_alone AS is_can_eat_alone_18,
  r0_.is_can_do_his_business_alone AS is_can_do_his_business_alone_19,
  r0_.is_falls_sleep_easily AS is_falls_sleep_easily_20,
  r0_.is_new AS is_new_21,
  r0_.portal_login AS portal_login_22,
  r0_.portal_password AS portal_password_23,
  r1_.id AS id_24,
  r1_.code AS code_25,
  r1_.last_name AS last_name_26,
  r1_.first_name AS first_name_27,
  r1_.notification_phone_number AS notification_phone_number_28,
  r1_.notification_name AS notification_name_29,
  r1_.notification_watsapp_number AS notification_watsapp_number_30,
  r1_.observation AS observation_31,
  r1_.location AS location_32,
  r1_.gender AS gender_33,
  r1_.birthday AS birthday_34,
  r1_.birth_location AS birth_location_35,
  r1_.birth_certificate_number AS birth_certificate_number_36,
  r1_.created_at AS created_at_37,
  r1_.updated_at AS updated_at_38,
  r1_.created_by AS created_by_39,
  r1_.updated_by AS updated_by_40,
  r1_.image AS image_41,
  r1_.create_date AS create_date_42,
  r1_.is_affected AS is_affected_43,
  r1_.is_redoubling AS is_redoubling_44,
  r1_.last_school_attended AS last_school_attended_45,
  r1_.last_school_attended_type AS last_school_attended_type_46,
  r1_.registration_number AS registration_number_47,
  r1_.lv1 AS lv1_48,
  r1_.lv2 AS lv2_49,
  r1_.art_or_musique AS art_or_musique_50,
  r1_.nationality AS nationality_51,
  r1_.where_resides AS where_resides_52,
  r1_.parent_status AS parent_status_53,
  r1_.is_parntal_authority_father AS is_parntal_authority_father_54,
  r1_.is_father_call_to_emergency AS is_father_call_to_emergency_55,
  r1_.father_last_name AS father_last_name_56,
  r1_.father_first_name AS father_first_name_57,
  r1_.father_address AS father_address_58,
  r1_.father_phone_number AS father_phone_number_59,
  r1_.father_post AS father_post_60,
  r1_.father_location AS father_location_61,
  r1_.father_email AS father_email_62,
  r1_.is_parntal_authority_mother AS is_parntal_authority_mother_63,
  r1_.is_mother_call_to_emergency AS is_mother_call_to_emergency_64,
  r1_.mother_last_name AS mother_last_name_65,
  r1_.mother_first_name AS mother_first_name_66,
  r1_.mother_address AS mother_address_67,
  r1_.mother_phone_number AS mother_phone_number_68,
  r1_.mother_post AS mother_post_69,
  r1_.mother_location AS mother_location_70,
  r1_.mother_email AS mother_email_71,
  r1_.responsible_of_schooling AS responsible_of_schooling_72,
  r1_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_73,
  r1_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_74,
  r1_.responsible_of_schooling_address AS responsible_of_schooling_address_75,
  r1_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_76,
  r1_.responsible_of_schooling_post AS responsible_of_schooling_post_77,
  r1_.responsible_of_schooling_location AS responsible_of_schooling_location_78,
  r1_.accompanying_person_name AS accompanying_person_name_79,
  r1_.accompanying_person_phone_number AS accompanying_person_phone_number_80,
  r1_.accompanying_person_name_2 AS accompanying_person_name_2_81,
  r1_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_82,
  r1_.accompanying_person_name_3 AS accompanying_person_name_3_83,
  r1_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_84,
  r1_.doctor_name AS doctor_name_85,
  r1_.doctor_phone_number AS doctor_phone_number_86,
  r1_.other_medical_history AS other_medical_history_87,
  r1_.other_learning_difficulty AS other_learning_difficulty_88,
  r1_.teacher_observation AS teacher_observation_89,
  r1_.parent_observation AS parent_observation_90,
  r1_.anterior_balance AS anterior_balance_91,
  r1_.is_archived AS is_archived_92,
  r0_.establishment_id AS establishment_id_93,
  r0_.student_id AS student_id_94,
  r0_.school_year_id AS school_year_id_95,
  r0_.classroom_id AS classroom_id_96,
  r0_.registration_student_pre_registration_id AS registration_student_pre_registration_id_97,
  r1_.establishment_id AS establishment_id_98,
  r1_.entry_level_id AS entry_level_id_99,
  r1_.medical_history_id AS medical_history_id_100,
  r1_.learning_difficulty_id AS learning_difficulty_id_101
FROM
  registration_student_registration r0_
  INNER JOIN registration_student r1_ ON r0_.student_id = r1_.id
WHERE
  r0_.establishment_id = ?
  AND r0_.school_year_id = ?
  AND r0_.classroom_id = ?
ORDER BY
  r1_.last_name ASC

SELECT r0_.id AS id_0, r0_.is_redoubling AS is_redoubling_1, r0_.is_diet AS is_diet_2, r0_.is_internal AS is_internal_3, r0_.is_affected AS is_affected_4, r0_.registered_at AS registered_at_5, r0_.created_at AS created_at_6, r0_.updated_at AS updated_at_7, r0_.created_by AS created_by_8, r0_.updated_by AS updated_by_9, r0_.last_amount_paid AS last_amount_paid_10, r0_.last_payment_id AS last_payment_id_11, r0_.last_payment_at AS last_payment_at_12, r0_.image AS image_13, r0_.is_abandonned AS is_abandonned_14, r0_.as_food_restrictions AS as_food_restrictions_15, r0_.is_meatless_menu AS is_meatless_menu_16, r0_.is_menu_without_pork AS is_menu_without_pork_17, r0_.is_can_eat_alone AS is_can_eat_alone_18, r0_.is_can_do_his_business_alone AS is_can_do_his_business_alone_19, r0_.is_falls_sleep_easily AS is_falls_sleep_easily_20, r0_.is_new AS is_new_21, r0_.portal_login AS portal_login_22, r0_.portal_password AS portal_password_23, r1_.id AS id_24, r1_.code AS code_25, r1_.last_name AS last_name_26, r1_.first_name AS first_name_27, r1_.notification_phone_number AS notification_phone_number_28, r1_.notification_name AS notification_name_29, r1_.notification_watsapp_number AS notification_watsapp_number_30, r1_.observation AS observation_31, r1_.location AS location_32, r1_.gender AS gender_33, r1_.birthday AS birthday_34, r1_.birth_location AS birth_location_35, r1_.birth_certificate_number AS birth_certificate_number_36, r1_.created_at AS created_at_37, r1_.updated_at AS updated_at_38, r1_.created_by AS created_by_39, r1_.updated_by AS updated_by_40, r1_.image AS image_41, r1_.create_date AS create_date_42, r1_.is_affected AS is_affected_43, r1_.is_redoubling AS is_redoubling_44, r1_.last_school_attended AS last_school_attended_45, r1_.last_school_attended_type AS last_school_attended_type_46, r1_.registration_number AS registration_number_47, r1_.lv1 AS lv1_48, r1_.lv2 AS lv2_49, r1_.art_or_musique AS art_or_musique_50, r1_.nationality AS nationality_51, r1_.where_resides AS where_resides_52, r1_.parent_status AS parent_status_53, r1_.is_parntal_authority_father AS is_parntal_authority_father_54, r1_.is_father_call_to_emergency AS is_father_call_to_emergency_55, r1_.father_last_name AS father_last_name_56, r1_.father_first_name AS father_first_name_57, r1_.father_address AS father_address_58, r1_.father_phone_number AS father_phone_number_59, r1_.father_post AS father_post_60, r1_.father_location AS father_location_61, r1_.father_email AS father_email_62, r1_.is_parntal_authority_mother AS is_parntal_authority_mother_63, r1_.is_mother_call_to_emergency AS is_mother_call_to_emergency_64, r1_.mother_last_name AS mother_last_name_65, r1_.mother_first_name AS mother_first_name_66, r1_.mother_address AS mother_address_67, r1_.mother_phone_number AS mother_phone_number_68, r1_.mother_post AS mother_post_69, r1_.mother_location AS mother_location_70, r1_.mother_email AS mother_email_71, r1_.responsible_of_schooling AS responsible_of_schooling_72, r1_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_73, r1_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_74, r1_.responsible_of_schooling_address AS responsible_of_schooling_address_75, r1_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_76, r1_.responsible_of_schooling_post AS responsible_of_schooling_post_77, r1_.responsible_of_schooling_location AS responsible_of_schooling_location_78, r1_.accompanying_person_name AS accompanying_person_name_79, r1_.accompanying_person_phone_number AS accompanying_person_phone_number_80, r1_.accompanying_person_name_2 AS accompanying_person_name_2_81, r1_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_82, r1_.accompanying_person_name_3 AS accompanying_person_name_3_83, r1_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_84, r1_.doctor_name AS doctor_name_85, r1_.doctor_phone_number AS doctor_phone_number_86, r1_.other_medical_history AS other_medical_history_87, r1_.other_learning_difficulty AS other_learning_difficulty_88, r1_.teacher_observation AS teacher_observation_89, r1_.parent_observation AS parent_observation_90, r1_.anterior_balance AS anterior_balance_91, r1_.is_archived AS is_archived_92, r0_.establishment_id AS establishment_id_93, r0_.student_id AS student_id_94, r0_.school_year_id AS school_year_id_95, r0_.classroom_id AS classroom_id_96, r0_.registration_student_pre_registration_id AS registration_student_pre_registration_id_97, r1_.establishment_id AS establishment_id_98, r1_.entry_level_id AS entry_level_id_99, r1_.medical_history_id AS medical_history_id_100, r1_.learning_difficulty_id AS learning_difficulty_id_101 FROM registration_student_registration r0_ INNER JOIN registration_student r1_ ON r0_.student_id = r1_.id WHERE r0_.establishment_id = 18 AND r0_.school_year_id = 3 AND r0_.classroom_id = 1159 ORDER BY r1_.last_name ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.note AS note_3,
  t0.note_on AS note_on_4,
  t0.coefficient AS coefficient_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.is_unclassified AS is_unclassified_10,
  t0.as_submatter AS as_submatter_11,
  t0.is_matter_conduct AS is_matter_conduct_12,
  t0.establishment_id AS establishment_id_13,
  t0.school_year_id AS school_year_id_14,
  t0.school_year_periode_id AS school_year_periode_id_15,
  t0.registration_student_registration_id AS registration_student_registration_id_16,
  t0.matter_id AS matter_id_17,
  t0.sub_matter_id AS sub_matter_id_18,
  t0.school_average_id AS school_average_id_19
FROM
  school_student_average t0
WHERE
  t0.registration_student_registration_id = ?
  AND t0.school_average_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.note AS note_3, t0.note_on AS note_on_4, t0.coefficient AS coefficient_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.is_unclassified AS is_unclassified_10, t0.as_submatter AS as_submatter_11, t0.is_matter_conduct AS is_matter_conduct_12, t0.establishment_id AS establishment_id_13, t0.school_year_id AS school_year_id_14, t0.school_year_periode_id AS school_year_periode_id_15, t0.registration_student_registration_id AS registration_student_registration_id_16, t0.matter_id AS matter_id_17, t0.sub_matter_id AS sub_matter_id_18, t0.school_average_id AS school_average_id_19 FROM school_student_average t0 WHERE t0.registration_student_registration_id = 25315 AND t0.school_average_id = 26302 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.note AS note_3,
  t0.note_on AS note_on_4,
  t0.coefficient AS coefficient_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.is_unclassified AS is_unclassified_10,
  t0.as_submatter AS as_submatter_11,
  t0.is_matter_conduct AS is_matter_conduct_12,
  t0.establishment_id AS establishment_id_13,
  t0.school_year_id AS school_year_id_14,
  t0.school_year_periode_id AS school_year_periode_id_15,
  t0.registration_student_registration_id AS registration_student_registration_id_16,
  t0.matter_id AS matter_id_17,
  t0.sub_matter_id AS sub_matter_id_18,
  t0.school_average_id AS school_average_id_19
FROM
  school_student_average t0
WHERE
  t0.registration_student_registration_id = ?
  AND t0.school_average_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.note AS note_3, t0.note_on AS note_on_4, t0.coefficient AS coefficient_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.is_unclassified AS is_unclassified_10, t0.as_submatter AS as_submatter_11, t0.is_matter_conduct AS is_matter_conduct_12, t0.establishment_id AS establishment_id_13, t0.school_year_id AS school_year_id_14, t0.school_year_periode_id AS school_year_periode_id_15, t0.registration_student_registration_id AS registration_student_registration_id_16, t0.matter_id AS matter_id_17, t0.sub_matter_id AS sub_matter_id_18, t0.school_average_id AS school_average_id_19 FROM school_student_average t0 WHERE t0.registration_student_registration_id = 24087 AND t0.school_average_id = 26302 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.note AS note_3,
  t0.note_on AS note_on_4,
  t0.coefficient AS coefficient_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.is_unclassified AS is_unclassified_10,
  t0.as_submatter AS as_submatter_11,
  t0.is_matter_conduct AS is_matter_conduct_12,
  t0.establishment_id AS establishment_id_13,
  t0.school_year_id AS school_year_id_14,
  t0.school_year_periode_id AS school_year_periode_id_15,
  t0.registration_student_registration_id AS registration_student_registration_id_16,
  t0.matter_id AS matter_id_17,
  t0.sub_matter_id AS sub_matter_id_18,
  t0.school_average_id AS school_average_id_19
FROM
  school_student_average t0
WHERE
  t0.registration_student_registration_id = ?
  AND t0.school_average_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.note AS note_3, t0.note_on AS note_on_4, t0.coefficient AS coefficient_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.is_unclassified AS is_unclassified_10, t0.as_submatter AS as_submatter_11, t0.is_matter_conduct AS is_matter_conduct_12, t0.establishment_id AS establishment_id_13, t0.school_year_id AS school_year_id_14, t0.school_year_periode_id AS school_year_periode_id_15, t0.registration_student_registration_id AS registration_student_registration_id_16, t0.matter_id AS matter_id_17, t0.sub_matter_id AS sub_matter_id_18, t0.school_average_id AS school_average_id_19 FROM school_student_average t0 WHERE t0.registration_student_registration_id = 25359 AND t0.school_average_id = 26302 LIMIT 1;