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 (
    16150, 15902, 16716, 16813, 16812, 16849, 
    17017, 16845, 16932, 16888, 16889, 
    15798, 16861, 16862, 16943, 15835, 
    15836, 15839, 15834, 15837, 16881, 
    15844, 16929, 16938, 16937, 16152, 
    16153, 16947, 15912, 15913, 15797, 
    13030, 13029, 15832, 16801, 16798, 
    16800, 16946, 16827, 16826, 16871, 
    16858, 15845, 16345, 15910, 16941, 
    16940, 16939
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00120

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "33.61"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "index_condition": "((`dev_yourmart_co_bw`.`cscart_product_descriptions`.`product_id` in (16150,15902,16716,16813,16812,16849,17017,16845,16932,16888,16889,15798,16861,16862,16943,15835,15836,15839,15834,15837,16881,15844,16929,16938,16937,16152,16153,16947,15912,15913,15797,13030,13029,15832,16801,16798,16800,16946,16827,16826,16871,16858,15845,16345,15910,16941,16940,16939)) and (`dev_yourmart_co_bw`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "28.81",
        "eval_cost": "4.80",
        "prefix_cost": "33.61",
        "data_read_per_join": "183K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
13029 <p>Cadence Revive Chocolate 910g provides the ideal formulation to help prevent excessive muscle damage, fatigue and immune suppression. High intensity or resistance training can result in greater muscle tissue damage, requiring a higher concentration of protein to halt catabolism and accelerate muscle regeneration.</p>
13030 <p></p> <p>The Balanced Energy Bar is a great tasting, easily chewable energy bar for endurance training or as a snack.</p> <p>The all natural ingredients provide a lower glycemic index than our race bars and provide an energy source that can be used in low intensity training or as a snack between meals. </p> <p>Balanced Energy Bars are  free from artificial flavour-ants, colourants and preservatives. The Balanced Energy Bar is also Halal certified and contains no animal products.</p>
15797
15798
15832
15834
15835
15836
15837
15839
15844
15845
15902
15910
15912
15913
16150
16152
16153
16345
16716
16798 <p>This bittersweet chocolate couverture is excellent for enrobing cakes with a thick layer of chocolate, preparing dense chocolate fillings and ganache, and for piping chocolate decorations. These are round drops of chocolate, easy to melt or temper, weigh, and store, and great for recipes calling for chunks of chocolate. The are made using 100% cocoa butter and a dash of vanilla that rounds off the taste with a slight sweet hint. chocolate requires tempering to obtain a high gloss for chocolate making. Product of Belgium.</p>
16800 <p>White Chocolate Chips by Barry Callebaut are an excellent choice for cookies, dessert bars, muffins, and more. Made with cocoa butter and vanilla, these white chocolate morsels are real white chocolate chips with superior taste. They're bake-stable and ready for your favorite recipes.</p>
16801 <p><strong>A great base for flavouring, colouring and texturing.</strong><br />Callebaut®'s cocoa powder is 100% pure cocoa, pressed from the same great blend as the one we use to craft our Finest Belgian Chocolate. It has a warm, red-brown colour and a very pleasant solid chocolaty taste that mainly comes from the West African bean blend that forms its base. It's spiced up with flavour beans from other African regions, Latin America and Asia.<br />This cocoa powder also has a very fine texture and can easily be mixed into doughs and liquids – which is great for flavouring and colouring your sponges, biscuits, ice creams, desserts, drinks and so much more. Its lovely taste and colour make this your must-have cocoa powder for decorating and finishing your desserts as well.</p>
16812 <p>Our premium anchovies hail from the azure coastal waters of the Pacific Ocean. They are wild-caught via sustainable fishing techniques and delivered to our processors at the peak of freshness. They are then pre-salted, cured in a brine of water, fat, sea salt, and filleted by hand.<br /></p>
16813 <p>Anchovies are small seawater fish about 3 inches long and closely related to herrings. They can be eaten raw or cooked, and with their rich flavour, provide a solid, multi-layered base to many Mediterranean dishes including salads, pasta dishes, and many sauces from around the world.</p>
16826 <p>Brined capers, with their sharp edge and bold flavor, are super-convenient. All you need to do is drain the liquid and they’re ready to toss into your dish. Salt-packed capers retain a better texture, but they’re not as pungent and they take just a bit more time to prep. Simply rinse away the excess salt, soak them in cold water for about 10 minutes, then drain and pat dry.</p> <p></p>
16827 <p>Caperberries are different from capers. While the both come from the same plant they are most definitely not the same thing. Capers are the buds from which the caper flower grows. From that flow the berries - caperberries - form. And while they come from the same plant they have a very different texture and flavor. Caperberries are preserved with the stem, allowing a crunchier texture. Flavorwise, the caperberry is milder than the caper, but can be used in a similar fashion.</p>
16845 <p>Avocado puree is a versatile and healthy ingredient that can be used in a variety of recipes. Avocado puree can be used in a variety of ways in the kitchen. You can use it as a healthy substitute for mayonnaise or sour cream in dips and dressings, or as a creamy base for smoothies and desserts. It can also be used as a spread for sandwiches or as a topping for toast. The possibilities are endless!</p>
16849 <p><b>Serena Risotto Italian Arborio Rice</b> is perfect for a quick and delicious meal. Sourced from Italy, this rice is ready in 15 minutes, making it a convenient ...</p>
16858 <p>Red Lumpfish Caviar Roe, crafted from sustainable seafood, exudes luxury and makes a delightful snack or classy hors d'oeuvre. Pair it with eggs, <span class="c5aZPb"><span class="JPfdse">blini</span></span>, sushi, and gourmet appetisers. Rich in vitamins B12 and A, protein, magnesium, and calcium, it's a top-quality product presented in a glass jar. </p>
16861 <p>Pastrami is made from beef brisket that has been cured, coated in spices, cold smoked and then steamed. Pastrami's thick coat of spices typically includes crushed black pepper, coriander, mustard seeds, garlic and other spices that might be included in a pickling spice mixture.</p>
16862 <p>roast beef is one of the leaner cuts of beef from the cow, it is <b>cooked low and slow for multiple hours</b>, resulting in a melt-in-your-mouth texture.</p>
16871 <p></p> <p>Ostrich Carpaccio is a stunning culinary delight that brings an <a href="https://zazarecipes.com/category/exotic-meat-recipes/">exotic</a> twist to the classic dish. This recipe features thinly sliced ostrich meat, which is lean, flavorful, and rich in nutrients. Paired with a zesty lemon dressing and fresh arugula, each bite is a delightful balance of flavors and textures, making it an impressive starter for any <a href="https://zazarecipes.com/category/dinner-recipes/">dinner</a> party or special occasion.</p> <p>This dish is not only appealing for its taste but also for its health benefits. Ostrich meat is known for being lower in fat than <a href="https://zazarecipes.com/category/beef-recipes/">beef</a> while still providing a high protein content. By serving it raw as carpaccio, you retain all of its natural flavors, making it a perfect choice for those who appreciate gourmet experiences. The bright citrus notes from the lemon and the peppery arugula elevate this dish, making it a standout choice for adventurous food lovers.</p>
16881 <p>Black Forest ham is a smoked, boneless German ham that has a blackened skin and a light, smokey flavor. It is dry-cured with salt and other spices for up to three months, and then cold-smoked over pine or fir wood. The spices used in Black Forest ham include salt, garlic, coriander, juniper, and pepper, among others. This gives it a moist, intense flavor that is perfect for sandwiches or soups.</p>
16888 <p>Back bacon is <b>a cut of bacon that includes the pork loin from the back of the pig</b>. It also includes a portion of the pork belly in the same cut.</p>
16889 <p>meat from the back or sides of a pig that consists of stripes of fat and stripes of meat, often eaten fried in thin slices.</p>
16929 <p>A full fat blue veined Gorgonzola style cheese with a mild flavour and rich creamy texture.</p>
16932 <p></p> <p>Mild, creamy and delicious, our Babybel<sup>®</sup> Cheese Original flavor makes snack time a tasty adventure. Mini Babybel<sup>®</sup> Original is the perfect cheese for cheese and crackers, and pairs perfectly with your favorite pretzels for a creamy, crunchy duo. It’s wonderful as a quick snack during a work day or as a cheesy surprise in a school lunch. </p> <p>This 100% real cheese snack has no artificial growth hormones*, artificial colors, flavors or preservatives. It contains 4g of Protein and is a good source of calcium**. </p>
16937 <p>Boerenkaas is a hard, dry and salty cheese with a strong, intense flavour. You’ll likely pick up it’s sweet undertones of caramel or toffee and those of bitter coffee. The texture is grainy and gritty as the cheese is packed with calcium lactate crystals, which develop during the ageing process, for added flavour and crunch.</p>
16938 <p></p><p>Our <strong>Boerenkaas</strong> is a mildly spicy aromatic flavoured smooth medium fat hard cheese with cumin.</p> <ul><li><br /></li></ul>
16939 <p>A soft, goat’s milk cheese with a characteristic flavour. Chevin is one of the first cheeses that was made at Fairview and is the most popular goat’s milk product. It is still made using the same traditional recipe, with the curd pressed in muslin bags to remove just the right amount of whey.</p>
16940 <p>Goat's Milk Cheese (Pasteurised Goat's Milk, Salt, Cheese Cultures, Non-Animal Rennet, Preservative: Potassium Sorbate), Seasoning Mix (Salt, Onion, Dextrose, Garlic, Herbs, Spices, Spice Extracts, Flavouring)</p>
16941 <p>Chevin Black Pepper Paprika . A soft goat's milk cheese a mild goat flavour, rolled in crushed black pepper and paprika seasoning. Made from 100% goat milk.</p>
16943 <p></p> <p>Very Berry Fruits brings you Frozen Mixedberry which are IQF (individually Quick Frozen) processed in a state-of-the-art facility, which helps in retaining its natural flavor & nutritional value intact.Our Frozen Mixedberry can be used for Breakfast Cereals, Smoothies, Jams, Muffins, Cakes, Pastries, Salads, Beverages, Desserts & much more…</p>
16946 <p>Fairview Camembert cheese is made using an age-old traditional recipe with a flavour that intensifies with age to a characteristic earthy, mushroom aroma.</p>
16947 <p>This Jersey cow's milk brie cheese is smooth and creamy, with a supple texture and a distinctive savoury flavour.</p>
17017