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 (
    10177, 
    10175, 
    9813, 
    10095, 
    9904, 
    10178, 
    10644, 
    10093, 
    10096, 
    10167, 
    10525, 
    10526, 
    10527, 
    10528, 
    10529, 
    10530, 
    10531, 
    10532, 
    10533, 
    10534, 
    10535, 
    10536, 
    10537, 
    10538, 
    10539, 
    10540, 
    10541, 
    10542, 
    10524, 
    10543, 
    10544, 
    13013, 
    13014, 
    13015, 
    13016, 
    13017, 
    13018, 
    13019, 
    13020, 
    13021, 
    13022, 
    13023, 
    13024, 
    13025, 
    13026, 
    13027, 
    13028, 
    13029, 
    13030, 
    10688, 
    10727, 
    10728, 
    10729, 
    10730, 
    10731, 
    10732, 
    10733, 
    10313, 
    10314, 
    10315, 
    10316, 
    10317, 
    10318, 
    10319, 
    10320, 
    10321, 
    10322, 
    9690, 
    10106, 
    10105, 
    10104, 
    10103, 
    10206, 
    10209, 
    10216, 
    10203, 
    10204, 
    10205, 
    10207, 
    10208, 
    10210, 
    10211, 
    10212, 
    10213, 
    10214, 
    10215, 
    10217, 
    10218, 
    10219, 
    10220, 
    10221, 
    10222, 
    10323, 
    10324, 
    10325, 
    10326, 
    10327, 
    10328, 
    10329, 
    10330, 
    10331, 
    10332, 
    10333, 
    10334, 
    10335, 
    10336, 
    10337, 
    10338, 
    10339, 
    10340, 
    10341, 
    10342, 
    10778, 
    10779, 
    10780, 
    10781, 
    10782, 
    10783, 
    10784, 
    10785, 
    10786, 
    10787, 
    10788, 
    10789, 
    10790, 
    10791, 
    9688, 
    10792
  ) 
  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.00220

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 (10177,10175,9813,10095,9904,10178,10644,10093,10096,10167,10525,10526,10527,10528,10529,10530,10531,10532,10533,10534,10535,10536,10537,10538,10539,10540,10541,10542,10524,10543,10544,13013,13014,13015,13016,13017,13018,13019,13020,13021,13022,13023,13024,13025,13026,13027,13028,13029,13030,10688,10727,10728,10729,10730,10731,10732,10733,10313,10314,10315,10316,10317,10318,10319,10320,10321,10322,9690,10106,10105,10104,10103,10206,10209,10216,10203,10204,10205,10207,10208,10210,10211,10212,10213,10214,10215,10217,10218,10219,10220,10221,10222,10323,10324,10325,10326,10327,10328,10329,10330,10331,10332,10333,10334,10335,10336,10337,10338,10339,10340,10341,10342,10778,10779,10780,10781,10782,10783,10784,10785,10786,10787,10788,10789,10790,10791,9688,10792) 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
9688 napoli 265/273
9690 malaga 265/273
9813 kingsman-games-col-04 265/280/286/1666
9904 kingsman-spy-col-01 265/280/286/1666
10093 kingsman-spy-col-04 265/280/286/1666
10095 kingsman-games-col-05 265/280/286/1666
10096 kingsman-spy-col-05 265/280/286/1666
10103 matisse-col-41 265/280/291/1618
10104 matisse-col-33 265/280/291/1618
10105 matisse-col-22 265/280/291/1618
10106 matisse-col-16 265/280/291/1618
10167 kingsman-spy-col-06 265/280/286/1666
10175 kingsman-games-col-03 265/280/286/1666
10177 kingsman-games-col-02 265/280/286/1666
10178 kingsman-spy-col-02 265/280/286/1666
10203 maverisk-col-01 265/280/370/1637
10204 maverisk-col-02 265/280/370/1637
10205 maverisk-col-03 265/280/370/1637
10206 maverick-col-04 265/280/370/1637
10207 maverisk-col-05 265/280/370/1637
10208 maverisk-col-06 265/280/370/1637
10209 maverick-col-07 265/280/370/1637
10210 maverisk-col-08 265/280/370/1637
10211 maverisk-col-09 265/280/370/1637
10212 maverisk-col-10 265/280/370/1637
10213 maverisk-col-11 265/280/370/1637
10214 maverisk-col-12 265/280/370/1637
10215 maverisk-col-13 265/280/370/1637
10216 maverick-col-14 265/280/370/1637
10217 maverisk-col-15 265/280/370/1637
10218 maverisk-col-16 265/280/370/1637
10219 maverisk-col-17 265/280/370/1637
10220 maverisk-col-18 265/280/370/1637
10221 maverisk-col-19 265/280/370/1637
10222 maverisk-col-20 265/280/370/1637
10313 magnifico-col-01 265/280/439/1643
10314 magnifico-col-02 265/280/439/1643
10315 magnifico-col-03 265/280/439/1643
10316 magnifico-col-04 265/280/439/1643
10317 magnifico-col-05 265/280/439/1643
10318 magnifico-plain-col-01 265/280/439/1643
10319 magnifico-plain-col-02 265/280/439/1643
10320 magnifico-plain-col-03 265/280/439/1643
10321 magnifico-plain-col-04 265/280/439/1643
10322 magnifico-plain-col-05 265/280/439/1643
10323 mechta-col-01 265/280/286/1648
10324 mechta-col-02 265/280/286/1648
10325 mechta-col-03 265/280/286/1648
10326 mechta-col-04 265/280/286/1648
10327 mechta-col-05 265/280/286/1648
10328 mechta-col-06 265/280/286/1648
10329 mechta-col-07 265/280/286/1648
10330 mechta-col-08 265/280/286/1648
10331 mechta-col-09 265/280/286/1648
10332 mechta-col-10 265/280/286/1648
10333 mechta-col-11 265/280/286/1648
10334 mechta-col-12 265/280/286/1648
10335 mechta-col-13 265/280/286/1648
10336 mechta-col-14 265/280/286/1648
10337 mechta-col-15 265/280/286/1648
10338 mechta-col-16 265/280/286/1648
10339 mechta-col-17 265/280/286/1648
10340 mechta-col-18 265/280/286/1648
10341 mechta-col-19 265/280/286/1648
10342 mechta-col-20 265/280/286/1648
10524 krasota-col-19 265/280/286/1657
10525 krasota-col-01 265/280/286/1657
10526 krasota-col-02 265/280/286/1657
10527 krasota-col-03 265/280/286/1657
10528 krasota-col-04 265/280/286/1657
10529 krasota-col-05 265/280/286/1657
10530 krasota-col-06 265/280/286/1657
10531 krasota-col-07 265/280/286/1657
10532 krasota-col-08 265/280/286/1657
10533 krasota-col-09 265/280/286/1657
10534 krasota-col-10 265/280/286/1657
10535 krasota-col-11 265/280/286/1657
10536 krasota-col-12 265/280/286/1657
10537 krasota-col-13 265/280/286/1657
10538 krasota-col-14 265/280/286/1657
10539 krasota-col-15 265/280/286/1657
10540 krasota-col-16 265/280/286/1657
10541 krasota-col-17 265/280/286/1657
10542 krasota-col-18 265/280/286/1657
10543 krasota-col-20 265/280/286/1657
10544 krasota-col-21 265/280/286/1657
10644 kingsman-spy-col-03 265/280/286/1666
10688 luna-col-01 265/280/439/1664
10727 luna-col-02 265/280/439/1664
10728 luna-col-03 265/280/439/1664
10729 luna-col-04 265/280/439/1664
10730 luna-col-05 265/280/439/1664
10731 luna-col-06 265/280/439/1664
10732 luna-col-07 265/280/439/1664
10733 luna-col-08 265/280/439/1664
10778 product-10778 265/280/283/1675
10779 product-10779 265/280/283/1675
10780 product-10780 265/280/283/1675
10781 product-10781 265/280/283/1675
10782 product-10782 265/280/283/1675
10783 product-10783 265/280/283/1675
10784 product-10784 265/280/283/1675
10785 product-10785 265/280/283/1675
10786 product-10786 265/280/283/1675
10787 product-10787 265/280/283/1675
10788 product-10788 265/280/283/1675
10789 product-10789 265/280/283/1675
10790 product-10790 265/280/283/1675
10791 product-10791 265/280/283/1675
10792 oasis-col-01 265/280/286/1676
13013 les-col-01 265/280/291/1683
13014 les-col-02 265/280/301
13015 les-col-03 265/280/291/1683
13016 les-col-04 265/280/291/1683
13017 les-col-05 265/280/291/1683
13018 les-col-06 265/280/291/1683
13019 les-col-07 265/280/291/1683
13020 les-col-08 265/280/291/1683
13021 les-col-09 265/280/291/1683
13022 les-plain-col-01 265/280/291/1683
13023 les-plain-col-02 265/280/291/1683
13024 les-plain-col-03 265/280/291/1683
13025 les-plain-col-04 265/280/291/1683
13026 les-plain-col-05 265/280/291/1683
13027 les-plain-col-06 265/280/291/1683
13028 les-plain-col-07 265/280/301
13029 les-plain-col-08 265/280/291/1683
13030 les-plain-col-09 265/280/291/1683