SELECT 
  * 
FROM 
  jmj_product_feature_variants 
WHERE 
  variant_id IN (
    2638, 
    3150, 
    3152, 
    3155, 
    3232, 
    3246, 
    3247, 
    2103, 
    2104, 
    2105, 
    2106, 
    2107, 
    2108, 
    2109, 
    2110, 
    2111, 
    2112, 
    2113, 
    2114, 
    2115, 
    2116, 
    2117, 
    2118, 
    2119, 
    2120, 
    2122, 
    2123, 
    2124, 
    2125, 
    2126, 
    2127, 
    2128, 
    2129, 
    2130, 
    2131, 
    2133, 
    2134, 
    2135, 
    2136, 
    2137, 
    2138, 
    2139, 
    2140, 
    2141, 
    2142, 
    2143, 
    2144, 
    2145, 
    2146, 
    2147, 
    2148, 
    2149, 
    2150, 
    2151, 
    2153, 
    2154, 
    2155, 
    2161, 
    2162, 
    2163, 
    2164, 
    2165, 
    2166, 
    2167, 
    2168, 
    2169, 
    2170, 
    2172, 
    2173, 
    2174, 
    2175, 
    2176, 
    2177, 
    2178, 
    2179, 
    2180, 
    2181, 
    2183, 
    2184, 
    2185, 
    2186, 
    2187, 
    2188, 
    2189, 
    2190, 
    2191, 
    2192, 
    2193, 
    2194, 
    2195, 
    2196, 
    2197, 
    2198, 
    2200, 
    2201, 
    2202, 
    2203, 
    2204, 
    2205, 
    2206, 
    2207, 
    2208, 
    2209, 
    2210, 
    2211, 
    2213, 
    2217, 
    2218, 
    2219, 
    2220, 
    2221, 
    2222, 
    2223, 
    2224, 
    2225, 
    2226, 
    2227, 
    2228, 
    2229, 
    2231, 
    2232, 
    2233, 
    2234, 
    2235, 
    2237, 
    2239, 
    3238, 
    766
  )

Query time 0.01116

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "307.21"
    },
    "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": 128,
      "rows_produced_per_join": 128,
      "filtered": "100.00",
      "index_condition": "(`jmj_test`.`jmj_product_feature_variants`.`variant_id` in (2638,3150,3152,3155,3232,3246,3247,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117,2118,2119,2120,2122,2123,2124,2125,2126,2127,2128,2129,2130,2131,2133,2134,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2145,2146,2147,2148,2149,2150,2151,2153,2154,2155,2161,2162,2163,2164,2165,2166,2167,2168,2169,2170,2172,2173,2174,2175,2176,2177,2178,2179,2180,2181,2183,2184,2185,2186,2187,2188,2189,2190,2191,2192,2193,2194,2195,2196,2197,2198,2200,2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2213,2217,2218,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2231,2232,2233,2234,2235,2237,2239,3238,766))",
      "cost_info": {
        "read_cost": "281.61",
        "eval_cost": "25.60",
        "prefix_cost": "307.21",
        "data_read_per_join": "198K"
      },
      "used_columns": [
        "variant_id",
        "feature_id",
        "url",
        "color",
        "position",
        "abt__ut2_color_style",
        "abt__ut2_multicolor"
      ]
    }
  }
}