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 = 53 
  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.00452

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
53 0 0 53 A T 0 1697151600 0 0 N 0 0 activity en The Inner Circle <div class="th-inner-circle"> <h2 class="ty-mainbox-simple-title">So, What Helped?&nbsp;</h2><h2 class="ty-mainbox-simple-title"><em>Your Stories</em></h2> <div class="th-inner-circle__item"> <div class="th-inner-circle__item-image"> <img src="/design/themes/the_helpful/media/images/inner-circle/Real Stories-Rebecca.jpg"> </div> <div class="th-inner-circle__item-caption"> <p><strong><em>"I didn't want to complain, but I was struggling".</em></strong></p><p>Rebecca has mastered the art of figuring sh*t out. Resourceful, deeply contemplative, and innately attuned to her surroundings, I was intrigued to hear her story of moving into the dilapidated house she and her husband are also restoring.</p> <a href="/blog/but-what-helped-rebeccas-story/">Read more</a> </div> </div> <div class="th-inner-circle__item"> <div class="th-inner-circle__item-image"> <img src="https://wearethehelpful.com/images/Viv.jpg?1731065949235"> </div> <div class="th-inner-circle__item-caption"> <p><strong><em>“More time / Less guilt”.</em></strong></p> <p>An intimate share of an unexpected overseas move and what those closest did to show up and support when it was truly needed.</p> <a href="/blog/but-what-helped-an-unexpected-overseas-move-and-what-those-closest-did-to-show-up-and-support-when-it-was-truly-needed/">Read more</a> </div> </div> <div class="th-inner-circle__item"> <div class="th-inner-circle__item-image"> <img src="https://wearethehelpful.com/images/Me.jpg?1731517272119"> </div> <div class="th-inner-circle__item-caption"> <p><em><strong>“I was so busy being a mum, I didn’t have time to be a daughter.”</strong></em></p><p> </p><p>Working so closely with Kate to build her vision for We Are The Helpful, we talked more intimately about her experience of losing her mum than we might have otherwise. Her words were as ever poignant, honest, and reflective, but this simple, disarming phrase struck me as so universally relatable.</p> <a href="/blog/what-helped-kates-story-on-loss-and-motherhood/">Read more</a> </div> </div> <div class="th-inner-circle__button"> <a href="/blog/" class="ty-btn ty-btn__primary">Your Stories: Read More</a> </div> </div> inner-circle