| Limit (cost=284.52..284.57 rows=20 width=150) |
| -> Sort (cost=284.52..287.25 rows=1089 width=150) |
| Sort Key: c.pinyin1, c.namecut1, c.pinyin2, c.namecut2, c.pinyin3, c.namecut3, c.pinyin4, c.namecut4, c.created_by, c.created_at DESC |
| -> HashAggregate (cost=244.66..255.55 rows=1089 width=150) |
| Group Key: c.id |
| -> Hash Right Join (cost=153.45..241.93 rows=1089 width=150) |
| 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=1089 width=150) |
| -> Seq Scan on tbl_contacts c (cost=0.00..139.84 rows=1089 width=150) |
| Filter: ((supplier_id IS NOT NULL) AND ((supplier_id IS NOT NULL) OR (client_id IS NOT NULL))) |