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 (
    12551, 
    12544, 
    12546, 
    12547, 
    12548, 
    12549, 
    12550, 
    12555, 
    12556, 
    12557, 
    12558, 
    12559, 
    12576, 
    12577, 
    12578, 
    9683, 
    9685, 
    9686, 
    9687, 
    9688, 
    9689, 
    9690, 
    12560, 
    12561, 
    9775, 
    9776, 
    9777, 
    9778, 
    9779, 
    9780, 
    9781, 
    9782, 
    9783, 
    9784, 
    9785, 
    9786, 
    9787, 
    9788, 
    9790, 
    9791, 
    9792, 
    9795, 
    9797, 
    9798, 
    9799, 
    9800, 
    9801, 
    9802, 
    9803, 
    9804, 
    9805, 
    9806, 
    9807, 
    9808, 
    9809, 
    9810, 
    9811, 
    9812, 
    9814, 
    9815, 
    9816, 
    9817, 
    9818, 
    9820, 
    9821, 
    9822, 
    9823, 
    9824, 
    9825, 
    9826, 
    9827, 
    9828, 
    9829, 
    9830, 
    15732, 
    9838, 
    9839, 
    9840, 
    9841, 
    9842, 
    9843, 
    9844, 
    9845, 
    9846, 
    9847, 
    9848, 
    9849, 
    9850, 
    9851, 
    9852, 
    9853, 
    9854, 
    9855, 
    9856, 
    9857, 
    9858, 
    9859, 
    9860, 
    9861, 
    9862, 
    9863, 
    9876, 
    9877, 
    9878, 
    9880, 
    9881, 
    9882, 
    9883, 
    9885, 
    9886, 
    9888, 
    9889, 
    9890, 
    9891, 
    9892, 
    9893, 
    9894, 
    9895, 
    9896, 
    9897, 
    9899, 
    9900, 
    9901, 
    9903, 
    9972, 
    9973, 
    9975, 
    9976
  ) 
  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.00190

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 (12551,12544,12546,12547,12548,12549,12550,12555,12556,12557,12558,12559,12576,12577,12578,9683,9685,9686,9687,9688,9689,9690,12560,12561,9775,9776,9777,9778,9779,9780,9781,9782,9783,9784,9785,9786,9787,9788,9790,9791,9792,9795,9797,9798,9799,9800,9801,9802,9803,9804,9805,9806,9807,9808,9809,9810,9811,9812,9814,9815,9816,9817,9818,9820,9821,9822,9823,9824,9825,9826,9827,9828,9829,9830,15732,9838,9839,9840,9841,9842,9843,9844,9845,9846,9847,9848,9849,9850,9851,9852,9853,9854,9855,9856,9857,9858,9859,9860,9861,9862,9863,9876,9877,9878,9880,9881,9882,9883,9885,9886,9888,9889,9890,9891,9892,9893,9894,9895,9896,9897,9899,9900,9901,9903,9972,9973,9975,9976) 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
9683 geneva 265/273
9685 brugge 265/273
9686 orlean 265/273
9687 stockholm 265/273
9688 napoli 265/273
9689 palermo 265/273
9690 malaga 265/273
9775 fantaziya-col-07 265/280/286/308
9776 fantaziya-col-01 265/280/286/308
9777 fantaziya-col-02 265/280/286/308
9778 fantaziya-col-08 265/280/286/308
9779 fantaziya-col-10 265/280/286/308
9780 fantaziya-col-17 265/280/286/308
9781 fantaziya-col-05 265/280/286/308
9782 fantaziya-col-19 265/280/286/308
9783 fantaziya-col-42 265/280/286/308
9784 fantaziya-col-38 265/280/286/308
9785 fantaziya-col-41 265/280/286/308
9786 fantaziya-col-46 265/280/286/308
9787 fantaziya-col-26 265/280/286/308
9788 fantaziya-col-50 265/280/286/308
9790 fantaziya-col-22 265/280/286/308
9791 fantaziya-col-30 265/280/286/308
9792 fantaziya-col-31 265/280/286/308
9795 fantaziya-col-37 265/280/286/308
9797 generation-col-101 265/280/286/1614
9798 generation-col-107 265/280/286/1614
9799 generation-col-106 265/280/286/1614
9800 generation-col-105 265/280/286/1614
9801 generation-col-108 265/280/286/1614
9802 generation-col-109 265/280/286/1614
9803 generation-col-04 265/280/286/1614
9804 generation-col-110 265/280/286/1614
9805 generation-col-06 265/280/286/1614
9806 generation-col-11 265/280/286/1614
9807 generation-col-12 265/280/286/1614
9808 generation-col-13 265/280/286/1614
9809 generation-col-111 265/280/286/1614
9810 generation-col-112 265/280/286/1614
9811 generation-col-115 265/280/286/1614
9812 generation-col-116 265/280/286/1614
9814 crush-col-01 265/280/286/1622
9815 crush-col-02 265/280/286/1622
9816 crush-col-03 265/280/286/1622
9817 crush-col-04 265/280/286/1622
9818 crush-col-05 265/280/286/1622
9820 crush-col-07 265/280/286/1622
9821 crush-col-08 265/280/286/1622
9822 crush-col-09 265/280/286/1622
9823 crush-col-10 265/280/286/1622
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
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
9876 romantika-izumrudnye-holmy-col-270 265/280/286/327
9877 romantika-snezhnaya-skazka-col-401 265/280/286/327
9878 romantika-hrustalnyy-zvon-col-402 265/280/286/327
9880 romantika-lepestok-zhasmina-col-01 265/280/286/327
9881 romantika-zhemchuzhnyy-bereg-col-07 265/280/286/327
9882 romantika-chaynaya-roza-col-10 265/280/286/327
9883 romantika-aromatnaya-pudra-col-61 265/280/286/327
9885 romantika-magiya-zolota-col-63 265/280/286/327
9886 romantika-cvetochnyy-med-col-62 265/280/286/327
9888 romantika-shokoladnyy-liker-col-33 265/280/286/327
9889 romantika-rechnaya-galka-col-43 265/280/286/327
9890 romantika-serebryanyy-dozhd-col-23 265/280/286/327
9891 romantika-stepnye-travy-col-18 265/280/286/327
9892 romantika-zelenyy-chay-col-42 265/280/286/327
9893 romantika-tropicheskiy-vodopad-col-56 265/280/286/327
9894 romantika-sosnovyy-les-col-80 265/280/286/327
9895 romantika-morskoy-veter-col-54 265/280/286/327
9896 romantika-zvezdnaya-noch-col-53 265/280/286/327
9897 romantika-moroznoe-utro-col-52 265/280/286/327
9899 romantika-dushistaya-lavanda-col-86 265/280/286/327
9900 romantika-nezhnoe-mercanie-col-85 265/280/286/327
9901 romantika-barhatnyy-iris-col-98 265/280/286/327
9903 romantika-granatovyy-zakat-col-89 265/280/286/327
9972 continent-col-03 265/280/283/1641
9973 continent-col-04 265/280/283/1641
9975 continent-col-06 265/280/283/1641
9976 continent-col-07 265/280/283/1641
12544 belgiyskiy-kover-granite-160x230 265/266/278
12546 belgiyskiy-kover-agat-200x300 265/266/278
12547 belgiyskiy-kover-chic-200x300 265/266/277
12548 belgiyskiy-kover-antique-160x230 265/266/277
12549 belgiyskiy-kover-basalt-160x230 265/266/267
12550 belgiyskiy-kover-fresco-160x230 265/266/278
12551 tureckiy-kover-bamboo-cuprum-200x300 265/266/268
12555 belgiyskiy-kover-origami-160h230 265/266/277
12556 belgiyskiy-kover-oscar-160h230 265/266/277
12557 belgiyskiy-kover-bauhaus-160h230 265/266/278
12558 belgiyskiy-kover-bauhaus-200x300 265/266/277
12559 belgiyskiy-kover-spectrum-160h230 265/266/278
12560 belgiyskiy-kover-origami-200x300 265/266/267
12561 belgiyskiy-kover-oscar-200x300 265/266/267
12576 belgiyskiy-kover-apatite-160x230 265/266/278
12577 belgiyskiy-kover-mirror-160x230 265/266/267
12578 belgiyskiy-kover-boreal-160x230 265/266/278
15732 crush-col-06 265/280/286/1622