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 (
    93326, 93327, 93328, 93329, 93330, 93331, 
    93332, 93333, 93334, 93335, 93336, 
    93337, 93896, 93897, 93898, 93899, 
    93900, 93901, 93902, 93903, 93904, 
    93905, 93906, 93907, 93908, 93909, 
    93910, 93911, 93912, 93913, 93914, 
    93915, 93916, 93917, 93918, 93919, 
    93920, 93921, 93922, 93923, 93924, 
    93925, 93926, 93927, 93928, 93929, 
    93930, 93931, 93932, 93933, 93934, 
    93935, 93936, 93937, 93938, 93939, 
    93940, 93941, 93942, 93943, 93944, 
    93945, 93946, 93947, 93948, 93949, 
    93950, 93951, 93952, 93953, 93954, 
    93955, 93956, 93957, 93958, 93959, 
    93960, 93961, 93962, 93963, 93964, 
    93965, 93966, 93967, 93968, 93969, 
    93970, 93971, 93972, 93973, 93974, 
    93975, 93976, 93977, 93978, 93979
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00239

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 (93326,93327,93328,93329,93330,93331,93332,93333,93334,93335,93336,93337,93896,93897,93898,93899,93900,93901,93902,93903,93904,93905,93906,93907,93908,93909,93910,93911,93912,93913,93914,93915,93916,93917,93918,93919,93920,93921,93922,93923,93924,93925,93926,93927,93928,93929,93930,93931,93932,93933,93934,93935,93936,93937,93938,93939,93940,93941,93942,93943,93944,93945,93946,93947,93948,93949,93950,93951,93952,93953,93954,93955,93956,93957,93958,93959,93960,93961,93962,93963,93964,93965,93966,93967,93968,93969,93970,93971,93972,93973,93974,93975,93976,93977,93978,93979)) 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'))"
    }
  }
}