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' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'pages'
  ) 
WHERE 
  cscart_pages.page_id = 1052 
  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', 'F')

Query time 0.00060

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "table": {
      "table_name": "cscart_pages",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["page_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_page_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["page_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_ult_objects_sharing",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "159",
      "used_key_parts": [
        "share_object_id",
        "share_company_id",
        "share_object_type"
      ],
      "ref": ["const", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "dispatch"],
      "key": "PRIMARY",
      "key_length": "206",
      "used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
      "ref": ["const", "const", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_seo_names.`type` = 'a' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
    }
  }
}

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 extra_css extra_js layout_id commercial_hidden lang_code page description meta_keywords meta_description page_title link seo_name seo_path
1052 1 1062 1062/1052 A T 1 1513486800 0 0 N 0 0 .content-top { margin: 50px 0; } #outlines path { transition: all 0.2s ease-out; } #outlines path:hover { fill: #6e7d8f!important; cursor: pointer; } #outlines path.selected { fill: #6e7d8f!important; } svg { width: 100%; height: auto; } 0 0 en Find a Sales Rep <div class="content-top"> <p style="margin-bottom: 30px;">Barn Light Electric partners with sales reps and agencies throughout the United States and Canada who have years of experience handling both small and large-volume commercial orders. Use the map below to connect with a sales rep in your area. Our partnering reps can’t wait to start working with you on your next project!</p> <div id="map-wrapper" style="margin-bottom: 20px;"> <div id="usa"> </div> <div id="canada"> </div> </div> <h2 style="margin-bottom: 10px;">Select Your Country</h2> <select id="country" style="cursor: pointer; width: 100%; max-width: 400px; margin-bottom: 20px;"> <option value="US">United States</option> <option value="CA">Canada</option> </select> <h2 style="margin-bottom: 10px;">Select Your Region</h2> <select id="state" style="cursor: pointer; width: 100%; max-width: 400px;"></select> <div id="sales-reps" class="row-fluid" style="margin-top: 20px;"> </div> <script src="/js/addons/ble/repmap.js?r=16" type="text/javascript"></script> </div> Find a Sales Rep find-sales-rep 1062