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 (
    265842, 265500, 265492, 265498, 265488, 
    265489, 265493, 265857, 265847, 265852, 
    265858, 265851
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00078

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.30"
    },
    "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": "9.11",
        "eval_cost": "1.20",
        "prefix_cost": "10.31",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (265842,265500,265492,265498,265488,265489,265493,265857,265847,265852,265858,265851)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
265488 <p>Our dryer balls are made of alpaca fiber and wet felted into a tight ball about the size of a baseball. They are unscented, and can be purchased individually or as a set of six.&nbsp; &nbsp;&nbsp;</p> <p>Colors will vary.</p>
265489 <p>The dryer ball set comes with six dryer balls and a cotton drawstring bag for storage or easy transport.&nbsp; Our dryer balls are made from the alpacas on the farm and are about the size of a baseball. They come unscented.&nbsp; Colors will vary.</p>
265492 <p>Paca Punch is a treat for your plants both indoor and outdoor.&nbsp;</p> <p>We've taken the method of packaging the alpaca manure a few steps further than what other farms are doing.&nbsp; We have a very hungry population of composting worms that enjoy feasting on the manure.&nbsp; What they leave behind is a very enriched worm compost that neither smells or even resembles the manure after only a couple of weeks.&nbsp;</p> <p>The finished product is then sorted (to collect worms that try to sneak out), dried, and stored until we can fill the bags.&nbsp; The burlap bags are 4x6 inch in size and filled to bursting.&nbsp;</p> <p>You can mix the dried paca punch around the base of potted plants or soak the entire bag in a gallon size container of warm water to make the "punch". Then just water your plants as needed. We have found that we can get about three soaks out of a bag.&nbsp;</p> <p>The contents of the burlap bag and the burlap bag are fully compostable so feel free to add it to your compost bin.</p>
265493 <p>For the bird watching enthusiast, we have alpaca fiber bundled together to be hung outside in the spring when the wild birds begin their nest building.&nbsp; Each nesting "ball" is made by hand which makes them each unique.</p>
265498 <ul><li>All wood construction except for the top hook.</li><li>Stained and clear-coated for a smooth finish.</li><li>Top whorl spindles which are better suited for finer fibers like alpaca, angora rabbit, silk, etc.</li><li>Weight is 1.5 to 2.5 ounces.</li><li>Specify wagon wheel design or closed wheel design when ordering.</li></ul> <p></p>
265500 <p>Our drop spindle kits contain a drop spindle, instructions on how to use the spindle, and two ounces of alpaca fiber (colors will vary as to what we have in stock each shearing season).</p> <p>Two spindles are shown in the picture. One has a wagon wheel type whorl and weighs 1.8oz.</p> <p>The other wheel has a smaller whorl and weighs 1oz. Both will spin fine fibers equally well.</p> <p>The fiber pictured is not the fiber that will come in the kit.</p>
265842 <p>Our alpaca hats are made from the warm and cozy alpaca fiber spun into fluffy yarn donated by our alpacas.&nbsp; They do contain a small amount of wool or bamboo or nylon to help hold their shape.&nbsp;</p>
265847 <p>Wrap yourself in our alpaca shawl with pink hearts at the points. This woven shawl reaches almost six feet across and is made of grey alpaca with accents of pink stripes and pink hearts.</p>
265851 <ul><li>100% alpaca</li><li>Sport weight</li><li>2-ply</li><li>165 yards</li></ul>
265852 <p>Green based yarn with grey streaks and darker green.</p> <ul><li>87.5% alpaca, 12.5% wool</li><li>2-ply</li><li>Worsted weight</li><li>150 yards</li></ul>
265857 <p>Grey alpaca yarn blended with red and dark pink alpaca blended into the twist.</p><p>100% alpaca&nbsp;<br></p> <p>2-ply</p> <p>Worsted weight&nbsp;</p> <p>145 yards</p> <p><br></p> <p><br></p> <p><br></p> <p><br></p> <p><br></p> <p><br></p> <p><br></p> <p><br></p> <p><br></p>
265858 <ul><li>100% alpaca</li><li>2-ply</li><li>Worsted weight</li><li>120 yards&nbsp;</li><li>Twists of black and rose grey fiber blended together.</li></ul>