| Limit (cost=9.24..34.61 rows=20 width=54) |
| -> Hash Left Join (cost=9.24..128.46 rows=94 width=54) |
| Hash Cond: (c.sales_rep = u.id) |
| -> Seq Scan on tbl_clients c (cost=0.00..118.97 rows=94 width=49) |
| Filter: ((NOT deleted) AND (sales_rep IS NOT NULL) AND (((name)::text ~~* '%信息%'::text) OR (pinyin_shortcut ~~* '%信息%'::text))) |
| -> Hash (cost=7.44..7.44 rows=144 width=13) |
| -> Seq Scan on tbl_users u (cost=0.00..7.44 rows=144 width=13) |