SELECT 
  variant_id, 
  color 
FROM 
  netting_product_feature_variants 
WHERE 
  feature_id = 569 
  AND variant_id IN (
    6838, 6840, 6841, 6843, 6830, 6844, 6835, 
    6836, 6833, 6846, 6845, 6839, 6842, 
    6834, 6837, 6847
  )

Query time 0.00072

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "netting_product_feature_variants",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY", "feature_id"],
          "rows": 45,
          "filtered": 15.80246925,
          "attached_condition": "netting_product_feature_variants.feature_id = 569 and netting_product_feature_variants.variant_id in (6838,6840,6841,6843,6830,6844,6835,6836,6833,6846,6845,6839,6842,6834,6837,6847)"
        }
      }
    ]
  }
}