SELECT 
  cscart_categories.category_id, 
  cscart_categories.parent_id, 
  cscart_categories.id_path, 
  cscart_category_descriptions.category, 
  cscart_categories.position, 
  cscart_categories.status, 
  cscart_categories.company_id, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_categories 
  LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id 
  AND cscart_category_descriptions.lang_code = 'se' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id 
  AND cscart_seo_names.type = 'c' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'se' 
  AND cscart_seo_names.company_id = cscart_categories.company_id 
WHERE 
  1 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A') 
  AND cscart_categories.id_path LIKE '258/%' 
  AND cscart_categories.company_id = 2 
ORDER BY 
  cscart_categories.is_trash asc, 
  cscart_categories.position asc, 
  cscart_category_descriptions.category asc

Query time 0.00089

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_categories range c_status,id_path,idx_id_path id_path 767 9 Using index condition; Using where; Using temporary; Using filesort
1 SIMPLE cscart_category_descriptions eq_ref PRIMARY PRIMARY 9 mahm3t_cs443.cscart_categories.category_id,const 1 Using where
1 SIMPLE cscart_seo_names eq_ref PRIMARY,dispatch PRIMARY 210 mahm3t_cs443.cscart_categories.category_id,const,const,const,const 1 Using where

Result

category_id parent_id id_path category position status company_id seo_name seo_path
913 912 258/912/913 Cellplast, Frigolit 10 A 2 polystyrene-boards-se 258/912
383 276 258/276/383 Cellplast, Frigolit 10 A 2 cellplast-frigolit 258/276
273 258 258/273 Fasadisolering 10 A 2 fasadisolering 258
274 273 258/273/274 Isoleringsskivor 10 A 2 isoleringskivor 258/273
370 278 258/278/370 Mineralull 10 A 2 mineralul 258/278
912 258 258/912 Fundament 20 A 2 fundament-se 258
296 273 258/273/296 Klister- och armeringsbruk 20 A 2 klister-och-armeringsbruk 258/273
914 276 258/276/914 PIR 20 A 2 pir-boards-se 258/276
905 278 258/278/905 Cellplast, Frigolit 30 A 2 eps-foer-tak 258/278
275 273 258/273/275 Puts 30 A 2 puts 258/273
278 258 258/278 Tak 30 A 2 tak-isolering 258
277 273 258/273/277 Färger 40 A 2 farger 258/273
276 258 258/276 Golv isolering 40 A 2 golv-isolering 258
906 278 258/278/906 PIR 40 A 2 pir 258/278
352 273 258/273/352 Tillbehör 50 A 2 tillbehoer 258/273