Sandbox

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

Query time 0.00165

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "140.01"
    },
    "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": 200,
      "rows_produced_per_join": 200,
      "filtered": "100.00",
      "index_condition": "((`test_uchur_k`.`cscart_product_feature_variant_descriptions`.`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')) and (`test_uchur_k`.`cscart_product_feature_variant_descriptions`.`lang_code` = 'ru'))",
      "cost_info": {
        "read_cost": "120.01",
        "eval_cost": "20.00",
        "prefix_cost": "140.01",
        "data_read_per_join": "623K"
      },
      "used_columns": [
        "variant_id",
        "lang_code",
        "yml2_unit"
      ]
    }
  }
}

Result

variant_id	yml2_unit
1
6
7
8
9
10
11
12
14
15
18
19
20
21
22
24
25
26
29
30
35
36
39
40
41
50
54
57
58
59
98
110
111
119
120
121
122
123
124
125
126
127
146
147
149
152
158
160
162
164
165
166
170
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
273
276
280
281
282
287
289
290
294
300
302
303
304
311
313
318
320
321
326
361
362
367
374
376
379
383
391
419
421
422
423
424
426
428
429
431
433
438
439
440
441
446
447
453
456
457
459
460
461
462
467
469
472
473
475
476
477
478
479
480
481
482
483
484
485
486
487
491
492
494
496
497
504
507
508
509
513
1293
1294
1295
1296
1297
1298
1299
1300
1303
1304
1305
1308
1313
1327
1329
1332
1333
1335
1340
1347
1348
1349
1351
1394
1453
1801
1805
1813
1824
1826
1829
1830
1832
1833