Query Metrics
36
Database Queries
8
Different statements
23.93 ms
Query time
0
Invalid entities
115
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.62 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:
[ "jeanluc.lohun" "jeanluc.lohun" ] |
| 2 | 0.28 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:
[
106
]
|
| 3 | 8.28 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, l1_.id AS id_31, l1_.start_date AS start_date_32, l1_.end_date AS end_date_33, l1_.count AS count_34, l1_.approved_start_date AS approved_start_date_35, l1_.approved_end_date AS approved_end_date_36, l1_.approved_count AS approved_count_37, l1_.reason AS reason_38, l1_.reject_reason AS reject_reason_39, l1_.is_half_day AS is_half_day_40, l1_.is_schedule_leave AS is_schedule_leave_41, l1_.category AS category_42, l1_.is_active AS is_active_43, l1_.type AS type_44, l1_.certificate AS certificate_45, l1_.status AS status_46, l1_.is_manager_added AS is_manager_added_47, l1_.is_ceo_added AS is_ceo_added_48, l1_.is_fingerprint_leave AS is_fingerprint_leave_49, l1_.created AS created_50, l1_.updated AS updated_51, l1_.slug AS slug_52, e0_.team_id AS team_id_53, l1_.emp_id AS emp_id_54, l1_.approver_id AS approver_id_55 FROM employee e0_ INNER JOIN leaves l1_ ON e0_.id = l1_.emp_id AND (((l1_.start_date >= ? OR l1_.end_date >= ?) AND ((l1_.status BETWEEN 1 AND 2) OR (l1_.status BETWEEN 5 AND 7))) OR ((l1_.start_date >= ? OR l1_.end_date >= ?) AND ((l1_.status BETWEEN 1 AND 2) OR (l1_.status BETWEEN 5 AND 7)))) WHERE e0_.roles NOT LIKE ? AND e0_.roles NOT LIKE ?
Parameters:
[ "2026-01-11" "2026-01-11" "2026-01-11" "2026-01-11" "%"ROLE_CEO"%" "%"ROLE_ADMIN"%" ] |
| 4 | 0.42 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:
[
28
]
|
| 5 | 0.48 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:
[
49
]
|
| 6 | 0.40 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:
[
56
]
|
| 7 | 0.35 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:
[
57
]
|
| 8 | 0.39 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:
[
62
]
|
| 9 | 0.34 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:
[
63
]
|
| 10 | 0.46 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:
[
64
]
|
| 11 | 0.33 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:
[
66
]
|
| 12 | 0.35 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:
[
67
]
|
| 13 | 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:
[
69
]
|
| 14 | 0.36 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:
[
73
]
|
| 15 | 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:
[
75
]
|
| 16 | 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:
[
76
]
|
| 17 | 0.43 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:
[
108
]
|
| 18 | 0.30 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:
[
109
]
|
| 19 | 0.26 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:
[
113
]
|
| 20 | 1.46 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, l1_.id AS id_31, l1_.start_date AS start_date_32, l1_.end_date AS end_date_33, l1_.count AS count_34, l1_.approved_start_date AS approved_start_date_35, l1_.approved_end_date AS approved_end_date_36, l1_.approved_count AS approved_count_37, l1_.reason AS reason_38, l1_.reject_reason AS reject_reason_39, l1_.is_half_day AS is_half_day_40, l1_.is_schedule_leave AS is_schedule_leave_41, l1_.category AS category_42, l1_.is_active AS is_active_43, l1_.type AS type_44, l1_.certificate AS certificate_45, l1_.status AS status_46, l1_.is_manager_added AS is_manager_added_47, l1_.is_ceo_added AS is_ceo_added_48, l1_.is_fingerprint_leave AS is_fingerprint_leave_49, l1_.created AS created_50, l1_.updated AS updated_51, l1_.slug AS slug_52, e0_.team_id AS team_id_53, l1_.emp_id AS emp_id_54, l1_.approver_id AS approver_id_55 FROM employee e0_ INNER JOIN grp_team g2_ ON e0_.team_id = g2_.id AND (g2_.id = 13) INNER JOIN leaves l1_ ON e0_.id = l1_.emp_id AND (((l1_.start_date >= ? OR l1_.end_date >= ?) AND ((l1_.status BETWEEN 1 AND 2) OR (l1_.status BETWEEN 5 AND 7))) OR ((l1_.start_date >= ? OR l1_.end_date >= ?) AND ((l1_.status BETWEEN 1 AND 2) OR (l1_.status BETWEEN 5 AND 7)))) WHERE e0_.roles NOT LIKE ? AND e0_.roles NOT LIKE ?
Parameters:
[ "2026-01-11" "2026-01-11" "2026-01-11" "2026-01-11" "%"ROLE_CEO"%" "%"ROLE_ADMIN"%" ] |
| 21 | 0.42 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:
[
13
]
|
| 22 | 0.43 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = ?
Parameters:
[
5930
]
|
| 23 | 0.35 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 WHERE t0.leave_id = ?
Parameters:
[
5930
]
|
| 24 | 0.36 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = ?
Parameters:
[
5872
]
|
| 25 | 0.73 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.username AS username_5, t0.fingerprintid AS fingerprintid_6, t0.fingerprintname AS fingerprintname_7, t0.password AS password_8, t0.phone AS phone_9, t0.fixedline AS fixedline_10, t0.roles AS roles_11, t0.status AS status_12, t0.is_vacation_allowed AS is_vacation_allowed_13, t0.schedule_used AS schedule_used_14, t0.casual_used AS casual_used_15, t0.vacation_used AS vacation_used_16, t0.wfh_used AS wfh_used_17, t0.past_schedule_used AS past_schedule_used_18, t0.past_casual_used AS past_casual_used_19, t0.last_year_schedule_used AS last_year_schedule_used_20, t0.last_year_casual_used AS last_year_casual_used_21, t0.schedule_remaining AS schedule_remaining_22, t0.casual_remaining AS casual_remaining_23, t0.vacation_remaining AS vacation_remaining_24, t0.total_schedule_used AS total_schedule_used_25, t0.total_casual_used AS total_casual_used_26, t0.total_schedule AS total_schedule_27, t0.total_casual AS total_casual_28, t0.created AS created_29, t0.updated AS updated_30, t0.slug AS slug_31, t0.team_id AS team_id_32, t33.id AS id_34, t33.name AS name_35, t33.email AS email_36, t33.password AS password_37, t33.created AS created_38, t33.updated AS updated_39, t33.slug AS slug_40, t33.employ_id AS employ_id_41, t33.inviter_id AS inviter_id_42 FROM employee t0 LEFT JOIN invite t33 ON t33.employ_id = t0.id WHERE t0.id = ?
Parameters:
[
32
]
|
| 26 | 0.72 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 WHERE t0.leave_id = ?
Parameters:
[
5872
]
|
| 27 | 0.45 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = ?
Parameters:
[
5887
]
|
| 28 | 0.40 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 WHERE t0.leave_id = ?
Parameters:
[
5887
]
|
| 29 | 0.42 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = ?
Parameters:
[
5925
]
|
| 30 | 0.46 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 WHERE t0.leave_id = ?
Parameters:
[
5925
]
|
| 31 | 0.42 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = ?
Parameters:
[
5927
]
|
| 32 | 0.41 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 WHERE t0.leave_id = ?
Parameters:
[
5927
]
|
| 33 | 0.44 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = ?
Parameters:
[
5928
]
|
| 34 | 0.41 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 WHERE t0.leave_id = ?
Parameters:
[
5928
]
|
| 35 | 0.44 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = ?
Parameters:
[
5934
]
|
| 36 | 0.43 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 WHERE t0.leave_id = ?
Parameters:
[
5934
]
|
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\Leave\Leaves | 57 |
| App\Entity\Employee\Employee | 19 |
| App\Entity\Employee\Invite | 18 |
| App\Entity\Employee\Notification | 13 |
| App\Entity\Group\Team | 7 |
| 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\Certificates\Certificates | No errors. |
| App\Entity\Group\Agency | No errors. |