| Sort (cost=180.21..180.36 rows=62 width=57) |
| Sort Key: c.pinyin1, c.namecut1, c.pinyin2, c.namecut2, c.pinyin3, c.namecut3, c.pinyin4, c.namecut4, c.created_at DESC |
| -> Group (cost=178.05..178.36 rows=62 width=57) |
| Group Key: c.id |
| -> Sort (cost=178.05..178.21 rows=62 width=57) |
| Sort Key: c.id |
| -> Hash Left Join (cost=35.93..176.21 rows=62 width=57) |
| Hash Cond: (c.supplier_id = s.id) |
| Filter: (((c.name)::text ~~* '%高%'::text) OR (c.pinyin_shortcut ~~* '%高%'::text) OR ((s.name)::text ~~* '%高%'::text) OR ((s.main_products)::text ~~* '%高%'::text)) |
| -> Seq Scan on tbl_contacts c (cost=0.00..136.75 rows=1337 width=60) |
| Filter: (supplier_id IS NOT NULL) |
| -> Hash (cost=28.19..28.19 rows=619 width=83) |
| -> Seq Scan on tbl_suppliers s (cost=0.00..28.19 rows=619 width=83) |