SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id 
  AND cscart_seo_names.type = 'a' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  cscart_pages.page_id = 52 
  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', 'P')

Query time 0.00284

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.37"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_pages",
          "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.10",
            "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",
            "staff_notes",
            "abt__ut2_microdata_schema_type"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_page_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.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "6K"
          },
          "used_columns": [
            "page_id",
            "lang_code",
            "page",
            "description",
            "meta_keywords",
            "meta_description",
            "page_title",
            "link",
            "page_sitemap",
            "ab__custom_page_h1",
            "custom_header",
            "ab__emd_alternative_name"
          ]
        }
      },
      {
        "table": {
          "table_name": "cscart_seo_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": "0.27",
            "eval_cost": "0.10",
            "prefix_cost": "0.37",
            "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 staff_notes abt__ut2_microdata_schema_type lang_code page description meta_keywords meta_description page_title link page_sitemap ab__custom_page_h1 custom_header ab__emd_alternative_name seo_name seo_path
52 0 0 52 A T 0 1566507600 0 0 N 0 0 activity en Infringenment ​Policy​ <div class="policy_pages_align"> <p><strong></strong></p><p><img src="https://www.stock2cart.com/images/Infringenment.jpg?1569928345773" alt="Infringenment.jpg?1569928345773" /></p><p><strong>Stock2cart.com</strong> is committed to removing infringing products from the site. To facilitate this, Stock2cart has put in place a ‘Stock2cart Infringement Verification’ process so that intellectual property owners could easily report listings that infringe their rights. It is in Stock2cart's interest to ensure that infringing products are removed from the site, as they erode Buyer and Seller trust. </p> <h5 class="page_heading">Policy </h5> <p>Stock2cart respects third party Intellectual Property rights and actively supports protection of all third party Intellectual Property including Copyrights and Trademarks (“IP”). It is our policy to expeditiously respond to clear notices of alleged IP infringement. </p> <p>If we receive proper notification of IP infringement, our response to such notices will include removing or disabling access to material claimed to be the subject of infringing activity. </p> <h5 class="page_heading">How to report a listing </h5> <p>If you have a good faith belief that your IP right has been infringed by any of our sellers, you may follow the below process: We require that the Intellectual Property right owner or authorized agent provide the following details and email it to <a href="mailto:infringement@stock2cart.com">infringement@stock2cart.com</a>.The email should contain the below information. </p> <ol><li>Identification or description of the copyrighted work/ trademark that has been infringed. </li> <li>Clear identification or description of where the material that you claim is infringing is located on <a href="http://www.stock2cart.com">www.stock2cart.com</a> with adequate particulars. Product ID / website links of infringing products (in case of copyright infringement). (Note: stock2cart is unable to process requests which do not specify exact product IDs or URLs. Please do not provide links to browse pages or links of search queries as these pages are dynamic and their contents change with time). </li> <li> (Note: stock2cart is unable to process requests which do not specify exact product IDs or URLs. Please do not provide links to browse pages or links of search queries as these pages are dynamic and their contents change with time). </li> <li>Your address, telephone number, and email address. </li> <li>A statement by you that you have a good faith belief that the use of the material complained of is not authorized by the copyright or intellectual property owner, its agent, or the law. </li> <li>A statement by you, that the information in your notice is accurate and that you are the copyright or intellectual property owner or authorized to act on the copyright or intellectual property owner's behalf. </li> <li>Brand Name (in case of Trademark infringement). </li> <li>Details of the intellectual property being infringed (Provide copyrighted images or trademark certificates as attachments)benefit. </li> </ol></div> Report Infringenment Report Infringenment Report Infringenment report-infringenment