SELECT 
  * 
FROM 
  cscart_product_feature_variants 
WHERE 
  variant_id IN (
    1, 
    158, 
    1313, 
    300, 
    491, 
    1351, 
    361, 
    1298, 
    289, 
    1299, 
    441, 
    125, 
    126, 
    367, 
    1308, 
    456, 
    1824, 
    211, 
    318, 
    1348, 
    321, 
    281, 
    311, 
    504, 
    508, 
    220, 
    1829, 
    419, 
    492, 
    258, 
    429, 
    1830, 
    433, 
    1329, 
    166, 
    223, 
    513, 
    1805, 
    226, 
    1826, 
    1347, 
    509, 
    227, 
    453, 
    457, 
    494, 
    326, 
    496, 
    233, 
    230, 
    231, 
    236, 
    462, 
    424, 
    239, 
    1297, 
    276, 
    241, 
    242, 
    473, 
    459, 
    244, 
    243, 
    245, 
    247, 
    1801, 
    248, 
    497, 
    290, 
    250, 
    460, 
    1327, 
    1335, 
    1332, 
    1293, 
    1304, 
    273, 
    164, 
    160, 
    485, 
    487, 
    251, 
    302, 
    1333, 
    119, 
    1394, 
    478, 
    374, 
    447, 
    379, 
    383, 
    428, 
    391, 
    1340, 
    122, 
    240, 
    121, 
    440, 
    127, 
    439, 
    1349, 
    362, 
    438, 
    149, 
    246, 
    120, 
    124, 
    123, 
    152, 
    461, 
    481, 
    479, 
    270, 
    234, 
    146, 
    483, 
    486, 
    431, 
    480, 
    228, 
    482, 
    446, 
    59, 
    50, 
    57, 
    58, 
    147, 
    9, 
    20, 
    21, 
    15, 
    18, 
    12, 
    19, 
    39, 
    14, 
    41, 
    40, 
    11, 
    10, 
    6, 
    8, 
    7, 
    35, 
    36, 
    30, 
    29, 
    24, 
    25, 
    22, 
    26, 
    1453, 
    426, 
    267, 
    1813, 
    423, 
    507, 
    287, 
    1303, 
    294, 
    1294, 
    262, 
    1295, 
    162, 
    263, 
    421, 
    110, 
    264, 
    1833, 
    265, 
    422, 
    1305, 
    282, 
    111, 
    1296, 
    313, 
    1832, 
    260, 
    1300, 
    54, 
    304, 
    303, 
    249, 
    237, 
    238, 
    475, 
    98, 
    280, 
    484, 
    469, 
    376, 
    467, 
    217, 
    232, 
    472, 
    477, 
    170, 
    476, 
    165, 
    320
  )

Query time 0.00411

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.66",
      "cost_info": {
        "read_cost": "89.35",
        "eval_cost": "20.00",
        "prefix_cost": "109.35",
        "data_read_per_join": "309K"
      },
      "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 (1,158,1313,300,491,1351,361,1298,289,1299,441,125,126,367,1308,456,1824,211,318,1348,321,281,311,504,508,220,1829,419,492,258,429,1830,433,1329,166,223,513,1805,226,1826,1347,509,227,453,457,494,326,496,233,230,231,236,462,424,239,1297,276,241,242,473,459,244,243,245,247,1801,248,497,290,250,460,1327,1335,1332,1293,1304,273,164,160,485,487,251,302,1333,119,1394,478,374,447,379,383,428,391,1340,122,240,121,440,127,439,1349,362,438,149,246,120,124,123,152,461,481,479,270,234,146,483,486,431,480,228,482,446,59,50,57,58,147,9,20,21,15,18,12,19,39,14,41,40,11,10,6,8,7,35,36,30,29,24,25,22,26,1453,426,267,1813,423,507,287,1303,294,1294,262,1295,162,263,421,110,264,1833,265,422,1305,282,111,1296,313,1832,260,1300,54,304,303,249,237,238,475,98,280,484,469,376,467,217,232,472,477,170,476,165,320))"
    }
  }
}

Result

variant_id feature_id url color position abt__ut2_color_style abt__ut2_multicolor
35 3 0 default
36 3 0 default
39 3 0 default
40 3 0 default
41 3 0 default
30 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
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
29 3 0 default
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
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
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
273 55 0 default
276 55 0 default
280 39 #ffffff 0 thumbnail #ffffff
281 55 0 default
282 47 0 default
287 86 0 default
289 58 0 default
290 55 0 default
294 86 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
361 58 0 default
362 56 0 default
367 58 0 default
374 55 0 default
376 39 #422f26 0 thumbnail #ffffff
379 55 0 default
383 55 0 default
391 55 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
429 55 0 default
431 65 0 default
433 55 0 default
438 56 0 default
439 56 0 default
440 56 0 default
441 58 0 default
446 65 0 default
447 55 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
491 58 0 default
492 55 0 default
494 55 0 default
496 55 0 default
497 55 0 default
504 55 0 default
507 86 0 default
508 55 0 default
509 55 0 default
513 55 0 default
1453 86 0 default
1394 55 0 default
1351 58 0 default
1348 55 0 default
1349 56 0 default
1347 55 0 default
1340 55 0 default
1335 55 0 default
1332 55 0 default
1333 55 0 default
1329 55 0 default
1327 55 0 default
1313 58 0 default
1293 55 0 default
1294 47 0 default
1295 47 0 default
1296 47 0 default
1297 55 0 default
1298 58 0 default
1299 58 0 default
1300 10 0 default
1303 86 0 default
1304 55 0 default
1305 47 0 default
1308 58 0 default
1801 55 0 default
1805 55 0 default
1813 86 0 default
1824 55 0 default
1826 55 0 default
1829 55 0 default
1830 55 0 default
1832 10 0 default
1833 47 0 default