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, 85) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00050

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 (3478,370,85) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	meta_keywords	meta_description	promo_text
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.
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
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>