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 (
    9984, 
    9985, 
    9986, 
    9987, 
    9988, 
    9989, 
    9990, 
    9991, 
    9992, 
    9993, 
    9994, 
    9995, 
    9996, 
    9997, 
    9998, 
    9999, 
    12995, 
    12996, 
    12997, 
    12998, 
    10734, 
    10735, 
    10736, 
    10737, 
    10738, 
    10747, 
    10748, 
    10749, 
    10750, 
    10751, 
    10752, 
    15744, 
    15745, 
    15746, 
    15743, 
    15738, 
    15739, 
    15740, 
    15741, 
    15742, 
    15736, 
    15737, 
    10668, 
    10669, 
    10670, 
    10671, 
    10672, 
    10673, 
    10674, 
    10675, 
    10676, 
    10677, 
    10678, 
    10679, 
    10680, 
    10681, 
    10682, 
    10683, 
    10684, 
    10685, 
    10686, 
    10607, 
    10608, 
    10609, 
    10610, 
    10611, 
    10612, 
    10613, 
    10614, 
    10615, 
    10616, 
    10617, 
    10618, 
    10619, 
    10620, 
    10621, 
    10622, 
    10623, 
    10624, 
    9685, 
    10653, 
    10646, 
    10645, 
    10647, 
    10648, 
    10649, 
    10726, 
    10650, 
    10547, 
    9789, 
    10655, 
    10654, 
    10605, 
    10604, 
    9873, 
    9972, 
    9973, 
    9975, 
    9976, 
    9977, 
    9978, 
    9979, 
    10179, 
    10180, 
    10523, 
    10073, 
    10077, 
    10076, 
    10086, 
    10085, 
    10084, 
    10083, 
    10082, 
    10081, 
    10080, 
    10079, 
    10584, 
    10594, 
    9814, 
    9815, 
    9816, 
    9817, 
    9818, 
    15732, 
    9820, 
    9821, 
    9822, 
    9823
  ) 
  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.00193

JSON explain

{
  "query_block": {
    "select_id": 1,
    "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": 256,
      "filtered": 100,
      "index_condition": "cscart_seo_names.object_id in (9984,9985,9986,9987,9988,9989,9990,9991,9992,9993,9994,9995,9996,9997,9998,9999,12995,12996,12997,12998,10734,10735,10736,10737,10738,10747,10748,10749,10750,10751,10752,15744,15745,15746,15743,15738,15739,15740,15741,15742,15736,15737,10668,10669,10670,10671,10672,10673,10674,10675,10676,10677,10678,10679,10680,10681,10682,10683,10684,10685,10686,10607,10608,10609,10610,10611,10612,10613,10614,10615,10616,10617,10618,10619,10620,10621,10622,10623,10624,9685,10653,10646,10645,10647,10648,10649,10726,10650,10547,9789,10655,10654,10605,10604,9873,9972,9973,9975,9976,9977,9978,9979,10179,10180,10523,10073,10077,10076,10086,10085,10084,10083,10082,10081,10080,10079,10584,10594,9814,9815,9816,9817,9818,15732,9820,9821,9822,9823) 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)"
    }
  }
}

Result

product_id seo_name seo_path
9685 brugge 265/273
9789 chalet-col-10 265/280/309/700
9814 crush-col-01 265/280/286/1622
9815 crush-col-02 265/280/286/1622
9816 crush-col-03 265/280/286/1622
9817 crush-col-04 265/280/286/1622
9818 crush-col-05 265/280/286/1622
9820 crush-col-07 265/280/286/1622
9821 crush-col-08 265/280/286/1622
9822 crush-col-09 265/280/286/1622
9823 crush-col-10 265/280/286/1622
9873 charisma-col-05 265/280/309/708
9972 continent-col-03 265/280/283/1641
9973 continent-col-04 265/280/283/1641
9975 continent-col-06 265/280/283/1641
9976 continent-col-07 265/280/283/1641
9977 continent-col-08 265/280/283/1641
9978 continent-col-09 265/280/283/1641
9979 continent-col-10 265/280/283/1641
9984 abitare-col-02-ru 265/280/283/1638
9985 abitare-col-03 265/280/283/1638
9986 abitare-col-04 265/280/283/1638
9987 abitare-col-05 265/280/283/1638
9988 abitare-col-06 265/280/283/1638
9989 abitare-col-07 265/280/283/1638
9990 abitare-col-08 265/280/283/1638
9991 abitare-col-09 265/280/283/1638
9992 abitare-col-10 265/280/283/1638
9993 abitare-col-11 265/280/283/1638
9994 abitare-col-12 265/280/283/1638
9995 abitare-col-13 265/280/283/1638
9996 abitare-col-14 265/280/283/1638
9997 abitare-col-15 265/280/283/1638
9998 abitare-col-16 265/280/283/1638
9999 abitare-col-17 265/280/283/1638
10073 cos-col-04 265/280/283/1674
10076 cos-col-06 265/280/283/1674
10077 cos-col-05 265/280/283/1674
10079 cos-col-14 265/280/283/1674
10080 cos-col-13 265/280/283/1674
10081 cos-col-12 265/280/283/1674
10082 cos-col-11 265/280/283/1674
10083 cos-col-10 265/280/283/1674
10084 cos-col-09 265/280/283/1674
10085 cos-col-08 265/280/283/1674
10086 cos-col-07 265/280/283/1674
10179 cos-col-01 265/280/283/1674
10180 cos-col-02 265/280/283/1674
10523 cos-col-03 265/280/283/1674
10547 chalet-col-09 265/280/309/700
10584 cos-col-15 265/280/283/1674
10594 cos-col-16 265/280/283/1674
10604 charisma-col-04 265/280/309/708
10605 charisma-col-03 265/280/309/708
10607 borneo-col-01 265/280/286/1659
10608 borneo-col-02 265/280/286/1659
10609 borneo-col-03 265/280/286/1659
10610 borneo-col-04 265/280/286/1659
10611 borneo-col-05 265/280/286/1659
10612 borneo-col-06 265/280/286/1659
10613 borneo-col-07 265/280/286/1659
10614 borneo-col-08 265/280/286/1659
10615 borneo-col-09 265/280/286/1659
10616 borneo-col-10 265/280/286/1659
10617 borneo-col-11 265/280/286/1659
10618 borneo-col-12 265/280/286/1659
10619 borneo-col-13 265/280/286/1659
10620 borneo-col-14 265/280/286/1659
10621 borneo-col-15 265/280/286/1659
10622 borneo-col-16 265/280/286/1659
10623 borneo-col-17 265/280/286/1659
10624 borneo-col-18 265/280/286/1659
10645 chalet-col-03 265/280/309/700
10646 chalet-col-02 265/280/309/700
10647 chalet-col-04 265/280/309/700
10648 chalet-col-05 265/280/309/700
10649 chalet-col-06 265/280/309/700
10650 chalet-col-08 265/280/309/700
10653 chalet-col-01 265/280/309/700
10654 charisma-col-02 265/280/309/708
10655 charisma-col-01 265/280/309/708
10668 bora-bora-col-01 265/280/286/1661
10669 bora-bora-col-02 265/280/286/1661
10670 bora-bora-col-03 265/280/286/1661
10671 bora-bora-col-04 265/280/286/1661
10672 bora-bora-col-05 265/280/286/1661
10673 bora-bora-col-06 265/280/286/1661
10674 bora-bora-col-07 265/280/286/1661
10675 bora-bora-col-08 265/280/286/1661
10676 bora-bora-col-09 265/280/286/1661
10677 bora-bora-col-10 265/280/286/1661
10678 bora-bora-col-11 265/280/286/1661
10679 bora-bora-col-12 265/280/286/1661
10680 bora-bora-col-13 265/280/286/1661
10681 bora-bora-col-14 265/280/286/1661
10682 bora-bora-col-15 265/280/286/1661
10683 bora-bora-col-16 265/280/286/1661
10684 bora-bora-col-17 265/280/286/1661
10685 bora-bora-col-18 265/280/286/1661
10686 bora-bora-col-19 265/280/286/1661
10726 chalet-col-07 265/280/309/700
10734 angora-col-01 265/280/286/1665
10735 angora-col-02 265/280/286/1665
10736 angora-col-03 265/280/286/1665
10737 angora-col-04 265/280/286/1665
10738 angora-col-05 265/280/286/1665
10747 product-10747 265/280/283/1677
10748 product-10748 265/280/283/1677
10749 product-10749 265/280/283/1677
10750 product-10750 265/280/283/1677
10751 product-10751 265/280/283/1677
10752 product-10752 265/280/283/1677
12995 akcent-col-01 265/280/301
12996 akcent-col-02 265/280/301
12997 akcent-col-03 265/280/301
12998 akcent-col-04 265/280/301
15732 crush-col-06 265/280/286/1622
15736 baxter-col-10 265/280/370/1673
15737 baxter-col-11 265/280/370/1673
15738 baxter-col-05 265/280/370/1673
15739 baxter-col-06 265/280/301
15740 baxter-col-07 265/280/370/1673
15741 baxter-col-08 265/280/370/1673
15742 baxter-col-09 265/280/301
15743 baxter-col-04 265/280/370/1673
15744 baxter-col-01 265/280/370/1673
15745 baxter-col-02 265/280/370/1673
15746 baxter-col-03 265/280/370/1673