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, 4692, 4696, 4694, 4695, 4693, 5025, 
    4302, 5019, 5026, 5020, 5027, 5024
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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": 13,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4691,4692,4696,4694,4695,4693,5025,4302,5019,5026,5020,5027,5024)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
4302 <p>APX Clamshell Battery Pack (requires 12 AA Alkaline batteries, not included), Submersible Battery-IP57 </p> APX 6000 Battery, APX 7000XE Battery, APX 7000; 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
4692 <p>The NNTN7033 is a 4100mAh Li-Ion Intrinsically Safe battery. Intrinsically safe batteries can be used in locations where flammable gas, vapors or combustible dust may be present.</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. This rugged battery meets an even more stringent military standard (MIL-STD-810E, Method 512.3 Immersion) allowing it to be submerged in water </p> APX 6000 Battery, APX 7000XE Battery, APX 6000XE Battery, APX 7000; Batteries
4693 <p>The NNTN7035 is a 2000mAh NiMH Intrinsically Safe and Ruggedized PLUS battery. Intrinsically safe batteries can be used in locations where flammable gas, vapors or combustible dust may be present. Ruggedized PLUS batteries meet an even more stringent military standard (MIL-STD-810E, Method 512.3 Immersion) allowing it to be submerged in water for up to 2 hours.</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.</p> APX 6000 Battery, APX 7000XE Battery, APX 6000XE Battery, APX 7000; Batteries
4694 <p><a href="/two-way-radio-accessories/portable-accessories/batteries/apx-6000-en-2/motorola-nntn7035-2000mah-nimh-intrinsically-safe-fm-and-ruggedized-plus-battery/">Replace with NNTN7035A</a></p> APX 6000 Battery, APX 7000XE Battery, APX 7000 Battery, APX 6000XE; Batteries
4695 <p>The NNTN7037 is a robust, durable 2100mAh NiMH 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.</p> APX 6000 Battery, APX 7000XE Battery, APX 6000XE Battery, APX 7000; Batteries
4696 <p>Motorola NNTN8092 IMPRES Li-Ion 2300mAh, Intrinsically Safe Rugged Battery</p><p>The NNTN8092 is a 2300mAh LiIon Intrinsically Safe battery. Intrinsically safe batteries can be used in locations where flammable gas, vapors or combustible dust may be present.</p> APX 6000 Battery, APX 7000XE Battery, APX 7000 Battery, APX 6000XE; Batteries
5019
5020 <p>Replaced the NNTN8930A IMPRES 2 battery. The PMNN4547A is also an IMPRES 2 TIA4950 (IS / FM approved) IP-68 rugged battery for the APX6000 and APX7000 Series radios. The PMNN4547A has a higher capacity (3100 mAH Li-Ion) than the legacy NNTN8930A (2650 mAH Li-Ion). </p> NNTN-8930, PMNN-4547, APX-6000, APX-7000
5024 <p>Motorola OEM 2550 mAh Li-Ion IP68 IMPRES battery for APX6000 and APX7000 Series. </p>
5025 <p><span data-bind="text: label">Chemistry</span>: <span data-bind="text: value">LI-ION 3400 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 2</span></p>
5026 APX6000, APX7000, APX8000, APEX6000, APEX7000, APEX8000, APX6000XE, APX7000XE, APX 6000, APX 7000, APX 8000
5027 <p>5100 mAh, IP68, IMPRES 2 battery for APX 8000, 7000/7000XE, 6000/6000XE, and SRX 2200</p>