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 (
    30669, 30670, 30671, 30672, 30673, 30674, 
    30675, 30676, 30677, 30678, 30679, 
    30680, 30681, 30682, 30683, 30684
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00065

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 (30669,30670,30671,30672,30673,30674,30675,30676,30677,30678,30679,30680,30681,30682,30683,30684)) 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
30669 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">MAKE YOUR KITCHEN SHINE - These Pineapple shaped Copper-Finish Mugs will really stand out in your kitchen and impress your friends. The shiny copper exterior glimmers wherever it is placed, and it's the perfect staple for the host or party-thrower. These mugs are externally lacquered to maintain the luster and last a long time unlike other mugs. Beautiful yet functional!</span></li> <li><span class="a-list-item">FEATURES - Pineapple shape with Straw; High quality stainless steel; Tarnish resistant finish; Uniquely designed to keep beverages COLD!</span></li> <li><span class="a-list-item">100% FOOD GRADE SAFE- Our mugs/cups are 100% Food Grade Safe which means you do not have to worry about chemicals being absorbed into your beverages. This issue comes about with the 100% copper moscow mules which are products AVOID</span></li> <li><span class="a-list-item">FEATURES - Pineapple shape with Straw; High quality stainless steel; Tarnish resistant finish; Uniquely designed to keep beverages COLD!</span></li> <li><span class="a-list-item">HOW TO CLEAN - Hand Wash Only with non-abrasive sponge and gentile detergent. To dry and maintain clean finish</span></li> </ul>
30670 <h2 class="default">oduct description</h2> <div class="a-section a-spacing-small"> <p> </p> <div>Product Description: </div> <div>. The car must be launched when use the car-type.</div> <div>. First, insert the plug into the cigarette lighter socket or12V power supply jack.</div> <div>. Then, plug the other end of the cable insert into the 12VDC jack or into the dual-use 220v jack ( jack at the bottom of the front panel ).</div> <div>. Later, dial the switch to the heating or cooling position and check the corresponding LED (heating: red light; cooling: green light).</div> <div>. It will take 15 minutes or 30 minutes to cool or heat (the duration of cooling or heating depends on the ambient temperature).</div> <div>. Before put into the food or beverage, first warm or cold, so that you can get better effect.</div> <div>. It takes 2-3 hours to freeze unfrozen food and drink. The design of car small refrigerator is not used to freeze food, mainly used heat preservation! According to the instructions properly to use, the food can be kept warm for several hours.</div> <div> </div> <div>Specifications:</div> <div>. Material: Food grade ABS</div> <div>. Capacity: 6L</div> <div>. Power: 30W</div> <div>. Input voltage: 12V (car type) or 220v, 12v (car dual-use type)</div> <div>. Fuse specifications: 10A</div> <div>. Heating temperature: heating to 65 ℃ or so</div> <div>. Refrigeration temperature: lower than the ambient temperature of about 5-10 ℃</div> <div>. The refrigerator is equipped with a cooling fan, the fan will sound when working.</div> <div>. Size: about 32.5 * 18 * 30 cm / 12.80 * 7.09 * 11.81 in</div> </div>
30671 <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">Manufacturer Number : i10 TWS</span></li> <li><span class="a-list-item">Color : White</span></li> <li><span class="a-list-item">Model Number : i10 tws</span></li> <li><span class="a-list-item">Connectivity : Wireless</span></li> <li><span class="a-list-item">Compatible with : All</span></li> <li><span class="a-list-item">Type : In Ear</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">Microphone included : Yes</span></li> <li><span class="a-list-item">Noise Cancelling : Yes</span></li> <li><span class="a-list-item">Are batteries needed to power the product or is this product a battery : Yes</span></li> </ul></div> </div>
30672 <div>Features:</div> <div>Optical-Grade Tempered Glass: protect your devices from scratches and high-impact drops</div> <div>9H Hardness. Even objects such as knives and keys will not scratch tempered glass</div> <div>Real Touch Sensitivity: Natural feel that provides flawless touch screen accuracy</div> <div>Bubble Free: Self-adhering surface to prevent bubble generation for easy installation</div> <div>Oleophobic coating: Prevent fingerprints and other oil contaminants</div> <div>UV Protection: Reduces eye strain caused by your screen</div> <div>Shatter Proof Glass: if broken, the tempered glass breaks into small pieces that are not sharp, making it safer than other glass products</div> <div>Pre-cut to fit your screen exactly</div> <div> </div> <div>Package Included:          </div> <div>2* Premium Tempered Glass Screen Protector</div> <div>2*Wet/dry Clearing Wipes</div> <div>2*Dust Remove Paper</div> <div> </div>
30673 <div>Feature:</div> <div>. compatible with DJI osmo pocket adapter and cover</div> <div>. prevent to lost your type C or lightning plug</div> <div>. small size, easy to take</div>
30674 <div>Product Description:</div> <div>FIT FOR NINTENDO SWITCH JOY-CONTROLLER </div> <div>CNTROLLER GRIP FOR LEFT-RIGHT GAMEPAD.</div> <div> </div> <div>PACKAGE:</div> <div>2 X CONTROLLER GRIP FOR NINTENDO JOY-CON WITH BOX</div> <div> </div>
30675 <div>Packing Including:</div> <div>2 X Tempered Glass Screen Protector</div> <div>2 X Alcohol swab</div> <div>2 X Cleaning Cloth</div>
30676 <span>PLUG AND PLAY, Use the Lightning Digital AV Cable with your iPhone, iPad or iPod with Lightning connector1080P HD, The Lightning Digital AV Cable supports mirroring of what is displayed on your device screen - including apps, presentations, websites, slideshows and more - to your HDMI-equipped TV, display, projector or other compatible display in up to 1080p HDVIDEO AND CHARGE,It also outputs video content - films, TV programmes, captured video - to your big screen in up to 1080p HD8 CHANNEL DIGITAL AUDIO, Simply attach the Lightning Digital AV Cable to the Lightning connector on your device and then to your TV or projectorCompatible with iPhone 7, 7 Plus, iPhone 5,5c,5s,SE,6,6 Plus,6S,6S Plus; iPad with Retina Display,iPad mini,mini 2,mini 3,mini 4,Air, Air 2,iPad Pro(9.7-Inch) and iPad Pro(12.9-Inch); iPod Touch 5th Gen(32gb and 64GB),iPod Touch 5th Gen 16gb,iPod touch 6th Generation</span>
30677 <span>Bring your feet and body to life foot massager, This pair of therapeutic slippers has spring massaging tips which stimulate different acupuncture points to provide a relaxing feel as you heal your whole body. The slippers promotes several health benefits such as blood circulation, eliminates fatigue, balances your endocrine system, enhances your metabolism to prevent aging, strengthens your immune system to fight disease, and improves sleep by easing the tension in your nerves among others. Product Features: Improves blood circulation and relieves fatigue Removes toxins Improves balance of the endocrine system Strengthens metabolism Helps to stay young Improves sleep and alleviates nervous tension High-quality rubber and plastic materials Guarantees maximum durability and full functionality Size: 44 to 45 cm</span>
30678 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Type : Adapters</span></li> <li><span class="a-list-item">Compatible with : Computers - PCs</span></li> <li><span class="a-list-item">Brand : Other</span></li> </ul>
30679 <div>Product Description</div> <div>.Model Number:MD759</div> <div>.Drum Heads Material: silicone</div> <div>.Drum Chamber Material: silicone</div> <div>.Colours: black</div> <div>.Material: Silicon</div> <div>.foldable: yes</div> <div>.Interface: USB 2.0</div> <div>.Size: L442xW259 x H10mm</div> <div>.Drum pad size: 39(L) x 27.5(W) x 2.5 (H)cm</div> <div>.Support pc or ipad various MIDI electronic drum games.</div> <div>.7 drum surface: 1 crash cymbal, 1 ride cymbal, 1 snare, 3 tom. Two pedal(1 hi-hat, 1 bass drum)</div> <div> <div>Features:</div> <div>This customizable, lightweight, and portable instrument kit gives today\'s modern technology and look over the traditional and bulky drum sets. Play the drums to prerecorded drum kits and songs -like soft rock, hard rock, electronic, pop, jazz, and much more - or record your own!</div> <div>.2 high quality built-in speakers bring super bass effect.</div> <div>.7 tritone standard drum pads.</div> <div>.Use pedal,hi-hat simulate the real effect.</div> <div>.You can play pop, rock, Latin, electronic and other styles.</div> <div>.USB MIDI JACK, connect with compputer to play midi software and drum games.(Only MD759 has this function, MIDI software: Sonar, Cubase, Nuendo, Ezdrummer)</div> <div>.Built-in metronome basic fucntions,training a good sense of rhythm.</div> <div>.An external headphone output,you can practice without disturbing others.</div> <div>.Drums using pedal simulation,hands and feel like real drums exercises.</div> <div>.Micro USB can be simultaneously powered and connected with the computer.</div> <div>.Hi-hat and snare drum position can be interchangeable to suit the player\'s handedness.</div> </div>
30680 <div>Product Description:</div> <div>-This padded bag is a great way to protect your Digital DSLR from accidental damage and scratches with its tough and durable foam exterior and its padded anti-shock interior.</div> <div>-This bag is universally designed to fit almost all digital cameras on the market. You will find space for accessories along with your memory cards and cables etc......</div> <div>-Protects the DSLR from scratches and dust</div> <div>-Soft Carrying case for DSLR</div> <div>-New design id featuring design with black trim</div> <div>-Increased interior capacity</div> <div>-Improved access to side pockets</div> <div>-Stain resistant Nylon</div> <div> </div> <div>Specification:</div> <div>.Material: Nylon</div> <div>.Dimensions (Approx.) : W: 170mm x H: 200mm x D: 110mm</div> <div>.Compatible for Nikon D3, D3x, D40, D40x, D50, D60, D70, D70S, D80, D90, D100, D200, D300, D700, D3000, D300S, D5000, and many more.</div> <div>.Note: Please measure your camera to make sure the size of Camera Case fit your camera before bidding,thanks a lot. </div> <div> </div> <div>Package Content:</div> <div>1x DSLR Digital Camera Bag </div> <div>1x Shoulder</div> <div> </div>
30681 <div>Product Description:</div> <div>. Ultra Slim and Light Weight, Classic Designed Appearance Designed.</div> <div>. Support DOS Start and System Recovery.</div> <div>. New Inport Chip, Power Ability to Correct Errors, Shockproof, Low Level Noise.</div> <div>. Route Optimalizing Design for Power Saving and Low Power Consumption, NO External Power Required.</div> <div>. Easy to install, Plug and Play, No Any Driver Required(Excluded Windows 98SE).</div> <div>. Intelligent Replication Technology, easy to Pause/ Record Files.</div> <div>. With enject button designed.</div> <div>. Compatible with All Laptop and PC with USB Port</div> <div> </div> <div>Specification:</div> <div>Write Speed:</div> <div>5X Speed DVD-RAM Writing</div> <div>8X Speed DVD +R Writing</div> <div>8X Speed DVD-R Writing</div> <div>8X Speed DVD +RW Writing</div> <div>8X Speed DVD-RW Writing</div> <div>DVD+R9 Dual Layer=6X 8.5GB Writing</div> <div>DVD-R9 Dual Layer=6X 8.5GB Writing</div> <div>Reading Speed:</div> <div>24X Speed DVD-ROM Reading</div> <div>24X Speed CD-ROM Reading</div> <div>Buffer Under Run Protection</div> <div>DMA66 support</div> <div> </div> <div>What is included:</div> <div>1 x USB 3.0 External DVD CD Drive for Macbook</div> <div>1 x User Manual</div>
30682 <div>Feature:</div> <div>.Inside the case for AirPods, there are nine magnets that can gather a lot of iron/metal dust over time</div> <div>.This dust guard can be as a buffer between the case and the cumulative metallic dust over time</div> <div>. When in need, you can replace it without much effort</div> <div>.It may be hard and require some time to align the stickers for AirPods</div> <div>. However, as it is made of metal, it is easier to install and clean</div> <div>.The plate thickness is only 0.04mm. If you install the dust guard, you can use the case smoothly</div> <div>.A wonderful protection for AirPods</div> <div> </div> <div>Specification:</div> <div>Material:Metal</div> <div>Size(Length x Width x Thickness):41.2x17.5x0.04mm</div> <div>Type:Dust Guard</div> <div>Theme:Houses</div>
30683 <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">Brand : PGYTECH</span></li> <li><span class="a-list-item">Mobile Accessory Type : Mounts & Holders</span></li> <li><span class="a-list-item">Compatible Devices Model : Multi</span></li> <li><span class="a-list-item">Color Family : Black</span></li> <li><span class="a-list-item">Compatible with : Multi</span></li> </ul>
30684 <ul class="generatedBullets"><li>Accessory Type : USB Fan</li> <li>Compatible with : Laptop</li> <li>Brand : Other</li> <li>Manufacturer Number : Not Available</li> <li></li> <li>USB Port Connection: Our cooling fan pad provide plug-and play usb connection, it works with for MacBook Pro / Air, for Dell, for ASUS and most laptop</li> <li>Superior Quality: Air-cooled laptop cooler has a built in high speed motor, enables excellent airflow and greater heat displacement. The measured drop is 20 to 30 degrees</li> <li>Non-slip design: The air external extracting cooling fan has the super powerful dual sides skid-resistant effect, more firm and convenient</li> <li>High Compatibility and Compact: COOLCOLD cooler is slim, portable and light weight with 3 different size wind sleeve provides a stable supports for various laptops sizes</li> <li>Fan Cooler and Adjustable Speed: The laptop air extracting fan coooler which absolutely helps to dissipate the heat-air away from underneath to prevent your laptop from getting hot during extended gaming or streaming sessions</li> </ul>