QUERY PLAN
Nested Loop (cost=0.00..8.28 rows=1 width=621)
Join Filter: (eipsn.erp_inventory_product_id = eip.id)
-> Seq Scan on tbl_erp_inventory_product_sns eipsn (cost=0.00..1.14 rows=1 width=621)
Filter: ((sn)::text = '556565656'::text)
-> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..7.09 rows=4 width=4)
Filter: (product_id = 1624)