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 (
    101808, 101807, 101806, 101805, 101804, 
    101803, 101802, 101801, 101800, 101799, 
    101798, 101797, 101796, 101795, 101794, 
    101793, 101792, 101791, 101790, 101789, 
    101788, 101787, 101786, 101785, 101784, 
    101783, 101782, 101781, 101780, 101779
  ) 
  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.00048

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_seo_names range PRIMARY,dispatch PRIMARY 210 60 Using where

Result

product_id seo_name seo_path
101779 base-graffiti-funky-ass-wax-part-2-hard-dance-coalition-en 4
101780 defective-audio-reflux-original-mix-hard-dance-coalition 4
101781 little-jon-demons-original-mix-hard-dance-coalition-en 4
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
101802 the-pandemics-typhoid-original-mix-hard-dance-coalition 4
101803 eufex-jay-b-vaccum-packed-justin-bourne-dynamic-intervention-remix-hard-dance-coalition 4
101804 unknown-cookie-8-original-mix-hard-dance-coalition 4
101805 unknown-cookie-10-original-mix-hard-dance-coalition-en 4
101806 12-inch-thumpers-don-t-cross-the-line-paul-glazby-remix-hard-dance-coalition-en 4
101807 adam-m-sweat-box-original-mix-hard-dance-coalition-en 4
101808 paul-glazby-rougn-n-tough-adam-m-remix-hard-dance-coalition 4