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 (
    85113, 78852, 6427, 2237, 2236, 2235, 
    2231, 2233, 2232, 6665, 2227, 2230, 
    2228, 42056, 2225, 6642, 2226, 6457, 
    2223, 2222, 2211, 2221, 2220, 2217, 
    2216, 2214, 2213, 2212, 2218, 2219, 
    2194, 2210, 2209, 2208, 2207, 2206, 
    2205, 2204, 2203, 2202, 2201, 2200, 
    2199, 2198, 2197, 2196, 2195, 2193, 
    2192, 2191, 2190, 2189, 2188, 2187, 
    2186, 2185, 2184, 2183, 2182, 2181, 
    2180, 2179, 2178, 2177, 2176, 2175, 
    2174, 2173, 2172, 6881, 6880, 7042, 
    2170, 2169, 2171, 2167, 2168, 14349, 
    14348, 14345
  ) 
  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.00124

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

Result

product_id seo_name seo_path
2167 ben-townsend-and-james-taff-ballistic 4
2168 wizard-do-you-believe 4
2169 noo-noo-and-nogger-vs-james-taff-trashed-in-public 4
2170 adam-m-disco-shit-boca-byrne-remix 4
2171 equinox-get-up 4
2172 curve-pusher-particle-board 4
2173 dave-owens-chemical-attack-2006 4
2174 baseware-woo-a-licious 4
2175 dave-owens-maraschino 4
2176 baseware-boom 4
2177 dave-owens-octane 4
2178 curve-pusher-flux 4
2179 d.f.o.-resonance 4
2180 dave-owens-onr 4
2181 captain-tinrib-and-dave-owens-fishcake 4
2182 dave-owens-el-paso 4
2183 dave-owens-crisp-and-dry 4
2184 dave-owens-and-defective-audio-macademia 4
2185 phil-cogan-heavy-bass-dave-owens-vip-mix 4
2186 phil-cogan-heavy-bass-dave-owens-remix 4
2187 curve-pusher-echelon 4
2188 dave-owens-carbonara-en 4
2189 evo-d-and-maxwell-blowing-ecstacy-dave-owens-remix 4
2190 d.f.o.-resonance-valex-remix 4
2191 dave-owens-freezer-burn 4
2192 genkei-ham-radio 4
2193 dave-owens-cinnabon 4
2194 flymo-cashew-nut-shuffle-crunchy-peanut-butter-is-gross-mix 4
2195 michael-smith-and-dave-owens-captivate 4
2196 dave-owens-nandino 4
2197 lusty-and-bonzo-feel-good-curve-pusher-remix 4
2198 curve-pusher-protocol 4
2199 doaf-c90 4
2200 dave-owens-baked-not-fried 4
2201 curve-pusher-disco-dog 4
2202 baseware-inspired-by-candi 4
2203 baseware-dont-move-yet 4
2204 dave-owens-titan 4
2205 dave-owens-robot-hoover 4
2206 dave-owens-bob-b-q 4
2207 gazz-hunt-pussy-whipped-curve-pusher-remix 4
2208 dave-owens-cherokee 4
2209 curve-pusher-echelon-dave-owens-remix 4
2210 dave-owens-ai 4
2211 digital-mafia-and-josh-r-u-slicing-bread 4
2212 dave-curtis-fire-devil 4
2213 justin-bourne-and-lee-jeffries-drop-the-dime-lt1-and-riggsys-deathstar-mix 4
2214 lt1-tuff-talk 4
2216 chris-summers-make-a-wish 4
2217 manik-black-sun-rising 4
2218 james-taff-stage-4 4
2219 boneidol-vs-stone-and-hewitt-amnesia 4
2220 ben-stevens-and-adam-m-mind-bender 4
2221 gaz-gibson-starlight 4
2222 boca-and-gary-byrne-ready-4-more 4
2223 matt-mara-clean-like-sheen 4
2225 encoded-three-way 4
2226 dan-dyson-technoid 4
2227 rookie-and-reedy-rise 4
2228 dave-curtis-fire-devil-costa-patanzis-remix 4
2230 fran-dunne-boys-on-the-couch 4
2231 milze-queen-anns-revenge 4
2232 rodi-style-and-james-k-shake-and-bake 4
2233 riggsy-and-lefty-ode-to-stace 4
2235 marky-t-and-hilze-sour-sensation 4
2236 karl-davis-and-frank-farrell-goodtimes 4
2237 ian-fitzpatrick-everythings-alright 4
6427 on-da-floor-original-mix 4
6457 twisted-evil-2009-original-mix 4
6642 kinetic-original-mix 4
6665 i-cant-help-it-charlie-bosh-remix 4
6880 hitman-original-mix 4
6881 hitman-ass-kicking-mix 4
7042 filthatronic-original-mix 4
14345 rock-the-beat-pickup-and-rise-vs-riggsy-rmx 4
14348 in-your-mind-original-mix 4
14349 motherfcker-original-mix-en 4
42056 wildfire-ghetto-blaster-sensual-soundz 4
78852 robbie-muir-buzz-tribute-original-mix-hard-drive 4
85113 robbie-muir-buzz-tribute-original-mix-tidy 4