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.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 = 2;

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.order_num AS order_num_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.is_validated AS is_validated_11,
  t0.report_card_average AS report_card_average_12,
  t0.level_average AS level_average_13,
  t0.smallest_average AS smallest_average_14,
  t0.strongest_average AS strongest_average_15,
  t0.establishment_id AS establishment_id_16,
  t0.school_year_id AS school_year_id_17,
  t0.school_year_periode_id AS school_year_periode_id_18,
  t0.level_id AS level_id_19
FROM
  report_card 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.order_num AS order_num_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.is_validated AS is_validated_11, t0.report_card_average AS report_card_average_12, t0.level_average AS level_average_13, t0.smallest_average AS smallest_average_14, t0.strongest_average AS strongest_average_15, t0.establishment_id AS establishment_id_16, t0.school_year_id AS school_year_id_17, t0.school_year_periode_id AS school_year_periode_id_18, t0.level_id AS level_id_19 FROM report_card t0 WHERE t0.id = '5641';

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,
  r0_.is_authorized_alone AS is_authorized_alone_24,
  r0_.status AS status_25,
  s1_.id AS id_26,
  s1_.label AS label_27,
  s1_.capacity AS capacity_28,
  s1_.created_at AS created_at_29,
  s1_.updated_at AS updated_at_30,
  s1_.created_by AS created_by_31,
  s1_.updated_by AS updated_by_32,
  s1_.is_excellent AS is_excellent_33,
  r2_.id AS id_34,
  r2_.code AS code_35,
  r2_.last_name AS last_name_36,
  r2_.first_name AS first_name_37,
  r2_.notification_phone_number AS notification_phone_number_38,
  r2_.notification_name AS notification_name_39,
  r2_.notification_watsapp_number AS notification_watsapp_number_40,
  r2_.observation AS observation_41,
  r2_.location AS location_42,
  r2_.gender AS gender_43,
  r2_.birthday AS birthday_44,
  r2_.birth_location AS birth_location_45,
  r2_.birth_certificate_number AS birth_certificate_number_46,
  r2_.created_at AS created_at_47,
  r2_.updated_at AS updated_at_48,
  r2_.created_by AS created_by_49,
  r2_.updated_by AS updated_by_50,
  r2_.image AS image_51,
  r2_.create_date AS create_date_52,
  r2_.is_affected AS is_affected_53,
  r2_.is_redoubling AS is_redoubling_54,
  r2_.last_school_attended AS last_school_attended_55,
  r2_.last_school_attended_type AS last_school_attended_type_56,
  r2_.registration_number AS registration_number_57,
  r2_.lv1 AS lv1_58,
  r2_.lv2 AS lv2_59,
  r2_.art_or_musique AS art_or_musique_60,
  r2_.nationality AS nationality_61,
  r2_.where_resides AS where_resides_62,
  r2_.parent_status AS parent_status_63,
  r2_.is_parntal_authority_father AS is_parntal_authority_father_64,
  r2_.is_father_call_to_emergency AS is_father_call_to_emergency_65,
  r2_.father_last_name AS father_last_name_66,
  r2_.father_first_name AS father_first_name_67,
  r2_.father_address AS father_address_68,
  r2_.father_phone_number AS father_phone_number_69,
  r2_.father_post AS father_post_70,
  r2_.father_location AS father_location_71,
  r2_.father_email AS father_email_72,
  r2_.is_parntal_authority_mother AS is_parntal_authority_mother_73,
  r2_.is_mother_call_to_emergency AS is_mother_call_to_emergency_74,
  r2_.mother_last_name AS mother_last_name_75,
  r2_.mother_first_name AS mother_first_name_76,
  r2_.mother_address AS mother_address_77,
  r2_.mother_phone_number AS mother_phone_number_78,
  r2_.mother_post AS mother_post_79,
  r2_.mother_location AS mother_location_80,
  r2_.mother_email AS mother_email_81,
  r2_.responsible_of_schooling AS responsible_of_schooling_82,
  r2_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_83,
  r2_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_84,
  r2_.responsible_of_schooling_address AS responsible_of_schooling_address_85,
  r2_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_86,
  r2_.responsible_of_schooling_post AS responsible_of_schooling_post_87,
  r2_.responsible_of_schooling_location AS responsible_of_schooling_location_88,
  r2_.accompanying_person_name AS accompanying_person_name_89,
  r2_.accompanying_person_phone_number AS accompanying_person_phone_number_90,
  r2_.accompanying_person_name_2 AS accompanying_person_name_2_91,
  r2_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_92,
  r2_.accompanying_person_name_3 AS accompanying_person_name_3_93,
  r2_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_94,
  r2_.doctor_name AS doctor_name_95,
  r2_.doctor_phone_number AS doctor_phone_number_96,
  r2_.other_medical_history AS other_medical_history_97,
  r2_.other_learning_difficulty AS other_learning_difficulty_98,
  r2_.teacher_observation AS teacher_observation_99,
  r2_.parent_observation AS parent_observation_100,
  r2_.anterior_balance AS anterior_balance_101,
  r2_.is_archived AS is_archived_102,
  r0_.establishment_id AS establishment_id_103,
  r0_.student_id AS student_id_104,
  r0_.school_year_id AS school_year_id_105,
  r0_.classroom_id AS classroom_id_106,
  r0_.registration_student_pre_registration_id AS registration_student_pre_registration_id_107,
  s1_.establishment_id AS establishment_id_108,
  s1_.level_id AS level_id_109,
  s1_.faculty_id AS faculty_id_110,
  s1_.round_id AS round_id_111,
  s1_.school_year_id AS school_year_id_112,
  r2_.establishment_id AS establishment_id_113,
  r2_.entry_level_id AS entry_level_id_114,
  r2_.medical_history_id AS medical_history_id_115,
  r2_.learning_difficulty_id AS learning_difficulty_id_116
FROM
  registration_student_registration r0_
  INNER JOIN setting_classroom s1_ ON r0_.classroom_id = s1_.id
  INNER JOIN registration_student r2_ ON r0_.student_id = r2_.id
WHERE
  s1_.level_id = ?
  AND r0_.establishment_id = ?
  AND r0_.status <> ?
ORDER BY
  r2_.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, r0_.is_authorized_alone AS is_authorized_alone_24, r0_.status AS status_25, s1_.id AS id_26, s1_.label AS label_27, s1_.capacity AS capacity_28, s1_.created_at AS created_at_29, s1_.updated_at AS updated_at_30, s1_.created_by AS created_by_31, s1_.updated_by AS updated_by_32, s1_.is_excellent AS is_excellent_33, r2_.id AS id_34, r2_.code AS code_35, r2_.last_name AS last_name_36, r2_.first_name AS first_name_37, r2_.notification_phone_number AS notification_phone_number_38, r2_.notification_name AS notification_name_39, r2_.notification_watsapp_number AS notification_watsapp_number_40, r2_.observation AS observation_41, r2_.location AS location_42, r2_.gender AS gender_43, r2_.birthday AS birthday_44, r2_.birth_location AS birth_location_45, r2_.birth_certificate_number AS birth_certificate_number_46, r2_.created_at AS created_at_47, r2_.updated_at AS updated_at_48, r2_.created_by AS created_by_49, r2_.updated_by AS updated_by_50, r2_.image AS image_51, r2_.create_date AS create_date_52, r2_.is_affected AS is_affected_53, r2_.is_redoubling AS is_redoubling_54, r2_.last_school_attended AS last_school_attended_55, r2_.last_school_attended_type AS last_school_attended_type_56, r2_.registration_number AS registration_number_57, r2_.lv1 AS lv1_58, r2_.lv2 AS lv2_59, r2_.art_or_musique AS art_or_musique_60, r2_.nationality AS nationality_61, r2_.where_resides AS where_resides_62, r2_.parent_status AS parent_status_63, r2_.is_parntal_authority_father AS is_parntal_authority_father_64, r2_.is_father_call_to_emergency AS is_father_call_to_emergency_65, r2_.father_last_name AS father_last_name_66, r2_.father_first_name AS father_first_name_67, r2_.father_address AS father_address_68, r2_.father_phone_number AS father_phone_number_69, r2_.father_post AS father_post_70, r2_.father_location AS father_location_71, r2_.father_email AS father_email_72, r2_.is_parntal_authority_mother AS is_parntal_authority_mother_73, r2_.is_mother_call_to_emergency AS is_mother_call_to_emergency_74, r2_.mother_last_name AS mother_last_name_75, r2_.mother_first_name AS mother_first_name_76, r2_.mother_address AS mother_address_77, r2_.mother_phone_number AS mother_phone_number_78, r2_.mother_post AS mother_post_79, r2_.mother_location AS mother_location_80, r2_.mother_email AS mother_email_81, r2_.responsible_of_schooling AS responsible_of_schooling_82, r2_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_83, r2_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_84, r2_.responsible_of_schooling_address AS responsible_of_schooling_address_85, r2_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_86, r2_.responsible_of_schooling_post AS responsible_of_schooling_post_87, r2_.responsible_of_schooling_location AS responsible_of_schooling_location_88, r2_.accompanying_person_name AS accompanying_person_name_89, r2_.accompanying_person_phone_number AS accompanying_person_phone_number_90, r2_.accompanying_person_name_2 AS accompanying_person_name_2_91, r2_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_92, r2_.accompanying_person_name_3 AS accompanying_person_name_3_93, r2_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_94, r2_.doctor_name AS doctor_name_95, r2_.doctor_phone_number AS doctor_phone_number_96, r2_.other_medical_history AS other_medical_history_97, r2_.other_learning_difficulty AS other_learning_difficulty_98, r2_.teacher_observation AS teacher_observation_99, r2_.parent_observation AS parent_observation_100, r2_.anterior_balance AS anterior_balance_101, r2_.is_archived AS is_archived_102, r0_.establishment_id AS establishment_id_103, r0_.student_id AS student_id_104, r0_.school_year_id AS school_year_id_105, r0_.classroom_id AS classroom_id_106, r0_.registration_student_pre_registration_id AS registration_student_pre_registration_id_107, s1_.establishment_id AS establishment_id_108, s1_.level_id AS level_id_109, s1_.faculty_id AS faculty_id_110, s1_.round_id AS round_id_111, s1_.school_year_id AS school_year_id_112, r2_.establishment_id AS establishment_id_113, r2_.entry_level_id AS entry_level_id_114, r2_.medical_history_id AS medical_history_id_115, r2_.learning_difficulty_id AS learning_difficulty_id_116 FROM registration_student_registration r0_ INNER JOIN setting_classroom s1_ ON r0_.classroom_id = s1_.id INNER JOIN registration_student r2_ ON r0_.student_id = r2_.id WHERE s1_.level_id = 148 AND r0_.establishment_id = 18 AND r0_.status <> 'ABANDONNE' ORDER BY r2_.last_name ASC;

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.label AS label_2,
  s0_.note_on AS note_on_3,
  s0_.coefficient AS coefficient_4,
  s0_.order_num AS order_num_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,
  s0_.type AS type_10,
  s0_.is_validated AS is_validated_11,
  s0_.report_card_average AS report_card_average_12,
  s0_.class_average AS class_average_13,
  s0_.smallest_average AS smallest_average_14,
  s0_.sstrongest_average AS sstrongest_average_15,
  s0_.rank AS rank_16,
  s0_.level_rank AS level_rank_17,
  s0_.total_average AS total_average_18,
  s0_.total_coefficient AS total_coefficient_19,
  s0_.justified_absence AS justified_absence_20,
  s0_.unjustified_absence AS unjustified_absence_21,
  s0_.annual_average AS annual_average_22,
  s0_.annual_rank AS annual_rank_23,
  s0_.class_annual_average AS class_annual_average_24,
  s0_.is_unclassified AS is_unclassified_25,
  r1_.id AS id_26,
  r1_.is_redoubling AS is_redoubling_27,
  r1_.is_diet AS is_diet_28,
  r1_.is_internal AS is_internal_29,
  r1_.is_affected AS is_affected_30,
  r1_.registered_at AS registered_at_31,
  r1_.created_at AS created_at_32,
  r1_.updated_at AS updated_at_33,
  r1_.created_by AS created_by_34,
  r1_.updated_by AS updated_by_35,
  r1_.last_amount_paid AS last_amount_paid_36,
  r1_.last_payment_id AS last_payment_id_37,
  r1_.last_payment_at AS last_payment_at_38,
  r1_.image AS image_39,
  r1_.is_abandonned AS is_abandonned_40,
  r1_.as_food_restrictions AS as_food_restrictions_41,
  r1_.is_meatless_menu AS is_meatless_menu_42,
  r1_.is_menu_without_pork AS is_menu_without_pork_43,
  r1_.is_can_eat_alone AS is_can_eat_alone_44,
  r1_.is_can_do_his_business_alone AS is_can_do_his_business_alone_45,
  r1_.is_falls_sleep_easily AS is_falls_sleep_easily_46,
  r1_.is_new AS is_new_47,
  r1_.portal_login AS portal_login_48,
  r1_.portal_password AS portal_password_49,
  r1_.is_authorized_alone AS is_authorized_alone_50,
  r1_.status AS status_51,
  r2_.id AS id_52,
  r2_.code AS code_53,
  r2_.last_name AS last_name_54,
  r2_.first_name AS first_name_55,
  r2_.notification_phone_number AS notification_phone_number_56,
  r2_.notification_name AS notification_name_57,
  r2_.notification_watsapp_number AS notification_watsapp_number_58,
  r2_.observation AS observation_59,
  r2_.location AS location_60,
  r2_.gender AS gender_61,
  r2_.birthday AS birthday_62,
  r2_.birth_location AS birth_location_63,
  r2_.birth_certificate_number AS birth_certificate_number_64,
  r2_.created_at AS created_at_65,
  r2_.updated_at AS updated_at_66,
  r2_.created_by AS created_by_67,
  r2_.updated_by AS updated_by_68,
  r2_.image AS image_69,
  r2_.create_date AS create_date_70,
  r2_.is_affected AS is_affected_71,
  r2_.is_redoubling AS is_redoubling_72,
  r2_.last_school_attended AS last_school_attended_73,
  r2_.last_school_attended_type AS last_school_attended_type_74,
  r2_.registration_number AS registration_number_75,
  r2_.lv1 AS lv1_76,
  r2_.lv2 AS lv2_77,
  r2_.art_or_musique AS art_or_musique_78,
  r2_.nationality AS nationality_79,
  r2_.where_resides AS where_resides_80,
  r2_.parent_status AS parent_status_81,
  r2_.is_parntal_authority_father AS is_parntal_authority_father_82,
  r2_.is_father_call_to_emergency AS is_father_call_to_emergency_83,
  r2_.father_last_name AS father_last_name_84,
  r2_.father_first_name AS father_first_name_85,
  r2_.father_address AS father_address_86,
  r2_.father_phone_number AS father_phone_number_87,
  r2_.father_post AS father_post_88,
  r2_.father_location AS father_location_89,
  r2_.father_email AS father_email_90,
  r2_.is_parntal_authority_mother AS is_parntal_authority_mother_91,
  r2_.is_mother_call_to_emergency AS is_mother_call_to_emergency_92,
  r2_.mother_last_name AS mother_last_name_93,
  r2_.mother_first_name AS mother_first_name_94,
  r2_.mother_address AS mother_address_95,
  r2_.mother_phone_number AS mother_phone_number_96,
  r2_.mother_post AS mother_post_97,
  r2_.mother_location AS mother_location_98,
  r2_.mother_email AS mother_email_99,
  r2_.responsible_of_schooling AS responsible_of_schooling_100,
  r2_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_101,
  r2_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_102,
  r2_.responsible_of_schooling_address AS responsible_of_schooling_address_103,
  r2_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_104,
  r2_.responsible_of_schooling_post AS responsible_of_schooling_post_105,
  r2_.responsible_of_schooling_location AS responsible_of_schooling_location_106,
  r2_.accompanying_person_name AS accompanying_person_name_107,
  r2_.accompanying_person_phone_number AS accompanying_person_phone_number_108,
  r2_.accompanying_person_name_2 AS accompanying_person_name_2_109,
  r2_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_110,
  r2_.accompanying_person_name_3 AS accompanying_person_name_3_111,
  r2_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_112,
  r2_.doctor_name AS doctor_name_113,
  r2_.doctor_phone_number AS doctor_phone_number_114,
  r2_.other_medical_history AS other_medical_history_115,
  r2_.other_learning_difficulty AS other_learning_difficulty_116,
  r2_.teacher_observation AS teacher_observation_117,
  r2_.parent_observation AS parent_observation_118,
  r2_.anterior_balance AS anterior_balance_119,
  r2_.is_archived AS is_archived_120,
  s0_.establishment_id AS establishment_id_121,
  s0_.school_year_id AS school_year_id_122,
  s0_.school_year_periode_id AS school_year_periode_id_123,
  s0_.student_registration_id AS student_registration_id_124,
  s0_.classroom_id AS classroom_id_125,
  s0_.report_card_id AS report_card_id_126,
  s0_.school_report_card_absence_id AS school_report_card_absence_id_127,
  r1_.establishment_id AS establishment_id_128,
  r1_.student_id AS student_id_129,
  r1_.school_year_id AS school_year_id_130,
  r1_.classroom_id AS classroom_id_131,
  r1_.registration_student_pre_registration_id AS registration_student_pre_registration_id_132,
  r2_.establishment_id AS establishment_id_133,
  r2_.entry_level_id AS entry_level_id_134,
  r2_.medical_history_id AS medical_history_id_135,
  r2_.learning_difficulty_id AS learning_difficulty_id_136
FROM
  school_report_card s0_
  INNER JOIN registration_student_registration r1_ ON s0_.student_registration_id = r1_.id
  INNER JOIN registration_student r2_ ON r1_.student_id = r2_.id
WHERE
  s0_.report_card_id = ?
ORDER BY
  r2_.last_name ASC

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.label AS label_2, s0_.note_on AS note_on_3, s0_.coefficient AS coefficient_4, s0_.order_num AS order_num_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, s0_.type AS type_10, s0_.is_validated AS is_validated_11, s0_.report_card_average AS report_card_average_12, s0_.class_average AS class_average_13, s0_.smallest_average AS smallest_average_14, s0_.sstrongest_average AS sstrongest_average_15, s0_.rank AS rank_16, s0_.level_rank AS level_rank_17, s0_.total_average AS total_average_18, s0_.total_coefficient AS total_coefficient_19, s0_.justified_absence AS justified_absence_20, s0_.unjustified_absence AS unjustified_absence_21, s0_.annual_average AS annual_average_22, s0_.annual_rank AS annual_rank_23, s0_.class_annual_average AS class_annual_average_24, s0_.is_unclassified AS is_unclassified_25, r1_.id AS id_26, r1_.is_redoubling AS is_redoubling_27, r1_.is_diet AS is_diet_28, r1_.is_internal AS is_internal_29, r1_.is_affected AS is_affected_30, r1_.registered_at AS registered_at_31, r1_.created_at AS created_at_32, r1_.updated_at AS updated_at_33, r1_.created_by AS created_by_34, r1_.updated_by AS updated_by_35, r1_.last_amount_paid AS last_amount_paid_36, r1_.last_payment_id AS last_payment_id_37, r1_.last_payment_at AS last_payment_at_38, r1_.image AS image_39, r1_.is_abandonned AS is_abandonned_40, r1_.as_food_restrictions AS as_food_restrictions_41, r1_.is_meatless_menu AS is_meatless_menu_42, r1_.is_menu_without_pork AS is_menu_without_pork_43, r1_.is_can_eat_alone AS is_can_eat_alone_44, r1_.is_can_do_his_business_alone AS is_can_do_his_business_alone_45, r1_.is_falls_sleep_easily AS is_falls_sleep_easily_46, r1_.is_new AS is_new_47, r1_.portal_login AS portal_login_48, r1_.portal_password AS portal_password_49, r1_.is_authorized_alone AS is_authorized_alone_50, r1_.status AS status_51, r2_.id AS id_52, r2_.code AS code_53, r2_.last_name AS last_name_54, r2_.first_name AS first_name_55, r2_.notification_phone_number AS notification_phone_number_56, r2_.notification_name AS notification_name_57, r2_.notification_watsapp_number AS notification_watsapp_number_58, r2_.observation AS observation_59, r2_.location AS location_60, r2_.gender AS gender_61, r2_.birthday AS birthday_62, r2_.birth_location AS birth_location_63, r2_.birth_certificate_number AS birth_certificate_number_64, r2_.created_at AS created_at_65, r2_.updated_at AS updated_at_66, r2_.created_by AS created_by_67, r2_.updated_by AS updated_by_68, r2_.image AS image_69, r2_.create_date AS create_date_70, r2_.is_affected AS is_affected_71, r2_.is_redoubling AS is_redoubling_72, r2_.last_school_attended AS last_school_attended_73, r2_.last_school_attended_type AS last_school_attended_type_74, r2_.registration_number AS registration_number_75, r2_.lv1 AS lv1_76, r2_.lv2 AS lv2_77, r2_.art_or_musique AS art_or_musique_78, r2_.nationality AS nationality_79, r2_.where_resides AS where_resides_80, r2_.parent_status AS parent_status_81, r2_.is_parntal_authority_father AS is_parntal_authority_father_82, r2_.is_father_call_to_emergency AS is_father_call_to_emergency_83, r2_.father_last_name AS father_last_name_84, r2_.father_first_name AS father_first_name_85, r2_.father_address AS father_address_86, r2_.father_phone_number AS father_phone_number_87, r2_.father_post AS father_post_88, r2_.father_location AS father_location_89, r2_.father_email AS father_email_90, r2_.is_parntal_authority_mother AS is_parntal_authority_mother_91, r2_.is_mother_call_to_emergency AS is_mother_call_to_emergency_92, r2_.mother_last_name AS mother_last_name_93, r2_.mother_first_name AS mother_first_name_94, r2_.mother_address AS mother_address_95, r2_.mother_phone_number AS mother_phone_number_96, r2_.mother_post AS mother_post_97, r2_.mother_location AS mother_location_98, r2_.mother_email AS mother_email_99, r2_.responsible_of_schooling AS responsible_of_schooling_100, r2_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_101, r2_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_102, r2_.responsible_of_schooling_address AS responsible_of_schooling_address_103, r2_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_104, r2_.responsible_of_schooling_post AS responsible_of_schooling_post_105, r2_.responsible_of_schooling_location AS responsible_of_schooling_location_106, r2_.accompanying_person_name AS accompanying_person_name_107, r2_.accompanying_person_phone_number AS accompanying_person_phone_number_108, r2_.accompanying_person_name_2 AS accompanying_person_name_2_109, r2_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_110, r2_.accompanying_person_name_3 AS accompanying_person_name_3_111, r2_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_112, r2_.doctor_name AS doctor_name_113, r2_.doctor_phone_number AS doctor_phone_number_114, r2_.other_medical_history AS other_medical_history_115, r2_.other_learning_difficulty AS other_learning_difficulty_116, r2_.teacher_observation AS teacher_observation_117, r2_.parent_observation AS parent_observation_118, r2_.anterior_balance AS anterior_balance_119, r2_.is_archived AS is_archived_120, s0_.establishment_id AS establishment_id_121, s0_.school_year_id AS school_year_id_122, s0_.school_year_periode_id AS school_year_periode_id_123, s0_.student_registration_id AS student_registration_id_124, s0_.classroom_id AS classroom_id_125, s0_.report_card_id AS report_card_id_126, s0_.school_report_card_absence_id AS school_report_card_absence_id_127, r1_.establishment_id AS establishment_id_128, r1_.student_id AS student_id_129, r1_.school_year_id AS school_year_id_130, r1_.classroom_id AS classroom_id_131, r1_.registration_student_pre_registration_id AS registration_student_pre_registration_id_132, r2_.establishment_id AS establishment_id_133, r2_.entry_level_id AS entry_level_id_134, r2_.medical_history_id AS medical_history_id_135, r2_.learning_difficulty_id AS learning_difficulty_id_136 FROM school_report_card s0_ INNER JOIN registration_student_registration r1_ ON s0_.student_registration_id = r1_.id INNER JOIN registration_student r2_ ON r1_.student_id = r2_.id WHERE s0_.report_card_id = 5641 ORDER BY r2_.last_name ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.note_on AS note_on_3,
  t0.average AS average_4,
  t0.coefficient AS coefficient_5,
  t0.coefficient_x_average AS coefficient_x_average_6,
  t0.order_num AS order_num_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.rank AS rank_12,
  t0.class_average AS class_average_13,
  t0.smallest_average AS smallest_average_14,
  t0.sstrongest_average AS sstrongest_average_15,
  t0.as_submatter AS as_submatter_16,
  t0.annual_average AS annual_average_17,
  t0.annual_rank AS annual_rank_18,
  t0.rank_average AS rank_average_19,
  t0.is_matter_conduct AS is_matter_conduct_20,
  t0.establishment_id AS establishment_id_21,
  t0.school_year_id AS school_year_id_22,
  t0.school_year_periode_id AS school_year_periode_id_23,
  t0.student_registration_id AS student_registration_id_24,
  t0.classroom_id AS classroom_id_25,
  t0.report_card_id AS report_card_id_26,
  t0.matter_id AS matter_id_27,
  t0.sub_matter_id AS sub_matter_id_28,
  t0.school_teacher_id AS school_teacher_id_29
FROM
  school_average_report_card t0
WHERE
  t0.report_card_id = ?
ORDER BY
  t0.order_num ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.note_on AS note_on_3, t0.average AS average_4, t0.coefficient AS coefficient_5, t0.coefficient_x_average AS coefficient_x_average_6, t0.order_num AS order_num_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.rank AS rank_12, t0.class_average AS class_average_13, t0.smallest_average AS smallest_average_14, t0.sstrongest_average AS sstrongest_average_15, t0.as_submatter AS as_submatter_16, t0.annual_average AS annual_average_17, t0.annual_rank AS annual_rank_18, t0.rank_average AS rank_average_19, t0.is_matter_conduct AS is_matter_conduct_20, t0.establishment_id AS establishment_id_21, t0.school_year_id AS school_year_id_22, t0.school_year_periode_id AS school_year_periode_id_23, t0.student_registration_id AS student_registration_id_24, t0.classroom_id AS classroom_id_25, t0.report_card_id AS report_card_id_26, t0.matter_id AS matter_id_27, t0.sub_matter_id AS sub_matter_id_28, t0.school_teacher_id AS school_teacher_id_29 FROM school_average_report_card t0 WHERE t0.report_card_id = 817485 ORDER BY t0.order_num ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.note_on AS note_on_3,
  t0.average AS average_4,
  t0.coefficient AS coefficient_5,
  t0.coefficient_x_average AS coefficient_x_average_6,
  t0.order_num AS order_num_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.rank AS rank_12,
  t0.class_average AS class_average_13,
  t0.smallest_average AS smallest_average_14,
  t0.sstrongest_average AS sstrongest_average_15,
  t0.as_submatter AS as_submatter_16,
  t0.annual_average AS annual_average_17,
  t0.annual_rank AS annual_rank_18,
  t0.rank_average AS rank_average_19,
  t0.is_matter_conduct AS is_matter_conduct_20,
  t0.establishment_id AS establishment_id_21,
  t0.school_year_id AS school_year_id_22,
  t0.school_year_periode_id AS school_year_periode_id_23,
  t0.student_registration_id AS student_registration_id_24,
  t0.classroom_id AS classroom_id_25,
  t0.report_card_id AS report_card_id_26,
  t0.matter_id AS matter_id_27,
  t0.sub_matter_id AS sub_matter_id_28,
  t0.school_teacher_id AS school_teacher_id_29
FROM
  school_average_report_card t0
WHERE
  t0.report_card_id = ?
ORDER BY
  t0.order_num ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.note_on AS note_on_3, t0.average AS average_4, t0.coefficient AS coefficient_5, t0.coefficient_x_average AS coefficient_x_average_6, t0.order_num AS order_num_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.rank AS rank_12, t0.class_average AS class_average_13, t0.smallest_average AS smallest_average_14, t0.sstrongest_average AS sstrongest_average_15, t0.as_submatter AS as_submatter_16, t0.annual_average AS annual_average_17, t0.annual_rank AS annual_rank_18, t0.rank_average AS rank_average_19, t0.is_matter_conduct AS is_matter_conduct_20, t0.establishment_id AS establishment_id_21, t0.school_year_id AS school_year_id_22, t0.school_year_periode_id AS school_year_periode_id_23, t0.student_registration_id AS student_registration_id_24, t0.classroom_id AS classroom_id_25, t0.report_card_id AS report_card_id_26, t0.matter_id AS matter_id_27, t0.sub_matter_id AS sub_matter_id_28, t0.school_teacher_id AS school_teacher_id_29 FROM school_average_report_card t0 WHERE t0.report_card_id = 817534 ORDER BY t0.order_num ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.note_on AS note_on_3,
  t0.average AS average_4,
  t0.coefficient AS coefficient_5,
  t0.coefficient_x_average AS coefficient_x_average_6,
  t0.order_num AS order_num_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.rank AS rank_12,
  t0.class_average AS class_average_13,
  t0.smallest_average AS smallest_average_14,
  t0.sstrongest_average AS sstrongest_average_15,
  t0.as_submatter AS as_submatter_16,
  t0.annual_average AS annual_average_17,
  t0.annual_rank AS annual_rank_18,
  t0.rank_average AS rank_average_19,
  t0.is_matter_conduct AS is_matter_conduct_20,
  t0.establishment_id AS establishment_id_21,
  t0.school_year_id AS school_year_id_22,
  t0.school_year_periode_id AS school_year_periode_id_23,
  t0.student_registration_id AS student_registration_id_24,
  t0.classroom_id AS classroom_id_25,
  t0.report_card_id AS report_card_id_26,
  t0.matter_id AS matter_id_27,
  t0.sub_matter_id AS sub_matter_id_28,
  t0.school_teacher_id AS school_teacher_id_29
FROM
  school_average_report_card t0
WHERE
  t0.report_card_id = ?
ORDER BY
  t0.order_num ASC