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 (
    30702, 30703, 30704, 30705, 30706, 30707, 
    30708, 30709, 30710, 30711, 30712, 
    30713, 30714, 30715, 30716, 30717, 
    30718, 30719, 30720, 30721, 30722, 
    30723, 30724, 30725, 30726, 30727, 
    30728, 30729, 30730, 30731, 30732, 
    30733
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00099

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "76.81"
    },
    "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": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (30702,30703,30704,30705,30706,30707,30708,30709,30710,30711,30712,30713,30714,30715,30716,30717,30718,30719,30720,30721,30722,30723,30724,30725,30726,30727,30728,30729,30730,30731,30732,30733)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "70.41",
        "eval_cost": "6.40",
        "prefix_cost": "76.81",
        "data_read_per_join": "122K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
30702 <div>Features:</div> <div>perfect workout partner for the Active listener.</div> <div>With Gear icon, you'll enjoy superior audio in a totally cable-free Package that includes stabilizing, Wing tipped ear gels.</div> <div>Ideal for a workout session. Users can stream music directly from their phone, or use the Built-in music player and not have to worry about carrying their phone to the gym or on those long walks or runs.</div> <div>Truly cable-free design with comfortable, stabilizing ear gels to keep the headset where it belongs and a charging carrying case, for storage and charging when not in use</div> <div>Coating for splash and sweat resistance</div> <div> </div> <div>Specification:</div> <div>Bluetooth version:V4.1 + EDR</div> <div>Bluetooth profiles:Hands free / Headset</div> <div>Transmission range:10 m</div> <div>Charging Power:AC input 110-240V DC output 5V (charging time / about 2 hours / charging voltage 3.7v)</div> <div>4 hours talk time (music playback 3 hours / standby time 120 hours / working current <15mA)</div> <div>Noise MIC:special top silicon Marks</div> <div>Wearing styles:Ear / Stealth headphones patented product</div> <div>Battery type:50mA rechargeable lithium battery</div> <div>Dimensions:26.4x18.9x26mm</div> <div> </div> <div>Package Includes:</div> <div>2xEarbuds</div> <div>2xWingtip</div> <div>2xEartip</div> <div>1xCharging case</div> <div>1xUSB cable</div> <div>1xQuick Start Guide</div> <div> </div>
30703
30704 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Manufacturer Number : AM-8899</span></li> <li><span class="a-list-item">Accessory Type : Case</span></li> <li><span class="a-list-item">Targeted Group : Unisex</span></li> <li><span class="a-list-item">Type : Smart Watches</span></li> <li><span class="a-list-item">Brand : Other</span></li> </ul>
30705 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : PGYTECH</span></li> <li><span class="a-list-item">Manufacturer Number : 1</span></li> <li><span class="a-list-item">Compatible with : Digital Camera</span></li> <li><span class="a-list-item">Accessory Type : Mounts</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>
30706 <div>Model No: UP-8T</div> <div>Material: Aluminum Alloy, ABS,</div> <div>Viewing Height Adjustable: 610-900mm</div> <div>Stand Column height: 900mm</div> <div>Arm length: 420mm</div> <div>Laptop Tray size: 535x360mm</div> <div> </div>
30707 <ul class="generatedBullets"><li>Manufacturer Number : 1</li> <li>Accessory Type : Cases & Covers</li> <li>Screen Size : 10.1 Inch</li> <li>Color Family : Blue</li> <li>Brand : Other</li> <li>Compatible with : Lenovo Tab M10</li> </ul>
30708 <div>Description:</div> <div>Specifically Designed for HUAWEI Honor FlyPods</div> <div>Protect your Headset against bumps, drops and shock without adding bulk to your charging case, provides full protection for your Headset.</div> <div>Made of durable impact-resistant silicone rubber.</div> <div>It brings super thin feelings, and offers wonderful grip. </div> <div>Easy access to the charging port.</div> <div> </div> <div>Specification:</div> <div>Type: Case cover.</div> <div>Material: Silicone.</div> <div>Size: for HUAWEI Honor FlyPods Charging box</div> <div> </div> <div>Package include:</div> <div>1x Silicone Case</div> <div>1x Metal Carabiner Hook</div>
30709 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Manufacturer Number : 1</span></li> <li><span class="a-list-item">Accessory Type : Lens Filter</span></li> <li><span class="a-list-item">Compatible with : Digital Camera</span></li> <li><span class="a-list-item">Brand : Ulanzi</span></li> </ul>
30710 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Manufacturer Number : CAM-OS-P-125</span></li> <li><span class="a-list-item">Accessory Type : Lens Filter</span></li> <li><span class="a-list-item">Compatible with : Digital Camera</span></li> <li><span class="a-list-item">Brand : Sunnylife </span></li> </ul>
30711 <ul class="generatedBullets"><li>Manufacturer Number : 1</li> <li>Accessory Type : Cases & Covers</li> <li>Screen Size : 10 Inch</li> <li>Color Family : Black</li> <li>Brand : Other</li> <li>Compatible with : Huawei mediapad M5</li> </ul>
30712 <span>Specification: Material: PU+PC Model: FOR flypods pro Weight: 0.12KG Product features: protect the earphones, anti-lost and scratch Packing list: 1*PU case for flypods 1*Buckle Buyer NOTICE: It Is only a case For Huawei Flypods , Not include earphone and charger</span>
30713 <div>Instructions: </div> <div>. Attach the bottom sticker on the body portion by aligning it with the LED indicator light. </div> <div>. Place the top sticker upside down on the bottom portion so that the adhesive side faces upwards on the body portion. </div> <div>. Close lid over the upward facing dust guard so that it sticks perfectly to the inner ceiling once shut. </div> <div>. Place your fingers in the AirPods inserts to check if the dust guard is applied properly</div> <div>. If it is not attached properly, it can scratch the AirPods.</div> <div> </div> <div>Features:</div> <div>.Premium metal material ensures maximum strength and durability for long lasting usage.</div> <div>.The thickness of the plate is 0.04mm</div> <div>.Experience flawless use of the case with the dust guard installed.</div> <div>.Easy to clean after patching, dustproof stickers do not harm Airpods.</div> <div>.No cutting needed</div> <div>.Easy to apply without air bubbles, leaves no residue when removed.</div> <div> </div>
30714 <div>Instructions: </div> <div>. Attach the bottom sticker on the body portion by aligning it with the LED indicator light. </div> <div>. Place the top sticker upside down on the bottom portion so that the adhesive side faces upwards on the body portion. </div> <div>. Close lid over the upward facing dust guard so that it sticks perfectly to the inner ceiling once shut. </div> <div>. Place your fingers in the AirPods inserts to check if the dust guard is applied properly</div> <div>. If it is not attached properly, it can scratch the AirPods.</div> <div> </div> <div>Features:</div> <div>.Premium metal material ensures maximum strength and durability for long lasting usage.</div> <div>.The thickness of the plate is 0.04mm</div> <div>.Experience flawless use of the case with the dust guard installed.</div> <div>.Easy to clean after patching, dustproof stickers do not harm Airpods.</div> <div>.No cutting needed</div> <div>.Easy to apply without air bubbles, leaves no residue when removed.</div> <div> </div> <div>Specification:</div> <div>Material: Metal</div> <div>Type: Accessories</div> <div>Length: 4.1cm/ 1.61in</div> <div>Width: 1.8cm/ 0.71in</div>
30715 <div class="a-section a-spacing-extra-large"> <div class="feature"> <div class="a-row feature"> <div class="a-section a-spacing-small"> <p>Bluetooth Version; BT5.0  Earphone Charging Time: ^2h Bluetooth Distance: 20m  Frequency: 20Hz-20KHz Talk Time: 5-7h  Microphone: -42dB Earphone Battery: 3.7V 60mA*2  3 Party Call: Support Base Battery: 2600mA LED Lamp Color: Red Blue And Two-Color LED Lamp Support For Bluetooth Protocol: A2DP.AVRCP.HFP.HSP.SPP</p> </div> </div> </div> </div> <div class="feature"> </div> <div> </div> <div> </div> <div class="celwidget"> <div> </div> <div> <div class="celwidget"> <div class="askInlineWidget"> </div> </div> </div> </div>
30716 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Accessory Type : Covers</span></li> <li><span class="a-list-item">Brand : Other</span></li> </ul>
30717 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Jewlery Type : Set</span></li> <li><span class="a-list-item">Brand : Other</span></li> </ul>
30718 <p class="a-size-large a-spacing-none"><span class="a-size-large">Right only Flydigi Stinger Gaming Trigger for PUBG mobile FORTNITE and more</span></p>
30719 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Manufacturer Number : WST123</span></li> <li><span class="a-list-item">Type : Desk Accessories & Workspace Organizers</span></li> <li><span class="a-list-item">Brand : Rubik</span></li> </ul>
30720 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Manufacturer Number : 9601443174249</span></li> <li><span class="a-list-item">Microphone included : 1</span></li> <li><span class="a-list-item">External Product ID : Huawei Honor xsport</span></li> <li><span class="a-list-item">Brand : Huawei</span></li> <li><span class="a-list-item">External Product ID Type : Not Available</span></li> <li><span class="a-list-item">Connectivity : Wireless</span></li> <li><span class="a-list-item">Model Number : AM61</span></li> </ul><div class="a-row a-expander-container a-expander-inline-container"> <div class="a-expander-content a-expander-extend-content a-expander-content-expanded"> <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Type : In Ear</span></li> <li><span class="a-list-item">Compatible with : All</span></li> <li><span class="a-list-item">Noise Cancelling : 0</span></li> </ul></div> </div>
30721 <span>Brand : Other Manufacturer Number : i10 TWS Color : White Model Number : i10 tws Connectivity : Wireless Compatible with : All Type : In Ear Microphone included : Yes Noise Cancelling : Yes Are batteries needed to power the product or is this product a battery : Yes Is this a Dangerous Good or a Hazardous Material, Substance or Waste that is regulated for transportation, storage, and/or disposal? : No External Product ID Type : EAN-8 null : i10 Tws</span>
30722 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">[Shooting button design]: metal plate buckle design, the hand can be placed on the back of the phone is no longer so tired, the button is physically triggered, it will not be triggered by mistake</span></li> <li><span class="a-list-item">[Cooling fan +shooting button]: The fan can effectively reduce the temperature of the phone, use the shooting button to play PUBG, 4 finger linkage, one step faster</span></li> <li><span class="a-list-item">[4000mAh battery]: Long battery life, Fully charged battery can provide about 48 hours of fan cooling, while also providing emergency charging function for your mobile phone, playing games no longer pit teammates</span></li> <li><span class="a-list-item">[Silicone joystick]: water-soluble silicone material, very durable, can be used on the screen of the touch screen device to play the game</span></li> <li><span class="a-list-item">This controller fits different sizes of smartphones up to 6.5 inches in size, make sure your phones size and dimensions are supported before you order it.This controller may not fit some thick phone cases, in this case, please remove the case and adjust your phone, repeating instructions for setting up controls.</span></li> </ul>
30723 <strong>About the product<span> </span></strong><br /><span>This luggage cover is made of durable 250 grams material, 15% spandex and 139% polyester.</span><br /><span>Thickness cover can protect your luggage against scratch and dust.</span><br /><span>Highlight your personalized</span>
30724 <span>Model: PG-9121 Functions: Bluetooth Bluetooth Version:4.0 Suitable for (iOS11.0 or higher system) Features: Battery,Charger Connection Type: Bluetooth BT 4.0 transmission distance:<8M PowerStandy time:30 day Support continues playing up to 20H Package Contents 1 x Gamepad 1 x USB Cable 1 x User Manual</span>
30725 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item"><span>Brand: Other</span></span></li> <li><span class="a-list-item"><span>Compatible with: Multi</span></span></li> <li><span class="a-list-item"><span>Accessory type: Game controllers for smartphones</span></span></li> <li><span class="a-list-item">Are batteries needed to power the product or is this product a battery : 0</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? : 0</span></li> </ul>
30726 <span>Model:DDHBC02NEB Wireles Connectivity:Bluetooth 4.0 BLE and above Max.Input Voltage:42V Output Current:1.7A CMIIT ID:2018DP2094 Compatible with:Android 4.3 or iOS 9.0 and above GROSS Weight:Approx.18.2kg Mi Electric Sctooter Pro,charging adapter,t-shape allen key,extension nozzle,screw*5,user manual,legal statement,quick start guide,maintenance card,,warranty notice</span>
30727 <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">Compatible with : Multi</span></li> <li><span class="a-list-item">Accessory Type : Controllers</span></li> <li><span class="a-list-item">Are batteries needed to power the product or is this product a battery : 0</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? : 0</span></li> </ul>
30728 <p class="a-size-large a-spacing-none"><span class="a-size-large">Wasp N for iPhone 6-8plus Mobile Gaming Controller For PUBG/FORTNITE and more</span></p>
30729 <span>Large Silicone Sports Replacement Watch Band Wrist Strap For Huawei Watch GT</span><br /><span>Feature:</span><br /><span>New fashionable pattern style,colorful,comfortable,durable,cute and stylish,you will get a outstanding wear experience</span><br /><span>Made of silicone,the bands are more durable and provide a comfortable wearing experience.Eco-friendly and safe for the human skin.It is skin-friendly and provides comfortable feeling when you wear it during sleep</span><br /><span>Durable and unique design for Huawei Watch GT, improves airflow and comfort, which brings you a comfortable wearing experience.</span><br /><span>Pratical Function - our classic replacement bands for Huawei Watch GT are sweat,rain, splash and water resistant, intended for high intensity workouts.</span><br /><span>Add a new style/a gift replacement band for watch, attractive dynamic sport wristband for women, men, girls and boys.</span><br /><span>Specification:</span><br /><span>Material: skin-friendly Soft Silicone</span><br /><span>Product weight: 0.015 kg</span><br /><span>Function: Replacement Strap</span><br /><span>Size: Large</span><br /><span>Length: 230mm</span><br /><span>Strap width: 22mm</span><br /><span>Compatible For Huawei Watch GT</span><br /><span>Package includes:</span><br /><span>1 x Fashion Sport Texture Soft Silicone Replacement Watch Band Wrist Strap</span>
30730 <div class="disclaim">Color:<strong>Black</strong></div> <p><br />Stainless Steel Bracelet Quick Replacement Watch Band Strap For Huawei Watch GT<br />Feature:<br />100% brand new and high quality<br />Elegant stainless steel metal link strap<br />Premium 316L stainless steel polished by several steps and colored by vacuum plating.<br />Classic version for Huawei Watch GT and feels comfortable on your wrist Hence it is more wearable and corrosion-resisting, and never will be rusty. Refined dual fold-over clasp design, easily to take on/remove, safe & fashion Premium stainless steel metal features luxury, nobility, elegance & durability Length: 175mm Strap width: 22mm<br />Package Content:<br />1 X Luxury Stainless Steel Strap Wrist Band Bracelet Replacement For Huawei Watch GT</p>
30731 <br /><span>Large Silicone Sports Replacement Watch Band Wrist Strap For Huawei Watch GT</span><br /><span>Feature:</span><br /><span>New fashionable pattern style,colorful,comfortable,durable,cute and stylish,you will get a outstanding wear experience</span><br /><span>Made of silicone,the bands are more durable and provide a comfortable wearing experience.Eco-friendly and safe for the human skin.It is skin-friendly and provides comfortable feeling when you wear it during sleep</span><br /><span>Durable and unique design for Huawei Watch GT, improves airflow and comfort, which brings you a comfortable wearing experience.</span><br /><span>Pratical Function - our classic replacement bands for Huawei Watch GT are sweat,rain, splash and water resistant, intended for high intensity workouts.</span><br /><span>Add a new style/a gift replacement band for watch, attractive dynamic sport wristband for women, men, girls and boys.</span><br /><span>Specification:</span><br /><span>Material: skin-friendly Soft Silicone</span><br /><span>Product weight: 0.015 kg</span><br /><span>Function: Replacement Strap</span><br /><span>Size: Large</span><br /><span>Length: 230mm</span><br /><span>Strap width: 22mm</span><br /><span>Compatible For Huawei Watch GT</span><br /><span>Package includes:</span><br /><span>1 x Fashion Sport Texture Soft Silicone Replacement Watch Band Wrist Strap</span>
30732 <span>Silicone Sports Replacement Watch Band Wrist Strap For Huawei Watch GT Smart Watch 22mm</span><br /><span>Feature:</span><br /><span>New fashionable pattern style,colorful,comfortable,durable,cute and stylish,you will get a outstanding wear experience</span><br /><span>Made of silicone,the bands are more durable and provide a comfortable wearing experience.Eco-friendly and safe for the human skin.It is skin-friendly and provides comfortable feeling when you wear it during sleep</span><br /><span>Durable and unique design for Huawei Watch GT smart watch, improves airflow and comfort, which brings you a comfortable wearing experience.</span><br /><span>Pratical Function - our classic replacement bands for Huawei Watch GT are sweat,rain, splash and water resistant, intended for high intensity workouts.</span><br /><span>Add a new style/a gift replacement band for watch, attractive dynamic sport wristband for women, men, girls and boys.</span><br /><span>Specification:</span><br /><span>Material: skin-friendly Soft Silicone</span><br /><span>Product weight: 0.015 kg</span><br /><span>Function: Replacement Strap</span><br /><span>Size: Large Length: 5.5-8.1inch</span><br /><span>Strap width: 22mm</span><br /><span>Package includes:</span><br /><span>1 x Fashion Sport Texture Soft Silicone Replacement Watch Band Wrist Strap</span>
30733 <br /><span>Silicone Anti-lost Protective Cover Skin Case for Apple AirPods 2 Charging Case Features:</span><br /><span>High Quality Material - Made of durable impact-resistant silicone rubber. It brings super comfortable feelings, and offers wonderful grip.</span><br /><span>All Round Protection - 360 Full protection design, high quality silicone Airpods cover effectively absorb impact, protect your Airpods from accident drop and scratches.</span><br /><span>Convenient Charging Case - Excellent workmanship to ensure quality cut-out on the bottom for the lightning port. Don't need to take out of the case when charging.</span><br /><span>Anti-lost Design - Comes with a AirPods soft silicone strap, ideal when hiking/running, need not worry that your expensive earbuds will fall out and get stepped on or lost.</span><br /><span>Ultra Lightweight - protect your AirPods against bumps, drops and shock without adding bulk to your charging case.</span><br /><span>Specification:</span><br /><span>Compatible Model For Apple AirPod 2th case</span><br /><span>Material Silicone</span><br /><span>Package Includes:</span><br /><span>1 x Airpods Case (Airpods NOT included)</span>