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 (
    275133, 
    275759, 
    275765, 
    276261, 
    276352, 
    276420, 
    276421, 
    276426, 
    276427, 
    276428, 
    276429, 
    276430, 
    276431, 
    276432, 
    276433, 
    276434, 
    276435, 
    276436, 
    276437, 
    276438, 
    276439, 
    276440, 
    276441, 
    276442, 
    276443, 
    276444, 
    276445, 
    276446, 
    276447, 
    276448, 
    276449, 
    276450, 
    276451, 
    276452, 
    276453, 
    276454, 
    276455, 
    276456, 
    276457, 
    276458, 
    276459, 
    276460, 
    276461, 
    276462, 
    276463, 
    276464, 
    276465, 
    276466, 
    276467, 
    276468, 
    276469, 
    276470, 
    276471, 
    276472, 
    276473, 
    276474, 
    276475, 
    276476, 
    276477, 
    276478, 
    276497, 
    276498, 
    276499, 
    276500, 
    276501, 
    276502, 
    276503, 
    276504, 
    276505, 
    276506, 
    276507, 
    276508, 
    276509, 
    276510, 
    276511, 
    276512, 
    276513, 
    276514, 
    276515, 
    276516, 
    276517, 
    276518, 
    276519, 
    276520, 
    276521, 
    276522, 
    276523, 
    276524, 
    276525, 
    276526, 
    276527, 
    276528, 
    276529, 
    276530, 
    276531, 
    276532, 
    276533, 
    276534, 
    276535, 
    276536, 
    276537, 
    276538, 
    276539, 
    276540, 
    276541, 
    276542, 
    276543, 
    276544, 
    276545, 
    276546, 
    276547, 
    276548, 
    276549, 
    276550, 
    276551, 
    276552, 
    276553, 
    276572, 
    276573, 
    276574, 
    276575, 
    276588, 
    276589, 
    276590, 
    276591, 
    276592, 
    276593, 
    276594, 
    276595, 
    276596, 
    276597, 
    276598, 
    276599, 
    276600, 
    276601, 
    276602, 
    276603, 
    276604, 
    276605, 
    276606, 
    276607, 
    276608, 
    276609, 
    276610, 
    276611, 
    276612, 
    276613, 
    276614, 
    276615, 
    276616, 
    276617, 
    276618, 
    276619, 
    276620, 
    276621, 
    276622, 
    276623, 
    276624, 
    276625, 
    276626
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00491

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "117.54"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code"
      ],
      "key_length": "206",
      "rows_examined_per_scan": 160,
      "rows_produced_per_join": 160,
      "filtered": "100.00",
      "index_condition": "((`s2cart`.`cscart_seo_names`.`object_id` in (275133,275759,275765,276261,276352,276420,276421,276426,276427,276428,276429,276430,276431,276432,276433,276434,276435,276436,276437,276438,276439,276440,276441,276442,276443,276444,276445,276446,276447,276448,276449,276450,276451,276452,276453,276454,276455,276456,276457,276458,276459,276460,276461,276462,276463,276464,276465,276466,276467,276468,276469,276470,276471,276472,276473,276474,276475,276476,276477,276478,276497,276498,276499,276500,276501,276502,276503,276504,276505,276506,276507,276508,276509,276510,276511,276512,276513,276514,276515,276516,276517,276518,276519,276520,276521,276522,276523,276524,276525,276526,276527,276528,276529,276530,276531,276532,276533,276534,276535,276536,276537,276538,276539,276540,276541,276542,276543,276544,276545,276546,276547,276548,276549,276550,276551,276552,276553,276572,276573,276574,276575,276588,276589,276590,276591,276592,276593,276594,276595,276596,276597,276598,276599,276600,276601,276602,276603,276604,276605,276606,276607,276608,276609,276610,276611,276612,276613,276614,276615,276616,276617,276618,276619,276620,276621,276622,276623,276624,276625,276626)) and (`s2cart`.`cscart_seo_names`.`type` = 'p') and (`s2cart`.`cscart_seo_names`.`dispatch` = '') and (`s2cart`.`cscart_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "101.54",
        "eval_cost": "16.00",
        "prefix_cost": "117.54",
        "data_read_per_join": "271K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id seo_name seo_path
275133 sealing-cover 4908
275759 abb-3-pole-contactor-275760 4905
275765 abb-3-phase-contactor-275766 4905
276261 abb-plugs-276262 4922
276352 abb-surface-socket-outlet-with-protection-276353 4927
276420 abb-integrated-aux.-contact 4935
276421 abb-integrated-aux.-contact-276422 4935
276426 abb-miniature-circuit-breaker-276427 5188/4936
276427 abb-miniature-circuit-breaker-276428 5188/4936
276428 abb-miniature-circuit-breaker-276429 5188/4936
276429 abb-miniature-circuit-breaker-276430 5188/4936
276430 abb-miniature-circuit-breaker-276431 5188/4936
276431 abb-miniature-circuit-breaker-276432 5188/4936
276432 abb-miniature-circuit-breaker-276433 5188/4936
276433 abb-miniature-circuit-breaker-276434 5188/4936
276434 abb-miniature-circuit-breaker-276435 5188/4936
276435 abb-miniature-circuit-breaker-276436 5188/4936
276436 abb-miniature-circuit-breaker-276437 5188/4936
276437 abb-miniature-circuit-breaker-276438 5188/4936
276438 abb-miniature-circuit-breaker-276439 5188/4936
276439 abb-miniature-circuit-breaker-276440 5188/4936
276440 abb-miniature-circuit-breaker-276441 5188/4936
276441 abb-miniature-circuit-breaker-276442 5188/4936
276442 abb-miniature-circuit-breaker-276443 5188/4936
276443 abb-miniature-circuit-breaker-276444 5188/4936
276444 abb-miniature-circuit-breaker-276445 5188/4936
276445 abb-miniature-circuit-breaker-276446 5188/4936
276446 abb-miniature-circuit-breaker-276447 5188/4936
276447 abb-miniature-circuit-breaker-276448 5188/4936
276448 abb-miniature-circuit-breaker-276449 5188/4936
276449 abb-miniature-circuit-breaker-276450 5188/4936
276450 abb-miniature-circuit-breaker-276451 5188/4936
276451 abb-miniature-circuit-breaker-276452 5188/4936
276452 abb-miniature-circuit-breaker-276453 5188/4936
276453 abb-miniature-circuit-breaker-276454 5188/4936
276454 abb-miniature-circuit-breaker-276455 5188/4936
276455 abb-miniature-circuit-breaker-276456 5188/4936
276456 abb-miniature-circuit-breaker-276457 5188/4936
276457 abb-miniature-circuit-breaker-276458 5188/4936
276458 abb-miniature-circuit-breaker-276459 5188/4936
276459 abb-miniature-circuit-breaker-276460 5188/4936
276460 abb-miniature-circuit-breaker-276461 5188/4936
276461 abb-miniature-circuit-breaker-276462 5188/4936
276462 abb-miniature-circuit-breaker-276463 5188/4936
276463 abb-miniature-circuit-breaker-276464 5188/4936
276464 abb-miniature-circuit-breaker-276465 5188/4936
276465 abb-miniature-circuit-breaker-276466 5188/4936
276466 abb-miniature-circuit-breaker-276467 5188/4936
276467 abb-miniature-circuit-breaker-276468 5188/4936
276468 abb-miniature-circuit-breaker-276469 5188/4936
276469 abb-miniature-circuit-breaker-276470 5188/4936
276470 abb-miniature-circuit-breaker-276471 5188/4936
276471 abb-miniature-circuit-breaker-276472 5188/4936
276472 abb-miniature-circuit-breaker-276473 5188/4936
276473 abb-miniature-circuit-breaker-276474 5188/4936
276474 abb-miniature-circuit-breaker-276475 5188/4936
276475 abb-miniature-circuit-breaker-276476 5188/4936
276476 abb-miniature-circuit-breaker-276477 5188/4936
276477 abb-miniature-circuit-breaker-276478 5188/4936
276478 abb-miniature-circuit-breaker-276479 5188/4936
276497 abb-miniature-circuit-breaker-276498 5188/4936
276498 abb-miniature-circuit-breaker-276499 5188/4936
276499 abb-miniature-circuit-breaker-276500 5188/4936
276500 abb-miniature-circuit-breaker-276501 5188/4936
276501 abb-miniature-circuit-breaker-276502 5188/4936
276502 abb-miniature-circuit-breaker-276503 5188/4936
276503 abb-miniature-circuit-breaker-276504 5188/4936
276504 abb-miniature-circuit-breaker-276505 5188/4936
276505 abb-miniature-circuit-breaker-276506 5188/4936
276506 abb-miniature-circuit-breaker-276507 5188/4936
276507 abb-miniature-circuit-breaker-276508 5188/4936
276508 abb-miniature-circuit-breaker-276509 5188/4936
276509 abb-miniature-circuit-breaker-276510 5188/4936
276510 abb-miniature-circuit-breaker-276511 5188/4936
276511 abb-miniature-circuit-breaker-276512 5188/4936
276512 abb-miniature-circuit-breaker-276513 5188/4936
276513 abb-miniature-circuit-breaker-276514 5188/4936
276514 abb-miniature-circuit-breaker-276515 5188/4936
276515 abb-miniature-circuit-breaker-276516 5188/4936
276516 abb-miniature-circuit-breaker-276517 5188/4936
276517 abb-miniature-circuit-breaker-276518 5188/4936
276518 abb-miniature-circuit-breaker-276519 5188/4936
276519 abb-miniature-circuit-breaker-276520 5188/4936
276520 abb-miniature-circuit-breaker-276521 5188/4936
276521 abb-miniature-circuit-breaker-276522 5188/4936
276522 abb-miniature-circuit-breaker-276523 5188/4936
276523 abb-miniature-circuit-breaker-276524 5188/4936
276524 abb-miniature-circuit-breaker-276525 5188/4936
276525 abb-miniature-circuit-breaker-276526 5188/4936
276526 abb-miniature-circuit-breaker-276527 5188/4936
276527 abb-miniature-circuit-breaker-276528 5188/4936
276528 abb-miniature-circuit-breaker-276529 5188/4936
276529 abb-miniature-circuit-breaker-276530 5188/4936
276530 abb-miniature-circuit-breaker-276531 5188/4936
276531 abb-miniature-circuit-breaker-276532 5188/4936
276532 abb-miniature-circuit-breaker-276533 5188/4936
276533 abb-miniature-circuit-breaker-276534 5188/4936
276534 abb-miniature-circuit-breaker-276535 5188/4936
276535 abb-miniature-circuit-breaker-276536 5188/4936
276536 abb-miniature-circuit-breaker-276537 5188/4936
276537 abb-miniature-circuit-breaker-276538 5188/4936
276538 abb-miniature-circuit-breaker-276539 5188/4936
276539 abb-miniature-circuit-breaker-276540 5188/4936
276540 abb-miniature-circuit-breaker-276541 5188/4936
276541 abb-miniature-circuit-breaker-s200m-4p-c 5188/4936
276542 abb-miniature-circuit-breaker-s200m-4p-c-276543 5188/4936
276543 abb-miniature-circuit-breaker-s200m-4p-c-276544 5188/4936
276544 abb-miniature-circuit-breaker-s200m-4p-c-276545 5188/4936
276545 abb-miniature-circuit-breaker-s200m-4p-c-276546 5188/4936
276546 abb-miniature-circuit-breaker-s200m-4p-d 5188/4936
276547 abb-miniature-circuit-breaker-s200m-4p-c-276548 5188/4936
276548 abb-miniature-circuit-breaker-s200m-4p-d-276549 5188/4936
276549 abb-miniature-circuit-breaker-s200m-4p-c-276550 5188/4936
276550 abb-miniature-circuit-breaker-s200m-4p-d-276551 5188/4936
276551 abb-miniature-circuit-breaker-s200m-4p-c-276552 5188/4936
276552 abb-miniature-circuit-breaker-s200m-4p-d-276553 5188/4936
276553 abb-miniature-circuit-breaker-s200m-4p-c-276554 5188/4936
276572 abb-miniature-circuit-breaker-s200m-4p-d-276573 5188/4936
276573 abb-miniature-circuit-breaker-s200m-4p-c-276574 5188/4936
276574 abb-miniature-circuit-breaker-s200m-4p-d-276575 5188/4936
276575 abb-miniature-circuit-breaker-s200m-4p-c-276576 5188/4936
276588 abb-miniature-circuit-breaker-sh200m-1p-c 5188/4936
276589 abb-miniature-circuit-breaker-sh200m-1p-c-276590 5188/4936
276590 abb-miniature-circuit-breaker-sh200m-1p-c-276591 5188/4936
276591 abb-miniature-circuit-breaker-sh200m-1p-c-276592 5188/4936
276592 abb-miniature-circuit-breaker-sh200m-1p-c-276593 5188/4936
276593 abb-miniature-circuit-breaker-sh200m-1p-c-276594 5188/4936
276594 abb-miniature-circuit-breaker-sh200m-1p-c-276595 5188/4936
276595 abb-miniature-circuit-breaker-sh200m-1p-c-276596 5188/4936
276596 abb-miniature-circuit-breaker-sh200m-1p-c-276597 5188/4936
276597 abb-miniature-circuit-breaker-sh200m-1p-c-276598 5188/4936
276598 abb-miniature-circuit-breaker-sh200m-1p-c-276599 5188/4936
276599 abb-miniature-circuit-breaker-sh200m-1p-c-276600 5188/4936
276600 abb-miniature-circuit-breaker-sh200m-1p-c-276601 5188/4936
276601 abb-miniature-circuit-breaker-sh200m-1p-c-276602 5188/4936
276602 abb-miniature-circuit-breaker-sh200m-1p-c-276603 5188/4936
276603 abb-miniature-circuit-breaker-sh200m-1p-c-276604 5188/4936
276604 abb-miniature-circuit-breaker-sh200m-1p-c-276605 5188/4936
276605 abb-miniature-circuit-breaker-sh200m-1p-c-276606 5188/4936
276606 abb-miniature-circuit-breaker-sh200m-1p-c-276607 5188/4936
276607 abb-miniature-circuit-breaker-sh200m-1p-c-276608 5188/4936
276608 abb-miniature-circuit-breaker-sh200m-1p-c-276609 5188/4936
276609 abb-miniature-circuit-breaker-sh200m-1p-c-276610 5188/4936
276610 abb-miniature-circuit-breaker-sh200m-1p-c-276611 5188/4936
276611 abb-miniature-circuit-breaker-sh200m-1p-c-276612 5188/4936
276612 abb-miniature-circuit-breaker-sh200m-1p-c-276613 5188/4936
276613 abb-miniature-circuit-breaker-sh200m-1p-c-276614 5188/4936
276614 abb-miniature-circuit-breaker-sh200m-1p-c-276615 5188/4936
276615 abb-miniature-circuit-breaker-sh200m-1p-c-276616 5188/4936
276616 abb-miniature-circuit-breaker-sh200m-1p-c-276617 5188/4936
276617 abb-miniature-circuit-breaker-sh200m-1p-c-276618 5188/4936
276618 abb-miniature-circuit-breaker-sh202m-2p-c 5188/4936
276619 abb-miniature-circuit-breaker-sh202m-2p-c-276620 5188/4936
276620 abb-miniature-circuit-breaker-sh202m-2p-c-276621 5188/4936
276621 abb-miniature-circuit-breaker-sh202m-2p-c-276622 5188/4936
276622 abb-miniature-circuit-breaker-sh202m-2p-c-276623 5188/4936
276623 abb-miniature-circuit-breaker-sh202m-2p-c-276624 5188/4936
276624 abb-miniature-circuit-breaker-sh202m-2p-c-276625 5188/4936
276625 abb-miniature-circuit-breaker-sh202m-2p-c-276626 5188/4936
276626 abb-miniature-circuit-breaker-sh202m-2p-c-276627 5188/4936