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 (
    90227, 84051, 84059, 90281, 90289, 85963, 
    90177, 90178, 90247, 90255, 83939, 
    84083, 90207, 90218, 90179, 90133, 
    90229, 90244, 90280, 90288, 90194, 
    90254, 90262, 85962, 90228, 90243, 
    83938, 84082, 90169, 90174, 90175, 
    90206, 90217, 90193, 84050, 84058, 
    90226, 90237, 90242, 90253, 90261, 
    90186, 85961, 90252, 90260, 90251, 
    90259, 90279
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00084

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 (90227,84051,84059,90281,90289,85963,90177,90178,90247,90255,83939,84083,90207,90218,90179,90133,90229,90244,90280,90288,90194,90254,90262,85962,90228,90243,83938,84082,90169,90174,90175,90206,90217,90193,84050,84058,90226,90237,90242,90253,90261,90186,85961,90252,90260,90251,90259,90279)) 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
83938 700mm-wetroom-screen-with-arms-and-feet 7165/7166/7193
83939 800mm-wetroom-screen-with-arms-and-feet 7165/7166/7193
84050 700mm-frame-screen-with-arms-and-feet 7165/7166/7193
84051 760mm-frame-screen-with-arms-and-feet 7165/7166/7193
84058 abstract-700mm-frame-wetroom-screen-with-support-bars 7165/7166/7193
84059 abstract-760mm-frame-wetroom-screen-with-support-bars 7165/7166/7193
84082 700mm-wetroom-screen-with-arms-and-feet-en 7165/7166/7193
84083 800mm-wetroom-screen-with-arms-and-feet-en 7165/7166/7193
85961 800mm-wetroom-screen-with-arms-and-feet-en-en 7165/7166/7193
85962 900mm-wetroom-screen-with-arms-and-feet-en-en 7165/7166/7193
85963 1000mm-wetroom-screen-with-arms-and-feet-en-en 7165/7166/7193
90133 800mm-fluted-wetroom-scren-with-arms-and-feet-polished-chrome 7165/7166/7193
90169 fluted-wetroom-screens-1000mmx1850mm-fluted-wetroom-screen-including-support-bar 7165/7166/7193
90174 fluted-wetroom-screens-800mmx1850mm-fluted-wetroom-screen-including-support-bar-en 7165/7166/7193
90175 fluted-wetroom-screens-800mmx1850mm-fluted-wetroom-screen-including-support-bar-en-en 7165/7166/7193
90177 fluted-wetroom-screens-900mmx1850mm-fluted-wetroom-screen-including-support-bar-en 7165/7166/7193
90178 fluted-wetroom-screens-900mmx1850mm-fluted-wetroom-screen-including-support-bar-en-en 7165/7166/7193
90179 1000mm-x-1950mm-fluted-wetroom-screen-inc-bar-polished-chrome 7165/7166/7193
90186 900mm-x-1950mm-fluted-wetroom-screen-inc-bar-polished-chrome 7165/7166/7193
90193 1100mm-wetroom-screen-and-support-bar 7165/7166/7193
90194 1200mm-wetroom-screen-and-support-bar 7165/7166/7193
90206 700mm-wetroom-screen-with-brass-support-bar 7165/7166/7193
90207 800mm-wetroom-screen-with-brass-support-bar 7165/7166/7193
90217 700mm-wetroom-screen-with-black-support-bar 7165/7166/7193
90218 800mm-wetroom-screen-with-black-support-bar 7165/7166/7193
90226 1200mm-wetroom-screen-and-support-bar-en 7165/7166/7193
90227 1400mm-wetroom-screen-and-support-bar-en 7165/7166/7193
90228 1000mm-wetroom-screen-with-support-bar 7165/7166/7193
90229 1100mm-wetroom-screen-with-support-bar 7165/7166/7193
90237 900mm-wetroom-screen-with-support-bar 7165/7166/7193
90242 900mm-wetroom-screen-with-support-bar-en 7165/7166/7193
90243 1000mm-wetroom-screen-with-support-bar-en 7165/7166/7193
90244 1100mm-wetroom-screen-with-support-bar-en 7165/7166/7193
90247 1000mm-outer-framed-wetroom-screen-with-support-bar 7165/7166/7193
90251 700mm-outer-framed-wetroom-screen-with-support-bar 7165/7166/7193
90252 760mm-outer-framed-wetroom-screen-with-support-bar 7165/7166/7193
90253 800mm-outer-framed-wetroom-screen-with-support-bar 7165/7166/7193
90254 900mm-outer-framed-wetroom-screen-with-support-bar 7165/7166/7193
90255 1000mm-outer-framed-wetroom-screen-with-support-bar-en 7165/7166/7193
90259 700mm-outer-framed-wetroom-screen-with-support-bar-en 7165/7166/7193
90260 760mm-outer-framed-wetroom-screen-with-support-bar-en 7165/7166/7193
90261 800mm-outer-framed-wetroom-screen-with-support-bar-en 7165/7166/7193
90262 900mm-outer-framed-wetroom-screen-with-support-bar-en 7165/7166/7193
90279 760mm-framed-wetroom-screen 7165/7166/7193
90280 800mm-framed-wetroom-screen 7165/7166/7193
90281 900mm-framed-wetroom-screen 7165/7166/7193
90288 abstract-800mm-frame-wetroom-screen-8mm-glass 7165/7166/7193
90289 abstract-900mm-frame-wetroom-screen-8mm-glass 7165/7166/7193