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 (
    45227, 45226, 45225, 45224, 45223, 45222, 
    45221, 45220, 45219, 45218, 45217, 
    45216, 45215, 44881, 44880, 44879, 
    44878, 44877, 44876, 44875
  ) 
  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.00037

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
44875 dj-benchuscoro-go-radio-edit-lw-recordings 1
44876 pain-disorder-project-houston-we-are-ready-for-take-off-da-productor-remix-lw-recordings 1
44877 alex-tr-infinity-original-mix-lw-recordings 1
44878 valex-4gotten-brendan-ashley-remix-lw-recordings 4
44879 sergio-caubal-isaac-sanchez-jaime-guerrero-nunu-get-naked-original-mix-lw-recordings 1
44880 cut-up-time-to-rock-original-mix-lw-recordings 1
44881 hard-dance-vol.-8-lw-recordings 13
45215 paul-elstak-firestone-blood-sweat-hardcore-the-beatkrusher-remix-lw-recordings 22
45216 srb-brainstabber-original-mix-lw-recordings 22
45217 hardcore-masterz-vienna-euphority-conquer-original-mix-lw-recordings 22
45218 e-noid-dx2r-srb-remix-lw-recordings 22
45219 dj-overdrive-little-fantasy-original-mix-lw-recordings 22
45220 jekyll-skoda-cool-kids-original-mix-lw-recordings 22
45221 ganar-true-original-mix-lw-recordings 22
45222 iyf-tripple-t-mc-gazy-j-never-change-original-mix-lw-recordings 22
45223 s3rl-catchit-dj-edit-lw-recordings 22
45224 bridson-allison-rhino-spunk-original-mix-lw-recordings 22
45225 freefall-now-i-let-them-go-original-mix-lw-recordings 22
45226 dope-d.o.d.-teddy-killerz-master-xploder-partyraiser-remix-lw-recordings 22
45227 gone-aura-original-mix-lw-recordings 22