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 (
    222799, 217614, 246207, 245407, 216502, 
    217753, 236337, 246162, 217616, 216503, 
    222797, 217974
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00079

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.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": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "8.92",
        "eval_cost": "1.20",
        "prefix_cost": "10.12",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (222799,217614,246207,245407,216502,217753,236337,246162,217616,216503,222797,217974)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
216502 <p>Three must-have 3-disc copper drop earrings are approximately 2" in length. They were torch fired with marigold enamel, and colorful millefiori wafers. Super light and comfortable! Works for day and evening wear.</p>
216503 <p>Three must-have 3-disc copper drop earrings are approximately 2" in length. They were torch fired with red enamel, and colorful millefiori wafers. Super light and comfortable! Works for day and evening wear.</p>
217614 <p>These apple green tribal shields boast a blue flower and a daisy. The background enamel is apple green.</p> <p>The are approximately 1" in length. These are suitable for any wardrobe.</p>
217616 <p>The color combination on these shields is lavender with green speckles enameled . The ear wires are purple hypo-allergenic , and the beads are translucent green and purple. As with the other tribal shields they are approximately 1" in length. These are perfect for casual wear.</p> <p><br></p>
217753 <p>1" sunburst earrings enameled in lavender with apple green tips. The ear wires are in purple, and are hypoallergenic.</p> <p>Perfect for any occasion.</p>
217974 <p>1" sunburst earrings enameled in red, white and blue. The ear wires are in dark blue.</p> <p>Perfect for any occasion.</p>
222797 <p>This fabulous piece will look great with anything in your wardrobe. There are many colors of millefiori wafers torched on a white enameled background. To give an idea of sizing, the largest disc is 1 1/2" in diameter. The neckchain is in bronze with a bronze magnetic closure. One of my personal favorites!</p>
222799 <p>This cross pendant is enameled in mint green and adorned with tiny millefiori flowers. At approximately 1", this piece is perfect for girls of any age. The silky black neck wear is completed with a magnetic closure. As always, my pieces are one of a kind.</p>
236337 <p>I have added a redhead to my 'glam gal' collection! She is 12" tall including the frame, and the widest point on the custom wood frame is 13". Her hair flows out of the top of the frame.</p>
245407 <p>This exquisite copper disc bracelet is part of my Eden collection. The disc is 1 1/2" in diameter, and looks fabulous on any wrist.</p> <p>The black enamel and tiny millefiori wafers were&nbsp;torched on, creating dainty flowers in white, yellow and purple. The thin, leather adjustable strap is black. This is a beauty that can be worn for any occasion, day or evening.</p>
246162 <p>This half inch copper cuff was flame-painted with a torch, resulting in the marvelous reds, greens, and blues that you see. The gauge is 20, making it a perfect weight for any wrist.</p>
246207 <p>The color combination on this 2 inch bracelet makes it work with any attire, casual or dress. The disc is enameled in apple green and lavender and is completed with an adjustable, thin purple leather strap. There is also a streak of yellow enamel on the piece.</p> <p><br></p>