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 (
    100564, 100494, 100493, 100477, 100251, 
    100248, 100180, 99431, 99373, 93465, 
    100470, 100446, 100405, 100404, 100403, 
    100393, 100392, 100391, 100300, 100247
  ) 
  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
93465 max-amino-pump-the-funk-coffin-dodgers-remix-vicious-circle 6
99373 baseglitz-jay-key-people-just-do-drugs-k-zone-digital 6
99431 bryn-whiting-elle-mariachi-house-of-the-rising-sun-frantic-digital 6
100180 paul-clark-drugs-rock-n-roll-trip-the-light-fantastic 6
100247 nik-denton-m-series-phorever-people-m-series-remix-toolbox-recordings 6
100248 f1-dj-gonzalo-it-s-my-beat-daren-morris-remix-toolbox-recordings 6
100251 amp-attack-feel-good-paul-kings-trade-club-mix-wlhh 6
100300 unit-dvsn-dale-dean-funky-ass-beat-global-awakening-records 6
100391 alpha-a-in-hell-indecision-audio 6
100392 tara-n-do-you-wanna-dance-full-circle-productions 6
100393 lo-pan-supernatural-powers-emmanating-records 6
100403 problematic-the-kick-drum-fresh-slice-digital 6
100404 jud-roper-thunderclouds-black-dog-records 6
100405 boski-lads-lads-lads-black-dog-records 6
100446 darrell-white-dispersal-area-hi-five-digital 6
100470 base-graffiti-take-you-high-spinball-records 6
100477 base-graffiti-drop-kick-spinball-records 6
100493 dean-richardson-david-marsh-light-on-me-global-awakening-records 6
100494 gaz-f-miss-detonate-digital-mafia-three-days-apart-global-awakening-records 6
100564 mfs-dmf-back-to-the-sound-pulse-8-records 6