Sandbox

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 = 338 
  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.00175

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
338	567	0	338	A	T	0	1663624800	0		0	N	0	0	activity		en	STRUCTURAL RECONSTRUCTION OF THE "KLARA 1& 2" BUILDING \| TIRANA	<h1 style="color:#000000;">STRUCTURAL RECONSTRUCTION OF THE "KLARA 1& 2" BUILDING \| TIRANA </h1> <p> <br /> </p> <p style="color:#000000;font-size:16px;">The Klara buildings were built in 2000, where the seismic performance is problematic. As a result, the intervention was made in the structure by expanding the plinths and skirting the columns up to the third floor, making all the interventions according to the proposal detailed in the project, for the rehabilitation of the structure. The C-FRP method is used, which serves to increase the bearing capacity of the element in the case of beams, this method means reinforcing the beams with carbon fibers.</p> <p> <br /> </p> <p style="color:#000000;font-size:22px;"> Check out some photos during the works on the facilities: </p> <p> <br /> </p> <p> <img src="https://webmarco.com/images/All%20vendors/txh%20shpk/clara17.png?1663254001076" alt="clara17.png?1663254001076" /> <img src="https://webmarco.com/images/All%20vendors/txh%20shpk/clara18.png?1663254018111" alt="clara18.png?1663254018111" /> <img src="https://webmarco.com/images/All%20vendors/txh%20shpk/clara19.png?1663254041354" alt="clara19.png?1663254041354" /> </p> <p> <img src="https://webmarco.com/images/All%20vendors/txh%20shpk/clara20.png?1663254057357" alt="clara20.png?1663254057357" /> </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	Ndërtesa është ideuar dhe organizuar për biznes dhe banim. (përdorimi i metodës me C-FRP) • Vlerë Investimi: 100,000,000 lekë • Sipërfaqe mbi 11,000 m2 • Investitor: Bashkia Tiranë • Përfundim I Punimeve Mars 2022	STRUCTURAL RECONSTRUCTION OF THE "KLARA 1& 2" BUILDING \| TIRANA				riaftesim-strukturor-i-nderteses-klara-1-and-2-tirane