Database Queries

总计4条数据
TimeDurationTypeQuery
  
20:16:18.8783.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5250

20:16:18.8821.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250

20:16:18.8877.8 msSELECTSELECT "user_id", "object_type", sum(num) as num FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type" != 24) AND ("object_type" != 29) AND ("visit_date" >= '2025-06-20') AND ("object_type" IN (23, 9, 21, 10, 22, 1, 19, 20, 37, 18, 101, 34, 7, 11, 12, 13, 25, 26, 16, 28, 29, 30, 10004)) GROUP BY "user_id", "object_type" ORDER BY "num" DESC LIMIT 10

20:16:18.8951.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/history/list-module', '{"web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"id":23,"title":"\u7edf\u8ba1\u5206\u6790","icon":"icon-tongjifenxi","appName":"analysis","isRouteShow":1,"url":"\/analysis"},{"id":1,"title":"\u5546\u673a\u4fe1\u606f","icon":"icon-shangjixinxi","appName":"project","isRouteShow":1,"url":"\/project"},{"id":37,"title":"\u5ba1\u6279\u7ba1\u7406","icon":"icon-shenpi","appName":"approve","isRouteShow":1,"url":"\/approve"},{"id":13,"title":"\u91c7\u8d2d\u5408\u540c","icon":"icon-caigouhetong","appName":"purchaseContracts","isRouteShow":1,"url":"\/contract"},{"id":10,"title":"\u5ba2\u6237\u4fe1\u606f","icon":" icon-kehuxinxi","appName":"client","isRouteShow":1,"url":"\/client"},{"id":12,"title":"\u4f9b\u5e94\u5546","icon":"icon-gongyingshang","appName":"suppliers","isRouteShow":1,"url":"\/supplier"},{"id":7,"title":"\u9500\u552e\u5408\u540c","icon":"icon-xiaoshouhetong","appName":"salesContracts","isRouteShow":1,"url":"\/salesContract"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 20:16:18') RETURNING "id"