Explain Query (mysql)
EXPLAIN
SELECT
baskets.*
FROM
baskets
INNER JOIN subscriptions s ON (s.user_id = '618755' AND baskets.basket_id = s.basket_id AND s.type != 4)
WHERE
baskets.in_use = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | no matching row in const table |