Query Metrics
6
Database Queries
6
Different statements
42.07 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.17 ms |
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:
[ "joan.correct@pinkart-ltd.com" "joan.correct@pinkart-ltd.com" ] |
| 2 | 0.56 ms |
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:
[
100
]
|
| 3 | 7.34 ms |
SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = ? LIMIT 1
Parameters:
[
"453872a094600985982d820fab1460d7be0bd7aaa5b39ce68ef5b81e0208b5239a89afa7d100aa4f33b1f74c6ebda4b36b1499552b54721db8aa494fc541a08d"
]
|
| 4 | 0.31 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.62 ms |
INSERT INTO refresh_tokens (refresh_token, username, valid) VALUES (?, ?, ?)
Parameters:
[ "453872a094600985982d820fab1460d7be0bd7aaa5b39ce68ef5b81e0208b5239a89afa7d100aa4f33b1f74c6ebda4b36b1499552b54721db8aa494fc541a08d" "joan.correct@pinkart-ltd.com" "2026-01-12 11:33:05" ] |
| 6 | 32.07 ms |
"COMMIT"
Parameters:
[] |
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 | 2 |
| App\Entity\Group\Team | 1 |
| App\Entity\Employee\Invite | 1 |
| App\Entity\Token\RefreshToken | 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. |