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 (
    69285, 69284, 69283, 69282, 69281, 69280, 
    69279, 69278, 69277, 69276, 69275, 
    69274, 69273, 69272, 69271, 69270, 
    69269, 69268, 69267, 69266, 69265, 
    69264, 69263, 69262, 69261, 69260, 
    69259, 69258, 69128, 68673, 68672, 
    68671, 68670, 68669, 68668, 69121, 
    68664, 68460, 68380, 68611
  ) 
  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.00072

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
68380 digital-mafia-dj-lolly-the-whistle-theme-original-mix-cheeky-tracks-en 4
68460 dj-dbc-coming-back-to-you-original-mix-dance-solution 4
68611 jumpin-jack-moving-with-the-best-original-mix-relay-records 4
68664 jue-be-magic-original-mix-relay-records 4
68668 starman-italo-bounce-big-girl-desires-radio-edit-cheeky-tracks 4
68669 starman-italo-bounce-heaven-radio-edit-cheeky-tracks 4
68670 starman-italo-bounce-boom-radio-edit-cheeky-tracks 4
68671 starman-italo-bounce-boom-original-mix-cheeky-tracks 4
68672 starman-italo-bounce-heaven-original-mix-cheeky-tracks 4
68673 starman-italo-bounce-big-girl-desires-original-mix-cheeky-tracks 4
69121 a-side-feel-the-piano-1-original-mix-relay-records 4
69128 cruse-control-unforgettable-original-mix-relay-records 4
69258 andy-farley-frank-farrell-pumpkin-head-original-mix-hard-dance-coalition 4
69259 frank-farrell-axle-sloth-original-mix-hard-dance-coalition 4
69260 andy-farley-frank-farrell-hung-up-original-mix-hard-dance-coalition 4
69261 paul-king-block-rockin-beats-frank-farrell-remix-hard-dance-coalition 4
69262 defamation-frank-farrell-hypnota-original-mix-hard-dance-coalition 4
69263 frank-farrell-bass-bomb-original-mix-hard-dance-coalition 4
69264 tony-heron-frank-farrell-match-point-original-mix-hard-dance-coalition-en 4
69265 richard-toomz-frank-farrell-strike-the-bank-original-mix-hard-dance-coalition 4
69266 frank-farrell-boomerang-original-mix-hard-dance-coalition 4
69267 nik-denton-frank-farrell-mad-tarts-on-acid-original-mix-hard-dance-coalition 4
69268 frank-farrell-captain-tinrib-get-lost-original-mix-hard-dance-coalition-en-2 4
69269 rodi-style-frank-farrell-frodi-says-relax-original-mix-hard-dance-coalition 4
69270 munkjack-dropped-the-ball-original-mix-hard-dance-coalition-en 4
69271 frank-farrell-dave-owens-manslap-original-mix-hard-dance-coalition 4
69272 ian-m-frank-farrell-stage-fright-original-mix-hard-dance-coalition 4
69273 frank-farrell-lash-accelerator-original-mix-hard-dance-coalition 4
69274 frank-farrell-root-boost-original-mix-hard-dance-coalition 4
69275 munkjack-hot-tamale-original-mix-hard-dance-coalition-en 4
69276 dng-frank-farrell-el-ranchito-original-mix-hard-dance-coalition 4
69277 andy-farley-frank-farrell-rupha-n-tupha-original-mix-hard-dance-coalition 4
69278 the-tom-frank-farrell-midnight-rush-original-mix-hard-dance-coalition 4
69279 frank-farrell-9-inch-shuffle-original-mix-hard-dance-coalition 4
69280 wgm-frank-farrell-precious-moments-joson-mix-hard-dance-coalition 4
69281 karim-frank-farrell-a-new-earth-original-mix-hard-dance-coalition-en 4
69282 adam-m-frank-farrell-sausage-nuts-original-mix-hard-dance-coalition-en-2 4
69283 frank-farrell-flycatcher-original-mix-hard-dance-coalition 4
69284 dustbin-barrell-crash-the-party-original-mix-hard-dance-coalition 4
69285 dion-devils-reject-frank-farrell-2008-remix-hard-dance-coalition 4