Sandbox

SELECT 
  q_seo_names.object_id AS product_id, 
  q_seo_names.name AS seo_name, 
  q_seo_names.path AS seo_path 
FROM 
  q_seo_names 
WHERE 
  q_seo_names.object_id IN (
    2393, 2394, 2396, 2397, 2398, 2399, 2403, 
    2020, 2032, 2042, 2058, 1848, 1856, 
    1868, 1878, 1886
  ) 
  AND q_seo_names.type = "p" 
  AND q_seo_names.dispatch = "" 
  AND q_seo_names.lang_code = 'en'

Query time 0.00091

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "39.81"
    },
    "table": {
      "table_name": "q_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": 17,
      "rows_produced_per_join": 17,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_seo_names`.`object_id` in (2393,2394,2396,2397,2398,2399,2403,2020,2032,2042,2058,1848,1856,1868,1878,1886)) and (`portal`.`q_seo_names`.`type` = 'p') and (`portal`.`q_seo_names`.`dispatch` = '') and (`portal`.`q_seo_names`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "36.41",
        "eval_cost": "3.40",
        "prefix_cost": "39.81",
        "data_read_per_join": "28K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}

Result

product_id	seo_name	seo_path
1848	y-and-d-womens-fashion-blouse-a-line-round-neck-flare-sleeve-floral-pattern-blouse-blue-color	12/13/14/17
1856	y-and-d-shirt-neck-chiffon-material-long-sleeve-blouse-for-women-office-style	12/13/14/17
1868	y-and-d-womens-floral-pattern-leopard-decor-round-neck-short-sleeve-fashion-blouse-multi-color	12/13/14/17
1878	y-and-d-pink-and-white-round-neck-blouse-for-women	12/13/14/17
1886	y-and-d-womens-chiffon-fashion-blouse-short-sleeve-round-neck-floral-pattern-sweet-color-blouse-black	12/13/14/17
2020	y-and-d-round-neck-splice-pattern-chiffon-material-short-sleeve-blouse-for-women-multi-color	12/13/14/17
2032	y-and-d-womens-round-neck-floral-pattern-short-sleeve-fashion-chiffon-blouse-multi-color	12/13/14/17
2042	y-and-d-round-neck-solid-pattern-chiffon-material-short-sleeve-blouse-for-women-blue-color	12/13/14/17
2058	y-and-d-round-neck-zig-zag-pattern-chiffon-material-short-sleeve-blouse-for-women-multi-color	12/13/14/17
2393	y-and-d-v-neck-a-line-dress-for-women	12/13/14/16
2394	y-and-d-fashion-dress-long-sleeved-dress-in-vintage-print	12/13/14/16
2396	y-and-d-summer-dresses-printed-dresses-beach-skirts	12/13/14/16
2397	y-and-d-leopard-print-v-neck-with-side-slit-dress	12/13/14/16
2398	y-and-d-slim-slanted-strapless-evening-dress-for-spring-summer	12/13/14/16
2399	y-and-d-womens-aline-round-neck-retro-flare-sleeve-lace-patch-flower-decor-midi-sweet-dress	12/13/14/16
2403	y-and-d-evening-and-formal-a-line-dress-for-women	12/13/14/16