Sandbox

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, 4760, 4747, 4746, 4748, 4903, 
    4759, 5062, 4756, 4307, 4757, 4755, 
    4758, 5032, 5031
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00035

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": 16,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4754,4745,4760,4747,4746,4748,4903,4759,5062,4756,4307,4757,4755,4758,5032,5031)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	search_words
4307		<p>APX Vehicular Adapter includes fused power cable, 2 keys for the lock, screws for attaching VA to the trunnion & quick start guide. Trunnion mounting bracket NTN8940 must be ordered separately. </p><p>*Radios require firmware version, R13.00.00 or later. Not compatible with VHF radios. </p>	APX 6000 Charger, APX 6000XE Chargers
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
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
4755		<p>This new charger provides public safety personnel the convenience of a spare battery that is charged and ready to be used at all times. The unique dual pocket design allows simultaneous charging of primary and secondary batteries. This charger provides advanced features, including the ability to turn on/off reconditioning, reduced reconditioning time and improved energy efficiency. The display shows critical battery information including: current charge status, battery mAh, voltage, battery kit number, serial number, and chemistry.</p>	APX 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE Chargers
4756		<p>Rapid-rate, single-unit charging system that allows users to charge batteries on the go in their vehicle. This IMPRES-compatible vehicular charger has full IMPRES charger-to-battery communication capability, but 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>	NNTN7624A, NNTN7624B, APX 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE Chargers
4757		<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 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE Chargers
4758		<p>This adapter allows users to charge APX batteries in the existing XTS single-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 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE Chargers
4759	<p>12V DC Travel Charger for APX6000, APX7000</p>		APX 6000 Charger, APX 6000XE Charger, APX 7000 Charger, APX 7000XE Chargers, APX vehicular charger, APX travel charger
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
5031		<p>Charge IMPRES batteries up to 40% faster with this IMPRES 2 multi-unit charger. </p><p><span data-bind="widgetLocaleText: 'dimensions'">Dimensions</span> (<span data-bind="text: msiDimensionUOM.value ? msiDimensionUOM.value : 'IN-Inch'">IN-Inch</span>): <span data-bind="text: value">7.5</span> <span data-bind="widgetLocaleText: 'width'">(W)</span> <span data-bind="text: value">17.5</span> <span data-bind="widgetLocaleText: 'height'">(H)</span> <span data-bind="text: value">10.25</span> <span data-bind="widgetLocaleText: 'length'">(L)</span><br> </p>
5032		<p>115 VAC single unit IMPRES desktop charger for the Motorola APX6000, APX7000, APX8000 Series radios. </p>
5062		<p>Trunnion Mounting Bracket </p>