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 (
    77577, 77576, 77575, 77574, 77573, 77572, 
    77571, 77570, 77569, 77568, 77567, 
    77566, 77565, 77564, 77563, 77562, 
    77561, 77560, 77559, 77558, 77557, 
    77556, 77555, 77554, 77553, 77552
  ) 
  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.00041

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

Result

product_id seo_name seo_path
77552 curve-pusher-tarpon-point-original-mix-hard-dance-coalition 4
77553 spice-boys-do-you-wanna-be-my-brother-original-mix-hard-dance-coalition 4
77554 wizard-i-want-ya-original-mix-hard-dance-coalition 4
77555 ben-stevens-music-is-my-life-original-mix-hard-dance-coalition 4
77556 shane-greene-i-wanna-dance-original-mix-hard-dance-coalition 4
77557 lusty-hilz-e-revenge-of-the-white-gloved-raver-original-mix-hard-dance-coalition 4
77558 wizard-people-on-the-floor-original-mix-hard-dance-coalition 4
77559 dave-owens-jess-gainzy-consuela-original-mix-hard-dance-coalition 4
77560 rattez-ben-stevens-essential-tremor-original-mix-hard-dance-coalition 4
77561 alf-graham-bring-me-to-life-original-mix-hard-dance-coalition 4
77562 hard-jeli-leighton-smith-believe-it-original-mix-hard-dance-coalition 4
77563 frank-farrell-late-mush-original-mix-hard-dance-coalition 4
77564 munkjack-often-imitated-never-duplicated-original-mix-hard-dance-coalition 4
77565 nik-denton-phorever-people-original-mix-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