SELECT 
  * 
FROM 
  jmj_product_feature_variants 
WHERE 
  variant_id IN (
    3246, 3247, 595, 601, 604, 605, 621, 620, 
    624, 616, 618, 626, 627, 629, 634, 635, 
    455, 1688, 1689, 1690, 1691, 1692, 1693, 
    1694, 2103, 2104, 2106, 2107, 2108, 
    2109, 2111, 2112, 2113, 2131, 2134, 
    2138, 2143, 2144, 2147, 2151, 2153, 
    2154, 2164, 2175, 2176, 2177, 2179, 
    2180, 2181, 2185, 2186, 2190, 2191, 
    2207, 2218, 2220, 2221, 3238, 766
  )

Query time 0.00441

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "141.61"
    },
    "table": {
      "table_name": "jmj_product_feature_variants",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "variant_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 59,
      "rows_produced_per_join": 59,
      "filtered": "100.00",
      "index_condition": "(`jmj_test`.`jmj_product_feature_variants`.`variant_id` in (3246,3247,595,601,604,605,621,620,624,616,618,626,627,629,634,635,455,1688,1689,1690,1691,1692,1693,1694,2103,2104,2106,2107,2108,2109,2111,2112,2113,2131,2134,2138,2143,2144,2147,2151,2153,2154,2164,2175,2176,2177,2179,2180,2181,2185,2186,2190,2191,2207,2218,2220,2221,3238,766))",
      "cost_info": {
        "read_cost": "129.81",
        "eval_cost": "11.80",
        "prefix_cost": "141.61",
        "data_read_per_join": "91K"
      },
      "used_columns": [
        "variant_id",
        "feature_id",
        "url",
        "color",
        "position",
        "abt__ut2_color_style",
        "abt__ut2_multicolor"
      ]
    }
  }
}