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 = 251 
  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', 'V')

Query time 0.00155

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.20"
    },
    "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.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",
            "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.20",
            "prefix_cost": "0.00",
            "data_read_per_join": "5K"
          },
          "used_columns": [
            "page_id",
            "lang_code",
            "page",
            "description",
            "meta_keywords",
            "meta_description",
            "page_title",
            "link",
            "ab__custom_page_h1",
            "page_sitemap"
          ]
        }
      },
      {
        "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": "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 abt__ut2_microdata_schema_type lang_code page description meta_keywords meta_description page_title link ab__custom_page_h1 page_sitemap seo_name seo_path
251 556 0 251 A T 0 1652392800 0 0 N 0 0 activity en EXPEDITOR / DISPECER <h1 style="color:#000000;">SHIPPER / DISPATCHER FOR INTERNATIONAL / DOMESTIC ROAD TRANSPORT </h1> <p></p> <p style="color:#000000;font-size:20px;"><strong>Job description:</strong> </p> <p style="color:#000000;font-size:15px;"> 95 Arion - company with a tradition in road transport, is looking for EXPERIENCED SHIPPER for INTERNATIONAL ROAD TRANSPORT (EU, non-EU). An exceptional opportunity for affirmation and development for people with experience in the field, who are looking for a new challenge.<br /><br />Do you know the transport market, do you want to do more, are you looking for new challenges? Join our team in the Oltenita office.<br /><br /><b></b> </p> <p style="color:#000000;font-size:20px;"> <strong>Requirements:</strong><br /></p> <p style="color:#000000;font-size:15px;">- Experience in a freight forwarder or similar position, which proves a good understanding and knowledge of the road freight transport market;<br />- Higher education completed;<br />- Knowledge of written / spoken conversational level - business of at least one foreign language;<br />- Very good communication and planning skills, customer and result orientation, proactive attitude and desire for development.</p> <p style="color:#000000;font-size:20px;"><br /><br /><b></b><strong>Main responsibilities:</strong><br /></p> <p style="color:#000000;font-size:15px;">- Ensuring the necessary transport, identifying the best solutions and controlling the non-compliance of the clients' requirements regarding the intermediated services, from the taking over of the transport request until the collection, respectively the payment;<br />- Development of a portfolio of approved clients and carriers;<br />- Achieving profitability objectives.</p> <p style="color:#000000;font-size:20px;"><br /><br />Join the team with the most dynamic brand in transport in Romania!</p> <p><br /></p> <p style="color:#000000;font-size:15px;">We are waiting for you!<br />Team 95 Arion</p> <p><br /></p> <p><br /></p> <p><a style="color:#FFFFFF;background-color:#1363A0;padding:20px;font-size:20px;" href="/contact/">APPLY </a></p> webmarco, arion srl, companii, romania. transport, marfuri, camioane, profesionisti, europa, roads, urban, Compania 95 Arion, una din cele mai mari companii din Romania pe segmentul Transporturi Rutiere de Marfuri, isi inoieste flota de camioane si angajeaza conducatori auto profesionisti EXPEDITOR / DISPECER PENTRU TRANSPORT RUTIER INTERNATIONAL / INTERN expeditor-dispecer