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 (
    87389, 87388, 87387, 87385, 87383, 87382, 
    87381, 87380, 87379, 87378, 87377, 
    87376, 87375, 87374, 87373, 87372, 
    87109, 87108, 87107, 87106
  ) 
  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.00052

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
87106 seb-storm-heat-of-the-night-original-mix-lw-recordings 1
87107 dj-sunkeeperz-basslove-original-mix-lw-recordings 1
87108 k-rai-brokken-kenny99-remix-lw-recordings 1
87109 dr-house-heroes-out-of-control-original-mix-lw-recordings 1
87372 bk-dice-original-mix-traffic-records 1
87373 ben-keen-pick-pick-original-mix-traffic-records 1
87374 bk-join-the-club-original-mix-traffic-records 1
87375 buddy-xl-smash-original-mix-traffic-records-en 1
87376 casella-house-music-original-mix-traffic-records 1
87377 diablik-oyaebu-ego-suicide-original-mix-traffic-records 1
87378 dj-generator-little-spys-original-mix-traffic-records 1
87379 energy-syndicate-growl-original-mix-traffic-records 1
87380 fullerlove-roo-original-mix-traffic-records 1
87381 future-disciple-28-tracks-later-original-mix-traffic-records 1
87382 george-kirby-no-good-scott-attrill-remix-traffic-records-en 1
87383 halestone-guardians-of-space-original-mix-traffic-records 1
87385 george-kirby-no-good-original-mix-riot-recordings 1
87387 anne-savage-scott-attrill-komatose-original-mix-riot-recordings 1
87388 scott-attrill-acid-doll-original-mix-riot-recordings-en-2 1
87389 scott-attrill-en-harmonia-perfecta-original-mix-riot-recordings 1