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 (
    85887, 85886, 85885, 85884, 85883, 85882, 
    85881, 85880, 85879, 85878, 85877, 
    85876, 85875, 85874, 85873, 85872, 
    85871, 85870, 85869, 85868
  ) 
  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.00035

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
85868 love-2-love-arnold-palmer-remix 1
85869 ki-ez-az-enber-roemikszek-sunset-blvd-remix 1
85870 hold-on-to-me-joan-jose-remix 1
85871 waves-kaan-pars-remix 1
85872 feels-so-good-original-mix 1
85873 hypnotized-original-mix 1
85874 three-minutes-on-the-corridor-original-mix 1
85875 stuck-on-you-original-mix 1
85876 tongues-of-angels-original-mix 1
85877 roadblocks-b4o-extended-remix 1
85878 love-is-on-fire-extended-version 1
85879 be-real-original-mix 1
85880 wayang-gender-dreamworld-mix 1
85881 comfort-zone-sal-medina-remix 1
85882 wanna-dance-original-mix-en 1
85883 till-the-morning-light-dave-loyd-remix 1
85884 there-for-you-original-mix-en-2 1
85885 feelin-naked-original-mix 1
85886 party-non-stop-extended-mix 1
85887 electric-disco-extended-mix 1