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 (
    10734, 
    10735, 
    10736, 
    10737, 
    10738, 
    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, 
    9814, 
    9815, 
    9816, 
    9817, 
    9818, 
    15732, 
    9820, 
    9821, 
    9822, 
    9823, 
    9824, 
    9825, 
    9826, 
    9827, 
    9828, 
    9829, 
    9830, 
    10241, 
    10242, 
    10243, 
    10244, 
    10245, 
    10246, 
    10247, 
    10248, 
    10249, 
    10250, 
    10251, 
    10252, 
    10253, 
    10254, 
    10255, 
    10256, 
    10257, 
    10258, 
    10259, 
    10260, 
    10261, 
    10425, 
    10426, 
    10427, 
    10428, 
    10429, 
    10430, 
    10431, 
    10432, 
    10433, 
    10434, 
    10435, 
    10436, 
    10437, 
    10438, 
    10439, 
    10440, 
    10441, 
    10442, 
    10443, 
    10444, 
    10522, 
    9803, 
    9805, 
    9797, 
    9800, 
    9799, 
    9798, 
    9801, 
    9802, 
    9806, 
    9804, 
    9809, 
    9810, 
    9811, 
    9812, 
    9807, 
    9808, 
    9905, 
    10168, 
    10041, 
    10643, 
    10606, 
    10094, 
    10097, 
    12703, 
    10177, 
    10175, 
    9813
  ) 
  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.00253

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 (10734,10735,10736,10737,10738,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,9814,9815,9816,9817,9818,15732,9820,9821,9822,9823,9824,9825,9826,9827,9828,9829,9830,10241,10242,10243,10244,10245,10246,10247,10248,10249,10250,10251,10252,10253,10254,10255,10256,10257,10258,10259,10260,10261,10425,10426,10427,10428,10429,10430,10431,10432,10433,10434,10435,10436,10437,10438,10439,10440,10441,10442,10443,10444,10522,9803,9805,9797,9800,9799,9798,9801,9802,9806,9804,9809,9810,9811,9812,9807,9808,9905,10168,10041,10643,10606,10094,10097,12703,10177,10175,9813) 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
9797 generation-col-101 265/280/286/1614
9798 generation-col-107 265/280/286/1614
9799 generation-col-106 265/280/286/1614
9800 generation-col-105 265/280/286/1614
9801 generation-col-108 265/280/286/1614
9802 generation-col-109 265/280/286/1614
9803 generation-col-04 265/280/286/1614
9804 generation-col-110 265/280/286/1614
9805 generation-col-06 265/280/286/1614
9806 generation-col-11 265/280/286/1614
9807 generation-col-12 265/280/286/1614
9808 generation-col-13 265/280/286/1614
9809 generation-col-111 265/280/286/1614
9810 generation-col-112 265/280/286/1614
9811 generation-col-115 265/280/286/1614
9812 generation-col-116 265/280/286/1614
9813 kingsman-games-col-04 265/280/286/1666
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
9824 crush-col-11 265/280/286/1622
9825 crush-col-12 265/280/286/1622
9826 crush-col-13 265/280/286/1622
9827 crush-col-14 265/280/286/1622
9828 crush-col-15 265/280/286/1622
9829 crush-col-16 265/280/286/1622
9830 crush-col-17 265/280/286/1622
9905 kingsman-games-col-01 265/280/286/1666
10041 kingsman-col-01 265/280/286/1666
10094 kingsman-col-04 265/280/286/1666
10097 kingsman-col-05 265/280/286/1666
10168 kingsman-games-col-06 265/280/286/1666
10175 kingsman-games-col-03 265/280/286/1666
10177 kingsman-games-col-02 265/280/286/1666
10241 crush-col-18 265/280/286/1622
10242 crush-col-19 265/280/286/1622
10243 crush-col-20 265/280/286/1622
10244 crush-col-21 265/280/286/1622
10245 crush-col-22 265/280/286/1622
10246 crush-col-23 265/280/286/1622
10247 crush-col-24 265/280/286/1622
10248 crush-col-25 265/280/286/1622
10249 crush-col-26 265/280/286/1622
10250 crush-col-27 265/280/286/1622
10251 crush-col-28 265/280/286/1622
10252 crush-col-29 265/280/286/1622
10253 crush-col-30 265/280/286/1622
10254 crush-col-31 265/280/286/1622
10255 crush-col-32 265/280/286/1622
10256 crush-col-33 265/280/286/1622
10257 crush-col-34 265/280/286/1622
10258 crush-col-35 265/280/286/1622
10259 crush-col-36 265/280/286/1622
10260 crush-col-37 265/280/286/1622
10261 crush-col-38 265/280/286/1622
10425 fly-col-01 265/280/286/1651
10426 fly-col-02 265/280/286/1651
10427 fly-col-03 265/280/286/1651
10428 fly-col-04 265/280/286/1651
10429 fly-col-05 265/280/286/1651
10430 fly-col-06 265/280/286/1651
10431 fly-col-07 265/280/286/1651
10432 fly-col-08 265/280/286/1651
10433 fly-col-09 265/280/286/1651
10434 fly-col-10 265/280/286/1651
10435 fly-col-11 265/280/286/1651
10436 fly-col-12 265/280/286/1651
10437 fly-col-13 265/280/286/1651
10438 fly-col-14 265/280/286/1651
10439 fly-col-15 265/280/286/1651
10440 fly-col-16 265/280/286/1651
10441 fly-col-17 265/280/286/1651
10442 fly-col-18 265/280/286/1651
10443 fly-col-19 265/280/286/1651
10444 fly-col-20 265/280/286/1651
10522 fly-col-22 265/280/286/1651
10606 kingsman-col-03 265/280/286/1666
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
10643 kingsman-col-02 265/280/286/1666
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
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
12703 kingsman-col-06 265/280/286/1666
15732 crush-col-06 265/280/286/1622