GET https://app-prod.fr/association/1865/duplicates

Query Metrics

19 Database Queries
6 Different statements
196.73 ms Query time
1 Invalid entities
45 Managed entities

Queries

Group similar statements

# Time Info
1 10.38 ms
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.produit_id AS produit_id_8 FROM association t0 WHERE t0.id = ?
Parameters:
[
  "1865"
]
2 10.03 ms
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:
[
  1865
]
3 9.91 ms
"START TRANSACTION"
Parameters:
[]
4 10.20 ms
INSERT INTO association (produit_reference, is_active_produit, is_coupure_produit, is_in_active_produit, date_debut, date_fin, produit_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "PQDF96614#NU"
  1
  1
  0
  null
  null
  264
]
5 11.69 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  3
  265
  2209
]
6 10.28 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  3
  171
  2209
]
7 10.02 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  2
  264
  2209
]
8 10.24 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  1
  266
  2209
]
9 10.30 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  1
  298
  2209
]
10 11.76 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  1
  147
  2209
]
11 10.06 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  1
  148
  2209
]
12 10.16 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  1
  149
  2209
]
13 10.09 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  1
  140
  2209
]
14 10.26 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  2
  104
  2209
]
15 10.17 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  1
  105
  2209
]
16 10.14 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  1
  108
  2209
]
17 10.24 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  1
  305
  2209
]
18 10.19 ms
INSERT INTO qt (quantite, composants_id, association_id) VALUES (?, ?, ?)
Parameters:
[
  1
  109
  2209
]
19 10.60 ms
"COMMIT"
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\Qt 28
App\Entity\Composant 14
App\Entity\Association 2
App\Entity\Produit 1

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.