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 (
    1154, 3315, 3318, 3687, 5076, 4691, 3071, 
    513, 3505, 3319, 3306, 3296, 1172, 1173, 
    4917, 4918, 3500, 3501, 3431, 6948, 
    3499, 3455, 3466, 3454, 3456, 3449, 
    3461, 3441, 3444, 3471, 3442, 3480, 
    3448, 3440, 3467, 3468, 3435, 3476, 
    3447, 3439, 3465, 3446, 3460, 3443, 
    3469, 3464, 3459, 6950, 3470, 3457, 
    3462, 3450, 3458, 3463, 3451, 3445, 
    3472, 3481, 3482, 3475, 3483, 3474, 
    3473, 3426, 6949, 3427, 3477, 3452, 
    3478, 3479, 3453, 3491, 3488, 3497, 
    3495, 3489, 3492, 3496, 3490, 3494, 
    6951, 3502, 3503, 3493, 3498, 3428, 
    5802
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )

Query time 0.00196

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "121.81"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "dispatch"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "object_id",
        "type",
        "dispatch",
        "lang_code",
        "company_id"
      ],
      "key_length": "210",
      "rows_examined_per_scan": 174,
      "rows_produced_per_join": 174,
      "filtered": "100.00",
      "index_condition": "((`gaseus`.`cscart_seo_names`.`object_id` in (1154,3315,3318,3687,5076,4691,3071,513,3505,3319,3306,3296,1172,1173,4917,4918,3500,3501,3431,6948,3499,3455,3466,3454,3456,3449,3461,3441,3444,3471,3442,3480,3448,3440,3467,3468,3435,3476,3447,3439,3465,3446,3460,3443,3469,3464,3459,6950,3470,3457,3462,3450,3458,3463,3451,3445,3472,3481,3482,3475,3483,3474,3473,3426,6949,3427,3477,3452,3478,3479,3453,3491,3488,3497,3495,3489,3492,3496,3490,3494,6951,3502,3503,3493,3498,3428,5802)) and (`gaseus`.`cscart_seo_names`.`type` = 'p') and (`gaseus`.`cscart_seo_names`.`dispatch` = '') and (`gaseus`.`cscart_seo_names`.`lang_code` = 'en') and ((`gaseus`.`cscart_seo_names`.`company_id` = 1) or (`gaseus`.`cscart_seo_names`.`company_id` = 0)))",
      "cost_info": {
        "read_cost": "104.41",
        "eval_cost": "17.40",
        "prefix_cost": "121.81",
        "data_read_per_join": "294K"
      },
      "used_columns": [
        "name",
        "object_id",
        "company_id",
        "type",
        "dispatch",
        "path",
        "lang_code"
      ]
    }
  }
}