Query Metrics
4
Database Queries
4
Different statements
6.79 ms
Query time
3
Invalid entities
Grouped Statements
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 |
|
App\Entity\Tbulletin |
|
App\Entity\LdossierContract | No errors. |
App\Entity\DemandeConge | No errors. |
App\Entity\InjectRemuneration | No errors. |
App\Entity\UsSousModule | No errors. |
App\Entity\UsOperation |
|
App\Entity\UserOperationDossier | No errors. |
App\Entity\UsModule | No errors. |