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 = 'en' 
  AND (
    cscart_seo_names.company_id = 1 
    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 ursa-df-42 412/897/975
557 sensor-kla-300 412/468
714 skylight-button-handle 412/897/975
716 remote-controllers-for-fakro-devices 412/468
1016 insulation-foam-collar-rooflite 412/947
9841 velux-solar-roller-blind-rsl 412/897/898
9870 pole-control-for-roof-windows-and-blinds 412/897/899
9969 fakro-smoke-detector-zfd 412/468
9970 fakro-adaptation-module-zwma1 412/468
10096 velux-bfx-1000f-for-flashing-edj 412/947
10164 fakro-roof-window-ftt-u-u8-thermo-fsc 412/432
10967 flashing-for-rooflite-de 412/461