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 (
    10566, 10499, 10474, 10473, 10472, 10471, 
    31948, 10339, 10226, 10064, 10049, 
    8088, 6289, 4064, 3580, 3578, 3577, 
    6278, 6202, 3978
  ) 
  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.00055

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
3577 toms-project-party-time 4
3578 johnny-napalm-and-dynamic-intervention-back-to-the-funk-ingo-remix 4
3580 toms-project-mindblowing 4
3978 dont-stop-dancing-reset-mix 4
4064 mad-as-hell-original-mix 4
6202 dont-you-think-bounce-mix 4
6278 facejacked-original-mix 4
6289 the-ultimate-original-mix 4
8088 bounce-me-original-mix 4
10049 black-betty-original-mix-en 4
10064 outbreak-original-mix 4
10226 the-jam-charlie-bosh-bounce-mix 4
10339 feel-the-groove-edit 4
10471 rock-the-beat-original-mix-en 4
10472 tora-poky-original-mix 4
10473 bee-hive-rush-original-mix 4
10474 the-rave-flute-original-mix 4
10499 gates-of-eden-original-mix 4
10566 time-to-bounce-original-mix 4
31948 give-it-all-ya-got-original-mix-en 4