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 (
    298, 232, 54, 337, 5473, 315, 236, 3478, 
    341, 5475, 59, 309, 65, 69, 70, 75, 5556, 
    76
  ) 
  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"],
      "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,232,54,337,5473,315,236,3478,341,5475,59,309,65,69,70,75,5556,76) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	meta_keywords	meta_description	search_words	promo_text
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.
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
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.
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.
70	The lemony, floral notes of our Italian Bergamot bar come from essential oil of bergamot, extracted from the peel of an orange-like citrus fruit that grows in southern Italy along the Mediterranean coast. The bergamot essential oil we use is bergaptene free so theres no problem in regards to sun exposure. The soft, spicy scents in the soap come from lavender and clove, which blend with the bergamot to make an especially fresh and clean aroma. We add hemp seed oil as a skin softener. Aromatherapists believe that bergamot perks you up when you feel stress and anxiety. We think you will enjoy this delightfully fragrant soap.	Italian Bergamot 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.
75	After a day in the sun, you will sing in the shower. Our Lime Coconut Aloe soap combines three superb ingredients evocative of a frosty Caribbean cocktail. This bar will cool you down and perk you up. Enjoy the full fragrance of fresh lime while your sun-drenched skin welcomes the moisturizing comforts of coconut oil. We pack an extra measure of the oil in every bar. To top off this luscious summer blend, we add the juice of aloe vera, the well known succulent especially soothing for sunburned skin. The soaps calm green color comes from nettle. You will love this bar so much you will want to use it year-round.	Lime Coconut Aloe soap	'I love this soap!' With moisturizing coconut oil. Buy 6 get 1 free. Free shipping on orders over $60. Over 60 varieties healthy for face and body.
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.
232	Most air fresheners and linen sprays saturate a room with throat-choking smells from synthetic fragrance. These aerosols also employ chemical propellants such as propane and butane. Ambiente Room Freshener and Linen Spray uses wholesome essential oils with natural aromas to delight you. Leave the bathroom without embarrassment. Five delightful varieties.	Ambiente room freshener natural	Ambiente room freshener uses essential oils to provide a wholesome, effective mist you won’t be afraid to inhale. The natural fragrances will delight you, your family, and your guests. Buy 6 get 1 free. Free shipping on $60 orders.
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
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>
309	Herbaria Deodorants are safe and gentle, without any of the many questionable chemicals found in most antiperspirants and deodorants such as synthetic fragrance, aluminum, parabens, petrochemicals, and propylene glycol.		Safe, gentle and effective deodorant, not antiperspirant, with essential oils. Lavender, Key Lime, Rose Bergamot, Vetiver. Free shipping on orders over $60. Read the rave reviews!		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">five fresh scents</span>
315	Your precious face needs extra care. Biotherapy Face Serum absorbs quickly through your skin to restore its elasticity and rejuvenate your complexion. Your skin will feel firmer, smoother, younger. A few drops a day will moisturize and protect your skin with deeply penetrating, extra-hydrating antioxidants. This nourishing blend of anti-aging oils includes sunflower, hemp seed, avocado, jojoba, sweet almond and rosehip, a powerhouse of phytonutrients. The fresh, clean scent comes from essential oils of lavender and bergaptene-free bergamot. To use: Wet your face. Put two or three drops on your palms and rub your hands together. Then pat your palms all over your face, massaging not necessary or recommended. Allow the serum to absorb.	face serum, facial moisturizer	Your skin will feel firmer, smoother, and younger. A few drops a day will moisturize and protect your skin with deeply penetrating, extra-hydrating antioxidants.
337	Herbaria Beard Oil soothes and conditions your beard and the skin under it without being greasy. You will look good all day and your skin will be itch-free. In response to customer requests, we developed this odorless blend of moisturizing organic oils: jojoba, high oleic sunflower seed and babassou. These oils wont clog pores but will soften coarse whiskers, keep hair follicles healthy and leave your beard shiny. Terrific for your hair, too.	all natural beard oil	'I love Herbaria all natural Beard Oil!' All natural, moisturizing, scented only with essential oils. Buy 6 get 1 free. Free shipping on $60 orders. Healthy for face and body.		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">three scents + unscented</span>
341	Do you know someone who enjoys a relaxing soak in the tub? She or he is sure to appreciate this collection of all seven of our Caracalla Bath Bombs. Each bath bomb has its own aromatherapeutic blend of essential oils to make a richly fragranced bath such as those in which Cleopatra indulged. Once dropped into the tub, a bath bomb will fizz away to release moisturizing high oleic sunflower oil that will coat an entire body.	Bath bombs, bath fizzies	Bombs away! Drop a Caracalla in your bath water. Watch it fizz and bubble as it dissolves. Smell the magnificent fragrance releasing. Step into your private spa.
3478	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and candelilla waxes ensure a clean and long-lasting burn. Braided cotton wicks support a steady flame.	candles, soy candles, all-natural	We are proud to offer you the finest quality hand-poured candles, sure to bring warmth and coziness to any environment. Scents are pure and natural. We use only essential oils for these alluring aromas. Our proprietary, vegan blend of soy, coconut, and ca		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">clean, long-burning</span>
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>
5475	Bombs away! Drop a Caracalla in your bath water. Watch it fizz and bubble as it dissolves. Smell the magnificent fragrance releasing. Step into your private spa. Lie back and relax. Breathe deeply. Your bath becomes soft and silky from powdered clays or finely ground oatmeal and Epsom salt. Enjoy the feeling of well-being as your stress floats away. Caracalla releases moisturizing organic high oleic sunflower oil to cover your entire body. The oil readily absorbs into your skin through your pores, which are open from the warm water. Your skin will feel velvety.	Bath bombs, bath fizzies	Bombs away! Drop a Caracalla in your bath water. Watch it fizz and bubble as it dissolves. Smell the magnificent fragrance releasing. Step into your private spa.		<span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">7 enchanting scents</span>
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>