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 (
    67841, 68817, 67790, 67789, 67788, 67787, 
    67786, 67785, 67784, 67783, 67782, 
    67781, 67780, 67779, 67778, 67777, 
    67776, 67775, 67774, 67773, 67772, 
    67771, 68694, 68693, 68661, 68532, 
    68124, 68123, 68692, 68662, 68573, 
    68531, 68374, 68361, 68199, 67871, 
    67844, 67843, 67840, 68201
  ) 
  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.00066

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
67771 jojo-ben-stevens-nothing-held-back-vicious-circle 6
67772 paul-glazby-rat-race-vicious-circle 6
67773 lucy-fur-lucy-in-the-sky-with-hoovers-grady-g-remix-vicious-circle 6
67774 rr-fierce-miloude-ben-stevens-remix-vicious-circle 6
67775 john-hardiman-early-learning-vicious-circle 6
67776 kirsty-lee-james-lucy-fur-escalator-vicious-circle 6
67777 matt-clarkson-jay-lowe-power-vicious-circle 6
67778 lucy-fur-discam-just-lose-it-vicious-circle 6
67779 discam-i-be-cookin-vicious-circle 6
67780 andy-farley-out-of-control-dyson-hilz-remix-vicious-circle 6
67781 gary-byrne-mortal-vicious-circle 6
67782 incisions-beyond-motion-vicious-circle 6
67783 trauma-fantastic-paul-king-s-twisted-t-remix-vicious-circle 6
67784 ben-stevens-funked-off-vicious-circle 6
67785 kirsty-lee-james-craig-lee-domestic-vicious-circle 6
67786 paul-glazby-adam-m-rough-n-tough-adam-m-remix-vicious-circle 6
67787 paul-maddox-ken-slater-reunion-vicious-circle 6
67788 paul-glazby-dynamic-intervention-locked-up-adam-m-remix-vicious-circle 6
67789 paul-glazby-motherfucker-vicious-circle 6
67790 paul-glazby-motherfucker-now-that-s-what-i-call-a-paul-glazby-remix-vicious-circle 6
67840 kirsty-walker-ryan-handley-hoovers-of-hell-vicious-circle 6
67841 jez-charlie-razors-edge-the-sticky-bandits-remix-vicious-circle 6
67843 nik-denton-derby-krunch-alf-graham-remix-toolbox-recordings 6
67844 nik-denton-freak-right-out-sean-inside-out-steve-clack-remix-toolbox-recordings 6
67871 dan-joseph-the-architect-fireball 6
68123 rick-james-general-bounce-can-t-have-you-radio-edit-cheeky-tracks 6
68124 rick-james-general-bounce-can-t-have-you-original-mix-cheeky-tracks 6
68199 asylum-whats-your-jam-dan-dyson-remix-drop-bear-digital 6
68201 one-foot-in-the-rave-take-you-back-tempo-trax 6
68361 slenderman-dead-fruition-records 6
68374 matt-wade-syanide-beatific-original-mix-hot-box-digital 6
68531 cupra-axis-slingshot 6
68532 drake-liddell-somebody-premonition-digital 6
68573 pluto-open-door-flat-4-audio 6
68661 paul-batten-ground-pound-original-mix-tuff-groove-recordings 6
68662 damien-blanes-mark-hard-lifting-up-unbounded-traxx 6
68692 leeroy-anthrax-orrible-noize 6
68693 random-but-raw-anna-k-time-to-be-bad-orrible-noize 6
68694 matt-wade-pez-party-blocker-inside-out-digital 6
68817 nikkdbubble-wide-awake-digital-damage-recordings 6