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 (
    5346, 5387, 5309, 5386, 5370, 5369, 5371, 
    5392, 5390, 5372, 11255, 11277, 11280, 
    11222, 11102, 11112, 11120, 11311, 
    11312, 11098, 11262, 11283, 11314, 
    11285
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00079

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 (5346,5387,5309,5386,5370,5369,5371,5392,5390,5372,11255,11277,11280,11222,11102,11112,11120,11311,11312,11098,11262,11283,11314,11285)) 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
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>
5369 <p>The De'Longhi ECAM25120SB espresso machine is a fully automatic espresso machine designed for convenience and customization. It features an intuitive touch display and one-touch operation for brewing a variety of drinks, from a classic espresso to a latte macchiato. With its integrated grinder, adjustable coffee strength and temperature settings, and a hands-free automatic milk frother, it effortlessly delivers barista style results at home, making it an excellent centerpiece for any coffee enthusiast's kitchen.</p>
5370 <p>The De'Longhi ECAM13123 is a fully automatic espresso machine designed for effortless, barista quality coffee at home. It features an integrated burr grinder with adjustable settings to customize the strength of your brew and a simple, intuitive interface for one-touch operation. With its automatic milk frother, you can easily create rich cappuccinos and lattes, while its compact design ensures it fits comfortably on most countertops. Ideal for daily use, the ECAM13123 delivers consistency, convenience, and the authentic flavor of freshly ground coffee with minimal effort.</p>
5371 <p>The De'Longhi ECAM 350.50.B Dinamica is a fully automatic espresso machine that delivers barista quality coffee with exceptional convenience and customization. It features an integrated conical burr grinder with 13 adjustable settings to fine tune the strength and flavor of your brew, alongside a one touch menu for effortlessly preparing espresso, coffee, lungo, or even over ice beverages. Its advanced LatteCrema system automatically froths milk to a silky texture for perfect cappuccinos and lattes at the touch of a button, while its compact design and intuitive interface make it an ideal centerpiece for any kitchen. Combining sleek aesthetics with innovative technology, the Dinamica ensures a premium, hassle free coffee experience every day.</p>
5372 <p>The De'Longhi ECAM 350.50.B Dinamica is a fully automatic espresso machine that delivers barista quality coffee with exceptional convenience and customization. It features an integrated conical burr grinder with 13 adjustable settings to fine tune the strength and flavor of your brew, alongside a one-touch menu for effortlessly preparing espresso, coffee, lungo, or even over-ice beverages. Its advanced LatteCrema system automatically froths milk to a silky texture for perfect cappuccinos and lattes at the touch of a button, while its compact design and intuitive interface make it an ideal centerpiece for any kitchen. Combining sleek aesthetics with innovative technology, the Dinamica ensures a premium, hassle-free coffee experience every day.</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>
5390 <p>The De'Longhi Burr Coffee Grinder is a significant step up in quality from a blade grinder, designed for coffee enthusiasts who value precision and consistency. It utilizes two revolving abrasive surfaces (burrs) to crush beans into uniform particles, which is essential for achieving optimal and even extraction during brewing. This allows for precise control over the grind size, making it suitable for everything from fine espresso to coarse French press, and ultimately results in a noticeably richer, more balanced, and flavorful cup of coffee.</p>
5392 <p>The De'Longhi ECAM450.86.T  Dedica Conical Burr Grinder is a sleek, countertop appliance designed to deliver the precise and consistent grind necessary for high quality coffee. It features durable stainless steel conical burrs that crush beans rather than chop them, preserving aroma and allowing for a wide range of grind settings from fine espresso to coarse French press. With its 18 precise grind settings, integrated timer for dose control, and a compact design that matches the popular Dedica espresso machine, it is an ideal grinder for enthusiasts looking to elevate their brewing process and unlock the full flavor potential of their beans.</p>
11098 <p>The De'Longhi Filter Coffee Maker is a practical and stylish drip coffee machine designed for everyday coffee brewing. It features a high-capacity 1.25 L glass carafe that can brew up to 10 cups at once, making it great for family mornings or entertaining guests, and has a front-button control for simple one-touch operation. The dishwasher-safe carafe and filter holder make cleaning easy, and helpful features like a water level indicator, keep-warm hotplate, and auto shut-off approx. 40 minutes after brewing add convenience and safety. Finished in sleek black with stainless-steel accents, this model blends performance with understated design — ideal for daily filter coffee lovers.</p>
11102 <p>The De'Longhi Coffee Grinder is a compact and easy-to-use electric coffee grinder ideal for home use, featuring stainless-steel blades that efficiently grind your coffee beans to the desired consistency. It offers three adjustable grind settings — fine, medium and coarse — so you can tailor the grind for different brewing methods, and its **“push-to-grind” button with cup selector lets you grind just the amount you need for up to 12 cups of coffee. The transparent bean container holds up to 90 g of beans, and the unit includes a cleaning brush and built-in cable storage for added convenience in everyday brewing</p>
11112 <p>The De'Longhi Burr Coffee Grinder  is a compact electric burr coffee grinder designed for home use, offering consistent grinding from fine to coarse thanks to its flat stainless‑steel burr system with adjustable settings (up to 16 levels) so you can tailor the grind for different brewing methods. It features a 120 g transparent bean hopper, a cup selector for grinding just enough for 2–12 cups, and a removable grounds container for easy dosing and cleaning. Built with safety in mind, the grinder includes a dual auto‑stop system that halts operation if the hopper or grounds container is removed, plus non‑slip feet and integrated cord storage for tidy countertop use — all in a sleek black finish that fits any kitchen.</p>
11120 <p><strong>The De'Longhi MiniMe Coffee Maker is a compact capsule‑based coffee machine designed to brew a wide variety of drinks quickly and easily using NESCAFÉ Dolce Gusto capsules. It operates with a 15 bar high‑pressure pump for rich flavour and crema, has a removable 0.8 L water tank, and a simple flow‑stop lever that lets you select your drink size and choose between hot or cold beverages. The unit features automatic standby/energy‑saving shut‑off, a removable drip tray for different cup sizes, and a sleek, countertop‑friendly design — perfect for everyday home use with minimal fuss.</strong></p>
11222 <p>The De'Longhi Nescafe Dolce Gusto Infinissima Touch is a compact, pod-based coffee machine that lets you easily brew a wide range of hot and cold drinks right at home using NESCAFÉ Dolce Gusto capsules. It features an intuitive touch-sensitive control panel so you can customize drink volume with a simple tap, plus a generous 1.2 L removable water tank that reduces refills and an adjustable drip tray to fit everything from espresso cups to tall glasses. With up to 15 bar pressure, it delivers rich, aromatic coffee with velvety crema, and supports both hot and cold beverage options including espresso, cappuccino, latte macchiato and more, all with automatic flow stop and energy-saving auto shut-off for everyday convenience.</p>
11255 <p>The De'Longhi Dedica Arte Coffee Machine is a compact manual espresso machine that brings barista-style coffee making into your kitchen with professional-level performance in a slim, stylish design. At only about 15 cm wide, it fits easily on crowded countertops while offering a 15 bar pressure pump and Thermoblock heating system for rich espresso with a thick, aromatic crema. It includes two filter baskets (for single and double shots), is compatible with both ground coffee and E.S.E. pods, and comes with a My LatteArt steam wand that lets you texture milk for cappuccinos and lattes, plus an adjustable drip tray for taller cups. Finished in sleek metal with intuitive controls and rapid heat-up, Dedica Arte delivers café-quality espresso and milk-based drinks at home with style and simplicity.</p>
11262 <p>The De'Longhi BCO Series Coffee Maker is a versatile dual-function coffee machine that combines a 15-bar pump espresso maker with a manual steam milk frother and a 10-cup drip coffee brewer in one unit, giving you both café-style espresso and larger batches of filter coffee from a single appliance. It features a 1.25 L water reservoir, front-loading fill system for easy access, keep-warm plate for the carafe, and anti-drip and auto shut-off functions for convenience and safety. Compatible with ground coffee and E.S.E. pods, and finished in a sleek silver/black design, the BCO 431.S brings everyday flexibility and performance to your kitchen.</p>
11277 <p>The <b>De'Longhi </b>Dedica Duo Espresso Machine with Cold Brew is a compact, versatile coffee maker that brings café‑style hot espresso, double espresso and cold brew drinks into your kitchen with ease. It features a 15‑bar professional pump for rich espresso extraction, an advanced thermoblock heating system that heats up quickly, and De’Longhi’s Cold Extraction Technology to brew refreshing cold brew in about five minutes — all accessible via an intuitive digital touch display with full‑colour icons. The machine also includes a commercial‑style steam wand for creamy milk froth, and comes with a professional barista kit (portafilter, tamper, measuring scoop and multiple filter baskets), while its slim Italian design fits easily on narrow countertops and accommodates various cup sizes with an adjustable drip tray.</p>
11280 <p>The De'Longhi Rivelia Coffee Machine is a premium fully automatic bean‑to‑cup coffee machine designed to deliver café‑quality coffee easily at home. It features dual bean hoppers with Bean Switch Technology, letting you load and swap two different coffee beans (e.g., regular and decaf) without emptying the grinder. With an intuitive full‑colour touch display and guided visual prompts, you can quickly select and customize a range of drinks — from espresso and lungo to cappuccino and flat white — with personalized strength, temperature and cup size. The machine also includes auto‑frothing with LatteCrema Hot technology for rich, creamy milk foam, Bean Adapt Technology that adjusts grind and extraction for optimal flavour, and automatic cleaning cycles for convenience. Sleek, compact and user‑friendly, the Rivelia delivers exceptional flavour and barista‑style performance with minimal effort.</p>
11283 <p>The De'Longhi La Specialista Touch is a premium all‑in‑one espresso machine that blends built‑in grinder (15 settings), 15 bar professional pump, and touchscreen controls for café‑quality drinks at home. It uses Cold Extraction Technology for quick cold brew and offers 10 preset beverages—from espresso to latte macchiato—with an Auto LatteArt steam wand that creates rich, creamy foam with adjustable milk texture. With Bean Adapt Technology for optimal grind and extraction, a removable 1.7 L water tank, and included accessories (milk jug, tamper and filter baskets), it delivers versatile, professional‑level coffee in a stylish, user‑friendly design.</p>
11285 <p>The De'Longhi PrimaDonna Soul Coffee Maker is a premium fully automatic bean-to-cup coffee machine that brings café-quality coffee and milk beverages into your home with intuitive touch controls and advanced customization. It features Bean Adapt Technology that automatically adjusts grind size and brewing parameters for your chosen coffee beans, a 4.3″ full-touch TFT colour display for easy navigation, and the LatteCrema System for rich, creamy milk foam on lattes, cappuccinos and more. With up to 21 one-touch drink recipes — including espresso, Americano, flat white, cortado, cold brew and tea — plus Wi-Fi app control via Coffee Link, dual cup dispensing, a 500 g bean hopper, 2.2 L water tank, and automatic cleaning features, it’s designed for versatility, personalization and everyday convenience.</p>
11311 <p>The De'Longhi Magnifica Start is a fully automatic bean-to-cup espresso machine from De’Longhi’s Magnifica Start line that brings freshly brewed coffee from beans or ground coffee into your kitchen with ease. It features a built-in conical grinder with 13 grind settings, a 1.8 L removable water tank, and a 15 bar pump for rich extraction and crema in every cup, plus a manual steam wand for frothing milk on cappuccinos and lattes. With simple touch-button controls and adjustable settings for coffee strength, temperature and drink size, it delivers classic espresso, long coffee and other beverages with everyday convenience and consistent quality.</p>
11312 <p>The De'Longhi Magnifica Evo Coffee Maker is a fully automatic bean-to-cup espresso and coffee machine that makes rich, café-style drinks easily at home. It features a 15 bar professional pump, a built-in conical grinder with 13 grind settings and a 250 g bean hopper, plus a 1.8 L removable water tank for multiple cups without frequent refills. With one-touch selection of up to 7 drinks including espresso, coffee, long, cappuccino and latte macchiato, the LatteCrema Hot system delivers creamy milk foam, and the MyLatte function lets you customize milk-based drinks without waste. User-friendly controls with colour icons, adjustable strength and volume settings, automatic cleaning programs, and removable parts for easy maintenance make it a versatile and convenient choice for everyday coffee enjoyment.</p>
11314 <p>The De'Longhi Cappuccino Coffee Maker is a fully automatic bean-to-cup coffee machine that combines convenience and quality for everyday home brewing. It has a built-in conical grinder with 13 adjustable settings so you can tailor grind size for your taste, a 250 g bean hopper and a 1.8 L removable water tank for multiple drinks without frequent refills. With 15 bar pump pressure for rich extraction, it can brew espresso, coffee and cappuccino at the touch of a button, and features De’Longhi’s LatteCrema automatic milk system for creamy, long-lasting foam plus automatic milk cleaning. The intuitive text display with button controls lets you adjust coffee strength, volume and temperature, and helpful functions like automatic rinsing, descaling alerts, water filter support and energy-saving standby make it easy to maintain and use daily.</p>