Sandbox

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 (
    29843, 29844, 29845, 29846, 29847, 29848, 
    29849, 29850, 29851, 29852, 29853, 
    29854, 29855, 29856, 29857, 29858
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00053

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 (29843,29844,29845,29846,29847,29848,29849,29850,29851,29852,29853,29854,29855,29856,29857,29858)) 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
29843		<ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Accessory Type : Cases & Covers</span></li> <li><span class="a-list-item">Screen Size : 9.7 Inch</span></li> <li><span class="a-list-item">Color Family : Multi Color</span></li> <li><span class="a-list-item">Brand : DUX DUCIS</span></li> <li><span class="a-list-item">Compatible with : Apple iPad</span></li> </ul>
29844		<ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Our sushi roller made of high end food grade plastic to offer you health and fun sushi making experience.</span></li> <li><span class="a-list-item">This sushi making measures only 12" X 2.5" X 2.5" with multipurpose using in your kitchen.</span></li> <li><span class="a-list-item">This sushi bazooka is well know design to easier way of sushi making.</span></li> <li><span class="a-list-item">It is easy to wash after you done your great journey of sushi making, just open and put in dishwasher.</span></li> <li><span class="a-list-item">With our sushi maker you can easily make your perfect sushi roll at home</span></li> </ul>
29845		<span>Material ：PVC+Oxford Cloth Size :42cm27cm29cm Bearing :8kg Pets Weight :1.6kg Style :Backpack Features ：Breathable and Teansparent Package included: 1Piece X Pet Backpack</span>
29846		<div>Product Description:</div> <div>.Made of durable ABS.</div> <div>.Suitable for handlebar diameter about 2.0-2.5cm.</div> <div>.With more than 90 db sound, a loud siren to draw people's attention on street</div> <div>.Keep your kids from danger by warning or noticing others</div> <div>.Easy to be fixed on the bicycle</div> <div> </div> <div>Specification:</div> <div>.Color: Black</div> <div>.Material: ABS plastic</div> <div>.Size: 525373mm</div> <div>.Battery Supply: 2 x AAA Battery(Not Included)</div>
29847		<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">Species : Fish</span></li> <li><span class="a-list-item">Type : Cleaning & Odor Control Supplies</span></li> <li><span class="a-list-item">Sub Type : Filters & Pumps</span><span class="a-list-item"></span></li> </ul>
29848		<div>Product Description:</div> <div>.Designed to fix and protect the propellers in transportation and storage</div> <div>.Avoid damages to the motor due to propeller displacement in transportation or storage</div> <div>.Made of soft plastic,doesn’t scratches the body and the propellers.</div> <div>.Easy to install and remove</div> <div> </div> <div>Packing include:</div> <div>1*props holder(For DJI Spark not included)</div>
29849		<div>Durable and washable.</div> <div> </div> <div>Perfectly fits the shape.</div> <div> </div> <div>Protect your from dust, scratching and shock</div> <div> </div> <div>Fashion design, easy to put on and easy to take off..</div> <div> </div> <div>Protect your valuable investment from scratched and damage. </div> <div> </div> <div>Material:PU leather +plastic </div> <div> </div> <div>Package Content：</div> <div>1 * 1pcs leather case</div>
29850		Durable and washable.<br /><br /><br />Perfectly fits the shape.<br /><br /><br />Protect your from dust, scratching and shock<br /><br /><br />Fashion design, easy to put on and easy to take off..<br /><br /><br />Protect your valuable investment from scratched and damage. <br /><br /><br />Material:PU leather +plastic <br /><br /><br />Package Content：<br />1 * 1pcs leather case
29851		<ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : CoolCold</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> <li><span class="a-list-item">External Product ID Type : Not Available</span></li> </ul>
29852		<div>Product Description:</div> <div>.PU leather front cover + PC hard shell back cover</div> <div>.Stylish and Durable, Easy to install and remove.</div> <div>.offers two different viewing angles：Viewing Angle and Typing Angle.</div> <div>. Drop resistance + shock-proof +Scratch-resistant, full cover protection.</div> <div>.easy access to all buttons, ports.</div> <div> </div> <div>Suitable models：</div> <div>For lenovo tab e7 tb-7104f case</div> <div> </div> <div>Package include:</div> <div>1 leather case </div>
29853		<div>. Specially designed for TomTom Multi-Sport GPS Watch/ TomTom Runner</div> <div>. Premium TPE strap+Hard PC holder,soft and comfortable wear</div> <div>. Light and flexible,porous design,more breathable while sport.</div> <div>. Sweat,rain, splash and water resistant, perfect for sports wear.</div> <div>. Snap in and out,easy to install and remove</div> <div>. Full Screen view</div> <div>. Classic Stainless Steel Buckle</div> <div>. Ajustable One Size fits most</div> <div> </div> <div>Fitment:</div> <div>1. TomTom Multi-Sport + HRM</div> <div>2. TomTom Multi-Sport + HRM+CSS+AM</div> <div>3. TomTom Multi-Sport Cardio Watch</div> <div>4. TomTom Multi-Sport GPS Watch</div> <div>5. TomTom Runner</div> <div>6. TomTom Runner + HRM</div> <div>7. TomTom Runner Cardio</div> <div> </div>
29854		<ul><li>Specification</li> <li>* TPU material with transparent design make your watch show its true color clearly, you can hardly feel the clear case on your watch.</li> <li> </li> <li>* Designed Specifically for Apple Watch Series 4 2018 Edition 44mm Only. </li> <li> </li> <li>* Case only, do not include screen protector, so you will not be worried about sweat buildup under the screen protector after a workout. The case is suited for any occasions in your daily life.</li> <li> </li> <li>Package Contains:</li> <li>1x tpu case</li> </ul><br /><br /><br /><br /><br /><br />
29855		<div>Product Description:</div> <div>.Designed for DJI Mavic Pro</div> <div>.Protect the gimbal and camera during transportation and storage</div> <div>.Easy to install and remove</div> <div> </div> <div>Packing include:</div> <div>1*Gimbal Lock Clamp</div>
29856		<ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">MUST-HAVE - Protect your bike from dust, weather, snow, ice, rain, sun UV, sand blowing, mucus, birds, insects and other nature elements and keeps it always in a good condition. Every time you want to ride a bicycle, your motorcycle will be clean and tidy.</span></li> <li><span class="a-list-item">ADAPTABLE DESIGN - motorcycle cover can be used for off-road and off-road standard motorcycles up to 108 inch; it fits 99% off-road standard size bikes on the market.</span></li> <li><span class="a-list-item">HARSH ENVIRONMENT PROOF - The large size covers the entire motorcycle, and the bottom is tightly stitched and heavy-duty buckle to withstand any rain, storm or wind.</span></li> <li><span class="a-list-item">HIGHEST QUALITY - Made of quality polyester fabric and PU material, no wear, mildew, waterproof, light weight and maintain its softness.</span></li> </ul>
29857		<ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Razer</span></li> <li><span class="a-list-item">Compatible with : Mouse</span></li> <li><span class="a-list-item">Accessory Type : Mouse Pad</span></li> </ul>
29858		<ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Type : Shoe Covers</span></li> <li><span class="a-list-item">Brand : Other</span></li> <li><span class="a-list-item">Size XL : Suitable for 41-42 yards</span></li> <li><span class="a-list-item">Length : 29.5cm/11.61in</span></li> <li><span class="a-list-item">This pair of rain shoe covers can prevent rain and mud from your shoes, keeping your shoes dry and clean in rainy days</span></li> </ul>