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 (
    4718, 5006, 4724, 4664, 4665, 4927, 4667, 
    4517
  ) 
  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": 8,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4718,5006,4724,4664,4665,4927,4667,4517)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
4517 <p>Communicate discreetly and easily with this comfortable, flexible fitting earpiece. Includes an inline push-to-talk and microphone for simple, unobtrusive operation. </p> PMLN5958A, SL7550 Headset, SL7580 Headset, SL7590 Headsets/Lapel Mics/Surveillance Kits
4664 <p>Replacement Eartips</p> XPR 5350, XPR 7580, XPR 5380, XPR 5550, XPR 5580, SL7550, XPR 6100, XPR 6350, XPR 6380, XPR 6550, XPR 6580, XPR 7350, XPR 7380, XPR 7550, SL7580, SL7590
4665 <p>Wireless Earpiece, Bluetooth Accessory Kit Multi (Pack of 3 PMLN6397)</p> XPR 5350, XPR 5380, XPR 5550, XPR 5580, SL7550, XPR 6100, XPR 6350, XPR 6380, XPR 6550, XPR 6580, XPR 7350, XPR 7550
4667 <p>Bluetooth Accessory Kit with NA Power Supply </p> XPR 5350, XPR 5380, XPR 5550, XPR 5580, SL7550, XPR 6100, XPR 6350, XPR 6380, XPR 6550, XPR 6580
4718 XPR 6100 Bluetooth Accessory, XPR 7580 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 3000 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory, XPR 7350 Bluetooth Accessory, XPR 7380 Bluetooth Accessory, XPR 7550 Bluetooth Accessory, XPR 7580 Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory, SL7590 Bluetooth Accessory, APX 3000 Bluetooth Accessory, APX 4000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory, SL7590 Bluetooth Accessory, XPR 6100 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory, XPR 7350 Bluetooth Accessory, XPR 7380 Bluetooth Accessory, XPR 7550 Bluetooth
4724 XPR 6100 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory, SL7590 Bluetooth Accessory, SL7550 Bluetooth Accessory, SL7580 Bluetooth Accessory, SL7590 Bluetooth Accessory, XPR 6100 Bluetooth Accessory, XPR 6350 Bluetooth Accessory, XPR 6380 Bluetooth Accessory, XPR 6550 Bluetooth Accessory, XPR 6580 Bluetooth Accessory
4927
5006 <p>Low noise kit with Quick Disconnect translucent tube and clear rubber ear tip.</p>