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 (
    3983, 3984, 3981, 3985, 3982, 4208, 4213, 
    4210, 4211, 4209, 4212
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00026

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": 11,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (3983,3984,3981,3985,3982,4208,4213,4210,4211,4209,4212)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
3981 <p>Colored bands easily slip on antennas and enable you to quickly visually identify custom radio user groups. Each ID band kit is sold in packs of 10. </p> SL300 Antenna, XPR3300 Antenna, XPR7580 Antenna, XPR7380 Antenna, XPR7350 Antenna, XPR3500 Antennas, TLK100, TLK 100
3982 <p>Colored bands easily slip on antennas and enable you to quickly visually identify custom radio user groups. Each ID band kit is sold in packs of 10. </p> SL300 Antenna, XPR3500 Antenna, XPR7580 Antenna, XPR7380 Antenna, XPR7350 Antenna, XPR3300 Antennas, TLK100, TLK 100
3983 <p>Colored bands easily slip on antennas and enable you to quickly visually identify custom radio user groups. Each ID band kit is sold in packs of 10. </p> SL300 Antenna, XPR3300 Antenna, XPR3500 Antenna, XPR7350 Antenna, XPR7380 Antenna, XPR7580 Antennas, TLK100, TLK 100
3984 <p>Colored bands easily slip on antennas and enable you to quickly visually identify custom radio user groups. Each ID band kit is sold in packs of 10. </p> SL300 Antenna, XPR3300 Antenna, XPR3500 Antenna, XPR7350 Antenna, XPR7380 Antenna, XPR7580 Antennas, TLK100, TLK 100
3985 <p>Colored bands easily slip on antennas and enable you to quickly visually identify custom radio user groups. Each ID band kit is sold in packs of 10. </p> SL300 Antenna, XPR3300 Antenna, XPR3500 Antenna, XPR7350 Antenna, XPR7380 Antenna, XPR7580 Antennas, TLK100, TLK 100
4208 PMAD4144A, SL300 Antenna
4209 PMAD4145A, SL300 Antenna
4210 PMAD4146A, SL300 Antenna
4211 PMAE4093A, SL300 Antenna
4212 PMAE4094A, SL300 Antenna
4213 <p>435-470 MHz UHF stubby antenna for SL300.</p> PMAE4095A, SL300 Antenna, PMAE-4095, PMAE-4095A, PMAE-4095B, PMAE4095B