SELECT 
  cscart_product_descriptions.product_id, 
  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 (
    47011, 40439, 47013, 40434, 47010, 40440, 
    47016, 47018, 47019, 47017, 40452, 
    39613, 40454, 40453, 306, 48843, 2321, 
    40455, 21464, 48844, 39612, 48850, 
    2317, 48849, 48847, 48845, 48851, 48852, 
    48848, 49397
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00229

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_descriptions",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "PRIMARY",
          "key_length": "11",
          "used_key_parts": ["product_id", "lang_code"],
          "rows": 30,
          "filtered": 100,
          "index_condition": "cscart_product_descriptions.product_id in (47011,40439,47013,40434,47010,40440,47016,47018,47019,47017,40452,39613,40454,40453,306,48843,2321,40455,21464,48844,39612,48850,2317,48849,48847,48845,48851,48852,48848,49397) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description
306 <p><span>Do Art invites you to stroll down a vibrant avenue of handcrafted leather AirPods cases. Move beyond the ordinary with their collection, where classic brown gives way to a symphony of colors. Imagine a stylish AirPods case that blends verdant green with a pop of fiery red, a testament to the boundless creativity of Do Art's artisans. These cases transcend mere protection; each one is a meticulously crafted work of art, infused with the passion of its creator. So slip your AirPods into a Do Art case, and don't just listen to your music - wear it.</span></p> <h3>How to order your own personalized airpods case or give it as a gift:</h3> <p>- Select Add-on engraved name as required</p> <p>- Write the name you want engraved on the case in the "<span>Customer note to Brand</span>" box. Character limit is 5-7 characters</p> <p><em>Note: Customers should note that the time it takes to place an engraved name will be about 7-10 days</em></p>
2317 <p><span>Tired of the ordinary AirPods case? Đỏ Art has crafted a unique masterpiece that will turn heads. </span></p> <p><span>Imagine an AirPods case meticulously hand-painted to resemble layers of sparkling dragon scales. Each scale is imbued with both magic and power, inspired by the legendary creatures of Vietnamese folklore. The artist, Đỏ Art, has captured the essence of the blue dragon from the "Dragon and the Fairy" tale, symbolizing a wish for a life filled with prosperity and abundance. This stunning transformation transcends the functionality of a case, becoming a wearable work of art that celebrates Vietnamese heritage.\</span></p> <h3>How to order your own personalized airpods case or give it as a gift:</h3> <p>- Select Add-on engraved name as required</p> <p>- Write the name you want engraved on the case in the "<span>Customer note to Brand</span>" box. Character limit is 5-7 characters</p> <p><em>Note: Customers should note that the time it takes to place an engraved name will be about 7-10 days</em></p>
2321 <p><span>Do Art's "Chim Lac in Breaking Dawn" AirPods case is a vibrant homage to Vietnamese culture. Made from high-quality cowhide, the design features a majestic crane spreading its wings against a backdrop of bold yellow and red. </span></p> <p><span>This hand-painted artwork isn't just aesthetically pleasing, it's meticulously crafted with close attention to detail. The "Chim Lac in Breaking Dawn" case transcends mere protection for your AirPods, transforming them into a stylish and artistic accessory.</span></p> <h3>How to order your own personalized airpods case or give it as a gift:</h3> <p>- Select Add-on engraved name as required</p> <p>- Write the name you want engraved on the case in the "<span>Customer note to Brand</span>" box. Character limit is 5-7 characters</p> <p><em>Note: Customers should note that the time it takes to place an engraved name will be about 7-10 days</em></p>
21464 <p><span>Imagine Vincent van Gogh's swirling night sky brought to life right next to you. The Starry Night AirPods case captures the essence of this iconic masterpiece, transforming your everyday tech into a miniature work of art. </span></p> <p><span>Handcrafted from genuine cowhide, the case boasts a meticulously hand-painted recreation of Van Gogh's famed brushstrokes. Each twist and turn of the starry night is meticulously reproduced, ensuring the brilliant starlight shines brightly against the deep blues and yellows that define this beloved painting. With the Starry Night case, a touch of artistic brilliance is always within reach.</span></p> <h3>How to order your own personalized airpods case or give it as a gift:</h3> <p>- Select Add-on engraved name as required</p> <p>- Write the name you want engraved on the case in the "<span>Customer note to Brand</span>" box. Character limit is 5-7 characters</p> <p><em>Note: Customers should note that the time it takes to place an engraved name will be about 7-10 days</em></p>
39612 <p>Inspired by the 12 Zodiacs in Eastern culture, each keychain in this collection is both a useful item and a piece of art itself. The artisans at Đỏ have meticulously hand-drawn the image of the Mouse on genuine cowhide leather. Not only that, every detail, from the hook to the painting's structure and colorways has been taken with extreme care to bring you the best quality.</p> <h3>How to order your own personalized keychain or give it as a gift:</h3> <p>- Select Add-on engraved name as required</p> <p>- Write the name you want engraved on the key chain in the "<span>Customer note to Brand</span>" box. Character limit is 5-7 characters</p> <p><em>Note: Customers should note that the time it takes to place an engraved name will be about 7-10 days</em></p>
39613 <p><span>This hand-crafted lighter isn't just an everyday tool; it's a work of art created exclusively by Đỏ. Each lighter features intricate details that are gracefully hand-drawn directly onto 100% genuine cowhide leather. But what truly sets these lighters apart is their bespoke nature. To ensure each piece reflects the owner's individuality, Đỏ only creates them upon receiving an order. </span></p> <p><span>This meticulous approach transforms the lighter from a simple flame source into a unique and personal gift. Imagine the delight of someone receiving a lighter that's not only beautiful but crafted specifically for them – a testament to their individuality and a constant reminder of the artistic inspiration behind it.</span></p> <h3><span>Adding an elegant touch as your personal touch to the lighter with engraved name: </span></h3> <p><span>- </span>Write the name you want engraved on the key chain in the "<span>Customer note to Brand</span>" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 7-10 days</p> <p><em>Note: </em><em>The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same. </em></p>
40434 <p>"Ox" belongs to the hand-drawn keychain line, inspired by the 12 Zodiacs in Eastern culture. To recreate the image of a strong ox, the artisans have meticulously drawn on genuine cowhide leather. The keychain also comes with a metal ring, making it convenient for you to use it as an ordinary keychain or accessory for your daily handbag or backpack.</p> <h3>How to order your own personalized keychain or give it as a gift:</h3> <p>- Select Add-on engraved name as required</p> <p>- Write the name you want engraved on the key chain in the "<span>Customer note to Brand</span>" box. Character limit is 5-7 characters</p> <p><em>Note: Customers should note that the time it takes to place an engraved name will be about 7-10 days</em></p>
40439 <p>Of the 12 animals, "Horse" is a symbol of perseverance and constancy. Therefore, in addition to being a gift for people born in the year of horses, this keychain in Đỏ 12 zodiacs collection is also a meaningful gift. The keychain is made from cowhide, then painted and colored by hand with ingenuity to help the overall look both artistic and poetic of the magical oriental culture.</p> <h3>How to order your own personalized keychain or give it as a gift:</h3> <p>- Select Add-on engraved name as required</p> <p>- Write the name you want engraved on the key chain in the "<span>Customer note to Brand</span>" box. Character limit is 5-7 characters</p> <p><em>Note: Customers should note that the time it takes to place an engraved name will be about 7-10 days</em> </p>
40440 <p>Leather keychains always radiate a trendy, luxurious style but still look dusty in their own way. To add to the impression, the keychain is hand-painted with the image of the goat, inspired by the 12 zodiacs in Eastern culture. All hand-painted details, the product can enhance your style better every time you use it.</p> <h3>How to order your own personalized keychain or give it as a gift:</h3> <p>- Select Add-on engraved name as required</p> <p>- Write the name you want engraved on the key chain in the "<span>Customer note to Brand</span>" box. Character limit is 5-7 characters</p> <p><em>Note: Customers should note that the time it takes to place an engraved name will be about 7-10 days</em></p>
40452 <p><span>Forget your standard plastic lighters. At Đỏ, they elevate the humble flame into a piece of art. Each lighter is meticulously hand-drawn on genuine leather, transforming a functional object into something truly captivating. The intricate details, likely featuring the Eye of Ra in this case, showcase the skill of the artist and ensure no two lighters are exactly alike. This inherent uniqueness makes them a fantastic choice for a personalized gift, offering the recipient a surprise they'll treasure and admire with every use.</span></p> <h3><span>Adding an elegant touch as your personal touch to the lighter with engraved name: </span></h3> <p><span>- </span>Write the name you want engraved on the product in the "<span>Customer note to Brand</span>" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 7-10 days</p> <p><em>Note: </em><em>The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same. </em></p>
40453 <p>The lighter, with a creative and exclusive design by Đỏ will not let you down. With meticulousness in hand-drawn patterns on genuine leather, Đỏ has created a different and highly personalized lighter. You can own one to express your personality as well as give it as a gift.</p> <h3><span>Adding an elegant touch as your personal touch to the lighter with engraved name: </span></h3> <p><span>- </span>Write the name you want engraved on the product in the "<span>Customer note to Brand</span>" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 7-10 days</p> <p><em>Note: </em><em>The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same. </em></p>
40454 <p>A seemingly ordinary item, but when it passed through the Đỏ, it became extremely sophisticated thanks to its handicraft value.</p> <p>Traditional bronze drum patterns are hand-drawn by artisans on genuine leather, then wrapped around a bronze lighter. The whole creates a special and unique accessory, showing the personality of the owner.</p> <h3>Adding your personal touch to the lighter with engraved name:</h3> <p>- Write the name you want engraved on the lighter in the "Customer note to Brand" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 3-4 days</p> <p><em>Note: The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same. </em></p> <p style="text-align:center;"><img src="https://chus.vn/images/chus/logo/Chuschoice-ngang%202.png?1709020039259" alt="" width="254" height="54" /></p> <p style="text-align:center;"><span style="font-size:12pt;color:#000080;">Consistently earned 5⭐, guaranteed return, shipped on time, certified by CHUS</span></p>
40455 <p><span>Stand out from the crowd with this sophisticated lighter featuring a graceful Vietnamese crane, a symbol of Đỏ. The lighter boasts a one-of-a-kind design thanks to meticulously hand-drawn patterns on genuine leather, all brought together in a beautifully balanced color scheme. It's more than just a way to light up - it's a conversation starter and a reflection of your own unique style. </span></p> <p><span>But this lighter isn't just for you. It also makes a thoughtful gift for someone special. The intricate craftsmanship and cultural symbolism will leave a lasting impression, fostering a deeper connection and a sense of respect between you and the recipient.</span></p> <h3>Adding your personal touch to the lighter with engraved name:</h3> <p>- Write the name you want engraved on the lighter in the "Customer note to Brand" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 3-4 days</p> <p><em>Note: The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same. </em></p> <p> </p> <p style="text-align:center;"><img src="https://chus.vn/images/chus/logo/Chuschoice-ngang%202.png?1709020093050" alt="" width="254" height="54" /></p> <p style="text-align:center;"><span style="font-size:12pt;color:#000080;">Consistently earned 5⭐, guaranteed return, shipped on time, certified by CHUS</span></p>
47010 <p><span>Inspired by Vincent Van Gogh's iconic painting, this ring transcends mere jewelry to become a part of the artistic story. The meticulously crafted stainless steel base ensures durability, while the hand-painted leather adds a unique and captivating touch, reminiscent of Van Gogh's brushstrokes. Imagine a splash of sunshine yellow or a hint of the vibrant blue sky adorning your finger, a constant reminder of the beauty and hope captured in the painting. Available in a refined silver color and three distinct sizes, this ring is perfect for personal adornment or a cherished gift for art enthusiasts. It's a way to carry a piece of Van Gogh's brilliance with you wherever you go.</span></p>
47011 <p><span>Đỏ Art offers a unique way to wear your love for art. They transform iconic paintings into stunning rings, creating wearable pieces imbued with artistic and sentimental value. One such example is their take on Van Gogh's "Almond Blossoms." Đỏ meticulously hand-paints the artwork onto genuine leather, encased in a luxurious, versatile stainless steel band. This combination ensures the ring's elegance transcends any occasion, making it a perfect accessory for work, a night out, or even a heartfelt gift for someone special. By incorporating renowned artworks, Đỏ goes beyond creating mere jewelry; they craft conversation starters and personal statements that celebrate both fashion and artistic appreciation.</span></p>
47013 <p><span>Đỏ elevates art beyond the canvas by translating captivating paintings into wearable masterpieces. Their rings transform a traditional accessory into a unique expression of your personality and style. </span></p> <p><span>Imagine the luxurious gleam of stainless steel intertwined with the bold dominance of a blue motif – a captivating fusion of art and adornment. Each ring is meticulously handcrafted, ensuring the quality reflects the beauty it embodies. This artistic expression is versatile, accompanying you from the office to a night out, making a lasting impression on any occasion. Whether you're treating yourself or searching for a distinctive gift, Đỏ's rings offer a captivating synergy of art and personal style.</span></p>
47016 <p>Đỏ Art wants to bring famous paintings into its products, transforming them into fashionable items with deep artistic value. Therefore, the famous painting "The Scream" by Edvard Munch has been recreated by hand on genuine leather, combined with the silver steel color to create a beautiful ring with a unique and distinctive design. The ring is suitable for any occasion as well as a gift for loved ones.</p>
47017 <p>To Đỏ Art, paintings aren't merely images; they're an integration of reality, transformed into fashion pieces that carry profound value. This handcrafted steel ring now becomes a part of the artistic narrative, a masterpiece expressing your individuality and unique sophistication. The 'Scream' ring, inspired by Edvard Munch's painting 'The Scream,' epitomizes such an accessory.</p>
47018 <p>Inspired by Claude Monet's iconic "Water Lilies" painting, this exquisite ring captures the serene beauty of the water lilies floating on a tranquil pond. The intricate design, meticulously crafted by Đỏ Art's skilled artisans, preserves the essence of Monet's masterpiece within a petite form, making it a stunning addition to your accessory collection.</p>
47019 <p>The yellow "Water Lilies" metal ring is capable of catching your attention thanks to the color contrast between the yellow color of the metal and the blue color of the hand-painted pond. On that quiet lake surface are dotted with white water lilies - inspired by the famous painting "Water Lilies" by Claude Monet. Therefore, this ring is truly a masterpiece combination of crafting art and painting.</p>
48843 <p>"Waves," a refined metal lighter adorned with ocean wave patterns, embodies the essence of both calm and power. Crafted with artistry, the "Waves" lighter captures the elegance of the ocean's flow – both its peaceful moments and its surging strength. It serves as a symbol of resilience in the face of life's challenges, a constant reminder to face them with unwavering spirit.</p> <h3>Adding your personal touch to the lighter with engraved name:</h3> <p>- Write the name you want engraved on the lighter in the "Customer note to Brand" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 3-4 days</p> <p><em>Note: The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same.</em></p>
48844 <p>This lighter design draws inspiration from the powerful Horus, the falcon-headed Egyptian god. Known as a protector and symbol of health, life, and rebirth, Horus's piercing gaze guides you. Legend tells us his right eye, white like the sun, represents strength and clarity, while his left, black as the moon, embodies wisdom and intuition.</p> <p>This lighter fuses the mystical beauty of the Eye of Horus with the timeless script of ancient Egypt. More than just an igniter, it's a reminder to keep your sights set high, like Horus himself, unwavering in your pursuit of goals.</p> <h3>Adding your personal touch to the lighter with engraved name:</h3> <p>- Write the name you want engraved on the lighter in the "Customer note to Brand" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 3-4 days</p> <p><em>Note: The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same. </em></p>
48845 <p>Crafted in the image of peacock, a symbol of wisdom and refinement, this lighter embodies sophistication and authority. A thoughtful gift for those you admire, it represents more than just lighting a flame. The design depicts two figures celebrating in the sun's glow, symbolizing prosperity, success, and a flourishing career path.</p> <h3>Adding your personal touch to the lighter with engraved name:</h3> <p>- Write the name you want engraved on the lighter in the "Customer note to Brand" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 3-4 days</p> <p><em>Note: The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same.</em></p>
48847 <p>Drawing inspiration from the vibrant motifs adorning ancient bronze drums, the Bronze Drum lighter embodies hidden power. These symbolic patterns, traditionally crafted from copper and gold, are believed to bring good fortune and ward off negativity.</p> <p>With its sophisticated design in a striking red and gold combination, this lighter serves as a powerful talisman, promoting confidence and optimism along life's journey.</p> <h3>Adding your personal touch to the lighter with engraved name:</h3> <p>- Write the name you want engraved on the lighter in the "Customer note to Brand" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 3-4 days</p> <p><em>Note: The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same.</em></p>
48848 <p>Stand out from the crowd with the Green Dragon of Ly Dynasty lighter! This exquisite piece features the powerful Ly Dynasty dragon, a symbol of Vietnamese pride and strength, tempered by the gentle spirit of its people.</p> <p>The green finish evokes a sense of renewal and hope, making it a meaningful gift for those you hold in high esteem.</p> <h3>Adding your personal touch to the lighter with engraved name:</h3> <p>- Write the name you want engraved on the lighter in the "Customer note to Brand" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 3-4 days</p> <p><em>Note: The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same. </em></p>
48849 <p>These hand-painted leather lighters are more than just lighters - they're works of art! Even non-smokers will appreciate their beauty and collectability. These lighters, especially those featuring the powerful Ly Dynasty dragon, Ly Long, become conversation pieces steeped in Vietnamese culture. The dragon's black coloring adds an air of mystery and wisdom. For a unique and impressive handmade gift, look no further.</p> <h3>Adding your personal touch to the lighter with engraved name:</h3> <p>- Write the name you want engraved on the lighter in the "Customer note to Brand" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 3-4 days</p> <p><em>Note: The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same. </em></p>
48850 <p>Known for their raw power, tigers embody immense strength. Imagine them with wings - a symbol of untapped potential unleashed. This lighter reflects that hidden power within. For those who possess quiet strength, it becomes a reminder that with motivation, they can soar, conquering any obstacle on their path to success.</p> <p>The black and gold tiger design, a masterpiece of handcrafted detail, is sure to turn heads - a perfect accessory for those who appreciate sophisticated artistry.</p> <h3>Adding your personal touch to the lighter with engraved name:</h3> <p>- Write the name you want engraved on the lighter in the "Customer note to Brand" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 3-4 days</p> <p><em>Note: The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same.</em></p>
48851 <p>The image of the carp overcoming rapids to become a dragon has long symbolized perseverance and ultimate success.</p> <p>This lighter captures that spirit with a powerful design: nine carp, tails raised in unison. Eight are colored red, bringing prosperity and luck, while the ninth, a distinguished black, represents the power to ward off negativity. A gift imbued with meaning, perfect for inspiring your loved ones.</p> <h3>Adding your personal touch to the lighter with engraved name:</h3> <p>- Write the name you want engraved on the lighter in the "Customer note to Brand" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 3-4 days</p> <p><em>Note: The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same. </em></p>
48852 <p>Inspired by the everyday beauty of encaustic tiles, the Brick patterned lighter tells a story. Just like each tile forms part of a larger picture, so too do we as individuals. This lighter is a reminder that your experiences, the ups and downs of life, contribute to your unique story.</p> <p>More than just a flame, this lighter becomes a symbol of your individuality and freedom. Crafted by the skilled artisans at Do, each lighter features intricate details laser-engraved and hand-painted on smooth leather, creating a sophisticated accessory that celebrates both design and craftsmanship.</p> <h3>Adding your personal touch to the lighter with engraved name:</h3> <p>- Write the name you want engraved on the lighter in the "Customer note to Brand" box. Character limit is 5-7 characters</p> <p>- Customers should note that the time it takes to place an engraved name will be about 3-4 days</p> <p><em>Note: The product is hand-drawn, so the patterns will have a slight difference in color and shape. However, the overall design will remain the same.</em></p>
49397 <p>A new artistic creation by ĐỎ, this meticulously crafted metal lighter features hand-painted golden ocean wave patterns, showcasing exquisite craftsmanship.<br /><br />Representing a delicate balance of freedom and tranquility, each flame from this masterpiece serves as a source of inspiration, encouraging confidence and the pursuit of new challenges.<br /><br />The perfect gift for strong, courageous men, this handcrafted wave lighter offers a boost of support.</p> <h3>Add a personal touch with engraved name:</h3> <p><span>- Write the desired name (5-7 characters) in the "Customer note to Brand" box.</span></p> <p>- Please allow 3-4 days for making the lighter.</p> <p><em><strong>Note:</strong><span> As a handcrafted product, each lighter will have unique variations in pattern. However, the overall design remains consistent.</span></em></p>