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 (
    9845, 9853, 9843, 478, 3321, 514, 8295, 
    480, 9851, 9842, 9849, 479
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'fr' 
  AND (
    cscart_seo_names.company_id = 3 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00055

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
478 store-pare-soleil-pour-velux 737/902/1005
479 volet-roulant-electrique-velux-sml 737/902/1006
480 volet-roulant-solaire-velux-ssl 737/902/1006
514 un-store-tamisant-economique-pour-fenetre-de-toit 737/902/1002
3321 store-occultant-pour-velux 737/902/1001
8295 moustiquaire-pour-fenetre-de-toit 737/902/1000
9842 velux-store-occultant-tamisant-dfd 737/902/1002
9843 velux-store-occultant-dkl 737/902/1001
9845 velux-solaire-store-occultant-dsl 737/902/814
9849 velux-sss-store-exterieur-occultant-a-energie-solaire-velux-pour-les-fenetres-de-toit 737/902/1005
9851 velux-store-plisse-occultant-isolant-fhc 737/902/1009
9853 velux-awning-blind-mhl-fr 737/902/1005