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 (
    138953, 22374, 41507, 19942, 29976, 
    22970, 23144, 19919, 34981, 212181, 
    17299, 40966
  ) 
  AND product_descriptions.lang_code = 'en'

Query time 0.00709

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "10.16"
    },
    "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.96",
        "eval_cost": "1.20",
        "prefix_cost": "10.16",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`goimagine`.`product_descriptions`.`product_id` in (138953,22374,41507,19942,29976,22970,23144,19919,34981,212181,17299,40966)) and (`goimagine`.`product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
17299 <p>This necklace is made using coin shaped rose quartz gemstone beads.&nbsp; The necklace has a line of these beads that gently overlap each other.&nbsp; The necklace has 9 of these rose quartz beads that I have wire wrapped into a curved segment that attaches to antique copper chain.&nbsp; I have twirls and swirls of copper wire going around and about the rose quartz gemstones.&nbsp; The necklace closes with a lobster clasp.</p><p>The earrings are made with one of the rose quartz gemstone beads.&nbsp; I have wire wrapped these with the antique copper wire with some of the twists and swirls like the necklace.&nbsp; These hang from antique copper fish hook style ear wires. <br></p>
19919 <p></p><p>This bracelet is made with round 12 mm agate gemstone beads.&nbsp; These agate gemstone beads vary in color from brown to orange to cream.&nbsp; Each of the agate beads have several colors within the gemstone.</p><p>The earrings are one of the round agate gemstone beads with an antique copper fish hook ear wire.&nbsp; On the ends of each of these agate gemstone beads used for the earrings there is an antiqued copper beads cap.&nbsp; The total length of the earrings is 1 ½ inches. </p><p></p>
19942 <p></p> <p>This&nbsp; gemstone is wire wrapped with solid copper wire. The gemstone is also set on the diagonal for this pendant.&nbsp; The copper wire is twisted and looped over to the right, then back down to the bottom ending in a copper swirled spiral.&nbsp; I am including a black suede necklace with your purchase and a pair of matching earrings.<br></p> <p></p>
22374 <p></p><p>This pendant is a beautiful fire agate pendant.&nbsp; The main color is black, and the lines going through the pendant have a green to blue turquoise color going through.&nbsp;&nbsp;</p><p>The earrings are made out of 12mm green jade gemstone beads.&nbsp; These jade gemstone beads vary in shades of green to a purple color.&nbsp;&nbsp;</p><p></p><p></p>
22970 <p>The focal point of this jewelry set is a banded agate gemstone in shades of green, purple, and pink.&nbsp; The banded lines go in a vertical direction on the pendant.&nbsp; The bail on the pendant is wire wrapped with gold over copper wire.&nbsp; This wire is twisted into three swirls.&nbsp;</p> <p>The earrings are made by wire wrapping the green crystal, the gold plated bead, and the pink agate.&nbsp; These hang from gold plated fish hook style ear wires.</p> <p></p>
23144 <p></p> <p>This gemstone badge holder or lanyard necklace is made with agates, jasper, and jade gemstone beads.&nbsp; The agate beads are what I notice when I first look at the lanyard.&nbsp; They are a creamy white with veins of brown, tan, yellow, and orange.&nbsp; There are also some brown picture jasper gemstone beads</p> <p>The earrings are the round brown jasper gemstone beads with a silver plate bead cap on top</p> <p></p>
29976 <p>Dark turquoise blue enameled crosses with a turquoise blue crystal above the cross.&nbsp; These hang from silver plate fish hook style ear wires.</p>
34981 <p></p> <p>This bracelet is made with memory wire.&nbsp; On the memory wire is purple amethyst gemstone chips and cubed purple mirrored crystals.&nbsp; On each end there are two of the cubed crystals and one of the chips dangling.&nbsp;</p> <p>The earrings are made with a Tibetan silver chandelier charm.&nbsp; To this charm I have wire wrapped the cubed crystals and an amethyst gemstone chip.</p> <p></p> <p></p>
40966 <p></p><p>This scarf is hand crocheted in a soft yarn that is variegated in the colors of brown, rust, and cream.&nbsp; The yarn is a soft acrylic yarn.&nbsp; The pattern of the scarf is a small section of crocheting that looks like netting, then a small sections that looks like triangles.&nbsp; The yarn is beautiful in the way that it changes colors.</p><p></p>
41507 <p><b>Title:&nbsp; &nbsp;</b>Clear Cracked Glass Bead Earrings with Silver Beads Hanging from Lever Backs</p> <p><b>Earring Description:&nbsp;&nbsp;</b>These earrings are made with a round cracked glass bead as the focal.&nbsp; On each side of this is a silver plate bead cap.&nbsp; Above this are small silver place spacer beads and a saucer silver glass bead.&nbsp;&nbsp;&nbsp; These earrings would be great for your bridesmaid gifts for your wedding.</p> <p><b>Closure/Hang:&nbsp;&nbsp;</b>Lever back closure.</p> <p><b>Your Purchase:&nbsp;&nbsp;</b>Your purchase will include one pair of earrings.&nbsp; For multiples you will need to increase your quantity.</p> <p><b>Measurements:&nbsp;&nbsp;</b>The total length of the earrings is 2 1/8 inches.&nbsp; The round cracked glass bead is 12 mm in diameter&nbsp; The small silver plate spacer beads are 3mm in diameter. The silver glass saucer bead is 3mm long and 6mm wide.</p> <p><b>My Inventory Info:&nbsp;&nbsp;</b>Handmade clear cracked glass bead earrings item EE00045.</p> <p><b>Processing:&nbsp;&nbsp;</b>This item is a finished product.&nbsp; My processing time takes 1-3 days based on USPS holidays and Sundays<b><br></b></p><p><b>Packaging:&nbsp;&nbsp;</b>My packaging for jewelry will include a cotton lined jewelry box.&nbsp; I do this because it adds more protection for the jewelry while it ships.&nbsp; It also makes a nice package for giving as a gift.</p> <p><b>Environment:&nbsp;&nbsp;</b>This item was created in a smoke free and pet free home.</p> <p><b>Color:&nbsp; </b>Colors may very just a bit based on the difference in computer monitors. </p>
138953 <p><b>Pendant Description:&nbsp; </b>The center gemstone pendant for this necklace set is a black, brown, and green square jasper gemstone.&nbsp; The hole for this pendant is on the diagonal, so it looks like a diamond shape, not a square.&nbsp; The gemstone looks mostly brown.&nbsp; You can see a bit of green and brown here and there.&nbsp; I have wire wrapped the bail out of antique copper wire, and have added a couple of twirls and curls just below the bail and wire wrapped a loop at the bottom of the pendant. In this loop I have wire wrapped some fancy jasper in brown, cream, and green, and agate gemstones in brown and tan.</p> <p><b>The Chain:</b> </p> <p>I will include an antique copper chain to go with your pendant.&nbsp; That way it will be ready to wear as soon as you open your package.&nbsp; The antique copper chain is 30 inches long.&nbsp; This can be made shorter if needed. Contact me to change the length. </p> <p><b>Earring Description:&nbsp; </b>The earrings are made using the the fancy jasper gemstone with antique copper bead caps on each end.&nbsp; There is a small jasper gemstone on the top and the bottom.&nbsp; Also on the earrings I have wire wrapped a loop where I have added&nbsp; the round faceted agate gemstone and the smaller jasper gemstones that were also used on the necklace. These are wire wrapped onto an antique copper fish hook type ear wires. </p> <p><b>Your Purchase:&nbsp; </b>Your purchase will include the pendant, the chain, and the earrings. </p> <p><b>Measurements:&nbsp; </b>The jasper gemstone is 2 inches long, 1 7/8 inches wide, and 9mm thick.&nbsp; The earrings are 2 ¾ inches long.&nbsp; With the copper wire wrapped bail the total length of the pendant is 4 ½ inches.&nbsp; The fancy jasper gemstone bead is 12mm in diameter. The round faceted brown and tan agate gemstones are 8mm in diameter.&nbsp; The small round jasper beads are 4mm in diameter. </p> <p><b>My Inventory Info:&nbsp; </b>Handmade copper wire wrapped black jasper pendant with fancy jasper earrings item EN00173. </p> <p><b>Processing:&nbsp; </b>This item is a finished product.&nbsp; My processing time takes 1-3 days because I have a day job.&nbsp; I need the day job to support my yarn and bead habit.&nbsp; So, sometimes an order may come in while I am at the day job and would not be able to mail the same day. </p> <p><b>Packaging:&nbsp; </b>My packaging for jewelry will include a cotton lined jewelry box.&nbsp; I do this because it adds more protection for the jewelry while it ships.&nbsp; It also makes a nice package for giving as a gift. </p> <p><b>Environment:&nbsp; </b>This item is crafted in a smoke free and pet free home. </p> <p><b>Color:&nbsp; </b>Colors may very just a bit based on the difference in computer monitors. </p>
212181 <p><b>Necklace Description:&nbsp; </b>This is a fun necklace made with lamp work beads with designs in colors of green, black, and purple. The center lamp work bead is a black square bead measuring 18mm high, 20mm wide and 10mm thick. Inside the square is a purple circle and in the center of this circle is a smaller circle of green. Inside this inner circle of green are some specks of black. Above and below this center lamp work bead going vertical on the necklace are 8mm black glass beads. Below this bead on the center of the necklace is a silver bead with a swirl design. Below this bead is a silver plate loop, and inside this silver loop I have wire wrapped 2 of the 8mm black glass beads, two green beads, and in the center one of the silver swirl beads. These dangle from the silver loop, with the silver swirl bead in the center, the green beads on each side of the swirl, and the black on each side of the green.&nbsp; Going up the side of the necklace there are green art glass coin beads that measure 16mm in diameter and 6mm thick. The background color of these beads is a darker green, and they either have black stripes or black polka dots on them. These work their way around the necklace with some of the smaller green beads, the black glass beads, the silver swirl beads, and some of the lamp work beads.&nbsp; The necklace measures 20 ½ inches long and closes with a large silver plate toggle. The center lamp work beads and beads dangling off the silver loop described above hang down an additional 3 ¼ inches. </p> <p><b>Earring Description:&nbsp; </b>The earrings are made with the green and black striped art glass bead on a long silver plate fishhook stylew ear wire. The total length of the earrings is 2 inches. </p> <p><b>Your Purchase:&nbsp; </b>Your purchase will include both the necklace and the earrings. </p> <p><b>Measurements:&nbsp; </b>The necklace measures 20 ½ inches long and closes with a large silver plate toggle. The center lamp work beads and beads dangling off the silver loop described above hang down an additional 3 ¼ inches.&nbsp; The total length of the earrings is 2 inches. </p> <p><b>Processing:&nbsp; </b>This item is a finished product.&nbsp; My processing time takes 1-3 days based on USPS holidays and Sundays. </p> <p><b>Packaging:&nbsp; </b>My packaging for jewelry will include a cotton lined jewelry box.&nbsp; I do this because it adds more protection for the jewelry while it ships.&nbsp; It also makes a nice package for giving as a gift. </p> <p><b>Environment:&nbsp; </b>This item is crafted in a smoke free and pet free home. </p> <p><b>Color:&nbsp; </b>Colors may very just a bit based on the difference in electronic devices. </p> <p><b>Inventory: &nbsp;</b>GN00073</p>