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 (
    10361, 
    10362, 
    10363, 
    10364, 
    10365, 
    10366, 
    10367, 
    10368, 
    10704, 
    10705, 
    10706, 
    10707, 
    10708, 
    10709, 
    10710, 
    10711, 
    10712, 
    10301, 
    10302, 
    10303, 
    10304, 
    10425, 
    10426, 
    10427, 
    10428, 
    10429, 
    10430, 
    10431, 
    10432, 
    10433, 
    10434, 
    10435, 
    10436, 
    10437, 
    10438, 
    10439, 
    10440, 
    10441, 
    10442, 
    10443, 
    10444, 
    10522, 
    9945, 
    10601, 
    9727, 
    9728, 
    9729, 
    9730, 
    9731, 
    9732, 
    9733, 
    10181, 
    9734, 
    9735, 
    9724, 
    9803, 
    9805, 
    9797, 
    9800, 
    9799, 
    9798, 
    9801, 
    9802, 
    9806, 
    9804, 
    9809, 
    9810, 
    9811, 
    9812, 
    9807, 
    9808, 
    9683, 
    10455, 
    10456, 
    10454, 
    10453, 
    10452, 
    10451, 
    10450, 
    10449, 
    10448, 
    10447, 
    12691, 
    12692, 
    12693, 
    12694, 
    12695, 
    12696, 
    12697, 
    12698, 
    12699, 
    10370, 
    10372, 
    10374, 
    10376, 
    10377, 
    10378, 
    10379, 
    10380, 
    10381, 
    10371, 
    10373, 
    10375, 
    10387, 
    10395, 
    10390, 
    10394, 
    10393, 
    10392, 
    10386, 
    10389, 
    10388, 
    10637, 
    10638, 
    10639, 
    10640, 
    10641, 
    10744, 
    10745, 
    10746, 
    9905, 
    10168, 
    10041, 
    10643, 
    10606, 
    10094, 
    10097, 
    12703
  ) 
  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.00531

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 (10361,10362,10363,10364,10365,10366,10367,10368,10704,10705,10706,10707,10708,10709,10710,10711,10712,10301,10302,10303,10304,10425,10426,10427,10428,10429,10430,10431,10432,10433,10434,10435,10436,10437,10438,10439,10440,10441,10442,10443,10444,10522,9945,10601,9727,9728,9729,9730,9731,9732,9733,10181,9734,9735,9724,9803,9805,9797,9800,9799,9798,9801,9802,9806,9804,9809,9810,9811,9812,9807,9808,9683,10455,10456,10454,10453,10452,10451,10450,10449,10448,10447,12691,12692,12693,12694,12695,12696,12697,12698,12699,10370,10372,10374,10376,10377,10378,10379,10380,10381,10371,10373,10375,10387,10395,10390,10394,10393,10392,10386,10389,10388,10637,10638,10639,10640,10641,10744,10745,10746,9905,10168,10041,10643,10606,10094,10097,12703) 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
9683 geneva 265/273
9724 for-rest-col-13 265/280/291/1671
9727 for-rest-col-03 265/280/291/1671
9728 for-rest-col-04 265/280/291/1671
9729 for-rest-col-05 265/280/291/1671
9730 for-rest-col-06 265/280/291/1671
9731 for-rest-col-07 265/280/291/1671
9732 for-rest-col-08 265/280/291/1671
9733 for-rest-col-09 265/280/291/1671
9734 for-rest-col-11 265/280/291/1671
9735 for-rest-col-12 265/280/291/1671
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
9905 kingsman-games-col-01 265/280/286/1666
9945 for-rest-col-01 265/280/291/1671
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
10181 for-rest-col-10 265/280/291/1671
10301 flashback-col-01 265/280/291/1644
10302 flashback-col-02 265/280/291/1644
10303 flashback-col-03 265/280/291/1644
10304 flashback-col-04 265/280/291/1644
10361 excellence-col-19 265/280/442/1646
10362 excellence-col-20 265/280/442/1646
10363 excellence-col-21 265/280/442/1646
10364 excellence-col-22 265/280/442/1646
10365 excellence-col-23 265/280/442/1646
10366 excellence-col-24 265/280/442/1646
10367 excellence-col-25 265/280/442/1646
10368 excellence-col-26 265/280/442/1646
10370 impulse-col-01 265/280/291/1652
10371 impulse-i-col-01 265/280/291/1652
10372 impulse-col-02 265/280/291/1652
10373 impulse-i-col-02 265/280/291/1652
10374 impulse-col-03 265/280/291/1652
10375 impulse-i-col-03 265/280/291/1652
10376 impulse-col-04 265/280/291/1652
10377 impulse-col-05 265/280/291/1652
10378 impulse-col-06 265/280/291/1652
10379 impulse-col-07 265/280/291/1652
10380 impulse-col-08 265/280/291/1652
10381 impulse-col-09 265/280/291/1652
10386 inspiration-plain-col-04 265/280/291/1650
10387 inspiration-col-03 265/280/291/1650
10388 inspiration-plain-col-06 265/280/291/1650
10389 inspiration-plain-col-05 265/280/291/1650
10390 inspiration-leave-col-02 265/280/291/1650
10392 inspiration-plain-col-03 265/280/291/1650
10393 inspiration-plain-col-02 265/280/291/1650
10394 inspiration-plain-col-01 265/280/291/1650
10395 inspiration-leave-col-01 265/280/291/1650
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
10447 graff-col-10 265/280/370/1656
10448 graff-col-09 265/280/370/1656
10449 graff-col-08 265/280/370/1656
10450 graff-col-07 265/280/370/1656
10451 graff-col-06 265/280/370/1656
10452 graff-col-05 265/280/370/1656
10453 graff-col-04 265/280/370/1656
10454 graff-col-03 265/280/370/1656
10455 graff-col-01 265/280/370/1656
10456 graff-col-02 265/280/370/1656
10522 fly-col-22 265/280/286/1651
10601 for-rest-col-02 265/280/291/1671
10606 kingsman-col-03 265/280/286/1666
10637 inspiration-plain-col-08 265/280/291/1650
10638 inspiration-plain-col-09 265/280/291/1650
10639 inspiration-plain-col-10 265/280/291/1650
10640 inspiration-plain-col-11 265/280/291/1650
10641 inspiration-plain-col-12 265/280/291/1650
10643 kingsman-col-02 265/280/286/1666
10704 flame-col-01 265/280/291/1662
10705 flame-col-02 265/280/291/1662
10706 flame-col-03 265/280/291/1662
10707 flame-col-04 265/280/291/1662
10708 flame-col-05 265/280/291/1662
10709 flame-col-06 265/280/291/1662
10710 flame-col-07 265/280/291/1662
10711 flame-col-08 265/280/291/1662
10712 flame-col-09 265/280/291/1662
10744 intellect-col-01 265/280/439/1668
10745 intellect-col-02 265/280/439/1668
10746 intellect-col-03 265/280/439/1668
12691 graff-col-11 265/280/370/1656
12692 graff-col-12 265/280/370/1656
12693 graff-col-13 265/280/370/1656
12694 graff-col-14 265/280/370/1656
12695 graff-col-15 265/280/370/1656
12696 graff-col-16 265/280/370/1656
12697 graff-col-17 265/280/370/1656
12698 graff-col-18 265/280/370/1656
12699 graff-col-19 265/280/370/1656
12703 kingsman-col-06 265/280/286/1666