QUERY PLAN
Limit (cost=3686.93..3686.95 rows=10 width=16)
-> Sort (cost=3686.93..3686.96 rows=14 width=16)
Sort Key: (sum(CASE WHEN ((tbl_visit_module_histories.visit_date <= '2026-06-17'::date) AND (tbl_visit_module_histories.visit_date >= '2026-06-14'::date)) THEN (tbl_visit_module_histories.num * 3) WHEN ((tbl_visit_module_histories.visit_date <= '2026-06-13'::date) AND (tbl_visit_module_histories.visit_date >= '2026-06-10'::date)) THEN (tbl_visit_module_histories.num * 2) WHEN ((tbl_visit_module_histories.visit_date <= '2026-06-09'::date) AND (tbl_visit_module_histories.visit_date >= '2026-06-02'::date)) THEN (tbl_visit_module_histories.num * 1) ELSE 0 END)) DESC
-> GroupAggregate (cost=3686.07..3686.66 rows=14 width=16)
Group Key: tbl_visit_module_histories.user_id, tbl_visit_module_histories.object_type
-> Sort (cost=3686.07..3686.10 rows=14 width=16)
Sort Key: tbl_visit_module_histories.object_type
-> Seq Scan on tbl_visit_module_histories (cost=0.00..3685.80 rows=14 width=16)
Filter: ((object_type <> 24) AND (object_type <> 29) AND (visit_date >= '2026-06-02'::date) AND (user_id = 1001) AND (object_type = ANY ('{23,9,21,10,22,1,19,20,37,18,101,34,7,11,12,13,25,26,16,28,29,30,10004,20000}'::integer[])))