1
0.30 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . prenom AS prenom_5 , t0 . nom AS nom_6 , t0 . session_id AS session_id_7 , t0 . last_login AS last_login_8 , t0 . visible AS visible_9 , t0 . visible_agenda AS visible_agenda_10 , t0 . archive AS archive_11 , t0 . couleurAgenda AS couleurAgenda_12 , t0 . reference AS reference_13 , t0 . google_agenda AS google_agenda_14 , t0 . badge AS badge_15 , t0 . receptionner AS receptionner_16 , t0 . fabriquer AS fabriquer_17 , t0 . preparer AS preparer_18 , t0 . emballer AS emballer_19 , t0 . signature_mail AS signature_mail_20 , t0 . date AS date_21 , t0 . date_maj AS date_maj_22 , t0 . date_supression AS date_supression_23 , t0 . telephone AS telephone_24 , t0 . skype AS skype_25 , t0 . type_menu AS type_menu_26 , t0 . toolbar_closed AS toolbar_closed_27 , t0 . mouvemente_recherche_article AS mouvemente_recherche_article_28 , t0 . tri_recherche_article AS tri_recherche_article_29 , t0 . ordre_tri_recherche_article AS ordre_tri_recherche_article_30 , t0 . id_import AS id_import_31 , t0 . equipe AS equipe_32 , t0 . fonction AS fonction_33 , t0 . position AS position_34 , t0 . client_id AS client_id_35 , t0 . type_id AS type_id_36 , t37 . id AS id_38 , t37 . colonne_1 AS colonne_1_39 , t37 . colonne_2 AS colonne_2_40 , t37 . colonne_3 AS colonne_3_41 , t37 . date AS date_42 , t37 . dateMaj AS dateMaj_43 , t37 . dateSuppression AS dateSuppression_44 , t37 . utilisateur_id AS utilisateur_id_45 FROM utilisateur__utilisateurs t0 LEFT JOIN widget__colonne_utilisateur t37 ON t37 . utilisateur_id = t0 . id WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . email AS email_2 ,
t0 . roles AS roles_3 ,
t0 . password AS password_4 ,
t0 . prenom AS prenom_5 ,
t0 . nom AS nom_6 ,
t0 . session_id AS session_id_7 ,
t0 . last_login AS last_login_8 ,
t0 . visible AS visible_9 ,
t0 . visible_agenda AS visible_agenda_10 ,
t0 . archive AS archive_11 ,
t0 . couleurAgenda AS couleurAgenda_12 ,
t0 . reference AS reference_13 ,
t0 . google_agenda AS google_agenda_14 ,
t0 . badge AS badge_15 ,
t0 . receptionner AS receptionner_16 ,
t0 . fabriquer AS fabriquer_17 ,
t0 . preparer AS preparer_18 ,
t0 . emballer AS emballer_19 ,
t0 . signature_mail AS signature_mail_20 ,
t0 . date AS date_21 ,
t0 . date_maj AS date_maj_22 ,
t0 . date_supression AS date_supression_23 ,
t0 . telephone AS telephone_24 ,
t0 . skype AS skype_25 ,
t0 . type_menu AS type_menu_26 ,
t0 . toolbar_closed AS toolbar_closed_27 ,
t0 . mouvemente_recherche_article AS mouvemente_recherche_article_28 ,
t0 . tri_recherche_article AS tri_recherche_article_29 ,
t0 . ordre_tri_recherche_article AS ordre_tri_recherche_article_30 ,
t0 . id_import AS id_import_31 ,
t0 . equipe AS equipe_32 ,
t0 . fonction AS fonction_33 ,
t0 . position AS position_34 ,
t0 . client_id AS client_id_35 ,
t0 . type_id AS type_id_36 ,
t37 . id AS id_38 ,
t37 . colonne_1 AS colonne_1_39 ,
t37 . colonne_2 AS colonne_2_40 ,
t37 . colonne_3 AS colonne_3_41 ,
t37 . date AS date_42 ,
t37 . dateMaj AS dateMaj_43 ,
t37 . dateSuppression AS dateSuppression_44 ,
t37 . utilisateur_id AS utilisateur_id_45
FROM
utilisateur__utilisateurs t0
LEFT JOIN widget__colonne_utilisateur t37 ON t37 . utilisateur_id = t0 . id
WHERE
t0 . id = ? Copy
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . prenom AS prenom_5 , t0 . nom AS nom_6 , t0 . session_id AS session_id_7 , t0 . last_login AS last_login_8 , t0 . visible AS visible_9 , t0 . visible_agenda AS visible_agenda_10 , t0 . archive AS archive_11 , t0 . couleurAgenda AS couleurAgenda_12 , t0 . reference AS reference_13 , t0 . google_agenda AS google_agenda_14 , t0 . badge AS badge_15 , t0 . receptionner AS receptionner_16 , t0 . fabriquer AS fabriquer_17 , t0 . preparer AS preparer_18 , t0 . emballer AS emballer_19 , t0 . signature_mail AS signature_mail_20 , t0 . date AS date_21 , t0 . date_maj AS date_maj_22 , t0 . date_supression AS date_supression_23 , t0 . telephone AS telephone_24 , t0 . skype AS skype_25 , t0 . type_menu AS type_menu_26 , t0 . toolbar_closed AS toolbar_closed_27 , t0 . mouvemente_recherche_article AS mouvemente_recherche_article_28 , t0 . tri_recherche_article AS tri_recherche_article_29 , t0 . ordre_tri_recherche_article AS ordre_tri_recherche_article_30 , t0 . id_import AS id_import_31 , t0 . equipe AS equipe_32 , t0 . fonction AS fonction_33 , t0 . position AS position_34 , t0 . client_id AS client_id_35 , t0 . type_id AS type_id_36 , t37 . id AS id_38 , t37 . colonne_1 AS colonne_1_39 , t37 . colonne_2 AS colonne_2_40 , t37 . colonne_3 AS colonne_3_41 , t37 . date AS date_42 , t37 . dateMaj AS dateMaj_43 , t37 . dateSuppression AS dateSuppression_44 , t37 . utilisateur_id AS utilisateur_id_45 FROM utilisateur__utilisateurs t0 LEFT JOIN widget__colonne_utilisateur t37 ON t37 . utilisateur_id = t0 . id WHERE t0 . id = 3 ; Copy
2
0.32 ms
"START TRANSACTION"
"START TRANSACTION" ; Copy
3
1.31 ms
INSERT INTO client__historique_client (date , dateSuppression , message , titre , TYPE , utilisateur_id , client_id ) VALUES (? , ? , ? , ? , ? , ? , ? )
Parameters :
[
"2026-08-04 16:00:29 "
null
"https://epobi-mw.devweb.pro/vente/commande/ajax/detail/171?mode= "
null
"tracking "
3
1
]
INSERT INTO client__historique_client (date , dateSuppression , message , titre , TYPE , utilisateur_id , client_id ) VALUES ('2026-08-04 16:00:29' , NULL , 'https://epobi-mw.devweb.pro/vente/commande/ajax/detail/171?mode=' , NULL , 'tracking' , 3 , 1 ); Copy
4
0.36 ms
"COMMIT"
5
0.66 ms
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 . id = ? AND ((t0 . dateSuppression IS NULL ))
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 . id = ?
AND (
(t0 . dateSuppression IS NULL )
)Copy
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 . id = '171' AND ((t0 . dateSuppression IS NULL )); Copy
6
0.57 ms
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 . reservations AS reservations_73 , t0 . article_id AS article_id_74 , t0 . transporteur_id AS transporteur_id_75 , t0 . article_composant_id AS article_composant_id_76 , t0 . article_associe_id AS article_associe_id_77 , t0 . remise_initial_id AS remise_initial_id_78 , t0 . commande_id AS commande_id_79 , t0 . litige_id AS litige_id_80 , t0 . commande_fournisseur_id AS commande_fournisseur_id_81 , t0 . fabrication_id AS fabrication_id_82 , t0 . fabrication_multiple_id AS fabrication_multiple_id_83 , t0 . taxe_id AS taxe_id_84 , t0 . devis_id AS devis_id_85 , t0 . article_commande_parent_id AS article_commande_parent_id_86 , t0 . article_commande_id AS article_commande_id_87 , t0 . condition_achat_id AS condition_achat_id_88 , t0 . article_commande_repris_id AS article_commande_repris_id_89 , t0 . article_commande_associe_id AS article_commande_associe_id_90 , t0 . article_market_place_id AS article_market_place_id_91 , t0 . fichier_id AS fichier_id_92 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 . reservations AS reservations_73 ,
t0 . article_id AS article_id_74 ,
t0 . transporteur_id AS transporteur_id_75 ,
t0 . article_composant_id AS article_composant_id_76 ,
t0 . article_associe_id AS article_associe_id_77 ,
t0 . remise_initial_id AS remise_initial_id_78 ,
t0 . commande_id AS commande_id_79 ,
t0 . litige_id AS litige_id_80 ,
t0 . commande_fournisseur_id AS commande_fournisseur_id_81 ,
t0 . fabrication_id AS fabrication_id_82 ,
t0 . fabrication_multiple_id AS fabrication_multiple_id_83 ,
t0 . taxe_id AS taxe_id_84 ,
t0 . devis_id AS devis_id_85 ,
t0 . article_commande_parent_id AS article_commande_parent_id_86 ,
t0 . article_commande_id AS article_commande_id_87 ,
t0 . condition_achat_id AS condition_achat_id_88 ,
t0 . article_commande_repris_id AS article_commande_repris_id_89 ,
t0 . article_commande_associe_id AS article_commande_associe_id_90 ,
t0 . article_market_place_id AS article_market_place_id_91 ,
t0 . fichier_id AS fichier_id_92
FROM
commerciale__article_commande t0
WHERE
t0 . commande_id = ?
ORDER BY
t0 . position ASC ,
t0 . id ASC Copy
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 . reservations AS reservations_73 , t0 . article_id AS article_id_74 , t0 . transporteur_id AS transporteur_id_75 , t0 . article_composant_id AS article_composant_id_76 , t0 . article_associe_id AS article_associe_id_77 , t0 . remise_initial_id AS remise_initial_id_78 , t0 . commande_id AS commande_id_79 , t0 . litige_id AS litige_id_80 , t0 . commande_fournisseur_id AS commande_fournisseur_id_81 , t0 . fabrication_id AS fabrication_id_82 , t0 . fabrication_multiple_id AS fabrication_multiple_id_83 , t0 . taxe_id AS taxe_id_84 , t0 . devis_id AS devis_id_85 , t0 . article_commande_parent_id AS article_commande_parent_id_86 , t0 . article_commande_id AS article_commande_id_87 , t0 . condition_achat_id AS condition_achat_id_88 , t0 . article_commande_repris_id AS article_commande_repris_id_89 , t0 . article_commande_associe_id AS article_commande_associe_id_90 , t0 . article_market_place_id AS article_market_place_id_91 , t0 . fichier_id AS fichier_id_92 FROM commerciale__article_commande t0 WHERE t0 . commande_id = 171 ORDER BY t0 . position ASC , t0 . id ASC ; Copy
7
0.62 ms
SELECT t0 . id AS id_1 , t0 . origine AS origine_2 , t0 . provenance AS provenance_3 , t0 . code_produit AS code_produit_4 , t0 . id_import AS id_import_5 , t0 . id_import_2 AS id_import_2_6 , t0 . donnees_import AS donnees_import_7 , t0 . libelle AS libelle_8 , t0 . nomenclature_douaniere AS nomenclature_douaniere_9 , t0 . unspsc AS unspsc_10 , t0 . ugs AS ugs_11 , t0 . ean AS ean_12 , t0 . libelle_secondaire AS libelle_secondaire_13 , t0 . date AS date_14 , t0 . dateCalculCump AS dateCalculCump_15 , t0 . dateProchaineDispo AS dateProchaineDispo_16 , t0 . date_supression AS date_supression_17 , t0 . date_maj AS date_maj_18 , t0 . date_maj_prix AS date_maj_prix_19 , t0 . reference AS reference_20 , t0 . reference_interne AS reference_interne_21 , t0 . reference_appel_1 AS reference_appel_1_22 , t0 . reference_appel_2 AS reference_appel_2_23 , t0 . reference_appel_3 AS reference_appel_3_24 , t0 . reference_appel_4 AS reference_appel_4_25 , t0 . reference_appel_5 AS reference_appel_5_26 , t0 . reference_appel_6 AS reference_appel_6_27 , t0 . reference_appel_7 AS reference_appel_7_28 , t0 . reference_appel_8 AS reference_appel_8_29 , t0 . reference_appel_9 AS reference_appel_9_30 , t0 . reference_appel_10 AS reference_appel_10_31 , t0 . reference_appel_11 AS reference_appel_11_32 , t0 . reference_client AS reference_client_33 , t0 . reference_fournisseur AS reference_fournisseur_34 , t0 . prix_base AS prix_base_35 , t0 . prix_revient AS prix_revient_36 , t0 . frais_fonctionnement AS frais_fonctionnement_37 , t0 . prix_vente AS prix_vente_38 , t0 . taux_marge AS taux_marge_39 , t0 . marge AS marge_40 , t0 . marge_reelle AS marge_reelle_41 , t0 . ecotaxe AS ecotaxe_42 , t0 . ecocontribution AS ecocontribution_43 , t0 . pump AS pump_44 , t0 . cpump AS cpump_45 , t0 . remise_max AS remise_max_46 , t0 . type_remise_max AS type_remise_max_47 , t0 . description AS description_48 , t0 . description_courte AS description_courte_49 , t0 . commentaire AS commentaire_50 , t0 . commentaire_achat AS commentaire_achat_51 , t0 . stock AS stock_52 , t0 . stock_reserve AS stock_reserve_53 , t0 . stock_reserve_fabrication AS stock_reserve_fabrication_54 , t0 . conditionnement AS conditionnement_55 , t0 . largeur AS largeur_56 , t0 . longueur AS longueur_57 , t0 . profondeur AS profondeur_58 , t0 . hauteur AS hauteur_59 , t0 . poids AS poids_60 , t0 . colis AS colis_61 , t0 . nomenclature_validee AS nomenclature_validee_62 , t0 . non_preparable AS non_preparable_63 , t0 . statut AS statut_64 , t0 . universel AS universel_65 , t0 . sur_prestashop AS sur_prestashop_66 , t0 . est_commentaire AS est_commentaire_67 , t0 . num_serie_obligatoire AS num_serie_obligatoire_68 , t0 . archive AS archive_69 , t0 . non_stocke AS non_stocke_70 , t0 . non_commandable AS non_commandable_71 , t0 . a_commander AS a_commander_72 , t0 . a_suggerer AS a_suggerer_73 , t0 . a_fabriquer AS a_fabriquer_74 , t0 . afficher_composant_pdf_interne AS afficher_composant_pdf_interne_75 , t0 . afficher_composant_pdf_externe AS afficher_composant_pdf_externe_76 , t0 . virtuel AS virtuel_77 , t0 . maj_prix AS maj_prix_78 , t0 . a_consigner AS a_consigner_79 , t0 . consigne AS consigne_80 , t0 . stock_auto AS stock_auto_81 , t0 . arret_gamme AS arret_gamme_82 , t0 . seuil_critique AS seuil_critique_83 , t0 . seuil_commande_f_mini AS seuil_commande_f_mini_84 , t0 . seuil_commande_f_maxi AS seuil_commande_f_maxi_85 , t0 . ral_fournisseur AS ral_fournisseur_86 , t0 . produit_interne AS produit_interne_87 , t0 . temporaire AS temporaire_88 , t0 . quantite_conseillee_mini AS quantite_conseillee_mini_89 , t0 . quantite_conseillee AS quantite_conseillee_90 , t0 . quantite_conseillee_maxi AS quantite_conseillee_maxi_91 , t0 . coefficient_px_base_px_vente AS coefficient_px_base_px_vente_92 , t0 . nom_web AS nom_web_93 , t0 . delai_reappro AS delai_reappro_94 , t0 . reference_web AS reference_web_95 , t0 . reference_fournisseur_web AS reference_fournisseur_web_96 , t0 . description_web AS description_web_97 , t0 . resume_web AS resume_web_98 , t0 . frais_ports_texte_web AS frais_ports_texte_web_99 , t0 . title_seo_web AS title_seo_web_100 , t0 . url_web AS url_web_101 , t0 . message_qd_en_stock AS message_qd_en_stock_102 , t0 . main_oeuvre AS main_oeuvre_103 , t0 . prestation AS prestation_104 , t0 . divers AS divers_105 , t0 . divers_composes AS divers_composes_106 , t0 . declinaison AS declinaison_107 , t0 . mouvemente AS mouvemente_108 , t0 . maj_poids AS maj_poids_109 , t0 . maj_prix_base AS maj_prix_base_110 , t0 . cond_achat AS cond_achat_111 , t0 . commentaire_dimensions AS commentaire_dimensions_112 , t0 . maj_composes AS maj_composes_113 , t0 . dispo AS dispo_114 , t0 . maj_dispo AS maj_dispo_115 , t0 . numero_reference AS numero_reference_116 , t0 . estParent AS estParent_117 , t0 . capacite_production AS capacite_production_118 , t0 . maj_capacite_prod AS maj_capacite_prod_119 , t0 . pump_hors_frais AS pump_hors_frais_120 , t0 . maj_pump AS maj_pump_121 , t0 . id_prestahop AS id_prestahop_122 , t0 . id_combination_prestahop AS id_combination_prestahop_123 , t0 . oqton_urn AS oqton_urn_124 , t0 . oqton_material_urn AS oqton_material_urn_125 , t0 . a_publier AS a_publier_126 , t0 . date_a_publier AS date_a_publier_127 , t0 . position AS position_128 , t0 . forme_hors_standard AS forme_hors_standard_129 , t0 . article_remplacement_id AS article_remplacement_id_130 , t0 . niveau_un_id AS niveau_un_id_131 , t0 . niveau_deux_id AS niveau_deux_id_132 , t0 . niveau_trois_id AS niveau_trois_id_133 , t0 . niveau_quatre_id AS niveau_quatre_id_134 , t0 . regle_taxe_id AS regle_taxe_id_135 , t0 . regle_taxe_achat_id AS regle_taxe_achat_id_136 , t0 . utilisateur_id AS utilisateur_id_137 , t0 . categorie_remise_article_id AS categorie_remise_article_id_138 , t0 . marque_id AS marque_id_139 , t0 . finition_id AS finition_id_140 , t0 . caisse_id AS caisse_id_141 , t0 . atelier_id AS atelier_id_142 , t0 . famille_compta_id AS famille_compta_id_143 , t0 . type_id AS type_id_144 , t0 . unite_mesure_id AS unite_mesure_id_145 , t0 . fournisseur_defaut_id AS fournisseur_defaut_id_146 , t0 . condition_achat_defaut_id AS condition_achat_defaut_id_147 , t0 . article_enconsigne_id AS article_enconsigne_id_148 , t0 . parent_id AS parent_id_149 , t0 . article_declinaison_parent_id AS article_declinaison_parent_id_150 , t0 . transporteur_id AS transporteur_id_151 , t0 . transporteur2_id AS transporteur2_id_152 FROM article__article t0 WHERE t0 . id = ? AND ((t0 . date_supression IS NULL ))
SELECT
t0 . id AS id_1 ,
t0 . origine AS origine_2 ,
t0 . provenance AS provenance_3 ,
t0 . code_produit AS code_produit_4 ,
t0 . id_import AS id_import_5 ,
t0 . id_import_2 AS id_import_2_6 ,
t0 . donnees_import AS donnees_import_7 ,
t0 . libelle AS libelle_8 ,
t0 . nomenclature_douaniere AS nomenclature_douaniere_9 ,
t0 . unspsc AS unspsc_10 ,
t0 . ugs AS ugs_11 ,
t0 . ean AS ean_12 ,
t0 . libelle_secondaire AS libelle_secondaire_13 ,
t0 . date AS date_14 ,
t0 . dateCalculCump AS dateCalculCump_15 ,
t0 . dateProchaineDispo AS dateProchaineDispo_16 ,
t0 . date_supression AS date_supression_17 ,
t0 . date_maj AS date_maj_18 ,
t0 . date_maj_prix AS date_maj_prix_19 ,
t0 . reference AS reference_20 ,
t0 . reference_interne AS reference_interne_21 ,
t0 . reference_appel_1 AS reference_appel_1_22 ,
t0 . reference_appel_2 AS reference_appel_2_23 ,
t0 . reference_appel_3 AS reference_appel_3_24 ,
t0 . reference_appel_4 AS reference_appel_4_25 ,
t0 . reference_appel_5 AS reference_appel_5_26 ,
t0 . reference_appel_6 AS reference_appel_6_27 ,
t0 . reference_appel_7 AS reference_appel_7_28 ,
t0 . reference_appel_8 AS reference_appel_8_29 ,
t0 . reference_appel_9 AS reference_appel_9_30 ,
t0 . reference_appel_10 AS reference_appel_10_31 ,
t0 . reference_appel_11 AS reference_appel_11_32 ,
t0 . reference_client AS reference_client_33 ,
t0 . reference_fournisseur AS reference_fournisseur_34 ,
t0 . prix_base AS prix_base_35 ,
t0 . prix_revient AS prix_revient_36 ,
t0 . frais_fonctionnement AS frais_fonctionnement_37 ,
t0 . prix_vente AS prix_vente_38 ,
t0 . taux_marge AS taux_marge_39 ,
t0 . marge AS marge_40 ,
t0 . marge_reelle AS marge_reelle_41 ,
t0 . ecotaxe AS ecotaxe_42 ,
t0 . ecocontribution AS ecocontribution_43 ,
t0 . pump AS pump_44 ,
t0 . cpump AS cpump_45 ,
t0 . remise_max AS remise_max_46 ,
t0 . type_remise_max AS type_remise_max_47 ,
t0 . description AS description_48 ,
t0 . description_courte AS description_courte_49 ,
t0 . commentaire AS commentaire_50 ,
t0 . commentaire_achat AS commentaire_achat_51 ,
t0 . stock AS stock_52 ,
t0 . stock_reserve AS stock_reserve_53 ,
t0 . stock_reserve_fabrication AS stock_reserve_fabrication_54 ,
t0 . conditionnement AS conditionnement_55 ,
t0 . largeur AS largeur_56 ,
t0 . longueur AS longueur_57 ,
t0 . profondeur AS profondeur_58 ,
t0 . hauteur AS hauteur_59 ,
t0 . poids AS poids_60 ,
t0 . colis AS colis_61 ,
t0 . nomenclature_validee AS nomenclature_validee_62 ,
t0 . non_preparable AS non_preparable_63 ,
t0 . statut AS statut_64 ,
t0 . universel AS universel_65 ,
t0 . sur_prestashop AS sur_prestashop_66 ,
t0 . est_commentaire AS est_commentaire_67 ,
t0 . num_serie_obligatoire AS num_serie_obligatoire_68 ,
t0 . archive AS archive_69 ,
t0 . non_stocke AS non_stocke_70 ,
t0 . non_commandable AS non_commandable_71 ,
t0 . a_commander AS a_commander_72 ,
t0 . a_suggerer AS a_suggerer_73 ,
t0 . a_fabriquer AS a_fabriquer_74 ,
t0 . afficher_composant_pdf_interne AS afficher_composant_pdf_interne_75 ,
t0 . afficher_composant_pdf_externe AS afficher_composant_pdf_externe_76 ,
t0 . virtuel AS virtuel_77 ,
t0 . maj_prix AS maj_prix_78 ,
t0 . a_consigner AS a_consigner_79 ,
t0 . consigne AS consigne_80 ,
t0 . stock_auto AS stock_auto_81 ,
t0 . arret_gamme AS arret_gamme_82 ,
t0 . seuil_critique AS seuil_critique_83 ,
t0 . seuil_commande_f_mini AS seuil_commande_f_mini_84 ,
t0 . seuil_commande_f_maxi AS seuil_commande_f_maxi_85 ,
t0 . ral_fournisseur AS ral_fournisseur_86 ,
t0 . produit_interne AS produit_interne_87 ,
t0 . temporaire AS temporaire_88 ,
t0 . quantite_conseillee_mini AS quantite_conseillee_mini_89 ,
t0 . quantite_conseillee AS quantite_conseillee_90 ,
t0 . quantite_conseillee_maxi AS quantite_conseillee_maxi_91 ,
t0 . coefficient_px_base_px_vente AS coefficient_px_base_px_vente_92 ,
t0 . nom_web AS nom_web_93 ,
t0 . delai_reappro AS delai_reappro_94 ,
t0 . reference_web AS reference_web_95 ,
t0 . reference_fournisseur_web AS reference_fournisseur_web_96 ,
t0 . description_web AS description_web_97 ,
t0 . resume_web AS resume_web_98 ,
t0 . frais_ports_texte_web AS frais_ports_texte_web_99 ,
t0 . title_seo_web AS title_seo_web_100 ,
t0 . url_web AS url_web_101 ,
t0 . message_qd_en_stock AS message_qd_en_stock_102 ,
t0 . main_oeuvre AS main_oeuvre_103 ,
t0 . prestation AS prestation_104 ,
t0 . divers AS divers_105 ,
t0 . divers_composes AS divers_composes_106 ,
t0 . declinaison AS declinaison_107 ,
t0 . mouvemente AS mouvemente_108 ,
t0 . maj_poids AS maj_poids_109 ,
t0 . maj_prix_base AS maj_prix_base_110 ,
t0 . cond_achat AS cond_achat_111 ,
t0 . commentaire_dimensions AS commentaire_dimensions_112 ,
t0 . maj_composes AS maj_composes_113 ,
t0 . dispo AS dispo_114 ,
t0 . maj_dispo AS maj_dispo_115 ,
t0 . numero_reference AS numero_reference_116 ,
t0 . estParent AS estParent_117 ,
t0 . capacite_production AS capacite_production_118 ,
t0 . maj_capacite_prod AS maj_capacite_prod_119 ,
t0 . pump_hors_frais AS pump_hors_frais_120 ,
t0 . maj_pump AS maj_pump_121 ,
t0 . id_prestahop AS id_prestahop_122 ,
t0 . id_combination_prestahop AS id_combination_prestahop_123 ,
t0 . oqton_urn AS oqton_urn_124 ,
t0 . oqton_material_urn AS oqton_material_urn_125 ,
t0 . a_publier AS a_publier_126 ,
t0 . date_a_publier AS date_a_publier_127 ,
t0 . position AS position_128 ,
t0 . forme_hors_standard AS forme_hors_standard_129 ,
t0 . article_remplacement_id AS article_remplacement_id_130 ,
t0 . niveau_un_id AS niveau_un_id_131 ,
t0 . niveau_deux_id AS niveau_deux_id_132 ,
t0 . niveau_trois_id AS niveau_trois_id_133 ,
t0 . niveau_quatre_id AS niveau_quatre_id_134 ,
t0 . regle_taxe_id AS regle_taxe_id_135 ,
t0 . regle_taxe_achat_id AS regle_taxe_achat_id_136 ,
t0 . utilisateur_id AS utilisateur_id_137 ,
t0 . categorie_remise_article_id AS categorie_remise_article_id_138 ,
t0 . marque_id AS marque_id_139 ,
t0 . finition_id AS finition_id_140 ,
t0 . caisse_id AS caisse_id_141 ,
t0 . atelier_id AS atelier_id_142 ,
t0 . famille_compta_id AS famille_compta_id_143 ,
t0 . type_id AS type_id_144 ,
t0 . unite_mesure_id AS unite_mesure_id_145 ,
t0 . fournisseur_defaut_id AS fournisseur_defaut_id_146 ,
t0 . condition_achat_defaut_id AS condition_achat_defaut_id_147 ,
t0 . article_enconsigne_id AS article_enconsigne_id_148 ,
t0 . parent_id AS parent_id_149 ,
t0 . article_declinaison_parent_id AS article_declinaison_parent_id_150 ,
t0 . transporteur_id AS transporteur_id_151 ,
t0 . transporteur2_id AS transporteur2_id_152
FROM
article__article t0
WHERE
t0 . id = ?
AND (
(t0 . date_supression IS NULL )
)Copy
SELECT t0 . id AS id_1 , t0 . origine AS origine_2 , t0 . provenance AS provenance_3 , t0 . code_produit AS code_produit_4 , t0 . id_import AS id_import_5 , t0 . id_import_2 AS id_import_2_6 , t0 . donnees_import AS donnees_import_7 , t0 . libelle AS libelle_8 , t0 . nomenclature_douaniere AS nomenclature_douaniere_9 , t0 . unspsc AS unspsc_10 , t0 . ugs AS ugs_11 , t0 . ean AS ean_12 , t0 . libelle_secondaire AS libelle_secondaire_13 , t0 . date AS date_14 , t0 . dateCalculCump AS dateCalculCump_15 , t0 . dateProchaineDispo AS dateProchaineDispo_16 , t0 . date_supression AS date_supression_17 , t0 . date_maj AS date_maj_18 , t0 . date_maj_prix AS date_maj_prix_19 , t0 . reference AS reference_20 , t0 . reference_interne AS reference_interne_21 , t0 . reference_appel_1 AS reference_appel_1_22 , t0 . reference_appel_2 AS reference_appel_2_23 , t0 . reference_appel_3 AS reference_appel_3_24 , t0 . reference_appel_4 AS reference_appel_4_25 , t0 . reference_appel_5 AS reference_appel_5_26 , t0 . reference_appel_6 AS reference_appel_6_27 , t0 . reference_appel_7 AS reference_appel_7_28 , t0 . reference_appel_8 AS reference_appel_8_29 , t0 . reference_appel_9 AS reference_appel_9_30 , t0 . reference_appel_10 AS reference_appel_10_31 , t0 . reference_appel_11 AS reference_appel_11_32 , t0 . reference_client AS reference_client_33 , t0 . reference_fournisseur AS reference_fournisseur_34 , t0 . prix_base AS prix_base_35 , t0 . prix_revient AS prix_revient_36 , t0 . frais_fonctionnement AS frais_fonctionnement_37 , t0 . prix_vente AS prix_vente_38 , t0 . taux_marge AS taux_marge_39 , t0 . marge AS marge_40 , t0 . marge_reelle AS marge_reelle_41 , t0 . ecotaxe AS ecotaxe_42 , t0 . ecocontribution AS ecocontribution_43 , t0 . pump AS pump_44 , t0 . cpump AS cpump_45 , t0 . remise_max AS remise_max_46 , t0 . type_remise_max AS type_remise_max_47 , t0 . description AS description_48 , t0 . description_courte AS description_courte_49 , t0 . commentaire AS commentaire_50 , t0 . commentaire_achat AS commentaire_achat_51 , t0 . stock AS stock_52 , t0 . stock_reserve AS stock_reserve_53 , t0 . stock_reserve_fabrication AS stock_reserve_fabrication_54 , t0 . conditionnement AS conditionnement_55 , t0 . largeur AS largeur_56 , t0 . longueur AS longueur_57 , t0 . profondeur AS profondeur_58 , t0 . hauteur AS hauteur_59 , t0 . poids AS poids_60 , t0 . colis AS colis_61 , t0 . nomenclature_validee AS nomenclature_validee_62 , t0 . non_preparable AS non_preparable_63 , t0 . statut AS statut_64 , t0 . universel AS universel_65 , t0 . sur_prestashop AS sur_prestashop_66 , t0 . est_commentaire AS est_commentaire_67 , t0 . num_serie_obligatoire AS num_serie_obligatoire_68 , t0 . archive AS archive_69 , t0 . non_stocke AS non_stocke_70 , t0 . non_commandable AS non_commandable_71 , t0 . a_commander AS a_commander_72 , t0 . a_suggerer AS a_suggerer_73 , t0 . a_fabriquer AS a_fabriquer_74 , t0 . afficher_composant_pdf_interne AS afficher_composant_pdf_interne_75 , t0 . afficher_composant_pdf_externe AS afficher_composant_pdf_externe_76 , t0 . virtuel AS virtuel_77 , t0 . maj_prix AS maj_prix_78 , t0 . a_consigner AS a_consigner_79 , t0 . consigne AS consigne_80 , t0 . stock_auto AS stock_auto_81 , t0 . arret_gamme AS arret_gamme_82 , t0 . seuil_critique AS seuil_critique_83 , t0 . seuil_commande_f_mini AS seuil_commande_f_mini_84 , t0 . seuil_commande_f_maxi AS seuil_commande_f_maxi_85 , t0 . ral_fournisseur AS ral_fournisseur_86 , t0 . produit_interne AS produit_interne_87 , t0 . temporaire AS temporaire_88 , t0 . quantite_conseillee_mini AS quantite_conseillee_mini_89 , t0 . quantite_conseillee AS quantite_conseillee_90 , t0 . quantite_conseillee_maxi AS quantite_conseillee_maxi_91 , t0 . coefficient_px_base_px_vente AS coefficient_px_base_px_vente_92 , t0 . nom_web AS nom_web_93 , t0 . delai_reappro AS delai_reappro_94 , t0 . reference_web AS reference_web_95 , t0 . reference_fournisseur_web AS reference_fournisseur_web_96 , t0 . description_web AS description_web_97 , t0 . resume_web AS resume_web_98 , t0 . frais_ports_texte_web AS frais_ports_texte_web_99 , t0 . title_seo_web AS title_seo_web_100 , t0 . url_web AS url_web_101 , t0 . message_qd_en_stock AS message_qd_en_stock_102 , t0 . main_oeuvre AS main_oeuvre_103 , t0 . prestation AS prestation_104 , t0 . divers AS divers_105 , t0 . divers_composes AS divers_composes_106 , t0 . declinaison AS declinaison_107 , t0 . mouvemente AS mouvemente_108 , t0 . maj_poids AS maj_poids_109 , t0 . maj_prix_base AS maj_prix_base_110 , t0 . cond_achat AS cond_achat_111 , t0 . commentaire_dimensions AS commentaire_dimensions_112 , t0 . maj_composes AS maj_composes_113 , t0 . dispo AS dispo_114 , t0 . maj_dispo AS maj_dispo_115 , t0 . numero_reference AS numero_reference_116 , t0 . estParent AS estParent_117 , t0 . capacite_production AS capacite_production_118 , t0 . maj_capacite_prod AS maj_capacite_prod_119 , t0 . pump_hors_frais AS pump_hors_frais_120 , t0 . maj_pump AS maj_pump_121 , t0 . id_prestahop AS id_prestahop_122 , t0 . id_combination_prestahop AS id_combination_prestahop_123 , t0 . oqton_urn AS oqton_urn_124 , t0 . oqton_material_urn AS oqton_material_urn_125 , t0 . a_publier AS a_publier_126 , t0 . date_a_publier AS date_a_publier_127 , t0 . position AS position_128 , t0 . forme_hors_standard AS forme_hors_standard_129 , t0 . article_remplacement_id AS article_remplacement_id_130 , t0 . niveau_un_id AS niveau_un_id_131 , t0 . niveau_deux_id AS niveau_deux_id_132 , t0 . niveau_trois_id AS niveau_trois_id_133 , t0 . niveau_quatre_id AS niveau_quatre_id_134 , t0 . regle_taxe_id AS regle_taxe_id_135 , t0 . regle_taxe_achat_id AS regle_taxe_achat_id_136 , t0 . utilisateur_id AS utilisateur_id_137 , t0 . categorie_remise_article_id AS categorie_remise_article_id_138 , t0 . marque_id AS marque_id_139 , t0 . finition_id AS finition_id_140 , t0 . caisse_id AS caisse_id_141 , t0 . atelier_id AS atelier_id_142 , t0 . famille_compta_id AS famille_compta_id_143 , t0 . type_id AS type_id_144 , t0 . unite_mesure_id AS unite_mesure_id_145 , t0 . fournisseur_defaut_id AS fournisseur_defaut_id_146 , t0 . condition_achat_defaut_id AS condition_achat_defaut_id_147 , t0 . article_enconsigne_id AS article_enconsigne_id_148 , t0 . parent_id AS parent_id_149 , t0 . article_declinaison_parent_id AS article_declinaison_parent_id_150 , t0 . transporteur_id AS transporteur_id_151 , t0 . transporteur2_id AS transporteur2_id_152 FROM article__article t0 WHERE t0 . id = 2665 AND ((t0 . date_supression IS NULL )); Copy
8
0.22 ms
SELECT t0 . id AS id_1 , t0 . id_prestashop AS id_prestashop_2 , t0 . url AS url_3 , t0 . date AS date_4 , t0 . extension AS extension_5 , t0 . position AS position_6 , t0 . affichage_web AS affichage_web_7 , t0 . id_import AS id_import_8 , t0 . id_import_woo AS id_import_woo_9 , t0 . ulid AS ulid_10 , t0 . article_id AS article_id_11 FROM article__image t0 WHERE t0 . article_id = ? AND t0 . affichage_web = ? ORDER BY t0 . position ASC LIMIT 1
SELECT t0 . id AS id_1 , t0 . id_prestashop AS id_prestashop_2 , t0 . url AS url_3 , t0 . date AS date_4 , t0 . extension AS extension_5 , t0 . position AS position_6 , t0 . affichage_web AS affichage_web_7 , t0 . id_import AS id_import_8 , t0 . id_import_woo AS id_import_woo_9 , t0 . ulid AS ulid_10 , t0 . article_id AS article_id_11 FROM article__image t0 WHERE t0 . article_id = 2665 AND t0 . affichage_web = 1 ORDER BY t0 . position ASC LIMIT 1 ; Copy
9
0.25 ms
SELECT a0_ . id AS id_0 , a0_ . date AS date_1 , a0_ . quantite AS quantite_2 , a0_ . article_id AS article_id_3 FROM article__date_dispo a0_ WHERE a0_ . article_id = ? AND ((a0_ . date > = ? OR a0_ . date IS NULL )) AND a0_ . quantite > ? ORDER BY CASE WHEN a0_ . date IS NULL THEN 1 ELSE 0 END ASC , a0_ . date ASC LIMIT 10
Parameters :
[
2665
"2026-08-04 00:00:00 "
0
]
SELECT a0_ . id AS id_0 , a0_ . date AS date_1 , a0_ . quantite AS quantite_2 , a0_ . article_id AS article_id_3 FROM article__date_dispo a0_ WHERE a0_ . article_id = 2665 AND ((a0_ . date > = '2026-08-04 00:00:00' OR a0_ . date IS NULL )) AND a0_ . quantite > 0 ORDER BY CASE WHEN a0_ . date IS NULL THEN 1 ELSE 0 END ASC , a0_ . date ASC LIMIT 10 ; Copy
10
0.35 ms
SELECT t0 . id AS id_1 , t0 . groupe AS groupe_2 , t0 . jours_livraison AS jours_livraison_3 , t0 . tva AS tva_4 , t0 . id_import AS id_import_5 , t0 . id_import_2 AS id_import_2_6 , t0 . id_prestashop AS id_prestashop_7 , t0 . donnees_import AS donnees_import_8 , t0 . logo AS logo_9 , t0 . date AS date_10 , t0 . date_maj AS date_maj_11 , t0 . reference AS reference_12 , t0 . numero_reference AS numero_reference_13 , t0 . code_comptable AS code_comptable_14 , t0 . banque AS banque_15 , t0 . guichet AS guichet_16 , t0 . n_cpte_banque AS n_cpte_banque_17 , t0 . cle_banque AS cle_banque_18 , t0 . domiciliation_1 AS domiciliation_1_19 , t0 . domiciliation_2 AS domiciliation_2_20 , t0 . iban AS iban_21 , t0 . bic AS bic_22 , t0 . prenom AS prenom_23 , t0 . nom AS nom_24 , t0 . civilite AS civilite_25 , t0 . telephone AS telephone_26 , t0 . telephone2 AS telephone2_27 , t0 . fax AS fax_28 , t0 . email AS email_29 , t0 . numTva AS numTva_30 , t0 . siren AS siren_31 , t0 . siret AS siret_32 , t0 . ape AS ape_33 , t0 . date_supression AS date_supression_34 , t0 . commentaire AS commentaire_35 , t0 . commentaire_facture AS commentaire_facture_36 , t0 . commentaire_supplementaire AS commentaire_supplementaire_37 , t0 . reference_client_obligatoire AS reference_client_obligatoire_38 , t0 . facturation_multi_bl AS facturation_multi_bl_39 , t0 . doublon AS doublon_40 , t0 . accepte_produit_auto AS accepte_produit_auto_41 , t0 . archive AS archive_42 , t0 . email_facture_auto AS email_facture_auto_43 , t0 . societe AS societe_44 , t0 . date_synchro_documents_erp AS date_synchro_documents_erp_45 , t0 . statut_api AS statut_api_46 , t0 . parent_id AS parent_id_47 , t0 . langue_id AS langue_id_48 , t0 . civilite_obj_id AS civilite_obj_id_49 , t0 . transporteur_id AS transporteur_id_50 , t0 . pays_id AS pays_id_51 , t0 . ville_id AS ville_id_52 , t0 . code_postal_id AS code_postal_id_53 , t0 . utilisateur_id AS utilisateur_id_54 , t0 . origine_id AS origine_id_55 , t0 . secteur_geographique_id AS secteur_geographique_id_56 , t0 . forme_juridique_id AS forme_juridique_id_57 , t0 . classification_id AS classification_id_58 , t0 . type_client_id AS type_client_id_59 , t0 . delai_paiement_id AS delai_paiement_id_60 , t0 . modereglement_id AS modereglement_id_61 , t0 . compta_id AS compta_id_62 , t0 . compte_market_place_id AS compte_market_place_id_63 FROM client__client t0 WHERE t0 . id = ? AND ((t0 . date_supression IS NULL ))
SELECT
t0 . id AS id_1 ,
t0 . groupe AS groupe_2 ,
t0 . jours_livraison AS jours_livraison_3 ,
t0 . tva AS tva_4 ,
t0 . id_import AS id_import_5 ,
t0 . id_import_2 AS id_import_2_6 ,
t0 . id_prestashop AS id_prestashop_7 ,
t0 . donnees_import AS donnees_import_8 ,
t0 . logo AS logo_9 ,
t0 . date AS date_10 ,
t0 . date_maj AS date_maj_11 ,
t0 . reference AS reference_12 ,
t0 . numero_reference AS numero_reference_13 ,
t0 . code_comptable AS code_comptable_14 ,
t0 . banque AS banque_15 ,
t0 . guichet AS guichet_16 ,
t0 . n_cpte_banque AS n_cpte_banque_17 ,
t0 . cle_banque AS cle_banque_18 ,
t0 . domiciliation_1 AS domiciliation_1_19 ,
t0 . domiciliation_2 AS domiciliation_2_20 ,
t0 . iban AS iban_21 ,
t0 . bic AS bic_22 ,
t0 . prenom AS prenom_23 ,
t0 . nom AS nom_24 ,
t0 . civilite AS civilite_25 ,
t0 . telephone AS telephone_26 ,
t0 . telephone2 AS telephone2_27 ,
t0 . fax AS fax_28 ,
t0 . email AS email_29 ,
t0 . numTva AS numTva_30 ,
t0 . siren AS siren_31 ,
t0 . siret AS siret_32 ,
t0 . ape AS ape_33 ,
t0 . date_supression AS date_supression_34 ,
t0 . commentaire AS commentaire_35 ,
t0 . commentaire_facture AS commentaire_facture_36 ,
t0 . commentaire_supplementaire AS commentaire_supplementaire_37 ,
t0 . reference_client_obligatoire AS reference_client_obligatoire_38 ,
t0 . facturation_multi_bl AS facturation_multi_bl_39 ,
t0 . doublon AS doublon_40 ,
t0 . accepte_produit_auto AS accepte_produit_auto_41 ,
t0 . archive AS archive_42 ,
t0 . email_facture_auto AS email_facture_auto_43 ,
t0 . societe AS societe_44 ,
t0 . date_synchro_documents_erp AS date_synchro_documents_erp_45 ,
t0 . statut_api AS statut_api_46 ,
t0 . parent_id AS parent_id_47 ,
t0 . langue_id AS langue_id_48 ,
t0 . civilite_obj_id AS civilite_obj_id_49 ,
t0 . transporteur_id AS transporteur_id_50 ,
t0 . pays_id AS pays_id_51 ,
t0 . ville_id AS ville_id_52 ,
t0 . code_postal_id AS code_postal_id_53 ,
t0 . utilisateur_id AS utilisateur_id_54 ,
t0 . origine_id AS origine_id_55 ,
t0 . secteur_geographique_id AS secteur_geographique_id_56 ,
t0 . forme_juridique_id AS forme_juridique_id_57 ,
t0 . classification_id AS classification_id_58 ,
t0 . type_client_id AS type_client_id_59 ,
t0 . delai_paiement_id AS delai_paiement_id_60 ,
t0 . modereglement_id AS modereglement_id_61 ,
t0 . compta_id AS compta_id_62 ,
t0 . compte_market_place_id AS compte_market_place_id_63
FROM
client__client t0
WHERE
t0 . id = ?
AND (
(t0 . date_supression IS NULL )
)Copy
SELECT t0 . id AS id_1 , t0 . groupe AS groupe_2 , t0 . jours_livraison AS jours_livraison_3 , t0 . tva AS tva_4 , t0 . id_import AS id_import_5 , t0 . id_import_2 AS id_import_2_6 , t0 . id_prestashop AS id_prestashop_7 , t0 . donnees_import AS donnees_import_8 , t0 . logo AS logo_9 , t0 . date AS date_10 , t0 . date_maj AS date_maj_11 , t0 . reference AS reference_12 , t0 . numero_reference AS numero_reference_13 , t0 . code_comptable AS code_comptable_14 , t0 . banque AS banque_15 , t0 . guichet AS guichet_16 , t0 . n_cpte_banque AS n_cpte_banque_17 , t0 . cle_banque AS cle_banque_18 , t0 . domiciliation_1 AS domiciliation_1_19 , t0 . domiciliation_2 AS domiciliation_2_20 , t0 . iban AS iban_21 , t0 . bic AS bic_22 , t0 . prenom AS prenom_23 , t0 . nom AS nom_24 , t0 . civilite AS civilite_25 , t0 . telephone AS telephone_26 , t0 . telephone2 AS telephone2_27 , t0 . fax AS fax_28 , t0 . email AS email_29 , t0 . numTva AS numTva_30 , t0 . siren AS siren_31 , t0 . siret AS siret_32 , t0 . ape AS ape_33 , t0 . date_supression AS date_supression_34 , t0 . commentaire AS commentaire_35 , t0 . commentaire_facture AS commentaire_facture_36 , t0 . commentaire_supplementaire AS commentaire_supplementaire_37 , t0 . reference_client_obligatoire AS reference_client_obligatoire_38 , t0 . facturation_multi_bl AS facturation_multi_bl_39 , t0 . doublon AS doublon_40 , t0 . accepte_produit_auto AS accepte_produit_auto_41 , t0 . archive AS archive_42 , t0 . email_facture_auto AS email_facture_auto_43 , t0 . societe AS societe_44 , t0 . date_synchro_documents_erp AS date_synchro_documents_erp_45 , t0 . statut_api AS statut_api_46 , t0 . parent_id AS parent_id_47 , t0 . langue_id AS langue_id_48 , t0 . civilite_obj_id AS civilite_obj_id_49 , t0 . transporteur_id AS transporteur_id_50 , t0 . pays_id AS pays_id_51 , t0 . ville_id AS ville_id_52 , t0 . code_postal_id AS code_postal_id_53 , t0 . utilisateur_id AS utilisateur_id_54 , t0 . origine_id AS origine_id_55 , t0 . secteur_geographique_id AS secteur_geographique_id_56 , t0 . forme_juridique_id AS forme_juridique_id_57 , t0 . classification_id AS classification_id_58 , t0 . type_client_id AS type_client_id_59 , t0 . delai_paiement_id AS delai_paiement_id_60 , t0 . modereglement_id AS modereglement_id_61 , t0 . compta_id AS compta_id_62 , t0 . compte_market_place_id AS compte_market_place_id_63 FROM client__client t0 WHERE t0 . id = 1 AND ((t0 . date_supression IS NULL )); Copy
11
0.17 ms
SELECT t0 . id AS id_1 , t0 . date AS date_2 , t0 . dateMaj AS dateMaj_3 , t0 . dateSuppression AS dateSuppression_4 , t0 . statut AS statut_5 , t0 . categorie_remise_client_id AS categorie_remise_client_id_6 , t0 . client_id AS client_id_7 FROM remise__categorie_remise_client_client t0 WHERE t0 . client_id = ?
SELECT t0 . id AS id_1 , t0 . date AS date_2 , t0 . dateMaj AS dateMaj_3 , t0 . dateSuppression AS dateSuppression_4 , t0 . statut AS statut_5 , t0 . categorie_remise_client_id AS categorie_remise_client_id_6 , t0 . client_id AS client_id_7 FROM remise__categorie_remise_client_client t0 WHERE t0 . client_id = 1 ; Copy
12
0.16 ms
SELECT t0 . id AS id_1 , t0 . position AS position_2 , t0 . categorie_id AS categorie_id_3 , t0 . article_id AS article_id_4 , t0 . article_market_place_id AS article_market_place_id_5 , t0 . market_place_id AS market_place_id_6 FROM article__article_categorie t0 WHERE t0 . article_id = ?
SELECT t0 . id AS id_1 , t0 . position AS position_2 , t0 . categorie_id AS categorie_id_3 , t0 . article_id AS article_id_4 , t0 . article_market_place_id AS article_market_place_id_5 , t0 . market_place_id AS market_place_id_6 FROM article__article_categorie t0 WHERE t0 . article_id = 2665 ; Copy
13
0.18 ms
SELECT t0 . id AS id_1 , t0 . dateMaj AS dateMaj_2 , t0 . dateSuppression AS dateSuppression_3 , t0 . date AS date_4 , t0 . categorie_id AS categorie_id_5 , t0 . client_id AS client_id_6 FROM client__client_categorie t0 WHERE t0 . client_id = ? AND ((t0 . dateSuppression IS NULL ))
SELECT t0 . id AS id_1 , t0 . dateMaj AS dateMaj_2 , t0 . dateSuppression AS dateSuppression_3 , t0 . date AS date_4 , t0 . categorie_id AS categorie_id_5 , t0 . client_id AS client_id_6 FROM client__client_categorie t0 WHERE t0 . client_id = 1 AND ((t0 . dateSuppression IS NULL )); Copy
14
1.49 ms
SELECT id , libelle
FROM
remise__remise r
WHERE
r . dateSuppression IS NULL
AND
r . statut = 1
AND
r . date_debut < = '2026-08-04 16:00:29'
AND
r . date_fin > = '2026-08-04 16:00:29'
AND
r . quantite_restante > 0
AND
r . parent_id IS NULL
AND
(r . article_id IS NULL OR r . article_id = '2665' )
AND
(r . client_id IS NULL OR r . client_id = '1' )
AND
(
r . id IN (SELECT remise_id FROM remise__remise_marque_article m WHERE m . marque_id = '213' AND m . dateSuppression IS NULL )
OR
r . id NOT IN (SELECT remise_id FROM remise__remise_marque_article m WHERE m . dateSuppression IS NULL )
)
AND
(
r . id IN (SELECT remise_id FROM remise__categorie_remise_article_remise m WHERE m . categorie_remise_article_id = '69' AND m . dateSuppression IS NULL )
OR
r . id NOT IN (SELECT remise_id FROM remise__categorie_remise_article_remise m WHERE m . dateSuppression IS NULL )
)
AND
(
r . id IN (SELECT remise_id FROM remise__categorie_remise_client_remise m WHERE m . categorie_remise_client_id IN (3 ) AND m . dateSuppression IS NULL )
OR
r . id NOT IN (SELECT remise_id FROM remise__categorie_remise_client_remise m WHERE m . dateSuppression IS NULL )
)
AND
(
r . id IN (SELECT remise_id FROM remise__remise_categorie_article m WHERE m . categorie_id IN (1028 , 1025 , 1023 ) AND m . dateSuppression IS NULL )
OR
r . id NOT IN (SELECT remise_id FROM remise__remise_categorie_article m WHERE m . dateSuppression IS NULL )
)
AND
(
r . id IN (SELECT remise_id FROM remise__remise_categorie_client m WHERE m . categorie_id IN (6 , 12 ) AND m . dateSuppression IS NULL )
OR
r . id NOT IN (SELECT remise_id FROM remise__remise_categorie_client m WHERE m . dateSuppression IS NULL )
)
SELECT id , libelle
FROM
remise__remise r
WHERE
r . dateSuppression IS NULL
AND
r . statut = 1
AND
r . date_debut < = '2026-08-04 16:00:29'
AND
r . date_fin > = '2026-08-04 16:00:29'
AND
r . quantite_restante > 0
AND
r . parent_id IS NULL
AND
(r . article_id IS NULL OR r . article_id = '2665' )
AND
(r . client_id IS NULL OR r . client_id = '1' )
AND
(
r . id IN (SELECT remise_id FROM remise__remise_marque_article m WHERE m . marque_id = '213' AND m . dateSuppression IS NULL )
OR
r . id NOT IN (SELECT remise_id FROM remise__remise_marque_article m WHERE m . dateSuppression IS NULL )
)
AND
(
r . id IN (SELECT remise_id FROM remise__categorie_remise_article_remise m WHERE m . categorie_remise_article_id = '69' AND m . dateSuppression IS NULL )
OR
r . id NOT IN (SELECT remise_id FROM remise__categorie_remise_article_remise m WHERE m . dateSuppression IS NULL )
)
AND
(
r . id IN (SELECT remise_id FROM remise__categorie_remise_client_remise m WHERE m . categorie_remise_client_id IN (3 ) AND m . dateSuppression IS NULL )
OR
r . id NOT IN (SELECT remise_id FROM remise__categorie_remise_client_remise m WHERE m . dateSuppression IS NULL )
)
AND
(
r . id IN (SELECT remise_id FROM remise__remise_categorie_article m WHERE m . categorie_id IN (1028 , 1025 , 1023 ) AND m . dateSuppression IS NULL )
OR
r . id NOT IN (SELECT remise_id FROM remise__remise_categorie_article m WHERE m . dateSuppression IS NULL )
)
AND
(
r . id IN (SELECT remise_id FROM remise__remise_categorie_client m WHERE m . categorie_id IN (6 , 12 ) AND m . dateSuppression IS NULL )
OR
r . id NOT IN (SELECT remise_id FROM remise__remise_categorie_client m WHERE m . dateSuppression IS NULL )
)
; Copy
15
0.19 ms
SELECT t0 . id AS id_1 , t0 . id_import AS id_import_2 , t0 . date_debut AS date_debut_3 , t0 . date_fin AS date_fin_4 , t0 . montant AS montant_5 , t0 . typeReduction AS typeReduction_6 , t0 . montant_minimum_commande AS montant_minimum_commande_7 , t0 . statut AS statut_8 , t0 . description AS description_9 , t0 . quantite_restante AS quantite_restante_10 , t0 . quantite_total AS quantite_total_11 , t0 . quantite_max_personne AS quantite_max_personne_12 , t0 . libelle AS libelle_13 , t0 . date AS date_14 , t0 . dateSuppression AS dateSuppression_15 , t0 . dateMaj AS dateMaj_16 , t0 . visible AS visible_17 , t0 . client_id AS client_id_18 , t0 . article_id AS article_id_19 , t0 . parent_id AS parent_id_20 , t0 . utilisateur_id AS utilisateur_id_21 FROM remise__remise t0 WHERE t0 . id = ? AND ((t0 . dateSuppression IS NULL ))
SELECT t0 . id AS id_1 , t0 . id_import AS id_import_2 , t0 . date_debut AS date_debut_3 , t0 . date_fin AS date_fin_4 , t0 . montant AS montant_5 , t0 . typeReduction AS typeReduction_6 , t0 . montant_minimum_commande AS montant_minimum_commande_7 , t0 . statut AS statut_8 , t0 . description AS description_9 , t0 . quantite_restante AS quantite_restante_10 , t0 . quantite_total AS quantite_total_11 , t0 . quantite_max_personne AS quantite_max_personne_12 , t0 . libelle AS libelle_13 , t0 . date AS date_14 , t0 . dateSuppression AS dateSuppression_15 , t0 . dateMaj AS dateMaj_16 , t0 . visible AS visible_17 , t0 . client_id AS client_id_18 , t0 . article_id AS article_id_19 , t0 . parent_id AS parent_id_20 , t0 . utilisateur_id AS utilisateur_id_21 FROM remise__remise t0 WHERE t0 . id = 186 AND ((t0 . dateSuppression IS NULL )); Copy
16
0.22 ms
SELECT t0 . id AS id_1 , t0 . position AS position_2 , t0 . reference AS reference_3 , t0 . suivi_colis AS suivi_colis_4 , t0 . tracking AS tracking_5 , t0 . id_import AS id_import_6 , t0 . coeff_vente AS coeff_vente_7 , t0 . statut AS statut_8 , t0 . libelle AS libelle_9 , t0 . transporteur_cdiscount AS transporteur_cdiscount_10 , t0 . date AS date_11 , t0 . dateMaj AS dateMaj_12 , t0 . dateSuppression AS dateSuppression_13 , t0 . telephone AS telephone_14 , t0 . telephone2 AS telephone2_15 , t0 . commentaire AS commentaire_16 , t0 . fax AS fax_17 , t0 . email AS email_18 , t0 . responsable AS responsable_19 , t0 . delaiHabituel AS delaiHabituel_20 , t0 . montantFraisFixe AS montantFraisFixe_21 , t0 . logo AS logo_22 , t0 . service_code AS service_code_23 , t0 . mode_livraison_amazon AS mode_livraison_amazon_24 , t0 . transporteur_amazon AS transporteur_amazon_25 , t0 . transporteur_ebay AS transporteur_ebay_26 , t0 . rapport_cloture AS rapport_cloture_27 , t0 . priorite AS priorite_28 , t0 . dimensionColisUnitaireMax AS dimensionColisUnitaireMax_29 , t0 . dimensionColisUnitaireMin AS dimensionColisUnitaireMin_30 , t0 . totalDimensionsColisMax AS totalDimensionsColisMax_31 , t0 . totalDimensionsColisMin AS totalDimensionsColisMin_32 , t0 . poidsColisUnitaireMax AS poidsColisUnitaireMax_33 , t0 . poidsColisUnitaireMin AS poidsColisUnitaireMin_34 , t0 . totalPoidsColisMax AS totalPoidsColisMax_35 , t0 . totalPoidsColisMin AS totalPoidsColisMin_36 , t0 . nombreColisMax AS nombreColisMax_37 , t0 . acceptePalette AS acceptePalette_38 , t0 . notification_mail_emballage AS notification_mail_emballage_39 , t0 . url_tracking AS url_tracking_40 , t0 . exclus_forme_hors_standard AS exclus_forme_hors_standard_41 , t0 . depassement_dimension AS depassement_dimension_42 , t0 . surcout_depassement_dimension AS surcout_depassement_dimension_43 , t0 . livraison_societe AS livraison_societe_44 , t0 . livraison_particulier AS livraison_particulier_45 , t0 . poids_max_consolidation AS poids_max_consolidation_46 , t0 . regle_taxe_id AS regle_taxe_id_47 , t0 . utilisateur_id AS utilisateur_id_48 FROM transporteur__transporteur t0 WHERE t0 . id = ? AND ((t0 . dateSuppression IS NULL ))
SELECT
t0 . id AS id_1 ,
t0 . position AS position_2 ,
t0 . reference AS reference_3 ,
t0 . suivi_colis AS suivi_colis_4 ,
t0 . tracking AS tracking_5 ,
t0 . id_import AS id_import_6 ,
t0 . coeff_vente AS coeff_vente_7 ,
t0 . statut AS statut_8 ,
t0 . libelle AS libelle_9 ,
t0 . transporteur_cdiscount AS transporteur_cdiscount_10 ,
t0 . date AS date_11 ,
t0 . dateMaj AS dateMaj_12 ,
t0 . dateSuppression AS dateSuppression_13 ,
t0 . telephone AS telephone_14 ,
t0 . telephone2 AS telephone2_15 ,
t0 . commentaire AS commentaire_16 ,
t0 . fax AS fax_17 ,
t0 . email AS email_18 ,
t0 . responsable AS responsable_19 ,
t0 . delaiHabituel AS delaiHabituel_20 ,
t0 . montantFraisFixe AS montantFraisFixe_21 ,
t0 . logo AS logo_22 ,
t0 . service_code AS service_code_23 ,
t0 . mode_livraison_amazon AS mode_livraison_amazon_24 ,
t0 . transporteur_amazon AS transporteur_amazon_25 ,
t0 . transporteur_ebay AS transporteur_ebay_26 ,
t0 . rapport_cloture AS rapport_cloture_27 ,
t0 . priorite AS priorite_28 ,
t0 . dimensionColisUnitaireMax AS dimensionColisUnitaireMax_29 ,
t0 . dimensionColisUnitaireMin AS dimensionColisUnitaireMin_30 ,
t0 . totalDimensionsColisMax AS totalDimensionsColisMax_31 ,
t0 . totalDimensionsColisMin AS totalDimensionsColisMin_32 ,
t0 . poidsColisUnitaireMax AS poidsColisUnitaireMax_33 ,
t0 . poidsColisUnitaireMin AS poidsColisUnitaireMin_34 ,
t0 . totalPoidsColisMax AS totalPoidsColisMax_35 ,
t0 . totalPoidsColisMin AS totalPoidsColisMin_36 ,
t0 . nombreColisMax AS nombreColisMax_37 ,
t0 . acceptePalette AS acceptePalette_38 ,
t0 . notification_mail_emballage AS notification_mail_emballage_39 ,
t0 . url_tracking AS url_tracking_40 ,
t0 . exclus_forme_hors_standard AS exclus_forme_hors_standard_41 ,
t0 . depassement_dimension AS depassement_dimension_42 ,
t0 . surcout_depassement_dimension AS surcout_depassement_dimension_43 ,
t0 . livraison_societe AS livraison_societe_44 ,
t0 . livraison_particulier AS livraison_particulier_45 ,
t0 . poids_max_consolidation AS poids_max_consolidation_46 ,
t0 . regle_taxe_id AS regle_taxe_id_47 ,
t0 . utilisateur_id AS utilisateur_id_48
FROM
transporteur__transporteur t0
WHERE
t0 . id = ?
AND (
(t0 . dateSuppression IS NULL )
)Copy
SELECT t0 . id AS id_1 , t0 . position AS position_2 , t0 . reference AS reference_3 , t0 . suivi_colis AS suivi_colis_4 , t0 . tracking AS tracking_5 , t0 . id_import AS id_import_6 , t0 . coeff_vente AS coeff_vente_7 , t0 . statut AS statut_8 , t0 . libelle AS libelle_9 , t0 . transporteur_cdiscount AS transporteur_cdiscount_10 , t0 . date AS date_11 , t0 . dateMaj AS dateMaj_12 , t0 . dateSuppression AS dateSuppression_13 , t0 . telephone AS telephone_14 , t0 . telephone2 AS telephone2_15 , t0 . commentaire AS commentaire_16 , t0 . fax AS fax_17 , t0 . email AS email_18 , t0 . responsable AS responsable_19 , t0 . delaiHabituel AS delaiHabituel_20 , t0 . montantFraisFixe AS montantFraisFixe_21 , t0 . logo AS logo_22 , t0 . service_code AS service_code_23 , t0 . mode_livraison_amazon AS mode_livraison_amazon_24 , t0 . transporteur_amazon AS transporteur_amazon_25 , t0 . transporteur_ebay AS transporteur_ebay_26 , t0 . rapport_cloture AS rapport_cloture_27 , t0 . priorite AS priorite_28 , t0 . dimensionColisUnitaireMax AS dimensionColisUnitaireMax_29 , t0 . dimensionColisUnitaireMin AS dimensionColisUnitaireMin_30 , t0 . totalDimensionsColisMax AS totalDimensionsColisMax_31 , t0 . totalDimensionsColisMin AS totalDimensionsColisMin_32 , t0 . poidsColisUnitaireMax AS poidsColisUnitaireMax_33 , t0 . poidsColisUnitaireMin AS poidsColisUnitaireMin_34 , t0 . totalPoidsColisMax AS totalPoidsColisMax_35 , t0 . totalPoidsColisMin AS totalPoidsColisMin_36 , t0 . nombreColisMax AS nombreColisMax_37 , t0 . acceptePalette AS acceptePalette_38 , t0 . notification_mail_emballage AS notification_mail_emballage_39 , t0 . url_tracking AS url_tracking_40 , t0 . exclus_forme_hors_standard AS exclus_forme_hors_standard_41 , t0 . depassement_dimension AS depassement_dimension_42 , t0 . surcout_depassement_dimension AS surcout_depassement_dimension_43 , t0 . livraison_societe AS livraison_societe_44 , t0 . livraison_particulier AS livraison_particulier_45 , t0 . poids_max_consolidation AS poids_max_consolidation_46 , t0 . regle_taxe_id AS regle_taxe_id_47 , t0 . utilisateur_id AS utilisateur_id_48 FROM transporteur__transporteur t0 WHERE t0 . id = 4 AND ((t0 . dateSuppression IS NULL )); Copy
17
0.15 ms
SELECT t0 . id AS id_1 , t0 . id_prestashop AS id_prestashop_2 , t0 . url AS url_3 , t0 . date AS date_4 , t0 . extension AS extension_5 , t0 . position AS position_6 , t0 . affichage_web AS affichage_web_7 , t0 . id_import AS id_import_8 , t0 . id_import_woo AS id_import_woo_9 , t0 . ulid AS ulid_10 , t0 . article_id AS article_id_11 FROM article__image t0 WHERE t0 . article_id = ?
SELECT t0 . id AS id_1 , t0 . id_prestashop AS id_prestashop_2 , t0 . url AS url_3 , t0 . date AS date_4 , t0 . extension AS extension_5 , t0 . position AS position_6 , t0 . affichage_web AS affichage_web_7 , t0 . id_import AS id_import_8 , t0 . id_import_woo AS id_import_woo_9 , t0 . ulid AS ulid_10 , t0 . article_id AS article_id_11 FROM article__image t0 WHERE t0 . article_id = 2665 ; Copy