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 (
    69618, 69616, 69615, 69459, 69449, 69401, 
    69350, 69507, 69506, 69505, 69503, 
    69447, 69410, 68998, 68698, 67810, 
    67809, 67808, 67807, 67806, 67805, 
    67804, 67803, 67802, 67801, 67800, 
    67799, 67798, 67797, 67796, 67795, 
    67794, 67793, 67792, 67791, 69107, 
    69432, 69348, 69005, 68836
  ) 
  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.00064

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
67791 paul-glazby-repentant-ben-stevens-remix-vicious-circle 6
67792 justin-bourne-dynamic-intervention-wayne-smart-work-it-wayne-smart-remix-vicious-circle 6
67793 lucy-fur-frank-farrell-acid-blowout-vicious-circle 6
67794 justin-bourne-rock-da-house-the-forbidden-remix-vicious-circle 6
67795 paul-king-ben-stevens-freak-the-funk-vicious-circle 6
67796 base-graffiti-bass-ep-part-1-lucy-fur-remix-vicious-circle 6
67797 hard-jeli-one-moment-vicious-circle 6
67798 mike-taylor-aaron-langstaff-snatch-vicious-circle 6
67799 paul-glazby-want-some-frank-farrell-remix-vicious-circle-en 6
67800 jody-6-then-it-drops-vicious-circle 6
67801 ben-stevens-batten-brow-swarm-batten-brown-remix-vicious-circle 6
67802 k1-hit-em-up-vicious-circle 6
67803 ken-slater-relentless-vicious-circle 6
67804 justin-charge-delorean-vicious-circle-en 6
67805 third-degree-gurns-jawsome-vicious-circle-en-2 6
67806 wayne-smart-hilly-up-to-no-good-vicious-circle 6
67807 tony-de-vit-are-you-all-ready-paul-king-remix-vicious-circle-en-2 6
67808 forbidden-friends-balls-out-vicious-circle-en-2 6
67809 hano-keepin-it-nasty-vicious-circle-en-2 6
67810 roosta-mumbles-on-ya-feet-vicious-circle-en-2 6
68698 emma-nate-half-a-monkey-sean-inside-out-black-gold-inside-out-digital 6
68836 matt-wade-joe-swales-intagalactic-original-mix-cheeky-tracks 6
68998 boris-the-noss-marky-p-korruption-korruption 6
69005 burak-harsitlioglu-reality-hurts-original-mix-ahura-mazda-recordings-nitro 6
69107 damaged-gudz-cock-culture-original-mix-hot-box-digital 6
69348 matt-wade-kaos-theory-digital-elements-recordings 6
69350 lee4real-poppyfields-original-mix-yeah-boi-recordings 6
69401 joe-swales-a-different-alternative-tempo-trax 6
69410 fabio-seramota-mel-found-you-premonition-digital 6
69432 tom-basquil-betelgeuse-hellstorm-trax 6
69447 miric-prime-top-notch-digital 6
69449 dark-by-design-fallen-heroes-arkett-spyndl-remix-immortal-noise-recordings 6
69459 miric-unleashed-digital-elements-recordings 6
69503 ben-stevens-damien-blanes-did-you-like-that-unbounded-traxx 6
69505 hard-jeli-dave-owens-la-chops-jeli-jams 6
69506 damaged-gudz-tosser-fruition-records 6
69507 damaged-gudz-nailed-that-fruition-records 6
69615 dan-dyson-april-foolz-hooverweight-records 6
69616 dan-dyson-on-da-rox-hooverweight-records 6
69618 team-sly-alf-graham-broken-bones-solid-state-digital 6