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 = 114 
  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.00029

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
114 0 7 7/114 A B 0 1744758000 0 0 N 0 0 en Meet Sara, Founder and Creative Director of Revivre <p>At <em>We Are The Helpful</em>, we’re so pleased to introduce <a href="https://revivreswim.com/">Revivre</a>&nbsp;into our curated gift edits. Designed by an all-female team and founded by Creative Director Sara Rocha, Revivre is a consciously crafted swimwear brand that champions movement, confidence, and connection - with your body, with nature, and with yourself.</p> <p>The name <em>Revivre</em> is French for “to come alive again” - a perfect reflection of the brand’s energy and ethos. Whether it’s a cold water dip, a healing holiday, or simply reclaiming comfort in your skin, Revivre’s pieces are made to support women through the very real, very human moments that shape us.</p> <p>We love that Revivre brings together performance and softness, function and femininity. Whether She Needs to feel strong again, reconnect with her body, or gift herself a moment of rest and renewal, Revivre belongs here - as part of our <em>Partnership Collective</em>, where every piece is chosen to support well-being, one thoughtful gift at a time.</p> <p>Let's get to know Sara a little better.</p> <h4>About the Founder:</h4> <p>Sara is the Founder and Creative Director of Revivre, a sustainable swim and resort wear brand that blends effortless sophistication with environmental responsibility. Based in Scotland, Sara lives with her husband, two children, and two kittens. She created Revivre with the vision of offering women thoughtful pieces that combine luxury, style, and comfort, while also promoting sustainability. Her dedication to creating high-quality, eco-friendly garments has shaped the essence of the brand, making it a symbol of both elegance and conscientious living.</p> <h4>About Revivre:</h4> <p>Revivre is a conscious swim & resort wear brand that champions the “buy less, buy better” movement, believing that well-made, quality garments and sustainability can coexist, and its collections reflect this ethos. Every piece is designed with an emphasis on timeless elegance and exceptional quality. Inspired by the beauty of nature, particularly the calming hues and textures of the ocean, Revivre celebrates craftsmanship and the natural beauty of the world. The Oceanique Collection brings the tranquility of the coast to your everyday wardrobe, offering versatile and sophisticated designs in limited quantities.</p> <h4>About the Best Gift I’ve Ever Received:</h4> <p>The best gift I’ve ever received was a matching White Company towel robe set for me and my daughter when my son was born. During that sleep-deprived period of adjusting to life with a newborn, I lived in that big, fluffy white robe for three months. It made me feel effortlessly luxurious and was such a thoughtful gesture. It was a moment of kindness that made me & my family feel cared for, and it meant the world to me during that time.</p> <h4>About My Inner Circle:</h4> <p>My inner circle is a group of people who are consistent, empowering, supportive, and fun. We make a conscious effort to spend quality time together, whether it’s one-on-one or through relaxing breaks at least once a year. Our time together is filled with good food, music, wine, and plenty of laughs. This group is not only a source of joy but also a strong pillar of support and empowerment in my life.</p> <p><br></p> <p></p> Gifts for her, gifts for friend, gifts for wife, self care gifts, wellness gifts, luxury gifts, gifts for new mum Discover Revivre at We Are The Helpful – thoughtfully designed robes and towels that make perfect gifts for her or for self. Rooted in self-care, calm home rituals, and headspace, these pieces offer everyday comfort with conscious design. Revivre Robes & Towels: Thoughtful Self-Care Gifts for Her and for Home meet-sara-founder-and-creative-director-of-revivre 7