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 = 'de' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00087

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-arz-h-manueller-aussenrollladen 412/897/899
407 fakro-arz-solar 412/897/899
3319 markise-fur-balio 412/897/900
3320 markise-fur-dakstra 412/897/900
8861 dachfenster-velux-gzl-b-1051 412/482
9842 velux-vorteils-set-verdunkelungsrollo-und-plissee-dfd 412/897/898
9849 hitzeschutz-markise-verdunkelung-velux-sss 412/897/898
9851 velux-wabenplissee-faltstore-duoline-fhc 412/897/898
10063 wandschalter-velux-integra-kli-31 412/468
10067 velux-integra-klf-200-interface 412/468
10104 fakro-isolierend-faltstore-apf 412/897/899
10201 dachfenster-fakro-ptp-v-u4-schwingfenster-aus-kunststoff 412/432