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 (
    275624, 269039, 267330, 300376, 269016, 
    277405, 269011, 285592, 269003
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00152

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "7.51"
    },
    "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": 9,
      "rows_produced_per_join": 9,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "6.61",
        "eval_cost": "0.90",
        "prefix_cost": "7.51",
        "data_read_per_join": "45K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (275624,269039,267330,300376,269016,277405,269011,285592,269003)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
267330 <p>"Wait!! It's not real??" This silk soft pink rose wrist corsage or boutonniere is so realistic looking that people will say that! <br>This rose is surrounded by soft pink satin and sheer ribbon loops as well as sparkly silver leaves. So beautiful!!</p> <p>The size of this wrist corsage is 4"x4"x2.5".</p> <p>The boutonniere is 5"x4.5". One boutonniere comes without a bow and one does. It is great to be used as a pin-on corsage.</p> <p>These items may be already bought so your floral arrangements will look as close to the picture as possible.</p>
269003 <p>It's a boy!! Such excitement as you prepare for the big arrival! But first there's a shower. This is the way to dress up that mom-to-be at that event. <br>One ribbon says "It's a boy" and the other has tiny blue footprints on it. There is also a set of cute footprint buttons on top!</p> <p>This corsage has an elastic wristband, fitting most any size. Upgrades are available.</p> <p>These items may be already bought so your floral arrangements will look as close to the picture as possible.</p>
269011 <p>Baby girl shower time! Put this beautiful corsage on the mother-to-be during the shower to celebrate the new life! <br>The wristband is an elastic band, fitting most sizes. Or you can choose a pin-on corsage.</p> <p>The words on the ribbon include: "It's A Girl" and "Sweet Girl." On top is two little footprints surrounded by loops of soft pink ribbon. So cute!</p> <p>Plastic pink booties not included.</p> <p>Baby boy shower corsage is on another listing.</p>
269016 <p>Need a sunflower crown to finish off the accessories of your sunflower wedding? Here it is! This crown has 2" silk sunflowers, artificial dark navy (or royal) blue blossoms, baby's breath and greens. It is constructed on sturdy floral brown rustic fiber-covered wire. <br>There is a ribbon included so the size can be adjusted. Adult size is 20" long or minimum of 6" diameter. Child is 16" long or minimum of 4" diameter.</p> <p>If you want burlap as a tie, please include that in the notes when you order.</p> <p>These items may be already bought so your floral arrangements will look as close to the picture as possible.</p>
269039 <p>Artificial sunflowers and red flowers are the main theme in this flower crown. The base is brown rustic fiber-covered wire covered with artificial greens (the adult crown will have the fern leaves as pictured). The flowers are 2" yellow sunflowers, red ruffle flowers and baby's breath. <br>This can come in either bright red or dark red. When you choose the tie color, that's what color the flowers will be.</p> <p>Adult size is 20" in length.<br>Child size is 16" in length. </p> <p>These can stretch as far as you'd like since there is a ribbon attaching them.</p> <p>These items may be already bought so your floral arrangements will look as close to the picture as possible.</p>
275624 <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>Bridesmaid bouquet: 10" L by 10" W &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bridal medium: 15" in floral length by 10" wide. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bridal large: 20" L by 15" W &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Boutonniere: 4" wide by 5.5" tall &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Wrist corsage: 4" by 4", elastic wristband. For upgraded bracelets, please message me.</p>
277405 <p>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>
285592 <p>White silk rosebuds and ranunculus are surrounded in emerald green, black and black/silver striped ribbon loops. To give it sparkle, there are rhinestone sprays and silver ball sprays. A perfect corsage or boutonniere for prom!</p> <p>The wrist corsage has 5 flowers and measures 4 1/2" x 4". The boutonniere (including the silver sprays) measures 5" x 3 1/2".</p> <p>They each come in a plastic corsage box.</p>
300376 <p>Silk ivory rosebuds surrounded by black, ivory, sage and olive green ribbon loops with rhinestones and beads. Matching boutonniere sold separately.<br>Corsage and boutonniere come in clear plastic boxes.<br>You can request white be used instead of ivory.</p>