1
0.25 ms
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 = ? Copy
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 ; Copy
2
0.46 ms
SELECT t0 . id AS id_1 , t0 . reference AS reference_2 , t0 . id_import AS id_import_3 , t0 . logo AS logo_4 , t0 . libelle AS libelle_5 , t0 . date AS date_6 , t0 . description AS description_7 , t0 . description_courte AS description_courte_8 , t0 . date_supression AS date_supression_9 , t0 . date_maj AS date_maj_10 , t0 . statut AS statut_11 , t0 . position AS position_12 , t0 . logo_nb AS logo_nb_13 , t0 . visible_accueil_ep_obi AS visible_accueil_ep_obi_14 , t0 . statut_api AS statut_api_15 , t0 . utilisateur_id AS utilisateur_id_16 FROM article__marque t0 WHERE t0 . visible_accueil_ep_obi = ? AND ((t0 . date_supression IS NULL ))
SELECT t0 . id AS id_1 , t0 . reference AS reference_2 , t0 . id_import AS id_import_3 , t0 . logo AS logo_4 , t0 . libelle AS libelle_5 , t0 . date AS date_6 , t0 . description AS description_7 , t0 . description_courte AS description_courte_8 , t0 . date_supression AS date_supression_9 , t0 . date_maj AS date_maj_10 , t0 . statut AS statut_11 , t0 . position AS position_12 , t0 . logo_nb AS logo_nb_13 , t0 . visible_accueil_ep_obi AS visible_accueil_ep_obi_14 , t0 . statut_api AS statut_api_15 , t0 . utilisateur_id AS utilisateur_id_16 FROM article__marque t0 WHERE t0 . visible_accueil_ep_obi = 1 AND ((t0 . date_supression IS NULL )); Copy
3
0.21 ms
SELECT f0_ . id AS id_0 , f0_ . url AS url_1 , f0_ . date AS date_2 , f0_ . dossier AS dossier_3 , f0_ . lien AS lien_4 , f0_ . statut AS statut_5 , f0_ . mobile AS mobile_6 , f0_ . position AS position_7 , f0_ . date_debut AS date_debut_8 , f0_ . date_fin AS date_fin_9 , f0_ . articles AS articles_10 , f0_ . societe_id AS societe_id_11 FROM fo__document f0_ WHERE f0_ . dossier = ? AND f0_ . statut = ? AND f0_ . mobile = ? AND f0_ . date_debut < = ? AND ((f0_ . date_fin > = ? OR f0_ . date_fin IS NULL )) ORDER BY f0_ . position ASC
Parameters :
[
"carrousel "
1
0
"2026-05-10 00:38:18 "
"2026-05-10 00:38:18 "
]
SELECT f0_ . id AS id_0 , f0_ . url AS url_1 , f0_ . date AS date_2 , f0_ . dossier AS dossier_3 , f0_ . lien AS lien_4 , f0_ . statut AS statut_5 , f0_ . mobile AS mobile_6 , f0_ . position AS position_7 , f0_ . date_debut AS date_debut_8 , f0_ . date_fin AS date_fin_9 , f0_ . articles AS articles_10 , f0_ . societe_id AS societe_id_11 FROM fo__document f0_ WHERE f0_ . dossier = 'carrousel' AND f0_ . statut = 1 AND f0_ . mobile = 0 AND f0_ . date_debut < = '2026-05-10 00:38:18' AND ((f0_ . date_fin > = '2026-05-10 00:38:18' OR f0_ . date_fin IS NULL )) ORDER BY f0_ . position ASC ; Copy
4
0.16 ms
SELECT f0_ . id AS id_0 , f0_ . url AS url_1 , f0_ . date AS date_2 , f0_ . dossier AS dossier_3 , f0_ . lien AS lien_4 , f0_ . statut AS statut_5 , f0_ . mobile AS mobile_6 , f0_ . position AS position_7 , f0_ . date_debut AS date_debut_8 , f0_ . date_fin AS date_fin_9 , f0_ . articles AS articles_10 , f0_ . societe_id AS societe_id_11 FROM fo__document f0_ WHERE f0_ . dossier = ? AND f0_ . statut = ? AND f0_ . mobile = ? AND f0_ . date_debut < = ? AND ((f0_ . date_fin > = ? OR f0_ . date_fin IS NULL )) ORDER BY f0_ . position ASC
Parameters :
[
"carrousel "
1
1
"2026-05-10 00:38:18 "
"2026-05-10 00:38:18 "
]
SELECT f0_ . id AS id_0 , f0_ . url AS url_1 , f0_ . date AS date_2 , f0_ . dossier AS dossier_3 , f0_ . lien AS lien_4 , f0_ . statut AS statut_5 , f0_ . mobile AS mobile_6 , f0_ . position AS position_7 , f0_ . date_debut AS date_debut_8 , f0_ . date_fin AS date_fin_9 , f0_ . articles AS articles_10 , f0_ . societe_id AS societe_id_11 FROM fo__document f0_ WHERE f0_ . dossier = 'carrousel' AND f0_ . statut = 1 AND f0_ . mobile = 1 AND f0_ . date_debut < = '2026-05-10 00:38:18' AND ((f0_ . date_fin > = '2026-05-10 00:38:18' OR f0_ . date_fin IS NULL )) ORDER BY f0_ . position ASC ; Copy
5
0.39 ms
SELECT t0 . id AS id_1 , t0 . document_commercial_id AS document_commercial_id_2 , t0 . ordre AS ordre_3 , t0 . libelle AS libelle_4 , t0 . date AS date_5 , t0 . dateMaj AS dateMaj_6 , t0 . dateSuppression AS dateSuppression_7 , t0 . action_statut_commande_id AS action_statut_commande_id_8 , t0 . utilisateur_id AS utilisateur_id_9 FROM commerciale__statut_commande t0 WHERE t0 . document_commercial_id = ? AND t0 . ordre = ? AND ((t0 . dateSuppression IS NULL )) LIMIT 1
SELECT t0 . id AS id_1 , t0 . document_commercial_id AS document_commercial_id_2 , t0 . ordre AS ordre_3 , t0 . libelle AS libelle_4 , t0 . date AS date_5 , t0 . dateMaj AS dateMaj_6 , t0 . dateSuppression AS dateSuppression_7 , t0 . action_statut_commande_id AS action_statut_commande_id_8 , t0 . utilisateur_id AS utilisateur_id_9 FROM commerciale__statut_commande t0 WHERE t0 . document_commercial_id = 14 AND t0 . ordre = '1' AND ((t0 . dateSuppression IS NULL )) LIMIT 1 ; Copy
6
0.77 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 . 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 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 . 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 ; Copy
7
0.47 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 . 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 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 . 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 ; Copy
8
0.56 ms
SELECT a . *
FROM article__article a
INNER JOIN article__article_categorie ac ON a . id = ac . article_id
LEFT JOIN article__marque m ON a . marque_id = m . id
LEFT JOIN client__client_marque ccm ON ccm . marque_id = a . marque_id AND ccm . client_id = :client_id
WHERE (a . dispo > :dispo OR 1 = 1 )
AND a . statut = :statut
AND ac . categorie_id = :categorie_id
AND (m . id IS NULL OR m . statut = 1 )
AND ccm . marque_id IS NULL
ORDER BY RAND ()
LIMIT :limit
Parameters :
[
"client_id " => null
"dispo " => 1
"statut " => 1
"categorie_id " => "1243 "
"limit " => 6
]
SELECT a . *
FROM article__article a
INNER JOIN article__article_categorie ac ON a . id = ac . article_id
LEFT JOIN article__marque m ON a . marque_id = m . id
LEFT JOIN client__client_marque ccm ON ccm . marque_id = a . marque_id AND ccm . client_id = NULL
WHERE (a . dispo > 1 OR 1 = 1 )
AND a . statut = 1
AND ac . categorie_id = '1243'
AND (m . id IS NULL OR m . statut = 1 )
AND ccm . marque_id IS NULL
ORDER BY RAND ()
LIMIT 6
; Copy
9
0.44 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 . article_remplacement_id AS article_remplacement_id_129 , t0 . niveau_un_id AS niveau_un_id_130 , t0 . niveau_deux_id AS niveau_deux_id_131 , t0 . niveau_trois_id AS niveau_trois_id_132 , t0 . niveau_quatre_id AS niveau_quatre_id_133 , t0 . regle_taxe_id AS regle_taxe_id_134 , t0 . regle_taxe_achat_id AS regle_taxe_achat_id_135 , t0 . utilisateur_id AS utilisateur_id_136 , t0 . categorie_remise_article_id AS categorie_remise_article_id_137 , t0 . marque_id AS marque_id_138 , t0 . finition_id AS finition_id_139 , t0 . caisse_id AS caisse_id_140 , t0 . atelier_id AS atelier_id_141 , t0 . famille_compta_id AS famille_compta_id_142 , t0 . type_id AS type_id_143 , t0 . unite_mesure_id AS unite_mesure_id_144 , t0 . fournisseur_defaut_id AS fournisseur_defaut_id_145 , t0 . condition_achat_defaut_id AS condition_achat_defaut_id_146 , t0 . article_enconsigne_id AS article_enconsigne_id_147 , t0 . parent_id AS parent_id_148 , t0 . article_declinaison_parent_id AS article_declinaison_parent_id_149 , t0 . transporteur_id AS transporteur_id_150 , t0 . transporteur2_id AS transporteur2_id_151 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 . article_remplacement_id AS article_remplacement_id_129 ,
t0 . niveau_un_id AS niveau_un_id_130 ,
t0 . niveau_deux_id AS niveau_deux_id_131 ,
t0 . niveau_trois_id AS niveau_trois_id_132 ,
t0 . niveau_quatre_id AS niveau_quatre_id_133 ,
t0 . regle_taxe_id AS regle_taxe_id_134 ,
t0 . regle_taxe_achat_id AS regle_taxe_achat_id_135 ,
t0 . utilisateur_id AS utilisateur_id_136 ,
t0 . categorie_remise_article_id AS categorie_remise_article_id_137 ,
t0 . marque_id AS marque_id_138 ,
t0 . finition_id AS finition_id_139 ,
t0 . caisse_id AS caisse_id_140 ,
t0 . atelier_id AS atelier_id_141 ,
t0 . famille_compta_id AS famille_compta_id_142 ,
t0 . type_id AS type_id_143 ,
t0 . unite_mesure_id AS unite_mesure_id_144 ,
t0 . fournisseur_defaut_id AS fournisseur_defaut_id_145 ,
t0 . condition_achat_defaut_id AS condition_achat_defaut_id_146 ,
t0 . article_enconsigne_id AS article_enconsigne_id_147 ,
t0 . parent_id AS parent_id_148 ,
t0 . article_declinaison_parent_id AS article_declinaison_parent_id_149 ,
t0 . transporteur_id AS transporteur_id_150 ,
t0 . transporteur2_id AS transporteur2_id_151
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 . article_remplacement_id AS article_remplacement_id_129 , t0 . niveau_un_id AS niveau_un_id_130 , t0 . niveau_deux_id AS niveau_deux_id_131 , t0 . niveau_trois_id AS niveau_trois_id_132 , t0 . niveau_quatre_id AS niveau_quatre_id_133 , t0 . regle_taxe_id AS regle_taxe_id_134 , t0 . regle_taxe_achat_id AS regle_taxe_achat_id_135 , t0 . utilisateur_id AS utilisateur_id_136 , t0 . categorie_remise_article_id AS categorie_remise_article_id_137 , t0 . marque_id AS marque_id_138 , t0 . finition_id AS finition_id_139 , t0 . caisse_id AS caisse_id_140 , t0 . atelier_id AS atelier_id_141 , t0 . famille_compta_id AS famille_compta_id_142 , t0 . type_id AS type_id_143 , t0 . unite_mesure_id AS unite_mesure_id_144 , t0 . fournisseur_defaut_id AS fournisseur_defaut_id_145 , t0 . condition_achat_defaut_id AS condition_achat_defaut_id_146 , t0 . article_enconsigne_id AS article_enconsigne_id_147 , t0 . parent_id AS parent_id_148 , t0 . article_declinaison_parent_id AS article_declinaison_parent_id_149 , t0 . transporteur_id AS transporteur_id_150 , t0 . transporteur2_id AS transporteur2_id_151 FROM article__article t0 WHERE t0 . id = 2674 AND ((t0 . date_supression IS NULL )); Copy
10
0.18 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 = 2674 AND t0 . affichage_web = 1 ORDER BY t0 . position ASC LIMIT 1 ; Copy
11
0.13 ms
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . date AS date_3 , t0 . dateSuppression AS dateSuppression_4 , t0 . dateMaj AS dateMaj_5 , t0 . taux_defaut AS taux_defaut_6 , t0 . ordre AS ordre_7 , t0 . utilisateur_id AS utilisateur_id_8 FROM taxte__regle_taxe t0 WHERE t0 . id = ? AND ((t0 . dateSuppression IS NULL ))
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . date AS date_3 , t0 . dateSuppression AS dateSuppression_4 , t0 . dateMaj AS dateMaj_5 , t0 . taux_defaut AS taux_defaut_6 , t0 . ordre AS ordre_7 , t0 . utilisateur_id AS utilisateur_id_8 FROM taxte__regle_taxe t0 WHERE t0 . id = 1 AND ((t0 . dateSuppression IS NULL )); Copy