Sandbox

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 (
    276583, 276584, 287048, 287052, 283192, 
    283179, 287051, 287050
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00267

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "6.82"
    },
    "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": 8,
      "rows_produced_per_join": 8,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "6.02",
        "eval_cost": "0.80",
        "prefix_cost": "6.82",
        "data_read_per_join": "40K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (276583,276584,287048,287052,283192,283179,287051,287050)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id	short_description	full_description
276583		<p>Measuring 75mm tall by 35mm wide. this pendant features a large carved labradorite focal piece, with a beautiful deep blue and green flash. In direct light this piece reveals it’s true depth of color and light play.  Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s new-penny look or polished to bring out the highlights.</p>
276584		<p></p> <p>Measuring 57mm tall by 23mm wide. this pendant features a small carved labradorite focal piece, with a pale blue and green flash. In direct light this piece reveals pretty, subtle light play.  Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s new-penny look or polished to bring out the highlights.</p> <p></p>
283179		<p>Measuring 68mm tall by 35mm wide. this pendant features a handmade lampwork bead by artist Chuckie Mac.  Wrapped in raw copper, this piece has already been given an aged patina and polished to create a greater sense of depth and light play, but it will continue to darken and change with age, as is the nature of copper.<br></p>
283192		<p>Measuring 52mm tall by 18mm wide, this pendant features a a gorgeous flashy labradorite, dancing with green and yellow tones. In direct light this piece reveals it’s true depth of color and light play.  Wrapped in sterling silver-filled, this piece will darken or develop a patina over time, It can be sealed to maintain its shine or polished to bring out the highlights from the darkening metal.<br></p>
287048		<p>Measuring 85mm tall by 40mm wide. this pendant features a floral carved labradorite focal piece. In direct light this piece reveals it’s true depth of color and light play.  Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s current look or polished to bring out the highlights.</p>
287050		<p>Measuring 65mm tall by 42mm wide. this pendant features a beautiful purple amethyst. Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s current look or polished to bring out the highlights.</p>
287051		<p>Measuring 62mm tall by 36mm wide. this pendant features a gorgeous blue and orange sodalite. Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s current look or polished to bring out the highlights.</p>
287052		<p></p> <p>Measuring 80mm tall by 42mm wide. this pendant features a gorgeous polished piece of maligano jasper. Wrapped in raw copper, this piece will darken or develop a patina over time, It can be sealed to maintain it’s current look or polished to bring out the highlights.</p> <p></p>