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 (
    90052, 89929, 89312, 89311, 89310, 89309, 
    89985, 89944, 89943, 89402, 89191, 
    89173, 89172, 89551, 89037, 89483, 
    89445, 89443, 88978, 88914
  ) 
  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.00064

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
88914 kirk-p-automanual-original-mix-shed-trax 4
88978 od404-9-bar-hoover-groover-remix-resurrection-digital 6
89037 droxford-lose-control-original-mix-traffic-records-en 4
89172 rick-james-good-times-roll-original-mix-shed-trax 4
89173 rick-james-what-i-need-original-mix-shed-trax 4
89191 alan-james-wain-johnstone-rocksteady-invincible-original-mix-lightning-trax 4
89309 charlie-bosh-get-wicked-radio-edit-cheeky-tracks 4
89310 charlie-bosh-get-wicked-vip-radio-edit-cheeky-tracks 4
89311 charlie-bosh-get-wicked-vip-remix-cheeky-tracks 4
89312 charlie-bosh-get-wicked-original-mix-cheeky-tracks 4
89402 eggman-joe-longbottom-berk-m.a.r.c-s-overfed-remix-pumped 6
89443 t-jay-adelle-all-or-nothing-original-mix-dnz-records 4
89445 bounce-enforcerz-like-this-original-mix-dnz-records 4
89483 jumpin-jack-a-true-gladiator-garbie-project-remix-dnz-records 4
89551 jamie-b-dream-lighter-original-mix-dnz-records 4
89929 jamie-b-someone-original-mix-dnz-records 4
89943 jumpin-jack-bang-the-drum-original-mix-dnz-records 4
89944 dj-pulse-dj-oskar-survive-original-mix-dnz-records 4
89985 scott-rage-i-don-t-mind-rec-tec-music 4
90052 nova-scotia-dj-pulse-donna-marie-angels-dj-oskar-remix-dnz-records-en 4