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 (
    28, 74, 112, 111, 61, 60, 72, 73, 24, 44, 
    27, 50, 51, 42, 43, 41, 88, 46, 79, 58
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'fr' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00068

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "ALL",
      "possible_keys": ["PRIMARY", "dispatch"],
      "rows": 186,
      "filtered": 21.50537682,
      "attached_condition": "cscart_seo_names.object_id in (28,74,112,111,61,60,72,73,24,44,27,50,51,42,43,41,88,46,79,58) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'fr' and (cscart_seo_names.company_id = 1 or cscart_seo_names.company_id = 0)"
    }
  }
}