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 (
    98753, 98752, 98751, 98750, 98749, 98624, 
    98427, 98939, 92935, 98907, 98906, 
    98905, 98904, 98902, 98832, 98831, 
    98795, 98623, 98615, 98435
  ) 
  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.00044

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
92935 paul-hunter-peter-davidson-welcome-to-slavery-vicious-circle 6
98427 tuna-charlie-nurogl-rising-101-original-mix-beast-mode-recordings 6
98435 sam-e-junkie-original-mix-ultratech 6
98615 paul-hunter-highway-61-slingshot 6
98623 munkjack-churchill-damien-blanes-remix-toolbox-recordings 6
98624 f1-dj-gonzalo-it-s-my-beat-ross-homson-remix-toolbox-recordings 6
98749 team-sly-for-the-music-original-mix-hot-box-digital-en 6
98750 kirk-p-team-sly-feel-the-love-original-mix-hot-box-digital-en-2 6
98751 team-sly-come-up-original-mix-hot-box-digital-en-2 6
98752 the-hoover-jocks-come-on-in-original-mix-hot-box-digital-en-2 6
98753 paul-hunter-ocean-eyes-original-mix-hot-box-digital-en 6
98795 mada-mr-dj-global-awakening-records 6
98831 dean-richardson-you-sigh-we-psy-trip-the-light-fantastic 6
98832 james-nardi-jonni-bryant-fil-ep-triumvirate-trip-the-light-fantastic 6
98902 homzy-random-but-raw-what-we-want-to-become-full-circle-productions 6
98904 nurogl-dig-this-burning-blade-records 6
98905 tara-n-nervous-energy-dig-this-tara-n-nervous-energy-remix-burning-blade-records 6
98906 danny-gibson-take-me-high-black-dog-records 6
98907 tara-n-lok-e-finger-linkin-good-indecision-audio 6
98939 john-casey-rock-the-party-hi-five-digital 6