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, 4506, 4508, 4507, 4505
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00050

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,4506,4508,4507,4505)",
      "attached_condition": "cscart_ult_product_descriptions.company_id = 1 and cscart_ult_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	meta_keywords	meta_description	search_words	promo_text
4505		<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 display radios. Belt loop and nylon cases feature "D" rings that allow the cases to be attached to a carrying strap.</p>			PMLN5015A, PMLN5015B, XPR 6550 Case, XPR 6580 Cases
4508		<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 display radios. Belt loop and nylon cases feature "D" rings that allow the cases to be attached to a carrying strap.</p>			PMLN5021A, PMLN5021B, XPR 6550 Case, XPR 6580 Cases