Query Metrics
6
Database Queries
6
Different statements
1.97 ms
Query time
0
Invalid entities
26
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.67 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.directory_path AS directory_path_6, t0.one_time_code AS one_time_code_7, t0.role AS role_8, t0.expiration_one_time_code AS expiration_one_time_code_9, t0.office_hours AS office_hours_10, t0.is_active AS is_active_11, t0.is_admin_active AS is_admin_active_12, t0.is_email_notification_active AS is_email_notification_active_13, t0.is_alert_read AS is_alert_read_14, t0.is_gdpr_sent AS is_gdpr_sent_15, t16.id AS id_17, t16.datetime_last_update AS datetime_last_update_18, t16.is_terms_accepted AS is_terms_accepted_19, t16.is_news_accepted AS is_news_accepted_20, t16.user_id AS user_id_21, t22.id AS id_23, t22.country_code AS country_code_24, t22.phone AS phone_25, t22.fax AS fax_26, t22.mobile AS mobile_27, t22.address AS address_28, t22.zip AS zip_29, t22.other_city AS other_city_30, t22.other_province AS other_province_31, t22.avatar AS avatar_32, t22.emergency_contact_1 AS emergency_contact_1_33, t22.emergency_contact_2 AS emergency_contact_2_34, t22.user_id AS user_id_35, t22.city_id AS city_id_36, t22.user_profession_id AS user_profession_id_37, t38.id AS id_39, t38.residue_rol AS residue_rol_40, t38.residue_holiday AS residue_holiday_41, t38.datetime_start_work AS datetime_start_work_42, t38.datetime_end_work AS datetime_end_work_43, t38.show_in_list AS show_in_list_44, t38.is_kam AS is_kam_45, t38.is_show_in_export_presences AS is_show_in_export_presences_46, t38.is_show_in_export_refunds AS is_show_in_export_refunds_47, t38.is_document_product_notify AS is_document_product_notify_48, t38.contract_type AS contract_type_49, t38.work_hours AS work_hours_50, t38.user_id AS user_id_51, t38.supervisor_id AS supervisor_id_52, t0.account_type_id AS account_type_id_53 FROM til_user t0 LEFT JOIN til_user_privacy t16 ON t16.user_id = t0.id LEFT JOIN til_user_profile t22 ON t22.user_id = t0.id LEFT JOIN til_employee t38 ON t38.user_id = t0.id WHERE t0.id = ?
Parameters:
[
"1844"
]
|
2 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.value AS value_2, t0_.notes AS notes_3, t0_.datetime_send AS datetime_send_4, t0_.datetime_supervisor AS datetime_supervisor_5, t0_.datetime_administration AS datetime_administration_6, t0_.is_holiday_counter_active AS is_holiday_counter_active_7, t0_.is_rol_counter_active AS is_rol_counter_active_8, t0_.employee_presence_year_id AS employee_presence_year_id_9 FROM til_employee_presence_month t0_ LEFT JOIN til_employee_presence_year t1_ ON t0_.employee_presence_year_id = t1_.id LEFT JOIN til_employee t2_ ON t1_.employee_id = t2_.id WHERE t2_.id = ? AND t0_.value = ? AND t1_.value = ?
Parameters:
[ "26" "09" "2025" ] |
3 | 0.24 ms |
SELECT t0_.id AS id_0, t0_.motivation AS motivation_1, t0_.datetime AS datetime_2, t0_.is_weekend AS is_weekend_3 FROM til_closure t0_ WHERE YEAR(t0_.datetime) = ? AND MONTH(t0_.datetime) = ?
Parameters:
[ "2025" "09" ] |
4 | 0.16 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.employee_id AS employee_id_3 FROM til_employee_presence_year t0 WHERE t0.id = ?
Parameters:
[
"98"
]
|
5 | 0.27 ms |
SELECT t0.id AS id_1, t0.year AS year_2, t0.rol AS rol_3, t0.holiday AS holiday_4, t0.employee_id AS employee_id_5 FROM til_employee_holiday_year t0 WHERE t0.employee_id = ?
Parameters:
[
"26"
]
|
6 | 0.31 ms |
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.job_hours AS job_hours_3, t0.holiday AS holiday_4, t0.rol AS rol_5, t0.permission AS permission_6, t0.is_business_trip AS is_business_trip_7, t0.is_illness AS is_illness_8, t0.illness_code AS illness_code_9, t0.overtime_work AS overtime_work_10, t0.is_closure AS is_closure_11, t0.notes AS notes_12, t0.employee_presence_month_id AS employee_presence_month_id_13 FROM til_employee_presence_day t0 WHERE t0.employee_presence_month_id = ?
Parameters:
[
"961"
]
|
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\EmployeePresenceDay | 9 |
App\Entity\Closure | 8 |
App\Entity\Employee | 2 |
App\Entity\User | 1 |
App\Entity\UserAccountType | 1 |
App\Entity\UserPrivacy | 1 |
App\Entity\UserProfile | 1 |
App\Entity\UserProfession | 1 |
App\Entity\EmployeePresenceMonth | 1 |
App\Entity\EmployeePresenceYear | 1 |