Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.raison_sociale AS raison_sociale_2,
  t0.gerant AS gerant_3,
  t0.adresse_installation AS adresse_installation_4,
  t0.compl_adresse_installation AS compl_adresse_installation_5,
  t0.cp_installation AS cp_installation_6,
  t0.ville_installation AS ville_installation_7,
  t0.adresse_siege_social AS adresse_siege_social_8,
  t0.compl_adresse_siege_social AS compl_adresse_siege_social_9,
  t0.cp_siege_social AS cp_siege_social_10,
  t0.ville_siege_social AS ville_siege_social_11,
  t0.numero_agrement AS numero_agrement_12,
  t0.date_agrement AS date_agrement_13,
  t0.telephone AS telephone_14,
  t0.email AS email_15,
  t0.nbr_effectif_total AS nbr_effectif_total_16,
  t0.nbr_controleur_rattache AS nbr_controleur_rattache_17,
  t0.nature_juridique AS nature_juridique_18,
  t0.type_centre AS type_centre_19,
  t20.id AS id_21,
  t20.num_rapport AS num_rapport_22,
  t20.version AS version_23,
  t20.date_audit AS date_audit_24,
  t20.date_heure_reunion_ouverture AS date_heure_reunion_ouverture_25,
  t20.date_heure_reunion_cloture AS date_heure_reunion_cloture_26,
  t20.id_canvas AS id_canvas_27,
  t20.id_type_audit AS id_type_audit_28,
  t20.lib_type_audit AS lib_type_audit_29,
  t20.type_centre AS type_centre_30,
  t20.lib_conclusion AS lib_conclusion_31,
  t20.termine AS termine_32,
  t20.nbr_anomalie_analyse_pv AS nbr_anomalie_analyse_pv_33,
  t20.nbr_analyse_pv AS nbr_analyse_pv_34,
  t20.pourcent_anomalie AS pourcent_anomalie_35,
  t20.canevas_reference AS canevas_reference_36,
  t20.canevas_indice AS canevas_indice_37,
  t20.canevas_date AS canevas_date_38,
  t20.fiche_ecart_reference AS fiche_ecart_reference_39,
  t20.fiche_ecart_indice AS fiche_ecart_indice_40,
  t20.fiche_ecart_date AS fiche_ecart_date_41,
  t20.resultat AS resultat_42,
  t20.date_cloture AS date_cloture_43,
  t20.date_modification AS date_modification_44,
  t20.etat AS etat_45,
  t20.util_creation AS util_creation_46,
  t20.util_modification AS util_modification_47,
  t20.nbr_ligne AS nbr_ligne_48,
  t20.auditeur_suppl AS auditeur_suppl_49,
  t20.result_prec_audit AS result_prec_audit_50,
  t20.date_prec_audit AS date_prec_audit_51,
  t20.motif_audit AS motif_audit_52,
  t20.motif_id AS motif_id_53,
  t20.ctrl_ctp_n1 AS ctrl_ctp_n1_54,
  t20.ctrl_stage20 AS ctrl_stage20_55,
  t20.ctrl_so AS ctrl_so_56,
  t20.nb_so_regl AS nb_so_regl_57,
  t20.nb_conf_regl AS nb_conf_regl_58,
  t20.nb_rem_regl AS nb_rem_regl_59,
  t20.nb_ncc_regl AS nb_ncc_regl_60,
  t20.nb_nc_regl AS nb_nc_regl_61,
  t20.nb_so_non_regl AS nb_so_non_regl_62,
  t20.nb_conf_non_regl AS nb_conf_non_regl_63,
  t20.nb_rem_non_regl AS nb_rem_non_regl_64,
  t20.nb_ncc_non_regl AS nb_ncc_non_regl_65,
  t20.nb_nc_non_regl AS nb_nc_non_regl_66,
  t20.type_activite AS type_activite_67,
  t20.envoie_mail AS envoie_mail_68,
  t20.signatairecentre AS signatairecentre_69,
  t20.numero_agrement_deroulement AS numero_agrement_deroulement_70,
  t20.force_info_ctp AS force_info_ctp_71,
  t20.force_analyze_pv AS force_analyze_pv_72,
  t20.force_ctrl_co AS force_ctrl_co_73,
  t20.force_info_logiciel AS force_info_logiciel_74,
  t20.aut_canevas_id AS aut_canevas_id_75,
  t20.id_aut_info_logiciel_id AS id_aut_info_logiciel_id_76,
  t20.id_aut_centre_audite_id AS id_aut_centre_audite_id_77,
  t20.auditeur_id AS auditeur_id_78,
  t20.TCentre AS TCentre_79,
  t20.TAudit AS TAudit_80,
  t20.controleur AS controleur_81
FROM
  aut_centre_audite t0
  LEFT JOIN aut_audit t20 ON t20.id_aut_centre_audite_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.gerant AS gerant_3, t0.adresse_installation AS adresse_installation_4, t0.compl_adresse_installation AS compl_adresse_installation_5, t0.cp_installation AS cp_installation_6, t0.ville_installation AS ville_installation_7, t0.adresse_siege_social AS adresse_siege_social_8, t0.compl_adresse_siege_social AS compl_adresse_siege_social_9, t0.cp_siege_social AS cp_siege_social_10, t0.ville_siege_social AS ville_siege_social_11, t0.numero_agrement AS numero_agrement_12, t0.date_agrement AS date_agrement_13, t0.telephone AS telephone_14, t0.email AS email_15, t0.nbr_effectif_total AS nbr_effectif_total_16, t0.nbr_controleur_rattache AS nbr_controleur_rattache_17, t0.nature_juridique AS nature_juridique_18, t0.type_centre AS type_centre_19, t20.id AS id_21, t20.num_rapport AS num_rapport_22, t20.version AS version_23, t20.date_audit AS date_audit_24, t20.date_heure_reunion_ouverture AS date_heure_reunion_ouverture_25, t20.date_heure_reunion_cloture AS date_heure_reunion_cloture_26, t20.id_canvas AS id_canvas_27, t20.id_type_audit AS id_type_audit_28, t20.lib_type_audit AS lib_type_audit_29, t20.type_centre AS type_centre_30, t20.lib_conclusion AS lib_conclusion_31, t20.termine AS termine_32, t20.nbr_anomalie_analyse_pv AS nbr_anomalie_analyse_pv_33, t20.nbr_analyse_pv AS nbr_analyse_pv_34, t20.pourcent_anomalie AS pourcent_anomalie_35, t20.canevas_reference AS canevas_reference_36, t20.canevas_indice AS canevas_indice_37, t20.canevas_date AS canevas_date_38, t20.fiche_ecart_reference AS fiche_ecart_reference_39, t20.fiche_ecart_indice AS fiche_ecart_indice_40, t20.fiche_ecart_date AS fiche_ecart_date_41, t20.resultat AS resultat_42, t20.date_cloture AS date_cloture_43, t20.date_modification AS date_modification_44, t20.etat AS etat_45, t20.util_creation AS util_creation_46, t20.util_modification AS util_modification_47, t20.nbr_ligne AS nbr_ligne_48, t20.auditeur_suppl AS auditeur_suppl_49, t20.result_prec_audit AS result_prec_audit_50, t20.date_prec_audit AS date_prec_audit_51, t20.motif_audit AS motif_audit_52, t20.motif_id AS motif_id_53, t20.ctrl_ctp_n1 AS ctrl_ctp_n1_54, t20.ctrl_stage20 AS ctrl_stage20_55, t20.ctrl_so AS ctrl_so_56, t20.nb_so_regl AS nb_so_regl_57, t20.nb_conf_regl AS nb_conf_regl_58, t20.nb_rem_regl AS nb_rem_regl_59, t20.nb_ncc_regl AS nb_ncc_regl_60, t20.nb_nc_regl AS nb_nc_regl_61, t20.nb_so_non_regl AS nb_so_non_regl_62, t20.nb_conf_non_regl AS nb_conf_non_regl_63, t20.nb_rem_non_regl AS nb_rem_non_regl_64, t20.nb_ncc_non_regl AS nb_ncc_non_regl_65, t20.nb_nc_non_regl AS nb_nc_non_regl_66, t20.type_activite AS type_activite_67, t20.envoie_mail AS envoie_mail_68, t20.signatairecentre AS signatairecentre_69, t20.numero_agrement_deroulement AS numero_agrement_deroulement_70, t20.force_info_ctp AS force_info_ctp_71, t20.force_analyze_pv AS force_analyze_pv_72, t20.force_ctrl_co AS force_ctrl_co_73, t20.force_info_logiciel AS force_info_logiciel_74, t20.aut_canevas_id AS aut_canevas_id_75, t20.id_aut_info_logiciel_id AS id_aut_info_logiciel_id_76, t20.id_aut_centre_audite_id AS id_aut_centre_audite_id_77, t20.auditeur_id AS auditeur_id_78, t20.TCentre AS TCentre_79, t20.TAudit AS TAudit_80, t20.controleur AS controleur_81 FROM aut_centre_audite t0 LEFT JOIN aut_audit t20 ON t20.id_aut_centre_audite_id = t0.id WHERE t0.id = 258;

SELECT
  t0.IDUser AS IDUser_1,
  t0.LoginUser AS LoginUser_2,
  t0.AvatarForum AS AvatarForum_3,
  t0.MotDePasseCrypte AS MotDePasseCrypte_4,
  t0.Civilite AS Civilite_5,
  t0.NomPersonnel AS NomPersonnel_6,
  t0.PrenomPersonnel AS PrenomPersonnel_7,
  t0.TitreEmploiResponsableLegal AS TitreEmploiResponsableLegal_8,
  t0.DateNaissance AS DateNaissance_9,
  t0.LieuNaissance AS LieuNaissance_10,
  t0.DateDebutEmploi AS DateDebutEmploi_11,
  t0.DateFinEmploi AS DateFinEmploi_12,
  t0.InformationsComplementaires AS InformationsComplementaires_13,
  t0.HorairesPermanence AS HorairesPermanence_14,
  t0.DateDerniereConnexion AS DateDerniereConnexion_15,
  t0.NumSecuriteSoc AS NumSecuriteSoc_16,
  t0.FKAdresseUser AS FKAdresseUser_17,
  t0.NumeroAgrementVL AS NumeroAgrementVL_18,
  t0.DateAgrementControleurVL AS DateAgrementControleurVL_19,
  t0.NumeroAgrementPL AS NumeroAgrementPL_20,
  t0.DateAgrementControleurPL AS DateAgrementControleurPL_21,
  t0.NumeroAgrementCL AS NumeroAgrementCL_22,
  t0.DateAgrementControleurCL AS DateAgrementControleurCL_23,
  t0.OrdreAffichage AS OrdreAffichage_24,
  t0.droitAccesPlanningABSComplet AS droitAccesPlanningABSComplet_25,
  t0.DateHeureMajMYSQL AS DateHeureMajMYSQL_26
FROM
  t_user t0
WHERE
  t0.IDUser = ?

SELECT t0.IDUser AS IDUser_1, t0.LoginUser AS LoginUser_2, t0.AvatarForum AS AvatarForum_3, t0.MotDePasseCrypte AS MotDePasseCrypte_4, t0.Civilite AS Civilite_5, t0.NomPersonnel AS NomPersonnel_6, t0.PrenomPersonnel AS PrenomPersonnel_7, t0.TitreEmploiResponsableLegal AS TitreEmploiResponsableLegal_8, t0.DateNaissance AS DateNaissance_9, t0.LieuNaissance AS LieuNaissance_10, t0.DateDebutEmploi AS DateDebutEmploi_11, t0.DateFinEmploi AS DateFinEmploi_12, t0.InformationsComplementaires AS InformationsComplementaires_13, t0.HorairesPermanence AS HorairesPermanence_14, t0.DateDerniereConnexion AS DateDerniereConnexion_15, t0.NumSecuriteSoc AS NumSecuriteSoc_16, t0.FKAdresseUser AS FKAdresseUser_17, t0.NumeroAgrementVL AS NumeroAgrementVL_18, t0.DateAgrementControleurVL AS DateAgrementControleurVL_19, t0.NumeroAgrementPL AS NumeroAgrementPL_20, t0.DateAgrementControleurPL AS DateAgrementControleurPL_21, t0.NumeroAgrementCL AS NumeroAgrementCL_22, t0.DateAgrementControleurCL AS DateAgrementControleurCL_23, t0.OrdreAffichage AS OrdreAffichage_24, t0.droitAccesPlanningABSComplet AS droitAccesPlanningABSComplet_25, t0.DateHeureMajMYSQL AS DateHeureMajMYSQL_26 FROM t_user t0 WHERE t0.IDUser = 3857;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.login AS login_5,
  t0.password AS password_6,
  t0.auditeur AS auditeur_7,
  t0.formateur AS formateur_8,
  t0.etat AS etat_9,
  t0.image AS image_10,
  t0.create_at AS create_at_11,
  t0.create_by AS create_by_12,
  t0.comptable AS comptable_13,
  t0.informatique AS informatique_14,
  t0.commercial AS commercial_15,
  t0.hotline AS hotline_16,
  t0.direction AS direction_17,
  t0.administratif AS administratif_18,
  t0.telephone AS telephone_19,
  t0.id_rise_up AS id_rise_up_20,
  t0.superviseur_audit AS superviseur_audit_21,
  t0.initial AS initial_22,
  t0.fonction_id AS fonction_id_23,
  t0.FKUser AS FKUser_24
FROM
  bo_personnel_abs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.login AS login_5, t0.password AS password_6, t0.auditeur AS auditeur_7, t0.formateur AS formateur_8, t0.etat AS etat_9, t0.image AS image_10, t0.create_at AS create_at_11, t0.create_by AS create_by_12, t0.comptable AS comptable_13, t0.informatique AS informatique_14, t0.commercial AS commercial_15, t0.hotline AS hotline_16, t0.direction AS direction_17, t0.administratif AS administratif_18, t0.telephone AS telephone_19, t0.id_rise_up AS id_rise_up_20, t0.superviseur_audit AS superviseur_audit_21, t0.initial AS initial_22, t0.fonction_id AS fonction_id_23, t0.FKUser AS FKUser_24 FROM bo_personnel_abs t0 WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.indice AS indice_3,
  t0.lib_doc_ref AS lib_doc_ref_4,
  t0.lib_criteres_validation AS lib_criteres_validation_5,
  t6.id AS id_7,
  t6.type_centre AS type_centre_8,
  t6.libelle AS libelle_9,
  t6.reference AS reference_10,
  t6.indice AS indice_11,
  t6.date AS date_12,
  t6.date_debut AS date_debut_13,
  t6.date_fin AS date_fin_14,
  t6.etat AS etat_15,
  t6.date_modification AS date_modification_16,
  t6.util_creation AS util_creation_17,
  t6.util_modification AS util_modification_18,
  t6.id_etat_canevas_id AS id_etat_canevas_id_19,
  t0.modele_id AS modele_id_20
FROM
  aut_etat_canevas t0
  LEFT JOIN aut_canevas t6 ON t6.id_etat_canevas_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.indice AS indice_3, t0.lib_doc_ref AS lib_doc_ref_4, t0.lib_criteres_validation AS lib_criteres_validation_5, t6.id AS id_7, t6.type_centre AS type_centre_8, t6.libelle AS libelle_9, t6.reference AS reference_10, t6.indice AS indice_11, t6.date AS date_12, t6.date_debut AS date_debut_13, t6.date_fin AS date_fin_14, t6.etat AS etat_15, t6.date_modification AS date_modification_16, t6.util_creation AS util_creation_17, t6.util_modification AS util_modification_18, t6.id_etat_canevas_id AS id_etat_canevas_id_19, t0.modele_id AS modele_id_20 FROM aut_etat_canevas t0 LEFT JOIN aut_canevas t6 ON t6.id_etat_canevas_id = t0.id WHERE t0.id = 17;

SELECT
  t0.id AS id_1,
  t0.type_centre AS type_centre_2,
  t0.libelle AS libelle_3,
  t0.reference AS reference_4,
  t0.indice AS indice_5,
  t0.date AS date_6,
  t0.date_debut AS date_debut_7,
  t0.date_fin AS date_fin_8,
  t0.etat AS etat_9,
  t0.date_modification AS date_modification_10,
  t0.util_creation AS util_creation_11,
  t0.util_modification AS util_modification_12,
  t0.id_etat_canevas_id AS id_etat_canevas_id_13
FROM
  aut_canevas t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type_centre AS type_centre_2, t0.libelle AS libelle_3, t0.reference AS reference_4, t0.indice AS indice_5, t0.date AS date_6, t0.date_debut AS date_debut_7, t0.date_fin AS date_fin_8, t0.etat AS etat_9, t0.date_modification AS date_modification_10, t0.util_creation AS util_creation_11, t0.util_modification AS util_modification_12, t0.id_etat_canevas_id AS id_etat_canevas_id_13 FROM aut_canevas t0 WHERE t0.id = 38;

SELECT
  aut_audit_id,
  SUM(rem) as totalRem,
  SUM(nc) as totalNc,
  SUM(ncc) as totalNcc
FROM
  (
    SELECT
      aut_audit_id,
      rem,
      nc,
      ncc
    FROM
      aut_contenu_audit
    WHERE
      aut_audit_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?
      )
    UNION ALL
    SELECT
      d.aut_audit_id,
      rem,
      nc,
      ncc
    FROM
      aut_defaut_ctrl
      LEFT JOIN aut_info_defaut_ctrl d on d.id = aut_defaut_ctrl.aut_info_defaut_ctrl_id
    WHERE
      d.aut_audit_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?
      )
    UNION ALL
    SELECT
      m.aut_audit_id,
      rem,
      nc,
      ncc
    FROM
      aut_defaut_materiel
      LEFT JOIN aut_materiel_audite m on m.id = aut_defaut_materiel.aut_info_materiel_id
    WHERE
      m.aut_audit_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?
      )
  ) combined
GROUP BY
  aut_audit_id

SELECT aut_audit_id, 
                SUM(rem) as totalRem, 
                SUM(nc) as totalNc, 
                SUM(ncc) as totalNcc
            FROM (
                SELECT aut_audit_id, rem, nc, ncc FROM aut_contenu_audit WHERE aut_audit_id IN (258, 252, 256, 251, 245, 244, 246, 249, 248, 247, 234, 235, 237, 241, 238, 243, 242, 229, 227, 226, 232, 219, 183, 151, 181, 182, 39, 210, 199, 202, 213, 201, 208, 191, 200, 189, 212, 187, 198, 193, 196, 205, 195, 206, 203, 204, 190, 188, 142, 180, 179, 184, 177, 139, 173, 161, 143, 168, 137, 140, 160, 172, 164, 176, 163, 165, 170, 162, 167, 169, 166, 135, 152, 158, 156, 178, 128, 155, 129)
                UNION ALL
                SELECT d.aut_audit_id, rem, nc, ncc FROM aut_defaut_ctrl LEFT JOIN aut_info_defaut_ctrl d on d.id = aut_defaut_ctrl.aut_info_defaut_ctrl_id  WHERE d.aut_audit_id IN (258, 252, 256, 251, 245, 244, 246, 249, 248, 247, 234, 235, 237, 241, 238, 243, 242, 229, 227, 226, 232, 219, 183, 151, 181, 182, 39, 210, 199, 202, 213, 201, 208, 191, 200, 189, 212, 187, 198, 193, 196, 205, 195, 206, 203, 204, 190, 188, 142, 180, 179, 184, 177, 139, 173, 161, 143, 168, 137, 140, 160, 172, 164, 176, 163, 165, 170, 162, 167, 169, 166, 135, 152, 158, 156, 178, 128, 155, 129)
                UNION ALL
                SELECT m.aut_audit_id, rem, nc, ncc FROM aut_defaut_materiel LEFT JOIN aut_materiel_audite m on m.id = aut_defaut_materiel.aut_info_materiel_id WHERE m.aut_audit_id IN (258, 252, 256, 251, 245, 244, 246, 249, 248, 247, 234, 235, 237, 241, 238, 243, 242, 229, 227, 226, 232, 219, 183, 151, 181, 182, 39, 210, 199, 202, 213, 201, 208, 191, 200, 189, 212, 187, 198, 193, 196, 205, 195, 206, 203, 204, 190, 188, 142, 180, 179, 184, 177, 139, 173, 161, 143, 168, 137, 140, 160, 172, 164, 176, 163, 165, 170, 162, 167, 169, 166, 135, 152, 158, 156, 178, 128, 155, 129)
            ) combined
            GROUP BY aut_audit_id
        ;

SELECT
  a0_.id AS id_0,
  a0_.num_rapport AS num_rapport_1,
  a0_.version AS version_2,
  a0_.date_audit AS date_audit_3,
  a0_.date_heure_reunion_ouverture AS date_heure_reunion_ouverture_4,
  a0_.date_heure_reunion_cloture AS date_heure_reunion_cloture_5,
  a0_.id_canvas AS id_canvas_6,
  a0_.id_type_audit AS id_type_audit_7,
  a0_.lib_type_audit AS lib_type_audit_8,
  a0_.type_centre AS type_centre_9,
  a0_.lib_conclusion AS lib_conclusion_10,
  a0_.termine AS termine_11,
  a0_.nbr_anomalie_analyse_pv AS nbr_anomalie_analyse_pv_12,
  a0_.nbr_analyse_pv AS nbr_analyse_pv_13,
  a0_.pourcent_anomalie AS pourcent_anomalie_14,
  a0_.canevas_reference AS canevas_reference_15,
  a0_.canevas_indice AS canevas_indice_16,
  a0_.canevas_date AS canevas_date_17,
  a0_.fiche_ecart_reference AS fiche_ecart_reference_18,
  a0_.fiche_ecart_indice AS fiche_ecart_indice_19,
  a0_.fiche_ecart_date AS fiche_ecart_date_20,
  a0_.resultat AS resultat_21,
  a0_.date_cloture AS date_cloture_22,
  a0_.date_modification AS date_modification_23,
  a0_.etat AS etat_24,
  a0_.util_creation AS util_creation_25,
  a0_.util_modification AS util_modification_26,
  a0_.nbr_ligne AS nbr_ligne_27,
  a0_.auditeur_suppl AS auditeur_suppl_28,
  a0_.result_prec_audit AS result_prec_audit_29,
  a0_.date_prec_audit AS date_prec_audit_30,
  a0_.motif_audit AS motif_audit_31,
  a0_.motif_id AS motif_id_32,
  a0_.ctrl_ctp_n1 AS ctrl_ctp_n1_33,
  a0_.ctrl_stage20 AS ctrl_stage20_34,
  a0_.ctrl_so AS ctrl_so_35,
  a0_.nb_so_regl AS nb_so_regl_36,
  a0_.nb_conf_regl AS nb_conf_regl_37,
  a0_.nb_rem_regl AS nb_rem_regl_38,
  a0_.nb_ncc_regl AS nb_ncc_regl_39,
  a0_.nb_nc_regl AS nb_nc_regl_40,
  a0_.nb_so_non_regl AS nb_so_non_regl_41,
  a0_.nb_conf_non_regl AS nb_conf_non_regl_42,
  a0_.nb_rem_non_regl AS nb_rem_non_regl_43,
  a0_.nb_ncc_non_regl AS nb_ncc_non_regl_44,
  a0_.nb_nc_non_regl AS nb_nc_non_regl_45,
  a0_.type_activite AS type_activite_46,
  a0_.envoie_mail AS envoie_mail_47,
  a0_.signatairecentre AS signatairecentre_48,
  a0_.numero_agrement_deroulement AS numero_agrement_deroulement_49,
  a0_.force_info_ctp AS force_info_ctp_50,
  a0_.force_analyze_pv AS force_analyze_pv_51,
  a0_.force_ctrl_co AS force_ctrl_co_52,
  a0_.force_info_logiciel AS force_info_logiciel_53,
  a0_.aut_canevas_id AS aut_canevas_id_54,
  a0_.id_aut_info_logiciel_id AS id_aut_info_logiciel_id_55,
  a0_.id_aut_centre_audite_id AS id_aut_centre_audite_id_56,
  a0_.auditeur_id AS auditeur_id_57,
  a0_.TCentre AS TCentre_58,
  a0_.TAudit AS TAudit_59,
  a0_.controleur AS controleur_60
FROM
  aut_audit a0_
WHERE
  (
    a0_.date_audit BETWEEN ?
    AND ?
  )
  AND a0_.date_cloture IS NOT NULL
ORDER BY
  a0_.date_audit DESC

SELECT a0_.id AS id_0, a0_.num_rapport AS num_rapport_1, a0_.version AS version_2, a0_.date_audit AS date_audit_3, a0_.date_heure_reunion_ouverture AS date_heure_reunion_ouverture_4, a0_.date_heure_reunion_cloture AS date_heure_reunion_cloture_5, a0_.id_canvas AS id_canvas_6, a0_.id_type_audit AS id_type_audit_7, a0_.lib_type_audit AS lib_type_audit_8, a0_.type_centre AS type_centre_9, a0_.lib_conclusion AS lib_conclusion_10, a0_.termine AS termine_11, a0_.nbr_anomalie_analyse_pv AS nbr_anomalie_analyse_pv_12, a0_.nbr_analyse_pv AS nbr_analyse_pv_13, a0_.pourcent_anomalie AS pourcent_anomalie_14, a0_.canevas_reference AS canevas_reference_15, a0_.canevas_indice AS canevas_indice_16, a0_.canevas_date AS canevas_date_17, a0_.fiche_ecart_reference AS fiche_ecart_reference_18, a0_.fiche_ecart_indice AS fiche_ecart_indice_19, a0_.fiche_ecart_date AS fiche_ecart_date_20, a0_.resultat AS resultat_21, a0_.date_cloture AS date_cloture_22, a0_.date_modification AS date_modification_23, a0_.etat AS etat_24, a0_.util_creation AS util_creation_25, a0_.util_modification AS util_modification_26, a0_.nbr_ligne AS nbr_ligne_27, a0_.auditeur_suppl AS auditeur_suppl_28, a0_.result_prec_audit AS result_prec_audit_29, a0_.date_prec_audit AS date_prec_audit_30, a0_.motif_audit AS motif_audit_31, a0_.motif_id AS motif_id_32, a0_.ctrl_ctp_n1 AS ctrl_ctp_n1_33, a0_.ctrl_stage20 AS ctrl_stage20_34, a0_.ctrl_so AS ctrl_so_35, a0_.nb_so_regl AS nb_so_regl_36, a0_.nb_conf_regl AS nb_conf_regl_37, a0_.nb_rem_regl AS nb_rem_regl_38, a0_.nb_ncc_regl AS nb_ncc_regl_39, a0_.nb_nc_regl AS nb_nc_regl_40, a0_.nb_so_non_regl AS nb_so_non_regl_41, a0_.nb_conf_non_regl AS nb_conf_non_regl_42, a0_.nb_rem_non_regl AS nb_rem_non_regl_43, a0_.nb_ncc_non_regl AS nb_ncc_non_regl_44, a0_.nb_nc_non_regl AS nb_nc_non_regl_45, a0_.type_activite AS type_activite_46, a0_.envoie_mail AS envoie_mail_47, a0_.signatairecentre AS signatairecentre_48, a0_.numero_agrement_deroulement AS numero_agrement_deroulement_49, a0_.force_info_ctp AS force_info_ctp_50, a0_.force_analyze_pv AS force_analyze_pv_51, a0_.force_ctrl_co AS force_ctrl_co_52, a0_.force_info_logiciel AS force_info_logiciel_53, a0_.aut_canevas_id AS aut_canevas_id_54, a0_.id_aut_info_logiciel_id AS id_aut_info_logiciel_id_55, a0_.id_aut_centre_audite_id AS id_aut_centre_audite_id_56, a0_.auditeur_id AS auditeur_id_57, a0_.TCentre AS TCentre_58, a0_.TAudit AS TAudit_59, a0_.controleur AS controleur_60 FROM aut_audit a0_ WHERE (a0_.date_audit BETWEEN '2026-03-22 00:00:00' AND '2026-05-21 23:59:59') AND a0_.date_cloture IS NOT NULL ORDER BY a0_.date_audit DESC;

SELECT
  t0.id AS id_1,
  t0.libele AS libele_2,
  t0.etat AS etat_3
FROM
  aut_modele_canevas t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libele AS libele_2, t0.etat AS etat_3 FROM aut_modele_canevas t0 WHERE t0.id = 2;