SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    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 (5112, 4936, 4933, 4937, 4935, 4910) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00022

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 6,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (5112,4936,4933,4937,4935,4910)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
4910 <p>Standard battery for the XPR3000e and XPR7000e Series . </p> PMNN4491A, XPR3300e, XPR3500e, XPR 3300, XPR 3500, PMNN4491B, PMNN-4491, XPR7350, XPR7550, XPR7380, XPR7580, XPR 7300, XPR 7350, XPR 7380, XPR 7550, XPR 7580
4933 xpr 3300 battery, xpr 3500 battery, xpr 7350 battery, xpr 7550 battery, xpr 7380 battery, xpr 7580 battery, xpr3300 battery, xpr3500 battery, xpr7350 battery, xpr7550 battery, xpr7380 battery, xpr7580 battery
4935 <p>TIA (Intrinsically Safe) IMPRES Low Volt 2900 mAh - TIA4950 / UL Approved for XPR3000e Series </p> PMNN4490A, PMNN4490B, PMNN-4490, PMNN-4490A, PMNN-4490B, PMNN4490IS, XPR3300e, XPR3500e, XPR 3300, XPR 3500, XPR3300e, XPR3500e, XPR3300 IS battery, XPR3500 IS battery
4936 <p>High capacity 3000 mAh IMPRES Li-Ion battery for XPR3000e, XPR7000e Series. IP68 rated. </p> XPR3300e, XPR3300, XPR3500e, XPR3500, XPR7350, XPR 7350, XPR7550, XPR 7550, XPR 7380, XPR7380, XPR 7580, XPR7580, high cap battery, high cap batteries
4937 <p>Motorola PMNN4525 - IMPRES 1950 mAh battery Submersible (IP68), -30ºC rated </p>
5112 <p>Motorola OEM IMPRES 2450 mAh Li-Ion IP68 battery for XPR3000, XPR7000 Series radios. Replaced the PMNN4409 battery. </p>