E-commerce website, how to design exclusions do not like goods, how to design high efficiency?

Do not like the product to what kind of structure to save, but show the treasure many, each user does not like the product is the changeable, this how to do? Every time the user queries are to be done to delete the election, is it a waste of resources?

Reply content:

Do not like the product to what kind of structure to save, but show the treasure many, each user does not like the product is the changeable, this how to do? Every time the user queries are to be done to delete the election, is it a waste of resources?

Do not like the commodity table:
PRODUCT_ID, user_id

Inquire:
1, get the user's dislike Product ID list = Not_like_product_ids
2.SELECT * FROM product WHERE id NOT IN (not_like_product_ids) AND ...

Roughly so.

