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 (
    12748, 15130, 2282, 2723, 15152, 15153, 
    2725, 2728, 2732, 2729, 2722, 15126, 
    2828, 2714, 2715, 2716, 2717, 2713, 
    2623, 2622, 15128, 2724, 2726, 2727, 
    2730, 15151, 15150, 15423, 3216, 2718
  ) 
  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": 30,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (12748,15130,2282,2723,15152,15153,2725,2728,2732,2729,2722,15126,2828,2714,2715,2716,2717,2713,2623,2622,15128,2724,2726,2727,2730,15151,15150,15423,3216,2718) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2282 <ul><li>This full sweet sherry wine have orange zest, dried fruit, floral aromas, honey and red bush tea flavours on the nose</li><li>The fruit is complimented by marzipan and caramel on the soft, juicy palate with a lingering, nutty persistence</li><li>1 year in 500L barrels and 5 - 6 years in 1800L barrels in the Solera system</li></ul>
2622 <ul><li>With its natural acidity and acute texture, the La Motte Sauvignon Blanc pairs beautifully with seafood, light pastas and spicy Chinese and Thai dishes</li><li>This white wine also goes extremely well with acute seasonings, and salty eats such as pre-dinner canapés</li><li>On its own, a refreshing aperitif white wine</li></ul>
2623 <ul><li>A dusty,&nbsp;<b>earthy nose</b>&nbsp;with raspberry and mulberry fruit, cinnamon spice and a hint of mint, promising a complex wine</li><li>The first touch on the palate is velvety and juicy</li><li>The mid-palate is firm, but medium-bodied and the finish mineral-dry and lingering</li></ul>
2713 <ul><li><b>Bright pale yellow colour</b> in the glass with a fresh melon, grapefruit and gooseberries on the nose</li><li>The palate is well- balanced with minerality and a fresh citrus finish</li></ul>
2714 <ul><li>Pale green colour</li><li>Mango and white pear on the nose</li><li>Light to medium body with tropical fruit flavours and a crisp finish</li></ul>
2715 <ul><li>This is the easy going, smooth jazz singer of wines</li><li>Bringing soft, <b>ripe redcurrant fruits aromas</b> and a smooth and integrated plum palate to the fore</li></ul>
2716 <ul><li>Pale yellow-green in colour, with fresh lime, pineapple and floral notes</li><li>Light and zesty on the palate with flavours of green apple</li></ul>
2717 <ul><li><b>Soft tannins and refreshing acidity</b>, with maraschino cherries red fruit enrobing the nose</li><li>Translucent <b>red</b> colour. Strawberry, cherry on the nose with rich <b>red</b> fruits and spice aromas enticing the palate</li></ul> <p><br /></p>
2718 <ul><li><b>Full bodied wine with dark berry flavours and touches of cedar and spice</b></li><li>Subtle and soft tannins with lovely oak flavours</li><li>An ideal accompaniment to matured red meats, venison and cheeses</li></ul>
2722 <ul><li>The KWV Classic Collection Cape Ruby Port is a <b>rich and flavourful dessert wine</b> with beautiful ripe berry flavours</li><li>This Ruby Port has beautiful dark berry flavours which are complemented by caramel, butterscotch and nuttiness</li><li>The wine is well balanced, fresh and fruitful with a lingering finish</li></ul>
2723 <ul><li>KWV WINE SHERRY MED CRM 1 x 750ML (1S)</li></ul>
2724 <ul><li>This lively and fresh Chenin blanc shows prominent aromas of <b>green apple, tropical fruit and litchi</b> with underlying hints of oak and almonds</li><li>On the palate, the wine is concentrated and round with nuances of kumquat and guava</li><li>Its linear acidity enhances the wine's freshness and enduring nish</li></ul>
2725 <ul><li>A classic red wine that is <b>soft, fresh and vibrant with blackberry and red berry aromas</b></li><li>This generous and vibrant <b>Merlot</b> shows prominent aromas of ripe plum and sour cherry with nuances of black pepper and cedary oak</li></ul> <p><br /></p>
2726 <ul><li>This generous and vibrant Merlot shows prominent <b>aromas of strawberry, sour cherry and pomegranate with nuances of herbs and cedary oak</b></li><li>The palate is accessible with indulgent tannins and a seamless finish</li><li>Enjoy this wine on its own or with tomato-based pastas, roasted duck, chicken or grilled steak</li></ul>
2727 <ul><li>This layered Sauvignon blanc shows prominent <b>aromas of green fig, guava and flint</b>, with hints of asparagus and green apple</li><li> The fresh and lively palate is well balanced with a linear acidity and a fruity finish</li><li>Sauvignon Blanc is best enjoyed when it is chilled</li></ul>
2728 <ul><li>This rich and flavourful <b>Pinotage</b> shows true varietal characteristics with aromas of black currant, strawberries and wild berries</li><li>It also has hints of plum, banana and fruitcake aromas</li></ul>
2729 <ul><li>This vibrant Shiraz shows upfront <b>plum and blackcurrant aromas</b> with notes of violets, cloves and dried herbs</li><li>This S<b>hiraz</b> shows prominent fruit sweetness with aromas of mulberries, basil leaves and white pepper</li></ul>
2730 <p>LABORIE WINE MERLOT CABERNET SAUVIGNON 1 x 750ML (1S)</p>
2732 <ul><li>This vibrant, classically styled Sauvignon Blanc presents a brilliant <b>lemon-lime colour</b></li><li>The nose is complex with and array of tropical fruit, ripe figs and gooseberries</li><li>These crisp flavours repeat in the mouth, along with a mineral character followed by a long fruity finish</li></ul>
2828 <ul><li>Bright vivacious and crisply zesty in the mouth</li><li>Tangy lime and green apple crunch with a richer, deeper, biscuit and sourdough undertone</li><li>The zingy citrus and creamy lees flavours are well balanced with acidity and fruit in complete harmony</li><li>Poised and elegant with a lingering aftertaste</li></ul>
3216 <ul><li>Medium bodied <b>wine</b> with plum and <b>red</b> berry flavours</li><li><b>Wine</b> has well integrated and soft tannins</li><li>Hints of spice</li></ul>
12748 <ul><li>KWV 5 has been aged for at least five years to bring you back to your beginnings with its subtle fruity notes</li><li>It's great on its own or with a high-end mixer</li></ul>
15126
15128
15130
15150
15151
15152
15153
15423