GET https://www.app-test.fr/commande/70/edit

Query Metrics

9 Database Queries
7 Different statements
15.31 ms Query time
3 Invalid entities
5189 Managed entities

Queries

Group similar statements

# Time Info
1 0.79 ms
SELECT t0.id AS id_1, t0.num_commande AS num_commande_2, t0.date AS date_3, t0.dateliv AS dateliv_4, t0.is_recu AS is_recu_5, t0.pdf_path AS pdf_path_6, t0.motif AS motif_7, t0.nom_fournisseur AS nom_fournisseur_8, t0.is_archive AS is_archive_9, t0.fournisseurs_id AS fournisseurs_id_10 FROM commande t0 WHERE t0.id = ?
Parameters:
[
  "70"
]
2 0.88 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = ?
Parameters:
[
  88
]
3 0.83 ms
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.ht AS ht_3, t0.quantite_recu AS quantite_recu_4, t0.date AS date_5, t0.composants_id AS composants_id_6, t0.commande_id AS commande_id_7 FROM qt_commande t0 WHERE t0.commande_id = ?
Parameters:
[
  70
]
4 0.90 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0 WHERE t0.id = ?
Parameters:
[
  205
]
5 0.74 ms
SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.contact AS contact_2, f0_.email AS email_3, f0_.telephone AS telephone_4, f0_.adresse AS adresse_5, f0_.ville AS ville_6, f0_.code_postal AS code_postal_7, f0_.pays AS pays_8, f0_.site_web AS site_web_9, f0_.ref_fournisseur AS ref_fournisseur_10 FROM fournisseur f0_ ORDER BY f0_.nom ASC
Parameters:
[]
6 1.53 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.ean13 AS ean13_2, c0_.quantite AS quantite_3, c0_.alerte AS alerte_4, c0_.categorie AS categorie_5, c0_.nomenclature AS nomenclature_6, c0_.ht AS ht_7, c0_.taxe AS taxe_8, c0_.dlc AS dlc_9, c0_.is_france AS is_france_10, c0_.qt_tempo AS qt_tempo_11, c0_.qt_site AS qt_site_12, c0_.qt_appro AS qt_appro_13, c0_.is_bouquet AS is_bouquet_14, c0_.qr_code_path AS qr_code_path_15, c0_.reffj AS reffj_16, c0_.is_surveillance AS is_surveillance_17, c0_.is_active_produit AS is_active_produit_18, c0_.is_coupure_produit AS is_coupure_produit_19, c0_.is_in_active_produit AS is_in_active_produit_20, c0_.date_debut AS date_debut_21, c0_.date_fin AS date_fin_22, c0_.fournisseurs_id AS fournisseurs_id_23, c0_.qt_id AS qt_id_24, c0_.commande_id AS commande_id_25, c0_.association_id AS association_id_26 FROM composant c0_
Parameters:
[]
7 4.81 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14, t0.is_relivraison AS is_relivraison_15 FROM mouvement_web t0
Parameters:
[]
8 2.75 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14, t0.is_relivraison AS is_relivraison_15 FROM mouvement_web t0
Parameters:
[]
9 2.08 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14, t0.is_relivraison AS is_relivraison_15 FROM mouvement_web t0
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MouvementWeb 4826
App\Entity\Composant 306
App\Entity\Fournisseur 55
App\Entity\Commande 1
App\Entity\QtCommande 1

Entities Mapping

Class Mapping errors
App\Entity\Commande
  • The mappings App\Entity\Commande#fournisseurs and App\Entity\Fournisseur#commandes are inconsistent with each other.
App\Entity\Fournisseur
  • The association App\Entity\Fournisseur#composants refers to the owning side field App\Entity\Composant#fournisseur which does not exist.
  • The association App\Entity\Fournisseur#commandes refers to the owning side field App\Entity\Commande#fournisseur which does not exist.
  • The association App\Entity\Fournisseur#qtCommandes refers to the owning side field App\Entity\QtCommande#fournisseur which does not exist.
App\Entity\QtCommande No errors.
App\Entity\Composant
  • The mappings App\Entity\Composant#fournisseurs and App\Entity\Fournisseur#composants are inconsistent with each other.
  • The field App\Entity\Composant#qt is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Qt#composants does not contain the required 'mappedBy="qt"' attribute.
  • If association App\Entity\Composant#qt is many-to-one, then the inversed side App\Entity\Qt#composants has to be one-to-many.
  • The association App\Entity\Composant#commande refers to the inverse side field App\Entity\Commande#countCommande which does not exist.
App\Entity\Qt No errors.
App\Entity\Association No errors.
App\Entity\Mouvement No errors.
App\Entity\SousComposants No errors.
App\Entity\MouvementWeb No errors.
App\Entity\MouvementTransporteur No errors.
App\Entity\MouvementWebAccessoires No errors.