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 (
    6934, 6935, 6936, 6937, 6938, 6939, 6940, 
    6941, 6942, 6943, 6944, 6945, 6946, 
    6947, 6948, 6949
  ) 
  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 (6934,6935,6936,6937,6938,6939,6940,6941,6942,6943,6944,6945,6946,6947,6948,6949)) 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
6934 <ul class="bullet"><li>Padded storage for a laptop up to 14".</li> <li>Dedicated slip pocket for a 10.5" tablet.</li> <li>Quick-access front pocket stores a phone and small accessories.</li> <li>Removable, padded shoulder strap adjusts for a custom fit.</li> <li>Padded carry handles ensure comfortable transport.</li> <li>Luggage strap securely attaches slim case to most rolling luggage.</li> <li>Melange fabric, copper touchpoints and trim details create a modern professional look.</li> </ul>
6935 <ul class="bullet"><li>Thickly Padded Storage for A Laptop up To 15.6".</li> <li>Dedicated Slip Pocket for A 10.5" Tablet.</li> <li>Spacious Main Compartment Stores Notebooks, Headphones and Other Bulky Items.</li> <li>Additional Compartment with Organization Panel and Volume for Power Brick Storage.</li> <li>Quick Access Front Pocket with Organization for Small Electronics.</li> <li>Two Side Pockets for Water Bottles or Go-To Items.</li> <li>Luggage Strap Securely Attaches Bag to Most Rolling Luggage.</li> <li>Elastic Strap Management Loops Neatly Secure Excess Strap Material.</li> <li>Melange Fabric, Copper Touchpoints and Trim Details Create a Modern Professional Look.</li> </ul>
6936 <ul><li>Removable shoulder strap adjusts for a custom fit.</li> <li>Luggage strap securely attaches slim case to most rolling luggage.</li> <li>Dedicated iPad or 10.1" tablet compartment.</li> <li>Multiple zippered pockets store accessories.</li> <li>Durable polyester material withstands your ever-changing schedule.</li> </ul><p>Slim attache with heathered fabric is perfect for protecting and transporting your 11.6" laptop to school, the office or the local cafe.</p>
6937 <ul><li>Removable shoulder strap adjusts for a custom fit.</li> <li>Luggage strap securely attaches slim case to most rolling luggage.</li> <li>Dedicated iPad or 10.1" tablet compartment.</li> <li>Multiple zippered pockets store accessories.</li> <li>Durable polyester material withstands your ever-changing schedule.</li> </ul><p>Slim attache with heathered fabric is perfect for protecting and transporting your 14" laptop to school, the office or the local cafe.</p>
6938 <ul><li>Removable shoulder strap adjusts for a custom fit.</li> <li>Luggage strap securely attaches slim case to most rolling luggage.</li> <li>Dedicated iPad or 10.1" tablet compartment.</li> <li>Multiple zippered pockets store accessories.</li> <li>Durable polyester material withstands your ever-changing schedule.</li> </ul><p>Slim attache with heathered fabric is perfect for protecting and transporting your 15" laptop to school, the office or the local cafe.</p>
6939 <ul><li>Removable Shoulder Strap Adjusts for A Custom Fit.</li> <li>Luggage Strap Securely Attaches Slim Case to Most Rolling Luggage.</li> <li>Dedicated I Pad or 10.1" Tablet Compartment.</li> <li>Multiple Zippered Pockets Store Accessories.</li> <li>Durable Polyester Material Withstands Your Ever-Changing Schedule.</li> </ul><p>Slim Attache with Heathered Fabric Is Perfect for Protecting and Transporting Your 15.6" Laptop to School, the Office or The Local Cafe.</p>
6940 <ul><li>Slimline Case Protects Your Device on Its Own or In Your Favorite Bag.</li> <li>Durable Polyester Material Withstands Your Ever-Changing Schedule.</li> <li>3/4 Zipper Opens Wide for Easy Access.</li> </ul><p>Correlating textures and playful color accents give this protective laptop sleeve a stylish edge.</p>
6941 <ul><li>Slimline Case Protects Your Device on Its Own or In Your Favorite Bag.</li> <li>Durable Polyester Material Withstands Your Ever-Changing Schedule.</li> <li>3/4 Zipper Opens Wide for Easy Access.</li> </ul><p>Correlating Textures and Playful Color Accents Give This Protective Laptop Sleeve a Stylish Edge.</p>
6942 <ul class="bullet"><li>Form fitting sleeve ensures a precise fit for your laptop or MacBook with up to a 13 point 3 inch screen</li> <li>A seamless wrap of Impact Foam padding provides top to bottom protection</li> <li>Woven webbing along each side adds subtle texture to the clean design</li> <li>Slimline case protects your device on its own or in your favorite bag</li> <li>Available in a variety of fresh colors to fit any personality</li> </ul>
6943 <ul class="bullet"><li>Form-Fitting Sleeve Ensures a Precise Fit for Your Laptop or Mac Book with Up to A 13.3 Inch Screen.</li> <li>A Seamless Wrap of Impact Foam Padding Provides Top to Bottom Protection.</li> <li>Woven Webbing Along Each Side Adds Subtle Texture to The Clean Design.</li> <li>Slimline Case Protects Your Device on Its Own or In Your Favorite Bag.</li> <li>Available in A Variety of Fresh Colors to Fit Any Personality.</li> </ul>
6944 <ul class="bullet"><li>Form Fitting Sleeve Ensures a Precise Fit for Your Laptop or Mac Book with Up to A 13 Point 3 Inch Screen</li> <li>A Seamless Wrap of Impact Foam Padding Provides Top to Bottom Protection</li> <li>Woven Webbing Along Each Side Adds Subtle Texture to The Clean Design</li> <li>Slimline Case Protects Your Device on Its Own or In Your Favorite Bag</li> <li>Available in A Variety of Fresh Colors to Fit Any Personality</li> </ul>
6945 <ul class="bullet"><li>Sleeve Designed to Fit a  14 Inches Laptop Plus Dedicated Pocket for 10 Inches 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>
6946 <ul><li>Molded Eva Sleeve Holds a Laptop with Up to A 11 Inches Screen</li> <li>An Assortment of Colors and A Unique Seat Belt Style Keep You Looking Good While on The Move</li> <li>Thick Quilted Padding Keeps Your Device Protected and Snugly in Place to Prevent It from Sliding Around</li> <li>Clam Shell Design and Integrated Airflow Channels Allow You to Use Your Laptop While Still in The Sleeve without The Risk of Overheating</li> <li>Padded Carry Handles for Comfortable Transportation</li> </ul>
6947 <ul><li>Molded Eva Sleeve Holds a Laptop with Up to A 13.3" Screen.</li> <li>An Assortment of Colors and A Unique Seatbelt Style Keep You Looking Good While on The Move.</li> <li>Thick, Quilted Padding Keeps Your Device Protected and Snugly in Place to Prevent It from Sliding Around.</li> <li>Clamshell Design and Integrated Airflow Channels Allow You to Use Your Laptop While Still in The Sleeve without The Risk of Overheating.</li> <li>Padded Carry Handles for Comfortable Transportation.</li> </ul><p>The Sleek Shape of This Molded EVA Case Provides Slimline Protection for 13.3" Laptops without Sacrificing Style or Design.</p>
6948 <ul><li>Compatible with Most Sl Rs with A Zoom Lens</li> <li>Patent Pending Hammock System Suspends Your Slr Above the Bottom of The Case, Providing Superior Impact Protection</li> <li>Memory Foam on Interior Helps Protect Your Delicate Lcd Screen</li> <li>Three Zippered Pockets Store Accessories</li> <li>Water-Proof Eva Base Withstands the Elements and Allows the Case to Stand up On Its Own</li> <li>Removable, Padded Shoulder Strap</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>
6949 <ul><li>Compatible with Most Sl Rs with A Zoom Lens.</li> <li>Patent Pending Hammock System Suspends Your Slr Above the Bottom of The Case, Providing Superior Impact Protection.</li> <li>Memory Foam on Interior Helps Protect Your Delicate Lcd Screen.</li> <li>Three Zippered Pockets Store Accessories.</li> <li>Water-Proof Eva Base Withstands the Elements and Allows the Case to Stand up On Its Own.</li> <li>Removable, Padded Shoulder Strap.</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>