Query Metrics
3
Database Queries
3
Different statements
5.36 ms
Query time
1
Invalid entities
Grouped Statements
mssql connection
| Time▼ | Count | Info |
|---|---|---|
|
2.19 ms (40.81%) |
1 |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.is_active AS is_active_6, t0.branch_id AS branch_id_7, t0.system_user_id AS system_user_id_8 FROM [neema].[user] t0 WHERE t0.id = ?
Parameters:
[
20
]
|
|
1.71 ms (31.87%) |
1 |
SELECT t0.id AS id_1, t0.staff_name AS staff_name_2, t0.staff_code AS staff_code_3, t0.phone AS phone_4, t0.branch_code AS branch_code_5, t0.id_number AS id_number_6, t0.created_at AS created_at_7, t0.sign_up_code AS sign_up_code_8 FROM [neema].[system_user] t0 WHERE t0.id = ?
Parameters:
[
29
]
|
|
1.46 ms (27.32%) |
1 |
SELECT b0_.id AS id_0, b0_.branch_name AS branch_name_1, b0_.branch_code AS branch_code_2, b0_.email AS email_3, b0_.contact_person AS contact_person_4, b0_.phone AS phone_5, b0_.active AS active_6, b0_.created_at AS created_at_7, b0_.location AS location_8 FROM neema.branch b0_
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| mssql | doctrine.dbal.mssql_connection |
| other_db | doctrine.dbal.other_db_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\User | No errors. |
| App\Entity\Branch | No errors. |
| App\Entity\SystemUser | No errors. |
| App\Entity\MpesaTransaction |
|