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 (
    6950, 6951, 6952, 6953, 6954, 6955, 6956, 
    6112, 6113, 6114, 6115, 6116, 6117, 
    6118, 6119, 6120, 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.00079

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 (6950,6951,6952,6953,6954,6955,6956,6112,6113,6114,6115,6116,6117,6118,6119,6120,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": "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
6112 <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>
6113 <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>
6114 <ul><li>Nickel plated connectors minimize signal loss</li> <li>Double shielding restricts outside interference</li> <li>Slim, lightweight design for ultra-portability and superior quality</li> <li>Soft pliable cord design for tangle free installation around your home</li> <li>Low-profile strain relief extends cable lifespan</li> </ul>
6115 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Apple MFi Certified Lightning to USB A cable to charge and sync your Apple devices</span></li> <li><span class="a-list-item">Ultra compact with reversible lightning connector</span></li> <li><span class="a-list-item">Plugs into any USB 2 0 port to charge</span></li> <li><span class="a-list-item">Syncs music and pictures to/from your laptop in seconds</span></li> </ul>
6116 <ul><li>3meters</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>
6117 <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>
6118 <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>
6119 <ul><li>Car Charger with USB 2.0 port</li> <li>17 Watt/3.4 Amp</li> <li>Charges 40% faster than 5 Watt charging</li> <li>Use any USB cable with charger</li> </ul>
6120 <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>
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>
6950 <ul><li>Backpack Fits Slr Camera Body with Attached Lens, a Dji Mavic Pro (or Drones up To 320mm X 270mm X 140mm) and A Variety of Accessories.</li> <li>Patent Pending Hammock System Suspends Your Slr Above the Bottom of The Case, Providing Superior Impact Protection.</li> <li>Water-Resistant Eva Base Withstands the Elements and Allows the Backpack to Stand up On Its Own.</li> <li>Memory Foam on Interior of Backpack Lid Helps Protect Your Delicate Lcd Screen.</li> <li>Adjustable Dividers Create a Fully Customizable Interior.</li> <li>Computer Compartment Compatible with 16" Laptops and The 17" Mac Book Pro (dimensions- 15.4" X 10.4" X 1").</li> <li>Four Accessory Pockets Allow Fast Access to Memory Cards and Other Small Items.</li> </ul><p>This Tough and Ready Slr Holster Was Designed to Keep Pace with Your Approach to Photography. Rugged Styling with A Professional Grade Interior and Organization Will Take You Anywhere the Shots Are Waiting.</p>
6951 <ul><li>Sleeve Designed to Fit a 13" Laptop Plus Dedicated Pocket for 10.1'' Tablet.</li> <li>Dual Density Foam Padding Cushions the Exterior and Prevents Internal Scratching.</li> <li>Slimline Case Protects Your Portable Electronics While Minimizing Bulk.</li> <li>Compact Design Allows This Case to Fit Easily Into Any Bag.</li> <li>Stylish and Trendy Exterior to Express Your Personality.</li> </ul><p>Doubling up Has Never Felt so Minimal. This Streamlined Sleeve Houses a 13" Laptop and Front Zipper Pocket Fits an I Pad 10.1" Tablet or Can Double as Storage for Accessories and Earbuds. Keep It All Together and Looking Sharp with This Innovative, Compact Solution for Your Growing Collection of Electronics.</p>
6952 <ul class="bullet"><li>Sleeve Designed to Fit a 15.6" Laptop Plus Dedicated Pocket for 10.1" Tablet.</li> <li>Dual Density Foam Padding Cushions the Exterior and Prevents Internal Scratching.</li> <li>Slimline Case Protects Your Portable Electronics While Minimizing Bulk.</li> <li>Compact Design Allows This Case to Fit Easily Into Any Bag.</li> <li>Stylish and Trendy Exterior to Express Your Personality.</li> </ul>
6953 <ul><li>Tailored Case Compatible with Most Laptops with A 15.6'' Screen.</li> <li>Padded Laptop Compartment Walls Provide Extra Protection.</li> <li>Internal Divider Keeps Documents Separated from Other Items in Your Bag.</li> <li>Front Pocket Panel Provides Basic Organization for Small Daily Accessories.</li> <li>Front Pocket Features a Wide Base for Bulky Items Like a Power Brick.</li> <li>Top-Load Access Allows You to Easily Slide Your Laptop in And Out.</li> <li>Carry Comfortably with Padded Handles and A Removable Strap with Anti-Slip Shoulder Pad.</li> </ul><p>Straightforward and All-Business with A Hint of Subtle Styling, This Laptop Toploader Has Dedicated Compartments for Your 15.6" Laptop, Documents and The Daily Accessories You Need to Get Between Home and Work.</p>
6954 <ul><li>Dedicated, 3/4 Zip Laptop Compartment Holds up To 17" Widescreen Laptops.</li> <li>Expansive Interior Storage Holds Books, Files and Folders.</li> <li>Organization Panel Stores Your Portable Electronics, Pens and More.</li> <li>Speed Pocket- a Quick Access, Secure Place to Put Valuables (watch, Keys, Cell Phone Etc.) Prior to Passing Through Airport Security.</li> <li>External Mesh Pocket Stores Water, Snacks or Other Small Items.</li> <li>Adjustable Shoulder Strap and Grab Handle Allows for Easy Transport.</li> </ul><p>Streamlined Styling and Smartly Placed Features Add up To a Minimalist Footprint. Sized to Fit Laptops with Up to 17" Displays with Practical Organization for Everything Else You Need to Carry.</p>
6955 <ul><li>Integrated compartment for your 15.6" laptop plus sleeve for your tablet.</li> <li>Quick access front pocket stows go-to items such as your phone or gum.</li> <li>Interior cord storage pocket keeps small power cords handy and prevents tangling.</li> <li>Mesh side pockets conveniently store water bottles easily within reach.</li> <li>Organizational panel keeps your smaller accessories easy-to-find and built-in pen loops assure you'll never miss jotting down important notes.</li> </ul><p>The sleek solution for an urban-dweller looking to efficiently pack electronics along with daily essentials. An integrated compartment for your 15.6" Laptop, sleeve for your tablet and interior cord storage pocket keep your electronics on hand. Quick-access front pocket stores your most-used items while organizational panel keep your accessories arranged, no matter where the day takes you.</p>
6956 <ul><li>Integrated Compartment for Your 15.6" Laptop Plus Sleeve for Your Tablet.</li> <li>Quick Access Front Pocket Stows Go-To Items Such as Your Phone or Gum.</li> <li>Interior Cord Storage Pocket Keeps Small Power Cords Handy and Prevents Tangling.</li> <li>Mesh Side Pockets Conveniently Store Water Bottles Easily Within Reach.</li> <li>Organizational Panel Keeps Your Smaller Accessories Easy-To-Find and Built-In Pen Loops Assure You'll Never Miss Jotting Down Important Notes.</li> </ul><p>The Sleek Solution for An Urban-Dweller Looking to Efficiently Pack Electronics Along with Daily Essentials. an Integrated Compartment for Your 15.6" Laptop, Sleeve for Your Tablet and Interior Cord Storage Pocket Keep Your Electronics on Hand. Quick-Access Front Pocket Stores Your Most-Used Items While Organizational Panel Keep Your Accessories Arranged, No Matter Where the Day Takes You.</p>