Sandbox

SELECT 
  vi_pages.*, 
  vi_page_descriptions.*, 
  vi_seo_names.name as seo_name, 
  vi_seo_names.path as seo_path 
FROM 
  vi_pages 
  INNER JOIN vi_page_descriptions ON vi_pages.page_id = vi_page_descriptions.page_id 
  LEFT JOIN vi_seo_names ON vi_seo_names.object_id = vi_pages.page_id 
  AND vi_seo_names.type = 'a' 
  AND vi_seo_names.dispatch = '' 
  AND vi_seo_names.lang_code = 'en' 
  INNER JOIN vi_ult_objects_sharing ON (
    vi_ult_objects_sharing.share_object_id = vi_pages.page_id 
    AND vi_ult_objects_sharing.share_company_id = 1 
    AND vi_ult_objects_sharing.share_object_type = 'pages'
  ) 
WHERE 
  vi_pages.page_id = 41 
  AND vi_page_descriptions.lang_code = 'en' 
  AND (
    vi_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, vi_pages.usergroup_ids) 
    OR FIND_IN_SET(1, vi_pages.usergroup_ids)
  ) 
  AND vi_pages.page_type IN ('T', 'L', 'B', 'F')

Query time 0.00064

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "nested_loop": [
      {
        "table": {
          "table_name": "vi_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": "vi_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": "vi_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": "vi_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(vi_seo_names.`type` = 'a' and vi_seo_names.dispatch = '' and vi_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	facebook_obj_type	abt__ut2_microdata_schema_type	page_code	lang_code	page	description	meta_keywords	meta_description	page_title	link	seo_name	seo_path
41	1	7	7/41	A	B	100	1773421943	0		0	N	0	0	activity			en	For those who love sound quality we have awesome Pioneer speakers! (Демо)	<h2>Demo article title h2</h2><p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p><h3>Demo article title h3</h3><p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p><p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>					for-those-who-love-sound-quality-we-have-awesome-pioneer-speakers-demo	7