| Nested Loop Left Join (cost=0.00..20.40 rows=1 width=296) |
| Join Filter: (u.enterprise_id = e.id) |
| Filter: ((COALESCE(e.schema_id, 'global'::character varying))::text <> 'global'::text) |
| -> Seq Scan on tbl_logins u (cost=0.00..19.34 rows=2 width=259) |
| Filter: (((email)::text = 'lrc@toast.com.cn'::text) OR ((mobile)::text = 'lrc@toast.com.cn'::text)) |
| -> Materialize (cost=0.00..1.01 rows=1 width=29) |
| -> Seq Scan on tbl_enterprises e (cost=0.00..1.01 rows=1 width=29) |