GET https://auth-diplome.ucar.rnu.tn/mes/demandes

Query Metrics

9 Database Queries
6 Different statements
2.58 ms Query time
1 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 0.86 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_verified AS is_verified_7, t0.identity AS identity_8, t0.type_user AS type_user_9, t0.date_naiss AS date_naiss_10, t0.nationalite AS nationalite_11, t0.lieu_naiss AS lieu_naiss_12, t0.cinimage AS cinimage_13, t0.cin_verso AS cin_verso_14, t0.phone AS phone_15, t0.genre AS genre_16, t0.address AS address_17 FROM user t0 WHERE t0.id = ?
Parameters:
[
  119
]
2 0.24 ms
SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.is_read AS is_read_2, n0_.created_at AS created_at_3, n0_.user_id AS user_id_4 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.is_read = ? ORDER BY n0_.created_at DESC
Parameters:
[
  119
  0
]
3 0.22 ms
SELECT count(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.is_read = 0
Parameters:
[
  119
]
4 0.23 ms
SELECT t0.id AS id_1, t0.statut AS statut_2, t0.commentaire AS commentaire_3, t0.date_demande AS date_demande_4, t0.traite AS traite_5, t0.user_id AS user_id_6 FROM demande t0 WHERE t0.user_id = ? ORDER BY t0.date_demande DESC
Parameters:
[
  119
]
5 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = ?
Parameters:
[
  54
]
6 0.22 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.abreviation AS abreviation_3 FROM etablissement t0 WHERE t0.id = ?
Parameters:
[
  21
]
7 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = ?
Parameters:
[
  55
]
8 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = ?
Parameters:
[
  56
]
9 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = ?
Parameters:
[
  57
]

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\Demande 4
App\Entity\Document 4
App\Entity\User 1
App\Entity\Etablissement 1

Entities Mapping

Class Mapping errors
App\Entity\User
  • The association App\Entity\User#user refers to the owning side field App\Entity\Etablissement#user which does not exist.
App\Entity\Demande No errors.
App\Entity\Etablissement No errors.
App\Entity\Notification No errors.
App\Entity\Document No errors.