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 (
    119395, 119394, 119393, 119392, 119391, 
    119390, 119389, 119388, 119387, 119386, 
    119385, 119384, 119383, 119382, 119381, 
    119380, 119379, 119378, 119377, 119376, 
    119375, 119374, 119373
  ) 
  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.00038

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_seo_names range PRIMARY,dispatch PRIMARY 210 46 Using where

Result

product_id seo_name seo_path
119373 tony-de-vit-burning-up-trade-extended-mix-tidy 4
119374 tony-de-vit-don-t-ever-stop-club-extended-mix-tidy 4
119375 tony-de-vit-nikki-mac-give-me-a-reason-trade-extended-mix-tidy 4
119376 tony-de-vit-higher-higher-trade-extended-mix-tidy 4
119377 tony-de-vit-get-loose-trade-extended-mix-tidy 4
119378 tony-de-vit-bring-the-beat-back-trade-extended-mix-tidy 4
119379 tony-de-vit-the-dawn-extended-tidy 4
119380 tony-de-vit-ufo-trade-extended-mix-tidy 4
119381 tony-de-vit-are-you-all-ready-extended-tidy 4
119382 tony-de-vit-resistance-is-futile-extended-tidy 4
119383 tony-de-vit-splashdown-extended-tidy 4
119384 tony-de-vit-to-the-limit-vocal-extended-mix-tidy 4
119385 tony-de-vit-i-don-t-care-trade-extended-mix-tidy 4
119386 tony-de-vit-nikki-mac-feel-my-love-don-t-go-away-eats-everything-s-big-organ-extended-remix-tidy 4
119387 tony-de-vit-nikki-mac-give-me-a-reason-morgan-seatree-extended-remix-tidy 4
119388 tony-de-vit-get-loose-airwolf-paradise-extended-remix-tidy 4
119389 tony-de-vit-burning-up-nicole-moudaber-extended-remix-tidy 4
119390 tony-de-vit-bring-the-beat-back-hannah-laing-extended-remix-tidy 4
119391 tony-de-vit-the-dawn-mark-sherry-extended-remix-tidy 3
119392 tony-de-vit-higher-higher-patrick-topping-extended-remix-tidy 4
119393 tony-de-vit-don-t-ever-stop-bk-extended-remix-tidy 4
119394 tony-de-vit-to-the-limit-alan-fitzpatrick-extended-remix-tidy 4
119395 tony-de-vit-i-don-t-care-absolute.-we-still-just-don-t-care-extended-remix-tidy 4