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 (
    66793, 66792, 66791, 66790, 66789, 67007, 
    66714, 66711, 66706, 66704, 66697, 
    66696, 66692, 66725, 66721, 66312, 
    66282, 66281, 66662, 66619, 66618, 
    66617, 66616, 66615, 66614, 66613, 
    66612, 66611, 66610, 66609, 66608, 
    66526, 66206, 66205, 66204, 66203, 
    66202, 66201, 66200, 66199
  ) 
  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.00046

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_seo_names range PRIMARY,dispatch PRIMARY 210 80 Using where

Result

product_id seo_name seo_path
66199 leeroy-dosing-up-original-mix-lw-recordings 4
66200 alf-graham-when-i-m-gone-original-mix-lw-recordings 4
66201 deadly-nightshade-take-me-there-original-mix-lw-recordings 4
66202 jay-pepper-not-glorious-original-mix-lw-recordings 4
66203 rich-resonate-boney-butt-original-mix-lw-recordings 4
66204 tim-clewz-jamie-haig-baloney-pony-original-mix-lw-recordings 4
66205 baseglitz-panik-original-mix-lw-recordings 4
66206 fabio-seramota-the-weapon-original-mix-lw-recordings 4
66281 sergio-m-g.party-original-mix-dance-solution 4
66282 sergio-m-g.party-dj-lara-rework-dance-solution 4
66312 mhx-bring-the-platform-original-mix-xtrahard-records 4
66526 jordi-bump-omg-original-mix-dnz-records 4
66608 raul-arribas-show-me-poky-original-mix-dnz-records-en 4
66609 gemeliyo-borja-qatja-slip-original-mix-dnz-records 4
66610 bounce-enforcerz-dj-oskar-my-house-handyman-remix-dnz-records-en 4
66611 dj-nillos-big-booty-original-mix-dnz-records-en 4
66612 jumpin-jack-the-most-annoyin-track-in-the-world-original-mix-dnz-records-en 4
66613 dj-navas-isaac-sanchez-pump-it-original-mix-dnz-records-en 4
66614 dj-oskar-i-love-hard-house-2-original-mix-dnz-records 4
66615 yannick-esquefa-raul-arribas-make-some-noise-original-mix-dnz-records-en 4
66616 pokytwins-dj-bass-over-heat-original-mix-dnz-records 4
66617 d3lta-maxin-relaxin-handyman-remix-dnz-records-en 4
66618 irra-dj-hammer-poky-original-mix-dnz-records-en 4
66619 dj-shetanckovik-dj-akiles-poky-selfie-original-mix-dnz-records-en 4
66662 isaac-sanchez-jaime-guerrero-sergio-caubal-hands-up-original-mix-power-tracks-records 4
66692 brian-theodore-original-gangsta-mke-original-mix-lw-recordings 4
66696 starman-dj-saber-nikki-a-feeling-joe-longbottom-leigh-d-remix-lw-recordings 4
66697 tom-parr-baz-bandit-original-mix-lw-recordings 4
66704 vadermonkey-laser-lips-original-mix-lw-recordings 4
66706 sean-inside-out-dale-west-i-dare-you-original-mix-lw-recordings 4
66711 bowie666-back-2-the-old-skool-original-mix-lw-recordings 4
66714 shaun-williams-house-work-original-mix-lw-recordings 4
66721 drake-liddell-master-d-original-mix-dnz-records 4
66725 the-lost-planets-you-aint-bounce-mix-dnz-records 4
66789 duck-cover-big-bad-bells-original-mix-cheeky-tracks-en 4
66790 pick-load-pumping-music-original-mix-cheeky-tracks-en 4
66791 duck-cover-what-a-night-original-mix-cheeky-tracks 4
66792 venkman-almost-famous-unreleased-version-cheeky-tracks 4
66793 mikey-snap-attack-original-mix-cheeky-tracks 4
67007 dj-nesket-dj-pascu-bassroom-original-mix-dnz-records 4