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 (
    92048, 92047, 92046, 92045, 92044, 92043, 
    92042, 92041, 92040, 92039, 92038, 
    92037, 92036, 92035, 92034, 92033, 
    92032, 92031, 91994, 91786
  ) 
  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.00039

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

Result

product_id seo_name seo_path
91786 venkman-jon-bw-keep-goin-original-mix-cheeky-tracks 6
91994 g.w.r.-nurogl-bloody-americans-visceral-records 6
92031 frank-farrell-fickletwitch-stop-my-heart-fireball-en 6
92032 robski-matt-clarkson-monsters-fireball-en 6
92033 frank-farrell-i-m-from-marylebone-fireball-en 6
92034 marc-lewis-boulder-holder-matt-wade-remix-fireball-en 6
92035 gaz-f-nothing-fireball-en 6
92036 lesley-anne-lulus-theme-fireball 6
92037 g-mix-g-storm-fireball-en 6
92038 matt-wade-e-fireball-en 6
92039 fredrik-redeg-rd-mutiny-fireball 6
92040 frank-farrell-ben-stevens-mugged-off-fireball-en 6
92041 matt-wade-andy-t-touch-the-sky-fireball-en 6
92042 fickletwitch-kick-the-oldskool-bass-fireball-en 6
92043 gaz-f-direct-one-minute-rice-fireball-en 6
92044 matt-wade-marc-lewis-pressurized-fireball-en 6
92045 wayne-german-party-time-fireball-en 6
92046 unit-dvsn-the-rhythm-fireball-en 6
92047 team-sly-i-wanna-love-fireball-en 6
92048 lesley-anne-n.i.f.-basic-pleasure-model-fireball-en 6