SELECT 
  product_descriptions.product_id, 
  product_descriptions.short_description, 
  IF(
    product_descriptions.short_description = '' 
    OR product_descriptions.short_description IS NULL, 
    product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  product_descriptions 
WHERE 
  product_descriptions.product_id IN (
    206024, 212352, 199359, 212370, 254311, 
    205990, 206029, 198581, 213507, 199221, 
    212367, 205982, 252947, 197351, 197392, 
    264369, 264384, 264386, 264366, 264381, 
    264368, 308137
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00099

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "18.71"
    },
    "table": {
      "table_name": "product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "11",
      "rows_examined_per_scan": 22,
      "rows_produced_per_join": 22,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.51",
        "eval_cost": "2.20",
        "prefix_cost": "18.71",
        "data_read_per_join": "112K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (206024,212352,199359,212370,254311,205990,206029,198581,213507,199221,212367,205982,252947,197351,197392,264369,264384,264386,264366,264381,264368,308137)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
197351 <p>This cute handmade beach-themed turtle bracelet is very cool.&nbsp; This beaded turtle bracelet features a cute turtle made of recycled materials, surrounded by tiny glow in the dark blue glass beads and vintage shell beads.&nbsp; This double-stranded turtle bracelet is 7.25 inches long with 1 inch stainless steel extender to fit multiple wrist sizes.&nbsp; The silver plated turtle charm on the extender adds extra charm and helps the wearer put on this bracelet independently.&nbsp; <br></p>
197392 <p>This cute handmade beach-themed turtle bracelet is very cool.&nbsp; This beaded turtle bracelet features a cute turtle that is made of recycled materials, surrounded by tiny glow in the dark blue glass beads, and rounded square emerald green glass beads.&nbsp;This single-stranded bracelet is 6.5 inches long with 1 inch stainless steel extender to fit multiple wrist sizes.&nbsp; The beaded detail on the extender helps the wearer put on this bracelet independently. <br></p> <p></p>
198581 <p>Add a piece of unique and sustainable handmade desk art to your space.&nbsp; This piece of sustainable home decor is called,<em> Camouflage</em>, since there are two figures hidden among the leaves on a nice sunny day.&nbsp; Can you find them? <em>Camouflage </em>is a sustainable product is made with nearly 50 hand-cut and folded pieces that were cut from boxes, and then glued onto another box.&nbsp; There are also 16 bright orange triangles of various lengths that radiate from the sun.&nbsp; This small paper-based wall art is approximately 13-1/4 inches in length, 6-3/4 inches in width, and 3/8 inches in depth when flat.&nbsp; <em>Camouflage </em>is intended to sit on a desk or table, but it can be adapted to hang on a wall.&nbsp; Please send me a message if you would like me to add a ribbon to hang.<br></p> <ul><li>Dimensions when flat (approximate) <ul><li>L x W x D = 13-1/4" x 6-3/4" x 3/8"</li><li>May not be completely flat</li></ul></li><li>Layout: landscape</li><li>Materials<ul><li>Snack boxes (canvas and hand-cut pieces)</li><li>Glue</li></ul></li><li>Colors<ul><li>Pink, yellow, blue, orange, purple, brown, black, green, and white</li></ul></li></ul> <p>Will ship in a small Priority Mail box, but pick-up is highly recommended.</p>
199221 <p>Add a piece of sustainable and one-of-a-kind handmade wall art to your space.&nbsp; This piece of sustainable home decor depicts a dynamic mix in nature with vibrant green leaves, brown trees, and coral colors.&nbsp; This small wall art measures 7 and 1/8 inches in length and 4 and 3/4 inches in width, including the ribbon for hanging, and has a landscape layout.&nbsp; The materials for this upcycled home decor consists of an ice cream box for the canvas, a magazine, glue, and ribbon.&nbsp; The ribbon is slightly off-center, but it can still be hung straight.&nbsp; This collage is thin and not completely flat on the back due to the amount of glue it takes for a project like this. Colors of this eco-friendly wall art are shades of green, shades of coral, brown, and white.</p> <ul><li>Dimensions<ul><li>L X W = 7-1/8" x 4-3/4"</li><li>Thickness = thin</li><li>Not completely flat when laid on the back</li></ul></li><li>Layout: landscape</li><li>Materials<ul><li>Ice cream box (canvas)</li><li>Magazine</li><li>Glue</li><li>Ribbon (to hang on the wall)</li></ul></li></ul>
199359 <p>This unique and earthy tiger eye statement necklace is sure to capture attention wherever you go.&nbsp; The numerous tiger eye beads ranges from tiny to medium sizes, with the largest front and center tapering to tiny beads toward the clasp.&nbsp; Because each gemstone is different and there are so many of them on each necklace, both necklaces are not the same.&nbsp; Soft brown and warm yellow hues makes this necklace naturally alluring.&nbsp; This chunky tiger eye necklace is also made with stainless steel closure, so it doesn't rust, and water-resistant wire.</p>
205982 <p>Add a piece of handmade&nbsp;upcycled wall art to your space.&nbsp; This unique piece of home decor is titled, <em>Behind the Curtain</em> because a fairy is revealed behind a curtain of leaves.&nbsp; <em>Behind the Curtain</em> is a sustainable product with 55 hand-cut and folded pieces from boxes and then glued on another box.&nbsp; There are also more than 30 small teal triangles all over the canvas. This small paper-based wall art measures approximately 12 inches in length, 8-1/4 inches in width, including the ribbon for hanging, and 3/8 inches in depth.&nbsp; <br></p> <ul><li>Dimensions (approximate) <ul><li>L x W x D = 12" x 8-1/4" (with ribbon) x 3/8"</li></ul><ul><li>May not be completely flat on the back</li></ul></li><li>Layout: landscape</li><li>Materials<ul><li>Snack boxes (canvas and 55 hand-cut pieces)</li><li>Glue</li><li>Ribbon (to hang on the wall)</li></ul></li><li>Colors<ul><li>Pink, blue, yellow, brown, and green</li></ul></li></ul> <p>Will ship in repurposed box, but pick-up is strongly recommended to prevent damage in transit.</p>
205990 <p></p> <p>This beautifully hand-crafted upcycled card is made from boxes.&nbsp; Each card uses the same patterned or branded box, but each design is unique, because of where they were cut on the box, the size and shape of each piece, and their placements.&nbsp; These upcycled cards are two-sided like a postcard.&nbsp; The front has the pattern and the back is blank for writing.&nbsp; It has smooth writing with any pen or marker, and dark color ink is recommended.&nbsp; Because each style does not have pre-determined occasions, these eco-friendly cards can be used for any occasion the sender deems appropriate.&nbsp; An envelope is included.&nbsp; Cards and envelopes can be recycled or kept as a meaningful one-of-a-kind keepsake.</p> <ul><li>Dimensions:&nbsp;<ul><li>Card:&nbsp;L x W = Approx. 6.25 inches x 3.25 inches&nbsp;</li><li>Envelope (included): L x W = 6.5 inches x 3.5 inches&nbsp;</li></ul></li></ul>
206024 <p>This beautifully hand-crafted upcycled card is made from boxes.&nbsp; Each card uses the same patterned or branded box, but each design is unique, because of where they were cut on the box, the size and shape of each piece, and their placements.&nbsp; These upcycled cards are two-sided like a postcard.&nbsp; The front has the pattern and the back is blank for writing.&nbsp; It has smooth writing with any pen or marker, and dark color ink is recommended.&nbsp; Because each style does not have pre-determined occasions, these eco-friendly cards can be used for any occasion the sender deems appropriate.&nbsp; An envelope is included.&nbsp; Cards and envelopes can be recycled or kept as a meaningful one-of-a-kind keepsake.<br></p> <ul><li>Dimensions:&nbsp;<ul><li>Card:&nbsp;L x W = Approx. 6.25 inches x 3.25 inches</li><li>Envelope (included): L x W = 6.5 inches x 3.5 inches&nbsp;</li></ul></li></ul>
206029 <p>These beautifully unique hand-crafted upcycled cards are made from boxes.&nbsp; Each card has a different design and color palette, along with not having pre-determined occasions, these eco-friendly cards can be used for any occasion the sender deems appropriate.&nbsp; These upcycled cards are two-sided like postcards.&nbsp; They have a patterned side on the front and a blank side on the back for writing. &nbsp;They have smooth writing with any pen or marker, and dark color ink is recommended. This blank card set comes with 3 cards and 3 envelopes.&nbsp; Cards and envelopes can be recycled or kept as meaningful one-of-a-kind keepsakes.<br></p> <ul><li>Dimensions:&nbsp;<ul><li>Cards:&nbsp;L x W = Approx. 5.5 inches x 3.25 inches&nbsp;</li><li>Envelopes (included): L x W = 6.5 inches x 3.5 inches </li></ul></li></ul> <ul><li>Patterns: Coffee, Abstract Painting, and Dreams Collage</li><li>Colors:&nbsp;<ul><li>Coffee: Dark brown, brown, beige, and white</li><li>Abstract Painting: Gray, yellow, green, and purple</li><li>Dreams Collage:&nbsp;Blue, purple, yellow, white, and gray</li></ul></li></ul>
212352 <p>These sleek black obsidian earrings have a minimalist design, so they will pair well with many outfits and suitable for multiple occasions.&nbsp; These earrings are handmade with thin stainless steel wire wrapped around black obsidian gemstones, and attached to niobium ear wires - a hypoallergenic metal.&nbsp; Because niobium is hypoallergenic, these black obsidian earrings are great gifts for loved ones with metal allergies.&nbsp; Black obsidian dangle earrings are short and slender with gender-neutral design.&nbsp; There are two lengths: earrings with two stones on each side are approximately 1 and 5/8 inches long and earrings with three stones are approximately 2 and 1/2 inches long.</p> <p>*<strong>Note</strong>: wire is very soft, so it's possible that earrings would be bent in transit.&nbsp; Carefully bend earrings back to the original design or return it to be fixed.&nbsp; When earrings are not worn, please store them properly, such as hanging them on an earring display, to avoid damage.<br></p>
212367 <p>This pair of handmade butterfly dangle earrings is playfully elegant and perfect for all occasions! Earrings are short, measuring 1.5 inches long.&nbsp; Each earring is made with two wire wrapped sapphire glass beads, and then attached to the butterfly earring posts.&nbsp; The sapphire glass beads shine beautifully in light.&nbsp; Butterfly studs are stainless steel with matte gold color.&nbsp; Let the compliments roll!<br></p>
212370 <p>Look stunning in sapphire! This handmade hypoallergenic jewelry set features a statement necklace and dangle earrings in sapphire and clear beads. The beaded statement necklace has over 150 glass beads, is 18 inches long, and stainless steel closure.&nbsp; The matching dangle earrings are made with surgical stainless steel (medical-grade stainless steel) ear wires with 316 stamps on each ear wire, and two sapphire glass beads dangling on each earring.&nbsp; Earrings are medium-length, measuring 1.75 inches in length.&nbsp; This sapphire jewelry set is an excellent gift for loved ones with metal allergies and people who love compliments.</p>
213507 <p>This elegant statement necklace in deep blue and white pearl is great for work and all occasions.&nbsp; This handmade necklace is 18 inches long.&nbsp; This necklace features a focal point with 5 handmade deep blue glass beads with silver lining, each with a unique look in blue, black, and silver.&nbsp; These deep blue beads are set in between intricately detailed silver plated bead caps and 4 white glass pearl beads.&nbsp; There are 50 glass pearls per necklace and closes with a stainless steel clasp and ring.<br></p>
252947 <p>This fabulously fashionable Frozen-inspired beaded bracelet features Elsa's color palette in iceberg and carolina blue glass beads and stainless steel round beads.&nbsp; Beads shine beautifully in the light.&nbsp; This beaded bracelet is also made with water-resistant wire and stainless steel closure.&nbsp; Stainless steel does not rust.&nbsp; Dress up or down, you'll look fashionably fabulous no matter what!<br></p>
254311 <p>This pair of handmade hoop earrings are hypoallergenic have a timeless and minimalist design that is great for work in all industries.&nbsp; These hoops are made with medical-grade stainless steel and can be worn by anyone with pierced ears.&nbsp; Stainless steel also does not tarnish.&nbsp; These small surgical stainless steel hoop earrings are also light-weight, so they are comfortable to wear all day.<br></p>
264366 <p>This bright and shiny gold and emerald green beaded bracelet is sure to capture everyone's attention wherever you go.&nbsp; The focal point comprises of three faceted green glass beads with two round gold-plated beads in between.&nbsp; The focal point is flanked by two sizes of gold-plated beads and closes with a lobster claw clasp.&nbsp; The beads are relatively small, but the bold colors pack a punch.&nbsp; This handmade, stylish, and trendy bracelet is 7 inches long with a one-inch extender.&nbsp; It's a great gift for yourself.<br></p>
264368 <p>Fabulous fluorite pendant necklace is great for all occasions.&nbsp; Fluorite has natural purple, green, and gray inclusions, making every pendant unique.&nbsp; The pendant is approximately 1.5 inches long in the shape of a hexagon.&nbsp; <br></p> <p>The shiny gold plated chain comes in two lengths: 17 and 18 inch necklaces.<br></p> <p>The silver plated chain comes in 18 inch necklaces.</p> <p>Glue is more visible on some pendants.<br></p>
264369 <p>This pair of emerald green and silver plated hoop earrings are stylish.&nbsp; Each earring is handmade with tiny emerald green and clear seed beads intricately wire-wrapping around the hoop's circumference.&nbsp; There are also three emerald green glass beads hanging on each earring's center base.&nbsp; This pair of earrings is lightweight and swings.&nbsp; These are medium-sized earrings, with the diameter measuring approximately 2.5 inches in length and 1.25 inches in diameter.<br></p>
264381 <p>This pair of bright pink and silver plated hoop earrings are stylish.&nbsp; Each earring is handmade with tiny light pink and clear seed beads intricately wire-wrapped around the hoop's circumference.&nbsp; There are also three bright pink resin beads hanging on each earring's center base.&nbsp; This pair of earrings is lightweight and swings.&nbsp; These are medium-sized earrings, with the diameter measuring approximately 2.5 inches in length and 1.25 inches in diameter.&nbsp; <br></p> <p>These earrings also come in green! Tiny emerald green and clear seed beads are wire-wrapped around the hoop's circumference with three lime green resin beads hanging from the center base.<br></p>
264384 <p>Intricately handmade wire-wrapped dangle hoop earrings are great for many occasions.&nbsp; Tiny emerald green seed beads are wire-wrapped along the hoop's silver plated circumference.&nbsp; There is translucent light green teardrop dangling from the top center of the hoop and small round cream glass beads swinging from the hoop's center base.&nbsp; This pair of earrings are lightweight and measure approximately 2 and 1/4 inches in length and 1 and 1/8 inches in diameter.&nbsp; These earrings are small to medium-size.<br></p> <p>Comes in hot pink magenta, too! Tiny hot pink seed beads wire-wrapped around the circumference of the hoop.&nbsp; A hot pink magenta teardrop bead hangs from the hoop's top center.&nbsp; Three larger seed beads swing from each earring's center base.&nbsp; These are also handmade, so they have similar dimensions dimensions.<br></p>
264386 <p>This handmade dainty gold filled gemstone bracelet is great for everyday wear.&nbsp; Round peridot and faceted black spinel beads alternate in a pattern and strung on water-resistant wire.&nbsp; This beaded gemstone bracelet is 7 inches long, lightweight, and has gold filled closure (14K/20 stamp on clasp).&nbsp; Delicate bracelet sparkles in the light and looks better when stacked.&nbsp; <br></p>
308137 <p>I'm tiny and super adorable at 3/4 inches long.&nbsp; I'm great for work because I look so professional, but really, you can wear me any time you want! I have a minimalist design, so I will support you in every outfit! I'm affordable, too! Pearls are glass but they look real (I'm a bit shiny in this picture), and chances are, I match with your other pearl jewelry.&nbsp; Studs and wire are silver plated, so please keep me dry.&nbsp; I can't wait to meet you!<br></p>