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 (
    101358, 101703, 101984, 101983, 101944, 
    101921, 101842, 101841, 101839, 101838, 
    101837, 101836, 101835, 101834, 101833, 
    101832, 101831, 101830, 101829, 101828
  ) 
  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.00043

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
101358 stormtrooper-sunflare-original-mix-rave-muzik 22
101703 sethrow-can-t-live-with-out-you-original-mix-dnz-records 22
101828 dj-storm-al-storm-boom-the-bomb-remix-records-mix-24-7-hardcore 22
101829 dj-storm-al-storm-darkzone-traffic-toonz-mix-24-7-hardcore 22
101830 dj-storm-al-storm-devastate-fallen-angel-alpha-project-mix-24-7-hardcore 22
101831 dj-storm-al-storm-kickin-hard-blatant-beats-mix-24-7-hardcore 22
101832 dj-storm-al-storm-ravers-choice-8.5-imagination-bonkers-6-mix-24-7-hardcore 22
101833 dj-storm-al-storm-devastate-reactor-dubplate-mix-24-7-hardcore 22
101834 dj-storm-al-storm-the-piano-track-raindance-mix-24-7-hardcore 22
101835 dj-storm-al-storm-funky-drums-blatant-beats-mix-24-7-hardcore 22
101836 dj-storm-al-storm-lisa-abbott-favourite-game-silk-cuts-mix-24-7-hardcore 22
101837 dj-s-unite-volume-1a-dj-storm-al-storm-remix-24-7-hardcore 22
101838 dougal-like-is-like-a-dance-al-storm-dj-storm-essential-platinum-mix-24-7-hardcore 22
101839 force-evolution-perfect-dreams-db-7-dj-storm-al-storm-two-mix-24-7-hardcore 22
101841 rob-iyf-never-realised-extended-mix-voodoo-panda 22
101842 rob-iyf-never-realised-radio-mix-voodoo-panda 22
101921 rob-iyf-never-realised-radio-mix-voodoo-panda-en 22
101944 trixy-sun-is-dark-original-mix-justice-hardcore 22
101983 chrono-chaotic-hostility-still-smoking-haze-original-mix-megarave-records 22
101984 chrono-smoke-haze-remastered-megarave-records 22