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 (
    59546, 59545, 59544, 59543, 59542, 59541, 
    59540, 59539, 59538, 59537, 59536, 
    59535, 59534, 59533, 59532, 59530, 
    59529, 59528, 59527, 59526
  ) 
  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.00045

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
59526 ben-stevens-the-warning-fireball 4
59527 ben-stevens-super-groover-fireball 4
59528 ben-stevens-bryan-doyle-chinook-marc-johnson-remix-fireball 4
59529 steve-maynard-slipped-disc-fireball 4
59530 ben-stevens-captain-tinrib-dirty-mushroom-fireball 4
59532 ben-stevens-defective-audio-radio-telescope-fireball 4
59533 ben-stevens-base-graffiti-signal-jam-fireball 4
59534 ben-stevens-frequency-response-fireball 4
59535 velos-the-joker-fireball 4
59536 ben-stevens-damage-narkotique-better-watch-out-fireball 4
59537 james-devlin-step-up-do-dat-dance-fireball 4
59538 ben-stevens-pwomp-it-up-fireball 4
59539 morgan-unstoppable-fireball 4
59540 jody-6-japanese-robot-girl-fireball 4
59541 morgan-take-you-back-fireball 4
59542 gaz-gibson-the-equaliser-fireball 4
59543 konekt-resonate-everyday-fireball 4
59544 pickup-rise-adam-m-something-like-this-fireball 4
59545 gary-o-connor-go-with-the-flow-fireball 4
59546 rodi-style-dr-device-what-da-fuck-fireball 4