QUERY PLAN
Nested Loop Left Join (cost=22.39..53.69 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=22.39..52.57 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=22.39..51.27 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=22.39..50.02 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=22.39..48.47 rows=1 width=158)
Filter: ((eip.erp_purchase_inbound_id IS NULL) OR (epi.status <> 6))
-> Nested Loop (cost=22.25..40.29 rows=1 width=162)
Join Filter: (eipsn.erp_inventory_product_id = eip.id)
-> Seq Scan on tbl_erp_inventory_product_sns eipsn (cost=22.25..24.53 rows=4 width=142)
Filter: ((NOT (hashed SubPlan 1)) AND ((sn)::text = ANY ('{申请类型,提前开发票申请,付款申请,正常开票,其他,请假申请,正常备货,0出库申请,提前备货申请}'::text[])))
SubPlan 1
-> Nested Loop (cost=2.01..22.24 rows=1 width=14)
-> Hash Join (cost=2.01..14.57 rows=1 width=18)
Hash Cond: (pp.id = pps.erp_purchase_inbound_product_id)
-> Seq Scan on tbl_erp_purchase_inbound_products pp (cost=0.00..12.50 rows=4 width=8)
Filter: (erp_purchase_inbound_id = 26)
-> Hash (cost=1.45..1.45 rows=45 width=18)
-> Seq Scan on tbl_erp_purchase_inbound_product_sns pps (cost=0.00..1.45 rows=45 width=18)
-> Seq Scan on tbl_erp_purchase_inbounds p (cost=0.00..7.66 rows=1 width=4)
Filter: (id = 26)
-> Materialize (cost=0.00..15.65 rows=2 width=24)
-> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..15.64 rows=2 width=24)
Filter: (product_id = 1943)
-> Index Scan using tbl_erp_purchase_inbounds_pkey on tbl_erp_purchase_inbounds epi (cost=0.14..8.16 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)