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 (
    62636, 62635, 62634, 62633, 62632, 62631, 
    62630, 62629, 62628, 62627, 62626, 
    62625, 62611, 62609, 62607, 62569, 
    62456, 61887, 60269, 62370, 62342, 
    62098, 62097, 61770, 61769, 61704, 
    60784, 60268, 62217, 61403, 61442, 
    62055, 61886, 61768, 60787, 60267, 
    62105, 61512, 62019, 61960
  ) 
  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.00064

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
60267 adam-m-tenchy-mr-dynamite-hi-oktane 6
60268 adam-m-tenchy-fone-jacka-hi-oktane 6
60269 adam-m-tenchy-the-pill-monster-hi-oktane 6
60784 aaron-price-damaged-fireball 6
60787 craig-jones-chemical-generation-fireball 6
61403 ip-make-it-with-drums-hagane-shizuka-hardbass-like-it-s-06-remix-fatal-energy-records 6
61442 dale-west-4get-original-mix-devious-trax 6
61512 burak-harsitlioglu-wooden-table-original-mix-ahura-mazda-recordings-nitro 6
61704 mark-hard-dan-dyson-gotta-move-original-mix-drop-bear-digital 6
61768 rattez-ben-stevens-technical-warfare-vicious-circle 6
61769 andy-farley-paul-glazby-naughty-original-mix-vicious-circle 6
61770 andy-farley-paul-glazby-naughty-ground-zero-remix-vicious-circle 6
61886 steve-clack-sean-inside-out-eyes-open-premonition-digital 6
61887 marky-p-i-will-shut-that-sh-t-down-premonition-digital 6
61960 ross-homson-on-fleek-terrabang-recordings 6
62019 bk-tbf-everything-we-are-the-bounce-factory 6
62055 asylum-hallucinations-fruition-records 6
62097 mikey-snap-attack-radio-edit-cheeky-tracks 6
62098 mikey-snap-attack-original-mix-cheeky-tracks 6
62105 danny-gilligan-jwd-inside-out-digital 6
62217 hilly-i.o.u-supercharged 6
62342 danny-harris-changing-jeli-jams 6
62370 ross-baldwin-circles-original-mix-hard-west-records 6
62456 insidious-killawatt-bedroom-raver-original-mix-top-notch-digital 6
62569 sean-inside-out-d-fi-mind-scatter-solid-state-digital 6
62607 matt-wade-pez-mad-as-cheeze-neverland-recordings 6
62609 marc-lewis-necessary-evil-tempo-trax 6
62611 boris-the-noss-shameless-inside-out-digital 6
62625 jp-jukesy-daley-what-you-got-left-nik-denton-twist-remix-toolbox-recordings 6
62626 hi-freak1c-kris-o-rourke-disfunktional-disco-pulse-fiction-disco-at-the-savoy-remix-toolbox-recordings-en 6
62627 pocock-you-ve-got-this-pulse-fiction-remix-toolbox-recordings-en 6
62628 trauma-fantastic-nik-denton-remix-toolbox-recordings-en 6
62629 pulse-fiction-electric-disco-toolbox-recordings-en 6
62630 nik-denton-kamishake-toolbox-recordings-en-2 6
62631 robbie-muir-94-nik-denton-remix-toolbox-recordings 6
62632 nik-denton-paul-king-sucka-ma-foo-toolbox-recordings-en 6
62633 rodi-style-dj-pseudo-pistol-packin-nik-denton-retro-trade-remix-toolbox-recordings 6
62634 nik-denton-freak-right-out-toolbox-recordings-en 6
62635 frank-farrell-pulse-fiction-mad-tarts-on-acid-toolbox-recordings 6
62636 nik-denton-fatal-abuse-toolbox-recordings-en 6