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 (
    98260, 98259, 98258, 98257, 98256, 98255, 
    98254, 98253, 98252, 98251, 98250, 
    98249, 98248, 98247, 98246, 98245, 
    98244, 98243, 98242, 98241
  ) 
  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.00036

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
98241 gary-o-connor-reloaded-digital-snail 6
98242 gary-o-connor-the-great-escopi-digital-snail-en 6
98243 gary-o-connor-danny-gilligan-zeeteah-massiah-eternity-digital-snail 6
98244 gary-o-connor-ger-quinlan-nunca-mas-digital-snail 6
98245 gary-o-connor-tenchy-nasty-pasty-digital-snail-en 6
98246 gary-o-connor-the-kraken-digital-snail 6
98247 henry-trotton-hetty-wainthrapper-digital-snail-en 6
98248 the-pet-detectives-pawsome-digital-snail-en 6
98249 the-snail-plain-snailing-digital-snail-en 6
98250 the-snail-sabotaged-digital-snail-en 6
98251 the-snail-without-you-digital-snail-en 6
98252 andy-farley-gary-o-connor-what-zapp-digital-snail-en 6
98253 gary-o-connor-clean-sheet-digital-snail 6
98254 gary-o-connor-escargot-digital-snail-en 6
98255 gary-o-connor-it-s-not-the-same-the-honestly-it-s-not-mix-digital-snail-en 6
98256 gary-o-connor-moonman-digital-snail-en 6
98257 gary-o-connor-mysterious-land-digital-snail-en 6
98258 gary-o-connor-shell-shocka-digital-snail-en 6
98259 gary-o-connor-shine-digital-snail-en 6
98260 gary-o-connor-amber-d-let-it-go-digital-snail-en 6