SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.product, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    2234, 2233, 6697, 4801, 4802, 5955, 5973, 
    5451, 5453, 5452, 5450, 5454
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00029

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "8.41"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "index_condition": "((`dbggbern`.`cscart_product_descriptions`.`product_id` in (2234,2233,6697,4801,4802,5955,5973,5451,5453,5452,5450,5454)) and (`dbggbern`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "7.21",
        "eval_cost": "1.20",
        "prefix_cost": "8.41",
        "data_read_per_join": "45K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "product",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id product short_description full_description
2233 Flesh & Blood TCG - Uprising Booster Display (24 Packs) - EN <p>Uprising is a standalone booster set that plunges fans into a brutal civil war sweeping across the harsh and unforgiving land of Volcor.<br><br>Dromai, an Imperial Illusionist able to conjure the legendary dragons of Volcor out of aether and ash faces off against Fai, a hot-headed Ninja who spearheads the Uprising against the draconian oppression of the Imperials, while Iyslander journeys from her Icy homestead in search of answers to painful questions seared deep within her mind.<br><br>Uprising is designed for exceptional booster draft, sealed deck, and constructed play, and includes incredible “Marvels” that will leave players and collectors in awe!<br><br>226 card set (1 Fabled, 6 Legendary, 27 Majestic, 51 Rares, 125 Commons, 16 Tokens, ??? Marvels)<br><br>Designed for sealed deck, booster draft, and constructed play.</p>
2234 Flesh & Blood TCG - Uprising Booster - EN <p>Uprising is a standalone booster set that plunges fans into a brutal civil war sweeping across the harsh and unforgiving land of Volcor.<br><br>Dromai, an Imperial Illusionist able to conjure the legendary dragons of Volcor out of aether and ash faces off against Fai, a hot-headed Ninja who spearheads the Uprising against the draconian oppression of the Imperials, while Iyslander journeys from her Icy homestead in search of answers to painful questions seared deep within her mind.<br><br>Uprising is designed for exceptional booster draft, sealed deck, and constructed play, and includes incredible “Marvels” that will leave players and collectors in awe!<br><br>226 card set (1 Fabled, 6 Legendary, 27 Majestic, 51 Rares, 125 Commons, 16 Tokens, ??? Marvels)<br><br>Designed for sealed deck, booster draft, and constructed play.</p>
4801 Flesh & Blood TCG Matte Art Sleeves Kassai (100 Sleeves) <p><strong>Kassai Sellsword unsheaths the Cintari Saber as her pulse beats loudly in her ears. The sight of her target brings her one step closer to her goal, and nothing will stand in her way.<br></strong><strong>This Matte Art sleeve features artwork by Flesh and Blood artist Soyameii.</strong><br><br>Theme your TCG decks and express yourself with awesome high detail artworks! The same textured back as our regular Matte sleeves with the shuffle feel you know and love.<br>Experience the exquisite buttery-smooth shuffle feel of Dragon Shield Mattes and play with peace of mind knowing your card game treasures are safeguarded by Dragon Shields!<br><br><strong>The sturdy cardboard box fits 75+ single sleeved cards or 65+ double sleeved cards.<br>Every box has a label at the top of the box for personalization.</strong></p>
4802 Flesh & Blood TCG Matte Art Sleeves Melody (100 Sleeves) <p><strong>Melody taps out three counts with her foot before striking up a catchy tune, enthralling the inn's entire audience with the spell-binding notes from her fiddle. The celebration has begun! This Matte Art sleeve features artwork by Flesh and Blood artist Andy Aslamov.</strong></p> <p> Theme your TCG decks and express yourself with awesome high detail artworks! The same textured back as our regular Matte sleeves with the shuffle feel you know and love. Experience the exquisite buttery-smooth shuffle feel of Dragon Shield Mattes and play with peace of mind knowing your card game treasures are safeguarded by Dragon Shields! <br><br><strong>The sturdy cardboard box fits 75+ single sleeved cards or 65+ double sleeved cards. Every box has a label at the top of the box for personalization.</strong></p>
5450 Flesh and Blood Dice - Small Chi (16mm) <p><strong>Enhance your Flesh and Blood matches with this Chi dice that indicate your resource!</strong></p> <p><strong>You will receive:</strong></p> <ul><li>1 small Chi dice</li></ul>
5451 Flesh and Blood Dice - Arcane Set Of 2 (25mm) <p><strong>Enhance your Flesh and Blood matches with these Arcane dices that indicate&nbsp;the&nbsp;scalding arcane damages your unfortunate foe is going to receive from all the Actions you have planned and stacked with your Wildfire, or just to indicate your general burns.</strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>2&nbsp;Arcane&nbsp;dice</li></ul>
5452 Flesh and Blood Dice - Runechant Set Of 2 (25mm) <p><strong>Enhance your Flesh and Blood matches with these Runechant dices that indicate your resources or damage!</strong></p> <p><strong>You will receive:</strong><br></p> <ul><li>2 Runechant dice</li></ul>
5453 Flesh and Blood Dice - Frostbite Set Of 2 (25mm) <p><strong>Enhance your Flesh and Blood matches with these Frostbite dices that indicate your resources or damage!</strong></p> <p><strong>You will receive:</strong></p> <ul><li>2 Frostbite dice</li></ul>
5454 Flesh and Blood Dice - Small Clear Set Of 8 (16mm) <div><strong>Enhance your Flesh and Blood matches with these&nbsp;clear dices that indicate your resources, damages, and defenses!</strong></div> <p><strong>The length, width, and height of the small dice is about approximately 1.6 cm (or 5/8 inches).</strong></p> <p><strong>In the set you will find:</strong><br></p> <ul><li>2 Damage dice</li><li>1 Resource dice in red</li><li>1 Resource dice in green</li><li>4 Defense dice</li></ul>
5955 Flesh and Blood - Armory Deck Dash - EN <p><em><strong>A bright spark from the bustling city of Metrix, Dash (and her digital friend Data Doll) love nothing more than putting pedal to the metal!</strong></em></p> <p>Dash has the invention ideas, Data Doll has the processing power. Together they create cool contraptions in the blink of an eye!<br>Dash's ability lets you play an item at instant speed without using your action point, which means if you crank it, you'll get a bonus action point! Boosting lets you attack multiple times. Use your hero ability to check that the top card of your deck is one you want to banish.&nbsp;</p> <p><strong>Holding Maximum Velocity&nbsp; in your arsenal or use Backup Protocol: RED to fetch it back when you've built up enough speed to pull it off!&nbsp;If your opponent doesn't defend, play the Boom Grenade from the top of your deck and you might just blow them up on the spot<br></strong></p> <p>With the Heavy Industry Power&nbsp;Plant you will get just enough extra juice to fuel the big turn you've been setting up and wipe out the opponent with maximum efficiency. Heavy Industry Ram Stop allows for extra workplace safety for when you want to use Dash's ability on the opponent's turn, or if you draw too many non-defending items. Symbiosis Shot can be fired as many times as you have action points. Heavy Industry Gear Shift offers you to let off that one extra round.<br><br><strong>Now that you've made your mark with Dash, try her out at your local game store. Use the event locator to find an Armory near you!</strong></p> <p><strong>Once you're comfortable with the deck, take it to the next level! Dash is a powerful pick for the next stage: Road to Nationals and Pro Quest!</strong></p>
5973 Flesh and Blood - Armory Deck Jarl Vetreidi - EN <p>Delve into the story behind Rathe's most fearsome heroes with all-new Armory Deck Origins! Making his debut is Jarl Vetreiđi, an Elemental Guardian who can shatter the opponent's equipment and freeze their exposed flesh!</p> <p>Ready-to-play out of the box and equipped with everything you need to dive into Classic Constructed, Armory Deck Origins: Jarl Vetreiđi brings the biting cold to your next Armory Event!</p> <p>Armory Deck Origins include brand new card designs specially made for the debuting hero, in addition to many foundational cards for their class and/or talent(s).</p> <p>An ideal way to pick-up and play at weekly Armory Events running in local game stores across the world!</p> <p></p>
6697 Flesh & Blood TCG -High Seas Display (24 Packs) - EN <p>Set sail for the High Seas in search of ancient treasure, big game sea monsters, and the adventure of a lifetime!</p> <p>High Seas introduces the highly anticipated Pirate and Necromancer classes to Flesh and Blood. Three new dual-class heroes will navigate Rathe's treacherous open waters, each wielding a unique swashbuckling strategy that taps into previously uncharted waters of Flesh and Blood game design!</p> <p>Discover breathtaking Marvels, Pirate Booty, and Lost Treasures thought to exist only in fables and folklore, in Treasure Packs, found in each display of High Seas!<br>All hands on decks! It's time to set sail for the High Seas!<br>High Seas is a standalone booster set featuring 265 cards.<br></p>