Symfony Profiler

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.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
  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 (2272);

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.eyJpYXQiOjE3ODM0NDE4NDMsImV4cCI6MTc4NDczNzg0Mywicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJhZG1pbkBjb3p5LmNvbSJ9.xgyXZg5EnnAGoSHysxoVUPiALPWyUbvLQX1kV_Dstd2HeQW1Bzvbj7sHlPLIRy7jMC1ON7D8jk1tl8iq0bjrrbi5jqS_YKC1WDo5Xi0IRjL3ImfuebxrZOg4dHNxyzSEI2pes9e7_ATJHefIEObuKkTiEGBX5mbmvsstmKOGkkqAbwyfALETeEgTZmdUqp-UiSohyYenh-ZrHOvHzg_KVoRO2-A5OICG7kQdvryZSBVyRUlUyZAB0YE0a5GJm7MKe7_pJjnwO39phVP0KAMFuMaRijSWft9GZUlGfktElu4POTT5um9CIc6vdrWYoiG7MkIIuApsRe8D0ZLuQg8aNg' LIMIT 1;

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_.unit_price AS unit_price_24,
  t0_.is_deleted AS is_deleted_25,
  t0_.checkout_time AS checkout_time_26,
  t0_.guest_name AS guest_name_27,
  t0_.number_of_guests AS number_of_guests_28,
  t0_.next_checkin_time AS next_checkin_time_29,
  t0_.damage_check_completed AS damage_check_completed_30,
  t0_.checkin_time AS checkin_time_31,
  t0_.guest_name AS guest_name_32,
  t0_.number_of_guests AS number_of_guests_33,
  t0_.maintenance_type AS maintenance_type_34,
  t0_.actual_cost AS actual_cost_35,
  t0_.vendor_name AS vendor_name_36,
  t0_.vendor_phone AS vendor_phone_37,
  (
    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_38,
  t0_.type AS type_39
FROM
  task t0_
WHERE
  (
    t0_.is_deleted = false
    AND t0_.listing_id IN (?)
  )
  AND t0_.type IN (
    'CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING',
    'MAINTENANCE'
  )
ORDER BY
  (t0_.todo_date):: date DESC,
  sclr_38 ASC,
  t0_.id ASC
LIMIT
  25

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_.unit_price AS unit_price_24, t0_.is_deleted AS is_deleted_25, t0_.checkout_time AS checkout_time_26, t0_.guest_name AS guest_name_27, t0_.number_of_guests AS number_of_guests_28, t0_.next_checkin_time AS next_checkin_time_29, t0_.damage_check_completed AS damage_check_completed_30, t0_.checkin_time AS checkin_time_31, t0_.guest_name AS guest_name_32, t0_.number_of_guests AS number_of_guests_33, t0_.maintenance_type AS maintenance_type_34, t0_.actual_cost AS actual_cost_35, t0_.vendor_name AS vendor_name_36, t0_.vendor_phone AS vendor_phone_37, (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_38, t0_.type AS type_39 FROM task t0_ WHERE (t0_.is_deleted = false AND t0_.listing_id IN (2272)) AND t0_.type IN ('CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING', 'MAINTENANCE') ORDER BY (t0_.todo_date)::date DESC, sclr_38 ASC, t0_.id ASC LIMIT 25;

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 (446, 5, 18);

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  task t0_
WHERE
  (
    t0_.is_deleted = false
    AND t0_.listing_id IN (?)
  )
  AND t0_.type IN (
    'CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING',
    'MAINTENANCE'
  )

SELECT COUNT(t0_.id) AS sclr_0 FROM task t0_ WHERE (t0_.is_deleted = false AND t0_.listing_id IN (2272)) AND t0_.type IN ('CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING', 'MAINTENANCE');

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,
  r0_.confirmation_code AS confirmation_code_19,
  r0_.last_event_at AS last_event_at_20
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, r0_.confirmation_code AS confirmation_code_19, r0_.last_event_at AS last_event_at_20 FROM "reservation" r0_ WHERE r0_.id IN (63945, 63950, 63957, 63953, 63963, 63975, 63971, 63965, 63973, 63954, 63961, 63947, 63951);

SELECT
  p0_.id AS id_0,
  p0_.file_name AS file_name_1,
  p0_.directory AS directory_2,
  p0_.deleted AS deleted_3,
  p0_.created_at AS created_at_4,
  p0_.category AS category_5,
  p0_.latitude AS latitude_6,
  p0_.longitude AS longitude_7,
  p0_.captured_at AS captured_at_8,
  p0_.device_info AS device_info_9,
  p0_.file_size AS file_size_10,
  p0_.mime_type AS mime_type_11,
  p0_.related_id AS related_id_12,
  p0_.passed AS passed_13,
  p0_.photo_type AS photo_type_14,
  p0_.task_id AS task_id_15
FROM
  photo p0_
WHERE
  (
    p0_.task_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
    AND p0_.deleted = false
  )
  AND p0_.photo_type IN ('task')
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.file_name AS file_name_1, p0_.directory AS directory_2, p0_.deleted AS deleted_3, p0_.created_at AS created_at_4, p0_.category AS category_5, p0_.latitude AS latitude_6, p0_.longitude AS longitude_7, p0_.captured_at AS captured_at_8, p0_.device_info AS device_info_9, p0_.file_size AS file_size_10, p0_.mime_type AS mime_type_11, p0_.related_id AS related_id_12, p0_.passed AS passed_13, p0_.photo_type AS photo_type_14, p0_.task_id AS task_id_15 FROM photo p0_ WHERE (p0_.task_id IN (104043, 104042, 104053, 104052, 104067, 104066, 104059, 104058, 104079, 104078, 104103, 104095, 104102, 104083, 104094, 104099, 104082, 104061, 104098, 104075, 104060, 104074, 104047, 104055, 104046) AND p0_.deleted = false) AND p0_.photo_type IN ('task') ORDER BY p0_.created_at DESC;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.description AS description_2,
  t0_.is_completed AS is_completed_3,
  t0_.is_required AS is_required_4,
  t0_.requires_photo AS requires_photo_5,
  t0_.sort_order AS sort_order_6,
  t0_.key AS key_7,
  t0_.passed AS passed_8,
  t0_.completed_at AS completed_at_9,
  t0_.created_at AS created_at_10,
  t0_.task_id AS task_id_11,
  t0_.template_item_id AS template_item_id_12,
  t0_.completed_by_id AS completed_by_id_13
FROM
  task_checklist_item t0_
WHERE
  t0_.task_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  t0_.sort_order ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.is_completed AS is_completed_3, t0_.is_required AS is_required_4, t0_.requires_photo AS requires_photo_5, t0_.sort_order AS sort_order_6, t0_.key AS key_7, t0_.passed AS passed_8, t0_.completed_at AS completed_at_9, t0_.created_at AS created_at_10, t0_.task_id AS task_id_11, t0_.template_item_id AS template_item_id_12, t0_.completed_by_id AS completed_by_id_13 FROM task_checklist_item t0_ WHERE t0_.task_id IN (104043, 104042, 104053, 104052, 104067, 104066, 104059, 104058, 104079, 104078, 104103, 104095, 104102, 104083, 104094, 104099, 104082, 104061, 104098, 104075, 104060, 104074, 104047, 104055, 104046) ORDER BY t0_.sort_order ASC;

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 (104043, 104042, 104053, 104052, 104067, 104066, 104059, 104058, 104079, 104078, 104103, 104095, 104102, 104083, 104094, 104099, 104082, 104061, 104098, 104075, 104060, 104074, 104047, 104055, 104046) AND t0_.is_deleted = false) AND t0_.note_type IN ('GENERAL') ORDER BY t0_.created_at DESC;

SELECT
  p0_.id AS id_0,
  p0_.file_name AS file_name_1,
  p0_.directory AS directory_2,
  p0_.deleted AS deleted_3,
  p0_.created_at AS created_at_4,
  p0_.category AS category_5,
  p0_.latitude AS latitude_6,
  p0_.longitude AS longitude_7,
  p0_.captured_at AS captured_at_8,
  p0_.device_info AS device_info_9,
  p0_.file_size AS file_size_10,
  p0_.mime_type AS mime_type_11,
  p0_.related_id AS related_id_12,
  p0_.passed AS passed_13,
  p0_.photo_type AS photo_type_14,
  p0_.task_id AS task_id_15,
  p0_.checklist_item_id AS checklist_item_id_16
FROM
  photo p0_
WHERE
  (
    p0_.checklist_item_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
    AND p0_.deleted = false
  )
  AND p0_.photo_type IN ('checklist')
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.file_name AS file_name_1, p0_.directory AS directory_2, p0_.deleted AS deleted_3, p0_.created_at AS created_at_4, p0_.category AS category_5, p0_.latitude AS latitude_6, p0_.longitude AS longitude_7, p0_.captured_at AS captured_at_8, p0_.device_info AS device_info_9, p0_.file_size AS file_size_10, p0_.mime_type AS mime_type_11, p0_.related_id AS related_id_12, p0_.passed AS passed_13, p0_.photo_type AS photo_type_14, p0_.task_id AS task_id_15, p0_.checklist_item_id AS checklist_item_id_16 FROM photo p0_ WHERE (p0_.checklist_item_id IN (335, 336, 337, 338, 339, 8, 9, 10, 11, 12, 325, 326, 327, 328, 329, 320, 321, 322, 323, 324, 362, 363, 364, 365, 366, 315, 316, 317, 318, 319, 18, 19, 20, 21, 22) AND p0_.deleted = false) AND p0_.photo_type IN ('checklist') ORDER BY p0_.created_at DESC;

SELECT
  t0_.id AS id_0,
  t0_.team_name AS team_name_1,
  t0_.phone_number AS phone_number_2,
  t0_.email AS email_3,
  t0_.cleaning_rules AS cleaning_rules_4,
  t0_.company_id AS company_id_5,
  t0_.created_at AS created_at_6
FROM
  team t0_
WHERE
  t0_.id IN (?, ?, ?)

SELECT t0_.id AS id_0, t0_.team_name AS team_name_1, t0_.phone_number AS phone_number_2, t0_.email AS email_3, t0_.cleaning_rules AS cleaning_rules_4, t0_.company_id AS company_id_5, t0_.created_at AS created_at_6 FROM team t0_ WHERE t0_.id IN (10, 62, 17);

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);