SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (9464)

Query time 0.00028

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "table": {
      "table_name": "cscart_products",
      "access_type": "const",
      "possible_keys": [
        "PRIMARY",
        "idx_products_inventory"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "ref": [
        "const"
      ],
      "rows_examined_per_scan": 1,
      "rows_produced_per_join": 1,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "0.00",
        "eval_cost": "0.10",
        "prefix_cost": "0.00",
        "data_read_per_join": "5K"
      },
      "used_columns": [
        "product_id",
        "kl_erp_inventory_id",
        "product_code",
        "hsn_code",
        "product_type",
        "status",
        "company_id",
        "list_price",
        "amount",
        "kl_enable_qc",
        "kl_qc_amount",
        "weight",
        "length",
        "width",
        "height",
        "shipping_freight",
        "low_avail_limit",
        "timestamp",
        "updated_timestamp",
        "usergroup_ids",
        "is_edp",
        "edp_shipping",
        "unlimited_download",
        "tracking",
        "free_shipping",
        "zero_price_action",
        "is_pbp",
        "is_op",
        "is_oper",
        "is_returnable",
        "return_period",
        "avail_since",
        "out_of_stock_actions",
        "localization",
        "min_qty",
        "max_qty",
        "qty_step",
        "list_qty_count",
        "tax_ids",
        "age_verification",
        "age_limit",
        "options_type",
        "exceptions_type",
        "details_layout",
        "shipping_params",
        "facebook_obj_type",
        "parent_product_id",
        "buy_now_url",
        "is_stock_split_by_warehouses",
        "master_product_id",
        "master_product_status",
        "master_product_offers_count",
        "youtube_link",
        "show_youtube_video",
        "replace_main_image",
        "position_youtube",
        "restrict_cod",
        "seo_content"
      ]
    }
  }
}

Result

product_id kl_erp_inventory_id product_code hsn_code product_type status company_id list_price amount kl_enable_qc kl_qc_amount weight length width height shipping_freight low_avail_limit timestamp updated_timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params facebook_obj_type parent_product_id buy_now_url is_stock_split_by_warehouses master_product_id master_product_status master_product_offers_count youtube_link show_youtube_video replace_main_image position_youtube restrict_cod seo_content
9464 #30100003 34013090 P A 13 849.00 2 0 0 0.000 0 0 0 0.00 0 1649151439 1772692240 0 N N N B N R Y N N Y 10 0 N 0 5 0 0 13 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0 N 0 A 0 Y N <h2>The Face Shop Rice Water Bright Cleansing Foam: K-Beauty's Most-Loved Cleanser for Glowing Skin</h2> <p>Some skincare products earn cult status for a reason, and <b>The Face Shop Rice Water Bright Cleansing Foam</b> is one of them. With over 35 million tubes sold worldwide, the <b>Rice Water Bright Face Wash</b> has become a staple in K-beauty routines everywhere. The secret? Rice water, an ingredient that Korean women have trusted for centuries to achieve that coveted bright, glass-like complexion.</p> <p>The<a href="https://www.kindlife.in/rice-water-bright-cleansing-foam-150ml/"> Face Shop Rice Water Bright Foaming Cleanser</a> transforms your daily cleanse into a pampering ritual. A whipped cream-like texture melts onto skin, lifting away makeup, dirt, and impurities while leaving your face hydrated and luminous rather than tight and stripped.</p> <h2>Why Rice Water Works Wonders for Skin</h2> <p>Rice water isn't just a trendy ingredient. Women during Korea's Joseon Dynasty used it as their beauty secret for achieving porcelain-like skin. The milky water obtained from rinsing rice contains a powerhouse of skin-loving nutrients that modern science has validated.</p> <p><b>The Face Shop Rice Water Bright Cleansing Foam</b> harnesses these brightening properties in every wash. Rice water is naturally rich in vitamins A, B, and E, along with minerals and ceramides that nourish skin while cleansing. Instead of harsh cleansing that leaves your face feeling parched, the <b>Rice Water Bright</b> formula maintains your skin's moisture balance while gently removing everything that doesn't belong.</p> <h2>Key Ingredients That Make the Difference</h2> <p><b>Rice Water Extract (Oryza Sativa):</b> The hero ingredient. Loaded with over 100 types of antioxidants, including vitamin E and ferulic acid, plus omega fatty acids. Brightens dull complexions, evens out skin tone, and provides gentle exfoliation of dead skin cells.</p> <p><b>Rice Bran Oil:</b> Extracted from the outer layer of rice grains, rice bran oil delivers deep nourishment and helps maintain the skin's moisture barrier. Leaves skin soft without a greasy residue.</p> <p><b>Soapwort Extract (Saponaria Officinalis):</b> A natural cleansing agent that creates that luxurious foam without being harsh. Gently lifts impurities while respecting your skin's natural balance.</p> <p><b>Moringa Oil:</b> Rich in antioxidants and fatty acids, moringa oil nourishes and protects skin from environmental stressors while keeping it supple and hydrated.</p> <p><b>Glycerin:</b> A moisture-binding ingredient that prevents the tight, dry feeling after cleansing. Keeps skin comfortable and hydrated.</p> <p><b>Ceramides:</b> Essential for maintaining a healthy skin barrier. Help lock in moisture and protect against external irritants.</p> <h2>Benefits You'll Love</h2> <p><b>The Face Shop Rice Water Bright Cleansing Foam</b> delivers multiple benefits in one simple step:</p> <p><b>Effective Makeup Removal:</b> The creamy foam melts away makeup, including stubborn waterproof formulas and SPF, without requiring harsh rubbing or multiple cleansing rounds.</p> <p><b>Deep Pore Cleansing:</b> Removes 99.9% of pore-clogging impurities in one wash. Dirt, excess sebum, and pollution particles don't stand a chance.</p> <p><b>Gentle Exfoliation:</b> Natural rice extracts help slough off dead skin cells, revealing fresher, brighter skin beneath.</p> <p><b>Brightening Effects:</b> Regular use visibly evens out skin tone and adds radiance. 94 out of 100 users reported brighter, clearer complexions in just 3 washes according to brand studies.</p> <p><b>Hydration Retention:</b> Unlike foaming cleansers that leave skin feeling tight and parched, the <b>Rice Water Bright Face Wash</b> maintains moisture levels so skin feels comfortable and nourished post-cleanse.</p> <p><b>Glass Skin Goals:</b> Takes you one step closer to that coveted dewy, luminous Korean glass skin look.</p> <h2>How to Use The Face Shop Rice Water Bright Foaming Cleanser</h2> <p>Getting the most from your <b>Rice Water Bright</b> cleanser is simple:</p> <ol><li>Tie your hair back from your face to avoid getting it wet.</li><li>Wet your face with lukewarm water.</li><li>Squeeze a small amount of the foam onto your palm.</li><li>Lather between your hands until you get that signature whipped cream-like foam.</li><li>Massage gently onto your face in circular motions, covering your entire face and neck.</li><li>Rinse thoroughly with lukewarm water.</li><li>Pat dry with a soft, clean towel.</li></ol> <p><b>Pro tip:</b> The <b>Face Shop Rice Water Bright Foaming Cleanser</b> pairs beautifully with electric cleansing brushes for an even deeper clean. Use morning and evening for best results, and follow with your toner and the rest of your skincare routine.</p> <h2>Who Should Use Rice Water Bright?</h2> <p><b>The Face Shop Rice Water Bright Cleansing Foam</b> works wonderfully for:</p> <ul><li>Anyone with dull, lacklustre skin craving a brightness boost</li><li>Normal to dry skin types looking for a cleanser that won't strip moisture</li><li>Sensitive skin that reacts to harsh cleansing formulas (the vegan, dermatologist-tested formula is gentle enough for daily use)</li><li>Makeup wearers who want effective removal without double cleansing</li><li>K-beauty enthusiasts building an authentic Korean skincare routine</li><li>Those dealing with uneven skin tone or rough texture</li></ul> <h2>Why Kindlife Loves The Face Shop Rice Water Bright</h2> <p>At<a href="https://www.kindlife.in/"> Kindlife</a>, we're always excited to share products that combine traditional wisdom with modern skincare science. <b>The Face Shop Rice Water Bright Cleansing Foam</b> embodies everything we love about K-beauty: gentle yet effective formulas, ingredients rooted in centuries of beauty tradition, and results you can actually see. The<a href="https://www.kindlife.in/rice-water-bright-cleansing-foam-150ml/"> Rice Water Bright Face Wash</a> proves that great skincare doesn't have to be complicated or harsh on your skin.</p> <h2>Frequently Asked Questions</h2> <h3>Is The Face Shop Rice Water Bright Cleansing Foam suitable for sensitive skin?</h3> <p>Yes! The vegan, dermatologist-tested formula cleanses gently without causing irritation or dryness. The creamy, whipped texture is mild enough for daily use on sensitive skin types.</p> <h3>Can I use the Rice Water Bright Face Wash to remove waterproof makeup?</h3> <p>Absolutely. The foaming cleanser effectively melts away waterproof makeup and SPF while keeping skin moisturised. For very heavy makeup, you might want to use an oil cleanser first, followed by the Rice Water Bright Foaming Cleanser as your second cleanse.</p> <h3>How often should I use this cleanser?</h3> <p>Use morning and evening for optimal results. The gentle formula won't over-strip your skin even with twice-daily use.</p> <h3>Will The Face Shop Rice Water Bright Cleansing Foam help with dark spots?</h3> <p>Regular use helps brighten overall skin tone and can gradually improve the appearance of dullness and uneven pigmentation. For targeted dark spot treatment, pair with a dedicated brightening serum in your routine.</p> <h3>Is this cleanser good for oily or acne-prone skin?</h3> <p>While the formula works for all skin types, the Rice Water Bright Cleansing Foam is best suited for normal to dry skin. Oily and acne-prone skin types may prefer a gel-based cleanser, though many find this foam effective for daily cleansing without issues.</p> <h3>Does the cleanser have a strong fragrance?</h3> <p>The <b>Rice Water Bright</b> has a light, pleasant scent that most users find refreshing rather than overpowering. The fragrance doesn't linger on the skin after rinsing.</p>