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 (
    69744, 70160, 70124, 70080, 69934, 70084, 
    70083, 70079, 70078, 69981, 69817, 
    69729, 69623, 70081, 69727, 69777, 
    69979, 69906, 69874, 69504, 69983, 
    68700, 69905, 69574, 69826, 69754, 
    69825, 69468, 69755, 69753, 69614, 
    69548, 68699, 69704, 69703, 69700, 
    69699, 69347, 69318, 69619
  ) 
  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.00070

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
68699 fur-taylor-west-ldn-inside-out-digital 6
68700 hornsby-flynn-this-right-here-inside-out-digital 6
69318 nick-e-twat-batter-original-mix-hot-box-digital 6
69347 mhx-the-hunter-original-mix-xtrahard-records 6
69468 matt-wade-gaz.p-headstrong-original-mix-hot-box-digital 6
69504 becki-boo-the-voices-unbounded-traxx 6
69548 tom-parr-baz-no-rules-premonition-digital 6
69574 matt-wade-miric-play-by-the-rules-d-fi-remix-hot-box-digital 6
69614 leeroy-overtime-original-mix-drop-bear-digital 6
69619 toffidge-no-onward-chain-fruition-records 6
69623 marc-lewis-shadow-people-original-mix-tuff-trax 6
69699 nikkdbubble-battered-digital-damage-recordings-en 6
69700 amp-attack-oh-fack-off-movin-house 6
69703 baseglitz-lnd-420-rekords 6
69704 riggsy-bad-omen-420-rekords 6
69727 burak-harsitlioglu-total-in-earth-original-mix-ahura-mazda-recordings-nitro 6
69729 strix-i-just-wanna-make-a-little-noize-original-mix-fatal-energy-records 6
69744 rick-james-cat-our-love-radio-edit-cheeky-tracks 6
69753 pez-surrender-original-mix-top-notch-digital 6
69754 kirk-p-falling-original-mix-digital-elements-recordings 6
69755 passion-bw-s-big-boogies 6
69777 todd-newell-ultimate-chakralege-toddslaw-korruption 6
69817 dramatik-i-gotcha-original-mix-drop-bear-digital 6
69825 d-boi-matt-clarkson-aye-laaa-tempo-trax 6
69826 random-but-raw-cramp-ya-style-fruition-records 6
69874 nick-e-psycho-pigeon-hooverweight-records 6
69905 nikkdbubble-filthy-kitten-mother-fish-horrible-people-digital-damage-recordings 6
69906 mumbles-jolene-glutton-for-punishment-premonition-digital 6
69934 matt-wade-pez-marc-coyne-exaltation-original-mix-hot-box-digital 6
69979 miss-detonate-gimme-gimmer-original-mix-top-notch-digital 6
69981 systemic-noise-believe-digital-elements-recordings 6
69983 jim-thomason-son-of-tron-flat-4-audio 6
70078 dark-society-adam-taylor-concepts-of-time-premonition-digital 6
70079 discam-be-strong-jeli-jams 6
70080 toryn-d-kashi-pero-pentathol-the-truth-pero-remix-mental-health-records 6
70081 thunderc-ts-trip-2-trancetown-thunderc-nts-original-mix-mental-health-records 6
70083 cupra-astro-dawn-bezerk 6
70084 gem-stone-the-spiller-raw-power 6
70124 nikkdbubble-trip-hazard-bad-day-digital-damage-recordings 6
70160 party-non-stop-movin-house 6