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 = 146 
  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')

Query time 0.00036

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
146 0 7 7/146 A B 0 1761523200 0 0 N 0 0 en Welcome, Anara Skincare (A Brand We’re So Excited About) <p>Every now and then, a brand crosses my path that makes me stop, breathe, and think, <i>yes, this is what we’re here for.</i></p> <p><i style="font-weight: 700;"></i>That’s exactly how I felt when I first spoke with Arati Nar, the founder of Anara Skincare.</p> <h4>Why We’re Excited to Welcome Anara into our Brand Collective</h4> <p>When I research and curate for We are The Helpful, I’m not just looking for great products (that’s a given), I’m looking for brands with soul.</p> <p> The kind built by people who have lived the need they now serve. Founders who understand that when life happens - in all its heartbreaks, hormones, and hope - we need more than “nice things” and “stuff”.</p> <p> We need care that meets us where we’re at. And Arati gets it. Completely.</p> <p> After losing her husband and entering perimenopause, she couldn’t find anything that felt right for her newly sensitive skin (and self). So, like many incredible female founders, she created it - slowly, intentionally, and with a depth of empathy and understanding you can’t fake.</p> <p>When I went through my own period of deep grief recently, I was genuinely surprised by how helpful self-care and ritual became (and how grateful I was to be gifted some beautiful products). The small, grounding gestures like washing your face slowly, taking time with your skin, breathing, became something more than routine. They were moments of calm when the rest of life felt unbearable.&nbsp; Pockets of time to prioritise self care amongst the all-consuming heartbreak.</p> <p>And talking to Arati, we connected instantly on that truth; that sometimes, caring for ourselves in these quiet, tactile ways is one of the few things that helps us keep going.</p> <h4>The Heart and Brains Behind the Brand</h4> <p>What Arati’s built is truly beautiful: skincare that’s gentle enough for every hormonal season (and let’s be honest, there are many&hellip;), yet powerful enough to make you feel confident and cared for.</p> <p>Her five multi-use products are designed for the eyes, face, and neck, are safe during pregnancy, grounding through stress, balancing through menopause and comforting when everything just feels a bit too much.</p> <p>And while still a young brand, <strong>Anara has already received 22 industry awards</strong>&nbsp;- a quiet but powerful nod to the integrity, quality and care that sits behind every formulation. Proof, really, that when something is made with heart and intention, it can be felt.<br></p> <p>Anara is proof that luxury and honesty can coexist; skincare that doesn’t overwhelm you with rules or empty promises, just the kind that quietly works, deeply comforts and helps you feel like yourself again.</p> <h4>For the Self + The Sisterhood</h4> <p>When Arati and I first spoke, I knew instantly she belonged in our Collective - the kind of founder who creates from empathy and a deep understanding for what’s needed.</p> <p> The kind who understands that true self-care and sisterhood aren’t separate things, they’re deeply linked.&nbsp; Because yes, we gift to others. But we also need to gift to ourselves - the moments of calm, the rituals that rebuild us, the skincare that helps us feel at home in our skin again.</p> <p>That’s what Anara does so beautifully. It’s a gift of confidence and comfort; for yourself, or someone who really needs a moment of both.</p> <h4>Why This Means So Much</h4> <p>At We are The Helpful, we’re obsessed with finding brands like this - the ones that can’t be copied or imitated, because they were born from real life experience.</p> <p> And Anara Skincare is one of those rare finds we’re genuinely so excited to share with you.</p> <p>Because when life changes (as it always does), having something that understands, supports, and gently steadies you - that’s the kind of helpful we’re here for.</p> <h4>The Ritual, the Gift, the Saving Grace</h4> <p>And because we’re big believers in the power of ritual, we’re so happy to now have <a href="https://wearethehelpful.com/she-needs/self-care/">Anara’s beautiful gift sets</a> available on We are The Helpful.</p> <p>They bring her full ritual experience together - thoughtful, grounding and designed to help you or someone you love carve out small, steady moments of care.</p> <p>And the best part? You’ll save up to 20% compared to purchasing the full-sized products individually (thank you, Arati - we love a founder who makes helpful gifting even more helpful).</p> <p><a href="https://wearethehelpful.com/she-needs/perfect-partners-gift-set-hydrate-protect-and-glow/">Explore Anara Skincare</a> - For the Self. For the Sisterhood. For every season of womanhood.</p> <p>Kate x</p> <p></p> anara skincare, we are the helpful, helpful gifting, self care gifts uk, ritual gifts uk, natural skincare uk, hormonal skincare, skincare for menopause, skincare for perimenopause, pregnancy safe skincare, award winning skincare uk, gifts for women uk, g Discover Anara Skincare - award-winning natural skincare designed for every hormonal season. Gentle, grounding, and now available in exclusive gift sets at We are The Helpful. Anara Skincare Joins The Helpful: Luxury, Natural Skincare for Every Season of Womanhood welcome-anara-skincare-a-brand-were-so-excited-about 7