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 (10410, 11001, 10984, 10989) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00063

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 (10410,11001,10984,10989)) 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
10410 <p><strong>Hausberg Electric Glass Kettle<br /></strong> is a stylish and practical kitchen appliance designed to heat water quickly and efficiently, featuring a clear, heat-resistant glass body that allows you to watch the boiling process while adding a modern touch to your countertop; equipped with a powerful heating element, it delivers rapid boiling for tea, coffee, and instant foods, and includes user-friendly controls with automatic shut-off and boil-dry protection for safe, worry-free operation, making it an excellent addition to any home or office.</p>
10984 <p><strong>Elekta Electric Kettle Glass 1.71L </strong> is a stylish and modern electric kettle designed to rapidly boil water for your everyday hot beverage and cooking needs while showcasing the beauty of your water through its transparent glass body. Built with high-quality, heat-resistant borosilicate glass and durable stainless-steel accents, it combines elegant aesthetics with robust performance. Its generous capacity makes it ideal for preparing tea, coffee, instant soups, and more for family or guests. The kettle features rapid boiling technology for quick heating, an easy-to-use on/off switch, and a 360° swivel base for convenient cordless serving. Safety features like automatic shut-off when water reaches boiling point and boil-dry protection add peace of mind with every use. The ergonomic handle provides a comfortable grip, and the removable limescale filter ensures cleaner water and easier maintenance. With its sleek glass design and reliable functionality, the <strong>Elekta Electric Kettle Glass 1.71L</strong> elevates both the look and convenience of daily hot water preparation.</p>
10989 <p><strong>Elekta 2 In 1 Tea Maker and Kettle 2L</strong> is a versatile and convenient kitchen appliance that combines the functions of a traditional electric kettle with a dedicated tea brewing system, making it perfect for tea lovers and everyday hot water needs. Designed with a generous capacity, it allows you to boil water quickly and efficiently for tea, coffee, instant drinks, and more. The integrated tea infuser or brewing chamber lets you steep loose leaves or tea bags directly, ensuring rich flavor extraction with ease. With user-friendly controls and adjustable settings for temperature and brewing time, you can tailor your tea to your preferred strength and taste. Safety features like automatic shut-off and boil-dry protection provide peace of mind, while the compact, sleek design adds a modern touch to any kitchen countertop. The <strong>Elekta 2 In 1 Tea Maker and Kettle 2L</strong> blends practicality, flexibility, and performance to elevate your daily beverage preparation.</p>
11001 <p><strong>Elekta Kettel+Toaster 1.7L</strong> is a coordinated kitchen appliance set designed to meet your basic breakfast and hot-beverage needs with both style and convenience. The <strong>electric kettle</strong> rapidly boils water for tea, coffee, and other hot drinks, featuring a durable build, easy-to-use controls, and safety features like automatic shut-off and boil-dry protection. The <strong>toaster</strong> delivers even toasting for bread, bagels, and pastries with adjustable browning settings so you can achieve your preferred crispness each time. Together, this kettle and toaster combo brings efficiency to your morning routine, combining reliable performance with a sleek design that complements any countertop. With user-friendly operation and easy-to-clean surfaces, the Elekta Kettel+Toaster 1.7L<strong></strong> set makes preparing breakfast faster, simpler, and more enjoyable.</p>