Database Queries

总计10条数据
TimeDurationTypeQuery
  
17:50:28.27610.7 msSELECTSELECT * FROM "global"."tbl_logins" WHERE ("mobile"='13810260729') AND ("user_status"='1')

17:50:29.1099.5 msINSERTINSERT INTO "global"."tbl_login_logs" ("email", "is_success", "ip_address") VALUES ('13810260729', TRUE, '39.156.194.178')

17:50:29.1240.6 msSELECTSELECT "id" FROM "global"."tbl_logins" WHERE "email"='caoyongsheng@toast.com.cn' LIMIT 2

17:50:29.1250.4 msSELECTSELECT "id" FROM "global"."tbl_logins" WHERE "mobile"='13810260729' LIMIT 2

17:50:29.1261.8 msSELECTSELECT EXISTS(SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2)

17:50:29.1283.1 msUPDATEUPDATE "global"."tbl_logins" SET "channel_id"='126c83f7611c8bb4bc3', "device_type"=6 WHERE "id"=1000

17:50:29.1320.8 msSELECTSELECT * FROM "global"."tbl_logins" WHERE "id"=1000

17:50:29.1330.3 msSELECTSELECT "schema_id" FROM "global"."tbl_enterprises" WHERE "id"=2

17:50:29.1341.4 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'

17:50:29.13711.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 6, 177, 'v2/login/login', '{"email":"13810260729","password":"A59chf#33","channel_id":"126c83f7611c8bb4bc3","posttime":"1781171428","device_type":"6","version_code":"177","token":"259ff59ef16449f285e36fc01fd68aa1"}', '{"code":200,"data":{"id":1000,"email":"caoyongsheng@toast.com.cn","password":"$2y$13$v07kEXW.mg0x9Hi6Zd2Kh.5NRkTaSZ3TRO\/Le4tHjOU9tG\/IHT\/LC","auth_key":"-H31NXUarscihfVhJEITSsQtUOaa6lcP","access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","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":"0iIk_7IoaTWhK8VwdG-45C8X4I8rrq3v","schema_id":"a57be577deb434","mod":0},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/1.0.41 (HUAWEI Mate 60 BRA-AL00; HarmonyOS 6.1.0)"}', FALSE, '2026-06-11 17:50:29', 871351040) RETURNING "id"