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

Query time 0.00042

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
3562 8809115025050 3304 P A 13 1570.00 36 0 0 35.000 0 0 0 0.00 0 1628586838 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 <h1>Klairs Vitamin C Serum: A Gentle Glow-Getter for Every Skin Typ</h1> <p>Vitamin C serums have a bit of a reputation for being too intense, especially if your skin leans sensitive. The <b>Klairs Freshly Juiced Vitamin Drop</b> flips that script entirely. With just 5% pure Vitamin C, the<a href="https://www.kindlife.in/freshly-juiced-vitamin-drop-35ml/"> Klairs Vitamin C Serum</a> delivers all the brightening, anti-aging goodness you want without the redness, stinging, or irritation that often comes with higher concentrations.</p> <p>Over 4 million bottles sold worldwide says something, right? Korean skincare brand Dear, Klairs has built a loyal following by keeping things simple and effective, and the <b>Klairs Freshly Juiced Vitamin C Serum</b> perfectly embodies that philosophy.</p> <h2>Why 5% Vitamin C Actually Makes Sense</h2> <p>Most people assume more is better when it comes to activities. Not always true. Studies show that Vitamin C concentrations between 1% and 20% are effective for skin benefits. Going too high too fast often leads to irritation, especially for sensitive or reactive skin types.</p> <p>The <b>Klairs Freshly Juiced Vitamin Drop</b> sits comfortably at 5%, making it an ideal entry point for Vitamin C beginners or anyone whose skin throws a tantrum at the slightest provocation. You still get the antioxidant protection, the brightening effects, and the collagen-boosting benefits without compromising your skin barrier.</p> <h2>Key Ingredients Worth Knowing</h2> <p><b>L-Ascorbic Acid (5%):</b> Pure Vitamin C in its most potent form. Fades dark spots, evens out skin tone, fights free radical damage from pollution and UV exposure, and supports collagen production for firmer, plumper skin.</p> <p><b>Centella Asiatica Extract:</b> A K-beauty favourite for good reason. Centella calms inflammation, speeds up healing, and strengthens the skin barrier. Perfect for balancing out the active Vitamin C.</p> <p><b>Yuzu Fruit Extract:</b> A Japanese citrus packed with natural Vitamin C and antioxidants. Boosts skin immunity while adding an extra layer of brightening power.</p> <p><b>Grapefruit & Orange Extracts:</b> Natural sources of Vitamin C that enhance the brightening effects while providing antioxidant protection.</p> <p><b>Broccoli Extract:</b> Rich in vitamins A, C, and K, along with antioxidants that protect skin cells from environmental stressors.</p> <p><b>Green Tea Extract:</b> Soothes, detoxifies, and provides anti-inflammatory benefits. Works beautifully alongside Vitamin C.</p> <p><b>Sodium Hyaluronate:</b> A hydration hero that draws moisture into skin, keeping it plump and comfortable during active treatment.</p> <h2>Benefits You Can Actually See</h2> <p>Regular use of the <b>Klairs Vitamin C Serum</b> brings noticeable changes to your skin over time:</p> <p><b>Brighter, More Radiant Complexion:</b> Dullness fades as Vitamin C works to even out skin tone and boost luminosity.</p> <p><b>Faded Dark Spots:</b> Post-acne marks, sun spots, and hyperpigmentation gradually become less visible with consistent use.</p> <p><b>Firmer, Smoother Texture:</b> Collagen production gets a boost, helping reduce the appearance of fine lines while improving overall skin texture.</p> <p><b>Antioxidant Protection:</b> Your skin gets a shield against environmental damage from pollution, blue light, and UV rays.</p> <p><b>Smaller-Looking Pores:</b> The gentle exfoliating action helps refine pore appearance over time.</p> <h2>How to Use Klairs Freshly Juiced Vitamin Drop</h2> <p>Getting the best results requires using the <b>Klairs Freshly Juiced Vitamin C Serum</b> correctly:</p> <ol><li>Cleanse your face thoroughly and pat dry.</li><li>Apply your toner and let it absorb.</li><li>Dispense 3-4 drops of the serum onto your fingertips.</li><li>Gently massage across your face and neck, patting lightly to encourage absorption.</li><li>Follow with your moisturiser and sunscreen (morning use requires SPF!).</li></ol> <p><b>Sensitive skin tip:</b> Mix one drop with your moisturiser before applying if you're new to Vitamin C or have reactive skin.</p> <p><b>Important:</b> Avoid using AHA, BHA, or other exfoliating acids in the same routine. Keep the serum stored in a cool, dark place (refrigerator works great) to prevent oxidation. A slight yellow tint after opening is normal, but if it turns brown, time to replace it.</p> <h2>Who Should Use Klairs Vitamin C?</h2> <p>The <b>Klairs Freshly Juiced Vitamin Drop</b> works beautifully for:</p> <ul><li>Sensitive skin types who've struggled with other Vitamin C serums</li><li>Anyone dealing with dullness, uneven tone, or lacklustre skin</li><li>Those with post-acne marks or mild hyperpigmentation</li><li>Skincare beginners looking to introduce Vitamin C into their routine</li><li>K-beauty enthusiasts who appreciate effective, no-fuss formulations</li></ul> <h2>Why Kindlife Loves Klairs</h2> <p>At<a href="https://www.kindlife.in/"> Kindlife</a>, we're big fans of skincare that works without being harsh. The <b>Klairs Vitamin C Serum</b> fits perfectly into our philosophy of kind choices. Vegan-friendly, hypoallergenic, and formulated with sensitive skin in mind, the<a href="https://www.kindlife.in/freshly-juiced-vitamin-drop-35ml/"> Klairs Freshly Juiced Vitamin Drop</a> proves that effective skincare doesn't have to come with a side of irritation.</p> <h2>Frequently Asked Questions</h2> <h3>Is Klairs Vitamin C suitable for sensitive skin?</h3> <p>Absolutely! The 5% concentration was specifically designed to be gentle enough for sensitive and reactive skin types. Mixing with moisturiser provides an even gentler application if needed.</p> <h3>Can I use Klairs Freshly Juiced Vitamin Drop every day?</h3> <p>Yes, daily use is fine for most skin types. Start with every other day if you're new to Vitamin C, then build up to daily application as your skin adjusts.</p> <h3>Should I use it in the morning or at night?</h3> <p>Both work. Morning application provides antioxidant protection throughout the day (always follow with sunscreen). Evening use allows the serum to work while your skin repairs overnight.</p> <h3>Can I use Klairs Vitamin C Serum with retinol or AHA/BHA?</h3> <p>Avoid using exfoliating acids or retinol in the same routine. Use them on alternate days or at different times of day to prevent irritation.</p> <h3>Why did my serum turn yellow?</h3> <p>A slight yellow tint is normal oxidation, and the product remains effective. Once it turns orange or brown, the serum has degraded and should be replaced.</p> <h3>How long before I see results?</h3> <p>Most people notice improved brightness within 2-3 weeks. Significant fading of dark spots typically takes 6-8 weeks of consistent use.</p> <p></p>