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.eyJpYXQiOjE3NzM5NjE5OTYsImV4cCI6MTc3NTI1Nzk5Niwicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJ0b2J5LnplbmdAY296eXN0YXkuY29tIn0.Lrvwe87SfweBUizdxWWLD36Jy4hwnbGux0a3WiXIZa-ROAfDtNwKJQxXiQhbgbzC_MYok2T5exJgM2CZ2Od0gWhXvVrR6modm1nvtUZ6vQWWdUcr0zG_4DhSWT0_ne0X7M72Zti3KfD9Z2DyEL0j6ytvjUfs0Smt-aiLOb9_31ooU9nL9blEJsdhelimK8m3IqpnlxYKp_Y2rniooqTYMFhGkk0tACDRPyaJApbMiwrXUUrs80yEHM1SCnFoDQFzZGgs5fqaKzhYVOVtuhLHR_FSlPPShSNUR--oQWNTu4gSkjBSHL780VYBEbb-igJs7i8IrRdZhLoIP3Mn8VLRzA' 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 = 5 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 = 5 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 = 5 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 = ?
  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 = 5 AND a0_.is_active = true;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  task t0_
  LEFT JOIN account a1_ ON (t0_.assignee_id = a1_.id)
  LEFT JOIN property p2_ ON (t0_.listing_id = p2_.id)
WHERE
  (
    t0_.is_deleted = false
    AND t0_.todo_date <= ?
    AND t0_.company_id = ?
    AND t0_.team_id = ?
  )
  AND t0_.type IN (
    'CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING',
    'MAINTENANCE'
  )

SELECT COUNT(t0_.id) AS sclr_0 FROM task t0_ LEFT JOIN account a1_ ON (t0_.assignee_id = a1_.id) LEFT JOIN property p2_ ON (t0_.listing_id = p2_.id) WHERE (t0_.is_deleted = false AND t0_.todo_date <= '2026-03-19 23:59:59' AND t0_.company_id = 1 AND t0_.team_id = 17) AND t0_.type IN ('CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING', 'MAINTENANCE');

SELECT
  t0_.id AS id_0,
  t0_.order_id AS order_id_1,
  t0_.todo_date AS todo_date_2,
  t0_.status AS status_3,
  t0_.priority AS priority_4,
  t0_.assignee_id AS assignee_id_5,
  t0_.created_at AS created_at_6,
  t0_.company_id AS company_id_7,
  t0_.listing_id AS listing_id_8,
  t0_.related_task_id AS related_task_id_9,
  t0_.reported_by AS reported_by_10,
  t0_.team_id AS team_id_11,
  t0_.started_at AS started_at_12,
  t0_.completed_at AS completed_at_13,
  t0_.completed_by AS completed_by_14,
  t0_.estimated_duration AS estimated_duration_15,
  t0_.actual_duration AS actual_duration_16,
  t0_.updated_at AS updated_at_17,
  t0_.inspection_status AS inspection_status_18,
  t0_.inspected_by AS inspected_by_19,
  t0_.inspected_at AS inspected_at_20,
  t0_.source_issue_id AS source_issue_id_21,
  t0_.cancelled_at AS cancelled_at_22,
  t0_.due_at AS due_at_23,
  t0_.is_deleted AS is_deleted_24,
  t0_.checkout_time AS checkout_time_25,
  t0_.guest_name AS guest_name_26,
  t0_.number_of_guests AS number_of_guests_27,
  t0_.next_checkin_time AS next_checkin_time_28,
  t0_.damage_check_completed AS damage_check_completed_29,
  t0_.checkin_time AS checkin_time_30,
  t0_.guest_name AS guest_name_31,
  t0_.number_of_guests AS number_of_guests_32,
  t0_.maintenance_type AS maintenance_type_33,
  t0_.actual_cost AS actual_cost_34,
  t0_.vendor_name AS vendor_name_35,
  t0_.vendor_phone AS vendor_phone_36,
  (
    CASE WHEN t0_.type IN ('CHECK_OUT') THEN
      0
    WHEN t0_.type IN ('ONE_TIME_CLEANING') THEN
      1
    WHEN t0_.type IN ('MAINTENANCE') THEN
      2
    WHEN t0_.type IN ('CHECK_IN') THEN
      3
    ELSE
      4
    END
  ) AS sclr_37,
  t0_.type AS type_38
FROM
  task t0_
  LEFT JOIN account a1_ ON (t0_.assignee_id = a1_.id)
  LEFT JOIN property p2_ ON (t0_.listing_id = p2_.id)
WHERE
  (
    t0_.is_deleted = false
    AND t0_.todo_date <= ?
    AND t0_.company_id = ?
    AND t0_.team_id = ?
  )
  AND t0_.type IN (
    'CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING',
    'MAINTENANCE'
  )
ORDER BY
  (t0_.todo_date):: date DESC,
  sclr_37 ASC,
  t0_.id ASC
LIMIT
  50

SELECT t0_.id AS id_0, t0_.order_id AS order_id_1, t0_.todo_date AS todo_date_2, t0_.status AS status_3, t0_.priority AS priority_4, t0_.assignee_id AS assignee_id_5, t0_.created_at AS created_at_6, t0_.company_id AS company_id_7, t0_.listing_id AS listing_id_8, t0_.related_task_id AS related_task_id_9, t0_.reported_by AS reported_by_10, t0_.team_id AS team_id_11, t0_.started_at AS started_at_12, t0_.completed_at AS completed_at_13, t0_.completed_by AS completed_by_14, t0_.estimated_duration AS estimated_duration_15, t0_.actual_duration AS actual_duration_16, t0_.updated_at AS updated_at_17, t0_.inspection_status AS inspection_status_18, t0_.inspected_by AS inspected_by_19, t0_.inspected_at AS inspected_at_20, t0_.source_issue_id AS source_issue_id_21, t0_.cancelled_at AS cancelled_at_22, t0_.due_at AS due_at_23, t0_.is_deleted AS is_deleted_24, t0_.checkout_time AS checkout_time_25, t0_.guest_name AS guest_name_26, t0_.number_of_guests AS number_of_guests_27, t0_.next_checkin_time AS next_checkin_time_28, t0_.damage_check_completed AS damage_check_completed_29, t0_.checkin_time AS checkin_time_30, t0_.guest_name AS guest_name_31, t0_.number_of_guests AS number_of_guests_32, t0_.maintenance_type AS maintenance_type_33, t0_.actual_cost AS actual_cost_34, t0_.vendor_name AS vendor_name_35, t0_.vendor_phone AS vendor_phone_36, (CASE WHEN t0_.type IN ('CHECK_OUT') THEN 0 WHEN t0_.type IN ('ONE_TIME_CLEANING') THEN 1 WHEN t0_.type IN ('MAINTENANCE') THEN 2 WHEN t0_.type IN ('CHECK_IN') THEN 3 ELSE 4 END) AS sclr_37, t0_.type AS type_38 FROM task t0_ LEFT JOIN account a1_ ON (t0_.assignee_id = a1_.id) LEFT JOIN property p2_ ON (t0_.listing_id = p2_.id) WHERE (t0_.is_deleted = false AND t0_.todo_date <= '2026-03-19 23:59:59' AND t0_.company_id = 1 AND t0_.team_id = 17) AND t0_.type IN ('CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING', 'MAINTENANCE') ORDER BY (t0_.todo_date)::date DESC, sclr_37 ASC, t0_.id ASC LIMIT 50;

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 (30, 420, 248, 403);

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_.latitude AS latitude_23,
  p0_.longitude AS longitude_24,
  p0_.has_living_room AS has_living_room_25,
  p0_.has_kitchen AS has_kitchen_26,
  p0_.has_garbage_bin AS has_garbage_bin_27,
  p0_.created_at AS created_at_28
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_.latitude AS latitude_23, p0_.longitude AS longitude_24, p0_.has_living_room AS has_living_room_25, p0_.has_kitchen AS has_kitchen_26, p0_.has_garbage_bin AS has_garbage_bin_27, p0_.created_at AS created_at_28 FROM property p0_ WHERE p0_.id IN (1891, 2125, 320, 2263, 2262, 2221, 1908, 2148, 2123, 968, 2124, 1753, 2126, 2290, 1957, 2227, 2143);

SELECT
  t0_.id AS id_0,
  t0_.content AS content_1,
  t0_.created_by_id AS created_by_id_2,
  t0_.created_at AS created_at_3,
  t0_.updated_at AS updated_at_4,
  t0_.is_deleted AS is_deleted_5,
  t0_.note_type AS note_type_6,
  t0_.task_id AS task_id_7
FROM
  task_note t0_
WHERE
  (
    t0_.task_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
    AND t0_.is_deleted = false
  )
  AND t0_.note_type IN ('GENERAL')
ORDER BY
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.content AS content_1, t0_.created_by_id AS created_by_id_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4, t0_.is_deleted AS is_deleted_5, t0_.note_type AS note_type_6, t0_.task_id AS task_id_7 FROM task_note t0_ WHERE (t0_.task_id IN (105640, 105642, 106057, 106269, 106904, 106926, 105534, 106574, 106738, 105494, 105620, 105638, 106733, 105639, 105641, 106167, 106280, 105533, 105951, 106191, 106974, 105552, 105919, 105921, 105923, 105998, 106372, 106467, 106781, 105435, 105637, 105763, 105347, 105938, 106732, 106780, 105554, 105493, 105551, 106371, 106050, 105937, 105760, 106114, 105019, 106466, 105808, 105346, 106278, 105553) AND t0_.is_deleted = false) AND t0_.note_type IN ('GENERAL') ORDER BY t0_.created_at DESC;

SELECT
  r0_.id AS id_0,
  r0_.listing_id AS listing_id_1,
  r0_.customer_name AS customer_name_2,
  r0_.guest_count AS guest_count_3,
  r0_.check_in_date AS check_in_date_4,
  r0_.check_out_date AS check_out_date_5,
  r0_.status_code AS status_code_6,
  r0_.contact_info AS contact_info_7,
  r0_.platform_code AS platform_code_8,
  r0_.channel_code AS channel_code_9,
  r0_.created_at AS created_at_10,
  r0_.channel_id AS channel_id_11,
  r0_.platform_order_id AS platform_order_id_12,
  r0_.integration AS integration_13,
  r0_.total AS total_14,
  r0_.currency AS currency_15,
  r0_.confirmed_at AS confirmed_at_16,
  r0_.is_paid AS is_paid_17,
  r0_.external_property_id AS external_property_id_18
FROM
  "reservation" r0_
WHERE
  r0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

SELECT r0_.id AS id_0, r0_.listing_id AS listing_id_1, r0_.customer_name AS customer_name_2, r0_.guest_count AS guest_count_3, r0_.check_in_date AS check_in_date_4, r0_.check_out_date AS check_out_date_5, r0_.status_code AS status_code_6, r0_.contact_info AS contact_info_7, r0_.platform_code AS platform_code_8, r0_.channel_code AS channel_code_9, r0_.created_at AS created_at_10, r0_.channel_id AS channel_id_11, r0_.platform_order_id AS platform_order_id_12, r0_.integration AS integration_13, r0_.total AS total_14, r0_.currency AS currency_15, r0_.confirmed_at AS confirmed_at_16, r0_.is_paid AS is_paid_17, r0_.external_property_id AS external_property_id_18 FROM "reservation" r0_ WHERE r0_.id IN (64838, 64839, 65069, 65182, 65532, 65544, 64781, 65286, 65440, 64757, 64828, 64837, 65437, 65127, 65187, 65010, 65139, 65570, 64791, 64991, 64992, 64993, 65037, 65237, 65289, 65462, 64724, 64765, 64677, 65001, 64792, 65064, 64907, 65099, 64497, 64931, 65186);

SELECT
  c0_.id AS id_0,
  c0_.company_name AS company_name_1,
  c0_.phone_number AS phone_number_2,
  c0_.email AS email_3,
  c0_.created_at AS created_at_4,
  c0_.cleaning_rules AS cleaning_rules_5
FROM
  company c0_
WHERE
  c0_.id IN (?)

SELECT c0_.id AS id_0, c0_.company_name AS company_name_1, c0_.phone_number AS phone_number_2, c0_.email AS email_3, c0_.created_at AS created_at_4, c0_.cleaning_rules AS cleaning_rules_5 FROM company c0_ WHERE c0_.id IN (1);

SELECT
  r0_.id AS id_0,
  r0_.listing_id AS listing_id_1,
  r0_.customer_name AS customer_name_2,
  r0_.guest_count AS guest_count_3,
  r0_.check_in_date AS check_in_date_4,
  r0_.check_out_date AS check_out_date_5,
  r0_.status_code AS status_code_6,
  r0_.contact_info AS contact_info_7,
  r0_.platform_code AS platform_code_8,
  r0_.channel_code AS channel_code_9,
  r0_.created_at AS created_at_10,
  r0_.channel_id AS channel_id_11,
  r0_.platform_order_id AS platform_order_id_12,
  r0_.integration AS integration_13,
  r0_.total AS total_14,
  r0_.currency AS currency_15,
  r0_.confirmed_at AS confirmed_at_16,
  r0_.is_paid AS is_paid_17,
  r0_.external_property_id AS external_property_id_18
FROM
  "reservation" r0_
WHERE
  r0_.listing_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND r0_.check_in_date >= ?
  AND r0_.status_code = ?
ORDER BY
  r0_.check_in_date ASC

SELECT r0_.id AS id_0, r0_.listing_id AS listing_id_1, r0_.customer_name AS customer_name_2, r0_.guest_count AS guest_count_3, r0_.check_in_date AS check_in_date_4, r0_.check_out_date AS check_out_date_5, r0_.status_code AS status_code_6, r0_.contact_info AS contact_info_7, r0_.platform_code AS platform_code_8, r0_.channel_code AS channel_code_9, r0_.created_at AS created_at_10, r0_.channel_id AS channel_id_11, r0_.platform_order_id AS platform_order_id_12, r0_.integration AS integration_13, r0_.total AS total_14, r0_.currency AS currency_15, r0_.confirmed_at AS confirmed_at_16, r0_.is_paid AS is_paid_17, r0_.external_property_id AS external_property_id_18 FROM "reservation" r0_ WHERE r0_.listing_id IN (1891, 2125, 2221, 2148, 1908, 2123, 968, 1753, 1957, 2124, 2126, 2227, 320, 2263, 2143, 2262) AND r0_.check_in_date >= '2026-03-20 12:54:42' AND r0_.status_code = 'CONFIRMED' ORDER BY r0_.check_in_date ASC;