Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.cin AS cin_7,
  t0.tel AS tel_8,
  t0.birthday AS birthday_9,
  t0.status AS status_10,
  t0.photo AS photo_11,
  t0.cin_path AS cin_path_12,
  t13.id AS id_14,
  t13.grade AS grade_15,
  t13.created_at AS created_at_16,
  t13.updated_at AS updated_at_17,
  t13.origin_institute AS origin_institute_18,
  t13.is_intern AS is_intern_19,
  t13.correspond_email AS correspond_email_20,
  t13.departement_id AS departement_id_21,
  t13.user_id AS user_id_22,
  t23.id AS id_24,
  t23.code_iav AS code_iav_25,
  t23.titre_these AS titre_these_26,
  t23.created_at AS created_at_27,
  t23.updated_at AS updated_at_28,
  t23.lieu_naissance AS lieu_naissance_29,
  t23.sexe AS sexe_30,
  t23.nationalite AS nationalite_31,
  t23.code_carte_sejour AS code_carte_sejour_32,
  t23.cne AS cne_33,
  t23.adresse AS adresse_34,
  t23.status AS status_35,
  t23.email_recommandation AS email_recommandation_36,
  t23.other_phd AS other_phd_37,
  t23.other_institution AS other_institution_38,
  t23.annee_inscription AS annee_inscription_39,
  t23.institution AS institution_40,
  t23.other_annee AS other_annee_41,
  t23.cv_path AS cv_path_42,
  t23.is_update AS is_update_43,
  t23.deactivated_at AS deactivated_at_44,
  t23.encadrant_id AS encadrant_id_45,
  t23.user_id AS user_id_46,
  t23.domaine_id AS domaine_id_47,
  t23.unite_recherche_id AS unite_recherche_id_48,
  t23.deactivated_by_id AS deactivated_by_id_49
FROM
  user t0
  LEFT JOIN professeur t13 ON t13.user_id = t0.id
  LEFT JOIN doctorant t23 ON t23.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.cin AS cin_7, t0.tel AS tel_8, t0.birthday AS birthday_9, t0.status AS status_10, t0.photo AS photo_11, t0.cin_path AS cin_path_12, t13.id AS id_14, t13.grade AS grade_15, t13.created_at AS created_at_16, t13.updated_at AS updated_at_17, t13.origin_institute AS origin_institute_18, t13.is_intern AS is_intern_19, t13.correspond_email AS correspond_email_20, t13.departement_id AS departement_id_21, t13.user_id AS user_id_22, t23.id AS id_24, t23.code_iav AS code_iav_25, t23.titre_these AS titre_these_26, t23.created_at AS created_at_27, t23.updated_at AS updated_at_28, t23.lieu_naissance AS lieu_naissance_29, t23.sexe AS sexe_30, t23.nationalite AS nationalite_31, t23.code_carte_sejour AS code_carte_sejour_32, t23.cne AS cne_33, t23.adresse AS adresse_34, t23.status AS status_35, t23.email_recommandation AS email_recommandation_36, t23.other_phd AS other_phd_37, t23.other_institution AS other_institution_38, t23.annee_inscription AS annee_inscription_39, t23.institution AS institution_40, t23.other_annee AS other_annee_41, t23.cv_path AS cv_path_42, t23.is_update AS is_update_43, t23.deactivated_at AS deactivated_at_44, t23.encadrant_id AS encadrant_id_45, t23.user_id AS user_id_46, t23.domaine_id AS domaine_id_47, t23.unite_recherche_id AS unite_recherche_id_48, t23.deactivated_by_id AS deactivated_by_id_49 FROM user t0 LEFT JOIN professeur t13 ON t13.user_id = t0.id LEFT JOIN doctorant t23 ON t23.user_id = t0.id WHERE t0.id = 298;

SELECT
  t0.id AS id_1,
  t0.resume AS resume_2,
  t0.objectif AS objectif_3,
  t0.justification AS justification_4,
  t0.text AS text_5,
  t0.planing AS planing_6,
  t0.reference AS reference_7,
  t0.financement AS financement_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.these AS these_11,
  t0.status AS status_12,
  t0.rapport_comite AS rapport_comite_13,
  t0.rapport_plagiat AS rapport_plagiat_14,
  t0.inscription_id AS inscription_id_15,
  t0.doctorant_id AS doctorant_id_16,
  t0.depot_dossier_id AS depot_dossier_id_17
FROM
  these_doc t0
WHERE
  t0.doctorant_id = ?

SELECT t0.id AS id_1, t0.resume AS resume_2, t0.objectif AS objectif_3, t0.justification AS justification_4, t0.text AS text_5, t0.planing AS planing_6, t0.reference AS reference_7, t0.financement AS financement_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.these AS these_11, t0.status AS status_12, t0.rapport_comite AS rapport_comite_13, t0.rapport_plagiat AS rapport_plagiat_14, t0.inscription_id AS inscription_id_15, t0.doctorant_id AS doctorant_id_16, t0.depot_dossier_id AS depot_dossier_id_17 FROM these_doc t0 WHERE t0.doctorant_id = 61;

SELECT
  t0.id AS id_1,
  t0.directeur AS directeur_2,
  t0.directeur_grade AS directeur_grade_3,
  t0.directeur_unite AS directeur_unite_4,
  t0.directeur_institution AS directeur_institution_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.courriel AS courriel_8,
  t0.doctorant_id AS doctorant_id_9,
  t0.inscription_id AS inscription_id_10
FROM
  comite_these_doctorant t0
WHERE
  t0.doctorant_id = ?

SELECT t0.id AS id_1, t0.directeur AS directeur_2, t0.directeur_grade AS directeur_grade_3, t0.directeur_unite AS directeur_unite_4, t0.directeur_institution AS directeur_institution_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.courriel AS courriel_8, t0.doctorant_id AS doctorant_id_9, t0.inscription_id AS inscription_id_10 FROM comite_these_doctorant t0 WHERE t0.doctorant_id = 61;

SELECT
  count(p0_.id) AS sclr_0
FROM
  paiment p0_
WHERE
  p0_.doctorant_id = ?
  AND p0_.statut <> 9

SELECT count(p0_.id) AS sclr_0 FROM paiment p0_ WHERE p0_.doctorant_id = 61 AND p0_.statut <> 9;

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.national AS national_2,
  p0_.nature AS nature_3,
  p0_.date AS date_4,
  p0_.comments AS comments_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7,
  p0_.statut AS statut_8,
  p0_.doctorant_id AS doctorant_id_9,
  p0_.depot_dossier_id AS depot_dossier_id_10
FROM
  part_journee_seminaire p0_
WHERE
  p0_.statut <> 9
  AND p0_.doctorant_id = ?
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.national AS national_2, p0_.nature AS nature_3, p0_.date AS date_4, p0_.comments AS comments_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.statut AS statut_8, p0_.doctorant_id AS doctorant_id_9, p0_.depot_dossier_id AS depot_dossier_id_10 FROM part_journee_seminaire p0_ WHERE p0_.statut <> 9 AND p0_.doctorant_id = 61 ORDER BY p0_.id DESC;

SELECT
  s0_.id AS id_0,
  s0_.organisateur AS organisateur_1,
  s0_.attestation AS attestation_2,
  s0_.status AS status_3,
  s0_.created_at AS created_at_4,
  s0_.updeated_at AS updeated_at_5,
  s0_.doctorant_id AS doctorant_id_6,
  s0_.depot_dossier_id AS depot_dossier_id_7
FROM
  seminaire_redaction_scientifique s0_
WHERE
  s0_.status <> 9
  AND s0_.doctorant_id = ?
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.organisateur AS organisateur_1, s0_.attestation AS attestation_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updeated_at AS updeated_at_5, s0_.doctorant_id AS doctorant_id_6, s0_.depot_dossier_id AS depot_dossier_id_7 FROM seminaire_redaction_scientifique s0_ WHERE s0_.status <> 9 AND s0_.doctorant_id = 61 ORDER BY s0_.id DESC;

SELECT
  count(a0_.id) AS sclr_0
FROM
  article a0_
WHERE
  a0_.doctorant_id = ?
  AND a0_.status <> 9

SELECT count(a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.doctorant_id = 61 AND a0_.status <> 9;

SELECT
  t0.id AS id_1,
  t0.start_inscriptions AS start_inscriptions_2,
  t0.end_inscriptions AS end_inscriptions_3,
  t0.statut AS statut_4,
  t0.charte AS charte_5,
  t0.declaration AS declaration_6,
  t0.start_reinscription AS start_reinscription_7,
  t0.end_reinscription AS end_reinscription_8,
  t0.start_inscriptions_traitement AS start_inscriptions_traitement_9,
  t0.end_inscriptions_traitement AS end_inscriptions_traitement_10,
  t0.start_reinscription_traitement AS start_reinscription_traitement_11,
  t0.end_reinscription_traitement AS end_reinscription_traitement_12,
  t0.annee_academique AS annee_academique_13
FROM
  settings t0
WHERE
  t0.statut = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.start_inscriptions AS start_inscriptions_2, t0.end_inscriptions AS end_inscriptions_3, t0.statut AS statut_4, t0.charte AS charte_5, t0.declaration AS declaration_6, t0.start_reinscription AS start_reinscription_7, t0.end_reinscription AS end_reinscription_8, t0.start_inscriptions_traitement AS start_inscriptions_traitement_9, t0.end_inscriptions_traitement AS end_inscriptions_traitement_10, t0.start_reinscription_traitement AS start_reinscription_traitement_11, t0.end_reinscription_traitement AS end_reinscription_traitement_12, t0.annee_academique AS annee_academique_13 FROM settings t0 WHERE t0.statut = '1' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.validation_prof AS validation_prof_3,
  t0.validation_admin AS validation_admin_4,
  t0.validation_responsable AS validation_responsable_5,
  t0.note_prof AS note_prof_6,
  t0.note_admin AS note_admin_7,
  t0.note_responsable AS note_responsable_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.statut_final AS statut_final_11,
  t0.validation_responsable_unite_recherche AS validation_responsable_unite_recherche_12,
  t0.note_responsable_unite_recherche AS note_responsable_unite_recherche_13,
  t0.validation_docs AS validation_docs_14,
  t0.docs_note AS docs_note_15,
  t0.acceptation_domaine AS acceptation_domaine_16,
  t0.note_domaine AS note_domaine_17,
  t0.situation_candidat AS situation_candidat_18,
  t0.autorise AS autorise_19,
  t0.financement_recherche AS financement_recherche_20,
  t0.autrefinancement AS autrefinancement_21,
  t0.paid AS paid_22,
  t0.doctorant_id AS doctorant_id_23,
  t0.domaine_id AS domaine_id_24,
  t0.unite_recherche_id AS unite_recherche_id_25,
  t26.id AS id_27,
  t26.resume AS resume_28,
  t26.objectif AS objectif_29,
  t26.justification AS justification_30,
  t26.text AS text_31,
  t26.planing AS planing_32,
  t26.reference AS reference_33,
  t26.financement AS financement_34,
  t26.created_at AS created_at_35,
  t26.updated_at AS updated_at_36,
  t26.these AS these_37,
  t26.status AS status_38,
  t26.rapport_comite AS rapport_comite_39,
  t26.rapport_plagiat AS rapport_plagiat_40,
  t26.inscription_id AS inscription_id_41,
  t26.doctorant_id AS doctorant_id_42,
  t26.depot_dossier_id AS depot_dossier_id_43,
  t44.id AS id_45,
  t44.directeur AS directeur_46,
  t44.directeur_grade AS directeur_grade_47,
  t44.directeur_unite AS directeur_unite_48,
  t44.directeur_institution AS directeur_institution_49,
  t44.created_at AS created_at_50,
  t44.updated_at AS updated_at_51,
  t44.courriel AS courriel_52,
  t44.doctorant_id AS doctorant_id_53,
  t44.inscription_id AS inscription_id_54,
  t0.oral_validation_by_id AS oral_validation_by_id_55
FROM
  inscription_doctorant t0
  LEFT JOIN these_doc t26 ON t26.inscription_id = t0.id
  LEFT JOIN comite_these_doctorant t44 ON t44.inscription_id = t0.id
WHERE
  t0.doctorant_id = ?

SELECT t0.id AS id_1, t0.year AS year_2, t0.validation_prof AS validation_prof_3, t0.validation_admin AS validation_admin_4, t0.validation_responsable AS validation_responsable_5, t0.note_prof AS note_prof_6, t0.note_admin AS note_admin_7, t0.note_responsable AS note_responsable_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.statut_final AS statut_final_11, t0.validation_responsable_unite_recherche AS validation_responsable_unite_recherche_12, t0.note_responsable_unite_recherche AS note_responsable_unite_recherche_13, t0.validation_docs AS validation_docs_14, t0.docs_note AS docs_note_15, t0.acceptation_domaine AS acceptation_domaine_16, t0.note_domaine AS note_domaine_17, t0.situation_candidat AS situation_candidat_18, t0.autorise AS autorise_19, t0.financement_recherche AS financement_recherche_20, t0.autrefinancement AS autrefinancement_21, t0.paid AS paid_22, t0.doctorant_id AS doctorant_id_23, t0.domaine_id AS domaine_id_24, t0.unite_recherche_id AS unite_recherche_id_25, t26.id AS id_27, t26.resume AS resume_28, t26.objectif AS objectif_29, t26.justification AS justification_30, t26.text AS text_31, t26.planing AS planing_32, t26.reference AS reference_33, t26.financement AS financement_34, t26.created_at AS created_at_35, t26.updated_at AS updated_at_36, t26.these AS these_37, t26.status AS status_38, t26.rapport_comite AS rapport_comite_39, t26.rapport_plagiat AS rapport_plagiat_40, t26.inscription_id AS inscription_id_41, t26.doctorant_id AS doctorant_id_42, t26.depot_dossier_id AS depot_dossier_id_43, t44.id AS id_45, t44.directeur AS directeur_46, t44.directeur_grade AS directeur_grade_47, t44.directeur_unite AS directeur_unite_48, t44.directeur_institution AS directeur_institution_49, t44.created_at AS created_at_50, t44.updated_at AS updated_at_51, t44.courriel AS courriel_52, t44.doctorant_id AS doctorant_id_53, t44.inscription_id AS inscription_id_54, t0.oral_validation_by_id AS oral_validation_by_id_55 FROM inscription_doctorant t0 LEFT JOIN these_doc t26 ON t26.inscription_id = t0.id LEFT JOIN comite_these_doctorant t44 ON t44.inscription_id = t0.id WHERE t0.doctorant_id = 61;

SELECT
  t0.id AS id_1,
  t0.situation_administrative AS situation_administrative_2,
  t0.boursier AS boursier_3,
  t0.etablissement_travail AS etablissement_travail_4,
  t0.type_bourse AS type_bourse_5,
  t0.these_en_cotutelle AS these_en_cotutelle_6,
  t0.etablissement_partenaire AS etablissement_partenaire_7,
  t0.year AS year_8,
  t0.annee_these AS annee_these_9,
  t0.presentation_orale AS presentation_orale_10,
  t0.demarche_intellectuelle AS demarche_intellectuelle_11,
  t0.reponses_questions AS reponses_questions_12,
  t0.propositions AS propositions_13,
  t0.travaux_realises AS travaux_realises_14,
  t0.validation_encadrant AS validation_encadrant_15,
  t0.note_encadrant AS note_encadrant_16,
  t0.validation_dir_cedoc AS validation_dir_cedoc_17,
  t0.note_dir_cedoc AS note_dir_cedoc_18,
  t0.validatio_dir_iav AS validatio_dir_iav_19,
  t0.note_dir_iav AS note_dir_iav_20,
  t0.publications_et_communications AS publications_et_communications_21,
  t0.statut AS statut_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.financement AS financement_25,
  t0.prolongation AS prolongation_26,
  t0.demande_signee AS demande_signee_27,
  t0.paid AS paid_28,
  t0.doctorant_id AS doctorant_id_29,
  t0.validated_by_id AS validated_by_id_30
FROM
  reinscription_doctorant t0
WHERE
  t0.doctorant_id = ?

SELECT t0.id AS id_1, t0.situation_administrative AS situation_administrative_2, t0.boursier AS boursier_3, t0.etablissement_travail AS etablissement_travail_4, t0.type_bourse AS type_bourse_5, t0.these_en_cotutelle AS these_en_cotutelle_6, t0.etablissement_partenaire AS etablissement_partenaire_7, t0.year AS year_8, t0.annee_these AS annee_these_9, t0.presentation_orale AS presentation_orale_10, t0.demarche_intellectuelle AS demarche_intellectuelle_11, t0.reponses_questions AS reponses_questions_12, t0.propositions AS propositions_13, t0.travaux_realises AS travaux_realises_14, t0.validation_encadrant AS validation_encadrant_15, t0.note_encadrant AS note_encadrant_16, t0.validation_dir_cedoc AS validation_dir_cedoc_17, t0.note_dir_cedoc AS note_dir_cedoc_18, t0.validatio_dir_iav AS validatio_dir_iav_19, t0.note_dir_iav AS note_dir_iav_20, t0.publications_et_communications AS publications_et_communications_21, t0.statut AS statut_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.financement AS financement_25, t0.prolongation AS prolongation_26, t0.demande_signee AS demande_signee_27, t0.paid AS paid_28, t0.doctorant_id AS doctorant_id_29, t0.validated_by_id AS validated_by_id_30 FROM reinscription_doctorant t0 WHERE t0.doctorant_id = 61;

SELECT
  t0.id AS id_1,
  t0.start_inscriptions AS start_inscriptions_2,
  t0.end_inscriptions AS end_inscriptions_3,
  t0.statut AS statut_4,
  t0.charte AS charte_5,
  t0.declaration AS declaration_6,
  t0.start_reinscription AS start_reinscription_7,
  t0.end_reinscription AS end_reinscription_8,
  t0.start_inscriptions_traitement AS start_inscriptions_traitement_9,
  t0.end_inscriptions_traitement AS end_inscriptions_traitement_10,
  t0.start_reinscription_traitement AS start_reinscription_traitement_11,
  t0.end_reinscription_traitement AS end_reinscription_traitement_12,
  t0.annee_academique AS annee_academique_13
FROM
  settings t0
WHERE
  t0.statut = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.start_inscriptions AS start_inscriptions_2, t0.end_inscriptions AS end_inscriptions_3, t0.statut AS statut_4, t0.charte AS charte_5, t0.declaration AS declaration_6, t0.start_reinscription AS start_reinscription_7, t0.end_reinscription AS end_reinscription_8, t0.start_inscriptions_traitement AS start_inscriptions_traitement_9, t0.end_inscriptions_traitement AS end_inscriptions_traitement_10, t0.start_reinscription_traitement AS start_reinscription_traitement_11, t0.end_reinscription_traitement AS end_reinscription_traitement_12, t0.annee_academique AS annee_academique_13 FROM settings t0 WHERE t0.statut = '1' LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.situation_administrative AS situation_administrative_1,
  r0_.boursier AS boursier_2,
  r0_.etablissement_travail AS etablissement_travail_3,
  r0_.type_bourse AS type_bourse_4,
  r0_.these_en_cotutelle AS these_en_cotutelle_5,
  r0_.etablissement_partenaire AS etablissement_partenaire_6,
  r0_.year AS year_7,
  r0_.annee_these AS annee_these_8,
  r0_.presentation_orale AS presentation_orale_9,
  r0_.demarche_intellectuelle AS demarche_intellectuelle_10,
  r0_.reponses_questions AS reponses_questions_11,
  r0_.propositions AS propositions_12,
  r0_.travaux_realises AS travaux_realises_13,
  r0_.validation_encadrant AS validation_encadrant_14,
  r0_.note_encadrant AS note_encadrant_15,
  r0_.validation_dir_cedoc AS validation_dir_cedoc_16,
  r0_.note_dir_cedoc AS note_dir_cedoc_17,
  r0_.validatio_dir_iav AS validatio_dir_iav_18,
  r0_.note_dir_iav AS note_dir_iav_19,
  r0_.publications_et_communications AS publications_et_communications_20,
  r0_.statut AS statut_21,
  r0_.created_at AS created_at_22,
  r0_.updated_at AS updated_at_23,
  r0_.financement AS financement_24,
  r0_.prolongation AS prolongation_25,
  r0_.demande_signee AS demande_signee_26,
  r0_.paid AS paid_27,
  r0_.doctorant_id AS doctorant_id_28,
  r0_.validated_by_id AS validated_by_id_29
FROM
  reinscription_doctorant r0_
WHERE
  r0_.doctorant_id = ?
  AND r0_.year = ?
  AND r0_.statut <> 9

SELECT r0_.id AS id_0, r0_.situation_administrative AS situation_administrative_1, r0_.boursier AS boursier_2, r0_.etablissement_travail AS etablissement_travail_3, r0_.type_bourse AS type_bourse_4, r0_.these_en_cotutelle AS these_en_cotutelle_5, r0_.etablissement_partenaire AS etablissement_partenaire_6, r0_.year AS year_7, r0_.annee_these AS annee_these_8, r0_.presentation_orale AS presentation_orale_9, r0_.demarche_intellectuelle AS demarche_intellectuelle_10, r0_.reponses_questions AS reponses_questions_11, r0_.propositions AS propositions_12, r0_.travaux_realises AS travaux_realises_13, r0_.validation_encadrant AS validation_encadrant_14, r0_.note_encadrant AS note_encadrant_15, r0_.validation_dir_cedoc AS validation_dir_cedoc_16, r0_.note_dir_cedoc AS note_dir_cedoc_17, r0_.validatio_dir_iav AS validatio_dir_iav_18, r0_.note_dir_iav AS note_dir_iav_19, r0_.publications_et_communications AS publications_et_communications_20, r0_.statut AS statut_21, r0_.created_at AS created_at_22, r0_.updated_at AS updated_at_23, r0_.financement AS financement_24, r0_.prolongation AS prolongation_25, r0_.demande_signee AS demande_signee_26, r0_.paid AS paid_27, r0_.doctorant_id AS doctorant_id_28, r0_.validated_by_id AS validated_by_id_29 FROM reinscription_doctorant r0_ WHERE r0_.doctorant_id = 61 AND r0_.year = '2025/2026' AND r0_.statut <> 9;

SELECT
  r0_.id AS id_0,
  r0_.auteur AS auteur_1,
  r0_.annee AS annee_2,
  r0_.titre AS titre_3,
  r0_.volume AS volume_4,
  r0_.categorie AS categorie_5,
  r0_.journal AS journal_6,
  r0_.revue AS revue_7,
  r0_.statut AS statut_8,
  r0_.created_at AS created_at_9,
  r0_.updated_at AS updated_at_10,
  r0_.doctorant_id AS doctorant_id_11,
  r0_.reinscription_doctorant_id AS reinscription_doctorant_id_12,
  r0_.depot_dossier_id AS depot_dossier_id_13
FROM
  revues_doctorant r0_
  INNER JOIN reinscription_doctorant r1_ ON r0_.reinscription_doctorant_id = r1_.id
WHERE
  r0_.statut <> 9
  AND r1_.statut <> 9
  AND r0_.doctorant_id = ?
  AND r0_.reinscription_doctorant_id = ?
ORDER BY
  r0_.id DESC

SELECT r0_.id AS id_0, r0_.auteur AS auteur_1, r0_.annee AS annee_2, r0_.titre AS titre_3, r0_.volume AS volume_4, r0_.categorie AS categorie_5, r0_.journal AS journal_6, r0_.revue AS revue_7, r0_.statut AS statut_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, r0_.doctorant_id AS doctorant_id_11, r0_.reinscription_doctorant_id AS reinscription_doctorant_id_12, r0_.depot_dossier_id AS depot_dossier_id_13 FROM revues_doctorant r0_ INNER JOIN reinscription_doctorant r1_ ON r0_.reinscription_doctorant_id = r1_.id WHERE r0_.statut <> 9 AND r1_.statut <> 9 AND r0_.doctorant_id = 61 AND r0_.reinscription_doctorant_id = 454 ORDER BY r0_.id DESC;

SELECT
  b0_.id AS id_0,
  b0_.equipe AS equipe_1,
  b0_.n_brevet AS n_brevet_2,
  b0_.annee AS annee_3,
  b0_.type AS type_4,
  b0_.status AS status_5,
  b0_.created_at AS created_at_6,
  b0_.updated_at AS updated_at_7,
  b0_.statut AS statut_8,
  b0_.titre AS titre_9,
  b0_.reinscription_id AS reinscription_id_10,
  b0_.doctorant_id AS doctorant_id_11,
  b0_.depot_dossier_id AS depot_dossier_id_12
FROM
  brevet_doctorant b0_
WHERE
  b0_.statut <> 9
  AND b0_.doctorant_id = ?
  AND b0_.reinscription_id = ?
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.equipe AS equipe_1, b0_.n_brevet AS n_brevet_2, b0_.annee AS annee_3, b0_.type AS type_4, b0_.status AS status_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.statut AS statut_8, b0_.titre AS titre_9, b0_.reinscription_id AS reinscription_id_10, b0_.doctorant_id AS doctorant_id_11, b0_.depot_dossier_id AS depot_dossier_id_12 FROM brevet_doctorant b0_ WHERE b0_.statut <> 9 AND b0_.doctorant_id = 61 AND b0_.reinscription_id = 454 ORDER BY b0_.id DESC;

SELECT
  c0_.id AS id_0,
  c0_.auteur AS auteur_1,
  c0_.year AS year_2,
  c0_.type AS type_3,
  c0_.conference AS conference_4,
  c0_.organisateur AS organisateur_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.form AS form_8,
  c0_.titre AS titre_9,
  c0_.statut AS statut_10,
  c0_.doctorant_id AS doctorant_id_11,
  c0_.reinscription_id AS reinscription_id_12,
  c0_.depot_dossier_id AS depot_dossier_id_13
FROM
  conference_doctorant c0_
WHERE
  c0_.statut <> 9
  AND c0_.doctorant_id = ?
  AND c0_.reinscription_id = ?
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.auteur AS auteur_1, c0_.year AS year_2, c0_.type AS type_3, c0_.conference AS conference_4, c0_.organisateur AS organisateur_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.form AS form_8, c0_.titre AS titre_9, c0_.statut AS statut_10, c0_.doctorant_id AS doctorant_id_11, c0_.reinscription_id AS reinscription_id_12, c0_.depot_dossier_id AS depot_dossier_id_13 FROM conference_doctorant c0_ WHERE c0_.statut <> 9 AND c0_.doctorant_id = 61 AND c0_.reinscription_id = 454 ORDER BY c0_.id DESC;

SELECT
  o0_.id AS id_0,
  o0_.auteur AS auteur_1,
  o0_.year AS year_2,
  o0_.type AS type_3,
  o0_.titre AS titre_4,
  o0_.chapitre AS chapitre_5,
  o0_.edition AS edition_6,
  o0_.created_at AS created_at_7,
  o0_.updated_at AS updated_at_8,
  o0_.statut AS statut_9,
  o0_.doctorant_id AS doctorant_id_10,
  o0_.reinscription_id AS reinscription_id_11,
  o0_.depot_dossier_id AS depot_dossier_id_12
FROM
  ouvrage_doctorant o0_
WHERE
  o0_.statut <> 9
  AND o0_.doctorant_id = ?
  AND o0_.reinscription_id = ?
ORDER BY
  o0_.id DESC

SELECT o0_.id AS id_0, o0_.auteur AS auteur_1, o0_.year AS year_2, o0_.type AS type_3, o0_.titre AS titre_4, o0_.chapitre AS chapitre_5, o0_.edition AS edition_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.statut AS statut_9, o0_.doctorant_id AS doctorant_id_10, o0_.reinscription_id AS reinscription_id_11, o0_.depot_dossier_id AS depot_dossier_id_12 FROM ouvrage_doctorant o0_ WHERE o0_.statut <> 9 AND o0_.doctorant_id = 61 AND o0_.reinscription_id = 454 ORDER BY o0_.id DESC;

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.annee AS annee_2,
  p0_.lieu AS lieu_3,
  p0_.organisateur AS organisateur_4,
  p0_.resume AS resume_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7,
  p0_.statut AS statut_8,
  p0_.doctorant_id AS doctorant_id_9,
  p0_.reinscription_id AS reinscription_id_10
FROM
  participation p0_
WHERE
  p0_.statut <> 9
  AND p0_.doctorant_id = ?
  AND p0_.reinscription_id = ?
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.annee AS annee_2, p0_.lieu AS lieu_3, p0_.organisateur AS organisateur_4, p0_.resume AS resume_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.statut AS statut_8, p0_.doctorant_id AS doctorant_id_9, p0_.reinscription_id AS reinscription_id_10 FROM participation p0_ WHERE p0_.statut <> 9 AND p0_.doctorant_id = 61 AND p0_.reinscription_id = 454 ORDER BY p0_.id DESC;

SELECT
  s0_.id AS id_0,
  s0_.structure AS structure_1,
  s0_.lieu AS lieu_2,
  s0_.duree AS duree_3,
  s0_.periode AS periode_4,
  s0_.financement AS financement_5,
  s0_.objectifs AS objectifs_6,
  s0_.statut AS statut_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9,
  s0_.comments AS comments_10,
  s0_.doctorant_id AS doctorant_id_11,
  s0_.reinscription_id AS reinscription_id_12,
  s0_.depot_dossier_id AS depot_dossier_id_13
FROM
  stage_doctorant s0_
WHERE
  s0_.statut <> 9
  AND s0_.doctorant_id = ?
  AND s0_.reinscription_id = ?
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.structure AS structure_1, s0_.lieu AS lieu_2, s0_.duree AS duree_3, s0_.periode AS periode_4, s0_.financement AS financement_5, s0_.objectifs AS objectifs_6, s0_.statut AS statut_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.comments AS comments_10, s0_.doctorant_id AS doctorant_id_11, s0_.reinscription_id AS reinscription_id_12, s0_.depot_dossier_id AS depot_dossier_id_13 FROM stage_doctorant s0_ WHERE s0_.statut <> 9 AND s0_.doctorant_id = 61 AND s0_.reinscription_id = 454 ORDER BY s0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.directeur AS directeur_2,
  t0.directeur_grade AS directeur_grade_3,
  t0.directeur_unite AS directeur_unite_4,
  t0.directeur_institution AS directeur_institution_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.courriel AS courriel_8,
  t0.doctorant_id AS doctorant_id_9,
  t0.inscription_id AS inscription_id_10
FROM
  comite_these_doctorant t0
WHERE
  t0.doctorant_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.directeur AS directeur_2, t0.directeur_grade AS directeur_grade_3, t0.directeur_unite AS directeur_unite_4, t0.directeur_institution AS directeur_institution_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.courriel AS courriel_8, t0.doctorant_id AS doctorant_id_9, t0.inscription_id AS inscription_id_10 FROM comite_these_doctorant t0 WHERE t0.doctorant_id = 61 LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.full_name AS full_name_1,
  p0_.grade AS grade_2,
  p0_.courriel AS courriel_3,
  p0_.institution AS institution_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6,
  p0_.statut AS statut_7,
  p0_.prof_order AS prof_order_8,
  p0_.comite_these_doctorant_id AS comite_these_doctorant_id_9
FROM
  professeur_comite_these_doctorant p0_
WHERE
  p0_.statut <> 9
  AND p0_.comite_these_doctorant_id = ?

SELECT p0_.id AS id_0, p0_.full_name AS full_name_1, p0_.grade AS grade_2, p0_.courriel AS courriel_3, p0_.institution AS institution_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.statut AS statut_7, p0_.prof_order AS prof_order_8, p0_.comite_these_doctorant_id AS comite_these_doctorant_id_9 FROM professeur_comite_these_doctorant p0_ WHERE p0_.statut <> 9 AND p0_.comite_these_doctorant_id = 201;