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 (
    29778, 29779, 29780, 29781, 29782, 29783, 
    29784, 29785, 29786, 29787, 29788, 
    29789, 29790, 29791, 29792, 29793
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00050

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 (29778,29779,29780,29781,29782,29783,29784,29785,29786,29787,29788,29789,29790,29791,29792,29793)) 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
29778 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Gaming Keyboard and Mouse Set</span></li> <li><span class="a-list-item">Model Number :2000DPI</span></li> <li><span class="a-list-item">Color: Black</span></li> </ul>
29779 <div>Product Description:</div> <div>Colorful LED design is perfectly for any working place especially at night time,Exclusive cooling gaming</div> <div>keyboard to offer the most comfortable gaming environment. Spring type ergonomic design, care for</div> <div>your wrist, long-term use is not easy fatigue. Best choice for seeking trendsetting users. It has some</div> <div>highlight keys and multimedia keys which can be easily used for the serious user.</div> <div> </div> <div>Features:</div> <div>104 keys QWERTY gaming keyboard.</div> <div>Fully backlit colorful LEDs back system with 7 colors.</div> <div>Keystrokes life up to 10 million times, more durable.</div> <div>Multiple water outlets design at the bottom of the keyboard for water draining.</div> <div>Stand structure at the bottom, stable and reliable, avoid move away when you are playing games.</div> <div>With a switch to turn on and off the backlit.</div>
29780 <div>Descriptions: </div> <div>This Baseus Pencil Silicone Holder is made of silicone which is water resistant and dustproof. Also protect the pencil tip. Equipped with a pencil cap. Do not worry about missing cap during charging. </div> <div>Take it with you. Small body yet useful. </div> <div> </div> <div>Main Features: </div> <div>- Made of silicone material, it protects the pencil tip from wearing and the pencil cap from falling off. </div> <div>- The pencil can be stably placed on the holder either in crosswise or lengthwise placement. </div> <div>- The silicone surface boasts fine coating treatment. More aesthetic and dust proof. </div> <div>- There are special places on the bottom of the base to hold the pencil tip and charging converter. </div> <div> </div> <div>Package Content</div> <div>1 x Pencil Holder, </div> <div>1 x Pencil Cap </div>
29781 <span>Material: Imitation leather Style: Business For iPad Pro 11 inch</span>
29782 B07MX6PQFW <div>Product Description:</div> <div>.Slim Wireless Keyboard and Mini Optical Mouse set with tiny USB Receiver.</div> <div>.It is an ideal input device for you PC, Laptop and Notebook.</div> <div>.It adopts 2.4GHz wireless transfer technology, it has strong and secured wireless signal, allows you to enjoy your PC/Laptop from anywhere.</div> <div>.It features new slim keys allowing a smoother and quieter experience when typing!</div> <div>for Mac "style"</div> <div>.New improved 2.4GHz wireless for much greater range(up to 10 Metres),less chance of interference from other nearby wireless devices;</div> <div>.Key stroke life: 5,000,000 times</div> <div>.X scissors foot structure design, unique keys, comfortable and durable</div> <div>.Tiny USB receiver fits discreetly in bottom of mouse and its range Up to 10 Metres(line of sight),but through walls may be varied;</div> <div> </div> <div>Package Including:</div> <div>1 x Wireless Keyboard</div> <div>1 x Wireless Mouse</div> <div>1 x USB Receive</div>
29783 <span>Product Description: .Easy to clean the aquarium without wetting your hands.4 accessories: fishing nets, gravel rake, fork and cleaning sponge make it simple to make aquarium cleanFeatures:.Name:Aquarium Tank Clean Set / Aquarium Cleaner.Material: plastic.Rod with handle length:. Approx 33.5 cmPackage Included:1 * Fishing net1 * Gravel rake1 * Water grass fork1 * Cleaning sponge1 * Rod</span>
29784 <span>Product Description:Magnification: 1.2x 1.8x 2.5x 3.5xBattery: 3AAA battery(Not inxluded for safety)Material:ABS Feature:- Ideal for detailed and small work, such as inspecting jewelry, needlework, PCB check, soldering, reading or any other works requiring a focus on small objects- 4 separated lens: provide 1.2X, 1.8X, 2.5X, 3.5X magnification, all the lenses of this glasses series are interchangeable and can use double lenses- Equipped with adjustable angle bright 3 LED lights allow doing a job even in the dark area, the brightness and the rotating direction ( left to right ) can be adjusted- Adjustable head strap design, fits for different head sizes- Made of high-quality plastic and acrylic optical lenses, durable and wear resistant</span>
29785 Slim Read/Write 3.5 Inch 1.44Mb Mb Floppy Disk Usb External Floppy Disk Drive Diskette Fdd For Laptops
29786 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : 8in1</span></li> <li><span class="a-list-item">Type : Apparel & Accessories</span></li> <li><span class="a-list-item">Sub Type : Animals Bath</span></li> <li><span class="a-list-item">Species : Bats</span></li> <li><span class="a-list-item">Are batteries needed to power the product or is this product a battery : No</span></li> <li><span class="a-list-item">Is this a Dangerous Good or a Hazardous Material, Substance or Waste that is regulated for transportation, storage, and/or disposal? : No</span></li> </ul>
29787 <span>Product Description: .Case for Samsung Galaxy tab S2 8.0 T710 T715 .2 IN 1 tire pattern design .Cool robert stand holder .Great touch feel, Soft to your ipad and hand .Durable lifespam .Made of slected TPU and PC(Outside made of plastic and inside made of soft TPU) Compatible with: For Samsung Galaxy Tab S2 8.0 T710 T715 Package included: 1 x Tire Pattern Case</span>
29788 <span>Product Description:.Material: Aluminum + Engineering Plastics.Handlebar Diameter : 22mm.Size:76mm*45mm*62mm.Weight: 40g.Compass:Has Features:.Aluminum alloy &  engineering plastic, durable.Comes with compass function for riding.Crisp sound,various colors quick and easy to install and release Package include:1 piece of Bicycle Bell</span>
29789 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Accessory Type: Monitor Stands</span></li> <li><span class="a-list-item">Compatible with: PC & Laptop</span></li> <li><span class="a-list-item">Brand: HMOV</span></li> </ul>
29790 <span>Features: This stand is design for Airpods Apple watch iPhone at the same time in one placeNo more mess on your desk, you can use this gadget to organize your devices, making desktop neat and organizedLooks good and elegant, perfectly decorates your bedroom, study, hall, and whole homeCompatible for 3 kinds of devices, for Apple Watch Series 3/Series 2/Series 1/Nike+/Sport/Edition, and work for both 38mm and 42mm for Apple Airpods for iPhone X/8/8 Plus 7/7 Plus/6/6s Plus/SE/5S/5C/5/ Specification:Material: Silicone Color:Black Package:1 x Charging Stand</span>
29791 <div>Product Description</div> <div>Strong compatibility laptop cooling pad</div> <div>Designed for gaming and office use, this cooling pad can support Laptops up to 12."-15.6"</div> <div> </div> <div>Superior Cooling, Whisper Quiet</div> <div>Mute motor andfive large 110mm fans provide superior airflow at whisper quiet noise levels, spinning at over 1,100 RPM. The 12."-15.6" laptop cooler provides a good air flow allowing you to work all day without making any noise and interrupting your flow.</div> <div> </div> <div>Rotatable switch,Eye-catching blue LED light</div> <div>Rotatable switch for adjusting the wind speed of five fans;Eye-catching blue LED light to better know wind speed status of the fans.(The brighter the light is, the faster the speed will be)</div> <div> </div> <div>Ergonomic Comfort</div> <div>With the help of ergonomic adjustable height setting design, the  laptop cooler provides you with the most relaxing incline angle for all-day viewing and tying</div> <div> </div> <div>Extra USB Port</div> <div>Built-in Two USB ports allows to connect other USB device.</div> <div> </div> <div>Slim, Light Weight, and Portable</div> <div>Barely over an inch of thickness and only 600g / 1.14 lb of weight, this laptop cooler is ultra-portable and cool your laptop/notebook wherever you go</div> <div> </div> <div>Product Size:410×330×50mm</div> <div>Fan Size: 110×110×15mm</div> <div>Color: Black</div> <div>Material: Plastic + Metal Mesh</div> <div>Voltage: DC 5.0V</div> <div>Length of USB cable: 60cm</div> <div>Air flow: 13CFM</div> <div> </div> <div>Packaging include</div> <div>1x  laptop cooling pad</div> <div>1 x USB Cable</div> <div>1 x Service Card</div> <div>1 x User Manual </div>
29792 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Other</span></li> <li><span class="a-list-item">Color : Black</span></li> <li><span class="a-list-item">Screen Size : 9.7 Inch</span></li> <li><span class="a-list-item">Compatible with : Apple iPad 5</span></li> <li><span class="a-list-item">Accessory Type : Cases & Covers</span></li> <li><span class="a-list-item">Color Family : Multi Color</span></li> <li><span class="a-list-item">Are batteries needed to power the product or is this product a battery : No</span></li> <li><span class="a-list-item">Is this a Dangerous Good or a Hazardous Material, Substance or Waste that is regulated for transportation, storage, and/or disposal? : No</span></li> </ul>
29793 <div>Product Description:</div> <div>*Durable and washable.</div> <div>*Perfectly fits the device.</div> <div>*Made of PU leather Material.</div> <div>*Protect your from dust, scratching and shock.</div> <div>*Fashion design, easy to put on and easy to take off.</div> <div> </div> <div>Parcel include:</div> <div>1*cover case</div>