Database Queries

总计24条数据
TimeDurationTypeQuery
  
13:20:51.1732.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

13:20:51.1761.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

13:20:51.1811.2 msSELECTSELECT COUNT(*) FROM (SELECT *, end_at - start_at AS hours_spent FROM "a57be577deb434"."tbl_work_logs" WHERE ("created_by"='5064') AND ("created_at" >= '2025-01-01 00:00:00') AND ("created_at" <= '2025-12-31 23:59:59') AND ("status"=-1) ORDER BY "created_at" DESC) "c"

13:20:51.1822.3 msSELECTSELECT *, end_at - start_at AS hours_spent FROM "a57be577deb434"."tbl_work_logs" WHERE ("created_by"='5064') AND ("created_at" >= '2025-01-01 00:00:00') AND ("created_at" <= '2025-12-31 23:59:59') AND ("status"=-1) ORDER BY "created_at" DESC LIMIT 20

13:20:51.1890.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

13:20:51.1900.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10

13:20:51.1900.7 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5064)

13:20:51.1910.5 msSELECTSELECT "id", "id" AS "key", "name", "client_class", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=518

13:20:51.1920.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=80

13:20:51.1920.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

13:20:51.1936.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id" IN (38456, 38454)

13:20:51.1991.0 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id" IN (72, 71)

13:20:51.2002.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"=1

13:20:51.2032.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id" IN (38456, 38454))

13:20:51.2062.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=101) AND ("object_id" IN (38456, 38454))

13:20:51.2084.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id" IN (38456, 38454)

13:20:51.2120.8 msSELECTSELECT "id", "id" AS "key", CASE WHEN user_status = '-1' THEN name || '(已离职)' ELSE name END AS name, "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5388

13:20:51.2130.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5388)

13:20:51.2143.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id" IN (38456, 38454) ORDER BY "id"

13:20:51.2170.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

13:20:51.2170.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

13:20:51.2184.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-12-18')

13:20:51.2230.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=30, "last_visit_at"='now()' WHERE "id"=59594

13:20:51.2241.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/worklog-data-list', '{"period":"currentfascalyear","periodline":"currentfascalyear","dataUserId":"5064","to":"","from":"","periodyear":"","page":"1"}', '{"code":2000,"result":{"list":[{"id":38456,"client_id":518,"scenario_id":1,"scenario_option_id":72,"end_at":"2025-12-15 10:00:00","created_by":5064,"created_at":"2025-12-15 11:32:11","updated_at":"2025-12-15 11:32:11","start_at":"2025-12-15 10:00:00","description":"","escort":"","is_draft":false,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":-1,"indistance":"","outdistance":"","hours_spent":"00:00:00","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","client_class":80,"logo":"","sales_rep":5295,"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237"},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"project":{},"workLogContacts":[],"scenarioOption":{"id":72,"key":72,"name":"\u6316\u6398\u5546\u673a"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"location":"","locationIn":{},"locationOut":{},"attachmentRelationships":[],"files":[],"workLogCarbonCopyRels":[{"id":15636,"work_log_id":38456,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}}],"workLogVerifyRels":[{"id":15591,"work_log_id":38456,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"hours_spent_display":"0\u5206\u949f","can_create_reimbursement":false,"read":0,"total":1,"bgcolor":"#89c541"},{"id":38454,"client_id":"","scenario_id":1,"scenario_option_id":71,"end_at":"2025-12-03 10:20:00","created_by":5064,"created_at":"2025-12-03 11:20:05","updated_at":"2025-12-03 11:20:05","start_at":"2025-12-03 10:18:00","description":"","escort":"","is_draft":false,"location_id":"","project_id":"","location_in_id":"","location_out_id":"","status":-1,"indistance":"","outdistance":"","hours_spent":"00:02:00","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},"client":{},"project":{},"workLogContacts":[],"scenarioOption":{"id":71,"key":71,"name":"\u62dc\u8bbf\u5ba2\u6237"},"scenarios":{"id":1,"key":1,"name":"\u9500\u552e\u65e5\u5fd7"},"location":"","locationIn":{},"locationOut":{},"attachmentRelationships":[],"files":[],"workLogCarbonCopyRels":[{"id":15635,"work_log_id":38454,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}}],"workLogVerifyRels":[{"id":15590,"work_log_id":38454,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"hours_spent_display":"2\u5206\u949f","can_create_reimbursement":false,"read":0,"total":1,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":2,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-18 13:20:51') RETURNING "id"