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 (
    64531, 63919, 63727, 64535, 64525, 64524, 
    64509, 64424, 64100, 64099, 63197, 
    64508, 64507, 64506, 64505, 64429, 
    64428, 64427, 64426, 64425, 64393, 
    64208, 63573, 63572, 61775, 61755, 
    64145, 64122, 64121, 64120, 61891, 
    64080, 64079, 63775, 63898, 63897, 
    63871, 63718, 63301, 63300
  ) 
  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.00068

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
61755 kris-o-rourke-replicant-fireball 6
61775 fabio-seramota-masterpiece-vicious-circle 6
61891 steve-thornton-resonator-premonition-digital 6
63197 dave-neale-parry-d-no-respect-toolbox-recordings 6
63300 brendan-ashley-dave-owens-carlton-john-carr-remix-cheeky-tracks 6
63301 brendan-ashley-dave-owens-carlton-vandalize-remix-cheeky-tracks 6
63572 groove-control-let-you-go-the-snail-remix-edit-cheeky-tracks 6
63573 groove-control-let-you-go-the-snail-remix-cheeky-tracks 6
63718 dave-owens-skyline-turtledog 6
63727 sam-alame-vadermonkey-bwerk-original-mix-ultratech 6
63775 mitch-doig-helmet-spectrum-trax 6
63871 valex-dave-owens-loco-land-bezerk 6
63897 boris-the-noss-transformers-jeli-jams 6
63898 addictive-tendancies-shake-that-inside-out-digital 6
63919 mischief-duo-chaos-disorder-unbounded-traxx 6
64079 delusion-delusion-10-delusion-en 6
64080 hilly-raw-procedure-supercharged 6
64099 craig-jones-she-mail-tim-clewz-remix-wlhh 6
64100 craig-jones-she-mail-wlhh-en-3 6
64120 matt-wade-gaz-f-back-beat-original-mix-top-notch-digital 6
64121 rick-james-gaz-f-jump-in-solid-state-digital 6
64122 d-fi-chucky-land-of-dreams-neverland-recordings 6
64145 bass-jumper-smiler-shelter-me-jump-trax 6
64208 random-but-raw-sinobe-palpable-shot-fruition-records-en 6
64393 dawn-lee-aria-helix-recordings 6
64424 delusion-delusion-7-delusion-en-2 6
64425 donald-trump-you-re-an-asshole-boscaland-recordings 6
64426 jon-the-dentist-imagination-2006-remix-boscaland-recordings 6
64427 the-culture-bryn-liedl-and-aaron-olson-remix-boscaland-recordings 6
64428 jon-the-dentist-like-this-boscaland-recordings 6
64429 jon-the-dentist-playa-sol-deep-remix-boscaland-recordings 6
64505 alan-sharkey-mob-money-tempo-trax 6
64506 jon-the-dentist-the-nightly-boscaland-recordings 6
64507 jon-the-dentist-sun-over-miami-boscaland-recordings 6
64508 jon-the-dentist-little-fluffy-clouds-boscaland-recordings 6
64509 james-k-ben-stevens-my-feeling-adrenaline-recordings 6
64524 barabas-and-od1-house-forever-boscaland-recordings 6
64525 jon-the-dentist-jeff-the-terminator-boscaland-recordings 6
64531 asylum-what-s-your-jam-original-mix-drop-bear-digital 6
64535 damaged-gudz-truffle-shuffle-digital-damage-recordings 6