Sandbox

SELECT 
  cscart_aprilpages.*, 
  cscart_aprilpage_descriptions.*, 
  cscart_aprilseo_names.name as seo_name, 
  cscart_aprilseo_names.path as seo_path 
FROM 
  cscart_aprilpages 
  INNER JOIN cscart_aprilpage_descriptions ON cscart_aprilpages.page_id = cscart_aprilpage_descriptions.page_id 
  LEFT JOIN cscart_aprilseo_names ON cscart_aprilseo_names.object_id = cscart_aprilpages.page_id 
  AND cscart_aprilseo_names.type = 'a' 
  AND cscart_aprilseo_names.dispatch = '' 
  AND cscart_aprilseo_names.lang_code = 'en' 
WHERE 
  cscart_aprilpages.page_id = 10 
  AND cscart_aprilpage_descriptions.lang_code = 'en' 
  AND (
    cscart_aprilpages.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_aprilpages.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_aprilpages.usergroup_ids
    )
  ) 
  AND cscart_aprilpages.page_type IN ('T', 'L', 'B', 'F')

Query time 0.00090

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.20"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_aprilpages",
          "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.20",
            "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_aprilpage_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.20",
            "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_aprilseo_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": "1.00",
            "eval_cost": "0.20",
            "prefix_cost": "1.20",
            "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
10	0	7	7/10	A	B	0	1415736000	0		0	N	0	0		en	How to Distribute Money between Vendors	<p>PayPal Complete Payments (Multiparty) is a solution that allows marketplaces to accept payments and split them between the vendors involved, while the marketplace takes its cut.</p><!--CUT--><p>To use PayPal Complete Payments (Multiparty), you must first contact PayPal and become approved for the use of this solution.</p><p>After that, you’ll be able to <a href="https://docs.cs-cart.com/latest/user_guide/payment_methods/paypal_commerce_platform.html" target="_blank">set up a payment method that uses PayPal Complete Payments (Multiparty)</a>. It’s important that vendors connect their accounts to your marketplace. If all of the vendors whose products are being bought connect their accounts, then customers will be offered that PayPal payment method at checkout.</p><p>In this case, everyone benefits:<ul><li>Customers benefit from having to pay only once.</li><li>You benefit from not having to split the money between vendors.</li><li>Vendors benefit from getting the money from their sold products.</li></ul></p>					how-to-distribute-money-between-vendors	7