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 (
    62561, 62560, 62559, 62558, 62557, 62556, 
    62555, 62554, 62553, 62552, 62551, 
    62550, 62549, 62548, 62547, 62546, 
    62545, 62544, 62543, 62542
  ) 
  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.00052

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
62542 bounce-enforcerz-be-the-cure-dj-oskar-remix-lw-recordings 1
62543 s3rl-pika-girl-lfz-remix-lw-recordings 1
62544 clayfacer-fractals-original-mix-lw-recordings 1
62545 andrea-montorsi-religion-original-mix-lw-recordings 1
62546 rr-reject-tell-me-original-mix-lw-recordings 1
62547 scott-attrill-retro-17-original-mix-lw-recordings 1
62548 charlie-goddard-symphony-of-salvation-original-mix-lw-recordings 1
62549 munkjack-supreme-original-mix-lw-recordings 1
62550 stu-infinity-save-my-life-ganar-2016-remix-lw-recordings 1
62551 john-carr-i-ll-be-with-you-original-mix-lw-recordings 1
62552 rob-gasser-dead-end-dancefloor-original-mix-lw-recordings 1
62553 blooddropz-no-joke-original-mix-lw-recordings 1
62554 ng-rezonance-liberation-original-mix-lw-recordings 1
62555 dj-lote-when-it-s-dark-and-there-s-no-one-remix-b-lw-recordings 1
62556 ginex-assis-adri-rtd-running-original-mix-lw-recordings 1
62557 ip-looking-for-a-groove-original-mix-lw-recordings 1
62558 chris-fear-frikshon-turbo-generated-original-mix-lw-recordings 1
62559 haaradak-last-game-original-mix-lw-recordings 1
62560 scott-attrill-duckface-original-mix-lw-recordings 1
62561 dean-reid-beanbags-original-mix-lw-recordings 1