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 (
    87668, 87667, 87689, 87688, 87651, 87790, 
    87789, 87681, 87758, 87757, 87756, 
    87755, 87684, 87677, 87585, 87885, 
    88049, 88048, 88047, 88046, 88045, 
    87873, 87766, 87765, 87646, 87590, 
    87589, 88131, 88130, 88129, 88128, 
    88071, 88070, 88069, 88057, 88056, 
    88055, 87482, 87481, 87487
  ) 
  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.00063

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

Result

product_id seo_name seo_path
87481 two-minds-project-opus-dreams-extended-mix-oneseventy 22
87482 two-minds-project-opus-dreams-radio-edit-oneseventy 22
87487 shtave-emoticon-disputed-original-mix-scarred-digital 22
87585 chris-fear-memories-original-mix-core-fever 22
87589 snipes-murf-butterflies-extended-mix-contagious-records 22
87590 snipes-murf-butterflies-radio-edit-contagious-records 22
87646 mike-steventon-to-the-beat-original-mix-keeping-the-rave-alive 22
87651 in-effect-jamie-ritmen-run-to-heaven-with-me-original-mix-executive-records 22
87667 andy-the-core-thunder-basic-rules-original-mix-darkside-unleashed 22
87668 andy-the-core-murdermind-original-mix-darkside-unleashed 22
87677 m3-o-kevin-instinct-quick-love-original-mix-tios-digital 22
87681 adam-frantic-colour-of-sound-original-mix-stomp-inc-uk 22
87684 niki-jager-automate-original-mix-justice-hardcore 22
87688 riko-aftashok-if-i-can-love-you-extended-mix-contagious-records 22
87689 riko-aftashok-if-i-can-love-you-radio-edit-contagious-records 22
87755 dave-dope-enter-the-ravezone-original-mix-darkside-unleashed 22
87756 dave-dope-enter-the-ravezone-artifex-remix-darkside-unleashed 22
87757 dave-dope-enter-the-ravezone-yk-project-remix-darkside-unleashed 22
87758 dave-dope-mi-sensi-original-mix-darkside-unleashed 22
87765 badkick-i-don-t-give-a-fuck-original-mix-underground-industry-records 22
87766 badkick-pyraw-get-the-fuck-back-original-mix-underground-industry-records 22
87789 arvid-fuck-that-feeling-original-mix-rave-instinct 22
87790 arvid-heartbreak-original-mix-rave-instinct 22
87873 mikey-p-gee-i-believe-original-mix-stomp-inc-uk 22
87885 slamma-colour-blind-original-mix-stomp-inc-uk 22
88045 angstfrai-psychotica-original-mix-core-rebelz-records 22
88046 angstfrai-the-janglehead-twins-back-in-time-original-mix-core-rebelz-records 22
88047 angstfrai-beyond-revolution-original-mix-core-rebelz-records 22
88048 angstfrai-don-t-cry-original-mix-core-rebelz-records 22
88049 angstfrai-kick-the-mechanism-original-mix-core-rebelz-records 22
88055 wicked-xxx-battle-station-ready-original-mix-mokum-records 22
88056 wicked-xxx-pumpin-the-flow-original-mix-mokum-records 22
88057 wicked-xxx-danger-zone-original-mix-mokum-records 22
88069 thunder-moon-dangerous-original-mix-darkside-unleashed 22
88070 thunder-this-is-war-original-mix-darkside-unleashed 22
88071 thunder-this-is-war-x-mind-remix-darkside-unleashed 22
88128 the-relic-the-path-to-enlightenment-original-mix-motormouth-recordz 22
88129 fracture-4-a-long-time-in-darkness-original-mix-motormouth-recordz 22
88130 dolphin-the-puppeteer-original-mix-motormouth-recordz 22
88131 sadistic-glitch-riffard-original-mix-motormouth-recordz 22