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 (
    2788, 2612, 15385, 2608, 2609, 2561, 
    2610, 2611, 2571, 2317, 2318, 12754, 
    11610, 11606, 11818, 11607, 11608, 
    14076, 14077, 11135, 12977, 12677, 
    12654, 2763
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 24,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (2788,2612,15385,2608,2609,2561,2610,2611,2571,2317,2318,12754,11610,11606,11818,11607,11608,14076,14077,11135,12977,12677,12654,2763)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2317 <ul><li>el Jimador Tequila is crafted using 100% agave and fermented naturally with wild yeast produced by the fruit trees and agave plants surrounding the distillery</li><li>el Jimador Tequila was introduced in 1994 as the world's first premium tequila at an accessible price point</li></ul>
2318 <ul><li>Named after the farmers who grow and harvest the agave plants, El Jimador Reposado is a 100% agave tequila aged for 3 months before bottling</li><li>el Jimador Tequila is <b>crafted using 100% blue agave and fermented naturally with wild yeast</b> produced by the fruit trees and agave plants surrounding the distillery</li><li>The final product is a premium, crisp tequila, perfect for any occasion</li><li>Sip it neat, on the rocks or in any cocktail</li></ul> <p></p>
2561 <ul><li>The grapes for this wine were selected from vineyards on the low- lying, south-facing slopes</li><li>The soil moisture levels of this particular vineyard ensured small berries with an excellent skin-to-fruit ratio providing an intense colour and flavour spectrum</li></ul>
2571 <ul><li>Colour: Brilliant clear with green edges </li><li>Nose: The bubble in the wine elevates both the greener and the riper tropical elements of the Sauvignon Blanc, resulting in a delightful bouquet of green pepper, kiwi fruit, fig and gooseberry</li><li>Taste: The burst of tiny bubbles on the tongue awakens the palate, allowing it to fully appreciate the fresh fruit flavours of the wine</li><li>Invigorating and refreshing</li><li>Fresh oysters, seafood salads, smoked salmon and sushi and other raw fish dishes</li></ul> <p></p>
2608 <ul><li>Pale straw with a green hue</li><li>Aromas of yellow citrus, stone fruit, orange blossom and a hint of sweet oak</li><li>An elegant, well-balanced wine that fills the mouth with sweet fruit, orange zest, leading to a fresh finish</li><li>Serve with Chinese-style deep-fried pork, macaroni and cheese, nut-crusted chicken, prawns served with cashews and selection of button, shiitake and oyster mushrooms fried with butter, garlic and onion</li></ul> <p></p>
2609 <ul><li>The unique character of this wine lies in the influence of the different vineyards from which the grapes were sourced</li><li>The grapes were selected from various low yield vineyards, established between 1985 and 1990 and planted in deep, dark red soils at around 250 m above sea level</li></ul>
2610 <ul><li>This medium bodied<b> </b>wine evokes a sweet sensation on the palate with hints of dark cherries and plums</li><li>It is well balanced with silky tannins and lingering flavors of sweet wood spice</li><li>Serve with a variety of Mexican foods, North African and mildly hot Asian dishes</li></ul>
2611 <ul><li>A Brilliant lime green colour </li><li>Delightful combination of citrus, paw-paw, asparagus, ripe figs and watermelon</li><li>Medium-bodied wine with subtle citrus and tropical fruit on the palate ending with a long, lingering finish</li></ul>
2612 <ul><li>Hints of leather, with plums and prunes in combination with sweet, ripe reds fruit, black pepper and oriental spice</li><li>Concentration of ripe plum and rich red fruit with hints of black pepper and sweet spice</li><li>Soft and elegant tannins on the palate with a mouth-watering finish</li></ul>
2763 <ul><li>This crisp, mouthwatering Chardonnay displays lively flavours of green apple, citrus and pineapple on a full, creamy palate Hints of orange blossom and subtle toasty notes round out this versatile and accessible everyday value</li></ul>
2788 <ul><li>Light, undemanding, dry sparkler, grassy, gooseberry and tropical flavours, crisp, clean finish</li><li>Excellent as an aperitif, however perfect with oysters, shellfish and salads</li></ul>
11135 <ul><li>This wine, made by cellar master Louis Strydom, is Ernie Els' vision to produce excellence, reflecting their respective commitment to quality</li><li>The Big Easy White 2012 offers an amazing array of tropical fruits, showing the complexity the Cape has to offer</li><li>This wine is crafted in an easy-drinking, unwooded style</li></ul>
11606 <ul><li>Energade is a concentrated energy sports drink </li><li>Grape flavour</li><li>1 x Case = 24 500ml bottles</li></ul> <p></p>
11607 <p><b>Energade Concentrated Sports Drink Naartjie</b></p>
11608 <ul><li>Energade is a concentrated energy sports drink </li><li>Tropical flavour</li><li>1 x Case = 24 500ml bottles</li></ul> <p></p> <p></p>
11610 <ul><li>Energade is a concentrated energy sports drink </li><li>Blueberry flavour</li><li>1 x Case = 24 500ml bottles</li></ul> <p></p>
11818 <ul><li>Energade is a concentrated energy sports drink </li><li>Mixed Berry flavour</li><li>1 x Case = 24 500ml bottles</li></ul> <p></p> <p></p>
12654 ESPRIT CIDER CAN MANGO&CHILLI 6 x 440ML
12677 <p>ESPRIT CIDER CAN MANGO&CHILLI 24 x 440ML</p>
12754 <p>EL JIMADOR TEQUILA DOUBLE SHOT GLASS 1 x 750ML (EA)</p>
12977
14076 <p>Enjoy a refreshing boost during your busy day when you keep this 6-pack close at hand. It features the great tasting flavours of lemon, lime and ginger, without any added sugar.</p>
14077 <p>Enjoy a refreshing boost during your busy day when you keep this 6-pack close at hand. It features the great tasting flavours of lemon, lime and ginger, without any added sugar.</p>
15385