SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    17792, 17791, 17790, 17789, 17788, 17787, 
    17786, 17785, 17784, 17775, 17774, 
    17773, 17772, 17753, 17752, 17751, 
    17750, 17749, 17748, 17747, 17746, 
    17745, 17744, 17743, 17742, 17783, 
    17782, 17781, 17780, 17779, 17778, 
    17777, 17776, 17741, 17740, 17739, 
    17738, 17737, 17771, 17770, 17769, 
    17768, 17767, 17766, 17765, 17764, 
    17763, 17762, 17761, 17760, 17759, 
    17758, 17757, 17756, 17755, 17754, 
    17736, 17735, 17734, 17733, 17730, 
    17732, 17731, 17729, 17728, 17727, 
    17726, 17725, 17667, 17679, 17678, 
    17677, 17676, 17675, 17674, 17673, 
    17672, 17671, 17670, 17669
  ) 
  AND cscart_product_descriptions.lang_code = 'kk'

Query time 0.00102

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 80,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (17792,17791,17790,17789,17788,17787,17786,17785,17784,17775,17774,17773,17772,17753,17752,17751,17750,17749,17748,17747,17746,17745,17744,17743,17742,17783,17782,17781,17780,17779,17778,17777,17776,17741,17740,17739,17738,17737,17771,17770,17769,17768,17767,17766,17765,17764,17763,17762,17761,17760,17759,17758,17757,17756,17755,17754,17736,17735,17734,17733,17730,17732,17731,17729,17728,17727,17726,17725,17667,17679,17678,17677,17676,17675,17674,17673,17672,17671,17670,17669) and cscart_product_descriptions.lang_code = 'kk'"
    }
  }
}

Result

product_id meta_keywords meta_description search_words promo_text unit_name
17667
17669
17670
17671
17672
17673
17674
17675
17676
17677
17678
17679
17725
17726
17727
17728
17729
17730
17731
17732
17733
17734
17735
17736
17737
17738
17739
17740
17741
17742
17743
17744
17745
17746
17747
17748
17749
17750
17751
17752
17753
17754
17755
17756
17757
17758
17759
17760
17761
17762
17763
17764
17765
17766
17767
17768
17769
17770
17771
17772
17773
17774
17775
17776
17777
17778
17779
17780
17781
17782
17783
17784 шт.
17785 шт.
17786 шт.
17787 шт.
17788 шт.
17789 шт.
17790 шт.
17791 шт.
17792 шт.