Sandbox

SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (
    4725, 4735, 4024, 4020, 4028, 4037, 4019, 
    4029, 4036, 4742, 4744, 4743, 4741, 
    4904, 4502, 4501, 4504, 4503
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00027

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_ult_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id", "company_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 18,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.product_id in (4725,4735,4024,4020,4028,4037,4019,4029,4036,4742,4744,4743,4741,4904,4502,4501,4504,4503)",
      "attached_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	search_words
4501	<p>Carrying cases are available in sizes designed to fit your radio and battery and permit audio to be heard clearly. This nylon case with 3-inch fixed belt loop is designed for the XPR 6000 series of non-display radios. Belt loop and nylon cases feature "D" rings that allow the cases to be attached to a carrying strap.</p>	PMLN5024A, XPR 6100 Case, XPR 6380 Cases
4503	<p>Carrying cases are available in sizes designed to fit your radio and battery and permit audio to be heard clearly. This hard leather case with 3-inch swivel belt loop is designed to work with the XPR 6000 series of non-display radios. Swivel model cases secure to a belt loop and allow the case to swing freely from side to side. The swivel latch system also allows the radio and case to be removed from the belt loop by simply inverting the case and lifting it up and out of the belt loop.</p>	PMLN5029A, XPR 6100 Case, XPR 6380 Cases
4504	<p>Carrying cases are available in sizes designed to fit your radio and battery and permit audio to be heard clearly. This hard leather case with 3-inch fixed belt loop is designed to work with the XPR 6000 series of non-display radios. Belt loop and nylon cases feature "D" rings that allow the cases to be attached to a carrying strap.</p>	PMLN5030A, XPR 6100 Case, XPR 6380 Cases