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 (
    4745, 4938, 4760, 4747, 4746, 4748, 4750, 
    4749, 4939, 6041, 4911, 4306
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00025

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": 12,
      "filtered": 100,
      "index_condition": "cscart_ult_product_descriptions.product_id in (4745,4938,4760,4747,4746,4748,4750,4749,4939,6041,4911,4306)",
      "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
4748 <p>This module is compatible with the standard IMPRES Multi-Unit Charger WPLN4108BR, WPLN4109BR and WPLN4110BR. Up to 6 modules can be used per charger, one for each charging pocket. Includes detailed installation instructions.</p> RLN5382A, RLN5382B, APX 1000 Charger, APX 3000 Charger, APX 4000 Charger, APX 4000XE Charger, APX 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE XPR 3300 Charger, XPR 3500 Charger, XPR 6100 Charger, XPR 6350 Charger, XPR 6380 Charger, XPR 6550 Charger, XPR 6580 Charger, XPR 7350 Charger, XPR 7380 Charger, XPR 7550 Charger, XPR 7580 Chargers