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 (
    13056, 13689, 13687, 13686, 13377, 12913, 
    12912, 13036, 12676, 12617, 12406, 
    12302, 12350, 12339, 12349, 12344, 
    12298, 18728, 18727, 12125
  ) 
  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.00047

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
12125 gangpoky-style-original-mix 4
12298 feel-the-groove-original-mix-en-2-3-4 4
12302 50-000-watts-2013-remix 4
12339 get-this-plane-original-mix 4
12344 work-original-mix 4
12349 beat-and-bass-original-mix 4
12350 mr.-poky-original-mix 4
12406 bricktop-original-mix 4
12617 peyas-original-mix 4
12676 on-facebook-original-mix 4
12912 the-melbourne-shuffle 4
12913 the-bouncer 4
13036 into-the-night-original-mix 4
13056 coming-original-mix 4
13377 hardhouse-baby-original-mix 4
13686 50-000-watts-original-mix-en 4
13687 attitude 4
13689 champion-sound 4
18727 revelation-dj-crazybass-remix 4
18728 kick-the-bass-dj-crazybass-remix 4