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 (
    9963, 381, 429, 9913, 9912, 10139, 9916, 
    9911, 10138, 10217, 10142, 10141
  ) 
  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.00056

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
381 ausstiegsfenster-velux-velta 452/932
429 kunststoff-ausstiegsfenster-skylight-loft-premium-wei 452/931
9911 fakro-ausstiegsfenster-wli 452/932
9912 fakro-ausstiegsfenster-mit-esg-und-universellem-eindeckrahmen-wgt 452/932
9913 fakro-ausstiegsfenster-mit-verbundscheibe-und-universellem-eindeckrahmen-wgi 452/932
9916 fakro-standard-ausstiegsfenster-mit-dem-eindeckrahmen-ws 452/932
9963 skylight-kunststoff-ausstiegsfenster-loft-weis 452/931
10138 dachausstiegsfenster-gxl-2070 452/931
10139 dachausstiegsfenster-gxl-3070 452/931
10141 dachausstiegsfenster-gxl-3066 452/931
10142 dachausstiegsfenster-gxu-0070 452/931
10217 dachausstiegsfenster-gxu-0066 452/931