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 (
    3675, 392, 3785, 393, 4990, 6211, 4989, 
    7905
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 8,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (3675,392,3785,393,4990,6211,4989,7905) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
392 <ul><li>· Submersible IPX8 / 1.5M (4.92Ft) for 30 minutes</li><li>· Selectable 5 or 1 Watt transmit power output</li><li>· Supplied with 2550 mAh Li-Ion battery, AC and DC 3-hour quick chargers</li><li>· Built-in noise Cancelling Microphone and Voice Scrambler for clear and private communications</li><li>· 40 Programmable Land Mobile Channels 134 MHz to 174 MHz with CTCSS and DCS</li><li>· Programmable channel names</li><li>· NOAA Weather channels and Weather Alert</li><li>· Low battery indicator</li><li>· All USA, International and Canadian Marine Channels</li><li>· Optional speaker microphones and headsets available</li><li>· Programmable Scan, Priority Scan and Dual Watch</li><li>· Preset key used to recall up to 10 favorite channels</li><li>· Key lock</li></ul>
393 <ul><li>Intrinsically safe</li><li>Submersible IPX8 (4.92 feet or 1.5 meters for 30 minutes)</li><li>Selectable 5 or 1 Watt transmit power output</li><li>Noise Cancelling Microphone</li><li>40 Programmable Land Mobile Channels 134 MHz to 174 MHz with CTCSS and DCS signaling</li><li>Programmable channel names</li><li>NOAA Weather channels and Weather Alert</li><li>Low battery indicator</li><li>Built in Voice Scrambler for private communications</li><li>All USA, International and Canadian Marine Channels</li><li>Optional speaker microphones and headsets available</li><li>Supplied with 2300mAh Li-Ion battery, and 110 VAC 3-hour quick charger</li><li>Programmable Scan, Priority Scan, Tri-watch and Dual Watch</li><li>Preset key used to recall up to 10 favorite channels</li><li>Key lock</li><li>3 Year Waterproof Warranty</li></ul>
3675 <p>Submersible 5 Watt Handheld Commercial VHF with LMR Channels</p><p style="margin-top: 0px; margin-bottom: 1rem; color: rgb(0, 0, 0); font-family: Roboto, sans-serif; font-size: 16px; background-color: rgb(255, 255, 255);">Features:</p><ul><li>40 Programmable Land Mobile Channels 134 MHz to 174 MHz with CTCSS and DCS signaling</li><li>Supplied with a 1750mAh Lithium-ion battery, 110 VAC and 12 VDC chargers and a charging cradle</li><li>Submersible IPX7 (3.3 feet for 30 minutes)</li><li>Selectable 5 and 1 Watt transmit power output</li><li>700 mW Loud speaker audio</li><li>Battery life indicator</li><li>All USA, International and Canadian Marine Channels</li><li>Programmable Scan, Priority Scan and Dual and TRI Watch</li><li>NOAA Weather channels and Weather Alert</li><li>Programmable channel names</li><li>Preset key used to recall up to 10 favorite channels</li><li>Optional speaker microphones and headsets available</li><li>Optional FBA-40 Alkaline Battery tray available</li><li>3 Year Waterproof Warranty Country of Origin: Japan</li></ul>
3785 <p><strong>6W Compact Floating Marine Handheld Transceiver</strong> </p><ul> <li>Floating / Submersible IPX7 waterproof rating (3.3 feet or 1 meter for 30 minutes)</li> <li>All USA, International, and Canadian channels</li> <li>Selectable 6W / 2.5W / 1W output power</li> <li>Receive WX and FM broadcast 76-108MHz</li> <li>High resolution Dot Matrix LCD</li> <li>E2O Easy to Operate menu system</li> <li>Programmable Function Keys</li> <li>Speaker Mic Jack</li> <li>High capacity 1800 mAh Li-Ion battery</li> <li>3 Hour desktop rapid charger</li> <li>3 Year Waterproof Warranty</li> </ul><p><strong>Compact Case Design</strong><br> Compact, ergonomic case design is a result of the new internal, large capacity 1850 mAh Lithium Ion battery technology. This gives the radio a much smaller case design yet light enough to float face up if dropped in the water </p><p><strong>Water Activated Emergency Strobe light</strong><br> If the radio falls in the water an emergency strobe light is automatically activated, even when the unit is turned off!!! The strobe can be reconfigured to flash on and off, flash SOS, or set to stay on continuously. </p><p><strong>Oversized full dot matrix display</strong><br> The HX210 boasts one of the largest displays in a compact and affordable handheld VHF. With a larger display, greater (dot matrix) resolution, and a super bright backlight there will be no mistaking the information displayed on the face of the radio day or night. </p><p><strong>E20 Easy to Operate Menu System</strong><br> New intuitive menu system allows easy access to all of the setup functions of the radio, making it easy to customize settings based on the preferences of the user </p><p><strong>Built in FM Broadcast band receive</strong><br> The HX210 has an expanded receiver allowing the user to tune in to their favorite FM radio station. The radio will receive FM broadcast bands between 76 MHz to 108 MHz. </p><p><strong>3-year Waterproof Warranty</strong><br> Because the HX210 is built better, it’s backed better. If your Standard Horizon HX210 ever fails for any reason including water damage during normal use in the first three years, STANDARD HORIZON will repair or replace it free, without hassle or charges…period! If it fails thereafter in normal use it is covered by Standard Horizon’s Flat Rate Service Program. </p>
4989 <p><strong>Features</strong></p><ul> <li>Floating (When fitted into the optional flotation case SHC-29*)</li> <li>Ultra Compact case design: 2.05"W × 3.74"H × 1.3"D</li> <li>6W transmit power output (Selectable 6/2.5/1W)</li> <li>600mW Loud Audio Output</li> <li>Preset key used to recall up to 10 favorite channels</li> <li>Easy to Operate Menu System</li> <li>Scanning operation and Multi-Watch (Dual Watch and Triple Watch)</li> <li>CH16/S Quick Access (S: Sub-channel)</li> <li>Built-in Lithium Polymer Battery Pack (7.4V, 1850mAh)</li> <li>NOAA Weather Channels with Weather Alert</li> <li>FM Broadcast Radio Receiver</li> <li>3 Year Waterproof Warranty</li> </ul><p><strong>Ultra Compact Case Design</strong><br> Measuring 2.05" W x 3.74" H x 1.3" D the new HX40 is about the size of a deck of playing cards. Making this portable radio easy to fit just about anywhere.</p><p><strong>Better Resolution (Dot Matrix) Display</strong><br> The HX40 comes with a very visible Dot Matrix display with a very clear, very bright fully backlit display.</p><p><strong>E2O Easy to Operate Menu System</strong><br> New intuitive menu system allows easy access to all of the setup functions of the radio, making it easy to customize settings based on the preferences of the user</p><p><strong>Built in FM Broadcast band receive</strong><br> The HX40 has an expanded receiver allowing the user to tune in to their favorite FM radio station. The radio will receive FM broadcast bands between 76 MHz to 108 MHz.</p><p><strong>3-year Waterproof Warranty</strong><br> Because the HX40 is built better, it’s backed better. If your Standard Horizon HX40 ever fails for any reason including water damage during normal use in the first three years, STANDARD HORIZON will repair or replace it free, without hassle or charges…period! If it fails thereafter in normal use it is covered by Standard Horizon’s Flat Rate Service Program.</p>
4990 <table border="0" cellpadding="0" cellspacing="0" width="364" style="width: 273pt;"><tbody><tr height="17" style="mso-height-source:userset;height:12.75pt"> <td height="17" class="xl66" width="364" style="height:12.75pt;width:273pt">6W Handheld VHF Class H DSC with Bluetooth, GPS, FM radio receiver, built in scrambler</td></tr></tbody></table> HX890B, HX890BK, HX-890B, HX-890, HX-891, HX-891B, HX891BT, HX891B
6211 <p>NEW! HX320 6W Marine Handheld VHF with Bluetooth & USB-C Charging</p><p>Comes with a 3 year waterproof warranty</p> HX300, HX-300, HX-320, marine bluetooth radio, bluetooth marine radio, bluetooth marine portable, bluetooth marine handheld
7905 <table border="0" cellpadding="0" cellspacing="0" width="364" style="width: 273pt;"><tbody><tr height="17" style="mso-height-source:userset;height:12.75pt"> <td height="17" class="xl66" width="364" style="height:12.75pt;width:273pt">Navy Blue 6W Handheld VHF Class H DSC with Bluetooth, GPS, FM radio receiver, built in scrambler</td></tr></tbody></table> HX890, HX890NB, HX-890B, HX-890, HX-891, HX-891B, HX891BT, HX891NB, HX-891BTNB