Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.signature_mail AS signature_mail_2,
  t0.texte_facture AS texte_facture_3,
  t0.logo AS logo_4,
  t0.afficher_donnees_import AS afficher_donnees_import_5,
  t0.date AS date_6,
  t0.en_inventaire AS en_inventaire_7,
  t0.date_debut_inventaire AS date_debut_inventaire_8,
  t0.date_fin_inventaire AS date_fin_inventaire_9,
  t0.date_maj AS date_maj_10,
  t0.libelle AS libelle_11,
  t0.capital AS capital_12,
  t0.rcs AS rcs_13,
  t0.numTva AS numTva_14,
  t0.adresse AS adresse_15,
  t0.adresse_complementaire AS adresse_complementaire_16,
  t0.code_postal AS code_postal_17,
  t0.ville AS ville_18,
  t0.pays AS pays_19,
  t0.telephone AS telephone_20,
  t0.fax AS fax_21,
  t0.siteWeb AS siteWeb_22,
  t0.siret AS siret_23,
  t0.ape AS ape_24,
  t0.email AS email_25,
  t0.emailTest AS emailTest_26,
  t0.mailTest AS mailTest_27,
  t0.dateDebutExercice AS dateDebutExercice_28,
  t0.dateFinExercice AS dateFinExercice_29,
  t0.note_service AS note_service_30,
  t0.mailer_user AS mailer_user_31,
  t0.mailer_password AS mailer_password_32,
  t0.mailer_host AS mailer_host_33,
  t0.mailer_port AS mailer_port_34,
  t0.bandeau_email AS bandeau_email_35,
  t0.date_debut_texte_bandeau AS date_debut_texte_bandeau_36,
  t0.date_fin_texte_bandeau AS date_fin_texte_bandeau_37,
  t0.statut_texte_bandeau AS statut_texte_bandeau_38,
  t0.utilisateur_id AS utilisateur_id_39,
  t0.famille_compta_frais_fixe_id AS famille_compta_frais_fixe_id_40,
  t0.famille_compta_frais_port_id AS famille_compta_frais_port_id_41,
  t0.famille_compta_frais_annexes_id AS famille_compta_frais_annexes_id_42
FROM
  societe__societe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.signature_mail AS signature_mail_2, t0.texte_facture AS texte_facture_3, t0.logo AS logo_4, t0.afficher_donnees_import AS afficher_donnees_import_5, t0.date AS date_6, t0.en_inventaire AS en_inventaire_7, t0.date_debut_inventaire AS date_debut_inventaire_8, t0.date_fin_inventaire AS date_fin_inventaire_9, t0.date_maj AS date_maj_10, t0.libelle AS libelle_11, t0.capital AS capital_12, t0.rcs AS rcs_13, t0.numTva AS numTva_14, t0.adresse AS adresse_15, t0.adresse_complementaire AS adresse_complementaire_16, t0.code_postal AS code_postal_17, t0.ville AS ville_18, t0.pays AS pays_19, t0.telephone AS telephone_20, t0.fax AS fax_21, t0.siteWeb AS siteWeb_22, t0.siret AS siret_23, t0.ape AS ape_24, t0.email AS email_25, t0.emailTest AS emailTest_26, t0.mailTest AS mailTest_27, t0.dateDebutExercice AS dateDebutExercice_28, t0.dateFinExercice AS dateFinExercice_29, t0.note_service AS note_service_30, t0.mailer_user AS mailer_user_31, t0.mailer_password AS mailer_password_32, t0.mailer_host AS mailer_host_33, t0.mailer_port AS mailer_port_34, t0.bandeau_email AS bandeau_email_35, t0.date_debut_texte_bandeau AS date_debut_texte_bandeau_36, t0.date_fin_texte_bandeau AS date_fin_texte_bandeau_37, t0.statut_texte_bandeau AS statut_texte_bandeau_38, t0.utilisateur_id AS utilisateur_id_39, t0.famille_compta_frais_fixe_id AS famille_compta_frais_fixe_id_40, t0.famille_compta_frais_port_id AS famille_compta_frais_port_id_41, t0.famille_compta_frais_annexes_id AS famille_compta_frais_annexes_id_42 FROM societe__societe t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.document_commercial_id AS document_commercial_id_2,
  t0.ordre AS ordre_3,
  t0.libelle AS libelle_4,
  t0.date AS date_5,
  t0.dateMaj AS dateMaj_6,
  t0.dateSuppression AS dateSuppression_7,
  t0.action_statut_commande_id AS action_statut_commande_id_8,
  t0.utilisateur_id AS utilisateur_id_9
FROM
  commerciale__statut_commande t0
WHERE
  t0.document_commercial_id = ?
  AND t0.ordre = ?
  AND (
    (t0.dateSuppression IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.document_commercial_id AS document_commercial_id_2, t0.ordre AS ordre_3, t0.libelle AS libelle_4, t0.date AS date_5, t0.dateMaj AS dateMaj_6, t0.dateSuppression AS dateSuppression_7, t0.action_statut_commande_id AS action_statut_commande_id_8, t0.utilisateur_id AS utilisateur_id_9 FROM commerciale__statut_commande t0 WHERE t0.document_commercial_id = 14 AND t0.ordre = '1' AND ((t0.dateSuppression IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.a_bloquer AS a_bloquer_2,
  t0.canal_vente AS canal_vente_3,
  t0.reference_market_place AS reference_market_place_4,
  t0.bascule_comptabilite AS bascule_comptabilite_5,
  t0.kilometrage AS kilometrage_6,
  t0.duree_validite AS duree_validite_7,
  t0.delai_relance AS delai_relance_8,
  t0.modifiable AS modifiable_9,
  t0.bp_auto AS bp_auto_10,
  t0.avoir_utilise AS avoir_utilise_11,
  t0.franco_port AS franco_port_12,
  t0.avecTaxe AS avecTaxe_13,
  t0.visible AS visible_14,
  t0.marge AS marge_15,
  t0.taux_marge AS taux_marge_16,
  t0.texte_facture AS texte_facture_17,
  t0.type_document_commercial_id AS type_document_commercial_id_18,
  t0.nb_colis AS nb_colis_19,
  t0.date_insertion AS date_insertion_20,
  t0.date_echeance AS date_echeance_21,
  t0.date_confirmation_preparation AS date_confirmation_preparation_22,
  t0.date_confirmation_expedition AS date_confirmation_expedition_23,
  t0.date_premiere_confirmation_expedition AS date_premiere_confirmation_expedition_24,
  t0.date_force_expedie AS date_force_expedie_25,
  t0.date_force_annule AS date_force_annule_26,
  t0.delai_livraison AS delai_livraison_27,
  t0.date_relance AS date_relance_28,
  t0.date_approximative_reception AS date_approximative_reception_29,
  t0.date_expedition AS date_expedition_30,
  t0.date_bon AS date_bon_31,
  t0.date_annulation AS date_annulation_32,
  t0.date AS date_33,
  t0.dateMaj AS dateMaj_34,
  t0.dateSuppression AS dateSuppression_35,
  t0.numero_reference AS numero_reference_36,
  t0.numero_suivi AS numero_suivi_37,
  t0.reference AS reference_38,
  t0.reference_prestashop AS reference_prestashop_39,
  t0.origine_saisie AS origine_saisie_40,
  t0.origine AS origine_41,
  t0.id_import AS id_import_42,
  t0.valide_manuellement AS valide_manuellement_43,
  t0.perdu AS perdu_44,
  t0.total_tva AS total_tva_45,
  t0.frais_port_supplementaire AS frais_port_supplementaire_46,
  t0.taux_tva_frais_port AS taux_tva_frais_port_47,
  t0.total_frais_port AS total_frais_port_48,
  t0.total_frais_port_ttc AS total_frais_port_ttc_49,
  t0.total_tva_frais_port AS total_tva_frais_port_50,
  t0.total_poids AS total_poids_51,
  t0.total_ttc AS total_ttc_52,
  t0.total AS total_53,
  t0.total_ht_avec_frais_port AS total_ht_avec_frais_port_54,
  t0.ville_livraison_txt AS ville_livraison_txt_55,
  t0.pays_livraison_txt AS pays_livraison_txt_56,
  t0.code_postal_livraison_txt AS code_postal_livraison_txt_57,
  t0.libelle_livraison AS libelle_livraison_58,
  t0.numero_livraison AS numero_livraison_59,
  t0.rue_livraison AS rue_livraison_60,
  t0.complement_livraison AS complement_livraison_61,
  t0.complement_livraison_2 AS complement_livraison_2_62,
  t0.pays_facturation_txt AS pays_facturation_txt_63,
  t0.ville_facturation_txt AS ville_facturation_txt_64,
  t0.code_postal_facturation_txt AS code_postal_facturation_txt_65,
  t0.libelle_facturation AS libelle_facturation_66,
  t0.numero_facturation AS numero_facturation_67,
  t0.rue_facturation AS rue_facturation_68,
  t0.complement_facturation AS complement_facturation_69,
  t0.complement_facturation_2 AS complement_facturation_2_70,
  t0.reference_client AS reference_client_71,
  t0.commentaire AS commentaire_72,
  t0.travaux AS travaux_73,
  t0.commentaire_annulation AS commentaire_annulation_74,
  t0.temps_passe AS temps_passe_75,
  t0.temps_facture AS temps_facture_76,
  t0.a_facturer AS a_facturer_77,
  t0.deja_facture AS deja_facture_78,
  t0.multi_bl AS multi_bl_79,
  t0.attente_facturation AS attente_facturation_80,
  t0.date_validation_bat AS date_validation_bat_81,
  t0.statut_bat AS statut_bat_82,
  t0.date_transfert_compta AS date_transfert_compta_83,
  t0.numero_lettrage AS numero_lettrage_84,
  t0.lettrage AS lettrage_85,
  t0.solde AS solde_86,
  t0.statut_a_modifier AS statut_a_modifier_87,
  t0.prenom AS prenom_88,
  t0.nom AS nom_89,
  t0.prenom_facturation AS prenom_facturation_90,
  t0.nom_facturation AS nom_facturation_91,
  t0.civilite AS civilite_92,
  t0.date_reception_fournisseur AS date_reception_fournisseur_93,
  t0.date_livraison_souhaitee AS date_livraison_souhaitee_94,
  t0.date_livraison_theorique AS date_livraison_theorique_95,
  t0.date_expedition_theorique AS date_expedition_theorique_96,
  t0.telephone AS telephone_97,
  t0.telephone2 AS telephone2_98,
  t0.email AS email_99,
  t0.telephone_facturation AS telephone_facturation_100,
  t0.telephone_facturation2 AS telephone_facturation2_101,
  t0.adresse_validee_manuellement AS adresse_validee_manuellement_102,
  t0.date_export_bext AS date_export_bext_103,
  t0.date_max_expedition_min AS date_max_expedition_min_104,
  t0.date_max_expedition_max AS date_max_expedition_max_105,
  t0.maj AS maj_106,
  t0.archive AS archive_107,
  t0.code_iso_facturation AS code_iso_facturation_108,
  t0.state_or_province_facturation AS state_or_province_facturation_109,
  t0.code_iso_livraison AS code_iso_livraison_110,
  t0.state_or_province_livraison AS state_or_province_livraison_111,
  t0.date_mail_facture AS date_mail_facture_112,
  t0.date_calcul_marge AS date_calcul_marge_113,
  t0.point_retrait AS point_retrait_114,
  t0.delivery_mode AS delivery_mode_115,
  t0.total_ttc_devise AS total_ttc_devise_116,
  t0.taux_change AS taux_change_117,
  t0.sended_to_oqton AS sended_to_oqton_118,
  t0.payplug_id AS payplug_id_119,
  t0.telephone_livraison AS telephone_livraison_120,
  t0.email_livraison AS email_livraison_121,
  t0.payplug_montant AS payplug_montant_122,
  t0.statut_attente AS statut_attente_123,
  t0.niveau_un_id AS niveau_un_id_124,
  t0.projet_id AS projet_id_125,
  t0.taxe_id AS taxe_id_126,
  t0.taxe_frais_port_id AS taxe_frais_port_id_127,
  t0.compte_market_place_id AS compte_market_place_id_128,
  t0.rapport_bext_id AS rapport_bext_id_129,
  t0.statut_commande_market_place_id AS statut_commande_market_place_id_130,
  t0.vehicules_client_id AS vehicules_client_id_131,
  t0.devis_id AS devis_id_132,
  t0.facture_id AS facture_id_133,
  t0.bl_id AS bl_id_134,
  t0.bp_id AS bp_id_135,
  t0.commande_id AS commande_id_136,
  t0.contact_livraison_id AS contact_livraison_id_137,
  t0.contact_facturation_id AS contact_facturation_id_138,
  t0.contact_acheteur_id AS contact_acheteur_id_139,
  t0.client_id AS client_id_140,
  t0.raison_anomalie_id AS raison_anomalie_id_141,
  t0.transporteur_id AS transporteur_id_142,
  t0.statut_paiement_id AS statut_paiement_id_143,
  t0.statut_commande_id AS statut_commande_id_144,
  t0.etat_commande_id AS etat_commande_id_145,
  t0.utilisateur_id AS utilisateur_id_146,
  t0.createur_id AS createur_id_147,
  t0.utilisateur_valide_manuellement_id AS utilisateur_valide_manuellement_id_148,
  t0.mecanicien_id AS mecanicien_id_149,
  t0.secteur_geographique_id AS secteur_geographique_id_150,
  t0.commercial_id AS commercial_id_151,
  t0.assistante_commercial_id AS assistante_commercial_id_152,
  t0.adresse_livraison_id AS adresse_livraison_id_153,
  t0.pays_livraison_id AS pays_livraison_id_154,
  t0.ville_livraison_id AS ville_livraison_id_155,
  t0.code_postal_livraison_id AS code_postal_livraison_id_156,
  t0.adresse_facturation_id AS adresse_facturation_id_157,
  t0.pays_facturation_id AS pays_facturation_id_158,
  t0.ville_facturation_id AS ville_facturation_id_159,
  t0.code_postal_facturation_id AS code_postal_facturation_id_160,
  t0.modereglement_id AS modereglement_id_161,
  t0.mode_reglement_market_place_id AS mode_reglement_market_place_id_162,
  t0.delai_paiement_id AS delai_paiement_id_163,
  t0.lcr_id AS lcr_id_164,
  t0.mode_expedition_id AS mode_expedition_id_165,
  t0.commande_parent_id AS commande_parent_id_166,
  t0.devise_id AS devise_id_167,
  t0.export_compta_id AS export_compta_id_168,
  t0.rapport_cloture_id AS rapport_cloture_id_169,
  t0.caisse_id AS caisse_id_170
FROM
  commerciale__commande t0
WHERE
  t0.statut_commande_id IS NULL
  AND t0.utilisateur_id IS NULL
  AND t0.type_document_commercial_id = ?
  AND (
    (t0.dateSuppression IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.a_bloquer AS a_bloquer_2, t0.canal_vente AS canal_vente_3, t0.reference_market_place AS reference_market_place_4, t0.bascule_comptabilite AS bascule_comptabilite_5, t0.kilometrage AS kilometrage_6, t0.duree_validite AS duree_validite_7, t0.delai_relance AS delai_relance_8, t0.modifiable AS modifiable_9, t0.bp_auto AS bp_auto_10, t0.avoir_utilise AS avoir_utilise_11, t0.franco_port AS franco_port_12, t0.avecTaxe AS avecTaxe_13, t0.visible AS visible_14, t0.marge AS marge_15, t0.taux_marge AS taux_marge_16, t0.texte_facture AS texte_facture_17, t0.type_document_commercial_id AS type_document_commercial_id_18, t0.nb_colis AS nb_colis_19, t0.date_insertion AS date_insertion_20, t0.date_echeance AS date_echeance_21, t0.date_confirmation_preparation AS date_confirmation_preparation_22, t0.date_confirmation_expedition AS date_confirmation_expedition_23, t0.date_premiere_confirmation_expedition AS date_premiere_confirmation_expedition_24, t0.date_force_expedie AS date_force_expedie_25, t0.date_force_annule AS date_force_annule_26, t0.delai_livraison AS delai_livraison_27, t0.date_relance AS date_relance_28, t0.date_approximative_reception AS date_approximative_reception_29, t0.date_expedition AS date_expedition_30, t0.date_bon AS date_bon_31, t0.date_annulation AS date_annulation_32, t0.date AS date_33, t0.dateMaj AS dateMaj_34, t0.dateSuppression AS dateSuppression_35, t0.numero_reference AS numero_reference_36, t0.numero_suivi AS numero_suivi_37, t0.reference AS reference_38, t0.reference_prestashop AS reference_prestashop_39, t0.origine_saisie AS origine_saisie_40, t0.origine AS origine_41, t0.id_import AS id_import_42, t0.valide_manuellement AS valide_manuellement_43, t0.perdu AS perdu_44, t0.total_tva AS total_tva_45, t0.frais_port_supplementaire AS frais_port_supplementaire_46, t0.taux_tva_frais_port AS taux_tva_frais_port_47, t0.total_frais_port AS total_frais_port_48, t0.total_frais_port_ttc AS total_frais_port_ttc_49, t0.total_tva_frais_port AS total_tva_frais_port_50, t0.total_poids AS total_poids_51, t0.total_ttc AS total_ttc_52, t0.total AS total_53, t0.total_ht_avec_frais_port AS total_ht_avec_frais_port_54, t0.ville_livraison_txt AS ville_livraison_txt_55, t0.pays_livraison_txt AS pays_livraison_txt_56, t0.code_postal_livraison_txt AS code_postal_livraison_txt_57, t0.libelle_livraison AS libelle_livraison_58, t0.numero_livraison AS numero_livraison_59, t0.rue_livraison AS rue_livraison_60, t0.complement_livraison AS complement_livraison_61, t0.complement_livraison_2 AS complement_livraison_2_62, t0.pays_facturation_txt AS pays_facturation_txt_63, t0.ville_facturation_txt AS ville_facturation_txt_64, t0.code_postal_facturation_txt AS code_postal_facturation_txt_65, t0.libelle_facturation AS libelle_facturation_66, t0.numero_facturation AS numero_facturation_67, t0.rue_facturation AS rue_facturation_68, t0.complement_facturation AS complement_facturation_69, t0.complement_facturation_2 AS complement_facturation_2_70, t0.reference_client AS reference_client_71, t0.commentaire AS commentaire_72, t0.travaux AS travaux_73, t0.commentaire_annulation AS commentaire_annulation_74, t0.temps_passe AS temps_passe_75, t0.temps_facture AS temps_facture_76, t0.a_facturer AS a_facturer_77, t0.deja_facture AS deja_facture_78, t0.multi_bl AS multi_bl_79, t0.attente_facturation AS attente_facturation_80, t0.date_validation_bat AS date_validation_bat_81, t0.statut_bat AS statut_bat_82, t0.date_transfert_compta AS date_transfert_compta_83, t0.numero_lettrage AS numero_lettrage_84, t0.lettrage AS lettrage_85, t0.solde AS solde_86, t0.statut_a_modifier AS statut_a_modifier_87, t0.prenom AS prenom_88, t0.nom AS nom_89, t0.prenom_facturation AS prenom_facturation_90, t0.nom_facturation AS nom_facturation_91, t0.civilite AS civilite_92, t0.date_reception_fournisseur AS date_reception_fournisseur_93, t0.date_livraison_souhaitee AS date_livraison_souhaitee_94, t0.date_livraison_theorique AS date_livraison_theorique_95, t0.date_expedition_theorique AS date_expedition_theorique_96, t0.telephone AS telephone_97, t0.telephone2 AS telephone2_98, t0.email AS email_99, t0.telephone_facturation AS telephone_facturation_100, t0.telephone_facturation2 AS telephone_facturation2_101, t0.adresse_validee_manuellement AS adresse_validee_manuellement_102, t0.date_export_bext AS date_export_bext_103, t0.date_max_expedition_min AS date_max_expedition_min_104, t0.date_max_expedition_max AS date_max_expedition_max_105, t0.maj AS maj_106, t0.archive AS archive_107, t0.code_iso_facturation AS code_iso_facturation_108, t0.state_or_province_facturation AS state_or_province_facturation_109, t0.code_iso_livraison AS code_iso_livraison_110, t0.state_or_province_livraison AS state_or_province_livraison_111, t0.date_mail_facture AS date_mail_facture_112, t0.date_calcul_marge AS date_calcul_marge_113, t0.point_retrait AS point_retrait_114, t0.delivery_mode AS delivery_mode_115, t0.total_ttc_devise AS total_ttc_devise_116, t0.taux_change AS taux_change_117, t0.sended_to_oqton AS sended_to_oqton_118, t0.payplug_id AS payplug_id_119, t0.telephone_livraison AS telephone_livraison_120, t0.email_livraison AS email_livraison_121, t0.payplug_montant AS payplug_montant_122, t0.statut_attente AS statut_attente_123, t0.niveau_un_id AS niveau_un_id_124, t0.projet_id AS projet_id_125, t0.taxe_id AS taxe_id_126, t0.taxe_frais_port_id AS taxe_frais_port_id_127, t0.compte_market_place_id AS compte_market_place_id_128, t0.rapport_bext_id AS rapport_bext_id_129, t0.statut_commande_market_place_id AS statut_commande_market_place_id_130, t0.vehicules_client_id AS vehicules_client_id_131, t0.devis_id AS devis_id_132, t0.facture_id AS facture_id_133, t0.bl_id AS bl_id_134, t0.bp_id AS bp_id_135, t0.commande_id AS commande_id_136, t0.contact_livraison_id AS contact_livraison_id_137, t0.contact_facturation_id AS contact_facturation_id_138, t0.contact_acheteur_id AS contact_acheteur_id_139, t0.client_id AS client_id_140, t0.raison_anomalie_id AS raison_anomalie_id_141, t0.transporteur_id AS transporteur_id_142, t0.statut_paiement_id AS statut_paiement_id_143, t0.statut_commande_id AS statut_commande_id_144, t0.etat_commande_id AS etat_commande_id_145, t0.utilisateur_id AS utilisateur_id_146, t0.createur_id AS createur_id_147, t0.utilisateur_valide_manuellement_id AS utilisateur_valide_manuellement_id_148, t0.mecanicien_id AS mecanicien_id_149, t0.secteur_geographique_id AS secteur_geographique_id_150, t0.commercial_id AS commercial_id_151, t0.assistante_commercial_id AS assistante_commercial_id_152, t0.adresse_livraison_id AS adresse_livraison_id_153, t0.pays_livraison_id AS pays_livraison_id_154, t0.ville_livraison_id AS ville_livraison_id_155, t0.code_postal_livraison_id AS code_postal_livraison_id_156, t0.adresse_facturation_id AS adresse_facturation_id_157, t0.pays_facturation_id AS pays_facturation_id_158, t0.ville_facturation_id AS ville_facturation_id_159, t0.code_postal_facturation_id AS code_postal_facturation_id_160, t0.modereglement_id AS modereglement_id_161, t0.mode_reglement_market_place_id AS mode_reglement_market_place_id_162, t0.delai_paiement_id AS delai_paiement_id_163, t0.lcr_id AS lcr_id_164, t0.mode_expedition_id AS mode_expedition_id_165, t0.commande_parent_id AS commande_parent_id_166, t0.devise_id AS devise_id_167, t0.export_compta_id AS export_compta_id_168, t0.rapport_cloture_id AS rapport_cloture_id_169, t0.caisse_id AS caisse_id_170 FROM commerciale__commande t0 WHERE t0.statut_commande_id IS NULL AND t0.utilisateur_id IS NULL AND t0.type_document_commercial_id = 14 AND ((t0.dateSuppression IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.seller_product_id AS seller_product_id_2,
  t0.libelle AS libelle_3,
  t0.libelle_secondaire AS libelle_secondaire_4,
  t0.numero_serie AS numero_serie_5,
  t0.commentaire AS commentaire_6,
  t0.commentaire_prive AS commentaire_prive_7,
  t0.commentaire_suppl AS commentaire_suppl_8,
  t0.date AS date_9,
  t0.date_supression AS date_supression_10,
  t0.date_maj AS date_maj_11,
  t0.date_maj_prix AS date_maj_prix_12,
  t0.date_priorisation AS date_priorisation_13,
  t0.reference AS reference_14,
  t0.reference_client AS reference_client_15,
  t0.reference_fournisseur AS reference_fournisseur_16,
  t0.prix_base AS prix_base_17,
  t0.prix_unitaire_ttc AS prix_unitaire_ttc_18,
  t0.description AS description_19,
  t0.description_courte AS description_courte_20,
  t0.largeur AS largeur_21,
  t0.profondeur AS profondeur_22,
  t0.hauteur AS hauteur_23,
  t0.poids AS poids_24,
  t0.a_consigner AS a_consigner_25,
  t0.forcer AS forcer_26,
  t0.bloquer AS bloquer_27,
  t0.consigne AS consigne_28,
  t0.tva_achat AS tva_achat_29,
  t0.tva_vente AS tva_vente_30,
  t0.quantite AS quantite_31,
  t0.coefficient_conditionnement AS coefficient_conditionnement_32,
  t0.quantite_dispo AS quantite_dispo_33,
  t0.quantite_deja_preparee_simplifie AS quantite_deja_preparee_simplifie_34,
  t0.quantite_deja_preparee AS quantite_deja_preparee_35,
  t0.maj_quantite_deja_preparee AS maj_quantite_deja_preparee_36,
  t0.ral_client AS ral_client_37,
  t0.ral AS ral_38,
  t0.rar AS rar_39,
  t0.quantite_reprise AS quantite_reprise_40,
  t0.remise AS remise_41,
  t0.remise_supplementaire AS remise_supplementaire_42,
  t0.position AS position_43,
  t0.total_ht AS total_ht_44,
  t0.total_with_tax AS total_with_tax_45,
  t0.tva AS tva_46,
  t0.pump AS pump_47,
  t0.cump AS cump_48,
  t0.etiquettes AS etiquettes_49,
  t0.generer_fabriquer AS generer_fabriquer_50,
  t0.maj_condition_achat AS maj_condition_achat_51,
  t0.checked AS checked_52,
  t0.frais_annexes AS frais_annexes_53,
  t0.frais_port AS frais_port_54,
  t0.reste_a_reprendre AS reste_a_reprendre_55,
  t0.date_livraison_theorique AS date_livraison_theorique_56,
  t0.date_expedition_theorique AS date_expedition_theorique_57,
  t0.ecocontribution AS ecocontribution_58,
  t0.id_import AS id_import_59,
  t0.commision_montant AS commision_montant_60,
  t0.commision_taux_tva AS commision_taux_tva_61,
  t0.commision_tva AS commision_tva_62,
  t0.remboursement_montant AS remboursement_montant_63,
  t0.remboursement_commision_montant_ht AS remboursement_commision_montant_ht_64,
  t0.remboursement_commision_tva AS remboursement_commision_tva_65,
  t0.date_approximative_reception AS date_approximative_reception_66,
  t0.prix_achat_unitaire_avec_frais AS prix_achat_unitaire_avec_frais_67,
  t0.ajouter_frais_prix_achat AS ajouter_frais_prix_achat_68,
  t0.total_ttc_devise AS total_ttc_devise_69,
  t0.taux_change AS taux_change_70,
  t0.fabrication_etiquette AS fabrication_etiquette_71,
  t0.prix_avec_remise AS prix_avec_remise_72,
  t0.article_id AS article_id_73,
  t0.transporteur_id AS transporteur_id_74,
  t0.article_composant_id AS article_composant_id_75,
  t0.article_associe_id AS article_associe_id_76,
  t0.remise_initial_id AS remise_initial_id_77,
  t0.commande_id AS commande_id_78,
  t0.litige_id AS litige_id_79,
  t0.commande_fournisseur_id AS commande_fournisseur_id_80,
  t0.fabrication_id AS fabrication_id_81,
  t0.fabrication_multiple_id AS fabrication_multiple_id_82,
  t0.taxe_id AS taxe_id_83,
  t0.devis_id AS devis_id_84,
  t0.article_commande_parent_id AS article_commande_parent_id_85,
  t0.article_commande_id AS article_commande_id_86,
  t0.condition_achat_id AS condition_achat_id_87,
  t0.article_commande_repris_id AS article_commande_repris_id_88,
  t0.article_commande_associe_id AS article_commande_associe_id_89,
  t0.article_market_place_id AS article_market_place_id_90,
  t0.fichier_id AS fichier_id_91
FROM
  commerciale__article_commande t0
WHERE
  t0.commande_id = ?
ORDER BY
  t0.position ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.seller_product_id AS seller_product_id_2, t0.libelle AS libelle_3, t0.libelle_secondaire AS libelle_secondaire_4, t0.numero_serie AS numero_serie_5, t0.commentaire AS commentaire_6, t0.commentaire_prive AS commentaire_prive_7, t0.commentaire_suppl AS commentaire_suppl_8, t0.date AS date_9, t0.date_supression AS date_supression_10, t0.date_maj AS date_maj_11, t0.date_maj_prix AS date_maj_prix_12, t0.date_priorisation AS date_priorisation_13, t0.reference AS reference_14, t0.reference_client AS reference_client_15, t0.reference_fournisseur AS reference_fournisseur_16, t0.prix_base AS prix_base_17, t0.prix_unitaire_ttc AS prix_unitaire_ttc_18, t0.description AS description_19, t0.description_courte AS description_courte_20, t0.largeur AS largeur_21, t0.profondeur AS profondeur_22, t0.hauteur AS hauteur_23, t0.poids AS poids_24, t0.a_consigner AS a_consigner_25, t0.forcer AS forcer_26, t0.bloquer AS bloquer_27, t0.consigne AS consigne_28, t0.tva_achat AS tva_achat_29, t0.tva_vente AS tva_vente_30, t0.quantite AS quantite_31, t0.coefficient_conditionnement AS coefficient_conditionnement_32, t0.quantite_dispo AS quantite_dispo_33, t0.quantite_deja_preparee_simplifie AS quantite_deja_preparee_simplifie_34, t0.quantite_deja_preparee AS quantite_deja_preparee_35, t0.maj_quantite_deja_preparee AS maj_quantite_deja_preparee_36, t0.ral_client AS ral_client_37, t0.ral AS ral_38, t0.rar AS rar_39, t0.quantite_reprise AS quantite_reprise_40, t0.remise AS remise_41, t0.remise_supplementaire AS remise_supplementaire_42, t0.position AS position_43, t0.total_ht AS total_ht_44, t0.total_with_tax AS total_with_tax_45, t0.tva AS tva_46, t0.pump AS pump_47, t0.cump AS cump_48, t0.etiquettes AS etiquettes_49, t0.generer_fabriquer AS generer_fabriquer_50, t0.maj_condition_achat AS maj_condition_achat_51, t0.checked AS checked_52, t0.frais_annexes AS frais_annexes_53, t0.frais_port AS frais_port_54, t0.reste_a_reprendre AS reste_a_reprendre_55, t0.date_livraison_theorique AS date_livraison_theorique_56, t0.date_expedition_theorique AS date_expedition_theorique_57, t0.ecocontribution AS ecocontribution_58, t0.id_import AS id_import_59, t0.commision_montant AS commision_montant_60, t0.commision_taux_tva AS commision_taux_tva_61, t0.commision_tva AS commision_tva_62, t0.remboursement_montant AS remboursement_montant_63, t0.remboursement_commision_montant_ht AS remboursement_commision_montant_ht_64, t0.remboursement_commision_tva AS remboursement_commision_tva_65, t0.date_approximative_reception AS date_approximative_reception_66, t0.prix_achat_unitaire_avec_frais AS prix_achat_unitaire_avec_frais_67, t0.ajouter_frais_prix_achat AS ajouter_frais_prix_achat_68, t0.total_ttc_devise AS total_ttc_devise_69, t0.taux_change AS taux_change_70, t0.fabrication_etiquette AS fabrication_etiquette_71, t0.prix_avec_remise AS prix_avec_remise_72, t0.article_id AS article_id_73, t0.transporteur_id AS transporteur_id_74, t0.article_composant_id AS article_composant_id_75, t0.article_associe_id AS article_associe_id_76, t0.remise_initial_id AS remise_initial_id_77, t0.commande_id AS commande_id_78, t0.litige_id AS litige_id_79, t0.commande_fournisseur_id AS commande_fournisseur_id_80, t0.fabrication_id AS fabrication_id_81, t0.fabrication_multiple_id AS fabrication_multiple_id_82, t0.taxe_id AS taxe_id_83, t0.devis_id AS devis_id_84, t0.article_commande_parent_id AS article_commande_parent_id_85, t0.article_commande_id AS article_commande_id_86, t0.condition_achat_id AS condition_achat_id_87, t0.article_commande_repris_id AS article_commande_repris_id_88, t0.article_commande_associe_id AS article_commande_associe_id_89, t0.article_market_place_id AS article_market_place_id_90, t0.fichier_id AS fichier_id_91 FROM commerciale__article_commande t0 WHERE t0.commande_id = 159 ORDER BY t0.position ASC, t0.id ASC;