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, 
  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 (
    5474, 5473, 248, 57, 205, 392, 59, 61, 
    62, 63, 65, 68, 69, 303, 73, 5556, 76, 
    380
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00087

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 (5474,5473,248,57,205,392,59,61,62,63,65,68,69,303,73,5556,76,380) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	meta_keywords	meta_description	search_words	promo_text
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.
59	Freshly squeezed oranges. Zest spritzing from a juicy tangerine. A touch of lemon. Our Citrus Oatmeal is a magnificent bar that revitalizes you with every shower. No wonder its one of our best sellers for men and women. We start with the same wholesome vegetable oils and emollients that go into all Herbaria soaps. Then we add ground oatmeal for gentle exfoliation and shea butter for moisturizing. The combination of rich, creamy lather and a good scrub makes for clean, healthy skin. It is a gorgeous bar colored by the bright orange essential oil and annatto, an all natural food coloring.	Citrus Oatmeal, orange, shea butter, olive oil, tangerine, 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.	'Smells fresh squeezed!' Citrus scent from orange & tangerine essential oils. Oatmeal soothes, scrubs. Shea butter moisturizes. Buy 6 get 1 free. Over 60 varieties.	Citrus 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
61	Two supremely complementary scents become one fragrant delight in this minty eucalyptus bar. Aromatic Australian eucalyptus will energize and renew you. If you are looking for a thrilling morning shower, this soap will satisfy you thoroughly. Powdered watercress gives this handsome bar its frosty green color. The soap is enriched with shea butter to hydrate and cleanse your skin. The copious lather makes for an invigorating shave.	Eucalyptus Mint soap	'I love Herbaria Eucalyptus Mint soap!' All natural soap, moisturizing, scented only with essential oils. Buy 6 get 1 free. Healthy for face and body. Over 60 varieties.
62	Our Evergreen soap delivers a fresh, clean, outdoor scent any season of the year. Its a marvelous blend of sweet, woody essential oils including fir needle, cedarwood, and eucalyptus. Breathe deeply. Your sinuses and lungs will naturally expand with the welcome camphoraceous scent of this bar. Its a terrific all-body soap packed with oatmeal and seaweed for an invigorating scrub. Shea butter is the added moisturizer. We make sure our soaps will never dry you out.	Evergreen soap	'I love Herbaria Evergreen soap!' All natural soap, moisturizing, scented only with essential oils. Buy 6 get 1 free. Healthy for face and body. Over 60 varieties.
63	These two ancient fragrances have been revered for over 5,000 years. Renowned as the gift of the Magi to the baby Jesus, and even more valuable than the gold they brought, frankincense and myrrh offered treasures in addition to their heavenly scents. As with all our soaps, Herbaria does not use imitation fragrances. To make this soap, we add genuine steam distilled essential oils imported from Somalia. These costly oils account for the bars premium price. The frankincense is derived from a resin of the Boswellia carterii tree; the myrrh is a resin from the Commifora myrrha tree. Finely ground Rhassoul clay, from the Atlas Mountains of Morocco, is marbled into this bar to provide a mineral-rich toner. Shea butter, also from Africa, moisturizes and protects your skin. We believe you will find this soap a royal treasure.	Frankincense and Myrrh soap	'I love Herbaria Frankincense and Myrrh soap!' With moisturizing shea butter. Buy 6 get 1 free. Free shipping on orders over $60. Over 60 varieties healthy for face and body.
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.
68	Indonesian Safflower makes people crazy. In addition to the lovely safflower blossoms scattered throughout the bar, it contains a heady blend of sweet basil, ylang ylang, vetiver and patchouli. It's our strongest scented soap. After a bath with this, you'll be looking for your sari. Basil oil is said to aid concentration and clarify the mind and ylang ylang is reputed to stimulate the senses and induce feelings of well-being. You will definitely feel altered after an experience with this bar.	Indonesian Safflower 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.
69	Do you remember making pomanders as a kid—an orange studded with whole cloves left to dry and scent the closet? That is what Island Spice soap smells like. Very spicy and warming, like cookies in the oven. Originally a holiday inspiration, folks demanded this soap all year 'round. It contains essential oils of nutmeg, clove leaf, cinnamon leaf, orange and tangerine, plus ground cinnamon for color. It's also superfatted with shea butter.	Island 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.
73	Hands down, we get more positive reports on our Lavender Oatmeal than on any other bar. Its so popular that, to suit a variety of skin types, we offer the soap in three different grinds of oatmeal, Regular, Extra Exfoliating, and Extra Colloidal.	Lavender Oatmeal soap	Lavender essential oil and moisturizing shea butter in a luxuriously lathering, long-lasting bar. Buy 6 get 1 free. Free shipping on orders over $60. Choose fine, medium, or coarse oatmeal.
76	Our May Chang bar is guaranteed to energize your day and put you in a sunny mood. May Chang smells intensely lemony yet the fragrance is sweeter and fruitier. The bar is smooth and creamy with a golden yellow color from turmeric. What is may chang? It is the common name of Litsea cubeba, a member of the Laurel family growing in East Asia. Its leaves are loaded with citral, which also imparts the scent to lemon verbena. Lemon verbena essential oil, used in perfumes, would be too expensive to use in our soap. Besides, honestly, we think may chang smells brighter and fresher. The first-rate cleansing benefits of this bar work well for face and body. In addition, it is said to relieve oily skin and acne and provide a calming effect on the nervous system.	May Chang soap	'I love this soap!' Lemon verbena scent. With moisturizing shea butter. Buy 6 get 1 free. Free shipping on orders over $60. Over 60 varieties healthy for face and body.
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.
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.
303	Over a decade ago, LaRee DeFreece developed our first soaps. Of all the varieties she created, this pure, unscented Castile soap is still her favorite. She loves the nourishing, moisturizing addition of extra shea butter and avocado oil. LaRee’s Scent Free is also available with ground oatmeal. Oatmeal exfoliates dead skin cells and offers colloidal benefits to further soothe and soften skin.	LaRee's Scent Free soap	“I love it!' LaRee's Scent Free all natural soap is perfect for face and body. With shea butter and avocado oil. With or without oatmeal. Buy 6 get 1 free. Free shipping on orders over $60. Over 60 varieties healthy for face and body.		<p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">with or without </span></p> <p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">oatmeal </span></p>
380	Assorted soap shreds festoon this activated charcoal, deep-cleansing body bar. Essential oils of may chang and lavender give it a fresh, lemony scent. Shea butter makes the soap extra moisturizing.	milled all-natural soap	Assorted soap shreds festoon this activated charcoal, deep-cleansing body bar. Essential oils of may chang and lavender give it a fresh, lemony scent. Shea butter makes the soap extra moisturizing.
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.
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. </p> <p>These five bestsellers are nearly twice as large as our regular bars. </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> </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.
5556	Welcome to an extraordinary shower. Luffa soap will quickly become your skins BFF. We’ve incorporated our moisturizing soap into whole natural luffas (also spelled loofah). The ones we use come directly to us from Egypt. Luffa aegyptiaca is a member of the Cucurbitaceae (gourd) family that includes squash, pumpkins and zucchini. When young and tender, sponge gourds are eaten. When mature, they are used for a natural scrub. You will see why luffas have been used for thousands of years. They have a perfect texture for the job: not too rough but just right.	luffa soap	Exfoliating Luffa Soaps, 6.5 oz., scented with essential oils. Buy 6 get 1 free. Free shipping on orders over $60. Lavender, Lemon, Mint, Biotherapy Black, Camper’s Choice, Soapy’s Choice.		<p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">7 sublime varieties </span></p>