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 (
    11095, 11097, 11114, 11286, 11103, 11290
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00059

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.26"
    },
    "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": 6,
      "rows_produced_per_join": 6,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_descriptions`.`product_id` in (11095,11097,11114,11286,11103,11290)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "3.66",
        "eval_cost": "0.60",
        "prefix_cost": "4.26",
        "data_read_per_join": "27K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "unit_name"
      ]
    }
  }
}

Result

product_id short_description full_description unit_name
11095 <p>The De'Longhi Coffee Knock Out Box is a sturdy barista-style accessory designed to make disposing of used espresso grounds quick, clean and convenient. It features a durable stainless-steel housing with a rubber “knock” bar inside, so you can gently tap and eject spent coffee pucks from the portafilter without making a mess. The box has a non-slip base for stability on your counter and a removable inner tray for easy cleaning and disposal of grounds. Compact yet robust, it’s a practical addition to any home espresso setup — especially if you routinely pull shots and want a tidy workspace.</p>
11097 <p>The De'Longhi Coffee Knock Box is a durable and practical espresso accessory designed to make disposing of used coffee grounds clean and easy. It features a sturdy container with an integrated rubber‑covered knock bar that lets you tap your portafilter to eject spent coffee pucks quickly, while the non‑slip base keeps it stable on your countertop. The removable inner bin makes emptying and cleaning simple, and its compact design fits neatly next to your espresso machine — ideal for daily home use and keeping your coffee station tidy.</p>
11103 <p>The De'Longhi Vacuum Coffee Storage Container is a high‑capacity, battery‑operated vacuum‑sealed coffee storage container designed to help keep your coffee beans or ground coffee fresher for longer by creating an airtight environment that protects against oxidation and preserves aroma. It features a removable 1.5 L canister that’s easy to clean, a sleek silver finish that looks great on your countertop, and a simple vacuum‑seal system to lock in freshness with minimal effort — ideal for regular coffee drinkers or anyone who wants to maintain peak flavour in their coffee stash.</p>
11114 <p>The De'Longhi Hot & Cold Collection is an elegant 6‑piece glassware set designed to showcase and enhance both hot and cold beverages with style and performance. The set includes 2 cappuccino glasses, 2 cold brew glasses and 2 thermal double‑wall glasses, all made from hand‑blown borosilicate glass with excellent thermal insulation that keeps drinks hot or cold longer while preventing condensation on the outside. Comfortable to hold and dishwasher‑safe, the set comes in eco‑friendly recyclable packaging and makes a refined gift or premium addition to any coffee setup.</p>
11286 <p>The De'Longhi Eletta Explore Coffee Machine is a fully automatic bean-to-cup espresso and coffee machine designed to deliver café-style drinks at home with exceptional versatility. It boasts a 19 bar high-pressure system, built-in grinder with adjustable settings, and a 1.8 L water tank, letting you brew coffee from fresh beans or ground coffee. The machine offers over 50 hot, cold and cold brew coffee recipes with advanced technologies like LatteCrema Hot & Cool for dense milk foam and Cold Extraction to make refreshing cold brew in minutes, all controlled through a 3.5″ colour TFT touch display and Wi-Fi app connectivity. With automatic cleaning programs, height-adjustable spout and milk system, it combines intuitive operation, broad beverage selection and premium performance in a sleek countertop design.</p>
11290 <p>The De'Longhi Eletta Cappuccino Top Coffee Maker is a premium fully-automatic bean-to-cup coffee and espresso machine that combines Italian design with versatile café-style performance. It features a 15 bar pump and integrated grinder with 13 adjustable settings to tailor your grind, plus a removable 2 L water tank and 0.6 L milk container for creamy milk-based drinks using the LatteCrema Hot system — all controllable through an intuitive metal touch panel with a 2-line display. You can brew espresso, long coffee, cappuccino, flat white and hot milk beverages with personalised aroma and volume, make two cups at once, use either beans or ground coffee, and enjoy automatic cleaning, descaling and programmable on/off functions for easy maintenance and everyday convenience.</p>