How bad is it to use such a request?

Question

MySQL

I'm making a kind of online store on Laravel. And Eloquent offers this query option:

select * from `products` where exists (
    select `id` from `properties_values_int`
    where `products`.`id` = `properties_values_int`.`product_id` and `value` = ?
) and exists (
    select `id` from `properties_values_string`
    where `products`.`id` = `properties_values_string`.`product_id` and `value` = ?
) and exists (
    select `id` from `properties_values_string`
    where `products`.`id` = `properties_values_string`.`product_id` and `value` = ?
)

How bad is it to use such a query when filtering products, given that the property types are spread across tables and indexes are placed?

Answer 1

The answer is irrelevant without load data.
If there is no load, then this is quite a good request.
If this query is executed for a long time, but there are frequent calls to it, that data does not change there, then it makes sense to prepare a selection in advance, write the result to a separate table and give this data to users

Answer 2

Do explain and see.