SELECT 
  cscart_seo_names.object_id AS product_id, 
  cscart_seo_names.name AS seo_name, 
  cscart_seo_names.path AS seo_path 
FROM 
  cscart_seo_names 
WHERE 
  cscart_seo_names.object_id IN (
    10067, 9851, 3320, 9842, 10104, 10063, 
    407, 8861, 405, 10201, 3319, 9849
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00054

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_seo_names range PRIMARY,dispatch PRIMARY 210 24 Using index condition; Using where

Result

product_id seo_name seo_path
405 fakro-external-roller-shutters-arz-h-for-centre-pivot-windows-ft 412/897/899
407 fakro-external-roller-shutters-arz-solar 412/897/899
3319 awning-for-balio 412/897/900
3320 awning-for-dakstra 412/897/900
8861 roof-window-velux-gzl-1051b 412/482
9842 velux-duo-blackout-blind-dfd 412/897/898
9849 soft-shutter-velux-sss 412/897/898
9851 velux-energy-blind-fhc 412/897/898
10063 wall-switches-velux-integra-kli-31 412/468
10067 home-interface-velux-klf-200 412/468
10104 fakro-insulating-pleated-blind-apf 412/897/899
10201 fakro-roof-window-ptp-v-u4 412/432