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 (4691, 4688, 4687, 4689, 4690) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00025

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": 5,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4691,4688,4687,4689,4690)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
4687 <p>IMPRES Li-ion, 2500 mAh, Submersible (IP67) Battery - TIA4950 / UL Approved </p> APX 1000 Battery, XPR 7580 Battery, XPR 7550 Battery, APX 4000XE Battery, APX 4000 Battery, APX 3000 Battery, XPR 7350 Battery, XPR 7380; Batteries
4688 <p><span data-bind="text: label">Chemistry</span>: <span data-bind="text: value">LI-ION 2800 MAH</span></p><p><span data-bind="text: label">Intrinsic Safety Rating</span>: <span data-bind="text: value">NO RATING</span></p><p><span data-bind="text: label">IP Rating</span>: <span data-bind="text: value">IP68</span></p><p><span data-bind="text: label">Technology</span>: <span data-bind="text: value">IMPRES</span></p> APX 1000 Battery, XPR 7580 Battery, XPR 7550 Battery, APX 4000XE Battery, APX 4000 Battery, APX 3000 Battery, XPR 7350 Battery, XPR 7380; Batteries
4689 <p>The NNTN8128 is a 1900 mAh slim Li-Ion submersible battery. </p><p>IMPRES batteries when used with an IMPRES charger provide automatic, adaptive reconditioning, end-of-life display, and other advanced features. Data is stored in the battery and communicated to the charger via a unique IMPRES communication protocol which is designed to maximize talk time and optimize battery cycle life - all automatically. Automated maintenance and a six-month extended capacity warranty when used with IMPRES chargers. </p> NNTN8128AR, APX 1000 Battery, APX 4000XE Battery, APX 4000 Battery, APX 3000; Batteries, NNTN8128BR, NNTN-8128
4690 <p>The PMNN4424 is a high-capacity, 2300 mAh Li-Ion submersible battery. </p><p>IMPRES batteries when used with an IMPRES charger provide automatic, adaptive reconditioning, end-of-life display, and other advanced features. Data is stored in the battery and communicated to the charger via a unique IMPRES communication protocol which is designed to maximize talk time and optimize battery cycle life - all automatically. Automated maintenance and a six-month extended capacity warranty when used with IMPRES chargers. </p> APX 1000 Battery, APX 4000XE Battery, APX 4000 Battery, APX 3000; Batteries
4691 <p>1800 mAh Li-Ion battery for RLN6544 and RLN6561 wireless speaker microphone. </p> APX 3000 Battery, APX 6000XE Battery, APX 7000 Battery, APX 6000 Battery, APX 4000XE Battery, APX 4000 Battery, APX 3000 Battery, APX 4000 Battery, APX 4000XE Battery, APX 6000 Battery, APX 6000XE Battery, APX 7000 Battery, APX 7000XE Battery, APX 1500 Battery, APX 4500 Battery, APX 6500 Battery, APX 7500 Battery, XPR 4350 Battery, XPR 4380 Battery, XPR 4550 Battery, XPR 4580 Battery, XPR 5350 Battery, XPR 5380 Battery, XPR 5550 Battery, XPR 5580 Battery, APX 7000XE; Batteries