SELECT 
  product_id, 
  feature_short_desc 
FROM 
  cscart_ab__short_desc_from_features_values 
WHERE 
  product_id IN (
    7172, 
    6924, 
    6730, 
    6784, 
    6764, 
    6737, 
    6690, 
    8742, 
    6771, 
    6724, 
    6723, 
    6813, 
    6797, 
    6801, 
    6750, 
    6694, 
    10195, 
    6706, 
    6689, 
    6782, 
    6763, 
    6736, 
    7084, 
    8743, 
    6768, 
    6720, 
    6722, 
    6812, 
    6798, 
    6793, 
    6749, 
    6691, 
    9495, 
    6702, 
    6688, 
    6781, 
    6759, 
    6734, 
    6921, 
    8680, 
    6765, 
    6718, 
    11375, 
    6721, 
    6811, 
    6796, 
    6791, 
    6748, 
    6682, 
    8802, 
    6700, 
    6687, 
    6779, 
    6755, 
    6732, 
    6923, 
    6810, 
    6920, 
    6762, 
    6717, 
    11104, 
    6719, 
    6795, 
    6789, 
    6747, 
    8801, 
    6701, 
    6686, 
    6778, 
    6754, 
    6731, 
    6808, 
    6922, 
    6761, 
    6715, 
    11103, 
    6716, 
    6794, 
    6783, 
    6746, 
    8688, 
    6699, 
    6685, 
    6776, 
    6751, 
    6915, 
    6806, 
    6918, 
    6760, 
    6712, 
    11059, 
    6714, 
    6790, 
    6780, 
    6745, 
    8241, 
    6698, 
    6684, 
    6777, 
    6744, 
    6729, 
    6916, 
    6805, 
    6919, 
    6758, 
    6713, 
    11052, 
    6711, 
    6788, 
    6769, 
    6743, 
    8008, 
    6697, 
    6683, 
    6775, 
    6740, 
    6728, 
    6917, 
    6804, 
    6914, 
    6757, 
    6705, 
    10992, 
    6710, 
    6787, 
    6770, 
    6742, 
    8000, 
    6696, 
    11378, 
    6773, 
    6739, 
    6727, 
    6912, 
    6803, 
    6809, 
    6756, 
    6704, 
    10778, 
    6708, 
    6786, 
    6767, 
    6741, 
    7914, 
    6693, 
    11211, 
    6774, 
    6735, 
    6726, 
    6913, 
    6800, 
    6807, 
    6753, 
    6703, 
    10640, 
    6709, 
    6785, 
    6766, 
    6738, 
    7411, 
    6692, 
    8865, 
    6772, 
    6733, 
    6725, 
    6814, 
    6799, 
    6802, 
    6752, 
    6695, 
    10246, 
    6707
  ) 
  AND lang_code = 'ru' 
  AND storefront_id = 1 
  AND cscart_ab__short_desc_from_features_values.company_id = 1

Query time 0.00116

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": 172,
          "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 (7172,6924,6730,6784,6764,6737,6690,8742,6771,6724,6723,6813,6797,6801,6750,6694,10195,6706,6689,6782,6763,6736,7084,8743,6768,6720,6722,6812,6798,6793,6749,6691,9495,6702,6688,6781,6759,6734,6921,8680,6765,6718,11375,6721,6811,6796,6791,6748,6682,8802,6700,6687,6779,6755,6732,6923,6810,6920,6762,6717,11104,6719,6795,6789,6747,8801,6701,6686,6778,6754,6731,6808,6922,6761,6715,11103,6716,6794,6783,6746,8688,6699,6685,6776,6751,6915,6806,6918,6760,6712,11059,6714,6790,6780,6745,8241,6698,6684,6777,6744,6729,6916,6805,6919,6758,6713,11052,6711,6788,6769,6743,8008,6697,6683,6775,6740,6728,6917,6804,6914,6757,6705,10992,6710,6787,6770,6742,8000,6696,11378,6773,6739,6727,6912,6803,6809,6756,6704,10778,6708,6786,6767,6741,7914,6693,11211,6774,6735,6726,6913,6800,6807,6753,6703,10640,6709,6785,6766,6738,7411,6692,8865,6772,6733,6725,6814,6799,6802,6752,6695,10246,6707) and cscart_ab__short_desc_from_features_values.lang_code = 'ru'"
        }
      }
    ]
  }
}

Result

product_id feature_short_desc
6682
6683
6684
6685
6686
6687
6688
6689
6690
6691
6692
6693
6694
6695
6696
6697
6698
6699
6700
6701
6702
6703
6704
6705
6706
6707
6708
6709
6710
6711
6712
6713
6714
6715
6716
6717
6718
6719
6720
6721
6722
6723
6724
6725
6726
6727
6728
6729
6730
6731
6732
6733
6734
6735
6736
6737
6738
6739
6740
6741
6742
6743
6744
6745
6746
6747
6748
6749
6750
6751
6752
6753
6754
6755
6756
6757
6758
6759
6760
6761
6762
6763
6764
6765
6766
6767
6768
6769
6770
6771
6772
6773
6774
6775
6776
6777
6778
6779
6780
6781
6782
6783
6784
6785
6786
6787
6788
6789
6790
6791
6793
6794
6795
6796
6797
6798
6799
6800
6801
6802
6803
6804
6805
6806
6807
6808
6809
6810
6811
6812
6813
6814
6912
6913
6914
6915
6916
6917
6918
6919
6920
6921
6922
6923
6924
7084
7172
7411
7914
8000
8008
8241
8680
8688
8742
8743
8801
8802
8865
9495
10195
10246
10640
10778
10992
11052
11059
11103
11104
11211
11375
11378