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 (231400) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00048

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "table": {
      "table_name": "product_descriptions",
      "access_type": "const",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "11",
      "ref": [
        "const",
        "const"
      ],
      "rows_examined_per_scan": 1,
      "rows_produced_per_join": 1,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "0.00",
        "eval_cost": "0.10",
        "prefix_cost": "0.00",
        "data_read_per_join": "5K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
231400 <p>Here we have pretty little terracotta flower pot that I have paint poured. All pictures are of the same pot - it looks different on each side! All of the colors of the rainbow and with a little shimmer added too!</p> <p>It is 4 1/2 inches tall and 4 1/2 inches across the planter opening.</p> <p>It has been primed before painting and sealed with an enamel gloss coat to help protect the paint. Should be suitable for outdoor use, but direct sunlight could cause fading (eventually.) I do suggest not planting live plants in these containers directly, purely because the chemicals in the paints could seep through and effect the plants roots. It may not hurt them, but I'm sure it could.&nbsp;</p><p>*Decor and artificial plant are for display purposes only.<br></p>