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 (
    10089, 14434, 11796, 13205, 11574, 3606, 
    7119, 11513, 7496, 15101, 17303, 18931
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.01136

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.04"
    },
    "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": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "8.84",
        "eval_cost": "1.20",
        "prefix_cost": "10.04",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (10089,14434,11796,13205,11574,3606,7119,11513,7496,15101,17303,18931)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
3606 <p><span style="color: rgb(0, 0, 0);">Felt flower brooch pin, red poinsettia wool flower brooch pin</span>,&nbsp;diameter 5.5" aprox.</p>
7119 <p></p> <p>Flower brooch, pin, felt wool hydrangea, blue, pink, white hydrangea brooch hand made from wool blend felt( 35% wool, 65% rayon) and decorated with beads. Dimensions: 3.5" diameter flower approx., with leaves - 4''<br></p> <p></p>
7496 <p></p> <p>Felted necklace, blue wool felted spiral necklace, headband, fiber unique jewelry hand made by me using wet felting process from extra fine merino wool roving, viscose roving, silk organza, OOAK. Measurements: necklace around the length 39"(100cm) with strings, , 22"( 57cm) without strings approx.<br></p> <p></p>
10089 <p></p> <p>Felted&nbsp; gray stone necklace, wool rock felt collar necklace, fiber unique jewelry hand made by me using wet felting process from extra fine merino wool roving, silk fiber, viscose fiber wool fleece, OOAK. Measurements: necklace around the length 24"(60cm), width in the widest part 3" (8cm) approx.<br></p> <p></p>
11513 <p></p> <p>Felted red wrap scarf stole, nuno felted silk wool shawl, scarf hand made by using wet felting process from silk wrap, extra fine merino wool, viscose, wool fleece. This scarf soft , warm and lightweight. Measures: length 61"(155cm) without fringe and 175 with fringe, width 19.5" (50cm) approx.<br></p> <p></p>
11574 <p></p> <p>Felted red wrap, scarf, stole, shawl, nuno felted silk wool lace wrap hand made by me using wet felting process from silk stole, extra fine merino wool, viscose fiber.&nbsp; Wrap is very soft, warm and lightweight. Measurements: length 61"(155cm), width 22" (56cm) approx.<br></p> <p></p>
11796 <p></p> <p>Beige felted cobweb scarf, wrap, stole, wool felt scarf with fringe hand made by using wet felting process from extra fine merino wool roving, Falkland wool roving , tussah silk, viscose roving, wool fleece, OOAK. Measurements: length 74"(188cm) with fringe , width 15" (38cm) approx. Cobweb felted scarf is lightweight, warm, soft and cozy.<br></p> <p></p>
13205 <p>Animal print nuno felted wrap, black yellow shawl, scarf, stole, silk wool lace scarf, wrap hand made by me using wet felting process from silk stole, extra fine merino wool, viscose fiber, raw wool locks.&nbsp;Measurements: length 67"(170cm), width 21" (53cm) approx. </p>
14434 <p></p> <p>Patchwork nuno felted shawl wrap, silk, wool shawl, OOAK hand made by me using wet felting process from upcycled sari silk, cotton, viscose scarfs&nbsp; extra fine merino wool, viscose fiber. Measurements: length 80"(205cm), width 29" (74cm) in widest part approx.<br></p> <p></p>
15101 <p>Felted infinity scarf, cowl, neck warmer, blue red wool silk nuno felted loop scarf, wrap OOAK hand made by using wet felting process from extra fine merino wool, chiffon silk, viscose roving. Measurements: circumference&nbsp; 58"(146cm),&nbsp; width 16.5" (41cm) approx.</p>
17303 <p></p> <p>Eco print silk scarf, naturally dyed silk scarf with botanical prints hand dyed using plants and natural dyes. This is natural dye technique and environmentally friendly process when the color is transferred directly from the leaf to the fabric. Scarf measurements: 11" x 60" approx.<br></p> <p></p>
18931 <p></p> <p>Eco print silk scarf, pink silk scarf with botanical print, naturally dyed silk scarf hand dyed using plants and natural dyes. This is natural dye technique and environmentally friendly process when the color is transferred directly from the leaf to the fabric. Plants used: Smock bush, Maple, Oak; natural dye: brazilwood. Scarf measurements: 14" x 70" approx.<br></p> <p></p>