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 (
    460617, 461378, 366330, 413091, 415174, 
    421021, 425726, 425728, 427046, 435531, 
    438172, 443463
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00183

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "9.98"
    },
    "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.78",
        "eval_cost": "1.20",
        "prefix_cost": "9.98",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (460617,461378,366330,413091,415174,421021,425726,425728,427046,435531,438172,443463)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
366330 <p>Grandma Sweatshirt, God Created, Personalize With Nana, Momma, Grammy, MawMaw, Abuelita, Grandparent, Parent Gift, Ships TODAY, AGFT 606</p>
413091 <p>Grandma Sweatshirt, God Created, Personalize With Nana, Momma, Grammy, MawMaw, Abuelita, Grandparent, Parent Gift, Ships TODAY, AGFT 606</p>
415174 <p>Grandma Sweatshirt, Custom With Eight Grandkids Name, Grandparent Gift For Mammie, Grannie, Grams, Gran, Abuelita, Popser, AGFT 855</p>
421021 <p>MaMaw Sweatshirt, Custom Grandparent Gift From Grandkids, MeMaw, Mommy, Mamaw, Nonna, Nonnie, Lolly, GiGi, Mammaw,&nbsp; Ships TODAY, AGFT 901</p>
425726 <p>MawMaw Sweatshirt, Sweetheart, Custom Grandparent Gift, Personalize With Two Grandkids, Nan, Gramma, Gram, Mimi, Oma, Ships Today, AGFT 924</p>
425728 <p>Great Grandpa Sweatshirt, Custom Grandparent Gift, Personalize With Name, MeMa, Pappy, Pops, PePaw, Granny, Grammy, Ships TODAY, AGFT 361</p>
427046 <p>MawMaw Sweatshirt, Sweetheart, Custom Grandparent Gift, Personalize With Two Grandkids, Nan, Gramma, Gram, Mimi, Oma, Ships Today, AGFT 924</p>
435531 <p>Grandma Sweatshirt, God Created, Personalize With Nana, Momma, Grammy, MawMaw, Abuelita, Grandparent, Parent Gift, Ships TODAY, AGFT 606</p>
438172 <p>Great Grandpa Sweatshirt, Custom Grandparent Gift, Personalize With Name, MeMa, Pappy, Pops, PePaw, Granny, Grammy, Ships TODAY, AGFT 361</p>
443463 <p>Grandpa Sweatshirt, Personalized With Granddaughter Name, Custom Grandparent Gift,&nbsp; Opa, Grampa, Gramps, Pappy, Pop, Ships TODAY, AGFT 263</p>
460617 <p><strong>Grandma Sweatshirt, Custom Grandparent Gift, Personalize With Seven Kids Names, Nana, Memere, Mammy, Mammie, Nonna,&nbsp; AGFT 399</strong></p>
461378 <p>Grandma Sweatshirt, Custom With Eight Grandkids Name, Grandparent Gift For Mammie, Grannie, Grams, Gran, Abuelita, Popser, AGFT 855</p>