| Limit (cost=3776.68..3776.69 rows=1 width=720) |
| -> Sort (cost=3776.68..3776.69 rows=1 width=720) |
| Sort Key: a.id DESC |
| -> Hash Left Join (cost=33.30..3776.67 rows=1 width=720) |
| 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..3742.94 rows=164 width=720) |
| 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) |