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 (
    2822, 2244, 2245, 2808, 2351, 2352, 2342, 
    2270, 2843, 2225, 2323, 2266, 13822, 
    2813, 2814, 13821, 4378, 2550, 2551, 
    13142, 15143, 15144, 12684, 14457, 
    2176, 2171, 2169, 2168, 2167, 2165
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00115

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 (2822,2244,2245,2808,2351,2352,2342,2270,2843,2225,2323,2266,13822,2813,2814,13821,4378,2550,2551,13142,15143,15144,12684,14457,2176,2171,2169,2168,2167,2165) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2165 <ul><li><b>Exotic fruity aroma, sweet and sour taste</b> which will make you feel like eating fresh passion fruit</li><li>With a true sweet and sour taste, MONIN Passion Fruit syrup is particularly enhanced with other exotic flavours such as mango</li></ul>
2167 <ul><li>The morello cherry, which takes its name from <b>the Italian word for sour</b>, has a distinctly orange flesh and is softer and less sweet than the classic cherry resulting in a fruity abundance of sour flesh</li></ul>
2168 <ul><li>Monin Mango Syrup adds rich, smooth flavor to lattes, mochas, smoothies, shakes, specialty cocktails or even whipped cream</li><li><b>Pure Cane Sugar</b>, Water, Natural Flavors, Natural Mango Extract</li></ul>
2169 <ul><li>Its flesh is almost creamy in consistency with an <b>invigorating taste reminiscent of strawberries</b>, melons and bananas, yet with its own unique sweet, slightly tart flavour</li><li>Try MONIN Kiwi syrup to enjoy the unique kiwi fruit taste and beautiful green colour in your signature drinks</li></ul>
2171 <ul><li>MONIN Coconut liqueur will transport you to sunny island beaches</li><li>Thanks to its <b>creamy coconut flavour</b> and its gentle touch of almond, MONIN Coconut liqueur will bring roundness and fruity flavour to your drink</li><li>You will love it for all exotic cocktails from pina-coladas, punches, batidas to tikis</li></ul>
2176 <ul><li>Monin Chai Tea Concentrate is the convenient, premium choice for creating delicious spiced chai teas, hot or cold speciality coffee drinks, dessert cocktails, culinary creations and more</li><li><b>Very aromatic, exotic, distinctive spiced aroma with predominant clove/cinnamon, spiced green tea flavour</b></li></ul>
2225 <ul><li>Martini Bianco is a <b>fine blend of Italian white wine infused with herbs and sweet floral botanicals</b> and produces an aromatic yet delicate drink with notes of vanilla and citrus</li><li>Drink over ice with soda and a slice of lemon - the perfect Italian spritzer</li></ul>
2244 <ul><li><b>Lupini Black Sambuca</b> is a produly South African shooter infused with an inspiring liquorice taste and bottled at a healthy 35% ABV to get any party going</li></ul>
2245 <ul><li><b>Lupini Gold Sambuca</b> is the showstopping anise and liquorice infused shooter with 22 carat <b>gold</b> flakes hinting at the true quality of this South African gem</li></ul>
2266 <ul><li>Martini Rosso is <b>slightly sweet, incredibly aromatic</b>, and has a distinctive herbal finish that is accompanied by a subtle bitterness</li></ul>
2270 <ul><li>Malibu Rum is the world's best-selling Caribbean rum with natural coconut flavour and a smooth and sweet finish</li><li>Caribbean rum with coconut flavour is perfect for when the sun's setting and the good times are flowing</li></ul>
2323 <ul><li>The exceptional crispness of a Martini Extra Dry cocktail stands up well to <b>sharp, acidic flavours</b>, and will cut straight through rich foods, such as oily fish</li><li>Try it teamed with the silvery, acidic richness of marinated sardines or anchovies</li></ul>
2342 <ul><li>Maker's Mark is a <b>small-batch bourbon whiskey</b> produced in Loretto, Kentucky, by Beam Suntory</li><li>It's a <b>sweet whiskey smelling of caramel and vanilla</b> that lands on the front of your palate, soft and smooth, with a long, warm finish</li></ul> <p><br /></p>
2351 <ul><li>Highlands, Scotland- Matured at The Macallan distillery for a minimum of 12 years in Sherry oak casks from Spain, this is a classic, <b>full-bodied Single Malt</b></li><li>Deliciously smooth palate of dried fruits, spice and wood smoke, leads to notes of flowers and sherry on the finish</li></ul>
2352 <ul><li>Loads of oak and perfume reads as <b>somewhat bitter at first</b>, with notes reminiscent of an amaretto sour and a hint of spiced plums</li><li>The nose softens dramatically after a few minutes, settling into dark sherry and plum sweetness</li><li>Sweet and full, but not overly complex</li></ul>
2550 <ul><li>The Moet & Chandon Imperial Brut NV is characterized by <b>bright fruitiness and elegant maturity</b></li><li>The colour is an elegant golden straw yellow with amber highlights</li><li>Radiant aromas reveal notes of apple, pear, yellow peach, honey, and floral nuances along with elegant blond notes of brioche and fresh nuts</li></ul>
2551 <ul><li>Brut Rose Imperial is a blend of the three wine varieties, with an emphasis on Pinot Noir, embodying a fruity and daring character</li><li><b>A dry, delicate rose, displaying hints of strawberry, melon and honeysuckle</b></li></ul>
2808 <ul><li>Aromas of black cherry, mulberry, fresh herbs and a hint of fennel</li><li>The palate shows great fruit density, bright acidity and fine tannins with a smooth finish</li></ul>
2813 <ul><li>Very bright, polished platinum with green, vivacious hue</li><li>Complex, appealing <b>nose with pear, citrus and floral notes</b> developing into lemon cream, oatmeal and marzipan richness</li><li>On the palate the wine is full bodied & generous, but still sleek and balanced by crisp acidity</li></ul>
2814 <ul><li>Very <b>classic Rubicon nose with violets</b>, ripe plum, cedar wood and intense spiciness</li><li>A typical liquorice note also evident on the nose. Still young and intense, promising further maturation potential</li><li>The palate is full bodied, structured but packed with fresh dark fruit and rounded, linear tannins</li></ul>
2822 <ul><li>Lively <b>hints of raspberry and cherry blossom intertwine </b>with sweet strawberry and subtle rose petal</li><li>The vibrant colour of this wine comes to life on the palate with the prominent taste of sweet red fruit and sherbet, the perfect combination of freshness and acidity</li></ul>
2843 <ul><li>The best are deliberate, focused, poised and generous, and show a <b>bright array of flavours and textures</b></li><li>Margaret River is making a really exciting variety of rosés, the best of which are scintillatingly layered, engagingly complex, and spicily dry</li></ul>
4378 <p>MILLERS GD 330ML BEER NRB 24 x 330ML</p>
12684 <p>MOET&CHANDON BRUT 2021 GIFTBOX 1 x 750ML (EA)</p>
13142 <p>Founded in 1743, <b>Moët & Chandon</b> is the Maison that introduced <b>champagne</b> to the world by offering a range of unique wines for every occasion.</p>
13821
13822
14457
15143
15144