Sandbox

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 (
    2237, 11920, 2184, 2231, 2288, 2346, 
    2348, 2345, 2344, 2350, 2250, 2223, 
    13349, 2355, 2204, 2273, 2278, 2275, 
    2276, 2277, 2272, 2274, 4359, 2326, 
    2251, 2293, 2294, 2295, 2247, 2248
  ) 
  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": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 30,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (2237,11920,2184,2231,2288,2346,2348,2345,2344,2350,2250,2223,13349,2355,2204,2273,2278,2275,2276,2277,2272,2274,4359,2326,2251,2293,2294,2295,2247,2248)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description
2184		<ul><li>Black and White is smooth, light, fresh and spciy with smokey hints</li><li>It is pale gold in colour with sweet aromas of oak, biscuits with notes of sharp grain alcohol, and a touch of peat</li><li>A short finish with notes of vanilla, honey and oak</li><li>200ml bottle </li></ul> <p></p>
2204		<ul><li>Grain whiskey reserved for Bushmills Original is slowly matured for a minimum of five years in American oak casks before blending with Irish Single Malt to produce this popular whiskey</li></ul>
2223		<ul><li>Bombay Sapphire is a London Dry gin,<b> </b>but that's not a regional designation (like Bordeaux or Scotch whisky)</li><li>It's a style specifically, a dry style of gin that doesn't use any artificial ingredients</li><li>Instead, distillers balance piney juniper notes with a dealer's choice of botanicals and spices</li></ul>
2231		<ul><li>The Black Douglas Scotch whisky was named after Sir James Douglas,<b> </b>a Scottish knight who fought in the Scottish Wars of Independence</li><li>A well-balanced grain and malt blend Scotch whiskey</li><li>The Black Douglas is a soft, well-aged product with a smooth finish</li></ul>
2237		<ul><li>Luxury vodka from the homeland of vodka, Poland</li><li>Belvedere rails from Poland, the homeland of vodka named after the Belvedere palace</li><li>Belvedere Vodka has notes of vanilla and rye on the palate, the finish is crisp and clean with lingering white pepper spice</li><li>It has a distinctive creamy mouth feel</li><li>Its aromas is a blend of vanilla, rye and white pepper</li></ul> <p><br /></p>
2247		<ul><li>Made with molasses, water, mash and yeast, Captain Morgan Original Spiced rum is distilled in a continuous still</li><li>Once distilled, the clear spirit is aged in oak barrels for up to a year, adding a golden colour and character to the rum before the flavours and spices are added</li></ul>
2248		<ul><li>Take a sip and lift it to your nose, just the way the Captain did when he first created his sumptuous spiced spirit drink</li><li>You'll taste notes of rich vanilla, brown sugar, warming spices with just the hint of oak</li><li>They all combine for balance, a smooth finish and the perfect drink for buccaneers and landlubbers alike</li></ul>
2250		<p><br /></p> <ul><li>Bols Brandy is triple-distilled from long fermented corn, rye and wheat with juniper berries </li><li>A personal blend from our Master Distiller</li><li>100% Malt Spirit </li></ul>
2251		<ul><li>Cape to Rio is a pure cane spirit produced from the fermentation and distillation of molasses</li><li>It is produced at the Glendale Distillery in Durban, South Africa and is triple distilled for unrivaled smoothness and purity</li></ul>
2272		<ul><li>Butlers Triple Sec is an Orange flavoured liqueur made from dried peels of bitter and sweet oranges </li><li>The peels are soaked in distilled water then steeped in a spirit before the distillation process</li><li>This clear coloured liqueur is best served with the Cosmopolitan Cocktail or the Long Island Iced Tea Cocktail</li></ul>
2273		<ul><li>Butlers Blue Curacao Liqueur blue Curacao is a sweet blue liqueur, distilled and flavored from the dried peel of bitter oranges</li><li> It can also contain distillates of lemons and curacao fruit, sugar and wine</li></ul>
2274		<ul><li>A unique tangerine flavoured liqueur,Van Der Hum is produced in the Cape winelands of South Africa</li><li>A blend of five year old potstill brandy, wine distillate, tangerine peel, herbs and spices</li><li>The extracts are sweetened with glucose and cane sugar syrup</li><li>KWV Van Der Hum Liqueur is a deep golden amber</li></ul>
2275		<ul><li>The appearance is seductively golden</li><li>On the nose an instantly warming aroma of ginger, zesty lemon, sherbet and golden syrup leads to an initial sweetness on the palate that is followed by bite of ginger and lemon notes</li><li>The mouth feel is deliciously satisfying and warming and the finish is lingering</li></ul>
2276		<ul><li>Nothing epitomises freshness as much as peppermint does</li><li>Cool and sweet, invigorate yourself by adding this liqueur to your Springbokkie, Choc Mint Martini and, of course, Grasshopper</li></ul>
2277		<ul><li>Sweet and seductive, the juicy strawberry flavour infused with rum and decorated with crushed ice, makes other daiquiris seem rather inadequate</li><li>Cultivated strawberries are macerated, distilled and sweetened</li><li>This strawberry liqueur has a bright red colour</li><li>Used in fruit daiquiris and margaritas</li></ul>
2278		<ul><li>Butlers Creme de Banana Ligueur is a wonderfully fruity spirit with strong, freshly peeled <b>banana</b> flavours and aromas that will make any cocktail tropical</li></ul>
2288		<ul><li>Black Moon Caramel Liqueur is a decadent blend of premium vodka and deliciously rich caramel flavours which gives it its distinctive taste</li><li>Black Moon has a golden honey colour and a deliciously smooth, unforgettable taste of caramel</li></ul>
2293		<ul><li>Cape Town Classic Dry Gin pays homage to the first Gins made in Holland and England over 150 years ago, when Juniper berries were the predominant flavour</li><li>This Dry Gin is a well-made, carefully balanced spirit with rich botanicals dominated by Juniper, punchy citrus notes and a hint of herbs and wild flowers</li></ul>
2294		<ul><li>The Cape Town Gin & Spirits Co. have created this gin with a particular flavour that South Africa is known for in mind - that of Rooibos</li><li>They combine handpicked Rooibos with juniper,orange peel and cinamon to create a rich, aromatic flavour profile</li></ul>
2295		<ul><li>Originally built in 1890, its light salmon pink colour has made this hotel an icon in Cape Town for over 100 years</li><li>The Pink Lady Gin is a delightful Gin, infused with hibiscus flowers and rose petals, and a heavenly hint of Rose water</li><li>Fresh floral aromas on the nose, with rose and Turkish delight on the palate</li></ul>
2326		<ul><li>Campari is a popular bitter Italian aperitif </li><li>The brilliantly red-colored spirit is made of a proprietary blend of herbs and spices</li><li>It has a very strong bitter flavor highlighted by orange that is an acquired taste, but an enlightening one</li></ul>
2344		<ul><li>Clear BOLS Triple Sec is a crystal clear liqueur flavoured with Curaçao,orange peel and hints of citrus </li><li>Bols Triple Sec is without a doubt the most essential liqueur in a modern bar</li><li>At least half of all classic and modern drinks are made with Triple Sec or a variant, like Dry Orange Curaçao</li></ul>
2345		<ul><li>Bols Crème de Menthe Peppermint liqueur is widely used as a digestive liqueur </li><li>Can be enjoyed straight, on the rocks and added to cocktails</li></ul>
2346		<ul><li>Banana liqueurs (crème de banane)</li><li>Bols Banana is based on a rum distillate rather than neutral spirit</li><li>Provides extra character and is flavoured with banana extract enhancing by a touch of vanilla and a hint of almonds </li></ul> <p><span class="hgKElc"><b></b></span></p> <p></p>
2348		<ul><li>Bols Elderflower Liqueur is flavoured with the <b>cream coloured, honey scented blossoms</b> of the elder tree, also called the sambucus nigra</li><li>Bols soaks dried elderflower blossoms in a water/alcohol mixture with a secret water/alcohol ratio in order to extract the optimum flavour</li></ul>
2350		<ul><li>Bols Zeer Oude Genever has a rich palate full of grainy, fruity notes and hints of juniper berry</li><li>It is made from a rye, corn and wheat distillate</li></ul>
2355		<p>BULLDOG 750ML GIN 1 x 750ML (EA)</p>
4359		<ul><li>The usual tequila aroma blends seductively with the punchy and vibrant sours</li><li>Notes of agave blend seamlessly into the distinct and powerful sour notes</li><li>A smooth and memorable finish that will have you coming back for more</li></ul>
11920		<ul><li>Black and White is smooth, light, fresh and spciy with smokey hints</li><li>It is pale gold in colour with sweet aromas of oak, biscuits with notes of sharp grain alcohol, and a touch of peat</li><li>A short finish with notes of vanilla, honey and oak</li></ul>
13349		<blockquote>ESTABLISHED IN BOTSWANA, BORO BRANDY DRAWS ITS CHARACTERISTICS FROM THE FAMOUS DELTA RIVER. JUST LIKE THE RIVER CONNECTS AND GIVES LIFE TO COMMUNITIES, BORO BRANDY IS BEST KNOWN FOR BRINGING PEOPLE FROM ALL PATHS OF LIFE TOGETHER TO ENJOY A FAMILIAR DRINK. SERVED TO YOUR PREFERENCE. BORO BRANDY DISPLAYS TREMENDOUS AROMATIC COMPLEXITY WHICH IS COMPLEMENTED WITHERED SOFT MOUTHFEEL.</blockquote>