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 (
    4974, 5376, 5397, 4995, 5549, 4992, 4991, 
    5346, 6823, 5472, 5387, 5565, 5309, 
    5386, 5568, 5393, 4988, 5468, 5394, 
    5375, 5396, 4961, 7772, 5467
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00090

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "17.00"
    },
    "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": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_descriptions`.`product_id` in (4974,5376,5397,4995,5549,4992,4991,5346,6823,5472,5387,5565,5309,5386,5568,5393,4988,5468,5394,5375,5396,4961,7772,5467)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "14.60",
        "eval_cost": "2.40",
        "prefix_cost": "17.00",
        "data_read_per_join": "109K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "unit_name"
      ]
    }
  }
}

Result

product_id short_description full_description unit_name
4961 <p>The Nespresso Citiz Platinum & Milk is a sleek, compact coffee machine designed for convenience and high-quality espresso. Featuring a fast heat-up system, one-touch brewing, and an integrated milk frother, it allows you to make lattes, cappuccinos, and espresso drinks effortlessly. Its stylish platinum finish adds elegance to any kitchen while delivering consistent, rich coffee flavor every time.</p>
4974 <p>The Nespresso Pixie Machine is a compact and stylish espresso maker designed for convenience and speed. With its fast heat-up system and one-touch brewing, it allows you to prepare espresso quickly and efficiently. Despite its small size, it delivers rich, full-bodied coffee with consistent flavor. Its colorful, modern design makes it a perfect fit for any kitchen countertop.</p>
4988 <p>The Nespresso Gran Lattissima White is an advanced coffee machine designed for effortless preparation of espresso, cappuccino, and latte drinks. It features a one-touch system, integrated milk frother, and customizable cup sizes for a perfect coffee experience every time. Its sleek white design adds elegance to any kitchen while delivering rich, consistent coffee flavor.</p>
4991 <p>The Nespresso Citiz is a sleek, compact espresso machine designed for quick and convenient coffee preparation. It features a fast heat-up system and one-touch brewing, delivering rich and flavorful espresso in seconds. Its modern design adds style to any kitchen while providing consistent, high-quality coffee.</p>
4992 <p>The Nespresso Essenza Mini C30 is a compact and lightweight espresso machine designed for efficiency and convenience. It features a fast heat-up system and one-touch brewing for espresso and lungo drinks. Despite its small size, it delivers rich, aromatic coffee with consistent flavor, making it perfect for small kitchens or on-the-go coffee lovers.</p>
4995 <p>The Nespresso Essenza Mini D30 is an ultra-compact espresso machine that combines simplicity, efficiency, and style. It features a fast heat-up system and one-touch operation to prepare espresso and lungo drinks with ease. Despite its small footprint, it delivers rich, full-flavored coffee consistently, making it a perfect choice for small spaces and everyday use.</p>
5309 <p>The De'Longhi EC685 Dedica Style is a compact and stylish espresso machine designed for small kitchens and busy lifestyles. Its iconic slim line brushed stainless steel design makes it a modern countertop centerpiece. Despite its small footprint, it delivers serious performance with a 15-bar pressure pump for authentic espresso extraction, a fast thermoblock heating system, and a versatile manual frother for creating lattes and cappuccinos. Perfect for espresso purists and milk-based drink lovers alike, the Dedica offers professional features and consistent results in a uniquely space saving design.</p>
5346 <p>The DE’LONGHI MAGNIFICA S is a fully automatic espresso machine that masterfully combines convenience with the authentic quality of a traditional café experience. It features an integrated burr grinder for freshly ground beans and a simple, one touch interface for effortlessly brewing espresso, coffee, or lungo. Its advanced automatic milk frother allows for the easy creation of rich cappuccinos and lattes, while its customizable settings let you fine-tune the strength, temperature, and volume of your beverages. Designed for daily use, the Magnifica S is the ideal all in one solution for anyone seeking barista quality results with minimal effort at home.</p>
5375 <p><strong>KRUPS EA8150 Compact PISA Super Automatic Espresso Machine EA815050</strong> A fully automatic bean-to-cup espresso machine that delivers espresso, coffee, and milk-based drinks with minimal effort. It includes a built-in metal conical burr grinder, a 15-bar pump, and a thermoblock heating system for fast warm-ups and consistent temperature. The Krups EA8150 has a 1.7-liter removable water tank and about 250-260 g bean hopper capacity. It offers adjustable settings for grind coarseness (3 levels), coffee strength, temperature (3 levels), and water volume; plus favourite drink memory (“dual favourites”), an LCD display, steam nozzle for frothing, and easy-maintenance features like removable drip tray and descaling alerts.</p>
5376 <p><strong>Krups SENSATION - EA910E40</strong> A bean-to-cup automatic espresso machine from Krups designed to simplify fresh coffee at home. The Sensation EA910E40 features a metal conical burr grinder with <strong>5 grind settings</strong>, a strong <strong>15-bar pressure pump</strong>, and a <strong>1.7-litre</strong> removable water tank. It has a <strong>260 g bean hopper</strong>, a manual steam nozzle for milk frothing, and serves multiple drink types including ristretto, espresso, long coffee, filter coffee and hot water/americano, with the ability to brew in two cups simultaneously. It offers 3 temperature levels, 3 strength settings, adjustable cup sizes (50-220 ml), a favourite memory function, and automatic cleaning/rinsing and descaling programs. Stylish silver & black finish, with compact dimensions and easy maintenance.</p>
5386 <p>The De'Longhi ECAM450.76.T Eletta Explore is a premium fully automatic espresso machine that delivers barista-quality coffee with smart connectivity. It features app integration for personalized brewing, a Dual Heating System for simultaneous espresso and milk frothing, a ceramic burr grinder for precise flavor, and unique Cold Brew functionality. With its intuitive touchscreen and sleek design, it effortlessly creates customized hot and iced specialties at home.</p>
5387 <p>The De'Longhi blade coffee grinder is an affordable and compact appliance designed for basic grinding tasks. It uses a simple, high-speed rotating blade to chop coffee beans, offering a range from coarse to fine, though with less consistency than a burr grinder. Its primary function is to provide freshly ground coffee for drip machines, French presses, and cold brew makers quickly and without complication, making it a practical entry-level tool for casual coffee drinkers.</p>
5393 <p>The <strong>Philips 5400 Series EP5447</strong> is a fully automatic espresso machine with Latte Go that delivers up to 12 bean-to-cup coffee drinks, including espresso, cappuccino, latte macchiato, Americano, and flat white. It features a 100% ceramic grinder with 12 grind settings, the Aroma Extract system for optimal brewing temperature and water flow, and the Latte Go milk system that creates silky froth with just two easy-to-clean parts. The machine includes four user profiles plus a guest profile to save personalized settings, a 1.8-litre removable water tank, and a 275-gram bean hopper. Designed for convenience, it has an intuitive TFT display, adjustable coffee spout, Aqua Clean filter for reduced descaling, and a sleek chrome-and-black finish that suits any modern kitchen.</p>
5394 <p>The <strong>Philips 5500 Series EP5546</strong> is a fully automatic bean-to-cup espresso machine designed to deliver café-quality drinks at home with ease. It offers up to 20 hot and iced beverage options, including espresso, cappuccino, latte macchiato, Americano, and iced coffee. Its durable ceramic grinder has 12 grind settings and works with a 15-bar pressure pump for optimal extraction. The Latte Go milk system creates smooth, silky froth in seconds with only two easy-to-clean parts. A 1.8-litre removable water tank, 275-gram bean hopper, and Aqua Clean filter ensure convenience and minimal maintenance. With a sleek black-and-silver finish, intuitive TFT display, adjustable strength, temperature, and four user profiles, the Philips 5500 Series EP5546 combines performance and style.</p>
5396 <p>The <strong>Philips 3300 Series EP3326</strong> is a fully automatic espresso machine that uses whole coffee beans, not capsules. It features a built-in ceramic grinder and offers five one-touch coffee options: espresso, regular black coffee, espresso lungo, iced coffee, and hot water for tea. The machine is equipped with a classic milk frother for preparing milk-based beverages like cappuccinos and hot milk for hot chocolates. Additionally, it incorporates SilentBrew technology, making it 40% quieter compared to previous models</p>
5397 <p>The <strong>Philips Series 3300 Latte Go-EP3347</strong> is a fully automatic bean-to-cup espresso machine that makes 6 drinks (espresso, coffee, cappuccino, latte macchiato, iced coffee, and hot water) at the touch of a button. It features a 100% ceramic grinder with <strong>12 grind settings</strong>, a 15-bar pressure pump, and comes with a 1.8-litre removable water tank. Its LatteGo milk system produces silky milk foam using just two parts (no tubes), and can be cleaned in about 10 seconds. The bean hopper holds about <strong>275 g</strong>, and the AquaClean filter reduces the need for frequent descaling. The machine also includes SilentBrew for quieter operation, an intuitive touch display for adjusting strength, temperature, and milk froth.</p>
5467 <p><strong></strong></p> <p>The <strong>Breville Barista Max Espresso Coffee Machine</strong> is a powerful home espresso maker with a built-in bean grinder offering 30 grind settings for ultimate control over flavor. It features a 15-bar Italian pump and Temp IQ Shot Control technology to maintain stable temperature and water flow for perfect extraction. The machine includes both auto-shot volumetric control and manual shot options, giving you flexibility for your brewing style. A cool-touch steam wand allows you to create silky microfoam for cappuccinos and lattes with ease. Its large 2.8 L removable water tank and integrated 250 g bean hopper provide convenience for multiple servings. With its sleek, modern stainless-steel design, the Breville Barista Max Espresso Coffee Machine delivers café-quality coffee right at home.</p>
5468 <p>The <strong>Breville Barista Max Plus</strong> is a high-end home espresso machine combining a built-in bean grinder with precise control. It offers 30 grind settings and includes feedback for proper dosing for single or double shots. With its Temp IQ Shot Control system (including thermocoil heating, PID regulation, and pre-infusion), a 15-bar pressure pump, a 2.8 L removable water tank, and a 250 g bean hopper, it delivers café-style coffee. It has a 58 mm portafilter, volumetric control for 1 or 2 shots, a powerful steam wand for creating microfoam for lattes and cappuccinos, and an LED screen to display extraction time. Designed for serious coffee lovers, it blends performance and convenience.</p>
5472 <p>The Rhea V+ Grande Premium is a high performance, fully automatic coffee machine designed for commercial or heavy duty office use. It features a dual brewing system that allows two different beverages to be prepared simultaneously, significantly reducing wait times in high traffic environments. With a large, intuitive touchscreen interface, extensive drink customization options, and separate systems for handling fresh milk and shelf stable alternatives, it delivers barista quality coffee, espresso, and milk based drinks at the touch of a button. Its large capacity for beans, water, and waste makes it an ideal solution for workplaces or settings requiring efficiency, volume, and consistent quality.</p>
5549 <p>The Trisa Coffee Machine Espresso Perfetto is designed to deliver café-quality espresso and coffee drinks at home. With easy-to-use controls, adjustable settings, and a sleek design, it ensures rich, aromatic coffee every time. Compact and stylish, it’s perfect for coffee enthusiasts seeking professional-quality beverages.</p>
5565 <p><strong></strong>The Saeco Phedra Evo is a high performance, fully automatic super automatic espresso machine designed for premium office environments or light commercial use. It combines elegant, modern design with advanced brewing technology, featuring a high resolution color touchscreen for intuitive navigation and extensive beverage customization. Key highlights include its ceramic burr grinder for precise consistency, a powerful dual heating system for simultaneous coffee and milk preparation, and advanced milk frothing technology that allows for the creation of barista level texturing directly from a fresh milk carafe. Built for durability, ease of maintenance, and consistent quality, the Phedra Evo delivers a wide range of café style drinks with exceptional flavor and user friendly operation.</p>
5568 <p>The iPilot Golden Eagle 4S is a feature rich, fully automatic bean to cup espresso machine designed for both home and office use. It emphasizes a balance of user friendly operation and the ability to create a wide range of customizable coffee shop style beverages. Key features typically include a high precision ceramic burr grinder with adjustable settings, an automatic milk frothing system for one touch milk based drinks, and an intuitive interface, often with a display for easy selection and programming. Built with a focus on consistent quality and durability, the Golden Eagle 4S is engineered to deliver reliable performance and excellent coffee with minimal effort, making it a strong contender in the premium home appliance segment.</p>
6823 <p>The <strong>Kenwood Coffee Machine CMM05</strong> is a stylish and efficient drip coffee maker designed for modern kitchens. With a <strong>650W motor</strong> and a <strong>750ml glass carafe</strong>, it can brew up to <strong>5 cups of rich, aromatic coffee</strong>—perfect for your morning routine or sharing with family. The <strong>anti-drip system</strong> prevents spills while pouring, and the <strong>keep-warm function</strong> maintains the perfect temperature for extended freshness. Its <strong>compact and elegant design</strong> fits seamlessly on any kitchen counter, while the <strong>removable filter basket</strong> ensures easy cleaning. Reliable, convenient, and beautifully designed, the CMM05 delivers the authentic coffee taste you love with every brew.</p>
7772 <p>Brew traditional Turkish coffee with precision using the <strong>Fakir Steel Turkish Coffee Maker (Silver Stone)</strong>. Crafted with a durable <strong>stainless steel body</strong> and <strong>non-stick brewing pot</strong>, it ensures even heat distribution for rich, aromatic coffee. The coffee maker features <strong>temperature control, automatic shut-off, and safety protection</strong>, delivering consistent results with every cup. Its <strong>compact and elegant design</strong> complements modern kitchens, while the easy-to-clean pot ensures hassle-free maintenance. Ideal for coffee enthusiasts seeking convenience, durability, and authentic Turkish flavor, the Fakir Steel makes every coffee moment exceptional.</p>