| Sort (cost=333.78..337.20 rows=1368 width=57) |
| Sort Key: c.pinyin1, c.namecut1, c.pinyin2, c.namecut2, c.pinyin3, c.namecut3, c.pinyin4, c.namecut4, c.created_at DESC |
| -> HashAggregate (cost=248.84..262.52 rows=1368 width=57) |
| Group Key: c.id |
| -> Hash Right Join (cost=156.94..245.42 rows=1368 width=57) |
| Hash Cond: (cm.contact_id = c.id) |
| -> Seq Scan on tbl_contact_mobiles cm (cost=0.00..76.52 rows=4552 width=4) |
| -> Hash (cost=139.84..139.84 rows=1368 width=57) |
| -> Seq Scan on tbl_contacts c (cost=0.00..139.84 rows=1368 width=57) |
| Filter: (supplier_id IS NOT NULL) |