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 (
    30880, 30881, 30882, 30883, 30884, 30885, 
    30886, 30887, 30888, 30889, 30890, 
    30891, 30892, 30893, 30894, 30895
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00054

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 (30880,30881,30882,30883,30884,30885,30886,30887,30888,30889,30890,30891,30892,30893,30894,30895)) 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
30880 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Perfect warm glow , Transform your spaces and events</span></li> <li><span class="a-list-item">Your Life,You Choose ; Your Home,You Decide ; Your Style,You Create</span></li> <li><span class="a-list-item">Home decor clearance home decorations for living room home decor farmhouse</span></li> <li><span class="a-list-item">Homes for sale home goods</span></li> <li><span class="a-list-item">Alone homecoming sweet home gift for her him</span></li> </ul>
30881 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Perfect warm glow , Transform your spaces and events</span></li> <li><span class="a-list-item">Your Life,You Choose ; Your Home,You Decide ; Your Style,You Create</span></li> <li><span class="a-list-item">Home decor clearance home decorations for living room home decor farmhouse</span></li> <li><span class="a-list-item">Homes for sale home goods</span></li> <li><span class="a-list-item">Alone homecoming sweet home gift for her him</span></li> </ul>
30882 <br />20 Pcs Super Gripping Pad Clear Anti Slip Pads Kitchen Car Holder Super Easy Gripping Pad<br /><br />Features:<br /><br />New design Gift: PU Gel Pad Sticker<br /><br />Washable and Reusable<br /><br />Can be easily removed without damaging anything Indoor or Outdoor Use<br /><br />Removable double sided super grip!<br /><br />Easily Mount Any Object,Anywhere,Just Peel,Stick and Grip!<br /><br />Keeps in the place,Till you remove it<br /><br />Double Sided Grip Pads-So Strong Holds up to 5lbs!<br /><br />Perfect for the Kitchen,Car and More!<br /><br />Holds it all: Eyeglasses,Ez Pass/Cell Phone,Hooks,iPad in Kitchen,Tools,Memo Pads on Fridge,<br /><br />Hold Down Rugs,Bath Accessories<br /><br />Pads will hang and hold objects anywhere in just a matter of seconds. The Hanging Pads are also reusable and Washable. Simply rinse and they are ready to use again – up to 1,000 times!<br /><br />The Pad works on metal and tile to keeps things handy, and sticks on wood and glass like nothing else can. Keep all your remotes handy to create more table space, or use it to keep that door mat in place.<br /><br />Super Pads are quite similar to other products that are available to hang things around the house. With pad , you can hang objects on any surface, including wood, tile, brick, and many more.<br /><br />Size:60x75mm<br /><br />How Do I Use Super Pad ?<br /><br />1.) Super pad are super easy to use and make hanging any object much easier.<br /><br />2.) Simply peel off the backing from the Pad and stick, and pads will hold the object tight.<br /><br />If you don't like it simply remove and reposition. They also come off as easily as they go on leaving no stick or messy residue behind.<br /><br />3.) Each pad holds up to 5 pounds, so you'll be able to hang all of the objects that you have.<br /><br />Package included: 20PCS Anti-slip Pad
30883 Pair Of Magnetic Crystal Curtain Tiebacks Tie Backs Buckle Clips Holdbacks Home<br /><br />Feature<br /><br />100% Brand New and High Quality<br /><br />Diamond flower design, adds elegance and temperament to your home<br /><br />No tools needed, no need to connect to the wall, the tie-back wraps around the curtain or drape and the magnetic halves connect together<br /><br />A fantastic way to hold your curtains back in style<br /><br />Length: as the picture show<br /><br />What You Get:<br /><br />2 x curtain tiebacks
30884 Handheld Woodworking Doweling Jig Drill Guide Wood Dowel Drilling Hole Saw<br /><br />Descriptions:<br /><br />100% brand new and high quality.<br /><br />Features:<br /><br />Quick jig peg that self-centers within boards to make fast, accurate positioning joints.<br /><br />Capable of edge-to-edge, T, and edge-to-corner joints.<br /><br />Made of impact resistant plastic.<br /><br />Can be used on cards up to 31mm thick.<br /><br />Suitable for wood dowel drilling. Fits 6 8 and 10mm drill bits.<br /><br />Specification:<br /><br />Material: Plastic + metal<br /><br />Dimensions: 20x7cm/7.87x2.76inch<br /><br />Color: Yellow<br /><br />Note:<br /><br />1.Please allow 1-3cm error due to manual measurement. pls make sure you do not mind before you bid.<br /><br />2.Due to the difference between different monitors, the picture may not reflect the actual color of the item. Thank you!<br /><br />Package includes:<br /><br />1 x Woodworking Doweling Jig
30885 Refillable Pilot Water Brush Ink Pen for Painting Watercolor Drawing Pen Pencil<br /><br />Feature:<br /><br />A portable compact fountain pens, soft brush pen.<br /><br />A good companion for paint Beginners, professional person can be used.<br /><br />Children can practice calligraphy.<br /><br />Painting enthusiasts can use.<br /><br />Easy to carry out painting.<br /><br />Handle Material: Plastic<br /><br />Hair Material: Fiber Hair<br /><br />Type: Watercolor Brush,Paintbrush<br /><br />Length of pen:Approx.15cm<br /><br />Small hair Length:Approx.1.2cm<br /><br />Medium hair Length: Approx. 1.4cm<br /><br />Large hair Length: Approx.1.6cm Package Included:<br /><br />1PC Small hair Paintbrush<br /><br />1C Medium hair Paintbrush<br /><br />1PC Large hair Paintbrush
30886 Nest Dox Nest House Bird House Bird House Bird Box Bird Box Wooden Box<br /><br />Specification:<br /><br />100% Brand new and high quality.<br /><br />Quantity: 1<br /><br />Brand new<br /><br />Material: wood<br /><br />Color: as picture shows<br /><br />Size: approx. 9.5x9cm This wooden bird house offers your feathered friends a cozy home<br /><br />A trip hole lets you see the birds inside<br /><br />Look forward to a metal eyelet for hanging, it also encourages easy add rope for ads<br /><br />This unique design birdhouse is the perfect addition to any home or garden of your choice<br /><br />Gorgeous garden accessory for adding color and interest to your terrace<br /><br />Package Included:<br /><br />1 x wooden bird house
30887 Well Made Blackboard Sticker Craft Kitchen Candy Jar Organizer Labels 48Pcs/Set<br /><br />Feature:<br /><br />Quantity: 1Set<br /><br />48 Labels<br /><br />These chalkboard labels are made with contact paper and made into pretty edged labels.<br /><br />Multiple uses on multiple surfaces and can be reused.<br /><br />Just peel the backing off a corner and place on a storage bin, mason jar, containers.<br /><br />Multiple uses: jar, container, storage bin<br /><br />Help you to organize<br /><br />Material: Contact paper<br /><br />Each label size(L x W): 5x 3.5cm<br /><br />Package Content:<br /><br />48 Pcs<br /><br />Sticker(6x8)
30888 Tile Gap Refill Agent Tile Reform Coating Mold Cleaner Tile Sealer Repair Glue Product description<br /><br />Amazing bright white tile gap filling agent that is Waterproof and Moldproof! Use it for bathtub tiles, washbasin, bathroom toilet tiles, balcony sink, porch tiles, corridor tiles and other cracks landscape. Features: A ready use grouting fill in product, most easy grout product ever on the market! White color grout to fix and cover all those old and dirty grouting. Suitable for all kind of floor tiles. Provides waterproof feature for floor tiles. Provides anti-fungus feature to prevent fungus grow on flooring. Size:6*16cm<br /><br />Net:280ML<br /><br />Package Include:<br /><br />1 x Tile Reform
30889 Simulation Oncidium Orchid Phalaenopsis Flowers For Wedding Decor Artificial<br /><br />Feature:<br /><br />100% Brand new and high quality.<br /><br />Material: Plastic, Cloth<br /><br />length:98cm<br /><br />Color:yellow<br /><br />Quantity : 1PC<br /><br />Perfect for decorating wedding party, your home and garden decoration,office,coffee house and so on<br /><br />Due to the different monitor and light effect, the actual color of the item might be slightly different from the color showed on the pictures. Thank you!<br /><br />Please allow 1-2cm measuring deviation due to manual measurement.<br /><br />Package Include:<br /><br />1PC Artificial Flower
30890 Foam Pot Orifice Nozzle Tips, 1.1 mm Foam Generator Nozzles For Snow Foam Lance<br /><br />Product selling point:<br /><br />Made of premium brass, work durably<br /><br />Universal replacement orifice nozzle tips fit most brands of pressure washer<br /><br />NPT male screw nozzles, about 0.28 inch fitting, orifice size 1.1 mm<br /><br />Max. Pressure: 3000 PSI of standard<br /><br />VERY EASY TO USE AND REPLACE<br /><br />Specification:<br /><br />Material: brass<br /><br />Aperture: 1.1mm<br /><br />Package Includes:<br /><br />1 x Foam Cannon Orifice Nozzle Tips<br /><br />1 x Foaming net<br /><br />WARNING:<br /><br />Serious injury may come from high pressure discharge produced by pressure washers, please keep the direction away from people or animal.
30891 Picnic Wheat Straw Bento 3 Compartment Meal Storage Lunch Container Food Prep Feature:<br /><br />Color: Pink/Blue/Beige/Green<br /><br />Material: Wheat Straw Fiber+ PP (BPA Free)<br /><br />Weight (approx.): 0.11kg<br /><br />Size (approx.): 23.5 x 15 x 5 cm/ 9.3x 6 x 2 inches<br /><br />Brand new<br /><br />Light weight, easy to carry out, good for picnic.<br /><br />Can be heated in a microwave ( no hole in the box, you need to open when you put it in the microwave)<br /><br />Note: 1.The main raw material of this product is wheat straw. After receiving the product, it will have the smell of wheat straw. This is harmless gas. After repeated cleaning and use, the smell will disappear.<br /><br />2. This product is not a completely leak proof lunch box, which is not suitable for food with soup.<br /><br />Package include:<br /><br />1 x Lunch Container
30892 2015 Jungle Animal Kids Baby Nursery Child Home Decor Mural Wall Sticker Decal<br /><br />Description<br /><br />100% brand new and high quality<br /><br />Style:Modern<br /><br />Material:PVC<br /><br />Decorate interior walls, windows, and furniture and will adhere to most hard,smooth, clean surfaces such as mirrors, metal, wood, and walls.<br /><br />Easy to apply, remove, reposition, and reuse without leaving damage or residue.<br /><br />Ideal for dry, clean, and smooth surfaces<br /><br />Sheet includes all stickers shown in picture; Made of PVC<br /><br />Package includes a single sheet of stickers<br /><br />Colors shown in pictures may slightly differ from actual product due to lighting and color settings<br /><br />This will make a nice decoration or gift.<br /><br />You could even make a DIY craft item by placing on a tile or painted board.<br /><br />Net weight: 90g Color: as pictures<br /><br />Size:90X30cm=35.4"X11.8"<br /><br />Packet content:<br /><br />1 x Wall Sticker
30893 Cap Washer Baseball Hat Cleaner Cleaning Protector Ball Cap Washing Frame Cage<br /><br />Feature:<br /><br />Quantity: 1 Product size:35*25*15cm<br /><br />Color:White<br /><br />Material:Plastic<br /><br />ULTRA STURDY PLASTIC PROTECTIVE CAGE - The best cap washing aid to maintain the interior shape of your cap while the exterior protective cage cover locks down to protect your baseball cap during cleaning<br /><br />VERSATILE - can be used as your hat rack,hat shaper,cap collection holder,hat hanger and cap organizer allowing you to clean your entire cap collection SAFE for TOP RACK of DISHWASHER(Recommended) & WASHING MACHINE- amazing results when flat and curved caps are washed in top rack of dishwasher(Only cleaning process).Gentle Cycle only if used in the washing machine! Use cold water and do not put in dryer IDEAL TRAVELING COMPANION - safely clean,dry,shape,protect and store your caps while traveling,make sure your cap DON'T crush Package Content:<br /><br />1XCap Washer
30894 Sound-Proof Door Window Foam Sticky Tape Strip Seal Noise Insulation Excluder Tape Roll B<br /><br />Features:<br /><br />Perfect for doors and window frames.<br /><br />Waterproof, Windproof, Excellent aging resistance.<br /><br />Easy to cut and easy to install, no requires specialist tool.<br /><br />Preventing dust collection between sliding doors or windows.<br /><br />Reduce the noise from outside and the sliding door slamming, give you a quiet and comfortable living environment.<br /><br />Resist rain and cold wind, give you a clean and warmer environment.<br /><br />Protect the window and door, reduce wear on window/door while open and close.<br /><br />Material: EVA + glue + paper<br /><br />Dimension: B:3cm x200cm<br /><br />Package included:<br /><br />1pack 2 Meter Self Adhesive seal strip
30895 Gamer Home Decor Wall Sticker Decal Bedroom Vinyl Art Mural<br /><br />Specifications:<br /><br />100% brand new and high quality<br /><br />Features: Removable<br /><br />Style:Wall sticker<br /><br />It can be applied to any smooth , clean and dry surface of walls, tiles, glass, furniture, etc., not suitable for dirty or rough surface.<br /><br />No transfer film needed, simply peel and stick<br /><br />Size:45*30CM<br /><br />Material:PVC<br /><br />Color:RED<br /><br />How to use:<br /><br />Ensure the surface is smooth, do not stick on the rough or uneven surface.<br /><br />Choose the place you want to apply, clean up the ash and grease, keep it dry and clean.<br /><br />Stick ​​in accordance with the picture, or DIY in your own idea.<br /><br />Peel off the paper and then stick on the wall, pave from the middle to left and right.<br /><br />Package Include:<br /><br />1PC Wall Sticker