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 (
    2532, 2533, 2534, 13416, 2357, 2807, 
    12976, 2305, 2304, 11806, 12980, 12740, 
    11117, 11787, 2587, 2588, 2591, 2590, 
    2553, 2589, 2581, 2592, 2576, 2685
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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 (2532,2533,2534,13416,2357,2807,12976,2305,2304,11806,12980,12740,11117,11787,2587,2588,2591,2590,2553,2589,2581,2592,2576,2685)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2304 <ul><li>Musgrave 11 Premium is no ordinary gin and its <b>top notes of aromatic Cardamom, African Ginger</b> (Whitei Mondei) and Grains of Paradise are reminiscent of the perfume of spice markets</li><li>The woody character gives way to cloves, cinnamon and a faint hint of cardamom and leaves you with a gentle flame</li></ul>
2305 <ul><li>Musgrave Gin is <b>born out of the flavours and history of Africa and its ancient spice route</b></li><li>Musgrave Premium is no ordinary gin and its top notes of aromatic Cardamom, African Ginger (Whitei Mondei) and Grains of Paradise are reminiscent of the perfume of spice markets</li></ul>
2357 <ul><li>Mount Gay is like <b>a single malt within rum</b>, made completely in Barbados from fermentation to bottling</li><li>Only the best sugarcane from Barbados and the Caribbean and follow open&dash;air fermentation in wooden casks using coral&dash;filtered water from our own original well and proprietary yeasts for aromatic richness</li></ul>
2532 <ul><li>Monster Energy Rossi with a <b>light, crisp and refreshing citrus flavour</b></li><li>With a light, crisp, refreshing citrus flavour and a full load of our legendary Monster Energy blend, it will get you up to speed in a hurry</li></ul>
2533 <ul><li>Monster Ultra is available in these zero-calorie flavors: Zero Ultra (<b>citrus</b>) Ultra Blue (light citrus and berry) Ultra Red (mixed berry)</li><li>"White Monster" is zero sugar, lighter-tasting, zero calories, but with a full load of our Monster energy blend</li><li>1 case of 24 units</li></ul>
2534 <ul><li>It has been proven <b>to counter fatigue and depression</b>, boost mental alertness, and promote weight loss. Predator energy drink also improves erection and sexual stamina or performance</li><li>1 case of 24 units</li></ul>
2553 <ul><li>Colour Bright red</li><li>Bouquet Rounded, <b>svelte red fruit aromas with black cherries, chocolate and a hint spice</b></li><li>Flavours of cocoa and black cherry, with creamy texture and a hint of exotic masala spice and peppercorn</li></ul>
2576 <ul><li>Made <b>from Chenin Blanc and Sauvignon Blanc grapes</b>, this fresh and fruity non-vintage sparkling wine was left on the lees (residual yeast) for almost two months prior to final blending</li><li>Strikingly clear with a vivid sparkle</li><li>Subtle pear and floral fragrances</li></ul>
2581 <ul><li>Pale straw colour with a <b>lifted nutty and herbal aromas with spicy and citrus notes</b></li><li>Also flavours of nuts, herbs and citrus fruit, well balanced with a fresh, clean finish</li></ul> <p><br /></p>
2587 <ul><li>Baronne is a <b>full-bodied wine with ripe juicy flavours, soft tannins, and light oaking</b> that is smooth, elegant, and self-assured With blueberry, cassis, a twist of pepper, and cinnamon, this wine is juicy, smooth, and velvety in the mouth</li></ul>
2588 <ul><li>Ruby red a<b>romas of sweet red and dark fruits</b>, with subtle hints of spice and well-integrated oak</li><li>A full-bodied wine with ripe fruit, blackcurrant and intricate oak flavour, supple tannins and a lingering aftertaste</li></ul>
2589 <ul><li>The Nederburg Pinotage is <b>vibrant red with aromas of plums and prunes and some subtle oak spice</b></li><li>A full mouthfeel with rich fruit flavours, soft tannins and a lingering aftertaste</li></ul>
2590 <ul><li>Brilliant with green tinges and aromas of passion fruit and jasmine with hints of melon and lime</li><li>Off-dry, crisp with a lovely follow-through of fruit aromas on the pallet.</li><li>Delicious with seafood, light meals and salads</li></ul> <p></p>
2591 <ul><li>Nederburg Winemasters Chardonnay is a <b>light straw-yellow with tints of green and gold</b></li><li>The nose has aromas of lime and dried apricot with vanilla oak notes in the background</li><li>The palate is crisp and fresh with a creamy texture and subtle citrus and apricot flavours leading to a an elegant finish</li></ul>
2592 <ul><li>Deep violet-ruby colour with <b>floral, smoky, prune, black olive and spice aromas</b></li><li>Medium-to-full bodied with rich dark berry flavours and a long finish<strong></strong></li></ul>
2685 <ul><li><b>Elegant red fruit carrying through on the palate with hints of coffee and nougat</b></li><li>A slight refreshing mint influence. Medium-bodied with soft tannins providing just enough structure</li></ul>
2807 <ul><li><b>Ripe tropical aromas of mango, pineapple and papaya</b> are lifted by a crisp, refreshing apple note</li><li>The palate is defined by a delicious fine mineral texture leading onto a succulent mid-palate</li><li>The final impression is one of a full flavoured, yet precisely poised Chenin Blanc</li></ul>
11117 <ul><li>Ruby red</li><li>Aromas of sweet red and dark fruits, with subtle hints of spice and well-integrated oak</li><li>A full-bodied wine with ripe fruit, blackcurrant and intricate oak flavour, supple tannins and a lingering aftertaste</li></ul>
11787 <ul><li>This wine is made entirely from Chenin Blanc</li><li>Reminiscent of ripe fruits, especially apricots and oranges with floral hints and traces of raisin and spice</li><li>Well-balanced, fresh and fruity with a beautiful minerality and an excellent structure</li></ul><p></p>
11806 <ul><li>A <b>crisp dry, refreshingly white wine with guava fruitiness on the nose</b></li></ul>
12740 <p>NDLOVU GIN ORGINAL 1 x 750ML (EA)</p>
12976 <p>Perfectly balanced with lingering focus and<br />acidity, the mid palate plays with classic cassis<br />and thyme flavours. Very much a wine for all<br />occasions.</p>
12980 <p>Aquarite's delicious natural tasting Nartjie Flavoured Sparkling Water is full of bubbles and packed with great taste.</p><p>12 x 500ml Packs</p><p>Sparkling drink</p>
13416 <p>Monster energy Drink, Purple, Energy</p>