Query Metrics
6
Database Queries
6
Different statements
2.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.04 ms (0.00%) |
1 |
SELECT DISTINCT p0_.id AS id_0, p0_.code_article AS code_article_1, p0_.code_produit AS code_produit_2, p0_.designation AS designation_3, p0_.descriptif AS descriptif_4, p0_.caracteristique AS caracteristique_5, p0_.reference_reach AS reference_reach_6, p0_.num_cas AS num_cas_7, p0_.formule_chimique_brute AS formule_chimique_brute_8, p0_.formule_chimique_developpee AS formule_chimique_developpee_9, p0_.certificat_analyse AS certificat_analyse_10, p0_.classe_transport AS classe_transport_11, p0_.ft AS ft_12, p0_.fds AS fds_13, p0_.densite AS densite_14, p0_.quantite_stock_lyon AS quantite_stock_lyon_15, p0_.quantite_stock_bordeaux AS quantite_stock_bordeaux_16, p0_.unite_vente AS unite_vente_17, p0_.information_technique AS information_technique_18, p0_.fiche_technique_fabricant AS fiche_technique_fabricant_19, p0_.image AS image_20, p0_.date_ajout AS date_ajout_21, p0_.date_modification AS date_modification_22, p0_.ordre AS ordre_23, p0_.is_actif AS is_actif_24, p0_.is_multilabo AS is_multilabo_25, p0_.is_chimique AS is_chimique_26, p0_.recherche_synonyme AS recherche_synonyme_27, p0_.is_recherche_selection_revol AS is_recherche_selection_revol_28, p0_.code_article_pivot AS code_article_pivot_29, p0_.code_onu AS code_onu_30, p0_.groupe_emballage AS groupe_emballage_31, p0_.temperature_transport AS temperature_transport_32, p0_.code_nacres AS code_nacres_33, p0_.quantite_limitee AS quantite_limitee_34, p0_.nom_declaration AS nom_declaration_35, p0_.purete AS purete_36, p0_.article_type AS article_type_37, p0_.code_fournisseur_article_pivot AS code_fournisseur_article_pivot_38, p0_.code_produit_pivot AS code_produit_pivot_39, p0_.prix_achat_ht_final_code_produit AS prix_achat_ht_final_code_produit_40, p0_.poids AS poids_41, p0_.coefficient AS coefficient_42, p0_.date_limite_valid_prix AS date_limite_valid_prix_43, p0_.eccn AS eccn_44, p0_.temperature_de_stockage AS temperature_de_stockage_45, p0_.point_eclair AS point_eclair_46, p0_.echa AS echa_47, p0_.contenant AS contenant_48, p0_.alcool_pourcentage AS alcool_pourcentage_49, p0_.code_article_remplacement AS code_article_remplacement_50, p0_.frais_port AS frais_port_51, p0_.frais_mini_commande AS frais_mini_commande_52, p0_.frais_gestion AS frais_gestion_53, p0_.groupe_drogue AS groupe_drogue_54, p0_.precurseur_drogue AS precurseur_drogue_55, p0_.ancien_code_article AS ancien_code_article_56, p0_.code_article_remplacement2 AS code_article_remplacement2_57, p0_.code_article_remplacement3 AS code_article_remplacement3_58, p0_.cee_code_pays AS cee_code_pays_59, p0_.cee_code_produit AS cee_code_produit_60, p0_.date_modification_manuelle_prix_vente_article AS date_modification_manuelle_prix_vente_article_61, p0_.date_modification_manuelle_prix_achat AS date_modification_manuelle_prix_achat_62, p0_.date_reactualisation_import_prix_vente_article AS date_reactualisation_import_prix_vente_article_63, p0_.date_reactualisation_import_prix_achat AS date_reactualisation_import_prix_achat_64, p0_.prix_public_ht_produit AS prix_public_ht_produit_65, p0_.remise_prix_public_ht_produit AS remise_prix_public_ht_produit_66, p0_.prix_achat_net_ht_code_produit AS prix_achat_net_ht_code_produit_67, p0_.prix_vente_unitaire_ht_code_article AS prix_vente_unitaire_ht_code_article_68, p0_.prix_vente_ht_final_code_article AS prix_vente_ht_final_code_article_69, p0_.code_produit_derniere_maj AS code_produit_derniere_maj_70, p0_.composant_nomenclature AS composant_nomenclature_71, p0_.quantite_composant_nomenclature AS quantite_composant_nomenclature_72, p0_.sous_famille AS sous_famille_73, p0_.categorie AS categorie_74, p0_.classe AS classe_75, p0_.nature AS nature_76, p0_.collection AS collection_77, p0_.is_stock_visible_front_office AS is_stock_visible_front_office_78, p0_.quantite_stock_paris AS quantite_stock_paris_79, p0_.ancien_code_produit AS ancien_code_produit_80, p0_.code_article_fabricant AS code_article_fabricant_81, p0_.is_article_specifique_creation AS is_article_specifique_creation_82, p0_.is_mail_fournisseur_acreer_sent AS is_mail_fournisseur_acreer_sent_83, p0_.is_delete AS is_delete_84, p0_.prix_public_conseille AS prix_public_conseille_85, p0_.explication_ppp AS explication_ppp_86, p0_.commentaire_interne AS commentaire_interne_87, p0_.is_marqueur_erp_bdx AS is_marqueur_erp_bdx_88, p0_.is_marqueur_erp_lyon AS is_marqueur_erp_lyon_89, p0_.num_contrat_fournisseur_adl AS num_contrat_fournisseur_adl_90, p0_.num_contrat_fournisseur_revol AS num_contrat_fournisseur_revol_91, p0_.prix_achat_devis_adl AS prix_achat_devis_adl_92, p0_.prix_achat_devis_revol AS prix_achat_devis_revol_93, p0_.date_fin_validite_devis_fournisseur_adl AS date_fin_validite_devis_fournisseur_adl_94, p0_.date_fin_validite_devis_fournisseur_revol AS date_fin_validite_devis_fournisseur_revol_95, p0_.date_modification_prix_achat_devis AS date_modification_prix_achat_devis_96, p0_.precedent_prix_achat_net_ht AS precedent_prix_achat_net_ht_97, p0_.precedent_prix_vente_net_ht AS precedent_prix_vente_net_ht_98, p0_.unspsc AS unspsc_99, p0_.date_mise_en_inactif AS date_mise_en_inactif_100, p0_.is_fragile AS is_fragile_101, p0_.is_exportable_allsciences AS is_exportable_allsciences_102, p0_.attributs AS attributs_103, p0_.delai_livraison_semaine AS delai_livraison_semaine_104, p1_.id AS id_105, p1_.suffixe_reference AS suffixe_reference_106, p1_.lot_quantite AS lot_quantite_107, p1_.lot_prix_ht AS lot_prix_ht_108, p1_.lot_pourcentage_remise AS lot_pourcentage_remise_109, p1_.is_actif AS is_actif_110, p1_.is_delete AS is_delete_111, u2_.id AS id_112, p3_.id AS id_113, p3_.image AS image_114, p3_.ordre AS ordre_115, p3_.date_modification AS date_modification_116, p4_.id AS id_117, p4_.designation AS designation_118, p0_.taux_tva_id AS taux_tva_id_119, p0_.site_id AS site_id_120, p0_.fournisseur_id AS fournisseur_id_121, p0_.qualite_produit_chimique_id AS qualite_produit_chimique_id_122, p0_.famille_id AS famille_id_123, p0_.article_pivot_id AS article_pivot_id_124, p0_.famille_produit_id AS famille_produit_id_125, p0_.conditionnement_id AS conditionnement_id_126, p0_.marque_id AS marque_id_127, p0_.createur_id AS createur_id_128, p1_.produit_id AS produit_id_129, u2_.utilisateur_id AS utilisateur_id_130, u2_.produit_id AS produit_id_131, u2_.famille_favori_id AS famille_favori_id_132, p3_.produit_id AS produit_id_133, p4_.produit_id AS produit_id_134, p4_.pays_id AS pays_id_135 FROM produit p0_ LEFT JOIN famille_article f5_ ON p0_.famille_id = f5_.id LEFT JOIN fournisseur f6_ ON p0_.fournisseur_id = f6_.id LEFT JOIN produit_lot p1_ ON p0_.id = p1_.produit_id LEFT JOIN utilisateur_produit u2_ ON p0_.id = u2_.produit_id LEFT JOIN produit_image p3_ ON p0_.id = p3_.produit_id LEFT JOIN categorisation_article_valeur c7_ ON p0_.conditionnement_id = c7_.id LEFT JOIN marque m8_ ON p0_.marque_id = m8_.id LEFT JOIN produit_designation_langue p4_ ON p0_.id = p4_.produit_id WHERE p0_.is_exportable_allsciences = 1 AND f5_.is_actif = 1 AND p0_.is_actif = 1 AND f6_.is_actif = 1 AND p0_.id IN (?) ORDER BY FIELD(p0_.id, 2919) ASC
Parameters:
[
[
2919
]
]
|
|
0.27 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.taux AS taux_3, t0.is_actif AS is_actif_4 FROM taux_tva t0 WHERE t0.id = ?
Parameters:
[
5
]
|
|
0.22 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code_fournisseur AS code_fournisseur_3, t0.pourcentage_remise AS pourcentage_remise_4, t0.is_fabriquant AS is_fabriquant_5, t0.is_marque AS is_marque_6, t0.is_actif AS is_actif_7, t0.is_catalogue AS is_catalogue_8, t0.reference_catalogue AS reference_catalogue_9, t0.fichier AS fichier_10, t0.image AS image_11, t0.ordre AS ordre_12, t0.date_modification AS date_modification_13, t0.is_visible_catalogue_fournisseur AS is_visible_catalogue_fournisseur_14, t0.contenu_html AS contenu_html_15, t0.adresse AS adresse_16, t0.complement_adresse AS complement_adresse_17, t0.code_postal AS code_postal_18, t0.ville AS ville_19, t0.telephone AS telephone_20, t0.mail AS mail_21, t0.frais_port AS frais_port_22, t0.minimum_commande_fournisseur AS minimum_commande_fournisseur_23, t0.has_produit_recherche_revol AS has_produit_recherche_revol_24, t0.pays_id AS pays_id_25 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
12
]
|
|
0.18 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.quantite AS quantite_3, t0.valeur AS valeur_4, t0.categorisation_id AS categorisation_id_5, t6.id AS id_7, t6.libelle AS libelle_8 FROM categorisation_article_valeur t0 LEFT JOIN categorisation_article t6 ON t0.categorisation_id = t6.id WHERE t0.id = ?
Parameters:
[
522
]
|
|
0.17 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM famille_erp t0 WHERE t0.id = ?
Parameters:
[
6
]
|
|
0.16 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.contenu_html AS contenu_html_3, t0.image AS image_4, t0.fichier_pdf AS fichier_pdf_5, t0.fichier_html AS fichier_html_6, t0.is_actif AS is_actif_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.date_modification AS date_modification_11, t0.icone AS icone_12, t0.is_stock_visible_fo AS is_stock_visible_fo_13, t0.icone_rose AS icone_rose_14, t0.parent_id AS parent_id_15, t0.famille_erp_id AS famille_erp_id_16 FROM famille_article t0 WHERE t0.id = ?
Parameters:
[
146
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Famille | No errors. |
| App\Entity\FamilleEvenement | No errors. |
| App\Entity\Produit | No errors. |
| App\Entity\ProduitSpecifique | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\Utilisateur | No errors. |
| App\Entity\Fournisseur | No errors. |
| App\Entity\ProduitLot | No errors. |
| App\Entity\UtilisateurProduit | No errors. |
| App\Entity\ProduitImage | No errors. |
| App\Entity\CategorisationArticleValeur | No errors. |
| App\Entity\Marque | No errors. |
| App\Entity\ProduitDesignationLangue | No errors. |
| App\Entity\TauxTva | No errors. |
| App\Entity\Site | No errors. |
| App\Entity\QualiteProduitChimique | No errors. |
| App\Entity\FamilleProduit | No errors. |
| App\Entity\UtilisateurBack | No errors. |
| App\Entity\FamilleFavoris | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\ProduitDocumentInterne | No errors. |
| App\Entity\ProduitDocumentExterne | No errors. |
| App\Entity\EvenementProduit | No errors. |
| App\Entity\InformationDeclarative | No errors. |
| App\Entity\DevisDemandeAchatProduit | No errors. |
| App\Entity\ClientRemiseProduit | No errors. |
| App\Entity\ProduitAssociation | No errors. |
| App\Entity\CorrespondanceProduit | No errors. |
| App\ApiResource\Entity\EvenementAllScience | No errors. |
| App\Entity\LogoFournisseur | No errors. |
| App\Entity\ClientRemiseFournisseur | No errors. |
| App\Entity\ClientFournisseurExclu | No errors. |
| App\Entity\ImportProduit | No errors. |
| App\Entity\CorrespondanceFournisseurs | No errors. |
| App\Entity\FamilleErp | No errors. |
| App\Entity\ClientCatalogueExclu | No errors. |
| App\Entity\ClientRemiseFamille | No errors. |
| App\Entity\CategorisationArticle | No errors. |
| App\Entity\DevisDemandeAchat | No errors. |
| App\Entity\Actualite | No errors. |
| App\Entity\ClientEvenement | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\ClientProfilEvenement | No errors. |
| App\Entity\OffresProchilab | No errors. |
| App\Entity\ClientAdresse | No errors. |
| App\Entity\ConfigurationGenerale | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\ContenuSpecifique | No errors. |