Symfony Profiler

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_.status = ?
    AND (
      t0_.type IN ('CHECK_OUT')
      OR t0_.type IN ('ONE_TIME_CLEANING')
    )
  )
  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_.status = 'COMPLETED' AND (t0_.type IN ('CHECK_OUT') OR t0_.type IN ('ONE_TIME_CLEANING'))) 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_.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_
  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_.status = ?
    AND (
      t0_.type IN ('CHECK_OUT')
      OR t0_.type IN ('ONE_TIME_CLEANING')
    )
  )
  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
  200

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_ 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_.status = 'COMPLETED' AND (t0_.type IN ('CHECK_OUT') OR t0_.type IN ('ONE_TIME_CLEANING'))) 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 200;

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_.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_.new_cleaning_fee AS new_cleaning_fee_28,
  p0_.cleaning_fee_effective_date AS cleaning_fee_effective_date_29,
  p0_.created_at AS created_at_30
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_.new_cleaning_fee AS new_cleaning_fee_28, p0_.cleaning_fee_effective_date AS cleaning_fee_effective_date_29, p0_.created_at AS created_at_30 FROM property p0_ WHERE p0_.id IN (2148, 2215, 2169, 2170, 320, 1908, 2168, 1585, 2195, 2157, 2243, 2172, 2227, 2279, 2126, 2125, 2280, 2222, 1739, 2262, 2263, 2124, 2242, 2173, 2202, 2216, 2217, 2223, 2220, 2265, 2260, 2143, 2203, 2171, 1742, 1891, 2123, 2129, 2182, 1944, 2151, 1957, 1945, 1587, 2221, 2134, 1946, 1950, 1942, 1947, 2167, 2219, 2132, 1949, 2165, 2184, 2130);

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.eyJpYXQiOjE3ODA2OTYwMTUsImV4cCI6MTc4MTk5MjAxNSwicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJhZG1pbkBjb3p5LmNvbSJ9.cPvcjh7KfF-kB5GxOoawiMjWnbsnYeoaH8gEBkBjXtgtIQWqdUqOBjDeI0-nCmzyuKxQnd75OF6zLubsmMt8nnTldfpL1_ShGSuDoNy8FqRt3eiQzlC_RBcFYzpOO3drmm2wj7CK5QzdA64-hafs202WqFAk0b-Bf85SUt6rhysBARoZHGLse9ctEXzyG3gyeWmbg1nCpDrfr_QKFIC7JfWOPn5zEnm0M1oqEC7Q8gloqQm1-zpvg24E5vDTc5K4gUW3x7BNl5t2jkHFjB7CfpYYpDt-AZw2xh24Or0mfeoS1qgmAbQsQI0wRzU1gtPmMEyzWPxqDMaDqwb2L_22AQ' LIMIT 1;

SELECT
  t0_.task_id AS sclr_0,
  SUM(
    CASE WHEN t0_.passed IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN t0_.passed = true THEN
      1
    ELSE
      0
    END
  ) AS sclr_2
FROM
  task_checklist_item t0_
WHERE
  t0_.task_id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
  AND t0_.requires_photo = true
GROUP BY
  t0_.task_id

SELECT t0_.task_id AS sclr_0, SUM(CASE WHEN t0_.passed IS NOT NULL THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN t0_.passed = true THEN 1 ELSE 0 END) AS sclr_2 FROM task_checklist_item t0_ WHERE t0_.task_id IN (105080, 103801, 103624, 103795, 105090, 105176, 105315, 105466, 105474, 102635, 104319, 105442, 103214, 103301, 104875, 104998, 105018, 105263, 104531, 104631, 105200, 101003, 103228, 104357, 104711, 104821, 105249, 103020, 103720, 103813, 103871, 104355, 105120, 103430, 103716, 104593, 103682, 104223, 105048, 103218, 103753, 104133, 104135, 104609, 104735, 104737, 104761, 104986, 105062, 105098, 105114, 103277, 103664, 104695, 104867, 104928, 104960, 103750, 104157, 104491, 104865, 104453, 104767, 104333, 104547, 104813, 104525, 103909, 103648, 103807, 104189, 103726, 103843, 104339, 104585, 104299, 104303, 104465, 103690, 102858, 103636, 103897, 104173, 102729, 102898, 104307, 101980, 102514, 102693, 102661, 102844, 103239, 103269, 103442, 103640, 104123, 102525, 103345, 102808, 102451, 103058, 103630, 102685, 103241, 102856, 103293, 102477, 103166, 103168, 103357, 103572, 102904, 102307, 102637, 102952, 103030, 103380, 103337, 103378, 102526, 101183, 102560, 102794, 102906, 103190, 101700, 102453, 102558, 102643, 102325, 102431, 102928, 102940, 102972, 103010, 101850, 102213, 102812, 103056, 102602, 102783, 102501, 102830, 102534, 102562, 102866, 102217, 102586, 102590, 102675, 102725, 101730, 102207, 102393, 102475, 102578, 102663, 102699, 102757, 102542, 102544, 102655, 102697, 100971, 101906, 102303, 102554, 102423, 102489, 101706, 102321, 102417, 102419, 101624, 102219, 102369, 101273, 102367, 101267, 101773, 101874, 102008, 102058, 100356, 100698, 101007, 101277, 101290, 101450, 101830, 101932, 102245, 102247, 102271, 102297, 102329, 99896, 101753, 101799, 101838) AND t0_.requires_photo = true GROUP BY t0_.task_id;

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 (105080, 103801, 103624, 103795, 105090, 105176, 105315, 105466, 105474, 102635, 104319, 105442, 103214, 103301, 104875, 104998, 105018, 105263, 104531, 104631, 105200, 101003, 103228, 104357, 104711, 104821, 105249, 103020, 103720, 103813, 103871, 104355, 105120, 103430, 103716, 104593, 103682, 104223, 105048, 103218, 103753, 104133, 104135, 104609, 104735, 104737, 104761, 104986, 105062, 105098, 105114, 103277, 103664, 104695, 104867, 104928, 104960, 103750, 104157, 104491, 104865, 104453, 104767, 104333, 104547, 104813, 104525, 103909, 103648, 103807, 104189, 103726, 103843, 104339, 104585, 104299, 104303, 104465, 103690, 102858, 103636, 103897, 104173, 102729, 102898, 104307, 101980, 102514, 102693, 102661, 102844, 103239, 103269, 103442, 103640, 104123, 102525, 103345, 102808, 102451, 103058, 103630, 102685, 103241, 102856, 103293, 102477, 103166, 103168, 103357, 103572, 102904, 102307, 102637, 102952, 103030, 103380, 103337, 103378, 102526, 101183, 102560, 102794, 102906, 103190, 101700, 102453, 102558, 102643, 102325, 102431, 102928, 102940, 102972, 103010, 101850, 102213, 102812, 103056, 102602, 102783, 102501, 102830, 102534, 102562, 102866, 102217, 102586, 102590, 102675, 102725, 101730, 102207, 102393, 102475, 102578, 102663, 102699, 102757, 102542, 102544, 102655, 102697, 100971, 101906, 102303, 102554, 102423, 102489, 101706, 102321, 102417, 102419, 101624, 102219, 102369, 101273, 102367, 101267, 101773, 101874, 102008, 102058, 100356, 100698, 101007, 101277, 101290, 101450, 101830, 101932, 102245, 102247, 102271, 102297, 102329, 99896, 101753, 101799, 101838) ORDER BY t0_.sort_order ASC;

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 (420, 433, 185, 30, 399, 348, 397, 234, 276, 422);