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 = 'se' 
  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 = 'se' 
  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 <= 1751290129 
      AND avail_till_timestamp >= 1751290129
    )
  ) 
ORDER BY 
  cscart_pages.timestamp desc 
LIMIT 
  0, 50

Query time 0.00088

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 position timestamp usergroup_ids localization new_window use_avail_period avail_from_timestamp avail_till_timestamp facebook_obj_type staff_notes page seo_name seo_path
140 2 109 109/140 A B 0 1706396400 0 0 N 0 0 activity Vilka arkitektoniska egenskaper bör ett vackert hus ha? vilka-arkitektoniska-egenskaper-boer-ett-vackert-hus-ha 109
141 2 109 109/141 A B 0 1706396400 0 0 N 0 0 activity Kan energieffektivt hus byggas med populära material? kan-energieffektivt-hus-byggas-med-populara-material 109
142 2 109 109/142 A B 0 1706396400 0 0 N 0 0 activity Hälsosamt, varmt och hållbart Stenhus från lättbetong halsosamt-varmt-och-haallbart-stenhus-fraan-lattbetong 109
117 2 109 109/117 A B 0 1637190000 0 0 N 0 0 activity Hur minskar man värmen i rummet? how-to-cool-an-attic-in-summer-se 109
115 2 109 109/115 A B 0 1631656800 0 0 N 0 0 activity Vilket takfönster ska jag köpa? vilket-takfoenster-ska-jag-koepa 109
114 2 109 109/114 A B 0 1622498400 0 0 N 0 0 activity TV-vägg: Läs här vad kan du göra för att din tv-vägg blir en blickfång! tv-vagg-las-har-vad-kan-du-goera-foer-att-din-tv-vagg-blir-en-blickfaang 109
112 2 109 109/112 A B 0 1622152800 0 0 N 0 0 activity Trä- eller PVC- takfönster tra-eller-pvc-takfoenster-se 109
113 2 109 109/113 A B 0 1622152800 0 0 N 0 0 activity Kvaliteten på billigare takfönster jämfört med VELUX? kvaliteten-paa-billigare-takfoenster-jamfoert-med-velux-se 109
111 2 109 109/111 A B 0 1621548000 0 0 N 0 0 activity Att bygga med SOLBET lättbetong från Polen att-bygga-med-solbet-lattbetong-fraan-polen 109
110 2 109 109/110 A B 0 1621461600 0 0 N 0 0 activity Kondens på takfönster kondens-paa-takfoenster 109