Sandbox

SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.page, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  AND cscart_page_descriptions.lang_code = 'en' 
  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' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id 
    AND cscart_ult_objects_sharing.share_company_id = 2 
    AND cscart_ult_objects_sharing.share_object_type = 'pages'
  ) 
WHERE 
  1 
  AND cscart_pages.parent_id IN (109) 
  AND cscart_pages.status IN ('A') 
  AND cscart_pages.page_type IN ('B') 
  AND (
    cscart_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, cscart_pages.usergroup_ids) 
    OR FIND_IN_SET(1, cscart_pages.usergroup_ids)
  ) 
  AND (
    use_avail_period = 'N' 
    OR (
      use_avail_period = 'Y' 
      AND avail_from_timestamp <= 1751286787 
      AND avail_till_timestamp >= 1751286787
    )
  ) 
ORDER BY 
  cscart_pages.timestamp desc 
LIMIT 
  0, 50

Query time 0.00093

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cscart_pages	ref	PRIMARY,parent_id	parent_id	3	const	10	Using where; Using filesort
1	SIMPLE	cscart_page_descriptions	eq_ref	PRIMARY	PRIMARY	9	mahm3t_cs443.cscart_pages.page_id,const	1	Using where
1	SIMPLE	cscart_ult_objects_sharing	eq_ref	PRIMARY	PRIMARY	159	mahm3t_cs443.cscart_pages.page_id,const,const	1	Using where; Using index
1	SIMPLE	cscart_seo_names	ref	PRIMARY,dispatch	PRIMARY	206	mahm3t_cs443.cscart_pages.page_id,const,const,const	2	Using where

Result

page_id	company_id	parent_id	id_path	status	page_type	timestamp	use_avail_period	facebook_obj_type	page	seo_name	seo_path
140	2	109	109/140	A	B	1706396400	N	activity	Vilka arkitektoniska egenskaper bör ett vackert hus ha?	vilka-arkitektoniska-egenskaper-boer-ett-vackert-hus-ha-en	109
141	2	109	109/141	A	B	1706396400	N	activity	Kan energieffektivt hus byggas med populära material?	kan-energieffektivt-hus-byggas-med-populara-material-en	109
142	2	109	109/142	A	B	1706396400	N	activity	Hälsosamt, varmt och hållbart Stenhus från lättbetong	halsosamt-varmt-och-haallbart-stenhus-fraan-lattbetong-en	109
117	2	109	109/117	A	B	1637190000	N	activity	How to cool an attic in summer	how-to-cool-an-attic-in-summer	109
115	2	109	109/115	A	B	1631656800	N	activity	How to choose a roof window	vilket-takfoenster-ska-jag-koepa-en	109
114	2	109	109/114	A	B	1622498400	N	activity	TV wall: Read here how you can transform your TV wall to an absolute unique installation.	tv-vagg-las-har-vad-kan-du-goera-foer-att-din-tv-vagg-blir-en-blickfaang-en	109
112	2	109	109/112	A	B	1622152800	N	activity	Wooden or PVC roof window?	tra-eller-pvc-takfoenster	109
113	2	109	109/113	A	B	1622152800	N	activity	VELUX vs SkyLight and OptiLight. Quality comparison.	kvaliteten-paa-billigare-takfoenster-jamfoert-med-velux	109
111	2	109	109/111	A	B	1621548000	N	activity	Building with SOLBET aerated concrete from Poland	att-bygga-med-solbet-lattbetong-fraan-polen-en	109
110	2	109	109/110	A	B	1621461600	N	activity	Window condensation	kondens-paa-takfoenster-en	109