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 (
    68835, 69400, 69349, 69324, 69291, 69257, 
    69256, 69255, 69123, 68831, 68697, 
    68696, 68879, 68906, 68576, 69176, 
    69175, 69174, 69033, 67842, 69173, 
    69172, 69100, 69099, 69032, 69022, 
    68905, 68408, 68368, 68367, 68695, 
    68547, 68555, 68904, 68903, 68834, 
    68833, 68725, 68605, 68292
  ) 
  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.00081

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
67842 matt-pickup-myles-davies-invasion-vicious-circle 6
68292 psydef-magellan-original-mix-tuff-trax 6
68367 jamie-tennant-follow-you-radio-edit-cheeky-tracks 6
68368 jamie-tennant-follow-you-original-mix-cheeky-tracks 6
68408 matt-wade-pez-marc-coyne-switch-the-flip-original-mix-drop-bear-digital 6
68547 noath-never-know-original-mix-innervate-records 6
68555 pez-da-inside-original-mix-hot-box-digital 6
68576 vadermonkey-chesticles-original-mix-ultratech 6
68605 mark-hard-dan-dyson-onyx-hooverweight-records 6
68695 sean-inside-out-vandalize-been-there-done-that-inside-out-digital 6
68696 sean-inside-out-marc-lewis-been-there-done-that-inside-out-digital 6
68697 sean-inside-out-dean-drake-liddell-been-there-done-that-inside-out-digital 6
68725 random-but-raw-face-it-all-tempo-trax 6
68831 burak-harsitlioglu-to-be-or-got-to-be-original-mix-ahura-mazda-recordings-nitro 6
68833 craig-jones-wonky-horror-show-fireball 6
68834 slenderman-perfect-composure-fruition-records 6
68835 matt-wade-joe-swales-intagalactic-radio-edit-cheeky-tracks 6
68879 kirk-p-can-you-hear-the-sound-original-mix-hot-box-digital 6
68903 gem-stone-the-trip-raw-power 6
68904 gem-stone-tempted-raw-power 6
68905 gaz-f-neil-bee-vs-ben-stevens-cake-hole-premonition-digital 6
68906 toryn-d-kashi-pentathol-the-truth-mental-health-records 6
69022 james-price-aaron-james-beef-brisket-jeli-jams 6
69032 marc-lewis-chairman-meow-top-notch-digital-en 6
69033 digital-elements-collective-bassdrop-digital-elements-recordings 6
69099 al-g-everybody-s-lookin-420-rekords 6
69100 skol-woop-woop-dub-mix-420-rekords 6
69123 damaged-gudz-cheezy-bumbum-hooverweight-records-en 6
69172 dan-dyson-drum-beat-flow-digital-damage-recordings 6
69173 jud-roper-frank-farrell-gorra-get-off-flat-4-audio 6
69174 junction-33-ufo-slingshot 6
69175 matt-wade-pez-can-t-deny-you-solid-state-digital 6
69176 unknown-cookie-22-cookie 6
69255 g-mix-salva-g-premonition-digital 6
69256 mischief-duo-follow-me-unbounded-traxx 6
69257 asylum-tempo-tantrum-original-mix-top-notch-digital 6
69291 ram-rise-flat-4-audio 6
69324 g.s.r-ben-kaye-on-the-fence-jump-trax 6
69349 nikkdbubble-shut-the-fuk-up-digital-damage-recordings 6
69400 john-reilly-i-can-t-hold-it-tempo-trax 6