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 (
    90150, 90165, 84073, 84081, 90149, 90164, 
    90142, 90157, 90148, 90163, 84072, 
    84080, 90147, 90162, 84071, 84079, 
    84095, 90141, 90156, 90297, 90304, 
    84057, 84065, 84070, 84078, 85973, 
    84069, 84077, 90140, 90155, 84068, 
    84076, 84094, 90139, 90154, 90296, 
    90303, 83944, 84088, 90203, 90214, 
    84093, 85972, 90153, 90168, 90285, 
    90293, 90295, 90302, 84056, 84064, 
    90152, 90167, 85971, 84067, 84075, 
    84092, 84055, 84063, 85966, 90294, 
    90301, 90131, 90132, 83943, 84087, 
    90250, 90258, 90180, 90181, 90202, 
    90213, 84054, 84062, 90151, 90166, 
    85970, 84091, 90146, 90161, 90300, 
    90307, 84053, 84061, 83942, 84086, 
    90231, 90246, 84066, 84074, 90201, 
    90212, 90137, 90138, 84090, 85969
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00259

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 (90150,90165,84073,84081,90149,90164,90142,90157,90148,90163,84072,84080,90147,90162,84071,84079,84095,90141,90156,90297,90304,84057,84065,84070,84078,85973,84069,84077,90140,90155,84068,84076,84094,90139,90154,90296,90303,83944,84088,90203,90214,84093,85972,90153,90168,90285,90293,90295,90302,84056,84064,90152,90167,85971,84067,84075,84092,84055,84063,85966,90294,90301,90131,90132,83943,84087,90250,90258,90180,90181,90202,90213,84054,84062,90151,90166,85970,84091,90146,90161,90300,90307,84053,84061,83942,84086,90231,90246,84066,84074,90201,90212,90137,90138,84090,85969)) 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
83942 1100mm-wetroom-screen-with-arms-and-feet 7165/7166/7193
83943 1200mm-wetroom-screen-with-arms-and-feet 7165/7166/7193
83944 1400mm-wetroom-screen-with-arms-and-feet 7165/7166/7193
84053 900mm-frame-screen-with-arms-and-feet 7165/7166/7193
84054 1000mm-frame-screen-with-arms-and-feet 7165/7166/7193
84055 1100mm-frame-screen-with-arms-and-feet 7165/7166/7193
84056 1200mm-frame-screen-with-arms-and-feet 7165/7166/7193
84057 1400mm-frame-screen-with-arms-and-feet 7165/7166/7193
84061 abstract-900mm-frame-wetroom-screen-with-support-bars 7165/7166/7193
84062 abstract-1000mm-frame-wetroom-screen-with-support-bars 7165/7166/7193
84063 abstract-1100mm-frame-wetroom-screen-with-support-bars 7165/7166/7193
84064 abstract-1200mm-frame-wetroom-screen-with-support-bars 7165/7166/7193
84065 abstract-1400mm-frame-wetroom-screen-with-support-bars 7165/7166/7193
84066 700mm-frame-screen-with-ceiling-posts 7165/7166/7193
84067 760mm-frame-screen-with-ceiling-posts 7165/7166/7193
84068 800mm-frame-screen-with-ceiling-posts 7165/7166/7193
84069 900mm-frame-screen-with-ceiling-posts 7165/7166/7193
84070 1000mm-frame-screen-with-ceiling-posts 7165/7166/7193
84071 1100mm-frame-screen-with-ceiling-posts 7165/7166/7193
84072 1200mm-frame-screen-with-ceiling-posts 7165/7166/7193
84073 1400mm-frame-screen-with-ceiling-posts 7165/7166/7193
84074 abstract-700mm-frame-wetroom-screen-with-ceiling-posts 7165/7166/7193
84075 abstract-760mm-frame-wetroom-screen-with-ceiling-posts 7165/7166/7193
84076 abstract-800mm-frame-wetroom-screen-with-ceiling-posts 7165/7166/7193
84077 abstract-900mm-frame-wetroom-screen-with-ceiling-posts 7165/7166/7193
84078 abstract-1000mm-frame-wetroom-screen-with-ceiling-posts 7165/7166/7193
84079 abstract-1100mm-frame-wetroom-screen-with-ceiling-posts 7165/7166/7193
84080 abstract-1200mm-frame-wetroom-screen-with-ceiling-posts 7165/7166/7193
84081 abstract-1400mm-frame-wetroom-screen-with-ceiling-posts 7165/7166/7193
84086 1100mm-wetroom-screen-with-arms-and-feet-en 7165/7166/7193
84087 1200mm-wetroom-screen-with-arms-and-feet-en 7165/7166/7193
84088 1400mm-wetroom-screen-with-arms-and-feet-en 7165/7166/7193
84090 800mm-wetroom-screen-with-ceiling-posts 7165/7166/7193
84091 900mm-wetroom-screen-with-ceiling-posts 7165/7166/7193
84092 1000mm-wetroom-screen-with-ceiling-posts 7165/7166/7193
84093 1100mm-wetroom-screen-with-ceiling-posts 7165/7166/7193
84094 1200mm-wetroom-screen-with-ceiling-posts 7165/7166/7193
84095 1400mm-wetroom-screen-with-ceiling-posts 7165/7166/7193
85966 1400mm-wetroom-screen-with-arms-and-feet-en-en 7165/7166/7193
85969 900mm-wetroom-screen-with-ceiling-post 7165/7166/7193
85970 1000mm-wetroom-screen-with-ceiling-post 7165/7166/7193
85971 1100mm-wetroom-screen-with-ceiling-posts-en 7165/7166/7193
85972 1200mm-wetroom-screen-with-ceiling-post 7165/7166/7193
85973 1400mm-wetroom-screen-with-ceiling-post 7165/7166/7193
90131 1000mm-fluted-wetroom-scren-with-arms-and-feet-brushed-brass 7165/7166/7193
90132 1000mm-fluted-wetroom-scren-with-arms-and-feet-matt-black 7165/7166/7193
90137 900mm-fluted-wetroom-scren-with-arms-and-feet-brushed-brass 7165/7166/7193
90138 900mm-fluted-wetroom-scren-with-arms-and-feet-matt-black 7165/7166/7193
90139 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-1850mm-x-1000mm-x-8mm 7165/7166/7193
90140 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-1850mm-x-1100mm-x-8mm 7165/7166/7193
90141 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-1850mm-x-1200mm-x-8mm 7165/7166/7193
90142 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-1850mm-x-1400mm-x-8mm 7165/7166/7193
90146 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-1850mm-x-900mm-x-8mm 7165/7166/7193
90147 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-1000mm-x-8mm 7165/7166/7193
90148 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-1100mm-x-8mm 7165/7166/7193
90149 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-1200mm-x-8mm 7165/7166/7193
90150 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-1400mm-x-8mm 7165/7166/7193
90151 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-700mm-x-8mm 7165/7166/7193
90152 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-800mm-x-8mm 7165/7166/7193
90153 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-900mm-x-8mm 7165/7166/7193
90154 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-1850mm-x-1000mm-x-8mm-en 7165/7166/7193
90155 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-1850mm-x-1100mm-x-8mm-en 7165/7166/7193
90156 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-1850mm-x-1200mm-x-8mm-en 7165/7166/7193
90157 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-1850mm-x-1400mm-x-8mm-en 7165/7166/7193
90161 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-1850mm-x-900mm-x-8mm-en 7165/7166/7193
90162 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-1000mm-x-8mm-en 7165/7166/7193
90163 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-1100mm-x-8mm-en 7165/7166/7193
90164 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-1200mm-x-8mm-en 7165/7166/7193
90165 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-1400mm-x-8mm-en 7165/7166/7193
90166 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-700mm-x-8mm-en 7165
90167 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-800mm-x-8mm-en 7165/7166/7193
90168 full-outer-frame-wetroom-screens-full-outer-frame-wetroom-8mm-toughened-safety-glass-screen-and-support-bar-1950mm-x-900mm-x-8mm-en 7165/7166/7193
90180 1000mm-fluted-wetroom-screen-with-support-bar-brushed-brass 7165/7166/7193
90181 1000mm-fluted-wetroom-screen-with-support-bar-matt-black 7165/7166/7193
90201 1100mm-wetroom-screen-with-brass-support-bar 7165/7166/7193
90202 1200mm-wetroom-screen-with-brass-support-bar 7165/7166/7193
90203 1400mm-wetroom-screen-with-brass-support-bar 7165/7166/7193
90212 1100mm-wetroom-screen-with-black-support-bar 7165/7166/7193
90213 1200mm-wetroom-screen-with-black-support-bar 7165/7166/7193
90214 1400mm-wetroom-screen-with-black-support-bar 7165/7166/7193
90231 1400mm-wetroom-screen-with-support-bar 7165/7166/7193
90246 1400mm-wetroom-screen-with-support-bar-en 7165/7166/7193
90250 1400mm-outer-framed-wetroom-screen-with-support-bar 7165/7166/7193
90258 1400mm-outer-framed-wetroom-screen-with-support-bar-en 7165/7166/7193
90285 1400mm-framed-wetroom-screen 7165/7166/7193
90293 abstract-1400mm-frame-wetroom-screen-8mm-glass 7165/7166/7193
90294 1000mm-outer-framed-wetroom-screen-with-support-bar-en-en 7165/7166/7193
90295 1100mm-outer-framed-wetroom-screen-with-support-bar-en-en 7165/7166/7193
90296 1200mm-outer-framed-wetroom-screen-with-support-bar-en-en 7165/7166/7193
90297 1400mm-outer-framed-wetroom-screen-with-support-bar-en-en 7165/7166/7193
90300 900mm-outer-framed-wetroom-screen-with-support-bar-en-en 7165/7166/7193
90301 1000mm-outer-framed-wetroom-screen-with-support-bar-en-en-en 7165/7166/7193
90302 1100mm-outer-framed-wetroom-screen-with-support-bar-en-en-en 7165/7166/7193
90303 1200mm-outer-framed-wetroom-screen-with-support-bar-en-en-en 7165/7166/7193
90304 1400mm-outer-framed-wetroom-screen-with-support-bar-en-en-en 7165/7166/7193
90307 900mm-outer-framed-wetroom-screen-with-support-bar-en-en-en 7165/7166/7193