Limit (cost=0.00..123.37 rows=1 width=54) |
-> Nested Loop Left Join (cost=0.00..123.37 rows=1 width=54) |
Join Filter: (c.sales_rep = u.id) |
-> Seq Scan on tbl_clients c (cost=0.00..114.25 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.39 rows=139 width=13) |