69427f19ebbb9: POST https://beta.jinchangxiao.com/v2/login/login at 2025-12-17 05:59:53 pm by 223.72.15.22
Database Queries
总计10条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 17:59:53.969 | 2.1 ms | SELECT | SELECT * FROM "global"."tbl_logins" WHERE ("email"='yaoxuechun@jinchangxiao.com') AND ("user_status"='1') |
| 17:59:54.424 | 1.1 ms | INSERT | INSERT INTO "global"."tbl_login_logs" ("email", "is_success", "ip_address") VALUES ('yaoxuechun@jinchangxiao.com', TRUE, '223.72.15.22') |
| 17:59:54.426 | 0.4 ms | SELECT | SELECT "id" FROM "global"."tbl_logins" WHERE "email"='yaoxuechun@jinchangxiao.com' LIMIT 2 |
| 17:59:54.427 | 0.2 ms | SELECT | SELECT "id" FROM "global"."tbl_logins" WHERE "mobile"='17610273960' LIMIT 2 |
| 17:59:54.427 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2) |
| 17:59:54.428 | 0.8 ms | UPDATE | UPDATE "global"."tbl_logins" SET "channel_id"='1a0018970b8fad276d7', "device_type"=0, "app"=1 WHERE "id"=5064 |
| 17:59:54.429 | 0.2 ms | SELECT | SELECT * FROM "global"."tbl_logins" WHERE "id"=5064 |
| 17:59:54.429 | 0.2 ms | SELECT | SELECT "schema_id" FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 17:59:54.430 | 0.9 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG' |
| 17:59:54.431 | 1.1 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5064, 0, 269, 'v2/login/login', '{"access_token":"","channel_id":"1a0018970b8fad276d7","device_type":"0","version_code":"269","email":"yaoxuechun@jinchangxiao.com","token":"4cf6312f82ffa2f8015f1ed2ecd42e48","posttime":"1765965592","password":"123456"}', '{"code":200,"data":{"id":5064,"email":"yaoxuechun@jinchangxiao.com","password":"$2y$13$Lpx6LOb6wJdiIjhCYo97JOGdobF0Vz215q5lSQfjJgaJyz0qWKMey","auth_key":"87-EqMYU-2KEeqX2x5mDAzTJyiotpbfR","access_token":"-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG","user_status":"1","enterprise_id":2,"created_at":"2018-03-06 16:55:56.851343+08","updated_at":"2018-03-06 16:55:56.851343+08","super_user":false,"open_id":null,"channel_id":"1a0018970b8fad276d7","device_type":0,"mutex":false,"app":1,"mobile":"17610273960","web_access_token":"uxMUSUyYtYH6gXgwfEfatQDQrz7kKsvL","schema_id":"a57be577deb434","mod":0},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"223.72.15.22","ua":"jinchangxiao\/2.3.169 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2025-12-17 17:59:54') RETURNING "id" |