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 (
    63035, 63034, 63033, 63032, 63031, 63030, 
    63029, 63028, 63027, 63026, 63025, 
    63024, 63023, 63022, 63021, 62566, 
    62565, 62564, 62563, 62562
  ) 
  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.00033

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
62562 dj-sefo-zl-happy-run-instrument-mix-lw-recordings 1
62563 ultra-violence-far-away-ghda-remix-lw-recordings 1
62564 adam-taylor-charlie-goddard-gravity-original-mix-lw-recordings 1
62565 d-railed-face-off-hardclash-remix-lw-recordings 1
62566 hard-dance-anthems-vol.-06-lw-recordings 13
63021 djos-pumpkins-strenght-original-mix-lw-recordings 22
63022 dimitri-motofunk-comet-original-mix-lw-recordings 22
63023 mark-grandel-eating-ice-original-mix-lw-recordings 22
63024 stan-pedrov-tessereis-aktines-original-mix-lw-recordings 22
63025 mal-hombre-icharus-original-mix-lw-recordings 22
63026 marcello-perri-stay-awake-original-mix-lw-recordings 22
63027 tech-c-evolution-original-mix-lw-recordings 22
63028 steel-grooves-fsociety-original-mix-lw-recordings 22
63029 dj-udo-d-vision-original-mix-lw-recordings 22
63030 earth-control-room-demons-answer-original-mix-lw-recordings 22
63031 steel-grooves-sad-sickness-original-mix-lw-recordings 22
63032 overdriive-wild-beats-original-mix-lw-recordings 22
63033 fuma-funaky-blurred-mind-original-mix-lw-recordings 22
63034 the-third-d2-original-mix-lw-recordings 22
63035 timao-akkurat-original-mix-lw-recordings 22