SELECT 
  q_product_descriptions.product_id, 
  q_product_descriptions.short_description, 
  IF(
    q_product_descriptions.short_description = '', 
    q_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  q_product_descriptions 
WHERE 
  q_product_descriptions.product_id IN (
    6121, 6122, 6123, 6124, 6125, 6126, 6127, 
    6128, 6129, 6130, 6131, 6132, 6133, 
    6134, 6135, 6136
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00049

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "38.41"
    },
    "table": {
      "table_name": "q_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": 16,
      "rows_produced_per_join": 16,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (6121,6122,6123,6124,6125,6126,6127,6128,6129,6130,6131,6132,6133,6134,6135,6136)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "35.21",
        "eval_cost": "3.20",
        "prefix_cost": "38.41",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
6121 <ul><li>Upgrade your network and enjoy clean and clear transmissions with the Belkin CAT6 Ethernet Patch Cable</li> <li>This patch cable lets you connect a laptop or desktop computer to a wall outlet modem router or another networking device</li> <li>It meets the CAT6 standard and is suitable for use with 100 1000BASE T networks</li> <li>Patch cables are also handy in home offices and hotel rooms to establish a wired Internet connection</li> </ul>
6122 <ul><li>3.5mm plug on each end</li> <li>Chrome-finished plugs and nickel-plated contacts</li> <li>Coiled cable stretches to 6' (1.8m)</li> </ul><p>Connect your iPod or iPhone to your car stereo, home stereo, portable speakers, sound card or any device that has a 3.5mm jack. The coiled cable prevents tangles and makes storage easy.</p>
6123 <ul><li>Right-angle 3.5mm plug puts less stress on the cable</li> <li>Chrome-finished plugs and nickel-plated contacts</li> <li>Flat design prevents tangles</li> <li>4-foot / 1.2-meter length</li> </ul>
6124 <ul><li>Right angle 3 5mm plug puts less stress on the cable</li> <li>Chrome finished plugs and nickel plated contacts</li> <li>Flat design prevents tangles</li> </ul>
6125 <ul><li>Auxiliary cable connects any two devices with 3.5mm port</li> <li>Sleek cable with metallic finish</li> <li>Available in five colors to match your device</li> <li>Designed to withstand heavy use</li> <li>4-foot length ideal for use everywhere</li> </ul><p>The MIXIT Metallic AUX Cable is an ideal solution for all your music needs. Featuring a 3.5-millimeter auxiliary jack at both ends, this versatile cable lets you connect a huge range of audio devices.</p>
6126 <ul><li>Auxiliary cable connects any two devices with 3.5mm port</li> <li>Sleek cable with metallic finish</li> <li>Available in five colors to match your device</li> <li>Designed to withstand heavy use</li> <li>4-foot length ideal for use everywhere</li> </ul><p>The MIXIT Metallic AUX Cable is an ideal solution for all your music needs. Featuring a 3.5-millimeter auxiliary jack at both ends, this versatile cable lets you connect a huge range of audio devices.</p>
6127 <ul><li>Supports Dolby Vision</li> <li>Supports 4K HDR</li> <li>PC and TPE durable construction</li> <li>Two layer shielding minimizes interference</li> <li>Compatible with MacBooks laptops AV components media players DVD players cable boxes and gaming consoles</li> <li>Simple plug and play connectivity</li> <li>6 6 feet 2 meter length</li> </ul>
6128 <ul><li>Transmit audio and video from Mini DisplayPort to HDTV</li> <li>Ideal for connecting MacBooks, Ultrabooks, or tablets to an HDTV</li> <li>Use for movies, presentations, photo slideshows, and more</li> <li>Molded-strain relief reduces wear and tear</li> <li>Black design with white labeling for clear identification</li> <li>6-foot (1.8-meter) length for hard-to-reach HDMI ports</li> <li>4K compatible</li> </ul><p>The Mini DisplayPort to HDTV Display Cable lets you stream high-quality A/V content from your laptop or tablet to your HDTV. Use it to watch movies, share photos, or expand your workstation with a mirrored desktop.</p>
6129 <ul><li>Plugs into any USB 2.0 port to charge portable devices</li> <li>Syncs music and pictures to or from your laptop in seconds</li> <li>Compatible with most devices with a Micro-USB port</li> </ul><p>Connect the MIXIT Micro-USB to USB ChargeSync Cable to your laptop to charge and sync your portable devices at the fastest possible speeds. With the MIXITƒ??ƒ?› ChargeSync Cable, you can also transfer music and photos to and from your phone or tablet quickly and safely</p>
6130 <ul><li>Plugs into any USB 2.0 port to charge portable devices</li> <li>Syncs music and pictures to or from your laptop in seconds</li> <li>Compatible with most devices with a Micro-USB port</li> </ul>
6131 <ul><li>Micro-USB to USB cable rapidly charges and syncs Android devices</li> <li>Sleek cable with metallic finish</li> <li>Available in six colors to match your device</li> <li>Designed to withstand heavy use</li> <li>4-foot length ideal for use everywhere</li> </ul>
6132 <ul><li>Micro-USB to USB cable rapidly charges and syncs Android devices</li> <li>Sleek cable with metallic finish</li> <li>Available in six colors to match your device</li> <li>Designed to withstand heavy use</li> <li>4-foot length ideal for use everywhere</li> </ul><p>The MIXIT Metallic Micro-USB to USB Cable lets you easily connect your Android device to a charger or computer. Use it to charge and sync any device that has a micro-USB port, including Android phones and tablets.</p>
6133 <ul><li>Micro-USB to USB cable rapidly charges and syncs Android devices</li> <li>Sleek cable with metallic finish</li> <li>Available in six colors to match your device</li> <li>Designed to withstand heavy use</li> <li>4-foot length ideal for use everywhere</li> </ul><p>The MIXIT Metallic Micro-USB to USB Cable lets you easily connect your Android device to a charger or computer. Use it to charge and sync any device that has a micro-USB port, including Android phones and tablets.</p>
6134 <ul><li>Micro-USB to USB cable rapidly charges and syncs Android devices</li> <li>Sleek cable with metallic finish</li> <li>Available in six colors to match your device</li> <li>Designed to withstand heavy use</li> <li>4-foot length ideal for use everywhere</li> </ul><p>The MIXITÂ Metallic Micro-USB to USB Cable lets you easily connect your Android device to a charger or computer. Use it to charge and sync any device that has a micro-USB port, including Android phones and tablets.</p>
6135 <ul><li>Aramid reinforced conductors provide added durability</li> <li>Longer flexible strain relief absorbs stress from bending to prevent breakage</li> <li>Double braided nylon forms flexible durable cable jacket</li> <li>Aluminum casing protects circuit board inside connector</li> <li>Flexible insulation reduces friction</li> <li>Intelligent chip supports up to 60W optimal charging</li> <li>4 foot 1 2 meters length</li> <li>Supports 3A charging and up to 480Mbps data transfer</li> </ul>
6136 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">HDMI to HDMI connection</span></li> <li><span class="a-list-item">To connect your PC to a high resolution screen or a flat screen</span></li> </ul>