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 (
    90788, 90790, 90789, 90791, 90784, 90786, 
    90774, 90772, 90785, 90787, 90780, 
    90782, 90775, 87367, 90781, 90783, 
    90773, 90776, 90778, 87366, 87365, 
    90777, 90779, 87354, 90770, 87364, 
    82550, 90768, 87352, 87353, 90771, 
    87358, 87378, 82548, 90769, 87380, 
    87357, 87376, 87377, 90766, 90767, 
    87374, 90150, 90165, 87379, 84073, 
    84081, 82509, 87373, 82508, 90149, 
    90164, 90764, 90765, 90142, 90157, 
    90762, 90763, 90148, 90163, 82531, 
    87369, 84072, 84080, 82541, 90759, 
    90147, 90162, 82440, 87368, 87363, 
    84071, 84079, 84095, 90141, 90156, 
    90297, 90304, 82539, 82530, 84057, 
    84065, 82439, 82549, 87362, 84070, 
    84078, 90758, 90760, 90761, 85973, 
    87361, 87356, 84069, 84077, 82540
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00277

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 (90788,90790,90789,90791,90784,90786,90774,90772,90785,90787,90780,90782,90775,87367,90781,90783,90773,90776,90778,87366,87365,90777,90779,87354,90770,87364,82550,90768,87352,87353,90771,87358,87378,82548,90769,87380,87357,87376,87377,90766,90767,87374,90150,90165,87379,84073,84081,82509,87373,82508,90149,90164,90764,90765,90142,90157,90762,90763,90148,90163,82531,87369,84072,84080,82541,90759,90147,90162,82440,87368,87363,84071,84079,84095,90141,90156,90297,90304,82539,82530,84057,84065,82439,82549,87362,84070,84078,90758,90760,90761,85973,87361,87356,84069,84077,82540)) 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'))"
    }
  }
}