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 (
    12664, 12667, 12666, 12751, 2641, 2642, 
    2635, 2636, 12691, 12690, 12692, 2199, 
    2200, 2237, 12678, 3238, 3237, 12656, 
    13107, 12672, 12671, 11136, 2772, 11808
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00035

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 (12664,12667,12666,12751,2641,2642,2635,2636,12691,12690,12692,2199,2200,2237,12678,3238,3237,12656,13107,12672,12671,11136,2772,11808)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description
2199		<ul><li>Bell's Extra Special Whisky combines 35 of the most iconic grain and malt whiskies from the Highlands, Islands and Lowlands of Scotland</li><li>Bell's has a slightly sweet, nutty and characteristically spicy taste</li><li>Soft grainy, with nuances of heather and moss with a spicy complex nose</li><li>1 L bottle </li></ul>
2200		<ul><li>Bell's Extra Special Whisky combines 35 of the most iconic grain and malt whiskies from the Highlands, Islands and Lowlands of Scotland</li><li>Bell's has a slightly sweet, nutty and characteristically spicy taste</li><li>Soft grainy, with nuances of heather and moss with a spicy complex nose</li><li>750 ml bottle </li></ul> <p></p>
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>
2635		<ul><li>This Shiraz has a deep ruby colour with plums, blackberry and pepper spice persisting from entry to finish</li><li>Nestled between the slopes of the Groot Drakenstein mountains in the Franschhoek Valley, lies the Bellingham Homestead</li><li>On the palate, it boasts with blackberry fruits, violets and black pepper</li></ul>
2636		<ul><li>Bellingham Pear Tree White is a brilliant pale straw in colour with green and gold sparkles</li><li>On the nose bursting with aromas of tropical honey melon, passion fruit and pineapple with zesty orange blossom and yellow peach shining through both on the palate and nose</li></ul>
2641		<ul><li>This lightly oaked wine is made from Coastal Stellenbosch Region grapes farmed for premium quality</li><li>This Chardonnay has a rich <b>yellow</b> with a copper glow with delightful Butterscotch, spicy cloves and orange peel aromas</li><li>Layers of citrus and melon lines the palate finishing with a citrus-lime freshness</li></ul>
2642		<ul><li>Ripe red fruit, sweet spices and soft tannins are hallmarks of this wine</li><li>Nestled between the slopes of the Groot Drakenstein mountains in the Franschhoek Valley, lies the Bellingham Homestead</li><li>An intense dark red middle with a ruby red rim plotting sweet spices, plums and mulberries with hints of vanilla on the nose</li></ul>
2772		<ul><li>A wine made to enjoy, to drink at any occasion</li><li>Average yield</li><li>Quality of the wines so far looks extremely good with rich dark colours and brilliant fruit on all the red cultivars</li></ul> <p></p>
3237		<ul><li>Sweet, delicate grape notes with a hint of honey reminiscent of a wine-like Muscat taste</li><li>Rich and golden in colour, Bernini Classic has a 4.5% alcohol by volume</li><li>Best enjoyed cold </li></ul>
3238		<ul><li>Sweet, floral grape notes with hints of tropical fruits and berries</li><li>Vibrant blush in colour, Bernini Blush has a 4.5% alcohol by volume</li><li>A sweet floral grape note with a hint of berry and tropical notes</li></ul>
11136		<ul><li>The Beyerskloof Chenin Blanc Pinotage is widely recognized as the 'white Pinotage' </li><li>Exciting and fruity, this wine showcases the versatility of Pinotage</li><li>When blended with Chenin Blanc the result is a unique tasting, refreshing white wine</li><li>A light colour with a fresh green and golden tint</li></ul>
11808		<ul><li>A <b>dry white blend of Chenin Blanc and Pinotage</b> which is best known as the 'White Pinotage'</li><li>This wine showcases the versatility of Pinotage, when blended with Chenin Blanc, resulting in a unique, social-sipping wine</li><li> Enjoyable as a crips summer drink on its own or a perfect companion of light summer dishes and seafood</li></ul>
12656		<p>BERNINI CIDER CAN BLUSH 6 x 440ML</p>
12664		BELGRAVIA GIN PINK TONIC 6 x 275ML
12666		BELGRAVIA GIN TONIC 6 x 275ML
12667		<p>BELGRAVIA GIN TONIC 24 x 275ML</p>
12671		BERNINI CIDER NRB CLASSIC GRAPE 24 x 275ML
12672		<p>BERNINI CIDER NRB BLUSH 24 x 275ML</p>
12678		<p>BERNINI CIDER CAN BLUSH 24 x 440ML</p>
12690		BELLINGHAM WINE HOMESTEAD LIGHT SAU BLANC 1 x 750ML (EA)
12691		<p>BELLINGHAM HOMESTEAD LIGHT PINOTAGE 1 x 750ML (EA)</p>
12692		BELLINGHAM WINE HOMESTEAD RED BLEND 1 x 750ML (EA)
12751		<p>BELGRAVIA GIN PINK 1 x 750ML (1s)</p>
13107