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

Query Metrics

22 Database Queries
15 Different statements
85.03 ms Query time
0 Invalid entities
576 Managed entities

Queries

Group similar statements

# Time Info
1 0.68 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"
  "joan"
]
2 0.32 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 1.09 ms
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.count AS count_4, t0.approved_start_date AS approved_start_date_5, t0.approved_end_date AS approved_end_date_6, t0.approved_count AS approved_count_7, t0.reason AS reason_8, t0.reject_reason AS reject_reason_9, t0.is_half_day AS is_half_day_10, t0.is_schedule_leave AS is_schedule_leave_11, t0.category AS category_12, t0.is_active AS is_active_13, t0.type AS type_14, t0.certificate AS certificate_15, t0.status AS status_16, t0.is_manager_added AS is_manager_added_17, t0.is_ceo_added AS is_ceo_added_18, t0.is_fingerprint_leave AS is_fingerprint_leave_19, t0.created AS created_20, t0.updated AS updated_21, t0.slug AS slug_22, t0.emp_id AS emp_id_23, t0.approver_id AS approver_id_24 FROM leaves t0 WHERE t0.start_date = ? AND t0.end_date = ? AND t0.emp_id = ? LIMIT 1
Parameters:
[
  "2026-05-04"
  "2026-05-05"
  100
]
4 1.01 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_.roles LIKE ? OR e0_.roles LIKE ?
Parameters:
[
  "%"ROLE_MANAGER"%"
  "%"ROLE_CEO"%"
]
5 0.49 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:
[
  32
]
6 0.38 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:
[
  58
]
7 0.26 ms
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:
[
  14
]
8 0.62 ms
SELECT o0_.date AS date_0, o0_.name AS name_1 FROM official_holiday o0_ WHERE o0_.date >= ? AND o0_.date < ?
Parameters:
[
  "2026-05-04"
  "2026-05-06"
]
9 1.98 ms
SELECT t0.id AS id_1, t0.message AS message_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.created AS created_5, t0.updated AS updated_6, t0.leave_id AS leave_id_7 FROM notification t0 INNER JOIN notify_receiver ON t0.id = notify_receiver.notify_id WHERE notify_receiver.receiver_id = ?
Parameters:
[
  32
]
10 1.74 ms
SELECT t0.id AS id_1, t0.message AS message_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.created AS created_5, t0.updated AS updated_6, t0.leave_id AS leave_id_7 FROM notification t0 INNER JOIN notify_receiver ON t0.id = notify_receiver.notify_id WHERE notify_receiver.receiver_id = ?
Parameters:
[
  58
]
11 2.85 ms
SELECT l0_.slug AS slug_0 FROM leaves l0_ WHERE l0_.slug LIKE ?
Parameters:
[
  "%"
]
12 0.21 ms
"START TRANSACTION"
Parameters:
[]
13 0.57 ms
INSERT INTO leaves (start_date, end_date, count, approved_start_date, approved_end_date, approved_count, reason, reject_reason, is_half_day, is_schedule_leave, category, is_active, type, certificate, status, is_manager_added, is_ceo_added, is_fingerprint_leave, created, updated, slug, emp_id, approver_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2026-05-04"
  "2026-05-05"
  "2"
  null
  null
  "0.0"
  "Sick"
  ""
  0
  0
  "annual"
  0
  "annual"
  null
  1
  0
  0
  0
  "2026-05-06 14:02:57"
  "2026-05-06 14:02:57"
  "-1111"
  100
  null
]
14 0.44 ms
INSERT INTO notification (message, firstname, lastname, created, updated, leave_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  " request a New day off"
  "Joan"
  ""
  "2026-05-06 14:02:57"
  "2026-05-06 14:02:57"
  6043
]
15 0.38 ms
UPDATE employee SET updated = ? WHERE id = ?
Parameters:
[
  "2026-05-06 14:02:57"
  32
]
16 0.24 ms
UPDATE employee SET updated = ? WHERE id = ?
Parameters:
[
  "2026-05-06 14:02:57"
  58
]
17 0.36 ms
INSERT INTO notify_receiver (receiver_id, notify_id) VALUES (?, ?)
Parameters:
[
  32
  5808
]
18 0.21 ms
INSERT INTO notify_receiver (receiver_id, notify_id) VALUES (?, ?)
Parameters:
[
  58
  5808
]
19 34.84 ms
"COMMIT"
Parameters:
[]
20 0.23 ms
"START TRANSACTION"
Parameters:
[]
21 0.64 ms
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:51:\"Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\":2:{s:60:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0message\";O:39:\"Symfony\\Bridge\\Twig\\Mime\\TemplatedEmail\":5:{i:0;s:30:\"emails/leave-request.html.twig\";i:1;N;i:2;a:9:{s:9:\"firstname\";s:4:\"Joan\";s:8:\"lastname\";s:0:\"\";s:11:\"emailMessge\";s:22:\"request a annual leave\";s:9:\"startDate\";s:11:\"04 May 2026\";s:7:\"endDate\";s:11:\"05 May 2026\";s:5:\"count\";i:2;s:9:\"leavetype\";s:6:\"annual\";s:6:\"reason\";s:4:\"Sick\";s:7:\"empData\";a:13:{s:9:\"firstname\";s:4:\"Joan\";s:8:\"lastname\";s:0:\"\";s:12:\"scheduleUsed\";d:58.5;s:10:\"casualUsed\";d:11;s:16:\"pastScheduleUsed\";d:0;s:14:\"pastCasualUsed\";d:0;s:17:\"scheduleRemaining\";s:5:\"-58.5\";s:15:\"casualRemaining\";s:5:\"-11.0\";s:17:\"totalScheduleUsed\";d:58.5;s:15:\"totalCasualUsed\";d:11;s:13:\"totalSchedule\";s:3:\"0.0\";s:11:\"totalCasual\";s:3:\"0.0\";s:7:\"leaveid\";N;}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\"Symfony\\Component\\Mime\\Header\\Headers\":2:{s:46:\"\0Symfony\\Component\\Mime\\Header\\Headers\0headers\";a:4:{s:4:\"from\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:4:\"From\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:22:\"dayoff@pinkart-ltd.com\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}s:2:\"to\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:2:\"To\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:2:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:34:\"christophe.lucette@pinkart-ltd.com\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}i:1;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:22:\"ajalon@pinkart-ltd.com\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}s:7:\"subject\";a:1:{i:0;O:48:\"Symfony\\Component\\Mime\\Header\\UnstructuredHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:7:\"Subject\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:55:\"\0Symfony\\Component\\Mime\\Header\\UnstructuredHeader\0value\";s:19:\"New day off request\";}}s:3:\"bcc\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:3:\"Bcc\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:22:\"dayoff@pinkart-ltd.com\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}}s:49:\"\0Symfony\\Component\\Mime\\Header\\Headers\0lineLength\";i:76;}i:1;N;}}i:4;N;}s:61:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0envelope\";N;}}"
  "[]"
  "default"
  "2026-05-06 10:02:57"
  "2026-05-06 10:02:57"
]
22 35.47 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\Notification 348
App\Entity\Leave\Leaves 218
App\Entity\Employee\Employee 4
App\Entity\Employee\Invite 3
App\Entity\Group\Team 2
App\Entity\Group\Agency 1