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 (
    4340, 2364, 13765, 13826, 13993, 2218, 
    2349, 2178, 2177, 11786, 2827, 2640, 
    2312, 2309, 2310, 2311, 3236, 4344, 
    3221, 3225, 3218, 3246, 3222, 4347, 
    3242, 12675, 11361, 12647, 12880, 12670
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00059

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": 30,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4340,2364,13765,13826,13993,2218,2349,2178,2177,11786,2827,2640,2312,2309,2310,2311,3236,4344,3221,3225,3218,3246,3222,4347,3242,12675,11361,12647,12880,12670)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2177 <ul><li>Overall, a classic brandy taste, with a <b>sweet fruitiness similar to burnt wine mellowed by a pleasant oakiness</b></li><li>You'll find floral and fruit (particularly citrus) notes in these cognacs, and hints of spice, vanilla, and chocolate are common</li><li>Hennessy V.S.O.P Privilège is a well balanced cognac, the expression of 200 years of Hennessy craft. The fruit of nature’s uncertainties, this unique blend has tamed the elements to embody the original concept of cognac. Each sip reveals new facets of its personality</li></ul>
2178 <ul><li>Overall, a classic brandy taste, with a <b>sweet fruitiness similar to burnt wine mellowed by a pleasant oakiness</b></li><li>You'll find floral and fruit (particularly citrus) notes in these cognacs, and hints of spice, vanilla, and chocolate are common</li></ul>
2218 <ul><li>Huge, intense nose with an initial burst of crisp zesty botanicals harmoniously <b>balanced juniper and coriander</b> and a deep, surprisingly floral aroma of violets and rose</li><li>Palate: Smooth and superbly balanced botanicals</li><li>Clean and dry without being in any way astringent</li></ul>
2309 <ul><li>Made using the London Dry one-shot method, this gin is <b>distilled using a grain spirit with carefully selected botanicals including citrus, lemon verbena and – of course – juniper</b></li><li>It is a South African take on a classic gin, with hints of citrus which complement rosemary and juniper</li></ul>
2310 <ul><li>It truly is a <b>savoury gin</b>, if you love olives, serve it “dirty” in a gin and tonic with a green olive and a dash of brine</li><li>Or else serve in a gin and tonic with a slice of orange, sprig of basil or an olive and rosemary</li></ul>
2311 <p>HOPE ON HOPKINS 750ML GIN SALT RIVER 1 x 750ML (1s)</p>
2312 <ul><li>Designed to be sipped, the Esperanza from Hope is a <b>smooth agave spirit</b></li><li>With a floral nose and butterscotch notes, it has rich caramel and spice on the palate and a soft vanilla finish</li></ul>
2349 <ul><li>Henkes Gin gets its <b>distinct flavour from a mix of juniper berries and coriander seeds</b>, which is rounded off with a touch of citrus from orange peels</li><li>Henkes Gin gets its distinct flavour from a mix of juniper berries and coriander seeds, which is rounded off with a touch of citrus from orange peels</li></ul>
2364 <ul><li>HEINEKEN 330ML BEER NRB 24 x 330ML</li></ul>
2640 <ul><li>Full-bodied wine with powerful varietal flavours of bell pepper, green apple and freshly cut grass</li><li>Good structure with lovely balancing acidity</li></ul>
2827 <ul><li>Sauvignon Blanc is <b>a white wine grape variety</b> that is most often used to produce dry white wines</li><li>Light and refreshing, its unique in that its flavor sets it apart from most other white wine grape varieties</li><li>Sauvignon Blanc tasting notes are most commonly associated with tropical, tree and citrus fruit</li></ul>
3218 <ul><li>Hunter's Extreme is a refreshing, apple ale with a natural energy kick from guarana and taurine</li><li>Rose gold colour, a refreshing, apple ale with added Guarana, taurine and caffeine</li><li>24 x 275 ml bottles </li></ul> <p></p>
3221 <ul><li>Distinctive crisp apple flavour, Hunters Dry, refreshes like nothing on earth</li><li>Hunters Dry is synonymous with family, friends and good times</li><li>It's a premium, pure, <b>thirst quenching natural cider</b> that consistently delivers the ultimate refreshment</li><li>A burst of refreshing, real, natural cider</li></ul>
3222 <ul><li>Hunter's Gold is an <b>all-natural apple cider</b> with a distinctively crisp taste</li><li>It is refreshingly sweet, balanced with the full-flavoured taste of fine apples</li><li>Hunter's Gold is best served chilled to enjoy its sparkling refreshment</li></ul> <p></p> <p></p>
3225 <ul><li>Distinctive crisp apple flavour, Hunters Dry, refreshes like nothing on earth</li><li>Hunters Dry is synonymous with family, friends and good times</li><li>It's a premium, pure, <b>thirst quenching natural cider</b> that consistently delivers the ultimate refreshment</li><li>A burst of refreshing, real, natural cider</li></ul> <p></p>
3236 <ul><li>HUNTERS HARD LEMON NRB 6 x 330ML</li></ul>
3242 <ul><li>Hunter's Gold is an <b>all-natural apple cider</b> with a distinctively crisp taste</li><li>It is refreshingly sweet, balanced with the full-flavoured taste of fine apples</li><li>Hunter's Gold is best served chilled to enjoy its sparkling refreshment</li></ul> <p></p>
3246 <ul><li>Hunter's Extreme is a refreshing, apple ale with a natural energy kick from guarana and taurine</li><li>Rose gold colour, a refreshing, apple ale with added Guarana, taurine and caffeine</li><li>6 x 250 ml cans </li></ul>
4340 <p>HEINEKEN 440ML BEER CAN 24 x 440ML</p>
4344 <ul><li>Hunters Hard Lemon is <b>a hard cider with an extra zesty twist</b></li><li>It has a bright golden yellow colour, and offers a mild sweetness on the palate, with an added dash of lemon to quench any thirst</li><li>Hunters Hard Lemon is a hard cider with an extra zesty twist</li></ul>
4347 <ul><li>Hunter's Gold is an <b>all-natural apple cider</b> with a distinctively crisp taste</li><li>It is refreshingly sweet, balanced with the full-flavoured taste of fine apples</li><li>Hunter's Gold is best served chilled to enjoy its sparkling refreshment</li></ul>
11361 <ul><li>Distinctive crisp apple flavour, Hunters Dry, refreshes like nothing on earth</li><li>Hunters Dry is synonymous with family, friends and good times</li><li>It's&nbsp; a premium, pure,&nbsp;<b>thirst quenching natural cider</b>&nbsp;that consistently delivers the ultimate refreshment</li><li>A burst of refreshing, real, natural cider</li></ul>
11786 <ul><li>Vibrant and fresh, this Sauvignon Blanc strikes a beautiful balance between the <b>tropical and herbaceous styles</b>, resulting in a quaffable yet complex wine</li><li>Fresh and vibrant with hints of green apple, guava and nettles with sweet melon in the background</li><li>Simultaneously herbaceous and tropical</li></ul>
12647 <p>HUNTERS EXTREME EXTREME NRB 6 x 275ML</p>
12670 ICE TROPEZ 275ML FRENCH ROSE WINE BASED C\TAIL 0% 6 x 275ML
12675 <p>HUNTERS CIDER CAN GOLD 24 x 330ML</p>
12880
13765
13826
13993