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 (
    38559, 384, 3917, 48179, 50444, 306, 
    34682, 25733, 1095, 6050, 3171, 3773, 
    6068, 3776, 35734, 33717, 142, 36781, 
    5778, 3771, 5507, 385, 6608, 2899, 1832, 
    37305, 6602, 2563, 3176, 1097, 3666, 
    5408
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.02856

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 (38559,384,3917,48179,50444,306,34682,25733,1095,6050,3171,3773,6068,3776,35734,33717,142,36781,5778,3771,5507,385,6608,2899,1832,37305,6602,2563,3176,1097,3666,5408) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description
142 <p>Arabica-Robusta Coffee Hana Dalat is a perfect combination of Robusta and Arabica coffee beans, bringing a unique and unforgettable taste. It's a bit of Robusta bitterness mixed with the sour stick from Arabica, with a sweet, rich fruit aroma.</p> <p>Hana Dalat's coffee beans are grown organically at an altitude of more than 1500m. Implements the sustainable process, Hana Dalat brings the best quality and environment-friendly products to the market.</p> <p>Let's get a cup of Hana Dalat coffee to feel the unique and charismatic taste of organic coffee.</p>
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>
384 <p>Miss Ede 3-in-1 cocoa powder is the perfect blend of pure cocoa, non-fat milk, and the appropriate amount of sugar. A brilliant option to recharge your energy quickly.</p> <p>Made from carefully selected cocoa pods and fermented on farms in the Central Highlands, Miss Ede's cocoa powder gives a distinctive and unforgettable flavor.</p> <p>The product is suitable for all ages and different diets due to the safe and healthy ingredients.</p>
385 <p>Miss Ede Instant Milk Chocolate with bold cocoa flavor, bitterness, and sweety creamy milk will bring you a delicious Choco Latte.</p> <p>Thanks to carefully researched and selected ingredients, Miss Ede's instant milk chocolate is not only tasty but still retains its nutritional values during the preparation process.</p> <p>If you want to enjoy a nice cup of chocolate but are too busy, this is the best choice for you.</p>
1095 <p>Walk down the street confidently and show off your simple but unique style with the Embroidered Bags from Tạp Hóa Ú.</p> <p>The sturdy Hand Embroidered Fabric Bags is made of linen and mixed with meticulously embroidered flowers or leaves, giving it a unique look.</p> <p>Moreover, the Hand Embroidered Fabric Bags from Tạp Hóa Ú are not only beautiful but also alternative to plastic bags when shopping.</p>
1097 <p>Protect yourself and show off your unique fashion sense with Masks from Tạp Hóa Ú.</p> <p>Light linen breathable fabric is perfectly suitable to make masks. It not only gives you a sleek look but also quite comfortable to wear. The Embroidered Masks of Tạp Hóa Ú are simple but meaningful gifts to give to your loved ones during this pandemic.</p>
1832 <p>The stuffed animals with many hand-woven designs by Hoa Tien Brocade are an outstanding accessory with sophisticated traditional Vietnamese art.</p> <p>Products are embroidered with the skillful, meticulous and enthusiastic technique of craftsmen. We can easily see the efforts and techniques of them through each needle.</p> <p>Materials cotton and silkworms in cotton animals are grown by hand from Hoa Tien village. The ethnic people have chosen ancient fabrics with unique and impressive colors and motifs to sew cute, ethnic floral patterns.</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>
2899 <p>The hip bag is both versatile and a fashion accessory full of personality.</p> <p>The bag has a round shape with a sturdy buckle strap, bringing a somewhat dusty beauty to the product. The recycled jeans material used from old outfits is the unique feature of the bag. After that, it will be designed and embroidered by hand with high meticulousness. Therefore, each finished product delivered to you is a single version.</p>
3171 <p>Limart - Zero Waste has made this Handwoven Recycled Plastic Handbag from recycled nylon with a helpful round bottom. Although this is not a new idea of recycling waste, Limart - Zero Waste still hopes its recycled products will inspire you to live consciously for the environment.</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>
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>
3771 <p>If you like accessories that are fashionable, unique and give off a bit naughty vibe, then the Dark Blue Drawstring Bucket Bag from Renew Jeans will be the perfect choice.</p> <p>The bag is made from recycled jeans material, with a convenient drawstring design to help you keep the items inside. In addition, the shape of the bucket bag like a small box will add a youthful vibe to the product, so you can combine it with a pretty dress or even comfy outfits. Made entirely by hand, the bag has a certain sophistication which will be a lovely gift for friends or yourself.</p>
3773 <p>Tote bags are preferred for their convenience, minimalist design and stylishness. When being made with denim from Renew Jeans, this tote bag will be even more unique and outstanding.</p> <p>With a moderate compact size, the product is suitable for you to use in many situations as well as combine with many different styles. The bag has a fancy design consisting of many different pieces of jeans fabric, connected by skillful hand-stitching techniques.</p> <p>Although made from recycled denim fabric, this tote bag is not too rough or harsh to wear. In fact, Renew Jeans has specially selected medium soft jeans for you to comfortably wear every day.</p>
3776 <p>A small bag to wear when walking on the street or on a date will be an accessory that everyone needs in their wardrobe. Let Renew Jeans help you find the perfect bag with this dark blue shoulder bag.</p> <p>The bag is designed from solid dark blue denim from recycled jeans, so it is easy to combine with many different outfits. The bag has a short shoulder strap that is suitable for you to combine with a feminine and graceful dress. However, when combined with a comfy and sporty outfit, it will portray a trendy and fashionable outlook.</p>
3917 <p>A deep sleep is crucial for a productive work day. One of the factors to have a good night sleep is the material of your sleep wear.</p> <p>100% Natural Silk Sleeping Robe - Mint from Goûttobed is made of Vietnamese natural silk that is so soft and absorbent. This product is gentle like a mother’s touch, cooing you to deep sleep. You will feel more refreshed and energized for the next day.</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>
5507 <p>Caro - Caro is the best-seller at Himalayan Kombucha thanks to its Eastern style of herbal ingredients.</p> <p>With this kombucha, you can taste the warm herbal flavor of ginger, turmeric and pepper combined together. These herbs are best known for their inflammation properties and the ability to improve health conditions. Meanwhile, carrot juice will nourish your skin and remove toxins from your body. This is an ideal choice that can satisfy your requirements in taste and health benefits.</p>
5778 <p>Succumb to pure indulgence with a box of delectable nama chocolates fromPPG Handmade Chocolate. Each box offers a symphony of five distinct flavors, crafted to tantalize your taste buds and transport you to a state of utter relaxation.</p> <p>Unwrap the first piece and savor the smooth, mildly sweet essence of the Original flavor. Next, embark on a creamy adventure with the Milky Brown, followed by the delightful infusion of Baileys in a decadent chocolate embrace. For the adventurous palate, the Bitter Dark offers an intense cocoa experience, while the Japanese Matcha introduces a unique twist with its earthy green tea notes.</p> <p>Imagine pairing these melt-in-your-mouth morsels with a steaming cup of tea. As the rich chocolate flavors dance on your tongue, let the stress of the day melt away. Each bite is an invitation to unwind, offering a welcome respite after long hours of work or study. So, close your eyes, savor the moment, and let these exquisite nama chocolates usher you into a world of pure relaxation.</p>
6050 <p>The gift box consists of accessories to take care of your body. They are made from soft natural silk to ensure that your skin and hair will only receive the best.</p> <p>The silk fabric used to make the face towel and scrunchie is woven manually by villagers in the Northern part of Vietnam. With various elegant colors, you can pick one that suits your skin tone the best. It is also a great gift to get for yourself and your friends.</p>
6068 <p>Compact mirrors are very necessary items in girls' bags, and they are now embellished with meticulous and lovely hand-embroidered patterns by Miti Flowers. On the signature linen material, your mirror will become special and unique. With its warm yellow color, this mirror will be a must-have for ladies that love vintage style.</p>
6602 <p>Serum Renew Skin Plus will help you effectively detox your skin, leaving you with a clean and bright skin after using it regularly.</p> <p>The serum is condensed from natural skin care essences such as ginseng extract, turmeric. BHA and Niacinamide are added to support deep cleansing. After that, the skin continues to be nourished to recover from the deep to make the skin smoother, calm acne inflammation and limit the formation of new acne.</p>
6608 <p>Flawless, damaged skin that becomes sensitive will become healthier thanks to the Super Speed Regenerating Serum from Mulan Neck.</p> <p>The serum effectively regenerates skin cells to help brighten, smooth, and youthful skin, as well as repair damage. It is prepared according to an improved formula containing ginseng, aloe vera, and turmeric essences, which will repel skin problems such as acne, dark spots, roughness, and aging.</p>
25733 <p>If you’re a person with a helter-skelter lifestyle but still appreciate the silence of life, this is your tea!</p> <p>The perfect combination of lemongrass, peppermint, and rosemary found in this tea will help to rejuvenate your body and produce the right amount of energy to kick off your day.</p> <p>Keeps the body awake</p> <p>Regulates blood pressure</p> <p>Helps lose weight faster</p>
33717 <p>This loose-shaped ao dai from Moriko Saigon stunts in a light yellow color and is made of soft and comfy linen. The sashiko stitches on the ao dai are the unique highlight that makes you stand out when going out or taking photos. The bright-colored ao dai goes with black linen pants, which also help elevate the overall look thanks to the sharp contrast.</p>
34682 <p>The shower gel from Natural Life not only cleanses the skin, but the components in the product also nourish it so that it is moisturized and even in tone. Moreover, essential oils mixed with peppermint, lemongrass and cajeput will help you get relaxed and comfortable in the shower and relieve stress effectively.</p>
35734 <p>The essential oils in agarwood will help the wearer avoid the wind, and the gentle fragrance will help relax and comfort. The bracelet has 108 beads representing 108 sorrows in each person's 3 lifetimes, helping the wearer to feel peaceful and avoid troubles.</p>
36781 <p>Pamper your sleep with this Silk Bed Sheet from Goûttobed. Made with Vietnamese natural silk, the bed sheet will bring you a great experience with its great softness.</p> <p>After a good night's sleep, you will have a lot more energy the next day. Therefore, Goûttobed, with their premium silk bed sheet, will help you take care of your physical and mental health so that you can sleep soundly.</p>
37305 <p>BHK Vietnam will be a paradise for women that are fond of hair accessories. Not only helps to keep your hair neat but this hair stick is also decorated with beautiful flowers. Therefore, it will be a nice touch to make your hair more elegant and pretty.</p>
38559 <p>You will fall in love at first sight with this lovely hand-crocheted bag that features a spacious compartment to hold all your essentials. With its retro charm, this bag is a perfect match for anyone who appreciates this vintage style.</p>
48179 <p>Sometimes, all it takes to feel truly good is a little pampering for your heart and soul. That's where SAOLA comes in, with their amazing combos of scented candles and essential oils made with love from the heart of Hue city!</p> <p>Each item is handmade from natural ingredients, free from chemicals so that you can rest assured to use it in family. This combo is also a meaningful gift for your family and friends.</p>
50444 <p>Veg leather is favored because it was tanned by tannin - a vegetable-based ingredient to dye leather. Thanks to the skillful handcrafted work of the artisans at Tamuha Handcraft and high-quality veg tanned leather, this simple brown leather wallet still stands out enough to strike any minimalism lover.</p>