Sandbox

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

Query time 0.00243

JSON explain

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

Result

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