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 (
    5473, 345, 56, 374, 370, 5476, 382, 92
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00064

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": 8,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (5473,345,56,374,370,5476,382,92) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
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.
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.
370 Because you asked, we now sell 45 of the same pure essential oils we use to scent our soaps and other products. They come in half-ounce and one-ounce amber glass bottles with screw caps. Select them from the dropdown list. Over the past dozen years, we have established reliable suppliers of quality oils from all over the world. Because we purchase in bulk, we can offer smaller quantities to you at a good price. bottled natural essential oils
374 Here are six to twelve of our most popular essential oils. These are the same pure essential oils we use to scent our soaps and other products. You'll find many enjoyable uses for these. essential oils Here are six of our most popular essential oils. These are the same pure essential oils we use to scent our soaps and other products. You'll find many enjoyable uses for these.The set contains 10ml (.34 oz) of Eucalyptus (Eucalyptus globulus), Lavender
382 Discover the scents you prefer of Citrus, Lavender, Rosemary Mint, and Tea Tree. Shampoo Cutie Bundles are available with packets of just 4 cuties, all of the Finer Formula Cuties or all of the Thicker Formula Cuties. shampoo soap samples sizes Herbaria Shampoo Cutie Bundles - All Natural - Essential Oils <span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">Finer or Thicker, all four scents</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.&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>
5476 Herbaria Shampoo Bars produce abundant creamy lather to gently but thoroughly cleanse your hair and leave it soft, shiny, and easy to manage. Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy. shampoo soap bars Our Shampoo bars are handmade with moisturizing, food-grade vegetable oils and rich emollients to keep your hair and scalp healthy. bar shampoo, natural shampoo, bar shampoo <p><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">two formulas, four</span><span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;"> scents</span></p>