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 (
    55, 337, 5473, 345, 56, 336, 105, 280, 
    5556, 5477, 235, 92, 227
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00115

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": 13,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (55,337,5473,345,56,336,105,280,5556,5477,235,92,227) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	meta_keywords	meta_description	promo_text
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.
92	Three different essential oils with the common name of tea tree combine to make this total tea tree bar. The blend of Australian tea tree (Melaleuca alternafolia) with kanuka (Kunzea ericoides) and manuka (Leptospermum scoparium), both from New Zealand, creates a pleasantly herbal aroma, somewhat reminiscent of leather. Tea tree oil is well recognized for its active role in skin care.	Tea Tree Green Tea soap	Melaleuca and 2 other "tea tree essential oils." Creamy lather with moisturizing jojoba oil. With or without oatmeal. Buy 6 get 1 free. Herbaria offers a full spectrum of excellent face and body soaps plus other personal products.
105	We have combined several of our favorite ingredients such as organic jojoba oil and essential oils of rosemary, lavender, cedarwood, thyme and basil to create Jojoba Healthy Hair, a leave-in conditioner for the luster and nourishment of your hair. For optimum results, massage just a few drops of this non-greasy formula into your hair and scalp.	Jojoba Healthy Hair	Leave-in conditioner for luster and nourishment of your hair with organic jojoba oil and essential oils. Buy 6 get 1 free. Free shipping on orders over $60. Enjoy all our excellent face and body soaps plus other personal products.
227	This solid bar is perfect for travel because it multitasks as shampoo, face and body soap, and shave cream. Since airline regulations limit liquids in carry-on luggage, you will zip through TSA inspections. Like all of our soaps, Travelers Choice contains no detergents, phthalates or synthetic fragrances. Rosemary and petitgrain create the light fragrance.	Traveler's Choice Shampoo	Solid bar shampoo makes rich lather, leaves hair soft, clean, manageable. No parabens, phthalates, or harsh detergents. “Great for traveling.”
235	Bar shampoo? Yes! If your dog has skin problems, check the ingredients in the liquid pet shampoo you are using. It is probably made with detergents, harsh surfactants and synthetic fragrances. These can cause dry skin and trigger allergies. Soapys Choice will leave your pup clean, fresh-smelling and huggable. Its made with the same gentle, wholesome base oils as our people soaps and guaranteed not to irritate a dogs sensitive skin. Soapys Choice is scented with canine-friendly essential oils: lavender, peppermint, cedarwood, tea tree, lemon eucalyptus and geranium. We add moisturizing jojoba and neem oils, emollients that assure a clean, healthy, shiny coat. How to use Soapys Choice Rub the wet bar over your dogs wet coat. Work up a lather and massage the suds into the fur. Avoid soap in the eyes or deep in the ears. Rinse thoroughly. Repeat the wash and rinse if you like. Stand back for the shake-off, then towel dry.	Soapy's Choice dog shampoo, dog bathing, dog bath,	Your pet will love Soapy's Choice Dog Shampoo. Perfect for sensitive skin. All natural soap bar, moisturizing, scented only with essential oils. Buy 6 get 1 free.
280	Jojoba mimics sebum, the waxy secretions from human skin. Considered one of the finest moisturizers, it waterproofs and protects your skin from daily irritants. Jojoba absorbs quickly, leaves no oily coating, and contains beneficial Vitamin E (natural tocopherols) and small amounts of phospholipids.	Organic Jojoba Oil	'I love Herbaria Jojoba Oil!' All natural, moisturizing, scented only with essential oils. Buy 6 get 1 free. Healthy for face and body. Over 60 varieties.
336	Simply roll a bit of this minty oil on your forehead, temples and the back of your neck. Goodbye Headache feels warm as you massage it in with your fingertips. Mints have long been used in aromatherapy for headaches, nausea and to refresh nasal sinuses. Jojoba oil enables smooth, easy application and absorbs quickly into the skin. Customers tell us it works. We agree. We don’t recommend Goodbye Headache for migraines because scents may worsen an episode.	Goodbye Headache herbal headache remedy	'I love Goodbye Headache!' Tension headache aromatherapy from essential oils. Buy 6 get 1 free. Free shipping on orders over $60.
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>
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.
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>
5477	Unless you shave with our soaps, you are subjecting your face to an astounding assault of petrochemicals, detergents, preservatives and synthetic fragrances. Ouch! By contrast, the wholesome ingredients in our shave pucks are especially kind to your skin. They are rich with moisturizing emollients and produce slick, cushiony, long-lasting lather. We guarantee you a close, comfortable shave, especially if you follow our suggestions to enjoy the best shave ever. We offer three superb combinations of scent and moisturizer. As in all our products, we use only essential oils for their complex and alluring aromas. Natural clays are added for lubrication and thickness.	shaving soap	"Creamy, quick to lather. Slick, moist work-ability: razor glides over tough to get to places." Moisturizing. Buy 6 get 1 free. We offer 60 soap varieties for face and body.	<span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">3 varieties</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>