SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id 
  AND cscart_seo_names.type = 'a' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  cscart_pages.page_id = 226 
  AND cscart_page_descriptions.lang_code = 'en' 
  AND (
    cscart_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, cscart_pages.usergroup_ids) 
    OR FIND_IN_SET(1, cscart_pages.usergroup_ids)
  ) 
  AND cscart_pages.page_type IN ('T', 'L', 'B', 'F', 'P', 'G')

Query time 0.00038

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.35"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_pages",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "page_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": "2K"
          },
          "used_columns": [
            "page_id",
            "company_id",
            "parent_id",
            "id_path",
            "status",
            "page_type",
            "position",
            "timestamp",
            "usergroup_ids",
            "localization",
            "new_window",
            "use_avail_period",
            "avail_from_timestamp",
            "avail_till_timestamp",
            "facebook_obj_type"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_page_descriptions",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "page_id",
            "lang_code"
          ],
          "key_length": "9",
          "ref": [
            "const",
            "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": "3K"
          },
          "used_columns": [
            "page_id",
            "lang_code",
            "page",
            "description",
            "meta_keywords",
            "meta_description",
            "page_title",
            "link"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_seo_names",
          "access_type": "ref",
          "possible_keys": [
            "PRIMARY",
            "dispatch"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "object_id",
            "type",
            "dispatch",
            "lang_code"
          ],
          "key_length": "206",
          "ref": [
            "const",
            "const",
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.25",
            "eval_cost": "0.10",
            "prefix_cost": "0.35",
            "data_read_per_join": "1K"
          },
          "used_columns": [
            "name",
            "object_id",
            "type",
            "dispatch",
            "path",
            "lang_code"
          ]
        }
      }
    ]
  }
}

Result

page_id company_id parent_id id_path status page_type position timestamp usergroup_ids localization new_window use_avail_period avail_from_timestamp avail_till_timestamp facebook_obj_type lang_code page description meta_keywords meta_description page_title link seo_name seo_path
226 0 153 153/226 A B 0 1771180200 0 0 N 0 0 en Snail Mucin for Skin: Benefits and How to Use It <p>A snail's secretion on your face might sound strange, but COSRX snail mucin has become one of the most talked-about ingredients in K-beauty. And for good reason. This humble ingredient hydrates, repairs, and soothes skin like few others can. If you've been curious about what the fuss is all about, let's break down everything you need to know.</p> <h2>Snail Mucin Meaning: What Actually Is It?</h2> <p>Snail mucin, also called snail secretion filtrate, is the slime that snails produce to protect and repair their own skin. When a snail moves across rough surfaces, this mucin shields it from cuts and infections while keeping its body hydrated.</p> <p>Scientists discovered that the same properties work beautifully on human skin. Snail mucin contains a powerful combination of glycoproteins, hyaluronic acid, glycolic acid, and zinc. These compounds work together to hydrate, repair damaged tissue, and support collagen production.</p> <p>The snail mucin used in skincare is collected ethically. Snails are placed on mesh surfaces in dark, calm environments where they naturally produce mucin without harm. The secretion is then filtered and purified for cosmetic use.</p> <h2>Snail Mucin Benefits for Skin</h2> <p>The snail mucin benefits extend across multiple skin concerns, making it one of the most versatile ingredients available.</p> <h3>Deep Hydration Without Heaviness</h3> <p>Snail mucin contains natural hyaluronic acid that draws moisture into your skin. Unlike heavy creams that sit on the surface, snail mucin absorbs quickly and hydrates from within. Your skin feels plump and bouncy, not greasy. This makes it perfect for all skin types, including oily and combination skin.</p> <h3>Skin Barrier Repair</h3> <p>A damaged moisture barrier leads to dryness, sensitivity, and irritation. According to<a href="https://jddonline.com/"> research published in the Journal of Drugs in Dermatology</a>, snail mucin supports skin barrier function and helps repair compromised skin. The glycoproteins and zinc in snail mucin accelerate healing and strengthen your skin's natural defences.</p> <h3>Soothing Irritation and Redness</h3> <p>If your skin gets red, irritated, or inflamed easily, snail mucin benefits for skin include powerful calming properties. It reduces redness without causing further sensitivity. Many people with reactive skin find that snail mucin is one of the few ingredients they can tolerate.</p> <h3>Fading Scars and Hyperpigmentation</h3> <p>Snail mucin promotes cell turnover and regeneration. Over time, this helps fade acne scars, dark spots, and uneven texture. The glycolic acid content provides gentle exfoliation without the irritation of stronger acids.</p> <h3>Anti-Aging Support</h3> <p>Collagen production naturally decreases with age. Snail mucin stimulates collagen synthesis, which helps reduce fine lines and keeps skin firm. The hydration boost also plumps skin, making wrinkles less noticeable.</p> <h2>Best Snail Mucin Products</h2> <p>When it comes to snail mucin, concentration and formulation matter.</p> <h3>COSRX Advanced Snail 96 Mucin Power Essence</h3> <p>The<a href="https://www.kindlife.in/advanced-snail-96-mucin-power-essence-100ml-en-1/"> COSRX Advanced Snail 96 Mucin Power Essence</a> is the gold standard. With 96% snail secretion filtrate, this essence delivers maximum snail mucin benefits in a lightweight, absorbing formula. It layers beautifully under moisturiser and works for every skin type.</p> <p>The texture is slightly viscous but not sticky. It sinks into skin within seconds, leaving behind a dewy, hydrated finish. Many users notice improved texture and reduced redness within the first week.</p> <h3>Complementary Products</h3> <p>For enhanced results, pair your snail mucin with other gentle actives. The<a href="https://www.kindlife.in/madagascar-centella-tone-brightening-capsule-ampoule-30ml/"> Skin1004 Madagascar Centella Tone Brightening Capsule Ampoule</a> works well alongside COSRX snail mucin for calming and brightening. For vitamin C benefits, the<a href="https://www.kindlife.in/freshly-juiced-vitamin-drop-35ml/"> Klairs Freshly Juiced Vitamin Drop</a> can be used in the morning, while snail mucin works its magic at night.</p> <h2>How to Use Snail Mucin in Your Routine</h2> <p>Snail mucin fits into the serum or essence step of your routine, after<a href="https://www.kindlife.in/skincare-l/cleansers/"> cleansing</a> and<a href="https://www.kindlife.in/skincare-l/toners/"> toning</a>, but before moisturiser.</p> <p>Start with clean, slightly damp skin. Dispense two to three pumps of COSRX snail mucin onto your fingertips. Warm the product between your hands, then press gently into your face. Pat rather than rub to encourage absorption. Wait about 30 seconds before applying your moisturiser to seal everything in.</p> <p>You can use snail mucin both morning and night. In the morning, follow with sunscreen. At night, layer with a richer moisturiser for overnight repair.</p> <h2>Adapting to Indian Weather</h2> <p>In humid Indian climates, snail mucin's lightweight texture is a major advantage. It provides hydration without heaviness, making it comfortable even in monsoon weather. During dry winters, layer your COSRX snail mucin twice for extra moisture, or follow with a richer<a href="https://www.kindlife.in/skincare-l/serums/face-serums/"> face serum</a>.</p> <p>For oily skin in humidity, snail mucin might be all the hydration you need. You can skip heavy moisturisers and let the essence do the work.</p> <h2>Kind Choices for Your Skin</h2> <p>At<a href="https://www.kindlife.in/"> Kindlife</a>, we bring you trusted K-beauty products like the<a href="https://www.kindlife.in/advanced-snail-96-mucin-power-essence-100ml-en-1/"> COSRX Advanced Snail 96 Mucin Power Essence</a>. Our curated<a href="https://www.kindlife.in/skincare-l/"> skincare collection</a> features formulas that deliver real results for Indian skin and weather conditions.</p> <p>Give snail mucin a try and let your skin experience the difference.</p> <h2>FAQs</h2> <h3>What is COSRX snail mucin used for?</h3> <p>COSRX snail mucin hydrates, repairs skin barrier damage, soothes irritation, and fades scars. It works for all skin types and addresses multiple concerns in one lightweight formula.</p> <h3>Can you use COSRX snail mucin every day?</h3> <p>Yes, snail mucin is gentle enough for twice-daily use. Apply morning and night after cleansing and toning. Consistent daily use delivers the best results for hydration and repair.</p> <h3>What is the best way to apply snail mucin?</h3> <ul><li>Apply two to three pumps on clean, slightly damp skin</li><li>Pat gently into your face rather than rubbing</li><li>Wait 30 seconds before applying moisturiser to seal in benefits</li></ul> <h3>How long does it take snail mucin to work?</h3> <ul><li>Hydration improves immediately after the first use</li><li>Reduced redness and improved texture appear within one to two weeks</li><li>Scar fading and anti-aging benefits take four to eight weeks of consistent use</li></ul> <h3>What ingredients should I avoid when using COSRX snail mucin?</h3> <p>Snail mucin pairs well with most ingredients. However, avoid using it with high-concentration vitamin C or strong acids like glycolic or salicylic in the same routine. Layer these at different times of day to prevent irritation.</p> Benefits for Skin Learn what snail mucin means, its benefits for skin, and how to use COSRX snail mucin for hydrated, glowing skin. Complete guide with top product picks. Snail Mucin Benefits for Skin | How to Use & Best Products benefits-and-uses-of-snail-mucin 153