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 (
    70121, 70812, 70727, 70339, 70697, 70696, 
    70695, 70694, 70640, 70600, 70584, 
    70539, 70432, 70357, 70587, 70586, 
    70583, 70579, 70537, 70493, 70120, 
    69978, 69977, 70358, 70462, 70459, 
    70458, 70433, 69982, 70435, 70434, 
    70362, 70015, 70014, 70235, 70234, 
    70161, 70119, 69980, 69745
  ) 
  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.00051

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
69745 rick-james-cat-our-love-original-mix-cheeky-tracks 6
69977 mikey-always-need-you-radio-edit-cheeky-tracks 6
69978 mikey-always-need-you-original-mix-cheeky-tracks 6
69980 jon-doe-d6-top-notch-digital 6
69982 matt-wade-andy-t-rock-your-body-up-and-down-digital-elements-recordings 6
70014 snoozy-alex-calver-a-few-seconds-original-mix-drop-bear-digital 6
70015 matt-wade-gaz.f-narcotica-original-mix-the-filth-foundry 6
70119 ultranova-one-last-time-fireball 6
70120 dark-matter-hoover-jam-fireball 6
70121 ultranova-major-rager-fireball 6
70161 matt-wade-pez-unreadable-premonition-digital 6
70234 dan-diamond-yo-dj-solid-state-digital 6
70235 matt-clarkson-it-s-a-dream-fruition-records 6
70339 rat-e-kiss-myself-original-mix-hot-box-digital 6
70357 damaged-gudz-boner-original-mix-the-filth-foundry 6
70358 random-but-raw-nikkdbubble-fuck-all-ya-toolbox-recordings 6
70362 danny-gilligan-come-with-me-inside-out-digital 6
70432 danny-clark-come-with-me-korruption 6
70433 random-but-raw-fired-up-fruition-records 6
70434 miss-adrenaline-only-your-lovin-420-rekords 6
70435 al-g-slim-boy-fat-420-rekords 6
70458 kevin-byrne-c4-to-the-floor-vicious-circle 6
70459 unknown-tdog-dubz-vol.-16-turtledog 6
70462 damaged-gudz-flump-weee-raw-power 6
70493 drake-liddell-man-hunt-premonition-digital 6
70537 d-fi-emma-nate-monster-original-remix-top-notch-digital 6
70539 neverumind-like-it-if-you-like-digital-elements-recordings 6
70579 dave-owens-hoedown-turtledog 6
70583 homzy-feelin-alive-tempo-trax 6
70584 danny-clark-bring-it-on-tempo-trax 6
70586 mark-heyes-delirious-raw-power 6
70587 mark-heyes-2crack-raw-power 6
70600 random-but-raw-luna-fruition-records 6
70640 mischief-duo-misunderstood-unbounded-traxx 6
70694 leighton-smith-4ever-jeli-jams 6
70695 unknown-tdog-dubz-vol.17-turtledog 6
70696 curve-pusher-queen-of-the-night-turtledog 6
70697 unknown-tdog-dubz-vol.18-turtledog 6
70727 mark-heyes-feel-the-filth-raw-power 6
70812 jolene-chambers-13-acid-tears-inside-out-digital 6