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 (
    10012, 718, 9967, 9844, 710, 720, 9931, 
    9840, 719, 715, 10946, 9964
  ) 
  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.00102

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
710 fakro-clavier-mural-sans-fil-zrw7 737/973
715 clavier-mural-radio-fakro-zwl 737/973
718 module-domotique-fakro-zwma 737/973
719 module-meteo-fakro-zwmp 737/973
720 detecteur-de-vent-fakro-zwd 737/973
9840 velux-electrique-store-rideau-enrouleur-rml 737/902/1002
9844 velux-electrique-store-occultant-dml 737/902/1001
9931 fakro-store-occultant-arf-z-wave-commande-electrique 737/902/1001
9964 fakro-moteur-a-chaine-zws12-tension-dentree-15v-dc-fr 737/973
9967 fakro-limiteur-douverture-zbb-fr 737/971
10012 fakro-store-pare-soleil-electrique-amz-z-wave 737/902/1005
10946 edg-raccordement-pour-fenetres-de-toit-velux 737/972