| Limit (cost=8232.47..8232.47 rows=1 width=1009) |
| -> Sort (cost=8232.47..8232.47 rows=1 width=1009) |
| Sort Key: a.id DESC |
| -> Nested Loop Left Join (cost=0.00..8232.45 rows=1 width=1009) |
| Join Filter: (u.id = a.user_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..8208.92 rows=1 width=1009) |
| Filter: (("time" >= '2025-12-17 17:00:00'::timestamp without time zone) AND ("time" <= '2025-12-17 23:55:00'::timestamp without time zone)) |
| -> Seq Scan on tbl_logins u (cost=0.00..20.51 rows=151 width=56) |