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 (
    253582, 253583, 253589, 253584, 253591, 
    253586
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00207

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "5.11"
    },
    "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": 6,
      "rows_produced_per_join": 6,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "4.51",
        "eval_cost": "0.60",
        "prefix_cost": "5.11",
        "data_read_per_join": "30K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (253582,253583,253589,253584,253591,253586)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id	short_description	full_description
253582		<p>Made to order item. Item will ship no later than 2 weeks after purchase date.<br>Crocheted with a soft 80% acrylic, 20% wool yarn. This shawl has ties that allow you to wrap it around your back and tie it in place.</p> <p>Measures approximately 68-70" across (not including ties) and 31-32" long. Each tie is about 15-17" long.<br>Hand wash or machine wash delicate cycle in cold water. Lay flat to dry. </p> <p>Inspired by the knitwear seen on the Starz TV show, Outlander. Crocheted using a pattern designed by Crababble Crafts. </p> <p>The shawl pictured is made with a color called Oxford grey.</p> <p>Due to the handmade nature of all of my items, some variation may occur.</p> <p>Crocheted in a smoke-free home. </p> <p>Please note that colors may vary due to screen resolution, light, and camera settings.</p> <p>Shawl will ship in a padded envelope via USPS First Class Mail. If purchasing with other items, a box may be used to accommodate all of your items and will be shipped via Parcel Post instead.</p>
253583		<p>This gorgeous scarf is the perfect accessory for fall or winter. Crocheted with soft acrylic/wool blend yarn and features 3 coconut shell buttons measuring 1.5". Item will come with instructions on how to style it.<br>Buttoned measurement of approximately 11 inches from bottom of neck opening to bottom point.</p> <p>Un-buttoned measurements approximately 39" x 9.5".</p> <p>Yarn is 82% acrylic, 10% wool, 8% rayon. Color is called barley which has flecks of black, cream, and tan.</p> <p>Crocheted in a smoke-free home. Will ship in a padded envelope.</p> <p>Due to the handmade nature of my items, some variation may occur.</p> <p>Please note that color may vary due to camera, lighting, and screen resolution settings.</p> <p>Crocheted using pattern by littlehavencrochet.com</p>
253584		Sunflower resin earrings measure approximately 2.5" long (top of hook to bottom of flower) and 1.75" wide. Statement earrings, but not heavy at all. Sunflower has a pearlescent sheen. The gold/yellow color is slightly translucent. Please look at all the pictures to see the earrings against different colored backgrounds. Due to the handmade nature of each of my items, some variations may occur. Please note that the pair pictured may be a previously sold pair. Resin may have air bubbles. Resin colors/glitters are hand mixed. Earrings will ship in a padded envelope via USPS. Made in a smoke-free home. Please note that colors may vary due to screen resolution, camera, and light settings.
253586		This gorgeous cowl is the perfect accessory for fall or winter. Crocheted with soft acrylic/wool blend yarn and features 3 coconut shell buttons measuring 1.5". Item will come with instructions on how to style it. Buttoned measurement of approximately 11 inches from bottom of neck opening to bottom point. Un-buttoned measurements approximately 39" x 9.5". Yarn is 77% acrylic, 20% wool, 3% other fiber. Color is called kale which is green with flecks of cream and tan. Due to the handmade nature of my items, some variation may occur. Crocheted in a smoke-free home. Will ship in a padded envelope. Please note that color may vary due to camera, lighting, and screen resolution settings. Crocheted using pattern by littlehavencrochet.com
253589		<p>Shawl will be made and shipped no later than 2 weeks after purchase date.<br>Crocheted with a soft 80% acrylic, 20% wool yarn. This shawl has ties that allow you to wrap it around your back and tie it in place.</p> <p>Measures approximately 68-70" across (not including ties) and 31-32" long. Each tie is about 15-17" long.<br>Hand wash or machine wash delicate cycle in cold water. Lay flat to dry. </p> <p>Inspired by the knitwear seen on the Starz TV show, Outlander. Crocheted using a pattern designed by Crababble Crafts. </p> <p>The shawl pictured is made with a color called dark rose heather.</p> <p>Due to the handmade nature of all of my items, some variation may occur.</p> <p>Crocheted in a smoke-free home. </p> <p>Please note that colors may vary due to screen resolution, light, and camera settings.</p>
253591		This gorgeous Highlander Cowl is knit in a beautiful deep shade of red called claret. This cowl is sure to keep you warm and cozy! The cowl is made with a twist in it. Just pull it over your head and arrange it as you wish. Knit with bulky yarn that is 80% acrylic 20% wool. Each cowl is handmade so some variation may occur. Knit in a smoke-free home. Item will ship in a padded envelope unless a box is needed to accommodate additional items purchased. Please note that color may vary due to screen resolution, camera, and light settings. Visit my Highlander Cowls section in my Etsy shop to see the other color options available in the Highlander Cowl.