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 (
    68534, 68533, 68459, 68363, 68362, 68360, 
    68358, 68357, 68135, 68065, 68064, 
    67902, 67896, 67685, 67684, 66983, 
    68359, 67955, 68319, 68312, 67848, 
    67845, 67839, 67686, 67683, 66841, 
    66840, 66839, 67958, 68200, 67770, 
    67769, 67768, 67767, 67766, 67765, 
    67764, 67763, 67762, 67761
  ) 
  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.00065

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
66839 tom-berry-jump-the-bounce-factory 6
66840 tom-berry-to-the-rythm-the-bounce-factory 6
66841 tom-berry-ransack-the-bounce-factory 6
66983 g-mix-smack-my-g-up-hooverweight-records 6
67683 trauma-kirsty-lee-james-the-hustler-vicious-circle 6
67684 trauma-matt-clarkson-give-in-vicious-circle 6
67685 trauma-nicholson-what-ya-gonna-do-vicious-circle 6
67686 trauma-high-dosage-what-you-feel-vicious-circle 6
67761 cupra-dangerous-bend-vicious-circle 6
67762 jody-6-vanilla-coke-vicious-circle 6
67763 lucy-fur-lucy-in-the-sky-with-hoovers-vicious-circle 6
67764 hilly-weekend-antics-vicious-circle 6
67765 rich-resonate-baddest-dj-vicious-circle 6
67766 paul-glazby-here-we-go-grady-g-remix-vicious-circle 6
67767 jez-charlie-razors-edge-kid-mosswah-random-but-raw-remix-vicious-circle 6
67768 mike-taylor-to-the-top-vicious-circle 6
67769 paul-glazby-alien-animal-gary-byrne-remix-vicious-circle 6
67770 ian-m-dirty-gaga-vicious-circle 6
67839 boris-the-noss-we-have-a-problem-vicious-circle 6
67845 darren-em-elliot-fletcher-that-hurt-fireball 6
67848 damaged-gudz-go-fuck-ya-self-original-mix-tuff-trax 6
67896 chaney-ridiculous-original-mix-tuff-trax 6
67902 strix-tiny-impulses-original-mix-fatal-energy-records 6
67955 matt-wade-miric-play-by-the-rules-original-mix-hot-box-digital 6
67958 burak-harsitlioglu-cube-5-original-mix-ahura-mazda-recordings-nitro 6
68064 alan-sharkey-evolved-radio-edit-cheeky-tracks 6
68065 alan-sharkey-evolved-original-mix-cheeky-tracks 6
68135 joe-longbottom-ben-diesel-snatch-my-pig-up-premonition-digital 6
68200 matt-clarkson-no-more-games-tempo-trax 6
68312 binty-feel-the-fire-burn-jeli-jams 6
68319 bry-randall-rude-b-tch-flat-4-audio 6
68357 damien-blanes-dave-owens-let-begin-frantic-digital 6
68358 dan-diamond-jamie-r-ad-molland-i-have-a-dream-the-bounce-factory 6
68359 si-stevens-nikkdbubble-hoover-tourettes-digital-damage-recordings 6
68360 d-fi-chucky-cut-me-loose-original-mix-top-notch-digital 6
68362 kelly-newbold-je-m-apelle-tupac-unbounded-traxx 6
68363 paul-king-bass-jumper-i-ll-be-there-4-u-solid-state-digital 6
68459 kumite-recycle-the-rush-bezerk 6
68533 damaged-gudz-hugs-not-drugs-420-rekords 6
68534 sean-inside-out-dale-west-mushroom-mountain-420-rekords 6