| Aggregate (cost=1539.66..1539.67 rows=1 width=32) |
| -> HashAggregate (cost=1496.12..1507.73 rows=1161 width=390) |
| Group Key: r.id, r.client_id, r.project_id, r.title, r.status, r.next_verify_user, r.verify_at, r.description, r.refuse_description, r.is_resubmited, r.created_by, r.created_at, r.updated_at, r.supplier_id, r.purchase_contract_id, r.amount, r.borrow_amount, r.borrow_collect_day, r.borrow_collect_status, r.borrow_collect_description, r.borrow_collect_at |
| -> HashAggregate (cost=1423.56..1435.17 rows=1161 width=390) |
| Group Key: r.id |
| -> Hash Right Join (cost=389.67..1420.66 rows=1161 width=390) |
| Hash Cond: (dt1.object_id = r.id) |
| -> Seq Scan on tbl_term_taxonomy_relationships dt1 (cost=0.00..1022.28 rows=1624 width=4) |
| Filter: (term_id = 17) |
| -> Hash (cost=375.16..375.16 rows=1161 width=390) |
| -> Hash Right Join (cost=179.78..375.16 rows=1161 width=390) |
| Hash Cond: (rccr.approve_id = r.id) |
| Filter: ((r.created_by = 5295) OR (rccr.user_id = 5295) OR (rvr.user_id = 5295)) |
| -> Seq Scan on tbl_approve_carbon_copy_rels rccr (cost=0.00..80.97 rows=5197 width=8) |
| -> Hash (cost=157.68..157.68 rows=1768 width=394) |
| -> Hash Right Join (cost=121.24..157.68 rows=1768 width=394) |
| Hash Cond: (rvr.approve_id = r.id) |
| -> Seq Scan on tbl_approve_verify_rels rvr (cost=0.00..31.77 rows=1777 width=8) |
| -> Hash (cost=100.17..100.17 rows=1685 width=390) |
| -> Seq Scan on tbl_approves r (cost=0.00..100.17 rows=1685 width=390) |
| Filter: (status <> 0) |