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 (
    389506, 388936, 389155, 388759, 389262, 
    391708, 388950, 389254, 389093, 391743, 
    435308, 389358, 381739, 389786, 388687, 
    388405, 389782, 389828, 389772, 389440, 
    388490, 390295, 390300, 389030, 389393, 
    435331, 389871, 390299, 389634, 390298, 
    391751, 389816, 426899, 389633, 389457, 
    389242, 389411, 390301, 389102, 434582, 
    389009, 389085, 389008, 388407, 388676, 
    389141, 388468, 388426, 390173, 415642, 
    435315, 388507, 389214, 389553, 388663, 
    388929, 388460, 389775, 427186, 388834, 
    415529, 372026, 415508, 388600, 388752, 
    435302, 388406, 415319, 381755, 388436, 
    381734, 389400, 389417, 388401, 389021, 
    434590, 379726, 389131, 435311, 389150, 
    389036, 427201, 389609, 435306, 388571, 
    388538, 389144, 388839, 388915, 434578, 
    389554, 390114, 389109, 389149, 415467, 
    388656, 388838, 390194, 388762, 426898
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00339

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 (389506,388936,389155,388759,389262,391708,388950,389254,389093,391743,435308,389358,381739,389786,388687,388405,389782,389828,389772,389440,388490,390295,390300,389030,389393,435331,389871,390299,389634,390298,391751,389816,426899,389633,389457,389242,389411,390301,389102,434582,389009,389085,389008,388407,388676,389141,388468,388426,390173,415642,435315,388507,389214,389553,388663,388929,388460,389775,427186,388834,415529,372026,415508,388600,388752,435302,388406,415319,381755,388436,381734,389400,389417,388401,389021,434590,379726,389131,435311,389150,389036,427201,389609,435306,388571,388538,389144,388839,388915,434578,389554,390114,389109,389149,415467,388656,388838,390194,388762,426898)) and (`webmarco`.`cscart_seo_names`.`type` = 'p') and (`webmarco`.`cscart_seo_names`.`dispatch` = '') and (`webmarco`.`cscart_seo_names`.`lang_code` = 'en'))"
    }
  }
}