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 (
    2172, 2175, 2170, 2166, 2173, 2174, 12742, 
    2600, 2597, 2598, 2357, 2807, 12976, 
    2305, 2304, 11806, 12740, 11117, 11787, 
    2587, 2588, 2591, 2590, 2553, 2589, 
    2581, 2592, 2576, 2685, 2686
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00092

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 (2172,2175,2170,2166,2173,2174,12742,2600,2597,2598,2357,2807,12976,2305,2304,11806,12740,11117,11787,2587,2588,2591,2590,2553,2589,2581,2592,2576,2685,2686)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description
2166		<ul><li>Monin Strawberry Purée adds <b>sweet, juicy strawberry flavor and texture to cocktails, lemonades, iced teas and smoothies</b></li><li> Sugar, Water, Strawberry Puree Concentrate, Natural Flavors, Vegetable Juice Concentrate (Colour), Pectin, Beta Carotene (Color), Citric Acid</li></ul>
2170		<ul><li><b>Rich and sweet, soft and succulent</b>, the blackberry likes to show off, with a deep purple hue and a complex taste of tart sweetness</li><li>Our Blackberry Syrup lets you bring its intriguing profile to refreshing cocktails, iced teas, lemonades and more</li></ul>
2172		<ul><li><b>Slightly acidulous peach taste and sweet, soft and long lasting aftertaste</b></li><li>Each year, the summer season signals the arrival of juicy, sweet peaches</li><li>But infusing your recipes with the sweet, unmistakable flavour and rich golden colour of peaches does not have to end when the long days of summer fade</li></ul>
2173		<ul><li>MONIN's virgin range of flavours, Triple Sec Curaçao syrup is <b>the non-alcoholic version of the famous bittersweet orange liqueur</b></li><li>Made from dried peels of bitter and sweet orange, Triple sec is an orange-flavoured liqueur, which was originally made in France in the mid-nineteenth century</li></ul>
2174		<ul><li>With Monin Mojito Mix, mojitos have never been easier; just <b>combine with rum, club soda and a squeeze of lime</b></li><li>Made with select ingredients and pure cane sugar</li><li>Monin Mojito Mix is a highly concentrated, authentic flavoring offering exceptional versatility for creating specialty beverages</li></ul>
2175		<ul><li>One of the top three speciality coffee flavours, along with vanilla and caramel, Monin Hazelnut syrup delivers the <b>fresh taste and aroma of hazelnut with a touch of almond and vanilla</b></li></ul>
2304		<ul><li>Musgrave 11 Premium is no ordinary gin and its <b>top notes of aromatic Cardamom, African Ginger</b> (Whitei Mondei) and Grains of Paradise are reminiscent of the perfume of spice markets</li><li>The woody character gives way to cloves, cinnamon and a faint hint of cardamom and leaves you with a gentle flame</li></ul>
2305		<ul><li>Musgrave Gin is <b>born out of the flavours and history of Africa and its ancient spice route</b></li><li>Musgrave Premium is no ordinary gin and its top notes of aromatic Cardamom, African Ginger (Whitei Mondei) and Grains of Paradise are reminiscent of the perfume of spice markets</li></ul>
2357		<ul><li>Mount Gay is like <b>a single malt within rum</b>, made completely in Barbados from fermentation to bottling</li><li>Only the best sugarcane from Barbados and the Caribbean and follow open&dash;air fermentation in wooden casks using coral&dash;filtered water from our own original well and proprietary yeasts for aromatic richness</li></ul>
2553		<ul><li>Colour Bright red</li><li>Bouquet Rounded, <b>svelte red fruit aromas with black cherries, chocolate and a hint spice</b></li><li>Flavours of cocoa and black cherry, with creamy texture and a hint of exotic masala spice and peppercorn</li></ul>
2576		<ul><li>Made <b>from Chenin Blanc and Sauvignon Blanc grapes</b>, this fresh and fruity non-vintage sparkling wine was left on the lees (residual yeast) for almost two months prior to final blending</li><li>Strikingly clear with a vivid sparkle</li><li>Subtle pear and floral fragrances</li></ul>
2581		<ul><li>Pale straw colour with a <b>lifted nutty and herbal aromas with spicy and citrus notes</b></li><li>Also flavours of nuts, herbs and citrus fruit, well balanced with a fresh, clean finish</li></ul> <p><br /></p>
2587		<ul><li>Baronne is a <b>full-bodied wine with ripe juicy flavours, soft tannins, and light oaking</b> that is smooth, elegant, and self-assured With blueberry, cassis, a twist of pepper, and cinnamon, this wine is juicy, smooth, and velvety in the mouth</li></ul>
2588		<ul><li>Ruby red a<b>romas of sweet red and dark fruits</b>, with subtle hints of spice and well-integrated oak</li><li>A full-bodied wine with ripe fruit, blackcurrant and intricate oak flavour, supple tannins and a lingering aftertaste</li></ul>
2589		<ul><li>The Nederburg Pinotage is <b>vibrant red with aromas of plums and prunes and some subtle oak spice</b></li><li>A full mouthfeel with rich fruit flavours, soft tannins and a lingering aftertaste</li></ul>
2590		<ul><li>Brilliant with green tinges and aromas of passion fruit and jasmine with hints of melon and lime</li><li>Off-dry, crisp with a lovely follow-through of fruit aromas on the pallet.</li><li>Delicious with seafood, light meals and salads</li></ul> <p></p>
2591		<ul><li>Nederburg Winemasters Chardonnay is a <b>light straw-yellow with tints of green and gold</b></li><li>The nose has aromas of lime and dried apricot with vanilla oak notes in the background</li><li>The palate is crisp and fresh with a creamy texture and subtle citrus and apricot flavours leading to a an elegant finish</li></ul>
2592		<ul><li>Deep violet-ruby colour with <b>floral, smoky, prune, black olive and spice aromas</b></li><li>Medium-to-full bodied with rich dark berry flavours and a long finish<strong></strong></li></ul>
2597		<ul><li>This medium cream <b>fortified wine</b> is silky smooth with hints of sweetness and a nutty character</li><li>Long, silky flow across the palate with rich rather than sweet fine raisins, citrus and Christmas pudding flavours ending in a long finish</li></ul>
2598		<ul><li>This pale dry sherry is aromatic and crisp with a refreshingly dry character</li><li>The flavours are diverse yet well balanced and on the nose the complex combination of salt and citrus lead to ripe pear and nuts. On the palate the sherry is clean with mineral notes, a dry lime flavour and cashew nuts that end in a rich, nutty and long, dry finish</li><li>Served slightly chilled it makes a fine aperitif but is also the ideal accompaniment to spicy prawns, veal escallops, macadamia-crusted line fish or a mezze platter consisting of Parma ham, thinly sliced ostrich biltong, nuts and strong flavourful cheeses</li></ul> <p></p>
2600		<ul><li>Dark brown in colour, this full cream sherry holds <b>sweet vanilla flavours with nuts and honey</b></li><li>Rich toffee and brown sugar aromatics with hints of barley sugar, spice and honey comes to the fore with a beautifully balanced and delicate character</li><li>Serve chilled before or after dinner</li></ul>
2685		<ul><li><b>Elegant red fruit carrying through on the palate with hints of coffee and nougat</b></li><li>A slight refreshing mint influence. Medium-bodied with soft tannins providing just enough structure</li></ul>
2686		<ul><li>A medium-bodied structure with classic cabernet-fruit characteristics of blackberries</li><li>Slight herbaceousness and soft tannins make this wine extremely elegant and easy to enjoy</li><li>The peppery character follows through from the nose onto the palate</li><li>The finish lingers on</li></ul>
2807		<ul><li><b>Ripe tropical aromas of mango, pineapple and papaya</b> are lifted by a crisp, refreshing apple note</li><li>The palate is defined by a delicious fine mineral texture leading onto a succulent mid-palate</li><li>The final impression is one of a full flavoured, yet precisely poised Chenin Blanc</li></ul>
11117		<ul><li>Ruby red</li><li>Aromas of sweet red and dark fruits, with subtle hints of spice and well-integrated oak</li><li>A full-bodied wine with ripe fruit, blackcurrant and intricate oak flavour, supple tannins and a lingering aftertaste</li></ul>
11787		<ul><li>This wine is made entirely from Chenin Blanc</li><li>Reminiscent of ripe fruits, especially apricots and oranges with floral hints and traces of raisin and spice</li><li>Well-balanced, fresh and fruity with a beautiful minerality and an excellent structure</li></ul><p></p>
11806		<ul><li>A <b>crisp dry, refreshingly white wine with guava fruitiness on the nose</b></li></ul>
12740		<p>NDLOVU GIN ORGINAL 1 x 750ML (EA)</p>
12742		<ul><li>Once upon a time tropical explorers enjoyed the tangy sweetness of this island fruit</li><li>Our Pineapple Syrup can be served up in an ice-cold concoction or in a frozen blend that will whisk you away</li></ul>
12976		<p>Perfectly balanced with lingering focus and<br />acidity, the mid palate plays with classic cassis<br />and thyme flavours. Very much a wine for all<br />occasions.</p>