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 (
    1230, 1229, 1228, 1227, 1226, 1225, 1224, 
    1223, 1222, 1221, 1220, 1219, 1218, 
    1217, 1216, 1215, 1170, 1171, 1177, 
    1175, 1168, 1183, 1184, 1174, 1187, 
    67, 1191, 1176, 1167, 1169, 1194, 1179, 
    1180, 1181, 1197, 1182, 1201, 1202, 
    1198, 1178, 603, 1185, 1209, 1186, 1210, 
    1211, 1203, 1212, 1213, 1188, 1190, 
    1193, 1207, 1208, 1195, 1196, 1199, 
    1205, 1173, 1200, 1172, 15, 16, 17, 18, 
    19, 20, 21, 22, 26, 27, 28, 29, 30, 31, 
    32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 
    42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 
    52
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00243

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": 96,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (1230,1229,1228,1227,1226,1225,1224,1223,1222,1221,1220,1219,1218,1217,1216,1215,1170,1171,1177,1175,1168,1183,1184,1174,1187,67,1191,1176,1167,1169,1194,1179,1180,1181,1197,1182,1201,1202,1198,1178,603,1185,1209,1186,1210,1211,1203,1212,1213,1188,1190,1193,1207,1208,1195,1196,1199,1205,1173,1200,1172,15,16,17,18,19,20,21,22,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
15
16
17
18
19
20
21
22
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
67
603
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1190
1191
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1205
1207
1208
1209
1210
1211
1212
1213
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230