Limit (cost=8.83..8.84 rows=1 width=265) |
-> Sort (cost=8.83..8.84 rows=1 width=265) |
Sort Key: updated_at DESC |
-> Seq Scan on tbl_users (cost=0.00..8.82 rows=1 width=265) |
Filter: ((user_status = ANY ('{1,2}'::type_global_user_status[])) AND (((name)::text ~~* '%yyx%'::text) OR ((email)::text ~~* '%yyx%'::text) OR (pinyin_shortcut ~~* '%yyx%'::text))) |