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 (
    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, 
    10323, 
    10324, 
    10325, 
    10326, 
    10327, 
    10328, 
    10329, 
    10330, 
    10331, 
    10332, 
    10333, 
    10334, 
    10335, 
    10336, 
    10337, 
    10338, 
    10339, 
    10340, 
    10341, 
    10342, 
    10792, 
    10793, 
    10794, 
    10795, 
    10796, 
    10797, 
    10798, 
    10799, 
    10800, 
    10801, 
    10802, 
    10803, 
    10804, 
    10805, 
    10806, 
    10807, 
    10808, 
    10809, 
    10810, 
    10811, 
    10812, 
    10827, 
    10828, 
    9839, 
    12702, 
    9841, 
    9848, 
    9840, 
    9844, 
    9843, 
    9846, 
    9845, 
    9860, 
    9859, 
    9858, 
    9857, 
    9852, 
    9861, 
    9862, 
    9847, 
    9863, 
    9856, 
    9855, 
    9838, 
    9849, 
    9850, 
    9853, 
    9842, 
    9851, 
    9854, 
    10263, 
    10264, 
    10265, 
    10266, 
    10267, 
    10268, 
    10269, 
    10270, 
    10271, 
    10272, 
    10273, 
    10478, 
    9883, 
    9901, 
    10493, 
    10485, 
    10476, 
    10479, 
    10494, 
    10492, 
    10468, 
    9903, 
    10487, 
    9899, 
    10473, 
    10486, 
    9881, 
    9896, 
    9892, 
    10481
  ) 
  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.00440

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 (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,10323,10324,10325,10326,10327,10328,10329,10330,10331,10332,10333,10334,10335,10336,10337,10338,10339,10340,10341,10342,10792,10793,10794,10795,10796,10797,10798,10799,10800,10801,10802,10803,10804,10805,10806,10807,10808,10809,10810,10811,10812,10827,10828,9839,12702,9841,9848,9840,9844,9843,9846,9845,9860,9859,9858,9857,9852,9861,9862,9847,9863,9856,9855,9838,9849,9850,9853,9842,9851,9854,10263,10264,10265,10266,10267,10268,10269,10270,10271,10272,10273,10478,9883,9901,10493,10485,10476,10479,10494,10492,10468,9903,10487,9899,10473,10486,9881,9896,9892,10481) 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
9838 gravitaciya-col-21 265/280/286/323
9839 gravitaciya-col-01 265/280/286/323
9840 gravitaciya-col-05 265/280/286/323
9841 gravitaciya-col-03 265/280/286/323
9842 gravitaciya-col-25 265/280/286/323
9843 gravitaciya-col-07 265/280/286/323
9844 gravitaciya-col-06 265/280/286/323
9845 gravitaciya-col-09 265/280/286/323
9846 gravitaciya-col-08 265/280/286/323
9847 gravitaciya-col-17 265/280/286/323
9848 gravitaciya-col-04 265/280/286/323
9849 gravitaciya-col-22 265/280/286/323
9850 gravitaciya-col-23 265/280/286/323
9851 gravitaciya-col-26 265/280/286/323
9852 gravitaciya-col-14 265/280/286/323
9853 gravitaciya-col-24 265/280/286/323
9854 gravitaciya-col-27 265/280/286/323
9855 gravitaciya-col-20 265/280/286/323
9856 gravitaciya-col-19 265/280/286/323
9857 gravitaciya-col-13 265/280/286/323
9858 gravitaciya-col-12 265/280/286/323
9859 gravitaciya-col-11 265/280/286/323
9860 gravitaciya-col-10 265/280/286/323
9861 gravitaciya-col-15 265/280/286/323
9862 gravitaciya-col-16 265/280/286/323
9863 gravitaciya-col-18 265/280/286/323
9881 romantika-zhemchuzhnyy-bereg-col-07 265/280/286/327
9883 romantika-aromatnaya-pudra-col-61 265/280/286/327
9892 romantika-zelenyy-chay-col-42 265/280/286/327
9896 romantika-zvezdnaya-noch-col-53 265/280/286/327
9899 romantika-dushistaya-lavanda-col-86 265/280/286/327
9901 romantika-barhatnyy-iris-col-98 265/280/286/327
9903 romantika-granatovyy-zakat-col-89 265/280/286/327
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
10167 kingsman-spy-col-06 265/280/286/1666
10178 kingsman-spy-col-02 265/280/286/1666
10263 gravitaciya-col-28 265/280/286/323
10264 gravitaciya-col-29 265/280/286/323
10265 gravitaciya-col-30 265/280/286/323
10266 gravitaciya-col-31 265/280/286/323
10267 gravitaciya-col-32 265/280/286/323
10268 gravitaciya-col-33 265/280/286/323
10269 gravitaciya-col-34 265/280/286/323
10270 gravitaciya-col-35 265/280/286/323
10271 gravitaciya-col-36 265/280/286/323
10272 gravitaciya-col-37 265/280/286/323
10273 gravitaciya-col-38 265/280/286/323
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
10468 romantika-gornye-vershiny-col-504 265/280/286/327
10473 romantika-dymchataya-orhideya-col-509 265/280/286/327
10476 romantika-bryzgi-priboya-col-512 265/280/286/327
10478 romantika-antichnaya-moneta-col-514 265/280/286/327
10479 romantika-vanilnyy-krem-col-515 265/280/286/327
10481 romantika-zybuchie-peski-col-517 265/280/286/327
10485 romantika-bodryaschiy-kofe-col-520 265/280/286/327
10486 romantika-zharenyy-kashtan-col-522 265/280/286/327
10487 romantika-dikiy-kiparis-col-523 265/280/286/327
10492 romantika-glubokoe-ozero-col-528 265/280/286/327
10493 romantika-blagorodnyy-sapfir-col-529 265/280/286/327
10494 romantika-virtualnoe-puteshestvie-col-530 265/280/286/327
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
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
10827 oasis-col-22 265/280/286/1676
10828 oasis-col-25 265/280/286/1676
12702 gravitaciya-col-02 265/280/286/323