| Limit (cost=8725.91..8725.96 rows=20 width=1006) |
| -> Sort (cost=8725.91..8725.96 rows=20 width=1006) |
| Sort Key: a.id DESC |
| -> Hash Left Join (cost=22.40..8725.48 rows=20 width=1006) |
| 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..8697.60 rows=1993 width=1006) |
| Filter: (("time" >= '2025-12-17 17:00:00'::timestamp without time zone) AND ("time" <= '2025-12-17 23:55:00'::timestamp without time zone)) |
| -> Hash (cost=20.51..20.51 rows=151 width=56) |
| -> Seq Scan on tbl_logins u (cost=0.00..20.51 rows=151 width=56) |