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, 4025, 4042, 4026, 
    4045, 4046, 4040
  ) 
  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": 10,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4024,4020,4028,4037,4025,4042,4026,4045,4046,4040)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	search_words
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
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
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
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
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