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 (
    66092, 66091, 66090, 66089, 66088, 66087, 
    66086, 66085, 66084, 66083, 66082, 
    66081, 66080, 66079, 66078, 66077, 
    66076, 66075, 66074, 66073, 66072, 
    66071, 66070, 66069, 66068, 66067, 
    66066, 66065, 66064, 66063
  ) 
  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.00055

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
66063 perfect-poise-busy-with-the-bass-original-mix-hard-dance-coalition 4
66064 wayne-smart-frantic-original-mix-hard-dance-coalition 4
66065 jojo-mumbles-jumbles-original-mix-hard-dance-coalition-en 4
66066 valex-helichopter-original-mix-hard-dance-coalition 4
66067 base-graffiti-domdevit-original-mix-hard-dance-coalition 4
66068 leon-allen-somewhere-anywhere-original-mix-hard-dance-coalition 4
66069 mumbles-dj-tony-k-infinity-original-mix-hard-dance-coalition 4
66070 ben-stevens-funked-off-original-mix-hard-dance-coalition-en-4 4
66071 defective-audio-omg-original-mix-hard-dance-coalition 4
66072 paul-glazby-motherfucker-hilly-remix-hard-dance-coalition 4
66073 rr-fierce-ta-mere-original-mix-hard-dance-coalition-en-3 4
66074 mischief-duo-dark-winter-original-mix-hard-dance-coalition 4
66075 aaron-james-matt-mara-bitch-kick-original-mix-hard-dance-coalition 4
66076 mike-taylor-aaron-langstaff-snatch-original-mix-hard-dance-coalition 4
66077 ben-stevens-adam-m-dave-neale-bean-machine-original-mix-hard-dance-coalition 4
66078 od404-x-press-hard-nrg-mix-hard-dance-coalition 4
66079 muzz-big-noddy-beat-of-the-kick-drum-wayne-smart-remix-hard-dance-coalition 4
66080 technikal-discam-damn-right-original-mix-hard-dance-coalition 4
66081 sam-townend-klubfiller-massive-banger-bk-s-gohard-remix-hard-dance-coalition 4
66082 mumbles-eyes-closed-original-mix-hard-dance-coalition-en 4
66083 bk-adam-m-like-this-original-mix-hard-dance-coalition-en-2 4
66084 defective-audio-shark-bait-part-2-original-mix-hard-dance-coalition 4
66085 forbidden-friends-balls-out-original-mix-hard-dance-coalition 4
66086 f1-motherfuckintwisted-ben-stevens-remix-hard-dance-coalition 4
66087 base-graffiti-bass-part-1-lucy-fur-remix-hard-dance-coalition 4
66088 wayne-german-bust-that-original-mix-hard-dance-coalition 4
66089 rr-fierce-this-is-original-mix-hard-dance-coalition-en 4
66090 boca-byrne-original-roughneck-original-mix-hard-dance-coalition-en 4
66091 defective-audio-bad-guy-smoked-original-mix-hard-dance-coalition-en-2 4
66092 andy-farley-valex-dr-dot-grady-g-remix-hard-dance-coalition 4