ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4ccccfef5a6: POST https://beta.jinchangxiao.com/vue/analysis/sales-year-histogram-by-month at 2026-07-07 05:54:23 pm by 114.244.130.20

Performance Profiling

Total processing time: 30 ms; Peak memory: 5.345 MB. Show Profiling Timeline

总计6条数据
TimeDurationCategoryInfo
  
17:54:23.9956.9 msyii\db\Command::querySELECT count(distinct p.client_id) as clients, count(distinct p.id) as projects, sum(p.budget) as budget, sum(p.budget / 100 * p.profit_pct) AS profits, to_char(p.bargain_date,'YYYY-MM') AS bargain_year FROM "a57be577deb434"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."created_by" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND (p.bargain_date IS NOT NULL) GROUP BY "bargain_year"
17:54:24.0041.8 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/sales-year-histogram-by-month', '{"to":"","from":"","period":"fascal2026","user_id":"","project_status":"3","alert":"false","web_access_token":"sHKfFzpC6AXRHThWzDm5OfadRXFFX-oO"}', '{"code":2000,"result":{"category":{"budgetCategory":["2026\u5e7401\u6708","2026\u5e7402\u6708","2026\u5e7403\u6708","2026\u5e7404\u6708","2026\u5e7405\u6708","2026\u5e7406\u6708","2026\u5e7407\u6708","2026\u5e7408\u6708","2026\u5e7409\u6708","2026\u5e7410\u6708","2026\u5e7411\u6708","2026\u5e7412\u6708"],"profitsCategory":["2026\u5e7401\u6708","2026\u5e7402\u6708","2026\u5e7403\u6708","2026\u5e7404\u6708","2026\u5e7405\u6708","2026\u5e7406\u6708","2026\u5e7407\u6708","2026\u5e7408\u6708","2026\u5e7409\u6708","2026\u5e7410\u6708","2026\u5e7411\u6708","2026\u5e7412\u6708"],"clientCategory":["2026\u5e7401\u6708","2026\u5e7402\u6708","2026\u5e7403\u6708","2026\u5e7404\u6708","2026\u5e7405\u6708","2026\u5e7406\u6708","2026\u5e7407\u6708","2026\u5e7408\u6708","2026\u5e7409\u6708","2026\u5e7410\u6708","2026\u5e7411\u6708","2026\u5e7412\u6708"],"projectCategory":["2026\u5e7401\u6708","2026\u5e7402\u6708","2026\u5e7403\u6708","2026\u5e7404\u6708","2026\u5e7405\u6708","2026\u5e7406\u6708","2026\u5e7407\u6708","2026\u5e7408\u6708","2026\u5e7409\u6708","2026\u5e7410\u6708","2026\u5e7411\u6708","2026\u5e7412\u6708"]},"seriesBudget":[{"key":"2026-01-01T2026-01-31","name":"2026\u5e7401\u6708","y":"6402227.60"},{"key":"2026-02-01T2026-02-28","name":"2026\u5e7402\u6708","y":"82820.00"},{"key":"2026-03-01T2026-03-31","name":"2026\u5e7403\u6708","y":"2415885.77"},{"key":"2026-04-01T2026-04-30","name":"2026\u5e7404\u6708","y":"13198484.00"},{"key":"2026-05-01T2026-05-31","name":"2026\u5e7405\u6708","y":"77086.00"},{"key":"2026-06-01T2026-06-30","name":"2026\u5e7406\u6708","y":"1002493823.00"},{"key":"2026-07-01T2026-07-31","name":"2026\u5e7407\u6708","y":"0.00"},{"key":"2026-08-01T2026-08-31","name":"2026\u5e7408\u6708","y":"0.00"},{"key":"2026-09-01T2026-09-30","name":"2026\u5e7409\u6708","y":"0.00"},{"key":"2026-10-01T2026-10-31","name":"2026\u5e7410\u6708","y":"0.00"},{"key":"2026-11-01T2026-11-30","name":"2026\u5e7411\u6708","y":"0.00"},{"key":"2026-12-01T2026-12-31","name":"2026\u5e7412\u6708","y":"0.00"}],"seriesProfits":[{"key":"2026-01-01T2026-01-31","name":"2026\u5e7401\u6708","y":"362132.74"},{"key":"2026-02-01T2026-02-28","name":"2026\u5e7402\u6708","y":"44989.93"},{"key":"2026-03-01T2026-03-31","name":"2026\u5e7403\u6708","y":"2548244.54"},{"key":"2026-04-01T2026-04-30","name":"2026\u5e7404\u6708","y":"5731856.54"},{"key":"2026-05-01T2026-05-31","name":"2026\u5e7405\u6708","y":"20388.60"},{"key":"2026-06-01T2026-06-30","name":"2026\u5e7406\u6708","y":"249039305.75"},{"key":"2026-07-01T2026-07-31","name":"2026\u5e7407\u6708","y":"0.00"},{"key":"2026-08-01T2026-08-31","name":"2026\u5e7408\u6708","y":"0.00"},{"key":"2026-09-01T2026-09-30","name":"2026\u5e7409\u6708","y":"0.00"},{"key":"2026-10-01T2026-10-31","name":"2026\u5e7410\u6708","y":"0.00"},{"key":"2026-11-01T2026-11-30","name":"2026\u5e7411\u6708","y":"0.00"},{"key":"2026-12-01T2026-12-31","name":"2026\u5e7412\u6708","y":"0.00"}],"seriesClients":[{"key":"2026-01-01T2026-01-31","name":"2026\u5e7401\u6708","y":14},{"key":"2026-02-01T2026-02-28","name":"2026\u5e7402\u6708","y":6},{"key":"2026-03-01T2026-03-31","name":"2026\u5e7403\u6708","y":7},{"key":"2026-04-01T2026-04-30","name":"2026\u5e7404\u6708","y":4},{"key":"2026-05-01T2026-05-31","name":"2026\u5e7405\u6708","y":3},{"key":"2026-06-01T2026-06-30","name":"2026\u5e7406\u6708","y":5},{"key":"2026-07-01T2026-07-31","name":"2026\u5e7407\u6708","y":0},{"key":"2026-08-01T2026-08-31","name":"2026\u5e7408\u6708","y":0},{"key":"2026-09-01T2026-09-30","name":"2026\u5e7409\u6708","y":0},{"key":"2026-10-01T2026-10-31","name":"2026\u5e7410\u6708","y":0},{"key":"2026-11-01T2026-11-30","name":"2026\u5e7411\u6708","y":0},{"key":"2026-12-01T2026-12-31","name":"2026\u5e7412\u6708","y":0}],"seriesProjects":[{"key":"2026-01-01T2026-01-31","name":"2026\u5e7401\u6708","y":15},{"key":"2026-02-01T2026-02-28","name":"2026\u5e7402\u6708","y":6},{"key":"2026-03-01T2026-03-31","name":"2026\u5e7403\u6708","y":7},{"key":"2026-04-01T2026-04-30","name":"2026\u5e7404\u6708","y":5},{"key":"2026-05-01T2026-05-31","name":"2026\u5e7405\u6708","y":6},{"key":"2026-06-01T2026-06-30","name":"2026\u5e7406\u6708","y":5},{"key":"2026-07-01T2026-07-31","name":"2026\u5e7407\u6708","y":0},{"key":"2026-08-01T2026-08-31","name":"2026\u5e7408\u6708","y":0},{"key":"2026-09-01T2026-09-30","name":"2026\u5e7409\u6708","y":0},{"key":"2026-10-01T2026-10-31","name":"2026\u5e7410\u6708","y":0},{"key":"2026-11-01T2026-11-30","name":"2026\u5e7411\u6708","y":0},{"key":"2026-12-01T2026-12-31","name":"2026\u5e7412\u6708","y":0}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.20","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-07-07 17:54:24', 22257664) RETURNING "id"
17:54:23.9851.0 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5252
17:54:23.9880.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:54:23.9890.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:54:23.9850.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta