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, 
  cscart_product_descriptions.unit_name 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    461277, 461276, 461275, 461274, 461273, 
    461272, 461271, 461270, 461269, 461268, 
    461267, 461266, 461265, 461264, 461263, 
    461262, 461261, 461260, 461259, 461258, 
    461257, 461256, 461255, 461254, 461253, 
    461252, 461251, 461250, 461249, 461248, 
    461247, 461246, 461245, 461244, 461243, 
    461242, 461218, 461039, 461038, 461037, 
    461036, 461035, 461034, 461033, 461032, 
    461031, 461030, 461029, 461026, 461025, 
    461022, 461020, 461018, 461017, 461013, 
    461010, 461009, 461008, 460961, 460958, 
    460957, 460955, 460952, 460951, 460948, 
    460947, 460946, 460918, 460921, 460936, 
    460804, 460816, 460828, 460835, 460856, 
    460859, 460861, 460869, 460870, 460873, 
    460888, 460902, 460734, 460754, 460758, 
    460765, 460774, 460778, 460795, 460638, 
    460693, 460698, 460504, 460515, 460518, 
    460521
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00107

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.16771496,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_descriptions",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["product_id", "lang_code"],
          "loops": 1,
          "rows": 96,
          "cost": 0.16771496,
          "filtered": 100,
          "attached_condition": "cscart_product_descriptions.product_id in (461277,461276,461275,461274,461273,461272,461271,461270,461269,461268,461267,461266,461265,461264,461263,461262,461261,461260,461259,461258,461257,461256,461255,461254,461253,461252,461251,461250,461249,461248,461247,461246,461245,461244,461243,461242,461218,461039,461038,461037,461036,461035,461034,461033,461032,461031,461030,461029,461026,461025,461022,461020,461018,461017,461013,461010,461009,461008,460961,460958,460957,460955,460952,460951,460948,460947,460946,460918,460921,460936,460804,460816,460828,460835,460856,460859,460861,460869,460870,460873,460888,460902,460734,460754,460758,460765,460774,460778,460795,460638,460693,460698,460504,460515,460518,460521) and cscart_product_descriptions.lang_code = 'en'"
        }
      }
    ]
  }
}

Result

product_id short_description full_description unit_name
460504 Mini Mixer 278 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460515 Lite Drone 402 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460518 Eco Bottle 435 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460521 Mini Router 523 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460638 Lite Mixer 946 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460693 Classic Mixer 829 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460698 Ultra Sofa 723 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460734 Eco Book 989 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460754 Lite Camera 893 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460758 Eco Router 864 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460765 Max Book 585 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460774 Ultra Sneakers 226 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460778 Prime Book 382 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460795 Pro Backpack 543 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460804 Lite Headphones 265 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460816 Classic Watch 816 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460828 Max Headphones 774 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460835 Ultra Book 817 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460856 Max Chair 145 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460859 Pro Sofa 329 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460861 Pro Router 734 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460869 Smart Drone 310 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460870 Prime Drone 596 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460873 Ultra Drone 674 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460888 Pro Book 200 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460902 Eco Mixer 258 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460918 Pro Router 777 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460921 Ultra Camera 719 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460936 Smart Book 218 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
460946 <p>Upgrade your wardrobe with this classic Allen Solly Men's Cotton Polo T-Shirt, designed for comfort and style.</p>
460947 <p> iPad features a stunning Retina display, iSight® and FaceTime cameras, the all new A6X chip and ultrafast wireless. And with access to over 275,000 apps1 on the App Store, you can do more than ever. </p>
460948 <p>Experience unparalleled sound quality and ultimate comfort with our <strong>Premium Wireless Noise-Cancelling Headphones</strong>. Perfect for travel, work, or pure relaxation.</p>
460951 <p>Precise archival pens create fade resistant, waterproof, bleed free marks for drawing, artwork, journaling, and more Includes 6 black ink Pigma Micron pens in point sizes 005 (0.20mm), 01 (0.25mm), 02 (0.30mm), 03 (0.35mm), 05 (0.45mm), and 08 (0.50mm) Pigma Micron ink is pH neutral, quick drying, and approved by ACMI toxicologists; pens have AP certification seal Single pigment ink prevents color variations; pens feature durable plastic body and smooth grip for comfort Japanese quality Sakura Pigma Micron pens deliver consistent results for manga artists, graphic designers, and crafters</p>
460952 Elevate your lifestyle with the Mi Smart Watch. Monitor your health, track fitness goals, and stay connected with smart notifications, all from your wrist.
460955
460957
460958
460961 testing
461008
461009 <p>Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.</p>
461010 <p>Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.</p>
461013
461017
461018
461020 Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
461022 <p>Seamlessly integrate and synchronize your pricing data between your systems and Zoho applications with our powerful Zoho Connector for Price.</p>
461025 <p>Discover the power of ZOHO PRODUCT, designed to streamline your operations and boost productivity. This test product highlights key features and capabilities for modern businesses.</p>
461026 Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.
461029
461030
461031
461032
461033 <p>Discover the joy of music with this beautiful <strong>Agathis Rosewood Acoustic Guitar</strong>. Perfect for beginners and experienced players alike, it features a rich brown finish and a comfortable right-hand orientation for effortless playability and warm, resonant tones.</p>
461034
461035 <p>Experience ultimate comfort and stability with the Lifelong LLYM101 Yoga Mat. Crafted from durable 10mm EVA material, this grey anti-slip mat is perfect for yoga, gym workouts, and various fitness routines for both women and men.</p>
461036 <p>思い出の写真を美しく飾るための20個のLEDクリップ付きストリングライトです。温かい光が空間を彩ります。</p>
461037
461038
461039
461218
461242 <p>Embark on your musical journey or enhance your existing skills with our exquisite Acoustic Guitar, designed for both aesthetic appeal and superior sound quality.Crafted with a durable Agathis wood body, this guitar produces a warm, balanced, and resonant tone that is perfect for a wide range of musical genres, from folk to pop to country. The Agathis top contributes to its bright attack and clear projection, making every strum and pluck a delight.The smooth Rosewood fretboard offers an incredibly comfortable playing surface, allowing for easy chord changes and intricate fingerwork. Paired with a comfortable neck profile, this right-hand oriented guitar ensures a natural and ergonomic playing experience, reducing fatigue during long practice sessions.Finished in a stunning brown gloss, this acoustic guitar not only sounds great but also looks beautiful, making it a proud addition to any musician's collection. Its classic dreadnought-style body provides excellent volume and sustain.Key Features:Premium Agathis Body: Delivers warm, resonant tones with excellent projection.Smooth Rosewood Fretboard: Ensures comfortable playability and easy navigation.Right Hand Orientation: Ergonomically designed for right-handed players.Elegant Brown Finish: A classic aesthetic that stands out.Versatile Sound: Ideal for various music styles and skill levels, from practice to performance.Whether you're strumming around a campfire, practicing at home, or performing on stage, this Agathis Rosewood Acoustic Guitar is built to inspire and deliver exceptional musical experiences.</p>
461243 写真飾り用20個LEDクリップストリングライトで、お部屋を個性的に演出しましょう。この魅力的なライトは、お気に入りの写真やポストカードをクリップで挟んで吊るすことができます。温かい白色LEDの光が、飾られた写真を優しく照らし、ロマンチックで居心地の良い雰囲気を作り出します。特徴:20個のLEDクリップ: 十分な数のクリップで、たくさんの思い出を飾れます。温かい白色光: どんな空間にも合う、柔らかく心地よい光を提供します。電池式: コンセント不要で、どこにでも設置可能です(単三電池2本使用、別売)。多用途: 誕生日パーティー、結婚式、クリスマス、バレンタインデー、記念日など、あらゆるイベントの装飾に最適です。簡単な設置: 壁に掛けたり、棚に飾ったり、アイデア次第で様々な使い方ができます。大切な瞬間を光で彩り、忘れられない思い出を作りましょう。
461244 <p> Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>
461245
461246 <p>Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. </p>
461247
461248   Studio: Warner Home Video Packaging Type: PS3 Genre: Action/Adventure, Racing Synopsis: In The Lord of the Rings: War in the North, players will experience an unrivaled Co-Op based Action/RPG gameplay experience – banding together on an untold journey to defeat the Dark Lord Sauron’s forces and turn the tide in the War of the Ring.  
461249
461250 Step into sophisticated style with the Symbol Men's Solid Cotton Formal Shirt. Crafted from premium 100% cotton, this shirt ensures breathability and all-day comfort, making it perfect for long hours at the office or formal events. Its timeless plain design and solid color make it a versatile addition to any wardrobe, easily paired with trousers, chinos, or suits. Key Features: Premium Cotton Fabric: Soft, breathable, and comfortable for extended wear.Classic Regular Fit: Offers a comfortable silhouette without being too loose or too tight.Full Sleeves: Perfect for a formal look, easily cuffed for a more relaxed style.Plain Solid Design: Versatile and easy to match with various outfits and accessories.Easy Care: Machine washable for convenient maintenance.Available in Plus Sizes: Ensuring a perfect fit for every body type. Whether you're heading to a business meeting, a formal dinner, or a special occasion, this Symbol formal shirt combines elegance with practicality. Invest in a wardrobe staple that offers both quality and timeless appeal.
461251
461252
461253 Ultra Watch 922 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
461254 Ultra Watch 928 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
461255 Ultra Watch 929 — high quality, tested and ready to ship. Generated sample data for CS-Cart import.
461256 Step out in confidence and style with our exquisite Women's Summer Cut Out Crop Top. Designed to highlight your figure, this fashionable t-shirt boasts a sophisticated sweetheart neckline that beautifully frames your décolletage. The daring yet tasteful cut-out details add a touch of edgy allure, making it a must-have for your summer wardrobe.Crafted from a soft, stretchy, and breathable fabric blend, this crop top ensures maximum comfort while maintaining its sleek, tight fit. It's the perfect choice for a variety of occasions, from casual outings with friends to vibrant night events.Sweetheart Neckline: Enhances femininity and provides a flattering look.Chic Cut-Out Design: Adds a modern and trendy touch.Tight Fit: Accentuates your curves beautifully.Premium Fabric: Soft, breathable, and comfortable for all-day wear.Versatile Style: Ideal for parties, clubs, dates, or everyday fashion statements.Pair it with high-waisted jeans, skirts, or shorts for an effortlessly stylish ensemble. Available in a range of sizes to ensure the perfect fit.
461257
461258
461259 Unlock the full potential of your business by connecting your pricing systems directly with Zoho applications. The Zoho Connector for Price offers a robust solution for businesses looking to maintain accurate, up-to-date pricing information across all their platforms. Key Features: Real-time Synchronization: Ensure your pricing data is always current across Zoho CRM, Zoho Books, Zoho Inventory, and other integrated systems.Bidirectional Data Flow: Support for both pushing pricing updates to Zoho and pulling pricing information from Zoho to your external systems.Customizable Mapping: Tailor data fields to match your specific business requirements, ensuring precise data transfer.Automated Updates: Schedule automatic synchronization to eliminate manual effort and reduce errors.Error Logging & Reporting: Monitor synchronization status and quickly identify and resolve any data discrepancies.Secure & Reliable: Built with industry-standard security protocols to protect your sensitive pricing information. Benefits for Your Business: Enhanced Accuracy: Eliminate pricing discrepancies and ensure consistent pricing across all customer touchpoints.Increased Efficiency: Automate data entry and updates, freeing up valuable time for your sales and finance teams.Improved Decision Making: Access real-time pricing data for better strategic planning and competitive analysis.Streamlined Operations: Create a cohesive ecosystem where pricing changes are reflected instantly, improving order processing and invoicing.Better Customer Experience: Provide accurate quotes and pricing information, building trust and satisfaction. Whether you're managing complex product catalogs, dynamic pricing strategies, or customer-specific discounts, our Zoho Connector for Price is the essential tool to keep your business running smoothly and efficiently.
461260 Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
461261 Introduce a delightful blend of comfort and cuteness to your girl's wardrobe with our 100% Cotton Bow Co-ord Set. Crafted from premium, breathable cotton, this two-piece ensemble ensures ultimate comfort for active little ones, making it ideal for everyday wear, playdates, or special occasions. The set includes: A stylish top with a charming bow accent, adding a touch of playful elegance.Coordinating bottoms designed for a comfortable fit and ease of movement. Key Features: Premium 100% Cotton: Soft, breathable, and gentle on delicate skin.Adorable Bow Detail: A sweet and fashionable touch that stands out.Co-ord Design: Perfectly matched top and bottom for an effortlessly chic look.Comfortable Fit: Allows for unrestricted movement and all-day comfort.Versatile Wear: Great for casual outings, parties, or just relaxing at home.Age Range: Available for girls from 1 to 10 years, ensuring a perfect fit as they grow. Care Instructions: Machine wash cold with like colors.Do not bleach.Tumble dry low.Iron on low heat if needed.
461262 Introduce a delightful blend of comfort and cuteness to your girl's wardrobe with our 100% Cotton Bow Co-ord Set. Crafted from premium, breathable cotton, this two-piece ensemble ensures ultimate comfort for active little ones, making it ideal for everyday wear, playdates, or special occasions. The set includes: A stylish top with a charming bow accent, adding a touch of playful elegance.Coordinating bottoms designed for a comfortable fit and ease of movement. Key Features: Premium 100% Cotton: Soft, breathable, and gentle on delicate skin.Adorable Bow Detail: A sweet and fashionable touch that stands out.Co-ord Design: Perfectly matched top and bottom for an effortlessly chic look.Comfortable Fit: Allows for unrestricted movement and all-day comfort.Versatile Wear: Great for casual outings, parties, or just relaxing at home.Age Range: Available for girls from 1 to 10 years, ensuring a perfect fit as they grow.
461263
461264
461265
461266
461267
461268
461269 The 18-55mm Portrait Lens is the perfect choice for photographers seeking to elevate their portrait photography. With a versatile focal length range, this lens allows you to capture everything from sweeping landscapes to intimate close-ups with exceptional clarity and detail. Its lightweight design makes it easy to carry, while the advanced optical technology minimizes distortion and enhances color accuracy. Whether you're shooting in natural light or using artificial lighting, this lens performs beautifully across various conditions. Ideal for family portraits, professional headshots, and artistic photography, the 18-55mm Portrait Lens is a must-have for any photography enthusiast looking to create stunning visual narratives.
461270 Used by Cleveland Golf tour staff players worldwide
461271
461272
461273
461274
461275 <p>Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.&nbsp;</p>
461276 <div class="product-description"> <p> Make every occasion memorable with this elegant <strong>Royal Personalized Leather Gift Set for Men</strong>, designed for those who appreciate style and practicality. Crafted with a premium leather finish and customized with the recipient's name, this luxurious gift box combines sophistication with everyday utility. </p> <h3>The Set Includes:</h3> <ul> <li>Personalized Leather Wallet</li> <li>Customized Key Holder</li> <li>Premium Clutch/Organizer Wallet</li> <li>Stylish Leather Eyeglass Case</li> <li>Elegant Gift Box Packaging</li> </ul> <h3>Perfect For:</h3> <ul> <li>Birthdays</li> <li>Anniversaries</li> <li>Father's Day</li> <li>Weddings & Groomsmen Gifts</li> <li>Corporate Gifting</li> <li>Festive Celebrations</li> </ul> <h3>Key Features:</h3> <ul> <li>✔ Personalized name engraving on all accessories</li> <li>✔ Premium leather-look finish with elegant stitching</li> <li>✔ Durable and practical everyday essentials</li> <li>✔ Luxury gift box presentation</li> <li>✔ Ideal gift for husbands, fathers, brothers, friends, and colleagues</li> </ul> <p> A thoughtful and stylish personalized gift set that combines luxury, utility, and a personal touch for every modern gentleman. </p> <p> <strong>Tagline:</strong> <em>"Personalized. Practical. Premium."</em> </p> </div>
461277