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 (
    4725, 4735, 4024, 4020, 4028, 4037, 4019, 
    4029, 4036, 4742, 4744, 4743, 4741, 
    4904, 4502, 4501, 4504, 4503
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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": 18,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4725,4735,4024,4020,4028,4037,4019,4029,4036,4742,4744,4743,4741,4904,4502,4501,4504,4503)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
4019 CP200d Case, CP185 Case, XPR6100 Case, XPR6350 Case, XPR6550 Case, XPR6380 Case, XPR6580 Case, XPR3300 Case, XPR3500 Case, XPR7350 Case, XPR7550 Case, XPR7380 Case, XPR7580 Cases
4020 <p>RadioPAk Extension Belt. For waists larger than 40 inches. </p> CP200 Case, CP200XLS Case, CP200d Case, XPR6100 Case, XPR6350 Case, XPR6550 Case, XPR6380 Case, XPR6580 Case, XPR3300 Case, XPR3500 Case, XPR7350 Case, XPR7550 Case, XPR7380 Case, XPR7580 Cases
4024 <p>The Motorola Original Universal Chest Pack protects the radio and provides the freedom from holding it during standby communication mode. The Universal Chest Pack fits virtually any radio and also has a pen holder and velcro secured pouch. </p> CP185 Case, CP200XLS Case, CP200d Case, CP200 Case, XPR6100 Case, XPR6350 Case, XPR6550 Case, XPR6380 Case, XPR6580 Case, XPR3300 Case, XPR3500 Case, XPR7350 Case, XPR7550 Case, XPR7380 Case, XPR7580 Cases
4028 <p>This waterproof bag fits any Motorola two-way radio and includes a convenient carrying strap. </p> HLN9985A, CP185 Case, CP200XLS Case, CP200d Case, CP200 Case, XPR6100 Case, XPR6350 Case, XPR6550 Case, XPR6380 Case, XPR6580 Case, XPR3300 Case, XPR3500 Case, XPR7350 Case, XPR7550 Case, XPR7380 Case, XPR7580 Cases
4029 <p>This adjustable, black nylon carrying strap, part of the Motorola Original series, attaches to D-rings on carrying cases. </p> CP200d Case, XPR6100 Case, XPR6350 Case, XPR6550 Case, XPR6380 Case, XPR6580 Case, XPR3300 Case, XPR3500 Case, XPR7350 Case, XPR7550 Case, XPR7380 Case, XPR7580 Cases, NTN-5243, NTN-5243A
4036 <p>This carry pack has all the features of the original Universal Chest Pack plus break-a-way tabs that allow the entire pack to be pulled off with approximately 10 lbs. of pressure. </p> CP200d Case, XPR6100 Case, XPR6350 Case, XPR6550 Case, XPR6380 Case, XPR6580 Case, XPR3300 Case, XPR3500 Case, XPR7350 Case, XPR7550 Case, XPR7380 Case, XPR7580 Cases
4037 CP185 Case, CP200XLS Case, CP200d Case, CP200 Case, XPR6100 Case, XPR6350 Case, XPR6550 Case, XPR6380 Case, XPR6580 Case, XPR3300 Case, XPR3500 Case, XPR7350 Case, XPR7550 Case, XPR7380 Case, XPR7580 Cases
4501 <p>Carrying cases are available in sizes designed to fit your radio and battery and permit audio to be heard clearly. This nylon case with 3-inch fixed belt loop is designed for the XPR 6000 series of non-display radios. Belt loop and nylon cases feature "D" rings that allow the cases to be attached to a carrying strap.</p> PMLN5024A, XPR 6100 Case, XPR 6380 Cases
4502 <p>Carrying cases are available in sizes designed to fit your radio and battery and permit audio to be heard clearly. This hard leather case with 2.5-inch swivel belt loop is designed to work with the XPR 6000 series of non-display radios. Swivel model cases secure to a belt loop and allow the case to swing freely from side to side. The swivel latch system also allows the radio and case to be removed from the belt loop by simply inverting the case and lifting it up and out of the belt loop.</p> PMLN5028A, XPR 6100 Case, XPR 6380 Cases
4503 <p>Carrying cases are available in sizes designed to fit your radio and battery and permit audio to be heard clearly. This hard leather case with 3-inch swivel belt loop is designed to work with the XPR 6000 series of non-display radios. Swivel model cases secure to a belt loop and allow the case to swing freely from side to side. The swivel latch system also allows the radio and case to be removed from the belt loop by simply inverting the case and lifting it up and out of the belt loop.</p> PMLN5029A, XPR 6100 Case, XPR 6380 Cases
4504 <p>Carrying cases are available in sizes designed to fit your radio and battery and permit audio to be heard clearly. This hard leather case with 3-inch fixed belt loop is designed to work with the XPR 6000 series of non-display radios. Belt loop and nylon cases feature "D" rings that allow the cases to be attached to a carrying strap.</p> PMLN5030A, XPR 6100 Case, XPR 6380 Cases
4725 <p>This carrying accessory is a spring-action, 2-inch belt clip for the XPR3000, XPR6000, APX1000, APX4000 Series radios. </p> APX 1000 Case, APX 4000 Case, APX 4000XE Case, XPR 3300 Case, XPR 3500 Case, XPR 6100 Case, XPR 6380 Case, XPR 6550 Case, XPR 6580 Cases, XPR3300e, XPR3500e, XPR6350, XPR6550, XPR6000, XPR6380, XPR6580, XPR7000, XPR7350, XPR7550, XPR7380, XPR7580
4735 APX 4000 Case, APX 4000XE Case, APX 6000 Case, APX 6000XE Case, APX 7000 Case, APX 7000XE Case, XPR 3300 Case, XPR 3500 Case, XPR 6100 Case, XPR 6380 Case, XPR 6550 Case, XPR 6580 Case, XPR 7350 Case, XPR 7380 Case, XPR 7550 Cases
4741 XPR 6100 Case, XPR 6380 Case, XPR 6550 Case, XPR 6580 Case, XPR 7350 Case, XPR 7380 Case, XPR 7550 Cases
4742 XPR 6100 Case, XPR 6380 Case, XPR 6550 Case, XPR 6580 Cases
4743 XPR 6100 Case, XPR 6380 Case, XPR 6550 Case, XPR 6580 Cases
4744 XPR 6100 Case, XPR 6380 Case, XPR 6550 Case, XPR 6580 Cases
4904