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 (
    87105, 87104, 87103, 87102, 87101, 87100, 
    87099, 87098, 87097, 87096, 87095, 
    87094, 87093, 87092, 87091, 87090, 
    87089, 87088, 87087, 87086
  ) 
  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.00049

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
87086 jonny-el-surge-original-mix-lw-recordings 1
87087 expulze-anima-splinta-remix-lw-recordings 1
87088 n3ckbr34kr-everything-changes-freeform-mix-lw-recordings 1
87089 s3rl-outforce-hartshorn-and-i-m-like-dj-edit-lw-recordings 1
87090 deluxe-corporation-strong-original-mix-lw-recordings 1
87091 dj-kano-voodoo-poky-original-mix-lw-recordings 1
87092 ganar-on-fire-extended-mix-lw-recordings 1
87093 john-carr-zombie-original-mix-lw-recordings 1
87094 phil-mackintosh-hit-the-floor-original-mix-lw-recordings 1
87095 milano-the-don-daryl-di-kar-og-original-mix-lw-recordings 1
87096 jon-doe-charged-up-original-mix-lw-recordings 1
87097 first-gift-self-original-mix-lw-recordings 1
87098 robbie-teeze-wanna-take-a-ride-original-mix-lw-recordings 1
87099 cookie-cookie-008-original-mix-lw-recordings 1
87100 blooddropz-don-t-break-my-heart-club-mix-lw-recordings 1
87101 ludo-dance-with-the-devil-original-mix-lw-recordings 1
87102 m1dy-everybody-wants-kiss-original-mix-lw-recordings 1
87103 blooddropz-cyber-dj-project-still-here-original-mix-lw-recordings 1
87104 hybridbeats-supercharged-original-mix-lw-recordings 1
87105 dj-trevor-mc-clarkie-think-about-original-mix-lw-recordings 1