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 (
    10793, 
    10794, 
    10795, 
    10796, 
    10797, 
    10798, 
    10799, 
    10800, 
    10801, 
    10802, 
    10803, 
    10804, 
    10805, 
    10806, 
    10807, 
    10808, 
    10809, 
    10810, 
    10811, 
    10812, 
    10827, 
    10828, 
    9686, 
    10767, 
    10768, 
    10769, 
    10770, 
    10771, 
    10772, 
    10773, 
    10774, 
    10775, 
    10776, 
    10777, 
    9689, 
    10459, 
    10460, 
    10461, 
    10462, 
    10463, 
    10464, 
    10465, 
    10625, 
    10626, 
    10627, 
    10628, 
    10629, 
    10630, 
    10631, 
    10632, 
    10633, 
    10634, 
    10635, 
    10636, 
    12944, 
    10829, 
    10830, 
    10831, 
    10832, 
    10833, 
    10834, 
    10835, 
    10836, 
    10837, 
    10838, 
    10839, 
    12985, 
    12986, 
    12987, 
    12988, 
    12989, 
    12990, 
    12991, 
    12992, 
    12993, 
    12994, 
    10403, 
    10404, 
    10405, 
    15781, 
    10406, 
    10407, 
    10408, 
    10409, 
    10410, 
    10411, 
    10412, 
    12853, 
    12854, 
    12855, 
    10414, 
    10415, 
    10416, 
    12856, 
    10417, 
    10418, 
    10419, 
    10420, 
    10421, 
    10422, 
    10423, 
    10424, 
    10384, 
    10383, 
    10382, 
    10753, 
    10754, 
    10755, 
    10296, 
    10297, 
    10298, 
    10299, 
    10300, 
    10446, 
    10063, 
    10052, 
    10072, 
    10046, 
    10059, 
    10064, 
    10057, 
    10048, 
    10062, 
    10070, 
    10058, 
    10045, 
    10054, 
    10047
  ) 
  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.00165

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 (10793,10794,10795,10796,10797,10798,10799,10800,10801,10802,10803,10804,10805,10806,10807,10808,10809,10810,10811,10812,10827,10828,9686,10767,10768,10769,10770,10771,10772,10773,10774,10775,10776,10777,9689,10459,10460,10461,10462,10463,10464,10465,10625,10626,10627,10628,10629,10630,10631,10632,10633,10634,10635,10636,12944,10829,10830,10831,10832,10833,10834,10835,10836,10837,10838,10839,12985,12986,12987,12988,12989,12990,12991,12992,12993,12994,10403,10404,10405,15781,10406,10407,10408,10409,10410,10411,10412,12853,12854,12855,10414,10415,10416,12856,10417,10418,10419,10420,10421,10422,10423,10424,10384,10383,10382,10753,10754,10755,10296,10297,10298,10299,10300,10446,10063,10052,10072,10046,10059,10064,10057,10048,10062,10070,10058,10045,10054,10047) 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
9686 orlean 265/273
9689 palermo 265/273
10045 simmetrika-col-15 265/280/283/1629
10046 simmetrika-col-06 265/280/283/1629
10047 simmetrika-col-17 265/280/283/1629
10048 simmetrika-col-10 265/280/283/1629
10052 simmetrika-col-03 265/280/283/1629
10054 simmetrika-col-16 265/280/283/1629
10057 simmetrika-col-09 265/280/283/1629
10058 simmetrika-col-13 265/280/283/1629
10059 simmetrika-col-07 265/280/283/1629
10062 simmetrika-col-11 265/280/283/1629
10063 simmetrika-col-01 265/280/283/1629
10064 simmetrika-col-08 265/280/283/1629
10070 simmetrika-col-12 265/280/283/1629
10072 simmetrika-col-05 265/280/283/1629
10296 salon-col-01 265/280/291/1645
10297 salon-col-02 265/280/291/1645
10298 salon-col-03 265/280/291/1645
10299 salon-col-04 265/280/291/1645
10300 salon-col-05 265/280/291/1645
10382 respect-patchwork-col-03 265/280/291/1654
10383 respect-patchwork-col-02 265/280/291/1654
10384 respect-patchwork-col-01 265/280/291/1654
10403 respect-col-01 265/280/291/1655
10404 respect-col-02 265/280/291/1655
10405 respect-col-03 265/280/291/1655
10406 respect-col-06 265/280/291/1655
10407 respect-col-07 265/280/291/1655
10408 respect-col-08 265/280/291/1655
10409 respect-col-09 265/280/291/1655
10410 respect-col-10 265/280/291/1655
10411 respect-col-11 265/280/291/1655
10412 respect-col-12 265/280/291/1655
10414 respect-col-17 265/280/291/1655
10415 respect-col-18 265/280/291/1655
10416 respect-col-19 265/280/291/1655
10417 respect-col-22 265/280/291/1655
10418 respect-col-23 265/280/291/1655
10419 respect-col-24 265/280/291/1655
10420 respect-col-25 265/280/291/1655
10421 respect-col-26 265/280/291/1655
10422 respect-col-27 265/280/291/1655
10423 respect-col-28 265/280/291/1655
10424 respect-col-30 265/280/291/1655
10446 salon-col-06 265/280/291/1645
10459 perla-col-03 265/280/439/1658
10460 perla-col-04 265/280/439/1658
10461 perla-col-05 265/280/439/1658
10462 perla-col-06 265/280/439/1658
10463 perla-col-07 265/280/439/1658
10464 perla-col-08 265/280/439/1658
10465 perla-col-09 265/280/439/1658
10625 persona-col-01 265/280/291/1660
10626 persona-col-02 265/280/291/1660
10627 persona-col-03 265/280/291/1660
10628 persona-col-04 265/280/291/1660
10629 persona-col-05 265/280/291/1660
10630 persona-col-06 265/280/291/1660
10631 persona-col-07 265/280/291/1660
10632 persona-col-08 265/280/291/1660
10633 persona-col-09 265/280/291/1660
10634 persona-col-10 265/280/291/1660
10635 persona-col-11 265/280/291/1660
10636 persona-col-12 265/280/291/1660
10753 ribbon-col-01 265/280/291/1680
10754 ribbon-col-02 265/280/291/1680
10755 ribbon-col-03 265/280/291/1680
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
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
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
12853 respect-col-13 265/280/291/1655
12854 respect-col-15 265/280/291/1655
12855 respect-col-16 265/280/291/1655
12856 respect-col-20 265/280/291/1655
12944 philosophy-jute-sol-01 265/280/283
12985 primo-col-01 265/280/283/1649
12986 primo-col-02 265/280/283/1649
12987 primo-col-03 265/280/283/1649
12988 primo-col-04 265/280/283/1649
12989 primo-col-05 265/280/283/1649
12990 primo-col-06 265/280/283/1649
12991 primo-col-07 265/280/283/1649
12992 primo-col-08 265/280/283/1649
12993 primo-col-09 265/280/283/1649
12994 primo-col-10 265/280/283/1649
15781 respect-col-05 265/280/291/1655