Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.avatar AS avatar_7,
  t0.job_position AS job_position_8,
  t0.mailbox_view_mode AS mailbox_view_mode_9,
  t0.timezone AS timezone_10,
  t0.created_at AS created_at_11,
  t0.activation_token AS activation_token_12,
  t0.activation_token_expires_at AS activation_token_expires_at_13,
  t0.reset_token AS reset_token_14,
  t0.reset_token_expires_at AS reset_token_expires_at_15,
  t0.is_active AS is_active_16,
  t0.employment_end_date AS employment_end_date_17,
  t0.deactivated_at AS deactivated_at_18,
  t0.notifications_read_at AS notifications_read_at_19,
  t0.dashboard_layout AS dashboard_layout_20,
  t0.last_seen_at AS last_seen_at_21,
  t0.totp_secret AS totp_secret_22,
  t0.totp_enabled AS totp_enabled_23,
  t0.totp_enabled_at AS totp_enabled_at_24,
  t0.sip_extension AS sip_extension_25,
  t0.voip_enabled AS voip_enabled_26,
  t0.can_call_external AS can_call_external_27,
  t0.sip_secret_encrypted AS sip_secret_encrypted_28,
  t0.mailbox_limit AS mailbox_limit_29,
  t0.mail_storage_quota_mb AS mail_storage_quota_mb_30,
  t0.quota_suspended_at AS quota_suspended_at_31,
  t0.quota_locked AS quota_locked_32,
  t0.company_id AS company_id_33
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.avatar AS avatar_7, t0.job_position AS job_position_8, t0.mailbox_view_mode AS mailbox_view_mode_9, t0.timezone AS timezone_10, t0.created_at AS created_at_11, t0.activation_token AS activation_token_12, t0.activation_token_expires_at AS activation_token_expires_at_13, t0.reset_token AS reset_token_14, t0.reset_token_expires_at AS reset_token_expires_at_15, t0.is_active AS is_active_16, t0.employment_end_date AS employment_end_date_17, t0.deactivated_at AS deactivated_at_18, t0.notifications_read_at AS notifications_read_at_19, t0.dashboard_layout AS dashboard_layout_20, t0.last_seen_at AS last_seen_at_21, t0.totp_secret AS totp_secret_22, t0.totp_enabled AS totp_enabled_23, t0.totp_enabled_at AS totp_enabled_at_24, t0.sip_extension AS sip_extension_25, t0.voip_enabled AS voip_enabled_26, t0.can_call_external AS can_call_external_27, t0.sip_secret_encrypted AS sip_secret_encrypted_28, t0.mailbox_limit AS mailbox_limit_29, t0.mail_storage_quota_mb AS mail_storage_quota_mb_30, t0.quota_suspended_at AS quota_suspended_at_31, t0.quota_locked AS quota_locked_32, t0.company_id AS company_id_33 FROM `user` t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.platform_role AS platform_role_3,
  t0.permission_overrides AS permission_overrides_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.tenant_id AS tenant_id_7
FROM
  user_tenant t0
WHERE
  t0.user_id = ?
  AND t0.tenant_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.platform_role AS platform_role_3, t0.permission_overrides AS permission_overrides_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.tenant_id AS tenant_id_7 FROM user_tenant t0 WHERE t0.user_id = 9 AND t0.tenant_id = 3 LIMIT 1;

SELECT
  h0_.id AS id_0,
  h0_.schedule_mode AS schedule_mode_1,
  h0_.overtime_mode AS overtime_mode_2,
  h0_.overtime_threshold_minutes AS overtime_threshold_minutes_3,
  h0_.closure_reminder_minutes AS closure_reminder_minutes_4,
  h0_.closure_cutoff_mode AS closure_cutoff_mode_5,
  h0_.closure_cutoff_hours AS closure_cutoff_hours_6,
  h0_.entrance_tolerance_minutes AS entrance_tolerance_minutes_7,
  h0_.exit_tolerance_minutes AS exit_tolerance_minutes_8,
  h0_.annual_vacation_days AS annual_vacation_days_9,
  h0_.vacation_accrual_mode AS vacation_accrual_mode_10,
  h0_.vacation_carry_enabled AS vacation_carry_enabled_11,
  h0_.vacation_carry_max_days AS vacation_carry_max_days_12,
  h0_.updated_at AS updated_at_13,
  h0_.tenant_id AS tenant_id_14
FROM
  hr_tenant_policy h0_
WHERE
  h0_.tenant_id = ?
LIMIT
  1

SELECT h0_.id AS id_0, h0_.schedule_mode AS schedule_mode_1, h0_.overtime_mode AS overtime_mode_2, h0_.overtime_threshold_minutes AS overtime_threshold_minutes_3, h0_.closure_reminder_minutes AS closure_reminder_minutes_4, h0_.closure_cutoff_mode AS closure_cutoff_mode_5, h0_.closure_cutoff_hours AS closure_cutoff_hours_6, h0_.entrance_tolerance_minutes AS entrance_tolerance_minutes_7, h0_.exit_tolerance_minutes AS exit_tolerance_minutes_8, h0_.annual_vacation_days AS annual_vacation_days_9, h0_.vacation_accrual_mode AS vacation_accrual_mode_10, h0_.vacation_carry_enabled AS vacation_carry_enabled_11, h0_.vacation_carry_max_days AS vacation_carry_max_days_12, h0_.updated_at AS updated_at_13, h0_.tenant_id AS tenant_id_14 FROM hr_tenant_policy h0_ WHERE h0_.tenant_id = 3 LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.type AS type_1,
  a0_.punched_at AS punched_at_2,
  a0_.work_date AS work_date_3,
  a0_.created_at AS created_at_4,
  a0_.user_id AS user_id_5,
  a0_.tenant_id AS tenant_id_6
FROM
  attendance_punch a0_
WHERE
  a0_.user_id = ?
  AND a0_.work_date = ?
  AND a0_.tenant_id = ?
ORDER BY
  a0_.punched_at ASC,
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.punched_at AS punched_at_2, a0_.work_date AS work_date_3, a0_.created_at AS created_at_4, a0_.user_id AS user_id_5, a0_.tenant_id AS tenant_id_6 FROM attendance_punch a0_ WHERE a0_.user_id = 9 AND a0_.work_date = '2026-09-15' AND a0_.tenant_id = 3 ORDER BY a0_.punched_at ASC, a0_.id ASC;

SELECT
  u0_.id AS id_0,
  u0_.is_default AS is_default_1,
  u0_.platform_role AS platform_role_2,
  u0_.permission_overrides AS permission_overrides_3,
  u0_.created_at AS created_at_4,
  t1_.id AS id_5,
  t1_.name AS name_6,
  t1_.slug AS slug_7,
  t1_.is_active AS is_active_8,
  t1_.is_platform AS is_platform_9,
  t1_.created_at AS created_at_10,
  t1_.user_slots_pool AS user_slots_pool_11,
  t1_.mailbox_slots_pool AS mailbox_slots_pool_12,
  t1_.microsoft_oauth_enabled AS microsoft_oauth_enabled_13,
  t1_.microsoft_oauth_tenant_id AS microsoft_oauth_tenant_id_14,
  t1_.microsoft_oauth_client_id AS microsoft_oauth_client_id_15,
  t1_.microsoft_oauth_client_secret AS microsoft_oauth_client_secret_16,
  t1_.microsoft_oauth_redirect_uri AS microsoft_oauth_redirect_uri_17,
  u0_.user_id AS user_id_18,
  u0_.tenant_id AS tenant_id_19
FROM
  user_tenant u0_
  INNER JOIN tenant t1_ ON u0_.tenant_id = t1_.id
WHERE
  u0_.user_id = ?
  AND t1_.is_active = 1
ORDER BY
  u0_.is_default DESC,
  t1_.name ASC

SELECT u0_.id AS id_0, u0_.is_default AS is_default_1, u0_.platform_role AS platform_role_2, u0_.permission_overrides AS permission_overrides_3, u0_.created_at AS created_at_4, t1_.id AS id_5, t1_.name AS name_6, t1_.slug AS slug_7, t1_.is_active AS is_active_8, t1_.is_platform AS is_platform_9, t1_.created_at AS created_at_10, t1_.user_slots_pool AS user_slots_pool_11, t1_.mailbox_slots_pool AS mailbox_slots_pool_12, t1_.microsoft_oauth_enabled AS microsoft_oauth_enabled_13, t1_.microsoft_oauth_tenant_id AS microsoft_oauth_tenant_id_14, t1_.microsoft_oauth_client_id AS microsoft_oauth_client_id_15, t1_.microsoft_oauth_client_secret AS microsoft_oauth_client_secret_16, t1_.microsoft_oauth_redirect_uri AS microsoft_oauth_redirect_uri_17, u0_.user_id AS user_id_18, u0_.tenant_id AS tenant_id_19 FROM user_tenant u0_ INNER JOIN tenant t1_ ON u0_.tenant_id = t1_.id WHERE u0_.user_id = 9 AND t1_.is_active = 1 ORDER BY u0_.is_default DESC, t1_.name ASC;

SELECT
  h0_.id AS id_0,
  h0_.work_date AS work_date_1,
  h0_.status AS status_2,
  h0_.expected_end_at AS expected_end_at_3,
  h0_.proposed_clock_out_at AS proposed_clock_out_at_4,
  h0_.reminder_sent_at AS reminder_sent_at_5,
  h0_.anomaly_detected_at AS anomaly_detected_at_6,
  h0_.confirmed_at AS confirmed_at_7,
  h0_.resolved_at AS resolved_at_8,
  h0_.notes AS notes_9,
  h0_.created_at AS created_at_10,
  h0_.updated_at AS updated_at_11,
  h0_.tenant_id AS tenant_id_12,
  h0_.user_id AS user_id_13
FROM
  hr_day_closure_proposal h0_
WHERE
  h0_.user_id = ?
  AND h0_.work_date = ?
  AND h0_.tenant_id = ?
LIMIT
  1

SELECT h0_.id AS id_0, h0_.work_date AS work_date_1, h0_.status AS status_2, h0_.expected_end_at AS expected_end_at_3, h0_.proposed_clock_out_at AS proposed_clock_out_at_4, h0_.reminder_sent_at AS reminder_sent_at_5, h0_.anomaly_detected_at AS anomaly_detected_at_6, h0_.confirmed_at AS confirmed_at_7, h0_.resolved_at AS resolved_at_8, h0_.notes AS notes_9, h0_.created_at AS created_at_10, h0_.updated_at AS updated_at_11, h0_.tenant_id AS tenant_id_12, h0_.user_id AS user_id_13 FROM hr_day_closure_proposal h0_ WHERE h0_.user_id = 9 AND h0_.work_date = '2026-09-15' AND h0_.tenant_id = 3 LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.status AS status_1,
  t0_.billing_period AS billing_period_2,
  t0_.started_at AS started_at_3,
  t0_.ends_at AS ends_at_4,
  t0_.notes AS notes_5,
  s1_.id AS id_6,
  s1_.name AS name_7,
  s1_.slug AS slug_8,
  s1_.description AS description_9,
  s1_.is_active AS is_active_10,
  s1_.sort_order AS sort_order_11,
  s1_.monthly_price_cents AS monthly_price_cents_12,
  s1_.max_users AS max_users_13,
  s1_.max_widget_sites AS max_widget_sites_14,
  s1_.projects_enabled AS projects_enabled_15,
  s1_.widget_enabled AS widget_enabled_16,
  s1_.voip_enabled AS voip_enabled_17,
  s1_.tickets_enabled AS tickets_enabled_18,
  s1_.internal_chat_enabled AS internal_chat_enabled_19,
  s1_.projects_price_cents AS projects_price_cents_20,
  s1_.widget_price_cents AS widget_price_cents_21,
  s1_.ticket_price_cents AS ticket_price_cents_22,
  s1_.internal_chat_price_cents AS internal_chat_price_cents_23,
  s1_.voip_price_cents AS voip_price_cents_24,
  s1_.billing_discount_percent_3_months AS billing_discount_percent_3_months_25,
  s1_.billing_discount_percent_6_months AS billing_discount_percent_6_months_26,
  s1_.billing_discount_percent_12_months AS billing_discount_percent_12_months_27,
  s1_.created_at AS created_at_28,
  t0_.tenant_id AS tenant_id_29,
  t0_.package_id AS package_id_30
FROM
  tenant_subscription t0_
  INNER JOIN service_package s1_ ON t0_.package_id = s1_.id
WHERE
  t0_.tenant_id = ?
  AND t0_.status = ?
ORDER BY
  t0_.started_at DESC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.billing_period AS billing_period_2, t0_.started_at AS started_at_3, t0_.ends_at AS ends_at_4, t0_.notes AS notes_5, s1_.id AS id_6, s1_.name AS name_7, s1_.slug AS slug_8, s1_.description AS description_9, s1_.is_active AS is_active_10, s1_.sort_order AS sort_order_11, s1_.monthly_price_cents AS monthly_price_cents_12, s1_.max_users AS max_users_13, s1_.max_widget_sites AS max_widget_sites_14, s1_.projects_enabled AS projects_enabled_15, s1_.widget_enabled AS widget_enabled_16, s1_.voip_enabled AS voip_enabled_17, s1_.tickets_enabled AS tickets_enabled_18, s1_.internal_chat_enabled AS internal_chat_enabled_19, s1_.projects_price_cents AS projects_price_cents_20, s1_.widget_price_cents AS widget_price_cents_21, s1_.ticket_price_cents AS ticket_price_cents_22, s1_.internal_chat_price_cents AS internal_chat_price_cents_23, s1_.voip_price_cents AS voip_price_cents_24, s1_.billing_discount_percent_3_months AS billing_discount_percent_3_months_25, s1_.billing_discount_percent_6_months AS billing_discount_percent_6_months_26, s1_.billing_discount_percent_12_months AS billing_discount_percent_12_months_27, s1_.created_at AS created_at_28, t0_.tenant_id AS tenant_id_29, t0_.package_id AS package_id_30 FROM tenant_subscription t0_ INNER JOIN service_package s1_ ON t0_.package_id = s1_.id WHERE t0_.tenant_id = 3 AND t0_.status = 'active' ORDER BY t0_.started_at DESC LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.valid_from AS valid_from_1,
  u0_.valid_to AS valid_to_2,
  u0_.created_at AS created_at_3,
  u0_.tenant_id AS tenant_id_4,
  u0_.user_id AS user_id_5,
  u0_.profile_id AS profile_id_6
FROM
  user_work_schedule_assignment u0_
WHERE
  u0_.user_id = ?
  AND u0_.valid_from <= ?
  AND (
    u0_.valid_to IS NULL
    OR u0_.valid_to >= ?
  )
  AND u0_.tenant_id = ?
ORDER BY
  u0_.valid_from DESC
LIMIT
  1

SELECT u0_.id AS id_0, u0_.valid_from AS valid_from_1, u0_.valid_to AS valid_to_2, u0_.created_at AS created_at_3, u0_.tenant_id AS tenant_id_4, u0_.user_id AS user_id_5, u0_.profile_id AS profile_id_6 FROM user_work_schedule_assignment u0_ WHERE u0_.user_id = 9 AND u0_.valid_from <= '2026-09-15' AND (u0_.valid_to IS NULL OR u0_.valid_to >= '2026-09-15') AND u0_.tenant_id = 3 ORDER BY u0_.valid_from DESC LIMIT 1;

SELECT
  h0_.id AS id_0,
  h0_.type AS type_1,
  h0_.duration AS duration_2,
  h0_.start_date AS start_date_3,
  h0_.end_date AS end_date_4,
  h0_.hours_minutes AS hours_minutes_5,
  h0_.start_time AS start_time_6,
  h0_.end_time AS end_time_7,
  h0_.status AS status_8,
  h0_.reason AS reason_9,
  h0_.decided_at AS decided_at_10,
  h0_.decision_note AS decision_note_11,
  h0_.cancellation_reason AS cancellation_reason_12,
  h0_.cancellation_requested_at AS cancellation_requested_at_13,
  h0_.created_at AS created_at_14,
  h0_.updated_at AS updated_at_15,
  h0_.tenant_id AS tenant_id_16,
  h0_.user_id AS user_id_17,
  h0_.decided_by_id AS decided_by_id_18
FROM
  hr_leave_request h0_
WHERE
  h0_.user_id = ?
  AND h0_.status IN (?, ?)
  AND h0_.start_date <= ?
  AND h0_.end_date >= ?
  AND h0_.tenant_id = ?
ORDER BY
  h0_.id ASC

SELECT h0_.id AS id_0, h0_.type AS type_1, h0_.duration AS duration_2, h0_.start_date AS start_date_3, h0_.end_date AS end_date_4, h0_.hours_minutes AS hours_minutes_5, h0_.start_time AS start_time_6, h0_.end_time AS end_time_7, h0_.status AS status_8, h0_.reason AS reason_9, h0_.decided_at AS decided_at_10, h0_.decision_note AS decision_note_11, h0_.cancellation_reason AS cancellation_reason_12, h0_.cancellation_requested_at AS cancellation_requested_at_13, h0_.created_at AS created_at_14, h0_.updated_at AS updated_at_15, h0_.tenant_id AS tenant_id_16, h0_.user_id AS user_id_17, h0_.decided_by_id AS decided_by_id_18 FROM hr_leave_request h0_ WHERE h0_.user_id = 9 AND h0_.status IN ('approved', 'cancel_requested') AND h0_.start_date <= '2026-09-15' AND h0_.end_date >= '2026-09-15' AND h0_.tenant_id = 3 ORDER BY h0_.id ASC;

SELECT
  h0_.id AS id_0,
  h0_.work_date AS work_date_1,
  h0_.status AS status_2,
  h0_.expected_end_at AS expected_end_at_3,
  h0_.proposed_clock_out_at AS proposed_clock_out_at_4,
  h0_.reminder_sent_at AS reminder_sent_at_5,
  h0_.anomaly_detected_at AS anomaly_detected_at_6,
  h0_.confirmed_at AS confirmed_at_7,
  h0_.resolved_at AS resolved_at_8,
  h0_.notes AS notes_9,
  h0_.created_at AS created_at_10,
  h0_.updated_at AS updated_at_11,
  h0_.tenant_id AS tenant_id_12,
  h0_.user_id AS user_id_13
FROM
  hr_day_closure_proposal h0_
WHERE
  h0_.user_id = ?
  AND h0_.status IN (?, ?)
  AND h0_.tenant_id = ?
ORDER BY
  h0_.work_date DESC

SELECT h0_.id AS id_0, h0_.work_date AS work_date_1, h0_.status AS status_2, h0_.expected_end_at AS expected_end_at_3, h0_.proposed_clock_out_at AS proposed_clock_out_at_4, h0_.reminder_sent_at AS reminder_sent_at_5, h0_.anomaly_detected_at AS anomaly_detected_at_6, h0_.confirmed_at AS confirmed_at_7, h0_.resolved_at AS resolved_at_8, h0_.notes AS notes_9, h0_.created_at AS created_at_10, h0_.updated_at AS updated_at_11, h0_.tenant_id AS tenant_id_12, h0_.user_id AS user_id_13 FROM hr_day_closure_proposal h0_ WHERE h0_.user_id = 9 AND h0_.status IN ('proposed', 'anomaly') AND h0_.tenant_id = 3 ORDER BY h0_.work_date DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.week_definition AS week_definition_3,
  t0.is_active AS is_active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.tenant_id AS tenant_id_7
FROM
  work_schedule_profile t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.week_definition AS week_definition_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.tenant_id AS tenant_id_7 FROM work_schedule_profile t0 WHERE t0.id = 1;