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 (5474, 303, 73) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00049

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": 3,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (5474,303,73) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
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.
303 Over a decade ago, LaRee DeFreece developed our first soaps. Of all the varieties she created, this pure, unscented Castile soap is still her favorite. She loves the nourishing, moisturizing addition of extra shea butter and avocado oil. LaRee’s Scent Free is also available with ground oatmeal. Oatmeal exfoliates dead skin cells and offers colloidal benefits to further soothe and soften skin. LaRee's Scent Free soap “I love it!' LaRee's Scent Free all natural soap is perfect for face and body. With shea butter and avocado oil. With or without oatmeal. Buy 6 get 1 free. Free shipping on orders over $60. Over 60 varieties healthy for face and body. <p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">with or without </span></p> <p><span style="font-family: georgia, palatino, serif; font-size: 14pt; color: #008000;">oatmeal </span></p>
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.