SELECT 
  product_id, 
  feature_short_desc 
FROM 
  cscart_ab__short_desc_from_features_values 
WHERE 
  product_id IN (
    9953, 9942, 9676, 9932, 9937, 9573, 9574, 
    9575, 9576, 9577, 9672, 9578, 9638, 
    9643, 9671, 9581, 9582, 9584, 9585, 
    8687, 9685, 9954, 9681, 9682, 9955, 
    9683, 9686, 9956, 9758, 9612, 9730, 
    9616, 8933, 9732, 9735, 9587, 9589, 
    9599, 8936, 9565, 9600, 9604, 9606, 
    9947, 9621, 9610, 8939, 9611, 9664, 
    9665, 9748, 9564, 9750, 9623, 9958, 
    9960, 9666, 9952, 9959, 9949, 9753, 
    9944, 9754, 9562, 9756, 8983, 9673, 
    9961, 9957, 9757, 9626, 9627, 9629, 
    9630, 9632, 9633, 9635, 9640, 9945, 
    9950, 9641, 8945, 9625, 9645, 9647, 
    9677, 9648, 9650, 9921, 8941, 9922, 
    9923, 9925, 9924, 9745, 9651, 9652, 
    9746, 9654, 9926
  ) 
  AND lang_code = 'en' 
  AND storefront_id = 1 
  AND cscart_ab__short_desc_from_features_values.company_id = 1

Query time 0.00070

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": 100,
          "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,9942,9676,9932,9937,9573,9574,9575,9576,9577,9672,9578,9638,9643,9671,9581,9582,9584,9585,8687,9685,9954,9681,9682,9955,9683,9686,9956,9758,9612,9730,9616,8933,9732,9735,9587,9589,9599,8936,9565,9600,9604,9606,9947,9621,9610,8939,9611,9664,9665,9748,9564,9750,9623,9958,9960,9666,9952,9959,9949,9753,9944,9754,9562,9756,8983,9673,9961,9957,9757,9626,9627,9629,9630,9632,9633,9635,9640,9945,9950,9641,8945,9625,9645,9647,9677,9648,9650,9921,8941,9922,9923,9925,9924,9745,9651,9652,9746,9654,9926) and cscart_ab__short_desc_from_features_values.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id feature_short_desc
8687
8933
8936
8939
8941
8945
8983
9562
9564
9565
9573
9574
9575
9576
9577
9578
9581
9582
9584
9585
9587
9589
9599
9600
9604
9606
9610
9611
9612
9616
9621
9623
9625
9626
9627
9629
9630
9632
9633
9635
9638
9640
9641
9643
9645
9647
9648
9650
9651
9652
9654
9664
9665
9666
9671
9672
9673
9676
9677
9681
9682
9683
9685
9686
9730
9732
9735
9745
9746
9748
9750
9753
9754
9756
9757
9758
9921
9922
9923
9924
9925
9926
9932
9937
9942
9944
9945
9947
9949
9950
9952
9953
9954
9955
9956
9957
9958
9959
9960
9961