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 (
    2307, 2306, 2308, 13820, 11805, 2335, 
    2216, 2217, 15142, 2220, 2803, 2264, 
    2262, 13109, 13110, 12701, 2580, 4394, 
    2769, 2768, 2767, 2766, 12700, 13840, 
    2224, 15149, 2192, 2191, 15146, 15147
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00089

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 (2307,2306,2308,13820,11805,2335,2216,2217,15142,2220,2803,2264,2262,13109,13110,12701,2580,4394,2769,2768,2767,2766,12700,13840,2224,15149,2192,2191,15146,15147) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2191 <ul><li>Haig Club Clubman is matured exclusively in American ex-bourbon casks, allowing the sweet, <b>gentle Single Grain Scotch Whisky</b> from Cameronbridge to interact with the vanilla, butterscotch and sweet toffee flavours found in the ex-bourbon casks </li><li>The result is a wonderfully smooth, sweet and enjoyable whisky</li></ul>
2192 <ul><li>Haig Club Clubman is matured exclusively in American ex-bourbon casks, allowing the sweet, <b>gentle Single Grain Scotch Whisky</b> from Cameronbridge to interact with the vanilla, butterscotch and sweet toffee flavours found in the ex-bourbon casks The result is a wonderfully smooth, sweet and enjoyable whisky</li></ul>
2216 <ul><li>The Glenfiddich 12-year-old is a classic to many and a <b>reliable whisky</b> to pour without too much effort</li><li>It's also potentially the greatest omission on MALT until now, believe it or not</li><li>This Glenfiddich staple comes in the iconic bottle shape and symbolises easy drinking</li></ul> <p></p>
2217 <ul><li>From the Solera Vat, the cask strength whisky goes to Solera Tuns (around 2,500 litres) for a further settling period of at least 3 months – a method used by Glenfiddich for all of their whiskies</li></ul>
2220 <ul><li>The result is a smooth whisky which welcomes you with a rush of citrus, then holds your attention with layers of luscious flavour, from <b>orange to honey and creamy vanilla, with bursts of peach</b></li></ul>
2224 <ul><li>Grey GoosemVodka has an <b>exquisite clear, fresh and elegantly aromatic taste</b></li><li>This is a premium vodka of unparalleled smoothness and exceptional taste, with subtle hints of almond and a long, satisfying finish</li></ul>
2262 <ul><li>The Gordon recipe includes <b>coriander seeds, angelica root, liquorice, orris root and orange and lemon peel</b> amongst the 120 botanicals</li><li>Gordon's London Dry gin is carefully distilled using a secret recipe</li></ul>
2264 <ul><li>According to the manufacturer, Gordon's gin is triple-distilled and contains <b>juniper berries, coriander seeds, angelica root, licorice, orris root, orange, and lemon peel</b>, though the exact recipe has remained a closely guarded secret since 1769</li></ul>
2306 <ul><li>A <b>floral infusion of rose geranium and orange blossom</b> gives this non-alcoholic spirit a long lingering flavour</li><li>The finish has both a soft dryness and a subtle sweetness, making this the ideal choice for those who prefer to serve gin with lite tonics or soda water</li></ul>
2307 <ul><li>A purist take on a citrus gin with clean, crisp, citrus flavours taking centre stage in what is an incredibly refreshing taste</li><li>Fresh citrus flavours linger on the tongue, with <b>lime</b> and grapefruit once again clearly distinguishable long after the last drop is gone</li></ul>
2308 <ul><li>An eastern style London Dry, the Spice gin <b>produces complex spicy notes with hints of cinnamon</b></li><li>The unique and bespoke flavours coat the mouth and tongue with the convivial appeal, finishing smoothly</li><li>The complexity and smoothness of the Spice gin make it easy to enjoy neat on the rocks</li></ul>
2335 <ul><li>A great beginner's whisky right here from the Glen Grant Distillery, produced in tall pot stills</li><li>This <b>10 year old Speyside single malt</b>, having spent a decade in bourbon casks, boasts oodles of light, malty notes</li></ul>
2580 <ul><li><b>Graca is lively-coloured with flashes of green</b>, a touch of asparagus on the nose and crisp, lemony, off dry flavours</li><li>Its petillance gives it a palate-tingling lift</li></ul>
2766 <ul><li>This delightful sparkling wine <b>exudes light yeasty aromas, limey fresh fruit on the nose, and rich creamy complexity on the palate</b></li></ul> <p></p>
2767 <ul><li>Sweet red berry fruit flavours from the <b>Merlot and Cabernet Franc</b> and spiciness from the Shiraz with layers of subtle fruit tannins on the palate</li><li>Enjoy with veal, roast lamb, stews or rich pasta dishes</li></ul>
2768 <ul><li>The Graham Beck Brut Rose has all the hallmarks of a traditional and carefully crafted bublly, with the addded appeal of bein flirtatious and fun</li><li>Elegant and structured, it truly is a sparkling wine for all seasons <a href="https://www.google.com/search?q=Is+Graham+Beck+Brut+Rose?&amp;sxsrf=AOaemvJHY6NL_Zuu0l56urmh7iniRWI5bQ:1631440086696&amp;tbm=isch&amp;source=iu&amp;ictx=1&amp;fir=kILCQ5y_pvRpiM%252CqioBBSzuZZDjUM%252C_&amp;vet=1&amp;usg=AI4_-kQmYeFbkY0uL25bgQTffIRonU_LoA&amp;sa=X&amp;ved=2ahUKEwiyotv2k_nyAhWTasAKHTerD8gQ9QF6BAgLEAE#imgrc=kILCQ5y_pvRpiM"><br /></a></li></ul>
2769 <ul><li>The Graham Beck wines are classic in style and a good value, <b>reliable alternative to Champagne</b></li><li>Here we have bready aromas allied to some New World fruitiness, and although the complexity of good Champagne is lacking, it's a very well-made traditional method wine</li></ul>
2803 <ul><li>Apple honey bread dough</li><li>A very good bottle of MCC</li><li>High acidity</li><li>Tertiary notes of honey and bread dough</li></ul>
4394 <ul><li>For those who do not like it dry, the Graham Beck Demi-Sec is perfect</li><li>With <b>light yeasty aromas and hints of butterscotch, honey and praline</b>, this delectable bubbly will stimulate your sweeter senses</li></ul>
11805 <ul><li>The <b>Glen Carlou</b> flagship Chardonnay is regarded for its well integrated fruit with rounded oak maturation flavour profile</li></ul>
12700 <p>GRAHAM BECK 750ML WINE GORGEOUS PINOT NOIR CHARDONNAY 1 x 750ML (EA)</p>
12701 <p>GORGEOUS SPARKLING CAP CLASSIQUE 1 x 750ML (EA)</p>
13109
13110
13820
13840
15142
15146
15147
15149