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
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00047

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