| Aggregate (cost=3775.51..3775.52 rows=1 width=8) |
| -> Hash Left Join (cost=33.30..3775.51 rows=1 width=0) |
| Hash Cond: (a.user_id = u.id) |
| Filter: ((a.user_id = 0) OR ((u.email)::text ~~* '%caoyongsheng%'::text) OR ((u.mobile)::text ~~* '%caoyongsheng%'::text)) |
| -> Seq Scan on tbl_api_log a (cost=0.00..3741.78 rows=164 width=4) |
| Filter: (("time" >= '2025-06-27 00:00:00'::timestamp without time zone) AND ("time" < '2025-06-28 00:00:00'::timestamp without time zone)) |
| -> Hash (cost=28.69..28.69 rows=369 width=47) |
| -> Seq Scan on tbl_logins u (cost=0.00..28.69 rows=369 width=47) |