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 (
    86866, 91330, 86262, 86280, 86300, 86326, 
    91328, 86867, 86270, 86291, 86299, 
    86325, 91329, 86261, 86244, 86269, 
    86290, 86292, 86318, 86271, 87736, 
    86281, 86346, 86350, 91327, 91426, 
    86283, 87745, 86256, 86309, 86369, 
    86272, 86374, 86298, 86324, 86282, 
    86311, 86327, 86260, 86308, 91326, 
    86243, 87748, 86378, 86246, 86268, 
    86289, 86277, 87744, 91425, 86304, 
    86317, 91424, 87751, 91325, 86373, 
    86310, 86347, 86351, 87753, 86344, 
    86348, 86276, 86376, 86353, 86303, 
    86316, 86254, 86306, 86371, 86313, 
    86329, 86312, 86328, 86245, 86345, 
    86349, 87743, 86865, 87747, 86259, 
    86307, 91422, 91423, 87742, 86297, 
    86323, 86273, 86305, 86377, 86296, 
    86322, 86372, 87750, 86375, 87746
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en'

Query time 0.00252

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 (86866,91330,86262,86280,86300,86326,91328,86867,86270,86291,86299,86325,91329,86261,86244,86269,86290,86292,86318,86271,87736,86281,86346,86350,91327,91426,86283,87745,86256,86309,86369,86272,86374,86298,86324,86282,86311,86327,86260,86308,91326,86243,87748,86378,86246,86268,86289,86277,87744,91425,86304,86317,91424,87751,91325,86373,86310,86347,86351,87753,86344,86348,86276,86376,86353,86303,86316,86254,86306,86371,86313,86329,86312,86328,86245,86345,86349,87743,86865,87747,86259,86307,91422,91423,87742,86297,86323,86273,86305,86377,86296,86322,86372,87750,86375,87746)) 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'))"
    }
  }
}