Sandbox

SELECT 
  * 
FROM 
  cscart_product_feature_variants 
WHERE 
  variant_id IN (
    4863, 
    3709, 
    4752, 
    1978, 
    1913, 
    2652, 
    4865, 
    1855, 
    3734, 
    2113, 
    1878, 
    2838, 
    2226, 
    1887, 
    1910, 
    2759, 
    2285, 
    3099, 
    3103, 
    3093, 
    3101, 
    3092, 
    3089, 
    3104, 
    3100, 
    1427, 
    595, 
    237, 
    576, 
    685, 
    1324, 
    1308, 
    1488, 
    204, 
    154, 
    1421, 
    215, 
    53, 
    217, 
    606, 
    1479, 
    675, 
    1318, 
    564, 
    1423, 
    531, 
    572, 
    1328, 
    157, 
    571, 
    57, 
    252, 
    380, 
    404, 
    80, 
    1304, 
    1487, 
    1464, 
    575, 
    1508, 
    1306, 
    1377, 
    684, 
    666, 
    1316, 
    1428, 
    1419, 
    1374, 
    2071, 
    2369, 
    2626, 
    2735, 
    4931, 
    2405, 
    2084, 
    2378, 
    2090, 
    2697, 
    2630, 
    2403, 
    2119, 
    2088, 
    1908, 
    2421, 
    2086, 
    4954, 
    4956, 
    2589, 
    3631, 
    4925, 
    4933, 
    3730, 
    4945, 
    4, 
    5, 
    3627, 
    2957, 
    3728, 
    4943, 
    3729, 
    4938, 
    4941, 
    4936, 
    3731, 
    4947, 
    4958, 
    3732, 
    4948, 
    4955, 
    4960, 
    3733, 
    4951, 
    4939, 
    1856, 
    2227, 
    1870, 
    1859, 
    1477, 
    607, 
    3632, 
    1767, 
    577, 
    686, 
    1480, 
    677, 
    574, 
    156, 
    538, 
    1406, 
    1330, 
    212, 
    3630, 
    55, 
    1141, 
    674, 
    203, 
    533, 
    1327, 
    1422, 
    563, 
    1425, 
    566, 
    1490, 
    1499, 
    1770, 
    669, 
    1431, 
    570, 
    1320, 
    239, 
    219, 
    670, 
    225, 
    1426, 
    56, 
    355, 
    4946, 
    360, 
    362, 
    4937, 
    359, 
    4932, 
    4950, 
    4949, 
    4957, 
    4952, 
    4959, 
    4926, 
    4961, 
    4934, 
    4944, 
    573, 
    1375, 
    1489, 
    155, 
    1322, 
    1429, 
    213, 
    1440, 
    668, 
    224, 
    218, 
    238, 
    1326, 
    1509, 
    537, 
    1329, 
    1445, 
    1325, 
    1504, 
    1424, 
    565, 
    1319, 
    676, 
    1430, 
    1340, 
    202, 
    562, 
    568, 
    54, 
    216, 
    1460, 
    0, 
    3727
  )

Query time 0.00702

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_feature_variants",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["variant_id"],
          "rows": 204,
          "filtered": 100,
          "index_condition": "cscart_product_feature_variants.variant_id in (4863,3709,4752,1978,1913,2652,4865,1855,3734,2113,1878,2838,2226,1887,1910,2759,2285,3099,3103,3093,3101,3092,3089,3104,3100,1427,595,237,576,685,1324,1308,1488,204,154,1421,215,53,217,606,1479,675,1318,564,1423,531,572,1328,157,571,57,252,380,404,80,1304,1487,1464,575,1508,1306,1377,684,666,1316,1428,1419,1374,2071,2369,2626,2735,4931,2405,2084,2378,2090,2697,2630,2403,2119,2088,1908,2421,2086,4954,4956,2589,3631,4925,4933,3730,4945,4,5,3627,2957,3728,4943,3729,4938,4941,4936,3731,4947,4958,3732,4948,4955,4960,3733,4951,4939,1856,2227,1870,1859,1477,607,3632,1767,577,686,1480,677,574,156,538,1406,1330,212,3630,55,1141,674,203,533,1327,1422,563,1425,566,1490,1499,1770,669,1431,570,1320,239,219,670,225,1426,56,355,4946,360,362,4937,359,4932,4950,4949,4957,4952,4959,4926,4961,4934,4944,573,1375,1489,155,1322,1429,213,1440,668,224,218,238,1326,1509,537,1329,1445,1325,1504,1424,565,1319,676,1430,1340,202,562,568,54,216,1460,0,3727)"
        }
      }
    ]
  }
}

Result

variant_id	feature_id	color	abt__ut2_color_style
4	4		default
5	4		default
53	28		default
54	29		default
55	30		default
56	31		default
57	32		default
80	18		default
154	28		default
155	29		default
156	30		default
157	32		default
202	29		default
203	30		default
204	28		default
212	30		default
213	29		default
215	28		default
216	29		default
217	28		default
218	29		default
219	30		default
224	29		default
225	30		default
237	28		default
238	29		default
239	30		default
252	18		default
355	14		default
359	14		default
360	14		default
362	14		default
380	18		default
404	18		default
531	28		default
533	30		default
537	29		default
538	30		default
562	29		default
563	30		default
564	28		default
565	29		default
566	30		default
568	29		default
570	30		default
571	32		default
572	28		default
573	29		default
574	30		default
575	50		default
576	28		default
577	30		default
595	28		default
606	28		default
607	30		default
666	50		default
668	29		default
669	30		default
670	30		default
674	30		default
675	28		default
676	29		default
677	30		default
684	50		default
685	28		default
686	30		default
1141	30		default
1304	50		default
1306	50		default
1308	28		default
1316	50		default
1318	28		default
1319	29		default
1320	30		default
1322	29		default
1324	28		default
1325	29		default
1326	29		default
1327	30		default
1328	28		default
1329	29		default
1330	30		default
1340	29		default
1374	50		default
1375	29		default
1377	50		default
1406	30		default
1419	50		default
1421	28		default
1422	30		default
1423	28		default
1424	29		default
1425	30		default
1426	31		default
1427	28		default
1428	50		default
1429	29		default
1430	29		default
1431	30		default
1440	29		default
1445	29		default
1460	9		default
1464	50		default
1477	30		default
1479	28		default
1480	30		default
1487	50		default
1488	28		default
1489	29		default
1490	30		default
1499	30		default
1504	29		default
1508	50		default
1509	29		default
1767	30		default
1770	30		default
1855	69		default
1856	70		default
1859	70		default
1870	70		default
1878	69		default
1887	69		default
1908	75		default
1910	69		default
1913	69		default
1978	69		default
2071	75		default
2084	75		default
2086	75		default
2088	75		default
2090	75		default
2113	69		default
2119	75		default
2226	69		default
2227	70		default
2285	69		default
2369	75		default
2378	75		default
2403	75		default
2405	75		default
2421	75		default
2589	75		default
2626	75		default
2630	75		default
2652	69		default
2697	75		default
2735	75		default
2759	69		default
2838	69		default
2957	76		default
3089	84	#efbadb	default
3092	84	#999999	default
3093	84	#0000ff	default
3099	84	#6fa8dc	default
3100	84	#ffff00	default
3101	84	#00ff00	default
3103	84	#b45f06	default
3104	84	#ff0000	default
3627	76		default
3630	30		default
3631	76		default
3632	30		default
3709	69		default
3727	6		default
3728	76		default
3729	76		default
3730	76		default
3731	76		default
3732	76		default
3733	76		default
3734	69		default
4752	69		default
4863	69		default
4865	69		default
4925	76		default
4926	14		default
4931	75		default
4932	14		default
4933	76		default
4934	14		default
4936	76		default
4937	14		default
4938	76		default
4939	76		default
4941	76		default
4943	76		default
4944	14		default
4945	76		default
4946	14		default
4947	76		default
4948	76		default
4949	14		default
4950	14		default
4951	76		default
4952	14		default
4954	75		default
4955	76		default
4956	75		default
4957	14		default
4958	76		default
4959	14		default
4960	76		default
4961	14		default