What are the cons of implementing faceted search with WHEREs and JOINs?
You should have indexes on more of the fields; it gets tedious scanning all 7K rows.

What is the datatype of order; can it be the PRIMARY KEY and get rid if id?

Recommend you use standard 2-letter country_code instead of an extra table.  And declare it CHAR(2) CHARACTER SET ascii.

If you expect to have a million rows, I would say that you will have lots of performance problems.  But...  1K/minute is exciting; 1K/second is challenging; 1K/year is nothing. -- So, performance is not an issue.