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_.id AS id_0,
  n0_.notif_to AS notif_to_1,
  n0_.message AS message_2,
  n0_.data_class AS data_class_3,
  n0_.has_been_read AS has_been_read_4,
  n0_.created_at AS created_at_5,
  n0_.updated_at AS updated_at_6,
  n0_.student_id AS student_id_7,
  n0_.document_student_id AS document_student_id_8
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_.id AS id_0, n0_.notif_to AS notif_to_1, n0_.message AS message_2, n0_.data_class AS data_class_3, n0_.has_been_read AS has_been_read_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.student_id AS student_id_7, n0_.document_student_id AS document_student_id_8 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
  t0.id AS id_1,
  t0.username AS username_2,
  t0.username_canonical AS username_canonical_3,
  t0.email AS email_4,
  t0.email_canonical AS email_canonical_5,
  t0.password AS password_6,
  t0.roles AS roles_7,
  t0.enabled AS enabled_8,
  t0.last_login AS last_login_9,
  t0.password_reset_token AS password_reset_token_10,
  t0.password_reset_token_expires_at AS password_reset_token_expires_at_11,
  t0.onboarded_at AS onboarded_at_12,
  t0.account_valid AS account_valid_13,
  t0.mail_sent_at AS mail_sent_at_14,
  t0.mail_relance_account_invalid_sent_at AS mail_relance_account_invalid_sent_at_15,
  t0.mail_relance_visa_sent_at AS mail_relance_visa_sent_at_16,
  t0.mail_relance_bank_sent_at AS mail_relance_bank_sent_at_17,
  t0.mail_warning_under_age_sent_at AS mail_warning_under_age_sent_at_18,
  t0.email2 AS email2_19,
  t0.firstName AS firstName_20,
  t0.lastName AS lastName_21,
  t0.birthDate AS birthDate_22,
  t0.phone AS phone_23,
  t0.nationality AS nationality_24,
  t0.countryVisaAsked AS countryVisaAsked_25,
  t0.cityVisaAsked AS cityVisaAsked_26,
  t0.enrollmentProgram AS enrollmentProgram_27,
  t0.startFranceCursus AS startFranceCursus_28,
  t0.endFranceCursus AS endFranceCursus_29,
  t0.flatNumber AS flatNumber_30,
  t0.buildingNumber AS buildingNumber_31,
  t0.country AS country_32,
  t0.delete_at AS delete_at_33,
  t0.activated_services AS activated_services_34,
  t0.cursus_month AS cursus_month_35,
  t0.cursus_year AS cursus_year_36,
  t0.show_profile AS show_profile_37,
  t0.accept_cnil AS accept_cnil_38,
  t0.previous_france_visa_refusal AS previous_france_visa_refusal_39,
  t0.need_flat_mate AS need_flat_mate_40,
  t0.need_eu_card_health_insurance AS need_eu_card_health_insurance_41,
  t0.enable_relance_mail AS enable_relance_mail_42,
  t0.delete_reason AS delete_reason_43,
  t0.arriving_date AS arriving_date_44,
  t0.locale AS locale_45,
  t0.spoken_language AS spoken_language_46,
  t0.length_of_stay AS length_of_stay_47,
  t0.gender AS gender_48,
  t0.cgu AS cgu_49,
  t0.french_phone_number AS french_phone_number_50,
  t0.allow_edit_text AS allow_edit_text_51,
  t0.matomo_visitor_id AS matomo_visitor_id_52,
  t0.platform_services AS platform_services_53,
  t0.use_zendesk_form AS use_zendesk_form_54,
  t0.visa_pre_validation AS visa_pre_validation_55,
  t0.titre_sejour_validation AS titre_sejour_validation_56,
  t0.additional_services AS additional_services_57,
  t0.school_free_field AS school_free_field_58,
  t0.rating AS rating_59,
  t0.rating_comment AS rating_comment_60,
  t0.rating_date AS rating_date_61,
  t0.relance_unsubscribe_token AS relance_unsubscribe_token_62,
  t0.relance_subscribed AS relance_subscribed_63,
  t0.delete_token AS delete_token_64,
  t0.last_verified_at AS last_verified_at_65,
  t0.created_source AS created_source_66,
  t0.preferred_communication_method AS preferred_communication_method_67,
  t0.password2 AS password2_68,
  t0.unlock_cvec AS unlock_cvec_69,
  t0.no_appointment AS no_appointment_70,
  t0.created_at AS created_at_71,
  t0.updated_at AS updated_at_72,
  t0.supervisor AS supervisor_73,
  t0.thesis_funding AS thesis_funding_74,
  t0.thesis_funding_contract_type AS thesis_funding_contract_type_75,
  t0.numberAndNameOfStreet AS numberAndNameOfStreet_76,
  t0.zipCode AS zipCode_77,
  t0.city AS city_78,
  t0.payed_at AS payed_at_79,
  t0.payment_reference AS payment_reference_80,
  t0.payment_id AS payment_id_81,
  t0.school_id AS school_id_82,
  t0.school_track_id AS school_track_id_83,
  t0.sector_id AS sector_id_84,
  t0.accommodation_data_id AS accommodation_data_id_85,
  t0.bank_phone_home_insurance_data_id AS bank_phone_home_insurance_data_id_86,
  t0.visa_data_id AS visa_data_id_87,
  t0.health_insurance_data_id AS health_insurance_data_id_88,
  t0.electricity_data_id AS electricity_data_id_89,
  t0.metro_data_id AS metro_data_id_90,
  t0.caf_data_id AS caf_data_id_91,
  t0.visa_ofii_data_id AS visa_ofii_data_id_92,
  t0.titre_sejour_data_id AS titre_sejour_data_id_93,
  t0.renewal_metro_data_id AS renewal_metro_data_id_94,
  t0.certificate_data_id AS certificate_data_id_95,
  t0.cvec_data_id AS cvec_data_id_96,
  t0.before_leaving_data_id AS before_leaving_data_id_97,
  t0.private_health_insurance_data_id AS private_health_insurance_data_id_98,
  t0.bank_data_id AS bank_data_id_99,
  t0.home_insurance_data_id AS home_insurance_data_id_100,
  t0.phone_data_id AS phone_data_id_101,
  t0.student_city_id AS student_city_id_102,
  t0.school_bto_c_id AS school_bto_c_id_103,
  t0.roommate_data_id AS roommate_data_id_104,
  t0.translation_data_id AS translation_data_id_105,
  t106.id AS id_107,
  t106.nb_personne AS nb_personne_108,
  t106.age AS age_109,
  t106.residence_type AS residence_type_110,
  t106.budget AS budget_111,
  t106.commentaire AS commentaire_112,
  t106.length_of_stay AS length_of_stay_113,
  t106.lease_start AS lease_start_114,
  t106.with_parent AS with_parent_115,
  t106.has_roommate AS has_roommate_116,
  t106.student_id AS student_id_117,
  t106.city_id AS city_id_118,
  t0.welcome_pack_data_id AS welcome_pack_data_id_119,
  t0.meet_and_greet_data_id AS meet_and_greet_data_id_120,
  t0.student_buddy_data_id AS student_buddy_data_id_121,
  t0.school_appointment_data_id AS school_appointment_data_id_122,
  t0.welcome_day_data_id AS welcome_day_data_id_123,
  t0.private_insurance_data_id AS private_insurance_data_id_124,
  t0.french_class_enrollment_data_id AS french_class_enrollment_data_id_125,
  t126.id AS id_127,
  t126.validated AS validated_128,
  t126.active AS active_129,
  t126.created_at AS created_at_130,
  t126.updated_at AS updated_at_131,
  t126.student_id AS student_id_132,
  t126.buddy_id AS buddy_id_133,
  t126.school_id AS school_id_134,
  t0.composante_id AS composante_id_135,
  t0.program_id AS program_id_136,
  t0.referent_id AS referent_id_137,
  t0.laboratoire_id AS laboratoire_id_138,
  t0.doctoral_school_id AS doctoral_school_id_139
FROM
  student t0
  LEFT JOIN score_card t106 ON t106.student_id = t0.id
  LEFT JOIN buddy_student_matching t126 ON t126.student_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.password AS password_6, t0.roles AS roles_7, t0.enabled AS enabled_8, t0.last_login AS last_login_9, t0.password_reset_token AS password_reset_token_10, t0.password_reset_token_expires_at AS password_reset_token_expires_at_11, t0.onboarded_at AS onboarded_at_12, t0.account_valid AS account_valid_13, t0.mail_sent_at AS mail_sent_at_14, t0.mail_relance_account_invalid_sent_at AS mail_relance_account_invalid_sent_at_15, t0.mail_relance_visa_sent_at AS mail_relance_visa_sent_at_16, t0.mail_relance_bank_sent_at AS mail_relance_bank_sent_at_17, t0.mail_warning_under_age_sent_at AS mail_warning_under_age_sent_at_18, t0.email2 AS email2_19, t0.firstName AS firstName_20, t0.lastName AS lastName_21, t0.birthDate AS birthDate_22, t0.phone AS phone_23, t0.nationality AS nationality_24, t0.countryVisaAsked AS countryVisaAsked_25, t0.cityVisaAsked AS cityVisaAsked_26, t0.enrollmentProgram AS enrollmentProgram_27, t0.startFranceCursus AS startFranceCursus_28, t0.endFranceCursus AS endFranceCursus_29, t0.flatNumber AS flatNumber_30, t0.buildingNumber AS buildingNumber_31, t0.country AS country_32, t0.delete_at AS delete_at_33, t0.activated_services AS activated_services_34, t0.cursus_month AS cursus_month_35, t0.cursus_year AS cursus_year_36, t0.show_profile AS show_profile_37, t0.accept_cnil AS accept_cnil_38, t0.previous_france_visa_refusal AS previous_france_visa_refusal_39, t0.need_flat_mate AS need_flat_mate_40, t0.need_eu_card_health_insurance AS need_eu_card_health_insurance_41, t0.enable_relance_mail AS enable_relance_mail_42, t0.delete_reason AS delete_reason_43, t0.arriving_date AS arriving_date_44, t0.locale AS locale_45, t0.spoken_language AS spoken_language_46, t0.length_of_stay AS length_of_stay_47, t0.gender AS gender_48, t0.cgu AS cgu_49, t0.french_phone_number AS french_phone_number_50, t0.allow_edit_text AS allow_edit_text_51, t0.matomo_visitor_id AS matomo_visitor_id_52, t0.platform_services AS platform_services_53, t0.use_zendesk_form AS use_zendesk_form_54, t0.visa_pre_validation AS visa_pre_validation_55, t0.titre_sejour_validation AS titre_sejour_validation_56, t0.additional_services AS additional_services_57, t0.school_free_field AS school_free_field_58, t0.rating AS rating_59, t0.rating_comment AS rating_comment_60, t0.rating_date AS rating_date_61, t0.relance_unsubscribe_token AS relance_unsubscribe_token_62, t0.relance_subscribed AS relance_subscribed_63, t0.delete_token AS delete_token_64, t0.last_verified_at AS last_verified_at_65, t0.created_source AS created_source_66, t0.preferred_communication_method AS preferred_communication_method_67, t0.password2 AS password2_68, t0.unlock_cvec AS unlock_cvec_69, t0.no_appointment AS no_appointment_70, t0.created_at AS created_at_71, t0.updated_at AS updated_at_72, t0.supervisor AS supervisor_73, t0.thesis_funding AS thesis_funding_74, t0.thesis_funding_contract_type AS thesis_funding_contract_type_75, t0.numberAndNameOfStreet AS numberAndNameOfStreet_76, t0.zipCode AS zipCode_77, t0.city AS city_78, t0.payed_at AS payed_at_79, t0.payment_reference AS payment_reference_80, t0.payment_id AS payment_id_81, t0.school_id AS school_id_82, t0.school_track_id AS school_track_id_83, t0.sector_id AS sector_id_84, t0.accommodation_data_id AS accommodation_data_id_85, t0.bank_phone_home_insurance_data_id AS bank_phone_home_insurance_data_id_86, t0.visa_data_id AS visa_data_id_87, t0.health_insurance_data_id AS health_insurance_data_id_88, t0.electricity_data_id AS electricity_data_id_89, t0.metro_data_id AS metro_data_id_90, t0.caf_data_id AS caf_data_id_91, t0.visa_ofii_data_id AS visa_ofii_data_id_92, t0.titre_sejour_data_id AS titre_sejour_data_id_93, t0.renewal_metro_data_id AS renewal_metro_data_id_94, t0.certificate_data_id AS certificate_data_id_95, t0.cvec_data_id AS cvec_data_id_96, t0.before_leaving_data_id AS before_leaving_data_id_97, t0.private_health_insurance_data_id AS private_health_insurance_data_id_98, t0.bank_data_id AS bank_data_id_99, t0.home_insurance_data_id AS home_insurance_data_id_100, t0.phone_data_id AS phone_data_id_101, t0.student_city_id AS student_city_id_102, t0.school_bto_c_id AS school_bto_c_id_103, t0.roommate_data_id AS roommate_data_id_104, t0.translation_data_id AS translation_data_id_105, t106.id AS id_107, t106.nb_personne AS nb_personne_108, t106.age AS age_109, t106.residence_type AS residence_type_110, t106.budget AS budget_111, t106.commentaire AS commentaire_112, t106.length_of_stay AS length_of_stay_113, t106.lease_start AS lease_start_114, t106.with_parent AS with_parent_115, t106.has_roommate AS has_roommate_116, t106.student_id AS student_id_117, t106.city_id AS city_id_118, t0.welcome_pack_data_id AS welcome_pack_data_id_119, t0.meet_and_greet_data_id AS meet_and_greet_data_id_120, t0.student_buddy_data_id AS student_buddy_data_id_121, t0.school_appointment_data_id AS school_appointment_data_id_122, t0.welcome_day_data_id AS welcome_day_data_id_123, t0.private_insurance_data_id AS private_insurance_data_id_124, t0.french_class_enrollment_data_id AS french_class_enrollment_data_id_125, t126.id AS id_127, t126.validated AS validated_128, t126.active AS active_129, t126.created_at AS created_at_130, t126.updated_at AS updated_at_131, t126.student_id AS student_id_132, t126.buddy_id AS buddy_id_133, t126.school_id AS school_id_134, t0.composante_id AS composante_id_135, t0.program_id AS program_id_136, t0.referent_id AS referent_id_137, t0.laboratoire_id AS laboratoire_id_138, t0.doctoral_school_id AS doctoral_school_id_139 FROM student t0 LEFT JOIN score_card t106 ON t106.student_id = t0.id LEFT JOIN buddy_student_matching t126 ON t126.student_id = t0.id WHERE t0.id = 2;

SELECT
  t0.state AS state_1,
  t0.validated_at AS validated_at_2,
  t0.invalidated_at AS invalidated_at_3,
  t0.message AS message_4,
  t0.service_history AS service_history_5,
  t0.invalid_history_state AS invalid_history_state_6,
  t0.valid_history_state AS valid_history_state_7,
  t0.id AS id_8,
  t0.created_account_from_etude_france AS created_account_from_etude_france_9,
  t0.campus_france_interview AS campus_france_interview_10,
  t0.visa_web_site_visited AS visa_web_site_visited_11,
  t0.bookedVisaCenter AS bookedVisaCenter_12,
  t0.visa_center_appointment_date AS visa_center_appointment_date_13,
  t0.visa_expiration_date AS visa_expiration_date_14,
  t0.visited_steps AS visited_steps_15,
  t0.documents_collected AS documents_collected_16,
  t0.current_step AS current_step_17,
  t0.cursus_beginning AS cursus_beginning_18,
  t0.cursus_ending AS cursus_ending_19,
  t0.admin_comment AS admin_comment_20,
  t0.document_ref_extra AS document_ref_extra_21,
  t0.late_attendance_date AS late_attendance_date_22,
  t0.visa_type AS visa_type_23,
  t0.campus_message AS campus_message_24,
  t0.mjm_enrollment_letter_unlocked_email_sent_at AS mjm_enrollment_letter_unlocked_email_sent_at_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.is_active AS is_active_28,
  t0.confidential_message AS confidential_message_29,
  t0.became_valid_at AS became_valid_at_30,
  t0.deletion_confirmed_at AS deletion_confirmed_at_31,
  t0.documents_deleted_at AS documents_deleted_at_32,
  t0.zone_id AS zone_id_33,
  t34.id AS id_35,
  t34.username AS username_36,
  t34.username_canonical AS username_canonical_37,
  t34.email AS email_38,
  t34.email_canonical AS email_canonical_39,
  t34.password AS password_40,
  t34.roles AS roles_41,
  t34.enabled AS enabled_42,
  t34.last_login AS last_login_43,
  t34.password_reset_token AS password_reset_token_44,
  t34.password_reset_token_expires_at AS password_reset_token_expires_at_45,
  t34.onboarded_at AS onboarded_at_46,
  t34.account_valid AS account_valid_47,
  t34.mail_sent_at AS mail_sent_at_48,
  t34.mail_relance_account_invalid_sent_at AS mail_relance_account_invalid_sent_at_49,
  t34.mail_relance_visa_sent_at AS mail_relance_visa_sent_at_50,
  t34.mail_relance_bank_sent_at AS mail_relance_bank_sent_at_51,
  t34.mail_warning_under_age_sent_at AS mail_warning_under_age_sent_at_52,
  t34.email2 AS email2_53,
  t34.firstName AS firstName_54,
  t34.lastName AS lastName_55,
  t34.birthDate AS birthDate_56,
  t34.phone AS phone_57,
  t34.nationality AS nationality_58,
  t34.countryVisaAsked AS countryVisaAsked_59,
  t34.cityVisaAsked AS cityVisaAsked_60,
  t34.enrollmentProgram AS enrollmentProgram_61,
  t34.startFranceCursus AS startFranceCursus_62,
  t34.endFranceCursus AS endFranceCursus_63,
  t34.flatNumber AS flatNumber_64,
  t34.buildingNumber AS buildingNumber_65,
  t34.country AS country_66,
  t34.delete_at AS delete_at_67,
  t34.activated_services AS activated_services_68,
  t34.cursus_month AS cursus_month_69,
  t34.cursus_year AS cursus_year_70,
  t34.show_profile AS show_profile_71,
  t34.accept_cnil AS accept_cnil_72,
  t34.previous_france_visa_refusal AS previous_france_visa_refusal_73,
  t34.need_flat_mate AS need_flat_mate_74,
  t34.need_eu_card_health_insurance AS need_eu_card_health_insurance_75,
  t34.enable_relance_mail AS enable_relance_mail_76,
  t34.delete_reason AS delete_reason_77,
  t34.arriving_date AS arriving_date_78,
  t34.locale AS locale_79,
  t34.spoken_language AS spoken_language_80,
  t34.length_of_stay AS length_of_stay_81,
  t34.gender AS gender_82,
  t34.cgu AS cgu_83,
  t34.french_phone_number AS french_phone_number_84,
  t34.allow_edit_text AS allow_edit_text_85,
  t34.matomo_visitor_id AS matomo_visitor_id_86,
  t34.platform_services AS platform_services_87,
  t34.use_zendesk_form AS use_zendesk_form_88,
  t34.visa_pre_validation AS visa_pre_validation_89,
  t34.titre_sejour_validation AS titre_sejour_validation_90,
  t34.additional_services AS additional_services_91,
  t34.school_free_field AS school_free_field_92,
  t34.rating AS rating_93,
  t34.rating_comment AS rating_comment_94,
  t34.rating_date AS rating_date_95,
  t34.relance_unsubscribe_token AS relance_unsubscribe_token_96,
  t34.relance_subscribed AS relance_subscribed_97,
  t34.delete_token AS delete_token_98,
  t34.last_verified_at AS last_verified_at_99,
  t34.created_source AS created_source_100,
  t34.preferred_communication_method AS preferred_communication_method_101,
  t34.password2 AS password2_102,
  t34.unlock_cvec AS unlock_cvec_103,
  t34.no_appointment AS no_appointment_104,
  t34.created_at AS created_at_105,
  t34.updated_at AS updated_at_106,
  t34.supervisor AS supervisor_107,
  t34.thesis_funding AS thesis_funding_108,
  t34.thesis_funding_contract_type AS thesis_funding_contract_type_109,
  t34.numberAndNameOfStreet AS numberAndNameOfStreet_110,
  t34.zipCode AS zipCode_111,
  t34.city AS city_112,
  t34.payed_at AS payed_at_113,
  t34.payment_reference AS payment_reference_114,
  t34.payment_id AS payment_id_115,
  t34.school_id AS school_id_116,
  t34.school_track_id AS school_track_id_117,
  t34.sector_id AS sector_id_118,
  t34.accommodation_data_id AS accommodation_data_id_119,
  t34.bank_phone_home_insurance_data_id AS bank_phone_home_insurance_data_id_120,
  t34.visa_data_id AS visa_data_id_121,
  t34.health_insurance_data_id AS health_insurance_data_id_122,
  t34.electricity_data_id AS electricity_data_id_123,
  t34.metro_data_id AS metro_data_id_124,
  t34.caf_data_id AS caf_data_id_125,
  t34.visa_ofii_data_id AS visa_ofii_data_id_126,
  t34.titre_sejour_data_id AS titre_sejour_data_id_127,
  t34.renewal_metro_data_id AS renewal_metro_data_id_128,
  t34.certificate_data_id AS certificate_data_id_129,
  t34.cvec_data_id AS cvec_data_id_130,
  t34.before_leaving_data_id AS before_leaving_data_id_131,
  t34.private_health_insurance_data_id AS private_health_insurance_data_id_132,
  t34.bank_data_id AS bank_data_id_133,
  t34.home_insurance_data_id AS home_insurance_data_id_134,
  t34.phone_data_id AS phone_data_id_135,
  t34.student_city_id AS student_city_id_136,
  t34.school_bto_c_id AS school_bto_c_id_137,
  t34.roommate_data_id AS roommate_data_id_138,
  t34.translation_data_id AS translation_data_id_139,
  t34.welcome_pack_data_id AS welcome_pack_data_id_140,
  t34.meet_and_greet_data_id AS meet_and_greet_data_id_141,
  t34.student_buddy_data_id AS student_buddy_data_id_142,
  t34.school_appointment_data_id AS school_appointment_data_id_143,
  t34.welcome_day_data_id AS welcome_day_data_id_144,
  t34.private_insurance_data_id AS private_insurance_data_id_145,
  t34.french_class_enrollment_data_id AS french_class_enrollment_data_id_146,
  t34.composante_id AS composante_id_147,
  t34.program_id AS program_id_148,
  t34.referent_id AS referent_id_149,
  t34.laboratoire_id AS laboratoire_id_150,
  t34.doctoral_school_id AS doctoral_school_id_151
FROM
  visa_data t0
  LEFT JOIN student t34 ON t34.visa_data_id = t0.id
WHERE
  t0.id = ?

SELECT t0.state AS state_1, t0.validated_at AS validated_at_2, t0.invalidated_at AS invalidated_at_3, t0.message AS message_4, t0.service_history AS service_history_5, t0.invalid_history_state AS invalid_history_state_6, t0.valid_history_state AS valid_history_state_7, t0.id AS id_8, t0.created_account_from_etude_france AS created_account_from_etude_france_9, t0.campus_france_interview AS campus_france_interview_10, t0.visa_web_site_visited AS visa_web_site_visited_11, t0.bookedVisaCenter AS bookedVisaCenter_12, t0.visa_center_appointment_date AS visa_center_appointment_date_13, t0.visa_expiration_date AS visa_expiration_date_14, t0.visited_steps AS visited_steps_15, t0.documents_collected AS documents_collected_16, t0.current_step AS current_step_17, t0.cursus_beginning AS cursus_beginning_18, t0.cursus_ending AS cursus_ending_19, t0.admin_comment AS admin_comment_20, t0.document_ref_extra AS document_ref_extra_21, t0.late_attendance_date AS late_attendance_date_22, t0.visa_type AS visa_type_23, t0.campus_message AS campus_message_24, t0.mjm_enrollment_letter_unlocked_email_sent_at AS mjm_enrollment_letter_unlocked_email_sent_at_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.is_active AS is_active_28, t0.confidential_message AS confidential_message_29, t0.became_valid_at AS became_valid_at_30, t0.deletion_confirmed_at AS deletion_confirmed_at_31, t0.documents_deleted_at AS documents_deleted_at_32, t0.zone_id AS zone_id_33, t34.id AS id_35, t34.username AS username_36, t34.username_canonical AS username_canonical_37, t34.email AS email_38, t34.email_canonical AS email_canonical_39, t34.password AS password_40, t34.roles AS roles_41, t34.enabled AS enabled_42, t34.last_login AS last_login_43, t34.password_reset_token AS password_reset_token_44, t34.password_reset_token_expires_at AS password_reset_token_expires_at_45, t34.onboarded_at AS onboarded_at_46, t34.account_valid AS account_valid_47, t34.mail_sent_at AS mail_sent_at_48, t34.mail_relance_account_invalid_sent_at AS mail_relance_account_invalid_sent_at_49, t34.mail_relance_visa_sent_at AS mail_relance_visa_sent_at_50, t34.mail_relance_bank_sent_at AS mail_relance_bank_sent_at_51, t34.mail_warning_under_age_sent_at AS mail_warning_under_age_sent_at_52, t34.email2 AS email2_53, t34.firstName AS firstName_54, t34.lastName AS lastName_55, t34.birthDate AS birthDate_56, t34.phone AS phone_57, t34.nationality AS nationality_58, t34.countryVisaAsked AS countryVisaAsked_59, t34.cityVisaAsked AS cityVisaAsked_60, t34.enrollmentProgram AS enrollmentProgram_61, t34.startFranceCursus AS startFranceCursus_62, t34.endFranceCursus AS endFranceCursus_63, t34.flatNumber AS flatNumber_64, t34.buildingNumber AS buildingNumber_65, t34.country AS country_66, t34.delete_at AS delete_at_67, t34.activated_services AS activated_services_68, t34.cursus_month AS cursus_month_69, t34.cursus_year AS cursus_year_70, t34.show_profile AS show_profile_71, t34.accept_cnil AS accept_cnil_72, t34.previous_france_visa_refusal AS previous_france_visa_refusal_73, t34.need_flat_mate AS need_flat_mate_74, t34.need_eu_card_health_insurance AS need_eu_card_health_insurance_75, t34.enable_relance_mail AS enable_relance_mail_76, t34.delete_reason AS delete_reason_77, t34.arriving_date AS arriving_date_78, t34.locale AS locale_79, t34.spoken_language AS spoken_language_80, t34.length_of_stay AS length_of_stay_81, t34.gender AS gender_82, t34.cgu AS cgu_83, t34.french_phone_number AS french_phone_number_84, t34.allow_edit_text AS allow_edit_text_85, t34.matomo_visitor_id AS matomo_visitor_id_86, t34.platform_services AS platform_services_87, t34.use_zendesk_form AS use_zendesk_form_88, t34.visa_pre_validation AS visa_pre_validation_89, t34.titre_sejour_validation AS titre_sejour_validation_90, t34.additional_services AS additional_services_91, t34.school_free_field AS school_free_field_92, t34.rating AS rating_93, t34.rating_comment AS rating_comment_94, t34.rating_date AS rating_date_95, t34.relance_unsubscribe_token AS relance_unsubscribe_token_96, t34.relance_subscribed AS relance_subscribed_97, t34.delete_token AS delete_token_98, t34.last_verified_at AS last_verified_at_99, t34.created_source AS created_source_100, t34.preferred_communication_method AS preferred_communication_method_101, t34.password2 AS password2_102, t34.unlock_cvec AS unlock_cvec_103, t34.no_appointment AS no_appointment_104, t34.created_at AS created_at_105, t34.updated_at AS updated_at_106, t34.supervisor AS supervisor_107, t34.thesis_funding AS thesis_funding_108, t34.thesis_funding_contract_type AS thesis_funding_contract_type_109, t34.numberAndNameOfStreet AS numberAndNameOfStreet_110, t34.zipCode AS zipCode_111, t34.city AS city_112, t34.payed_at AS payed_at_113, t34.payment_reference AS payment_reference_114, t34.payment_id AS payment_id_115, t34.school_id AS school_id_116, t34.school_track_id AS school_track_id_117, t34.sector_id AS sector_id_118, t34.accommodation_data_id AS accommodation_data_id_119, t34.bank_phone_home_insurance_data_id AS bank_phone_home_insurance_data_id_120, t34.visa_data_id AS visa_data_id_121, t34.health_insurance_data_id AS health_insurance_data_id_122, t34.electricity_data_id AS electricity_data_id_123, t34.metro_data_id AS metro_data_id_124, t34.caf_data_id AS caf_data_id_125, t34.visa_ofii_data_id AS visa_ofii_data_id_126, t34.titre_sejour_data_id AS titre_sejour_data_id_127, t34.renewal_metro_data_id AS renewal_metro_data_id_128, t34.certificate_data_id AS certificate_data_id_129, t34.cvec_data_id AS cvec_data_id_130, t34.before_leaving_data_id AS before_leaving_data_id_131, t34.private_health_insurance_data_id AS private_health_insurance_data_id_132, t34.bank_data_id AS bank_data_id_133, t34.home_insurance_data_id AS home_insurance_data_id_134, t34.phone_data_id AS phone_data_id_135, t34.student_city_id AS student_city_id_136, t34.school_bto_c_id AS school_bto_c_id_137, t34.roommate_data_id AS roommate_data_id_138, t34.translation_data_id AS translation_data_id_139, t34.welcome_pack_data_id AS welcome_pack_data_id_140, t34.meet_and_greet_data_id AS meet_and_greet_data_id_141, t34.student_buddy_data_id AS student_buddy_data_id_142, t34.school_appointment_data_id AS school_appointment_data_id_143, t34.welcome_day_data_id AS welcome_day_data_id_144, t34.private_insurance_data_id AS private_insurance_data_id_145, t34.french_class_enrollment_data_id AS french_class_enrollment_data_id_146, t34.composante_id AS composante_id_147, t34.program_id AS program_id_148, t34.referent_id AS referent_id_149, t34.laboratoire_id AS laboratoire_id_150, t34.doctoral_school_id AS doctoral_school_id_151 FROM visa_data t0 LEFT JOIN student t34 ON t34.visa_data_id = t0.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.school_services AS school_services_3,
  t0.studapart_link AS studapart_link_4,
  t0.registration_code AS registration_code_5,
  t0.theme_folder AS theme_folder_6,
  t0.display_community AS display_community_7,
  t0.certificate_payant AS certificate_payant_8,
  t0.slug AS slug_9,
  t0.bank_email AS bank_email_10,
  t0.video_url AS video_url_11,
  t0.facebook_url AS facebook_url_12,
  t0.instagram_url AS instagram_url_13,
  t0.use_zendesk_form AS use_zendesk_form_14,
  t0.flatmate_box AS flatmate_box_15,
  t0.street AS street_16,
  t0.zip AS zip_17,
  t0.city AS city_18,
  t0.latitude AS latitude_19,
  t0.longitude AS longitude_20,
  t0.bank2_email AS bank2_email_21,
  t0.zendesk_tag AS zendesk_tag_22,
  t0.show_in_profile_bto_c AS show_in_profile_bto_c_23,
  t0.excluded_documents_ref AS excluded_documents_ref_24,
  t0.is_customer AS is_customer_25,
  t0.student_can_delete_account AS student_can_delete_account_26,
  t0.use_zendesk_form_bto_c AS use_zendesk_form_bto_c_27,
  t0.need_bphi_visa AS need_bphi_visa_28,
  t0.auth_type AS auth_type_29,
  t0.report AS report_30,
  t0.without_brevo_automation AS without_brevo_automation_31,
  t0.buddy_code AS buddy_code_32,
  t0.send_raspail_bank_email AS send_raspail_bank_email_33,
  t0.display_agent AS display_agent_34,
  t0.display_rating AS display_rating_35,
  t0.webinar_url AS webinar_url_36,
  t0.event_url AS event_url_37,
  t0.display_webinar AS display_webinar_38,
  t0.display_event AS display_event_39,
  t0.has_lcl_bank AS has_lcl_bank_40,
  t0.contact_for_buddy AS contact_for_buddy_41,
  t0.display_webinar_video AS display_webinar_video_42,
  t0.display_translation AS display_translation_43,
  t0.welcome_pack_delivery_point AS welcome_pack_delivery_point_44,
  t0.welcome_pack_email_recipient AS welcome_pack_email_recipient_45,
  t0.meet_and_greet_email_recipient AS meet_and_greet_email_recipient_46,
  t0.excluded_from_etude_france AS excluded_from_etude_france_47,
  t0.excluded_from_campus_france AS excluded_from_campus_france_48,
  t0.service_structure_id AS service_structure_id_49,
  t0.logo_id AS logo_id_50,
  t0.learn_french_section AS learn_french_section_51,
  t0.principal_school_id AS principal_school_id_52,
  t0.school_city_id AS school_city_id_53,
  t54.id AS id_55,
  t54.title AS title_56,
  t54.site AS site_57,
  t54.added_to_bto_c AS added_to_bto_c_58,
  t54.created_at AS created_at_59,
  t54.updated_at AS updated_at_60,
  t54.school_id AS school_id_61,
  t54.student_id AS student_id_62,
  t0.webinar_photo_en_id AS webinar_photo_en_id_63,
  t0.webinar_photo_fr_id AS webinar_photo_fr_id_64,
  t0.event_photo_en_id AS event_photo_en_id_65,
  t0.event_photo_fr_id AS event_photo_fr_id_66
FROM
  school t0
  LEFT JOIN school_free_field t54 ON t54.school_id = t0.id
  INNER JOIN student_school ON t0.id = student_school.school_id
WHERE
  student_school.student_id = ?
  AND (
    (t0.slug != 'ifa-french-tech')
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.school_services AS school_services_3, t0.studapart_link AS studapart_link_4, t0.registration_code AS registration_code_5, t0.theme_folder AS theme_folder_6, t0.display_community AS display_community_7, t0.certificate_payant AS certificate_payant_8, t0.slug AS slug_9, t0.bank_email AS bank_email_10, t0.video_url AS video_url_11, t0.facebook_url AS facebook_url_12, t0.instagram_url AS instagram_url_13, t0.use_zendesk_form AS use_zendesk_form_14, t0.flatmate_box AS flatmate_box_15, t0.street AS street_16, t0.zip AS zip_17, t0.city AS city_18, t0.latitude AS latitude_19, t0.longitude AS longitude_20, t0.bank2_email AS bank2_email_21, t0.zendesk_tag AS zendesk_tag_22, t0.show_in_profile_bto_c AS show_in_profile_bto_c_23, t0.excluded_documents_ref AS excluded_documents_ref_24, t0.is_customer AS is_customer_25, t0.student_can_delete_account AS student_can_delete_account_26, t0.use_zendesk_form_bto_c AS use_zendesk_form_bto_c_27, t0.need_bphi_visa AS need_bphi_visa_28, t0.auth_type AS auth_type_29, t0.report AS report_30, t0.without_brevo_automation AS without_brevo_automation_31, t0.buddy_code AS buddy_code_32, t0.send_raspail_bank_email AS send_raspail_bank_email_33, t0.display_agent AS display_agent_34, t0.display_rating AS display_rating_35, t0.webinar_url AS webinar_url_36, t0.event_url AS event_url_37, t0.display_webinar AS display_webinar_38, t0.display_event AS display_event_39, t0.has_lcl_bank AS has_lcl_bank_40, t0.contact_for_buddy AS contact_for_buddy_41, t0.display_webinar_video AS display_webinar_video_42, t0.display_translation AS display_translation_43, t0.welcome_pack_delivery_point AS welcome_pack_delivery_point_44, t0.welcome_pack_email_recipient AS welcome_pack_email_recipient_45, t0.meet_and_greet_email_recipient AS meet_and_greet_email_recipient_46, t0.excluded_from_etude_france AS excluded_from_etude_france_47, t0.excluded_from_campus_france AS excluded_from_campus_france_48, t0.service_structure_id AS service_structure_id_49, t0.logo_id AS logo_id_50, t0.learn_french_section AS learn_french_section_51, t0.principal_school_id AS principal_school_id_52, t0.school_city_id AS school_city_id_53, t54.id AS id_55, t54.title AS title_56, t54.site AS site_57, t54.added_to_bto_c AS added_to_bto_c_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.school_id AS school_id_61, t54.student_id AS student_id_62, t0.webinar_photo_en_id AS webinar_photo_en_id_63, t0.webinar_photo_fr_id AS webinar_photo_fr_id_64, t0.event_photo_en_id AS event_photo_en_id_65, t0.event_photo_fr_id AS event_photo_fr_id_66 FROM school t0 LEFT JOIN school_free_field t54 ON t54.school_id = t0.id INNER JOIN student_school ON t0.id = student_school.school_id WHERE student_school.student_id = 2 AND ((t0.slug != 'ifa-french-tech'));