Complex sorting of objects?

Question

PostgreSQL

Good afternoon!
There is an online store site. It has many, many products and many categories.
There was an idea, is it possible to make a unique sorting of products for each combination of categories?
That is, there are three parameters, parameter1, parameter2, parameter3.
For example, if the user has selected parameter1, he has one sorting, parameter2 - another, three - the third.
I chose parameter 1, parameter 2 - one more.
Haven't figured out yet how to solve this for django without high database load ( postgresql ) and very perverted solutions.
Each parameter is a manytomany relation, that is, many different parameters can be bound.
I would be grateful for any ideas! Thank you!

Answer 1

Sort all options in advance and cache them.

Answer 2

After several hours, a complex solution was found that basically works)
Result - 1 query goes to the database, slightly modified by hand, that is, raw sql is executed)
Who cares about the result?)