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 (
    4024, 4020, 4028, 4037, 4019, 4029, 4036, 
    4025, 4042, 4026, 4045, 4038, 4046, 
    4040, 4039, 4022, 4021, 4041
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00032

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 (4024,4020,4028,4037,4019,4029,4036,4025,4042,4026,4045,4038,4046,4040,4039,4022,4021,4041)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	search_words
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
4021	<p>Durable, 2.5-inch swivel belt loop. </p>	CP200d Case
4022	<p>The Motorola 4280483B04 is a genuine replacement 3" swivel belt loop with a D-lock base compatible with the CP200d. It allows the user to replace any old and broken belt loops and attach any carry case to it.</p>	CP200d Case, CP200d belt loop, CP-200d case, CP-200d belt loop, CP200d swivel
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
4025	<p>3" Spring Action Belt Clip </p>	CP200 Case, CP200d Case, CP200XLS Cases
4026	<p>This nylon carrying case with fixed belt loop fits all battery sizes. The nylon case is flexible, lightweight and durable enough to withstand busy work days. The belt loop features a "D" ring that allow the case to be attached to a carrying strap. Compatible with the following radios: CP150, CP200, CP200D, EP450, HT1250, HT750, MTX8250, MTX8250-LS, PR400, PR860, PRO5150, PRO5350, PRO7150, PRO7350, PRO7550 </p>	HLN9701A, CP185 Case, CP200 Case, CP200d Case, CP200XLS 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
4038	<p>Add protection to your radio while you carry it in comfort. Constructed of top-grain leather designed to withstand your busy work days, this case has a 3" fixed belt loop, includes a D-ring to attach a strap for additional carrying flexibility and fits non-display radio models. </p>	CP200 Case, CP200d Cases, CP200d leather case, CP200d case, CP200 leather case
4039	<p>Hard Leather Case with 2.5" Swivel Belt Loop and D-rings </p>	RLN5384A, CP200 Case, CP200d Cases
4040	<p>Add protection to your radio while you carry it in comfort. Constructed of top-grain leather designed to withstand your busy work days, this case has a 3" belt loop, includes a D-ring to attach a strap for additional carrying flexibility and fits non-display radio models. </p>	RLN5385A, CP200d Case, CP200XLS Cases
4041	<p>This is a replacement T-Strap for Motorola Original leather cases. </p>	CP200d Case
4042	<p>2" Spring Action Belt Clip </p>	CP200 Case, CP200d Case, CP200XLS Cases
4045	<p>This portable radio hanger slides over and hangs from the vehicle door panel allowing convenient, easy mounting. This portable radio hanger is for door panels up to 2.75 inches. A radio belt clip required. </p>	CP200 Case, CP200d Case, CP200XLS Cases
4046	<p>This portable radio hanger slides over and hangs from the vehicle door panel allowing convenient, easy mounting. This portable radio hanger is for door panels from 2.75 to 3.25 inches. A radio belt clip required. </p>	CP200 Case, CP200d Case, CP200XLS Cases