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 (
    3524, 9985, 10466, 9989, 10463, 10418, 
    10405, 10417, 10465, 10385, 10464, 
    10373
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en' 
  AND (
    cscart_seo_names.company_id = 2 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00335

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
3524 ash-milkshake-grande 386/396/397
9985 parquet-oak-askania-piccolo 386/396/397
9989 parquet-oak-nugat-piccolo 386/396/397
10373 parquet-oak-bright-piccolo 386/396/397
10385 parquet-oak-madeira-grande 386/396/397
10405 parquet-oak-salt-chevron-130 386/396/397
10417 parquet-oak-bright-chevron-130 386/396/397
10418 parquet-oak-trivor-chevron-130 386/396/397
10463 parquet-oak-serene-chevron-130 386/396/397
10464 parquet-oak-caramel-chevron-130 386/396/397
10465 parquet-oak-raisins-chevron-130 386/396/397
10466 parquet-oak-mainland-chevron-130 386/396/397