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 (
    9861, 3520, 580, 8347, 1167, 3246, 1162, 
    1196, 1193, 1628, 583, 1159
  ) 
  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.00049

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
580 atlas-elastified-general-purpose-tile-adhesive-c1te-2-10-mm 257/280/372
583 atlas-plus-white-white-tile-adhesive-with-increased-flexibility-and-adhesion-c2tes1-2-10-mm 257/280/372
1159 schlitzkratzer-en 257/384/884
1162 dosenbohrer-en 257/384/884
1167 atlas-gips-solaris-manual-gypsum-plaster 257/280/518
1193 calcium-silicate-block-250x180x240mm-en 257/384/405
1196 calcium-silicate-block-pallet 257/384/405
1628 cellular-concrete-pallete 257/384/279
3246 atlas-elastyk-elastic-tile-adhesive-c2te-2-10-mm 257/280/372
3520 calcium-silicate-block-240x240x250mm 257/384/405
8347 atlas-plastering-mix-zt 257/280/510
9861 atlas-postar-10-quick-setting-cement-based-compound-10-100-mm 257/280/371