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 (
    430, 9470, 10705, 750, 10195, 426, 10670, 
    9457, 10157, 9938, 8862, 8860, 3322, 
    11485, 10960, 9845, 9853, 717, 9843, 
    10065, 10707, 478, 3325, 428, 3321, 
    10101, 10172, 8878, 514, 10070, 8295, 
    3315, 7353, 4939, 480, 3318, 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.00131

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_seo_names range PRIMARY,dispatch PRIMARY 210 96 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
426 fenetre-de-toit-pvc-skylight-premium-blanc 737/968
428 stores-occultants-pour-fenetres-de-toit-2 737/902/1001
430 fenetre-de-toit-optilight-b 737/967
478 store-pare-soleil-pour-velux 737/902/1005
480 volet-roulant-solaire-velux-ssl 737/902/1006
514 un-store-tamisant-economique-pour-fenetre-de-toit 737/902/1002
717 store-pare-soleil-pour-fenetre-de-toit-fakro-et-optilight 737/902/1005
750 fenetre-de-toit-pvc-optilight-tlp 737/967
3315 bdx-2000-velux 737/971
3318 store-pare-soleil-pour-fenetre-de-toit-dakea 737/902/1005
3319 store-pare-soleil-pour-fenetre-de-toit-balio 737/902/1005
3320 store-pare-soleil-pour-dakstra 737/902/1005
3321 store-occultant-pour-velux 737/902/1001
3322 store-occultant-pour-fakro-optilight 737/902/1001
3325 store-occultant-pour-fenetre-de-toit-dakstra-luminatec-ou-rooflite 737/902/1001
4939 store-occultant-fakro-arf 737/902/998
7353 fakro-stores-exterieurs-pare-soleil-amz 737/902/998
8295 moustiquaire-pour-fenetre-de-toit 737/902/1000
8860 fenetre-de-toit-velux-gzl-1051 737/966
8861 fenetre-de-toit-velux-gzl-b-1051 737/967
8862 fenetre-de-toit-velux-gll-1061 737/966
8878 fenetre-de-toit-velux-glu-0051-finition-everfinish-le-blanc-eternel 737/966
9457 rooflite-fenetre-de-toit-trio-pine 737/967
9470 fenetre-de-toit-optilight-vk 737/969
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
9938 collerette-de-sous-toiture 737/971
10063 clavier-mural-velux-integra-kli-31 737/973
10065 systeme-de-controle-velux-kux-110 737/973
10067 interface-repeteur-velux-integra-klf-200 737/973
10070 stores-exterieurs-pare-soleil-pour-skylight-skylight-premium-fenetre-de-toit 737/902/1005
10101 moteur-unique-velux-integra-kmg-100 737/973
10104 store-occultant-isolant-fakro-apf 737/902/998
10157 fenetre-skyfens-skylight-plus-termo 737/968
10172 fenetre-de-toit-velux-glu-0061 737/966
10195 fenetre-de-toit-en-pvc-optilight-tlp-confort-triple-vitrage 737/967
10201 fenetre-de-toit-fakro-ptp-v-u4 737/967
10670 fenetre-de-toit-skyfens-supro 737/968
10705 fenetres-de-toit-optilight-d-pro 737/967
10707 stores-occultants-pour-fenetres-de-toit 737/902/1001
10960 fenetre-de-toit-fakro-greenview-ptp-v-u41-abmx 737/967
11485 fenetre-de-toit-fakro-ftp-v-u41-apmx-greenview 737/964