Database Queries

总计22条数据
TimeDurationTypeQuery
  
19:04:38.0493.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

19:04:38.0542.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

19:04:38.0571.3 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_visit_object_histories" WHERE "user_id"=1001 ORDER BY "last_visit_at" DESC LIMIT 10) "c"

19:04:38.0600.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_object_histories" WHERE "user_id"=1001 ORDER BY "last_visit_at" DESC LIMIT 20

19:04:38.0630.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3834

19:04:38.0660.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=3843

19:04:38.0670.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"=1730

19:04:38.0680.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"=1704

19:04:38.0690.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=7141

19:04:38.0700.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=7141

19:04:38.0710.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (307, 356))

19:04:38.0720.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=6714

19:04:38.0730.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=6714

19:04:38.0730.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (307, 379))

19:04:38.0730.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=7355

19:04:38.0740.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=7355

19:04:38.0740.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (307, 379))

19:04:38.0751.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3810

19:04:38.0770.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_work_logs" WHERE "id"=21704

19:04:38.0780.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id"=67

19:04:38.0790.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3801

19:04:38.0801.6 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/history/list-object', '{"web_access_token":"SXPCUp7Z_YgHJ45TnvuyG1o7l8nwuHKC"}', '{"code":2000,"result":{"list":[{"id":170076,"user_id":1001,"object_type":13,"object_id":3834,"last_visit_at":"2025-06-27 14:41:54","title":"\u5408\u540c\u7f16\u53f7\uff1a\u6d4b\u8bd5\u9500\u552e\u5408\u540c\u5173\u8054\u91c7\u8d2d\u5408\u540c\u95ee\u9898","icon":"icon-caigouhetong"},{"id":170060,"user_id":1001,"object_type":7,"object_id":3843,"last_visit_at":"2025-06-27 14:39:21","title":"\u5408\u540c\u7f16\u53f7\uff1aTS-LRC-20250611001","icon":"icon-xiaoshouhetong"},{"id":170075,"user_id":1001,"object_type":37,"object_id":1730,"last_visit_at":"2025-06-24 16:26:13","title":"jfhfn","icon":"icon-shenpi"},{"id":170074,"user_id":1001,"object_type":37,"object_id":1704,"last_visit_at":"2025-06-24 16:25:56","title":"\u8f6f\u8003\u62a5\u540d\u53ca\u57f9\u8bad\u8d39","icon":"icon-shenpi"},{"id":170065,"user_id":1001,"object_type":20,"object_id":7141,"last_visit_at":"2025-06-19 11:36:21","title":"\u65e5\u5e38\u529e\u516c","icon":"icon-feiyongbaoxiao"},{"id":170064,"user_id":1001,"object_type":20,"object_id":6714,"last_visit_at":"2025-06-19 11:35:31","title":"\u65e5\u5e38\u529e\u516c","icon":"icon-feiyongbaoxiao"},{"id":170063,"user_id":1001,"object_type":20,"object_id":7355,"last_visit_at":"2025-06-19 11:24:19","title":"\u65e5\u5e38\u529e\u516c","icon":"icon-feiyongbaoxiao"},{"id":170062,"user_id":1001,"object_type":1,"object_id":3810,"last_visit_at":"2025-06-18 15:24:23","title":"\u6d4b\u8bd5\u52a8\u6001","icon":"icon-shangjixinxi"},{"id":170061,"user_id":1001,"object_type":19,"object_id":21704,"last_visit_at":"2025-06-17 16:02:06","title":"\u5546\u673a\u63a8\u52a8","icon":"icon-gongzuorizhi"},{"id":170025,"user_id":1001,"object_type":1,"object_id":3801,"last_visit_at":"2025-06-11 15:29:08","title":"\u8d1f\u6570\u95ee\u9898","icon":"icon-shangjixinxi"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-06-27 19:04:38') RETURNING "id"