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 (
    298, 488, 52, 53, 54, 222, 55, 5474, 5473, 
    345, 56, 248, 57, 205, 518, 236, 392, 
    58
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00084

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": 18,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (298,488,52,53,54,222,55,5474,5473,345,56,248,57,205,518,236,392,58) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
52 Almond Green Tea tops our list of over 60 soap varieties, all exceptionally moisturizing, lathering, and long lasting. To create the rich, characteristic almond aroma of Almond Green Tea, we add to our base costly essential oil of bitter almond, prized for its marzipan scent. We do not use imitation almond flavoring. Almond Green Tea soap, Almond oil, Green Tea Soap, 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. Real bitter almond essential oil and moisturizing sweet almond oil in a luxuriously lathering, long lasting bar. Buy 6 get 1 free. Free shipping on $60 orders. See 60 more soap varieties.
53 While our Almond Green Tea delivers a straightforward marzipan scent, Almond Spice radiates with clove and cinnamon-like cassia, citrusy, floral bergamot and natural almond essential oil. The warm, comforting aroma becomes wholly satisfying. This golden soap is flecked with tender calendula petals. Sweet almond oil superfats the bar for a luxurious moisturizing lather that leaves your skin soft and smooth. Let this bar scent your dresser drawers and linen closets. Delight your friends with Almond Spice in your guest bath. Take time yourself to relax and enjoy the soap in a lavish bath. A year-round favorite, especially appreciated during the winter holidays, Almond Spice brings joy any day. It makes a lovely hostess gift. Almond Spice soap, cinnamon, clove, 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. "I love this soap!" With real almond essential oil, almond oil for moisturizing. Buy 6 get 1 free. Free shipping on $60 orders.
54 This soap will brighten your bath or shower with its crisp, clean fragrance. The vivid citrus scent comes from tangy lemon, fresh lemongrass and zesty orange essential oils. Finely-ground dried lemon adds texture to the bar for a gentle exfoliant. Avocado oil in the bar provides soothing benefits to your whole body. The oil is anti-bacterial and well known for healing skin irritations. It’s also high in Vitamin E, a powerful antioxidant. This is one of LaRee’s original varieties and it remains a favorite of many customers. Avocado Lemon soap, avocado oil, 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. "Best handmade bars!" Avocado Lemon natural soap is moisturizing, scented with essential oils. Buy 6 get 1 free. Free shipping on $60 orders.
55 If you are searching for classic bay rum scent in a soap, we have got the best. We are crazy about it! We offer this body bar with or without exfoliating oatmeal and also in a round, creamy shave puck. Vibrant with the irresistible spiciness of the West Indian bay tree, this soap will quickly become your favorite. Prized essential oil of Pimenta racemosa, a cousin of allspice, dominates the fragrance. Then we top off the aroma with just a dash of sweet orange oil. The natural russet color of the bar comes from steeped elderberries. Bay Rum, soap, jojoba oil, oatmeal, 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. West Indies Bay Rum essential oil in a moisturizing, shower, shave & shampoo bar. Choose w/ or w/o oatmeal. Buy 6 get 1 free. Free shipping on $60 orders. See 60 other soap varieties.
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.
57 The traditional fragrances of Germany: bergamot, cinnamon leaf, lavender, lemongrass and orange blend and balance magnificently in Black Forest Chamomile. Faintly floral but not flowery, spicy but not piquant, it is a very popular bar among both men and women. The soap is richly superfatted with shea butter to provide a long lasting moisturizer. The beautiful color and gentle texture come from crushed chamomile blossoms. Black Forest Chamomile soap, shea butter, superfatted, 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. 'I love Herbaria Black Forest Chamomile soap!' All natural soap, moisturizing, scented only with essential oils. Buy 6 get 1 free. Healthy for face and body. Over 60 varieties.
58 If you love chocolate, you will love this bar. Enjoy it all you want and you wont gain an ounce. Chocolate is good for you. We use only real chocolate, an absolute of cocoa beans from the cacao tree, Theobroma cacao. The genus name Theobroma means food of the gods. Also from Theobroma cacao comes the cocoa butter we add as an excellent emollient to soften your skin. The bar makes scrumptiously scented creamy lather that delivers a bounty of antioxidants and phytonutrients to and through your skin. Every chocolate lover you know will crave this cake of soap. Chocolate soap, cocoa butter, 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 'I love Herbaria Chocolate soap!' All natural soap, moisturizing, scented with cocoa absolute. Buy 6 get 1 free. Healthy for face and body. Over 60 varieties.
205 The basis of our Brown Windsor soap comes from Perfumery and Kindred Arts, a Comprehensive Treatise on Perfumery by Richard Cristiani, published in Philadelphia in 1877. Even then, the author referred to the recipe as Old Brown Windsor Soap. The original soap was made in Windsor, England, and exported around the world. Brown Windsor was said to be a favorite of Napoleon, a notorious lover of scent. Cristianis recipe called for lavender, bergamot, caraway, petitgrain, cinnamon, and clove. We tested various proportions of these essential oils and chose the blend we found most satisfying. Brown Windsor Soap, shea butter, superfatted, 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.avocado oil, bergamo “A classic.” Old fashioned Brown Windsor soap smells of spice and citrus. Natural skin care bar with shea butter and essential oils. Feel the difference. Buy 6 get 1 free. Over 60 varieties.
222 Sniff this bar and you will smell the aromatic fragrance of a fresh cut Christmas tree. In the background, a cozy fire burns in the fireplace. Fond memories swell up from deep inside you. Balsam Fir and Juniper is an ideal winter bar. To help your skin during the chilly, drying seasons, we add sweet almond oil to our already moisturizing base oils. With its lovely holiday green color, you could suppose this is just a Christmas bar, but like our Frankincense and Myrrh, you may want to use it all year round. The evergreen scent is perfect, really, anytime. Balsam, Fir, juniper, soap, almond oil, 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. "Best handmade bars!" Balsam Fir & Juniper natural soap is moisturizing and scented with essential oils. Buy 6 get 1 free. Try Citrus Oatmeal, too. Over 60 varieties. Free shipping on $60 orders. 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
236 Does the scent of your soap attract mosquitoes? Campers Choice contains eight essential oils known to repel insects. Like all of our soaps, its moisturizing, luxuriously lathering and long lasting. You will love the scent. Lemon predominates. Its from the citronella, lemongrass, and lemon eucalyptus. Other pleasantly fragrant plant oils in this bar are lavender, basil, thyme and patchouli. They repel mosquitoes also. To top it off, we add costly catnip essential oil, reported to be ten times stronger than DEET. Camper's Choice Soap, shea butter, superfatted, 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.avocado oil, catni Repels mosquitoes, smells nice! Safe, natural, effective insect repellent soap with DEET-free herbal blend of 8 essential oils, including lemon eucalyptus, catnip and citronella
248 In your shower, gently rub this luxurious natural body treatment wherever your skin is rough, hands, elbows, knees, feet, heels. The coarse turbinado sugar crystals scrub dead cells away and leave treated areas baby smooth and soft. The healthy sheen you will enjoy also comes from unrefined shea butter and organic high oleic sunflower seed oil, which moisturize and condition your skin. The sweet scent of lavender and peppermint essential oils complements the sugar scrub and adds to your pleasure as you pamper yourself. The shea butter and sunflower oil in this mixture will make a shower or tub slippery. Please be careful. Biotherapy Sugar Scrub 'I love Herbaria Biotherapy Sugar Scrub!' All natural, moisturizing, scented only with essential oils. Buy 6 get 1 free. Healthy for face and body. Over 40 varieties.
298 Herbaria Aftershaves condition your skin to make your face feel great for hours, even after the closest shave. They smell irresistible from essential oils, not irritating synthetic fragrance. after shave conditioner, skin conditioner, aftershave, men's aftershave, women's aftershave, balm aftershave, aftershave skin conditioner, lotion aftershave, essential oil aftershaves Not stinky, stinging or drying, our aftershaves are skin conditioners more than cologne. Makes skin feel comfortable all day. Buy 6 get 1 free. Free shipping on $60 orders. <span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">not Grandpa's aftershave</span>
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.
392 Chai Spice soap will soothe your soul with this delightful, exotic blend of essential oils including coriander, cardamom, cinnamon, ginger, nutmeg, vanilla and black pepper. Cardamom is second only to saffron in the realm of costly spices, but it's key to a great chai and why this bar is a premium soap. You may choose it for your free bar. The bar contains shea butter to moisturize your skin. Black tea provides the color and kaolin clay adds a creaminess to the lather. Chai Spice soap 'I love this soap!' Buy 6 get 1 free. Shea butter moisturizes. Buy 6 get 1 free. Free Shipping on orders over $60. Over 60 varieties, healthy for face and body.
488 <p>The aroma of Almond Aloe is soft and sweet, nutty and floral. The scent was inspired by orgeat (<span>pronounced or-zhat)</span>, an almond syrup used in classic cocktails such as the Mai Tai. Above and beyond our moisturizing base, we've added sweet almond oil and aloe vera. The creamy lather leaves skin soft from head to toe. To remove oils and impurities from your skin, we've added micronized Rhassoul clay. It serves as a natural, gentle exfoliant.</p> Almond Aloe soap, best, handmade, all-natural, cold-process, all-vegetable, vegan, Castile, bar soap, moisturize, moisturizing, skin, face, body, "I love this soap!" With real almond essential oil, almond oil for moisturizing. Buy 6 get 1 free. Free shipping on $60 orders.
518 Like all Herbaria products, Burano is free of detergents, synthetic fragrances, dyes, enzymes and brighteners, any of which can remain in clothes and bedding. Those harsh additives often cause skin irritation or allergies. Burano is simply our soap odds and ends shredded to dissolve quickly in water. It has the pleasant aroma of natural soap, light scented with essential oils. laundry soap, burano laundry soap, all-natural soap Burano extends the life of your clothes and bedding. Wash delicates with Burano—sweaters, knits, jackets, comforters. It’s safe for washable wool, linen, cotton, silk, and synthetic fabrics.
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>
5474 Not every test we make becomes a bar we want to keep in rotation.  Try our newest creations and we'll see what our customers love and what should stick around. soap Try our test bars—free shipping on $60 orders. Buy 6 get 1 Free.