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 (2318, 2321, 2386, 2392) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00050

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 (2318,2321,2386,2392)) 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
2318 <p><span class="relative -mx-px my-[-0.2rem] rounded px-px py-[0.2rem] transition-colors duration-100 ease-in-out">Anker SOLIX C200 DC Portable Power Station is a compact yet powerful solution for off-grid power, boasting a robust <strong>192 Wh LiFePO₄ battery</strong> and <strong>200 W output</strong> to run multiple devices simultaneously. Featuring versatile ports—including a <strong>140 W bidirectional USB‑C</strong> for both fast charging your devices and rapidly refilling the station—it achieves 80% charge in only ~1.3 hours. With additional USB‑C, USB‑A, and a car socket, plus support for 100 W solar input, it’s versatile for camping, road trips, or emergency backup. At roughly <strong>4.2 lb</strong>, it’s small enough to carry yet rugged and durable, with 3000-cycle battery life, app-based monitoring, and a 3-year warranty—making it a reliable and portable powerhouse.</span><span class="ms-1 inline-flex max-w-full items-center relative top-[-0.094rem] animate-[show_150ms_ease-in]"><br /></span></p>
2321 <p>The Anker SOLIX C300 Portable Power Station (600 W | 288 Wh, Dark Gray) packs power and versatility into a compact, vertical design. With a robust 288 Wh LiFePO₄ battery and 300 W continuous (600 W surge) output, it offers unmatched performance for off-grid adventures, remote work, or emergency backup. Featuring three USB-C ports (two 140 W bi-directional), pure-sine AC outlets, USB-A, and a 120 W car socket, it can handle everything from laptops and drones to mini-fridges and power tools. The unit supports rapid recharge via dual 140 W USB-C (up to 280 W), AC input, solar panels, or car charging, refilling 80% in approximately an hour. A smart display shows realtime power stats, and the integrated LED light adds usability at night. Built rugged yet portable with an optional strap and offering a long-lasting 3,000-cycle battery plus a multi-year warranty, the C300 is a powerhouse that’s designed for life on the move. </p>
2386 <p>The <strong>Anker Nano Power Bank 20K (30 W)</strong> is a sleek, travel ready charger that packs serious power. With its massive 20,000 mAh battery, it can deliver up to <strong>30 W Power Delivery</strong> through both its built in USB‑C cable and separate USB‑C port perfect for fast charging smartphones, tablets, and even emergency laptop top-ups. A USB‑A port adds versatility for other devices, while the built-in USB‑C cable eliminates the need to carry extra cords. An intuitive digital LED display shows remaining battery at a glance. Designed for portability and safety, it supports bi directional fast charging and is safe for air travel. Whether you're on the move or just out for the day, this power bank ensures you're never without enough power.</p>
2392 <p>The <strong>Anker 20K mAh Power Bank (87 W) with Built In USB‑C Cable</strong> is a professional grade portable charger designed for fast, efficient charging on the go. Its built‑in USB‑C cable delivers <strong>up to 65 W Power Delivery</strong>, capable of rapidly charging laptops like a 14" MacBook Pro to 50% in under 40 minutes, while the onboard USB‑C port and USB‑A PowerIQ port share a combined <strong>87 W total output </strong>enough to charge three devices simultaneously. The high-capacity 20,000 mAh battery 74 Wh ensures multiple full charges for smartphones or significant runtime for tablets, and supports air travel. With speedy <strong>1.5 hour recharging via 65 W PD</strong>, a clear digital LED level indicator, and built-in cable for on the go convenience, this sleek black power bank is a portable powerhouse built to meet the demands of professionals and travelers alike.</p>