Query Metrics
3
Database Queries
3
Different statements
4.12 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.37 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:
[
8
]
|
2 | 1.80 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 INNER JOIN user_operation_dossier u2_ ON u0_.id = u2_.operation_id WHERE u2_.user_id = ? AND u1_.link = ? AND u2_.dossier_id = ? AND u0_.active = 1 ORDER BY u0_.ordre ASC
Parameters:
[ 8 "app_salarie_salarie" 40 ] |
3 | 0.95 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, l0_.code AS code_2, p1_.nom AS nom_3, p1_.matricule AS matricule_4, p1_.prenom AS prenom_5, p2_.abreviation AS abreviation_6, t3_.sous_mode AS sous_mode_7, p2_.designation AS designation_8 FROM lcontract l0_ INNER JOIN pemploye p1_ ON l0_.employe_id = p1_.id INNER JOIN pnature_contract p2_ ON l0_.pnature_contract_id = p2_.id INNER JOIN typ_remuneration t3_ ON p2_.type_id = t3_.id WHERE l0_.active = 1 AND l0_.employe_id = ?
Parameters:
[
"7483"
]
|
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 |
|
App\Entity\UsSousModule | No errors. |
App\Entity\UserOperationDossier | No errors. |
App\Entity\LContract |
|
App\Entity\Pemploye |
|
App\Entity\PnatureContract | No errors. |
App\Entity\TypRemuneration | No errors. |