http://drh-fcz.ma/

Query Metrics

2 Database Queries
2 Different statements
14.33 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
13.09 ms
(91.33%)
1
SELECT DISTINCT p0_.designation AS designation_0, p0_.id AS id_1, p0_.abreviation AS abreviation_2 FROM user_operation_dossier u1_ INNER JOIN pdossier p0_ ON u1_.dossier_id = p0_.id INNER JOIN users u2_ ON u1_.user_id = u2_.id INNER JOIN us_operation u3_ ON u1_.operation_id = u3_.id WHERE u2_.id = ? AND u3_.active = 1 AND p0_.active = 1
Parameters:
[
  3
]
1.24 ms
(8.67%)
1
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:
[
  3
]

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\UserOperationDossier 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.