Sandbox

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 (
    267320, 267318, 267332, 267315, 267319, 
    267330, 300376, 277405, 269011, 285592
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00239

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "8.43"
    },
    "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": 10,
      "rows_produced_per_join": 10,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "7.43",
        "eval_cost": "1.00",
        "prefix_cost": "8.43",
        "data_read_per_join": "50K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (267320,267318,267332,267315,267319,267330,300376,277405,269011,285592)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id	short_description	full_description
267315		<p>Lavender and silver is so pretty together! This wrist corsage or boutonniere includes 2 shades of lavender. <br>Among the loops of silver and sheer ribbon are silk lavender ranunculus. Silver bead sprays as well as rhinestone strands add to the fun!</p> <p>The ribbon part is approximately 3 1/2" x 3 1/2".</p> <p>The boutonniere is approximately 3" x 3 1/2".</p>
267318		<p>Soft pink silk rosebuds and silver are gorgeous in this wrist corsage and boutonniere. The sparkly net ribbon as well as the rhinestone strands add the perfect bling. <br>Perfect for prom, formal birthday celebrations, weddings, or any other fancy occasion!</p> <p>Wrist corsage is approximately 4"x4" and the boutonniere is approximately 4"x3".</p>
267319		<p>This is a boutonniere that would look great at a rustic or boho wedding or event. There are no flowers in it, just an artificial green succulent surrounded by eucalyptus, eucalyptus leaves, fern and seeded eucalyptus. <br>It measures 5 1/2" long and 4 1/2" wide. It is fairly heavy but it comes with pins to keep it in place.</p> <p>If choosing color other than the ones listed, please message me the color preferred.</p> <p>Additional floral for duplicate items is dependent on supplier availability. If a substitute is used, it will be very similar.</p>
267320		<p>Ahhh the classic colors of black and dark red. It never goes out of style!<br>This wrist corsage features dark (or bright) red rosebuds surrounded by loops of black, sheer, silver and music note ribbon. Among the loops of ribbon are rows of silver bling as well as a few rhinestones sprinkled in.</p> <p>You can order this matching boutonniere with or without the music ribbon.</p> <p>There are also a several different wristbands to choose from.</p>
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>
267332		<p>You can't go wrong with white and silver! It will match everything! The silver sparkly balls along with the pearl surrounded in tiny rhinestones make this wrist corsage stunning!<br>The ribbon is sheer and white with a silver stripe. There is also metallic silver ribbon.</p> <p>You can choose elastic wristband, silver rhinestone bracelet or white pearl bracelet (petite or regular size).</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>
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". </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>