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 = 98 
  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.00035

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.70"
    },
    "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": 2,
          "rows_produced_per_join": 2,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.50",
            "eval_cost": "0.20",
            "prefix_cost": "0.70",
            "data_read_per_join": "3K"
          },
          "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
98 0 7 7/98 A B 0 1709769600 0 0 N 0 0 en Meet Dani, Author of 'About Hedgehog' and Founder of Eco-able <p>Curating ‘About Hedgehog’ by Dani Seatter is quite personal for me. &nbsp;<br>&nbsp;<br>It's a book that means we've lost someone we love, but it's also a book that when we receive it, it comes with a real sense of gratitude and feels like a knowing exchange from another who <i>really</i> <i>understands</i> what we're going through.<br>&nbsp;<br>A beautiful example of ‘<i>being met where we’re at</i>' by another. &nbsp;<br>&nbsp;<br>I know this because Dani (Author of ‘About Hedgehog’ and Founder of Eco-able) generously sent this book to me after hearing about the loss of my beautiful Mum, knowing I was finding it really hard to find the words to explain it to my young daughter who was <i>FULL</i> of questions. &nbsp;I simply didn't have the capacity or knowledge of how to talk about it properly with her.<br>&nbsp;<br>When we talk about helpful, heartfelt gifts for the inner circle, it's hard to go past gifts like this.</p> <p>So, let's get to know Dani and Eco-able a little better - enjoy x</p> <p><em><br></em></p> <p><strong><em>Hi Dani, introduce yourself!</em></strong></p> <p><span style="color: var(--redactor2-text-color);">I’m Dani and I’m an award winning children’s author and founder of award winning sustainable brand Eco-Able.</span></p> <p><strong><em>Why did you start Eco-able?</em></strong></p> <p>I started Eco-Able after a conversation with my sister about plastic free July, we were both frustrated by the difficulties in finding great sustainable products in one place and it occurred to me that I could do something about that. So I decided to set up Eco-Able to provide tried and tested products to help people like me live more sustainably.&nbsp;<em><br></em></p> <p><strong><em>Tell us more about Eco-able</em></strong></p> <p>Eco-Able is a sustainable brand which specialises in sourcing and creating sustainable products for families. We take time to source the right products, allowing families to feel confident that they are being mindful of the planet as well as getting what is best for their families. We specialise in creating both heirloom products, such as our reusable advent calendars and educational ones, like our sustainably made children’s books.<em><br></em></p> <p><strong><em>What was the most thoughtful and helpful gift you've received?</em></strong></p> <p>Over the years I’ve received some beautiful gifts from friends and loved ones, the most special of these are always the ones that someone has thoughtfully bought or made for me. There’s something so special about choosing gifts with someone specific in mind.<em><br></em></p> <p><strong><em>How would you describe your inner circle?</em></strong></p> <p>Thoughtful, understanding, accepting and nurturing</p> grief, loss, death, eco-able, books that explain grief to kids, helpful gifting, we are the helpful, bereavement, sympathies Curating ‘About Hedgehog’ by Dani Seatter is quite personal for me. It's a book that means we've lost someone we love, but it's also a book that when we receive it, it comes with a real sense of gratitude and feels like a knowing exchange from anoth Meet Dani meet-dani-author-of-about-hedgehog-and-founder-of-eco-able 7