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 (
    9982, 9983, 7798, 7797, 7779, 7778, 7777, 
    7776, 7775, 7772, 7771, 6913, 6914, 
    6915, 6916, 6917
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00057

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 (9982,9983,7798,7797,7779,7778,7777,7776,7775,7772,7771,6913,6914,6915,6916,6917)) 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
6913 <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>Thickly padded laptop compartment protects a 14" PC/15" MacBook Pro.</li> <li>Top zipper pocket provides quick access to DSLR camera.</li> <li>Included rain cover stows behind back panel when not in use.</li> <li>Secure tripod attachment with adjustable strap.</li> <li>Internal mesh pockets and secure elastic bands store accessories, cables and propellers.</li> <li>Exterior pockets organize camera accessories and personal items.</li> <li>Luggage strap securely attaches backpack to most rolling luggage.</li> <li>Durable exterior constructed of 1680D polyester.</li> </ul>
6914 <ul class="bullet"><li>Designed to fit an SLR camera with attached lens (up to 70-200mm), a DJI Mavic Pro (or drones up to 320mm x 260mm x 120mm) and a variety of accessories.</li> <li>15" MacBook Pro or 14" PC fit in the padded laptop compartment.</li> <li>Side straps adjust to secure a tripod or other bulky items.</li> <li>Weather hood fits snugly over the bag to protect from the elements (when not in use, roll into its stuff sack for storage).</li> <li>Front pocket provides storage for any non-camera items you require.</li> <li>A padded front panel ensures your camera and accessories are protected from impact.</li> <li>Convenient mesh water bottle pouch.</li> <li>Innovative strap management system eliminates messy, hanging straps.</li> </ul>
6915 <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>2-in-1 bag can be carried as a briefcase or a backpack.</li> <li>Additional compartment for files, books and headphones.</li> <li>Removable, padded shoulder strap adjusts for a custom fit.</li> <li>Front pocket with organization panel.</li> <li>Quick-access front pocket stores small accessories.</li> <li>Melange fabric, copper touchpoints and trim details create a modern professional look.</li> <li>Backpack straps tuck away when not in use.</li> <li>Multiple grab handles for use in either briefcase or backpack mode.</li> </ul>
6916 <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 13" laptop to school, the office or the local cafe.</p>
6917 <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 13" laptop to school, the office or the local cafe.</p>
7771 <p><br />Nanopresso M-Case is made of durable EVA material and soft fabric interior lining.<br />It is specially designed to fit around the Nanopresso with the addition of the adapter ring from the NS Adapter or the Barista Kit.<br />The case helps protect from any bumps, scratches and dust.</p>
7772 <div class="jsx-115903991 jsx-3349621030" style="margin-bottom:0px;padding:0px;border-width:0px;font-size:12px;line-height:inherit;font-family:'Proxima Nova', 'Helvetica Neue', Arial, sans-serif;vertical-align:baseline;color:rgb(64,69,83);background-color:rgb(255,255,255);"><div class="jsx-1889249662 overviewSection" style="margin-bottom:0px;padding:0px;border-width:0px;font:inherit;vertical-align:baseline;"><ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Efficient and easy to use semi-automatic piston that controls the amount of extracted coffee.</li><li class="jsx-1889249662">Heat sink that absorbs heat and protects your hands while operating.</li><li class="jsx-1889249662">Comes equipped with built in espresso cup and scoop.</li></ul></div></div>
7775 <br /><ul><li> <ul><li>The NS Adapter allows the Nanopresso to use NS CAPSULES to prepare espresso.</li> </ul></li> </ul><br /><ul><li> <ul><li>The advantage of using capsules is that the coffee is mechanically ground, measured, and tamped with a higher precision than we are capable of doing by hand.</li> </ul></li> </ul><br /><ul><li> <ul><li>There is very little left for error, so your espresso is consistent every single time. Pods are convenient, mess free and easier to clean after use.</li> </ul></li> </ul>
7776 <br /><ul><li><ul><li>The Barista Kit is a full set of accessories packed in a small container.</li> </ul></li></ul><br /><ul><li><ul><li>It expands the Nanopresso capabilities by giving you the possibility to prepare double espresso (16 grams of ground coffee) up to 120ml.</li> </ul></li></ul><br /><ul><li><ul><li>Thanks to its high pressure extraction of 18 bar, Nanopresso takes full advantage of the larger filter basket and surpasses the extraction quality of most home espresso machine.</li> </ul></li></ul><br /><ul><li><ul><li>Coffee lovers will be pleased to enjoy unbelievably rich espresso. The double espresso basket is a unique feature that can not be found in any other portable espresso machine.</li> </ul></li></ul>
7777 <ul><br /><li>COMPACT &amp; FEATHERWEIGHT - Whether you're going away for few hours or few weeks, space and weight are major factors when selecting your travel equipment</li><br /><li>INNOVATIVE &amp; POWERFUL - With the help of the semi-automatic piston, small quantities of water are injected into the coffee adapter. After a few pushes, the optimal extraction pressure is achieved and a rich and bold espresso is extracted</li><br /><li>CONVENIENT &amp; EVOLUTIVE - Minipresso doesn't require compressed air, N2O cartridges or electricity for its operation. Hand operated, you are free to prepare coffee drinks that you love</li><br /></ul><br /><p>Minipresso GR is your best choice to savor all the varieties of ground coffee and enjoy an authentic espresso wherever you are. Compact, lightweight and sturdy, Minipresso will make you smile when you get the first drip of espresso from this little coffee bullet.</p>
7778 <ul><br /><li>COMPACT &amp; FEATHERWEIGHT - Whether you're going away for few hours or few weeks, space and weight are major factors when selecting your travel equipment</li><br /><li>INNOVATIVE &amp; POWERFUL - With the help of the semi-automatic piston, small quantities of water are injected into the coffee adapter. After a few pushes, the optimal extraction pressure is achieved and a rich and bold espresso is extracted</li><br /><li>CONVENIENT &amp; EVOLUTIVE - Minipresso doesn't require compressed air, N2O cartridges or electricity for its operation. Hand operated, you are free to prepare coffee drinks that you love</li><br /></ul><br /><p>Minipresso NS is your best choice to quickly and efficiently enjoy delicious espresso wherever you are. Compatible with Nespresso* capsules, in which the coffee is ground, measured, tamped with high precision, there is very little left for error. Your espresso looks great and taste fantastic every time.</p>
7779 <ul><li>MASSIVE POWER - Built around a newly patented pumping system, the Nanopresso is capable of reaching, with the h elp of your hands, a maximum of 18 bars (261 PSI) of pressure</li><li>THE SMALLEST - Nanopresso's ergonomic design and shorter length makes it easy to hold and easy to pack</li><li>EVEN LIGHTER At just 336 grams, Nanopresso is engineered to be extremely light</li><li>EASY CLEANING - After each shot, Nanopresso maintenance takes only few seconds</li></ul><p><br /></p><p>Packed with new features and capabilities, which will drastically improve the way you prepare your favorite coffee, Nanopresso is one of the best and most versatile espresso machines. A truly unique addition to your coffee toolkit!</p>
7797 <br /><ul><li><ul><li>MASSIVE POWER - Built around a newly patented pumping system, the Nanopresso is capable of reaching, with the help of your hands, a maximum of 18 bars (261 PSI) of pressure</li> </ul></li></ul><br /><ul><li><ul><li>THE SMALLEST - Nanopresso's ergonomic design and shorter length makes it easy to hold and easy to pack</li> </ul></li></ul><br /><ul><li><ul><li>EVEN LIGHTER At just 336 grams, Nanopresso is engineered to be extremely light</li> </ul></li></ul><br /><ul><li><ul><li>EASY CLEANING - After each shot, Nanopresso maintenance takes only few seconds</li> </ul></li></ul><br /><br />Package includes:- Nanopresso for Ground Coffee<br />- Adapter for NS Capsules<br />- Protective case<br />- Built-in espresso cup<br />- Filter basket<br />- Scoop & Brush<br />- Multi-language instruction book and two stickers<br />Packed with new features and capabilities, which will drastically improve the way you prepare your favorite coffee, Nanopresso is one of the best and most versatile espresso machines. A truly unique addition to your coffee toolkit!
7798
9982 <div>With a sleek ultra slim design the ZENS Powerbank Wireless Charger is a fantastic space saving way to charge your smartphone everywhere at home in the office or on the go</div> <ul><li> Max 5W output</li> <li>9000mAh capacity recharge your phone up to 4 times</li> <li>Wirelessly charges two devices simultaneously</li> <li>Wirelessly rechargeable</li> <li>USB C cable included</li> <li>Qi certified</li> </ul><p>Designed for quick and intuitive charging this powerbank allows you to charge any compatible smartphone without the tangle of power cords</p> <p>With a strong 4500 mAh capacity this wireless charging solution fuels your mobile device and keeps it going at any place and time</p>
9983 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">The ZENS Single Aluminum Wireless Charger has an ultra thin design that is made from one piece high-grade aluminum and it is designed to efficiently fast charge a single device The charger supports Apple and Samsung fast charge with a maximum output of 10W The charger comes with a braided USB C cable and power adapter</span></li> <li><span class="a-list-item">Charging your device wirelessly has never been easier The charging pad itself is powered via an included USB cable and adapter that features ultra low standby power Charging stops when your phone reaches full charge then resumes as battery life drops Simply place your Qi enabled device on the charger and it will begin charging</span></li> <li><span class="a-list-item">The underlying inductive technology ensures foolproof charging every time your device is placed on the charger Your phone can be freely placed and doesnt have to be locked into position A flawless performance is ensured time and again</span></li> </ul>