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