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 (
    15943, 
    15951, 
    15952, 
    15956, 
    15958, 
    15959, 
    15944, 
    15960, 
    15961, 
    15962, 
    15966, 
    15957, 
    15965, 
    15945, 
    15968, 
    15946, 
    15947, 
    15949, 
    15950, 
    12520, 
    12497, 
    12528, 
    12512, 
    12511, 
    12527, 
    10580, 
    10579, 
    9936, 
    9931, 
    12521, 
    12504, 
    12502, 
    12505, 
    13099, 
    12514, 
    12513, 
    9759, 
    10496, 
    10560, 
    10561, 
    10581, 
    10102, 
    9940, 
    10578, 
    10143, 
    9947, 
    10567, 
    10568, 
    10565, 
    9933, 
    12499, 
    12500, 
    10200, 
    10201, 
    10566, 
    10545, 
    10227, 
    10552, 
    12506, 
    10693, 
    12508, 
    9953, 
    12522, 
    12507, 
    12498, 
    13101, 
    13100, 
    10699, 
    10695, 
    10195, 
    10576, 
    10696, 
    9760, 
    10583, 
    10701, 
    10582, 
    10139, 
    12503, 
    10575, 
    9932, 
    10075, 
    10135, 
    9952, 
    10074, 
    10573, 
    10577, 
    10651, 
    10642, 
    12529, 
    12515, 
    12525, 
    12532, 
    12523, 
    10198, 
    10557, 
    10202, 
    10556, 
    10101, 
    10558, 
    10142, 
    10134, 
    10141, 
    10053, 
    10138, 
    10130, 
    9934, 
    10563, 
    10569, 
    10572, 
    10602, 
    10603, 
    10137, 
    12517, 
    12531, 
    12526, 
    12509, 
    10226, 
    10551, 
    10550, 
    10193, 
    10659, 
    10664, 
    10666, 
    10661, 
    10663, 
    10190, 
    10657, 
    10658
  ) 
  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.00243

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 (15943,15951,15952,15956,15958,15959,15944,15960,15961,15962,15966,15957,15965,15945,15968,15946,15947,15949,15950,12520,12497,12528,12512,12511,12527,10580,10579,9936,9931,12521,12504,12502,12505,13099,12514,12513,9759,10496,10560,10561,10581,10102,9940,10578,10143,9947,10567,10568,10565,9933,12499,12500,10200,10201,10566,10545,10227,10552,12506,10693,12508,9953,12522,12507,12498,13101,13100,10699,10695,10195,10576,10696,9760,10583,10701,10582,10139,12503,10575,9932,10075,10135,9952,10074,10573,10577,10651,10642,12529,12515,12525,12532,12523,10198,10557,10202,10556,10101,10558,10142,10134,10141,10053,10138,10130,9934,10563,10569,10572,10602,10603,10137,12517,12531,12526,12509,10226,10551,10550,10193,10659,10664,10666,10661,10663,10190,10657,10658) 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
9759 podushka-dekorativnaya-erwin-ii-01-30h50 265/271/275
9760 product-9760 265/271/275
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
9940 podushka-dekorativnaya-esckimo-05-30h50 265/271/275
9947 product-9947 265/271/275
9952 podushka-dekorativnaya-respect-11-30h50 265/271/275
9953 product-9953 265/271/275
10053 product-10053 265/271/275
10074 podushka-dekorativnaya-respect-11-50h50 265/271/275
10075 podushka-dekorativnaya-respect-04-50h50 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
10190 podushka-dekorativnaya-garmoniya-grafika-07-30h50 265/271/275
10193 podushka-dekorativnaya-garmoniya-bukle-05-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
10545 podushka-dekorativnaya-inspiration-03-50x50 265/271/275
10550 podushka-dekorativnaya-winnie-03-50x50 265/271/275
10551 podushka-dekorativnaya-winnie-02-50x50 265/271/275
10552 podushka-dekorativnaya-inspiration-plain-03-50x50 265/271/275
10556 podushka-dekorativnaya-salon-04-50x50 265/271/275
10557 podushka-dekorativnaya-salon-01-50x50 265/271/275
10558 podushka-dekorativnaya-salon-06-50x50 265/271/275
10560 podushka-dekorativnaya-erwin-ii-03-50x50 265/271/275
10561 podushka-dekorativnaya-erwin-ii-05-50x50 265/271/275
10563 product-10563 265/271/275
10565 podushka-dekorativnaya-flashback-03-45x45 265/271/275
10566 podushka-dekorativnaya-inspiration-03-45x45 265/271/275
10567 podushka-dekorativnaya-flashback-01-45x45 265/271/275
10568 podushka-dekorativnaya-flashback-02-45x45 265/271/275
10569 podushka-dekorativnaya-swiss-velvet-10-45x45 265/271/275
10572 product-10572 265/271/275
10573 podushka-dekorativnaya-respect-12-45x45 265/271/275
10575 podushka-dekorativnaya-primo-05-30x50 265/271/275
10576 podushka-dekorativnaya-magnifico-plain-01-30x50 265/271/275
10577 podushka-dekorativnaya-respect-17-30x50 265/271/275
10578 product-10578 265/271/275
10579 podushka-dekorativnaya-bella-vita-06-30x50 265/271/275
10580 podushka-dekorativnaya-bella-vita-02-30x50 265/271/275
10581 podushka-dekorativnaya-esckimo-01-30x50 265/271/275
10582 podushka-dekorativnaya-mechta-18-30x50 265/271/275
10583 product-10583 265/271/275
10602 product-10602 265/271/275
10603 product-10603 265/271/275
10642 podushka-dekorativnaya-respect-20-50h50 265/271/275
10651 product-10651 265/271/275
10657 podushka-dekorativnaya-garmoniya-grafika-07-50x50 265/271/275
10658 podushka-dekorativnaya-garmoniya-grafika-08-50x50 265/271/275
10659 podushka-dekorativnaya-garmoniya-bukle-05-50x50 265/271/275
10661 podushka-dekorativnaya-garmoniya-grafika-01-45x45 265/271/275
10663 podushka-dekorativnaya-garmoniya-grafika-04-45x45 265/271/275
10664 podushka-dekorativnaya-garmoniya-bukle-07-30x50 265/271/275
10666 podushka-dekorativnaya-garmoniya-bukle-08-30x50 265/271/275
10693 podushka-dekorativnaya-inspiration-plain-12-45x45 265/271/275
10695 product-10695 265/271/275
10696 product-10696 265/271/275
10699 product-10699 265/271/275
10701 product-10701 265/271/275
12497 podushka-dekorativnaya-akcent-01-30h50 265/271/275
12498 podushka-dekorativnaya-krasota-17-chernyy-kant-30h50 265/271/275
12499 podushka-dekorativnaya-impulse-03-30x50 265/271/275
12500 podushka-dekorativnaya-impulse-03-50x50 265/271/275
12502 podushka-dekorativnaya-desert-02-30h50 265/271/275
12503 podushka-dekorativnaya-persona-11-45h45 265/271/275
12504 podushka-dekorativnaya-desert-01-30h50 265/271/275
12505 podushka-dekorativnaya-desert-03-30h50 265/271/275
12506 podushka-dekorativnaya-inspiration-plain-11-45h45 265/271/275
12507 podushka-dekorativnaya-krasota-17-cherno-belyy-kant-50h50 265/271/275
12508 podushka-dekorativnaya-krasota-12-50h50 265/271/275
12509 podushka-dekorativnaya-vista-03-chernyy-kant-50h50 265/271/275
12511 podushka-dekorativnaya-aurora-02-ryzhiy-kant-50h50 265/271/275
12512 podushka-dekorativnaya-akcent-02-50h50 265/271/275
12513 podushka-dekorativnaya-empire-21-belyy-kant-30h50 265/271/275
12514 podushka-dekorativnaya-divo-04-belyy-kant-50h50 265/271/275
12515 podushka-dekorativnaya-ribbon-02-chernyy-kant-50h50 265/271/275
12517 podushka-dekorativnaya-vista-02-belyy-kant-50h50 265/271/275
12520 podushka-dekorativnaya-akcent-01-belyy-kant-50h50 265/271/275
12521 podushka-dekorativnaya-del-vento-01-30h50 265/271/275
12522 podushka-dekorativnaya-krasota-17-cherno-belyy-kant-30h50 265/271/275
12523 podushka-dekorativnaya-ribbon-03-chernyy-kant-50h50 265/271/275
12525 podushka-dekorativnaya-ribbon-03-belyy-kant-50h50 265/271/275
12526 podushka-dekorativnaya-vista-03-siniy-kant-30h50 265/271/275
12527 podushka-dekorativnaya-aurora-02-seryy-kant-30h50 265/271/275
12528 podushka-dekorativnaya-akcent-02-30h50 265/271/275
12529 podushka-dekorativnaya-ribbon-02-chernyy-kant-30h50 265/271/275
12531 podushka-dekorativnaya-vista-02-goluboy-kant-30h50 265/271/275
12532 podushka-dekorativnaya-ribbon-03-chernyy-kant-30h50 265/271/275
13099 podushka-dekorativnaya-divo-04-belyy-kant-30h50 265/271/275
13100 podushka-dekorativnaya-les-01-30h50 265/271/275
13101 podushka-dekorativnaya-krasota-17-chernyy-kant-50h50 265/271/275
15943 komplekt-podushek-1 265/271/272
15944 komplekt-podushek-2 265/271/272
15945 komplekt-podushek-3 265/271/272
15946 komplekt-podushek-4 265/271/272
15947 komplekt-podushek-5 265/271/272
15949 komplekt-podushek-8 265/271/272
15950 komplekt-podushek-9 265/271/272
15951 komplekt-podushek-10 265/271/272
15952 komplekt-podushek-11 265/271/272
15956 komplekt-podushek-16 265/271/272
15957 komplekt-podushek-27 265/271/272
15958 komplekt-podushek-18 265/271/272
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
15965 komplekt-podushek-28 265/271/272
15966 komplekt-podushek-26 265/271/272
15968 komplekt-podushek-31 265/271/272