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 (
    10402, 10599, 10710, 10084, 10377, 8925, 
    8510, 10407, 11236, 12236, 12237, 11235, 
    12159, 12158, 12238, 12235, 11421, 
    12801, 8952, 11418, 7845, 10036, 7520, 
    11983
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'uk' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00172

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_seo_names",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "dispatch"],
          "key": "PRIMARY",
          "key_length": "210",
          "used_key_parts": [
            "object_id",
            "type",
            "dispatch",
            "lang_code",
            "company_id"
          ],
          "rows": 48,
          "filtered": 100,
          "index_condition": "cscart_seo_names.object_id in (10402,10599,10710,10084,10377,8925,8510,10407,11236,12236,12237,11235,12159,12158,12238,12235,11421,12801,8952,11418,7845,10036,7520,11983) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'uk' and (cscart_seo_names.company_id = 1 or cscart_seo_names.company_id = 0)"
        }
      }
    ]
  }
}

Result

product_id seo_name seo_path
7520 okulyari-dlya-maystra-manikyuru-i-pedikyuru-sini 451/492
7845 metalizovani-nakleyki-dlya-nigtiv-54 406/672
8510 nakleyki-dlya-dizaynu-nigtiv-f548-chorni 385/386
8925 nakleyki-dlya-dizaynu-nigtiv-f547-chorni 385/386
8952 nakleyki-dlya-dizaynu-nigtiv-f220-chorni 406/672
10036 nakleyki-na-tipsi-1-list-165-sht-sini 451/523
10084 nakleyki-dlya-dizaynu-nigtiv-f306-bili 385/386
10377 nakleyki-dlya-dizaynu-nigtiv-f306-sriblo 385/386
10402 nakleyki-dlya-dizaynu-nigtiv-f213-bili 385/386
10407 nakleyki-dlya-dizaynu-nigtiv-f549-chorni 385/386
10599 nakleyki-dlya-dizaynu-nigtiv-f213-chorni 385/386
10710 nakleyki-dlya-dizaynu-nigtiv-f305-chorni 385/386
11235 nakleyki-dlya-dizaynu-sa-300 406/672
11236 nakleyki-dlya-dizaynu-sa-122 406/672
11418 nakleyki-dlya-dizaynu-cc-054 406/672
11421 nakleyki-dlya-dizaynu-cc-048 406/672
11983 pigment-neonovo-zhovtiy 385/463
12158 nakleyki-dlya-dizaynu-sa-471-uk 406/672
12159 nakleyki-dlya-dizaynu-sa-466-uk 406/672
12235 nakleyki-dlya-dizaynu-sa-578-uk 406/672
12236 nakleyki-dlya-dizaynu-sa-124-uk 406/672
12237 nakleyki-dlya-dizaynu-sa-125-uk 406/672
12238 nakleyki-dlya-dizaynu-sa-472-uk 406/672
12801 nakleyki-dlya-nigtiv-810 406/672