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 (
    2826, 467, 468, 2591, 2827, 622, 664, 
    1227, 2828, 667, 2829, 2830, 1628, 669, 
    682, 1009, 1010, 2831, 2832
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'ru' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00103

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "26.61"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code",
        "company_id"
      ],
      "key_length": "210",
      "rows_examined_per_scan": 38,
      "rows_produced_per_join": 38,
      "filtered": "100.00",
      "index_condition": "((`zdrowy_db`.`cscart_seo_names`.`object_id` in (2826,467,468,2591,2827,622,664,1227,2828,667,2829,2830,1628,669,682,1009,1010,2831,2832)) and (`zdrowy_db`.`cscart_seo_names`.`type` = 'p') and (`zdrowy_db`.`cscart_seo_names`.`dispatch` = '') and (`zdrowy_db`.`cscart_seo_names`.`lang_code` = 'ru') and ((`zdrowy_db`.`cscart_seo_names`.`company_id` = 1) or (`zdrowy_db`.`cscart_seo_names`.`company_id` = 0)))",
      "cost_info": {
        "read_cost": "22.81",
        "eval_cost": "3.80",
        "prefix_cost": "26.61",
        "data_read_per_join": "64K"
      },
      "used_columns": [
        "name",
        "object_id",
        "company_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
467 vilki-10sht-77013 290/292
468 vilki-10sht-yud-0125 290/292
622 lozhki-stolovye-10sht-77012 290/292
664 nabor-v-dorogu-h50 290/292
667 nabor-nalivayka 290/292
669 nabor-standart-h40 290/292
682 nozhi-stolovye 290/292
1009 ryumki-kristal-100ml-6sht-77001 290/292
1010 ryumki-kristall-50ml.-6sht 290/292
1227 chashki-kofeynye-6sht-77004 290/292
1628 nabor-piknik-h40 290/292
2591 vilki-stolovye-18-sm-premium-nabor-10-sht-770474 290/292
2826 vilka-stolovaya-10-sht-nabor-vil-1-300 290/292
2827 lozhka-stolovaya-10-sht-nabor-na-veslah-1-200 290/292
2828 nabor-kofe-s-molokom-6-tar-d170-belyh-6-chash-kof-bel-kor-200-ml-6-lozh-chaynyh-6-salf-1-nozh 290/292
2829 nabor-piknik-tarelka-d205-6-sht-stakan-200-ml-6-sht-vilka-stolovaya-6-sht-1-40 290/292
2830 nabor-pirushka-tar-d205-stak-200-ml-stak-100-ml-vilka-salf-po-6-shtuk-i-1-nozh-stol-1-40 290/292
2831 stakan-100-ml-10-sht-nabor-po-pyatdesyat-1-250 290/292
2832 stakan-200-ml-belyy-prozrachnyy-10-sht-nabor-na-troih-1-140 290/292