http://drh-fcz.ma/traitement/demande

Query Metrics

5 Database Queries
5 Different statements
6.27 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.33 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.enable AS enable_7, t0.created AS created_8, t0.email AS email_9, t0.updated AS updated_10, t0.user_updated_id AS user_updated_id_11, t0.dossier_responsable_id AS dossier_responsable_id_12 FROM users t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 1.78 ms
SELECT u0_.id AS id_0, u0_.link AS link_1, u0_.icon AS icon_2, u0_.designation AS designation_3, u0_.class_tag AS class_tag_4, u0_.id_tag AS id_tag_5, u0_.ordre AS ordre_6, u0_.align AS align_7, u0_.active AS active_8, u0_.sous_module_id AS sous_module_id_9 FROM us_operation u0_ INNER JOIN us_sous_module u1_ ON u0_.sous_module_id = u1_.id WHERE u1_.link = ? ORDER BY u0_.ordre ASC
Parameters:
[
  "app_traitement_demande"
]
3 1.41 ms
SELECT p0_.id AS id_0, p0_.classe AS classe_1, p0_.statut AS statut_2, p0_.message AS message_3, p0_.created AS created_4, p0_.user_id AS user_id_5 FROM pmessenger_statut p0_ WHERE p0_.created <= ? AND p0_.statut IN (?, ?)
Parameters:
[
  "2025-03-18 22:30:49"
  "en cours"
  "demarer"
]
4 0.56 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.abreviation AS abreviation_3, t0.date AS date_4, t0.is_valider AS is_valider_5, t0.is_integrer AS is_integrer_6 FROM periode t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "032025"
]
5 1.19 ms
SELECT t0.id AS id_1, t0.message AS message_2, t0.seen AS seen_3, t0.created AS created_4, t0.user_id AS user_id_5 FROM pnotification t0 WHERE t0.user_id = ? AND t0.seen = ? ORDER BY t0.created DESC LIMIT 5
Parameters:
[
  1
  0
]

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\Users No errors.
App\Entity\PDossier No errors.
App\Entity\HonoraireDetFixe No errors.
App\Entity\TCnssA00 No errors.
App\Entity\PNotification No errors.
App\Entity\UsOperation
  • The field App\Entity\UsOperation#userOperationDossiers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserOperationDossier#operation does not contain the required 'inversedBy="userOperationDossiers"' attribute.
App\Entity\UsSousModule No errors.
App\Entity\UserOperationDossier No errors.
App\Entity\PMessengerStatut No errors.
App\Entity\Periode No errors.
App\Entity\PArretTravailLg No errors.
App\Entity\LElementEcheance No errors.
App\Entity\Tbulletin
  • The field App\Entity\Tbulletin#bulletinLgs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TbulletinLg#bulletin does not contain the required 'inversedBy="bulletinLgs"' attribute.
App\Entity\PPrelevementLg No errors.
App\Entity\Probleme No errors.
App\Entity\PBordereau No errors.
App\Entity\SyntheseRemunarationCab No errors.
App\Entity\InjectRemuneration No errors.