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 (
    359228, 359250, 350456, 352934, 354809, 
    355716, 356197, 357325, 350519, 351538, 
    352933, 354545, 354601, 355811, 356999, 
    357125, 358041, 358356, 358745, 359222, 
    351591, 352307, 355177, 355720, 356842, 
    357665, 358420, 359065, 350720, 350916, 
    351166, 351470, 352480, 355366, 358082, 
    358140, 358256, 359274, 349856, 352111, 
    355519, 355742, 357553, 357633, 358343, 
    358485, 358866, 359131, 349896, 351448, 
    351633, 352271, 352810, 352867, 354117, 
    354793, 354847, 355439, 357789, 359167, 
    350417, 350810, 352507, 352724, 352883, 
    356615, 357642, 358423, 359279, 352333, 
    352365, 352597, 352671, 353323, 353958, 
    354866, 356248, 356643, 356828, 358012, 
    358340, 354561, 355136, 355899, 355987, 
    357079, 357476, 357931, 358029, 358228, 
    359091, 359139, 351042, 354022, 354074, 
    354919, 355124, 355257, 356296, 357939
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00291

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "140.11"
    },
    "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": 100,
      "rows_produced_per_join": 100,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "120.11",
        "eval_cost": "20.00",
        "prefix_cost": "140.11",
        "data_read_per_join": "169K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`webmarco`.`cscart_seo_names`.`object_id` in (359228,359250,350456,352934,354809,355716,356197,357325,350519,351538,352933,354545,354601,355811,356999,357125,358041,358356,358745,359222,351591,352307,355177,355720,356842,357665,358420,359065,350720,350916,351166,351470,352480,355366,358082,358140,358256,359274,349856,352111,355519,355742,357553,357633,358343,358485,358866,359131,349896,351448,351633,352271,352810,352867,354117,354793,354847,355439,357789,359167,350417,350810,352507,352724,352883,356615,357642,358423,359279,352333,352365,352597,352671,353323,353958,354866,356248,356643,356828,358012,358340,354561,355136,355899,355987,357079,357476,357931,358029,358228,359091,359139,351042,354022,354074,354919,355124,355257,356296,357939)) and (`webmarco`.`cscart_seo_names`.`type` = 'p') and (`webmarco`.`cscart_seo_names`.`dispatch` = '') and (`webmarco`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}