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 (
    90714, 90720, 90713, 90719, 90728, 90729, 
    90717, 90723, 90725, 90727, 90712, 
    90718, 90730, 90731, 90724, 90726, 
    90716, 90722, 89243, 89244, 89253, 
    89254, 90715, 90721, 90048, 90049, 
    90050, 90051, 90052, 90053, 90042, 
    90043, 90044, 90045, 90046, 90047, 
    90058, 90059, 87836, 93834, 93835, 
    93882, 93883, 93884, 93885, 96122, 
    96124, 96125
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00139

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.62"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.82",
        "eval_cost": "4.80",
        "prefix_cost": "21.62",
        "data_read_per_join": "81K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ],
      "attached_condition": "((`nuie_scalesta_net`.`cscart_seo_names`.`object_id` in (90714,90720,90713,90719,90728,90729,90717,90723,90725,90727,90712,90718,90730,90731,90724,90726,90716,90722,89243,89244,89253,89254,90715,90721,90048,90049,90050,90051,90052,90053,90042,90043,90044,90045,90046,90047,90058,90059,87836,93834,93835,93882,93883,93884,93885,96122,96124,96125)) 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'))"
    }
  }
}