Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.is_verified AS is_verified_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.username AS username_7,
  t0.token AS token_8,
  t0.token_mdp AS token_mdp_9,
  t0.desactivation_compte AS desactivation_compte_10,
  t0.created_at AS created_at_11,
  t0.refus_campagne AS refus_campagne_12,
  t0.compte_finalise AS compte_finalise_13,
  t0.structure AS structure_14,
  t0.nom_structure AS nom_structure_15,
  t0.coordonnees_id AS coordonnees_id_16,
  t0.info_allocataire_id AS info_allocataire_id_17,
  t18.id AS id_19,
  t18.date_naissance AS date_naissance_20,
  t18.pays_naissance AS pays_naissance_21,
  t18.code_postal_naissance AS code_postal_naissance_22,
  t18.commune_naissance AS commune_naissance_23,
  t18.numero_securite_social AS numero_securite_social_24,
  t18.intitule_poste AS intitule_poste_25,
  t18.nom_photo AS nom_photo_26,
  t18.updated_at_photo AS updated_at_photo_27,
  t18.notes AS notes_28,
  t18.code_insee AS code_insee_29,
  t18.user_id AS user_id_30,
  t18.statut_employe_id AS statut_employe_id_31
FROM
  user t0
  LEFT JOIN animateur t18 ON t18.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.username AS username_7, t0.token AS token_8, t0.token_mdp AS token_mdp_9, t0.desactivation_compte AS desactivation_compte_10, t0.created_at AS created_at_11, t0.refus_campagne AS refus_campagne_12, t0.compte_finalise AS compte_finalise_13, t0.structure AS structure_14, t0.nom_structure AS nom_structure_15, t0.coordonnees_id AS coordonnees_id_16, t0.info_allocataire_id AS info_allocataire_id_17, t18.id AS id_19, t18.date_naissance AS date_naissance_20, t18.pays_naissance AS pays_naissance_21, t18.code_postal_naissance AS code_postal_naissance_22, t18.commune_naissance AS commune_naissance_23, t18.numero_securite_social AS numero_securite_social_24, t18.intitule_poste AS intitule_poste_25, t18.nom_photo AS nom_photo_26, t18.updated_at_photo AS updated_at_photo_27, t18.notes AS notes_28, t18.code_insee AS code_insee_29, t18.user_id AS user_id_30, t18.statut_employe_id AS statut_employe_id_31 FROM user t0 LEFT JOIN animateur t18 ON t18.user_id = t0.id WHERE t0.id = 11;

SELECT
  a0_.id AS id_0,
  a0_.statut_paiement AS statut_paiement_1,
  a0_.validation_admin AS validation_admin_2,
  a0_.created_at AS created_at_3,
  a0_.updated_at AS updated_at_4,
  a0_.supprimer_commande_complete AS supprimer_commande_complete_5,
  a0_.commentaire AS commentaire_6,
  a0_.num_facture_avoir AS num_facture_avoir_7,
  c1_.id AS id_8,
  c1_.total_avant_reduc AS total_avant_reduc_9,
  c1_.total_apres_reduc AS total_apres_reduc_10,
  c1_.created_at AS created_at_11,
  c1_.total_acompte AS total_acompte_12,
  c1_.statut AS statut_13,
  c1_.num_facture AS num_facture_14,
  r2_.id AS id_15,
  r2_.created_at AS created_at_16,
  r2_.updated_at AS updated_at_17,
  r2_.statut_reservation AS statut_reservation_18,
  r2_.montant_total AS montant_total_19,
  r2_.montant_acompte AS montant_acompte_20,
  r2_.valide AS valide_21,
  r2_.statut AS statut_22,
  r2_.archive AS archive_23,
  r2_.num_liste_attente AS num_liste_attente_24,
  r2_.plus_de_six_ans AS plus_de_six_ans_25,
  r2_.numero_attestation_presence AS numero_attestation_presence_26,
  a0_.commande_id AS commande_id_27,
  a0_.createur_id AS createur_id_28,
  a0_.utilisateur_concerne_id AS utilisateur_concerne_id_29,
  r2_.utilisateur_id AS utilisateur_id_30,
  r2_.enfant_id AS enfant_id_31,
  r2_.activite_id AS activite_id_32,
  r2_.commande_id AS commande_id_33,
  r2_.annulation_id AS annulation_id_34,
  r2_.presence_sejour_id AS presence_sejour_id_35,
  r2_.tarif_id AS tarif_id_36
FROM
  annulation a0_
  INNER JOIN commande c1_ ON a0_.commande_id = c1_.id
  LEFT JOIN reservation r2_ ON c1_.id = r2_.commande_id
  LEFT JOIN sejour s3_ ON r2_.activite_id = s3_.id
  LEFT JOIN adhesion_utilisateur a4_ ON c1_.id = a4_.commande_id
  LEFT JOIN adhesion a5_ ON a4_.adhesion_id = a5_.id
WHERE
  (
    r2_.id IS NOT NULL
    OR a4_.id IS NOT NULL
  )
  AND (
    (
      s3_.statut = ?
      OR (
        s3_.statut IS NULL
        AND s3_.id IS NOT NULL
      )
    )
    OR a5_.archive = 0
  )

SELECT a0_.id AS id_0, a0_.statut_paiement AS statut_paiement_1, a0_.validation_admin AS validation_admin_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.supprimer_commande_complete AS supprimer_commande_complete_5, a0_.commentaire AS commentaire_6, a0_.num_facture_avoir AS num_facture_avoir_7, c1_.id AS id_8, c1_.total_avant_reduc AS total_avant_reduc_9, c1_.total_apres_reduc AS total_apres_reduc_10, c1_.created_at AS created_at_11, c1_.total_acompte AS total_acompte_12, c1_.statut AS statut_13, c1_.num_facture AS num_facture_14, r2_.id AS id_15, r2_.created_at AS created_at_16, r2_.updated_at AS updated_at_17, r2_.statut_reservation AS statut_reservation_18, r2_.montant_total AS montant_total_19, r2_.montant_acompte AS montant_acompte_20, r2_.valide AS valide_21, r2_.statut AS statut_22, r2_.archive AS archive_23, r2_.num_liste_attente AS num_liste_attente_24, r2_.plus_de_six_ans AS plus_de_six_ans_25, r2_.numero_attestation_presence AS numero_attestation_presence_26, a0_.commande_id AS commande_id_27, a0_.createur_id AS createur_id_28, a0_.utilisateur_concerne_id AS utilisateur_concerne_id_29, r2_.utilisateur_id AS utilisateur_id_30, r2_.enfant_id AS enfant_id_31, r2_.activite_id AS activite_id_32, r2_.commande_id AS commande_id_33, r2_.annulation_id AS annulation_id_34, r2_.presence_sejour_id AS presence_sejour_id_35, r2_.tarif_id AS tarif_id_36 FROM annulation a0_ INNER JOIN commande c1_ ON a0_.commande_id = c1_.id LEFT JOIN reservation r2_ ON c1_.id = r2_.commande_id LEFT JOIN sejour s3_ ON r2_.activite_id = s3_.id LEFT JOIN adhesion_utilisateur a4_ ON c1_.id = a4_.commande_id LEFT JOIN adhesion a5_ ON a4_.adhesion_id = a5_.id WHERE (r2_.id IS NOT NULL OR a4_.id IS NOT NULL) AND ((s3_.statut = 'publie' OR (s3_.statut IS NULL AND s3_.id IS NOT NULL)) OR a5_.archive = 0);

SELECT
  t0.id AS id_1,
  t0.total_avant_reduc AS total_avant_reduc_2,
  t0.total_apres_reduc AS total_apres_reduc_3,
  t0.created_at AS created_at_4,
  t0.total_acompte AS total_acompte_5,
  t0.statut AS statut_6,
  t0.num_facture AS num_facture_7,
  t8.id AS id_9,
  t8.statut_paiement AS statut_paiement_10,
  t8.validation_admin AS validation_admin_11,
  t8.created_at AS created_at_12,
  t8.updated_at AS updated_at_13,
  t8.supprimer_commande_complete AS supprimer_commande_complete_14,
  t8.commentaire AS commentaire_15,
  t8.num_facture_avoir AS num_facture_avoir_16,
  t8.commande_id AS commande_id_17,
  t8.createur_id AS createur_id_18,
  t8.utilisateur_concerne_id AS utilisateur_concerne_id_19
FROM
  commande t0
  LEFT JOIN annulation t8 ON t8.commande_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.total_avant_reduc AS total_avant_reduc_2, t0.total_apres_reduc AS total_apres_reduc_3, t0.created_at AS created_at_4, t0.total_acompte AS total_acompte_5, t0.statut AS statut_6, t0.num_facture AS num_facture_7, t8.id AS id_9, t8.statut_paiement AS statut_paiement_10, t8.validation_admin AS validation_admin_11, t8.created_at AS created_at_12, t8.updated_at AS updated_at_13, t8.supprimer_commande_complete AS supprimer_commande_complete_14, t8.commentaire AS commentaire_15, t8.num_facture_avoir AS num_facture_avoir_16, t8.commande_id AS commande_id_17, t8.createur_id AS createur_id_18, t8.utilisateur_concerne_id AS utilisateur_concerne_id_19 FROM commande t0 LEFT JOIN annulation t8 ON t8.commande_id = t0.id WHERE t0.id = 1138;

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.nom AS nom_1,
  m0_.ordre_cheque AS ordre_cheque_2,
  m0_.adresse_cheque AS adresse_cheque_3,
  m0_.utilisation_admin AS utilisation_admin_4,
  m0_.choix_parametre AS choix_parametre_5,
  m0_.description_sur_place AS description_sur_place_6,
  m1_.id AS id_7,
  m1_.montant_paye AS montant_paye_8,
  m1_.numero_cheque AS numero_cheque_9,
  m1_.numero_avoir AS numero_avoir_10,
  m1_.avoir_utilise AS avoir_utilise_11,
  m1_.created_at AS created_at_12,
  m1_.fin_validite AS fin_validite_13,
  m1_.id_paiement AS id_paiement_14,
  m1_.id_lien_paiement_stripe AS id_lien_paiement_stripe_15,
  m1_.somme_remboursee AS somme_remboursee_16,
  m1_.paiement_plusieurs_fois AS paiement_plusieurs_fois_17,
  m1_.montant_attendu AS montant_attendu_18,
  m1_.order_id AS order_id_19,
  m1_.cancel_order AS cancel_order_20,
  m1_.date_utilisation_avoir AS date_utilisation_avoir_21,
  m2_.id AS id_22,
  m2_.nom AS nom_23,
  m2_.ordre_cheque AS ordre_cheque_24,
  m2_.adresse_cheque AS adresse_cheque_25,
  m2_.utilisation_admin AS utilisation_admin_26,
  m2_.choix_parametre AS choix_parametre_27,
  m2_.description_sur_place AS description_sur_place_28,
  m1_.moyen_paiement_id AS moyen_paiement_id_29,
  m1_.utilisateur_id AS utilisateur_id_30,
  m1_.annulation_id AS annulation_id_31
FROM
  moyen_paiement m0_
  INNER JOIN mode_paiement_commande m1_ ON m0_.id = m1_.moyen_paiement_id
  LEFT JOIN moyen_paiement m2_ ON m1_.moyen_paiement_id = m2_.id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      commande_mode_paiement_commande c3_
    WHERE
      c3_.mode_paiement_commande_id = m1_.id
      AND c3_.commande_id IN (?)
  )

SELECT DISTINCT m0_.id AS id_0, m0_.nom AS nom_1, m0_.ordre_cheque AS ordre_cheque_2, m0_.adresse_cheque AS adresse_cheque_3, m0_.utilisation_admin AS utilisation_admin_4, m0_.choix_parametre AS choix_parametre_5, m0_.description_sur_place AS description_sur_place_6, m1_.id AS id_7, m1_.montant_paye AS montant_paye_8, m1_.numero_cheque AS numero_cheque_9, m1_.numero_avoir AS numero_avoir_10, m1_.avoir_utilise AS avoir_utilise_11, m1_.created_at AS created_at_12, m1_.fin_validite AS fin_validite_13, m1_.id_paiement AS id_paiement_14, m1_.id_lien_paiement_stripe AS id_lien_paiement_stripe_15, m1_.somme_remboursee AS somme_remboursee_16, m1_.paiement_plusieurs_fois AS paiement_plusieurs_fois_17, m1_.montant_attendu AS montant_attendu_18, m1_.order_id AS order_id_19, m1_.cancel_order AS cancel_order_20, m1_.date_utilisation_avoir AS date_utilisation_avoir_21, m2_.id AS id_22, m2_.nom AS nom_23, m2_.ordre_cheque AS ordre_cheque_24, m2_.adresse_cheque AS adresse_cheque_25, m2_.utilisation_admin AS utilisation_admin_26, m2_.choix_parametre AS choix_parametre_27, m2_.description_sur_place AS description_sur_place_28, m1_.moyen_paiement_id AS moyen_paiement_id_29, m1_.utilisateur_id AS utilisateur_id_30, m1_.annulation_id AS annulation_id_31 FROM moyen_paiement m0_ INNER JOIN mode_paiement_commande m1_ ON m0_.id = m1_.moyen_paiement_id LEFT JOIN moyen_paiement m2_ ON m1_.moyen_paiement_id = m2_.id WHERE EXISTS (SELECT 1 FROM commande_mode_paiement_commande c3_ WHERE c3_.mode_paiement_commande_id = m1_.id AND c3_.commande_id IN (1138));

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.key_secrete AS key_secrete_3,
  t0.key_public AS key_public_4,
  t0.moyen_paiement_id AS moyen_paiement_id_5
FROM
  plateforme_paiement t0
WHERE
  t0.moyen_paiement_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.key_secrete AS key_secrete_3, t0.key_public AS key_public_4, t0.moyen_paiement_id AS moyen_paiement_id_5 FROM plateforme_paiement t0 WHERE t0.moyen_paiement_id = 2;

SELECT
  t0.id AS id_1,
  t0.total_avant_reduc AS total_avant_reduc_2,
  t0.total_apres_reduc AS total_apres_reduc_3,
  t0.created_at AS created_at_4,
  t0.total_acompte AS total_acompte_5,
  t0.statut AS statut_6,
  t0.num_facture AS num_facture_7,
  t8.id AS id_9,
  t8.statut_paiement AS statut_paiement_10,
  t8.validation_admin AS validation_admin_11,
  t8.created_at AS created_at_12,
  t8.updated_at AS updated_at_13,
  t8.supprimer_commande_complete AS supprimer_commande_complete_14,
  t8.commentaire AS commentaire_15,
  t8.num_facture_avoir AS num_facture_avoir_16,
  t8.commande_id AS commande_id_17,
  t8.createur_id AS createur_id_18,
  t8.utilisateur_concerne_id AS utilisateur_concerne_id_19
FROM
  commande t0
  LEFT JOIN annulation t8 ON t8.commande_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.total_avant_reduc AS total_avant_reduc_2, t0.total_apres_reduc AS total_apres_reduc_3, t0.created_at AS created_at_4, t0.total_acompte AS total_acompte_5, t0.statut AS statut_6, t0.num_facture AS num_facture_7, t8.id AS id_9, t8.statut_paiement AS statut_paiement_10, t8.validation_admin AS validation_admin_11, t8.created_at AS created_at_12, t8.updated_at AS updated_at_13, t8.supprimer_commande_complete AS supprimer_commande_complete_14, t8.commentaire AS commentaire_15, t8.num_facture_avoir AS num_facture_avoir_16, t8.commande_id AS commande_id_17, t8.createur_id AS createur_id_18, t8.utilisateur_concerne_id AS utilisateur_concerne_id_19 FROM commande t0 LEFT JOIN annulation t8 ON t8.commande_id = t0.id WHERE t0.id = 1136;

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.nom AS nom_1,
  m0_.ordre_cheque AS ordre_cheque_2,
  m0_.adresse_cheque AS adresse_cheque_3,
  m0_.utilisation_admin AS utilisation_admin_4,
  m0_.choix_parametre AS choix_parametre_5,
  m0_.description_sur_place AS description_sur_place_6,
  m1_.id AS id_7,
  m1_.montant_paye AS montant_paye_8,
  m1_.numero_cheque AS numero_cheque_9,
  m1_.numero_avoir AS numero_avoir_10,
  m1_.avoir_utilise AS avoir_utilise_11,
  m1_.created_at AS created_at_12,
  m1_.fin_validite AS fin_validite_13,
  m1_.id_paiement AS id_paiement_14,
  m1_.id_lien_paiement_stripe AS id_lien_paiement_stripe_15,
  m1_.somme_remboursee AS somme_remboursee_16,
  m1_.paiement_plusieurs_fois AS paiement_plusieurs_fois_17,
  m1_.montant_attendu AS montant_attendu_18,
  m1_.order_id AS order_id_19,
  m1_.cancel_order AS cancel_order_20,
  m1_.date_utilisation_avoir AS date_utilisation_avoir_21,
  m2_.id AS id_22,
  m2_.nom AS nom_23,
  m2_.ordre_cheque AS ordre_cheque_24,
  m2_.adresse_cheque AS adresse_cheque_25,
  m2_.utilisation_admin AS utilisation_admin_26,
  m2_.choix_parametre AS choix_parametre_27,
  m2_.description_sur_place AS description_sur_place_28,
  m1_.moyen_paiement_id AS moyen_paiement_id_29,
  m1_.utilisateur_id AS utilisateur_id_30,
  m1_.annulation_id AS annulation_id_31
FROM
  moyen_paiement m0_
  INNER JOIN mode_paiement_commande m1_ ON m0_.id = m1_.moyen_paiement_id
  LEFT JOIN moyen_paiement m2_ ON m1_.moyen_paiement_id = m2_.id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      commande_mode_paiement_commande c3_
    WHERE
      c3_.mode_paiement_commande_id = m1_.id
      AND c3_.commande_id IN (?)
  )

SELECT DISTINCT m0_.id AS id_0, m0_.nom AS nom_1, m0_.ordre_cheque AS ordre_cheque_2, m0_.adresse_cheque AS adresse_cheque_3, m0_.utilisation_admin AS utilisation_admin_4, m0_.choix_parametre AS choix_parametre_5, m0_.description_sur_place AS description_sur_place_6, m1_.id AS id_7, m1_.montant_paye AS montant_paye_8, m1_.numero_cheque AS numero_cheque_9, m1_.numero_avoir AS numero_avoir_10, m1_.avoir_utilise AS avoir_utilise_11, m1_.created_at AS created_at_12, m1_.fin_validite AS fin_validite_13, m1_.id_paiement AS id_paiement_14, m1_.id_lien_paiement_stripe AS id_lien_paiement_stripe_15, m1_.somme_remboursee AS somme_remboursee_16, m1_.paiement_plusieurs_fois AS paiement_plusieurs_fois_17, m1_.montant_attendu AS montant_attendu_18, m1_.order_id AS order_id_19, m1_.cancel_order AS cancel_order_20, m1_.date_utilisation_avoir AS date_utilisation_avoir_21, m2_.id AS id_22, m2_.nom AS nom_23, m2_.ordre_cheque AS ordre_cheque_24, m2_.adresse_cheque AS adresse_cheque_25, m2_.utilisation_admin AS utilisation_admin_26, m2_.choix_parametre AS choix_parametre_27, m2_.description_sur_place AS description_sur_place_28, m1_.moyen_paiement_id AS moyen_paiement_id_29, m1_.utilisateur_id AS utilisateur_id_30, m1_.annulation_id AS annulation_id_31 FROM moyen_paiement m0_ INNER JOIN mode_paiement_commande m1_ ON m0_.id = m1_.moyen_paiement_id LEFT JOIN moyen_paiement m2_ ON m1_.moyen_paiement_id = m2_.id WHERE EXISTS (SELECT 1 FROM commande_mode_paiement_commande c3_ WHERE c3_.mode_paiement_commande_id = m1_.id AND c3_.commande_id IN (1136));

SELECT
  t0.id AS id_1,
  t0.total_avant_reduc AS total_avant_reduc_2,
  t0.total_apres_reduc AS total_apres_reduc_3,
  t0.created_at AS created_at_4,
  t0.total_acompte AS total_acompte_5,
  t0.statut AS statut_6,
  t0.num_facture AS num_facture_7,
  t8.id AS id_9,
  t8.statut_paiement AS statut_paiement_10,
  t8.validation_admin AS validation_admin_11,
  t8.created_at AS created_at_12,
  t8.updated_at AS updated_at_13,
  t8.supprimer_commande_complete AS supprimer_commande_complete_14,
  t8.commentaire AS commentaire_15,
  t8.num_facture_avoir AS num_facture_avoir_16,
  t8.commande_id AS commande_id_17,
  t8.createur_id AS createur_id_18,
  t8.utilisateur_concerne_id AS utilisateur_concerne_id_19
FROM
  commande t0
  LEFT JOIN annulation t8 ON t8.commande_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.total_avant_reduc AS total_avant_reduc_2, t0.total_apres_reduc AS total_apres_reduc_3, t0.created_at AS created_at_4, t0.total_acompte AS total_acompte_5, t0.statut AS statut_6, t0.num_facture AS num_facture_7, t8.id AS id_9, t8.statut_paiement AS statut_paiement_10, t8.validation_admin AS validation_admin_11, t8.created_at AS created_at_12, t8.updated_at AS updated_at_13, t8.supprimer_commande_complete AS supprimer_commande_complete_14, t8.commentaire AS commentaire_15, t8.num_facture_avoir AS num_facture_avoir_16, t8.commande_id AS commande_id_17, t8.createur_id AS createur_id_18, t8.utilisateur_concerne_id AS utilisateur_concerne_id_19 FROM commande t0 LEFT JOIN annulation t8 ON t8.commande_id = t0.id WHERE t0.id = 1137;

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.nom AS nom_1,
  m0_.ordre_cheque AS ordre_cheque_2,
  m0_.adresse_cheque AS adresse_cheque_3,
  m0_.utilisation_admin AS utilisation_admin_4,
  m0_.choix_parametre AS choix_parametre_5,
  m0_.description_sur_place AS description_sur_place_6,
  m1_.id AS id_7,
  m1_.montant_paye AS montant_paye_8,
  m1_.numero_cheque AS numero_cheque_9,
  m1_.numero_avoir AS numero_avoir_10,
  m1_.avoir_utilise AS avoir_utilise_11,
  m1_.created_at AS created_at_12,
  m1_.fin_validite AS fin_validite_13,
  m1_.id_paiement AS id_paiement_14,
  m1_.id_lien_paiement_stripe AS id_lien_paiement_stripe_15,
  m1_.somme_remboursee AS somme_remboursee_16,
  m1_.paiement_plusieurs_fois AS paiement_plusieurs_fois_17,
  m1_.montant_attendu AS montant_attendu_18,
  m1_.order_id AS order_id_19,
  m1_.cancel_order AS cancel_order_20,
  m1_.date_utilisation_avoir AS date_utilisation_avoir_21,
  m2_.id AS id_22,
  m2_.nom AS nom_23,
  m2_.ordre_cheque AS ordre_cheque_24,
  m2_.adresse_cheque AS adresse_cheque_25,
  m2_.utilisation_admin AS utilisation_admin_26,
  m2_.choix_parametre AS choix_parametre_27,
  m2_.description_sur_place AS description_sur_place_28,
  m1_.moyen_paiement_id AS moyen_paiement_id_29,
  m1_.utilisateur_id AS utilisateur_id_30,
  m1_.annulation_id AS annulation_id_31
FROM
  moyen_paiement m0_
  INNER JOIN mode_paiement_commande m1_ ON m0_.id = m1_.moyen_paiement_id
  LEFT JOIN moyen_paiement m2_ ON m1_.moyen_paiement_id = m2_.id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      commande_mode_paiement_commande c3_
    WHERE
      c3_.mode_paiement_commande_id = m1_.id
      AND c3_.commande_id IN (?)
  )

SELECT DISTINCT m0_.id AS id_0, m0_.nom AS nom_1, m0_.ordre_cheque AS ordre_cheque_2, m0_.adresse_cheque AS adresse_cheque_3, m0_.utilisation_admin AS utilisation_admin_4, m0_.choix_parametre AS choix_parametre_5, m0_.description_sur_place AS description_sur_place_6, m1_.id AS id_7, m1_.montant_paye AS montant_paye_8, m1_.numero_cheque AS numero_cheque_9, m1_.numero_avoir AS numero_avoir_10, m1_.avoir_utilise AS avoir_utilise_11, m1_.created_at AS created_at_12, m1_.fin_validite AS fin_validite_13, m1_.id_paiement AS id_paiement_14, m1_.id_lien_paiement_stripe AS id_lien_paiement_stripe_15, m1_.somme_remboursee AS somme_remboursee_16, m1_.paiement_plusieurs_fois AS paiement_plusieurs_fois_17, m1_.montant_attendu AS montant_attendu_18, m1_.order_id AS order_id_19, m1_.cancel_order AS cancel_order_20, m1_.date_utilisation_avoir AS date_utilisation_avoir_21, m2_.id AS id_22, m2_.nom AS nom_23, m2_.ordre_cheque AS ordre_cheque_24, m2_.adresse_cheque AS adresse_cheque_25, m2_.utilisation_admin AS utilisation_admin_26, m2_.choix_parametre AS choix_parametre_27, m2_.description_sur_place AS description_sur_place_28, m1_.moyen_paiement_id AS moyen_paiement_id_29, m1_.utilisateur_id AS utilisateur_id_30, m1_.annulation_id AS annulation_id_31 FROM moyen_paiement m0_ INNER JOIN mode_paiement_commande m1_ ON m0_.id = m1_.moyen_paiement_id LEFT JOIN moyen_paiement m2_ ON m1_.moyen_paiement_id = m2_.id WHERE EXISTS (SELECT 1 FROM commande_mode_paiement_commande c3_ WHERE c3_.mode_paiement_commande_id = m1_.id AND c3_.commande_id IN (1137));

SELECT
  t0.id AS id_1,
  t0.total_avant_reduc AS total_avant_reduc_2,
  t0.total_apres_reduc AS total_apres_reduc_3,
  t0.created_at AS created_at_4,
  t0.total_acompte AS total_acompte_5,
  t0.statut AS statut_6,
  t0.num_facture AS num_facture_7,
  t8.id AS id_9,
  t8.statut_paiement AS statut_paiement_10,
  t8.validation_admin AS validation_admin_11,
  t8.created_at AS created_at_12,
  t8.updated_at AS updated_at_13,
  t8.supprimer_commande_complete AS supprimer_commande_complete_14,
  t8.commentaire AS commentaire_15,
  t8.num_facture_avoir AS num_facture_avoir_16,
  t8.commande_id AS commande_id_17,
  t8.createur_id AS createur_id_18,
  t8.utilisateur_concerne_id AS utilisateur_concerne_id_19
FROM
  commande t0
  LEFT JOIN annulation t8 ON t8.commande_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.total_avant_reduc AS total_avant_reduc_2, t0.total_apres_reduc AS total_apres_reduc_3, t0.created_at AS created_at_4, t0.total_acompte AS total_acompte_5, t0.statut AS statut_6, t0.num_facture AS num_facture_7, t8.id AS id_9, t8.statut_paiement AS statut_paiement_10, t8.validation_admin AS validation_admin_11, t8.created_at AS created_at_12, t8.updated_at AS updated_at_13, t8.supprimer_commande_complete AS supprimer_commande_complete_14, t8.commentaire AS commentaire_15, t8.num_facture_avoir AS num_facture_avoir_16, t8.commande_id AS commande_id_17, t8.createur_id AS createur_id_18, t8.utilisateur_concerne_id AS utilisateur_concerne_id_19 FROM commande t0 LEFT JOIN annulation t8 ON t8.commande_id = t0.id WHERE t0.id = 1151;

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.nom AS nom_1,
  m0_.ordre_cheque AS ordre_cheque_2,
  m0_.adresse_cheque AS adresse_cheque_3,
  m0_.utilisation_admin AS utilisation_admin_4,
  m0_.choix_parametre AS choix_parametre_5,
  m0_.description_sur_place AS description_sur_place_6,
  m1_.id AS id_7,
  m1_.montant_paye AS montant_paye_8,
  m1_.numero_cheque AS numero_cheque_9,
  m1_.numero_avoir AS numero_avoir_10,
  m1_.avoir_utilise AS avoir_utilise_11,
  m1_.created_at AS created_at_12,
  m1_.fin_validite AS fin_validite_13,
  m1_.id_paiement AS id_paiement_14,
  m1_.id_lien_paiement_stripe AS id_lien_paiement_stripe_15,
  m1_.somme_remboursee AS somme_remboursee_16,
  m1_.paiement_plusieurs_fois AS paiement_plusieurs_fois_17,
  m1_.montant_attendu AS montant_attendu_18,
  m1_.order_id AS order_id_19,
  m1_.cancel_order AS cancel_order_20,
  m1_.date_utilisation_avoir AS date_utilisation_avoir_21,
  m2_.id AS id_22,
  m2_.nom AS nom_23,
  m2_.ordre_cheque AS ordre_cheque_24,
  m2_.adresse_cheque AS adresse_cheque_25,
  m2_.utilisation_admin AS utilisation_admin_26,
  m2_.choix_parametre AS choix_parametre_27,
  m2_.description_sur_place AS description_sur_place_28,
  m1_.moyen_paiement_id AS moyen_paiement_id_29,
  m1_.utilisateur_id AS utilisateur_id_30,
  m1_.annulation_id AS annulation_id_31
FROM
  moyen_paiement m0_
  INNER JOIN mode_paiement_commande m1_ ON m0_.id = m1_.moyen_paiement_id
  LEFT JOIN moyen_paiement m2_ ON m1_.moyen_paiement_id = m2_.id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      commande_mode_paiement_commande c3_
    WHERE
      c3_.mode_paiement_commande_id = m1_.id
      AND c3_.commande_id IN (?)
  )

SELECT DISTINCT m0_.id AS id_0, m0_.nom AS nom_1, m0_.ordre_cheque AS ordre_cheque_2, m0_.adresse_cheque AS adresse_cheque_3, m0_.utilisation_admin AS utilisation_admin_4, m0_.choix_parametre AS choix_parametre_5, m0_.description_sur_place AS description_sur_place_6, m1_.id AS id_7, m1_.montant_paye AS montant_paye_8, m1_.numero_cheque AS numero_cheque_9, m1_.numero_avoir AS numero_avoir_10, m1_.avoir_utilise AS avoir_utilise_11, m1_.created_at AS created_at_12, m1_.fin_validite AS fin_validite_13, m1_.id_paiement AS id_paiement_14, m1_.id_lien_paiement_stripe AS id_lien_paiement_stripe_15, m1_.somme_remboursee AS somme_remboursee_16, m1_.paiement_plusieurs_fois AS paiement_plusieurs_fois_17, m1_.montant_attendu AS montant_attendu_18, m1_.order_id AS order_id_19, m1_.cancel_order AS cancel_order_20, m1_.date_utilisation_avoir AS date_utilisation_avoir_21, m2_.id AS id_22, m2_.nom AS nom_23, m2_.ordre_cheque AS ordre_cheque_24, m2_.adresse_cheque AS adresse_cheque_25, m2_.utilisation_admin AS utilisation_admin_26, m2_.choix_parametre AS choix_parametre_27, m2_.description_sur_place AS description_sur_place_28, m1_.moyen_paiement_id AS moyen_paiement_id_29, m1_.utilisateur_id AS utilisateur_id_30, m1_.annulation_id AS annulation_id_31 FROM moyen_paiement m0_ INNER JOIN mode_paiement_commande m1_ ON m0_.id = m1_.moyen_paiement_id LEFT JOIN moyen_paiement m2_ ON m1_.moyen_paiement_id = m2_.id WHERE EXISTS (SELECT 1 FROM commande_mode_paiement_commande c3_ WHERE c3_.mode_paiement_commande_id = m1_.id AND c3_.commande_id IN (1151));

SELECT
  t0.id AS id_1,
  t0.total_avant_reduc AS total_avant_reduc_2,
  t0.total_apres_reduc AS total_apres_reduc_3,
  t0.created_at AS created_at_4,
  t0.total_acompte AS total_acompte_5,
  t0.statut AS statut_6,
  t0.num_facture AS num_facture_7,
  t8.id AS id_9,
  t8.statut_paiement AS statut_paiement_10,
  t8.validation_admin AS validation_admin_11,
  t8.created_at AS created_at_12,
  t8.updated_at AS updated_at_13,
  t8.supprimer_commande_complete AS supprimer_commande_complete_14,
  t8.commentaire AS commentaire_15,
  t8.num_facture_avoir AS num_facture_avoir_16,
  t8.commande_id AS commande_id_17,
  t8.createur_id AS createur_id_18,
  t8.utilisateur_concerne_id AS utilisateur_concerne_id_19
FROM
  commande t0
  LEFT JOIN annulation t8 ON t8.commande_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.total_avant_reduc AS total_avant_reduc_2, t0.total_apres_reduc AS total_apres_reduc_3, t0.created_at AS created_at_4, t0.total_acompte AS total_acompte_5, t0.statut AS statut_6, t0.num_facture AS num_facture_7, t8.id AS id_9, t8.statut_paiement AS statut_paiement_10, t8.validation_admin AS validation_admin_11, t8.created_at AS created_at_12, t8.updated_at AS updated_at_13, t8.supprimer_commande_complete AS supprimer_commande_complete_14, t8.commentaire AS commentaire_15, t8.num_facture_avoir AS num_facture_avoir_16, t8.commande_id AS commande_id_17, t8.createur_id AS createur_id_18, t8.utilisateur_concerne_id AS utilisateur_concerne_id_19 FROM commande t0 LEFT JOIN annulation t8 ON t8.commande_id = t0.id WHERE t0.id = 1157;

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.nom AS nom_1,
  m0_.ordre_cheque AS ordre_cheque_2,
  m0_.adresse_cheque AS adresse_cheque_3,
  m0_.utilisation_admin AS utilisation_admin_4,
  m0_.choix_parametre AS choix_parametre_5,
  m0_.description_sur_place AS description_sur_place_6,
  m1_.id AS id_7,
  m1_.montant_paye AS montant_paye_8,
  m1_.numero_cheque AS numero_cheque_9,
  m1_.numero_avoir AS numero_avoir_10,
  m1_.avoir_utilise AS avoir_utilise_11,
  m1_.created_at AS created_at_12,
  m1_.fin_validite AS fin_validite_13,
  m1_.id_paiement AS id_paiement_14,
  m1_.id_lien_paiement_stripe AS id_lien_paiement_stripe_15,
  m1_.somme_remboursee AS somme_remboursee_16,
  m1_.paiement_plusieurs_fois AS paiement_plusieurs_fois_17,
  m1_.montant_attendu AS montant_attendu_18,
  m1_.order_id AS order_id_19,
  m1_.cancel_order AS cancel_order_20,
  m1_.date_utilisation_avoir AS date_utilisation_avoir_21,
  m2_.id AS id_22,
  m2_.nom AS nom_23,
  m2_.ordre_cheque AS ordre_cheque_24,
  m2_.adresse_cheque AS adresse_cheque_25,
  m2_.utilisation_admin AS utilisation_admin_26,
  m2_.choix_parametre AS choix_parametre_27,
  m2_.description_sur_place AS description_sur_place_28,
  m1_.moyen_paiement_id AS moyen_paiement_id_29,
  m1_.utilisateur_id AS utilisateur_id_30,
  m1_.annulation_id AS annulation_id_31
FROM
  moyen_paiement m0_
  INNER JOIN mode_paiement_commande m1_ ON m0_.id = m1_.moyen_paiement_id
  LEFT JOIN moyen_paiement m2_ ON m1_.moyen_paiement_id = m2_.id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      commande_mode_paiement_commande c3_
    WHERE
      c3_.mode_paiement_commande_id = m1_.id
      AND c3_.commande_id IN (?)
  )

SELECT DISTINCT m0_.id AS id_0, m0_.nom AS nom_1, m0_.ordre_cheque AS ordre_cheque_2, m0_.adresse_cheque AS adresse_cheque_3, m0_.utilisation_admin AS utilisation_admin_4, m0_.choix_parametre AS choix_parametre_5, m0_.description_sur_place AS description_sur_place_6, m1_.id AS id_7, m1_.montant_paye AS montant_paye_8, m1_.numero_cheque AS numero_cheque_9, m1_.numero_avoir AS numero_avoir_10, m1_.avoir_utilise AS avoir_utilise_11, m1_.created_at AS created_at_12, m1_.fin_validite AS fin_validite_13, m1_.id_paiement AS id_paiement_14, m1_.id_lien_paiement_stripe AS id_lien_paiement_stripe_15, m1_.somme_remboursee AS somme_remboursee_16, m1_.paiement_plusieurs_fois AS paiement_plusieurs_fois_17, m1_.montant_attendu AS montant_attendu_18, m1_.order_id AS order_id_19, m1_.cancel_order AS cancel_order_20, m1_.date_utilisation_avoir AS date_utilisation_avoir_21, m2_.id AS id_22, m2_.nom AS nom_23, m2_.ordre_cheque AS ordre_cheque_24, m2_.adresse_cheque AS adresse_cheque_25, m2_.utilisation_admin AS utilisation_admin_26, m2_.choix_parametre AS choix_parametre_27, m2_.description_sur_place AS description_sur_place_28, m1_.moyen_paiement_id AS moyen_paiement_id_29, m1_.utilisateur_id AS utilisateur_id_30, m1_.annulation_id AS annulation_id_31 FROM moyen_paiement m0_ INNER JOIN mode_paiement_commande m1_ ON m0_.id = m1_.moyen_paiement_id LEFT JOIN moyen_paiement m2_ ON m1_.moyen_paiement_id = m2_.id WHERE EXISTS (SELECT 1 FROM commande_mode_paiement_commande c3_ WHERE c3_.mode_paiement_commande_id = m1_.id AND c3_.commande_id IN (1157));

SELECT
  t0.id AS id_1,
  t0.total_avant_reduc AS total_avant_reduc_2,
  t0.total_apres_reduc AS total_apres_reduc_3,
  t0.created_at AS created_at_4,
  t0.total_acompte AS total_acompte_5,
  t0.statut AS statut_6,
  t0.num_facture AS num_facture_7,
  t8.id AS id_9,
  t8.statut_paiement AS statut_paiement_10,
  t8.validation_admin AS validation_admin_11,
  t8.created_at AS created_at_12,
  t8.updated_at AS updated_at_13,
  t8.supprimer_commande_complete AS supprimer_commande_complete_14,
  t8.commentaire AS commentaire_15,
  t8.num_facture_avoir AS num_facture_avoir_16,
  t8.commande_id AS commande_id_17,
  t8.createur_id AS createur_id_18,
  t8.utilisateur_concerne_id AS utilisateur_concerne_id_19
FROM
  commande t0
  LEFT JOIN annulation t8 ON t8.commande_id = t0.id
WHERE
  t0.id = ?