SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  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 (
    107, 73, 102, 1154, 1155, 307, 1157, 1156, 
    227, 487, 1153, 324, 229, 228, 1152, 
    1151, 1149, 1067, 1150, 1063, 1064, 
    905, 490, 1333, 1334, 1332, 567, 570, 
    568, 907, 1000, 999, 995, 1001, 996, 
    992, 998, 997, 993, 991, 909, 908, 1070, 
    469, 225, 226, 1095, 569, 612, 1025, 
    1026, 1016, 1055, 975, 976, 418, 1148, 
    472
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00173

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": 58,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (107,73,102,1154,1155,307,1157,1156,227,487,1153,324,229,228,1152,1151,1149,1067,1150,1063,1064,905,490,1333,1334,1332,567,570,568,907,1000,999,995,1001,996,992,998,997,993,991,909,908,1070,469,225,226,1095,569,612,1025,1026,1016,1055,975,976,418,1148,472) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
73
102
107
225
226
227
228
229
307
324
418
469
472
487
490
567
568
569
570
612
905
907
908
909
975
976
991
992
993
995
996
997
998
999
1000
1001
1016
1025
1026
1055
1063
1064
1067
1070
1095
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1332
1333
1334