GET https://bereup.online/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CUserCrudController

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT DISTINCT u0_.id AS id_0 FROM `user` u0_ LIMIT 20
Parameters:
[]
2 0.52 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:
[
  74
  7
  65
  34
  43
  62
  63
  64
  35
  36
  37
  38
  39
  40
  41
  42
  75
  249
  289
  17
]
3 0.28 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:
[
  7
]
4 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:
[
  7
]
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:
[
  17
]
6 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:
[
  17
]
7 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:
[
  34
]
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:
[
  34
]
9 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:
[
  35
]
10 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:
[
  35
]
11 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:
[
  36
]
12 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:
[
  36
]
13 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:
[
  37
]
14 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:
[
  37
]
15 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:
[
  38
]
16 0.22 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:
[
  38
]
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:
[
  39
]
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:
[
  39
]
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:
[
  40
]
20 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:
[
  40
]
21 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:
[
  41
]
22 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:
[
  41
]
23 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:
[
  42
]
24 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:
[
  42
]
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:
[
  43
]
26 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:
[
  43
]
27 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:
[
  62
]
28 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:
[
  62
]
29 2.61 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:
[
  63
]
30 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:
[
  63
]
31 7.04 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:
[
  64
]
32 0.24 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:
[
  64
]
33 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:
[
  65
]
34 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:
[
  65
]
35 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:
[
  74
]
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:
[
  74
]
37 3.68 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:
[
  75
]
38 4.26 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:
[
  75
]
39 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:
[
  249
]
40 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:
[
  249
]
41 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:
[
  289
]
42 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:
[
  289
]
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.
App\Entity\Inventaire No errors.