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 (7652, 7653, 7654, 7651) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00081

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 (7652,7653,7654,7651)) 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
7651 <p><strong>Oscar de la Renta Bella Tropicale EDP</strong> is a vibrant and sun-drenched fragrance that evokes the carefree essence of a tropical paradise. It opens with a splash of juicy pineapple agua fresca and a radiant citrine accord, immediately transporting you to lush, exotic surroundings. At the heart, tropical ylang-ylang blossoms mingle with coconut water, orange blossom and warm solar accords, creating a bright floral-fruity core with a soothing, beach-washed twist. The base brings in sea-mist musk, tonka bean and sandalwood which wrap the scent in a soft, sensual warmth—like the lingering memory of sun on the skin. The result is an exuberant yet elegant fragrance, perfect for the modern woman who wants to carry the essence of holiday skies and golden light wherever she goes.</p>
7652 <p><strong>Oscar de la Renta Bella Rosa EDP</strong> is a captivating chypre-floral fragrance crafted for the feminine spirit who embraces elegance and playful romance. It opens with a vibrant burst of pink pepper, freesia and mandarin orange, creating an immediate impression of freshness and vitality. At the heart, a lush bouquet of pink rose, jasmine and orris unfolds, enveloping the senses in soft floral sophistication. The base reveals warm woods and resinous depth—patchouli, sandalwood and amber—that anchor the scent with a subtle sensuality and timeless refinement</p>
7653 <p><strong>Oscar de la Renta Bella Blanca EDP</strong> is a luminous white-floral fragrance capturing pure elegance and modern femininity. It opens with fresh, sparkling top notes of freesia, green pear, cassis and mandarin. At the heart, a refined bouquet of violet leaves, jasmine sambac, white rose and dewy lily-of-the-valley unfolds. The base combines creamy sandalwood, cashmere musk, peach-skin musk and subtle ambrox to wrap the scent in a soft, velvety embrace that lingers with understated sophistication.</p>
7654 <p><strong>Oscar de la Renta Alibi EDP</strong> is a modern floral-gourmand fragrance for women that celebrates duality — fresh and vibrant at first, yet sensually warm and refined at its core. It opens with bright notes of mandarin and a juicy accord infused with ginger blossom. The heart introduces cool aquatic undertones alongside soft vanilla orchid and heliotrope, lending both elegance and airy brightness. In the base, skin-musk, praline and amberwood create a creamy, intimate trail that lingers delightfully.</p>