Query Metrics

43 Database Queries
5 Different statements
3227.24 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3218.76 ms
(99.74%)
1
SELECT DISTINCT u0_.id AS id_0 FROM `user` u0_ LIMIT 20 OFFSET 60
Parameters:
[]
4.37 ms
(0.14%)
20
SELECT t0.id AS id_1, t0.nom_structure AS nom_structure_2, t0.type_structure AS type_structure_3, t0.types_projet AS types_projet_4, t0.volume_vehicule AS volume_vehicule_5, t0.manutention AS manutention_6, t0.adresse AS adresse_7, t0.nom_contact AS nom_contact_8, t0.email_contact AS email_contact_9, t0.telephone_contact AS telephone_contact_10, t0.site_web AS site_web_11, t0.linkedin AS linkedin_12, t0.ressources AS ressources_13, t0.details AS details_14, t0.validation AS validation_15, t0.user_id AS user_id_16 FROM filiere t0 WHERE t0.user_id = ?
Parameters:
[
  10
]
3.49 ms
(0.11%)
20
SELECT t0.id AS id_1, t0.quantites AS quantites_2, t0.proprietaire_id AS proprietaire_id_3 FROM panier t0 WHERE t0.proprietaire_id = ?
Parameters:
[
  10
]
0.42 ms
(0.01%)
1
SELECT u0_.id AS id_0, u0_.login AS login_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.prenom AS prenom_4, u0_.nom AS nom_5, u0_.datedenaissance AS datedenaissance_6, u0_.lieudenaissance AS lieudenaissance_7, u0_.adresse AS adresse_8, u0_.contact AS contact_9, u0_.rib AS rib_10, u0_.siret AS siret_11, u0_.securitesociale AS securitesociale_12, u0_.email AS email_13, u0_.contacturgence AS contacturgence_14, u0_.contacturgencetel AS contacturgencetel_15, u0_.photo AS photo_16, u0_.permis AS permis_17, u0_.autres AS autres_18 FROM `user` u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  286
  10
  32
  33
  287
  21
  160
  253
  28
  12
  56
  61
  267
  71
  292
  261
  80
  169
  69
  68
]
0.20 ms
(0.01%)
1
SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_
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\User
  • The field App\Entity\User#panier is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Panier#proprietaire does not contain the required 'inversedBy="panier"' attribute.
App\Entity\Suivi No errors.
App\Entity\Filiere No errors.
App\Entity\Panier No errors.
App\Entity\Inventaire No errors.
App\Entity\Reservation No errors.