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 (8071, 8077, 8076, 8073) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00067

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 (8071,8077,8076,8073)) 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
8071 <p>Angel Schlesser Les Eaux D’un Instant Absolu Deep Leather Eau de Parfum is a bold and sophisticated unisex fragrance that masterfully balances strength with sensuality. Created in 2020 by perfumer Hamid Merati-Kashani, this scent opens with the radiant freshness of bergamot, immediately drawing attention with its luminous character. The heart reveals an intense leather accord that symbolizes power, confidence, and timeless elegance. As the fragrance evolves, a warm, enveloping base of smooth vanilla emerges, softening the composition and adding depth. Deep Leather captures the olfactory image of masculinity expressed through feminine grace — a reflection of the intimate connection between horse and rider galloping freely along the shore. Both dynamic and comforting, it is a scent for those who embrace inner strength and refined passion.</p>
8073 <p>Angel Schlesser Les Eaux D’un Instant Absolu Opulent Vanilla Eau de Parfum is a captivating unisex fragrance that embodies the sensual richness and elegance of vanilla in its most luxurious form. Introduced in 2022, this exquisite composition opens with an intriguing blend of salty accord, myrrh, saffron, and a touch of zesty lime, creating a luminous and contemporary first impression. The heart unfolds with a sophisticated fusion of plum, narcissus, and coffee, adding creamy warmth and aromatic depth. Finally, the base reveals the indulgent essence of vanilla absolute intertwined with tobacco, violet, and honey — a sensual, velvety trail that lingers with comforting allure. Opulent Vanilla is a tribute to timeless sophistication, offering a perfect balance between warmth, mystery, and modern refinement for both men and women.</p>
8076 <p>Angel Schlesser Les Eaux D’un Instant Absolu Sensual Patchouli Eau de Parfum is a mesmerizing unisex fragrance that captures the deep, earthy allure of patchouli with an elegant modern twist. Launched in 2020 and crafted by perfumer Hamid Merati-Kashani, this scent opens with a burst of spicy black pepper that adds vibrancy and intrigue. The heart reveals luminous jasmine, lending floral softness and balance to the composition. Finally, the fragrance unfolds into a rich, balsamic base of patchouli enhanced with woody and musky undertones, evoking the feeling of warm earth beneath sunlit forests. Sensual Patchouli embodies a perfect harmony between mystery and sophistication — a timeless choice for those who seek a fragrance that is both grounding and irresistibly sensual.</p>
8077 <p>Angel Schlesser Les Eaux D’un Instant Absolu Sublime Rose Eau de Parfum is an elegant unisex fragrance that celebrates the timeless beauty of the rose in a modern and sophisticated interpretation. Launched in 2020, this composition opens with the refreshing and slightly woody aroma of Cypress Leaf, setting a serene and refined tone. At the heart, a delicate yet powerful Rose note blooms gracefully, enveloping the senses in floral opulence. The base of Saffron adds a warm, spicy richness, enhancing the fragrance with depth and sensuality. Inspired by the allure of oriental palaces and desert winds, Sublime Rose embodies both strength and elegance — a perfect choice for those who seek a scent that is luxurious, refined, and effortlessly captivating.</p>