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 (403, 237, 235, 404) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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": 4,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (403,237,235,404) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	meta_keywords	meta_description	promo_text
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.
237	After bathing your dog with Soapys Choice shampoo bar, drizzle or spritz some Soapys Apres le Bain moisturizing lotion onto the fur and massage it into his or her coat and skin. You will love the shine it leaves. This all natural balm will scent your dog with pleasantly fragrant canine-friendly essential oils. Kiss, kiss!	Après le Bain, dog deodorant	After bathing your dog with Soapy’s Choice shampoo bar, drizzle a small amount of Soapy's Après le Bain™ moisturizing lotion in your hand and massage it into his or her coat and skin. You’ll love the shine it leaves.
403	These three bars come with our stow n' go case, a remarkably sturdy, reusable, clear plastic clamshell. Use it for travel or storage. It's vented, so soaps dry out between uses.		These bars come with a case for either storage or travel. Our Stow ‘n Go Soap Case is a clear, sturdy, reusable plastic clamshell	<span style="font-size: 14pt; font-family: georgia, palatino, serif; color: #008000;">three varieties </span>
404	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. Soapy's Choice will leave your pup clean, fresh-smelling, and, huggable. It's made with the same gentle, wholesome base oils as our people soaps and guaranteed not to irritate a dog's sensitive skin. Soapy's 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 Soapy's Choice: Rub the wet bar over your dog's 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. Apres le Bain makes pup smell great and moisturizes coat.