0.58 ms
(38.08%)
|
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 = ?
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;
|
0.44 ms
(28.89%)
|
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 = ?
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;
|
0.29 ms
(18.78%)
|
1 |
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 = ?
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;
|