POST https://dayoff.pinkart-ltd.com/api/login

Query Metrics

6 Database Queries
6 Different statements
42.07 ms Query time
0 Invalid entities
5 Managed entities

Queries

Group similar statements

# 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