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 (
    86768, 86767, 86766, 86765, 86764, 86763, 
    86762, 86761, 86760, 86593, 86576, 
    86573, 86571, 86569, 86567, 86565, 
    86547, 86448, 86416, 86773
  ) 
  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.00048

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
86416 garbie-project-falling-over-the-moon-original-mix-dnz-records 1
86448 dj-ruiz-without-you-original-mix-power-tracks-records 1
86547 projekt-phase-all-night-original-mix-disposition-digital 1
86565 qm-corp-way-you-move-original-mix-power-tracks-records 1
86567 qm-corp-broken-heart-2017-original-mix-power-tracks-records 1
86569 qm-corp-burning-in-the-sky-original-mix-power-tracks-records 1
86571 qm-corp-here-without-you-original-mix-power-tracks-records 1
86573 qm-corp-i-don-t-wanna-know-original-mix-power-tracks-records 1
86576 qm-corp-wanna-you-touch-original-mix-power-tracks-records 1
86593 dan-diamond-house-party-original-mix-shed-trax 1
86760 jumpin-jack-a-true-gladiator-dj-oskar-remix-dnz-records 1
86761 dj-muela-heat-of-the-night-original-mix-dnz-records 1
86762 bounce-enforcerz-about-us-dj-oskar-remix-dnz-records-en 1
86763 dj-bass-in-the-moment-original-mix-dnz-records-en 1
86764 miky-one-dj-kino-how-you-feel-original-mix-dnz-records 1
86765 raul-arribas-reunited-original-mix-dnz-records 1
86766 dancelord-trying-original-mix-dnz-records 1
86767 jj-dj-oskar-cloudy-days-dj-oskar-hdm-mix-dnz-records 1
86768 tribute-vocals-material-girl-original-mix-dnz-records-en 1
86773 jaime-guerrero-katelyn-anymore-original-mix-power-tracks-records 1