Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.status AS status_3,
  t0.nb_personnes AS nb_personnes_4,
  t0.montant_frais_dossier_eur AS montant_frais_dossier_eur_5,
  t0.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_6,
  t0.montant_frais_dossier_chf AS montant_frais_dossier_chf_7,
  t0.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_8,
  t0.sous_total_du_eur AS sous_total_du_eur_9,
  t0.sous_total_eur AS sous_total_eur_10,
  t0.sous_total_du_chf AS sous_total_du_chf_11,
  t0.sous_total_chf AS sous_total_chf_12,
  t0.assurance AS assurance_13,
  t0.taux_change_chf_to_eur AS taux_change_chf_to_eur_14,
  t0.remarque_client AS remarque_client_15,
  t0.ref_commande AS ref_commande_16,
  t0.delai_annulation AS delai_annulation_17,
  t0.litige AS litige_18,
  t0.motif_litige AS motif_litige_19,
  t0.commentaire_litige AS commentaire_litige_20,
  t0.frais_annulation_eur AS frais_annulation_eur_21,
  t0.frais_annulation_chf AS frais_annulation_chf_22,
  t0.last_action AS last_action_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.created_by AS created_by_26,
  t0.updated_by AS updated_by_27,
  t0.client_id AS client_id_28,
  t0.circuit_id AS circuit_id_29,
  t0.cancelled_command_id AS cancelled_command_id_30,
  t31.id AS id_32,
  t31.date AS date_33,
  t31.status AS status_34,
  t31.nb_personnes AS nb_personnes_35,
  t31.montant_frais_dossier_eur AS montant_frais_dossier_eur_36,
  t31.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_37,
  t31.montant_frais_dossier_chf AS montant_frais_dossier_chf_38,
  t31.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_39,
  t31.sous_total_du_eur AS sous_total_du_eur_40,
  t31.sous_total_eur AS sous_total_eur_41,
  t31.sous_total_du_chf AS sous_total_du_chf_42,
  t31.sous_total_chf AS sous_total_chf_43,
  t31.assurance AS assurance_44,
  t31.taux_change_chf_to_eur AS taux_change_chf_to_eur_45,
  t31.remarque_client AS remarque_client_46,
  t31.ref_commande AS ref_commande_47,
  t31.delai_annulation AS delai_annulation_48,
  t31.litige AS litige_49,
  t31.motif_litige AS motif_litige_50,
  t31.commentaire_litige AS commentaire_litige_51,
  t31.frais_annulation_eur AS frais_annulation_eur_52,
  t31.frais_annulation_chf AS frais_annulation_chf_53,
  t31.last_action AS last_action_54,
  t31.created_at AS created_at_55,
  t31.updated_at AS updated_at_56,
  t31.created_by AS created_by_57,
  t31.updated_by AS updated_by_58,
  t31.client_id AS client_id_59,
  t31.circuit_id AS circuit_id_60,
  t31.cancelled_command_id AS cancelled_command_id_61
FROM
  commande t0
  LEFT JOIN commande t31 ON t31.cancelled_command_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.status AS status_3, t0.nb_personnes AS nb_personnes_4, t0.montant_frais_dossier_eur AS montant_frais_dossier_eur_5, t0.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_6, t0.montant_frais_dossier_chf AS montant_frais_dossier_chf_7, t0.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_8, t0.sous_total_du_eur AS sous_total_du_eur_9, t0.sous_total_eur AS sous_total_eur_10, t0.sous_total_du_chf AS sous_total_du_chf_11, t0.sous_total_chf AS sous_total_chf_12, t0.assurance AS assurance_13, t0.taux_change_chf_to_eur AS taux_change_chf_to_eur_14, t0.remarque_client AS remarque_client_15, t0.ref_commande AS ref_commande_16, t0.delai_annulation AS delai_annulation_17, t0.litige AS litige_18, t0.motif_litige AS motif_litige_19, t0.commentaire_litige AS commentaire_litige_20, t0.frais_annulation_eur AS frais_annulation_eur_21, t0.frais_annulation_chf AS frais_annulation_chf_22, t0.last_action AS last_action_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.client_id AS client_id_28, t0.circuit_id AS circuit_id_29, t0.cancelled_command_id AS cancelled_command_id_30, t31.id AS id_32, t31.date AS date_33, t31.status AS status_34, t31.nb_personnes AS nb_personnes_35, t31.montant_frais_dossier_eur AS montant_frais_dossier_eur_36, t31.montant_assurance_annulation_eur AS montant_assurance_annulation_eur_37, t31.montant_frais_dossier_chf AS montant_frais_dossier_chf_38, t31.montant_assurance_annulation_chf AS montant_assurance_annulation_chf_39, t31.sous_total_du_eur AS sous_total_du_eur_40, t31.sous_total_eur AS sous_total_eur_41, t31.sous_total_du_chf AS sous_total_du_chf_42, t31.sous_total_chf AS sous_total_chf_43, t31.assurance AS assurance_44, t31.taux_change_chf_to_eur AS taux_change_chf_to_eur_45, t31.remarque_client AS remarque_client_46, t31.ref_commande AS ref_commande_47, t31.delai_annulation AS delai_annulation_48, t31.litige AS litige_49, t31.motif_litige AS motif_litige_50, t31.commentaire_litige AS commentaire_litige_51, t31.frais_annulation_eur AS frais_annulation_eur_52, t31.frais_annulation_chf AS frais_annulation_chf_53, t31.last_action AS last_action_54, t31.created_at AS created_at_55, t31.updated_at AS updated_at_56, t31.created_by AS created_by_57, t31.updated_by AS updated_by_58, t31.client_id AS client_id_59, t31.circuit_id AS circuit_id_60, t31.cancelled_command_id AS cancelled_command_id_61 FROM commande t0 LEFT JOIN commande t31 ON t31.cancelled_command_id = t0.id WHERE t0.id = '401783';

SELECT
  t0.id AS id_1,
  t0.montant_paye AS montant_paye_2,
  t0.montant_du AS montant_du_3,
  t0.montant_total AS montant_total_4,
  t0.delai_annulation AS delai_annulation_5,
  t0.status AS status_6,
  t0.calc_date_arrivee AS calc_date_arrivee_7,
  t0.calc_date_depart AS calc_date_depart_8,
  t0.montant_rembourse AS montant_rembourse_9,
  t0.note_interne AS note_interne_10,
  t0.pms_reservation_id AS pms_reservation_id_11,
  t0.mail_refuge_sent AS mail_refuge_sent_12,
  t0.frais_annulation AS frais_annulation_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.created_by AS created_by_16,
  t0.updated_by AS updated_by_17,
  t0.refuge_id AS refuge_id_18,
  t0.currency_id AS currency_id_19,
  t0.commande_id AS commande_id_20,
  t21.id AS id_22,
  t21.status AS status_23,
  t21.request_xml AS request_xml_24,
  t21.scheduled_at AS scheduled_at_25,
  t21.created_at AS created_at_26,
  t21.updated_at AS updated_at_27,
  t21.created_by AS created_by_28,
  t21.updated_by AS updated_by_29,
  t21.reservation_id AS reservation_id_30,
  t21.refuge_id AS refuge_id_31,
  t0.cancelled_reservation_id AS cancelled_reservation_id_32,
  t33.id AS id_34,
  t33.montant_paye AS montant_paye_35,
  t33.montant_du AS montant_du_36,
  t33.montant_total AS montant_total_37,
  t33.delai_annulation AS delai_annulation_38,
  t33.status AS status_39,
  t33.calc_date_arrivee AS calc_date_arrivee_40,
  t33.calc_date_depart AS calc_date_depart_41,
  t33.montant_rembourse AS montant_rembourse_42,
  t33.note_interne AS note_interne_43,
  t33.pms_reservation_id AS pms_reservation_id_44,
  t33.mail_refuge_sent AS mail_refuge_sent_45,
  t33.frais_annulation AS frais_annulation_46,
  t33.created_at AS created_at_47,
  t33.updated_at AS updated_at_48,
  t33.created_by AS created_by_49,
  t33.updated_by AS updated_by_50,
  t33.refuge_id AS refuge_id_51,
  t33.currency_id AS currency_id_52,
  t33.commande_id AS commande_id_53,
  t33.cancelled_reservation_id AS cancelled_reservation_id_54
FROM
  reservation t0
  LEFT JOIN pms_booking_dispatch t21 ON t21.reservation_id = t0.id
  LEFT JOIN reservation t33 ON t33.cancelled_reservation_id = t0.id
WHERE
  t0.commande_id = ?

SELECT t0.id AS id_1, t0.montant_paye AS montant_paye_2, t0.montant_du AS montant_du_3, t0.montant_total AS montant_total_4, t0.delai_annulation AS delai_annulation_5, t0.status AS status_6, t0.calc_date_arrivee AS calc_date_arrivee_7, t0.calc_date_depart AS calc_date_depart_8, t0.montant_rembourse AS montant_rembourse_9, t0.note_interne AS note_interne_10, t0.pms_reservation_id AS pms_reservation_id_11, t0.mail_refuge_sent AS mail_refuge_sent_12, t0.frais_annulation AS frais_annulation_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.refuge_id AS refuge_id_18, t0.currency_id AS currency_id_19, t0.commande_id AS commande_id_20, t21.id AS id_22, t21.status AS status_23, t21.request_xml AS request_xml_24, t21.scheduled_at AS scheduled_at_25, t21.created_at AS created_at_26, t21.updated_at AS updated_at_27, t21.created_by AS created_by_28, t21.updated_by AS updated_by_29, t21.reservation_id AS reservation_id_30, t21.refuge_id AS refuge_id_31, t0.cancelled_reservation_id AS cancelled_reservation_id_32, t33.id AS id_34, t33.montant_paye AS montant_paye_35, t33.montant_du AS montant_du_36, t33.montant_total AS montant_total_37, t33.delai_annulation AS delai_annulation_38, t33.status AS status_39, t33.calc_date_arrivee AS calc_date_arrivee_40, t33.calc_date_depart AS calc_date_depart_41, t33.montant_rembourse AS montant_rembourse_42, t33.note_interne AS note_interne_43, t33.pms_reservation_id AS pms_reservation_id_44, t33.mail_refuge_sent AS mail_refuge_sent_45, t33.frais_annulation AS frais_annulation_46, t33.created_at AS created_at_47, t33.updated_at AS updated_at_48, t33.created_by AS created_by_49, t33.updated_by AS updated_by_50, t33.refuge_id AS refuge_id_51, t33.currency_id AS currency_id_52, t33.commande_id AS commande_id_53, t33.cancelled_reservation_id AS cancelled_reservation_id_54 FROM reservation t0 LEFT JOIN pms_booking_dispatch t21 ON t21.reservation_id = t0.id LEFT JOIN reservation t33 ON t33.cancelled_reservation_id = t0.id WHERE t0.commande_id = 401783;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.connect_id AS connect_id_6,
  t0.username AS username_7,
  t0.actif AS actif_8,
  t0.last_login AS last_login_9,
  t0.locale AS locale_10,
  t0.profil_id AS profil_id_11,
  t0.refuge_id AS refuge_id_12
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.connect_id AS connect_id_6, t0.username AS username_7, t0.actif AS actif_8, t0.last_login AS last_login_9, t0.locale AS locale_10, t0.profil_id AS profil_id_11, t0.refuge_id AS refuge_id_12 FROM user t0 WHERE t0.id = 19;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.symbol AS symbol_3,
  t0.prefix AS prefix_4,
  t0.suffix AS suffix_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9
FROM
  currency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.symbol AS symbol_3, t0.prefix AS prefix_4, t0.suffix AS suffix_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM currency t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_role AS is_role_3,
  t0.active AS active_4,
  t0.required_role AS required_role_5,
  t0.rank AS rank_6,
  t0.label AS label_7
FROM
  lle_credential_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_role AS is_role_3, t0.active AS active_4, t0.required_role AS required_role_5, t0.rank AS rank_6, t0.label AS label_7 FROM lle_credential_group t0 WHERE t0.id = 3;