Sandbox

SELECT 
  * 
FROM 
  cscart_product_feature_variants 
WHERE 
  variant_id IN (
    1462, 
    1, 
    3, 
    158, 
    502, 
    366, 
    300, 
    491, 
    1351, 
    289, 
    125, 
    172, 
    126, 
    296, 
    148, 
    414, 
    367, 
    456, 
    211, 
    318, 
    1348, 
    321, 
    281, 
    311, 
    504, 
    508, 
    220, 
    1829, 
    419, 
    492, 
    258, 
    1830, 
    166, 
    223, 
    226, 
    1826, 
    1347, 
    509, 
    227, 
    453, 
    457, 
    494, 
    326, 
    496, 
    233, 
    230, 
    231, 
    236, 
    462, 
    424, 
    239, 
    241, 
    242, 
    473, 
    459, 
    244, 
    243, 
    245, 
    247, 
    1463, 
    1468, 
    1465, 
    1470, 
    1801, 
    248, 
    497, 
    290, 
    250, 
    460, 
    1327, 
    1335, 
    1332, 
    1293, 
    1304, 
    164, 
    160, 
    485, 
    487, 
    251, 
    302, 
    1333, 
    119, 
    1394, 
    478, 
    155, 
    173, 
    428, 
    122, 
    240, 
    121, 
    440, 
    127, 
    439, 
    1349, 
    438, 
    149, 
    246, 
    120, 
    124, 
    123, 
    152, 
    461, 
    481, 
    479, 
    270, 
    234, 
    146, 
    483, 
    486, 
    480, 
    228, 
    482, 
    59, 
    50, 
    57, 
    58, 
    147, 
    176, 
    9, 
    20, 
    21, 
    15, 
    18, 
    12, 
    19, 
    42, 
    39, 
    32, 
    14, 
    41, 
    40, 
    11, 
    10, 
    6, 
    8, 
    7, 
    33, 
    31, 
    44, 
    43, 
    35, 
    36, 
    24, 
    25, 
    22, 
    26, 
    1453, 
    426, 
    267, 
    1813, 
    298, 
    423, 
    507, 
    287, 
    294, 
    1294, 
    262, 
    1295, 
    162, 
    263, 
    421, 
    110, 
    264, 
    1833, 
    265, 
    422, 
    1305, 
    282, 
    111, 
    1296, 
    313, 
    1832, 
    260, 
    1300, 
    299, 
    54, 
    1466, 
    304, 
    503, 
    303, 
    249, 
    237, 
    238, 
    475, 
    98, 
    484, 
    469, 
    467, 
    217, 
    232, 
    472, 
    477, 
    170, 
    476, 
    1396, 
    154, 
    489, 
    165, 
    320
  )

Query time 0.00408

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "109.35"
    },
    "table": {
      "table_name": "cscart_product_feature_variants",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 1072,
      "rows_produced_per_join": 199,
      "filtered": "18.56",
      "cost_info": {
        "read_cost": "89.45",
        "eval_cost": "19.90",
        "prefix_cost": "109.35",
        "data_read_per_join": "307K"
      },
      "used_columns": [
        "variant_id",
        "feature_id",
        "url",
        "color",
        "position",
        "abt__ut2_color_style",
        "abt__ut2_multicolor"
      ],
      "attached_condition": "(`test_uchur_k`.`cscart_product_feature_variants`.`variant_id` in (1462,1,3,158,502,366,300,491,1351,289,125,172,126,296,148,414,367,456,211,318,1348,321,281,311,504,508,220,1829,419,492,258,1830,166,223,226,1826,1347,509,227,453,457,494,326,496,233,230,231,236,462,424,239,241,242,473,459,244,243,245,247,1463,1468,1465,1470,1801,248,497,290,250,460,1327,1335,1332,1293,1304,164,160,485,487,251,302,1333,119,1394,478,155,173,428,122,240,121,440,127,439,1349,438,149,246,120,124,123,152,461,481,479,270,234,146,483,486,480,228,482,59,50,57,58,147,176,9,20,21,15,18,12,19,42,39,32,14,41,40,11,10,6,8,7,33,31,44,43,35,36,24,25,22,26,1453,426,267,1813,298,423,507,287,294,1294,262,1295,162,263,421,110,264,1833,265,422,1305,282,111,1296,313,1832,260,1300,299,54,1466,304,503,303,249,237,238,475,98,484,469,467,217,232,472,477,170,476,1396,154,489,165,320))"
    }
  }
}

Result

variant_id	feature_id	color	position	abt__ut2_color_style	abt__ut2_multicolor
31	3		0	default
32	3		0	default
33	3		0	default
35	3		0	default
36	3		0	default
39	3		0	default
40	3		0	default
41	3		0	default
42	3		0	default
43	3		0	default
44	3		0	default
50	6		0	default
162	47		0	default
54	10		0	default
57	6	#ffffff	0	default	#ffffff
58	6	#ffffff	0	default	#ffffff
59	6	#ffffff	0	default	#ffffff
3	1		2	default
6	3		0	default
7	3		0	default
8	3		0	default
9	3		0	default
10	3		0	default
11	3		0	default
12	3		0	default
14	3		0	default
15	3		0	default
1	1		1	default
18	3		0	default
19	3		0	default
20	3		0	default
21	3		0	default
22	3		0	default
24	3		0	default
25	3		0	default
26	3		0	default
176	66	#ffffff	0	default	#ffffff
155	55		0	default
154	39	#78866b	0	default	#ffffff
160	55		0	default
152	57	#ffffff	0	default	#ffffff
98	39	#c9bdaa	0	default
110	47		0	default
111	47		0	default
158	58		0	default
119	55		0	default
120	56		0	default
121	56		0	default
122	56		0	default
123	57	#ffffff	0	default	#ffffff
124	57	#ffffff	0	default	#ffffff
125	58	#ffffff	0	default	#ffffff
126	58	#ffffff	0	default	#ffffff
127	56	#ffffff	0	default	#ffffff
173	55		0	default
172	58		0	default
170	39	#999999	0	thumbnail	#ffffff
166	55	#ffffff	0	default	#ffffff
165	39	#000000	0	default	#ffffff
164	55		0	default
146	65	#ffffff	0	default	#ffffff
147	66	#ffffff	0	default	#ffffff
148	58		0	default
149	56		0	default
211	55		0	default
217	39	#262e41	0	thumbnail	#ffffff
220	55		0	default
223	55		0	default
226	55		0	default
227	55		0	default
228	65		0	default
230	55		0	default
231	55		0	default
232	39	#686702	0	thumbnail	#ffffff
233	55		0	default
234	65		0	default
236	55		0	default
237	39	#ac937f	0	default	#ffffff
238	39	#4f5b5c	0	thumbnail	#ffffff
239	55		0	default
240	56		0	default
241	55		0	default
242	55		0	default
243	55		0	default
244	55		0	default
245	55		0	default
246	56		0	default
247	55		0	default
248	55		0	default
249	39	#242424	0	thumbnail	#ffffff
250	55		0	default
251	55		0	default
258	55		0	default
260	10		0	default
262	47		0	default
263	47		0	default
264	47		0	default
265	47		0	default
267	86		0	default
270	65		0	default
281	55		0	default
282	47		0	default
287	86		0	default
289	58		0	default
290	55		0	default
294	86		0	default
296	58		0	default
298	86		0	default
299	10		0	default
300	58		0	default
302	55		0	default
303	10		0	default
304	10		0	default
311	55		0	default
313	47		0	default
318	55		0	default
320	39	#3b3b3b	0	thumbnail	#ffffff
321	55		0	default
326	55		0	default
366	58		0	default
367	58		0	default
414	58		0	default
419	55		0	default
421	47		0	default
422	47		0	default
423	86		0	default
424	55		0	default
426	86		0	default
428	55		0	default
438	56		0	default
439	56		0	default
440	56		0	default
453	55		0	default
456	58		0	default
457	55		0	default
459	55		0	default
460	55		0	default
461	65		0	default
462	55		0	default
467	39	#292929	0	thumbnail	#ffffff
469	39	#6aa84f	0	thumbnail	#ffffff
472	39	#363437	0	thumbnail	#ffffff
473	55		0	default
475	39	#4f463b	0	thumbnail	#ffffff
476	39	#a69e9f	0	thumbnail	#ffffff
477	39	#646a76	0	thumbnail	#ffffff
478	55		0	default
479	65		0	default
480	65		0	default
481	65		0	default
482	65		0	default
483	65		0	default
484	39	#303332	0	thumbnail	#ffffff
485	55		0	default
486	65		0	default
487	55		0	default
489	39	#dd711d	0	thumbnail	#ffffff
491	58		0	default
492	55		0	default
494	55		0	default
496	55		0	default
497	55		0	default
502	58		0	default
503	10		0	default
504	55		0	default
507	86		0	default
508	55		0	default
509	55		0	default
1470	55		0	default
1466	10		0	default
1468	55		0	default
1465	55		0	default
1462	1		0	default
1463	55		0	default
1453	86		0	default
1396	39	#0000ff	0	default
1394	55		0	default
1351	58		0	default
1348	55		0	default
1349	56		0	default
1347	55		0	default
1335	55		0	default
1332	55		0	default
1333	55		0	default
1327	55		0	default
1293	55		0	default
1294	47		0	default
1295	47		0	default
1296	47		0	default
1300	10		0	default
1304	55		0	default
1305	47		0	default
1801	55		0	default
1813	86		0	default
1826	55		0	default
1829	55		0	default
1830	55		0	default
1832	10		0	default
1833	47		0	default