Query Metrics
17
Database Queries
17
Different statements
7.53 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.49 ms (19.83%) |
1 |
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) )
Parameters:
[] |
|
1.31 ms (17.43%) |
1 |
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 ] |
|
0.66 ms (8.83%) |
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.id = ? AND ((t0.dateSuppression IS NULL))
Parameters:
[
"171"
]
|
|
0.62 ms (8.22%) |
1 |
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))
Parameters:
[
2665
]
|
|
0.57 ms (7.58%) |
1 |
SELECT t0.id AS id_1, t0.seller_product_id AS seller_product_id_2, t0.libelle AS libelle_3, t0.libelle_secondaire AS libelle_secondaire_4, t0.numero_serie AS numero_serie_5, t0.commentaire AS commentaire_6, t0.commentaire_prive AS commentaire_prive_7, t0.commentaire_suppl AS commentaire_suppl_8, t0.date AS date_9, t0.date_supression AS date_supression_10, t0.date_maj AS date_maj_11, t0.date_maj_prix AS date_maj_prix_12, t0.date_priorisation AS date_priorisation_13, t0.reference AS reference_14, t0.reference_client AS reference_client_15, t0.reference_fournisseur AS reference_fournisseur_16, t0.prix_base AS prix_base_17, t0.prix_unitaire_ttc AS prix_unitaire_ttc_18, t0.description AS description_19, t0.description_courte AS description_courte_20, t0.largeur AS largeur_21, t0.profondeur AS profondeur_22, t0.hauteur AS hauteur_23, t0.poids AS poids_24, t0.a_consigner AS a_consigner_25, t0.forcer AS forcer_26, t0.bloquer AS bloquer_27, t0.consigne AS consigne_28, t0.tva_achat AS tva_achat_29, t0.tva_vente AS tva_vente_30, t0.quantite AS quantite_31, t0.coefficient_conditionnement AS coefficient_conditionnement_32, t0.quantite_dispo AS quantite_dispo_33, t0.quantite_deja_preparee_simplifie AS quantite_deja_preparee_simplifie_34, t0.quantite_deja_preparee AS quantite_deja_preparee_35, t0.maj_quantite_deja_preparee AS maj_quantite_deja_preparee_36, t0.ral_client AS ral_client_37, t0.ral AS ral_38, t0.rar AS rar_39, t0.quantite_reprise AS quantite_reprise_40, t0.remise AS remise_41, t0.remise_supplementaire AS remise_supplementaire_42, t0.position AS position_43, t0.total_ht AS total_ht_44, t0.total_with_tax AS total_with_tax_45, t0.tva AS tva_46, t0.pump AS pump_47, t0.cump AS cump_48, t0.etiquettes AS etiquettes_49, t0.generer_fabriquer AS generer_fabriquer_50, t0.maj_condition_achat AS maj_condition_achat_51, t0.checked AS checked_52, t0.frais_annexes AS frais_annexes_53, t0.frais_port AS frais_port_54, t0.reste_a_reprendre AS reste_a_reprendre_55, t0.date_livraison_theorique AS date_livraison_theorique_56, t0.date_expedition_theorique AS date_expedition_theorique_57, t0.ecocontribution AS ecocontribution_58, t0.id_import AS id_import_59, t0.commision_montant AS commision_montant_60, t0.commision_taux_tva AS commision_taux_tva_61, t0.commision_tva AS commision_tva_62, t0.remboursement_montant AS remboursement_montant_63, t0.remboursement_commision_montant_ht AS remboursement_commision_montant_ht_64, t0.remboursement_commision_tva AS remboursement_commision_tva_65, t0.date_approximative_reception AS date_approximative_reception_66, t0.prix_achat_unitaire_avec_frais AS prix_achat_unitaire_avec_frais_67, t0.ajouter_frais_prix_achat AS ajouter_frais_prix_achat_68, t0.total_ttc_devise AS total_ttc_devise_69, t0.taux_change AS taux_change_70, t0.fabrication_etiquette AS fabrication_etiquette_71, t0.prix_avec_remise AS prix_avec_remise_72, t0.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
Parameters:
[
171
]
|
|
0.36 ms (4.75%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.35 ms (4.68%) |
1 |
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))
Parameters:
[
1
]
|
|
0.32 ms (4.31%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.30 ms (3.98%) |
1 |
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 = ?
Parameters:
[
3
]
|
|
0.25 ms (3.28%) |
1 |
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 ] |
|
0.22 ms (2.91%) |
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 = ? AND t0.affichage_web = ? ORDER BY t0.position ASC LIMIT 1
Parameters:
[ 2665 1 ] |
|
0.22 ms (2.88%) |
1 |
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))
Parameters:
[
4
]
|
|
0.19 ms (2.56%) |
1 |
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))
Parameters:
[
186
]
|
|
0.18 ms (2.34%) |
1 |
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))
Parameters:
[
1
]
|
|
0.17 ms (2.21%) |
1 |
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 = ?
Parameters:
[
1
]
|
|
0.16 ms (2.18%) |
1 |
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 = ?
Parameters:
[
2665
]
|
|
0.15 ms (2.04%) |
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 = ?
Parameters:
[
2665
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.