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 (
    1097, 1057, 1058, 772, 768, 770, 774, 
    776, 777, 773, 769, 771, 775, 1117, 1116, 
    633, 1118, 1019, 563, 611, 1060, 544, 
    1069, 1068, 631, 1111, 632, 1112, 1062, 
    1101, 906, 1099, 831, 830, 1065, 1056, 
    1059, 543, 510, 1017, 779, 778, 1113, 
    1114, 1115, 1096, 1061, 1100
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00157

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": 48,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (1097,1057,1058,772,768,770,774,776,777,773,769,771,775,1117,1116,633,1118,1019,563,611,1060,544,1069,1068,631,1111,632,1112,1062,1101,906,1099,831,830,1065,1056,1059,543,510,1017,779,778,1113,1114,1115,1096,1061,1100) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text unit_name
510
543
544
563
611
631
632
633
768
769
770
771
772
773
774
775
776
777
778
779
830
831
906
1017
1019
1056
1057
1058
1059
1060
1061
1062
1065
1068
1069
1096
1097
1099
1100
1101
1111
1112
1113
1114
1115
1116
1117
1118