| Aggregate (cost=131.66..131.67 rows=1 width=32) |
| -> Nested Loop (cost=123.56..131.65 rows=1 width=14) |
| -> HashAggregate (cost=123.28..123.29 rows=1 width=4) |
| Group Key: ip.id |
| -> Group (cost=123.26..123.27 rows=1 width=8) |
| Group Key: ip.id, pci.id |
| -> Sort (cost=123.26..123.27 rows=1 width=8) |
| Sort Key: ip.id, pci.id |
| -> Nested Loop Left Join (cost=8.31..123.25 rows=1 width=8) |
| -> Seq Scan on tbl_inventory_products ip (cost=0.00..79.28 rows=1 width=8) |
| Filter: ((inventory > '0'::numeric) AND (lower(description) = '*计算机配套产品*内存'::text) AND (lower((title)::text) = '16g'::text)) |
| -> Hash Right Join (cost=8.31..43.97 rows=1 width=4) |
| Hash Cond: (pip.purchase_invoice_id = pci.id) |
| -> Seq Scan on tbl_purchase_invoice_projects pip (cost=0.00..30.52 rows=1952 width=8) |
| -> Hash (cost=8.30..8.30 rows=1 width=8) |
| -> Index Scan using tbl_purchase_contract_invoices_pkey on tbl_purchase_contract_invoices pci (cost=0.28..8.30 rows=1 width=8) |
| Index Cond: (ip.purchase_invoice_id = id) |
| -> Index Scan using tbl_inventory_products_pkey on tbl_inventory_products (cost=0.28..8.30 rows=1 width=18) |
| Index Cond: (id = ip.id) |
| Filter: (inventory > '0'::numeric) |