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 (
    9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 
    248
  ) 
  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.00041

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

Result

product_id seo_name seo_path
9 toshiba-42tl515u-42-class-1080p-3d-led-hd-tv 166/174/193
10 toshiba-47tl515u-47-class-1080p-3d-led-hd-tv 166/174/193
19 toshiba-bdx2150-blu-ray-player 166/174/194
21 toshiba-sd3300-dvd-player 166/174/194
48 ts-mr2040 166/175/186
49 ts-mr1640 166/175/186
50 ts-d1720c 166/175/186
51 ts-d6902r 166/175/186
54 ts-w3002d2d4 166/175/202
153 ur55-full-size-headphones 166/177/181
164 wb210-10mb-14-megapixel-slim-digital-camera-red 166/196/198
248 x-box-one 245/248