Sandbox

SELECT 
  variant_id, 
  yml2_unit 
FROM 
  cscart_product_feature_variant_descriptions 
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'
  ) 
  AND lang_code = 'ru'

Query time 0.00207

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "139.31"
    },
    "table": {
      "table_name": "cscart_product_feature_variant_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "variant_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 199,
      "rows_produced_per_join": 199,
      "filtered": "100.00",
      "index_condition": "((`test_uchur_k`.`cscart_product_feature_variant_descriptions`.`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')) and (`test_uchur_k`.`cscart_product_feature_variant_descriptions`.`lang_code` = 'ru'))",
      "cost_info": {
        "read_cost": "119.41",
        "eval_cost": "19.90",
        "prefix_cost": "139.31",
        "data_read_per_join": "620K"
      },
      "used_columns": [
        "variant_id",
        "lang_code",
        "yml2_unit"
      ]
    }
  }
}

Result

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