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 (
    92255, 92256, 92257, 92496, 92497, 92498, 
    92499, 92254, 92489, 92490, 92491, 
    92492, 92493, 92494, 92495, 92240, 
    92245, 92247, 92248, 92249, 92250, 
    92252, 92253, 92485, 92486, 92487, 
    92241, 92242, 92243, 92244, 92246, 
    92251, 92483, 92484, 92488, 92476, 
    92477, 92478, 92479, 92480, 92481, 
    92482, 85554, 85570, 85543, 92239, 
    85591, 85597
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00152

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.62"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.82",
        "eval_cost": "4.80",
        "prefix_cost": "21.62",
        "data_read_per_join": "81K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (92255,92256,92257,92496,92497,92498,92499,92254,92489,92490,92491,92492,92493,92494,92495,92240,92245,92247,92248,92249,92250,92252,92253,92485,92486,92487,92241,92242,92243,92244,92246,92251,92483,92484,92488,92476,92477,92478,92479,92480,92481,92482,85554,85570,85543,92239,85591,85597)) and (`nuie_scalesta_net`.`cscart_seo_names`.`type` = 'p') and (`nuie_scalesta_net`.`cscart_seo_names`.`dispatch` = '') and (`nuie_scalesta_net`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id seo_name seo_path
85543 wastes-and-extras-basin-pop-up-waste 7184/7219/7220
85554 waste-trap-for-furniture-basins 7148/7156/7157
85570 traditional-basin-black-pull-up-waste 7148/7156/7157
85591 square-push-button-basin-waste-slotted 7148/7158/7159
85597 wastes-and-extras-universal-push-button-basin-waste-slotted-and-un-slotted-en 7184/7219/7220
92239 basin-wastes-push-down-basin-waste-unslotted 7148
92240 basin-wastes-push-down-basin-waste-unslotted-en 7148
92241 basin-wastes-push-down-basin-waste-unslotted-en-en 7148
92242 basin-wastes-push-down-basin-waste-unslotted-en-en-en 7148
92243 basin-wastes-push-down-basin-waste-unslotted-en-en-en-en 7148
92244 basin-wastes-push-down-basin-waste-unslotted-en-en-en-en-en 7148
92245 basin-wastes-push-down-basin-waste-unslotted-en-en-en-en-en-en 7148
92246 basin-wastes-push-down-basin-waste-unslotted-en-en-en-en-en-en-en 7148
92247 basin-wastes-push-down-basin-waste-unslotted-en-en-en-en-en-en-en-en 7148
92248 basin-wastes-push-down-basin-waste-unslotted-en-en-en-en-en-en-en-en-en 7148
92249 basin-wastes-push-down-basin-waste-unslotted-en-en-en-en-en-en-en-en-en-en 7148
92250 basin-wastes-push-down-basin-waste-unslotted-en-en-en-en-en-en-en-en-en-en-en 7148
92251 basin-wastes-push-down-basin-waste-unslotted-en-en-en-en-en-en-en-en-en-en-en-en 7148
92252 basin-wastes-push-down-basin-waste-unslotted-en-en-en-en-en-en-en-en-en-en-en-en-en 7148
92253 basin-wastes-push-down-basin-waste-unslotted-en-en-en-en-en-en-en-en-en-en-en-en-en-en 7148
92254 bath-wastes-overflow-filler-and-push-down-waste 7148
92255 bath-wastes-overflow-filler-and-push-down-waste-en 7148
92256 bath-wastes-overflow-filler-and-push-down-waste-en-en 7148
92257 bath-wastes-overflow-filler-and-push-down-waste-en-en-en 7148
92476 basin-waste-with-plug-and-link-chain-en 7148
92477 basin-waste-with-plug-and-link-chain-en-en 7148
92478 basin-waste-with-plug-and-link-chain-en-en-en 7148
92479 basin-waste-with-plug-and-link-chain-en-en-en-en 7148
92480 basin-waste-with-plug-and-link-chain-en-en-en-en-en 7148
92481 basin-waste-with-plug-and-link-chain-en-en-en-en-en-en 7148
92482 basin-waste-with-plug-and-link-chain-en-en-en-en-en-en-en 7148
92483 push-down-basin-waste-unslotted 7148
92484 push-down-basin-waste-unslotted-en 7148
92485 push-down-basin-waste-unslotted-en-en 7148
92486 push-down-basin-waste-unslotted-en-en-en 7148
92487 push-down-basin-waste-unslotted-en-en-en-en 7148
92488 traditional-pull-up-basin-waste 7148
92489 traditional-pull-up-basin-waste-en 7148
92490 traditional-pull-up-basin-waste-en-en 7148
92491 traditional-pull-up-basin-waste-en-en-en 7148
92492 traditional-pull-up-basin-waste-en-en-en-en 7148
92493 traditional-pull-up-basin-waste-en-en-en-en-en 7148
92494 traditional-pull-up-basin-waste-en-en-en-en-en-en 7148
92495 traditional-pull-up-basin-waste-en-en-en-en-en-en-en 7148
92496 overflow-filler-and-push-down-waste 7148
92497 overflow-filler-and-push-down-waste-en 7148
92498 overflow-filler-and-push-down-waste-en-en 7148
92499 overflow-filler-and-push-down-waste-en-en-en 7148