Sandbox

SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.* 
FROM 
  cscart_pages 
  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  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 = 5 
  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.00072

JSON explain

{
  "query_block": {
    "select_id": 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
    }
  }
}

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
5	1	0	5	A	T	0	1208788200	0		0	N	0	0	activity	en	Cash For Cars	<h2>Manners Cash For Cars – Best Quote For Scrap Car Removals</h2> <p>Get cash for cars, trucks, SUVs, Ute’s, Jeeps, Buses, or other vehicles in three easy steps: 1. Call us for quotes 2. Accept offer 3. Get Your Cash. We offer cash for junk cars  In the Mid North SA with Same Day Payment For all Scrap Unwanted, Old Cars, Trucks, Commercial vehicles & Farm Equiptment Contact Manners Auto wreckers Port Pirie On 0401 003 530.</p> <h2><b>Our Cash For Cars Removal Services</b></h2> <ul><li>Free old, used, and unwanted car removal – We offer Free Car Removaland towing services in all parts of The Mid North.</li><li>Cash for unregistered cars – We pay for vehicles that are not registered.</li><li>Cash for unwanted cars – We buy all types of unwanted cars in South Australia.</li><li>Cash for wrecked, accident, junk and old cars.</li><li>Free scrap, wrecked, accident and damaged car removals – Our free car removal services include free towing, wrecking, collection, all necessary paperwork, and cash on the spot.</li><li>Cash for 4wd wreckers – We offer top dollar for all 4wds of all manufacturers and tow them for free.</li></ul> <p></p>	Cash for Cars, Mid North Cash for Cars, we Buy cars, Manners Auto wreckers	Cash for Cars unwanted cars Mid north we buy cars and trucks	Cash For Cars