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 = 44 
  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.00176

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
44 0 0 44 A T 0 1566507600 0 0 N 0 0 activity en Careers <h4 class="page_heading"><img src="https://www.stock2cart.com/images/CAREERS.jpg?1569928831771" alt="CAREERS.jpg?1569928831771" /><br /></h4><h4 class="page_heading">Careers</h4><p>At Stock2cart, you’ll work with a team of dedicated, talented professionals with an entrepreneurial spirit and a drive to win. At our growing company, each day brings exciting new challenges and opportunities to learn on the job. We work hard each day to meet our collective goals—but we keep life balanced with time spent away from the office, too. </p><p>For people enthusiastic about adding discernible value to the industrial e-commerce space, Stock2cart aims to provide a work environment that is conducive to learning and a catalyst for personal and professional growth. </p><p>Stock2cart is constantly expanding its team to include bright minds and starry-eyed professionals to contribute in various ways to the company's journey and in turn lighten up their own futures. </p><p><strong>Our immediate requirements are as under:</strong> </p><ol><li>SEO Specialist</li> <li>Seller On-boarding Specialist</li> <li>Buyer On-boarding Specialist</li> <li>Senior Software Engineer </li> <li>Web Designer</li> <li>Content Managers</li> </ol><p>If you are interested in exploring opportunities with us, please write to us at care@stock2cart.com </p><h4 class="page_heading">Our Core Values</h4><p>These are the values that keep us focused on what really matters. We developed them with input from team members across the company—and we live them out every day, keeping them in mind as we tackle each new project, meeting, and initiative. </p><h6>At Stock2cart, we…</h6><h4 class="page_heading">Win & Lose Together (We prefer winning!)</h4><p>We celebrate our accomplishments and learn from our failures. </p><h4 class="page_heading">Are Transparent</h4><p>We are open, honest, and candid with each other. </p><h4 class="page_heading">Take Ownership</h4><p>We all are empowered and accountable to take risks and find a better way. </p><h4 class="page_heading">Aspire to Be Customer-Obsessed</h4><p>Our customers are everything to us. </p> careers