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 (
    99544, 99526, 99529, 99525, 99531, 99551, 
    99533
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00196

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "5.91"
    },
    "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": 7,
      "rows_produced_per_join": 7,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "5.21",
        "eval_cost": "0.70",
        "prefix_cost": "5.91",
        "data_read_per_join": "35K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (99544,99526,99529,99525,99531,99551,99533)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
99525 <p>Sweet, Tangy, and cute handmade soap. Not only is this soap look and smell delicious, but it has great skin healing properties.</p> <p><br></p> <p>Packed with vitamin E, C and A. This soap keeps your skin moisturized while clean. Helps aid aging skin, eczema, dry skin, and repairs.</p> <p><br></p> <p>This fun soap features a plastic straw(only for aesthetics), lemon wedges, and ice cubes all made from soap. ***Remove straw before use.</p> <p>This is a 4-5oz bar of soap.</p> <p>Main Ingredients: Goat milk, glycerin, coconut oil, vitamin e, mica, and fragrance.&nbsp; Full list on product.</p>
99526 <p>This handmade Royal soap smells of berry patches and features a pretty swirl of colors.</p><p>It packs a whollop of skin loving ingredients that not only clean your skin but leave you moisturized.</p><p>Main Ingredients: Goat Milk, honey, coconut oil, Vitamin E, mica and fragrance. Full list on product.</p>
99529 <p>This solid handmade lotion stick packs more moisturizers than 2 bottles of lotion combined.&nbsp;</p><p>It's for those quick touch ups or on the go swipes when you realize your lotion failed you in the middle of the day. This lotion stick is proven to last your full day.&nbsp;</p><p>Full of skin loving ingredients that improve your skin with each use.</p><p><br></p><p>To use: push the bottom of the tube up and smear on needed area of your skin. Rub in. Remember a little goes a long way.</p><p>Main Ingredients: Honey, Beeswax, Shea Butter, Mango Butter, coconut oil, fragrance, and mica. *Full list on product.</p>
99531 <p>This handmade solid lotion has your front, back and all the sides when you need it.</p> <p>It's packed full of skin loving ingredients that keep your skin moisturized throughout the day. And...it smells glorious.&nbsp;</p> <p>Picture your favorite brand of Shea mixed with the sweet cocoa scent and you have Sheacoco.</p> <p>To use: Twist the bottom of the tube until the stick meets the top of the tube. Rub on needed area and rub in. A little goes a long way.</p> <p>Main Ingredients: Beeswax, mango butter, Coconut oil, mica, fragrance. * Full list on product.</p>
99533 <p>This handmade solid stick packs a punch of moisturizers and a delicious mouth watering smell.&nbsp;</p><p>For all those moments you realize your lotion has failed or you forgot to hit up that area you thought no one would see. Perfect for a purse or beach bag.</p><p>To use: Push the bottom the the tube up, until the lotion stick reaches the top. Rub onto needed area. Rub into skin. Remember a little goes a long way.</p><p>Main Ingredients: Beeswax, Mango butter, fragrance, and mica. *Full list on product.</p>
99544 <p>This handmade soap is full of moisturizing properties that repair and rejuvenate the skin.</p><p>Made with real Goat Milk and local Honey.</p><p><br></p><p>Main Ingredients: Goat Milk, Honey, coconut oil, Vitamin E, Fragrance, and Mica. *Full list of ingredients on product.</p><p>These are 4-5oz bars.</p>
99551 <p>This handmade soap not only cleans but the smell is mouth watering.</p> <p><br></p> <p>Its full of goodness in the form of coconut oil, and Vitamin E.&nbsp;</p> <p><br></p> <p>This soap is layered fun,&nbsp; Resembling a watermelon. On top and throughout are clay watermelons for decoration.&nbsp;</p> <p>Main Ingredients: Glycerin, Honey, coconut oil, fragrance, and mica.</p>