Ensure fts is prefered over trigram and use union_all instead of union in user search query
Union does not guarantee that second query is appended to the first one so instead we add a search_type
field and order by that before filtering by distinct user id. Also changed union
to union_all
because it is significantly faster and deduping is done by distinct
anyway