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 (
    45646, 45645, 45644, 45643, 45642, 45641, 
    45640, 45240, 45239, 45238, 45237, 
    45236, 45235, 45234, 45233, 45232, 
    45231, 45230, 45229, 45228
  ) 
  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.00046

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
45228 haze-givin-it-all-i-got-original-mix-lw-recordings 22
45229 scott-brown-al-storm-evilution-original-mix-lw-recordings 22
45230 phat-boyz-let-s-hear-it-original-mix-lw-recordings 22
45231 miss-special-k-dionne-i-missed-you-original-mix-lw-recordings 22
45232 noize-sfx-original-mix-lw-recordings 22
45233 anon-nothings-gonna-change-original-mix-lw-recordings 22
45234 jordi-k-stana-v-nax-from-me-original-mix-lw-recordings 22
45235 hyperforce-iyf-deanne-is-it-any-wonder-original-mix-lw-recordings 22
45236 para-italia-bad-ass-bass-original-mix-lw-recordings 22
45237 m-style-new-generation-original-mix-lw-recordings 22
45238 joey-riot-kris-kinetic-walking-on-the-moon-original-mix-lw-recordings 22
45239 sc-r-booming-track-original-mix-lw-recordings 22
45240 warehouse-anthems-hardcore-vol.-9-lw-recordings 13
45640 scott-attrill-boom-original-mix-lw-recordings 1
45641 trance-pennine-express-don-t-tell-me-ng-rezonance-remix-lw-recordings 3
45642 merz-walk-away-original-mix-lw-recordings 1
45643 hardforze-dbs-origins-ghda-remix-lw-recordings 3
45644 audio-hedz-alex-burn-technikal-turn-me-up-original-mix-lw-recordings 1
45645 perfect-poise-ultimate-adventure-original-mix-lw-recordings 3
45646 f2-f2-original-mix-lw-recordings 4