How to save tags to something?

Question

symfony

For example, goods are stored in one table. You can then add a tag to each. There is a separate table for tags. For communication product tags the third table. During post-moderation, you need to remove a certain tag.
* delete tag
* delete product-tag links
Problem when selecting a list of products. One request does not work - for 50 products, 50 requests for tags. Do denormalization for the list of tags of each product - then when the tag is deleted (moderation), this table is difficult to update, and there may be a data discrepancy. How is this solved in Symfony+Doctrine?

Answer 1

Denormalizing tags is insanity IMHO.
* delete tag
* delete product-tag links
Use foreign keys with CASCADE on DELETE.

Answer 2

I also think that QueryBuilder is needed here and joining records using Left Join, then it will be possible to filter by tags. In general, it is better to always do complex bundles through QueryBuilder in order to avoid a large number of queries IMHO.