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 (
    9009, 9214, 9216, 9503, 9215, 9502, 9286, 
    9287, 8997, 9154, 9155, 9242, 9284, 
    9285, 8996, 9156, 9243, 9283, 9289, 
    9288, 9290, 8995, 9244, 9282
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00105

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "17.00"
    },
    "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": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_descriptions`.`product_id` in (9009,9214,9216,9503,9215,9502,9286,9287,8997,9154,9155,9242,9284,9285,8996,9156,9243,9283,9289,9288,9290,8995,9244,9282)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "14.60",
        "eval_cost": "2.40",
        "prefix_cost": "17.00",
        "data_read_per_join": "109K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "unit_name"
      ]
    }
  }
}

Result

product_id short_description full_description unit_name
8995 <p><strong>VICTORIA'S SECRET PINK HAIR & BODY MIST VANILLA</strong> is a soft, comforting hair-and-body mist that wraps you in a gentle veil of warm vanilla with a light, airy feel. The scent is centered around a clean, simple vanilla note — cozy and slightly sweet, but not heavy or overpowering — giving off a “skin but better” vibe with a subtle, comforting warmth rather than a strong perfume-like intensity.</p>
8996 <p><strong>VICTORIA'S SECRET PINK BODY MIST WARM VANILLA</strong> is a cozy, sweet, softly glowing mist that blends creamy vanilla with a gentle touch of warm amber and a hint of soft sweetness, creating a comforting cloud that feels like slipping into a favorite sweater. The scent is light, easy to wear, and smooth on the skin — warm without being heavy, sweet without becoming sugary — making it perfect for everyday use or layering when you want a soft, warm, inviting aura around you.</p>
8997 <p><strong>VICTORIA'S SECRET PINK HAIR & BODY MIST COCONUT</strong> is a light, breezy mist that wraps your hair and body in a soft coconut-centered scent: imagine a gentle wave of creamy, slightly sweet coconut that smells clean and fresh rather than heavy — more like a soft tropical breeze than a thick perfume. The coconut aroma leans toward the milky and airy side, giving a relaxed, summery vibe. As it settles, the scent becomes more powdery and subtle: cozy, calm, and very wearable — ideal for everyday use when you want a light, beachy, “just-stepped-out-of-the-shower” freshness rather than a strong perfume statement.</p>
9009 <p><strong>Victoria’s Secret PINK Hair & Body Mist Vitamin B5 Lavender</strong> drifts in with a calming, airy glow, opening in a soft wave of fresh lavender that feels like a deep, slow breath at the edge of a quiet evening. The scent carries a clean, lightly herbal sweetness that settles gently against the skin and hair, while the touch of Vitamin B5 adds a smooth, healthy-feeling softness. As it lingers, the lavender deepens into a cozy, skin-close warmth that feels soothing and balanced — a peaceful, comforting mist that wraps you in a serene, lavender-tinted hush.</p>
9154 <p><strong>VICTORIA'S SECRET PINK Refreshing Body Wash Cucumber Extract</strong></p> <p>This body wash is a fresh, gentle cleanser designed for everyday shower use. It lathers up easily and rinses off cleanly, cleansing skin without stripping moisture. Its formula leaves skin feeling refreshed and light — clean and renewed rather than dry — with a crisp cucumber-fresh scent that evokes coolness and clarity. Dermatologist-tested and formulated to rinse out without residue, it works well for regular use if you want a simple, fresh start to your day.</p>
9155 <p><strong>VICTORIA'S SECRET PINK Nourishing Body Wash Honey</strong></p> <p>This body wash is a soft, nourishing cleanser that transforms your shower into a pampering ritual. It foams gently to cleanse skin while honey and shea butter infuse moisture — leaving your skin feeling soft, hydrated, and smooth rather than tight or dry. The scent is sweet and comforting, with a warm honey-forward aroma that lingers lightly, giving a cozy, soothing finish. Because it rinses cleanly without stripping natural oils, it’s well suited for regular use, especially if your skin tends to get dry or needs extra care.</p>
9156 <p><strong>VICTORIA'S SECRET PINK Comforting Body Wash Vanilla</strong></p> <p>This body wash offers a cuddly, comforting cleanse: it gently washes your skin while enveloping it in a warm, creamy vanilla aroma that feels soft and soothing. It leaves skin clean, conditioned and subtly scented — making showers feel relaxing and skin feeling smooth rather than dry. The vanilla scent gives a cozy, sweet-but-gentle vibe, perfect for a calming, comforting shower experience at the end of the day.</p>
9214 <p><strong>VICTORIA'S SECRET PINK BODY LOTION WARM & COZY</strong> is a soft, comforting blend that drapes the skin in a creamy, warm embrace of toasted vanilla and velvety sweet notes, creating the feeling of slipping into a freshly heated blanket on a cool night. Its plush, cloud-like texture melts in smoothly, giving long-lasting moisture that leaves the skin supple, lightly perfumed, and quietly glowing. The scent hums with a cozy sweetness that sits close to the skin, gentle yet inviting, making it an easy everyday lotion for anyone who loves a warm, cuddly, quietly addictive fragrance that lingers like a soft, glowing whisper.</p>
9215 <p><strong>VICTORIA'S SECRET PINK BODY LOTION VANILLA & DREAMY</strong> floats onto the skin with a creamy, weightless softness, blending airy vanilla, gentle sweetness, and a touch of cloud-like warmth that feels like drifting through a calm, golden haze. Its silky texture glides in smoothly, delivering lasting hydration that leaves the skin plush, lightly scented, and subtly glowing. The fragrance whispers with soft vanilla and tender sweetness — comforting, delicate, and effortlessly dreamy — creating an easy, everyday aura that lingers like a warm, velvety hush around you.</p>
9216 <p><strong>VICTORIA'S SECRET PINEAPPLE COVE FRAGRANCE LOTION</strong> glides onto the skin with a smooth, sun-kissed freshness, blending juicy pineapple brightness with soft, tropical sweetness that feels like stepping into a warm breeze by a shimmering shoreline. Its creamy texture absorbs easily, delivering lasting moisture that leaves the skin supple, lightly glowing, and wrapped in a breezy island scent. The fragrance hums with a cheerful, fruity warmth — refreshing, playful, and effortlessly summery — creating an uplifting, beach-bright aura that lingers like sunshine resting gently on the skin.</p>
9242 <p><strong>VICTORIA'S SECRET PINK REFRESHING BODY LOTION CUCUMBER</strong> glides onto the skin with a cool, airy lightness, delivering refreshing hydration that feels like a gentle splash of crisp cucumber water on a warm day. Its formula is infused with hyaluronic acid and soothing moisture boosters that leave the skin soft, balanced, and comfortably hydrated without heaviness. The scent is clean, watery, and quietly uplifting — a blend that feels fresh-from-the-shower and naturally bright — making it a perfect everyday body moisturizer that keeps the skin smooth, refreshed, and lightly scented with a cool green glow</p>
9243 <p><strong>VICTORIA'S SECRET PINK NOURISHING BODY OIL HONEY</strong> melts over the skin in a warm, silky veil, delivering deep nourishment that leaves the body glowing with a soft, healthy sheen. Its lightweight oil blend absorbs quickly, especially when applied after a shower, locking in moisture and giving the skin a smooth, supple finish without greasiness. The scent drifts in with a cozy honey warmth — sweet, soft, and gently comforting — creating an aura that feels soothing, subtly sweet, and perfect for an everyday glow that lingers beautifully on the skin.</p>
9244 <p><strong>VICTORIA'S SECRET PINK NOURISHING BODY LOTION SHEA BUTTER HONEY</strong> settles onto the skin with a creamy smoothness that delivers comforting, long-lasting hydration. Enriched with shea butter and pure honey, it nourishes deeply while keeping the texture feather-light and fast-absorbing, leaving the skin soft, balanced, and touchably supple. Its scent carries a warm, gentle sweetness — a soft honey glow wrapped in cozy warmth — creating an everyday lotion that feels soothing, subtly sweet, and effortlessly comforting from the moment it meets the skin.</p>
9282 <p><strong>VICTORIA'S SECRET PINK CONDITIONING BODY LOTION COCONUT OIL</strong> glides over the skin with a silky, sun-kissed smoothness, releasing the warm, creamy aroma of fresh coconut as it melts in. Enriched with coconut oil for deep, comforting nourishment, it softens dry areas, boosts lasting hydration, and leaves the skin looking naturally dewy and healthy. The texture feels feather-light yet indulgent, creating a softly glowing finish that lingers with a gentle tropical warmth — the kind of effortless, breezy comfort that makes everyday moisturizing feel like a small escape.</p>
9283 <p><strong>VICTORIA'S SECRET PINK BODY LOTION SUGAR SKY</strong> drapes the skin in a soft, airy veil of hydration, blending a light creamy texture with a bright, sweet scent that feels like a pastel sky just warming into daybreak. Its silky formula absorbs quickly, soothing dryness and leaving the skin supple, smooth, and lightly scented with a whisper of sugary freshness carried on a cool, breezy undertone. The result is a gentle, comforting lotion that keeps the skin moisturized while surrounding you with a delicate, uplifting sweetness that lingers with calm ease.</p>
9284 <p><strong>VICTORIA'S SECRET PINK BODY LOTION FRESH & CLEAN</strong> settles onto the skin with a refreshing, buoyant lightness, blending its silky lotion texture with a crisp, bright scent that feels like stepping into cool morning air. It absorbs quickly, easing dryness and leaving the skin soft, smooth, and comfortably hydrated, while its clean, uplifting fragrance — a mix of fresh apples and dewy clarity — lingers softly in the background. The result is a breezy, cheerful lotion that keeps the skin moisturized and wrapped in an effortlessly fresh, just-showered aroma that carries you through the day with calm, airy ease.</p>
9285 <p><strong>VICTORIA'S SECRET PINK BODY LOTION COOL & BRIGHT</strong> caresses the skin with a breezy, refreshing touch, merging its smooth, lightweight texture with a crisp, invigorating scent that feels like a cool splash at sunrise. It absorbs swiftly, easing dryness and leaving the skin soft, comfortably hydrated, and subtly radiant, while its bright, chilled fragrance — a blend of cool fruits and airy freshness — lingers gently. The result is a lively, clean-feeling lotion that keeps the skin moisturized and wrapped in a cool, energizing clarity that follows you through the day with effortless brightness.</p>
9286 <p><strong>VICTORIA'S SECRET PINK BODY LOTION APPLE DREAM</strong> glides onto the skin with a soft, velvety smoothness, carrying a bright, juicy sweetness that feels like biting into a crisp red apple under gentle sunlight. Its lightweight, creamy texture absorbs quickly, easing dryness and leaving the skin comfortably hydrated, supple, and subtly glowing. The scent drifts between fresh apple brightness and a tender, sugary warmth, creating a dreamy, uplifting aura that lingers softly. The result is a cheerful, soothing lotion that wraps the skin in long-lasting moisture and a deliciously fresh, feel-good fragrance.</p>
9287 <p><strong>VICTORIA'S SECRET BODY LOTION PLATINUM</strong> smooths over the skin with a polished, silky touch, releasing a refined, luminous scent that feels cool, modern, and quietly luxurious. Its creamy yet lightweight texture absorbs effortlessly, easing dryness and leaving the skin soft, comfortably hydrated, and subtly glowing. The fragrance carries a clean, elegant freshness with a hint of soft warmth beneath — a balanced, contemporary aura that lingers with understated sophistication. The result is a sleek, hydrating lotion that wraps the skin in lasting moisture and a smooth, radiant finish that feels effortlessly elevated.</p>
9288 <p><strong>VICTORIA'S SECRET BODY LOTION DEEP WATER</strong> flows over the skin with a cool, fluid smoothness, delivering a refreshing wave of hydration that feels like slipping beneath calm, crystal-blue water. Its lightweight, silky texture absorbs quickly, soothing dryness and leaving the skin soft, balanced, and lightly glowing. The scent carries a clean aquatic freshness with a subtle mineral clarity, softened by a gentle, airy warmth that lingers like a quiet ocean breeze. The result is a calming, invigorating lotion that keeps the skin comfortably moisturized while surrounding you with a serene, water-fresh aura throughout the day.</p>
9289 <p><strong>VICTORIA'S SECRET WANDER THE MEADOW FRAGRANCE LOTION</strong> melts into the skin with a soft, creamy smoothness, releasing a gentle, floral freshness that feels like walking through a sunlit meadow brushed with wild blossoms. Its lightweight, silky texture absorbs quickly, easing dryness and leaving the skin comfortably hydrated, supple, and lightly glowing. The scent carries a bright, airy bloom with hints of soft greenery, creating a calm, uplifting aura that lingers delicately. The result is a soothing, fragrant lotion that wraps the skin in lasting moisture and a serene, nature-kissed sweetness that feels quietly refreshing throughout the day.</p>
9290 <p><strong>VICTORIA'S SECRET SLIVER OF SUN FRAGRANCE LOTION</strong> drifts across the skin with a warm, silky glow, releasing a radiant, sunlit sweetness that feels like catching the first golden beam of morning light. Its creamy, lightweight texture absorbs effortlessly, easing dryness and leaving the skin soft, supple, and subtly luminous. The fragrance blends gentle warmth with a bright, lightly sweet aura — a soft shimmer of sunshine wrapped in a breezy, uplifting freshness that lingers with quiet comfort. The result is a smooth, fragrant lotion that envelopes the skin in lasting hydration and a warm, glowing scent that feels both cozy and bright.</p>
9502 <p><strong>VICTORIA'S SECRET PINK NOURISHING BODY SCRUB VITAMIN E HONEY</strong> caresses the skin with a soft, comforting blend of sugar exfoliants and creamy nourishment, gently polishing away dullness while melting into a smooth, hydrating texture enriched with vitamin E and golden honey; as it works across the skin, it leaves a warm, lightly sweet aroma paired with a velvety softness, creating a pampering exfoliation experience that feels cozy, soothing, and beautifully renewing.</p>
9503 <p><strong>VICTORIA'S SECRET PINK REFRESHING BODY SCRUB CUCUMBER</strong> envelops the skin in a crisp, cooling freshness as its gentle scrub particles softly polish away dullness, melting into a light, hydrating texture infused with the clean, watery brightness of cucumber; with each sweep, it leaves the skin feeling smoother, revived, and lightly refreshed, carrying a cool, green aroma that evokes pure clarity and comfort, creating an exfoliating experience that feels airy, uplifting, and naturally energizing.</p>