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 (
    13101, 
    12498, 
    12496, 
    12510, 
    12519, 
    12516, 
    12530, 
    12526, 
    12531, 
    12509, 
    12517, 
    12523, 
    12532, 
    12525, 
    12515, 
    12529, 
    12503, 
    13100, 
    12507, 
    12522, 
    12508, 
    12506, 
    12500, 
    12499, 
    12513, 
    12514, 
    13099, 
    12521, 
    12527, 
    12511, 
    12512, 
    12528, 
    12520, 
    12497, 
    12505, 
    12502, 
    12504, 
    10847, 
    13152, 
    10846, 
    10845, 
    10844, 
    10843, 
    10842, 
    10841, 
    10840, 
    10839, 
    10838, 
    10837, 
    10836, 
    10835, 
    10834, 
    10833, 
    10832, 
    10831, 
    10830, 
    10829, 
    10828, 
    10827, 
    12642, 
    12648, 
    12651, 
    12645, 
    12644, 
    12650, 
    12649, 
    12643, 
    12640, 
    12647, 
    15800, 
    12639, 
    12641, 
    12638, 
    12637, 
    12634, 
    12635, 
    12636, 
    12654, 
    12653, 
    12652, 
    12656, 
    12655, 
    12646, 
    12631, 
    12998, 
    12997, 
    12996, 
    12995, 
    10826, 
    10825, 
    10824, 
    10823, 
    10822, 
    10821, 
    10820, 
    10819, 
    10818, 
    10817, 
    10816, 
    10815, 
    10814, 
    10813, 
    13044, 
    13043, 
    13042, 
    13041, 
    13040, 
    13039, 
    13038, 
    13037, 
    13036, 
    13035, 
    13034, 
    13033, 
    13032, 
    13031, 
    13030, 
    13029, 
    13028, 
    13027, 
    13026, 
    13025, 
    13024, 
    13023, 
    13022, 
    13021, 
    13020, 
    13019
  ) 
  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.00268

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 (13101,12498,12496,12510,12519,12516,12530,12526,12531,12509,12517,12523,12532,12525,12515,12529,12503,13100,12507,12522,12508,12506,12500,12499,12513,12514,13099,12521,12527,12511,12512,12528,12520,12497,12505,12502,12504,10847,13152,10846,10845,10844,10843,10842,10841,10840,10839,10838,10837,10836,10835,10834,10833,10832,10831,10830,10829,10828,10827,12642,12648,12651,12645,12644,12650,12649,12643,12640,12647,15800,12639,12641,12638,12637,12634,12635,12636,12654,12653,12652,12656,12655,12646,12631,12998,12997,12996,12995,10826,10825,10824,10823,10822,10821,10820,10819,10818,10817,10816,10815,10814,10813,13044,13043,13042,13041,13040,13039,13038,13037,13036,13035,13034,13033,13032,13031,13030,13029,13028,13027,13026,13025,13024,13023,13022,13021,13020,13019) 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
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
10827 oasis-col-22 265/280/286/1676
10828 oasis-col-25 265/280/286/1676
10829 positiv-col-01 265/280/439/1685
10830 positiv-col-02 265/280/439/1685
10831 positiv-col-03 265/280/439/1685
10832 positiv-col-04 265/280/439/1685
10833 positiv-col-05 265/280/439/1685
10834 positiv-col-06 265/280/439/1685
10835 positiv-col-07 265/280/439/1685
10836 positiv-col-08 265/280/439/1685
10837 positiv-col-09 265/280/439/1685
10838 positiv-col-10 265/280/439/1685
10839 positiv-col-11 265/280/439/1685
10840 epoha-col-01 265/280/283/667
10841 epoha-col-02 265/280/283/667
10842 epoha-col-03 265/280/283/667
10843 epoha-col-04 265/280/283/667
10844 epoha-col-05 265/280/283/667
10845 epoha-col-06 265/280/283/667
10846 epoha-col-07 265/280/283/667
10847 epoha-col-08 265/280/283/667
12496 podushka-dekorativnaya-garmoniya-rogozhka-03-seryy-kant-30h50 265/271/275
12497 podushka-dekorativnaya-akcent-01-30h50 265/271/275
12498 podushka-dekorativnaya-krasota-17-chernyy-kant-30h50 265/271/275
12499 podushka-dekorativnaya-impulse-03-30x50 265/271/275
12500 podushka-dekorativnaya-impulse-03-50x50 265/271/275
12502 podushka-dekorativnaya-desert-02-30h50 265/271/275
12503 podushka-dekorativnaya-persona-11-45h45 265/271/275
12504 podushka-dekorativnaya-desert-01-30h50 265/271/275
12505 podushka-dekorativnaya-desert-03-30h50 265/271/275
12506 podushka-dekorativnaya-inspiration-plain-11-45h45 265/271/275
12507 podushka-dekorativnaya-krasota-17-cherno-belyy-kant-50h50 265/271/275
12508 podushka-dekorativnaya-krasota-12-50h50 265/271/275
12509 podushka-dekorativnaya-vista-03-chernyy-kant-50h50 265/271/275
12510 podushka-dekorativnaya-garmoniya-rogozhka-04-siniy-kant-30h50 265/271/275
12511 podushka-dekorativnaya-aurora-02-ryzhiy-kant-50h50 265/271/275
12512 podushka-dekorativnaya-akcent-02-50h50 265/271/275
12513 podushka-dekorativnaya-empire-21-belyy-kant-30h50 265/271/275
12514 podushka-dekorativnaya-divo-04-belyy-kant-50h50 265/271/275
12515 podushka-dekorativnaya-ribbon-02-chernyy-kant-50h50 265/271/275
12516 podushka-dekorativnaya-garmoniya-rogozhka-02-goluboy-kant-50h50 265/271/275
12517 podushka-dekorativnaya-vista-02-belyy-kant-50h50 265/271/275
12519 podushka-dekorativnaya-garmoniya-rogozhka-03-seryy-kant-50h50 265/271/275
12520 podushka-dekorativnaya-akcent-01-belyy-kant-50h50 265/271/275
12521 podushka-dekorativnaya-del-vento-01-30h50 265/271/275
12522 podushka-dekorativnaya-krasota-17-cherno-belyy-kant-30h50 265/271/275
12523 podushka-dekorativnaya-ribbon-03-chernyy-kant-50h50 265/271/275
12525 podushka-dekorativnaya-ribbon-03-belyy-kant-50h50 265/271/275
12526 podushka-dekorativnaya-vista-03-siniy-kant-30h50 265/271/275
12527 podushka-dekorativnaya-aurora-02-seryy-kant-30h50 265/271/275
12528 podushka-dekorativnaya-akcent-02-30h50 265/271/275
12529 podushka-dekorativnaya-ribbon-02-chernyy-kant-30h50 265/271/275
12530 podushka-dekorativnaya-garmoniya-rogozhka-02-goluboy-kant-30h50 265/271/275
12531 podushka-dekorativnaya-vista-02-goluboy-kant-30h50 265/271/275
12532 podushka-dekorativnaya-ribbon-03-chernyy-kant-30h50 265/271/275
12631 belgiyskiy-kover-topaz-160h230 265/266/267
12634 tureckiy-kover-bohem-ash-100x200 265/266/268
12635 tureckiy-kover-bohem-choco-100x200 265/266/270
12636 tureckiy-kover-bohem-carop-160h230 265/266/268
12637 tureckiy-kover-jakarta-vanila-100h200 265/266/270
12638 tureckiy-kover-bear-120x180 265/266/270
12639 tureckiy-kover-cat-120x180 265/266/267
12640 tureckiy-kover-games-120x180 265/266/267
12641 tureckiy-kover-lion-120x180 265/266/267
12642 tureckiy-kover-moon-120x180 265/266/270
12643 tureckiy-kover-rabbit-120x180 265/266/277
12644 tureckiy-kover-space-120x180 265/266/270
12645 tureckiy-kover-stars-120x180 265/266/267
12646 tureckiy-kover-stark-stripe-100x200 265/266/267
12647 tureckiy-kover-games-160x230 265/266/267
12648 tureckiy-kover-moon-160x230 265/266/270
12649 tureckiy-kover-rabbit-160x230 265/266/267
12650 tureckiy-kover-space-160x230 265/266/267
12651 tureckiy-kover-stars-160x230 265/266/267
12652 tureckiy-kover-stark-basket-100x200 265/266/267
12653 tureckiy-kover-stark-basket-160h230 265/266/267
12654 tureckiy-kover-stark-basket-200h290 265/266/270
12655 tureckiy-kover-stark-stripe-160x230 265/266/267
12656 tureckiy-kover-stark-stripe-200h290 265/266/267
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
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
13031 fantastika-col-01 265/280/301
13032 fantastika-col-02 265/280/301
13033 fantastika-col-03 265/280/301
13034 fantastika-col-04 265/280/301
13035 fantastika-col-05 265/280/301
13036 fantastika-col-06 265/280/301
13037 fantastika-col-07 265/280/301
13038 fantastika-col-08 265/280/301
13039 fantastika-col-09 265/280/301
13040 fantastika-col-10 265/280/301
13041 fantastika-col-11 265/280/301
13042 fantastika-col-12 265/280/301
13043 fantastika-col-13 265/280/301
13044 fantastika-col-14 265/280/301
13099 podushka-dekorativnaya-divo-04-belyy-kant-30h50 265/271/275
13100 podushka-dekorativnaya-les-01-30h50 265/271/275
13101 podushka-dekorativnaya-krasota-17-chernyy-kant-50h50 265/271/275
13152 epoha-col-08-ru 265/280/283/667
15800 tureckiy-kover-cat-160x230 265/266/277