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 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    2764, 12676, 12655, 2831, 2832, 15312, 
    13836, 2844, 2679, 2669, 2683, 2680, 
    2675, 2674, 4357, 11901, 11902, 11919, 
    11906, 11662, 11903, 11661, 11907, 
    11908
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00097

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 24,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (2764,12676,12655,2831,2832,15312,13836,2844,2679,2669,2683,2680,2675,2674,4357,11901,11902,11919,11906,11662,11903,11661,11907,11908)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2669 <ul><li>A rich, golden yellow colour with complex aromas of vanilla and honeysuckle layered with subtle nuances of oak</li><li>On the palate, this wine has a full body with an eruption of tropical fruit flavors that develop into a long, toasty finish</li></ul>
2674 <ul><li>Deep red medium bodied wine with layers of dark ripe fruit, spice and chocolates on the nose and palate</li><li>Rich ripe fruit well integrated with soft tannins</li><li>The Fat Bastard Shiraz was made from carefully selected grapes with the aim to produce a wine with pure fruit character</li></ul>
2675 <ul><li>A brilliant lemon yellow colour with green reflections</li><li>Enticing grapefruit, lemon grass and floral aromas intermingle on the nose while the palate displays fresh exotic fruit aromas and a pronounced, crisp acidity followed by a long, persistent finish</li></ul>
2679 <ul><li>Made from ripe grapes from the sunny south of France</li><li>It's dark ruby in colour</li><li>The nose shows lifted aromas of coffee, licorice and prune with notes of more spices</li><li>Medium to full-bodied palate, with ripe tannins and generous flavours of coffee, dark fruit and spice</li></ul>
2680 <ul><li>FAT bastard Pinotage is also aged in small oak barrels for 22 months to add greater weight and complexity</li><li>Pinotage, a truly South African grape, originated from a cross between Pinot Noir and Hermitage</li><li>This wine shows rich aromas of ripe plum and banana with a lingering impression of chocolate and plum pudding</li></ul>
2683 <ul><li>Fat Bastard Merlot is a 100% Merlot with the fruit sourced from several vineyards throughout the Languedoc region of France</li><li>It has an intense dark ruby color, aromas of stone-fruit like plums and cherries, combining smoothly with cedar and toasty aromas</li></ul>
2764 <ul><li>This Cabernet Sauvignon displays ripe blackcurrant, and dried herb characters on<b> </b>the nose, which are backed up with some spicy oak notes</li><li>The palate is smooth and soft, with beautiful ripe tannins and a long finish</li></ul>
2831 <ul><li>Apart from being higher in residual sugar content, sweet red wines usually have lower alcohol content</li><li>These bottles are flavourful and complex</li><li>Sweet red wines unlike their dry counterparts don't have the full tannic flavors of traditional red wines like Cabernet Franc or Merlot</li></ul>
2832 <ul><li>Rosé is a pink colored wine that tastes like fruit and flowers mixed together and then filtered out to perfection</li><li> It's lighter than your average wine and has been deemed as summer water</li></ul>
2844 <ul><li>Pale straw in colour with light and elegant aromas of fruit and honeysuckle</li><li> Followed by crisp flavours of citrus, melon, and pear</li></ul>
4357 <ul><li>First watch is 100% genuine Canadian Whisky distilled, blended and matured in Canada and bottled in South Africa</li><li>Its velvety smooth and mellow character is achieved by blending 3 year old rye whiskies with double rye pot stilled blends</li></ul>
11661 <ul><li>Fitch & Leedes - Indian Tonic  - 24 x 200 ml</li></ul>
11662 <p></p> <h1>Fitch & Leedes Ginger Ale Mixer Can 24 x 200ml</h1>
11901 <ul><li>Fitch & Leedes - Sparkling Drink Mixer - Bitter Lemon - 24 x 200 ml</li></ul>
11902 <ul><li>Fitch & Leedes - Sparkling Drink - Bitter Lemon - 6 x 200 ml</li></ul>
11903 <ul><li>Fitch & Leedes - Ginger Ale - 6 x 200 ml</li></ul>
11906 <ul><li>Fitch & Leedes - Club Soda - 6 x 200 ml</li></ul>
11907 <ul><li>Fitch & Leedes - Indian Tonic  - 6 x 200 ml</li></ul>
11908 <ul><li>Fitch & Leedes - Indian Tonic Light  - 6 x 200 ml</li></ul>
11919 <ul><li>Fitch & Leedes - Blue Tonic  - 24 x 200 ml</li></ul>
12655 <p>EXTREME CIDER BOLD W\GUARANA 4 x 440ML</p>
12676 <p>EXTREME CIDER BOLD W\GUARANA 24 x 440ML</p>
13836
15312