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 (
    10067, 9851, 3320, 9842, 10104, 10063, 
    407, 8861, 405, 10201, 3319, 9849
  ) 
  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.00059

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
405 stores-roulants-exterieurs-fakro-arz-h 737/902/1005
407 stores-roulants-exterieurs-fakro-arz-solar 737/902/1006
3319 store-pare-soleil-pour-fenetre-de-toit-balio 737/902/1005
3320 store-pare-soleil-pour-dakstra 737/902/1005
8861 fenetre-de-toit-velux-gzl-b-1051 737/967
9842 velux-store-occultant-tamisant-dfd 737/902/1002
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
10063 clavier-mural-velux-integra-kli-31 737/973
10067 interface-repeteur-velux-integra-klf-200 737/973
10104 store-occultant-isolant-fakro-apf 737/902/998
10201 fenetre-de-toit-fakro-ptp-v-u4 737/967