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 (
    2241, 2238, 2164, 2283, 11114, 14589, 
    15137, 2743, 2742, 2687, 11797, 11796, 
    2688, 11899, 11898, 2756, 2755, 15156, 
    11810, 2189, 2328, 12694, 12696, 12695
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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 (2241,2238,2164,2283,11114,14589,15137,2743,2742,2687,11797,11796,2688,11899,11898,2756,2755,15156,11810,2189,2328,12694,12696,12695) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2164 <ul><li>Courvoisier VS cognac is a blend of several crus aged between three and seven years, composed principally of Fins Bois with a balancing hand of Petite Champagne</li><li>The fusion of younger and older cognacs gives Courvoisier VS a fruity, delicate taste and a bouquet filled with ripe fruit and spring flowers</li></ul>
2189 <ul><li>Dimple is famous for not only its unique bottle shape, but by its long standing reputation for producing one of the finest blended malts available</li><li>Using malts predominantly from Glenkinchie and Linkwood, Dimple 12 Year Old is a beautifully well-rounded Scotch with surprising depth</li></ul>
2238 <ul><li>A mineral infusion with some light floral notes, pineapple skins and white chocolate </li><li>The palate is oily with a thick dose of cream, coconut and vanilla all of which appear well on the finish with some white pepper</li><li>12 x 50 ml bottles in a pack </li></ul> <p></p>
2241 <ul><li>A mineral infusion with light floral notes, pineapple skins and white chocolate </li><li>The palate is oily with a thick dose of cream, coconut and vanilla all of which appear well on the finish with some white pepper</li></ul>
2283 <ul><li>A clear, fragrant liquid, Cruxland Gin infused with Kalahari Truffles boasts notes of fresh juniper and lemon</li><li>Further enhanced by coriander and spices with an earthy character from the Kalahari truffles</li></ul>
2328 <ul><li>Disaronno is a type of amaretto—an amber-colored liqueur with a characteristic almond taste, although it does not actually contain almonds</li><li><em>It is produced in Saronno, in the Lombardy region, and is sold worldwide</em></li><li><a href="https://www.google.com/search?q=What+is+amaretto+Trussardi?&amp;sxsrf=AOaemvKeIPy7pXo2iToes5mBbFeNYF3s3w:1630953698769&amp;tbm=isch&amp;source=iu&amp;ictx=1&amp;fir=vXwU5R81zjR5mM%252C6Ku-8nxDTkdlXM%252C_&amp;vet=1&amp;usg=AI4_-kSMtfhipAye9VIVGNljZufDYn3-PA&amp;sa=X&amp;ved=2ahUKEwiDnfD-_-ryAhUKEcAKHZ9wAYgQ9QF6BAgnEAE#imgrc=vXwU5R81zjR5mM"><i class="rISBZc M4dUYb" style="margin-right:-45px;"><i class="rISBZc M4dUYb" style="color:rgb(51,51,51);margin-right:-45px;"><span class="ILfuVd NA6bn"><span class="hgKElc"><em>A cocktail designed by the barmen at Café Trussardi to <b>enhance the flavour of Disaronno liqueur</b></em></span></span></i></i></a></li><li><a href="https://www.google.com/search?q=What+is+amaretto+Trussardi?&amp;sxsrf=AOaemvKeIPy7pXo2iToes5mBbFeNYF3s3w:1630953698769&amp;tbm=isch&amp;source=iu&amp;ictx=1&amp;fir=vXwU5R81zjR5mM%252C6Ku-8nxDTkdlXM%252C_&amp;vet=1&amp;usg=AI4_-kSMtfhipAye9VIVGNljZufDYn3-PA&amp;sa=X&amp;ved=2ahUKEwiDnfD-_-ryAhUKEcAKHZ9wAYgQ9QF6BAgnEAE#imgrc=vXwU5R81zjR5mM"><i class="rISBZc M4dUYb" style="margin-right:-45px;"><i class="rISBZc M4dUYb" style="color:rgb(51,51,51);margin-right:-45px;"><span class="ILfuVd NA6bn"><span class="hgKElc"><em>With its distinctively fresh flavour, created with ingredients such as sour mix and lime, this cocktail perfectly complements the Disaronno</em></span></span></i></i></a></li></ul>
2687 <ul><li>Aromas of cassis, plum, cedar wood and cigar box with a slight herbaceous undertone</li><li>The palate is well structured with fine and delicate tannins and beautiful oak integration</li><li>Cassis flavours linger on the finish</li></ul>
2688 <ul><li>Light crimson colour with a purple tinge which indicates youthfulness of the wine</li><li>On the nose prunes, blue berries with undertones of spice and dark chocolate come to mind</li><li>The palate lingers with flavours of fruit supported by silky tannins</li></ul>
2742 <ul><li>De Krans Ruby Port is a gorgeous, perfectly balanced port bursting with fruity flavours and some hints of spice in the aromas create a delicious port</li></ul>
2743 <ul><li>Lovely coppery-gold colour</li><li>Flavours of coffee-toffee, hazelnut, cinnamon spice, as well as some raisins in the background</li><li>Good, long finish and excellent grip at 19% alcohol</li></ul>
2755 <ul><li>The Journal Sauvignon Blanc is made from carefully selected grapes and fermented in French oak barrels to ensure a wine with a full, rich mouthfeel and a long finish</li><li>The flavours fynbos, cassis and tropical fruit are underpinned by a core of minerality and complex fruit and vanilla flavours</li></ul>
2756 <ul><li>The nose seduces with beautiful ripe blackberry and dried fruit aromas along with spicy undertones</li><li>This wine is well structured with elegance and mouth filling fruit flavours</li><li>Hints of cedarwood,mint and spice flavours follow through on the palate</li></ul>
11114 <ul><li>This super premium handcrafted vodka is distilled four times and charcoal filtered three times</li><li>It is blended with pure water producing a vodka with intense purity and exceptional smoothness</li><li>This quality vodka has a delicately smooth finish and a captivating aroma of delicious Candy</li></ul>
11796 <ul><li>Delheim Pinotage Rose is <b>a classic and light</b>, with grapefruit and berry aromas</li></ul>
11797 <ul><li>A <b>medium bodied and fruit driven style of Merlot</b>, with a subtle structure and silky tannins</li><li>Fleshy plums, cigar box and oak undertones with very smooth and silky tannins</li><li>Perfect to savour on it's own but also a great companion to a hearty lamb stew</li></ul>
11810 <ul><li>The original Coffee/Chocolate style Pinotage</li><li>On the <b>nose rich dark chocolate and powerful freshly brewed coffee styling</b>, with a hint of mint and baked plums</li><li>The palate shows distinct characters of coffee and chocolate, which is balanced with smooth velvety tannins and a lingering aftertaste</li></ul>
11898 <ul><li>Dias Cordial - Lime - 1 x 750 ml </li></ul>
11899 <ul><li>Dias Cordial - Grenadine - 1 x 750 ml </li></ul>
12694 <p>DOUGLAS GREEN V/YARD FRIENDS CHENIN BLANC 1 x 750ML (EA)</p>
12695 DOUGLAS GREEN VINEYARD FRIENDS PINOTAGE 1 x 750ML (EA)
12696 <p>DOUGLAS GREEN VINEYARD FRIENDS MERLOT MALBEC 1 x 750ML (EA)</p>
14589 <p>Light and bubbly. Well priced not too sweet. Good value. Crisp and refreshing. Better than any other Prosecco I’ve tasted to date. May even be better than some leading MCC bubbly. Definitely going to have a bottle in the chiller. Really enjoyed this bottle</p>
15137
15156