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 (
    5571, 5309, 3337, 4470, 4410, 5197, 2012, 
    5194, 3997, 2189, 2283, 4209, 2281, 
    1669, 1988, 3939, 4429, 3358, 1581, 
    1769, 4411, 1582, 5204, 5386, 5568, 
    2240, 4451, 5957, 10873, 2186, 2180, 
    5574, 5393, 5002, 1628, 1627, 1971, 
    5678, 4988, 3486, 5815, 4285, 2178, 
    4763, 4782, 5007, 2191, 2170, 2181, 
    2190, 5019, 3480, 2185, 5109, 3326, 
    3821, 5010, 2279, 5018, 2026, 2182, 
    3445, 3462, 3508, 3985, 4255, 2188, 
    5192, 2173, 2284, 5912, 8784, 2280, 
    1672, 3625, 3955, 2184, 3485, 3490, 
    4258
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'ar'

Query time 0.00268

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "63.66"
    },
    "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": 97,
      "rows_produced_per_join": 97,
      "filtered": "100.00",
      "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`object_id` in (5571,5309,3337,4470,4410,5197,2012,5194,3997,2189,2283,4209,2281,1669,1988,3939,4429,3358,1581,1769,4411,1582,5204,5386,5568,2240,4451,5957,10873,2186,2180,5574,5393,5002,1628,1627,1971,5678,4988,3486,5815,4285,2178,4763,4782,5007,2191,2170,2181,2190,5019,3480,2185,5109,3326,3821,5010,2279,5018,2026,2182,3445,3462,3508,3985,4255,2188,5192,2173,2284,5912,8784,2280,1672,3625,3955,2184,3485,3490,4258)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`type` = 'p') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`dispatch` = '') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_seo_names`.`lang_code` = 'ar'))",
      "cost_info": {
        "read_cost": "53.96",
        "eval_cost": "9.70",
        "prefix_cost": "63.66",
        "data_read_per_join": "164K"
      },
      "used_columns": [
        "name",
        "object_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}