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