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 (
    4754, 4745, 4938, 4760, 4747, 4746, 4748, 
    4903, 4750, 4749, 4753, 4752
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00027

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": 12,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4754,4745,4938,4760,4747,4746,4748,4903,4750,4749,4753,4752)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
4745 <p>The industry exclusive IMPRES Battery Reader provides IMPRES battery users the ability to access charging, reconditioning and key usage data that can affect overall battery performance. By keeping batteries in peak condition, talk time and cycle life are optimized, reducing battery replacement. Package includes IMPRES Battery Reader, system software, USB cord and adapter inserts for APX Series radios.</p> APX 1000 Charger, APX 3000 Charger, APX 4000 Charger, APX 4000XE Charger, APX 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE Charger, 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
4746 <p>The Charger Interface Unit (CIU) attaches to an IMPRES multi-unit charger to enable the data transfer to IMPRES Fleet Management. This CIU is required for all IMPRES multi-unit chargers that report data to IMPRES Fleet Management. IMPRES dual-unit chargers and IMPRES Battery Data Readers do not require the CIU to interface with IMPRES Fleet Management.</p> APX 1000 Charger, APX 3000 Charger, APX 4000 Charger, APX 4000XE Charger, APX 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE Charger, 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
4747 <p>This single-unit charger interface unit (CIU) attaches to an IMPRES single-unit charger and enables data transfer to the IMPRES Battery Fleet Management System. One CIU must be attached to each IMPRES single-unit charger that reports data to the IMPRES Battery Fleet Management System. Please note that this CIU is NOT compatible with the XTS IMPRES Single-Unit Charger (WPLN4111 or NTN1873). </p> APX 1000 Charger, APX 3000 Charger, APX 4000 Charger, APX 4000XE Charger, APX 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE Charger, 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
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
4749 <p>Rapid-rate, single-unit charging system that allows users to charge batteries on the go in their vehicles. This IMPRES-compatible vehicular charger has full IMPRES charger-to-battery communication capability, but it does not recondition IMPRES batteries due to operational demand in a vehicle. It will indicate when reconditioning is required once the battery is placed in an IMPRES desktop charger, ensuring your battery receives adaptive automatic reconditioning. </p> NNTN7616A, NNTN7616B, NNTN7616C, APX 1000 Charger, APX 3000 Charger, APX 4000 Charger, APX 4000XE Charger, 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
4750 <p>Travel Charger with voltage regulated vehicular charger adapter, custom charger base, mounting bracket, and coil cord </p> APX 1000 Charger, APX 3000 Charger, APX 4000 Charger, APX 4000XE Charger, 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, APX1000, APX3000, APX4000, APX4000XE, XPR3300, XPR3500, XPR6000, XPR6550, XPR6350, XPR6100, XPR6380, XPR6580
4752 <p>This adapter allows users to charge APX 4000 batteries in the existing XTS multi-unit charger (WPLN4111). </p><p>This charger insert is only compatible with chargers that have been loaded with software version 3.4 or greater.</p> APX 1000 Charger, APX 3000 Charger, APX 4000 Charger, APX 4000XE Chargers
4753 <p>This adapter allows users to charge APX batteries in the existing XTS multi-unit charger (WPLN4108 or WPLN4130).</p><p>This charger insert is only compatible with chargers that have been loaded with software version 3.4 or greater.</p> APX 1000 Charger, APX 3000 Charger, APX 4000 Charger, APX 4000XE Chargers
4754 <p>Wireless RSM Vehicular Charger. Compatible with RLN6554.</p> APX 3000 Charger, XPR 5580 Charger, XPR 5580 Charger, XPR 5550 Charger, XPR 5380 Charger, XPR 5350 Charger, XPR 4580 Charger, XPR 4550 Charger, XPR 4380 Charger, XPR 4350 Charger, APX 7500 Charger, APX 6500 Charger, APX 4500 Charger, APX 1500 Charger, APX 7000XE Charger, APX 7000 Charger, APX 6000XE Charger, APX 6000 Charger, APX 4000XE Charger, APX 4000 Charger, APX 3000 Charger, APX 4000 Charger, APX 4000XE Charger, APX 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE Charger, APX 1500 Charger, APX 4500 Charger, APX 6500 Charger, APX 7500 Charger, XPR 4350 Charger, XPR 4380 Charger, XPR 4550 Charger, XPR 4580 Charger, XPR 5350 Charger, XPR 5380 Charger, XPR 5550 Chargers, RLN6554, RLN6554A, RLN-6554, RLN-6554A, PMLN-6716, PMLN-6716A
4760 <p>These brackets enable you to mount your multi-unit charger on the wall. </p> APX 1000 Charger, APX 3000 Charger, APX 4000 Charger, APX 4000XE Charger, APX 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE Charger, 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
4903
4938 <p>PMPN4576A replaced the PMPN4174A.</p> PMPN-4576, PMPN-4174, PMPN4174A, PMPN4174B, PMPN4576B