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 (
    13018, 
    13017, 
    13016, 
    13015, 
    13014, 
    13013, 
    13012, 
    13011, 
    13010, 
    13009, 
    13008, 
    13007, 
    13006, 
    13005, 
    13004, 
    13003, 
    13002, 
    13001, 
    13000, 
    12999, 
    10812, 
    10811, 
    10810, 
    10809, 
    10808, 
    10807, 
    10806, 
    10805, 
    10804, 
    10803, 
    10802, 
    10801, 
    10800, 
    10799, 
    10798, 
    10797, 
    10796, 
    10795, 
    10794, 
    10793, 
    10792, 
    10791, 
    10790, 
    10789, 
    10788, 
    10787, 
    10786, 
    10785, 
    10784, 
    10783, 
    10782, 
    10781, 
    10780, 
    10779, 
    10778, 
    10777, 
    10776, 
    10775, 
    10774, 
    10773, 
    10772, 
    10771, 
    10770, 
    10769, 
    10768, 
    10767, 
    10766, 
    10765, 
    10764, 
    10763, 
    10762, 
    10761, 
    10760, 
    10759, 
    10758, 
    10757, 
    10756, 
    10755, 
    10754, 
    10753, 
    10752, 
    10751, 
    10750, 
    10749, 
    10748, 
    10747, 
    15736, 
    15737, 
    15738, 
    15739, 
    15740, 
    15741, 
    15742, 
    15743, 
    15745, 
    15746, 
    15744, 
    12632, 
    12633, 
    10179, 
    10180, 
    10523, 
    10073, 
    10077, 
    10076, 
    10086, 
    10085, 
    10084, 
    10083, 
    10082, 
    10081, 
    10080, 
    10079, 
    10584, 
    10594, 
    12574, 
    10168, 
    10167, 
    12703, 
    15968, 
    15938, 
    10053, 
    10041, 
    9904, 
    9905, 
    15966, 
    15965, 
    9940
  ) 
  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.00284

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 (13018,13017,13016,13015,13014,13013,13012,13011,13010,13009,13008,13007,13006,13005,13004,13003,13002,13001,13000,12999,10812,10811,10810,10809,10808,10807,10806,10805,10804,10803,10802,10801,10800,10799,10798,10797,10796,10795,10794,10793,10792,10791,10790,10789,10788,10787,10786,10785,10784,10783,10782,10781,10780,10779,10778,10777,10776,10775,10774,10773,10772,10771,10770,10769,10768,10767,10766,10765,10764,10763,10762,10761,10760,10759,10758,10757,10756,10755,10754,10753,10752,10751,10750,10749,10748,10747,15736,15737,15738,15739,15740,15741,15742,15743,15745,15746,15744,12632,12633,10179,10180,10523,10073,10077,10076,10086,10085,10084,10083,10082,10081,10080,10079,10584,10594,12574,10168,10167,12703,15968,15938,10053,10041,9904,9905,15966,15965,9940) 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
9904 kingsman-spy-col-01 265/280/286/1666
9905 kingsman-games-col-01 265/280/286/1666
9940 podushka-dekorativnaya-esckimo-05-30h50 265/271/275
10041 kingsman-col-01 265/280/286/1666
10053 product-10053 265/271/275
10073 cos-col-04 265/280/283/1674
10076 cos-col-06 265/280/283/1674
10077 cos-col-05 265/280/283/1674
10079 cos-col-14 265/280/283/1674
10080 cos-col-13 265/280/283/1674
10081 cos-col-12 265/280/283/1674
10082 cos-col-11 265/280/283/1674
10083 cos-col-10 265/280/283/1674
10084 cos-col-09 265/280/283/1674
10085 cos-col-08 265/280/283/1674
10086 cos-col-07 265/280/283/1674
10167 kingsman-spy-col-06 265/280/286/1666
10168 kingsman-games-col-06 265/280/286/1666
10179 cos-col-01 265/280/283/1674
10180 cos-col-02 265/280/283/1674
10523 cos-col-03 265/280/283/1674
10584 cos-col-15 265/280/283/1674
10594 cos-col-16 265/280/283/1674
10747 product-10747 265/280/283/1677
10748 product-10748 265/280/283/1677
10749 product-10749 265/280/283/1677
10750 product-10750 265/280/283/1677
10751 product-10751 265/280/283/1677
10752 product-10752 265/280/283/1677
10753 ribbon-col-01 265/280/291/1680
10754 ribbon-col-02 265/280/291/1680
10755 ribbon-col-03 265/280/291/1680
10756 vista-col-01 265/280/291/1679
10757 vista-col-02 265/280/291/1679
10758 vista-col-03 265/280/291/1679
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
10767 product-10767 265/280/283/1681
10768 product-10768 265/280/283/1681
10769 product-10769 265/280/283/1681
10770 product-10770 265/280/283/1681
10771 product-10771 265/280/283/1681
10772 product-10772 265/280/283/1681
10773 pafos-col-07 265/280/283/1681
10774 pafos-col-08 265/280/283/1681
10775 product-10775 265/280/283/1681
10776 product-10776 265/280/283/1681
10777 pafos-col-11 265/280/283/1681
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
10793 oasis-col-02 265/280/286/1676
10794 oasis-col-03 265/280/286/1676
10795 oasis-col-04 265/280/286/1676
10796 oasis-col-05 265/280/286/1676
10797 oasis-col-06 265/280/286/1676
10798 oasis-col-07 265/280/286/1676
10799 oasis-col-08 265/280/286/1676
10800 oasis-col-09 265/280/286/1676
10801 oasis-col-10 265/280/286/1676
10802 oasis-col-11 265/280/286/1676
10803 oasis-col-12 265/280/286/1676
10804 oasis-col-13 265/280/286/1676
10805 oasis-col-14 265/280/286/1676
10806 oasis-col-15 265/280/286/1676
10807 oasis-col-16 265/280/286/1676
10808 oasis-col-17 265/280/286/1676
10809 oasis-col-18 265/280/286/1676
10810 oasis-col-19 265/280/286/1676
10811 oasis-col-20 265/280/286/1676
10812 oasis-col-21 265/280/286/1676
12574 belgiyskiy-kover-florense-200x300 265/266/277
12632 belgiyskiy-kover-slab-200x300 265/266/277
12633 belgiyskiy-kover-air-200x300 265/266/277
12703 kingsman-col-06 265/280/286/1666
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
15736 baxter-col-10 265/280/370/1673
15737 baxter-col-11 265/280/370/1673
15738 baxter-col-05 265/280/370/1673
15739 baxter-col-06 265/280/301
15740 baxter-col-07 265/280/370/1673
15741 baxter-col-08 265/280/370/1673
15742 baxter-col-09 265/280/301
15743 baxter-col-04 265/280/370/1673
15744 baxter-col-01 265/280/370/1673
15745 baxter-col-02 265/280/370/1673
15746 baxter-col-03 265/280/370/1673
15938 komplekt-podushek-30 265/266/267
15965 komplekt-podushek-28 265/271/272
15966 komplekt-podushek-26 265/271/272
15968 komplekt-podushek-31 265/271/272