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 (
    15123, 2184, 2231, 2288, 2754, 2346, 
    2348, 2345, 2344, 2350, 15295, 2250, 
    2223, 2649, 2652, 2651, 2650, 2634, 
    12688, 2639, 2637, 2638, 2355, 2204
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00069

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 (15123,2184,2231,2288,2754,2346,2348,2345,2344,2350,15295,2250,2223,2649,2652,2651,2650,2634,12688,2639,2637,2638,2355,2204) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2184 <ul><li>Black and White is smooth, light, fresh and spciy with smokey hints</li><li>It is pale gold in colour with sweet aromas of oak, biscuits with notes of sharp grain alcohol, and a touch of peat</li><li>A short finish with notes of vanilla, honey and oak</li><li>200ml bottle&nbsp;</li></ul> <p></p>
2204 <ul><li>Grain whiskey reserved for Bushmills Original is slowly matured for a minimum of five years in American oak casks before blending with Irish Single Malt to produce this popular whiskey</li></ul>
2223 <ul><li>Bombay Sapphire is a London Dry gin,<b> </b>but that's not a regional designation (like Bordeaux or Scotch whisky)</li><li>It's a style specifically, a dry style of gin that doesn't use any artificial ingredients</li><li>Instead, distillers balance piney juniper notes with a dealer's choice of botanicals and spices</li></ul>
2231 <ul><li>The Black Douglas Scotch whisky was named after Sir James Douglas,<b> </b>a Scottish knight who fought in the Scottish Wars of Independence</li><li>A well-balanced grain and malt blend Scotch whiskey</li><li>The Black Douglas is a soft, well-aged product with a smooth finish</li></ul>
2250 <p><br /></p> <ul><li>Bols Brandy is triple-distilled from long fermented corn, rye and wheat with juniper berries </li><li>A personal blend from our Master Distiller</li><li>100% Malt Spirit  </li></ul>
2288 <ul><li>Black Moon Caramel Liqueur is a decadent blend of premium vodka and deliciously rich caramel flavours which gives it its distinctive taste</li><li>Black Moon has a golden honey colour and a deliciously smooth, unforgettable taste of caramel</li></ul>
2344 <ul><li>Clear BOLS Triple Sec is a crystal clear liqueur flavoured with Curaçao,orange peel and hints of citrus </li><li>Bols Triple Sec is without a doubt the most essential liqueur in a modern bar</li><li>At least half of all classic and modern drinks are made with Triple Sec or a variant, like Dry Orange Curaçao</li></ul>
2345 <ul><li>Bols Crème de Menthe Peppermint liqueur is widely used as a digestive liqueur </li><li>Can be enjoyed straight, on the rocks and added to cocktails</li></ul>
2346 <ul><li>Banana liqueurs (crème de banane)</li><li>Bols Banana is based on a rum distillate rather than neutral spirit</li><li>Provides extra character and is flavoured with banana extract enhancing by a touch of vanilla and a hint of almonds </li></ul> <p><span class="hgKElc"><b></b></span></p> <p></p>
2348 <ul><li>Bols Elderflower Liqueur is flavoured with the <b>cream coloured, honey scented blossoms</b> of the elder tree, also called the sambucus nigra</li><li>Bols soaks dried elderflower blossoms in a water/alcohol mixture with a secret water/alcohol ratio in order to extract the optimum flavour</li></ul>
2350 <ul><li>Bols Zeer Oude Genever has a rich palate full of grainy, fruity notes and hints of juniper berry</li><li>It is made from a rye, corn and wheat distillate</li></ul>
2355 <p>BULLDOG 750ML GIN 1 x 750ML (EA)</p>
2634 <ul><li>Pale gold with a flourish of delicate bubbles and enticing lemon cream and almond Biscotti precede</li><li>Lovely layers of citrus and a finish with appealing tones of fruit aromas</li></ul>
2637 <ul><li>Expressive tropical fruit salad aromas leap out of the glass, followed by underlying green fig and apple notes</li><li>Fruit forward with a rich tropical mid-palate of guava and passion fruit underlined by green fig</li><li>This Sauvignon Blanc is made in a lively and fresh style, displaying complex but beautifully balanced fruit</li></ul>
2638 <ul><li>This Brampton Unoaked Chardonnay is pale yellow with a green tint </li><li>Citrus and lime on the nose as well as a hint of pear, peach and winter melon</li><li>This is a rich wine with a creamy core layered with not only lime notes, but also delicate green apple</li></ul>
2639 <ul><li>The wine has a rich ruby colour with a dense core of red cherry, mulberry and blackcurrant flavours</li><li>There is also a hint of ripe plum and cocoa on the nose, which is backed by dark chocolate notes</li><li>The ripe, silky tannins offer smooth drinkability, while the oak and clove notes add complexity</li></ul>
2649 <ul><li>The original Cape Blanc de Noir-style wine that inspired an entire category and remains a South African favourite and a Boschendal classic</li><li>An appealing pale salmon colour leads to bright red fruit, strawberry and red berries</li><li>Good freshness, balance and drinkability. Crisp and dry, but with a pleasant hint of fruit sweetness</li></ul>
2650 <ul><li>This fruit driven white wine shows complex mineral aromas on the nose</li><li>The rich, complex palate has ripe peach and pineapple flavours</li><li>Ready to drink now, it is an ideal choice for all occasions</li></ul>
2651 <ul><li>This bold statement wine, which is big on aromas and flavours, has a lemony, cinnamon and nutmeg nose </li><li>Well balanced with a soft, buttery character from barrel fermentation and maturation add to the complexity and roundness of the wine</li></ul>
2652 <ul><li>The Brut Rosé captivates with its delicate pale pink colour </li><li>Intoxicating red fruit aromas which further delight the palate with hints of strawberry, raspberry and cherry flavours</li></ul>
2754 <ul><li>This handcrafted Cabernet Sauvignon has layers of ripe blackcurrant and spice flavours on the palate</li><li>Well-balanced with firm structure and elegance followed by lingering savoury notes</li><li>Lengthy barrel aging adds complexity and elegance to this richly layered wine</li><li>Delicious with grilled beef or any red meat dishes</li></ul>
12688 <p>BOSCHENDAL WINE NICOLAS 1 x 750ML (EA)</p>
15123
15295