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 (
    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, 
    10194, 
    10692, 
    12530, 
    12516, 
    12496, 
    12519, 
    12510, 
    10087, 
    10100, 
    10698, 
    10478, 
    9883, 
    9901, 
    10493, 
    10485, 
    10476, 
    10479, 
    10494, 
    10492, 
    10468, 
    9903, 
    10487, 
    9899, 
    10473, 
    10486, 
    9881, 
    9896, 
    9892, 
    10481, 
    9876, 
    10474, 
    10491, 
    10489, 
    10471, 
    9880, 
    10472, 
    9885, 
    10488, 
    9897, 
    9895, 
    10467, 
    9900, 
    10470, 
    10466, 
    10477, 
    9889, 
    10475, 
    9890, 
    10483, 
    10495, 
    10490, 
    10469, 
    9877, 
    9894, 
    9891, 
    10480, 
    9893, 
    9878, 
    9886, 
    9882, 
    9888, 
    10482, 
    13091, 
    12551, 
    12638, 
    12634, 
    12636, 
    12635, 
    12599, 
    12627, 
    12600, 
    12639, 
    15800, 
    12595, 
    12587, 
    12593, 
    12620, 
    12623, 
    12619, 
    12585, 
    12616, 
    12601, 
    12628, 
    12602, 
    12640, 
    12647, 
    12588, 
    12605, 
    12606, 
    12637, 
    12612, 
    12613, 
    12641, 
    12554, 
    12552, 
    12642
  ) 
  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.00380

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 (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,10194,10692,12530,12516,12496,12519,12510,10087,10100,10698,10478,9883,9901,10493,10485,10476,10479,10494,10492,10468,9903,10487,9899,10473,10486,9881,9896,9892,10481,9876,10474,10491,10489,10471,9880,10472,9885,10488,9897,9895,10467,9900,10470,10466,10477,9889,10475,9890,10483,10495,10490,10469,9877,9894,9891,10480,9893,9878,9886,9882,9888,10482,13091,12551,12638,12634,12636,12635,12599,12627,12600,12639,15800,12595,12587,12593,12620,12623,12619,12585,12616,12601,12628,12602,12640,12647,12588,12605,12606,12637,12612,12613,12641,12554,12552,12642) 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
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
9934 product-9934 265/271/275
10053 product-10053 265/271/275
10087 product-10087 265/271/275
10100 podushka-dekorativnaya-romantika-52-30h50 265/271/275
10101 podushka-dekorativnaya-salon-06-30h50 265/271/275
10130 product-10130 265/271/275
10134 podushka-dekorativnaya-simmetrika-i-01-45x45 265/271/275
10137 podushka-dekorativnaya-target-soft-04-45x45 265/271/275
10138 product-10138 265/271/275
10141 podushka-dekorativnaya-simmetrika-i-02-v-50h50 265/271/275
10142 product-10142 265/271/275
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
10226 podushka-dekorativnaya-winnie-02-30h50 265/271/275
10466 romantika-perlamutrovyy-shelk-col-501 265/280/286/327
10467 romantika-nebesnaya-doroga-col-503 265/280/286/327
10468 romantika-gornye-vershiny-col-504 265/280/286/327
10469 romantika-sled-komety-col-505 265/280/286/327
10470 romantika-novaya-zvezda-col-506 265/280/286/327
10471 romantika-ledyanoe-steklo-col-507 265/280/286/327
10472 romantika-lunnyy-svet-col-508 265/280/286/327
10473 romantika-dymchataya-orhideya-col-509 265/280/286/327
10474 romantika-ispanskaya-villa-col-510 265/280/286/327
10475 romantika-roza-v-teni-col-511 265/280/286/327
10476 romantika-bryzgi-priboya-col-512 265/280/286/327
10477 romantika-pustynnyy-shalfey-col-513 265/280/286/327
10478 romantika-antichnaya-moneta-col-514 265/280/286/327
10479 romantika-vanilnyy-krem-col-515 265/280/286/327
10480 romantika-toskanskiy-mramor-col-516 265/280/286/327
10481 romantika-zybuchie-peski-col-517 265/280/286/327
10482 romantika-shum-goroda-col-518 265/280/286/327
10483 romantika-sizyy-pepel-col-519 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
10488 romantika-mayskiy-buton-col-524 265/280/286/327
10489 romantika-laymovyy-punsh-col-525 265/280/286/327
10490 romantika-sladkaya-paprika-col-526 265/280/286/327
10491 romantika-korolevskaya-siren-col-527 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
10495 romantika-sinyaya-ptica-col-531 265/280/286/327
10550 podushka-dekorativnaya-winnie-03-50x50 265/271/275
10551 podushka-dekorativnaya-winnie-02-50x50 265/271/275
10556 podushka-dekorativnaya-salon-04-50x50 265/271/275
10558 podushka-dekorativnaya-salon-06-50x50 265/271/275
10563 product-10563 265/271/275
10569 podushka-dekorativnaya-swiss-velvet-10-45x45 265/271/275
10572 product-10572 265/271/275
10602 product-10602 265/271/275
10603 product-10603 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
10692 podushka-dekorativnaya-garmoniya-grafika-09-50x50 265/271/275
10698 product-10698 265/271/275
12496 podushka-dekorativnaya-garmoniya-rogozhka-03-seryy-kant-30h50 265/271/275
12509 podushka-dekorativnaya-vista-03-chernyy-kant-50h50 265/271/275
12510 podushka-dekorativnaya-garmoniya-rogozhka-04-siniy-kant-30h50 265/271/275
12516 podushka-dekorativnaya-garmoniya-rogozhka-02-goluboy-kant-50h50 265/271/275
12517 podushka-dekorativnaya-vista-02-belyy-kant-50h50 265/271/275
12519 podushka-dekorativnaya-garmoniya-rogozhka-03-seryy-kant-50h50 265/271/275
12526 podushka-dekorativnaya-vista-03-siniy-kant-30h50 265/271/275
12530 podushka-dekorativnaya-garmoniya-rogozhka-02-goluboy-kant-30h50 265/271/275
12531 podushka-dekorativnaya-vista-02-goluboy-kant-30h50 265/271/275
12551 tureckiy-kover-bamboo-cuprum-200x300 265/266/268
12552 tureckiy-kover-marble-powder-160x230 265/266/268
12554 tureckiy-kover-marble-ocean-200x290 265/266/268
12585 tureckiy-kover-donna-satin-silver-200h300 265/266/1688
12587 tureckiy-kover-donna-antik-gold-200h300 265/266/1688
12588 tureckiy-kover-good-night-blue-152h200 265/266/267
12593 tureckiy-kover-donna-antique-copper-300x400 265/266/1688
12595 tureckiy-kover-donna-antik-gold-160x230 265/266/1688
12599 tureckiy-kover-botanica-bone-bone-160x230 265/266/270
12600 tureckiy-kover-botanica-bone-bone-80x150 265/266/270
12601 tureckiy-kover-elegant-bone-bone-160x230 265/266/277
12602 tureckiy-kover-elegant-bone-bone-80x150 265/266/267
12605 tureckiy-kover-grigio-grey-grey-160x230 265/266/270
12606 tureckiy-kover-grigio-grey-grey-80x150 265/266/267
12612 tureckiy-kover-lama-i-bone-black-160x230 265/266/277
12613 tureckiy-kover-lama-ii-bone-grey-160x230 265/266/277
12616 tureckiy-kover-ecotouch-grey-papatya-160x230 265/266/277
12619 tureckiy-kover-donna-satin-silver-160x230 265/266/1688
12620 tureckiy-kover-donna-pearl-160x230 265/266/267
12623 tureckiy-kover-donna-pearl-200h300 265/266/270
12627 tureckiy-kover-botanica-bone-bone-200x300 265/266/267
12628 tureckiy-kover-elegant-bone-bone-200x300 265/266/270
12634 tureckiy-kover-bohem-ash-100x200 265/266/268
12635 tureckiy-kover-bohem-choco-100x200 265/266/270
12636 tureckiy-kover-bohem-carop-160h230 265/266/268
12637 tureckiy-kover-jakarta-vanila-100h200 265/266/270
12638 tureckiy-kover-bear-120x180 265/266/270
12639 tureckiy-kover-cat-120x180 265/266/267
12640 tureckiy-kover-games-120x180 265/266/267
12641 tureckiy-kover-lion-120x180 265/266/267
12642 tureckiy-kover-moon-120x180 265/266/270
12647 tureckiy-kover-games-160x230 265/266/267
13091 tureckiy-kover-balloons-grey-152h200 265/266/267
15800 tureckiy-kover-cat-160x230 265/266/277