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, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    5473, 345, 56, 370, 65, 80, 84, 83, 294
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00051

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 9,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (5473,345,56,370,65,80,84,83,294) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
56 Biotherapy Skincare is an excellent everyday face and body soap. People with problem skin love it. It contains essential oils of tea tree, palmarosa, lavender, geranium, patchouli and vetiver. The soap is pleasantly scented, perfect for dry or oily skin. We put two other beneficial ingredients in Biotherapy Skincare. Jojoba oil, a noncomedogenic moisturizer, will soften your skin without clogging your pores. Pulverized oatmeal will soothe and tone your skin. Use Biotherapy Skincare to wash regularly. Dont forget good nutrition, exercise, and a doctors care when necessary. Biotherapy Skincare soap, jojoba oil, oatmeal, best, handmade, all natural, cold-process, all-vegetable, vegan, Castile, bar soap, moisturize, moisturizing, skin, face, pimples, body, acne, dermatitis, psoriasis, eczema, dry skin, skin problems, zits Skin balancing essential oils and moisturizing jojoba oil in an effective complexion bar. Buy 6 get 1 free. Free Shipping on orders over $60. See 60 other soap varieties.
65 You are passionate about your perennials. While your beds look spectacular, your hands suffer. They’re not just dirty, but dry and damaged. Wash your hands with Gardener’s Hand Soap to gently scrub your skin clean. The bar contains finely ground cornmeal to remove stubborn dirt and to make your hands feel smooth again. Rich African shea butter in the soap will restore moisture. Your skin will feel soft and pampered. A blend of three essential oils makes the fresh citrus scent a perfect finish. Gardeners Hand soap 'I love this soap!' Cornmeal scrubs clean, shea butter moisturizes. Buy 6 get 1 free. Free shipping on orders over $60. Over 60 varieties healthy for face and body.
80 Peppermint bars contain unique swirls of Australian pink clay. The clay adds color and  minerals to make a delightful bathing experience for everyone in the family. Creamy, cleansing lather leaves your skin feeling tingly with natural menthol from the oil of peppermint. Peppermint essential oil also provides the dominant scent, which we soften and round out with a touch of sweet palmarosa essential oil. Enjoy inhaling the smooth mint aroma. Peppermint soap 'I love this minty soap!' With moisturizing shea butter. Buy 6 get 1 free. Over 60 varieties healthy for face and body.
83 Rosemary has a long history as a favorite fragrance. Some time in the 1300s, it was the key ingredient in the famous perfume, Hungary water. Legend tells of a queen of Hungary, who, wearing the fragrance at the age of 72, captivated the King of Poland in a romantic liaison. For the next 500 years, until the French started producing eau de Cologne in the Eighteenth Century, no other herb enjoyed the popularity of rosemary either as a scent or as a natural remedy. No wonder one of our most beloved soaps is Rosemary. We blend three essential oils to create this scent. It is predominately rosemary but tempered with lavender and softened with rose-like palmarosa. Your skin will love the Rosemary bar as much as your nose. Finely crumbled rosemary leaves add a bit of texture. A healthy dose of hemp seed oil provides a lavish moisturizer. Rosemary soap 'I love this soap!' With moisturizing hemp seed oil. Buy 6 get 1 free. Over 60 varieties healthy for face and body.
84 The romantic scent of this soap will brighten your spirits as you clean and moisturize your skin. The natural fragrance comes from the essential oil of Egyptian rose geranium. Palmarosa, another rosy-scented essential oil, moderates the sweetness to create a fuller and more complex aroma. The Rose Geranium bar is one of our few floral-scented soaps. We cannot use real rose extractions because they are prohibitively expensive, added only to costly perfumes. And our products never contain synthetic fragrance oils. Soothing, and gentle enough for sensitive skin, this soap promotes the body's natural ability to balance oil production. We add French pink clay not only to create the lovely pink color but also to provide its softening and conditioning qualities. Our emollient in this bar is avocado oil. Rose Geranium soap 'I love this all vegetable bar!' With moisturizing avocado oil. Buy 6 get 1 free. Over 60 varieties healthy for face and body.
294 The bright yellow color of our Saffron Gold comes from Spanish saffron. You can see its yellow-orange threads throughout the bright yellow bar. This treasured spice in the soap adds a sensuous scent to the citrusy blend of nine essential oils. This soap not only looks and smells good, its also really good for you. Saffron Gold is superfatted with mango butter, expeller pressed from the seeds of mangos. The butter softens, soothes and moisturizes dry skin. Saffron is one of the plants used to dye the robes of Buddhist monks. If you see a bit of yellow on your washcloth, try laundering it with oxygen bleach. Saffron Gold soap "I love this fragrant soap!" With moisturizing mango butter. Buy 6 get 1 free. Over 60 varieties healthy for face and body.
345 We have taken our popular Biotherapy™ Skincare soap to new depths of cleansing by adding activated charcoal to the original formula. Because activated charcoal removes impurities, it can help reduce the instances of acne and other skin problems. It works wonders for thoroughly removing makeup. You can use it all over your body. The soap is pleasantly scented. It contains essential oils of tea tree, palmarosa, lavender, geranium, patchouli and vetiver, to balance your skin's oil production, whether you have dry or oily skin. It also contains finely ground oatmeal, though you won't see it. Oatmeal helps cleanse, soothe and moisturize your skin. We've superfatted the soap with jojoba oil, a noncomedogenic moisturizer, which will soften your skin without clogging pores. Use Biotherapy Skincare to wash regularly. Don’t forget good nutrition, exercise, and a doctor’s care when necessary. Biotherapy Black soap, jojoba oil, oatmeal, activated charcoal, best, handmade, all natural, cold-process, all-vegetable, vegan, Castile, bar soap, moisturize, moisturizing, skin, face, body, acne, dermatitis, psoriasis, eczema, dry skin, skin problems. Skin balancing essential oils and activated charcoal in an effective complexion bar. Buy 6 get 1 free. Free shipping on $60 orders. See 60 other soap varieties.
370 Because you asked, we now sell 45 of the same pure essential oils we use to scent our soaps and other products. They come in half-ounce and one-ounce amber glass bottles with screw caps. Select them from the dropdown list. Over the past dozen years, we have established reliable suppliers of quality oils from all over the world. Because we purchase in bulk, we can offer smaller quantities to you at a good price. bottled natural essential oils
5473 <p><span class="gmail_default">Though there are those who can't wait to try another soap variety, s</span>ome of us are just too darn lazy to get a new bar for the shower so we made Big Bars.&nbsp;</p> <p>These five bestsellers are nearly twice as large as our regular bars.&nbsp;</p> big bars soap large bars larger Our bestsellers are nearly twice the size of regular bars. Free shipping on $60 orders. We offer 60 soap varieties for face and body. <p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">five popular varieties</span></p> <p>&nbsp;</p>