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 (
    395653, 464851, 490697, 313812, 316452, 
    323612, 399613, 406773, 413373, 311732, 
    321723, 346052
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00274

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.03"
    },
    "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.83",
        "eval_cost": "1.20",
        "prefix_cost": "10.03",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (395653,464851,490697,313812,316452,323612,399613,406773,413373,311732,321723,346052)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
311732 <p>This listing is for a custom made 25 yard hand dyed shibori belly dance free size drawstring waistband skirt. You choose the colors and the length. This will take some communication between us to design the skirt of your dreams, so please message me before ordering. You can choose from 1 to 4 colors in the same skirt.&nbsp;You don't order and pay until you have seen and approved the photos of your dress in your own custom listing.</p>
313812 <p>This listing is for a custom made 25 yard hand dyed shibori belly dance free size drawstring waistband skirt. You choose the colors and the length. This will take some communication between us to design the skirt of your dreams, so please message me before ordering. You can choose from 1 to 4 colors in the same skirt.&nbsp;You don't order and pay until you have seen and approved the photos of your dress in your own custom listing.</p>
316452 <p>This listing is for a custom made 25 yard hand dyed shibori belly dance free size drawstring waistband skirt. You choose the colors and the length. This will take some communication between us to design the skirt of your dreams, so please message me before ordering. You can choose from 1 to 4 colors in the same skirt.&nbsp;You don't order and pay until you have seen and approved the photos of your dress in your own custom listing.</p>
321723 <p>This 37 inch long 2 in 1 Tube Dress/Bustle Skirt can be worn as a Dress or a long Skirt. It has an adjustable drawstring top for comfort and fit, and is handmade with love from a mix of vintage cotton prints and hand dyed cotton blend. It is free size, lightweight, cool and comfortable, and can even be worn as a maternity dress.<br><br>Feel free to contact me if you have any questions about the item or wholesale pricing. I am always happy to hear from you.<br><br>All of my items are handmade by me in my home studio in Atlanta, Georgia and are ready to ship right away.<br></p>
323612 <p>This listing is for a custom made 25 yard hand dyed shibori belly dance free size drawstring waistband skirt. You choose the colors and the length. This will take some communication between us to design the skirt of your dreams, so please message me before ordering. You can choose from 1 to 4 colors in the same skirt.&nbsp;You don't order and pay until you have seen and approved the photos of your dress in your own custom listing.</p>
346052 <p>This listing is for a custom made 25 yard hand dyed shibori belly dance free size drawstring waistband skirt. You choose the colors and the length. This will take some communication between us to design the skirt of your dreams, so please message me before ordering. You can choose from 1 to 4 colors in the same skirt.&nbsp;You don't order and pay until you have seen and approved the photos of your dress in your own custom listing.</p>
395653 <p>This listing is for a custom made 25 yard hand dyed shibori belly dance free size drawstring waistband skirt. You choose the colors and the length. This will take some communication between us to design the skirt of your dreams, so please message me before ordering. You can choose from 1 to 4 colors in the same skirt.&nbsp;You don't order and pay until you have seen and approved the photos of your dress in your own custom listing.</p>
399613 <p>This listing is for a custom made 25 yard hand dyed shibori belly dance free size drawstring waistband skirt. You choose the colors and the length. This will take some communication between us to design the skirt of your dreams, so please message me before ordering. You can choose from 1 to 4 colors in the same skirt.&nbsp;You don't order and pay until you have seen and approved the photos of your dress in your own custom listing.</p>
406773 <p>This listing is for a custom made 25 yard hand dyed shibori belly dance free size drawstring waistband skirt. You choose the colors and the length. This will take some communication between us to design the skirt of your dreams, so please message me before ordering. You can choose from 1 to 4 colors in the same skirt.&nbsp;You don't order and pay until you have seen and approved the photos of your dress in your own custom listing.</p>
413373 <p>This listing is for a custom made 25 yard hand dyed shibori belly dance free size drawstring waistband skirt. You choose the colors and the length. This will take some communication between us to design the skirt of your dreams, so please message me before ordering. You can choose from 1 to 4 colors in the same skirt.&nbsp;You don't order and pay until you have seen and approved the photos of your dress in your own custom listing.</p>
464851 <p>This Backless Halter Apron Top is Upcycled from a Crochet Bikini and patchworked with pretty recycled fabric for the skirt. It's perfect for a Summer Festival.<br><br>Measurements:<br>Cup size -B,C<br>Bottom Skirt Part- 22 inches wide and 16 inches long from right below the cup<br>Ties- 38 inches each<br><br>Feel free to contact me if you have any questions. I am always happy to hear from you.<br><br>All of my items are handmade by me in my home studio in Atlanta, Georgia and are all one of a kind.</p>
490697 <p>This listing is for a custom made 25 yard hand dyed shibori belly dance free size drawstring waistband skirt. You choose the colors and the length. This will take some communication between us to design the skirt of your dreams, so please message me before ordering. You can choose from 1 to 4 colors in the same skirt.&nbsp;You don't order and pay until you have seen and approved the photos of your dress in your own custom listing.</p>