SELECT 
  product_id, 
  feature_short_desc 
FROM 
  cscart_ab__short_desc_from_features_values 
WHERE 
  product_id IN (
    9953, 
    9629, 
    9753, 
    9569, 
    9655, 
    9611, 
    10030, 
    9643, 
    9925, 
    9584, 
    9683, 
    8457, 
    9952, 
    9630, 
    9568, 
    9668, 
    9654, 
    9937, 
    9610, 
    9738, 
    8939, 
    9961, 
    9923, 
    9582, 
    9682, 
    8308, 
    9632, 
    9750, 
    9666, 
    9737, 
    8936, 
    8307, 
    9641, 
    9924, 
    9581, 
    9681, 
    9950, 
    9627, 
    9565, 
    9665, 
    9652, 
    9934, 
    9606, 
    8933, 
    9960, 
    9640, 
    9922, 
    9578, 
    9949, 
    9626, 
    9748, 
    9564, 
    9664, 
    9651, 
    9933, 
    9604, 
    9735, 
    8687, 
    9959, 
    9921, 
    9577, 
    9662, 
    9947, 
    9625, 
    9562, 
    9650, 
    9932, 
    9600, 
    9734, 
    7493, 
    9958, 
    9638, 
    9576, 
    9677, 
    9945, 
    9623, 
    9746, 
    8999, 
    9931, 
    9599, 
    8463, 
    6883, 
    9956, 
    9758, 
    9575, 
    9676, 
    9660, 
    9944, 
    9621, 
    9745, 
    8983, 
    9648, 
    9930, 
    9732, 
    8462, 
    9957, 
    9635, 
    9757, 
    9574, 
    9673, 
    9658, 
    9943, 
    9744, 
    9647, 
    9928, 
    9589, 
    9730, 
    8461, 
    9955, 
    9756, 
    9573, 
    9672, 
    9657, 
    9942, 
    9616, 
    9743, 
    8945, 
    9927, 
    9587, 
    9686, 
    8459, 
    9954, 
    9633, 
    9754, 
    9671, 
    9656, 
    9612, 
    8941, 
    10202, 
    9645, 
    9926, 
    9585, 
    9685, 
    8458, 
    9670, 
    9939, 
    9740, 
    8940, 
    9752, 
    9642, 
    9951, 
    9566, 
    9653, 
    9935, 
    9607, 
    9962, 
    9749, 
    9736, 
    8235, 
    9680, 
    8213, 
    9639, 
    9678, 
    9747, 
    8686, 
    9920, 
    9661, 
    9649, 
    9733, 
    9636, 
    9591, 
    9619, 
    8982, 
    9634, 
    9646, 
    9572, 
    9940, 
    9741
  ) 
  AND lang_code = 'en' 
  AND storefront_id = 1 
  AND cscart_ab__short_desc_from_features_values.company_id = 1

Query time 0.00105

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_ab__short_desc_from_features_values",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "17",
          "used_key_parts": [
            "product_id",
            "lang_code",
            "company_id",
            "storefront_id"
          ],
          "rows": 168,
          "filtered": 100,
          "attached_condition": "cscart_ab__short_desc_from_features_values.storefront_id = 1 and cscart_ab__short_desc_from_features_values.company_id = 1 and cscart_ab__short_desc_from_features_values.product_id in (9953,9629,9753,9569,9655,9611,10030,9643,9925,9584,9683,8457,9952,9630,9568,9668,9654,9937,9610,9738,8939,9961,9923,9582,9682,8308,9632,9750,9666,9737,8936,8307,9641,9924,9581,9681,9950,9627,9565,9665,9652,9934,9606,8933,9960,9640,9922,9578,9949,9626,9748,9564,9664,9651,9933,9604,9735,8687,9959,9921,9577,9662,9947,9625,9562,9650,9932,9600,9734,7493,9958,9638,9576,9677,9945,9623,9746,8999,9931,9599,8463,6883,9956,9758,9575,9676,9660,9944,9621,9745,8983,9648,9930,9732,8462,9957,9635,9757,9574,9673,9658,9943,9744,9647,9928,9589,9730,8461,9955,9756,9573,9672,9657,9942,9616,9743,8945,9927,9587,9686,8459,9954,9633,9754,9671,9656,9612,8941,10202,9645,9926,9585,9685,8458,9670,9939,9740,8940,9752,9642,9951,9566,9653,9935,9607,9962,9749,9736,8235,9680,8213,9639,9678,9747,8686,9920,9661,9649,9733,9636,9591,9619,8982,9634,9646,9572,9940,9741) and cscart_ab__short_desc_from_features_values.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id feature_short_desc
6883
7493
8213
8235
8307
8308
8457
8458
8459
8461
8462
8463
8686
8687
8933
8936
8939
8940
8941
8945
8982
8983
8999
9562
9564
9565
9566
9568
9569
9572
9573
9574
9575
9576
9577
9578
9581
9582
9584
9585
9587
9589
9591
9599
9600
9604
9606
9607
9610
9611
9612
9616
9619
9621
9623
9625
9626
9627
9629
9630
9632
9633
9634
9635
9636
9638
9639
9640
9641
9642
9643
9645
9646
9647
9648
9649
9650
9651
9652
9653
9654
9655
9656
9657
9658
9660
9661
9662
9664
9665
9666
9668
9670
9671
9672
9673
9676
9677
9678
9680
9681
9682
9683
9685
9686
9730
9732
9733
9734
9735
9736
9737
9738
9740
9741
9743
9744
9745
9746
9747
9748
9749
9750
9752
9753
9754
9756
9757
9758
9920
9921
9922
9923
9924
9925
9926
9927
9928
9930
9931
9932
9933
9934
9935
9937
9939
9940
9942
9943
9944
9945
9947
9949
9950
9951
9952
9953
9954
9955
9956
9957
9958
9959
9960
9961
9962
10030
10202