https://payments.neemaopticians.co.ke/web/system_users/json Return to referer URL

Query Metrics

3 Database Queries
3 Different statements
45.42 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

mssql connection

Time Count Info
24.96 ms
(54.95%)
1
SELECT b.phone, c.branch_code, c.branch_name,b.staff_name, b.created_at FROM neema."system_user" b
                        JOIN neema.branch c on b.branch_code = c.branch_code
                        
                    WHERE b.staff_name is not NULL   AND  b.staff_name like'%ann%' ORDER BY b.created_at desc OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY
Parameters:
[]
17.42 ms
(38.36%)
1
SELECT count(*) as total FROM neema."system_user" b
                        JOIN neema.branch c on b.branch_code = c.branch_code
                        
                    WHERE b.staff_name is not NULL   AND  b.staff_name like'%ann%'
Parameters:
[]
3.04 ms
(6.69%)
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
]

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.