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 (
    267296, 267324, 267308, 281009, 267307, 
    267306, 285546, 269043, 269050, 267309, 
    267317, 267303, 267322, 276327, 267331, 
    280993, 267313, 282231, 281008, 267321, 
    267328, 273575, 269018, 267305
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00099

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "20.04"
    },
    "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": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "17.64",
        "eval_cost": "2.40",
        "prefix_cost": "20.04",
        "data_read_per_join": "122K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (267296,267324,267308,281009,267307,267306,285546,269043,269050,267309,267317,267303,267322,276327,267331,280993,267313,282231,281008,267321,267328,273575,269018,267305)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
267296 <p>Dark purple silk rosebuds with silver and black accents make up the color combination in this wrist corsage and boutonniere. There is just enough sparkle to make it perfect for prom, QuinceaƱera, or other fancy events. </p> <p>The wrist corsage is approximately 4" x 4" with the boutonniere 4" x 3".</p>
267303 <p>This is the perfect wrist corsage and boutonniere for prom or other fancy event. The turquoise sparkly ribbon with the strands of silver rhinestones make it stand out! Along with the sparkly turquoise beads, there are also 2 white anemone with black centers (and a silver rhinestone) that add a fun element. Such a beautiful combination!<br>The wrist corsage is approximately 4"x4" with the boutonniere at 3"x4".</p> <p>There are a variety of bands to choose from.</p> <p><br></p>
267305 <p>Ivory rosebuds with pearls and rhinestones make a beautiful combination! It is so elegant and so neutral, it matches any color. This corsage includes 3 silk ivory rosebuds, pearls with rhinestones surrounding them as well as individual rhinestones. This is set on layers of satin and sheer ivory ribbon.<br>There are 2 bands to choose from. The less expensive is the plain elastic band. The more elegant band is the elastic rhinestone bracelet which has 3-rows of gold backed rhinestones. Perfect for a mother-of-the-bride or mother-of-the-groom. It would also work for bridesmaids!</p> <p>If you are in need of a different color combination, please message me. Most likely I can accommodate you!</p>
267306 <p>Perfect for prom! Royal blue, black and silver make up the color scheme for this pretty wrist corsage and boutonniere. </p> <p>There are 3 royal blue rosebuds surrounded by loops and loops of black, silver and silver sheer ribbon as well as rhinestone loops and single rhinestones too! </p> <p>You can choose the wristband you'd like: black elastic, silver rhinestone or black beaded.</p> <p>These items may be already bought so your floral arrangements will look as close to the picture as possible.</p>
267307 <p>Red and black are always stunning by themselves. But when you add this wrist corsage and boutonniere, it will really be stunning!<br>The wrist corsage bracelet is a black elastic band, of medium size. It includes silk red satin roses, silver rhinestone strands, and pearls with rhinestones. The ribbon loops are made of satin black and white stripes, black satin, white sheer, and silver sheer.</p> <p>The measurements for the wrist corsage are 4" in diameter with ribbon tails hanging down. <br>The matching boutonniere is 4" long and includes the same rose and ribbon as the wrist corsage.</p> <p>These both come in separate clear corsage boxes.</p>
267308 <p>Black and red are such classic colors! They are so elegant and striking! Celebrate your special day, whether it be prom or a wedding or a special event with this beautiful corsage!<br>Specifics: <br> Floral: silk dark red daisy mums (or eggplant or other color--message me)<br> Ribbon: Black satin and light gray sheer<br> Bling: rhinestone centers in the flowers, silver bead sprays, rhinestone loops<br> Band: your choice<br> Occasions: prom, wedding, Quinceanera<br> Size: 4" x 4" with ribbon and bead spray tails</p> <p>Plastic corsage box(es) included.</p> <p>If you want this customized, whether it be ribbon or flower color, please message me. I want to please you! </p> <p>Additional floral for duplicate items is dependent on supplier availability. If a substitute is used, it will be very similar.</p> <p>These items may be already bought so your floral arrangements will look similar. I will send you a pic to approve before mailing.</p>
267309 <p>Red, black and white are such classic colors! So beautiful together! This wrist corsage is made of black, red and sheer white ribbon loops with 3 white silk rosebuds. Also included are shiny black beads and strings of black beads. The boutonniere is of the same white rosebud with the same color loops and beads.</p> <p>I can do this in many colors. Please message me for more information. I love custom orders!<br></p> <p>The measurements for the wrist corsage are 4 1/2" by 4 1/2" with ribbon tails that are 4" long. <br>The boutonniere measures 4 1/2" by 3".</p> <p>Corsage and boutonniere comes in a plastic corsage box.</p> <p><br></p>
267313 <p>Soft pink, dark gray and silver are so pretty together! This corsage and boutonniere would look great at prom or any other formal event where you want your corsage to stand out from the rest! This corsage will last forever because the rosebuds are silk. You will have a memento of your special night!<br>There are rhinestones among the loops of silver stripe, black and sheer gray.</p> <p>The wrist corsage is 4"x4" and the boutonniere is 3 1/2"x4".</p> <p>The band can either be elastic or rhinestone. There is also a matching boutonniere.</p>
267317 <p>Stunning is the word that comes to mind with this wrist corsage! The metallic gold just sparkles! <br>Mesh metallic rose gold ribbon with ivory satin ribbon and 3 ivory silk rosebuds make for a beautiful soft but stunning combination.</p> <p>The wristband is also metallic gold with either beaded or rhinestone bands, matching the rhinestone "strings" and the rhinestone loops.</p> <p>There is also a matching boutonniere. </p> <p>These come in their own clear corsage boxes.</p> <p>These items may be already bought so your floral arrangements will look as close to the picture as possible.</p>
267321 <p>Glitzy to the max! Besides the shiny gold ribbon and 3 life-like bright red rosebuds, there are gold and diamond faux rhinestones which give it a sparkle! Actually, there are many different ribbons of different widths and color. </p> <p>You can purchase this beautiful wrist corsage or boutonniere for any special occasion like prom, weddings, homecoming, formal birthday party, or any other event where you want your wrist to sparkle!</p> <p>This wrist corsage will live forever, vs real flowers that wilt and die away. It can be worn many times without wilting!</p> <p>The corsage is designed on either an elastic wristlet or a sparkly rhinestone bracelet. </p> <p>A clear plastic corsage box comes with this order.</p> <p>You can request customizations!</p> <p>These items may be already bought so your floral arrangements will look as close to the picture as possible.</p>
267322 <p>Red, black and silver say glamorous! The added bling of rhinestones really makes it stunning!<br>This can be worn to prom, bridesmaids or mothers at a wedding, special birthday, or any other special event where you want to sparkle!</p> <p>The band can either be black elastic, black rhinestone or petite black pearl. A boutonniere is sold separately from the corsage.</p> <p>The ribbon is black satin, white sheer and metallic silver. 3 silk rosebuds are either dark red or bright red.</p> <p>If you want to custom make this, contact me. I can do many different colors!</p> <p>If more than 1 item is ordered, shipping costs will be combined. You will get a refund if there are overages.</p> <p>These items may be already bought so your floral arrangements will look as close to the picture as possible.</p>
267324 <p>Black and red is so classic! And this wrist corsage and matching boutonniere are very classy! Bright red silk rosebuds surrounded by loops of various black ribbons with a few silver rhinestones sprinkled in. Beautiful!!</p> <p>Corsage is approx 4" x 4"<br>Boutonniere is approx 4" x 3"</p> <p>The petite band and the elastic band both fit small wrists. </p> <p>These are sold separate so if you want both, please put one at a time in your cart by using the drop down arrow.</p> <p>If you have any questions, feel free to ask!</p>
267328 <p>If you need a pop of color for your event, this is it! Bright orange, hot pink, lime green, bright yellow on loops of black ribbon make up this gorgeous corsage and boutonniere. There are also black bead sprays and pink rhinestone picks. <br>The flowers in this are rosebuds, ranunculus, and blossoms.</p> <p>These are priced separately so if you want both corsage and boutonniere, you need to put them in your cart individually.</p>
267331 <p>Red, black and gold say glamorous! The added bling of rhinestones really makes it stunning!</p> <p>This can be worn to prom, bridesmaids or mothers at a wedding, special birthday, or any other special event where you want to sparkle!</p> <p>The band can either be black or gold elastic or black or gold rhinestone. A boutonniere can be made to match. </p> <p>The ribbon is black satin and metallic gold. Silk rosebuds are a dark red or bright red.</p> <p>If you want to custom make this, contact me. I can do many different colors!</p>
269018 <p>This listing uses all artificial floral.&nbsp;<br>Dark eggplant with light dusty lavender makes for a gorgeous spring or summer bouquet! The white anemone with black centers is a perfect addition to this bouquet. Lavender stems give it that spring look. A splash of succulents along with the variety of textured greens add to the beauty of this bouquet. </p> <p>The bridal bouquet is cascading, while the bridesmaid bouquet is forward-facing. Floral included in this listing are white and eggplant cabbage roses, dusty lavender roses, succulents, lavender delphinium, white anemone, white ranunculus, sprigs of lavender and a variety of greens, including dollar eucalyptus.</p> <p>Bridal: 15" in floral length by 10" wide. <br>Bridesmaid: 10" in floral length, with stems 11.5" tall, by 10" wide<br>Boutonniere: 4" wide by 5.5" tall<br>Wrist corsage: 4" by 4", elastic wristband. For upgraded bracelets, please message me.</p>
269043 <p>Light baby blue, white and metallic silver make up this gorgeous wrist corsage. It has such a soft, feminine appearance that would be so stunning for prom! Mixed in with the loops of ribbon are loops of rhinestone-like strands. Also adding to the bling are silver bead strands.<br>It has a matching boutonniere if you choose to purchase that also. </p> <p>I can vary the colors in this to just about anything you'd like. Just message me for more information.</p> <p>The corsage can have either a white elastic band or a silver rhinestone bracelet. </p> <p>Corsage and bout come in plastic corsage boxes.</p> <p>These items may be already bought so your floral arrangements will look as close to the picture as possible.</p>
269050 <p>Dark burgundy, black and gray make up the coloration in this stunning wrist corsage. The dark red velvet rose and rosebud are surrounded by loops of satin and sheer black and gray ribbon. Rhinestones add the bling which shines in a dark background.<br>This corsage would look great at prom or weddings.</p> <p>The wristband can be either elastic, black beaded, or black rhinestone. I can also do a pin-on corsages using the same elements.</p> <p>These items may be already bought so your floral arrangements will look as close to the picture as possible.</p>
273575 <p><em></em>Silk turquoise rosebuds are surrounded by black ribbon loops, turquoise rhinestone strands, glitter balls and leaves and black ball sprays. Gorgeous!!</p> <p>Perfect for prom, wedding, quinceanera or other formal event.&nbsp;</p> <p>The wrist corsage is approximately 4"x4".<br>The boutonniere is approximately 3 1/2" x 4".&nbsp;</p> <p>They come in plastic corsage boxes.</p> <p><br></p>
276327 <p>Dusty blue weddings are so popular right now. And paired with navy blue, white and sage green succulents, it's so beautiful! This listing includes a bridal bouquet, bridesmaid bouquets, wrist corsage, boutonniere and succulent crowns.</p> <p>The silk bouquets have more of a random shape, not perfectly round or oval.&nbsp;</p> <p>Included in these bouquets are navy and dusty blue silk roses, ranunculus, dusty blue billy balls, anemones, hydrangea, various greens including dusty green eucalyptus. All floral is wrapped in a satin ribbon color of your choice.&nbsp;</p> <p>Dusty succulent crown measures in length 20" for adult, 16" child. It includes a ribbon tie so the size is flexible.<br>Wrist corsages have an elastic wristband, fitting most sizes. Approximate size is 4"x4". Boutonniere is approximately 3 1/2"x4".&nbsp;</p> <p>Message me for customizations!</p>
280993 <p>Wow! Stunning black and lavender wrist corsage or boutonniere would be perfect for prom or any other formal event. The rhinestone bling adds just enough bling, but not too much. There are 2 silk clematis flowers with a rhinestone as the center in the wrist corsage, 1 in the boutonniere.</p> <p>The wrist corsage is approximately 4"x4". The boutonniere is approximately 3 1/2" x 4".&nbsp;</p> <p>There are a variety of wristbands you can choose from.</p> <p>Each one comes in a clear box.</p>
281008 <p>This bright orange wrist corsage or boutonniere would be perfect to match your bright orange or multi-colored dress for prom or a wedding or another formal event.&nbsp;</p> <p>The silk rosebuds/ranunculus are so bright and fun! Around the flowers are loops of beautiful white ribbon with added greens to finish the corsage.</p> <p>The wrist corsage is approximately 4"x4". The boutonniere is approximately 4"x3 1/2".</p> <p>These will come in corsage or boutonniere boxes.</p>
281009 <p>Silk hot pink cosmos flowers mixed with silver and black makes for a stunning wrist corsage and boutonniere! Since it is artificial, it will last forever! The bling includes hot pink rhinestone sprays as well as glitter balls.&nbsp;</p> <p>The wrist corsage is approximately 4"x4" with ribbon tails. The boutonniere is approximately 4 1/2" by 3".</p> <p>There are wristband options to choose from.</p> <p>Each item comes in a plastic corsage/boutonniere box.</p>
282231 <p>Want just lime green, black and sparkle?? This is the one for you! There are no flowers but are plenty of ribbon loops and lime green sparkles. The sparkly components are rhinestone loops, lime green glittery balls, and sparkly green baby's breath.</p> <p>Wrist corsage measures approximately 4" x 4", boutonniere is 3 1/2" x 4".</p> <p>Each item comes in a clear corsage box.</p>
285546 <p>Sparkly emerald green wrist corsage or boutonniere with two black-center anemones surrounded with black and silver ribbon loops. Rhinestone strands and glittery balls give it the sparkle! Perfect for prom or any other formal event where you need black and green accents to finish your look!</p> <p>There are different wristband options for you to choose from. If you have any questions, feel free to message me.</p> <p>The size of the corsage is approximately 4" x 4". The boutonniere is approximately 3 1/2" x 4"</p>