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 (
    84022, 84023, 84024, 84025, 84037, 92043, 
    92044, 92045, 92046, 92047, 92048, 
    92049, 92059, 92060, 92061, 92062, 
    92063, 92064, 92065, 92075, 92076, 
    92077, 92078, 92079, 92080, 92081, 
    92131, 92132, 92133, 92134, 92135, 
    92136, 92137, 89014, 92019, 92020, 
    92021, 92022, 92023, 92024, 92025, 
    92107, 92108, 92109, 92110, 92111, 
    92112, 92113, 89651, 84014, 84015, 
    84016, 84017, 84036, 89011, 90109, 
    83978, 83979, 83980, 83981, 88936, 
    89648, 83970, 83971, 83972, 83973, 
    89650, 90083, 84030, 84031, 84032, 
    84033, 84038, 88935, 88934, 83131, 
    90084, 89647, 89642, 89644, 90110, 
    92042, 92058, 92074, 92130, 85534, 
    90090, 90100, 83105, 84111, 88930, 
    90107, 90080, 89526, 90064, 89641
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00256

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 (84022,84023,84024,84025,84037,92043,92044,92045,92046,92047,92048,92049,92059,92060,92061,92062,92063,92064,92065,92075,92076,92077,92078,92079,92080,92081,92131,92132,92133,92134,92135,92136,92137,89014,92019,92020,92021,92022,92023,92024,92025,92107,92108,92109,92110,92111,92112,92113,89651,84014,84015,84016,84017,84036,89011,90109,83978,83979,83980,83981,88936,89648,83970,83971,83972,83973,89650,90083,84030,84031,84032,84033,84038,88935,88934,83131,90084,89647,89642,89644,90110,92042,92058,92074,92130,85534,90090,90100,83105,84111,88930,90107,90080,89526,90064,89641)) 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
83105 arvan-deck-mounted-3-tap-hole-basin-mixer-with-pop-up-waste 7184/7187
83131 arvan-wall-mounted-2-tap-hole-basin-mixer-with-plate-en-en-en 7184/7187
83970 white-topaz-with-lever-handle-mono-basin-mixer 7184/7187
83971 white-topaz-with-crosshead-handle-mono-basin-mixer 7184/7187
83972 white-topaz-with-lever-handle-mono-basin-mixer-en 7184/7187
83973 white-topaz-with-crosshead-handle-mono-basin-mixer-en 7184/7187
83978 white-topaz-with-lever-handle-3-tap-hole-basin-mixer 7184/7187
83979 white-topaz-with-crosshead-handle-3-tap-hole-basin-mixer 7184/7187
83980 white-topaz-with-lever-handle-3-tap-hole-basin-mixer-en 7184/7187
83981 white-topaz-with-crosshead-handle-3-tap-hole-basin-mixer-en 7184/7187
84014 black-topaz-with-lever-handle-mono-basin-mixer 7184/7187
84015 black-topaz-with-crosshead-handle-mono-basin-mixer 7184/7187
84016 black-topaz-with-lever-handle-mono-basin-mixer-en 7184/7187
84017 black-topaz-with-crosshead-handle-mono-basin-mixer-en 7184/7187
84022 black-topaz-with-lever-handle-3-tap-hole-basin-mixer 7184/7187
84023 black-topaz-with-crosshead-handle-3-tap-hole-basin-mixer 7184/7187
84024 black-topaz-with-lever-handle-3-tap-hole-basin-mixer-en 7184/7187
84025 black-topaz-with-crosshead-handle-3-tap-hole-basin-mixer-en 7184/7187
84030 black-topaz-with-lever-handle-3-tap-hole-wall-mounted-basin-mixer 7184/7187
84031 black-topaz-with-crosshead-handle-3-tap-hole-wall-mounted-basin-mixer 7184/7187
84032 black-topaz-with-lever-handle-3-tap-hole-wall-mounted-basin-mixer-en 7184/7187
84033 black-topaz-with-crosshead-handle-3-tap-hole-wall-mounted-basin-mixer-en 7184/7187
84036 brass-topaz-with-crosshead-handle-mono-basin-mixer 7184/7187
84037 brass-topaz-with-crosshead-handle-3-tap-hole-basin-mixer 7184/7187
84038 brass-topaz-with-crosshead-handle-3-tap-hole-wall-mounted-basin-mixer 7184/7187
84111 binsey-deck-mounted-3-tap-hole-basin-mixer-with-pop-up-waste 7184/7187
85534 drift-tall-mono-basin-mixer 7184/7187
88930 tec-single-lever-wall-mounted-basin-bath-filler 7184/7187
88934 tec-single-lever-high-rise-mixer 7184/7187
88935 tec-single-lever-wall-mounted-basin-bath-filler-matt-black 7184/7187
88936 tec-single-lever-wall-mounted-basin-bath-filler-brushed-brass 7184/7187
89011 tec-single-lever-high-rise-mixer-matt-black 7184/7187
89014 tec-single-lever-high-rise-mixer-brushed-brass 7184/7187
89526 sottile-wall-plated-single-lever-basin-mixer 7184/7187
89641 revolution-mono-basin-mixer 7184/7187
89642 revolution-wall-mounted-basin-mixer 7184/7187
89644 revolution-3-tap-hole-basin-mixer 7184/7187
89647 revolution-mono-basin-mixer-matt-black 7184/7187
89648 revolution-wall-mounted-basin-mixer-matt-black 7184/7187
89650 revolution-mono-basin-mixer-brushed-brass 7184/7187
89651 revolution-wall-mounted-basin-mixer-brushed-brass 7184/7187
90064 willow-wall-plated-single-lever-basin-mixer 7184/7187
90080 windon-wall-mounted-2-tap-hole-basin-mixer-with-plate 7184/7187
90083 windon-deck-mounted-3-tap-hole-basin-mixer-with-pop-up-waste 7184/7187
90084 windon-wall-mounted-3-tap-hole-basin-mixer-with-plate 7184/7187
90090 windon-wall-mounted-2-tap-hole-basin-mixer-with-plate-en 7184/7187
90100 windon-wall-mounted-2-tap-hole-basin-mixer-with-plate-en-en 7184/7187
90107 windon-mono-basin-mixer-with-push-button-waste-en-en-en 7184/7187
90109 windon-wall-mounted-2-tap-hole-basin-mixer-with-plate-en-en-en 7184/7187
90110 windon-high-rise-mono-basin-mixer-no-waste-en-en-en 7184/7187
92019 victrion-deck-mounted-crosshead-mono-basin-mixer-tap-en 7184
92020 victrion-deck-mounted-crosshead-mono-basin-mixer-tap-en-en 7184
92021 victrion-deck-mounted-crosshead-mono-basin-mixer-tap-en-en-en 7184
92022 victrion-deck-mounted-crosshead-mono-basin-mixer-tap-en-en-en-en 7184
92023 victrion-deck-mounted-crosshead-mono-basin-mixer-tap-en-en-en-en-en 7184
92024 victrion-deck-mounted-crosshead-mono-basin-mixer-tap-en-en-en-en-en-en 7184
92025 victrion-deck-mounted-crosshead-mono-basin-mixer-tap-en-en-en-en-en-en-en 7184
92042 victrion-deck-mounted-crosshead-3-tap-hole-basin-mixer-tap 7184
92043 victrion-deck-mounted-crosshead-3-tap-hole-basin-mixer-tap-en 7184
92044 victrion-deck-mounted-crosshead-3-tap-hole-basin-mixer-tap-en-en 7184
92045 victrion-deck-mounted-crosshead-3-tap-hole-basin-mixer-tap-en-en-en 7184
92046 victrion-deck-mounted-crosshead-3-tap-hole-basin-mixer-tap-en-en-en-en 7184
92047 victrion-deck-mounted-crosshead-3-tap-hole-basin-mixer-tap-en-en-en-en-en 7184
92048 victrion-deck-mounted-crosshead-3-tap-hole-basin-mixer-tap-en-en-en-en-en-en 7184
92049 victrion-deck-mounted-crosshead-3-tap-hole-basin-mixer-tap-en-en-en-en-en-en-en 7184
92058 victrion-wall-mount-crosshead-3-tap-hole-basin-filler-tap 7184
92059 victrion-wall-mount-crosshead-3-tap-hole-basin-filler-tap-en 7184
92060 victrion-wall-mount-crosshead-3-tap-hole-basin-filler-tap-en-en 7184
92061 victrion-wall-mount-crosshead-3-tap-hole-basin-filler-tap-en-en-en 7184
92062 victrion-wall-mount-crosshead-3-tap-hole-basin-filler-tap-en-en-en-en 7184
92063 victrion-wall-mount-crosshead-3-tap-hole-basin-filler-tap-en-en-en-en-en 7184
92064 victrion-wall-mount-crosshead-3-tap-hole-basin-filler-tap-en-en-en-en-en-en 7184
92065 victrion-wall-mount-crosshead-3-tap-hole-basin-filler-tap-en-en-en-en-en-en-en 7184
92074 victrion-wall-mount-lever-3-tap-hole-basin-filler-tap 7184
92075 victrion-wall-mount-lever-3-tap-hole-basin-filler-tap-en 7184
92076 victrion-wall-mount-lever-3-tap-hole-basin-filler-tap-en-en 7184
92077 victrion-wall-mount-lever-3-tap-hole-basin-filler-tap-en-en-en 7184
92078 victrion-wall-mount-lever-3-tap-hole-basin-filler-tap-en-en-en-en 7184
92079 victrion-wall-mount-lever-3-tap-hole-basin-filler-tap-en-en-en-en-en 7184
92080 victrion-wall-mount-lever-3-tap-hole-basin-filler-tap-en-en-en-en-en-en 7184
92081 victrion-wall-mount-lever-3-tap-hole-basin-filler-tap-en-en-en-en-en-en-en 7184
92107 victrion-deck-mounted-lever-mono-basin-mixer-tap-en 7184
92108 victrion-deck-mounted-lever-mono-basin-mixer-tap-en-en 7184
92109 victrion-deck-mounted-lever-mono-basin-mixer-tap-en-en-en 7184
92110 victrion-deck-mounted-lever-mono-basin-mixer-tap-en-en-en-en 7184
92111 victrion-deck-mounted-lever-mono-basin-mixer-tap-en-en-en-en-en 7184
92112 victrion-deck-mounted-lever-mono-basin-mixer-tap-en-en-en-en-en-en 7184
92113 victrion-deck-mounted-lever-mono-basin-mixer-tap-en-en-en-en-en-en-en 7184
92130 victrion-deck-mounted-lever-3-tap-hole-basin-mixer-tap 7184
92131 victrion-deck-mounted-lever-3-tap-hole-basin-mixer-tap-en 7184
92132 victrion-deck-mounted-lever-3-tap-hole-basin-mixer-tap-en-en 7184
92133 victrion-deck-mounted-lever-3-tap-hole-basin-mixer-tap-en-en-en 7184
92134 victrion-deck-mounted-lever-3-tap-hole-basin-mixer-tap-en-en-en-en 7184
92135 victrion-deck-mounted-lever-3-tap-hole-basin-mixer-tap-en-en-en-en-en 7184
92136 victrion-deck-mounted-lever-3-tap-hole-basin-mixer-tap-en-en-en-en-en-en 7184
92137 victrion-deck-mounted-lever-3-tap-hole-basin-mixer-tap-en-en-en-en-en-en-en 7184