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 (370, 295, 82, 227) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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

Result

product_id	short_description	meta_keywords	meta_description
82	The elusive scent of this bar comes from the essential oil of pink grapefruit and makes showering a refreshing, exhilarating experience. Rosehip powder provides gentle exfoliation and natural color. Australian pink clay adds color and creaminess to the lather. Avocado oil superfats the bar to moisturize skin.	Pink Grapefruit soap	'I love this soap!' With moisturizing avocado oil. Buy 6 get 1 free. Over 60 varieties healthy for face and body.
227	This solid bar is perfect for travel because it multitasks as shampoo, face and body soap, and shave cream. Since airline regulations limit liquids in carry-on luggage, you will zip through TSA inspections. Like all of our soaps, Travelers Choice contains no detergents, phthalates or synthetic fragrances. Rosemary and petitgrain create the light fragrance.	Traveler's Choice Shampoo	Solid bar shampoo makes rich lather, leaves hair soft, clean, manageable. No parabens, phthalates, or harsh detergents. “Great for traveling.”
295	Our Pink Grapefruit Eucalyptus bath bomb is so popular we made a soap with the same wonderful aroma. The scent is bright and sweet and captivating. The combination of grapefruit with eucalyptus is magical. We have superfatted this bar with unrefined shea butter for all its healthy, moisturizing power. French pink clay adds extra creaminess to the bar as well as the soft pink color.	Pink Grapefruit Eucalyptus soap	'I love the scent!' Moisturizing with shea butter. Vegan. Buy 6 get 1 free. Healthy for face and body. Over 60 varieties.
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