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 = 23 
  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.00077

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
23 0 0 23 A T 0 1208808000 0 0 N 0 0 en Pay in rewards points and save money <div class="ty-column2"> <img class="ty-image" src="images/companies/1/pages/reward-points-1.png"> </div> <div class="ty-column2"> <div class="ty-column1 ty-notice"> <p> When you purchase goods in our store, you get reward points. </p> <p> You can use them at any time—we think that earned reward points shouldn’t expire, like it happens in some other stores. </p> </div> <div class="ty-column1"> <h3>See how many points you have</h3> <div > <img class="ty-image" src="images/companies/1/pages/reward-points-3.png"> </div> </div> </div> <div class="ty-column1 ty-notice"> <h3>Use your reward points</h3> <div > <img src="images/companies/1/pages/reward-points-2.png"> </div> <div class="ty-column1"> <p> <br> When on the checkout page, enter the amount of reward points you want to spend in the field on the right. The sum you have to pay will be recalculated automatically. </p> </div> </div> pay-in-rewards-points-and-save-money