Query Metrics
9
Database Queries
4
Different statements
4.34 ms
Query time
0
Invalid entities
15
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.76 ms (40.50%) |
1 |
SELECT e0_.id AS id_0, e0_.firstname AS firstname_1, e0_.lastname AS lastname_2, e0_.email AS email_3, e0_.username AS username_4, e0_.fingerprintid AS fingerprintid_5, e0_.fingerprintname AS fingerprintname_6, e0_.password AS password_7, e0_.phone AS phone_8, e0_.fixedline AS fixedline_9, e0_.roles AS roles_10, e0_.status AS status_11, e0_.is_vacation_allowed AS is_vacation_allowed_12, e0_.schedule_used AS schedule_used_13, e0_.casual_used AS casual_used_14, e0_.vacation_used AS vacation_used_15, e0_.wfh_used AS wfh_used_16, e0_.past_schedule_used AS past_schedule_used_17, e0_.past_casual_used AS past_casual_used_18, e0_.last_year_schedule_used AS last_year_schedule_used_19, e0_.last_year_casual_used AS last_year_casual_used_20, e0_.schedule_remaining AS schedule_remaining_21, e0_.casual_remaining AS casual_remaining_22, e0_.vacation_remaining AS vacation_remaining_23, e0_.total_schedule_used AS total_schedule_used_24, e0_.total_casual_used AS total_casual_used_25, e0_.total_schedule AS total_schedule_26, e0_.total_casual AS total_casual_27, e0_.created AS created_28, e0_.updated AS updated_29, e0_.slug AS slug_30, e0_.team_id AS team_id_31 FROM employee e0_ WHERE e0_.username = ? OR e0_.email = ?
Parameters:
[ "vicky@pinkart-ltd.com" "vicky@pinkart-ltd.com" ] |
|
1.27 ms (29.30%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.password AS password_4, t0.created AS created_5, t0.updated AS updated_6, t0.slug AS slug_7, t0.employ_id AS employ_id_8, t0.inviter_id AS inviter_id_9 FROM invite t0 WHERE t0.employ_id = ?
Parameters:
[
56
]
|
|
0.96 ms (22.19%) |
1 |
SELECT e0_.id AS id_0, e0_.firstname AS firstname_1, e0_.lastname AS lastname_2, e0_.email AS email_3, e0_.username AS username_4, e0_.fingerprintid AS fingerprintid_5, e0_.fingerprintname AS fingerprintname_6, e0_.password AS password_7, e0_.phone AS phone_8, e0_.fixedline AS fixedline_9, e0_.roles AS roles_10, e0_.status AS status_11, e0_.is_vacation_allowed AS is_vacation_allowed_12, e0_.schedule_used AS schedule_used_13, e0_.casual_used AS casual_used_14, e0_.vacation_used AS vacation_used_15, e0_.wfh_used AS wfh_used_16, e0_.past_schedule_used AS past_schedule_used_17, e0_.past_casual_used AS past_casual_used_18, e0_.last_year_schedule_used AS last_year_schedule_used_19, e0_.last_year_casual_used AS last_year_casual_used_20, e0_.schedule_remaining AS schedule_remaining_21, e0_.casual_remaining AS casual_remaining_22, e0_.vacation_remaining AS vacation_remaining_23, e0_.total_schedule_used AS total_schedule_used_24, e0_.total_casual_used AS total_casual_used_25, e0_.total_schedule AS total_schedule_26, e0_.total_casual AS total_casual_27, e0_.created AS created_28, e0_.updated AS updated_29, e0_.slug AS slug_30, e0_.team_id AS team_id_31 FROM employee e0_ WHERE e0_.team_id = ? AND e0_.id <> ? AND e0_.roles NOT LIKE ? AND e0_.roles NOT LIKE ?
Parameters:
[ 13 56 "%"ROLE_CEO"%" "%"ROLE_ADMIN"%" ] |
|
0.35 ms (8.01%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created AS created_3, t0.updated AS updated_4, t0.slug AS slug_5, t0.agency_id AS agency_id_6, t0.manager_id AS manager_id_7 FROM grp_team t0 WHERE t0.id = ?
Parameters:
[
13
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Employee\Employee | 7 |
| App\Entity\Employee\Invite | 6 |
| App\Entity\Group\Team | 1 |
| App\Entity\Group\Agency | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken | No errors. |
| App\Entity\Token\RefreshToken | No errors. |
| App\Entity\Employee\Employee | No errors. |
| App\Entity\Group\Team | No errors. |
| App\Entity\Employee\Invite | No errors. |
| App\Entity\Leave\Leaves | No errors. |
| App\Entity\Employee\Notification | No errors. |
| App\Entity\Group\Agency | No errors. |