Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.30 ms
SELECT DISTINCT u0_.id AS id_0 FROM `user` u0_ LIMIT 20 OFFSET 20
Parameters:
[]
2 0.59 ms
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:
[
  291
  66
  15
  23
  70
  73
  31
  24
  19
  27
  13
  67
  29
  290
  57
  273
  279
  285
  288
  18
]
3 0.30 ms
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:
[
  13
]
4 0.21 ms
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:
[
  13
]
5 0.52 ms
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:
[
  15
]
6 0.20 ms
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:
[
  15
]
7 0.34 ms
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:
[
  18
]
8 0.17 ms
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:
[
  18
]
9 0.19 ms
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:
[
  19
]
10 0.15 ms
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:
[
  19
]
11 0.19 ms
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:
[
  23
]
12 0.41 ms
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:
[
  23
]
13 0.23 ms
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:
[
  24
]
14 0.18 ms
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:
[
  24
]
15 0.23 ms
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:
[
  27
]
16 0.43 ms
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:
[
  27
]
17 0.20 ms
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:
[
  29
]
18 0.18 ms
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:
[
  29
]
19 0.22 ms
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:
[
  31
]
20 0.18 ms
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:
[
  31
]
21 0.23 ms
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:
[
  57
]
22 0.20 ms
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:
[
  57
]
23 0.42 ms
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:
[
  66
]
24 0.19 ms
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:
[
  66
]
25 0.21 ms
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:
[
  67
]
26 0.17 ms
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:
[
  67
]
27 0.21 ms
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:
[
  70
]
28 0.34 ms
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:
[
  70
]
29 0.20 ms
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:
[
  73
]
30 0.18 ms
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:
[
  73
]
31 0.21 ms
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:
[
  273
]
32 0.16 ms
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:
[
  273
]
33 0.20 ms
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:
[
  279
]
34 0.19 ms
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:
[
  279
]
35 0.20 ms
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:
[
  285
]
36 0.17 ms
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:
[
  285
]
37 1.44 ms
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:
[
  288
]
38 0.17 ms
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:
[
  288
]
39 0.22 ms
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:
[
  290
]
40 0.16 ms
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:
[
  290
]
41 0.21 ms
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:
[
  291
]
42 0.16 ms
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:
[
  291
]
43 0.22 ms
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\Reservation No errors.