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 (
    98021, 98020, 98019, 98018, 98017, 98016, 
    98015, 98014, 97917, 97758, 97671, 
    97663, 97471, 97470, 97469, 97468, 
    97292, 97291, 97178, 89232
  ) 
  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.00046

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
89232 matt-pickup-mini-minx-blue-rinse-original-resurrection-digital 6
97178 fabio-seramota-dana-unbounded-traxx 6
97291 d-fi-kp-mardi-gras-original-mix-epidemic-digital 6
97292 d-fi-kp-bella-original-mix-epidemic-digital 6
97468 grapey-laura-mac-come-into-my-dream-groove-control-radio-edit-cheeky-tracks 6
97469 grapey-laura-mac-come-into-my-dream-team-sly-radio-edit-cheeky-tracks 6
97470 grapey-laura-mac-come-into-my-dream-team-sly-remix-cheeky-tracks 6
97471 grapey-laura-mac-come-into-my-dream-groove-control-remix-cheeky-tracks 6
97663 gary-o-connor-go-with-the-flow-digital-snail 6
97671 dean-richardson-crowbar-tempo-trax 6
97758 riksta-spirit-of-house-global-awakening-records 6
97917 boris-the-noss-boris-the-noss-call-that-nasty-emmanating-records 6
98014 gaz-pritchard-cant-stop-now-superfly-en-5 6
98015 team-sly-sunshine-superfly-en 6
98016 vandalize-pete-maxwell-should-i-go-superfly-en-2 6
98017 team-sly-unit-dvsn-searching-superfly-en 6
98018 vandalize-team-sly-i-m-feeling-you-superfly-en 6
98019 darrell-white-redeye-superfly-en 6
98020 naughty-tempo-fire-in-my-eyes-superfly-en 6
98021 mickey-bo-mickey-g-back-on-track-superfly-en 6