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 (
    3765, 3846, 6924, 5186, 6925, 5187, 5336, 
    4207, 2346, 3522, 3442, 2343
  ) 
  AND cscart_product_descriptions.lang_code = 'de'

Query time 0.00047

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 (3765,3846,6924,5186,6925,5187,5336,4207,2346,3522,3442,2343)) and (`dbggbern`.`cscart_product_descriptions`.`lang_code` = 'de'))",
      "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
2343 Weiß Schwarz - Saekano: How to Raise a Boring Girlfriend Booster Display (16 Packs) - EN <p>Inspired by the encounter with this dream heroine, join Tomoya in his fun-filled journey to realize his dreams of creating the ultimate dating sim! Together with the support of his friends, Tomoya is one step closer to making his dream a reality.<br><br>One spring day, I came face to face with Weiß Schwarz.<br><br>Every pack you purchase has a chance to contain a foiled SP card!<br><br>※Please be informed that the artwork for the SP cards have been modified from the Japanese Edition.<br>For more details, please visit the product page on our website.<br><br>NEO-STANDARD DECK CONSTRUCTION<br>The cards in this Booster Pack may be used together with cards with card number beginning with「SHS/」!</p>
2346 Weiß Schwarz - Rascal Does Not Dream of a Dreaming Girl Booster Display (16 Packs) - EN <p>"Rascal Does Not Dream of a Dreaming Girl" joins the Weiß Schwarz lineup!<br><br>The movie sequel to "Rascal Does Not Dream of Bunny Girl Senpai" focuses on the puberty syndrome of Shoko Makinohara.<br><br>Don't miss this chance to power up your deck!<br><br>Every pack you purchase has a chance to contain a foiled SP or SEC card!<br><br>*Please be informed that the artwork for the SP and SEC cards have been modified from the Japanese Edition.<br>NEO-STANDARD DECK CONSTRUCTION<br>The cards in this Booster Pack may be used together with cards with card number beginning with 「SBY/」 !<br><br>Compatible with the following neo-standard products:<br>• Trial Deck+ Rascal Does Not Dream of Bunny Girl Senpai<br>• Booster Pack Rascal Does Not Dream of Bunny Girl Senpai</p>
3442 Weiß Schwarz - Saekano: How to Raise a Boring Girlfriend Booster - EN <p>Inspired by the encounter with this dream heroine, join Tomoya in his fun-filled journey to realize his dreams of creating the ultimate dating sim! Together with the support of his friends, Tomoya is one step closer to making his dream a reality.<br><br>One spring day, I came face to face with Weiß Schwarz.<br><br>Every pack you purchase has a chance to contain a foiled SP card!<br><br>※Please be informed that the artwork for the SP cards have been modified from the Japanese Edition.<br>For more details, please visit the product page on our website.<br><br>NEO-STANDARD DECK CONSTRUCTION<br>The cards in this Booster Pack may be used together with cards with card number beginning with「SHS/」!</p>
3522 Weiß Schwarz - Revue Starlight The Movie Booster Display (16 packs) - EN <p></p> <p>The Stage Girls' Silver Screen Revue unfolds on the stage of Weiß Schwarz!</p> <p>"Revue Starlight The Movie" which has been receiving raving reviews since its release in June 2021, is now coming to the stage of Weiß Schwarz!</p> <p>This product is not only compatible with past editions, it can also be used to build a "Revue Starlight" deck to play!</p> <p>Every pack you purchase has a chance to contain a SIGN CARD!</p> <p>Chance to collect 9 Hot-Stamp autographed cards from the cast, as well as, 9 new illustrations!</p> <p>Momoyo Koyama as Karen Aijo Suzuko Mimori as Hikari Kagura Maho Tomita as Maya Tendo Hinata Satou as Junna Hoshimi Haruki Iwata as Mahiru Tsuyuzaki</p> <p>Moeka Koizumi as Nana Daiba Aina Aiba as Claudine Saijo Teru Ikuta as Futaba Isurugi Ayasa Itou as Kaoruko Hanayagi</p> <p>Plus, you get a chance to collect Green cards, in addition to Yellow, Red, and Blue ones! Yellow Card ...... Nana Daiba / Kaoruko Hanayagi Green Card ...... Junna Hoshimi / Mahiru Tsuyuzaki Red Card ...... Karen Aijo / Claudine Saijo / Futaba Isurugi Blue Card ...... Hikari Kagura / Maya Tendo</p> <p>NEO-STANDARD DECK CONSTRUCTION The cards in this Booster Pack may be used together with cards with card number beginning with RSL! &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</p> <p>Compatible with the following neo-standard products Trial Deck+ Revue Starlight Booster Pack Revue Starlight Booster Pack Revue Starlight -Re LIVE-</p> <p>Special Items!! 1 of 9 exclusive PR cards in every display box! 1 English Edition exclusive Stitched Playmat included in every carton!</p> <p>Products Specifications Total 100 types of cards + 57 types (Parallel) 9 cards per pack, 16 packs per display 18 displays per carton Weiß Schwarz (English Edition) does not include gold/silver campaign coupon.</p>
3765 Weiß Schwarz - Dengeki Bunko Weiss Side Trial Deck - JP
3846 Weiß Schwarz - Guilty Gear -Strive- Booster Display (16 Packs) - EN <p>Parallel Cards Included - Frameless OFR (Over Frame Rare) cards with illustration specially drawn by the artist, hncl</p> <p>- SP (Special Rare) cards with unique hot stamp in gold</p> <p>That's not all... There's also a SEC (Secret Rare) card with signature by Daisuke Ishiwatari, developer of Guilty Gear! Tournament Store Assist PR Pack Campaign These packs will only be available at tournament-registered stores! We are pleased to announce an exciting new campaign for the upcoming "Guilty Gear -Strive-" booster pack. We believe this campaign will help greatly to promote the upcoming set, and hope you make full use of it! Campaign Rules</p> <p>Customers can receive 1 Tournament Store Assist PR Pack with the purchase of 1 booster pack display of the below product (while stocks last):</p> <p>• Weiß Schwarz (English Edition Original) Booster Pack Guilty Gear -Strive-</p> <p>Each pack will contain 1 random type of 5 types of special PR cards! The 5 types contain 5 foil parallel designs.</p> <p>Limited to 5 packs per person. Subject to availability while stocks last. The TSAPP card images will be revealed at a later date.</p> <p>Special Items!! (Limited to 1st Edition only) • 1 of 10 exclusive PR cards in every display box! • 4 Rubber Playmats included in every carton!</p> <p>Products Specifications Total 100 types of cards + 56 types (Parallel) 9 cards per pack, 16 packs per display 18 displays per carton Weiß Schwarz (English Edition) does not include gold/silver campaign coupon. &nbsp;</p>
4207 Weiß Schwarz - Lycoris Recoil Booster Display (16 Packs) - EN <p>The popular anime "Lycoris Recoil" arrives on the stage of Weiß Schwarz!&nbsp; Build your deck with your favorite characters from Café LycoReco and more with this Booster Pack!</p> <p>Consists of 7 newly drawn illustrations! Chisato Nishikigi (2 types) / Takina Inoue (2 types) Mizuki Nakahara / Kurumi / Majima</p> <p>★Hot-stamped sign cards of the VA★ Every pack you purchase has a chance to contain a sign card from the following cast: • Chika Anzai (as Chisato Nishikigi) • Shion Wakayama (as Takina Inoue) • Ami Koshimizu (as Mizuki Nakahara) • Misaki Kuno (as Kurumi) • Yoshitsugu Matsuoka (as Majima)</p> <p>NEO-STANDARD DECK CONSTRUCTION The cards in this Booster Pack may be used together with cards with card number beginning with「LRC/」!</p> <p>Special Items!! (Exclusive to 1st Edition only) • 1 of 6 exclusive PR cards in every display box! • 1 English Edition exclusive Stitched Playmat included in every carton!</p> <p>Product Specifications Total 100 types of cards + 39 types (Parallel) 9 cards per pack, 16 packs per display 18 displays per carton ※Weiß Schwarz (English Edition) does not include gold/silver campaign coupon.</p>
5186 Weiß Schwarz - JoJo's Bizarre Adventure: Stardust Crusaders Premium Booster Display (6 packs) - EN <p><strong>Die Erfolgsserie "JoJo's Bizarre Adventure: Stardust Crusaders" reist auf die Bühne von Weiß Schwarz!&nbsp;<br>Du kannst auch mit den Karten aus "JoJo's Bizarre Adventure" mischen und spielen: Stone Ocean", das am selben Tag erscheint!</strong></p> <p><strong>Jede Packung garantiert 1 glänzende Karte mit heißer Prägung!</strong></p> <p><strong>SP (Special)-Karten enthalten außerdem ein heiß gestempeltes Zeichen!</strong></p> <p><strong>Enthaltene Signierte Karten:</strong></p> <ul><li>Daisuke Ono (als Jotaro Kujo)&nbsp;</li><li>Takehito Koyasu (als DIO)&nbsp;</li><li>Kenta Miyake (als Mohammed Avdol)&nbsp;</li><li>Daisuke Hirakawa (als Noriaki Kakyoin)&nbsp;</li><li>Fuminori Komatsu (als Jean Pierre Polnareff)&nbsp;</li><li>Misato Fukuen (als Iggy)&nbsp;</li><li>Hidenobu Kiuchi (als Hol Horse)</li></ul> <p><strong>Inhalt des Sets:</strong><br></p> <ul><li>60 Typen (Normal)</li><li>67 Typen (Parallel)!</li><li>N (Normal): 60 Typen&nbsp;</li><li>JJR (JoJo Selten): 60 Typen (Heiß gestempelt)&nbsp;</li><li>SP (Spezial): 7 Typen (Heißgestempeltes Zeichen)</li></ul> <p><strong>Neo-Standard Deckaufbau Die Karten in diesem Premium Booster können zusammen mit Karten verwendet werden, deren Kartennummern mit「JJ/」 beginnen!</strong></p>
5187 Weiß Schwarz - JoJo's Bizarre Adventure: Stone Ocean Premium Booster Display (6 packs) - EN <p><strong>Die Erfolgsserie "JoJo's Bizarre Adventure: Stone Ocean" reist auf die Bühne von Weiß Schwarz!</strong><br>Du kannst auch mit den Karten aus "JoJo's Bizarre Adventure" mischen und spielen: Stardust Crusaders", das am selben Tag erscheint!</p> <p><strong>Jede Packung garantiert 1 glänzende Karte mit heißer Prägung!</strong></p> <p><strong>SP (Special)-Karten enthalten außerdem ein heiß gestempeltes Zeichen!</strong></p> <p><strong>Enthaltene Signierte Karten:</strong></p> <ul><li>Fairouz Ai (als Jolyne Cujoh)&nbsp;</li><li>Yūichirō Umehara (als Wettervorhersage)&nbsp;</li><li>Tomokazu Seki (als Vater Pucchi)&nbsp;</li><li>Mutsumi Tamura (als Ermes Costello)&nbsp;</li><li>Mariya Ise (als F.F.)&nbsp;</li><li>Daisuke Namikawa (als Narciso Anastasia)&nbsp;</li><li>Atsumi Tanezaki (als Emporio Alnino)&nbsp;</li><li>Daisuke Ono (als Jotaro Kujo)</li></ul> <p><strong>Inhalt des Sets:</strong></p> <ul><li>N (Normal): 60 Typen&nbsp;</li><li>JJR (JoJo Rare): 60 Typen (heiß gestempelt)&nbsp;</li><li>SP (Spezial): 8 Typen (heiß gestempeltes Zeichen)</li></ul> <p><strong>Neo-Standard Deckaufbau Die Karten in diesem Premium Booster können zusammen mit Karten verwendet werden, deren Kartennummern mit「JJ/」 beginnen!</strong></p>
5336 Weiß Schwarz - Love Live School idol festival 2 MIRACLE LIVE! Booster Display (16 Packs) - EN <p>Love Live School idol festival 2 MIRACLE LIVE! arrives on the stage of Weiß Schwarz! This product brings all 4 groups in the Love Live series to the stage!</p> <p>Whether it be [μ's], [Aquors], [Nijigasaki High School Idol Club], or [Liella!], you'll be able to combine their strengths together! You can even use these cards to power up your older decks from the Love Live series!</p> <p>Consists of sign cards from the voice actors!</p> <p>Emi Nitta (as Honoka Kosaka) Anju Inami (as Chika Takami) Aguri Onishi (as Ayumu Uehara) Sayuri Date (as Kanon Shibuya)</p> <p>Also consists of newly drawn illustrations!</p> <p>Honoka Kosaka / Chika Takami / Ayumu Uehara / Kanon Shibuya</p> <p> Featuring Hot-Stamped Sign Cards!</p> <p>All 39 School Idols have member sign cards!</p> <p>Special Items Limited to the 1st Edition Only</p> <p>Box Topper 1 of 4 exclusive PR cards in every display box! Carton Topper 1 English Edition exclusive Stitched Playmat included in every carton!</p> <p>Product Specifications Total 138 types: 60 types (Normal) + 120 types (Parallel)&nbsp; 9 cards per pack 16 packs per display 18 displays per carton</p>
6924 Weiß Schwarz - JoJo's Bizarre Adventure: Stardust Crusaders Premium Booster - EN <p><strong>Die Erfolgsserie "JoJo's Bizarre Adventure: Stardust Crusaders" reist auf die Bühne von Weiß Schwarz!&nbsp;<br>Du kannst auch mit den Karten aus "JoJo's Bizarre Adventure" mischen und spielen: Stone Ocean", das am selben Tag erscheint!</strong></p> <p><strong>Jede Packung garantiert 1 glänzende Karte mit heißer Prägung!</strong></p> <p><strong>SP (Special)-Karten enthalten außerdem ein heiß gestempeltes Zeichen!</strong></p> <p><strong>Enthaltene Signierte Karten:</strong></p> <ul><li>Daisuke Ono (als Jotaro Kujo)&nbsp;</li><li>Takehito Koyasu (als DIO)&nbsp;</li><li>Kenta Miyake (als Mohammed Avdol)&nbsp;</li><li>Daisuke Hirakawa (als Noriaki Kakyoin)&nbsp;</li><li>Fuminori Komatsu (als Jean Pierre Polnareff)&nbsp;</li><li>Misato Fukuen (als Iggy)&nbsp;</li><li>Hidenobu Kiuchi (als Hol Horse)</li></ul> <p><strong>Inhalt des Sets:</strong><br></p> <ul><li>60 Typen (Normal)</li><li>67 Typen (Parallel)!</li><li>N (Normal): 60 Typen&nbsp;</li><li>JJR (JoJo Selten): 60 Typen (Heiß gestempelt)&nbsp;</li><li>SP (Spezial): 7 Typen (Heißgestempeltes Zeichen)</li></ul> <p><strong>Neo-Standard Deckaufbau Die Karten in diesem Premium Booster können zusammen mit Karten verwendet werden, deren Kartennummern mit「JJ/」 beginnen!</strong></p>
6925 Weiß Schwarz - JoJo's Bizarre Adventure: Stone Ocean Premium Booster - EN <p><strong>Die Erfolgsserie "JoJo's Bizarre Adventure: Stone Ocean" reist auf die Bühne von Weiß Schwarz!</strong><br>Du kannst auch mit den Karten aus "JoJo's Bizarre Adventure" mischen und spielen: Stardust Crusaders", das am selben Tag erscheint!</p> <p><strong>Jede Packung garantiert 1 glänzende Karte mit heißer Prägung!</strong></p> <p><strong>SP (Special)-Karten enthalten außerdem ein heiß gestempeltes Zeichen!</strong></p> <p><strong>Enthaltene Signierte Karten:</strong></p> <ul><li>Fairouz Ai (als Jolyne Cujoh)&nbsp;</li><li>Yūichirō Umehara (als Wettervorhersage)&nbsp;</li><li>Tomokazu Seki (als Vater Pucchi)&nbsp;</li><li>Mutsumi Tamura (als Ermes Costello)&nbsp;</li><li>Mariya Ise (als F.F.)&nbsp;</li><li>Daisuke Namikawa (als Narciso Anastasia)&nbsp;</li><li>Atsumi Tanezaki (als Emporio Alnino)&nbsp;</li><li>Daisuke Ono (als Jotaro Kujo)</li></ul> <p><strong>Inhalt des Sets:</strong></p> <ul><li>N (Normal): 60 Typen&nbsp;</li><li>JJR (JoJo Rare): 60 Typen (heiß gestempelt)&nbsp;</li><li>SP (Spezial): 8 Typen (heiß gestempeltes Zeichen)</li></ul> <p><strong>Neo-Standard Deckaufbau Die Karten in diesem Premium Booster können zusammen mit Karten verwendet werden, deren Kartennummern mit「JJ/」 beginnen!</strong></p>