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 (
    95818, 95817, 95816, 95815, 95814, 95813, 
    95812, 95811, 95810, 95809, 95808, 
    95807, 95806, 95805, 95804, 95803, 
    95874, 95867, 95638, 95637
  ) 
  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
95637 dj-ivan-diaz-sue-sky-original-mix-power-tracks-records 1
95638 dj-ivan-diaz-sue-sky-alternative-mix-power-tracks-records 1
95803 robbie-teeze-heart-beat-faster-original-mix-hard-dance-coalition 1
95804 mark-hybridz-blow-my-mind-original-mix-hard-dance-coalition-en 1
95805 fluu-x-fluu-glitch-original-mix-hard-dance-coalition 1
95806 arran-t-the-future-original-mix-hard-dance-coalition-en 1
95807 scott-attrill-in-your-eyes-original-mix-hard-dance-coalition 1
95808 audox-max-mozart-full-control-original-mix-hard-dance-coalition 1
95809 cut-up-hit-it-original-mix-hard-dance-coalition-en 1
95810 andy-whitby-karlston-khaos-fire-original-mix-hard-dance-coalition 1
95811 andy-whitby-karlston-khaos-don-t-worry-original-mix-hard-dance-coalition-en 1
95812 scott-attrill-stingray-original-mix-hard-dance-coalition 1
95813 audox-no-need-too-run-original-mix-hard-dance-coalition 1
95814 andy-whitby-klubfiller-cally-gage-kyla-everything-s-alright-breeze-modulate-remix-hard-dance-coalition 1
95815 12-inch-thumpers-this-is-the-one-mobi-d-remix-hard-dance-coalition 1
95816 andy-whitby-mda-spherical-like-it-hard-original-mix-hard-dance-coalition 1
95817 jonzzo-get-together-original-mix-hard-dance-coalition 1
95818 12-inch-thumpers-respect-original-mix-hard-dance-coalition 1
95867 jaime-guerrero-you-i-original-mix-power-tracks-records 1
95874 garbie-project-shut-up-and-sleep-with-me-original-mix-dnz-records 1