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 (5376, 5375, 5377, 5374) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00057

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2.84"
    },
    "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": 4,
      "rows_produced_per_join": 4,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_descriptions`.`product_id` in (5376,5375,5377,5374)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "2.44",
        "eval_cost": "0.40",
        "prefix_cost": "2.84",
        "data_read_per_join": "18K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "unit_name"
      ]
    }
  }
}

Result

product_id short_description full_description unit_name
5374 <p><strong>Krups EA82FE10 Quattro</strong> is a fully automatic bean-to-cup espresso machine that grinds fresh beans and delivers drinks with minimal effort. It features a built-in grinder with adjustable grind settings, a powerful 15-bar pump for optimal extraction, and a 1.7-liter removable water tank. The machine includes a steam nozzle for milk-based coffees such as cappuccinos or lattes. Its sleek silver/black finish gives it a modern look for any kitchen. The EA82FE10 also has a bean hopper so you can store whole beans and a user-friendly interface for selecting different coffee options.</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>
5377 <p>The <b>Krups EVIDENCE ECO DESIGN - EA897B40 </b> is a fully automatic bean-to-cup espresso machine that combines sustainable design with advanced coffee-making technology. Crafted from 62% recycled plastic and recyclable up to 90%, it offers 8 one-touch drink options, including black, milk-based, and hot water for tea. The machine features a touch-sensitive interface, customizable settings, and an auto-clean system, ensuring consistent, café-quality coffee with minimal environmental impact.</p>