Query Metrics
20
Database Queries
9
Different statements
6.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.16 ms (33.54%) |
6 |
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))
Parameters:
[
3112
]
|
|
0.90 ms (13.98%) |
6 |
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:
[ 3112 1 ] |
|
0.80 ms (12.38%) |
1 |
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" => "1270" "limit" => 6 ] |
|
0.76 ms (11.73%) |
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
Parameters:
[
14
]
|
|
0.56 ms (8.74%) |
1 |
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))
Parameters:
[
1
]
|
|
0.43 ms (6.64%) |
2 |
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-11 17:41:53" "2026-05-11 17:41:53" ] |
|
0.42 ms (6.53%) |
1 |
SELECT t0.id AS id_1, t0.document_commercial_id AS document_commercial_id_2, t0.ordre AS ordre_3, t0.libelle AS libelle_4, t0.date AS date_5, t0.dateMaj AS dateMaj_6, t0.dateSuppression AS dateSuppression_7, t0.action_statut_commande_id AS action_statut_commande_id_8, t0.utilisateur_id AS utilisateur_id_9 FROM commerciale__statut_commande t0 WHERE t0.document_commercial_id = ? AND t0.ordre = ? AND ((t0.dateSuppression IS NULL)) LIMIT 1
Parameters:
[ 14 "1" ] |
|
0.29 ms (4.50%) |
1 |
SELECT t0.id AS id_1, t0.signature_mail AS signature_mail_2, t0.texte_facture AS texte_facture_3, t0.logo AS logo_4, t0.afficher_donnees_import AS afficher_donnees_import_5, t0.date AS date_6, t0.en_inventaire AS en_inventaire_7, t0.date_debut_inventaire AS date_debut_inventaire_8, t0.date_fin_inventaire AS date_fin_inventaire_9, t0.date_maj AS date_maj_10, t0.libelle AS libelle_11, t0.capital AS capital_12, t0.rcs AS rcs_13, t0.numTva AS numTva_14, t0.adresse AS adresse_15, t0.adresse_complementaire AS adresse_complementaire_16, t0.code_postal AS code_postal_17, t0.ville AS ville_18, t0.pays AS pays_19, t0.telephone AS telephone_20, t0.fax AS fax_21, t0.siteWeb AS siteWeb_22, t0.siret AS siret_23, t0.ape AS ape_24, t0.email AS email_25, t0.emailTest AS emailTest_26, t0.mailTest AS mailTest_27, t0.dateDebutExercice AS dateDebutExercice_28, t0.dateFinExercice AS dateFinExercice_29, t0.note_service AS note_service_30, t0.mailer_user AS mailer_user_31, t0.mailer_password AS mailer_password_32, t0.mailer_host AS mailer_host_33, t0.mailer_port AS mailer_port_34, t0.bandeau_email AS bandeau_email_35, t0.date_debut_texte_bandeau AS date_debut_texte_bandeau_36, t0.date_fin_texte_bandeau AS date_fin_texte_bandeau_37, t0.statut_texte_bandeau AS statut_texte_bandeau_38, t0.utilisateur_id AS utilisateur_id_39, t0.famille_compta_frais_fixe_id AS famille_compta_frais_fixe_id_40, t0.famille_compta_frais_port_id AS famille_compta_frais_port_id_41, t0.famille_compta_frais_annexes_id AS famille_compta_frais_annexes_id_42 FROM societe__societe t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.13 ms (1.97%) |
1 |
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))
Parameters:
[
1
]
|
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.