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 (
    6137, 6138, 6139, 6140, 6141, 6142, 6143, 
    6144, 6145, 6146, 6147, 6148, 6149, 
    6150, 6151, 6152, 6153, 6154, 6155, 
    6156, 6157, 6158, 6159, 6160, 6161, 
    6162, 6163, 6164, 6165, 6166, 6167, 
    5845
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00069

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "76.81"
    },
    "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": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (6137,6138,6139,6140,6141,6142,6143,6144,6145,6146,6147,6148,6149,6150,6151,6152,6153,6154,6155,6156,6157,6158,6159,6160,6161,6162,6163,6164,6165,6166,6167,5845)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "70.41",
        "eval_cost": "6.40",
        "prefix_cost": "76.81",
        "data_read_per_join": "122K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
5845 <ul><li>Raised Edge for better protection.</li> <li>Anti-Slip Grip.</li> <li>Dock Compatible cut-outs.</li> <li>Drop Tested to meet/exceed industry standards.</li> </ul>
6137 <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>
6138 <ul><li>2m length</li> <li>Full 1080p support</li> <li>3D Compatible</li> <li>4K Cinema resolution</li> <li>Audio Return Channel</li> <li>Ethernet channel adds networking capabilities (Up to 10.2 Gbps speed rating)</li> <li>24K Gold-plated connectors minimize signal loss</li> <li>2-layer shielding restricts outside interference</li> </ul>
6139 <ul><li>15W USB-C Car Charger</li> <li>USB-A port</li> <li>LED light</li> <li>4ft Hardwired USB-C cable</li> <li>Sleek black design</li> </ul><p>Charge your USB-C enabled device and USB-A device quickly and efficiently while youÆ’??re in your car with this versatile car charger. The 15W USB-C connector allows for 50% faster charger compared to 5W charging* while the USB-A port also allows you to charge your legacy devices as well.</p>
6140 <ul><li>2 4 Amp 12 Watts</li> <li>Hardwired Micro USB cable</li> <li>Plugs into any wall AC power outlet</li> <li>6 ft 1 8M cable</li> <li>Sleek minimalist design</li> <li>40 percent faster than standard 5W charger</li> </ul>
6141 <ul><li>Qualcomm Quick Charge 3.0 technology provides a faster, more optimal charge</li> <li>4ft/1.2M USB-A to USB-C cable enables charging for a variety of devices</li> </ul>
6142 <ul><li>Single 18W port</li> <li>Quick Charge 3 0 with backwards compatibility for Quick Charge 2 0</li> <li>USB A port</li> <li>USB A to USB-C cable for syncing and charging</li> <li>10W charge for devices not enabled with Quick Charge</li> </ul>
6143 <ul><li>4' length</li> <li>Ultra-compact</li> <li>Plugs into any USB 2.0 port to charge</li> <li>Syncs music and pictures to/from your laptop in seconds</li> </ul>
6144 <ul><li>4' length</li> <li>Ultra-compact</li> <li>Plugs into any USB 2.0 port to charge</li> <li>Syncs music and pictures to/from your laptop in seconds</li> </ul>
6145 <ul><li>3 m length</li> <li>Ultra-compact</li> <li>Plugs into any USB 2.0 port to charge</li> <li>Syncs music and pictures to/from your laptop in seconds</li> </ul>
6146 <ul><li>Premium aluminum finish????</li> <li>Ultra-compact</li> <li>Plugs into any USB 2.0 port to charge</li> <li>Syncs music and pictures to/from your laptop in seconds</li> </ul>
6147 <ul><li>Premium aluminum finish????</li> <li>Ultra-compact</li> <li>Plugs into any USB 2.0 port to charge</li> <li>Syncs music and pictures to/from your laptop in seconds</li> </ul>
6148 <ul><li>4' length</li> <li>Ultra-compact</li> <li>Plugs into any USB 2.0 port to charge</li> <li>Syncs music and pictures to/from your laptop in seconds</li> </ul>
6149 <ul><li>4 inches length</li> <li>Ultra compact</li> <li>Plugs into any USB 2.0 port to charge</li> <li>Syncs music and pictures to/from your laptop in seconds</li> </ul>
6150 <ul><li>4' length</li> <li>Ultra-compact</li> <li>Plugs into any USB 2.0 port to charge</li> <li>Syncs music and pictures to/from your laptop in seconds</li> </ul>
6151 <ul><li>Kevlar-reinforced conductors provide added durability</li> <li>Double-braided nylon forms flexible, durable cable jacket</li> <li>Longer, flexible strain relief absorbs stress from bending to prevent breakage</li> <li>Aluminum casing protects circuit board</li> <li>Flexible insulation reduces friction</li> <li>Supports optimal 12W/2.4A charging</li> <li>2m length</li> </ul>
6152 <ul><li>Kevlar-reinforced conductors provide added durability</li> <li>Double-braided nylon forms flexible, durable cable jacket</li> <li>Longer, flexible strain relief absorbs stress from bending to prevent breakage</li> <li>Aluminum casing protects circuit board</li> <li>Flexible insulation reduces friction</li> <li>Supports optimal 12W/2.4A charging</li> <li>2m length</li> </ul>
6153 <ul><li>Kevlar-reinforced conductors provide added durability</li> <li>Double-braided nylon forms flexible, durable cable jacket</li> <li>Longer, flexible strain relief absorbs stress from bending to prevent breakage</li> <li>Aluminum casing protects circuit board</li> <li>Flexible insulation reduces friction</li> <li>Supports optimal 12W/2.4A charging</li> <li>2m length</li> </ul>
6154 <ul><li>Kevlar-reinforced conductors provide added durability</li> <li>Double-braided nylon forms flexible, durable cable jacket</li> <li>Longer, flexible strain relief absorbs stress from bending to prevent breakage</li> <li>Aluminum casing protects circuit board</li> <li>Flexible insulation reduces friction</li> <li>Supports optimal 12W/2.4A charging</li> <li>2m length</li> </ul>
6155 <ul><li>Connects iPhone directly to 3.5 mm outlet.</li> <li>One-cable solution connects without an adapter.</li> <li>MFi-certified to guarantee compatibility after iOS updates.</li> <li>Integrated Digital-to-Analog Converter (DAC)</li> <li>Available in 3-foot/0.9m or 6-foot/1.8m length.</li> </ul>
6156 <ul><li>Connect USB-C enabled devices (new Macbook, Chromebook Pixel) with standard USB-A devices (laptops, hard drives, etc.)</li> <li>Reversible USB-C connector.</li> <li>10Gbps data transfer rate.</li> <li>3A charging output.</li> <li>3.3-feet / 1-meter length.</li> </ul>
6157 <ul><li>Connect USB-C mobile devices (Galaxy S8/S8+) to standard USB-A devices (laptops, USB-A chargers, hard drives)</li> <li>Reversible USB-C connector</li> <li>3A charging output</li> <li>480 Mbps data transfer speeds</li> <li>MIXIT with 4ft/1.2m, 6ft/1.8m, or 10ft/3m lengths</li> </ul>
6158 <ul><li>Connect USB-C mobile devices Galaxy S8/S8+ to standard USB-A devices (laptops, USB-A chargers, hard drives)</li> <li>Reversible USB-C connector</li> <li>3A charging output</li> <li>480 Mbps data transfer speeds</li> <li>MIXIT with 4ft/1.2m, 6ft/1.8m, or 10ft/3m lengths</li> </ul>
6159 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Full USB-C to HDMI Connectivity: Connect USB-C video-enabled devices like MacBook or Chromebook Pixel to HDMI-enabled monitors, projectors, or TVs</span></li> <li><span class="a-list-item">Ultimate 4K Experience: Supports 4K at 60Hz for stunning High-Def resolutions of up to 4096x2160 and therefore is ideal for High Dynamic Range Video</span></li> <li><span class="a-list-item">Picture-Perfect Streaming: Supports HDCP 2.2 to play protected content from online streaming providers with a clean, crisp picture without motion blur or noise</span></li> <li><span class="a-list-item">Advanced Shielding & Added Durability: 6-layer metallic shields within adapter provide structural stability & serve to minimize electromagnetic interference to prevent disrupting wireless signals</span></li> <li><span class="a-list-item">Portable & Ideal Length: Lightweight and with only 5.5in/14cm length, the adapter offers perfect portability; 2m/6ft HDMI cable is ideal for monitor/projector/HDTV setup</span></li> </ul>
6160 <ul><li>Kevlar??-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>4-foot length</li> <li>Supports 2.4A charging</li> </ul>
6161 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Length is 2 m</span></li> <li><span class="a-list-item">Golden connectors</span></li> </ul>
6162 <ul><li>15W USB-C charging</li> <li>Reversible USB-C connector</li> <li>5 ft. USB-C to USB-C cable</li> <li>Sleek white and silver design</li> </ul><p>Charge your USB-C enabled device quickly and efficiently while you're at home or in the office. The 15W USB-C port charges any USB-C smartphone up to 15W which is 50% faster than regular 5W charging.</p>
6163 <div><ul><li>Universal USB-C high speed charging: Up to 45 W USB.</li> <li>6 feet/1.8 m durable USB-C To USB-C cable included.</li> <li>Reversible USB type C connector and premium metallic finish.</li> <li>Broad compatibility: Compatible with any USB-C enabled ultrabook.</li> </ul></div>
6164 <ul><li>Charge smartphones up to 70% faster*</li> <li>Universal chipset charges any USB-C device including tablets and Ultrabooks up to 27W/3A</li> <li>USB Type-C port</li> <li>LED Indicator</li> <li>4-foot/1.2 meter USB-C to USB-C cable</li> <li>Supports USB 2.0 data transfer</li> <li>PC Overmold</li> </ul><p>The USB-C Car Charger + Cable makes it easy to charge your USB-C smartphone or tablet in your car. The 4-foot USB-C to USB-C cable and robust charger offer up to 27W output for charging thatÆ’??s up to 70% faster than standard 5W.</p>
6165 <ul><li>Compatible with Lightning, USB-C and Micro-USB devices</li> <li>MFi certification for peace of mind</li> <li>4-feet / 1.2-meter length</li> </ul>
6166 <ul><li>Home Charger with USB 2.0 port</li> <li>12 Watt/2.4 Amp</li> <li>Charges 40% faster than 5 Watt charging</li> <li>4' Lightning to USB Cable</li> <li>Use any USB cable with charger</li> </ul><p>Never suffer from the dreaded low battery again. With the fastest charging capabilities on the market, Belkin BOOSTUP mobile chargers for your home and car are designed for your active, on-the-go lifestyle. The sleek, compact design is easy on the eyes, and you can plug it in virtually anywhere, so a battery boost is always in reach.</p>
6167 <ul><li>24W/4.8 amp Car Charger</li> <li>2 USB-A Ports</li> <li>Universal compatibility</li> <li>LED light</li> <li>Sleek black design</li> </ul><p>Keep devices charged while you're on the go with the Belkin BOOSTUP 2-Port Car Charger + USB-A to Lightning Cable. This sleek, compact car charger features dual USB-A ports that let you charge up to two devices simultaneously and delivers a 24 watt/4.8 amp total output to power devices quickly and safely. </p>