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 (
    112329, 112328, 112327, 112321, 112287, 
    112286, 112285, 112284, 112283, 112282, 
    112281, 112280, 112279, 112278, 112277, 
    112276, 112275, 112274, 112273, 112272
  ) 
  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.00033

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
112272 al-storm-rob-iyf-zoe-van-west-within-your-eyes-original-mix-24-7-hardcore-en 22
112273 footprintz-al-storm-love-you-forever-unreleased-2008-mix-24-7-hardcore 22
112274 sharkey-lisa-abbott-bonkers-anthem-al-storm-remix-24-7-hardcore 22
112275 al-storm-malaya-it-s-over-darren-styles-remix-24-7-hardcore 22
112276 bang-sailaway-al-storm-dj-seduction-remix-24-7-hardcore 22
112277 groove-coverage-poison-al-storm-remix-24-7-hardcore 22
112278 visa-al-storm-fly-away-al-storm-2008-mix-24-7-hardcore 22
112279 al-storm-marie-louise-wherever-i-go-original-mix-24-7-hardcore 22
112280 dj-seduction-al-storm-louder-orbit1-remix-24-7-hardcore 22
112281 al-storm-euphony-dj-fx-cat-knight-so-strong-original-mix-24-7-hardcore 22
112282 al-storm-jumpin-original-mix-24-7-hardcore-en 22
112283 al-storm-noisemaker-original-mix-24-7-hardcore 22
112284 al-storm-surrender-unreleased-htid-intro-mix-24-7-hardcore 22
112285 al-storm-everybody-in-the-club-original-mix-24-7-hardcore 22
112286 heaven-7-al-storm-your-the-feeling-mind-over-matter-mix-24-7-hardcore 22
112287 sy-al-storm-love-drug-original-mix-24-7-hardcore-en 22
112321 neurotek-excel-quantonium-neurotek-rework-neurotek-digital 22
112327 neurotek-excel-amok-thing-no-mc-mix-neurotek-digital 22
112328 neurotek-excel-feel-like-dancing-no-mc-mix-neurotek-digital 22
112329 neurotek-excel-inferniator-no-mc-mix-neurotek-digital 22