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 (238475, 238487, 238492, 238481) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00058

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "3.32"
    },
    "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.92",
        "eval_cost": "0.40",
        "prefix_cost": "3.32",
        "data_read_per_join": "20K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (238475,238487,238492,238481)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
238475 <p>Reiki & Crystal Infused. Our smokeless smudge will lighten the energy of any room within minutes. Clear your space, clear your aura, this stuff is amazing for empaths as well; it's a difference you can literally feel.<br>Blended with two different types of Sage, Palo Santo, and Lemongrass essential oils, you can skip the smoke of smudging and just spray away. This power packed blend is made with only the highest grade organically grown oils out there.</p> <p>Organic Essential Oils: Clary Sage, Dalmation Sage, Palo Santo, Lemongrass, Litsea.</p> <p>Our smokeless spray is also supercharged with cleared and full moon charged:</p> <p>Fluorite for it’s balancing nature and ability to radiate overall positivity.</p> <p>Amethyst wards off psychic attack and calms anger.</p> <p>Quartz also repels negativity, harmonizes the chakras, and amplifies all other properties within the blend.</p>
238481 <p>Reiki Infused. Smudge is a unique blend of negative vibe busting essential oils that will lighten the energy of any room within minutes. It's a difference you can literally feel.Skip the smoke of smudging and just diffuse throughout the day. This power packed blend is 100% pure, made with only the highest grade organically grown essential oils out there.<br>Add 2-4 drops into your diffuser and let the good vibes roll!</p> <p>As a bonus the essential oils used within will naturally neutralize bacteria and other impurities in the air and leave the room smelling fresh.</p> <p>Smudge features: clary sage, dalmatian sage, palo santo, lemongrass and litsea essential oils.</p>
238487 <p>Reiki Charged. Get rid of lingering energy, neutralize a space for meditation or dispel bad vibes in your home.All of our Sage is sustainably grown on private land and very carefully collected to preserve these sacred plants.</p>
238492 <p>Reiki Charged - Get rid of lingering energy, neutralize a space for meditation or tarot session, or dispel bad vibes in your home<br>Palo Santo is heavily regulated in South America and all of our Palo Santo is naturally harvested from a community in Northern Peru that replants thousands of saplings of Palo Santo each year.&nbsp; It is also illegal to cut Palo Santo trees down so all of the trees that are collected have naturally fallen and have been laying in the sun for years.</p> <p>Therefore this Palo Santo is sustainably collected from naturally fallen tress & limbs only.</p>