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 (
    125591, 125590, 125589, 125588, 125587, 
    125586, 125585, 125584, 125583, 125582, 
    125581, 125580, 125579, 125578, 125577, 
    125576, 125575, 125574, 125573, 125572
  ) 
  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.00040

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
125572 the-freak-brothers-ready-to-ride-extended-mix-tidy 4
125573 tony-de-vit-splashdown-ben-stevens-extended-remix-tidy 4
125574 big-tool-4-u-just-cum-extended-mix-tidy 4
125575 allnighters-black-is-black-ian-m-extended-remix-tidy 4
125576 nrg-never-lost-his-hardcore-baby-doc-97-extended-remix-tidy 4
125577 andy-farley-paul-glazby-naughty-ground-zero-extended-remix-tidy 4
125578 jon-doe-good-timez-karim-extended-remix-tidy 4
125579 paul-glazby-i-need-to-know-extended-mix-tidy 4
125580 paul-glazby-kanashimi-extended-mix-tidy 4
125581 trauma-salt-shake-extended-mix-tidy 4
125582 beatniqz-kick-it-bk-extended-remix-tidy-en 4
125583 captain-tinrib-sol-ray-attack-of-the-50ft-dj-extended-mix-tidy-en 4
125584 e-trax-let-s-rock-pants-corset-extended-remix-tidy 4
125585 trauma-what-ya-got-paul-glazby-extended-remix-tidy 4
125586 paul-glazby-want-some-extended-mix-tidy 4
125587 paul-maddox-karim-double-edged-sword-extended-mix-tidy-en 4
125588 paul-glazby-here-we-go-karim-extended-remix-tidy 4
125589 defective-audio-internal-drama-extended-mix-tidy-en-2 4
125590 tony-de-vit-are-you-all-ready-extended-mix-tidy 4
125591 harder-faster-vol-1-tidy 13