| Limit (cost=2.32..2.34 rows=9 width=16) |
| -> Sort (cost=2.32..2.34 rows=9 width=16) |
| Sort Key: (sum(CASE WHEN ((tbl_visit_module_histories.visit_date <= '2026-05-29'::date) AND (tbl_visit_module_histories.visit_date >= '2026-05-26'::date)) THEN (tbl_visit_module_histories.num * 3) WHEN ((tbl_visit_module_histories.visit_date <= '2026-05-25'::date) AND (tbl_visit_module_histories.visit_date >= '2026-05-22'::date)) THEN (tbl_visit_module_histories.num * 2) WHEN ((tbl_visit_module_histories.visit_date <= '2026-05-21'::date) AND (tbl_visit_module_histories.visit_date >= '2026-05-14'::date)) THEN (tbl_visit_module_histories.num * 1) ELSE 0 END)) DESC |
| -> HashAggregate (cost=2.09..2.18 rows=9 width=16) |
| Group Key: tbl_visit_module_histories.user_id, tbl_visit_module_histories.object_type |
| -> Seq Scan on tbl_visit_module_histories (cost=0.00..1.79 rows=10 width=16) |
| Filter: ((object_type <> 24) AND (object_type <> 29) AND (visit_date >= '2026-05-14'::date) AND (user_id = 5495) AND (object_type = ANY ('{23,9,10,1,19,20,37,18,101,34,11,26,16,28}'::integer[]))) |