Database Queries

总计8条数据
TimeDurationTypeQuery
  
22:47:25.8312.1 msSELECTSELECT * FROM "global"."tbl_logins" WHERE (("email"='caoyongsheng@toast.com.cn') AND ("access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u')) AND ("user_status"='1')

22:47:25.8340.3 msSELECTSELECT "id" FROM "global"."tbl_logins" WHERE "email"='caoyongsheng@toast.com.cn' LIMIT 2

22:47:25.8340.2 msSELECTSELECT "id" FROM "global"."tbl_logins" WHERE "mobile"='13810260729' LIMIT 2

22:47:25.8350.4 msSELECTSELECT EXISTS(SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2)

22:47:25.8350.9 msUPDATEUPDATE "global"."tbl_logins" SET "device_type"=2, "app"=2 WHERE "id"=1000

22:47:25.8370.2 msSELECTSELECT * FROM "global"."tbl_logins" WHERE "id"=1000

22:47:25.8380.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u'

22:47:25.8391.8 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/login/check-login', '{"access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","app":"2","channel_id":"","device_type":"2","email":"caoyongsheng@toast.com.cn","posttime":"1750776448","token":"fc81a93da3fcf3247bf35af36102d4bd","version_code":"1141"}', '{"code":200,"data":{"id":1000,"email":"caoyongsheng@toast.com.cn","password":"$2y$13$OHFzAZErAhoYC0cdbf7CYu4EOa6K8w14igLnCwEjcjbpOQNvsQaQC","auth_key":"-H31NXUarscihfVhJEITSsQtUOaa6lcP","access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","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":null,"device_type":2,"mutex":null,"app":2,"mobile":"13810260729","web_access_token":"vD0FzBuy9SkdmeoOMqEqKO1yquMQkpOH","mod":0},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-24 22:47:25') RETURNING "id"