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

Query time 0.00085

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.20"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_multi_decpages",
          "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_multi_decpage_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_multi_decseo_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