GET http://cocagne.neotech.fr/livraison/1949384/edit

Query Metrics

11 Database Queries
11 Different statements
22.75 ms Query time
0 Invalid entities
8236 Managed entities

Queries

Group similar statements

# Time Info
1 2.22 ms
SELECT t0.qte AS qte_1, t0.livre AS livre_2, t0.jour AS jour_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.abonnement_id AS abonnement_id_7, t0.produit_id AS produit_id_8, t0.depot_id AS depot_id_9, t0.tournee_id AS tournee_id_10, t0.calendrier_id AS calendrier_id_11 FROM livraison t0 WHERE t0.id = ?
Parameters:
[
  "1949384"
]
2 0.91 ms
SELECT t0.date_debut AS date_debut_1, t0.nombre AS nombre_2, t0.montant AS montant_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.adherent_id AS adherent_id_7, t0.panier_id AS panier_id_8, t0.saison_id AS saison_id_9, t0.mode_paiement_id AS mode_paiement_id_10 FROM abonnement t0 WHERE t0.id = ?
Parameters:
[
  27407
]
3 0.84 ms
SELECT t0.produit AS produit_1, t0.prix AS prix_2, t0.marge AS marge_3, t0.categorie AS categorie_4, t0.couleur AS couleur_5, t0.doublage_id AS doublage_id_6, t0.id AS id_7, t0.actif AS actif_8, t0.ordre AS ordre_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  6
]
4 1.02 ms
SELECT t0.depot AS depot_1, t0.capacite AS capacite_2, t0.id AS id_3 FROM depot t0 WHERE t0.id = ?
Parameters:
[
  50
]
5 0.76 ms
SELECT t0.tournee AS tournee_1, t0.couleur AS couleur_2, t0.id AS id_3, t0.ordre AS ordre_4, t0.preparation_id AS preparation_id_5, t0.calendrier_id AS calendrier_id_6 FROM tournee t0 WHERE t0.id = ?
Parameters:
[
  16
]
6 0.70 ms
SELECT t0.calendrier AS calendrier_1, t0.id AS id_2, t0.saison_id AS saison_id_3 FROM calendrier t0 WHERE t0.id = ?
Parameters:
[
  6
]
7 14.09 ms
SELECT a0_.date_debut AS date_debut_0, a0_.nombre AS nombre_1, a0_.montant AS montant_2, a0_.id AS id_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.adherent_id AS adherent_id_6, a0_.panier_id AS panier_id_7, a0_.saison_id AS saison_id_8, a0_.mode_paiement_id AS mode_paiement_id_9 FROM abonnement a0_
Parameters:
[]
8 0.82 ms
SELECT p0_.produit AS produit_0, p0_.prix AS prix_1, p0_.marge AS marge_2, p0_.categorie AS categorie_3, p0_.couleur AS couleur_4, p0_.doublage_id AS doublage_id_5, p0_.id AS id_6, p0_.actif AS actif_7, p0_.ordre AS ordre_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM produit p0_
Parameters:
[]
9 0.48 ms
SELECT d0_.depot AS depot_0, d0_.capacite AS capacite_1, d0_.id AS id_2 FROM depot d0_
Parameters:
[]
10 0.47 ms
SELECT t0_.tournee AS tournee_0, t0_.couleur AS couleur_1, t0_.id AS id_2, t0_.ordre AS ordre_3, t0_.preparation_id AS preparation_id_4, t0_.calendrier_id AS calendrier_id_5 FROM tournee t0_
Parameters:
[]
11 0.45 ms
SELECT c0_.calendrier AS calendrier_0, c0_.id AS id_1, c0_.saison_id AS saison_id_2 FROM calendrier c0_
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\Abonnement 6622
App\Entity\Adherent 1412
App\Entity\ModePaiement 48
App\Entity\Tournee 47
App\Entity\Depot 43
App\Entity\Panier 31
App\Entity\Calendrier 16
App\Entity\Produit 10
App\Entity\Saison 4
App\Entity\Preparation 2
App\Entity\Livraison 1

Entities Mapping

Class Mapping errors
App\Entity\Livraison No errors.
App\Entity\Abonnement No errors.
App\Entity\Produit No errors.
App\Entity\Depot No errors.
App\Entity\Tournee No errors.
App\Entity\Calendrier No errors.
App\Entity\Adherent No errors.
App\Entity\Panier No errors.
App\Entity\Saison No errors.
App\Entity\ModePaiement No errors.
App\Entity\PointDistribution No errors.
App\Entity\Preparation No errors.