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, 4028, 4037, 4019, 4027, 4032) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00021

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": 6,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4024,4028,4037,4019,4027,4032)",
      "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
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
4027	<p>Durable, 2-inch belt clip. </p>	CP185 Case
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
4032		CP185 Case
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