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 (
    110550, 110388, 110332, 110331, 110329, 
    110328, 110419, 110389, 110424, 110423, 
    110391, 110390, 110349, 110696, 110386, 
    110358, 110357, 110354, 110351, 110350
  ) 
  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.00050

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
110328 the-only-one-it-s-an-evil-original-mix-qdance-records-en 25
110329 the-only-one-get-your-sing-it-loud-original-mix-qdance-records-en 25
110331 comare-one-myself-original-mix-qdance-records-en 25
110332 the-only-one-dj-will-give-me-the-bangin-original-mix-qdance-records-en 25
110349 mysterioz-with-me-forever-original-mix-karmakontra-records 25
110350 lux3l-kroxy-call-for-you-radio-edit-karmakontra-records 25
110351 lux3l-kroxy-call-for-you-extended-karmakontra-records 25
110354 xetlar-new-world-original-mix-karmakontra-records 25
110357 subtraqx-take-control-radio-edit-karmakontra-records 25
110358 subtraqx-take-control-extended-karmakontra-records 25
110386 mixturez-with-you-original-mix-upcoming-records 25
110388 daniele-mondello-the-time-has-come-to-say-goodbye-extended-mix-infexious-origins 25
110389 genesiz-black-hole-original-mix-upcoming-records 25
110390 overage-l-scream-over-the-rage-radio-edit-karmakontra-records 25
110391 overage-l-scream-over-the-rage-extended-karmakontra-records 25
110419 assailant-valhalla-original-mix-scarred-digital 25
110423 refold-close-encounters-emceed-get-dissed-radio-edit-karmakontra-records 25
110424 refold-close-encounters-emceed-get-dissed-extended-karmakontra-records 25
110550 double-f-ect-kriminal-drop-brainkicker-re-kick-hbr-black 25
110696 jimmy-the-sound-ode-to-multigroove-extended-mix-hb-records 25