https://www.blackstarsco.fr/bscm/admin/gestion/lettre_d_intension_d_achat/new

Query Metrics

14 Database Queries
14 Different statements
3.73 ms Query time
9 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.89 ms
(23.86%)
1
SELECT s0_.id AS id_0, s0_.produit_en_gestion AS produit_en_gestion_1, s0_.numero AS numero_2, s0_.hscode AS hscode_3, s0_.donneur_d_ordre AS donneur_d_ordre_4, s0_.stock AS stock_5, s0_.tc AS tc_6, s0_.nom_scientifique AS nom_scientifique_7, s0_.origine AS origine_8, s0_.certification AS certification_9, s0_.idea_scoring AS idea_scoring_10, s0_.prod_annuelle AS prod_annuelle_11, s0_.crit_org AS crit_org_12, s0_.crit_ph AS crit_ph_13, s0_.crit_mic AS crit_mic_14, s0_.concervation AS concervation_15, s0_.domaine_d_utilisation AS domaine_d_utilisation_16, s0_.type_marq_ut AS type_marq_ut_17, s0_.type_marq_colis AS type_marq_colis_18, s0_.localisation_ut AS localisation_ut_19, s0_.localisation_colis AS localisation_colis_20, s0_.signification_marq_ut AS signification_marq_ut_21, s0_.signification_marq_colis AS signification_marq_colis_22, s0_.presentation AS presentation_23, s0_.nature_emballage AS nature_emballage_24, s0_.dimenssion AS dimenssion_25, s0_.poids_emballage AS poids_emballage_26, s0_.poids_fixe_ou_variable AS poids_fixe_ou_variable_27, s0_.poids_net AS poids_net_28, s0_.sous_emballage1 AS sous_emballage1_29, s0_.sous_emballage2 AS sous_emballage2_30, s0_.sous_emballage3 AS sous_emballage3_31, s0_.sous_emballage4 AS sous_emballage4_32, s0_.sous_emballage5 AS sous_emballage5_33, s0_.sous_emballage6 AS sous_emballage6_34, s0_.nombre_de_colis_par_couche AS nombre_de_colis_par_couche_35, s0_.nombre_de_couche_par_palette AS nombre_de_couche_par_palette_36, s0_.nombre_de_colis_par_palette AS nombre_de_colis_par_palette_37, s0_.nombre_d_unite_par_palette AS nombre_d_unite_par_palette_38, s0_.dimension_palette AS dimension_palette_39, s0_.poids_net_palette AS poids_net_palette_40, s0_.created_at AS created_at_41, s0_.px_spot AS px_spot_42, s0_.unite4 AS unite4_43, s0_.vol_disp AS vol_disp_44, s0_.qt_min AS qt_min_45, s0_.mandat_id AS mandat_id_46, s0_.filiere_id AS filiere_id_47, s0_.qualite_id AS qualite_id_48, s0_.qt_min_unite_id AS qt_min_unite_id_49, s0_.unite2_id AS unite2_id_50, s0_.unite1_id AS unite1_id_51, s0_.niveau_id AS niveau_id_52, s0_.unite3_id AS unite3_id_53, s0_.status_id AS status_id_54, s0_.stade_id AS stade_id_55 FROM sous_jacent s0_
Parameters:
[]
0.45 ms
(12.01%)
1
SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.code AS code_2, a0_.raison AS raison_3, a0_.identifiant AS identifiant_4, a0_.adresse AS adresse_5, a0_.cp AS cp_6, a0_.tel AS tel_7, a0_.email AS email_8, a0_.dirigeant AS dirigeant_9, a0_.fonction AS fonction_10, a0_.produit AS produit_11, a0_.capacite AS capacite_12, a0_.prix_fob AS prix_fob_13, a0_.ut AS ut_14, a0_.certification AS certification_15, a0_.mode_reglement AS mode_reglement_16, a0_.banque AS banque_17, a0_.banque_adresse AS banque_adresse_18, a0_.code_swift AS code_swift_19, a0_.iban AS iban_20, a0_.num_compte AS num_compte_21, a0_.titulaire_compte AS titulaire_compte_22, a0_.gestionnaire_compte AS gestionnaire_compte_23, a0_.date_d AS date_d_24, a0_.tc AS tc_25, a0_.numero AS numero_26, a0_.pays AS pays_27, a0_.ville AS ville_28, a0_.website AS website_29, a0_.produit1 AS produit1_30, a0_.produit2 AS produit2_31, a0_.produit3 AS produit3_32, a0_.capacite1 AS capacite1_33, a0_.capacite2 AS capacite2_34, a0_.capacite3 AS capacite3_35, a0_.evaluation AS evaluation_36, a0_.prix_fob1 AS prix_fob1_37, a0_.prix_fob2 AS prix_fob2_38, a0_.prix_fob3 AS prix_fob3_39, a0_.certification1 AS certification1_40, a0_.certification2 AS certification2_41, a0_.certification3 AS certification3_42, a0_.gestionnaire_email AS gestionnaire_email_43, a0_.ut1 AS ut1_44, a0_.ut2 AS ut2_45, a0_.ut3 AS ut3_46, a0_.created_at AS created_at_47, a0_.envoi_echantillon AS envoi_echantillon_48, a0_.autres AS autres_49, a0_.activite AS activite_50, a0_.couriel AS couriel_51, a0_.port AS port_52, a0_.description AS description_53, a0_.referent AS referent_54, a0_.origine_dest AS origine_dest_55, a0_.spot_target AS spot_target_56, a0_.quantite_contactuelle AS quantite_contactuelle_57, a0_.lead_id AS lead_id_58, a0_.suivi_par_id AS suivi_par_id_59, a0_.devise_id AS devise_id_60, a0_.unite_id AS unite_id_61, a0_.sous_jacent_id AS sous_jacent_id_62, a0_.filiere_id AS filiere_id_63, a0_.sous_jacent1_id AS sous_jacent1_id_64, a0_.sous_jacent2_id AS sous_jacent2_id_65, a0_.niveau_id AS niveau_id_66, a0_.status_id AS status_id_67, a0_.base_id AS base_id_68, a0_.filiere1_id AS filiere1_id_69, a0_.filiere2_id AS filiere2_id_70, a0_.filiere3_id AS filiere3_id_71, a0_.duree_id AS duree_id_72, a0_.position_id AS position_id_73, a0_.nature_contrat_id AS nature_contrat_id_74 FROM admin_donneur_ordre a0_ INNER JOIN position p1_ ON a0_.position_id = p1_.id WHERE p1_.name = ?
Parameters:
[
  "Vendeur"
]
0.39 ms
(10.32%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.niveau AS niveau_4, t0.name AS name_5, t0.matricule AS matricule_6, t0.roles AS roles_7, t0.email_pro AS email_pro_8, t0.fonction AS fonction_9, t0.entry_at AS entry_at_10, t0.prenoms AS prenoms_11, t0.date_sortie AS date_sortie_12, t0.status_id AS status_id_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
  17
]
0.38 ms
(10.21%)
1
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.created_at AS created_at_3 FROM emballage e0_
Parameters:
[]
0.29 ms
(7.88%)
1
SELECT u0_.id AS id_0, u0_.nom AS nom_1, u0_.description AS description_2 FROM unite u0_
Parameters:
[]
0.26 ms
(7.08%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.created_at AS created_at_3 FROM conditionnement c0_
Parameters:
[]
0.26 ms
(6.97%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.description AS description_3 FROM payment_method p0_
Parameters:
[]
0.26 ms
(6.89%)
1
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2 FROM devise d0_
Parameters:
[]
0.18 ms
(4.93%)
1
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.niveau AS niveau_3, u0_.name AS name_4, u0_.matricule AS matricule_5, u0_.roles AS roles_6, u0_.email_pro AS email_pro_7, u0_.fonction AS fonction_8, u0_.entry_at AS entry_at_9, u0_.prenoms AS prenoms_10, u0_.date_sortie AS date_sortie_11, u0_.status_id AS status_id_12 FROM user u0_
Parameters:
[]
0.08 ms
(2.25%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.formulaire AS formulaire_2, s0_.description AS description_3 FROM status s0_ WHERE LOWER(s0_.formulaire) LIKE ?
Parameters:
[
  "%intention%achat%"
]
0.08 ms
(2.09%)
1
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.created_at AS created_at_3 FROM exigence e0_
Parameters:
[]
0.07 ms
(1.99%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2 FROM products p0_
Parameters:
[]
0.07 ms
(1.82%)
1
SELECT n0_.id AS id_0, n0_.niveau AS niveau_1, n0_.created_at AS created_at_2, n0_.description AS description_3 FROM niveau n0_
Parameters:
[]
0.06 ms
(1.69%)
1
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.niveau AS niveau_3, u0_.name AS name_4, u0_.matricule AS matricule_5, u0_.roles AS roles_6, u0_.email_pro AS email_pro_7, u0_.fonction AS fonction_8, u0_.entry_at AS entry_at_9, u0_.prenoms AS prenoms_10, u0_.date_sortie AS date_sortie_11, u0_.status_id AS status_id_12 FROM user u0_ INNER JOIN user_status u1_ ON u0_.status_id = u1_.id WHERE u1_.name = ?
Parameters:
[
  "Autorisé"
]

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\User
  • The mappings App\Entity\User#suivipars and App\Entity\LetterOfIntentToPurchase#suivipar are inconsistent with each other.
App\Entity\UserStatus No errors.
App\Entity\PlaceDeMarche No errors.
App\Entity\TraitementDsDemdDachat No errors.
App\Entity\AdminDonneurOrdre
  • The mappings App\Entity\AdminDonneurOrdre#mandats and App\Entity\SousJacent#mandat are inconsistent with each other.
  • The mappings App\Entity\AdminDonneurOrdre#qmandats and App\Entity\Quotation#mandat are inconsistent with each other.
  • The mappings App\Entity\AdminDonneurOrdre#recipient and App\Entity\LetterOfIntentToPurchase#recipient are inconsistent with each other.
App\Entity\LeveeDeFond No errors.
App\Entity\LetterOfIntentToPurchase
  • The association App\Entity\LetterOfIntentToPurchase#recipient refers to the inverse side field App\Entity\AdminDonneurOrdre#letterOfIntentToPurchases which does not exist.
  • The mappings App\Entity\LetterOfIntentToPurchase#suivipar and App\Entity\User#letterOfIntentToPurchases are inconsistent with each other.
  • The mappings App\Entity\LetterOfIntentToPurchase#paiement_mode and App\Entity\PaymentMethod#letterOfIntentToPurchases are inconsistent with each other.
App\Entity\Document No errors.
App\Entity\DemandeDeCotation No errors.
App\Entity\Prospect No errors.
App\Entity\RequeteDeFinancement No errors.
App\Entity\Visiteur No errors.
App\Entity\Abonne No errors.
App\Entity\Position No errors.
App\Entity\Devise No errors.
App\Entity\Unite No errors.
App\Entity\SousJacent
  • The association App\Entity\SousJacent#mandat refers to the inverse side field App\Entity\AdminDonneurOrdre#sousJacents which does not exist.
  • The mappings App\Entity\SousJacent#stade and App\Entity\Stade#sousJacents are inconsistent with each other.
App\Entity\Products No errors.
App\Entity\Niveau No errors.
App\Entity\Status No errors.
App\Entity\Incoterm
  • The mappings App\Entity\Incoterm#quotaions and App\Entity\Quotation#incoterm are inconsistent with each other.
App\Entity\Duree No errors.
App\Entity\NatureContrat No errors.
App\Entity\OperationDeCourtage No errors.
App\Entity\Appariement
  • The mappings App\Entity\Appariement#spot_devise and App\Entity\Devise#appariements are inconsistent with each other.
App\Entity\Quotation
  • The association App\Entity\Quotation#incoterm refers to the inverse side field App\Entity\Incoterm#quotations which does not exist.
  • The association App\Entity\Quotation#mandat refers to the inverse side field App\Entity\AdminDonneurOrdre#quotations which does not exist.
App\Entity\Transaction
  • The association App\Entity\Transaction#total_unite refers to the inverse side field App\Entity\Devise#transactions which does not exist.
App\Entity\Operation No errors.
App\Entity\FraisDeCourtage No errors.
App\Entity\Emballage No errors.
App\Entity\Conditionnement No errors.
App\Entity\PaymentMethod No errors.
App\Entity\Exigence No errors.
App\Entity\Qualite No errors.
App\Entity\Stade
  • The association App\Entity\Stade#sousJacents refers to the owning side field App\Entity\SousJacent#statde which does not exist.
App\Entity\AppelDeMarge No errors.
App\Entity\MatPremiere No errors.