Sandbox

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 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    3077, 3075, 3064, 3061, 3022, 2970, 2929, 
    2881, 2786
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00022

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.06"
    },
    "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": 9,
      "rows_produced_per_join": 9,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "3.17",
        "eval_cost": "0.90",
        "prefix_cost": "4.07",
        "data_read_per_join": "34K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`shoptheindependents_com`.`cscart_product_descriptions`.`product_id` in (3077,3075,3064,3061,3022,2970,2929,2881,2786)) and (`shoptheindependents_com`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id	short_description	full_description
2786		<p>These fuzzy slides are crafted in collaboration with esteemed AD100 designer, Jake Arnold. Part slipper, part shoe – they’re as chic at your bedside as they are stepping out of the house. Made from shearling wool in a rich olive hue for cozy toes and effortless style.</p>
2881		<p>With two slouchy front pockets, a snug waist tie and cozy shawl collar, this super plush bathrobe is the ultimate relaxation wear.</p>
2929		<p>Inspired by organic curves and postmodern design, this is a side table that stands out. It features a simple conical base with two slabs of white marble layered to create a round top. Leave the lower shelf bare to add dimension and highlight its unique silhouette. Fan favorite</p>
2970		<p><meta charset="utf-8"><span>Soft suede leather houses a spacious main compartment, sealed with a solid colored zipper in a fresh, contrasting tone. Mini Woven Bag houses one inner pocket and a bottom pouch for your travel card, allowing you to swipe easily without rummaging in line to take it out. Designed to carry mini wallet, large phone, and your daily essentials. Easily carried with two handles toted on your arm or worn with a removable strap across your body.</span></p>
3022		<p>Elevate your wardrobe with this timeless, structured coat that combines elegance and comfort. Designed with a sleek silhouette, it features a classic button-front closure and clean lines, making it versatile enough for both casual and formal occasions. Crafted with premium materials, this coat provides warmth without sacrificing style. The subtle detailing and tailored fit ensure a sophisticated look that will seamlessly complement your seasonal wardrobe staples.</p>
3061		<p><meta charset="UTF-8"><span>An open and inviting piece inspired by slow, intentional movement. Each curve reflects its own unique angle—and yours.</span></p>
3064		<p><meta charset="UTF-8"><span>An open and inviting piece inspired by slow, intentional movement. Each curve reflects its own unique angle—and yours.</span></p>
3075		<p><meta charset="utf-8"><span>Our experimentation with texture continues. Elevated sense of design and craftsmanship manifests in our Italian-made Louise sandals. They have a square-toed silhouette with a wide band formed with leather pleats and extra comfortable leather-wrapped fussbett for day-long wear.</span></p>
3077		<p>Our experimentation with texture continues. Elevated sense of design and craftsmanship manifests in our Italian-made Louise sandals. They have a square-toed silhouette with a wide band formed with leather pleats and extra comfortable leather-wrapped fussbett for day-long wear.</p>