ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68a6eade1ea0f: POST https://beta.jinchangxiao.com/vue/erp-dashboard/list-log at 2025-08-21 05:46:06 pm by 221.194.148.30

Performance Profiling

Total processing time: 21 ms; Peak memory: 3.381 MB. Show Profiling Timeline

总计13条数据
TimeDurationCategoryInfo
  
17:46:06.1282.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:46:06.1362.0 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT r.* FROM "a57be577deb434"."tbl_erp_ticket_change_logs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_ticket_change_log_handlers" "rvr" ON rvr.erp_ticket_change_log_id = r.id WHERE ("r"."created_at" >= '2025-08-18 00:00:00') AND ("r"."created_at" <= '2025-08-24 23:59:59') GROUP BY "r"."id" ORDER BY r.created_at DESC) "c"
17:46:06.1271.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:46:06.1321.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:46:06.1431.5 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-dashboard/list-log', '{"ErpTicketChangeLogSearch":{"created_at_period":"thisweek","status":"","created_by":"","created_at_to":"","created_at_from":""},"page":"1","web_access_token":"0OmNcjMNpl7I6Nbm2bTJGMI-xreQBLAo"}', '{"code":2000,"result":{"list":[{"id":147,"serial_no":"XJFYD-20250821-00006","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":"","abstract":"","description":"","verify_at":"2025-08-21 17:13:40","created_by":1001,"created_at":"2025-08-21 17:13:12","updated_at":"2025-08-21 17:13:40","contact_id":"","user_id":"","amount":"3","object_id":7362,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{},"contact":{},"handlers":[{"id":127,"erp_ticket_change_log_id":147,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{}},{"id":148,"serial_no":"XJFYD-20250821-00005","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":"","abstract":"","description":"","verify_at":"2025-08-21 17:14:10","created_by":1001,"created_at":"2025-08-21 17:13:12","updated_at":"2025-08-21 17:14:10","contact_id":"","user_id":"","amount":"33","object_id":7361,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{},"contact":{},"handlers":[{"id":128,"erp_ticket_change_log_id":148,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{}},{"id":149,"serial_no":"XJFYD-20250821-00004","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":"","abstract":"","description":"","verify_at":"2025-08-21 17:14:13","created_by":1001,"created_at":"2025-08-21 17:13:08","updated_at":"2025-08-21 17:14:13","contact_id":"","user_id":"","amount":"234","object_id":7360,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{},"contact":{},"handlers":[{"id":129,"erp_ticket_change_log_id":149,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{}},{"id":145,"serial_no":"XJFYD-20250821-00002","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":"","abstract":"","description":"","verify_at":"2025-08-21 16:43:13","created_by":1001,"created_at":"2025-08-21 16:42:35","updated_at":"2025-08-21 16:43:13","contact_id":"","user_id":"","amount":"1","object_id":7358,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{},"contact":{},"handlers":[{"id":125,"erp_ticket_change_log_id":145,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{}},{"id":144,"serial_no":"XJFYD-20250821-00003","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":"","abstract":"","description":"","verify_at":"2025-08-21 16:43:10","created_by":1001,"created_at":"2025-08-21 16:42:35","updated_at":"2025-08-21 16:43:10","contact_id":"","user_id":"","amount":"222","object_id":7359,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{},"contact":{},"handlers":[{"id":124,"erp_ticket_change_log_id":144,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{}},{"id":146,"serial_no":"XJFYD-20250821-00001","ticket_type":20018,"wrote_date":"","status":2,"supplier_id":"","client_id":"","abstract":"","description":"","verify_at":"2025-08-21 16:43:15","created_by":1001,"created_at":"2025-08-21 16:42:31","updated_at":"2025-08-21 16:43:15","contact_id":"","user_id":"","amount":"222","object_id":7357,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{},"contact":{},"handlers":[{"id":126,"erp_ticket_change_log_id":146,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","unit":{}},{"id":141,"serial_no":"XSDD-20250821-00004","ticket_type":20007,"wrote_date":"2025-08-21","status":2,"supplier_id":"","client_id":3278,"abstract":"","description":"","verify_at":"2025-08-21 15:42:29","created_by":1001,"created_at":"2025-08-21 15:42:15","updated_at":"2025-08-21 15:42:29","contact_id":"","user_id":"","amount":"423423","object_id":1575,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"handlers":[{"id":121,"erp_ticket_change_log_id":141,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u9500\u552e\u8ba2\u5355","unit":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"}},{"id":140,"serial_no":"XSDD-20250821-00002","ticket_type":20007,"wrote_date":"2025-07-18","status":2,"supplier_id":"","client_id":2699,"abstract":"","description":"","verify_at":"2025-08-21 15:39:37","created_by":1001,"created_at":"2025-08-21 15:36:05","updated_at":"2025-08-21 15:39:37","contact_id":"","user_id":"","amount":"0","object_id":1573,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":2699,"key":2699,"name":"\u5317\u4eac\u5609\u8fd0\u8fbe\u79d1\u6280\u5f00\u53d1\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"user":{},"contact":{},"handlers":[{"id":120,"erp_ticket_change_log_id":140,"user_id":5087,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae"}}],"ticket_type_display":"\u9500\u552e\u8ba2\u5355","unit":{"id":2699,"key":2699,"name":"\u5317\u4eac\u5609\u8fd0\u8fbe\u79d1\u6280\u5f00\u53d1\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},{"id":138,"serial_no":"CGRK-20250819-00002","ticket_type":20002,"wrote_date":"2025-08-19","status":2,"supplier_id":431,"client_id":"","abstract":"","description":"","verify_at":"2025-08-19 17:37:36","created_by":1001,"created_at":"2025-08-19 14:40:46","updated_at":"2025-08-19 17:37:36","contact_id":"","user_id":"","amount":"666","object_id":6,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":119,"erp_ticket_change_log_id":138,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"ticket_type_display":"\u91c7\u8d2d\u5165\u5e93\u5355","unit":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"}},{"id":136,"serial_no":"CGDD-20250819-00002","ticket_type":20001,"wrote_date":"2025-08-19","status":2,"supplier_id":431,"client_id":"","abstract":"","description":"","verify_at":"2025-08-19 14:40:18","created_by":1001,"created_at":"2025-08-19 14:39:32","updated_at":"2025-08-19 14:40:18","contact_id":"","user_id":"","amount":"666","object_id":2013,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"handlers":[{"id":118,"erp_ticket_change_log_id":136,"user_id":1011,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"}}],"ticket_type_display":"\u91c7\u8d2d\u8ba2\u5355","unit":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"}}],"pagenation":{"totalcount":10,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-21 17:46:06') RETURNING "id"
17:46:06.1390.7 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
17:46:06.1380.6 msyii\db\Command::querySELECT r.* FROM "a57be577deb434"."tbl_erp_ticket_change_logs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_ticket_change_log_handlers" "rvr" ON rvr.erp_ticket_change_log_id = r.id WHERE ("r"."created_at" >= '2025-08-18 00:00:00') AND ("r"."created_at" <= '2025-08-24 23:59:59') GROUP BY "r"."id" ORDER BY r.created_at DESC LIMIT 20
17:46:06.1410.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3278, 2699)
17:46:06.1400.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431
17:46:06.1400.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
17:46:06.1380.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:46:06.1420.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1001, 5087)
17:46:06.1410.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_ticket_change_log_handlers" WHERE "erp_ticket_change_log_id" IN (147, 148, 149, 145, 144, 146, 141, 140, 138, 136)