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 (3478, 370, 68, 294, 5476, 383) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00047

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": 6,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (3478,370,68,294,5476,383) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	meta_keywords	meta_description	search_words	promo_text
68	Indonesian Safflower makes people crazy. In addition to the lovely safflower blossoms scattered throughout the bar, it contains a heady blend of sweet basil, ylang ylang, vetiver and patchouli. It's our strongest scented soap. After a bath with this, you'll be looking for your sari. Basil oil is said to aid concentration and clarify the mind and ylang ylang is reputed to stimulate the senses and induce feelings of well-being. You will definitely feel altered after an experience with this bar.	Indonesian Safflower 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.
294	The bright yellow color of our Saffron Gold comes from Spanish saffron. You can see its yellow-orange threads throughout the bright yellow bar. This treasured spice in the soap adds a sensuous scent to the citrusy blend of nine essential oils. This soap not only looks and smells good, its also really good for you. Saffron Gold is superfatted with mango butter, expeller pressed from the seeds of mangos. The butter softens, soothes and moisturizes dry skin. Saffron is one of the plants used to dye the robes of Buddhist monks. If you see a bit of yellow on your washcloth, try laundering it with oxygen bleach.	Saffron Gold soap	"I love this fragrant soap!" With moisturizing mango butter. Buy 6 get 1 free. Over 60 varieties healthy for face and body.
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
383	Raise a bar of Tutti Frutti to your nose and sniff like a wine connoisseur or, if you prefer, a puppy. You will detect notes of banana, strawberry, cherry, grape, orange, lemon, mango, papaya, jackfruit, honeydew. Keep sniffing, and you may discover more. Remarkably we have created this fresh scent using entirely essential oils. There are no essential oils of banana, strawberry, grape, or mango. Our devoted customers know that we never use synthetic fragrance oils to scent our products. A mix of dried blueberries and raspberries make a fully textured bar. To superfat the bar, we add apricot kernel oil.	Tutti Frutti soap	'I love this soap!' yummy fruit scent. With moisturizing apricot oil. Buy 6 get 1 free. Over 60 varieties healthy for face and body.
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>
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>