| Aggregate (cost=1733.67..1733.68 rows=1 width=8) |
| -> Sort (cost=1727.85..1728.82 rows=388 width=301) |
| Sort Key: (CASE WHEN ((sub.verify_status = 0) OR (sub.stop_verify_status = 0) OR (sub.cancel_verify_status = 0)) THEN 1 ELSE 2 END), sub.created_at DESC |
| -> Result (cost=32.51..1711.17 rows=388 width=301) |
| -> Append (cost=32.51..1704.38 rows=388 width=20) |
| -> Subquery Scan on sub (cost=32.51..32.58 rows=2 width=20) |
| -> Group (cost=32.51..32.56 rows=2 width=305) |
| Group Key: r.id, rvr.status, rsvr.status |
| -> Sort (cost=32.51..32.52 rows=2 width=30) |
| Sort Key: r.id, rvr.status, rsvr.status |
| -> Hash Left Join (cost=27.50..32.50 rows=2 width=30) |
| Hash Cond: (r.id = rvr.erp_purchase_inbound_id) |
| Filter: ((CASE WHEN (1 = r.verify_type) THEN rvr.status ELSE CASE WHEN (r.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr.status = 0) THEN NULL::integer ELSE rvr.status END END END = 1) OR (CASE WHEN (1 = r.verify_type) THEN rsvr.status ELSE CASE WHEN (r.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr.status = 0) THEN NULL::integer ELSE rsvr.status END END END = 1) OR (CASE WHEN (1 = r.verify_type) THEN rvr.status ELSE CASE WHEN (r.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr.status = 0) THEN NULL::integer ELSE rvr.status END END END = 2) OR (CASE WHEN (1 = r.verify_type) THEN rsvr.status ELSE CASE WHEN (r.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr.status = 0) THEN NULL::integer ELSE rsvr.status END END END = 2)) |
| -> Hash Left Join (cost=22.19..26.78 rows=96 width=26) |
| Hash Cond: (r.id = rsvr.erp_purchase_inbound_id) |
| -> Seq Scan on tbl_erp_purchase_inbounds r (cost=0.00..4.21 rows=96 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=8) |
| -> Seq Scan on tbl_erp_purchase_inbound_stop_verify_rels rsvr (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=5.30..5.30 rows=1 width=8) |
| -> Seq Scan on tbl_erp_purchase_inbound_verify_rels rvr (cost=0.00..5.30 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 2" (cost=118.73..121.50 rows=65 width=20) |
| -> HashAggregate (cost=118.73..120.85 rows=65 width=309) |
| Group Key: r_1.id, rvr_1.status, rsvr_1.status, rcvr.status |
| -> Hash Left Join (cost=25.56..118.08 rows=65 width=38) |
| Hash Cond: (r_1.id = rsvr_1.erp_purchase_order_id) |
| Filter: ((CASE WHEN (1 = r_1.verify_type) THEN rvr_1.status ELSE CASE WHEN (r_1.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_1.status = 0) THEN NULL::integer ELSE rvr_1.status END END END = 1) OR (CASE WHEN (1 = r_1.verify_type) THEN rsvr_1.status ELSE CASE WHEN (r_1.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_1.status = 0) THEN NULL::integer ELSE rsvr_1.status END END END = 1) OR (CASE WHEN (1 = r_1.verify_type) THEN rcvr.status ELSE CASE WHEN (r_1.next_cancel_verify_user = 5064) THEN 0 ELSE CASE WHEN (rcvr.status = 0) THEN NULL::integer ELSE rcvr.status END END END = 1) OR (CASE WHEN (1 = r_1.verify_type) THEN rvr_1.status ELSE CASE WHEN (r_1.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_1.status = 0) THEN NULL::integer ELSE rvr_1.status END END END = 2) OR (CASE WHEN (1 = r_1.verify_type) THEN rsvr_1.status ELSE CASE WHEN (r_1.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_1.status = 0) THEN NULL::integer ELSE rsvr_1.status END END END = 2) OR (CASE WHEN (1 = r_1.verify_type) THEN rcvr.status ELSE CASE WHEN (r_1.next_cancel_verify_user = 5064) THEN 0 ELSE CASE WHEN (rcvr.status = 0) THEN NULL::integer ELSE rcvr.status END END END = 2)) |
| -> Hash Left Join (cost=24.48..108.66 rows=2206 width=34) |
| Hash Cond: (r_1.id = rcvr.erp_purchase_order_id) |
| -> Hash Left Join (cost=2.29..78.14 rows=2206 width=30) |
| Hash Cond: (r_1.id = rvr_1.erp_purchase_order_id) |
| -> Seq Scan on tbl_erp_purchase_orders r_1 (cost=0.00..67.58 rows=2206 width=26) |
| Filter: (status <> 0) |
| -> Hash (cost=2.28..2.28 rows=1 width=8) |
| -> Seq Scan on tbl_erp_purchase_order_verify_rels rvr_1 (cost=0.00..2.28 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=22.12..22.12 rows=5 width=8) |
| -> Seq Scan on tbl_erp_purchase_order_cancel_verify_rels rcvr (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.07..1.07 rows=1 width=8) |
| -> Seq Scan on tbl_erp_purchase_order_stop_verify_rels rsvr_1 (cost=0.00..1.07 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 3" (cost=58.91..59.05 rows=4 width=20) |
| -> Group (cost=58.91..59.01 rows=4 width=305) |
| Group Key: r_2.id, rvr_2.status, rsvr_2.status |
| -> Sort (cost=58.91..58.92 rows=4 width=30) |
| Sort Key: r_2.id, rvr_2.status, rsvr_2.status |
| -> Hash Left Join (cost=44.38..58.87 rows=4 width=30) |
| Hash Cond: (r_2.id = rsvr_2.erp_purchase_return_id) |
| Filter: ((CASE WHEN (1 = r_2.verify_type) THEN rvr_2.status ELSE CASE WHEN (r_2.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_2.status = 0) THEN NULL::integer ELSE rvr_2.status END END END = 1) OR (CASE WHEN (1 = r_2.verify_type) THEN rsvr_2.status ELSE CASE WHEN (r_2.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_2.status = 0) THEN NULL::integer ELSE rsvr_2.status END END END = 1) OR (CASE WHEN (1 = r_2.verify_type) THEN rvr_2.status ELSE CASE WHEN (r_2.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_2.status = 0) THEN NULL::integer ELSE rvr_2.status END END END = 2) OR (CASE WHEN (1 = r_2.verify_type) THEN rsvr_2.status ELSE CASE WHEN (r_2.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_2.status = 0) THEN NULL::integer ELSE rsvr_2.status END END END = 2)) |
| -> Hash Left Join (cost=22.19..35.65 rows=209 width=26) |
| Hash Cond: (r_2.id = rvr_2.erp_purchase_return_id) |
| -> Seq Scan on tbl_erp_purchase_returns r_2 (cost=0.00..12.62 rows=209 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=8) |
| -> Seq Scan on tbl_erp_purchase_return_verify_rels rvr_2 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=22.12..22.12 rows=5 width=8) |
| -> Seq Scan on tbl_erp_purchase_return_stop_verify_rels rsvr_2 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 4" (cost=24.58..24.61 rows=1 width=20) |
| -> Group (cost=24.58..24.60 rows=1 width=305) |
| Group Key: r_3.id, rvr_3.status, rsvr_3.status |
| -> Sort (cost=24.58..24.58 rows=1 width=30) |
| Sort Key: r_3.id, rvr_3.status, rsvr_3.status |
| -> Nested Loop Left Join (cost=0.00..24.57 rows=1 width=30) |
| Join Filter: (rvr_3.erp_inventory_lost_id = r_3.id) |
| Filter: ((CASE WHEN (1 = r_3.verify_type) THEN rvr_3.status ELSE CASE WHEN (r_3.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_3.status = 0) THEN NULL::integer ELSE rvr_3.status END END END = 1) OR (CASE WHEN (1 = r_3.verify_type) THEN rsvr_3.status ELSE CASE WHEN (r_3.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_3.status = 0) THEN NULL::integer ELSE rsvr_3.status END END END = 1) OR (CASE WHEN (1 = r_3.verify_type) THEN rvr_3.status ELSE CASE WHEN (r_3.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_3.status = 0) THEN NULL::integer ELSE rvr_3.status END END END = 2) OR (CASE WHEN (1 = r_3.verify_type) THEN rsvr_3.status ELSE CASE WHEN (r_3.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_3.status = 0) THEN NULL::integer ELSE rsvr_3.status END END END = 2)) |
| -> Nested Loop Left Join (cost=0.00..23.32 rows=3 width=26) |
| Join Filter: (rsvr_3.erp_inventory_lost_id = r_3.id) |
| -> Seq Scan on tbl_erp_inventory_losts r_3 (cost=0.00..1.04 rows=2 width=22) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..22.15 rows=5 width=8) |
| -> Seq Scan on tbl_erp_inventory_lost_stop_verify_rels rsvr_3 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Materialize (cost=0.00..1.08 rows=1 width=8) |
| -> Seq Scan on tbl_erp_inventory_lost_verify_rels rvr_3 (cost=0.00..1.07 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 5" (cost=24.39..24.42 rows=1 width=20) |
| -> Group (cost=24.39..24.41 rows=1 width=305) |
| Group Key: r_4.id, rvr_4.status, rsvr_4.status |
| -> Sort (cost=24.39..24.39 rows=1 width=30) |
| Sort Key: r_4.id, rvr_4.status, rsvr_4.status |
| -> Nested Loop Left Join (cost=0.00..24.38 rows=1 width=30) |
| Join Filter: (rvr_4.erp_inventory_build_id = r_4.id) |
| Filter: ((CASE WHEN (1 = r_4.verify_type) THEN rvr_4.status ELSE CASE WHEN (r_4.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_4.status = 0) THEN NULL::integer ELSE rvr_4.status END END END = 1) OR (CASE WHEN (1 = r_4.verify_type) THEN rsvr_4.status ELSE CASE WHEN (r_4.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_4.status = 0) THEN NULL::integer ELSE rsvr_4.status END END END = 1) OR (CASE WHEN (1 = r_4.verify_type) THEN rvr_4.status ELSE CASE WHEN (r_4.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_4.status = 0) THEN NULL::integer ELSE rvr_4.status END END END = 2) OR (CASE WHEN (1 = r_4.verify_type) THEN rsvr_4.status ELSE CASE WHEN (r_4.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_4.status = 0) THEN NULL::integer ELSE rsvr_4.status END END END = 2)) |
| -> Nested Loop Left Join (cost=0.00..23.21 rows=2 width=26) |
| Join Filter: (rsvr_4.erp_inventory_build_id = r_4.id) |
| -> Seq Scan on tbl_erp_inventory_builds r_4 (cost=0.00..1.02 rows=1 width=22) |
| Filter: (status <> 0) |
| -> Seq Scan on tbl_erp_inventory_build_stop_verify_rels rsvr_4 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Materialize (cost=0.00..1.05 rows=1 width=8) |
| -> Seq Scan on tbl_erp_inventory_build_verify_rels rvr_4 (cost=0.00..1.05 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 6" (cost=99.65..101.81 rows=48 width=20) |
| -> Group (cost=99.65..101.33 rows=48 width=309) |
| Group Key: r_5.id, rvr_5.status, rsvr_5.status, rcvr_1.status |
| -> Sort (cost=99.65..99.77 rows=48 width=38) |
| Sort Key: r_5.id, rvr_5.status, rsvr_5.status, rcvr_1.status |
| -> Hash Left Join (cost=3.84..98.31 rows=48 width=38) |
| Hash Cond: (r_5.id = rcvr_1.erp_sales_order_id) |
| Filter: ((CASE WHEN (1 = r_5.verify_type) THEN rvr_5.status ELSE CASE WHEN (r_5.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_5.status = 0) THEN NULL::integer ELSE rvr_5.status END END END = 1) OR (CASE WHEN (1 = r_5.verify_type) THEN rsvr_5.status ELSE CASE WHEN (r_5.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_5.status = 0) THEN NULL::integer ELSE rsvr_5.status END END END = 1) OR (CASE WHEN (1 = r_5.verify_type) THEN rcvr_1.status ELSE CASE WHEN (r_5.next_cancel_verify_user = 5064) THEN 0 ELSE CASE WHEN (rcvr_1.status = 0) THEN NULL::integer ELSE rcvr_1.status END END END = 1) OR (CASE WHEN (1 = r_5.verify_type) THEN rvr_5.status ELSE CASE WHEN (r_5.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_5.status = 0) THEN NULL::integer ELSE rvr_5.status END END END = 2) OR (CASE WHEN (1 = r_5.verify_type) THEN rsvr_5.status ELSE CASE WHEN (r_5.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_5.status = 0) THEN NULL::integer ELSE rsvr_5.status END END END = 2) OR (CASE WHEN (1 = r_5.verify_type) THEN rcvr_1.status ELSE CASE WHEN (r_5.next_cancel_verify_user = 5064) THEN 0 ELSE CASE WHEN (rcvr_1.status = 0) THEN NULL::integer ELSE rcvr_1.status END END END = 2)) |
| -> Hash Left Join (cost=2.81..91.15 rows=1616 width=34) |
| Hash Cond: (r_5.id = rsvr_5.erp_sales_order_id) |
| -> Hash Left Join (cost=1.64..83.91 rows=1616 width=30) |
| Hash Cond: (r_5.id = rvr_5.erp_sales_order_id) |
| -> Seq Scan on tbl_erp_sales_orders r_5 (cost=0.00..76.20 rows=1616 width=26) |
| Filter: (status <> 0) |
| -> Hash (cost=1.62..1.62 rows=1 width=8) |
| -> Seq Scan on tbl_erp_sales_order_verify_rels rvr_5 (cost=0.00..1.62 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.16..1.16 rows=1 width=8) |
| -> Seq Scan on tbl_erp_sales_order_stop_verify_rels rsvr_5 (cost=0.00..1.16 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.01..1.01 rows=1 width=8) |
| -> Seq Scan on tbl_erp_sales_order_cancel_verify_rels rcvr_1 (cost=0.00..1.01 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 7" (cost=30.67..30.71 rows=1 width=20) |
| -> Group (cost=30.67..30.70 rows=1 width=305) |
| Group Key: r_6.id, rvr_6.status, rsvr_6.status |
| -> Sort (cost=30.67..30.68 rows=1 width=30) |
| Sort Key: r_6.id, rvr_6.status, rsvr_6.status |
| -> Hash Left Join (cost=26.26..30.66 rows=1 width=30) |
| Hash Cond: (r_6.id = rvr_6.erp_sales_outbound_id) |
| Filter: ((CASE WHEN (1 = r_6.verify_type) THEN rvr_6.status ELSE CASE WHEN (r_6.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_6.status = 0) THEN NULL::integer ELSE rvr_6.status END END END = 1) OR (CASE WHEN (1 = r_6.verify_type) THEN rsvr_6.status ELSE CASE WHEN (r_6.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_6.status = 0) THEN NULL::integer ELSE rsvr_6.status END END END = 1) OR (CASE WHEN (1 = r_6.verify_type) THEN rvr_6.status ELSE CASE WHEN (r_6.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_6.status = 0) THEN NULL::integer ELSE rvr_6.status END END END = 2) OR (CASE WHEN (1 = r_6.verify_type) THEN rsvr_6.status ELSE CASE WHEN (r_6.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_6.status = 0) THEN NULL::integer ELSE rsvr_6.status END END END = 2)) |
| -> Hash Left Join (cost=22.19..26.29 rows=66 width=26) |
| Hash Cond: (r_6.id = rsvr_6.erp_sales_outbound_id) |
| -> Seq Scan on tbl_erp_sales_outbounds r_6 (cost=0.00..3.84 rows=66 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=8) |
| -> Seq Scan on tbl_erp_sales_outbound_stop_verify_rels rsvr_6 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=4.06..4.06 rows=1 width=8) |
| -> Seq Scan on tbl_erp_sales_outbound_verify_rels rvr_6 (cost=0.00..4.06 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 8" (cost=24.46..24.50 rows=1 width=20) |
| -> Group (cost=24.46..24.49 rows=1 width=305) |
| Group Key: r_7.id, rvr_7.status, rsvr_7.status |
| -> Sort (cost=24.46..24.46 rows=1 width=30) |
| Sort Key: r_7.id, rvr_7.status, rsvr_7.status |
| -> Nested Loop Left Join (cost=0.00..24.45 rows=1 width=30) |
| Join Filter: (rsvr_7.erp_sales_return_id = r_7.id) |
| Filter: ((CASE WHEN (1 = r_7.verify_type) THEN rvr_7.status ELSE CASE WHEN (r_7.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_7.status = 0) THEN NULL::integer ELSE rvr_7.status END END END = 1) OR (CASE WHEN (1 = r_7.verify_type) THEN rsvr_7.status ELSE CASE WHEN (r_7.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_7.status = 0) THEN NULL::integer ELSE rsvr_7.status END END END = 1) OR (CASE WHEN (1 = r_7.verify_type) THEN rvr_7.status ELSE CASE WHEN (r_7.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_7.status = 0) THEN NULL::integer ELSE rvr_7.status END END END = 2) OR (CASE WHEN (1 = r_7.verify_type) THEN rsvr_7.status ELSE CASE WHEN (r_7.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_7.status = 0) THEN NULL::integer ELSE rsvr_7.status END END END = 2)) |
| -> Nested Loop Left Join (cost=0.00..2.06 rows=1 width=26) |
| Join Filter: (rvr_7.erp_sales_return_id = r_7.id) |
| -> Seq Scan on tbl_erp_sales_returns r_7 (cost=0.00..1.01 rows=1 width=22) |
| Filter: (status <> 0) |
| -> Seq Scan on tbl_erp_sales_return_verify_rels rvr_7 (cost=0.00..1.04 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Seq Scan on tbl_erp_sales_return_stop_verify_rels rsvr_7 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 9" (cost=3.68..3.72 rows=1 width=20) |
| -> Group (cost=3.68..3.71 rows=1 width=305) |
| Group Key: r_8.id, rvr_8.status, rsvr_8.status |
| -> Sort (cost=3.68..3.68 rows=1 width=30) |
| Sort Key: r_8.id, rvr_8.status, rsvr_8.status |
| -> Hash Left Join (cost=2.44..3.67 rows=1 width=30) |
| Hash Cond: (r_8.id = rsvr_8.erp_purchase_gift_id) |
| Filter: ((CASE WHEN (1 = r_8.verify_type) THEN rvr_8.status ELSE CASE WHEN (r_8.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_8.status = 0) THEN NULL::integer ELSE rvr_8.status END END END = 1) OR (CASE WHEN (1 = r_8.verify_type) THEN rsvr_8.status ELSE CASE WHEN (r_8.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_8.status = 0) THEN NULL::integer ELSE rsvr_8.status END END END = 1) OR (CASE WHEN (1 = r_8.verify_type) THEN rvr_8.status ELSE CASE WHEN (r_8.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_8.status = 0) THEN NULL::integer ELSE rvr_8.status END END END = 2) OR (CASE WHEN (1 = r_8.verify_type) THEN rsvr_8.status ELSE CASE WHEN (r_8.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_8.status = 0) THEN NULL::integer ELSE rsvr_8.status END END END = 2)) |
| -> Hash Left Join (cost=1.35..2.50 rows=8 width=26) |
| Hash Cond: (r_8.id = rvr_8.erp_purchase_gift_id) |
| -> Seq Scan on tbl_erp_purchase_gifts r_8 (cost=0.00..1.11 rows=8 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=1.34..1.34 rows=1 width=8) |
| -> Seq Scan on tbl_erp_purchase_gift_verify_rels rvr_8 (cost=0.00..1.34 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.07..1.07 rows=1 width=8) |
| -> Seq Scan on tbl_erp_purchase_gift_stop_verify_rels rsvr_8 (cost=0.00..1.07 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 10" (cost=9.75..9.79 rows=1 width=20) |
| -> Group (cost=9.75..9.78 rows=1 width=305) |
| Group Key: r_9.id, rvr_9.status, rsvr_9.status |
| -> Sort (cost=9.75..9.75 rows=1 width=30) |
| Sort Key: r_9.id, rvr_9.status, rsvr_9.status |
| -> Hash Left Join (cost=5.43..9.74 rows=1 width=30) |
| Hash Cond: (r_9.id = rsvr_9.erp_sales_gift_id) |
| Filter: ((CASE WHEN (1 = r_9.verify_type) THEN rvr_9.status ELSE CASE WHEN (r_9.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_9.status = 0) THEN NULL::integer ELSE rvr_9.status END END END = 1) OR (CASE WHEN (1 = r_9.verify_type) THEN rsvr_9.status ELSE CASE WHEN (r_9.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_9.status = 0) THEN NULL::integer ELSE rsvr_9.status END END END = 1) OR (CASE WHEN (1 = r_9.verify_type) THEN rvr_9.status ELSE CASE WHEN (r_9.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_9.status = 0) THEN NULL::integer ELSE rvr_9.status END END END = 2) OR (CASE WHEN (1 = r_9.verify_type) THEN rsvr_9.status ELSE CASE WHEN (r_9.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_9.status = 0) THEN NULL::integer ELSE rsvr_9.status END END END = 2)) |
| -> Hash Left Join (cost=4.38..8.41 rows=62 width=26) |
| Hash Cond: (r_9.id = rvr_9.erp_sales_gift_id) |
| -> Seq Scan on tbl_erp_sales_gifts r_9 (cost=0.00..3.79 rows=62 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=4.36..4.36 rows=1 width=8) |
| -> Seq Scan on tbl_erp_sales_gift_verify_rels rvr_9 (cost=0.00..4.36 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.04..1.04 rows=1 width=8) |
| -> Seq Scan on tbl_erp_sales_gift_stop_verify_rels rsvr_9 (cost=0.00..1.04 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 11" (cost=81.30..82.77 rows=42 width=20) |
| -> HashAggregate (cost=81.30..82.34 rows=42 width=305) |
| Group Key: r_10.id, rvr_10.status, rsvr_10.status |
| -> Hash Left Join (cost=3.16..80.98 rows=42 width=30) |
| Hash Cond: (r_10.id = rsvr_10.erp_collect_ticket_id) |
| Filter: ((CASE WHEN (1 = r_10.verify_type) THEN rvr_10.status ELSE CASE WHEN (r_10.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_10.status = 0) THEN NULL::integer ELSE rvr_10.status END END END = 1) OR (CASE WHEN (1 = r_10.verify_type) THEN rsvr_10.status ELSE CASE WHEN (r_10.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_10.status = 0) THEN NULL::integer ELSE rsvr_10.status END END END = 1) OR (CASE WHEN (1 = r_10.verify_type) THEN rvr_10.status ELSE CASE WHEN (r_10.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_10.status = 0) THEN NULL::integer ELSE rvr_10.status END END END = 2) OR (CASE WHEN (1 = r_10.verify_type) THEN rsvr_10.status ELSE CASE WHEN (r_10.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_10.status = 0) THEN NULL::integer ELSE rsvr_10.status END END END = 2)) |
| -> Hash Left Join (cost=2.09..71.85 rows=2136 width=26) |
| Hash Cond: (r_10.id = rvr_10.erp_collect_ticket_id) |
| -> Seq Scan on tbl_erp_collect_tickets r_10 (cost=0.00..61.74 rows=2136 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=2.08..2.08 rows=1 width=8) |
| -> Seq Scan on tbl_erp_collect_ticket_verify_rels rvr_10 (cost=0.00..2.08 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.06..1.06 rows=1 width=8) |
| -> Seq Scan on tbl_erp_collect_ticket_stop_verify_rels rsvr_10 (cost=0.00..1.06 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 12" (cost=88.97..90.51 rows=44 width=20) |
| -> Group (cost=88.97..90.07 rows=44 width=305) |
| Group Key: r_11.id, rvr_11.status, rsvr_11.status |
| -> Sort (cost=88.97..89.08 rows=44 width=30) |
| Sort Key: r_11.id, rvr_11.status, rsvr_11.status |
| -> Hash Left Join (cost=3.61..87.77 rows=44 width=30) |
| Hash Cond: (r_11.id = rsvr_11.erp_payment_ticket_id) |
| Filter: ((CASE WHEN (1 = r_11.verify_type) THEN rvr_11.status ELSE CASE WHEN (r_11.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_11.status = 0) THEN NULL::integer ELSE rvr_11.status END END END = 1) OR (CASE WHEN (1 = r_11.verify_type) THEN rsvr_11.status ELSE CASE WHEN (r_11.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_11.status = 0) THEN NULL::integer ELSE rsvr_11.status END END END = 1) OR (CASE WHEN (1 = r_11.verify_type) THEN rvr_11.status ELSE CASE WHEN (r_11.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_11.status = 0) THEN NULL::integer ELSE rvr_11.status END END END = 2) OR (CASE WHEN (1 = r_11.verify_type) THEN rsvr_11.status ELSE CASE WHEN (r_11.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_11.status = 0) THEN NULL::integer ELSE rsvr_11.status END END END = 2)) |
| -> Hash Left Join (cost=2.49..78.35 rows=2200 width=26) |
| Hash Cond: (r_11.id = rvr_11.erp_payment_ticket_id) |
| -> Seq Scan on tbl_erp_payment_tickets r_11 (cost=0.00..67.60 rows=2200 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=2.48..2.48 rows=1 width=8) |
| -> Seq Scan on tbl_erp_payment_ticket_verify_rels rvr_11 (cost=0.00..2.48 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.11..1.11 rows=1 width=8) |
| -> Seq Scan on tbl_erp_payment_ticket_stop_verify_rels rsvr_11 (cost=0.00..1.11 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 13" (cost=26.27..26.31 rows=1 width=20) |
| -> Group (cost=26.27..26.30 rows=1 width=305) |
| Group Key: r_12.id, rvr_12.status, rsvr_12.status |
| -> Sort (cost=26.27..26.28 rows=1 width=30) |
| Sort Key: r_12.id, rvr_12.status, rsvr_12.status |
| -> Hash Left Join (cost=3.98..26.26 rows=1 width=30) |
| Hash Cond: (r_12.id = rvr_12.erp_cost_ticket_id) |
| Filter: ((CASE WHEN (1 = r_12.verify_type) THEN rvr_12.status ELSE CASE WHEN (r_12.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_12.status = 0) THEN NULL::integer ELSE rvr_12.status END END END = 1) OR (CASE WHEN (1 = r_12.verify_type) THEN rsvr_12.status ELSE CASE WHEN (r_12.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_12.status = 0) THEN NULL::integer ELSE rsvr_12.status END END END = 1) OR (CASE WHEN (1 = r_12.verify_type) THEN rvr_12.status ELSE CASE WHEN (r_12.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_12.status = 0) THEN NULL::integer ELSE rvr_12.status END END END = 2) OR (CASE WHEN (1 = r_12.verify_type) THEN rsvr_12.status ELSE CASE WHEN (r_12.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_12.status = 0) THEN NULL::integer ELSE rsvr_12.status END END END = 2)) |
| -> Hash Right Join (cost=2.66..24.80 rows=26 width=26) |
| Hash Cond: (rsvr_12.erp_cost_ticket_id = r_12.id) |
| -> Seq Scan on tbl_erp_cost_ticket_stop_verify_rels rsvr_12 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=2.34..2.34 rows=26 width=22) |
| -> Seq Scan on tbl_erp_cost_tickets r_12 (cost=0.00..2.34 rows=26 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=1.30..1.30 rows=1 width=8) |
| -> Seq Scan on tbl_erp_cost_ticket_verify_rels rvr_12 (cost=0.00..1.30 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 14" (cost=24.98..25.02 rows=1 width=20) |
| -> Group (cost=24.98..25.01 rows=1 width=305) |
| Group Key: r_13.id, rvr_13.status, rsvr_13.status |
| -> Sort (cost=24.98..24.98 rows=1 width=30) |
| Sort Key: r_13.id, rvr_13.status, rsvr_13.status |
| -> Hash Left Join (cost=2.71..24.97 rows=1 width=30) |
| Hash Cond: (r_13.id = rvr_13.erp_other_income_ticket_id) |
| Filter: ((CASE WHEN (1 = r_13.verify_type) THEN rvr_13.status ELSE CASE WHEN (r_13.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_13.status = 0) THEN NULL::integer ELSE rvr_13.status END END END = 1) OR (CASE WHEN (1 = r_13.verify_type) THEN rsvr_13.status ELSE CASE WHEN (r_13.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_13.status = 0) THEN NULL::integer ELSE rsvr_13.status END END END = 1) OR (CASE WHEN (1 = r_13.verify_type) THEN rvr_13.status ELSE CASE WHEN (r_13.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_13.status = 0) THEN NULL::integer ELSE rvr_13.status END END END = 2) OR (CASE WHEN (1 = r_13.verify_type) THEN rsvr_13.status ELSE CASE WHEN (r_13.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_13.status = 0) THEN NULL::integer ELSE rsvr_13.status END END END = 2)) |
| -> Hash Right Join (cost=1.46..23.60 rows=18 width=26) |
| Hash Cond: (rsvr_13.erp_other_income_ticket_id = r_13.id) |
| -> Seq Scan on tbl_erp_other_income_ticket_stop_verify_rels rsvr_13 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.24..1.24 rows=18 width=22) |
| -> Seq Scan on tbl_erp_other_income_tickets r_13 (cost=0.00..1.24 rows=18 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=1.24..1.24 rows=1 width=8) |
| -> Seq Scan on tbl_erp_other_income_ticket_verify_rels rvr_13 (cost=0.00..1.24 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 15" (cost=24.55..24.59 rows=1 width=20) |
| -> Group (cost=24.55..24.58 rows=1 width=305) |
| Group Key: r_14.id, rvr_14.status, rsvr_14.status |
| -> Sort (cost=24.55..24.55 rows=1 width=30) |
| Sort Key: r_14.id, rvr_14.status, rsvr_14.status |
| -> Hash Left Join (cost=1.06..24.54 rows=1 width=30) |
| Hash Cond: (r_14.id = rvr_14.erp_cost_convert_ticket_id) |
| Filter: ((CASE WHEN (1 = r_14.verify_type) THEN rvr_14.status ELSE CASE WHEN (r_14.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_14.status = 0) THEN NULL::integer ELSE rvr_14.status END END END = 1) OR (CASE WHEN (1 = r_14.verify_type) THEN rsvr_14.status ELSE CASE WHEN (r_14.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_14.status = 0) THEN NULL::integer ELSE rsvr_14.status END END END = 1) OR (CASE WHEN (1 = r_14.verify_type) THEN rvr_14.status ELSE CASE WHEN (r_14.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_14.status = 0) THEN NULL::integer ELSE rvr_14.status END END END = 2) OR (CASE WHEN (1 = r_14.verify_type) THEN rsvr_14.status ELSE CASE WHEN (r_14.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_14.status = 0) THEN NULL::integer ELSE rsvr_14.status END END END = 2)) |
| -> Nested Loop Left Join (cost=0.00..23.41 rows=4 width=26) |
| Join Filter: (rsvr_14.erp_cost_convert_ticket_id = r_14.id) |
| -> Seq Scan on tbl_erp_cost_convert_tickets r_14 (cost=0.00..1.05 rows=3 width=22) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..22.15 rows=5 width=8) |
| -> Seq Scan on tbl_erp_cost_convert_ticket_stop_verify_rels rsvr_14 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.05..1.05 rows=1 width=8) |
| -> Seq Scan on tbl_erp_cost_convert_ticket_verify_rels rvr_14 (cost=0.00..1.05 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 16" (cost=3.65..3.69 rows=1 width=20) |
| -> Group (cost=3.65..3.68 rows=1 width=305) |
| Group Key: r_15.id, rvr_15.status, rsvr_15.status |
| -> Sort (cost=3.65..3.66 rows=1 width=30) |
| Sort Key: r_15.id, rvr_15.status, rsvr_15.status |
| -> Hash Left Join (cost=2.35..3.64 rows=1 width=30) |
| Hash Cond: (r_15.id = rsvr_15.erp_bank_transfer_ticket_id) |
| Filter: ((CASE WHEN (1 = r_15.verify_type) THEN rvr_15.status ELSE CASE WHEN (r_15.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_15.status = 0) THEN NULL::integer ELSE rvr_15.status END END END = 1) OR (CASE WHEN (1 = r_15.verify_type) THEN rsvr_15.status ELSE CASE WHEN (r_15.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_15.status = 0) THEN NULL::integer ELSE rsvr_15.status END END END = 1) OR (CASE WHEN (1 = r_15.verify_type) THEN rvr_15.status ELSE CASE WHEN (r_15.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_15.status = 0) THEN NULL::integer ELSE rvr_15.status END END END = 2) OR (CASE WHEN (1 = r_15.verify_type) THEN rsvr_15.status ELSE CASE WHEN (r_15.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_15.status = 0) THEN NULL::integer ELSE rsvr_15.status END END END = 2)) |
| -> Hash Left Join (cost=1.31..2.51 rows=11 width=26) |
| Hash Cond: (r_15.id = rvr_15.erp_bank_transfer_ticket_id) |
| -> Seq Scan on tbl_erp_bank_transfer_tickets r_15 (cost=0.00..1.15 rows=11 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=1.30..1.30 rows=1 width=8) |
| -> Seq Scan on tbl_erp_bank_transfer_ticket_verify_rels rvr_15 (cost=0.00..1.30 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.02..1.02 rows=1 width=8) |
| -> Seq Scan on tbl_erp_bank_transfer_ticket_stop_verify_rels rsvr_15 (cost=0.00..1.02 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 17" (cost=733.17..738.63 rows=156 width=20) |
| -> Group (cost=733.17..737.07 rows=156 width=305) |
| Group Key: r_16.id, rvr_16.status, rsvr_16.status |
| -> Sort (cost=733.17..733.56 rows=156 width=30) |
| Sort Key: r_16.id, rvr_16.status, rsvr_16.status |
| -> Hash Left Join (cost=363.65..727.49 rows=156 width=30) |
| Hash Cond: (r_16.id = rsvr_16.erp_cash_cost_ticket_id) |
| Filter: ((CASE WHEN (1 = r_16.verify_type) THEN rvr_16.status ELSE CASE WHEN (r_16.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_16.status = 0) THEN NULL::integer ELSE rvr_16.status END END END = 1) OR (CASE WHEN (1 = r_16.verify_type) THEN rsvr_16.status ELSE CASE WHEN (r_16.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_16.status = 0) THEN NULL::integer ELSE rsvr_16.status END END END = 1) OR (CASE WHEN (1 = r_16.verify_type) THEN rvr_16.status ELSE CASE WHEN (r_16.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_16.status = 0) THEN NULL::integer ELSE rvr_16.status END END END = 2) OR (CASE WHEN (1 = r_16.verify_type) THEN rsvr_16.status ELSE CASE WHEN (r_16.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_16.status = 0) THEN NULL::integer ELSE rsvr_16.status END END END = 2)) |
| -> Hash Left Join (cost=362.59..696.94 rows=7849 width=26) |
| Hash Cond: (r_16.id = rvr_16.erp_cash_cost_ticket_id) |
| -> Seq Scan on tbl_erp_cash_cost_tickets r_16 (cost=0.00..275.14 rows=7849 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=362.15..362.15 rows=35 width=8) |
| -> Seq Scan on tbl_erp_cash_cost_ticket_verify_rels rvr_16 (cost=0.00..362.15 rows=35 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.05..1.05 rows=1 width=8) |
| -> Seq Scan on tbl_erp_cash_cost_ticket_stop_verify_rels rsvr_16 (cost=0.00..1.05 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 18" (cost=57.83..57.94 rows=3 width=20) |
| -> Group (cost=57.83..57.91 rows=3 width=305) |
| Group Key: r_17.id, rvr_17.status, rsvr_17.status |
| -> Sort (cost=57.83..57.84 rows=3 width=30) |
| Sort Key: r_17.id, rvr_17.status, rsvr_17.status |
| -> Hash Left Join (cost=44.38..57.81 rows=3 width=30) |
| Hash Cond: (r_17.id = rsvr_17.erp_advance_payment_ticket_id) |
| Filter: ((CASE WHEN (1 = r_17.verify_type) THEN rvr_17.status ELSE CASE WHEN (r_17.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_17.status = 0) THEN NULL::integer ELSE rvr_17.status END END END = 1) OR (CASE WHEN (1 = r_17.verify_type) THEN rsvr_17.status ELSE CASE WHEN (r_17.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_17.status = 0) THEN NULL::integer ELSE rsvr_17.status END END END = 1) OR (CASE WHEN (1 = r_17.verify_type) THEN rvr_17.status ELSE CASE WHEN (r_17.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_17.status = 0) THEN NULL::integer ELSE rvr_17.status END END END = 2) OR (CASE WHEN (1 = r_17.verify_type) THEN rsvr_17.status ELSE CASE WHEN (r_17.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_17.status = 0) THEN NULL::integer ELSE rsvr_17.status END END END = 2)) |
| -> Hash Left Join (cost=22.19..34.82 rows=159 width=26) |
| Hash Cond: (r_17.id = rvr_17.erp_advance_payment_ticket_id) |
| -> Seq Scan on tbl_erp_advance_payment_tickets r_17 (cost=0.00..12.00 rows=159 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=8) |
| -> Seq Scan on tbl_erp_advance_payment_ticket_verify_rels rvr_17 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=22.12..22.12 rows=5 width=8) |
| -> Seq Scan on tbl_erp_advance_payment_ticket_stop_verify_rels rsvr_17 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 19" (cost=27.44..27.47 rows=1 width=20) |
| -> Group (cost=27.44..27.46 rows=1 width=305) |
| Group Key: r_18.id, rvr_18.status, rsvr_18.status |
| -> Sort (cost=27.44..27.44 rows=1 width=30) |
| Sort Key: r_18.id, rvr_18.status, rsvr_18.status |
| -> Hash Left Join (cost=23.30..27.43 rows=1 width=30) |
| Hash Cond: (r_18.id = rsvr_18.erp_other_payment_ticket_id) |
| Filter: ((CASE WHEN (1 = r_18.verify_type) THEN rvr_18.status ELSE CASE WHEN (r_18.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_18.status = 0) THEN NULL::integer ELSE rvr_18.status END END END = 1) OR (CASE WHEN (1 = r_18.verify_type) THEN rsvr_18.status ELSE CASE WHEN (r_18.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_18.status = 0) THEN NULL::integer ELSE rsvr_18.status END END END = 1) OR (CASE WHEN (1 = r_18.verify_type) THEN rvr_18.status ELSE CASE WHEN (r_18.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_18.status = 0) THEN NULL::integer ELSE rvr_18.status END END END = 2) OR (CASE WHEN (1 = r_18.verify_type) THEN rsvr_18.status ELSE CASE WHEN (r_18.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_18.status = 0) THEN NULL::integer ELSE rsvr_18.status END END END = 2)) |
| -> Hash Left Join (cost=1.11..4.99 rows=52 width=26) |
| Hash Cond: (r_18.id = rvr_18.erp_other_payment_ticket_id) |
| -> Seq Scan on tbl_erp_other_payment_tickets r_18 (cost=0.00..3.67 rows=52 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=1.10..1.10 rows=1 width=8) |
| -> Seq Scan on tbl_erp_other_payment_ticket_verify_rels rvr_18 (cost=0.00..1.10 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=22.12..22.12 rows=5 width=8) |
| -> Seq Scan on tbl_erp_other_payment_ticket_stop_verify_rels rsvr_18 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 20" (cost=4.89..4.93 rows=1 width=20) |
| -> Group (cost=4.89..4.92 rows=1 width=305) |
| Group Key: r_19.id, rvr_19.status, rsvr_19.status |
| -> Sort (cost=4.89..4.90 rows=1 width=30) |
| Sort Key: r_19.id, rvr_19.status, rsvr_19.status |
| -> Hash Left Join (cost=2.31..4.88 rows=1 width=30) |
| Hash Cond: (r_19.id = rsvr_19.erp_other_collect_ticket_id) |
| Filter: ((CASE WHEN (1 = r_19.verify_type) THEN rvr_19.status ELSE CASE WHEN (r_19.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_19.status = 0) THEN NULL::integer ELSE rvr_19.status END END END = 1) OR (CASE WHEN (1 = r_19.verify_type) THEN rsvr_19.status ELSE CASE WHEN (r_19.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_19.status = 0) THEN NULL::integer ELSE rsvr_19.status END END END = 1) OR (CASE WHEN (1 = r_19.verify_type) THEN rvr_19.status ELSE CASE WHEN (r_19.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_19.status = 0) THEN NULL::integer ELSE rvr_19.status END END END = 2) OR (CASE WHEN (1 = r_19.verify_type) THEN rsvr_19.status ELSE CASE WHEN (r_19.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_19.status = 0) THEN NULL::integer ELSE rsvr_19.status END END END = 2)) |
| -> Hash Left Join (cost=1.29..3.72 rows=25 width=26) |
| Hash Cond: (r_19.id = rvr_19.erp_other_collect_ticket_id) |
| -> Seq Scan on tbl_erp_other_collect_tickets r_19 (cost=0.00..2.33 rows=25 width=22) |
| Filter: (status <> 0) |
| -> Hash (cost=1.27..1.27 rows=1 width=8) |
| -> Seq Scan on tbl_erp_other_collect_ticket_verify_rels rvr_19 (cost=0.00..1.27 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.01..1.01 rows=1 width=8) |
| -> Seq Scan on tbl_erp_other_collect_ticket_stop_verify_rels rsvr_19 (cost=0.00..1.01 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 21" (cost=7.08..7.17 rows=2 width=20) |
| -> Group (cost=7.08..7.15 rows=2 width=309) |
| Group Key: r_20.id, rvr_20.status, rsvr_20.status, rcvr_2.status |
| -> Sort (cost=7.08..7.09 rows=2 width=38) |
| Sort Key: r_20.id, rvr_20.status, rsvr_20.status, rcvr_2.status |
| -> Hash Left Join (cost=3.71..7.07 rows=2 width=38) |
| Hash Cond: (r_20.id = rcvr_2.erp_purchase_cost_id) |
| Filter: ((CASE WHEN (1 = r_20.verify_type) THEN rvr_20.status ELSE CASE WHEN (r_20.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_20.status = 0) THEN NULL::integer ELSE rvr_20.status END END END = 1) OR (CASE WHEN (1 = r_20.verify_type) THEN rsvr_20.status ELSE CASE WHEN (r_20.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_20.status = 0) THEN NULL::integer ELSE rsvr_20.status END END END = 1) OR (CASE WHEN (1 = r_20.verify_type) THEN rcvr_2.status ELSE CASE WHEN (r_20.next_cancel_verify_user = 5064) THEN 0 ELSE CASE WHEN (rcvr_2.status = 0) THEN NULL::integer ELSE rcvr_2.status END END END = 1) OR (CASE WHEN (1 = r_20.verify_type) THEN rvr_20.status ELSE CASE WHEN (r_20.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_20.status = 0) THEN NULL::integer ELSE rvr_20.status END END END = 2) OR (CASE WHEN (1 = r_20.verify_type) THEN rsvr_20.status ELSE CASE WHEN (r_20.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_20.status = 0) THEN NULL::integer ELSE rsvr_20.status END END END = 2) OR (CASE WHEN (1 = r_20.verify_type) THEN rcvr_2.status ELSE CASE WHEN (r_20.next_cancel_verify_user = 5064) THEN 0 ELSE CASE WHEN (rcvr_2.status = 0) THEN NULL::integer ELSE rcvr_2.status END END END = 2)) |
| -> Hash Left Join (cost=2.68..5.77 rows=53 width=34) |
| Hash Cond: (r_20.id = rsvr_20.erp_purchase_cost_id) |
| -> Hash Left Join (cost=1.59..4.47 rows=53 width=30) |
| Hash Cond: (r_20.id = rvr_20.erp_purchase_cost_id) |
| -> Seq Scan on tbl_erp_purchase_costs r_20 (cost=0.00..2.67 rows=53 width=26) |
| Filter: (status <> 0) |
| -> Hash (cost=1.58..1.58 rows=1 width=8) |
| -> Seq Scan on tbl_erp_purchase_cost_verify_rels rvr_20 (cost=0.00..1.58 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.07..1.07 rows=1 width=8) |
| -> Seq Scan on tbl_erp_purchase_cost_stop_verify_rels rsvr_20 (cost=0.00..1.07 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.02..1.02 rows=1 width=8) |
| -> Seq Scan on tbl_erp_purchase_cost_cancel_verify_rels rcvr_2 (cost=0.00..1.02 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 22" (cost=24.55..24.59 rows=1 width=20) |
| -> Group (cost=24.55..24.58 rows=1 width=305) |
| Group Key: r_21.id, rvr_21.status, rsvr_21.status |
| -> Sort (cost=24.55..24.55 rows=1 width=30) |
| Sort Key: r_21.id, rvr_21.status, rsvr_21.status |
| -> Hash Left Join (cost=1.06..24.54 rows=1 width=30) |
| Hash Cond: (r_21.id = rvr_21.erp_wage_ticket_id) |
| Filter: ((CASE WHEN (1 = r_21.verify_type) THEN rvr_21.status ELSE CASE WHEN (r_21.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_21.status = 0) THEN NULL::integer ELSE rvr_21.status END END END = 1) OR (CASE WHEN (1 = r_21.verify_type) THEN rsvr_21.status ELSE CASE WHEN (r_21.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_21.status = 0) THEN NULL::integer ELSE rsvr_21.status END END END = 1) OR (CASE WHEN (1 = r_21.verify_type) THEN rvr_21.status ELSE CASE WHEN (r_21.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_21.status = 0) THEN NULL::integer ELSE rvr_21.status END END END = 2) OR (CASE WHEN (1 = r_21.verify_type) THEN rsvr_21.status ELSE CASE WHEN (r_21.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_21.status = 0) THEN NULL::integer ELSE rsvr_21.status END END END = 2)) |
| -> Nested Loop Left Join (cost=0.00..23.41 rows=4 width=26) |
| Join Filter: (rsvr_21.erp_wage_ticket_id = r_21.id) |
| -> Seq Scan on tbl_erp_wage_tickets r_21 (cost=0.00..1.05 rows=3 width=22) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..22.15 rows=5 width=8) |
| -> Seq Scan on tbl_erp_wage_ticket_stop_verify_rels rsvr_21 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.05..1.05 rows=1 width=8) |
| -> Seq Scan on tbl_erp_wage_ticket_verify_rels rvr_21 (cost=0.00..1.05 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 23" (cost=24.71..24.75 rows=1 width=20) |
| -> Group (cost=24.71..24.74 rows=1 width=305) |
| Group Key: r_22.id, rvr_22.status, rsvr_22.status |
| -> Sort (cost=24.71..24.72 rows=1 width=30) |
| Sort Key: r_22.id, rvr_22.status, rsvr_22.status |
| -> Nested Loop Left Join (cost=1.14..24.70 rows=1 width=30) |
| Join Filter: (rvr_22.erp_social_insurance_id = r_22.id) |
| Filter: ((CASE WHEN (1 = r_22.verify_type) THEN rvr_22.status ELSE CASE WHEN (r_22.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_22.status = 0) THEN NULL::integer ELSE rvr_22.status END END END = 1) OR (CASE WHEN (1 = r_22.verify_type) THEN rsvr_22.status ELSE CASE WHEN (r_22.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_22.status = 0) THEN NULL::integer ELSE rsvr_22.status END END END = 1) OR (CASE WHEN (1 = r_22.verify_type) THEN rvr_22.status ELSE CASE WHEN (r_22.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_22.status = 0) THEN NULL::integer ELSE rvr_22.status END END END = 2) OR (CASE WHEN (1 = r_22.verify_type) THEN rsvr_22.status ELSE CASE WHEN (r_22.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_22.status = 0) THEN NULL::integer ELSE rsvr_22.status END END END = 2)) |
| -> Hash Right Join (cost=1.14..23.28 rows=5 width=26) |
| Hash Cond: (rsvr_22.erp_social_insurance_id = r_22.id) |
| -> Seq Scan on tbl_erp_social_insurance_stop_verify_rels rsvr_22 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.07..1.07 rows=5 width=22) |
| -> Seq Scan on tbl_erp_social_insurances r_22 (cost=0.00..1.07 rows=5 width=22) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..1.15 rows=1 width=8) |
| -> Seq Scan on tbl_erp_social_insurance_verify_rels rvr_22 (cost=0.00..1.15 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 24" (cost=24.58..24.61 rows=1 width=20) |
| -> Group (cost=24.58..24.60 rows=1 width=305) |
| Group Key: r_23.id, rvr_23.status, rsvr_23.status |
| -> Sort (cost=24.58..24.58 rows=1 width=30) |
| Sort Key: r_23.id, rvr_23.status, rsvr_23.status |
| -> Nested Loop Left Join (cost=0.00..24.57 rows=1 width=30) |
| Join Filter: (rvr_23.erp_provident_fund_id = r_23.id) |
| Filter: ((CASE WHEN (1 = r_23.verify_type) THEN rvr_23.status ELSE CASE WHEN (r_23.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_23.status = 0) THEN NULL::integer ELSE rvr_23.status END END END = 1) OR (CASE WHEN (1 = r_23.verify_type) THEN rsvr_23.status ELSE CASE WHEN (r_23.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_23.status = 0) THEN NULL::integer ELSE rsvr_23.status END END END = 1) OR (CASE WHEN (1 = r_23.verify_type) THEN rvr_23.status ELSE CASE WHEN (r_23.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_23.status = 0) THEN NULL::integer ELSE rvr_23.status END END END = 2) OR (CASE WHEN (1 = r_23.verify_type) THEN rsvr_23.status ELSE CASE WHEN (r_23.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_23.status = 0) THEN NULL::integer ELSE rsvr_23.status END END END = 2)) |
| -> Nested Loop Left Join (cost=0.00..23.32 rows=3 width=26) |
| Join Filter: (rsvr_23.erp_provident_fund_id = r_23.id) |
| -> Seq Scan on tbl_erp_provident_funds r_23 (cost=0.00..1.04 rows=2 width=22) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..22.15 rows=5 width=8) |
| -> Seq Scan on tbl_erp_provident_fund_stop_verify_rels rsvr_23 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Materialize (cost=0.00..1.08 rows=1 width=8) |
| -> Seq Scan on tbl_erp_provident_fund_verify_rels rvr_23 (cost=0.00..1.07 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 25" (cost=24.55..24.59 rows=1 width=20) |
| -> Group (cost=24.55..24.58 rows=1 width=305) |
| Group Key: r_24.id, rvr_24.status, rsvr_24.status |
| -> Sort (cost=24.55..24.55 rows=1 width=30) |
| Sort Key: r_24.id, rvr_24.status, rsvr_24.status |
| -> Hash Left Join (cost=1.06..24.54 rows=1 width=30) |
| Hash Cond: (r_24.id = rvr_24.erp_personal_tax_id) |
| Filter: ((CASE WHEN (1 = r_24.verify_type) THEN rvr_24.status ELSE CASE WHEN (r_24.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_24.status = 0) THEN NULL::integer ELSE rvr_24.status END END END = 1) OR (CASE WHEN (1 = r_24.verify_type) THEN rsvr_24.status ELSE CASE WHEN (r_24.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_24.status = 0) THEN NULL::integer ELSE rsvr_24.status END END END = 1) OR (CASE WHEN (1 = r_24.verify_type) THEN rvr_24.status ELSE CASE WHEN (r_24.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_24.status = 0) THEN NULL::integer ELSE rvr_24.status END END END = 2) OR (CASE WHEN (1 = r_24.verify_type) THEN rsvr_24.status ELSE CASE WHEN (r_24.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_24.status = 0) THEN NULL::integer ELSE rsvr_24.status END END END = 2)) |
| -> Nested Loop Left Join (cost=0.00..23.41 rows=4 width=26) |
| Join Filter: (rsvr_24.erp_personal_tax_id = r_24.id) |
| -> Seq Scan on tbl_erp_personal_taxs r_24 (cost=0.00..1.05 rows=3 width=22) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..22.15 rows=5 width=8) |
| -> Seq Scan on tbl_erp_personal_tax_stop_verify_rels rsvr_24 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=1.05..1.05 rows=1 width=8) |
| -> Seq Scan on tbl_erp_personal_tax_verify_rels rvr_24 (cost=0.00..1.05 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 26" (cost=24.54..24.58 rows=1 width=20) |
| -> Group (cost=24.54..24.57 rows=1 width=305) |
| Group Key: r_25.id, rvr_25.status, rsvr_25.status |
| -> Sort (cost=24.54..24.54 rows=1 width=30) |
| Sort Key: r_25.id, rvr_25.status, rsvr_25.status |
| -> Nested Loop Left Join (cost=0.00..24.53 rows=1 width=30) |
| Join Filter: (rvr_25.erp_wage_prize_id = r_25.id) |
| Filter: ((CASE WHEN (1 = r_25.verify_type) THEN rvr_25.status ELSE CASE WHEN (r_25.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_25.status = 0) THEN NULL::integer ELSE rvr_25.status END END END = 1) OR (CASE WHEN (1 = r_25.verify_type) THEN rsvr_25.status ELSE CASE WHEN (r_25.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_25.status = 0) THEN NULL::integer ELSE rsvr_25.status END END END = 1) OR (CASE WHEN (1 = r_25.verify_type) THEN rvr_25.status ELSE CASE WHEN (r_25.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_25.status = 0) THEN NULL::integer ELSE rvr_25.status END END END = 2) OR (CASE WHEN (1 = r_25.verify_type) THEN rsvr_25.status ELSE CASE WHEN (r_25.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_25.status = 0) THEN NULL::integer ELSE rsvr_25.status END END END = 2)) |
| -> Nested Loop Left Join (cost=0.00..23.32 rows=3 width=26) |
| Join Filter: (rsvr_25.erp_wage_prize_id = r_25.id) |
| -> Seq Scan on tbl_erp_wage_prizes r_25 (cost=0.00..1.04 rows=2 width=22) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..22.15 rows=5 width=8) |
| -> Seq Scan on tbl_erp_wage_prize_stop_verify_rels rsvr_25 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Materialize (cost=0.00..1.04 rows=1 width=8) |
| -> Seq Scan on tbl_erp_wage_prize_verify_rels rvr_25 (cost=0.00..1.04 rows=1 width=8) |
| Filter: (user_id = 5064) |
| -> Subquery Scan on "*SELECT* 27" (cost=59.33..59.55 rows=5 width=20) |
| -> GroupAggregate (cost=59.33..59.50 rows=5 width=305) |
| Group Key: r_26.id, rvr_26.status, rsvr_26.status |
| -> Sort (cost=59.33..59.34 rows=5 width=30) |
| Sort Key: r_26.id, rvr_26.status, rsvr_26.status |
| -> Hash Left Join (cost=44.38..59.27 rows=5 width=30) |
| Hash Cond: (r_26.id = rsvr_26.erp_profit_distribute_id) |
| Filter: ((CASE WHEN (1 = r_26.verify_type) THEN rvr_26.status ELSE CASE WHEN (r_26.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_26.status = 0) THEN NULL::integer ELSE rvr_26.status END END END = 1) OR (CASE WHEN (1 = r_26.verify_type) THEN rsvr_26.status ELSE CASE WHEN (r_26.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_26.status = 0) THEN NULL::integer ELSE rsvr_26.status END END END = 1) OR (CASE WHEN (1 = r_26.verify_type) THEN rvr_26.status ELSE CASE WHEN (r_26.next_verify_user = 5064) THEN 0 ELSE CASE WHEN (rvr_26.status = 0) THEN NULL::integer ELSE rvr_26.status END END END = 2) OR (CASE WHEN (1 = r_26.verify_type) THEN rsvr_26.status ELSE CASE WHEN (r_26.next_stop_verify_user = 5064) THEN 0 ELSE CASE WHEN (rsvr_26.status = 0) THEN NULL::integer ELSE rsvr_26.status END END END = 2)) |
| -> Hash Left Join (cost=22.19..35.97 rows=229 width=26) |
| Hash Cond: (r_26.id = rvr_26.erp_profit_distribute_id) |
| -> Seq Scan on tbl_erp_profit_distributes r_26 (cost=0.00..12.88 rows=229 width=26) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=8) |
| -> Seq Scan on tbl_erp_profit_distribute_verify_rels rvr_26 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |
| -> Hash (cost=22.12..22.12 rows=5 width=8) |
| -> Seq Scan on tbl_erp_profit_distribute_stop_verify_rels rsvr_26 (cost=0.00..22.12 rows=5 width=8) |
| Filter: (user_id = 5064) |