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 (
    10102, 
    10643, 
    10178, 
    10177, 
    10606, 
    10644, 
    10101, 
    10175, 
    10100, 
    15962, 
    15961, 
    15960, 
    15959, 
    10094, 
    10093, 
    9813, 
    10097, 
    9760, 
    9759, 
    9934, 
    9933, 
    9932, 
    9931, 
    9936, 
    9947, 
    9953, 
    9952, 
    10074, 
    10096, 
    10075, 
    10602, 
    10087, 
    10130, 
    10603, 
    10135, 
    10134, 
    10139, 
    10138, 
    10137, 
    10141, 
    10143, 
    10142, 
    12628, 
    12627, 
    12629, 
    10095, 
    10195, 
    10194, 
    10193, 
    10190, 
    10496, 
    10198, 
    10202, 
    10201, 
    10200, 
    10227, 
    10226, 
    10651, 
    9945, 
    10642, 
    10601, 
    9727, 
    9728, 
    9729, 
    9730, 
    9731, 
    9732, 
    9733, 
    10181, 
    9734, 
    9735, 
    9724, 
    10655, 
    10654, 
    10605, 
    10604, 
    9873, 
    10653, 
    10646, 
    10645, 
    10647, 
    10648, 
    10649, 
    10726, 
    10650, 
    9789, 
    10547, 
    9796, 
    9874, 
    9875, 
    9879, 
    9887, 
    9941, 
    9942, 
    9943, 
    9944, 
    10744, 
    10745, 
    10746, 
    10739, 
    10740, 
    10741, 
    10742, 
    10734, 
    10735, 
    10736, 
    10737, 
    10738, 
    10688, 
    10727, 
    10728, 
    10729, 
    10730, 
    10731, 
    10732, 
    10733, 
    10713, 
    10714, 
    10715, 
    10716, 
    10717, 
    10718, 
    10719, 
    10720, 
    10721, 
    10722, 
    10723, 
    10704
  ) 
  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.00362

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 (10102,10643,10178,10177,10606,10644,10101,10175,10100,15962,15961,15960,15959,10094,10093,9813,10097,9760,9759,9934,9933,9932,9931,9936,9947,9953,9952,10074,10096,10075,10602,10087,10130,10603,10135,10134,10139,10138,10137,10141,10143,10142,12628,12627,12629,10095,10195,10194,10193,10190,10496,10198,10202,10201,10200,10227,10226,10651,9945,10642,10601,9727,9728,9729,9730,9731,9732,9733,10181,9734,9735,9724,10655,10654,10605,10604,9873,10653,10646,10645,10647,10648,10649,10726,10650,9789,10547,9796,9874,9875,9879,9887,9941,9942,9943,9944,10744,10745,10746,10739,10740,10741,10742,10734,10735,10736,10737,10738,10688,10727,10728,10729,10730,10731,10732,10733,10713,10714,10715,10716,10717,10718,10719,10720,10721,10722,10723,10704) 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
9724 for-rest-col-13 265/280/291/1671
9727 for-rest-col-03 265/280/291/1671
9728 for-rest-col-04 265/280/291/1671
9729 for-rest-col-05 265/280/291/1671
9730 for-rest-col-06 265/280/291/1671
9731 for-rest-col-07 265/280/291/1671
9732 for-rest-col-08 265/280/291/1671
9733 for-rest-col-09 265/280/291/1671
9734 for-rest-col-11 265/280/291/1671
9735 for-rest-col-12 265/280/291/1671
9759 podushka-dekorativnaya-erwin-ii-01-30h50 265/271/275
9760 product-9760 265/271/275
9789 chalet-col-10 265/280/309/700
9796 empire-col-05 265/280/291/1672
9813 kingsman-games-col-04 265/280/286/1666
9873 charisma-col-05 265/280/309/708
9874 empire-col-01 265/280/291/1672
9875 empire-col-02 265/280/291/1672
9879 empire-col-04 265/280/291/1672
9887 empire-col-03 265/280/291/1672
9931 product-9931 265/271/275
9932 product-9932 265/271/275
9933 product-9933 265/271/275
9934 product-9934 265/271/275
9936 product-9936 265/271/275
9941 empire-col-08 265/280/291/1672
9942 empire-col-06 265/280/291/1672
9943 empire-col-07 265/280/291/1672
9944 empire-col-09 265/280/291/1672
9945 for-rest-col-01 265/280/291/1671
9947 product-9947 265/271/275
9952 podushka-dekorativnaya-respect-11-30h50 265/271/275
9953 product-9953 265/271/275
10074 podushka-dekorativnaya-respect-11-50h50 265/271/275
10075 podushka-dekorativnaya-respect-04-50h50 265/271/275
10087 product-10087 265/271/275
10093 kingsman-spy-col-04 265/280/286/1666
10094 kingsman-col-04 265/280/286/1666
10095 kingsman-games-col-05 265/280/286/1666
10096 kingsman-spy-col-05 265/280/286/1666
10097 kingsman-col-05 265/280/286/1666
10100 podushka-dekorativnaya-romantika-52-30h50 265/271/275
10101 podushka-dekorativnaya-salon-06-30h50 265/271/275
10102 podushka-dekorativnaya-esckimo-04-30h50 265/271/275
10130 product-10130 265/271/275
10134 podushka-dekorativnaya-simmetrika-i-01-45x45 265/271/275
10135 product-10135 265/271/275
10137 podushka-dekorativnaya-target-soft-04-45x45 265/271/275
10138 product-10138 265/271/275
10139 podushka-dekorativnaya-persona-03-50h50 265/271/275
10141 podushka-dekorativnaya-simmetrika-i-02-v-50h50 265/271/275
10142 product-10142 265/271/275
10143 product-10143 265/271/275
10175 kingsman-games-col-03 265/280/286/1666
10177 kingsman-games-col-02 265/280/286/1666
10178 kingsman-spy-col-02 265/280/286/1666
10181 for-rest-col-10 265/280/291/1671
10190 podushka-dekorativnaya-garmoniya-grafika-07-30h50 265/271/275
10193 podushka-dekorativnaya-garmoniya-bukle-05-30h50 265/271/275
10194 podushka-dekorativnaya-garmoniya-grafika-09-30h50 265/271/275
10195 podushka-dekorativnaya-magnifico-05-30h50 265/271/275
10198 podushka-dekorativnaya-salon-01-30h50 265/271/275
10200 podushka-dekorativnaya-impulse-i-01-30h50 265/271/275
10201 podushka-dekorativnaya-impulse-i-02-30h50 265/271/275
10202 podushka-dekorativnaya-salon-04-30h50 265/271/275
10226 podushka-dekorativnaya-winnie-02-30h50 265/271/275
10227 podushka-dekorativnaya-inspiration-plain-03-30h50 265/271/275
10496 podushka-dekorativnaya-erwin-ii-03-30h50 265/271/275
10547 chalet-col-09 265/280/309/700
10601 for-rest-col-02 265/280/291/1671
10602 product-10602 265/271/275
10603 product-10603 265/271/275
10604 charisma-col-04 265/280/309/708
10605 charisma-col-03 265/280/309/708
10606 kingsman-col-03 265/280/286/1666
10642 podushka-dekorativnaya-respect-20-50h50 265/271/275
10643 kingsman-col-02 265/280/286/1666
10644 kingsman-spy-col-03 265/280/286/1666
10645 chalet-col-03 265/280/309/700
10646 chalet-col-02 265/280/309/700
10647 chalet-col-04 265/280/309/700
10648 chalet-col-05 265/280/309/700
10649 chalet-col-06 265/280/309/700
10650 chalet-col-08 265/280/309/700
10651 product-10651 265/271/275
10653 chalet-col-01 265/280/309/700
10654 charisma-col-02 265/280/309/708
10655 charisma-col-01 265/280/309/708
10688 luna-col-01 265/280/439/1664
10704 flame-col-01 265/280/291/1662
10713 del-vento-col-01 265/280/291/1663
10714 del-vento-col-02 265/280/291/1663
10715 del-vento-col-03 265/280/291/1663
10716 del-vento-col-04 265/280/291/1663
10717 del-vento-col-05 265/280/291/1663
10718 del-vento-col-06 265/280/291/1663
10719 del-vento-col-07 265/280/291/1663
10720 del-vento-col-08 265/280/291/1663
10721 del-vento-col-09 265/280/291/1663
10722 del-vento-col-10 265/280/291/1663
10723 del-vento-col-11 265/280/291/1663
10726 chalet-col-07 265/280/309/700
10727 luna-col-02 265/280/439/1664
10728 luna-col-03 265/280/439/1664
10729 luna-col-04 265/280/439/1664
10730 luna-col-05 265/280/439/1664
10731 luna-col-06 265/280/439/1664
10732 luna-col-07 265/280/439/1664
10733 luna-col-08 265/280/439/1664
10734 angora-col-01 265/280/286/1665
10735 angora-col-02 265/280/286/1665
10736 angora-col-03 265/280/286/1665
10737 angora-col-04 265/280/286/1665
10738 angora-col-05 265/280/286/1665
10739 desert-col-01 265/280/283/1669
10740 desert-col-02 265/280/283/1669
10741 desert-col-03 265/280/283/1669
10742 desert-plain 265/280/283/1669
10744 intellect-col-01 265/280/439/1668
10745 intellect-col-02 265/280/439/1668
10746 intellect-col-03 265/280/439/1668
12627 tureckiy-kover-botanica-bone-bone-200x300 265/266/267
12628 tureckiy-kover-elegant-bone-bone-200x300 265/266/270
12629 tureckiy-kover-zebra-bone-bone-200x300 265/266/270
15959 komplekt-podushek-19 265/271/272
15960 komplekt-podushek-20 265/271/272
15961 komplekt-podushek-21 265/271/272
15962 komplekt-podushek-22 265/271/272