Sandbox

SELECT 
  wt.* 
FROM 
  cscart_cp_object_week_table as wt 
  LEFT JOIN cscart_shippings ON cscart_shippings.shipping_id = wt.object_id 
WHERE 
  cscart_shippings.cp_use_days = 'Y' 
  AND wt.object_id IN (7, 1, 6, 11) 
  AND wt.object_type = 's' 
  AND wt.day = 'we' 
  AND (
    wt.from_h > 0 
    OR wt.from_m > 0 
    OR wt.to_h > 0 
    OR wt.to_m > 0
  )

Query time 0.00043

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}