Database Queries

总计8条数据
TimeDurationTypeQuery
  
15:59:44.6773.8 msSELECTSELECT * FROM "global"."tbl_logins" WHERE (("email"='lrc@toast.com.cn') AND ("access_token"='LpLquexa4MxJRClJNdb9gPVa_MzadLnu')) AND ("user_status"='1')

15:59:44.6820.3 msSELECTSELECT "id" FROM "global"."tbl_logins" WHERE "email"='lrc@toast.com.cn' LIMIT 2

15:59:44.6820.2 msSELECTSELECT "id" FROM "global"."tbl_logins" WHERE "mobile"='13501128560' LIMIT 2

15:59:44.6821.0 msSELECTSELECT EXISTS(SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2)

15:59:44.6840.9 msUPDATEUPDATE "global"."tbl_logins" SET "device_type"=7 WHERE "id"=1001

15:59:44.6850.2 msSELECTSELECT * FROM "global"."tbl_logins" WHERE "id"=1001

15:59:44.6850.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='LpLquexa4MxJRClJNdb9gPVa_MzadLnu'

15:59:44.6871.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 7, 165, 'v2/login/check-login', '{"email":"lrc@toast.com.cn","channel_id":"126c83f7611a29859e7","posttime":"1751011184","access_token":"LpLquexa4MxJRClJNdb9gPVa_MzadLnu","device_type":"7","version_code":"165","token":"5c9eeb4475f956cb8ff0b80f7aab9ef3"}', '{"code":200,"data":{"id":1001,"email":"lrc@toast.com.cn","password":"$2y$13$g3gCWi.E8A3dXG1WpIjYKurnzyFSHtjyA2Eqzo8m8QqHRNzDHqaFu","auth_key":"AjLOvSLPDBjQA9eaXHjTm0gDoI5fJcEz","access_token":"LpLquexa4MxJRClJNdb9gPVa_MzadLnu","user_status":"1","enterprise_id":2,"created_at":"2017-02-06 13:05:08.080822+08","updated_at":"2017-02-06 13:05:08.080822+08","super_user":false,"open_id":null,"channel_id":"126c83f7611a29859e7","device_type":7,"mutex":null,"app":1,"mobile":"13501128560","web_access_token":"SXPCUp7Z_YgHJ45TnvuyG1o7l8nwuHKC","mod":0},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-27 15:59:44') RETURNING "id"