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.eyJpYXQiOjE3ODI3NTIyOTYsImV4cCI6MTc4NDA0ODI5Niwicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJhZG1pbkBjb3p5LmNvbSJ9.qSTKoTNc8tjfaSxVorvq3YNfRe3cGmuK2y6DVgULKiLNg4eltpQHT3JpSwjROa6mlxq_dS7TzxeGcFrlJvv7AeD-O0xfikwgSshFO-_792g2FEkMWdYxYfUilWuow_XpaXWkS8ywau_1WO5_GWqXulQn5XW8aKcM75wDjSW7qvSWKZmehoLi7Q3Ljx2H4oPzozhCDq0IjRA7yDoNEJl3lmgy5Y2qRDd0pzY7lFf0kyEbidtlepJY1vuJVowkgSYH4Qc8nxh-_kGZHT-Fpc_cyfPTj7mCBclkE137NjsQpfQnFVHhY4kh_3I-o1d7Svtc22QVVksXcDUUGWGb8s-XZA' 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.address AS address_2,
  t0.nickname AS nickname_3,
  t0.price AS price_4,
  t0.pet_fee AS pet_fee_5,
  t0.deposit_fee AS deposit_fee_6,
  t0.cleaning_fee AS cleaning_fee_7,
  t0.room_type AS room_type_8,
  t0.house_rules AS house_rules_9,
  t0.minimal_stay AS minimal_stay_10,
  t0.maximum_stay AS maximum_stay_11,
  t0.accommodates AS accommodates_12,
  t0.room_area AS room_area_13,
  t0.number_of_beds AS number_of_beds_14,
  t0.number_of_rooms AS number_of_rooms_15,
  t0.number_of_bathrooms AS number_of_bathrooms_16,
  t0.access_code AS access_code_17,
  t0.timezone AS timezone_18,
  t0.company_id AS company_id_19,
  t0.assignee_id AS assignee_id_20,
  t0.team_id AS team_id_21,
  t0.is_active AS is_active_22,
  t0.need_key AS need_key_23,
  t0.city AS city_24,
  t0.latitude AS latitude_25,
  t0.longitude AS longitude_26,
  t0.has_living_room AS has_living_room_27,
  t0.has_kitchen AS has_kitchen_28,
  t0.has_garbage_bin AS has_garbage_bin_29,
  t0.new_cleaning_fee AS new_cleaning_fee_30,
  t0.cleaning_fee_effective_date AS cleaning_fee_effective_date_31,
  t0.created_at AS created_at_32
FROM
  property t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.address AS address_2, t0.nickname AS nickname_3, t0.price AS price_4, t0.pet_fee AS pet_fee_5, t0.deposit_fee AS deposit_fee_6, t0.cleaning_fee AS cleaning_fee_7, t0.room_type AS room_type_8, t0.house_rules AS house_rules_9, t0.minimal_stay AS minimal_stay_10, t0.maximum_stay AS maximum_stay_11, t0.accommodates AS accommodates_12, t0.room_area AS room_area_13, t0.number_of_beds AS number_of_beds_14, t0.number_of_rooms AS number_of_rooms_15, t0.number_of_bathrooms AS number_of_bathrooms_16, t0.access_code AS access_code_17, t0.timezone AS timezone_18, t0.company_id AS company_id_19, t0.assignee_id AS assignee_id_20, t0.team_id AS team_id_21, t0.is_active AS is_active_22, t0.need_key AS need_key_23, t0.city AS city_24, t0.latitude AS latitude_25, t0.longitude AS longitude_26, t0.has_living_room AS has_living_room_27, t0.has_kitchen AS has_kitchen_28, t0.has_garbage_bin AS has_garbage_bin_29, t0.new_cleaning_fee AS new_cleaning_fee_30, t0.cleaning_fee_effective_date AS cleaning_fee_effective_date_31, t0.created_at AS created_at_32 FROM property t0 WHERE t0.id = 2267;

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 = 103976 AND t0.type IN ('CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING', 'MAINTENANCE');

SELECT
  NEXTVAL('issue_id_seq')

SELECT NEXTVAL('issue_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO issue (
  id, property_id, task_id, code, description,
  status, reported_by, created_at,
  updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO issue (id, property_id, task_id, code, description, status, reported_by, created_at, updated_at) VALUES (230, 2267, 103976, 'MAINTENANCE', '334', 'OPEN', 450, '2026-06-29 10:08:29', NULL);

"COMMIT"

"COMMIT";

SELECT
  NEXTVAL('photo_id_seq')

SELECT NEXTVAL('photo_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO photo (
  id, file_name, directory, deleted,
  created_at, category, latitude, longitude,
  captured_at, device_info, file_size,
  mime_type, related_id, passed, task_id,
  issue_id, photo_type
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

INSERT INTO photo (id, file_name, directory, deleted, created_at, category, latitude, longitude, captured_at, device_info, file_size, mime_type, related_id, passed, task_id, issue_id, photo_type) VALUES (106716, 'photos/task_103976/2026/06/29/6a42a68b951e65.30953411.png', NULL, 0, '2026-06-29 10:08:29', 'ISSUE', NULL, NULL, NULL, NULL, 1320050, NULL, 230, NULL, NULL, 230, 'issue');

"COMMIT"

"COMMIT";

SELECT
  NEXTVAL('issue_audit_log_id_seq')

SELECT NEXTVAL('issue_audit_log_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO issue_audit_log (
  id, action, old_value, new_value, metadata,
  performed_by_id, created_at, issue_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO issue_audit_log (id, action, old_value, new_value, metadata, performed_by_id, created_at, issue_id) VALUES (3, 'CREATED', NULL, NULL, NULL, 450, '2026-06-29 10:08:29', 230);

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.address AS address_1,
  p0_.nickname AS nickname_2,
  p0_.price AS price_3,
  p0_.pet_fee AS pet_fee_4,
  p0_.deposit_fee AS deposit_fee_5,
  p0_.cleaning_fee AS cleaning_fee_6,
  p0_.room_type AS room_type_7,
  p0_.house_rules AS house_rules_8,
  p0_.minimal_stay AS minimal_stay_9,
  p0_.maximum_stay AS maximum_stay_10,
  p0_.accommodates AS accommodates_11,
  p0_.room_area AS room_area_12,
  p0_.number_of_beds AS number_of_beds_13,
  p0_.number_of_rooms AS number_of_rooms_14,
  p0_.number_of_bathrooms AS number_of_bathrooms_15,
  p0_.access_code AS access_code_16,
  p0_.timezone AS timezone_17,
  p0_.company_id AS company_id_18,
  p0_.assignee_id AS assignee_id_19,
  p0_.team_id AS team_id_20,
  p0_.is_active AS is_active_21,
  p0_.need_key AS need_key_22,
  p0_.city AS city_23,
  p0_.latitude AS latitude_24,
  p0_.longitude AS longitude_25,
  p0_.has_living_room AS has_living_room_26,
  p0_.has_kitchen AS has_kitchen_27,
  p0_.has_garbage_bin AS has_garbage_bin_28,
  p0_.new_cleaning_fee AS new_cleaning_fee_29,
  p0_.cleaning_fee_effective_date AS cleaning_fee_effective_date_30,
  p0_.created_at AS created_at_31
FROM
  property p0_
WHERE
  p0_.id IN (?)

SELECT p0_.id AS id_0, p0_.address AS address_1, p0_.nickname AS nickname_2, p0_.price AS price_3, p0_.pet_fee AS pet_fee_4, p0_.deposit_fee AS deposit_fee_5, p0_.cleaning_fee AS cleaning_fee_6, p0_.room_type AS room_type_7, p0_.house_rules AS house_rules_8, p0_.minimal_stay AS minimal_stay_9, p0_.maximum_stay AS maximum_stay_10, p0_.accommodates AS accommodates_11, p0_.room_area AS room_area_12, p0_.number_of_beds AS number_of_beds_13, p0_.number_of_rooms AS number_of_rooms_14, p0_.number_of_bathrooms AS number_of_bathrooms_15, p0_.access_code AS access_code_16, p0_.timezone AS timezone_17, p0_.company_id AS company_id_18, p0_.assignee_id AS assignee_id_19, p0_.team_id AS team_id_20, p0_.is_active AS is_active_21, p0_.need_key AS need_key_22, p0_.city AS city_23, p0_.latitude AS latitude_24, p0_.longitude AS longitude_25, p0_.has_living_room AS has_living_room_26, p0_.has_kitchen AS has_kitchen_27, p0_.has_garbage_bin AS has_garbage_bin_28, p0_.new_cleaning_fee AS new_cleaning_fee_29, p0_.cleaning_fee_effective_date AS cleaning_fee_effective_date_30, p0_.created_at AS created_at_31 FROM property p0_ WHERE p0_.id IN (2267);