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 (96169, 96301, 96165, 96176) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00170

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "3.33"
    },
    "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": 4,
      "rows_produced_per_join": 4,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "2.93",
        "eval_cost": "0.40",
        "prefix_cost": "3.33",
        "data_read_per_join": "20K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (96169,96301,96165,96176)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
96165 <p>We all know one, it may even be you. No judging. This strawberry daiquiri fragranced soap will make you thirsty well before 5:00. Strawberries, limes, alcohol, ice cubes, what's not to like? Excellent lather and great skin feel, moisturizing glycerin and slight exfoliation from a few cranberry seeds sprinkled here & there. This oversized 8-9oz soap will last through many happy hours in the bath or shower. If it's too big for your hands, feel free to cut it in half with a clean kitchen knife and place one in each bath or sink! NOT EDIBLE. Don't eat (or drink) the soap. </p>
96169 <p>Yummy, limey, salty goodness! Nothing screams summer&nbsp;louder than a salt rimmed, tequila-soaked margarita.&nbsp;Party in the tub! Course grained salt on the top, for scrubbing those tired feet. Marguerite&nbsp;has excellent lather, and is handmade with moisturizing glycerin soap;&nbsp;8oz of it, for&nbsp;many "happy hours" in the bath or shower. If it's too big for your hands, feel free to cut it in half with a clean kitchen knife and place one in each bath or sink! It's all soap, even the limes. NOT EDIBLE. Don't eat (or drink) the soap. </p>
96176 <p>Peaches and limes, dancing in a fine honey wine soap create a generous 8-9 oz bath bar. Great lather with a luxurious skin feel, this soap smells just like Peach Sangria.&nbsp;Each bar is entirely handcrafted for a unique experience that makes bath time fun again!&nbsp;If it's too big for your hands, feel free to cut it in half with a clean kitchen knife and place one in each bathroom, shower, or sink! It's all soap, even the peaches and limes. Did I&nbsp;mention there's wine in the soap? NOT EDIBLE. Don't eat (or drink) the soap. This soap is not vegan, it contains honey.</p>
96301 <p>Ever had a Blue Hawaiian? Pineapple, cream of coconut, blue curaçao, and of course, rum! You really should try it, but don't drink this one;&nbsp;it's soap. This treat for your senses produces a soft, bubbly lather, enhanced by honey- a natural lather booster! The eco-glitter and gorgeous transparent blue are a feast for the eyes, and the fragrance... it's a vacation in itself. A generous bath bar sized serving of The Blue Hawaiian for your vacation or staycation, a full 8-9 oz of soap.&nbsp;&nbsp;If it's too big for your hands, feel free to cut it in half with a clean kitchen knife and place one in each bathroom, shower, or sink! It's all soap, even the cherries and hand carved pineapples. NOT EDIBLE. Don't eat (or drink) the soap. This soap is not vegan, it contains honey.</p>