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 (
    87296, 87297, 85852, 85853, 85862, 85863, 
    91007, 91008, 91019, 91020, 91031, 
    91032, 91044, 91045, 85842, 85843, 
    91004, 91005, 91016, 91017, 91028, 
    91029, 91040, 91041, 91042, 90008, 
    90564, 90570, 90576, 84678, 87304, 
    87305, 87316, 87317, 87328, 87329, 
    87340, 87341, 89818, 89819, 89870, 
    89871, 89942, 89943, 91508, 91509, 
    83083, 83084, 83611, 83612, 90922, 
    90923, 91001, 91002, 87292, 87293, 
    89816, 89868, 89940, 91506, 85848, 
    85849, 85858, 85859, 83081, 83609, 
    90920, 90999, 89997, 90004, 86471, 
    86472, 86747, 86748, 85838, 85839, 
    90546, 89817, 89869, 89941, 91507, 
    83082, 83610, 90921, 91000, 86469, 
    86745, 84808, 84809, 84826, 84827, 
    84838, 84839, 91106, 91192, 91247
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00199

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 (87296,87297,85852,85853,85862,85863,91007,91008,91019,91020,91031,91032,91044,91045,85842,85843,91004,91005,91016,91017,91028,91029,91040,91041,91042,90008,90564,90570,90576,84678,87304,87305,87316,87317,87328,87329,87340,87341,89818,89819,89870,89871,89942,89943,91508,91509,83083,83084,83611,83612,90922,90923,91001,91002,87292,87293,89816,89868,89940,91506,85848,85849,85858,85859,83081,83609,90920,90999,89997,90004,86471,86472,86747,86748,85838,85839,90546,89817,89869,89941,91507,83082,83610,90921,91000,86469,86745,84808,84809,84826,84827,84838,84839,91106,91192,91247)) 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
83081 arno-800mm-floor-standing-2-drawer-vanity-and-mid-edge-basin-en-en-en-en-en-en 7170/7191
83082 arno-800mm-floor-standing-2-drawer-vanity-and-minimalist-basin-en-en-en-en-en-en 7170/7191
83083 arno-800mm-floor-standing-2-drawer-vanity-and-thin-edge-basin-en-en-en-en-en-en 7170/7191
83084 arno-800mm-floor-standing-2-drawer-vanity-and-curved-basin-en-en-en-en-en-en 7170/7191
83609 athena-floor-standing-2-drawer-vanity-with-mid-edge-1-tap-hole-basin-800mm-en-en-en-en-en 7170/7191
83610 athena-floor-standing-2-drawer-vanity-with-minimalist-1-tap-hole-basin-800mm-en-en-en-en-en 7170/7191
83611 athena-floor-standing-2-drawer-vanity-with-thin-edge-1-tap-hole-basin-800mm-en-en-en-en-en 7170/7191
83612 athena-floor-standing-2-drawer-vanity-with-curved-1-tap-hole-basin-800mm-en-en-en-en-en 7170/7191
84678 fusion-wall-hung-4-door-vanity-unit-and-polymarble-basin-compact-1000mm-en-en-en-en-en 7170/7191
84808 classique-floor-standing-2-door-vanity-basin-unit-and-1-tap-hole-fireclay-basin-800mm-en 7170/7191
84809 classique-floor-standing-2-door-vanity-basin-unit-and-3-tap-hole-fireclay-basin-800mm-en 7170/7191
84826 classique-floor-standing-2-door-vanity-basin-unit-and-1-tap-hole-fireclay-basin-800mm-en-en 7170/7191
84827 classique-floor-standing-2-door-vanity-basin-unit-and-3-tap-hole-fireclay-basin-800mm-en-en 7170/7191
84838 classique-floor-standing-2-door-vanity-basin-unit-and-1-tap-hole-fireclay-basin-800mm-en-en-en 7170/7191
84839 classique-floor-standing-2-door-vanity-basin-unit-and-3-tap-hole-fireclay-basin-800mm-en-en-en 7170/7191
85838 parade-floor-standing-2-drawer-vanity-unit-with-polymarble-basin-600mm 7170/7191
85839 parade-floor-standing-2-drawer-vanity-unit-with-ceramic-basin-600mm 7170/7191
85842 parade-floor-standing-2-drawer-vanity-unit-with-polymarble-basin-800mm 7170/7191
85843 parade-floor-standing-2-drawer-vanity-unit-with-ceramic-basin-800mm 7170/7191
85848 parade-floor-standing-2-drawer-vanity-basin-unit-and-polymarble-basin-600mm 7170/7191
85849 parade-floor-standing-2-drawer-vanity-basin-unit-and-ceramic-basin-600mm 7170/7191
85852 parade-floor-standing-2-drawer-vanity-basin-unit-and-polymarble-basin-800mm 7170/7191
85853 parade-floor-standing-2-drawer-vanity-basin-unit-and-ceramic-basin-800mm 7170/7191
85858 parade-floor-standing-2-drawer-vanity-basin-unit-and-polymarble-basin-600mm-en 7170/7191
85859 parade-floor-standing-2-drawer-vanity-basin-unit-and-ceramic-basin-600mm-en 7170/7191
85862 parade-floor-standing-2-drawer-vanity-basin-unit-and-polymarble-basin-800mm-en 7170/7191
85863 parade-floor-standing-2-drawer-vanity-basin-unit-and-ceramic-basin-800mm-en 7170/7191
86469 juno-800mm-floor-standing-2-door-vanity-and-mid-edge-1-tap-hole-basin-en 7170/7191/7310
86471 juno-800mm-floor-standing-2-door-vanity-and-thin-edge-1-tap-hole-basin-en 7170/7191/7310
86472 juno-800mm-floor-standing-2-door-vanity-and-curved-1-tap-hole-basin-en 7170/7191/7310
86745 juno-floor-standing-2-door-vanity-basin-unit-and-mid-edge-ceramic-basin-800mm 7170/7191
86747 juno-floor-standing-2-door-vanity-basin-unit-and-thin-edge-ceramic-basin-800mm 7170/7191
86748 juno-floor-standing-2-door-vanity-basin-unit-and-curved-ceramic-basin-800mm 7170/7191
87292 lunar-floor-standing-2-drawer-unit-and-polymarble-basin-600mm 7170/7191
87293 lunar-floor-standing-2-drawer-unit-and-ceramic-basin-600mm 7170/7191
87296 lunar-floor-standing-2-drawer-unit-and-polymarble-basin-800mm 7170/7191
87297 lunar-floor-standing-2-drawer-unit-and-ceramic-basin-800mm 7170/7191
87304 lunar-floor-standing-2-drawer-unit-and-polymarble-basin-600mm-en 7170/7191
87305 lunar-floor-standing-2-drawer-unit-and-ceramic-basin-600mm-en 7170/7191
87316 lunar-floor-standing-2-drawer-unit-and-polymarble-basin-600mm-en-en 7170/7191
87317 lunar-floor-standing-2-drawer-unit-and-ceramic-basin-600mm-en-en 7170/7191
87328 lunar-floor-standing-2-drawer-unit-and-polymarble-basin-600mm-en-en-en 7170/7191
87329 lunar-floor-standing-2-drawer-unit-and-ceramic-basin-600mm-en-en-en 7170/7191
87340 lunar-floor-standing-2-drawer-unit-and-polymarble-basin-600mm-en-en-en-en 7170/7191
87341 lunar-floor-standing-2-drawer-unit-and-ceramic-basin-600mm-en-en-en-en 7170/7191
89816 urban-floor-standing-2-door-1-drawer-vanity-unit-with-mid-edge-basin-800mm-en 7170/7191
89817 urban-floor-standing-2-door-1-drawer-vanity-unit-with-minimalist-basin-800mm-en 7170/7191
89818 urban-floor-standing-2-door-vanity-unit-with-thin-edge-basin-800mm-en 7170/7191
89819 urban-floor-standing-2-door-vanity-unit-with-curved-basin-800mm-en 7170/7191
89868 urban-floor-standing-2-door-1-drawer-vanity-unit-with-mid-edge-basin-800mm-en-en 7170/7191
89869 urban-floor-standing-2-door-1-drawer-vanity-unit-with-minimalist-basin-800mm-en-en 7170/7191
89870 urban-floor-standing-2-door-vanity-unit-with-thin-edge-basin-800mm-en-en 7170/7191
89871 urban-floor-standing-2-door-vanity-unit-with-curved-basin-800mm-en-en 7170/7191
89940 urban-800mm-floor-standing-2-door-drawer-unit-and-mid-edge-basin-1-tap-hole 7170/7191/7310
89941 urban-800mm-floor-standing-2-door-drawer-unit-and-minimalist-basin-1-tap-hole 7170/7191/7310
89942 urban-800mm-floor-standing-2-door-drawer-unit-and-thin-edge-basin-1-tap-hole 7170/7191/7310
89943 urban-800mm-floor-standing-2-door-drawer-unit-and-curved-basin-1-tap-hole 7170/7191/7310
89997 eden-floor-standing-3-door-2-drawer-vanity-unit-with-mid-edge-basin-1000mm 7170/7191
90004 eden-floor-standing-3-door-2-drawer-vanity-unit-with-minimalist-basin-1000mm 7170/7191
90008 mayford-floor-standing-3-door-3-drawer-vanity-unit-with-round-basin-1250mm 7170/7191
90546 arno-1200mm-floor-standing-4-door-vanity-and-worktop 7170/7191
90564 arno-1200mm-floor-standing-4-door-vanity-and-worktop-en-en-en 7170/7191
90570 arno-1200mm-floor-standing-4-door-vanity-and-worktop-en-en-en-en 7170/7191
90576 arno-1200mm-floor-standing-4-door-vanity-and-worktop-en-en-en-en-en 7170/7191
90920 arno-floor-standing-2-drawer-vanity-and-mid-edge-ceramic-basin-800mm 7170
90921 arno-floor-standing-2-drawer-vanity-and-minimalist-ceramic-basin-800mm 7170
90922 arno-floor-standing-2-drawer-vanity-and-thin-edge-ceramic-basin-800mm 7170
90923 arno-floor-standing-2-drawer-vanity-and-curved-ceramic-basin-800mm 7170
90999 arno-floor-standing-2-drawer-vanity-and-mid-edge-ceramic-basin-800mm-en 7170
91000 arno-floor-standing-2-drawer-vanity-and-minimalist-ceramic-basin-800mm-en 7170
91001 arno-floor-standing-2-drawer-vanity-and-thin-edge-ceramic-basin-800mm-en 7170
91002 arno-floor-standing-2-drawer-vanity-and-curved-ceramic-basin-800mm-en 7170
91004 bexley-floor-standing-2-door-1-shelf-vanity-and-1-tap-hole-fireclay-basin-500mm 7170
91005 bexley-floor-standing-2-door-1-shelf-vanity-and-3-tap-hole-fireclay-basin-500mm 7170
91007 bexley-floor-standing-2-door-1-shelf-vanity-and-1-tap-hole-fireclay-basin-600mm 7170
91008 bexley-floor-standing-2-door-1-shelf-vanity-and-3-tap-hole-fireclay-basin-600mm 7170
91016 bexley-floor-standing-2-door-1-shelf-vanity-and-1-tap-hole-fireclay-basin-500mm-en 7170
91017 bexley-floor-standing-2-door-1-shelf-vanity-and-3-tap-hole-fireclay-basin-500mm-en 7170
91019 bexley-floor-standing-2-door-1-shelf-vanity-and-1-tap-hole-fireclay-basin-600mm-en 7170
91020 bexley-floor-standing-2-door-1-shelf-vanity-and-3-tap-hole-fireclay-basin-600mm-en 7170
91028 bexley-floor-standing-2-door-1-shelf-vanity-and-1-tap-hole-fireclay-basin-500mm-en-en 7170
91029 bexley-floor-standing-2-door-1-shelf-vanity-and-3-tap-hole-fireclay-basin-500mm-en-en 7170
91031 bexley-floor-standing-2-door-1-shelf-vanity-and-1-tap-hole-fireclay-basin-600mm-en-en 7170
91032 bexley-floor-standing-2-door-1-shelf-vanity-and-3-tap-hole-fireclay-basin-600mm-en-en 7170
91040 bexley-floor-standing-2-door-1-shelf-vanity-and-1-tap-hole-fireclay-basin-500mm-en-en-en 7170
91041 bexley-floor-standing-2-door-1-shelf-vanity-and-3-tap-hole-fireclay-basin-500mm-en-en-en 7170
91042 bexley-floor-standing-2-door-1-shelf-vanity-and-0-tap-hole-fireclay-basin-500mm 7170
91044 bexley-floor-standing-2-door-1-shelf-vanity-and-1-tap-hole-fireclay-basin-600mm-en-en-en 7170
91045 bexley-floor-standing-2-door-1-shelf-vanity-and-3-tap-hole-fireclay-basin-600mm-en-en-en 7170
91106 classique-floor-standing-2-door-unit-and-0-tap-hole-fireclay-basin-800mm-en 7170
91192 classique-floor-standing-2-door-unit-and-0-tap-hole-fireclay-basin-800mm-en-en 7170
91247 classique-floor-standing-2-door-unit-and-0-tap-hole-fireclay-basin-800mm-en-en-en 7170
91506 urban-floor-standing-2-door-vanity-and-mid-edge-ceramic-basin-800mm 7170
91507 urban-floor-standing-2-door-vanity-and-minimalist-ceramic-basin-800mm 7170
91508 urban-floor-standing-2-door-vanity-and-thin-edge-ceramic-basin-800mm 7170
91509 urban-floor-standing-2-door-vanity-and-curved-ceramic-basin-800mm 7170