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 (
    14263, 14262, 8767, 8765, 8604, 8783, 
    14054, 14053, 14050, 79658, 79611, 
    79600, 79615, 79712, 79660, 79659, 
    79613, 79612, 14508, 14550
  ) 
  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
8604 rise-above-original-mix-en-2 4/29
8765 will-2-ill-original-mix-en-2-3 4/29
8767 rise-above-original-mix-en-2-3 4/29
8783 bounce-right-now-original-mix 4
14050 baddest-mutha-original-mix 21
14053 baddest-mutha-pin-up-remix 4
14054 baddest-mutha-ingo-remix 4
14262 higher-dark13s-very-high-remix 4
14263 move-your-body-dark13s-out-of-body-bootleg 4
14508 muzik-4-the-people-original-mix 4
14550 muzik-4-the-people-original-mix-en 4
79600 the-naughty-boyz-time-2-rock-original-mix-nrg-music 4
79611 the-naughty-boyz-amp-d-original-mix-nrg-music 4
79612 the-naughty-boyz-i-feel-love-original-mix-nrg-music 4
79613 the-naughty-boyz-i-feel-love-set-starter-mix-nrg-music 4
79615 the-naughty-boyz-the-theme-original-mix-nrg-music 4
79658 the-naughty-boyz-turn-up-the-bass-original-mix-nrg-music 4
79659 the-naughty-boyz-more-more-original-mix-nrg-music 4
79660 the-naughty-boyz-more-more-set-starter-mix-nrg-music 4
79712 the-naughty-boyz-9pm-original-mix-nrg-music 4