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 (
    12709, 12644, 2801, 15148, 3217, 2265, 
    2509, 13837, 2512, 2574, 2565, 15388, 
    12935, 2621, 11119, 2560, 2664, 2684, 
    2665, 2663, 2279, 2514, 2511, 2513
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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": 24,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (12709,12644,2801,15148,3217,2265,2509,13837,2512,2574,2565,15388,12935,2621,11119,2560,2664,2684,2665,2663,2279,2514,2511,2513) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2265 <ul><li>The nose has a hint of freshly roasted coffee</li><li>The <b>taste is bittersweet, orangey, with herbal and anise and root notes</b></li><li>This is a key ingredient in the famous Pimm's Cup Cocktail</li></ul> <p><br /></p>
2279 <ul><li>Potency has a stimulating effect if consumed in the evening</li><li>This alcohol based Taurine drink makes an awesome shooter or as a long drink create serious liqiud energy by adding soda or spring water</li><li>Not suitable for persons sensitive to caffeine</li></ul>
2509 <ul><li>Sparletta Pine Nut 2ltr has a <b>sweet, coconut and pineapple flavour</b> - enjoyed cold or mix it with your favourite spirit for a zingy tropical drink</li><li>Sparletta is a brand aimed at teens and young adults, which encourages a spirit of having fun</li><li>1 case of 6</li></ul>
2511 <ul><li>Powerade Mountain Blast is <b>a tropical flavoured drink made with four electrolytes</b></li><li>It's designed to be in balance with your body's fluids to give you fast hydration and energy when you need it most</li><li>1 case of 24 units</li></ul>
2512 <ul><li>Sparletta Pine Nut 300ml has a <b>sweet, coconut and pineapple flavour</b> - enjoyed cold or mix it with your favourite spirit for a zingy tropical drink</li><li>Sparletta is a brand aimed at teens and young adults, which encourages a spirit of having fun</li><li>1 case of 24 units</li></ul>
2513 <ul><li>Powerade wants to be part of your fitness journey so that we can celebrate your personal best, no matter how big or small Powerade is the perfect sports drink before, during or after your workout that ensures you're beating your best</li><li>Naartjie flavour with hints of citrus </li><li>1 case of 24 units</li></ul>
2514 <ul><li>Powerade wants to be part of your fitness journey so that we can celebrate your personal best, no matter how big or small Powerade is the perfect sports drink before, during or after your workout that ensures you're beating your best</li><li>Orange flavour with hints of citrus </li><li>1 case of 24 units</li></ul> <p><br /></p>
2560 <ul><li>This wine imparts a <b>delicious foamy mouthful of black berries</b> with a smooth, long-lasting finish</li></ul>
2565 <ul><li>A beautiful <b>red blend of Shiraz</b>, Cabernet Sauvignon, Petit Verdot and Cabernet Franc matured for 12 to 16 months in French and American oak</li><li>Aromatic red berries coat the mouth with sweet spicy notes subtle vanilla and a silky smooth finish</li></ul>
2574 <ul><li>Plaisir de Merle Merlot is <b>ruby red in colour</b></li><li>The nose is teeming with violets, strawberries, blackberries and blackcurrant and a hint of mint</li><li>It is medium to full-bodied with a soft and velvety palate laced with ripe fruit and supported by vanilla oak flavours</li></ul>
2621 <ul><li>This timeless Cap Classique is the perfect balance of <b>crisp acidity, fragrant apples and subtle brioche</b>, for an elegant and distinctive flavour and feel</li><li>This MCC wine is an elegant and delicately layered blend of Pinot Noir and Chardonnay</li></ul>
2663 <ul><li>Vibrant, <b>inviting white with aromas of apple, lime and greengage and flavours of papaya, pineapple and gooseberry</b></li><li>The finish is clean with a hint of sherbert on the palate</li><li>Try it with salmon and hollandaise sauce or mussels</li></ul>
2664 <ul><li>The intense, <b>dark berry aromas and garrigue notes</b> of the nose follow through onto a mid-palate which is broody and sophisticated, yet exceptionally structured with chalky tannins and integrated acidity</li></ul>
2665 <ul><li><b>Raspberry and ripe plum with vanilla flavours and a velvety texture</b></li><li>Deep ruby appearance which persists to the rim. Attractive, open raspberry and vanilla nose with oak to the fore</li></ul>
2684 <ul><li>The <b>nose is vibrant and intense</b>, showing an abundance of lemon, lime, grapefruit and crème fraiche aromas and whiffs of pineapple</li></ul>
2801 <ul><li>Lovely complexity with mix of <b>tropical fruit</b>, tangy grassy notes, fig leaves & nectarine nuances with a crisp dry finish</li></ul>
3217 <ul><li>Created in the traditional French method of bottle fermentation or ‘Méthode Cap Classique’</li><li>Enjoy delicate yeasty aromas on the nose, complemented by fresh citrus flavours and crisp acidity</li></ul>
11119 <ul><li>On the palate the velvety, <b>creamy butter and citrus notes</b> blend seamlessly with delicate bubbles, light yeasty aromas, crisp, juicy pears, and litchi</li><li>Delicious on its own or served with Masala or Thai chicken curry, duck spring rolls with a quince and chilli jam, fresh strawberries, créme brûlée and tiramisu</li></ul>
12644 <p>PERNOD 750ML LIQUEUR SPIRIT APERITIF 1 x 750ML (1S)</p>
12709 PERDEBERG WINE LIGHTHEARTED PINOTAGE 1 x 750ML (EA)
12935 <p><span class="label_tag">VARIETY : </span>Pinot Noir [ 60% Pinot Noir, 40% Chardonnay ]<br /><span class="label_tag">WINERY : </span><a href="https://wine.co.za/winery/winery.aspx?CLIENTID=1139">Pongracz</a><br /><span class="label_tag">WINEMAKER : </span>Elunda Basson<br /><span class="label_tag">WINE OF ORIGIN : </span><span></span><br /><span class="label_tag">ANALYSIS : </span><span class="subheading">alc : </span>11.68 % vol <span class="subheading">rs : </span>8.0 g/l <span class="subheading">pH : </span>3.11 <span class="subheading">ta : </span>6.35 g/l <br /><span class="subheading">type : </span>Cap_Classique <span class="subheading">body : </span>Full <span class="subheading">taste : </span>Fruity <br /><span class="subheading">pack : </span>Bottle <span class="subheading">size : </span>750ml <span class="subheading">closure : </span>Cork </p>
13837
15148
15388