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 (
    283181, 279099, 279109, 287067, 276569, 
    279103, 287052, 276802, 283192, 283186, 
    283179, 283182
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00080

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.17"
    },
    "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": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "8.97",
        "eval_cost": "1.20",
        "prefix_cost": "10.17",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (283181,279099,279109,287067,276569,279103,287052,276802,283192,283186,283179,283182)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
276569 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is mostly flat and includes the edge of the plate on one side as a part of the design.</p> <p>Size is 56 x 32mm&nbsp;</p>
276802 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is taken partially from the edge of the plate, it doesn't lay perfectly flat.</p> <p>Size is 40 x 50mm&nbsp;</p>
279099 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece has a curve to it</p> <p>Size is 25 x 40mm&nbsp;</p>
279103 <p>Handmade cabochon or focal piece. Made from a chipped vintage plate, this unique focal will give your wire wrap or hot metal work projects an interesting flair. You could even incorporate this focal into your next macrame project.</p> <p>This piece is mostly flat.</p> <p>Size is 38 x 58mm&nbsp;</p>
279109 <p>I hand-painted these purple fireweed wildflowers on leather and suspended them on sterling silver filled earwires. Accented by a light-catching purple glass bead, these earrings are sure to initiate conversations.</p> <p>These earrings are very long at 110mm from the vase of the earwires and 32mm wide</p>
283179 <p>Measuring 68mm tall by 35mm wide. this pendant features a handmade lampwork bead by artist Chuckie Mac.&nbsp; Wrapped in raw copper, this piece has already been given an aged patina and polished to create a greater sense of depth and light play, but it will continue to darken and change with age, as is the nature of copper.<br></p>
283181 <p>Dyed magnesite black bears surrounded by a hand-hammered copper frame, accented with dyed stone and multicolored beads. Measure 58mm x 43mm excluding the earwire.<br></p>
283182 <p>Handmade lampwork blueberries surrounded by a hand-hammered copper hoop, accented with matching iridescent blue crystal beads. Measure 60mm x 60mm excluding the earwire.<br></p>
283186 <p>I hand-painted these Alaskan wildflowers on ulu-shaped leather and suspended them on sterling silver filled earwires. <br></p> <p>These earrings are small at 32mm from the base of the earwires and 29mm wide</p>
283192 <p>Measuring 52mm tall by 18mm wide, this pendant features a a gorgeous flashy labradorite, dancing with green and yellow tones. In direct light this piece reveals it’s true depth of color and light play.&nbsp; Wrapped in sterling silver-filled, this piece will darken or develop a patina over time, It can be sealed to maintain its shine or polished to bring out the highlights from the darkening metal.<br></p>
287052 <p></p> <p>Measuring 80mm tall by 42mm wide. this pendant features a gorgeous polished piece of maligano jasper. Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s current look or polished to bring out the highlights.</p> <p></p>
287067 <p>Hand-formed copper hoop, accented with matching red and amber crystal beads. Measure 55mm x 55mm excluding the earwire.</p>