| Limit (cost=5.26..5.26 rows=1 width=59) |
| -> Sort (cost=5.26..5.26 rows=1 width=59) |
| Sort Key: t.ticket_date, t.ticket_word, t.serial_no, t.id |
| -> Group (cost=5.24..5.25 rows=1 width=59) |
| Group Key: t.id |
| -> Sort (cost=5.24..5.25 rows=1 width=59) |
| Sort Key: t.id |
| -> Hash Join (cost=3.41..5.23 rows=1 width=59) |
| Hash Cond: (t.id = ti.ledger_ticket_id) |
| -> Seq Scan on tbl_ledger_tickets t (cost=0.00..1.67 rows=38 width=59) |
| Filter: ((ticket_date >= '2026-03-01'::date) AND (ticket_date <= '2026-06-30'::date) AND (ledger_id = 1)) |
| -> Hash (cost=3.40..3.40 rows=1 width=4) |
| -> Seq Scan on tbl_ledger_ticket_items ti (cost=0.00..3.40 rows=1 width=4) |
| Filter: ((summary)::text ~~* '%现金费用%'::text) |