http://drh-fcz.ma/redirect Return to referer URL

Query Metrics

4 Database Queries
4 Different statements
6.79 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.92 ms
(43.05%)
1
SELECT u0_.id AS id_0, u0_.link AS link_1, u0_.designation AS designation_2, u0_.prefix AS prefix_3, u0_.ordre AS ordre_4, u0_.module_id AS module_id_5 FROM us_sous_module u0_ INNER JOIN us_operation u1_ ON u0_.id = u1_.sous_module_id INNER JOIN user_operation_dossier u2_ ON u1_.id = u2_.operation_id WHERE u2_.user_id = ? AND u2_.dossier_id = ? AND u1_.active = 1
Parameters:
[
  10
  6
]
1.54 ms
(22.72%)
1
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.abreviation AS abreviation_3, t0.code AS code_4, t0.groupement AS groupement_5, t0.dossier_ugouv_id AS dossier_ugouv_id_6, t0.abreviation2 AS abreviation2_7, t0.abreviation_ugouv AS abreviation_ugouv_8, t0.fcy0 AS fcy0_9, t0.cpy0 AS cpy0_10, t0.partenaire_id AS partenaire_id_11, t0.affiliation AS affiliation_12, t0.statut_cimr AS statut_cimr_13, t0.image AS image_14, t0.adresse AS adresse_15, t0.ice AS ice_16, t0.num_if AS num_if_17, t0.fax AS fax_18, t0.telephone AS telephone_19, t0.active AS active_20, t0.das AS das_21, t0.fcy_id AS fcy_id_22 FROM pdossier t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
1.27 ms
(18.62%)
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:
[
  10
]
1.06 ms
(15.61%)
1
SELECT u0_.id AS id_0, u0_.designation AS designation_1, u0_.prefix AS prefix_2, u0_.icon AS icon_3, u0_.ordre AS ordre_4 FROM us_module u0_ INNER JOIN us_sous_module u1_ ON u0_.id = u1_.module_id WHERE u1_.id IN (?, ?, ?, ?, ?) ORDER BY u0_.ordre ASC
Parameters:
[
  1
  14
  16
  2
  11
]

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\PFcy No errors.
App\Entity\LContract
  • The mappings App\Entity\LContract#lmatriculationCotis and App\Entity\LmatriculationCoti#contract_id are inconsistent with each other.
  • The mappings App\Entity\LContract#fonction and App\Entity\Pfonction#lContracts are inconsistent with each other.
  • The association App\Entity\LContract#tCnssA02s refers to the owning side field App\Entity\TCnssA02#LContract which does not exist.
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\LdossierContract No errors.
App\Entity\DemandeConge No errors.
App\Entity\InjectRemuneration No errors.
App\Entity\UsSousModule 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\UserOperationDossier No errors.
App\Entity\UsModule No errors.