Query Metrics

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

Queries

Group similar statements

# Time Info
1 3218.76 ms
SELECT DISTINCT u0_.id AS id_0 FROM `user` u0_ LIMIT 20 OFFSET 60
Parameters:
[]
2 0.42 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:
[
  286
  10
  32
  33
  287
  21
  160
  253
  28
  12
  56
  61
  267
  71
  292
  261
  80
  169
  69
  68
]
3 0.27 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:
[
  10
]
4 0.25 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:
[
  10
]
5 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:
[
  12
]
6 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:
[
  12
]
7 0.26 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:
[
  21
]
8 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:
[
  21
]
9 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:
[
  28
]
10 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:
[
  28
]
11 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:
[
  32
]
12 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:
[
  32
]
13 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:
[
  33
]
14 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:
[
  33
]
15 0.24 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:
[
  56
]
16 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:
[
  56
]
17 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:
[
  61
]
18 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:
[
  61
]
19 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:
[
  68
]
20 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:
[
  68
]
21 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:
[
  69
]
22 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:
[
  69
]
23 0.25 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:
[
  71
]
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:
[
  71
]
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:
[
  80
]
26 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:
[
  80
]
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:
[
  160
]
28 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:
[
  160
]
29 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:
[
  169
]
30 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:
[
  169
]
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:
[
  253
]
32 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:
[
  253
]
33 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:
[
  261
]
34 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:
[
  261
]
35 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:
[
  267
]
36 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:
[
  267
]
37 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:
[
  286
]
38 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:
[
  286
]
39 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:
[
  287
]
40 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:
[
  287
]
41 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:
[
  292
]
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:
[
  292
]
43 0.20 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\Inventaire No errors.
App\Entity\Reservation No errors.