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 (
    87241, 87244, 87245, 87246, 87249, 87250, 
    87251, 86894, 92232, 92233, 92234, 
    92235, 92236, 92238, 92468, 92472, 
    92473, 92474, 84240, 88588, 84239, 
    92212, 92213, 92214, 92215, 92217, 
    92223, 92465, 92466, 92191, 84238, 
    92228, 92229, 92230, 92231, 92237, 
    92469, 92470, 92471, 91865, 85585, 
    92366, 92367, 92368, 92369, 92370, 
    92371, 92372, 91892, 92150, 84254, 
    84259, 87577, 87592, 87607, 88788, 
    92197, 92457, 85646, 91866, 91867, 
    92325, 92326, 92327, 92328, 90054, 
    90056, 90057, 84252, 84253, 84257, 
    84258, 87575, 87576, 87590, 87591, 
    87605, 87606, 88786, 88787, 85578, 
    87656, 87670, 87677, 87684, 87705, 
    87716, 87717, 87730, 87731, 90022, 
    90024, 90038, 90040, 90041, 92440
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00229

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "43.23"
    },
    "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": 96,
      "rows_produced_per_join": 96,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "33.63",
        "eval_cost": "9.60",
        "prefix_cost": "43.23",
        "data_read_per_join": "162K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (87241,87244,87245,87246,87249,87250,87251,86894,92232,92233,92234,92235,92236,92238,92468,92472,92473,92474,84240,88588,84239,92212,92213,92214,92215,92217,92223,92465,92466,92191,84238,92228,92229,92230,92231,92237,92469,92470,92471,91865,85585,92366,92367,92368,92369,92370,92371,92372,91892,92150,84254,84259,87577,87592,87607,88788,92197,92457,85646,91866,91867,92325,92326,92327,92328,90054,90056,90057,84252,84253,84257,84258,87575,87576,87590,87591,87605,87606,88786,88787,85578,87656,87670,87677,87684,87705,87716,87717,87730,87731,90022,90024,90038,90040,90041,92440)) 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
84238 straight-front-panel-and-plinth-1500mm 7148/7156/7194
84239 straight-front-panel-and-plinth-1600mm 7148/7156/7194
84240 straight-front-panel-and-plinth-1700mm 7148/7156/7194
84252 700mm-straight-bath-end-panel-and-plinth 7148/7156/7194
84253 750mm-straight-end-panel-and-plinth-en 7148/7156/7194
84254 800mm-straight-end-panel-and-plinth-en 7148/7156/7194
84257 700mm-straight-bath-end-panel-and-plinth-en 7148/7156/7194
84258 750mm-straight-bath-end-panel-and-plinth 7148/7156/7194
84259 800mm-straight-end-panel-and-plinth-en-en 7148/7156/7194
85578 shallow-seal-trap 7148/7156/7157
85585 classic-exposed-bath-waste-and-overflow 7148/7156/7157
85646 ornate-cistern-brackets 7148/7156/7157
86894 traditional-shower-tidy 7148/7156/7157
87241 straight-bath-end-panel-800mm-en 7148/7156/7194
87244 straight-bath-end-panel-700mm-en-en 7148/7156/7194
87245 straight-bath-end-panel-750mm-en-en 7148/7156/7194
87246 straight-bath-end-panel-800mm-en-en 7148/7156/7194
87249 straight-bath-end-panel-700mm-en-en-en 7148/7156/7194
87250 straight-bath-end-panel-750mm-en-en-en 7148/7156/7194
87251 straight-bath-end-panel-800mm-en-en-en 7148/7156/7194
87575 urban-bath-end-panel-700mm 7170/7248/7249
87576 urban-bath-end-panel-750mm 7170/7248/7249
87577 urban-bath-end-panel-800mm 7170/7248/7249
87590 urban-bath-end-panel-700mm-en 7170/7248/7249
87591 urban-bath-end-panel-750mm-en 7170/7248/7249
87592 urban-bath-end-panel-800mm-en 7170/7248/7249
87605 urban-bath-end-panel-700mm-en-en 7170/7248/7249
87606 urban-bath-end-panel-750mm-en-en 7170/7248/7249
87607 urban-bath-end-panel-800mm-en-en 7170/7248/7249
87656 800mm-straight-bath-end-panel-and-plinth 7148/7156/7194
87670 800mm-straight-bath-end-panel-and-plinth-en-en 7148/7156/7194
87677 800mm-straight-bath-end-panel-and-plinth-en-en-en 7148/7156/7194
87684 havana-straight-shower-bath-end-panel-and-plinth-800mm 7195/7316/7317
87705 800mm-straight-end-panel-and-plinth-en-en-en-en 7148/7156/7194
87716 fusion-bath-end-panel-800mm-en 7148/7156/7194
87717 800mm-straight-end-panel-and-plinth-en-en-en-en-en 7148/7156/7194
87730 fusion-bath-end-panel-800mm-en-en 7148/7156/7194
87731 800mm-straight-end-panel-and-plinth-en-en-en-en-en-en 7148/7156/7194
88588 fusion-bath-front-panel-and-plinth-1700mm 7148/7156/7194
88786 fusion-straight-bath-end-panel-and-plinth-700mm 7210/7211/7282
88787 fusion-straight-bath-end-panel-and-plinth-750mm 7210/7211/7282
88788 fusion-bath-end-panel-800mm-en-en-en 7148/7156/7194
90022 b-shape-shower-bath-front-panel-1700mm 7148/7156/7194
90024 b-shape-shower-bath-front-panel-1500mm 7148/7156/7194
90038 p-shape-shower-bath-front-panel-1700mm 7148/7156/7194
90040 p-shape-shower-bath-front-panel-1500mm 7148/7156/7194
90041 p-shape-shower-bath-front-panel-1600mm 7148/7156/7194
90054 l-shape-shower-bath-front-panel-1700mm 7148/7156/7194
90056 l-shape-shower-bath-front-panel-1500mm 7148/7156/7194
90057 l-shape-shower-bath-front-panel-1600mm 7148/7156/7194
91865 victrion-glass-gallery-shelf-en 7148
91866 victrion-glass-gallery-shelf-en-en 7148
91867 victrion-glass-gallery-shelf-en-en-en 7148
91892 victrion-3-tier-towel-rack 7148
92150 standpipes-traditional-bath-legs-with-adjustable-shrouds 7148
92191 bath-wastes-plug-and-chain-exposed-ext-bath-waste 7148
92197 bath-wastes-push-down-concealed-bath-waste 7148
92212 bath-wastes-push-down-bath-waste-70mm-slotted-en-en 7148
92213 bath-wastes-push-down-bath-waste-70mm-slotted-en-en-en 7148
92214 bath-wastes-push-down-bath-waste-70mm-slotted-en-en-en-en 7148
92215 bath-wastes-push-down-bath-waste-70mm-slotted-en-en-en-en-en 7148
92217 bath-wastes-push-down-bath-waste-70mm-slotted-en-en-en-en-en-en-en 7148
92223 bath-wastes-push-down-bath-waste-70mm-slotted-en-en-en-en-en-en-en-en-en-en-en-en-en 7148
92228 bath-wastes-push-down-bath-waste-60mm-unslotted-en 7148
92229 bath-wastes-push-down-bath-waste-60mm-unslotted-en-en 7148
92230 bath-wastes-push-down-bath-waste-60mm-unslotted-en-en-en 7148
92231 bath-wastes-push-down-bath-waste-60mm-unslotted-en-en-en-en 7148
92232 bath-wastes-push-down-bath-waste-60mm-unslotted-en-en-en-en-en 7148
92233 bath-wastes-push-down-bath-waste-60mm-unslotted-en-en-en-en-en-en 7148
92234 bath-wastes-push-down-bath-waste-60mm-unslotted-en-en-en-en-en-en-en 7148
92235 bath-wastes-push-down-bath-waste-60mm-unslotted-en-en-en-en-en-en-en-en 7148
92236 bath-wastes-push-down-bath-waste-60mm-unslotted-en-en-en-en-en-en-en-en-en 7148
92237 bath-wastes-push-down-bath-waste-60mm-unslotted-en-en-en-en-en-en-en-en-en-en 7148
92238 bath-wastes-push-down-bath-waste-60mm-unslotted-en-en-en-en-en-en-en-en-en-en-en 7148
92325 victrion-gallery-shelf 7148
92326 victrion-gallery-shelf-en 7148
92327 victrion-gallery-shelf-en-en 7148
92328 victrion-gallery-shelf-en-en-en 7148
92366 basin-bottle-trap-en-en 7148
92367 basin-bottle-trap-en-en-en 7148
92368 basin-bottle-trap-en-en-en-en 7148
92369 basin-bottle-trap-en-en-en-en-en 7148
92370 basin-bottle-trap-en-en-en-en-en-en 7148
92371 basin-bottle-trap-en-en-en-en-en-en-en 7148
92372 basin-bottle-trap-en-en-en-en-en-en-en-en 7148
92440 plug-and-chain-concealed-bath-waste 7148
92457 exposed-bath-trap-with-adapter-40-42mm 7148
92465 push-down-bath-waste-70mm-slotted 7148
92466 push-down-bath-waste-70mm-slotted-en 7148
92468 push-down-bath-waste-60mm-unslotted 7148
92469 push-down-bath-waste-60mm-unslotted-en 7148
92470 push-down-bath-waste-60mm-unslotted-en-en 7148
92471 push-down-bath-waste-60mm-unslotted-en-en-en 7148
92472 push-down-bath-waste-60mm-unslotted-en-en-en-en 7148
92473 push-down-bath-waste-60mm-unslotted-en-en-en-en-en 7148
92474 push-down-bath-waste-60mm-unslotted-en-en-en-en-en-en 7148