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 (6048, 3759, 2761, 3753, 2760, 7936) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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": 6,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (6048,3759,2761,3753,2760,7936) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description	search_words
2760	<p>5W Airband Handheld with an ILS and VOR Navigation Display, 200 memory channels, NOAA WX alert/receive, IPX5 rating, AA alkaline battery tray</p>		FTA-550, FTA550, FTA550AA, FTA-550AA, FTA-550 AA
2761	<p>5W Airband Handheld with an ILS and VOR Navigation Display, 200 memory channels, NOAA WX alert/receive, IPX5 rating, 1800 mAh Li-Ion battery</p>		FTA550, FTA-550, FTA-550L, FTA550L
3753	<p>Yaesu FTA-450L 5W Airband VHF handheld (Comm Only w/ 1800 mAh Li-Ion battery)</p>		FTA450, FTA-450, FTA450L
3759		<p>The Yaesu FTA-250L is an extremely affordable, compact (COMM ONLY) Airband transceiver. Featuring an extremely rugged Polycarbonate housing with an IPX5 Waterproof rating for use in harsh environments with rain, splash and spray. Loud 700mW audio output guarantees that radio calls will not be missed even in noisy environments. 8.33kHz Narrow Band capable, with a huge programmable 250 channel capacity memory bank. The FTA-250L comes programmed with Yaesu's exclusive E2O Easy to Operate menu system making the radio a pleasure to operate without the use of a manual. The intuitive operating system is further complimented by the high resolution Dot Matrix display and the bright, fully Lit, sunlight viewable backlight. Value packaged with a High Capacity (1950mAh) Li-ion battery, Headset adapter, belt clip, 100-240VAC charger, 12VDC charger / power cable, with drop in charging cradle. The Yaesu FTA-250L is backed by a industry leading 3 year waterproof warranty.<br> </p><h2>Features</h2><p><strong>Compact size</strong><br> In response to the huge demand for a compact Airband transceiver, Yaesu has responded with our smallest airband transceiver yet, at only (2.1" W x 4.1" H x 1.2" D) the FTA-250L is guaranteed to fit in the smallest of places. </p><p><strong>250 Memory Channels</strong><br> Now with an expanded memory bank the FTA-250L can now store up to 250 memory channels for quick and easy recall, making this transceiver a pleasure to operate for heavy avionics users. </p><p><strong>High-Capacity 1950mAh Li-ion battery</strong><br> The FTA-250L comes packaged with our largest capacity battery yet. measuring in at 1950mAh, even heavy radio users are guaranteed to have a radio that will keep going strong all day long. </p>	FTA250, FTA250L, Yaesu aviation handheld, Yaesu airband handheld
6048	<p>VHF 6W Airband Handheld with color display, Bluetooth and ILS/VOR navigation. Includes SBR-39LI battery, SAD-25B adapter, SBH-11 cradle.</p>		FTA850L, FTA850, FTA-850, new Yaesu airband handheld, Yaesu aviation handheld, Yaesu airband handheld, FTA-750, FTA-750L, FTA750, FTA750L
7936	<p>Yaesu FTA-850AA VHF 5W airband VHF/GPS/Bluetooth transceiver. Powered by AA alkaline batteries.</p>		FTA-750AA, FTA750, FTA850