SELECT 
  ushop_product_descriptions.product_id, 
  ushop_product_descriptions.short_description, 
  IF(
    ushop_product_descriptions.short_description = '' 
    OR ushop_product_descriptions.short_description IS NULL, 
    ushop_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  ushop_product_descriptions.unit_name 
FROM 
  ushop_product_descriptions 
WHERE 
  ushop_product_descriptions.product_id IN (337, 321, 326, 332, 336, 343) 
  AND ushop_product_descriptions.lang_code = 'es'

Query time 0.00060

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.21"
    },
    "table": {
      "table_name": "ushop_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 6,
      "rows_produced_per_join": 6,
      "filtered": "100.00",
      "index_condition": "((`marketplace`.`ushop_product_descriptions`.`product_id` in (337,321,326,332,336,343)) and (`marketplace`.`ushop_product_descriptions`.`lang_code` = 'es'))",
      "cost_info": {
        "read_cost": "3.61",
        "eval_cost": "0.60",
        "prefix_cost": "4.21",
        "data_read_per_join": "38K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "unit_name"
      ]
    }
  }
}

Result

product_id short_description full_description unit_name
321 <p>Many cars come with a 2DIN opening so swap that basic factory radio out for a DPX308U! This full featured CD-receiver comes with front USB input which provides a simple connection for your iPod/iPhone, allowing you to listen to your favorite music while controlling it easily from you your car stereo. When connecting an iPod or iPhone to the USB port you get the added benefit of advanced search features designed to let you spend more time listening to your favorite songs instead of hunting for them.</p>
326 <p>With music in so many different formats, it only makes sense to have a CD receiver that can play them all. Take your digital songs on the go by copying them directly onto a CD-R or CD-RW disc in either MP3 or WMA formats. Since these files are digitally encoded, you will be able to see detailed track information such as artist, song title, and album.</p>
332 <p>This is marine audio at its best. This 8" two-way speaker is built specifically for marine use, with heavy-duty construction that strenuously resists water, corrosion, heat&mdash;and boring music. Pioneer research showed that more bass is required for boating applications, and this 8" size delivers.</p>
336 <p>1200W Peak Power<br /> 400W RMS Power<br /> 4 ohms Impedance<br /> 34Hz - 300Hz Frequency Response<br /> 6" Mounting Depth<br /> PP Cone with Diamond Array Pattern<br /> Dual-Ventilation System<br /> Rubber Surround</p>
337 <p>Super-sturdy, super powerful, the KFC-W3012 is a 12-inch, 4-ohm sub that handles an impressive 1200W of power. A truly high-performance sub, the KFC-W3012 has a long stroke design and a silver textured pattern cone woofer that adds strength and rigidity to the cone for maximum bass performance.</p>
343 <p>The AVH-P4400BH DVD multimedia receiver features a 7" motorized touchscreen display, built-in Bluetooth&reg; for hands-free calling and audio streaming, and an HD Radio&trade; tuner. The newly updated and innovative user interface makes direct operation of the unit stress-free by eliminating complicated layered selection displays, so access to desired functions is smoother and simpler than ever. A variety of multimedia options ensures that you will be properly entertained. Customizable audio and video functions make it easy to suit your mood.</p>