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, 315, 236, 305, 70, 5556, 77, 79, 67, 
    83, 86, 85, 5477
  ) 
  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": 13,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (298,315,236,305,70,5556,77,79,67,83,86,85,5477) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	meta_keywords	meta_description	promo_text
67	First you will pick up the scent of freshly squeezed Valencia oranges. Thats the volatile top note of the soaps natural perfume, the initial fragrance that bursts forth. We pair the orange perfectly with base notes from dark, Indonesian patchouli. Mysterious and deep, patchouli lingers to sustain the satisfying experience of this soap. We make it superfatted with plenty of hemp seed oil. Hemp seed oil provides numerous skin friendly benefits. Non-greasy, it contains antioxidants, carotene, Vitamin E and a number of healthy minerals. If you are looking to be knocked out with a powerful patchouli bar, you will want our Patchouli Hemp Seed Oil soap.	Patchouli Orange soap	'I love this vegan soap!' With moisturizing hemp seed oil. Buy 6 get 1 free. 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.
77	We have sold Natural Citronella and Marigold soap for years. With the introduction of our Choice Series, we named our insect repellent soap Campers Choice. We added oatmeal for scrubbing and French green clay for thicker lather. Some customers were so happy with Natural Citronella and Marigold soap they are reluctant to try Campers Choice. For them, we still make the old bar.	Natural Citronella & Marigold soap	Repels mosquitoes, smells nice! Safe, effective with DEET-free blend with lemon eucalyptus, catnip. Buy 6 get 1 free. Free shipping on orders over $60. Over 60 moisturizing varieties healthy for face and body.
79	You may remember patchouli from the hippie craze of the 60s and 70s but this remarkable fragrance has been esteemed for centuries. The deep, earthy, woody scent is treasured because it lingers an extraordinarily long time. Spicy, sensuous, alluring, sometimes considered an aphrodisiac by aromatherapists, patchouli is the powerhouse of our very popular Patchouli Hemp Seed Oil soap. We pack as much patchouli essential oil as we can into our signature all-vegetable soap base. Hemp seed oil is one of natures best moisturizers and doubles with the patchouli to relieve dry, cracked skin. Combined with the exfoliating properties of oatmeal, this bar is the epitome of what soap should be. As an added bonus, its a repellent to insects.	Patchouli Hemp Seed Oil soap	"I love it!" All vegetable, vegan moisturizing bar. Buy 6 get 1 free. Free shipping on orders over $60. Over 60 varieties healthy for face and body.
83	Rosemary has a long history as a favorite fragrance. Some time in the 1300s, it was the key ingredient in the famous perfume, Hungary water. Legend tells of a queen of Hungary, who, wearing the fragrance at the age of 72, captivated the King of Poland in a romantic liaison. For the next 500 years, until the French started producing eau de Cologne in the Eighteenth Century, no other herb enjoyed the popularity of rosemary either as a scent or as a natural remedy. No wonder one of our most beloved soaps is Rosemary. We blend three essential oils to create this scent. It is predominately rosemary but tempered with lavender and softened with rose-like palmarosa. Your skin will love the Rosemary bar as much as your nose. Finely crumbled rosemary leaves add a bit of texture. A healthy dose of hemp seed oil provides a lavish moisturizer.	Rosemary soap	'I love this soap!' With moisturizing hemp seed oil. Buy 6 get 1 free. Over 60 varieties healthy for face and body.
85	The root beer scent, also associated with birch beer and sarsaparilla, comes from essential oil of white birch. The hint of wintergreen is also from birch. Ground sassafras root and bark is added to the bar to lightly exfoliate the skin. The sassafras also makes the bar a lovely purple shade. Like all Herbaria soaps, Sassafras Birch is first and foremost a great soap with terrific lather and moisturizing hemp seed oil.	Sassafras Birch soap	"Smells like root beer!" With moisturizing hemp seed oil. Buy 6 get 1 free. Over 60 varieties healthy for face and body.
86	This popular bar delivers an irresistibly uplifting fragrance that appeals to both women and men. Clary sage essential oil, often used in perfumery, contributes a fresh, earthy scent. Lemongrass essential oil lends its clean, lemony aroma. Additionally, clary sage and lemongrass essential oils are considered natural deodorants. They are excellent alternatives to environmentally unfriendly trichlosan in those heavily marketed antibacterial, detergent bars and body washes. Rest assured, all Herbaria soaps will not only wash away dirt and germs, but leave your skin healthy and well moisturized.	Sage Lemongrass soap	"I love this fragrant fragrance free soap!" With moisturizing hemp seed oil. Buy 6 get 1 free. Over 60 varieties healthy for face and body.
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>
305	This cold-pressed, unrefined hemp seed oil is a nutrient-rich moisturizer. It has a vibrant green color and a pleasant, nutty smell. Use it on the body, face, hands, feet, cuticles and hair. It absorbs quickly and is not greasy. It is also noncomedogenic, meaning it wont clog pores. This pure, natural oil has no added chemicals. To extend shelf life, store in the refrigerator.	hemp seed oil	Nutrient-rich moisturizer rejuvenating for body, face, hands, feet, cuticles, hair. Absorbs quickly, non-greasy, spreads easily. Noncomedogenic.
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.
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>