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 (
    3983, 3984, 3981, 3985, 3982, 4681, 4683, 
    4679, 4685, 4677, 4682, 4678, 4680, 
    4684, 4451
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00034

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": 15,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (3983,3984,3981,3985,3982,4681,4683,4679,4685,4677,4682,4678,4680,4684,4451)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	full_description	search_words
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
4451		PMAD4121A, XPR 7350 Antenna, XPR 7550 Antennas
4677	<p>This is a VHF/GPS helical antenna for the 144-165 MHz range.</p><p>Note the XPR3000 series (3300, 3500) radios do not have GPS capability, but still use this antenna. Also compatible with XPR7350, XPR7380, XPR7550, XPR7580.</p>	XPR 3300 Antenna, XPR 3500 Antenna, XPR 7350 Antenna, XPR 7550 Antennas, XPR3300e, XPR3500e
4678	<p>This is a VHF/GPS helical antenna for the 136-155 MHz range.</p><p>Note the XPR 3000 series radios do not have GPS capability, but still use this antenna.</p>	XPR 3300 Antenna, XPR 3500 Antenna, XPR 7350 Antenna, XPR 7550 Antennas
4679	<p>This is a VHF/GPS helical antenna for the 152-174 MHz range. </p><p>Note the XPR 3000 series radios do not have GPS capability, but still use this antenna. </p>	XPR 3300 Antenna, XPR 3500 Antenna, XPR 7350 Antenna, XPR 7550 Antennas, XPR3300e, XPR3500e, MOTOTRBO R7, MOTOTRBO R7 antenna, R7 antenna, VHF antenna for R7, R7 VHF, VHF R7
4680	<p>VHF/GPS combination stubby antenna for the 136-148 MHz range. Stubby antennas are ideal when the radio is worn on the belt as they are short and unobtrusive. </p><p> XPR 7000 and XPR 3000 series stubby antennas provide improved range and performance over XPR 6000 series stubby antennas. </p><p> Note XPR 3000 radios do not have GPS capability, but still use these antennas. </p>	XPR 3300 Antenna, XPR 3500 Antenna, XPR 7350 Antenna, XPR 7550 Antennas
4681	<p>VHF/GPS combination stubby antenna for the 146-160 MHz range. Stubby antennas are ideal when the radio is worn on the belt as they are short and unobtrusive. </p><p>Compatible with the XPR6000, XPR7000e and XPR3000e </p><p> Note XPR 3000 radios do not have GPS capability, but still use these antennas. </p>	XPR 3300 Antenna, XPR 7350 Antenna, XPR 3500 Antenna, XPR 7550 Antennas
4682	<p>UHF/GPS combination stubby antenna for the 403-450 MHz range. Stubby antennas are ideal when the radio is worn on the belt as they are short and unobtrusive. </p><p> XPR 7000 and XPR 3000 series stubby antennas provide improved range and performance over XPR 6000 series stubby antennas. </p><p> Note XPR 3000 radios do not have GPS capability, but still use these antennas. </p>	XPR 3300 Antenna, XPR 7550 Antenna, XPR 7350 Antenna, XPR 3500 Antennas, XPR3300, XPR7550, XPR7350, XPR3500
4683	<p>UHF/GPS combination stubby antenna for the 440-490 MHz range. Stubby antennas are ideal when the radio is worn on the belt as they are short and unobtrusive.</p><p> XPR 7000 and XPR 3000 series stubby antennas provide improved range and performance over XPR 6000 series stubby antennas.</p><p> Note XPR 3000 radios do not have GPS capability, but still use these antennas.</p>	XPR 3300 Antenna, XPR 3500 Antenna, XPR 7350 Antenna, XPR 7550 Antennas, XPR3300e stubby, XPR3500e stubby, UHF stubby, XPR3300 UHF stubby, XPR3500 UHF stubby, XPR7350e stubby, XPR7550e stubby
4684	<p>UHF/GPS combination stubby antenna for the 470-512 MHz range. Stubby antennas are ideal when the radio is worn on the belt as they are short and unobtrusive.</p><p> XPR 7000 and XPR 3000 series stubby antennas provide improved range and performance over XPR 6000 series stubby antennas.</p><p> Note XPR 3000 radios do not have GPS capability, but still use these antennas.</p>	XPR 3300 Antenna, XPR 3500 Antenna, XPR 7350 Antenna, XPR 7550 Antennas
4685	<p>This is a UHF/GPS combination whip antenna for the 403-527 MHz range. This wideband antenna provides coverage across entire UHF frequency band and provides range equivalent to the XPR 6000 whip antennas.</p><p> Note the XPR3000 series radios do not have GPS capability, but still use this antenna.</p>	XPR 3300 Antenna, XPR 3500 Antenna, XPR 7350 Antenna, XPR 7550 Antennas, XPR3300e, XPR3500e