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 (
    60624, 60623, 60622, 60621, 60620, 60619, 
    60618, 77578, 77577, 77576, 77575, 
    77574, 77573, 77572, 77571, 77570, 
    77569, 77568, 77567, 77566
  ) 
  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.00046

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_seo_names range PRIMARY,dispatch PRIMARY 210 40 Using where

Result

product_id seo_name seo_path
60618 vinylgroover-the-red-hed-the-answer-original-mix-hard-dance-coalition 4
60619 jez-charlie-it-s-about-music-original-mix-hard-dance-coalition-en 4
60620 od404-crash-guard-original-mix-hard-dance-coalition 4
60621 the-tom-tear-up-original-mix-hard-dance-coalition-en-2 4
60622 bk-it-s-just-a-feeling-cortina-mk2-remix-hard-dance-coalition 4
60623 chris-summers-diseased-raindrops-original-mix-hard-dance-coalition-en-2 4
60624 tony-heron-frank-farrell-match-point-technikal-remix-hard-dance-coalition 4
77566 disco-dubz-finally-original-mix-hard-dance-coalition 4
77567 curve-pusher-cupertino-original-mix-hard-dance-coalition 4
77568 leighton-smith-one-family-original-mix-hard-dance-coalition 4
77569 ben-stevens-tell-me-why-original-mix-hard-dance-coalition 4
77570 wizard-restless-dave-owens-remix-hard-dance-coalition 4
77571 ben-stevens-paul-maddox-give-me-sanctuary-original-mix-hard-dance-coalition 4
77572 curve-pusher-echelon-original-mix-hard-dance-coalition 4
77573 leighton-smith-feel-the-same-original-mix-hard-dance-coalition 4
77574 dave-owens-tonight-original-mix-hard-dance-coalition 4
77575 tony-heron-frank-farrell-match-point-original-mix-hard-dance-coalition 4
77576 matt-pickup-mini-minx-disco-fun-original-mix-hard-dance-coalition 4
77577 a-vs-b-gap-attack-original-mix-hard-dance-coalition 4
77578 hard-piano-anthems-vol.-1-hard-dance-coalition 13