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 (
    12995, 
    12996, 
    12997, 
    12998, 
    10713, 
    10714, 
    10715, 
    10716, 
    10717, 
    10718, 
    10719, 
    10720, 
    10721, 
    10722, 
    10723, 
    10305, 
    10306, 
    10307, 
    10308, 
    10309, 
    10310, 
    10311, 
    10312, 
    12999, 
    13000, 
    13001, 
    13002, 
    13003, 
    13004, 
    13005, 
    13006, 
    13007, 
    13008, 
    13009, 
    13010, 
    13011, 
    13012, 
    9874, 
    9875, 
    9887, 
    9879, 
    9796, 
    9942, 
    9943, 
    9941, 
    9944, 
    10813, 
    10814, 
    10815, 
    10816, 
    10817, 
    10818, 
    10819, 
    10820, 
    10821, 
    10822, 
    10823, 
    10824, 
    10825, 
    10826, 
    10704, 
    10705, 
    10706, 
    10707, 
    10708, 
    10709, 
    10710, 
    10711, 
    10712, 
    10301, 
    10302, 
    10303, 
    10304, 
    9945, 
    10601, 
    9727, 
    9728, 
    9729, 
    9730, 
    9731, 
    9732, 
    9733, 
    10181, 
    9734, 
    9735, 
    9724, 
    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, 
    13013, 
    13014, 
    13015, 
    13016, 
    13017, 
    13018, 
    13019, 
    13020, 
    13021, 
    13022, 
    13023, 
    13024, 
    13025, 
    13026, 
    13027, 
    13028
  ) 
  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.00258

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 (12995,12996,12997,12998,10713,10714,10715,10716,10717,10718,10719,10720,10721,10722,10723,10305,10306,10307,10308,10309,10310,10311,10312,12999,13000,13001,13002,13003,13004,13005,13006,13007,13008,13009,13010,13011,13012,9874,9875,9887,9879,9796,9942,9943,9941,9944,10813,10814,10815,10816,10817,10818,10819,10820,10821,10822,10823,10824,10825,10826,10704,10705,10706,10707,10708,10709,10710,10711,10712,10301,10302,10303,10304,9945,10601,9727,9728,9729,9730,9731,9732,9733,10181,9734,9735,9724,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,13013,13014,13015,13016,13017,13018,13019,13020,13021,13022,13023,13024,13025,13026,13027,13028) 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
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
9796 empire-col-05 265/280/291/1672
9874 empire-col-01 265/280/291/1672
9875 empire-col-02 265/280/291/1672
9879 empire-col-04 265/280/291/1672
9887 empire-col-03 265/280/291/1672
9941 empire-col-08 265/280/291/1672
9942 empire-col-06 265/280/291/1672
9943 empire-col-07 265/280/291/1672
9944 empire-col-09 265/280/291/1672
9945 for-rest-col-01 265/280/291/1671
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
10305 devotion-col-01 265/280/291/1647
10306 devotion-col-02 265/280/291/1647
10307 devotion-col-03 265/280/291/1647
10308 devotion-col-04 265/280/291/1647
10309 devotion-col-05 265/280/291/1647
10310 devotion-col-06 265/280/291/1647
10311 devotion-col-07 265/280/291/1647
10312 devotion-col-08 265/280/291/1647
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
10601 for-rest-col-02 265/280/291/1671
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
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
10713 del-vento-col-01 265/280/291/1663
10714 del-vento-col-02 265/280/291/1663
10715 del-vento-col-03 265/280/291/1663
10716 del-vento-col-04 265/280/291/1663
10717 del-vento-col-05 265/280/291/1663
10718 del-vento-col-06 265/280/291/1663
10719 del-vento-col-07 265/280/291/1663
10720 del-vento-col-08 265/280/291/1663
10721 del-vento-col-09 265/280/291/1663
10722 del-vento-col-10 265/280/291/1663
10723 del-vento-col-11 265/280/291/1663
10813 empire-col-10 265/280/291/1672
10814 empire-col-11 265/280/291/1672
10815 empire-col-12 265/280/291/1672
10816 empire-col-13 265/280/291/1672
10817 empire-col-14 265/280/291/1672
10818 empire-col-15 265/280/291/1672
10819 empire-col-16 265/280/291/1672
10820 empire-col-17 265/280/291/1672
10821 empire-col-18 265/280/291/1672
10822 empire-col-19 265/280/291/1672
10823 empire-col-20 265/280/291/1672
10824 empire-col-21 265/280/291/1672
10825 empire-col-22 265/280/291/1672
10826 empire-col-23 265/280/291/1672
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
12999 divo-col-01 265/280/301
13000 divo-col-02 265/280/301
13001 divo-col-03 265/280/301
13002 divo-col-04 265/280/301
13003 divo-col-05 265/280/301
13004 divo-col-06 265/280/301
13005 divo-col-07 265/280/301
13006 divo-col-08 265/280/301
13007 divo-col-09 265/280/301
13008 divo-col-10 265/280/301
13009 divo-col-11 265/280/301
13010 divo-col-12 265/280/301
13011 divo-col-13 265/280/301
13012 divo-col-14 265/280/301
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