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 (5670, 5957, 4818, 8812) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00062

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 (5670,5957,4818,8812)) 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
4818 <p>The Ubiquiti PoE Adapter PoE-48-24W-G (0.5A) is a <strong>Power over Ethernet injector</strong> designed to safely power Ubiquiti devices through a single Ethernet cable. Delivering 48V, 0.5A of power with a maximum output of 24W, it is ideal for access points, cameras, and other PoE-enabled devices. The adapter features built-in surge, clamping, and overcurrent protection to enhance device safety and network reliability. Its compact design makes it easy to integrate into any setup, whether for home, office, or enterprise deployments. Perfect for providing both data and power without additional cabling.</p>
5670 <p>The MikroTik Adapter 18POW is a compact, wall plug power adapter designed specifically for MikroTik networking equipment that supports passive Power over Ethernet (PoE). This adapter serves a dual purpose: it functions as the primary power source for a compatible device while also providing the ability to send power over the Ethernet cable to another device, such as a wireless access point or a security camera. With a robust output of 18 watts, it is a versatile and practical solution for simplifying installations by reducing the need for separate power outlets at the location of the powered device, making it a common accessory for building efficient and clean network setups.</p>
5957 <p>The MikroTik PoE Adapter RBGPOE is a compact, single-port Gigabit Power over Ethernet injector designed to power compatible MikroTik devices like wireless access points, routers, and cameras. It supports the 802.3af/at PoE standard, delivering up to 30W of power over a standard Ethernet cable, simplifying installation by eliminating the need for a separate power outlet at the device's location. The adapter features a Gigabit Ethernet input port for data and power from a network switch or router, and a Gigabit Ethernet output port that combines both data and power to the connected device. Its compact, plug-in design and robust build make it a reliable and convenient accessory for deploying networked equipment where power access is limited.</p>
8812 <p>The Hama 200322 network adapter allows you to connect a USB‑C device (like a laptop or tablet) to an Ethernet network using a standard RJ‑45 cable. It supports Gigabit Ethernet (10/100/1000 Mbps) for fast and stable data transfer. Designed with flexible materials, it resists cable bending and wear. The adapter is plug‑and‑play, so no driver installation is needed, and it's compatible with Thunderbolt 3 and 4. Ideal for devices that lack a built-in Ethernet port. </p>