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 (
    714, 10096, 9970, 552, 9841, 9870, 9969, 
    10967, 557, 10164, 716, 1016
  ) 
  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.00051

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
552 laine-de-verre-ursa-practic-42 737/902/1008
557 module-additionnel-de-capteurs-kla-300-pour-velux-active 737/973
714 fakro-transformateur-zz60h-dans-un-boitier-en-pvc 737/902/1008
716 commande-a-distance-pour-appareils-fakro 737/973
1016 cadre-mousse-isolant-pour-fenetres-de-toit-rooflite-et-dakea 737/971
9841 velux-solaire-store-rideau-enrouleur-rsl 737/902/1002
9870 canne-telescopique-pour-fenetres-ou-stores 737/902/1007
9969 fakro-detecteur-de-fumee-zfd-fr 737/973
9970 fakro-module-domotique-zwma1-fr 737/973
10096 velux-bfx-1000f-pour-raccordement-edj 737/971
10164 fenetre-de-toit-fakro-ftt-u-u8-thermo-fsc 737/967
10967 raccordement-pour-rooflite 737/972