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 (
    437, 443, 439, 435, 1805, 1806, 434, 436, 
    10161, 504, 9865, 438
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'se' 
  AND (
    cscart_seo_names.company_id = 2 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00048

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
434 frigolit-cellplast-vagg-silver 258/273/274
435 frigolit-cellplast-vagg-gold 258/273/274
436 frigolit-cellplast-vagg-thermo 258/273/274
437 frigolit-cellplast-vagg-thermo-se 258/273/274
438 rockwool-frontrock-l-mineralull-foer-fasad 258/273/274
439 rockwool-frontrock-max-e-mineralull-foer-fasad 258/273/274
443 extuderad-polystyren-xps-30 258/276/383
504 atlas-uni-grunt-snabbtorkande-primer 257/280/372
1805 frigolit-cellplast-vagg-bas 258/273/274
1806 frigolit-cellplast-vagg-standard 258/273/274
9865 frigolit-cellplast-vagg-galaxy 258/273/274
10161 stenull-rockwool-frontrock-35-isolering-av-fasad 258/273/274