GET https://app-test.fr/composition

Query Metrics

67 Database Queries
6 Different statements
58.14 ms Query time
3 Invalid entities
4930 Managed entities

Grouped Statements

Show all queries

Time Count Info
19.20 ms
(33.02%)
24
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:
[
  188
]
17.15 ms
(29.50%)
24
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.quantite AS quantite_3, t0.sous_composants_id AS sous_composants_id_4 FROM sous_composants t0 WHERE t0.sous_composants_id = ?
Parameters:
[
  188
]
10.20 ms
(17.55%)
3
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:
[]
7.19 ms
(12.37%)
10
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:
[
  84
]
3.62 ms
(6.23%)
5
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.composants_id AS composants_id_3, t0.association_id AS association_id_4 FROM qt t0 WHERE t0.association_id = ?
Parameters:
[
  3429
]
0.78 ms
(1.34%)
1
SELECT t0.id AS id_1, t0.produit_reference AS produit_reference_2, t0.is_active_produit AS is_active_produit_3, t0.is_coupure_produit AS is_coupure_produit_4, t0.is_in_active_produit AS is_in_active_produit_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.is_bouquet AS is_bouquet_8, t0.produit_id AS produit_id_9 FROM association t0 WHERE t0.is_bouquet = ?
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MouvementWeb 4842
App\Entity\Qt 44
App\Entity\Composant 24
App\Entity\Fournisseur 10
App\Entity\Association 5
App\Entity\Produit 5

Entities Mapping

Class Mapping errors
App\Entity\Association No errors.
App\Entity\Produit No errors.
App\Entity\Qt 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\MouvementWeb No errors.
App\Entity\MouvementTransporteur No errors.
App\Entity\MouvementWebAccessoires No errors.
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\Commande
  • The mappings App\Entity\Commande#fournisseurs and App\Entity\Fournisseur#commandes are inconsistent with each other.
App\Entity\QtCommande No errors.
App\Entity\Mouvement No errors.
App\Entity\SousComposants No errors.