Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.account_id AS account_id_2,
  t0.expires_in AS expires_in_3,
  t0.token AS token_4,
  t0.created_at AS created_at_5
FROM
  access_token t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.expires_in AS expires_in_3, t0.token AS token_4, t0.created_at AS created_at_5 FROM access_token t0 WHERE t0.token = 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3ODM1Mjk2ODUsImV4cCI6MTc4NDgyNTY4NSwicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJhZG1pbkBjb3p5LmNvbSJ9.qEYjR9LxlQhyyqLIvM9Q4_HGNIrN7AHuKRJVvCo8aLpzAF9lgJpqmwpQ1BojSPW1rkYvYTlaPEVN-UYwIj1qla0EM2mB7kok_H4gFBoGyy0yhMkibS9bQHVBapReHaIHzyfozw48vhx4Uu0jX4cZISyM3UthupIzi5R8A82wiq2lmyQRWsSidmjN3x1dlI3XEXJhOOsijwfd9hoeoTpjBx1vK6Q4OpZlzMmbugHr3cp4dMrhlM4q6wgM1wWINlKuJQQGJo4vMOFk-muAXl-72BFvM86RM1gKhnzaiwNUBMpd0OFf79qwfDTBaU3qXQc0xD8MCzBwZ10MYr5pYUMyOQ' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.full_name AS full_name_3,
  t0.password AS password_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.contact_info AS contact_info_7,
  t0.timezone AS timezone_8,
  t0.current_company_id AS current_company_id_9,
  t0.current_team_id AS current_team_id_10
FROM
  account t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.full_name AS full_name_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.contact_info AS contact_info_7, t0.timezone AS timezone_8, t0.current_company_id AS current_company_id_9, t0.current_team_id AS current_team_id_10 FROM account t0 WHERE t0.id = 450 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.full_name AS full_name_3,
  t0.password AS password_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.contact_info AS contact_info_7,
  t0.timezone AS timezone_8,
  t0.current_company_id AS current_company_id_9,
  t0.current_team_id AS current_team_id_10
FROM
  account t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.full_name AS full_name_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.contact_info AS contact_info_7, t0.timezone AS timezone_8, t0.current_company_id AS current_company_id_9, t0.current_team_id AS current_team_id_10 FROM account t0 WHERE t0.id = 450 LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.role AS role_1,
  a0_.scope AS scope_2,
  a0_.is_active AS is_active_3,
  a0_.created_at AS created_at_4,
  a0_.account_id AS account_id_5,
  a0_.company_id AS company_id_6,
  a0_.team_id AS team_id_7
FROM
  account_role a0_
WHERE
  a0_.account_id = ?
  AND a0_.is_active = true

SELECT a0_.id AS id_0, a0_.role AS role_1, a0_.scope AS scope_2, a0_.is_active AS is_active_3, a0_.created_at AS created_at_4, a0_.account_id AS account_id_5, a0_.company_id AS company_id_6, a0_.team_id AS team_id_7 FROM account_role a0_ WHERE a0_.account_id = 450 AND a0_.is_active = true;

SELECT
  t0.id AS id_1,
  t0.order_id AS order_id_2,
  t0.todo_date AS todo_date_3,
  t0.status AS status_4,
  t0.priority AS priority_5,
  t0.assignee_id AS assignee_id_6,
  t0.created_at AS created_at_7,
  t0.company_id AS company_id_8,
  t0.listing_id AS listing_id_9,
  t0.related_task_id AS related_task_id_10,
  t0.reported_by AS reported_by_11,
  t0.team_id AS team_id_12,
  t0.started_at AS started_at_13,
  t0.completed_at AS completed_at_14,
  t0.completed_by AS completed_by_15,
  t0.estimated_duration AS estimated_duration_16,
  t0.actual_duration AS actual_duration_17,
  t0.updated_at AS updated_at_18,
  t0.inspection_status AS inspection_status_19,
  t0.inspected_by AS inspected_by_20,
  t0.inspected_at AS inspected_at_21,
  t0.source_issue_id AS source_issue_id_22,
  t0.cancelled_at AS cancelled_at_23,
  t0.due_at AS due_at_24,
  t0.unit_price AS unit_price_25,
  t0.is_deleted AS is_deleted_26,
  t0.type,
  t0.checkout_time AS checkout_time_27,
  t0.guest_name AS guest_name_28,
  t0.number_of_guests AS number_of_guests_29,
  t0.next_checkin_time AS next_checkin_time_30,
  t0.damage_check_completed AS damage_check_completed_31,
  t0.checkin_time AS checkin_time_32,
  t0.guest_name AS guest_name_33,
  t0.number_of_guests AS number_of_guests_34,
  t0.maintenance_type AS maintenance_type_35,
  t0.actual_cost AS actual_cost_36,
  t0.vendor_name AS vendor_name_37,
  t0.vendor_phone AS vendor_phone_38
FROM
  task t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING',
    'MAINTENANCE'
  )

SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.todo_date AS todo_date_3, t0.status AS status_4, t0.priority AS priority_5, t0.assignee_id AS assignee_id_6, t0.created_at AS created_at_7, t0.company_id AS company_id_8, t0.listing_id AS listing_id_9, t0.related_task_id AS related_task_id_10, t0.reported_by AS reported_by_11, t0.team_id AS team_id_12, t0.started_at AS started_at_13, t0.completed_at AS completed_at_14, t0.completed_by AS completed_by_15, t0.estimated_duration AS estimated_duration_16, t0.actual_duration AS actual_duration_17, t0.updated_at AS updated_at_18, t0.inspection_status AS inspection_status_19, t0.inspected_by AS inspected_by_20, t0.inspected_at AS inspected_at_21, t0.source_issue_id AS source_issue_id_22, t0.cancelled_at AS cancelled_at_23, t0.due_at AS due_at_24, t0.unit_price AS unit_price_25, t0.is_deleted AS is_deleted_26, t0.type, t0.checkout_time AS checkout_time_27, t0.guest_name AS guest_name_28, t0.number_of_guests AS number_of_guests_29, t0.next_checkin_time AS next_checkin_time_30, t0.damage_check_completed AS damage_check_completed_31, t0.checkin_time AS checkin_time_32, t0.guest_name AS guest_name_33, t0.number_of_guests AS number_of_guests_34, t0.maintenance_type AS maintenance_type_35, t0.actual_cost AS actual_cost_36, t0.vendor_name AS vendor_name_37, t0.vendor_phone AS vendor_phone_38 FROM task t0 WHERE t0.id = 105807 AND t0.type IN ('CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING', 'MAINTENANCE');

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.phone_number AS phone_number_3,
  t0.email AS email_4,
  t0.created_at AS created_at_5,
  t0.cleaning_rules AS cleaning_rules_6
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.phone_number AS phone_number_3, t0.email AS email_4, t0.created_at AS created_at_5, t0.cleaning_rules AS cleaning_rules_6 FROM company t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.team_name AS team_name_2,
  t0.phone_number AS phone_number_3,
  t0.email AS email_4,
  t0.cleaning_rules AS cleaning_rules_5,
  t0.company_id AS company_id_6,
  t0.created_at AS created_at_7
FROM
  team t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.team_name AS team_name_2, t0.phone_number AS phone_number_3, t0.email AS email_4, t0.cleaning_rules AS cleaning_rules_5, t0.company_id AS company_id_6, t0.created_at AS created_at_7 FROM team t0 WHERE t0.id = 17;

SELECT
  DISTINCT a0_.account_id AS sclr_0
FROM
  account_role a0_
WHERE
  a0_.team_id = ?
  AND a0_.is_active = true

SELECT DISTINCT a0_.account_id AS sclr_0 FROM account_role a0_ WHERE a0_.team_id = 17 AND a0_.is_active = true;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.full_name AS full_name_3,
  t0.password AS password_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.contact_info AS contact_info_7,
  t0.timezone AS timezone_8,
  t0.current_company_id AS current_company_id_9,
  t0.current_team_id AS current_team_id_10
FROM
  account t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.email AS email_2, t0.full_name AS full_name_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.contact_info AS contact_info_7, t0.timezone AS timezone_8, t0.current_company_id AS current_company_id_9, t0.current_team_id AS current_team_id_10 FROM account t0 WHERE t0.id IN (189, 235, 239, 420, 273, 188, 46, 286, 304, 240, 52, 53, 301, 419, 275, 308, 174, 278, 381, 187, 248, 293, 309, 237, 409, 262, 292, 30, 234, 403, 236, 271, 13, 265, 5, 414, 18, 2, 249, 307, 388);

SELECT
  NEXTVAL('task_audit_log_id_seq')

SELECT NEXTVAL('task_audit_log_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO task_audit_log (
  id, action, old_value, new_value, metadata,
  performed_by_id, created_at, ip_address,
  task_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO task_audit_log (id, action, old_value, new_value, metadata, performed_by_id, created_at, ip_address, task_id) VALUES (78, 'ASSIGNED', NULL, '5', '{\"assigneeName\":\"Toby Zeng\"}', 450, '2026-07-08 10:36:13', NULL, 105807);

UPDATE
  task
SET
  status = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE task SET status = 'ASSIGNED', updated_at = '2026-07-08 10:36:13' WHERE id = 105807;

"COMMIT"

"COMMIT";

SELECT
  NEXTVAL('task_note_id_seq')

SELECT NEXTVAL('task_note_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO task_note (
  id, content, created_by_id, created_at,
  updated_at, is_deleted, task_id,
  audit_log_id, note_type
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO task_note (id, content, created_by_id, created_at, updated_at, is_deleted, task_id, audit_log_id, note_type) VALUES (5034, 'dsadsad', 450, '2026-07-08 10:36:13', NULL, 0, 105807, 78, 'AUDIT_LOG');

"COMMIT"

"COMMIT";

SELECT
  a0_.id AS id_0,
  a0_.email AS email_1,
  a0_.full_name AS full_name_2,
  a0_.password AS password_3,
  a0_.is_active AS is_active_4,
  a0_.created_at AS created_at_5,
  a0_.contact_info AS contact_info_6,
  a0_.timezone AS timezone_7,
  a0_.current_company_id AS current_company_id_8,
  a0_.current_team_id AS current_team_id_9
FROM
  account a0_
WHERE
  a0_.id IN (?)

SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.full_name AS full_name_2, a0_.password AS password_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.contact_info AS contact_info_6, a0_.timezone AS timezone_7, a0_.current_company_id AS current_company_id_8, a0_.current_team_id AS current_team_id_9 FROM account a0_ WHERE a0_.id IN (5);