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 (
    54, 5474, 345, 56, 59, 280, 73, 76, 82, 
    141, 92
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00048

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": 11,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (54,5474,345,56,59,280,73,76,82,141,92) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	meta_keywords	meta_description	search_words
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.
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.
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
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.
82	The elusive scent of this bar comes from the essential oil of pink grapefruit and makes showering a refreshing, exhilarating experience. Rosehip powder provides gentle exfoliation and natural color. Australian pink clay adds color and creaminess to the lather. Avocado oil superfats the bar to moisturize skin.	Pink Grapefruit soap	'I love this soap!' With moisturizing avocado oil. Buy 6 get 1 free. Over 60 varieties healthy for face and body.
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.
141	Straight from the mountains of Europe comes the essential oil in our irresistible Silver Fir and Lavender. We chose this specific fir from many possible evergreen oils because of its soft, lovely balsam-like fragrance. To fully develop the bouquet of the soap, we added lavender and a touch of cade (Juniperus oxycedrus)—a smoky, cedar-like essential oil we hadnt offered before. We know many people love our Evergreen bar, which LaRee created years ago. It is an extra-exfoliating bar with oatmeal and seaweed. Silver Fir and Lavender is a smooth, creamy bar with French green clay. The clays micro molecules absorb excess oils, toxins and impurities from your skin, help you treat complexion problems, and tone your skin. Almond oil is added for extra moisturizing. You will adore this silvery-green bar.	Silver Fir and Lavender soap	Woody evergreen scent with moisturizing sweet almond oil. Creamy lather. Buy 6 get 1 free. Herbaria offers a spectrum of good face and body soaps plus other personal products you can trust.
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.
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.
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.