| Limit (cost=0.00..128.21 rows=1 width=54) |
| -> Nested Loop Left Join (cost=0.00..128.21 rows=1 width=54) |
| Join Filter: (c.sales_rep = u.id) |
| -> Seq Scan on tbl_clients c (cost=0.00..118.97 rows=1 width=49) |
| Filter: ((NOT deleted) AND (sales_rep IS NOT NULL) AND (((name)::text ~~* '%中国信息安全研究所%'::text) OR (pinyin_shortcut ~~* '%中国信息安全研究所%'::text))) |
| -> Seq Scan on tbl_users u (cost=0.00..7.44 rows=144 width=13) |