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 (
    45504, 2563, 48770, 3882, 3176, 3666, 
    5408, 775, 2566, 48843, 38146, 3384, 
    1755, 41446, 135, 41435, 2412, 5505, 
    16612, 31643, 313, 2321, 383, 2415, 
    6609, 144, 33306, 1120, 19567, 4020, 
    4239, 5198
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.01018

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": 32,
          "filtered": 100,
          "index_condition": "cscart_product_descriptions.product_id in (45504,2563,48770,3882,3176,3666,5408,775,2566,48843,38146,3384,1755,41446,135,41435,2412,5505,16612,31643,313,2321,383,2415,6609,144,33306,1120,19567,4020,4239,5198) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description
135 <p>Artichoke tea is famous as a healthy-tea that helps reduce cholesterol, cancer prevention, good for the liver and digestive system, etc. It is widely believed by many people every day.</p> <p>Hana Dalat's artichoke tea is produced in closed-process from harvesting high-quality artichoke flowers and stems in organic farms to processing. Therefore, this tea gets the highest active ingredients that benefit from artichokes.</p> <p>Hana Dalat's artichoke tea brings a smooth and naturally sweet flavor.</p> <p>A healthy cup of tea every day, why not?</p>
144 <p>Macadamias is one of the premium nuts, famous for their deliciousness and nutritional value. This nut is a miracle remedy for the effective treatment of several health problems, including improved digestive system, heart health, weight control, and blood sugar.</p> <p>Macadamia Nuts Hana Dalat is selected from the cultivated area without chemicals to create unique quality and taste; 100% roasted without additives. This product offers a delicate, buttery-like and greasy taste.</p>
313 <p>Granola from HAPPI OHA uses different types of seeds and dried fruits for better nutrition intake. Products have a sweet taste and make a great combination with yoghurt, smoothies, breads and seed butter.</p> <p>HAPPI OHA’s Granola line can be used in weight management and maintaining a healthy lifestyle. Products are handmade without sugar with no added flavourings or preservatives.</p> <p>Nurture your body with natural healthy products from HAPPI OHA. There’s 4 choices in this Granola line to add more flavour to your healthy meals.</p>
383 <p>There's nothing like a mug of Miss Ede hot chocolate to warm your spirits.</p> <p>Miss Ede's pure cocoa powder is made from 100% cocoa that is fermented in the local farms in the Central Highlands. With strict production and international standards, the products bring out their distinctive flavor, delicious and excellent quality.</p> <p>Moreover, the product is also suitable for vegans. Therefore, Pure Cocoa Powder From 100% Cocoa Beans In The Central Highlands will be a great choice to make a variety of your vegetarian dishes.</p>
775 <p>Accentuate a room corner with KATTIE HANDMADE’s floaty model, made in 3 different designs: flamingo, duck and unicorn.</p> <p>Products are made of Japanese clay - an eco-friendly material, light, durable and waterproof. KATTIE HANDMADE loves playing with clay since childhood and has been inspired by the beauty of such a simple thing, these products are designed as cute animal figurines.</p>
1120 <p>Stay handsome and in style with the Men Stay Simplicity Moisturizer.</p> <p>Designed to match the unique characteristics of men's skin, this moisturizer is made with ingredients of 100% natural origin, user-friendly and safe for even the sensitive skins. Men Stay Simplicity's Moisturizer helps moisturize and nourish the skin.</p> <p>Remember to moisturize at least 2 times a day to experience pleasant changes to your skin.</p>
1755 <p>Electric Heating Multi Purpose Herbal Pad is both a soft pillow for a good night's sleep and an assistant to help relieve painful areas on the body.</p> <p>The product uses the power to heat with 3 different temperatures depending on your needs, making it easy to adjust as you like. Heat and natural herbal essence inside the pillow will help the pain quickly disappear. Suitable for people who often suffer from neck pain; low back pain caused by sitting a lot or doing heavy work; Women often experience menstrual pain or back pain because of period.</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>
2412 <p>Ba Hoa IPA from Deme Brewing possesses a fun name. “Ba Hoa” in Vietnamese means “3 Flowers” that have been used in the recipe, Amarillo, Centennial and Citra. Besides, the name also means jokes in Vietnamese.</p> <p>This beer gives you a burst of flavours from caramel to tropical fruits, then ending with a bitter aftertaste. Together, the flavours create a great tasting experience. On the other hand, with a special formula from the brand, Ba Hoa IPA from Deme Brewing is supposed to taste better when drunk without ice.</p>
2415 <p>If the slightly acrid Kombucha taste is not for you , then the sweet, sour flavor and fresh scent of pink guava combined in this Pink Guava Kombucha from Sober.saigon will give you a unique experience.</p> <p>Pink guava mixed with honey and fermented tea will introduce you to a unique flavour profile that you can only find at Sober. Not only is it a great cold drink, but it also provides many beneficial probiotics, antioxidants that are good for your health, digestive system as well as your skin.</p>
2563 <p>What better choice to quench your thirst than the sweet and sour taste of hibiscus flowers mixed with a little bit of fermented tea? Kombucha Simple charming hibiscus flavor is an ideal choice to satisfy your thirst and add some health benefits.</p> <p>This is a simple flavor profile from Lady Kombucha with an addition of hand-fermented hibiscus tea. "Simple" because the product has a pure natural flavor, not mixed with flavor enhancers. This helps kombucha retain all the beneficial bacteria, and organic acids that are good for the body.</p>
2566 <p>Kombucha Superfood Turmeric is in the line of "Superfood" drinks from Lady Kombucha. These are natural flavors that contain many nutrients and minerals and are extremely good for health.</p> <p>With this kombucha flavor, you not only feel the warmth of ginger, pepper, and turmeric, but also the gentle sourness of passion fruit. A unique combination that explodes in your mouth. This is definitely the perfect choice for those who want to try a special taste, different from the usual ones.</p>
3176 <p>If you think recycling will be monotonous and not "luxurious", the products at Limart - Zero Waste will give you a different perspective. You will find unique and abundant recycled plastic bags that are convenient here. Take this Handwoven Recycled Plastic Pouch for example.</p> <p>The product has many small compartments, fit in hand designed to help store many personal items. A compact, stylish and eco-friendly product.</p>
3384 <p>Like the lotus leaf and seed - the lotus plumule is well-known with great ability for supporting health treatment. However, it contains some toxins that require a skillful method for preparing to ensure safety.</p> <p>Using the five-element theory method that applies for traditional medicine preparation - after fry-drying and cooling, the toxins and side effects in lotus plumule will be decreased. It will leave nothing but a pleasant smell.</p> <p>This tea helps to improve your well-being, relax your mind and deliver a better sleep.</p>
3666 <p>A gift for a person who’s always dreamed of living in a beautiful garden of fragrance. This set features healing scent notes such as lavender, cinnamon, or green tea that surely evoke your feelings. Plus, it contains a bunch of statement pieces to put on display.</p>
3882 <p>This Ceramic Chicken figurine flaunts a dark yellow color, which gives off a rustic, simple but still outstanding beauty.</p> <p>HCeramics uses glazed ceramic as the main material to recreate the funny image of a chicken. Not only can you use it as an ordinary jar to store stuff inside, but it can also be a unique decorative accessory. An interesting gift for those who love well-made ceramic crafts, right?</p>
4020 <p>After a long day at work, a healthy, delicious snack can really pick up your mood in no time.</p> <p>Choose Macca Chocolate from Damaca to enjoy the nutty flavor of macca and sweet chocolate. The product is packed in a cute little box that you can also give to friends and family as a gift.</p>
4239 <p>Maybe more than once that you feel sad and alone. You feel like leaving everything behind and go to a new place to find yourself.</p> <p>Half Of Mine Collection from I Have Been There are handmade cards that contain loving, soothing messages to your soul. I Have Been There hopes you can hug yourself a little tighter and be happy with yourself more.</p>
5198 <p>Accessories in green are not too hard to mix as you always thought. In fact, a simple outfit in basic colors would make a perfect match to make you look effortlessly pretty.</p> <p>This bucket bag from Bong Crochet is designed with the inspiration of a cooling matcha latte drink on a hot summer day. The product is hand-knit from acrylic yarn with high durability so that you can comfortably store personal items inside without worrying of falling off. Thanks to the unique yet simple bucket shape, you can easily mix the bag with many different styles and are suitable for many occasions.</p>
5408 <p>Tote bags are always favored, thanks to their convenience. But if you're already bored with fabric bags, why not try this recycled denim tote bag from Renew Jeans?</p> <p>Besides the unique material, the significant feature of the bag is its design, made from 3 different colored fabric pieces. Each detail of the bag was made meticulous by hand with great attention to make the bag durable for usage. The product is suitable for both everyday use and romantic dates.</p>
5505 <p>Power Petal Kombucha is the perfect balance of the mildly sour flavor of fermented tea, sweet cane sugar, mixed with the charming flavors of rose and hibiscus.</p> <p>Right from the first sip, you can easily smell a pleasant floral scent that paves the way for the true flavors coming after to gradually conquer you. Kombucha Power Petal also contains a large amount of antioxidants that help protect the body and nourish the skin.</p>
6609 <p>The mildly sweet coconut candy has a nutty, buttery taste, and can melt in your mouth</p> <p>The pack contains candies with mixed flavors for you to enjoy with the whole family. Containing no artificial flavorings nor fragrances, the treats bring a natural sweet taste that is also safe for your health. Therefore, you don’t have to worry a bit when enjoying them.</p>
16612 <p>Giong 1 Arabica blend coffee combines coffee beans from two different geographical regions. With natural processing methods and light roasting, Giong 1 coffee is fit for those who like a light, fresh taste. When enjoying it, you will feel a light, herbal flavor with a hint of cantaloupe. That rustic flavor will slowly envelop your taste buds, spreading in your mouth, bringing peace of mind.</p>
19567 <p>This serving contains less than 30% cocoa butter that delivers a subtly sweet flavor and a hint of bitter notes. Perfectly good for those who are health conscious or in need of coffee alternatives.</p>
31643 <p>With the name as an inspiring greeting, Morning Lover pure multi-flowered honey from Bonie Bee contains wonderful layers of sweetness to start your day full of excitement. The honey is only extracted when the honeycomb cells are 100% capped. Therefore, besides its sweet, slightly floral flavor, this honey retains nutrients, all of which bring you to their best state.</p>
33306 <p>Moc Truly Hue's pressed cake has a mildly spicy, salty taste, which makes it a delicious snack to enjoy as well as an appropriate choice to introduce Vietnamese cuisine to friends and family.</p> <p>The cake is made from sweet, freshly-caught lagoon shrimp, lean meat, tapioca starch, and eggs. Under the skilled hands of the makers, those ingredients have fused into a cake fully packed with love, care, and the quintessence of Vietnam.</p>
38146 <p>The premium weaving technique has brought value and quality to the products of Pieu Brocade. The thin and lightweight scarf in warm tones, combined with artistic patterns, will become a wonderful fashion accessory for those who love ethnic culture.</p>
41435 <p><span style="font-weight:400;">The Romelo Black Leather Bag is a luxurious and stylish accessory that is perfect for any occasion. Made from genuine leather, this bag is both durable and elegant. The unique crocodile skin pattern adds a touch of personality and sophistication. The sleek design is versatile and can be dressed up or down.</span></p> <p><span style="font-weight:400;">Whether you're going to a formal event or running errands, the Romelo Black Leather Bag is the perfect accessory to complete your look. It's spacious enough to hold all of your essentials, but it's also compact enough to be carried comfortably. And the matching leather wallet is a convenient way to keep your cards and cash organized.</span></p> <p><span style="font-weight:400;">If you're looking for a high-quality leather bag that will last for years, the Romelo Black Leather Bag is the perfect choice. It's a versatile and stylish accessory that will make a statement wherever you go.</span></p> <p style="text-align:center;"><a href="https://chus.vn/big-news-from-chus-its-time-to-see-chus-choice/" target="_blank" rel="noreferrer noopener"><img src="https://chus.vn/images/Blog/CHUS%20CHOICE/CHUS-CHOICE-Label.png?1698726975598" alt="" width="250" height="99" /></a></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>
41446 <p>With colorful canvas painting, Nombre brings to you beautiful pictures in the Spatter In The Garden collection that are put on carefully hand-made "Tùng" bags.</p> <p>Simple and gentle pictures are hand-painted on canvas, creating a highlight for the bag. The dark brown color of the cowhide brings an old look feeling, making the leather bag more prominent, making it a stylish accessory that exudes both a vintage vibe and art. Those who are pursuing such a style should not miss this item.</p>
45504 <p>It's okay if you're not a student who's good at spatial geometry! This colorful notebook with graphic patterns on the cover is still attractive enough to capture your attention at first sight!</p> <p>The notebook is made from high-quality art paper, with a sturdy thread-stitched spine so you can comfortably write notes and draw pictures inside. The cover image with outstanding colors is also a plus point to help you always remember to bring it when going outside, to school or to work.</p> <p style="text-align:center;"><a href="https://chus.vn/big-news-from-chus-its-time-to-see-chus-choice/" target="_blank" rel="noreferrer noopener"><img src="https://chus.vn/images/Blog/CHUS%20CHOICE/CHUS-CHOICE-Label.png?1698215821510" alt="" width="250" height="99" /></a></p> <p style="text-align:center;"><span style="color:#000080;font-size:12pt;">Consistently earned 5⭐, guaranteed return, shipped on time, certified by CHUS</span></p>
48770 <p>This Aeonian car perfume will bring a luxurious and high-class vibe to your car space thanks to the premium scent notes from imported perfume. This is the kind of scent that is not intense but has the ability to wrap your intention with a deep, relaxing notes of timeless memories.</p> <p>It also works as an air purifier to eliminate unpleasant odors, which is the nightmare for those who have carsickness.</p> <p>The eye-catching, impressive green color of the perfume bottle is also a fancy touch to elevate your car space.</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>