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 (
    38258, 38254, 38207, 38213, 38217, 38199, 
    38206, 38247, 38214, 38216, 38201, 
    38229, 38255, 38222, 38245, 38256, 
    38230, 38233, 38242, 38252, 38219, 
    38223, 38234, 38237, 38248, 38210, 
    38257, 38200, 38204, 38224, 38227, 
    38228, 38246, 38203, 38202, 38231, 
    38208, 38215, 38239, 38253, 38218, 
    38205, 38209, 38221, 38225, 38226, 
    38240, 38241, 38251, 38235, 38244, 
    38249, 38232, 38211, 38220, 38236, 
    38238, 38212, 38243, 38250
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00188

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "48.31"
    },
    "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": 74,
      "rows_produced_per_join": 74,
      "filtered": "100.00",
      "index_condition": "((`cscartdb`.`cscart_seo_names`.`object_id` in (38258,38254,38207,38213,38217,38199,38206,38247,38214,38216,38201,38229,38255,38222,38245,38256,38230,38233,38242,38252,38219,38223,38234,38237,38248,38210,38257,38200,38204,38224,38227,38228,38246,38203,38202,38231,38208,38215,38239,38253,38218,38205,38209,38221,38225,38226,38240,38241,38251,38235,38244,38249,38232,38211,38220,38236,38238,38212,38243,38250)) and (`cscartdb`.`cscart_seo_names`.`type` = 'p') and (`cscartdb`.`cscart_seo_names`.`dispatch` = '') and (`cscartdb`.`cscart_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "40.91",
        "eval_cost": "7.40",
        "prefix_cost": "48.31",
        "data_read_per_join": "125K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}