Explain Query (mysql)
EXPLAIN SELECT p.* FROM products p, marketplace_gifts_settings mgs WHERE mgs.delivery_date = '2025-04-12' AND mgs.gift_preferences_id = -1 AND p.product_id = mgs.product_id AND p.gift = 1 AND p.unlocked_above > 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | no matching row in const table |