| Nested Loop Left Join (cost=2.88..26.71 rows=1 width=142) |
| Join Filter: (eip.erp_inventory_disassemble_id = eid.id) |
| Filter: ((eip.erp_inventory_disassemble_id IS NULL) OR (eid.status <> 6)) |
| -> Nested Loop Left Join (cost=2.88..25.59 rows=1 width=146) |
| Join Filter: (eip.erp_inventory_build_id = eib.id) |
| Filter: ((eip.erp_inventory_build_id IS NULL) OR (eib.status <> 6)) |
| -> Nested Loop Left Join (cost=2.88..24.29 rows=1 width=150) |
| Join Filter: (eip.erp_inventory_overflow_id = eio.id) |
| Filter: ((eip.erp_inventory_overflow_id IS NULL) OR (eio.status <> 6)) |
| -> Nested Loop Left Join (cost=2.88..23.04 rows=1 width=154) |
| Join Filter: (eip.erp_purchase_gift_id = epg.id) |
| Filter: ((eip.erp_purchase_gift_id IS NULL) OR (epg.status <> 6)) |
| -> Nested Loop Left Join (cost=2.88..21.49 rows=1 width=158) |
| Filter: ((eip.erp_purchase_inbound_id IS NULL) OR (epi.status <> 6)) |
| -> Hash Join (cost=2.74..18.51 rows=1 width=162) |
| Hash Cond: (eip.id = eipsn.erp_inventory_product_id) |
| -> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..15.64 rows=10 width=24) |
| Filter: (product_id = 2261) |
| -> Hash (cost=2.55..2.55 rows=15 width=142) |
| -> Seq Scan on tbl_erp_inventory_product_sns eipsn (cost=0.00..2.55 rows=15 width=142) |
| Filter: ((sn)::text = ANY ('{321,321111,3211111,32111151,32111115,321154,3215465,2316546,231563215,3213.011,2135215,3213215321.0,2132153513,32135,21352132.0}'::text[])) |
| -> Index Scan using tbl_erp_purchase_inbounds_pkey on tbl_erp_purchase_inbounds epi (cost=0.14..2.96 rows=1 width=6) |
| Index Cond: (eip.erp_purchase_inbound_id = id) |
| -> Seq Scan on tbl_erp_purchase_gifts epg (cost=0.00..1.22 rows=22 width=6) |
| -> Seq Scan on tbl_erp_inventory_overflows eio (cost=0.00..1.10 rows=10 width=6) |
| -> Seq Scan on tbl_erp_inventory_builds eib (cost=0.00..1.12 rows=12 width=6) |
| -> Seq Scan on tbl_erp_inventory_disassembles eid (cost=0.00..1.05 rows=5 width=6) |