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 (
    86855, 84265, 89384, 89389, 89300, 89432, 
    89731, 89439, 82381, 89301, 82396, 
    86851, 89440, 82416, 86853, 89431, 
    89299, 84263, 84267, 89349, 89334, 
    83088, 89124, 89128, 89160, 89551, 
    82343, 89350, 89263, 89340, 82450, 
    82451, 86238, 91290, 84264, 91913, 
    91914, 91915, 91916, 91917, 91918, 
    91919, 82332, 86814, 86844, 89101, 
    89336, 89729, 89734, 91286, 82415, 
    86854, 89339, 82355, 90093, 90103, 
    90112, 89438, 82398, 86849, 89730, 
    91293, 89353, 82380, 89333, 89354, 
    82340, 82341, 82346, 86389, 86391, 
    89430, 83115, 83125, 83134, 82449, 
    86823, 89123, 89127, 89159, 89550, 
    89355, 89356, 83087, 89284, 89437, 
    91289, 84262, 84266, 90120, 89157, 
    89548, 90092, 90102, 90111, 89335
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00240

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 (86855,84265,89384,89389,89300,89432,89731,89439,82381,89301,82396,86851,89440,82416,86853,89431,89299,84263,84267,89349,89334,83088,89124,89128,89160,89551,82343,89350,89263,89340,82450,82451,86238,91290,84264,91913,91914,91915,91916,91917,91918,91919,82332,86814,86844,89101,89336,89729,89734,91286,82415,86854,89339,82355,90093,90103,90112,89438,82398,86849,89730,91293,89353,82380,89333,89354,82340,82341,82346,86389,86391,89430,83115,83125,83134,82449,86823,89123,89127,89159,89550,89355,89356,83087,89284,89437,91289,84262,84266,90120,89157,89548,90092,90102,90111,89335)) 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
82332 tec-pura-triple-thermostatic-shower-valve-with-diverter 7143/7144/7147
82340 edwardian-triple-thermostatic-shower-valve 7143/7144/7145
82341 edwardian-triple-thermostatic-shower-valve-en 7143/7144/7145
82343 square-showers-twin-thermostatic-shower-valve-with-diverter 7143/7144/7145
82346 victorian-triple-thermostatic-shower-valve 7143/7144/7145
82355 shower-kits-traditional-thermostatic-shower-valve-and-kit-en 7143/7153/7155
82380 multi-option-shower-kits-round-brass-thermostatic-bar-valve-and-shower-kit 7143/7153/7155
82381 multi-option-shower-kits-square-brass-thermostatic-bar-valve-and-shower-kit 7143/7153/7155
82396 tec-pura-triple-thermostatic-shower-valve-matt-black 7143/7144/7147
82398 tec-pura-twin-thermostatic-shower-valve-with-diverter-matt-black 7143/7144/7145
82415 tec-pura-twin-thermostatic-shower-valve-brushed-brass 7143/7144/7145
82416 tec-pura-twin-thermostatic-shower-valve-with-diverter-brushed-brass 7143/7144/7145
82449 shower-kits-rigid-riser-kit-en-en-en-en 7148/7149/7160
82450 shower-kits-deluxe-grand-rigid-riser-kit 7148/7149/7160
82451 shower-kits-rigid-riser-kit-en-en-en-en-en 7148/7149/7160
83087 art-triple-thermostatic-shower-valve 7143/7144/7145
83088 art-triple-thermostatic-shower-valve-with-diverter 7143/7144/7147
83115 arvan-triple-thermostatic-valve-with-diverter 7143/7144/7147
83125 arvantriple-thermostatic-valve-with-diverter 7143/7144/7147
83134 arvan-triple-thermostatic-valve-with-diverter-en 7143/7144/7147
84262 black-topaz-twin-concealed-shower-valve 7143/7144/7146
84263 black-topaz-triple-concealed-shower-valve 7143/7144/7145
84264 black-topaz-twin-concealed-shower-valve-with-diverter 7143/7144/7145
84265 black-topaz-triple-concealed-shower-valve-with-diverter 7143/7144/7147
84266 black-topaz-twin-exposed-shower-valve 7143/7144/7146
84267 black-topaz-triple-exposed-shower-valve 7143/7144/7145
86238 fixed-shower-heads-ceiling-tile-fixed-head-en-en 7148/7149/7227
86389 victorian-triple-thermostatic-shower-valve-en 7143/7144/7145
86391 victorian-triple-thermostatic-shower-valve-en-en 7143/7144/7145
86814 square-showers-triple-thermostatic-shower-valve-with-diverter 7143/7144/7147
86823 shower-kits-square-thermostatic-bar-valve-and-shower-kit-en-en 7143/7153/7155
86844 tec-crosshead-triple-thermostatic-shower-valve-with-diverter 7143/7144/7147
86849 tec-crosshead-twin-thermostatic-shower-valve-with-diverter-matt-black 7143/7144/7145
86851 tec-crosshead-triple-thermostatic-shower-valve-matt-black 7143/7144/7147
86853 tec-crosshead-twin-thermostatic-shower-valve-with-diverter-brushed-brass 7143/7144/7145
86854 tec-crosshead-twin-thermostatic-shower-valve-brushed-brass 7143/7144/7145
86855 tec-crosshead-triple-thermostatic-shower-valve-brushed-brass 7143/7144/7147
89101 round-showers-triple-thermostatic-shower-valve-with-diverter 7143/7144/7147
89123 reign-triple-thermostatic-shower-valve 7143/7144/7145
89124 reign-triple-thermostatic-shower-valve-with-diverter 7143/7144/7147
89127 reign-triple-thermostatic-shower-valve-en 7143/7144/7145
89128 reign-triple-thermostatic-shower-valve-with-diverter-en 7143/7144/7147
89157 indus-twin-thermostatic-shower-valve-with-diverter 7143/7144/7145
89159 round-valves-triple-valve 7143/7144/7145
89160 round-valves-triple-valve-with-diverter 7143/7144/7147
89263 concealed-round-thermostatic-twin-valve-and-head 7143/7153/7154
89284 1-outlet-bundle-arvan 7143/7153/7288
89299 binsey-thermostatic-concealed-twin-round-valve-with-diverter-slide-rail-kit-with-multi-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-round-fixed-head-shower-kit 7143/7153/7154
89300 concealed-round-thermostatic-triple-valve-kit-and-head-en 7143/7153/7154
89301 arvan-thermostatic-concealed-twin-round-valve-with-diverter-slide-rail-kit-with-multi-function-handset-and-outlet-elbow-wall-mount-shower-arm-and-round-fixed-head-shower-kit 7143/7153/7154
89333 windon-thermostatic-square-bath-shower-mixer-and-single-function-slide-rail-shower-kit 7143/7153/7155
89334 windon-thermostatic-square-bath-shower-mixer-and-single-function-slide-rail-shower-kit-en 7143/7153/7155
89335 sanford-thermostatic-square-bath-shower-mixer-and-single-function-slide-rail-shower-kit 7143/7153/7155
89336 sanford-thermostatic-square-bath-shower-mixer-and-single-function-slide-rail-shower-kit-en 7143/7153/7155
89339 1-outlet-bundle-windon 7143/7153/7288
89340 1-outlet-bundle-windon-en 7143/7153/7288
89349 concealed-square-thermostatic-twin-valve-and-kit 7143/7153/7154
89350 thermostatic-concealed-twin-square-valve-wall-mount-shower-arm-and-square-fixed-head-shower-kit 7143/7153/7154
89353 concealed-square-thermostatic-twin-valve-and-kit-en 7143/7153/7154
89354 windon-thermostatic-concealed-twin-square-valve-wall-mount-shower-arm-and-square-fixed-head-shower-kit 7143/7153/7154
89355 sanford-thermostatic-concealed-twin-square-valve-and-slide-rail-kit-with-single-function-handset-and-outlet-elbow-shower-kit 7143/7153/7154
89356 concealed-square-thermostatic-twin-valve-and-head 7143/7153/7154
89384 dual-exposed-valve-and-slide-rail-kit 7143/7153/7154
89389 dual-exposed-valve-and-slide-rail-kit-en 7143/7153/7154
89430 industrial-valves-triple-valve 7143/7144/7145
89431 industrial-valves-triple-valve-with-diverter 7143/7144/7147
89432 industrial-valves-triple-valve-matt-black 7143/7144/7147
89437 industrial-valves-twin-valve-with-diverter 7143/7144/7145
89438 industrial-valves-twin-valve-matt-black 7143/7144/7145
89439 industrial-valves-twin-valve-with-diverter-matt-black 7143/7144/7145
89440 industrial-valves-twin-valve-brushed-brass 7143/7144/7145
89548 lennox-twin-thermostatic-shower-valve-with-diverter 7143/7144/7145
89550 square-valves-triple-valve 7143/7144/7145
89551 square-valves-triple-valve-with-diverter 7143/7144/7147
89729 white-topaz-triple-thermostatic-shower-valve 7143/7144/7145
89730 white-topaz-twin-concealed-shower-valve-with-diverter 7143/7144/7145
89731 white-topaz-triple-concealed-shower-valve-with-diverter 7143/7144/7147
89734 white-topaz-triple-thermostatic-shower-valve-en 7143/7144/7145
90092 windon-triple-thermostatic-valve 7143/7144/7145
90093 windon-triple-thermostatic-valve-with-diverter 7143/7144/7147
90102 windon-triple-thermostatic-valve-en 7143/7144/7145
90103 windon-triple-thermostatic-valve-with-diverter-en 7143/7144/7147
90111 windon-triple-thermostatic-valve-en-en 7143/7144/7145
90112 windon-triple-thermostatic-valve-with-diverter-en-en 7143/7144/7147
90120 windon-triple-thermostatic-valve-with-diverter-en-en-en 7143/7144/7147
91286 aztec-triple-thermostatic-concealed-shower-valve-with-diverter-3-outlet-en 7143
91289 aztec-triple-thermostatic-concealed-shower-valve-2-outlet-en 7143
91290 aztec-triple-thermostatic-concealed-shower-valve-with-diverter-3-outlet-en-en 7143
91293 aztec-triple-thermostatic-concealed-shower-valve-2-outlet-en-en 7143
91913 victrion-single-outlet-twin-thermostatic-concealed-shower-valve-en 7143
91914 victrion-single-outlet-twin-thermostatic-concealed-shower-valve-en-en 7143
91915 victrion-single-outlet-twin-thermostatic-concealed-shower-valve-en-en-en 7143
91916 victrion-single-outlet-twin-thermostatic-concealed-shower-valve-en-en-en-en 7143
91917 victrion-single-outlet-twin-thermostatic-concealed-shower-valve-en-en-en-en-en 7143
91918 victrion-single-outlet-twin-thermostatic-concealed-shower-valve-en-en-en-en-en-en 7143
91919 victrion-single-outlet-twin-thermostatic-concealed-shower-valve-en-en-en-en-en-en-en 7143