687075c5806dd: POST https://beta.jinchangxiao.com/v2/login/login at 2025-07-11 10:24:05 am by 114.246.237.65
Database Queries
总计10条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:24:05.533 | 2.9 ms | SELECT | SELECT * FROM "global"."tbl_logins" WHERE ("email"='caoyongsheng@toast.com.cn') AND ("user_status"='1') |
| 10:24:06.007 | 2.1 ms | INSERT | INSERT INTO "global"."tbl_login_logs" ("email", "is_success", "ip_address") VALUES ('caoyongsheng@toast.com.cn', TRUE, '114.246.237.65') |
| 10:24:06.010 | 0.9 ms | SELECT | SELECT "id" FROM "global"."tbl_logins" WHERE "email"='caoyongsheng@toast.com.cn' LIMIT 2 |
| 10:24:06.011 | 0.7 ms | SELECT | SELECT "id" FROM "global"."tbl_logins" WHERE "mobile"='13810260729' LIMIT 2 |
| 10:24:06.012 | 1.1 ms | SELECT | SELECT EXISTS(SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2) |
| 10:24:06.014 | 1.7 ms | UPDATE | UPDATE "global"."tbl_logins" SET "channel_id"='126c83f7611c8bb4bc3', "device_type"=6 WHERE "id"=1000 |
| 10:24:06.017 | 0.8 ms | SELECT | SELECT * FROM "global"."tbl_logins" WHERE "id"=1000 |
| 10:24:06.018 | 0.7 ms | SELECT | SELECT "schema_id" FROM "global"."tbl_enterprises" WHERE "id"=2 |
| 10:24:06.019 | 1.5 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH' |
| 10:24:06.023 | 2.0 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', 1000, 6, 166, 'v2/login/login', '{"email":"caoyongsheng@toast.com.cn","password":"A59chf#33","channel_id":"126c83f7611c8bb4bc3","posttime":"1752200645","access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"6","version_code":"166","token":"b0388105e36107cb92c94ab960a65349"}', '{"code":200,"data":{"id":1000,"email":"caoyongsheng@toast.com.cn","password":"$2y$13$aDold8cou3LsmRzJTqy\/m.PfXmk.mrS7BZveeFEDhgyUKQQ9DT1\/C","auth_key":"-H31NXUarscihfVhJEITSsQtUOaa6lcP","access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","user_status":"1","enterprise_id":2,"created_at":"2016-10-14 22:23:37.599226+08","updated_at":"2016-10-14 22:23:37.599226+08","super_user":false,"open_id":null,"channel_id":"126c83f7611c8bb4bc3","device_type":6,"mutex":null,"app":1,"mobile":"13810260729","web_access_token":"AYm1nZ5eJB81Cw359BU2uScuMxXTKILV","schema_id":"a57be577deb434","mod":0},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-11 10:24:06') RETURNING "id" |