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 (
    714, 10096, 9970, 552, 9841, 9870, 9969, 
    10967, 557, 10164, 716, 1016
  ) 
  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.00060

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
552 ursa-df-42-daemmfilz 412/897/975
557 raumklima-sensor-kla-300 412/468
714 skylight-bedienungssperre 412/897/975
716 fernbedienungen-fur-fakro-gerate 412/468
1016 isolierschaumkragen-fuer-dachfenster-rooflite 412/947
9841 velux-solar-sichtschutzrollo-rsl 412/897/898
9870 teleskop-bedienungsstange-fur-dachfenster 412/897/899
9969 fakro-rauchsensor-zfd 412/468
9970 fakro-modul-zwma1 412/468
10096 velux-bfx-1000f-fur-eindeckrahmen-edj 412/947
10164 dachfenster-fakro-ftt-u-u8-thermo-energieeffizientes-schwingfenster-aus-holz-mit-4-fach-verglasung 412/432
10967 eindeckrahmen-fur-rooflite 412/461