https://blackstarsco.fr/demande-de-cotation

Query Metrics

2 Database Queries
2 Different statements
8.51 ms Query time
7 Invalid entities

Queries

Group similar statements

# Time Info
1 7.80 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2 FROM products p0_
Parameters:
[]
2 0.72 ms
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:
[]

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\Products 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\MatPremiere 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\Transaction
  • The association App\Entity\Transaction#total_unite refers to the inverse side field App\Entity\Devise#transactions which does not exist.
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\AppelDeMarge No errors.
App\Entity\Operation No errors.
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\TraitementDsDemdDachat No errors.
App\Entity\DemandeDeCotation No errors.
App\Entity\Prospect No errors.
App\Entity\Qualite No errors.
App\Entity\Unite No errors.
App\Entity\Devise No errors.
App\Entity\Niveau No errors.
App\Entity\Status 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\Appariement
  • The mappings App\Entity\Appariement#spot_devise and App\Entity\Devise#appariements are inconsistent with each other.