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 (
    15087, 15056, 15050, 15049, 15048, 15047, 
    11134, 2816, 2815, 13609, 13514, 2214, 
    15387, 2451, 2453, 2162, 12741, 11785, 
    15298, 2806, 2805, 2710, 2709, 2712, 
    2711, 4211, 4353, 11891, 11835, 2253
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00079

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": 30,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (15087,15056,15050,15049,15048,15047,11134,2816,2815,13609,13514,2214,15387,2451,2453,2162,12741,11785,15298,2806,2805,2710,2709,2712,2711,4211,4353,11891,11835,2253) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2162 <p>REMY MARTIN 750ML COGNAC VSOP 1 x 750ML (1S)</p>
2214 <ul><li>Red Heart is <b>double distilled</b> and is an aromatic blend of 18 different types of Caribbean Rum ranging from the light and clean continuous still rums, to the heavier, fruitier flavoured Pot still rums which typify the Jamaican Rums and set them apart from all others</li></ul>
2253 <ul><li>Richelieu International Brandy is a <b>French brandy</b>, steeped in the French brandy master's art of combining breeding, purity, mellowness, and maturity to produce a rich and rewarding, full-bodied brandy</li><li>It's very fresh, smooth with sweet fruits and spice on the palate</li></ul> <p></p>
2451 <ul><li>Red Heart is <b>double distilled</b> and is an aromatic blend of 18 different types of Caribbean Rum ranging from the light and clean continuous still rums, to the heavier, fruitier flavoured Pot still rums which typify the Jamaican Rums and set them apart from all others</li><li>1 case - 24 x 500ml cans </li></ul>
2453 <ul><li>Red Heart is <b>double distilled</b> and is an aromatic blend of 18 different types of Caribbean Rum ranging from the light and clean continuous still rums, to the heavier, fruitier flavoured Pot still rums which typify the Jamaican Rums and set them apart from all others</li><li>1 x crate of 660ml bottles </li></ul>
2709 RHINO RUN 750ML CHARDONNAY WINE 1 x 750ML (1s)
2710 <p>RHINO RUN 750ML CABERNET SAUVIGNON WINE 1 x 750ML (1s)</p>
2711 <p>RHINO RUN 750ML PINOTAGE WINE 1 x 750ML (1s)</p>
2712 <p>RHINO RUN 750ML IAN PLAYER WINE 1 x 750ML (1s)</p>
2805 <ul><li>This Shiraz/Cabernet Sauvignon blend offers <b>spicy aromas of black pepper, cherry and cedar wood with the accompaniment of violet and plum scents on the nose</b></li><li>The palate is well-balanced and structured with fresh, juicy tannins and a dry finish</li></ul>
2806 <ul><li>This is a <b>delicate wine</b> with a complex array of aromas and flavours ranging from lime, pineapples and quince to tinned peas and fresh asparagus</li><li>It is clean, keen and zesty, the mouth is full and rounded with enough dryness and acidity to make the wine mouth-watering</li></ul>
2815 <ul><li>His Syrah is an exceptional example of just how fantastic his wines can be</li><li>The Syrah <b>leans towards an Old World</b>, French style, indicating Alex's background in Burgundian wines</li><li>Ripe, dark fruits lead on the palate with hints of spice providing an excellent balance. Stunning.</li></ul>
2816 <ul><li>This example is a wonderfully lively, intense, <b>fruity</b> and beautifully balanced dry Chenin Blanc. </li><li>Aromas of green apples and white peach invite the juicy, yet taut palate</li><li>A depth of fruit is what sets this wine apart</li></ul>
4211 <ul><li>Rib Shack Red is <b>a stellar wine out of South Africa</b></li><li>Robust, yet smooth Rib Shack Red wine out of South Africa's Western Cape is a very versatile wine that pairs well with both meats and poultry</li><li>The rich dark berry flavors meld beautifully with a slightly smoky oak spice from wood maturation</li></ul>
4353 <ul><li>Ricard is a pastis, an anise and licorice-flavoured aperitif, created by Marseille native Paul Ricard in 1932, who marketed it as the "true pastis from Marseille"<sup class="reference"></sup></li><li>Licorice flavour</li><li>French liquer</li></ul>
11134 <ul><li>Cassis <b>and blackcurrant aromas with light floral and herbal nuances</b></li><li>Elegant and genteel in a toned, restrained way the wine is full of cassis, cocoa and tobacco leaf with a dry cranberry element</li></ul> <p><br /></p>
11785 <p>REMY MARTIN COGNAC CHAMPAGNE FINE 1 x 750ML (1S)</p>
11835 <p>Richelieu is a brandy made vin the age-old French tradition, steeped in the French brandy master’s art of combining breeding, purity, mellowness and maturity to produce a rich and rewarding, full-bodied brandy. Its mellow maturity flows from years in casks of Cognac oak, while its richness derives from the fine art of traditional French copper pot distillation.</p>
11891 <p>RICHELIEU BRANDY 750ML 10YR 1 x 750ML (1S)</p>
12741 <p><span class="ILfuVd"><span class="hgKElc">Launched mid 2003, <b>'XO Excellence' replaced Rémy's 'XO Special</b>. Comprising 15% Petite Champagne and 85% Grande Champagne, this Fine Champagne cognac is blended from some 300 eaux-de-vie aged 10 - 37 years and is said to have an average tasting age of 25 years</span></span><br /></p><p></p>
13514 <ul><li>Red Bull Energy Drink&nbsp;</li><li>8.3 FL OZ</li><li>1 x Case = 24 250ml cans</li></ul> <p></p>
13609 <p>Aquarite Raspberry Apple flavoured Sparkling Water</p><p>12 x 500ml Pack</p>
15047
15048
15049
15050
15056
15087
15298
15387