Sandbox

SELECT 
  ushop_product_filters.*, 
  ushop_product_features.feature_type 
FROM 
  ushop_product_filters 
  LEFT JOIN ushop_product_features ON ushop_product_features.feature_id = ushop_product_filters.feature_id 
WHERE 
  ushop_product_filters.filter_id IN (10) 
  AND ushop_product_filters.status = 'A'

Query time 0.00068

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}