Sandbox

SELECT 
  * 
FROM 
  cscart_product_feature_variants 
WHERE 
  variant_id IN (
    4775, 
    4766, 
    4763, 
    4783, 
    4787, 
    4773, 
    4780, 
    4784, 
    3095, 
    3096, 
    3099, 
    3100, 
    3101, 
    3103, 
    3085, 
    3086, 
    3087, 
    3088, 
    3089, 
    3090, 
    3093, 
    3091, 
    3094, 
    3104, 
    3084, 
    1287, 
    1372, 
    476, 
    152, 
    153, 
    21, 
    463, 
    75, 
    144, 
    1605, 
    437, 
    462, 
    135, 
    66, 
    1455, 
    145, 
    608, 
    1446, 
    58, 
    147, 
    148, 
    540, 
    617, 
    636, 
    1604, 
    605, 
    1351, 
    613, 
    473, 
    601, 
    600, 
    125, 
    603, 
    578, 
    126, 
    604, 
    644, 
    638, 
    403, 
    50, 
    88, 
    1457, 
    123, 
    626, 
    629, 
    635, 
    127, 
    48, 
    1331, 
    122, 
    436, 
    657, 
    146, 
    1363, 
    602, 
    477, 
    59, 
    478, 
    655, 
    381, 
    614, 
    631, 
    90, 
    47, 
    474, 
    633, 
    1462, 
    392, 
    632, 
    87, 
    1577, 
    60, 
    619, 
    535, 
    1354, 
    498, 
    536, 
    654, 
    479, 
    645, 
    643, 
    890, 
    611, 
    421, 
    1579, 
    422, 
    610, 
    1578, 
    623, 
    64, 
    49, 
    622, 
    85, 
    639, 
    612, 
    124, 
    501, 
    242, 
    129, 
    616, 
    120, 
    625, 
    128, 
    393, 
    640, 
    627, 
    20, 
    1313, 
    150, 
    419, 
    278, 
    1288, 
    176, 
    1793, 
    233, 
    2597, 
    2663, 
    1984, 
    2598, 
    2833, 
    96, 
    3386, 
    431, 
    3384, 
    1856, 
    2030, 
    1859, 
    1870, 
    1293, 
    1349, 
    1290, 
    1376, 
    491, 
    1291, 
    455, 
    1402, 
    434, 
    62, 
    1702, 
    175, 
    1307, 
    61, 
    79, 
    450, 
    1460, 
    1512, 
    1400, 
    0, 
    461, 
    1315, 
    1285, 
    3063, 
    1348, 
    1321, 
    1743, 
    3543, 
    3567, 
    347, 
    3568, 
    142, 
    17, 
    345, 
    42, 
    1353, 
    630, 
    628, 
    1, 
    486, 
    489, 
    65, 
    1456, 
    43, 
    624, 
    1364, 
    1437, 
    356, 
    298, 
    195, 
    1020, 
    487, 
    590, 
    214, 
    44, 
    1451, 
    299, 
    136, 
    121, 
    91, 
    710, 
    45, 
    490, 
    341, 
    637, 
    46, 
    1877, 
    2137, 
    2728
  )

Query time 0.00270

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": 222,
          "filtered": 100,
          "index_condition": "cscart_product_feature_variants.variant_id in (4775,4766,4763,4783,4787,4773,4780,4784,3095,3096,3099,3100,3101,3103,3085,3086,3087,3088,3089,3090,3093,3091,3094,3104,3084,1287,1372,476,152,153,21,463,75,144,1605,437,462,135,66,1455,145,608,1446,58,147,148,540,617,636,1604,605,1351,613,473,601,600,125,603,578,126,604,644,638,403,50,88,1457,123,626,629,635,127,48,1331,122,436,657,146,1363,602,477,59,478,655,381,614,631,90,47,474,633,1462,392,632,87,1577,60,619,535,1354,498,536,654,479,645,643,890,611,421,1579,422,610,1578,623,64,49,622,85,639,612,124,501,242,129,616,120,625,128,393,640,627,20,1313,150,419,278,1288,176,1793,233,2597,2663,1984,2598,2833,96,3386,431,3384,1856,2030,1859,1870,1293,1349,1290,1376,491,1291,455,1402,434,62,1702,175,1307,61,79,450,1460,1512,1400,0,461,1315,1285,3063,1348,1321,1743,3543,3567,347,3568,142,17,345,42,1353,630,628,1,486,489,65,1456,43,624,1364,1437,356,298,195,1020,487,590,214,44,1451,299,136,121,91,710,45,490,341,637,46,1877,2137,2728)"
        }
      }
    ]
  }
}

Result

variant_id	feature_id	color	position	abt__ut2_color_style
1	1		0	default
17	6		0	default
20	16		0	default
21	17		0	default
42	1		0	default
43	1		0	default
44	1		0	default
45	1		0	default
46	1		0	default
47	26		0	default
48	26		0	default
49	26		0	default
50	26		0	default
58	26		0	default
59	26		0	default
60	26		0	default
61	9		0	default
62	9		0	default
64	26		0	default
65	1		0	default
66	26		0	default
75	26		0	default
79	9		0	default
85	26		0	default
87	26		0	default
88	26		0	default
90	26		0	default
91	1		0	default
96	38		0	default
120	26		0	default
121	1		0	default
122	26		0	default
123	26		0	default
124	26		0	default
125	26		0	default
126	26		0	default
127	26		0	default
128	26		0	default
129	26		0	default
135	26		0	default
136	1		0	default
142	6		0	default
144	26		0	default
145	26		0	default
146	26		0	default
147	26		0	default
148	26		0	default
150	42		0	default
152	43		0	default
153	43		0	default
175	9		0	default
176	42		0	default
195	1		0	default
214	1		0	default
233	3		0	default
242	26		0	default
278	42		0	default
298	1		0	default
299	1		0	default
341	1		0	default
345	6		0	default
347	6		0	default
356	1		0	default
381	26		0	default
392	26		0	default
393	26		0	default
403	26		0	default
419	42		0	default
421	26		0	default
422	26		0	default
431	49		0	default
434	9		0	default
436	26		0	default
437	26		0	default
450	9		0	default
455	46		0	default
461	6		0	default
462	26		0	default
463	26		0	default
473	26		0	default
474	26		0	default
476	43		0	default
477	26		0	default
478	26		0	default
479	26		0	default
486	1		0	default
487	1		0	default
489	1		0	default
490	1		0	default
491	46		0	default
498	26		0	default
501	26		0	default
535	26		0	default
536	26		0	default
540	26		0	default
578	26		0	default
590	1		0	default
600	26		0	default
601	26		0	default
602	26		0	default
603	26		0	default
604	26		0	default
605	26		0	default
608	26		0	default
610	26		0	default
611	26		0	default
612	26		0	default
613	26		0	default
614	26		0	default
616	26		0	default
617	26		0	default
619	26		0	default
622	26		0	default
623	26		0	default
624	1		0	default
625	26		0	default
626	26		0	default
627	26		0	default
628	1		0	default
629	26		0	default
630	1		0	default
631	26		0	default
632	26		0	default
633	26		0	default
635	26		0	default
636	26		0	default
637	1		0	default
638	26		0	default
639	26		0	default
640	26		0	default
643	26		0	default
644	26		0	default
645	26		0	default
654	26		0	default
655	26		0	default
657	26		0	default
710	1		0	default
890	26		0	default
1020	1		0	default
1285	6		0	default
1287	4		0	default
1288	42		0	default
1290	46		0	default
1291	46		0	default
1293	46		0	default
1307	9		0	default
1313	52		0	default
1315	6		0	default
1321	6		0	default
1331	26		0	default
1348	6		0	default
1349	46		0	default
1351	26		0	default
1353	1		0	default
1354	26		0	default
1363	26		0	default
1364	1		0	default
1372	43		0	default
1376	46		0	default
1400	9		0	default
1402	46		0	default
1437	1		0	default
1446	26		0	default
1451	1		0	default
1455	26		0	default
1456	1		0	default
1457	26		0	default
1460	9		0	default
1462	26		0	default
1512	9		0	default
1577	26		0	default
1578	26		0	default
1579	26		0	default
1604	26		0	default
1605	26		0	default
1702	9		0	default
1743	6		0	default
1793	15		0	default
1856	70		0	default
1859	70		0	default
1870	70		0	default
1877	78		0	default
1984	83		0	default
2030	70		0	default
2137	78		0	default
2597	83		0	default
2598	83		0	default
2663	83		0	default
2728	78		0	default
2833	83		0	default
3063	6		0	default
3084	84	#001	0	default
3085	84	#fff2cc	0	default
3086	84	#f4cccc	0	default
3087	84	#ff9900	0	default
3088	84	#ffffff	0	default
3089	84	#efbadb	0	default
3090	84	#00ff00	0	default
3091	84	#d9d9d9	0	default
3093	84	#0000ff	0	default
3094	84	#8e7cc3	0	default
3095	84	#ffffff	0	default
3096	84	#e6b8af	0	default
3099	84	#6fa8dc	0	default
3100	84	#ffff00	0	default
3101	84	#00ff00	0	default
3103	84	#b45f06	0	default
3104	84	#ff0000	0	default
3384	51		0	default
3386	49		0	default
3543	6		0	default
3567	6		0	default
3568	6		0	default
4763	155		30	default
4766	155	#ffffff	15	default
4773	155	#ffffff	100	default
4775	155		5	default
4780	155	#ffffff	250	default
4783	155	#ffffff	50	default
4784	155	#ffffff	500	default
4787	155	#ffffff	75	default