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 (
    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, 
    10713, 
    10714, 
    10715, 
    10716, 
    10717, 
    10718, 
    10719, 
    10720, 
    10721, 
    10722, 
    10723, 
    10739, 
    10740, 
    10741, 
    10742, 
    10305, 
    10306, 
    10307, 
    10308, 
    10309, 
    10310, 
    10311, 
    10312, 
    12999, 
    13000, 
    13001, 
    13002, 
    13003, 
    13004, 
    13005, 
    13006, 
    13007, 
    13008, 
    13009, 
    13010, 
    13011, 
    13012, 
    10759, 
    10760, 
    10761, 
    10762, 
    10763, 
    10764, 
    10765, 
    10766, 
    9874, 
    9875, 
    9887, 
    9879, 
    9796, 
    9942, 
    9943, 
    9941, 
    9944, 
    10813, 
    10814, 
    10815, 
    10816, 
    10817, 
    10818, 
    10819, 
    10820, 
    10821, 
    10822, 
    10823, 
    10824, 
    10825, 
    10826, 
    12969, 
    10144, 
    10145, 
    10146, 
    10147, 
    10148, 
    10149, 
    10150, 
    10151, 
    10152, 
    10293, 
    10294, 
    10295, 
    10724, 
    10725, 
    10343, 
    10345, 
    10346, 
    10347, 
    10348, 
    10349, 
    10350, 
    10351, 
    10352, 
    10353, 
    10354, 
    10355, 
    10356, 
    10357, 
    10358, 
    10359, 
    10360
  ) 
  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.00438

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 (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,10713,10714,10715,10716,10717,10718,10719,10720,10721,10722,10723,10739,10740,10741,10742,10305,10306,10307,10308,10309,10310,10311,10312,12999,13000,13001,13002,13003,13004,13005,13006,13007,13008,13009,13010,13011,13012,10759,10760,10761,10762,10763,10764,10765,10766,9874,9875,9887,9879,9796,9942,9943,9941,9944,10813,10814,10815,10816,10817,10818,10819,10820,10821,10822,10823,10824,10825,10826,12969,10144,10145,10146,10147,10148,10149,10150,10151,10152,10293,10294,10295,10724,10725,10343,10345,10346,10347,10348,10349,10350,10351,10352,10353,10354,10355,10356,10357,10358,10359,10360) 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
9796 empire-col-05 265/280/291/1672
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
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
10144 erwin-i-col-02 265/280/393/1151
10145 erwin-i-col-03 265/280/393/1151
10146 erwin-i-col-04 265/280/393/1151
10147 erwin-i-col-05 265/280/393/1151
10148 erwin-ii-col-01 265/280/393/1151
10149 erwin-ii-col-02 265/280/393/1151
10150 erwin-ii-col-03 265/280/393/1151
10151 erwin-ii-col-04 265/280/393/1151
10152 erwin-ii-col-05 265/280/393/1151
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
10293 esckimo-col-01 265/280/309/775
10294 esckimo-col-02 265/280/309/775
10295 esckimo-col-03 265/280/309/775
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
10343 excellence-col-01 265/280/442/1646
10345 excellence-col-03 265/280/442/1646
10346 excellence-col-04 265/280/442/1646
10347 excellence-col-05 265/280/442/1646
10348 excellence-col-06 265/280/442/1646
10349 excellence-col-07 265/280/442/1646
10350 excellence-col-08 265/280/442/1646
10351 excellence-col-09 265/280/442/1646
10352 excellence-col-10 265/280/442/1646
10353 excellence-col-11 265/280/442/1646
10354 excellence-col-12 265/280/442/1646
10355 excellence-col-13 265/280/442/1646
10356 excellence-col-14 265/280/442/1646
10357 excellence-col-15 265/280/442/1646
10358 excellence-col-16 265/280/442/1646
10359 excellence-col-17 265/280/442/1646
10360 excellence-col-18 265/280/442/1646
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
10724 esckimo-col-04 265/280/309/775
10725 esckimo-col-05 265/280/309/775
10739 desert-col-01 265/280/283/1669
10740 desert-col-02 265/280/283/1669
10741 desert-col-03 265/280/283/1669
10742 desert-plain 265/280/283/1669
10759 product-10759 265/280/283/1678
10760 product-10760 265/280/283/1678
10761 product-10761 265/280/283/1678
10762 dune-col-04 265/280/283/1678
10763 dune-col-05 265/280/283/1678
10764 dune-col-06 265/280/283/1678
10765 dune-col-07 265/280/283/1678
10766 dune-col-08 265/280/283/1678
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
12969 erwin-i-col-01 265/280/393/1151
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