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 = 336 
  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.00067

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
336 567 0 336 A T 0 1663624800 0 0 N 0 0 activity en RESTORATION OF THE FACADES OF THE OBJECTS, IN THE "5 SHTATORI" NEIGHBORHOOD | COROVODE <h1 style="color:#000000;">RESTORATION OF THE FACADES OF THE OBJECTS, IN THE "5 SHTATORI" NEIGHBORHOOD | COROVODE</h1> <p> <br /> </p> <p style="color:#000000;font-size:16px;">These buildings were built before the 90s, but have undergone subsequent additions over the years. The existing condition of the facades of the buildings is quite problematic, with damage to the external refinishing of the buildings, different and unfixed treatments of additions or later interventions. The facades will be insulated with a capot system and painted with plastic-based paint according to the color defined in the project.</p> <p style="color:#000000;font-size:16px;"> <b> Some of the works performed are: </b> <br /> - Removal of the existing plaster <br /> - Demolition of concrete terrace parapet at height <br /> - Knocking with cement mortar <br /> - Ordinary facade plaster <br /> - Import hydroplastic paint <br /> </p> <p> <br /> </p> <p style="color:#000000;font-size:22px;">See some photos during the facade works:</p> <p> <img src="https://webmarco.com/images/All%20vendors/txh%20shpk/fasade19.png?1663254839502" alt="fasade19.png?1663254839502" />  <img src="https://webmarco.com/images/All%20vendors/txh%20shpk/fasade20.png?1663254859209" alt="fasade20.png?1663254859209" />  <img src="https://webmarco.com/images/All%20vendors/txh%20shpk/fasade21.png?1663254878312" alt="fasade21.png?1663254878312" />  <img src="https://webmarco.com/images/All%20vendors/txh%20shpk/fasade22.png?1663254898543" alt="fasade22.png?1663254898543" />  <img src="https://webmarco.com/images/All%20vendors/txh%20shpk/fasade23.png?1663254915985" alt="fasade23.png?1663254915985" />  </p> <p> <img src="https://webmarco.com/images/All%20vendors/txh%20shpk/fasade24.png?1663254935077" alt="fasade24.png?1663254935077" />  </p> construction, riconstruction, rikonstruksion, biznes, txh shpk, investitor, dovana, durres, ndertesa, ambient, sherbime, zyra, godina, investim, siperfaqe, fondi shqiptar, qytet, bulevard, vlore, ismail qemali, biznes, objekt ekzistues, kat shtese, fasade The buildings are organized for housing. Investment value: 20,000,000 ALL Area: 15,000 m2 Investor: Skrapar Municipality Completion of Works July 2021 RESTORATION OF THE FACADES OF THE OBJECTS, IN THE "5 SHTATORI" NEIGHBORHOOD | COROVODE restaurimi-i-fasadave-te-objekteve-ne-lagjen-5-shtatori-corovode