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 (
    101801, 101800, 101799, 101798, 101797, 
    101796, 101795, 101794, 101793, 101792, 
    101791, 101790, 101789, 101788, 101787, 
    101786, 101785, 101784, 101783, 101782
  ) 
  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
101782 jp-jukesy-what-ya-got-left-original-mix-hard-dance-coalition 4
101783 phlash-frantic-theme-get-a-life-bk-s-classic-3am-at-frantic-mix-hard-dance-coalition-en 4
101784 wizard-databass-original-mix-hard-dance-coalition 4
101785 karim-ravers-delight-original-mix-hard-dance-coalition-en 4
101786 defective-audio-pure-energy-glazby-remix-hard-dance-coalition 4
101787 base-graffiti-bamzooki-original-mix-hard-dance-coalition 4
101788 masmada-repent-paul-glazby-remix-hard-dance-coalition 4
101789 daley-adz-alex-calver-more-drugs-original-mix-hard-dance-coalition 4
101790 gary-cooke-frank-farrell-etherwave-original-mix-hard-dance-coalition 4
101791 paul-glazby-here-we-go-original-mix-hard-dance-coalition 4
101792 leon-allen-stalker-original-mix-hard-dance-coalition 4
101793 jojo-gary-o-connor-where-s-the-hoover-original-mix-hard-dance-coalition 4
101794 12-inch-thumpers-3-turntables-paul-glazby-remix-hard-dance-coalition 4
101795 boca-byrne-beat-the-bass-original-mix-hard-dance-coalition 4
101796 henry-trotton-charlie-the-giant-hoover-original-mix-hard-dance-coalition 4
101797 aaron-james-silky-sounds-original-mix-hard-dance-coalition 4
101798 gary-byrne-eternal-hoover-original-mix-hard-dance-coalition-en-2 4
101799 leon-allen-victory-defeat-original-mix-hard-dance-coalition 4
101800 base-graffiti-the-hulk-original-mix-hard-dance-coalition-en-2 4
101801 karim-begonia-original-mix-hard-dance-coalition-en-2 4