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 (
    33523, 33522, 33521, 33520, 33519, 33518, 
    33517, 33516, 33515, 33514, 33513, 
    33512, 33511, 33510, 33509
  ) 
  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.00056

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

Result

product_id seo_name seo_path
33509 i-need-to-know-original-mix-en-3 6
33510 alien-animal-original-mix 6
33511 im-your-nightmare-original-mix-en-3 6
33512 new-clear-war-fair-original-mix 6
33513 tortured-original-mix-en-3 6
33514 genetically-modified-original-mix-en-2 6
33515 beautiful-original-mix-en-5 6
33516 locked-up-original-mix-en 6
33517 paranoid-original-mix-en 6
33518 want-some-original-mix-en-2 6
33519 megatron-original-mix-en 6
33520 here-i-come-original-mix-en-3 6
33521 motherfucker-original-mix-en-3 6
33522 hostile-original-mix-en-4 6
33523 kick-it-original-mix-en-7 6