WIP: CS-5432

First draft for optimizing backend search.

Please merge takeit's sql_optimize branch first.
translation domain should be `authors` not `author`, there isnt author.en.yml file but authors.en.yml