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 (
    6918, 6919, 6920, 6921, 6922, 6923, 6924, 
    6925, 6926, 6927, 6928, 6929, 6930, 
    6931, 6932, 6933
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00051

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 (6918,6919,6920,6921,6922,6923,6924,6925,6926,6927,6928,6929,6930,6931,6932,6933)) 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
6918 <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.6" laptop to school, the office or the local cafe.</p>
6919 <ul><li>Form-fitting sleeve ensures a precise fit for your laptop or MacBook with up to a 13.3" 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><p>A traditional sleeve complete with protective foam padding and sophisticated, stylish details.</p>
6920 <ul><li>Compatible with most compact camcorders & CSC cameras.</li> <li>Semi-rigid, molded EVA case safeguards your camcorder and accessories.</li> <li>Angled camcorder pocket is designed for simple, speedy retrieval.</li> <li>Detachable, adjustable shoulder strap and grab handle for easy transport.</li> </ul><p>A grooved, shock-absorbing front panel protects compact camcorders from everyday abuse. Unzip the main compartment to slide your camcorder into the tailored, padded interior pocket where you can be assured it will remain secure.</p>
6921 <ul class="bullet"><li>Compatible with most SLRs with a zoom lens.</li> <li>Patent pending hammock system suspends your SLR above the bottom of 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>
6922 <ul><li>Compatible with 1 action camera, such as GoPro, attachments sized up to a 3-way, remote control and other accessories.</li> <li>Protect camera by separating accessories with adjustable, padded divider wall.</li> <li>Zippered pocket and mesh pouches store accessories and attachments.</li> <li>Water-resistant DuraBase offers protection and stability from the ground up.</li> <li>Organization panel provides storage for cords, SD cards, manual and other small accessories.</li> <li>Dual zippers on the main compartment designed to fit a luggage lock for extra security.</li> <li>Top grab handle for easy transport.</li> </ul><p>A rugged, protective case designed to keep up with your adventurous side. Fits a GoPro, 3-way, remote control, mounts and accessories.</p>
6923 <ul><li>Files remain crisp and unbent in their designated pocket separated from your electronics</li> <li>Front pocket stores bulky power cords neatly in the bottom and out of the way</li> <li>Organizer panel in front pocket with dedicated storage for an external hard drive pens and other accessories</li> <li>Zippered front pocket keeps your smartphone secure yet easily accessible</li> <li>Comfortable removable shoulder strap and padded handle for easy portability</li> </ul>
6924 A Modern Take on Pure Practicality, This Slim Case Holds a 15.6'' Laptop and I Pad Plus Your Daily Must-Haves. Room at The Bottom for A Power Adapter and An Exterior Smartphone Pocket Round out The Reasons This Will Be Your Weekday Go-To<br /><ul><li>Files Remain Crisp and Unbent in Their Designated Pocket, Separated from Your Electronics.</li> <li>Front Pocket Stores Bulky Power Cords Neatly in The Bottom and Out of The Way.</li> <li>Organizer Panel in Front Pocket with Dedicated Storage for An External Hard Drive, Pens and Other Accessories.</li> <li>Zippered Front Pocket Keeps Your Smartphone Secure yet Easily Accessible.</li> <li>Comfortable, Removable Shoulder Strap and Padded Handle for Easy Portability.</li> </ul><p> </p>
6925 <ul class="bullet"><li>Fully Customizable Storage Protects a Variety of Dslr and Drone Equipment Plus Accessories.</li> <li>Compatible with Drones up To 320 X 280 X 100 Mm Including Dji Mavic Pro, Dji Mavic Spark, Yuneec Breeze.</li> <li>Dedicated Slip Pocket for An I Pad/10.1" Tablet.</li> <li>Secure Tripod Attachment with Adjustable Strap.</li> <li>Exterior Pockets Organize Camera Accessories and Personal Items.</li> <li>Zippered Lid Pocket Provides Storage for Personal Items.</li> <li>Mesh Side Pocket Stores a Water Bottle.</li> <li>Durable Exterior Constructed of 1680 D Polyester.</li> </ul>
6926 <ul class="bullet"><li>Fits a Mirrorless Camera with Kit Lens.</li> <li>Adjustable, Padded Divider Provides Custom Protection.</li> <li>Front Zippered Pocket Keeps Accessories Secure yet Accessible.</li> <li>Mesh Side Pockets Conveniently Store a Lens Cap and Small Accessories.</li> <li>Removable, Adjustable Shoulder Strap, Comfortable Grab Handle and Belt Loops Provide Multiple Carry Options.</li> <li>Internal Memory Card Pouch.</li> <li>Durable Exterior Constructed of 1680 D Polyester.</li> </ul>
6927 <ul class="bullet"><li>Fits a DSLR camera with kit lens.</li> <li>Adjustable, padded divider provides custom protection.</li> <li>Front zippered pocket keeps accessories secure yet accessible.</li> <li>Internal zippered pocket and secure memory card pouches.</li> <li>Mesh side pockets conveniently store a lens cap and small accessories.</li> <li>Removable, adjustable shoulder strap, comfortable grab handle and belt loops provide multiple carry options.</li> <li>Durable exterior constructed of 1680D polyester.</li> </ul>
6928 <ul class="bullet"><li>Fits a Dslr Camera with Lens and Accessories.</li> <li>Adjustable, Padded Dividers Provide Custom Protection.</li> <li>Front Zippered Pocket with Mesh Slip Pockets Keeps Accessories Secure yet Accessible.</li> <li>Internal Zippered Pocket and Secure Memory Card Pouches.</li> <li>Mesh Side Pockets Conveniently Store a Lens Cap and Small Accessories.</li> <li>Removable, Adjustable Shoulder Strap, Comfortable Grab Handle and Belt Loops Provide Multiple Carry Options.</li> <li>Durable Exterior Constructed of 1680 D Polyester.</li> </ul>
6929 <ul class="bullet"><li>Padded Laptop Compartment Provides Quality Protection.</li> <li>Protective I Pad or 10.1 Inch Tablet Storage.</li> <li>Zippered Accessory Storage with Slip Pockets.</li> <li>Cord Organization Loop Provides Convenient In-Case Charging Capability.</li> <li>Separate File Compartment Stores Folders, Magazines and Loose Papers.</li> <li>Removable, Padded Shoulder Strap.</li> <li>Convenient Carry Handles.</li> <li>Luggage Strap Securely Attaches Slim Case to Most Rolling Luggage.</li> </ul>
6930 <ul class="bullet"><li>Padded Laptop Compartment Provides Quality Protection.</li> <li>Protective I Pad or 10.1 Inch Tablet Storage.</li> <li>Additional Storage Compartment Keep Daily Essentials Separate from Hardware.</li> <li>Zippered Accessory Storage with Slip Pockets.</li> <li>Cord Organization Loop Provides Convenient In-Case Charging Capability.</li> <li>Removable, Padded Shoulder Strap.</li> <li>Convenient Carry Handles.</li> <li>Luggage Strap Securely Attaches Slim Case to Most Rolling Luggage.</li> </ul>
6931 <ul class="bullet"><li>Designed to fit an SLR camera with standard zoom lens attached.</li> <li>Side zippered pockets store an extra battery, cables, lens cap, or small accessories.</li> <li>Lid unzips to create a wide opening for easy, quick access to the grip of your camera.</li> <li>Padded base protects your camera and lens.</li> <li>Internal zippered pocket stores memory cards, a lens cloth and small accessories.</li> <li>Integrated belt loop, padded handle and removable shoulder strap offer multiple carrying options.</li> </ul>
6932 <ul><li><span>Rich Material Clean Lines and Stylish Accents Give Professional Laptop Sleeves a New Standard.</span></li> <li><span>USB Pen Key Flash Drives Slim Line Case Protects Your Device on Its Own or In Your Favorite Bag.</span></li> <li><span class="a-list-item">Fits Device Dimensions: 13.8 X 1.2 X 11.4" (lx Wx H).</span></li> <li><span class="a-list-item">Spacious Front Pocket Stores Accessories and A Power Brick.</span></li> <li><span class="a-list-item">Dual Zipper Pulls Open Wide for Smooth, Quick Access.</span></li> <li><span class="a-list-item">Glossy Nylon Twill, Metal Rivet Accents and Unique Thread Detail Create a Refined, Professional Style.</span></li> </ul>
6933 <ul class="bullet"><li>Padded Storage for A Laptop up To 11.6".</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>