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 (
    206024, 205990, 206029, 198581, 199221, 
    205982
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00071

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "5.05"
    },
    "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.45",
        "eval_cost": "0.60",
        "prefix_cost": "5.05",
        "data_read_per_join": "30K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (206024,205990,206029,198581,199221,205982)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
198581 <p>Add a piece of unique and sustainable handmade desk art to your space.&nbsp; This piece of sustainable home decor is called,<em> Camouflage</em>, since there are two figures hidden among the leaves on a nice sunny day.&nbsp; Can you find them? <em>Camouflage </em>is a sustainable product is made with nearly 50 hand-cut and folded pieces that were cut from boxes, and then glued onto another box.&nbsp; There are also 16 bright orange triangles of various lengths that radiate from the sun.&nbsp; This small paper-based wall art is approximately 13-1/4 inches in length, 6-3/4 inches in width, and 3/8 inches in depth when flat.&nbsp; <em>Camouflage </em>is intended to sit on a desk or table, but it can be adapted to hang on a wall.&nbsp; Please send me a message if you would like me to add a ribbon to hang.<br></p> <ul><li>Dimensions when flat (approximate) <ul><li>L x W x D = 13-1/4" x 6-3/4" x 3/8"</li><li>May not be completely flat</li></ul></li><li>Layout: landscape</li><li>Materials<ul><li>Snack boxes (canvas and hand-cut pieces)</li><li>Glue</li></ul></li><li>Colors<ul><li>Pink, yellow, blue, orange, purple, brown, black, green, and white</li></ul></li></ul> <p>Will ship in a small Priority Mail box, but pick-up is highly recommended.</p>
199221 <p>Add a piece of sustainable and one-of-a-kind handmade wall art to your space.&nbsp; This piece of sustainable home decor depicts a dynamic mix in nature with vibrant green leaves, brown trees, and coral colors.&nbsp; This small wall art measures 7 and 1/8 inches in length and 4 and 3/4 inches in width, including the ribbon for hanging, and has a landscape layout.&nbsp; The materials for this upcycled home decor consists of an ice cream box for the canvas, a magazine, glue, and ribbon.&nbsp; The ribbon is slightly off-center, but it can still be hung straight.&nbsp; This collage is thin and not completely flat on the back due to the amount of glue it takes for a project like this. Colors of this eco-friendly wall art are shades of green, shades of coral, brown, and white.</p> <ul><li>Dimensions<ul><li>L X W = 7-1/8" x 4-3/4"</li><li>Thickness = thin</li><li>Not completely flat when laid on the back</li></ul></li><li>Layout: landscape</li><li>Materials<ul><li>Ice cream box (canvas)</li><li>Magazine</li><li>Glue</li><li>Ribbon (to hang on the wall)</li></ul></li></ul>
205982 <p>Add a piece of handmade&nbsp;upcycled wall art to your space.&nbsp; This unique piece of home decor is titled, <em>Behind the Curtain</em> because a fairy is revealed behind a curtain of leaves.&nbsp; <em>Behind the Curtain</em> is a sustainable product with 55 hand-cut and folded pieces from boxes and then glued on another box.&nbsp; There are also more than 30 small teal triangles all over the canvas. This small paper-based wall art measures approximately 12 inches in length, 8-1/4 inches in width, including the ribbon for hanging, and 3/8 inches in depth.&nbsp; <br></p> <ul><li>Dimensions (approximate) <ul><li>L x W x D = 12" x 8-1/4" (with ribbon) x 3/8"</li></ul><ul><li>May not be completely flat on the back</li></ul></li><li>Layout: landscape</li><li>Materials<ul><li>Snack boxes (canvas and 55 hand-cut pieces)</li><li>Glue</li><li>Ribbon (to hang on the wall)</li></ul></li><li>Colors<ul><li>Pink, blue, yellow, brown, and green</li></ul></li></ul> <p>Will ship in repurposed box, but pick-up is strongly recommended to prevent damage in transit.</p>
205990 <p></p> <p>This beautifully hand-crafted upcycled card is made from boxes.&nbsp; Each card uses the same patterned or branded box, but each design is unique, because of where they were cut on the box, the size and shape of each piece, and their placements.&nbsp; These upcycled cards are two-sided like a postcard.&nbsp; The front has the pattern and the back is blank for writing.&nbsp; It has smooth writing with any pen or marker, and dark color ink is recommended.&nbsp; Because each style does not have pre-determined occasions, these eco-friendly cards can be used for any occasion the sender deems appropriate.&nbsp; An envelope is included.&nbsp; Cards and envelopes can be recycled or kept as a meaningful one-of-a-kind keepsake.</p> <ul><li>Dimensions:&nbsp;<ul><li>Card:&nbsp;L x W = Approx. 6.25 inches x 3.25 inches&nbsp;</li><li>Envelope (included): L x W = 6.5 inches x 3.5 inches&nbsp;</li></ul></li></ul>
206024 <p>This beautifully hand-crafted upcycled card is made from boxes.&nbsp; Each card uses the same patterned or branded box, but each design is unique, because of where they were cut on the box, the size and shape of each piece, and their placements.&nbsp; These upcycled cards are two-sided like a postcard.&nbsp; The front has the pattern and the back is blank for writing.&nbsp; It has smooth writing with any pen or marker, and dark color ink is recommended.&nbsp; Because each style does not have pre-determined occasions, these eco-friendly cards can be used for any occasion the sender deems appropriate.&nbsp; An envelope is included.&nbsp; Cards and envelopes can be recycled or kept as a meaningful one-of-a-kind keepsake.<br></p> <ul><li>Dimensions:&nbsp;<ul><li>Card:&nbsp;L x W = Approx. 6.25 inches x 3.25 inches</li><li>Envelope (included): L x W = 6.5 inches x 3.5 inches&nbsp;</li></ul></li></ul>
206029 <p>These beautifully unique hand-crafted upcycled cards are made from boxes.&nbsp; Each card has a different design and color palette, along with not having pre-determined occasions, these eco-friendly cards can be used for any occasion the sender deems appropriate.&nbsp; These upcycled cards are two-sided like postcards.&nbsp; They have a patterned side on the front and a blank side on the back for writing. &nbsp;They have smooth writing with any pen or marker, and dark color ink is recommended. This blank card set comes with 3 cards and 3 envelopes.&nbsp; Cards and envelopes can be recycled or kept as meaningful one-of-a-kind keepsakes.<br></p> <ul><li>Dimensions:&nbsp;<ul><li>Cards:&nbsp;L x W = Approx. 5.5 inches x 3.25 inches&nbsp;</li><li>Envelopes (included): L x W = 6.5 inches x 3.5 inches </li></ul></li></ul> <ul><li>Patterns: Coffee, Abstract Painting, and Dreams Collage</li><li>Colors:&nbsp;<ul><li>Coffee: Dark brown, brown, beige, and white</li><li>Abstract Painting: Gray, yellow, green, and purple</li><li>Dreams Collage:&nbsp;Blue, purple, yellow, white, and gray</li></ul></li></ul>