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 (
    4434, 4681, 4432, 4438, 4433, 4435, 4437, 
    4436, 4441, 4430, 4440, 4450, 4439, 
    4442, 4429, 4431, 4916
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00035

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": 17,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (4434,4681,4432,4438,4433,4435,4437,4436,4441,4430,4440,4450,4439,4442,4429,4431,4916)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
4429 <p>Optimum length antenna, designed for higher gain to maximize range. This rugged, stylish, capless design provides maximum flexibility and built-in capability to operate at GPS frequencies.</p> PMAD4067A, PMAD4067B, XPR 6100 Antenna, XPR 6350 Antenna, XPR 6550 Antennas
4430 <p>Optimum length antenna, designed for higher gain to maximize range. This rugged, stylish, capless design provides maximum flexibility and built-in capability to operate at GPS frequencies.</p> PMAD4068A, PMAD4068B, XPR 6100 Antenna, XPR 6550 Antenna, XPR 6350 Antennas
4431 <p>Optimum length antenna, designed for higher gain to maximize range. This rugged, stylish, capless design provides maximum flexibility and built-in capability to operate at GPS frequencies.</p> PMAD4069A, PMAD4069B, XPR 6100 Antenna, XPR 6550 Antenna, XPR 6350 Antennas
4432 PMAD4088A, XPR 6100 Antenna, XPR 6350 Antenna, XPR 6550 Antennas, APX7000 VHF antenna, APX7000 VHF antennas, APX7000, APX7000XE, APX 7000 antenna, APX 7000XE antenna, APX7000 VHF, APX 7000 VHF, APX7000XE VHF, APX 7000XE VHF
4433 <p>VHF stubby antenna for the 136-147 MHz range. This 11cm stubby antenna is ideal when the radio is worn on the belt as it is short and unobtrusive.</p> XPR 6100 Antenna, XPR 6550 Antenna, XPR 6350 Antennas
4434 <p>VHF stubby antenna for the 147-160 MHz range. This 11cm stubby antenna is ideal when the radio is worn on the belt as it is short and unobtrusive.</p> XPR 6100 Antenna, XPR 6550 Antenna, XPR 6350 Antennas
4435 <p>VHF stubby antenna for the 160-174 MHz range. This 11cm stubby antenna is ideal when the radio is worn on the belt as it is short and unobtrusive.</p> XPR 6100 Antenna, XPR 6350 Antenna, XPR 6550 Antennas
4436 <p>UHF/GPS combination stubby antenna for the 403-433 MHz range. This 9cm stubby antenna is ideal when the radio is worn on the belt as it is short and unobtrusive. Compatible with the XPR6000 Series radios.</p> PMAE4021A, XPR 6100 Antenna, XPR 6550 Antenna, XPR 6350 Antennas
4437 <p>UHF/GPS combination stubby antenna for the 430-470 MHz range. This 9cm stubby antenna is ideal when the radio is worn on the belt as it is short and unobtrusive.</p> PMAE4023A, XPR 6100 Antenna, XPR 6550 Antenna, XPR 6350 Antennas
4438 <p>UHF/GPS combination whip antenna for the 430-470 MHz range. Antenna designed to maximize range. A rugged, capless design provides maximum flexibility and built-in capability to access a GPS signal. Compatible with the XPR6000 Series radios.</p> PMAE4024A, XPR 6100 Antenna, XPR 6350 Antenna, XPR 6550 Antennas
4439 <p>UHF/GPS combination stubby antenna for the 450-512 MHz range. This 9cm stubby antenna is ideal when the radio is worn on the belt as it is short and unobtrusive.</p> XPR 6100 Antenna, XPR 6550 Antenna, XPR 6350 Antennas
4440 <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 6100 Antenna, XPR 6350 Antenna, XPR 6550 Antennas
4441 <p>UHF/GPS combination whip antenna for the 450-495 MHz range. Antenna designed to maximize range. A rugged, capless design provides maximum flexibility and built-in capability to access a GPS signal.</p> XPR 6100 Antenna, XPR 6550 Antenna, XPR 6350 Antennas
4442 <p>UHF/GPS combination whip antenna for the 495-527 MHz range. Antenna designed to maximize range. A rugged, capless design provides maximum flexibility and built-in capability to access a GPS signal.</p> XPR 6100 Antenna, XPR 6350 Antenna, XPR 6550 Antennas
4450 <p>UHF wideband flexible whip antenna for the 403-470 MHz range. This 16 cm antenna has a one-piece finish, steel core, and sprial wound counductor for optimal radiation characteristics.</p> PMAE4022A, XPR 6550 Antenna, XPR 6350 Antenna, XPR 6100 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
4916 PMAE4018A,