Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.price AS price_1,
  s0_.title AS title_2,
  s0_.slug AS slug_3,
  s0_.stripe_id AS stripe_id_4,
  s0_.data_class AS data_class_5,
  s0_.tracking AS tracking_6,
  s0_.payment_for AS payment_for_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9
FROM
  stripe_payment s0_
WHERE
  s0_.slug = ?

SELECT s0_.id AS id_0, s0_.price AS price_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.stripe_id AS stripe_id_4, s0_.data_class AS data_class_5, s0_.tracking AS tracking_6, s0_.payment_for AS payment_for_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9 FROM stripe_payment s0_ WHERE s0_.slug = 'full-access-platform';

SELECT
  s0_.id AS id_0,
  s0_.price AS price_1,
  s0_.title AS title_2,
  s0_.slug AS slug_3,
  s0_.stripe_id AS stripe_id_4,
  s0_.data_class AS data_class_5,
  s0_.tracking AS tracking_6,
  s0_.payment_for AS payment_for_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9
FROM
  stripe_payment s0_
WHERE
  s0_.slug = ?

SELECT s0_.id AS id_0, s0_.price AS price_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.stripe_id AS stripe_id_4, s0_.data_class AS data_class_5, s0_.tracking AS tracking_6, s0_.payment_for AS payment_for_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9 FROM stripe_payment s0_ WHERE s0_.slug = 'page-unlock';

SELECT
  s0_.id AS id_0,
  s0_.price AS price_1,
  s0_.title AS title_2,
  s0_.slug AS slug_3,
  s0_.stripe_id AS stripe_id_4,
  s0_.data_class AS data_class_5,
  s0_.tracking AS tracking_6,
  s0_.payment_for AS payment_for_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9
FROM
  stripe_payment s0_
WHERE
  s0_.slug = ?

SELECT s0_.id AS id_0, s0_.price AS price_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.stripe_id AS stripe_id_4, s0_.data_class AS data_class_5, s0_.tracking AS tracking_6, s0_.payment_for AS payment_for_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9 FROM stripe_payment s0_ WHERE s0_.slug = 'btoc';

SELECT
  n0_.student_id AS sclr_0,
  n0_.data_class AS data_class_1,
  n0_.created_at AS created_at_2
FROM
  notification n0_
  INNER JOIN student s1_ ON n0_.student_id = s1_.id
  INNER JOIN school s2_ ON s1_.school_id = s2_.id
  AND (s2_.slug != 'ifa-french-tech')
  LEFT JOIN accommodation_data a3_ ON s1_.accommodation_data_id = a3_.id
  LEFT JOIN residence r4_ ON a3_.residence_id = r4_.id
  LEFT JOIN residence_notification r5_ ON (
    r5_.residence_id = r4_.id
    AND r5_.school_id = s2_.id
  )
WHERE
  n0_.data_class <> ?
  AND n0_.data_class <> ?
  AND n0_.data_class <> ?
  AND n0_.has_been_read = ?
  AND n0_.notif_to = ?
  AND (
    n0_.data_class <> ?
    OR (
      n0_.data_class = ?
      AND (
        (
          r5_.residence_id IS NULL
          AND r5_.school_id IS NULL
        )
        OR r5_.notify = 1
      )
    )
  )
GROUP BY
  n0_.student_id,
  n0_.data_class
ORDER BY
  n0_.created_at DESC

SELECT n0_.student_id AS sclr_0, n0_.data_class AS data_class_1, n0_.created_at AS created_at_2 FROM notification n0_ INNER JOIN student s1_ ON n0_.student_id = s1_.id INNER JOIN school s2_ ON s1_.school_id = s2_.id AND (s2_.slug != 'ifa-french-tech') LEFT JOIN accommodation_data a3_ ON s1_.accommodation_data_id = a3_.id LEFT JOIN residence r4_ ON a3_.residence_id = r4_.id LEFT JOIN residence_notification r5_ ON (r5_.residence_id = r4_.id AND r5_.school_id = s2_.id) WHERE n0_.data_class <> 'FrenchClassEnrollmentData' AND n0_.data_class <> 'RoommateData' AND n0_.data_class <> 'TranslationData' AND n0_.has_been_read = 0 AND n0_.notif_to = 'admin' AND (n0_.data_class <> 'AccommodationData' OR (n0_.data_class = 'AccommodationData' AND ((r5_.residence_id IS NULL AND r5_.school_id IS NULL) OR r5_.notify = 1))) GROUP BY n0_.student_id, n0_.data_class ORDER BY n0_.created_at DESC;

SELECT
  s0_.id AS id_0,
  s0_.username AS username_1,
  s0_.username_canonical AS username_canonical_2,
  s0_.email AS email_3,
  s0_.email_canonical AS email_canonical_4,
  s0_.password AS password_5,
  s0_.roles AS roles_6,
  s0_.enabled AS enabled_7,
  s0_.last_login AS last_login_8,
  s0_.password_reset_token AS password_reset_token_9,
  s0_.password_reset_token_expires_at AS password_reset_token_expires_at_10,
  s0_.onboarded_at AS onboarded_at_11,
  s0_.account_valid AS account_valid_12,
  s0_.mail_sent_at AS mail_sent_at_13,
  s0_.mail_relance_account_invalid_sent_at AS mail_relance_account_invalid_sent_at_14,
  s0_.mail_relance_visa_sent_at AS mail_relance_visa_sent_at_15,
  s0_.mail_relance_bank_sent_at AS mail_relance_bank_sent_at_16,
  s0_.mail_warning_under_age_sent_at AS mail_warning_under_age_sent_at_17,
  s0_.email2 AS email2_18,
  s0_.firstName AS firstName_19,
  s0_.lastName AS lastName_20,
  s0_.birthDate AS birthDate_21,
  s0_.phone AS phone_22,
  s0_.nationality AS nationality_23,
  s0_.countryVisaAsked AS countryVisaAsked_24,
  s0_.cityVisaAsked AS cityVisaAsked_25,
  s0_.enrollmentProgram AS enrollmentProgram_26,
  s0_.startFranceCursus AS startFranceCursus_27,
  s0_.endFranceCursus AS endFranceCursus_28,
  s0_.flatNumber AS flatNumber_29,
  s0_.buildingNumber AS buildingNumber_30,
  s0_.country AS country_31,
  s0_.delete_at AS delete_at_32,
  s0_.activated_services AS activated_services_33,
  s0_.cursus_month AS cursus_month_34,
  s0_.cursus_year AS cursus_year_35,
  s0_.show_profile AS show_profile_36,
  s0_.accept_cnil AS accept_cnil_37,
  s0_.previous_france_visa_refusal AS previous_france_visa_refusal_38,
  s0_.need_flat_mate AS need_flat_mate_39,
  s0_.need_eu_card_health_insurance AS need_eu_card_health_insurance_40,
  s0_.enable_relance_mail AS enable_relance_mail_41,
  s0_.delete_reason AS delete_reason_42,
  s0_.arriving_date AS arriving_date_43,
  s0_.locale AS locale_44,
  s0_.spoken_language AS spoken_language_45,
  s0_.length_of_stay AS length_of_stay_46,
  s0_.gender AS gender_47,
  s0_.cgu AS cgu_48,
  s0_.french_phone_number AS french_phone_number_49,
  s0_.allow_edit_text AS allow_edit_text_50,
  s0_.matomo_visitor_id AS matomo_visitor_id_51,
  s0_.platform_services AS platform_services_52,
  s0_.use_zendesk_form AS use_zendesk_form_53,
  s0_.visa_pre_validation AS visa_pre_validation_54,
  s0_.titre_sejour_validation AS titre_sejour_validation_55,
  s0_.additional_services AS additional_services_56,
  s0_.school_free_field AS school_free_field_57,
  s0_.rating AS rating_58,
  s0_.rating_comment AS rating_comment_59,
  s0_.rating_date AS rating_date_60,
  s0_.relance_unsubscribe_token AS relance_unsubscribe_token_61,
  s0_.relance_subscribed AS relance_subscribed_62,
  s0_.delete_token AS delete_token_63,
  s0_.last_verified_at AS last_verified_at_64,
  s0_.created_source AS created_source_65,
  s0_.preferred_communication_method AS preferred_communication_method_66,
  s0_.password2 AS password2_67,
  s0_.unlock_cvec AS unlock_cvec_68,
  s0_.no_appointment AS no_appointment_69,
  s0_.created_at AS created_at_70,
  s0_.updated_at AS updated_at_71,
  s0_.supervisor AS supervisor_72,
  s0_.thesis_funding AS thesis_funding_73,
  s0_.thesis_funding_contract_type AS thesis_funding_contract_type_74,
  s0_.numberAndNameOfStreet AS numberAndNameOfStreet_75,
  s0_.zipCode AS zipCode_76,
  s0_.city AS city_77,
  s0_.payed_at AS payed_at_78,
  s0_.payment_reference AS payment_reference_79,
  s0_.payment_id AS payment_id_80,
  v1_.state AS state_81,
  v1_.validated_at AS validated_at_82,
  v1_.invalidated_at AS invalidated_at_83,
  v1_.message AS message_84,
  v1_.service_history AS service_history_85,
  v1_.invalid_history_state AS invalid_history_state_86,
  v1_.valid_history_state AS valid_history_state_87,
  v1_.id AS id_88,
  v1_.created_account_from_etude_france AS created_account_from_etude_france_89,
  v1_.campus_france_interview AS campus_france_interview_90,
  v1_.visa_web_site_visited AS visa_web_site_visited_91,
  v1_.bookedVisaCenter AS bookedVisaCenter_92,
  v1_.visa_center_appointment_date AS visa_center_appointment_date_93,
  v1_.visa_expiration_date AS visa_expiration_date_94,
  v1_.visited_steps AS visited_steps_95,
  v1_.documents_collected AS documents_collected_96,
  v1_.current_step AS current_step_97,
  v1_.cursus_beginning AS cursus_beginning_98,
  v1_.cursus_ending AS cursus_ending_99,
  v1_.admin_comment AS admin_comment_100,
  v1_.document_ref_extra AS document_ref_extra_101,
  v1_.late_attendance_date AS late_attendance_date_102,
  v1_.visa_type AS visa_type_103,
  v1_.campus_message AS campus_message_104,
  v1_.mjm_enrollment_letter_unlocked_email_sent_at AS mjm_enrollment_letter_unlocked_email_sent_at_105,
  v1_.created_at AS created_at_106,
  v1_.updated_at AS updated_at_107,
  v1_.is_active AS is_active_108,
  v1_.confidential_message AS confidential_message_109,
  v1_.became_valid_at AS became_valid_at_110,
  v1_.deletion_confirmed_at AS deletion_confirmed_at_111,
  v1_.documents_deleted_at AS documents_deleted_at_112,
  z2_.id AS id_113,
  z2_.villes AS villes_114,
  z2_.pays AS pays_115,
  z2_.created_account_from_etude_france AS created_account_from_etude_france_116,
  z2_.created_account_from_campus_france AS created_account_from_campus_france_117,
  z2_.common_check_list AS common_check_list_118,
  s0_.school_id AS school_id_119,
  s0_.school_track_id AS school_track_id_120,
  s0_.sector_id AS sector_id_121,
  s0_.accommodation_data_id AS accommodation_data_id_122,
  s0_.bank_phone_home_insurance_data_id AS bank_phone_home_insurance_data_id_123,
  s0_.visa_data_id AS visa_data_id_124,
  s0_.health_insurance_data_id AS health_insurance_data_id_125,
  s0_.electricity_data_id AS electricity_data_id_126,
  s0_.metro_data_id AS metro_data_id_127,
  s0_.caf_data_id AS caf_data_id_128,
  s0_.visa_ofii_data_id AS visa_ofii_data_id_129,
  s0_.titre_sejour_data_id AS titre_sejour_data_id_130,
  s0_.renewal_metro_data_id AS renewal_metro_data_id_131,
  s0_.certificate_data_id AS certificate_data_id_132,
  s0_.cvec_data_id AS cvec_data_id_133,
  s0_.before_leaving_data_id AS before_leaving_data_id_134,
  s0_.private_health_insurance_data_id AS private_health_insurance_data_id_135,
  s0_.bank_data_id AS bank_data_id_136,
  s0_.home_insurance_data_id AS home_insurance_data_id_137,
  s0_.phone_data_id AS phone_data_id_138,
  s0_.student_city_id AS student_city_id_139,
  s0_.school_bto_c_id AS school_bto_c_id_140,
  s0_.roommate_data_id AS roommate_data_id_141,
  s0_.translation_data_id AS translation_data_id_142,
  s0_.welcome_pack_data_id AS welcome_pack_data_id_143,
  s0_.meet_and_greet_data_id AS meet_and_greet_data_id_144,
  s0_.student_buddy_data_id AS student_buddy_data_id_145,
  s0_.school_appointment_data_id AS school_appointment_data_id_146,
  s0_.welcome_day_data_id AS welcome_day_data_id_147,
  s0_.private_insurance_data_id AS private_insurance_data_id_148,
  s0_.french_class_enrollment_data_id AS french_class_enrollment_data_id_149,
  s0_.composante_id AS composante_id_150,
  s0_.program_id AS program_id_151,
  s0_.referent_id AS referent_id_152,
  s0_.laboratoire_id AS laboratoire_id_153,
  s0_.doctoral_school_id AS doctoral_school_id_154,
  v1_.zone_id AS zone_id_155
FROM
  student s0_
  LEFT JOIN visa_data v1_ ON s0_.visa_data_id = v1_.id
  LEFT JOIN zone z2_ ON v1_.zone_id = z2_.id
WHERE
  s0_.id IN (?, ?, ?, ?, ?, ?, ?)

SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.username_canonical AS username_canonical_2, s0_.email AS email_3, s0_.email_canonical AS email_canonical_4, s0_.password AS password_5, s0_.roles AS roles_6, s0_.enabled AS enabled_7, s0_.last_login AS last_login_8, s0_.password_reset_token AS password_reset_token_9, s0_.password_reset_token_expires_at AS password_reset_token_expires_at_10, s0_.onboarded_at AS onboarded_at_11, s0_.account_valid AS account_valid_12, s0_.mail_sent_at AS mail_sent_at_13, s0_.mail_relance_account_invalid_sent_at AS mail_relance_account_invalid_sent_at_14, s0_.mail_relance_visa_sent_at AS mail_relance_visa_sent_at_15, s0_.mail_relance_bank_sent_at AS mail_relance_bank_sent_at_16, s0_.mail_warning_under_age_sent_at AS mail_warning_under_age_sent_at_17, s0_.email2 AS email2_18, s0_.firstName AS firstName_19, s0_.lastName AS lastName_20, s0_.birthDate AS birthDate_21, s0_.phone AS phone_22, s0_.nationality AS nationality_23, s0_.countryVisaAsked AS countryVisaAsked_24, s0_.cityVisaAsked AS cityVisaAsked_25, s0_.enrollmentProgram AS enrollmentProgram_26, s0_.startFranceCursus AS startFranceCursus_27, s0_.endFranceCursus AS endFranceCursus_28, s0_.flatNumber AS flatNumber_29, s0_.buildingNumber AS buildingNumber_30, s0_.country AS country_31, s0_.delete_at AS delete_at_32, s0_.activated_services AS activated_services_33, s0_.cursus_month AS cursus_month_34, s0_.cursus_year AS cursus_year_35, s0_.show_profile AS show_profile_36, s0_.accept_cnil AS accept_cnil_37, s0_.previous_france_visa_refusal AS previous_france_visa_refusal_38, s0_.need_flat_mate AS need_flat_mate_39, s0_.need_eu_card_health_insurance AS need_eu_card_health_insurance_40, s0_.enable_relance_mail AS enable_relance_mail_41, s0_.delete_reason AS delete_reason_42, s0_.arriving_date AS arriving_date_43, s0_.locale AS locale_44, s0_.spoken_language AS spoken_language_45, s0_.length_of_stay AS length_of_stay_46, s0_.gender AS gender_47, s0_.cgu AS cgu_48, s0_.french_phone_number AS french_phone_number_49, s0_.allow_edit_text AS allow_edit_text_50, s0_.matomo_visitor_id AS matomo_visitor_id_51, s0_.platform_services AS platform_services_52, s0_.use_zendesk_form AS use_zendesk_form_53, s0_.visa_pre_validation AS visa_pre_validation_54, s0_.titre_sejour_validation AS titre_sejour_validation_55, s0_.additional_services AS additional_services_56, s0_.school_free_field AS school_free_field_57, s0_.rating AS rating_58, s0_.rating_comment AS rating_comment_59, s0_.rating_date AS rating_date_60, s0_.relance_unsubscribe_token AS relance_unsubscribe_token_61, s0_.relance_subscribed AS relance_subscribed_62, s0_.delete_token AS delete_token_63, s0_.last_verified_at AS last_verified_at_64, s0_.created_source AS created_source_65, s0_.preferred_communication_method AS preferred_communication_method_66, s0_.password2 AS password2_67, s0_.unlock_cvec AS unlock_cvec_68, s0_.no_appointment AS no_appointment_69, s0_.created_at AS created_at_70, s0_.updated_at AS updated_at_71, s0_.supervisor AS supervisor_72, s0_.thesis_funding AS thesis_funding_73, s0_.thesis_funding_contract_type AS thesis_funding_contract_type_74, s0_.numberAndNameOfStreet AS numberAndNameOfStreet_75, s0_.zipCode AS zipCode_76, s0_.city AS city_77, s0_.payed_at AS payed_at_78, s0_.payment_reference AS payment_reference_79, s0_.payment_id AS payment_id_80, v1_.state AS state_81, v1_.validated_at AS validated_at_82, v1_.invalidated_at AS invalidated_at_83, v1_.message AS message_84, v1_.service_history AS service_history_85, v1_.invalid_history_state AS invalid_history_state_86, v1_.valid_history_state AS valid_history_state_87, v1_.id AS id_88, v1_.created_account_from_etude_france AS created_account_from_etude_france_89, v1_.campus_france_interview AS campus_france_interview_90, v1_.visa_web_site_visited AS visa_web_site_visited_91, v1_.bookedVisaCenter AS bookedVisaCenter_92, v1_.visa_center_appointment_date AS visa_center_appointment_date_93, v1_.visa_expiration_date AS visa_expiration_date_94, v1_.visited_steps AS visited_steps_95, v1_.documents_collected AS documents_collected_96, v1_.current_step AS current_step_97, v1_.cursus_beginning AS cursus_beginning_98, v1_.cursus_ending AS cursus_ending_99, v1_.admin_comment AS admin_comment_100, v1_.document_ref_extra AS document_ref_extra_101, v1_.late_attendance_date AS late_attendance_date_102, v1_.visa_type AS visa_type_103, v1_.campus_message AS campus_message_104, v1_.mjm_enrollment_letter_unlocked_email_sent_at AS mjm_enrollment_letter_unlocked_email_sent_at_105, v1_.created_at AS created_at_106, v1_.updated_at AS updated_at_107, v1_.is_active AS is_active_108, v1_.confidential_message AS confidential_message_109, v1_.became_valid_at AS became_valid_at_110, v1_.deletion_confirmed_at AS deletion_confirmed_at_111, v1_.documents_deleted_at AS documents_deleted_at_112, z2_.id AS id_113, z2_.villes AS villes_114, z2_.pays AS pays_115, z2_.created_account_from_etude_france AS created_account_from_etude_france_116, z2_.created_account_from_campus_france AS created_account_from_campus_france_117, z2_.common_check_list AS common_check_list_118, s0_.school_id AS school_id_119, s0_.school_track_id AS school_track_id_120, s0_.sector_id AS sector_id_121, s0_.accommodation_data_id AS accommodation_data_id_122, s0_.bank_phone_home_insurance_data_id AS bank_phone_home_insurance_data_id_123, s0_.visa_data_id AS visa_data_id_124, s0_.health_insurance_data_id AS health_insurance_data_id_125, s0_.electricity_data_id AS electricity_data_id_126, s0_.metro_data_id AS metro_data_id_127, s0_.caf_data_id AS caf_data_id_128, s0_.visa_ofii_data_id AS visa_ofii_data_id_129, s0_.titre_sejour_data_id AS titre_sejour_data_id_130, s0_.renewal_metro_data_id AS renewal_metro_data_id_131, s0_.certificate_data_id AS certificate_data_id_132, s0_.cvec_data_id AS cvec_data_id_133, s0_.before_leaving_data_id AS before_leaving_data_id_134, s0_.private_health_insurance_data_id AS private_health_insurance_data_id_135, s0_.bank_data_id AS bank_data_id_136, s0_.home_insurance_data_id AS home_insurance_data_id_137, s0_.phone_data_id AS phone_data_id_138, s0_.student_city_id AS student_city_id_139, s0_.school_bto_c_id AS school_bto_c_id_140, s0_.roommate_data_id AS roommate_data_id_141, s0_.translation_data_id AS translation_data_id_142, s0_.welcome_pack_data_id AS welcome_pack_data_id_143, s0_.meet_and_greet_data_id AS meet_and_greet_data_id_144, s0_.student_buddy_data_id AS student_buddy_data_id_145, s0_.school_appointment_data_id AS school_appointment_data_id_146, s0_.welcome_day_data_id AS welcome_day_data_id_147, s0_.private_insurance_data_id AS private_insurance_data_id_148, s0_.french_class_enrollment_data_id AS french_class_enrollment_data_id_149, s0_.composante_id AS composante_id_150, s0_.program_id AS program_id_151, s0_.referent_id AS referent_id_152, s0_.laboratoire_id AS laboratoire_id_153, s0_.doctoral_school_id AS doctoral_school_id_154, v1_.zone_id AS zone_id_155 FROM student s0_ LEFT JOIN visa_data v1_ ON s0_.visa_data_id = v1_.id LEFT JOIN zone z2_ ON v1_.zone_id = z2_.id WHERE s0_.id IN (2, 1371, 1395, 1396, 1416, 1418, 1469);

SELECT
  t0.id AS id_1,
  t0.nb_personne AS nb_personne_2,
  t0.age AS age_3,
  t0.residence_type AS residence_type_4,
  t0.budget AS budget_5,
  t0.commentaire AS commentaire_6,
  t0.length_of_stay AS length_of_stay_7,
  t0.lease_start AS lease_start_8,
  t0.with_parent AS with_parent_9,
  t0.has_roommate AS has_roommate_10,
  t0.student_id AS student_id_11,
  t0.city_id AS city_id_12
FROM
  score_card t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.nb_personne AS nb_personne_2, t0.age AS age_3, t0.residence_type AS residence_type_4, t0.budget AS budget_5, t0.commentaire AS commentaire_6, t0.length_of_stay AS length_of_stay_7, t0.lease_start AS lease_start_8, t0.with_parent AS with_parent_9, t0.has_roommate AS has_roommate_10, t0.student_id AS student_id_11, t0.city_id AS city_id_12 FROM score_card t0 WHERE t0.student_id = 2;

SELECT
  t0.id AS id_1,
  t0.validated AS validated_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.student_id AS student_id_6,
  t0.buddy_id AS buddy_id_7,
  t0.school_id AS school_id_8
FROM
  buddy_student_matching t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.validated AS validated_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.buddy_id AS buddy_id_7, t0.school_id AS school_id_8 FROM buddy_student_matching t0 WHERE t0.student_id = 2;

SELECT
  t0.id AS id_1,
  t0.nb_personne AS nb_personne_2,
  t0.age AS age_3,
  t0.residence_type AS residence_type_4,
  t0.budget AS budget_5,
  t0.commentaire AS commentaire_6,
  t0.length_of_stay AS length_of_stay_7,
  t0.lease_start AS lease_start_8,
  t0.with_parent AS with_parent_9,
  t0.has_roommate AS has_roommate_10,
  t0.student_id AS student_id_11,
  t0.city_id AS city_id_12
FROM
  score_card t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.nb_personne AS nb_personne_2, t0.age AS age_3, t0.residence_type AS residence_type_4, t0.budget AS budget_5, t0.commentaire AS commentaire_6, t0.length_of_stay AS length_of_stay_7, t0.lease_start AS lease_start_8, t0.with_parent AS with_parent_9, t0.has_roommate AS has_roommate_10, t0.student_id AS student_id_11, t0.city_id AS city_id_12 FROM score_card t0 WHERE t0.student_id = 1371;

SELECT
  t0.id AS id_1,
  t0.validated AS validated_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.student_id AS student_id_6,
  t0.buddy_id AS buddy_id_7,
  t0.school_id AS school_id_8
FROM
  buddy_student_matching t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.validated AS validated_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.buddy_id AS buddy_id_7, t0.school_id AS school_id_8 FROM buddy_student_matching t0 WHERE t0.student_id = 1371;

SELECT
  t0.id AS id_1,
  t0.nb_personne AS nb_personne_2,
  t0.age AS age_3,
  t0.residence_type AS residence_type_4,
  t0.budget AS budget_5,
  t0.commentaire AS commentaire_6,
  t0.length_of_stay AS length_of_stay_7,
  t0.lease_start AS lease_start_8,
  t0.with_parent AS with_parent_9,
  t0.has_roommate AS has_roommate_10,
  t0.student_id AS student_id_11,
  t0.city_id AS city_id_12
FROM
  score_card t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.nb_personne AS nb_personne_2, t0.age AS age_3, t0.residence_type AS residence_type_4, t0.budget AS budget_5, t0.commentaire AS commentaire_6, t0.length_of_stay AS length_of_stay_7, t0.lease_start AS lease_start_8, t0.with_parent AS with_parent_9, t0.has_roommate AS has_roommate_10, t0.student_id AS student_id_11, t0.city_id AS city_id_12 FROM score_card t0 WHERE t0.student_id = 1395;

SELECT
  t0.id AS id_1,
  t0.validated AS validated_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.student_id AS student_id_6,
  t0.buddy_id AS buddy_id_7,
  t0.school_id AS school_id_8
FROM
  buddy_student_matching t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.validated AS validated_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.buddy_id AS buddy_id_7, t0.school_id AS school_id_8 FROM buddy_student_matching t0 WHERE t0.student_id = 1395;

SELECT
  t0.id AS id_1,
  t0.nb_personne AS nb_personne_2,
  t0.age AS age_3,
  t0.residence_type AS residence_type_4,
  t0.budget AS budget_5,
  t0.commentaire AS commentaire_6,
  t0.length_of_stay AS length_of_stay_7,
  t0.lease_start AS lease_start_8,
  t0.with_parent AS with_parent_9,
  t0.has_roommate AS has_roommate_10,
  t0.student_id AS student_id_11,
  t0.city_id AS city_id_12
FROM
  score_card t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.nb_personne AS nb_personne_2, t0.age AS age_3, t0.residence_type AS residence_type_4, t0.budget AS budget_5, t0.commentaire AS commentaire_6, t0.length_of_stay AS length_of_stay_7, t0.lease_start AS lease_start_8, t0.with_parent AS with_parent_9, t0.has_roommate AS has_roommate_10, t0.student_id AS student_id_11, t0.city_id AS city_id_12 FROM score_card t0 WHERE t0.student_id = 1396;

SELECT
  t0.id AS id_1,
  t0.validated AS validated_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.student_id AS student_id_6,
  t0.buddy_id AS buddy_id_7,
  t0.school_id AS school_id_8
FROM
  buddy_student_matching t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.validated AS validated_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.buddy_id AS buddy_id_7, t0.school_id AS school_id_8 FROM buddy_student_matching t0 WHERE t0.student_id = 1396;

SELECT
  t0.id AS id_1,
  t0.nb_personne AS nb_personne_2,
  t0.age AS age_3,
  t0.residence_type AS residence_type_4,
  t0.budget AS budget_5,
  t0.commentaire AS commentaire_6,
  t0.length_of_stay AS length_of_stay_7,
  t0.lease_start AS lease_start_8,
  t0.with_parent AS with_parent_9,
  t0.has_roommate AS has_roommate_10,
  t0.student_id AS student_id_11,
  t0.city_id AS city_id_12
FROM
  score_card t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.nb_personne AS nb_personne_2, t0.age AS age_3, t0.residence_type AS residence_type_4, t0.budget AS budget_5, t0.commentaire AS commentaire_6, t0.length_of_stay AS length_of_stay_7, t0.lease_start AS lease_start_8, t0.with_parent AS with_parent_9, t0.has_roommate AS has_roommate_10, t0.student_id AS student_id_11, t0.city_id AS city_id_12 FROM score_card t0 WHERE t0.student_id = 1416;

SELECT
  t0.id AS id_1,
  t0.validated AS validated_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.student_id AS student_id_6,
  t0.buddy_id AS buddy_id_7,
  t0.school_id AS school_id_8
FROM
  buddy_student_matching t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.validated AS validated_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.buddy_id AS buddy_id_7, t0.school_id AS school_id_8 FROM buddy_student_matching t0 WHERE t0.student_id = 1416;

SELECT
  t0.id AS id_1,
  t0.nb_personne AS nb_personne_2,
  t0.age AS age_3,
  t0.residence_type AS residence_type_4,
  t0.budget AS budget_5,
  t0.commentaire AS commentaire_6,
  t0.length_of_stay AS length_of_stay_7,
  t0.lease_start AS lease_start_8,
  t0.with_parent AS with_parent_9,
  t0.has_roommate AS has_roommate_10,
  t0.student_id AS student_id_11,
  t0.city_id AS city_id_12
FROM
  score_card t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.nb_personne AS nb_personne_2, t0.age AS age_3, t0.residence_type AS residence_type_4, t0.budget AS budget_5, t0.commentaire AS commentaire_6, t0.length_of_stay AS length_of_stay_7, t0.lease_start AS lease_start_8, t0.with_parent AS with_parent_9, t0.has_roommate AS has_roommate_10, t0.student_id AS student_id_11, t0.city_id AS city_id_12 FROM score_card t0 WHERE t0.student_id = 1418;

SELECT
  t0.id AS id_1,
  t0.validated AS validated_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.student_id AS student_id_6,
  t0.buddy_id AS buddy_id_7,
  t0.school_id AS school_id_8
FROM
  buddy_student_matching t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.validated AS validated_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.buddy_id AS buddy_id_7, t0.school_id AS school_id_8 FROM buddy_student_matching t0 WHERE t0.student_id = 1418;

SELECT
  t0.id AS id_1,
  t0.nb_personne AS nb_personne_2,
  t0.age AS age_3,
  t0.residence_type AS residence_type_4,
  t0.budget AS budget_5,
  t0.commentaire AS commentaire_6,
  t0.length_of_stay AS length_of_stay_7,
  t0.lease_start AS lease_start_8,
  t0.with_parent AS with_parent_9,
  t0.has_roommate AS has_roommate_10,
  t0.student_id AS student_id_11,
  t0.city_id AS city_id_12
FROM
  score_card t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.nb_personne AS nb_personne_2, t0.age AS age_3, t0.residence_type AS residence_type_4, t0.budget AS budget_5, t0.commentaire AS commentaire_6, t0.length_of_stay AS length_of_stay_7, t0.lease_start AS lease_start_8, t0.with_parent AS with_parent_9, t0.has_roommate AS has_roommate_10, t0.student_id AS student_id_11, t0.city_id AS city_id_12 FROM score_card t0 WHERE t0.student_id = 1469;

SELECT
  t0.id AS id_1,
  t0.validated AS validated_2,
  t0.active AS active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.student_id AS student_id_6,
  t0.buddy_id AS buddy_id_7,
  t0.school_id AS school_id_8
FROM
  buddy_student_matching t0
WHERE
  t0.student_id = ?

SELECT t0.id AS id_1, t0.validated AS validated_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.buddy_id AS buddy_id_7, t0.school_id AS school_id_8 FROM buddy_student_matching t0 WHERE t0.student_id = 1469;