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 (
    88904, 90824, 90825, 87232, 87233, 87237, 
    87238, 87242, 87243, 87247, 87248, 
    84251, 84256, 87580, 87595, 87610, 
    88791, 84250, 84255, 87578, 87579, 
    87593, 87594, 87608, 87609, 88151, 
    88153, 88789, 88790, 87653, 87667, 
    87674, 87681, 87702, 87710, 87711, 
    87724, 87725, 87652, 87658, 87666, 
    87672, 87673, 87679, 87680, 87686, 
    87701, 87707, 87709, 87721, 87723, 
    87735, 88694, 88695, 88741, 88742, 
    88149, 88587, 84241, 87234, 87235, 
    87236, 87239, 87240, 87241, 87244, 
    87245, 87246, 87249, 87250, 87251, 
    84240, 88588, 84239, 84238, 84254, 
    84259, 87577, 87592, 87607, 88788, 
    90054, 90056, 90057, 84252, 84253, 
    84257, 84258, 87575, 87576, 87590, 
    87591, 87605, 87606, 88786, 88787
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00213

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 (88904,90824,90825,87232,87233,87237,87238,87242,87243,87247,87248,84251,84256,87580,87595,87610,88791,84250,84255,87578,87579,87593,87594,87608,87609,88151,88153,88789,88790,87653,87667,87674,87681,87702,87710,87711,87724,87725,87652,87658,87666,87672,87673,87679,87680,87686,87701,87707,87709,87721,87723,87735,88694,88695,88741,88742,88149,88587,84241,87234,87235,87236,87239,87240,87241,87244,87245,87246,87249,87250,87251,84240,88588,84239,84238,84254,84259,87577,87592,87607,88788,90054,90056,90057,84252,84253,84257,84258,87575,87576,87590,87591,87605,87606,88786,88787)) 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
84241 front-panel-and-plinth-1800mm 7148/7156/7194
84250 1700mm-straight-front-panel-and-plinth-en 7148/7156/7194
84251 1800mm-straight-front-panel-and-plinth-en 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
84255 1700mm-straight-front-panel-and-plinth-en-en 7148/7156/7194
84256 1800mm-straight-bath-front-panel-and-plinth 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
87232 straight-bath-front-panel-1700mm 7148/7156/7194
87233 straight-bath-front-panel-1800mm 7148/7156/7194
87234 straight-bath-end-panel-700mm 7148/7156/7194
87235 straight-bath-end-panel-750mm 7148/7156/7194
87236 straight-bath-end-panel-800mm 7148/7156/7194
87237 straight-bath-front-panel-1700mm-en 7148/7156/7194
87238 straight-bath-front-panel-1800mm-en 7148/7156/7194
87239 straight-bath-end-panel-700mm-en 7148/7156/7194
87240 straight-bath-end-panel-750mm-en 7148/7156/7194
87241 straight-bath-end-panel-800mm-en 7148/7156/7194
87242 straight-bath-front-panel-1700mm-en-en 7148/7156/7194
87243 straight-bath-front-panel-1800mm-en-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
87247 straight-bath-front-panel-1700mm-en-en-en 7148/7156/7194
87248 straight-bath-front-panel-1800mm-en-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
87578 urban-l-shape-square-shower-bath-front-panel-1700mm 7170/7248/7249
87579 urban-straight-bath-front-panel-1700mm 7170/7248/7249
87580 urban-straight-bath-front-panel-1800mm 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
87593 urban-l-shape-square-shower-bath-front-panel-1700mm-en 7170/7248/7249
87594 urban-straight-bath-front-panel-1700mm-en 7170/7248/7249
87595 urban-straight-bath-front-panel-1800mm-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
87608 urban-l-shape-square-shower-bath-front-panel-1700mm-en-en 7170/7248/7249
87609 urban-straight-bath-front-panel-1700mm-en-en 7170/7248/7249
87610 urban-straight-bath-front-panel-1800mm-en-en 7170/7248/7249
87652 1700mm-straight-bath-front-panel-and-plinth 7148/7156/7194
87653 1800mm-straight-bath-front-panel-and-plinth-en 7148/7156/7194
87658 1700mm-l-shape-square-shower-bath-front-panel-en 7148/7156/7194
87666 1700mm-straight-bath-front-panel-and-plinth-en-en 7148/7156/7194
87667 1800mm-straight-bath-front-panel-and-plinth-en-en-en 7148/7156/7194
87672 1700mm-l-shape-square-shower-bath-front-panel-en-en-en 7148/7156/7194
87673 1700mm-straight-bath-front-panel-and-plinth-en-en-en 7148/7156/7194
87674 1800mm-straight-bath-front-panel-and-plinth-en-en-en-en 7148/7156/7194
87679 1700mm-l-shape-square-shower-bath-front-panel-en-en-en-en 7148/7156/7194
87680 havana-straight-shower-bath-front-panel-and-plinth-1700mm 7195/7316/7317
87681 havana-straight-shower-bath-front-panel-and-plinth-1800mm 7195/7316/7317
87686 havana-square-l-shape-shower-bath-front-panel-and-plinth-1700mm 7195/7316/7317
87701 1700mm-straight-front-panel-and-plinth-en-en-en-en 7148/7156/7194
87702 1800mm-straight-front-panel-and-plinth-en-en-en 7148/7156/7194
87707 1700mm-l-shape-square-shower-bath-front-panel-en-en-en-en-en 7148/7156/7194
87709 1700mm-straight-front-panel-and-plinth-en-en-en-en-en 7148/7156/7194
87710 fusion-bath-front-panel-1800mm-en 7148/7156/7194
87711 1800mm-straight-front-panel-and-plinth-en-en-en-en 7148/7156/7194
87721 1700mm-l-shape-square-shower-bath-front-panel-en-en-en-en-en-en 7148/7156/7194
87723 1700mm-straight-front-panel-and-plinth-en-en-en-en-en-en 7148/7156/7194
87724 fusion-bath-front-panel-1800mm-en-en 7148/7156/7194
87725 1800mm-straight-front-panel-and-plinth-en-en-en-en-en 7148/7156/7194
87735 1700mm-l-shape-square-shower-bath-front-panel-en-en-en-en-en-en-en 7148/7156/7194
88149 l-shaped-shower-bath-front-panel-1700mm 7148/7156/7194
88151 1700mm-l-shape-square-shower-bath-front-panel-en-en-en-en-en-en-en-en-en 7148/7156/7194
88153 1700mm-l-shape-square-shower-bath-front-panel-en-en-en-en-en-en-en-en-en-en 7148/7156/7194
88587 fusion-l-shape-shower-bath-front-panel-1700mm 7148/7156/7194
88588 fusion-bath-front-panel-and-plinth-1700mm 7148/7156/7194
88694 fusion-l-shape-shower-bath-front-panel-1700mm-en-en 7148/7156/7194
88695 fusion-bath-front-panel-and-plinth-1700mm-en-en 7148/7156/7194
88741 fusion-l-shape-shower-bath-front-panel-1700mm-en-en-en 7148/7156/7194
88742 fusion-bath-front-panel-and-plinth-1700mm-en-en-en 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
88789 fusion-l-shape-shower-bath-front-panel-1700mm-en-en-en-en 7148/7156/7194
88790 fusion-bath-front-panel-and-plinth-1700mm-en-en-en-en 7148/7156/7194
88791 fusion-bath-front-panel-1800mm-en-en-en 7148/7156/7194
88904 back-to-wall-bath-panel 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
90824 back-to-wall-corner-bath-panel-lh 7195/7196
90825 back-to-wall-corner-bath-panel-right-hand 7195/7196