perf: Faster lookup of search context repos
Created by: eseliger
- We drop the soft-deletion which seems not required here, so we don't need to join at all. @novoselrok is this alright with you?
- We change the order of fields in the unique index so a lookup by repo id is cheap (what we always use to query)