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 = 51 
  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.00047

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_ult_objects_sharing",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "share_object_id",
            "share_company_id",
            "share_object_type"
          ],
          "key_length": "159",
          "ref": [
            "const",
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "160"
          },
          "used_columns": [
            "share_company_id",
            "share_object_id",
            "share_object_type"
          ]
        }
      },
      {
        "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
51 1 0 51 A T 0 1763938800 0 0 N 0 0 en Legal Notice <p>Legal Notice</p> <p>In accordance with Spanish Law 34/2002, of 11 July, on Information Society Services and Electronic Commerce, users are informed of the following general information about this website.</p> <p>**Website owner**</p> <p>- Company name: KOSHAL SOLUTIONS, S.L.&nbsp;&nbsp;<br>- Tax ID (CIF): B70761671&nbsp;&nbsp;<br>- Registered office: Ronda Sant Pau 47, 08015 Barcelona, Spain&nbsp;&nbsp;<br>- E-mail: info@koshal.es&nbsp;&nbsp;<br></p> <p>The websites **https://koshal.es** and **https://test.gaseus.es** (hereinafter, the “Websites”) are owned by KOSHAL SOLUTIONS, S.L. (hereinafter, “KOSHAL” or the “Company”).</p> <p>## Purpose</p> <p>This Legal Notice regulates access to and use of the Websites. By accessing or using the Websites, you agree to be bound by this Legal Notice.</p> <p>## Intellectual and industrial property</p> <p>All content on the Websites (including, but not limited to, texts, images, graphics, logos, icons, buttons, software, source code and any other material) is owned by KOSHAL or third parties who have authorised its use, and is protected by intellectual and industrial property laws.</p> <p>Any reproduction, distribution, public communication, transformation or any other form of exploitation of such content without the prior written consent of KOSHAL is strictly prohibited, except where legally permitted.</p> <p>## Conditions of use</p> <p>The user undertakes to use the Websites and their services in accordance with the law, this Legal Notice, the Privacy Policy, the Cookies Policy and any other applicable conditions.</p> <p>The user shall refrain from using the Websites for purposes that are unlawful, harmful to the rights and interests of KOSHAL or third parties, or that may in any way damage, disable, overload or impair the Websites or prevent the normal use or enjoyment of the Websites by other users.</p> <p>## Links</p> <p>The Websites may contain links to third-party websites. KOSHAL has no control over such websites and is not responsible for their content, information or services, which are provided solely for information purposes.</p> <p>The existence of such links does not in any case imply any kind of association, merger or participation with the linked entities.</p> <p>## Liability</p> <p>KOSHAL does not guarantee the availability and continuity of the Websites. However, KOSHAL will make reasonable efforts to ensure the Websites remain accessible and to minimise interruptions caused by technical problems.</p> <p>KOSHAL shall not be liable for any damages or losses that may arise from:</p> <p>- Interferences, omissions, interruptions, computer viruses, breakdowns or disconnections in the operational functioning of the Websites or the user’s devices, due to causes beyond KOSHAL’s control.&nbsp;&nbsp;<br>- Unlawful or inappropriate use of the Websites by users.&nbsp;&nbsp;<br>- Decisions taken on the basis of information provided through the Websites.</p> <p>## Applicable law and jurisdiction</p> <p>This Legal Notice is governed by Spanish law. For the resolution of any disputes or matters related to the Websites, the parties submit to the Courts and Tribunals of Barcelona, expressly waiving any other jurisdiction that may correspond to them.</p><p></p> legal-notice