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 (
    4714, 4773, 4762, 4769, 4763, 4761, 4770, 
    4764, 4771, 4768, 4767, 4765, 4766
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00030

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": 13,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4714,4773,4762,4769,4763,4761,4770,4764,4771,4768,4767,4765,4766)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
4714 <p>Ear Straps (qty 10) for secure attachment to the ear</p> 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, APX 4000 Bluetooth Accessory, APX 3000 Bluetooth Accessory, APX 4000XE Bluetooth Accessory, APX 6000 Bluetooth Accessory, APX 6000XE Bluetooth Accessory, APX 7000 Bluetooth Accessory, APX 7000XE Bluetooth Accessory
4761 APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE
4762 APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE
4763 <p>Replacement Ring PTT Cable for NTN1663 & NTN1724 & RLN6483</p> APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE
4764 <p>Add a spare for extra preparedness or replace your CommPort Integrated Microphone/Receiver System earpiece. This replacement accessory helps you get the most out of your device.</p> NTN8819A, APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE
4765 <p>Integrated Ear Microphone/Receiver System with Palm PTT (Includes adapter BDN6783) </p> APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE
4766 <p>Integrated Ear Microphone/Receiver System with PTT on Adapter (Includes adapter BDN6783) </p> APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE
4767 APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE
4768 <p>Integrated Ear Microphone/Receiver System with Ring PTT (Includes adapter BDN6783) </p> APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE
4769 <p>Integrated Ear Microphone/Receiver System with Body PTT (Includes adapter BDN6783) </p> APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE
4770 <p>Replacement Cable for NTN1722 & NTN1625 & RLN6481</p> APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE
4771 APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE
4773 <p>Replacement Remote PTT Body Switch for NNTN4186A and RLN6484</p><p>Replace or add this cable to your CommPort Remote PTT Body Switch device to extend the life of your microphone/receiver system.</p> APX 3000, APX 4000, APX 4000XE, APX 6000, APX 6000XE, APX 7000, APX 7000XE