QUERY PLAN
Nested Loop (cost=0.00..13.81 rows=1 width=560)
Join Filter: (eprp.erp_inventory_disassemble_id = epr.id)
-> Nested Loop (cost=0.00..12.71 rows=1 width=564)
Join Filter: (r.erp_inventory_disassemble_spent_product_id = eprp.id)
-> Seq Scan on tbl_erp_inventory_disassemble_spent_product_sns r (cost=0.00..11.62 rows=1 width=560)
Filter: (erp_inventory_product_sn_id = 86)
-> Seq Scan on tbl_erp_inventory_disassemble_spent_products eprp (cost=0.00..1.04 rows=4 width=8)
-> Seq Scan on tbl_erp_inventory_disassembles epr (cost=0.00..1.06 rows=3 width=4)
Filter: (status = ANY ('{1,2}'::integer[]))