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 (
    9230, 9320, 9337, 9342, 9345, 9346, 9349, 
    9357, 9360, 9470, 9099, 9108, 9122, 
    9131, 9143, 9144, 9145, 9184, 9236, 
    9318, 9097, 9102, 9146, 9361
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00102

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 (9230,9320,9337,9342,9345,9346,9349,9357,9360,9470,9099,9108,9122,9131,9143,9144,9145,9184,9236,9318,9097,9102,9146,9361)) 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
9097 <p><strong>Bath & Body Works White Tea & Ginger Body Mist</strong> wraps the skin in a soft, tranquil freshness that feels clean and subtly warm. It opens with crisp, bright notes of white tea leaves, sparkling yuzu and fresh bergamot — like a soothing sip of tea on a sunny morning. Soon after, delicate geranium petals and a subtle whisper of ginger emerge, adding a gentle floral-spicy depth. As the scent dries down, soft musk, light woods and a warm amber-like softness settle in, leaving a calm, clean and slightly cozy trail — ideal for everyday wear or a relaxing start to the day.</p>
9099 <p><strong>Bath & Body Works Summer Melody Body Mist</strong> wraps you in a bright, joyful burst that feels like a carefree summer day under golden sunshine. It opens with sweet, juicy melon sweetness (especially honeydew melon) that floods the senses with a fresh, juicy glow; beneath that, a soft touch of bronzed vanilla adds a creamy warmth and subtle sweetness as the scent dries down — together creating a light, cheerful, summery mist that’s fresh, fruity, and gently sweet, perfect for hot weather or a sunny mood.</p>
9102 <p><strong>Bath & Body Works Sea Salt Coast Body Mist</strong> — This mist evokes the feel of a breezy seaside escape: it opens with a crisp salty-air freshness that instantly brings to mind ocean waves and coastal breezes. As it settles, a watery aquatic heart note of water lotus (or similar marine blossom) emerges, adding a cool, slightly floral-fresh aquatic nuance. In the dry down, soft sandalwood grounds the scent, giving it a calm, clean, slightly woody warmth that balances the saltiness. Overall the aroma feels airy, fresh, clean and mildly oceanic — refreshing and unisex, ideal for casual wear, especially during warm weather or on days when you want a “clean skin + sea breeze” vibe.</p>
9108 <p><strong>Bath & Body Works Poolside Cabana Body Mist</strong> — This mist brings the fresh, easygoing vibe of a sunny pool-day getaway. It opens with crisp pear that feels bright and juicy, like a cool sweet fruit just picked. Then comes a soft airy warmth — as if a gentle breeze is brushing your skin under sunlight. The dry-down wraps things up with a light solar sandalwood note, adding a subtle woody softness that keeps the scent airy, relaxed, and slightly skin-like. Overall, it smells fresh, warm, casual — ideal for summer days, vacation-style moods, or whenever you want a light, easy fragrance.</p>
9122 <p><strong>Bath & Body Works Pink Pineapple Sunrise Body Mist</strong> — This body mist smells like a tropical sunrise: juicy and sweet pineapple shines right away, giving a bright and sunny fruitiness. Behind that, a subtle note of palm sugar adds a sweet, almost candy-like softness, while the “sun-drenched nectar” note brings a warm, lightly syrupy tropical fruit vibe. Overall, it feels playful, summery, and carefree — a bright, sugary-fruity mist that evokes lounging under palm trees or sipping a pineapple drink in warm weather.</p>
9131 <p><strong>Bath & Body Works Juniper Breeze Body Mist</strong> — This mist wraps you in a fresh, crisp breeze as if you just stepped into a dewy, pine-scented forest at dawn. The top notes of juniper leaves and green apple give a sharp, invigorating freshness that feels natural and clean. As it evolves, hints of blue jasmine add a subtle floral-green softness, while fresh woods and dewy musk in the dry-down bring a calm, airy, softly woody and slightly soapy warmth. Overall, it smells clean, green, and a bit “just-out-of-shower,” making it ideal as a refreshing everyday scent with a unisex, natural-fresh vibe. </p>
9143 <p><strong>Bath & Body Works Golden Mango Lagoon Body Mist</strong> envelops you in a bright, sunlit tropical freshness where juicy golden mango takes the lead, radiating a sweet, vibrant fruitiness that feels like a warm breeze from a distant island. Beneath this lively opening, soft coral blooms add a gentle, airy floral whisper, while the hint of saltwater woods brings a clean, breezy depth that keeps the fragrance light, refreshing, and perfectly balanced. The result is a crisp, cheerful, summery mist that feels effortless on the skin — fruity without heaviness, fresh without sharpness, and ideal for warm days or anytime you want a little tropical glow.</p>
9144 <p><strong>Bath & Body Works Gingham Fresh Body Mist</strong> delivers a bright, uplifting bouquet where juicy pear and sparkling clementine open the scent with fresh, zesty energy. Soft floral notes of daisies and hints of delicate violet petals join the fruitiness, giving a clean-floral vibe that feels airy and cheerful. Underneath, a subtle clean musk (and occasionally faint powdery or “fresh linen” vibes) adds a gentle base that keeps the fragrance light and wearable. The overall impression is crisp, youthful, breezy, and perfect for everyday wear — ideal for spring or warm weather when you want a fresh, happy scent without heaviness.</p>
9145 <p><strong>Bath & Body Works Coco Paradise Body Mist</strong> delivers a warm, tropical embrace that instantly evokes a sun-drenched island getaway. At first spray, you’re greeted by creamy salted coconut monoi — rich, smooth, and slightly sweet. As it develops, delicate sugared neroli unfolds, adding a soft floral sweetness that balances the coconut’s richness. Finally, a bronzed sandalwood base grounds the scent with a warm, woody depth that keeps the mist from feeling overly sweet or cloying. The overall vibe is luxurious and beachy: cozy coconut warmth with a gentle floral touch and a calm, woody finish — perfect for summer days or whenever you want a laid-back island feel.</p>
9146 <p><strong>Bath & Body Works Chasing Fireflies Body Mist</strong> delivers a charming blend of fruity brightness and soft floral elegance that feels both playful and refined. It opens with juicy golden pear — adding a fresh, slightly sweet fruitiness — merged with airy white florals (especially jasmine blooms), which give the scent a gentle floral freshness. As it dries down, a subtle woody base emerges, lending a soft, cozy depth that balances the fruit and florals so the mist never feels too sweet or sharp. The overall vibe is delicate yet uplifting — airy, fresh, a bit dreamy, and ideal for everyday wear or when you want a light, slightly magical scent with a touch of sophistication.</p>
9184 <p><strong>Bath & Body Works Dream Bright Bubble Bath</strong> surrounds your bath in a cloud of soft, luxurious bubbles infused with the luminous Dream Bright scent. Once poured under running water, it blossoms into a rich, cushiony foam that fills the tub with a sparkling blend of berries, light florals, and warm vanilla, creating a soothing, uplifting atmosphere. As you soak, the formula helps leave your skin feeling pampered, lightly scented, and gently refreshed — turning an ordinary bath into a calm, fragrant escape.</p>
9230 <p><strong>Bath & Body Works Satin Slippers Body Cream</strong> settles onto the skin with a smooth, velvety richness, wrapping you in a soft, elegant scent that blends airy florals with a gentle musk glow. Its texture feels plush and creamy, sinking in deeply to drench dry skin with long-lasting moisture. Enriched with shea butter, cocoa butter, aloe, vitamin E, and hyaluronic acid, it restores softness, eases roughness, and leaves the skin feeling silky, cushioned, and comforted as if it slipped into its own pair of satin slippers.</p>
9236 <p><strong>Bath & Body Works Lakeside Citrus Body Cream</strong> envelopes the skin in a fresh, airy wake of crisp autumn air, zesty citrus peel, and shimmering water — evoking the clean, breezy scent of a lakeside retreat at sunrise. Its creamy, rich texture glides smoothly over skin, deeply moisturizing and leaving it soft, hydrated, and supple for hours. Infused with nourishing shea butter, cocoa butter, aloe, and hyaluronic acid, it works to soothe dryness, replenish skin’s moisture, and restore a healthy, refreshed glow while wrapping you in a bright, invigorating aura of citrus freshness and gentle aquatic lightness.</p>
9318 <p><strong>Bath & Body Works Sea Salt Coast Body Cream</strong> sweeps over the skin with cool, refreshing moisture, sinking in deeply to soften, hydrate, and restore a smooth, supple feel; enriched with shea butter, cocoa butter, vitamin E, aloe, and hyaluronic acid, it replenishes dryness and keeps the skin comfortably nourished, while its crisp blend of sea salt, airy coastal mist, and soft woods drifts gently over the senses with a clean, breezy calm.</p>
9320 <p><strong>Bath & Body Works Marble Body Cream</strong> immerses the skin in deep, velvety hydration that melts in smoothly to soften, nourish, and restore lasting comfort; enriched with shea butter, cocoa butter, aloe, vitamin E, and hyaluronic acid, it replenishes dryness and leaves the body feeling supple and refreshed, while its cool, refined scent — a blend of clean waters, aromatic geranium, and warm amber wood — settles over the senses with a fresh, polished, quietly elegant aura.</p>
9337 <p><strong>Bath & Body Works Hello Beautiful Body Lotion</strong> is a soft, hydrating lotion that smooths and moisturizes the skin while surrounding it with a bright, feminine floral scent; its lightweight texture absorbs effortlessly as notes of white gardenia, jasmine petals, and pink nectarine create a fresh, graceful aura, leaving the skin delicately scented, silky, and comfortably nourished throughout the day.</p>
9342 <p><strong>Bath & Body Works Coco Paradise Body Lotion</strong> is a silky, hydrating lotion that smooths and softens skin while surrounding it with a tropical, vacation-like scent; its creamy texture absorbs quickly as coconut and creamy vanilla mingle with hints of creamy musk to create a warm, beachy aroma, leaving skin feeling nourished, light, and subtly scented all day.</p>
9345 <p><strong>Bath & Body Works Butterfly Body Butter</strong> is a rich, ultra-creamy body moisturizer designed to deeply nourish and soften the skin; its velvety texture melts in smoothly as notes of raspberry nectar, iris petals, and vanilla blend into a sweet, airy floral scent, leaving the skin intensely hydrated, silky, and beautifully scented throughout the day.</p>
9346 <p><strong>Bath & Body Works Bonfire Bash Body Cream</strong> is a cozy, deeply moisturizing body cream that drenches skin in warmth and softness while leaving a rich, inviting scent; its blend of vanilla-bourbon, creamy sandalwood, and cashmere musk creates a smoky-sweet aroma reminiscent of a crackling campfire with toasted marshmallows, and its shea and cocoa butters boost hydration so skin feels smooth, nourished, and comfortably scented for hours.</p>
9349 <p><strong>Bath & Body Works Aromatherapy Lavender & Vanilla Body Lotion</strong> is a gentle, calming body moisturizer that deeply hydrates skin while wrapping it in a soothing scent; the soft blend of lavender and creamy vanilla—paired with notes of soft musk and warm woods—creates a relaxing, spa-like aroma, and the lightweight lotion absorbs quickly leaving skin smooth, nourished, and softly scented all day.</p>
9357 <p><strong>Bath & Body Works Aroma Mindful Pause Vetiver & Vanilla Body Cream</strong> is a rich, deeply comforting cream that envelops the skin in soothing hydration, blending the earthy calm of vetiver with the soft, creamy warmth of vanilla to create a serene, grounding aroma; its velvety texture melts in luxuriously, nourishing the skin and leaving it silky, well-moisturized, and lightly scented with a peaceful, centering calm that feels like taking a quiet moment to pause, breathe, and reset.</p>
9360 <p><strong>Bath & Body Works Among The Clouds Body Cream</strong> wraps the skin in a lush, cloud-soft veil of hydration, blending bright, uplifting notes of wild berries with a gentle, airy sweetness that feels like drifting through a sky full of soft pink clouds; its rich, creamy texture melts smoothly into the skin, delivering deep moisture that leaves it velvety, nourished, and lightly scented with a playful, glowing freshness that lingers beautifully.</p>
9361 <p><strong>Bath & Body Works All The Beach Super Soft Body Butter</strong> cushions the skin with a creamy, sun-kissed wave of rich hydration, blending warm, beachy notes with a smooth, airy freshness that feels like stepping into a soft coastal breeze; its ultra-creamy, whipped texture melts deeply into the skin, comforting dryness and leaving it velvety, nourished, and lightly scented with a radiant, seaside glow that lingers beautifully.</p>
9470 <p><strong>Bath & Body Works Bourbon Body Spray Pour Homme</strong> unfolds with a smooth, warm freshness that blends rich bourbon notes with creamy vanilla and a hint of spice, creating a confident, masculine scent that feels both modern and effortlessly classic; its lightweight mist settles cleanly on the skin and clothes without heaviness, offering an instant boost of warmth and sophistication that lingers throughout the day, making it an easy everyday signature for anyone who enjoys a bold yet refined fragrance style.</p>