Query Metrics
22
Database Queries
15
Different statements
85.03 ms
Query time
0
Invalid entities
576
Managed entities
Queries
| #▲ | 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 |
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. |
| App\Entity\Settings\OfficialHoliday | No errors. |
| App\Entity\Certificates\Certificates | No errors. |